pgBadger-
Global information
- Generated on Thu Sep 24 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 38,393 log entries in 12s
- Log start from 2026-09-24 00:00:46 to 2026-09-24 23:49:27
-
Overview
Global Stats
- 418 Number of unique normalized queries
- 5,108 Number of queries
- 6h53m37s Total query duration
- 2026-09-24 00:02:22 First query
- 2026-09-24 23:46:49 Last query
- 6 queries/s at 2026-09-24 09:38:24 Query peak
- 6h53m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h53m37s Execute total duration
- 3,622 Number of events
- 15 Number of unique normalized events
- 3,557 Max number of times the same event was reported
- 0 Number of cancellation
- 480 Total number of automatic vacuums
- 1,060 Total number of automatic analyzes
- 20 Number temporary file
- 247.35 MiB Max size of temporary file
- 67.30 MiB Average size of temporary file
- 367 Total number of sessions
- 8 sessions at 2026-09-24 01:05:03 Session peak
- 13d5h11m32s Total duration of sessions
- 51m51s Average duration of sessions
- 13 Average queries per session
- 1m7s Average queries duration per session
- 50m43s Average idle time per session
- 383 Total number of connections
- 6 connections/s at 2026-09-24 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-24 09:38:24 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-24 10:04:53 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-24 23:42:17 Date
Queries duration
Key values
- 6h53m37s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 00 24 0ms 19s845ms 4s812ms 3s894ms 7s103ms 1m2s 01 40 0ms 5s428ms 1s140ms 4s427ms 6s890ms 8s337ms 02 11 0ms 4s290ms 2s614ms 2s770ms 4s926ms 7s28ms 03 11 0ms 3s868ms 3s112ms 3s417ms 6s452ms 6s655ms 04 43 0ms 4s125ms 1s100ms 4s97ms 6s455ms 7s338ms 05 17 0ms 11m10s 1m24s 6s520ms 3m3s 11m10s 06 20 0ms 18s791ms 3s472ms 3s747ms 4s961ms 26s168ms 07 202 0ms 7m36s 7s617ms 49s 2m8s 7m36s 08 390 0ms 6m18s 4s205ms 37s215ms 3m38s 6m20s 09 599 0ms 5m52s 3s93ms 56s337ms 1m59s 6m7s 10 485 150ms 6m30s 3s123ms 36s31ms 3m34s 6m31s 11 367 0ms 6m1s 5s354ms 43s776ms 5m41s 8m50s 12 132 0ms 5m16s 6s704ms 24s506ms 47s807ms 6m3s 13 461 0ms 6m49s 3s 35s150ms 3m26s 6m55s 14 558 0ms 5m35s 2s811ms 59s762ms 1m29s 5m59s 15 655 0ms 5m39s 3s865ms 1m23s 3m45s 6m53s 16 344 151ms 6m5s 4s439ms 56s360ms 3m50s 6m31s 17 189 0ms 5m38s 6s110ms 24s470ms 2m56s 5m48s 18 22 0ms 5m10s 27s624ms 2s862ms 28s668ms 5m55s 19 18 0ms 5m5s 32s152ms 2s760ms 3s98ms 5m50s 20 116 0ms 5m28s 9s984ms 1m3s 1m15s 6m24s 21 27 0ms 5m10s 21s822ms 3s999ms 4s878ms 5m55s 22 24 0ms 5m5s 24s351ms 4s146ms 5s757ms 5m48s 23 353 0ms 1m2s 5s533ms 1m5s 1m6s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 00 5 0 5s609ms 0ms 0ms 945ms 01 28 0 354ms 432ms 658ms 1s265ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 30 0 415ms 455ms 824ms 1s102ms 05 2 0 376ms 0ms 0ms 0ms 06 5 0 5s365ms 0ms 0ms 658ms 07 111 0 9s666ms 3s981ms 20s154ms 3m59s 08 258 0 4s697ms 6s314ms 19s285ms 5m51s 09 434 0 3s17ms 22s273ms 44s650ms 3m46s 10 372 0 3s380ms 7s784ms 31s213ms 5m32s 11 280 0 5s520ms 4s559ms 40s813ms 5m41s 12 76 0 8s988ms 1s515ms 5s288ms 3m25s 13 372 0 3s289ms 7s746ms 12s588ms 5m33s 14 397 0 2s675ms 10s648ms 31s477ms 3m33s 15 475 0 3s599ms 19s724ms 50s677ms 5m45s 16 250 0 5s232ms 10s481ms 38s950ms 5m31s 17 155 0 6s814ms 9s705ms 19s736ms 3m31s 18 9 0 1m2s 0ms 0ms 3m23s 19 6 0 1m32s 0ms 0ms 3m27s 20 19 80 11s416ms 42s14ms 1m1s 3m24s 21 9 0 1m2s 0ms 0ms 3m23s 22 6 0 1m32s 0ms 0ms 3m24s 23 30 321 5s561ms 1m2s 1m5s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 24 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 24 00 0 0 0.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 10 10.00 0.00% 08 0 16 16.00 0.00% 09 0 14 14.00 0.00% 10 0 11 11.00 0.00% 11 0 11 11.00 0.00% 12 0 5 5.00 0.00% 13 0 13 13.00 0.00% 14 0 12 12.00 0.00% 15 0 13 13.00 0.00% 16 0 12 12.00 0.00% 17 0 8 8.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Sep 24 00 17 0.00/s 01 10 0.00/s 02 14 0.00/s 03 18 0.01/s 04 9 0.00/s 05 11 0.00/s 06 14 0.00/s 07 14 0.00/s 08 21 0.01/s 09 26 0.01/s 10 26 0.01/s 11 18 0.01/s 12 12 0.00/s 13 22 0.01/s 14 21 0.01/s 15 21 0.01/s 16 23 0.01/s 17 25 0.01/s 18 9 0.00/s 19 10 0.00/s 20 14 0.00/s 21 8 0.00/s 22 7 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Sep 24 00 6 59m52s 59m32s 01 16 1h56s 1h53s 02 10 1h18s 1h15s 03 18 19m58s 19m56s 04 7 1h3m 1h2m53s 05 10 55m36s 53m12s 06 10 1h29s 1h22s 07 14 52m47s 50m58s 08 12 56m35s 54m18s 09 27 50m34s 49m26s 10 24 51m44s 50m41s 11 22 54m46s 53m17s 12 16 57m17s 56m22s 13 13 56m49s 55m3s 14 23 55m10s 54m2s 15 23 48m 46m10s 16 22 49m8s 47m58s 17 23 43m21s 42m31s 18 18 1h51s 1h17s 19 9 1h34s 59m29s 20 13 47m7s 45m38s 21 11 1h45s 59m51s 22 8 1h3s 58m50s 23 12 32m43s 30m -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-09-24 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 383 connections Total
Connections per user
Key values
- intelifix Main User
- 383 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-24 01:05:03 Date
Histogram of session times
Key values
- 288 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 367 sessions Total
Sessions per user
Key values
- intelifix Main User
- 367 sessions Total
Sessions per host
Key values
- [local] Main Host
- 367 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 70,383 buffers Checkpoint Peak
- 2026-09-24 00:09:40 Date
- 270.034 seconds Highest write time
- 0.128 seconds Sync time
Checkpoints Wal files
Key values
- 23 files Wal files usage Peak
- 2026-09-24 15:44:36 Date
Checkpoints distance
Key values
- 736.00 Mo Distance Peak
- 2026-09-24 15:44:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 24 00 85,248 646.092s 0.087s 646.233s 01 3,354 335.925s 0.097s 336.078s 02 1,703 170.624s 0.203s 170.844s 03 1,609 160.343s 0.13s 160.505s 04 4,583 458.816s 0.112s 458.966s 05 10,608 1,043.778s 0.025s 1,043.849s 06 6,634 551.312s 0.089s 551.419s 07 11,869 1,209.653s 0.132s 1,209.861s 08 40,716 3,101.689s 0.295s 3,102.067s 09 45,280 3,239.028s 0.515s 3,239.689s 10 49,466 3,204.826s 0.364s 3,205.283s 11 48,213 3,018.474s 0.415s 3,018.963s 12 14,203 1,431.412s 0.096s 1,431.568s 13 32,746 2,367.23s 0.439s 2,367.746s 14 41,814 3,239.177s 0.356s 3,239.694s 15 53,023 3,174.161s 0.311s 3,174.587s 16 39,126 3,123.36s 0.105s 3,123.609s 17 31,127 2,125.74s 0.176s 2,126.001s 18 2,029 202.995s 0.02s 203.033s 19 28 2.82s 0.005s 2.836s 20 1,347 156.5s 0.07s 156.581s 21 2,907 292.836s 0.027s 292.895s 22 2,118 212.029s 0.029s 212.211s 23 563 56.453s 0.074s 56.627s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 24 00 0 0 12 527 0.062s 0.008s 01 0 0 1 666 0.063s 0.009s 02 0 0 0 394 0.063s 0.005s 03 0 0 1 338 0.059s 0.008s 04 0 0 1 698 0.032s 0.01s 05 0 0 20 600 0.003s 0.007s 06 0 0 1 335 0.056s 0.005s 07 0 0 26 2,743 0.064s 0.012s 08 0 0 36 5,670 0.063s 0.012s 09 0 0 52 7,811 0.064s 0.012s 10 0 0 31 7,201 0.055s 0.012s 11 0 0 26 6,124 0.062s 0.012s 12 0 0 17 3,376 0.013s 0.012s 13 0 0 13 5,387 0.063s 0.012s 14 0 0 48 6,707 0.063s 0.012s 15 0 0 86 7,192 0.057s 0.012s 16 0 0 25 6,137 0.003s 0.012s 17 0 0 17 3,993 0.061s 0.012s 18 0 0 1 214 0.004s 0.007s 19 0 0 0 7 0.003s 0.002s 20 0 0 1 88 0.060s 0.005s 21 0 0 0 591 0.003s 0.009s 22 0 0 1 494 0.005s 0.009s 23 0 0 0 117 0.058s 0.012s Day Hour Count Avg time (sec) Sep 24 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 24 00 27,181.43 kB 84,543.86 kB 01 1,793.00 kB 38,374.33 kB 02 1,645.60 kB 18,763.60 kB 03 1,257.14 kB 3,451.86 kB 04 2,319.70 kB 3,279.30 kB 05 46,347.29 kB 164,942.00 kB 06 3,635.40 kB 136,943.80 kB 07 35,717.92 kB 83,793.25 kB 08 48,956.42 kB 89,518.75 kB 09 70,164.92 kB 126,564.58 kB 10 42,737.08 kB 75,102.00 kB 11 35,409.58 kB 64,577.42 kB 12 23,579.08 kB 68,364.08 kB 13 17,145.75 kB 34,016.75 kB 14 66,519.58 kB 131,538.92 kB 15 116,589.08 kB 190,273.08 kB 16 35,081.42 kB 174,824.42 kB 17 22,899.33 kB 70,288.17 kB 18 1,448.67 kB 50,129.17 kB 19 98.00 kB 32,495.50 kB 20 4,105.67 kB 26,000.67 kB 21 1,742.50 kB 15,584.62 kB 22 1,260.50 kB 7,582.62 kB 23 370.80 kB 4,181.40 kB -
Temporary Files
Size of temporary files
Key values
- 494.70 MiB Temp Files size Peak
- 2026-09-24 05:31:55 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-24 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 24 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.30 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 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 16 1.01 GiB 36.89 MiB 247.35 MiB 64.91 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-24 05:32:04 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-24 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 307.56 MiB 57.17 MiB 94.09 MiB 76.89 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-24 05:30:42 Duration: 38s950ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-24 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 247.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 247.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-24 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-24 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.22 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-24 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-24 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-24 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 48.46 sec Highest CPU-cost vacuum
Table public.triagens
Database rio - 2026-09-24 05:08:22 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 48.46 sec Highest CPU-cost vacuum
Table public.triagens
Database rio - 2026-09-24 05:08:22 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (128) Main table analyzed (database rio)
- 1,060 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 128 rio.public.temp0000292328 85 rio.pg_catalog.pg_class 70 rio.pg_catalog.pg_type 55 rio.public.usuarios 48 rio.public.temp0000292414 39 rio.pg_catalog.pg_index 37 brasilia.pg_catalog.pg_attribute 35 contagem.public.usuarios 30 contagem.pg_catalog.pg_attribute 29 rio.public.temp0000292370 26 rio.public.temp0000291977 26 rio.public.temp0000292430 25 rio.pg_catalog.pg_depend 25 rio.public.temp0000292392 24 rio.public.temp0000292372 23 contagem.public.temp0000227268 19 contagem.public.temp0000227296 19 brasilia.pg_catalog.pg_class 19 brasilia.pg_catalog.pg_type 16 rio.public.temp0000292342 14 rio.public.temp0000290230 12 contagem.pg_catalog.pg_class 12 brasilia.public.temp0000240818 11 brasilia.pg_catalog.pg_index 11 brasilia.public.usuarios 10 contagem.pg_catalog.pg_type 10 rio.public.temp0000292390 10 brasilia.public.temp0000240866 10 rio.public.temp0000292432 9 rio.public.temp0000290026 8 rio.public.temp0000292056 8 rio.public.temp0000292348 8 brasilia.pg_catalog.pg_depend 8 contagem.pg_catalog.pg_index 7 contagem.public.temp0000227290 6 rio.public.temp0000292354 6 rio.public.temp0000292338 5 rio.public.temp0000292420 5 rio.public.temp0000292360 5 contagem.public.temp0000227298 5 brasilia.public.temp0000240888 5 contagem.pg_catalog.pg_depend 5 brasilia.public.temp0000240836 5 rio.public.temp0000292358 4 rio.public.temp0000292416 4 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000292376 4 rio.public.temp0000292324 4 rio.public.temp0000292418 4 contagem.pg_catalog.pg_shdepend 4 brasilia.public.temp0000240870 3 brasilia.public.temp0000240810 3 brasilia.public.temp0000240876 3 contagem.public.nf_entrada 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.nf_entrada 2 brasilia.public.temp0000240820 2 brasilia.public.temp0000240872 2 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000292350 2 rio.public.tmp_drill_0175 2 brasilia.public.temp0000240900 2 brasilia.public.temp0000240860 1 brasilia.public.temp0000240864 1 rio.public.tmp_drill_0302 1 rio.public.temp0000292382 1 contagem.public.temp0000227294 1 rio.public.temp0000292452 1 rio.public.temp0000292380 1 rio.public.temp0000292454 1 brasilia.public.temp0000240840 1 brasilia.public.temp0000240902 1 brasilia.public.temp0000240828 1 rio.public.temp0000292334 1 brasilia.public.temp0000240816 1 brasilia.public.temp0000240826 1 brasilia.public.temp0000240844 1 rio.public.temp0000292362 1 rio.public.temp0000291299 1 brasilia.public.temp0000240874 1 rio.public.temp0000292316 1 rio.public.temp0000292456 1 contagem.public.temp0000227292 1 rio.public.temp0000292410 1 brasilia.public.temp0000240842 1 brasilia.public.temp0000240858 1 rio.public.temp0000292394 1 brasilia.public.temp0000240814 1 rio.public.temp0000292388 1 contagem.public.temp0000227288 1 brasilia.public.temp0000240852 1 rio.public.tmp_drill_0320 1 Total 1,060 Vacuums per table
Key values
- public.temp0000292328 (85) Main table vacuumed on database rio
- 480 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000292328 85 0 0 0 0 0 0 43,843 481 2,780,387 0 0 rio.pg_catalog.pg_attribute 41 41 0 0 0 0 0 22,631 6,298 9,738,568 323 8,050 contagem.public.usuarios 28 0 0 0 0 0 0 153 122 56,834 1 1 rio.public.temp0000292414 24 0 0 0 0 0 0 10,361 211 775,992 0 0 rio.pg_catalog.pg_class 22 22 0 0 0 0 0 4,259 1,432 2,375,263 77 286 rio.public.temp0000292372 19 0 0 0 0 0 0 7,866 82 476,581 0 0 rio.public.temp0000292430 18 0 0 0 0 0 0 7,935 89 482,088 0 0 rio.pg_catalog.pg_type 17 17 0 0 0 0 0 1,778 587 844,296 62 181 rio.public.temp0000290230 12 0 0 0 0 0 0 974 227 338,256 0 0 rio.pg_catalog.pg_index 12 12 0 0 0 0 0 655 211 217,353 31 69 brasilia.pg_catalog.pg_attribute 12 12 0 0 0 0 0 6,207 1,439 2,375,413 61 1,621 rio.pg_catalog.pg_statistic 11 11 0 0 0 0 0 12,955 3,393 15,049,271 1,590 6,459 rio.public.temp0000292392 11 0 0 0 0 0 0 367 129 154,600 0 0 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,659 1,328 2,160,243 61 553 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 6,815 1,634 3,020,415 35 1,071 rio.public.temp0000292432 9 0 0 0 0 0 0 12,794 36 760,416 0 0 rio.public.usuarios 9 3 0 0 0 0 0 133 53 116,514 17 42 brasilia.pg_catalog.pg_class 8 8 0 0 0 0 0 1,442 312 581,691 18 60 rio.public.temp0000292056 8 0 0 0 0 0 0 391 126 169,588 0 0 rio.public.temp0000291977 8 0 0 0 0 0 0 710 130 193,901 0 0 rio.public.temp0000290026 8 0 0 0 0 0 0 680 214 340,004 0 0 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 584 177 274,372 14 44 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,098 154 298,848 8 25 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 710 152 251,705 5 10 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 195 53 51,106 10 28 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,160 546 2,866,695 151 381 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 223 53 60,418 3 7 rio.public.temp0000292354 4 0 0 0 0 0 0 199 67 85,960 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 841 304 471,082 15 180 contagem.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 550 170 283,991 29 55 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,088 269 534,901 7 34 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,128 792 3,055,670 533 3,318 contagem.public.temp0000227298 3 0 0 0 0 0 0 348 18 23,451 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,997 285 1,220,965 203 1,714 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 219 54 176,439 9 30 contagem.public.temp0000227296 2 0 0 0 0 0 0 232 12 15,631 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 248 58 106,421 7 20 rio.public.tmp_drill_0175 2 2 0 0 0 0 0 106 6 22,505 0 0 contagem.public.temp0000227290 2 0 0 0 0 0 0 232 121 199,932 0 0 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 445 152 245,920 13 30 rio.public.temp0000292350 2 0 0 0 0 0 0 76 11 6,153 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 365 80 448,286 36 92 brasilia.public.temp0000240870 2 0 0 0 0 0 0 511 8 31,362 0 0 brasilia.public.temp0000240852 1 0 0 0 0 0 0 255 4 15,648 0 0 rio.public.tmp_drill_0320 1 1 0 0 0 0 0 35 3 7,566 0 0 brasilia.public.temp0000240820 1 0 0 0 0 0 0 255 4 15,648 0 0 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 202 71 127,000 14 31 rio.public.temp0000292388 1 0 0 0 0 0 0 1,823 4 108,160 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 356 174 254,421 13 21 rio.public.temp0000292348 1 0 0 0 0 0 0 68 6 4,887 0 0 rio.auditor.auditor_2026_09 1 0 0 0 0 0 0 146,330 98,943 126,184,336 22,094 443,591 rio.public.temp0000292394 1 0 0 0 0 0 0 91 89 151,533 0 0 rio.public.temp0000292418 1 0 0 0 0 0 0 73 6 5,197 0 0 brasilia.public.temp0000240902 1 0 0 0 0 0 0 255 4 15,648 0 0 brasilia.public.temp0000240840 1 0 0 0 0 0 0 255 4 15,648 0 0 brasilia.public.temp0000240828 1 0 0 0 0 0 0 255 4 15,648 0 0 contagem.public.temp0000227268 1 0 0 0 0 0 0 116 6 7,814 0 0 contagem.public.temp0000227292 1 0 0 0 0 0 0 116 6 7,814 0 0 brasilia.public.temp0000240818 1 0 0 0 0 0 0 255 4 15,648 0 0 rio.public.temp0000292416 1 0 0 0 0 0 0 73 6 5,197 0 0 rio.public.temp0000291299 1 0 0 0 0 0 0 68 4 4,615 0 0 rio.public.temp0000292452 1 0 0 0 0 0 0 82 6 5,745 0 0 rio.public.temp0000292358 1 0 0 0 0 0 0 8 5 1,266 0 0 rio.public.temp0000292380 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.triagens 1 1 0 0 0 0 0 145,305 93,808 263,655,242 2,733 32,657 rio.public.temp0000292370 1 0 0 0 0 0 0 68 6 4,885 0 0 rio.public.temp0000292376 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.temp0000292360 1 0 0 0 0 0 0 68 6 4,887 0 0 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 43 3 12,161 0 0 Total 480 208 0 0 0 0 0 460,749 215,260 444,395,036 28,173 500,661 Vacuum throughput per table
Key values
- public.triagens (48.46) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000292328 0 0 1.11 rio.pg_catalog.pg_attribute 0 0 2.9 contagem.public.usuarios 0 0 0.01 rio.public.temp0000292414 0 0 0.33 rio.pg_catalog.pg_class 0 0 0.71 rio.public.temp0000292372 0 0 0.21 rio.public.temp0000292430 0 0 0.28 rio.pg_catalog.pg_type 0 0 0.22 rio.public.temp0000290230 0 0 0.01 rio.pg_catalog.pg_index 0 0 0.16 brasilia.pg_catalog.pg_attribute 0 0 1.02 rio.pg_catalog.pg_statistic 0 0 1.44 rio.public.temp0000292392 0 0 0.07 rio.pg_catalog.pg_depend 0 0 0.69 contagem.pg_catalog.pg_attribute 0 0 1.09 rio.public.temp0000292432 0 0 0.35 rio.public.usuarios 0 0 0 brasilia.pg_catalog.pg_class 0 0 0.84 rio.public.temp0000292056 0 0 0.07 rio.public.temp0000291977 0 0 0.04 rio.public.temp0000290026 0 0 0.02 brasilia.pg_catalog.pg_type 0 0 0.69 contagem.pg_catalog.pg_class 0 0 1 contagem.pg_catalog.pg_type 0 0 0.21 brasilia.pg_catalog.pg_index 0 0 0.27 rio.pg_toast.pg_toast_2619 0 0 0.3 contagem.pg_catalog.pg_index 0 0 0.08 rio.public.temp0000292354 0 0 0.01 brasilia.pg_catalog.pg_depend 0 0 0.63 contagem.pg_catalog.pg_shdepend 0 0 0.27 contagem.pg_catalog.pg_depend 0 0 0.52 brasilia.pg_catalog.pg_statistic 0 0 0.44 contagem.public.temp0000227298 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.24 contagem.pg_toast.pg_toast_2619 0 0 0.05 contagem.public.temp0000227296 0 0 0 contagem.public.nf_entrada 0 0 0.06 rio.public.tmp_drill_0175 0 0 0 contagem.public.temp0000227290 0 0 0.03 postgres.pg_catalog.pg_shdepend 0 0 0.21 rio.public.temp0000292350 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.public.temp0000240870 0 0 0 brasilia.public.temp0000240852 0 0 0 rio.public.tmp_drill_0320 0 0 0 brasilia.public.temp0000240820 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.1 rio.public.temp0000292388 0 0 0.04 brasilia.public.nf_entrada 0 0 0.17 rio.public.temp0000292348 0 0 0 rio.auditor.auditor_2026_09 0 0 32.41 rio.public.temp0000292394 0 0 0 rio.public.temp0000292418 0 0 0 brasilia.public.temp0000240902 0 0 0 brasilia.public.temp0000240840 0 0 0 brasilia.public.temp0000240828 0 0 0 contagem.public.temp0000227268 0 0 0 contagem.public.temp0000227292 0 0 0 brasilia.public.temp0000240818 0 0 0 rio.public.temp0000292416 0 0 0 rio.public.temp0000291299 0 0 0 rio.public.temp0000292452 0 0 0.01 rio.public.temp0000292358 0 0 0 rio.public.temp0000292380 0 0 0 rio.public.triagens 0 0 48.46 rio.public.temp0000292370 0 0 0 rio.public.temp0000292376 0 0 0 rio.public.temp0000292360 0 0 0 rio.public.tmp_drill_0302 0 0 0 Total 0 0 97.8 Tuples removed per table
Key values
- pg_catalog.pg_attribute (162343) Main table with removed tuples on database rio
- 366707 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 41 41 162,343 984,056 9,999 126 23,721 brasilia.pg_catalog.pg_attribute 12 12 49,701 270,504 80 79 7,144 contagem.pg_catalog.pg_attribute 10 10 48,805 241,348 0 397 5,391 rio.public.triagens 1 1 25,651 4,015,307 0 0 144,628 rio.pg_catalog.pg_statistic 11 11 18,042 92,074 283 0 14,146 rio.pg_catalog.pg_depend 10 10 8,276 190,240 369 0 1,870 brasilia.pg_catalog.pg_statistic 3 3 6,467 23,661 0 0 3,216 contagem.pg_catalog.pg_statistic 2 2 5,437 14,982 0 0 2,022 rio.pg_catalog.pg_type 17 17 5,130 38,583 8 9 1,206 rio.auditor.auditor_2026_09 1 0 5,116 16,532,036 0 0 778,028 rio.pg_catalog.pg_class 22 22 3,494 78,642 423 0 2,472 contagem.pg_catalog.pg_type 6 6 3,161 13,514 0 58 380 contagem.pg_catalog.pg_shdepend 3 3 2,582 40,840 19 0 375 contagem.pg_catalog.pg_class 6 6 2,498 23,346 2,368 20 826 rio.pg_catalog.pg_index 12 12 2,376 23,047 7 13 615 brasilia.pg_catalog.pg_type 7 7 2,214 15,637 48 5 481 contagem.public.usuarios 28 0 1,828 672 0 0 56 postgres.pg_catalog.pg_shdepend 2 2 1,794 27,755 607 0 250 contagem.public.nf_entrada 2 2 1,627 3,100 0 0 174 brasilia.pg_catalog.pg_class 8 8 1,511 33,794 0 0 1,192 contagem.pg_catalog.pg_index 4 4 1,418 7,697 474 16 205 brasilia.pg_catalog.pg_shdepend 1 1 1,361 13,631 0 0 125 rio.pg_toast.pg_toast_2619 5 5 1,289 3,180 16 3 1,338 brasilia.public.nf_entrada 1 1 993 3,295 0 0 152 brasilia.pg_catalog.pg_depend 3 3 944 55,393 0 0 515 brasilia.pg_catalog.pg_index 5 5 940 9,461 0 7 250 rio.public.usuarios 9 3 739 5,672 1,083 0 171 contagem.pg_catalog.pg_depend 3 3 597 59,097 3,080 22 535 brasilia.pg_toast.pg_toast_2619 2 2 237 306 0 0 150 contagem.pg_toast.pg_toast_2619 2 2 136 226 0 32 66 rio.public.temp0000292372 19 0 0 150,618 0 85 10,091 brasilia.public.temp0000240852 1 0 0 3,344 0 0 256 rio.public.tmp_drill_0320 1 1 0 453 0 0 12 brasilia.public.temp0000240820 1 0 0 3,341 0 0 256 rio.public.temp0000292432 9 0 0 208,228 0 58 14,918 rio.public.temp0000292388 1 0 0 25,819 0 0 1,856 contagem.public.temp0000227296 2 0 0 2,782 0 40 216 rio.public.temp0000290230 12 0 0 41,199 0 353 927 rio.public.temp0000292348 1 0 0 1,019 0 4 60 rio.public.temp0000292392 11 0 0 50,751 0 596 2,540 rio.public.temp0000292056 8 0 0 22,246 0 204 500 rio.public.temp0000292394 1 0 0 3,684 0 45 83 rio.public.temp0000292418 1 0 0 1,072 0 63 65 rio.public.temp0000292328 85 0 0 658,856 0 1,259 46,613 brasilia.public.temp0000240902 1 0 0 3,346 0 0 256 brasilia.public.temp0000240840 1 0 0 3,342 0 0 256 brasilia.public.temp0000240828 1 0 0 3,341 0 0 256 rio.public.tmp_drill_0175 2 2 0 1,355 0 0 37 rio.public.temp0000291977 8 0 0 33,086 0 280 744 contagem.public.temp0000227268 1 0 0 1,390 0 20 108 contagem.public.temp0000227290 2 0 0 2,780 0 40 216 contagem.public.temp0000227292 1 0 0 1,390 0 20 108 brasilia.public.temp0000240818 1 0 0 3,341 0 0 256 rio.public.temp0000292416 1 0 0 1,072 0 63 65 rio.public.temp0000291299 1 0 0 1,064 0 0 64 rio.public.temp0000292350 2 0 0 2,038 0 8 120 rio.public.temp0000292452 1 0 0 1,229 0 54 74 contagem.public.temp0000227298 3 0 0 4,176 0 60 324 rio.public.temp0000292358 1 0 0 1,019 0 4 60 rio.public.temp0000292380 1 0 0 1,036 0 0 64 rio.public.temp0000290026 8 0 0 29,990 0 93 675 rio.public.temp0000292414 24 0 0 190,240 0 1,011 12,429 rio.public.temp0000292370 1 0 0 1,021 0 4 60 rio.public.temp0000292354 4 0 0 7,462 0 89 167 rio.public.temp0000292430 18 0 0 180,944 0 617 12,055 rio.public.temp0000292376 1 0 0 1,028 0 0 64 rio.public.temp0000292360 1 0 0 1,019 0 4 60 rio.public.tmp_drill_0302 1 1 0 630 0 0 17 brasilia.public.temp0000240870 2 0 0 6,688 0 0 512 Total 480 208 366,707 24,478,535 18,864 5,861 1,099,140 Pages removed per table
Key values
- public.temp0000292328 (1259) Main table with removed pages on database rio
- 5861 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000292328 85 0 0 1259 rio.public.temp0000292414 24 0 0 1011 rio.public.temp0000292430 18 0 0 617 rio.public.temp0000292392 11 0 0 596 contagem.pg_catalog.pg_attribute 10 10 48805 397 rio.public.temp0000290230 12 0 0 353 rio.public.temp0000291977 8 0 0 280 rio.public.temp0000292056 8 0 0 204 rio.pg_catalog.pg_attribute 41 41 162343 126 rio.public.temp0000290026 8 0 0 93 rio.public.temp0000292354 4 0 0 89 rio.public.temp0000292372 19 0 0 85 brasilia.pg_catalog.pg_attribute 12 12 49701 79 rio.public.temp0000292418 1 0 0 63 rio.public.temp0000292416 1 0 0 63 contagem.public.temp0000227298 3 0 0 60 rio.public.temp0000292432 9 0 0 58 contagem.pg_catalog.pg_type 6 6 3161 58 rio.public.temp0000292452 1 0 0 54 rio.public.temp0000292394 1 0 0 45 contagem.public.temp0000227296 2 0 0 40 contagem.public.temp0000227290 2 0 0 40 contagem.pg_toast.pg_toast_2619 2 2 136 32 contagem.pg_catalog.pg_depend 3 3 597 22 contagem.pg_catalog.pg_class 6 6 2498 20 contagem.public.temp0000227268 1 0 0 20 contagem.public.temp0000227292 1 0 0 20 contagem.pg_catalog.pg_index 4 4 1418 16 rio.pg_catalog.pg_index 12 12 2376 13 rio.pg_catalog.pg_type 17 17 5130 9 rio.public.temp0000292350 2 0 0 8 brasilia.pg_catalog.pg_index 5 5 940 7 brasilia.pg_catalog.pg_type 7 7 2214 5 rio.public.temp0000292348 1 0 0 4 rio.public.temp0000292358 1 0 0 4 rio.public.temp0000292370 1 0 0 4 rio.public.temp0000292360 1 0 0 4 rio.pg_toast.pg_toast_2619 5 5 1289 3 brasilia.public.temp0000240852 1 0 0 0 rio.pg_catalog.pg_statistic 11 11 18042 0 contagem.pg_catalog.pg_statistic 2 2 5437 0 rio.public.tmp_drill_0320 1 1 0 0 brasilia.public.temp0000240820 1 0 0 0 brasilia.pg_catalog.pg_shdepend 1 1 1361 0 brasilia.pg_catalog.pg_class 8 8 1511 0 rio.public.temp0000292388 1 0 0 0 rio.pg_catalog.pg_class 22 22 3494 0 contagem.public.nf_entrada 2 2 1627 0 brasilia.public.nf_entrada 1 1 993 0 brasilia.pg_catalog.pg_depend 3 3 944 0 contagem.pg_catalog.pg_shdepend 3 3 2582 0 rio.auditor.auditor_2026_09 1 0 5116 0 brasilia.public.temp0000240902 1 0 0 0 brasilia.public.temp0000240840 1 0 0 0 brasilia.public.temp0000240828 1 0 0 0 rio.public.tmp_drill_0175 2 2 0 0 rio.pg_catalog.pg_depend 10 10 8276 0 brasilia.public.temp0000240818 1 0 0 0 rio.public.usuarios 9 3 739 0 rio.public.temp0000291299 1 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 1794 0 brasilia.pg_catalog.pg_statistic 3 3 6467 0 brasilia.pg_toast.pg_toast_2619 2 2 237 0 rio.public.temp0000292380 1 0 0 0 contagem.public.usuarios 28 0 1828 0 rio.public.triagens 1 1 25651 0 rio.public.temp0000292376 1 0 0 0 rio.public.tmp_drill_0302 1 1 0 0 brasilia.public.temp0000240870 2 0 0 0 Total 480 208 366,707 5,861 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 24 00 0 1 01 0 3 02 0 0 03 0 0 04 1 1 05 7 1 06 0 0 07 30 48 08 51 98 09 72 147 10 38 114 11 38 94 12 10 33 13 36 86 14 70 156 15 59 126 16 37 90 17 27 57 18 0 0 19 0 0 20 0 1 21 4 2 22 0 1 23 0 1 - 48.46 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 3m3s 3m3s 3m3s 3m3s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 11:38:13 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 00:05:33 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 20:05:07 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s 1s 1s 1s drop table if exists temp0000292328;-
DROP TABLE IF EXISTS temp0000292328;
Date: 2026-09-24 08:45:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000292328;
Date: 2026-09-24 08:27:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000292328;
Date: 2026-09-24 16:04:43 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 3m3s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-24 11:38:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s DROP TABLE IF EXISTS temp0000292328;[ Date: 2026-09-24 08:45:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,329 Total read queries
- 1,357 Total write queries
Queries by database
Key values
- rio Main database
- 3,174 Requests
- 5h1m59s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,960 Requests
User Request type Count Duration etiquetas Total 38 9s146ms select 38 9s146ms intelifix Total 4,960 6h52m2s copy to 401 41m25s ddl 956 54m48s others 422 44m57s select 3,181 4h30m52s lenon Total 110 1m25s select 110 1m25s Duration by user
Key values
- 6h52m2s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 38 9s146ms select 38 9s146ms intelifix Total 4,960 6h52m2s copy to 401 41m25s ddl 956 54m48s others 422 44m57s select 3,181 4h30m52s lenon Total 110 1m25s select 110 1m25s Queries by host
Key values
- [local] Main host
- 5,108 Requests
- 6h53m37s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,060 Requests
- 3h34m32s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-24 08:14:03 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,544 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m10s analyze verbose;[ Date: 2026-09-24 05:11:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 07:12:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m23s analyze verbose;[ Date: 2026-09-24 05:18:35 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-09-01''),DATE(''2026-09-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-09-24 13:20:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030326, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-24 10:37:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m18s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030291, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-24 08:03:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030392, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-24 16:12:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 11:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 09:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030328, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-24 11:38:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030327, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-24 11:19:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 15:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 17:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-09-01''),DATE(''2026-09-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-09-24 15:37:30 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 14:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 13:10:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 16:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 10:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 20:10:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-24 08:10:19 - 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 1h35m11s 48 2s85ms 7m36s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 07 3 8m25s 2m48s 08 3 5m43s 1m54s 09 3 6m10s 2m3s 10 3 5m51s 1m57s 11 3 6m18s 2m6s 12 3 5m35s 1m51s 13 3 5m50s 1m56s 14 3 5m54s 1m58s 15 3 5m57s 1m59s 16 3 5m50s 1m56s 17 3 6m5s 2m1s 18 3 5m28s 1m49s 19 3 5m22s 1m47s 20 3 5m47s 1m55s 21 3 5m27s 1m49s 22 3 5m21s 1m47s [ User: intelifix - Total duration: 1h35m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h35m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 07:12:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 11:11:02 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 09:10:53 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: psql
2 1h4m22s 47 255ms 3m47s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 07 3 5m16s 1m45s 08 3 3m55s 1m18s 09 3 4m9s 1m23s 10 3 3m57s 1m19s 11 3 3m56s 1m18s 12 3 3m54s 1m18s 13 3 3m52s 1m17s 14 3 4m1s 1m20s 15 3 3m56s 1m18s 16 2 4m2s 2m1s 17 3 3m56s 1m18s 18 3 3m50s 1m16s 19 3 3m54s 1m18s 20 3 3m55s 1m18s 21 3 3m51s 1m17s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h4m22s - Times executed: 47 ]
[ Application: psql - Total duration: 1h4m22s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-24 07:18:32 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-24 09:15:19 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-24 14:14:54 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1h20s 196 152ms 6m49s 18s471ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 07 16 1m16s 4s804ms 08 13 7m18s 33s725ms 09 40 2m41s 4s38ms 10 20 7m17s 21s872ms 11 18 12m56s 43s125ms 12 4 48s524ms 12s131ms 13 14 6m55s 29s699ms 14 16 20s720ms 1s295ms 15 33 10m9s 18s457ms 16 8 6m42s 50s288ms 17 14 3m53s 16s673ms [ User: intelifix - Total duration: 1h20s - Times executed: 196 ]
[ Application: [unknown] - Total duration: 1h20s - Times executed: 196 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-09-01''),DATE(''2026-09-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-09-24 13:20:19 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030326, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-24 10:37:54 Duration: 6m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030291, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-24 08:03:35 Duration: 6m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 21m37s 3 3m3s 11m10s 7m12s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 05 3 21m37s 7m12s [ User: intelifix - Total duration: 21m37s - Times executed: 3 ]
[ Application: psql - Total duration: 21m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-24 05:11:11 Duration: 11m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-24 05:18:35 Duration: 7m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-24 05:21:39 Duration: 3m3s Database: contagem User: intelifix Remote: [local] Application: psql
5 15m5s 92 1s513ms 1m50s 9s839ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 07 2 17s99ms 8s549ms 09 6 2m44s 27s357ms 10 3 14s867ms 4s955ms 11 1 4s789ms 4s789ms 12 4 17s871ms 4s467ms 13 5 21s768ms 4s353ms 14 9 3m13s 21s463ms 15 12 3m10s 15s848ms 16 15 2m13s 8s933ms 17 35 2m27s 4s210ms [ User: intelifix - Total duration: 15m5s - Times executed: 92 ]
[ Application: [unknown] - Total duration: 15m5s - Times executed: 92 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-24', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 09:31:12 Duration: 1m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 14:03:40 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-24', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 14:45:11 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 14m9s 82 8s217ms 1m4s 10s363ms create table temp0000292328 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 07 26 4m35s 10s602ms 08 17 2m30s 8s881ms 09 6 59s817ms 9s969ms 10 9 1m38s 10s922ms 11 9 1m41s 11s286ms 12 2 21s292ms 10s646ms 14 2 22s215ms 11s107ms 15 6 1m5s 10s969ms 16 5 54s90ms 10s818ms [ User: intelifix - Total duration: 14m9s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 14m9s - Times executed: 82 ]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 07:02:40 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 11:13:29 Duration: 14s651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 16:05:29 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11m15s 913 150ms 5s795ms 740ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 07 11 6s515ms 592ms 08 100 1m30s 903ms 09 156 1m59s 763ms 10 147 1m34s 646ms 11 95 55s869ms 588ms 12 17 10s119ms 595ms 13 83 48s908ms 589ms 14 97 1m19s 817ms 15 83 1m15s 904ms 16 97 1m12s 742ms 17 27 23s435ms 867ms [ User: intelifix - Total duration: 11m15s - Times executed: 913 ]
[ Application: [unknown] - Total duration: 11m15s - Times executed: 913 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289640, 450, 'Z87325051014502,241738570814,241765391636,241776195978,241745806076,241817010714,241778845563$Z87325051023131,241739433737,241746406370,241759495560,241768999911,241764646377,241775609400,241812995271$Z87325051015422,241738662843,241779182847,241769933347', '',0464,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-24 13:48:33 Duration: 5s795ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289617, 450, 'CP2310324PH,D4925E34216C,544D42420065C3E6,D4925E34216F$CP233032EVC,D4925EE40F82,544D4242006E88E3,D4925EE40F85$CP23193220B,D4925E9FD1A7,544D424200699139,D4925E9FD1AA$CP234532GHC,08C7F5044B7D,544D42420073784A,08C7F5044B80$CP225032361,A0B53CF99F38,544D42420060B57E,A0B53CF99F3B$CP240932L1U,08C7F52E3E66,544D4242007854A3,08C7F52E3E69$CP23193222T,D4925E9FD489,544D42420069918B,D4925E9FD48C$CP2319328CM,D4925EA0C5A3,544D42420069AC55,D4925EA0C5A6$CP240932H9Y,08C7F52DD4EE,544D4242007848EB,08C7F52DD4F1$CP234332A11,D4925EFFC29C,544D42420072D3F1,D4925EFFC29F$CP234232T50,D4925EF98748,544D4242007254C5,D4925EF9874B$CP23453235W,08C7F5024C7E,544D424200733F83,08C7F5024C81$CP240332HNC,08C7F5237300,544D42420076EC85,08C7F5237303$CP230532928,D4925E19E56C,544D424200639DE7,D4925E19E56F$CP2404326CV,08C7F525E1A0,544D4242007731B1,08C7F525E1A3$CP230132UPU,D4925E05AECF,544D424200618A16,D4925E05AED0$CP234532FZ0,08C7F504362F,544D4242007375EC,08C7F5043632$CP240432644,08C7F525D777,544D424200773090,08C7F525D77A$CP233032FQ5,D4925EE42FD1,544D4242006E8C7A,D4925EE42FD4$CP234232Q1A,D4925EF91023,544D424200724788,D4925EF91026$CP2310322MA,D4925E33D225,544D42420065BB17,D4925E33D228$CP234532DQ2,08C7F503E067,544D424200736C64,08C7F503E06A$CP230132AFE,D4925E02F3DE,544D424200613C6D,D4925E02F3E1$CP230332835,D4925E14CB4F,544D42420062D5A8,D4925E14CB52$CP2319322CZ,D4925E9FE059,544D4242006992DB,D4925E9FE05C$CP2345324MS,08C7F5028533,544D4242007345D0,08C7F5028536$CP234332A0S,D4925EFFC254,544D42420072D3E9,D4925EFFC257$CP233032EQW,D4925EE40A4E,544D4242006E884F,D4925EE40A51$CP2319321MR,D4925E9FC481,544D424200698FC3,D4925E9FC484$CP2319328B3,D4925EA0C3D8,544D42420069AC22,D4925EA0C3DB$CP23453232T,08C7F50248E8,544D424200733F1D,08C7F50248EB$CP2305327TF,D4925E19B61A,544D4242006398A5,D4925E19B61D$CP240932END,08C7F52D7086,544D424200783DC3,08C7F52D7089$CP240932LZ1,08C7F52E616A,544D424200785887,08C7F52E616D$CP233032GMH,D4925EE452F9,544D4242006E9062,D4925EE452FC$CP2404325UD,08C7F525CD57,544D424200772F70,08C7F525CD5A$CP24073280B,08C7F52A5C68,544D42420077EF01,08C7F52A5C6B$CP232532JN6,D4925ECE5D55,544D4242006D62C3,D4925ECE5D58$CP23193222H,D4925E9FD42F,544D424200699181,D4925E9FD432$CP23033265L,D4925E148157,544D42420062CD70,D4925E14815A', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-24 08:12:27 Duration: 3s881ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (59268, 406, '835163924001093,241689191427,241618241315,241676792641,241708911320,241729506887,241708827596,241678478204,241676758091,241698680322,241704721214,241667599409,241695625062,241698662340,241676725361,241649470727,241631240014,241660125559,241593298701,241783829797,241639368910,241593430611,241712505576,241637719007,241704368800,241654365154,241708929806,241731761328,241594994848,241604320619,241598831127,241714938697,241663829501,241668298197,241708902127,241711223644,241671497488,241728534559,241732117074,241699887273,241604273543,241698702344,241666335862,241646433853,241726628491,241595788595,241695437692,241730908809,241704357687,241601128702,241708897580', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"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-09-24 17:24:48 Duration: 3s563ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 10m15s 149 156ms 3m6s 4s130ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 00 7 27s9ms 3s858ms 01 6 16s620ms 2s770ms 02 6 16s378ms 2s729ms 03 6 17s533ms 2s922ms 04 6 17s531ms 2s921ms 05 6 18s199ms 3s33ms 06 6 16s678ms 2s779ms 07 6 18s328ms 3s54ms 08 8 22s356ms 2s794ms 09 7 20s244ms 2s892ms 10 7 19s448ms 2s778ms 11 7 3m23s 29s90ms 12 6 17s655ms 2s942ms 13 6 17s895ms 2s982ms 14 7 20s763ms 2s966ms 15 7 19s664ms 2s809ms 16 7 17s752ms 2s536ms 17 6 17s779ms 2s963ms 18 7 17s113ms 2s444ms 19 6 16s948ms 2s824ms 20 7 21s535ms 3s76ms 21 6 17s210ms 2s868ms 22 6 17s223ms 2s870ms [ User: intelifix - Total duration: 10m15s - Times executed: 149 ]
[ Application: psql - Total duration: 10m15s - Times executed: 149 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 11:38:13 Duration: 3m6s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 00:05:33 Duration: 11s756ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 20:05:07 Duration: 5s661ms Database: rio User: intelifix Remote: [local] Application: psql
9 6m55s 164 170ms 19s845ms 2s530ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 00 6 30s684ms 5s114ms 01 6 19s82ms 3s180ms 02 5 12s380ms 2s476ms 03 5 16s707ms 3s341ms 04 6 16s544ms 2s757ms 05 3 4s838ms 1s612ms 06 4 5s775ms 1s443ms 07 11 28s974ms 2s634ms 08 12 25s569ms 2s130ms 09 12 43s321ms 3s610ms 10 11 23s234ms 2s112ms 11 13 35s431ms 2s725ms 12 13 17s693ms 1s361ms 13 7 7s730ms 1s104ms 14 12 26s528ms 2s210ms 15 12 43s642ms 3s636ms 16 10 35s869ms 3s586ms 17 3 4s23ms 1s341ms 20 1 498ms 498ms 21 6 7s30ms 1s171ms 22 6 9s495ms 1s582ms [ User: intelifix - Total duration: 6m55s - Times executed: 164 ]
[ Application: psql - Total duration: 6m55s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 00:05:21 Duration: 19s845ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 09:55:13 Duration: 11s610ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 16:25:10 Duration: 9s157ms Database: rio User: intelifix Remote: [local] Application: psql
10 6m48s 37 10s604ms 11s401ms 11s35ms create table temp0000292430 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 15 37 6m48s 11s35ms [ User: intelifix - Total duration: 6m48s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 6m48s - Times executed: 37 ]
-
CREATE TABLE temp0000292430 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:33:05 Duration: 11s401ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292430 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:37:05 Duration: 11s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292430 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:21:57 Duration: 11s335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m33s 51 272ms 1m36s 7s706ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 07 6 1m49s 18s291ms 08 4 12s8ms 3s2ms 09 9 46s56ms 5s117ms 10 2 38s362ms 19s181ms 11 3 14s967ms 4s989ms 12 2 20s314ms 10s157ms 13 2 34s420ms 17s210ms 14 6 46s556ms 7s759ms 15 11 45s984ms 4s180ms 16 3 20s599ms 6s866ms 17 3 3s991ms 1s330ms [ User: intelifix - Total duration: 6m33s - Times executed: 51 ]
[ Application: psql - Total duration: 6m33s - Times executed: 51 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030284);
Date: 2026-09-24 07:06:03 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030322);
Date: 2026-09-24 10:05:05 Duration: 30s788ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030337);
Date: 2026-09-24 13:56:16 Duration: 26s320ms Database: rio User: intelifix Remote: [local] Application: psql
12 6m26s 680 150ms 3s144ms 568ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 07 1 2s529ms 2s529ms 08 62 49s826ms 803ms 09 104 1m12s 692ms 10 106 51s421ms 485ms 11 80 37s609ms 470ms 12 17 6s708ms 394ms 13 74 47s1ms 635ms 14 65 32s122ms 494ms 15 90 52s12ms 577ms 16 49 22s879ms 466ms 17 32 12s744ms 398ms [ User: intelifix - Total duration: 6m26s - Times executed: 680 ]
[ Application: [unknown] - Total duration: 6m26s - Times executed: 680 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290361", "modelo" : "320", "itens" : "241601514654,241728644749,241695194459,241665791534,241694942841,241609930325,241669605968,241674242336,241673170728,241669615969,241694856872,241609943636,241622674250,241727965760,241602593940,241715733153,241617526082,241634980424,241615921515,241650561529,241649597988,241638359608,241639040719,241654315778,241629873449,241661460808,230047923341,241697051936,241597422235,241702162749,241653303749,241650558497,241691793050,241615187391,241675435976,241698701839,241667825671,241646511616,241658522328,241598749299,241674142629,241645494154,230039892434,241599480618,241638268184,241664957781,241628054966,241618881737", "usuario" : "414", "caixa" : "3707365", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 09:45:40 Duration: 3s144ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290363", "modelo" : "320", "itens" : "241727299398,241663162029,241604591734,241679397901,241714535673,241652280002,241673203435,241672329297,241637307395,241601583651,241651418996,241657962442,230049316978,241714579920,241649137786,241734186165,241700680416,241621279400,241629157385,241677667989,241662660409,241688821537,241655009415,241594041333,241604214345,241628213141,241616053447,241631504865,241627943642,241616075974,241607152040,241726910114,241596663642,241654949207,241627870729,241695180923,241677827073,241605412128,241654938296,241617822834,241622534360,241654917587,241694386568,241711227078,241710788090,241694382629,241697082141,241676458993", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 08:08:48 Duration: 2s616ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290360", "modelo" : "320", "itens" : "241638391531,241679283344,241663020018,241645856164,241658525863,241618178199,241645860004,241712582834,241691750319,241595780919,241599472738,241664925455,241665219401,241616757084,241663176676,241593089612,241615186482,241593920210,230048078787,241674080121,241609233657,241630868709,241599412833,241658298691,241649620315,241706535779,241689863142,241674109820,241704745963,241672732222,241663207588,241706508099,241647646182,241628802626,241652112634,241615167793,241674104466,241615156984,241608843035,241658628702,241638302532,241650466670,241615164460,241638295561,241608841924,241593861214,241631454658,241674119797", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 07:58:00 Duration: 2s529ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5m39s 111 2s254ms 25s855ms 3s57ms create table temp0000292328 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 07 32 1m38s 3s85ms 08 21 51s462ms 2s450ms 09 11 28s414ms 2s583ms 10 11 28s625ms 2s602ms 11 10 26s624ms 2s662ms 12 5 13s207ms 2s641ms 14 9 36s793ms 4s88ms 15 4 12s5ms 3s1ms 16 8 43s520ms 5s440ms [ User: intelifix - Total duration: 5m39s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 5m39s - Times executed: 111 ]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 07:05:25 Duration: 25s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 16:12:58 Duration: 23s286ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 14:56:54 Duration: 14s427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 5m18s 28 10s624ms 20s290ms 11s370ms create table temp0000292414 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 13 5 1m4s 12s866ms 14 23 4m14s 11s45ms [ User: intelifix - Total duration: 5m18s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 5m18s - Times executed: 28 ]
-
CREATE TABLE temp0000292414 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 13:55:37 Duration: 20s290ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292414 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 14:25:12 Duration: 11s398ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292414 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 14:17:28 Duration: 11s389ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 4m39s 29 8s525ms 11s440ms 9s633ms create table temp0000292372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 08 10 1m28s 8s838ms 09 16 2m37s 9s852ms 10 3 33s336ms 11s112ms [ User: intelifix - Total duration: 4m39s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 4m39s - Times executed: 29 ]
-
CREATE TABLE temp0000292372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 09:17:44 Duration: 11s440ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 10:04:45 Duration: 11s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 09:18:52 Duration: 11s146ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m42s 101 153ms 15s585ms 1s606ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 07 15 11s500ms 766ms 09 19 1m16s 4s48ms 10 9 5s153ms 572ms 11 8 5s554ms 694ms 13 8 4s739ms 592ms 14 9 11s180ms 1s242ms 15 29 45s298ms 1s562ms 17 4 1s909ms 477ms [ User: intelifix - Total duration: 2m42s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 2m42s - Times executed: 101 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-24 09:22:50 Duration: 15s585ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-24 09:23:19 Duration: 13s205ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-24 15:01:25 Duration: 12s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 2m34s 13 10s512ms 19s301ms 11s909ms create table temp0000292432 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 15 7 1m18s 11s165ms 16 2 30s819ms 15s409ms 17 4 45s843ms 11s460ms [ User: intelifix - Total duration: 2m34s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m34s - Times executed: 13 ]
-
CREATE TABLE temp0000292432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 16:15:22 Duration: 19s301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 17:42:35 Duration: 13s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:44:06 Duration: 11s742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m15s 4 4s748ms 1m3s 33s823ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 20 2 1m7s 33s956ms 23 2 1m7s 33s690ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-24 20:08:39 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-24 23:16:34 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-24 20:10:38 Duration: 4s861ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m57s 339 150ms 1s260ms 347ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 13 122 46s306ms 379ms 14 107 35s146ms 328ms 15 110 36s305ms 330ms [ User: intelifix - Total duration: 1m57s - Times executed: 339 ]
[ Application: [unknown] - Total duration: 1m57s - Times executed: 339 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"138310","seriais":"241628228495,241620672540,241699077183,241708585171,241630909093,241713836884,241637159704,241659516173,241607106479,241607694954,241680732745,241731149719,241690551627,241678226686,241717097191,241701765863,241616888185,241657651828,241700808788,241717094060,241678260910,241717096787,241701786168","usuario":"399","observacao":""}');
Date: 2026-09-24 14:09:40 Duration: 1s260ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"138310","seriais":"241708691624,241619561332,241680272240,241713835167,241679870809,241731658892,241607662123,241731653135,241631538909,241646522829,241678271618,241615386681,241699057787,241604354763,241602980421,241674647279,241733944548,241631563030,241731143658,241689524646,241699056373,241731663237,241602979410,241727529095,241631546990,241673288291,241678277678,241731191216,241632318288,241708594162,241678278587,241700796363,241708576584,241700779516,241647633959,241664124760","usuario":"399","observacao":""}');
Date: 2026-09-24 13:50:06 Duration: 1s244ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"138310","seriais":"241679876869,241701749801,241659517991,241708587999,241701735052,241690577790,241599524157,241731670410,241656895760,230049184059,241631534060,241708705665,241668154951,241731171315,241708581939,241699084154,241731559411,241679875758,241597885770,241595405169,241731168889,241708570221,241646477897,241727573646,241677180816,241620174960,241615192847,241689505273,241616018796,241647889719,241707753036,241670159715,241731164950,241731172426,241701764146","usuario":"399","observacao":""}');
Date: 2026-09-24 13:55:55 Duration: 1s109ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 1m46s 6 3s121ms 39s525ms 17s700ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 20 3 53s197ms 17s732ms 23 3 53s4ms 17s668ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-24 20:06:26 Duration: 39s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-24 23:14:22 Duration: 39s223ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-24 20:10:14 Duration: 10s550ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 913 11m15s 150ms 5s795ms 740ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 07 11 6s515ms 592ms 08 100 1m30s 903ms 09 156 1m59s 763ms 10 147 1m34s 646ms 11 95 55s869ms 588ms 12 17 10s119ms 595ms 13 83 48s908ms 589ms 14 97 1m19s 817ms 15 83 1m15s 904ms 16 97 1m12s 742ms 17 27 23s435ms 867ms [ User: intelifix - Total duration: 11m15s - Times executed: 913 ]
[ Application: [unknown] - Total duration: 11m15s - Times executed: 913 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289640, 450, 'Z87325051014502,241738570814,241765391636,241776195978,241745806076,241817010714,241778845563$Z87325051023131,241739433737,241746406370,241759495560,241768999911,241764646377,241775609400,241812995271$Z87325051015422,241738662843,241779182847,241769933347', '',0464,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-24 13:48:33 Duration: 5s795ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289617, 450, 'CP2310324PH,D4925E34216C,544D42420065C3E6,D4925E34216F$CP233032EVC,D4925EE40F82,544D4242006E88E3,D4925EE40F85$CP23193220B,D4925E9FD1A7,544D424200699139,D4925E9FD1AA$CP234532GHC,08C7F5044B7D,544D42420073784A,08C7F5044B80$CP225032361,A0B53CF99F38,544D42420060B57E,A0B53CF99F3B$CP240932L1U,08C7F52E3E66,544D4242007854A3,08C7F52E3E69$CP23193222T,D4925E9FD489,544D42420069918B,D4925E9FD48C$CP2319328CM,D4925EA0C5A3,544D42420069AC55,D4925EA0C5A6$CP240932H9Y,08C7F52DD4EE,544D4242007848EB,08C7F52DD4F1$CP234332A11,D4925EFFC29C,544D42420072D3F1,D4925EFFC29F$CP234232T50,D4925EF98748,544D4242007254C5,D4925EF9874B$CP23453235W,08C7F5024C7E,544D424200733F83,08C7F5024C81$CP240332HNC,08C7F5237300,544D42420076EC85,08C7F5237303$CP230532928,D4925E19E56C,544D424200639DE7,D4925E19E56F$CP2404326CV,08C7F525E1A0,544D4242007731B1,08C7F525E1A3$CP230132UPU,D4925E05AECF,544D424200618A16,D4925E05AED0$CP234532FZ0,08C7F504362F,544D4242007375EC,08C7F5043632$CP240432644,08C7F525D777,544D424200773090,08C7F525D77A$CP233032FQ5,D4925EE42FD1,544D4242006E8C7A,D4925EE42FD4$CP234232Q1A,D4925EF91023,544D424200724788,D4925EF91026$CP2310322MA,D4925E33D225,544D42420065BB17,D4925E33D228$CP234532DQ2,08C7F503E067,544D424200736C64,08C7F503E06A$CP230132AFE,D4925E02F3DE,544D424200613C6D,D4925E02F3E1$CP230332835,D4925E14CB4F,544D42420062D5A8,D4925E14CB52$CP2319322CZ,D4925E9FE059,544D4242006992DB,D4925E9FE05C$CP2345324MS,08C7F5028533,544D4242007345D0,08C7F5028536$CP234332A0S,D4925EFFC254,544D42420072D3E9,D4925EFFC257$CP233032EQW,D4925EE40A4E,544D4242006E884F,D4925EE40A51$CP2319321MR,D4925E9FC481,544D424200698FC3,D4925E9FC484$CP2319328B3,D4925EA0C3D8,544D42420069AC22,D4925EA0C3DB$CP23453232T,08C7F50248E8,544D424200733F1D,08C7F50248EB$CP2305327TF,D4925E19B61A,544D4242006398A5,D4925E19B61D$CP240932END,08C7F52D7086,544D424200783DC3,08C7F52D7089$CP240932LZ1,08C7F52E616A,544D424200785887,08C7F52E616D$CP233032GMH,D4925EE452F9,544D4242006E9062,D4925EE452FC$CP2404325UD,08C7F525CD57,544D424200772F70,08C7F525CD5A$CP24073280B,08C7F52A5C68,544D42420077EF01,08C7F52A5C6B$CP232532JN6,D4925ECE5D55,544D4242006D62C3,D4925ECE5D58$CP23193222H,D4925E9FD42F,544D424200699181,D4925E9FD432$CP23033265L,D4925E148157,544D42420062CD70,D4925E14815A', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-24 08:12:27 Duration: 3s881ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (59268, 406, '835163924001093,241689191427,241618241315,241676792641,241708911320,241729506887,241708827596,241678478204,241676758091,241698680322,241704721214,241667599409,241695625062,241698662340,241676725361,241649470727,241631240014,241660125559,241593298701,241783829797,241639368910,241593430611,241712505576,241637719007,241704368800,241654365154,241708929806,241731761328,241594994848,241604320619,241598831127,241714938697,241663829501,241668298197,241708902127,241711223644,241671497488,241728534559,241732117074,241699887273,241604273543,241698702344,241666335862,241646433853,241726628491,241595788595,241695437692,241730908809,241704357687,241601128702,241708897580', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"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-09-24 17:24:48 Duration: 3s563ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 680 6m26s 150ms 3s144ms 568ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 07 1 2s529ms 2s529ms 08 62 49s826ms 803ms 09 104 1m12s 692ms 10 106 51s421ms 485ms 11 80 37s609ms 470ms 12 17 6s708ms 394ms 13 74 47s1ms 635ms 14 65 32s122ms 494ms 15 90 52s12ms 577ms 16 49 22s879ms 466ms 17 32 12s744ms 398ms [ User: intelifix - Total duration: 6m26s - Times executed: 680 ]
[ Application: [unknown] - Total duration: 6m26s - Times executed: 680 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290361", "modelo" : "320", "itens" : "241601514654,241728644749,241695194459,241665791534,241694942841,241609930325,241669605968,241674242336,241673170728,241669615969,241694856872,241609943636,241622674250,241727965760,241602593940,241715733153,241617526082,241634980424,241615921515,241650561529,241649597988,241638359608,241639040719,241654315778,241629873449,241661460808,230047923341,241697051936,241597422235,241702162749,241653303749,241650558497,241691793050,241615187391,241675435976,241698701839,241667825671,241646511616,241658522328,241598749299,241674142629,241645494154,230039892434,241599480618,241638268184,241664957781,241628054966,241618881737", "usuario" : "414", "caixa" : "3707365", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 09:45:40 Duration: 3s144ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290363", "modelo" : "320", "itens" : "241727299398,241663162029,241604591734,241679397901,241714535673,241652280002,241673203435,241672329297,241637307395,241601583651,241651418996,241657962442,230049316978,241714579920,241649137786,241734186165,241700680416,241621279400,241629157385,241677667989,241662660409,241688821537,241655009415,241594041333,241604214345,241628213141,241616053447,241631504865,241627943642,241616075974,241607152040,241726910114,241596663642,241654949207,241627870729,241695180923,241677827073,241605412128,241654938296,241617822834,241622534360,241654917587,241694386568,241711227078,241710788090,241694382629,241697082141,241676458993", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 08:08:48 Duration: 2s616ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290360", "modelo" : "320", "itens" : "241638391531,241679283344,241663020018,241645856164,241658525863,241618178199,241645860004,241712582834,241691750319,241595780919,241599472738,241664925455,241665219401,241616757084,241663176676,241593089612,241615186482,241593920210,230048078787,241674080121,241609233657,241630868709,241599412833,241658298691,241649620315,241706535779,241689863142,241674109820,241704745963,241672732222,241663207588,241706508099,241647646182,241628802626,241652112634,241615167793,241674104466,241615156984,241608843035,241658628702,241638302532,241650466670,241615164460,241638295561,241608841924,241593861214,241631454658,241674119797", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 07:58:00 Duration: 2s529ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 339 1m57s 150ms 1s260ms 347ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 13 122 46s306ms 379ms 14 107 35s146ms 328ms 15 110 36s305ms 330ms [ User: intelifix - Total duration: 1m57s - Times executed: 339 ]
[ Application: [unknown] - Total duration: 1m57s - Times executed: 339 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"138310","seriais":"241628228495,241620672540,241699077183,241708585171,241630909093,241713836884,241637159704,241659516173,241607106479,241607694954,241680732745,241731149719,241690551627,241678226686,241717097191,241701765863,241616888185,241657651828,241700808788,241717094060,241678260910,241717096787,241701786168","usuario":"399","observacao":""}');
Date: 2026-09-24 14:09:40 Duration: 1s260ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"138310","seriais":"241708691624,241619561332,241680272240,241713835167,241679870809,241731658892,241607662123,241731653135,241631538909,241646522829,241678271618,241615386681,241699057787,241604354763,241602980421,241674647279,241733944548,241631563030,241731143658,241689524646,241699056373,241731663237,241602979410,241727529095,241631546990,241673288291,241678277678,241731191216,241632318288,241708594162,241678278587,241700796363,241708576584,241700779516,241647633959,241664124760","usuario":"399","observacao":""}');
Date: 2026-09-24 13:50:06 Duration: 1s244ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"138310","seriais":"241679876869,241701749801,241659517991,241708587999,241701735052,241690577790,241599524157,241731670410,241656895760,230049184059,241631534060,241708705665,241668154951,241731171315,241708581939,241699084154,241731559411,241679875758,241597885770,241595405169,241731168889,241708570221,241646477897,241727573646,241677180816,241620174960,241615192847,241689505273,241616018796,241647889719,241707753036,241670159715,241731164950,241731172426,241701764146","usuario":"399","observacao":""}');
Date: 2026-09-24 13:55:55 Duration: 1s109ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 196 1h20s 152ms 6m49s 18s471ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 24 07 16 1m16s 4s804ms 08 13 7m18s 33s725ms 09 40 2m41s 4s38ms 10 20 7m17s 21s872ms 11 18 12m56s 43s125ms 12 4 48s524ms 12s131ms 13 14 6m55s 29s699ms 14 16 20s720ms 1s295ms 15 33 10m9s 18s457ms 16 8 6m42s 50s288ms 17 14 3m53s 16s673ms [ User: intelifix - Total duration: 1h20s - Times executed: 196 ]
[ Application: [unknown] - Total duration: 1h20s - Times executed: 196 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-09-01''),DATE(''2026-09-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-09-24 13:20:19 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030326, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-24 10:37:54 Duration: 6m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030291, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-24 08:03:35 Duration: 6m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 164 6m55s 170ms 19s845ms 2s530ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 00 6 30s684ms 5s114ms 01 6 19s82ms 3s180ms 02 5 12s380ms 2s476ms 03 5 16s707ms 3s341ms 04 6 16s544ms 2s757ms 05 3 4s838ms 1s612ms 06 4 5s775ms 1s443ms 07 11 28s974ms 2s634ms 08 12 25s569ms 2s130ms 09 12 43s321ms 3s610ms 10 11 23s234ms 2s112ms 11 13 35s431ms 2s725ms 12 13 17s693ms 1s361ms 13 7 7s730ms 1s104ms 14 12 26s528ms 2s210ms 15 12 43s642ms 3s636ms 16 10 35s869ms 3s586ms 17 3 4s23ms 1s341ms 20 1 498ms 498ms 21 6 7s30ms 1s171ms 22 6 9s495ms 1s582ms [ User: intelifix - Total duration: 6m55s - Times executed: 164 ]
[ Application: psql - Total duration: 6m55s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 00:05:21 Duration: 19s845ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 09:55:13 Duration: 11s610ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 16:25:10 Duration: 9s157ms Database: rio User: intelifix Remote: [local] Application: psql
6 149 10m15s 156ms 3m6s 4s130ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 00 7 27s9ms 3s858ms 01 6 16s620ms 2s770ms 02 6 16s378ms 2s729ms 03 6 17s533ms 2s922ms 04 6 17s531ms 2s921ms 05 6 18s199ms 3s33ms 06 6 16s678ms 2s779ms 07 6 18s328ms 3s54ms 08 8 22s356ms 2s794ms 09 7 20s244ms 2s892ms 10 7 19s448ms 2s778ms 11 7 3m23s 29s90ms 12 6 17s655ms 2s942ms 13 6 17s895ms 2s982ms 14 7 20s763ms 2s966ms 15 7 19s664ms 2s809ms 16 7 17s752ms 2s536ms 17 6 17s779ms 2s963ms 18 7 17s113ms 2s444ms 19 6 16s948ms 2s824ms 20 7 21s535ms 3s76ms 21 6 17s210ms 2s868ms 22 6 17s223ms 2s870ms [ User: intelifix - Total duration: 10m15s - Times executed: 149 ]
[ Application: psql - Total duration: 10m15s - Times executed: 149 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 11:38:13 Duration: 3m6s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 00:05:33 Duration: 11s756ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 20:05:07 Duration: 5s661ms Database: rio User: intelifix Remote: [local] Application: psql
7 111 5m39s 2s254ms 25s855ms 3s57ms create table temp0000292328 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 07 32 1m38s 3s85ms 08 21 51s462ms 2s450ms 09 11 28s414ms 2s583ms 10 11 28s625ms 2s602ms 11 10 26s624ms 2s662ms 12 5 13s207ms 2s641ms 14 9 36s793ms 4s88ms 15 4 12s5ms 3s1ms 16 8 43s520ms 5s440ms [ User: intelifix - Total duration: 5m39s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 5m39s - Times executed: 111 ]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 07:05:25 Duration: 25s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 16:12:58 Duration: 23s286ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 14:56:54 Duration: 14s427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 104 32s847ms 295ms 546ms 315ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 01 3 932ms 310ms 04 3 900ms 300ms 05 1 300ms 300ms 06 1 299ms 299ms 07 7 2s157ms 308ms 08 10 3s302ms 330ms 09 12 3s935ms 327ms 10 11 3s534ms 321ms 11 9 2s838ms 315ms 12 2 615ms 307ms 13 12 3s728ms 310ms 14 8 2s509ms 313ms 15 8 2s554ms 319ms 16 8 2s487ms 310ms 17 7 2s147ms 306ms 20 1 298ms 298ms 23 1 304ms 304ms [ User: lenon - Total duration: 32s847ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 32s847ms - Times executed: 104 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-24 08:45:02 Duration: 546ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-24 09:15:00 Duration: 430ms 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-09-24 09:38:24 Duration: 413ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 101 2m42s 153ms 15s585ms 1s606ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 07 15 11s500ms 766ms 09 19 1m16s 4s48ms 10 9 5s153ms 572ms 11 8 5s554ms 694ms 13 8 4s739ms 592ms 14 9 11s180ms 1s242ms 15 29 45s298ms 1s562ms 17 4 1s909ms 477ms [ User: intelifix - Total duration: 2m42s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 2m42s - Times executed: 101 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-24 09:22:50 Duration: 15s585ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-24 09:23:19 Duration: 13s205ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-24 15:01:25 Duration: 12s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 96 37s79ms 330ms 747ms 386ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 01 3 1s450ms 483ms 04 3 1s53ms 351ms 05 1 451ms 451ms 07 4 1s360ms 340ms 08 9 3s892ms 432ms 09 12 4s562ms 380ms 10 11 4s76ms 370ms 11 8 2s983ms 372ms 12 2 733ms 366ms 13 12 4s526ms 377ms 14 7 2s593ms 370ms 15 8 3s330ms 416ms 16 8 2s972ms 371ms 17 7 2s501ms 357ms 23 1 591ms 591ms [ User: intelifix - Total duration: 37s79ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 37s79ms - Times executed: 96 ]
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-09-24 01:20:35 Duration: 747ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-09-24 08:18:54 Duration: 746ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 21, 1);
Date: 2026-09-24 15:32:57 Duration: 702ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 92 15m5s 1s513ms 1m50s 9s839ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 07 2 17s99ms 8s549ms 09 6 2m44s 27s357ms 10 3 14s867ms 4s955ms 11 1 4s789ms 4s789ms 12 4 17s871ms 4s467ms 13 5 21s768ms 4s353ms 14 9 3m13s 21s463ms 15 12 3m10s 15s848ms 16 15 2m13s 8s933ms 17 35 2m27s 4s210ms [ User: intelifix - Total duration: 15m5s - Times executed: 92 ]
[ Application: [unknown] - Total duration: 15m5s - Times executed: 92 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-24', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 09:31:12 Duration: 1m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 14:03:40 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-24', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 14:45:11 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 85 28s876ms 153ms 1s100ms 339ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 01 18 6s655ms 369ms 04 23 10s299ms 447ms 07 3 971ms 323ms 08 5 1s171ms 234ms 09 2 547ms 273ms 10 9 2s459ms 273ms 11 2 467ms 233ms 12 4 827ms 206ms 13 1 248ms 248ms 14 8 2s108ms 263ms 15 4 933ms 233ms 16 4 797ms 199ms 23 2 1s388ms 694ms [ User: intelifix - Total duration: 28s876ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 28s876ms - Times executed: 85 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241631328507,241610023442,241689343237,241639132748,241616014857,241617956382,241649840819,241646171931,241603589098,241674540828,241676679396,241674363133,241629173246,241669489414,241696958895,241659697279,230049385874,241701790210,241616203136,241596113050', NULL, NULL, 0320, 00);
Date: 2026-09-24 04:51:28 Duration: 1s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '80', 2, '241622032235,241694962338,241676431618,241712578186,241652104855', NULL, NULL, 0320, 00);
Date: 2026-09-24 23:42:04 Duration: 1s18ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241732900822,241661874260,241663813944,241694553959,241614618592,241609952223,241703522343,241734147878,241703555353,241695196580,241689446378,241622683039,241694908998,230057059900,241677732946,241631637178,241618315463,241667017578,241701236182,241617572832,241701693152', NULL, NULL, 0320, 00);
Date: 2026-09-24 04:36:10 Duration: 855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 85 24s376ms 207ms 1s58ms 286ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 07 9 3s214ms 357ms 08 13 3s512ms 270ms 09 12 3s556ms 296ms 10 7 1s877ms 268ms 11 5 1s379ms 275ms 12 2 569ms 284ms 13 4 1s90ms 272ms 14 6 1s742ms 290ms 15 14 3s898ms 278ms 16 6 1s656ms 276ms 17 7 1s879ms 268ms [ User: intelifix - Total duration: 24s376ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 24s376ms - Times executed: 85 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-24 07:56:02 Duration: 1s58ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-24 09:17:24 Duration: 446ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-24 16:00:55 Duration: 347ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 82 14m9s 8s217ms 1m4s 10s363ms create table temp0000292328 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 07 26 4m35s 10s602ms 08 17 2m30s 8s881ms 09 6 59s817ms 9s969ms 10 9 1m38s 10s922ms 11 9 1m41s 11s286ms 12 2 21s292ms 10s646ms 14 2 22s215ms 11s107ms 15 6 1m5s 10s969ms 16 5 54s90ms 10s818ms [ User: intelifix - Total duration: 14m9s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 14m9s - Times executed: 82 ]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 07:02:40 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 11:13:29 Duration: 14s651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 16:05:29 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 58 1m33s 566ms 26s80ms 1s610ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 08 4 5s112ms 1s278ms 09 4 4s377ms 1s94ms 10 3 2s30ms 676ms 11 3 3s429ms 1s143ms 12 4 4s622ms 1s155ms 13 3 5s963ms 1s987ms 14 4 9s594ms 2s398ms 15 3 2s340ms 780ms 16 4 7s343ms 1s835ms 17 5 7s430ms 1s486ms 18 5 29s108ms 5s821ms 19 4 2s742ms 685ms 20 4 2s951ms 737ms 21 4 3s366ms 841ms 22 4 2s986ms 746ms [ User: intelifix - Total duration: 1m33s - Times executed: 58 ]
[ Application: psql - Total duration: 1m33s - Times executed: 58 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-24 18:00:27 Duration: 26s80ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-24 14:20:09 Duration: 7s526ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-24 17:00:05 Duration: 4s297ms Database: rio User: intelifix Remote: [local] Application: psql
16 58 21s890ms 154ms 975ms 377ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 09 6 2s953ms 492ms 10 14 4s674ms 333ms 11 9 2s777ms 308ms 12 4 1s874ms 468ms 13 8 3s827ms 478ms 14 4 708ms 177ms 15 7 2s696ms 385ms 16 6 2s378ms 396ms [ User: intelifix - Total duration: 21s890ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 21s890ms - Times executed: 58 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '6C11BA6C09B7,D831398FFCDE,14CA56D4F2FD,3891484ABD41,843C99225467,D89A0DACDB03,4896D9532C58,3CF9F0AE70E4,C4EBFF8BD59E,843C9920BA9F,F4E84F8428D0,689E29BEA9D9,843C99227A59,D89A0DA65235,D89A0DB05D59,3CF9F070A799,D89A0DACBEBF,4896D957EED0,F4E84F849710,4896D958383E', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-24 13:01:58 Duration: 975ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '48BDCE72D613,F8D2AC5B8553,B85E71AF3EFB,B85E71AF515B,10A793412883,10A79341FD9B,F8D2AC59F6E3,CCF3C853ED2B', '138;1', 'DEFAULT', 09, 0312, '','', '', 00);
Date: 2026-09-24 12:54:04 Duration: 876ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'ZTEGD64164AC,ZTEGD970A323,4896D95890FA,ZTEGD7BA4BD9,ZTEGD7BBFB31,ZTEGDC70638B,ZTEGD640B670,ZTEGD70A3F43,ZTEGD97B0F98', '76;1', 'DEFAULT', 09, 0318, '','', '', 00);
Date: 2026-09-24 16:05:45 Duration: 858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 57 12s997ms 151ms 945ms 228ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 00 2 1s144ms 572ms 01 3 541ms 180ms 08 3 543ms 181ms 09 9 2s26ms 225ms 10 3 583ms 194ms 11 16 3s357ms 209ms 13 4 766ms 191ms 14 4 856ms 214ms 15 3 561ms 187ms 16 7 1s371ms 195ms 17 1 364ms 364ms 21 1 434ms 434ms 23 1 444ms 444ms [ User: intelifix - Total duration: 12s997ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 12s997ms - Times executed: 57 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241630674851');
Date: 2026-09-24 00:24:52 Duration: 945ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('');
Date: 2026-09-24 23:41:33 Duration: 444ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241665406265');
Date: 2026-09-24 21:01:51 Duration: 434ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 56 17s843ms 246ms 2s409ms 318ms create table temp0000292348 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 08 1 2s409ms 2s409ms 13 13 3s428ms 263ms 14 15 4s178ms 278ms 15 11 3s150ms 286ms 16 16 4s676ms 292ms [ User: intelifix - Total duration: 17s843ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 17s843ms - Times executed: 56 ]
-
CREATE TABLE temp0000292348 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 08:03:15 Duration: 2s409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292348 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"85202", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 16:45:32 Duration: 336ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292348 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"85202", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 15:19:21 Duration: 327ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 51 6m33s 272ms 1m36s 7s706ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 07 6 1m49s 18s291ms 08 4 12s8ms 3s2ms 09 9 46s56ms 5s117ms 10 2 38s362ms 19s181ms 11 3 14s967ms 4s989ms 12 2 20s314ms 10s157ms 13 2 34s420ms 17s210ms 14 6 46s556ms 7s759ms 15 11 45s984ms 4s180ms 16 3 20s599ms 6s866ms 17 3 3s991ms 1s330ms [ User: intelifix - Total duration: 6m33s - Times executed: 51 ]
[ Application: psql - Total duration: 6m33s - Times executed: 51 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030284);
Date: 2026-09-24 07:06:03 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030322);
Date: 2026-09-24 10:05:05 Duration: 30s788ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030337);
Date: 2026-09-24 13:56:16 Duration: 26s320ms Database: rio User: intelifix Remote: [local] Application: psql
20 48 1h35m11s 2s85ms 7m36s 1m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 07 3 8m25s 2m48s 08 3 5m43s 1m54s 09 3 6m10s 2m3s 10 3 5m51s 1m57s 11 3 6m18s 2m6s 12 3 5m35s 1m51s 13 3 5m50s 1m56s 14 3 5m54s 1m58s 15 3 5m57s 1m59s 16 3 5m50s 1m56s 17 3 6m5s 2m1s 18 3 5m28s 1m49s 19 3 5m22s 1m47s 20 3 5m47s 1m55s 21 3 5m27s 1m49s 22 3 5m21s 1m47s [ User: intelifix - Total duration: 1h35m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h35m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 07:12:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 11:11:02 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 09:10:53 Duration: 5m52s 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 3m3s 11m10s 7m12s 3 21m37s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 24 05 3 21m37s 7m12s [ User: intelifix - Total duration: 21m37s - Times executed: 3 ]
[ Application: psql - Total duration: 21m37s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-24 05:11:11 Duration: 11m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-24 05:18:35 Duration: 7m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-24 05:21:39 Duration: 3m3s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s85ms 7m36s 1m58s 48 1h35m11s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 24 07 3 8m25s 2m48s 08 3 5m43s 1m54s 09 3 6m10s 2m3s 10 3 5m51s 1m57s 11 3 6m18s 2m6s 12 3 5m35s 1m51s 13 3 5m50s 1m56s 14 3 5m54s 1m58s 15 3 5m57s 1m59s 16 3 5m50s 1m56s 17 3 6m5s 2m1s 18 3 5m28s 1m49s 19 3 5m22s 1m47s 20 3 5m47s 1m55s 21 3 5m27s 1m49s 22 3 5m21s 1m47s [ User: intelifix - Total duration: 1h35m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h35m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 07:12:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 11:11:02 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-24 09:10:53 Duration: 5m52s Database: rio User: intelifix Remote: [local] Application: psql
3 255ms 3m47s 1m22s 47 1h4m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 24 07 3 5m16s 1m45s 08 3 3m55s 1m18s 09 3 4m9s 1m23s 10 3 3m57s 1m19s 11 3 3m56s 1m18s 12 3 3m54s 1m18s 13 3 3m52s 1m17s 14 3 4m1s 1m20s 15 3 3m56s 1m18s 16 2 4m2s 2m1s 17 3 3m56s 1m18s 18 3 3m50s 1m16s 19 3 3m54s 1m18s 20 3 3m55s 1m18s 21 3 3m51s 1m17s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h4m22s - Times executed: 47 ]
[ Application: psql - Total duration: 1h4m22s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-24 07:18:32 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-24 09:15:19 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-24 14:14:54 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s748ms 1m3s 33s823ms 4 2m15s 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 Sep 24 20 2 1m7s 33s956ms 23 2 1m7s 33s690ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-24 20:08:39 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-24 23:16:34 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-24 20:10:38 Duration: 4s861ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 152ms 6m49s 18s471ms 196 1h20s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 24 07 16 1m16s 4s804ms 08 13 7m18s 33s725ms 09 40 2m41s 4s38ms 10 20 7m17s 21s872ms 11 18 12m56s 43s125ms 12 4 48s524ms 12s131ms 13 14 6m55s 29s699ms 14 16 20s720ms 1s295ms 15 33 10m9s 18s457ms 16 8 6m42s 50s288ms 17 14 3m53s 16s673ms [ User: intelifix - Total duration: 1h20s - Times executed: 196 ]
[ Application: [unknown] - Total duration: 1h20s - Times executed: 196 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-09-01''),DATE(''2026-09-23'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-09-24 13:20:19 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030326, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-24 10:37:54 Duration: 6m30s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030291, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-24 08:03:35 Duration: 6m18s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 3s121ms 39s525ms 17s700ms 6 1m46s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 24 20 3 53s197ms 17s732ms 23 3 53s4ms 17s668ms [ User: intelifix - Total duration: 1m46s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-24 20:06:26 Duration: 39s525ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-24 23:14:22 Duration: 39s223ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-24 20:10:14 Duration: 10s550ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 10s512ms 19s301ms 11s909ms 13 2m34s create table temp0000292432 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 24 15 7 1m18s 11s165ms 16 2 30s819ms 15s409ms 17 4 45s843ms 11s460ms [ User: intelifix - Total duration: 2m34s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m34s - Times executed: 13 ]
-
CREATE TABLE temp0000292432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 16:15:22 Duration: 19s301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 17:42:35 Duration: 13s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:44:06 Duration: 11s742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s624ms 20s290ms 11s370ms 28 5m18s create table temp0000292414 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 24 13 5 1m4s 12s866ms 14 23 4m14s 11s45ms [ User: intelifix - Total duration: 5m18s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 5m18s - Times executed: 28 ]
-
CREATE TABLE temp0000292414 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 13:55:37 Duration: 20s290ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292414 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 14:25:12 Duration: 11s398ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292414 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 14:17:28 Duration: 11s389ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s604ms 11s401ms 11s35ms 37 6m48s create table temp0000292430 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 24 15 37 6m48s 11s35ms [ User: intelifix - Total duration: 6m48s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 6m48s - Times executed: 37 ]
-
CREATE TABLE temp0000292430 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:33:05 Duration: 11s401ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292430 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:37:05 Duration: 11s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292430 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 15:21:57 Duration: 11s335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8s217ms 1m4s 10s363ms 82 14m9s create table temp0000292328 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 24 07 26 4m35s 10s602ms 08 17 2m30s 8s881ms 09 6 59s817ms 9s969ms 10 9 1m38s 10s922ms 11 9 1m41s 11s286ms 12 2 21s292ms 10s646ms 14 2 22s215ms 11s107ms 15 6 1m5s 10s969ms 16 5 54s90ms 10s818ms [ User: intelifix - Total duration: 14m9s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 14m9s - Times executed: 82 ]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 07:02:40 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 11:13:29 Duration: 14s651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 16:05:29 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 1s513ms 1m50s 9s839ms 92 15m5s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 24 07 2 17s99ms 8s549ms 09 6 2m44s 27s357ms 10 3 14s867ms 4s955ms 11 1 4s789ms 4s789ms 12 4 17s871ms 4s467ms 13 5 21s768ms 4s353ms 14 9 3m13s 21s463ms 15 12 3m10s 15s848ms 16 15 2m13s 8s933ms 17 35 2m27s 4s210ms [ User: intelifix - Total duration: 15m5s - Times executed: 92 ]
[ Application: [unknown] - Total duration: 15m5s - Times executed: 92 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-24', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 09:31:12 Duration: 1m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-23', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 14:03:40 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-24', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-24 14:45:11 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s525ms 11s440ms 9s633ms 29 4m39s create table temp0000292372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 24 08 10 1m28s 8s838ms 09 16 2m37s 9s852ms 10 3 33s336ms 11s112ms [ User: intelifix - Total duration: 4m39s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 4m39s - Times executed: 29 ]
-
CREATE TABLE temp0000292372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 09:17:44 Duration: 11s440ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 10:04:45 Duration: 11s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-24 09:18:52 Duration: 11s146ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 272ms 1m36s 7s706ms 51 6m33s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 24 07 6 1m49s 18s291ms 08 4 12s8ms 3s2ms 09 9 46s56ms 5s117ms 10 2 38s362ms 19s181ms 11 3 14s967ms 4s989ms 12 2 20s314ms 10s157ms 13 2 34s420ms 17s210ms 14 6 46s556ms 7s759ms 15 11 45s984ms 4s180ms 16 3 20s599ms 6s866ms 17 3 3s991ms 1s330ms [ User: intelifix - Total duration: 6m33s - Times executed: 51 ]
[ Application: psql - Total duration: 6m33s - Times executed: 51 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030284);
Date: 2026-09-24 07:06:03 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030322);
Date: 2026-09-24 10:05:05 Duration: 30s788ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030337);
Date: 2026-09-24 13:56:16 Duration: 26s320ms Database: rio User: intelifix Remote: [local] Application: psql
14 156ms 3m6s 4s130ms 149 10m15s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 24 00 7 27s9ms 3s858ms 01 6 16s620ms 2s770ms 02 6 16s378ms 2s729ms 03 6 17s533ms 2s922ms 04 6 17s531ms 2s921ms 05 6 18s199ms 3s33ms 06 6 16s678ms 2s779ms 07 6 18s328ms 3s54ms 08 8 22s356ms 2s794ms 09 7 20s244ms 2s892ms 10 7 19s448ms 2s778ms 11 7 3m23s 29s90ms 12 6 17s655ms 2s942ms 13 6 17s895ms 2s982ms 14 7 20s763ms 2s966ms 15 7 19s664ms 2s809ms 16 7 17s752ms 2s536ms 17 6 17s779ms 2s963ms 18 7 17s113ms 2s444ms 19 6 16s948ms 2s824ms 20 7 21s535ms 3s76ms 21 6 17s210ms 2s868ms 22 6 17s223ms 2s870ms [ User: intelifix - Total duration: 10m15s - Times executed: 149 ]
[ Application: psql - Total duration: 10m15s - Times executed: 149 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 11:38:13 Duration: 3m6s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 00:05:33 Duration: 11s756ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-24 20:05:07 Duration: 5s661ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s254ms 25s855ms 3s57ms 111 5m39s create table temp0000292328 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 24 07 32 1m38s 3s85ms 08 21 51s462ms 2s450ms 09 11 28s414ms 2s583ms 10 11 28s625ms 2s602ms 11 10 26s624ms 2s662ms 12 5 13s207ms 2s641ms 14 9 36s793ms 4s88ms 15 4 12s5ms 3s1ms 16 8 43s520ms 5s440ms [ User: intelifix - Total duration: 5m39s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 5m39s - Times executed: 111 ]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 07:05:25 Duration: 25s855ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 16:12:58 Duration: 23s286ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292328 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"19-09-2026", "ate" :"24-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-24 14:56:54 Duration: 14s427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 170ms 19s845ms 2s530ms 164 6m55s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 24 00 6 30s684ms 5s114ms 01 6 19s82ms 3s180ms 02 5 12s380ms 2s476ms 03 5 16s707ms 3s341ms 04 6 16s544ms 2s757ms 05 3 4s838ms 1s612ms 06 4 5s775ms 1s443ms 07 11 28s974ms 2s634ms 08 12 25s569ms 2s130ms 09 12 43s321ms 3s610ms 10 11 23s234ms 2s112ms 11 13 35s431ms 2s725ms 12 13 17s693ms 1s361ms 13 7 7s730ms 1s104ms 14 12 26s528ms 2s210ms 15 12 43s642ms 3s636ms 16 10 35s869ms 3s586ms 17 3 4s23ms 1s341ms 20 1 498ms 498ms 21 6 7s30ms 1s171ms 22 6 9s495ms 1s582ms [ User: intelifix - Total duration: 6m55s - Times executed: 164 ]
[ Application: psql - Total duration: 6m55s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 00:05:21 Duration: 19s845ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 09:55:13 Duration: 11s610ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-24 16:25:10 Duration: 9s157ms Database: rio User: intelifix Remote: [local] Application: psql
17 566ms 26s80ms 1s610ms 58 1m33s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 24 08 4 5s112ms 1s278ms 09 4 4s377ms 1s94ms 10 3 2s30ms 676ms 11 3 3s429ms 1s143ms 12 4 4s622ms 1s155ms 13 3 5s963ms 1s987ms 14 4 9s594ms 2s398ms 15 3 2s340ms 780ms 16 4 7s343ms 1s835ms 17 5 7s430ms 1s486ms 18 5 29s108ms 5s821ms 19 4 2s742ms 685ms 20 4 2s951ms 737ms 21 4 3s366ms 841ms 22 4 2s986ms 746ms [ User: intelifix - Total duration: 1m33s - Times executed: 58 ]
[ Application: psql - Total duration: 1m33s - Times executed: 58 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-24 18:00:27 Duration: 26s80ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-24 14:20:09 Duration: 7s526ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-24 17:00:05 Duration: 4s297ms Database: rio User: intelifix Remote: [local] Application: psql
18 153ms 15s585ms 1s606ms 101 2m42s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 24 07 15 11s500ms 766ms 09 19 1m16s 4s48ms 10 9 5s153ms 572ms 11 8 5s554ms 694ms 13 8 4s739ms 592ms 14 9 11s180ms 1s242ms 15 29 45s298ms 1s562ms 17 4 1s909ms 477ms [ User: intelifix - Total duration: 2m42s - Times executed: 101 ]
[ Application: [unknown] - Total duration: 2m42s - Times executed: 101 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057787) LIMIT 1;
Date: 2026-09-24 09:22:50 Duration: 15s585ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-24 09:23:19 Duration: 13s205ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (057786) LIMIT 1;
Date: 2026-09-24 15:01:25 Duration: 12s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 5s795ms 740ms 913 11m15s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 24 07 11 6s515ms 592ms 08 100 1m30s 903ms 09 156 1m59s 763ms 10 147 1m34s 646ms 11 95 55s869ms 588ms 12 17 10s119ms 595ms 13 83 48s908ms 589ms 14 97 1m19s 817ms 15 83 1m15s 904ms 16 97 1m12s 742ms 17 27 23s435ms 867ms [ User: intelifix - Total duration: 11m15s - Times executed: 913 ]
[ Application: [unknown] - Total duration: 11m15s - Times executed: 913 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289640, 450, 'Z87325051014502,241738570814,241765391636,241776195978,241745806076,241817010714,241778845563$Z87325051023131,241739433737,241746406370,241759495560,241768999911,241764646377,241775609400,241812995271$Z87325051015422,241738662843,241779182847,241769933347', '',0464,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-24 13:48:33 Duration: 5s795ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289617, 450, 'CP2310324PH,D4925E34216C,544D42420065C3E6,D4925E34216F$CP233032EVC,D4925EE40F82,544D4242006E88E3,D4925EE40F85$CP23193220B,D4925E9FD1A7,544D424200699139,D4925E9FD1AA$CP234532GHC,08C7F5044B7D,544D42420073784A,08C7F5044B80$CP225032361,A0B53CF99F38,544D42420060B57E,A0B53CF99F3B$CP240932L1U,08C7F52E3E66,544D4242007854A3,08C7F52E3E69$CP23193222T,D4925E9FD489,544D42420069918B,D4925E9FD48C$CP2319328CM,D4925EA0C5A3,544D42420069AC55,D4925EA0C5A6$CP240932H9Y,08C7F52DD4EE,544D4242007848EB,08C7F52DD4F1$CP234332A11,D4925EFFC29C,544D42420072D3F1,D4925EFFC29F$CP234232T50,D4925EF98748,544D4242007254C5,D4925EF9874B$CP23453235W,08C7F5024C7E,544D424200733F83,08C7F5024C81$CP240332HNC,08C7F5237300,544D42420076EC85,08C7F5237303$CP230532928,D4925E19E56C,544D424200639DE7,D4925E19E56F$CP2404326CV,08C7F525E1A0,544D4242007731B1,08C7F525E1A3$CP230132UPU,D4925E05AECF,544D424200618A16,D4925E05AED0$CP234532FZ0,08C7F504362F,544D4242007375EC,08C7F5043632$CP240432644,08C7F525D777,544D424200773090,08C7F525D77A$CP233032FQ5,D4925EE42FD1,544D4242006E8C7A,D4925EE42FD4$CP234232Q1A,D4925EF91023,544D424200724788,D4925EF91026$CP2310322MA,D4925E33D225,544D42420065BB17,D4925E33D228$CP234532DQ2,08C7F503E067,544D424200736C64,08C7F503E06A$CP230132AFE,D4925E02F3DE,544D424200613C6D,D4925E02F3E1$CP230332835,D4925E14CB4F,544D42420062D5A8,D4925E14CB52$CP2319322CZ,D4925E9FE059,544D4242006992DB,D4925E9FE05C$CP2345324MS,08C7F5028533,544D4242007345D0,08C7F5028536$CP234332A0S,D4925EFFC254,544D42420072D3E9,D4925EFFC257$CP233032EQW,D4925EE40A4E,544D4242006E884F,D4925EE40A51$CP2319321MR,D4925E9FC481,544D424200698FC3,D4925E9FC484$CP2319328B3,D4925EA0C3D8,544D42420069AC22,D4925EA0C3DB$CP23453232T,08C7F50248E8,544D424200733F1D,08C7F50248EB$CP2305327TF,D4925E19B61A,544D4242006398A5,D4925E19B61D$CP240932END,08C7F52D7086,544D424200783DC3,08C7F52D7089$CP240932LZ1,08C7F52E616A,544D424200785887,08C7F52E616D$CP233032GMH,D4925EE452F9,544D4242006E9062,D4925EE452FC$CP2404325UD,08C7F525CD57,544D424200772F70,08C7F525CD5A$CP24073280B,08C7F52A5C68,544D42420077EF01,08C7F52A5C6B$CP232532JN6,D4925ECE5D55,544D4242006D62C3,D4925ECE5D58$CP23193222H,D4925E9FD42F,544D424200699181,D4925E9FD432$CP23033265L,D4925E148157,544D42420062CD70,D4925E14815A', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-24 08:12:27 Duration: 3s881ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (59268, 406, '835163924001093,241689191427,241618241315,241676792641,241708911320,241729506887,241708827596,241678478204,241676758091,241698680322,241704721214,241667599409,241695625062,241698662340,241676725361,241649470727,241631240014,241660125559,241593298701,241783829797,241639368910,241593430611,241712505576,241637719007,241704368800,241654365154,241708929806,241731761328,241594994848,241604320619,241598831127,241714938697,241663829501,241668298197,241708902127,241711223644,241671497488,241728534559,241732117074,241699887273,241604273543,241698702344,241666335862,241646433853,241726628491,241595788595,241695437692,241730908809,241704357687,241601128702,241708897580', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"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-09-24 17:24:48 Duration: 3s563ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 150ms 3s144ms 568ms 680 6m26s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 24 07 1 2s529ms 2s529ms 08 62 49s826ms 803ms 09 104 1m12s 692ms 10 106 51s421ms 485ms 11 80 37s609ms 470ms 12 17 6s708ms 394ms 13 74 47s1ms 635ms 14 65 32s122ms 494ms 15 90 52s12ms 577ms 16 49 22s879ms 466ms 17 32 12s744ms 398ms [ User: intelifix - Total duration: 6m26s - Times executed: 680 ]
[ Application: [unknown] - Total duration: 6m26s - Times executed: 680 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290361", "modelo" : "320", "itens" : "241601514654,241728644749,241695194459,241665791534,241694942841,241609930325,241669605968,241674242336,241673170728,241669615969,241694856872,241609943636,241622674250,241727965760,241602593940,241715733153,241617526082,241634980424,241615921515,241650561529,241649597988,241638359608,241639040719,241654315778,241629873449,241661460808,230047923341,241697051936,241597422235,241702162749,241653303749,241650558497,241691793050,241615187391,241675435976,241698701839,241667825671,241646511616,241658522328,241598749299,241674142629,241645494154,230039892434,241599480618,241638268184,241664957781,241628054966,241618881737", "usuario" : "414", "caixa" : "3707365", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 09:45:40 Duration: 3s144ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290363", "modelo" : "320", "itens" : "241727299398,241663162029,241604591734,241679397901,241714535673,241652280002,241673203435,241672329297,241637307395,241601583651,241651418996,241657962442,230049316978,241714579920,241649137786,241734186165,241700680416,241621279400,241629157385,241677667989,241662660409,241688821537,241655009415,241594041333,241604214345,241628213141,241616053447,241631504865,241627943642,241616075974,241607152040,241726910114,241596663642,241654949207,241627870729,241695180923,241677827073,241605412128,241654938296,241617822834,241622534360,241654917587,241694386568,241711227078,241710788090,241694382629,241697082141,241676458993", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 08:08:48 Duration: 2s616ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "290360", "modelo" : "320", "itens" : "241638391531,241679283344,241663020018,241645856164,241658525863,241618178199,241645860004,241712582834,241691750319,241595780919,241599472738,241664925455,241665219401,241616757084,241663176676,241593089612,241615186482,241593920210,230048078787,241674080121,241609233657,241630868709,241599412833,241658298691,241649620315,241706535779,241689863142,241674109820,241704745963,241672732222,241663207588,241706508099,241647646182,241628802626,241652112634,241615167793,241674104466,241615156984,241608843035,241658628702,241638302532,241650466670,241615164460,241638295561,241608841924,241593861214,241631454658,241674119797", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-24 07:58:00 Duration: 2s529ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 24 15 2 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 2s389ms - Times executed: 3 ]
[ User: etiquetas - Total duration: 224ms - Times executed: 1 ]
[ Application: psql - Total duration: 1s589ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 1s23ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 16,000 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 26 FATAL entries
- 3591 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,557 Max number of times the same event was reported
- 3,622 Total events found
Rank Times reported Error 1 3,557 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 24 00 59 01 60 02 60 03 55 04 60 05 59 06 70 07 156 08 259 09 329 10 375 11 373 12 116 13 179 14 272 15 314 16 247 17 167 18 59 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029AE5A00" does not exist
- ERROR: prepared statement "_PLAN0000000029BE0DD0" does not exist
- ERROR: prepared statement "_PLAN0000000029BDE4C0" does not exist
Statement: DEALLOCATE "_PLAN0000000029AE5A00"
Date: 2026-09-24 00:00:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029BE0DD0"
Date: 2026-09-24 00:01:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029BDE4C0"
Date: 2026-09-24 00:02:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 14 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 24 00 1 02 5 03 2 06 2 10 2 13 1 16 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-24 00:02:29 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-24 02:16:15 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-24 02:16:30 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 12 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 24 09 2 10 3 11 3 13 2 17 2 - ERROR: trailing junk after numeric literal at or near "38A65921C2AE" at character 27
- ERROR: trailing junk after numeric literal at or near "38A65921C2AE" at character 27
- ERROR: trailing junk after numeric literal at or near "2B" at character 39
Statement: select * from rs_caixa_qr(38A65921C2AE)
Date: 2026-09-24 09:50:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(38A65921C2AE)
Date: 2026-09-24 09:50:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-99-2B-E1)
Date: 2026-09-24 10:18:43 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 24 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-24 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-24 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 24 09 4 10 3 14 2 - ERROR: syntax error at or near "140456" at character 37
- ERROR: syntax error at or near "140456" at character 37
- ERROR: syntax error at or near "140456" at character 37
Statement: select * from rs_caixa_qr(->> Caixa 140456)
Date: 2026-09-24 09:21:17 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(->> Caixa 140456)
Date: 2026-09-24 09:21:17 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(->> Caixa 140456)
Date: 2026-09-24 09:21:21 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
6 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 24 05 4 09 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-24 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-24 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-24 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
7 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 24 07 1 15 3 - ERROR: column "controle" does not exist at character 36
- ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: SELECT * FROM temp0000240810 WHERE CONTROLE='L'
Date: 2026-09-24 07:55:53 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-09-24 15:04:34 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-09-24 15:04:34 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 24 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-24 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-24 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-24 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 24 11 2 - LOG: process 2045377 still waiting for ShareLock on transaction 6701825 after 1000.116 ms
- LOG: process 2045377 still waiting for ShareLock on transaction 6701825 after 7071.727 ms
Detail: Process holding the lock: 2016716. Wait queue: 2045377.
Context: while updating tuple (18716,61) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-24 11:35:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2016716. Wait queue: 2045377.
Context: while updating tuple (18716,61) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-24 11:35:16 Database: rio Application: psql User: intelifix Remote: [local]
10 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 24 08 2 - 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-09-24 08:45:29 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-24 08:45:30 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 1 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 24 11 1 - ERROR: process 2016716 detected deadlock while waiting for ShareLock on transaction 6702217 after 1000.222 ms
Detail: Process holding the lock: 2045377. Wait queue: .
Context: while updating tuple (80788,32) 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,character varying,integer) line 1028 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 030328, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-09-24 11:35:11 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 24 03 1 - LOG: database system was shut down at 2026-09-24 03:05:02 -03
Date: 2026-09-24 03:05:02
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 24 08 1 - LOG: process 1850987 still waiting for AccessExclusiveLock on relation 5361133 of database 358220 after 1000.068 ms
Detail: Process holding the lock: 1886758. Wait queue: 1850987.
Statement: DROP TABLE IF EXISTS temp0000292328;Date: 2026-09-24 08:45:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 24 08 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000292328"
Date: 2026-09-24 08:45:37
15 1 ERROR: prepared statement "..." does not existNOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 24 15 1 - ERROR: prepared statement "_PLAN000000003FB0FF00" does not existNOTICE: table "tmp_entrada" does not exist, skipping
Statement: DEALLOCATE "_PLAN000000003FB0FF00"
Date: 2026-09-24 15:14:58 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]