pgBadger-
Global information
- Generated on Mon Sep 28 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 34,781 log entries in 10s
- Log start from 2026-09-28 00:00:55 to 2026-09-28 23:49:48
-
Overview
Global Stats
- 389 Number of unique normalized queries
- 4,543 Number of queries
- 6h24m58s Total query duration
- 2026-09-28 00:02:24 First query
- 2026-09-28 23:45:03 Last query
- 6 queries/s at 2026-09-28 08:33:12 Query peak
- 6h24m58s Total query duration
- 341ms Prepare/parse total duration
- 0ms Bind total duration
- 6h24m58s Execute total duration
- 3,666 Number of events
- 12 Number of unique normalized events
- 3,626 Max number of times the same event was reported
- 0 Number of cancellation
- 374 Total number of automatic vacuums
- 801 Total number of automatic analyzes
- 20 Number temporary file
- 247.60 MiB Max size of temporary file
- 67.39 MiB Average size of temporary file
- 337 Total number of sessions
- 7 sessions at 2026-09-28 01:03:17 Session peak
- 12d46m55s Total duration of sessions
- 51m24s Average duration of sessions
- 13 Average queries per session
- 1m8s Average queries duration per session
- 50m16s Average idle time per session
- 345 Total number of connections
- 4 connections/s at 2026-09-28 14:45:09 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-28 08:33:12 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-28 08:33:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-28 23:42:24 Date
Queries duration
Key values
- 6h24m58s 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 28 00 17 0ms 21s29ms 5s634ms 3s52ms 3s332ms 51s424ms 01 6 0ms 3s394ms 3s207ms 3s62ms 3s229ms 3s394ms 02 6 0ms 3s401ms 3s101ms 3s17ms 3s32ms 3s401ms 03 5 0ms 3s335ms 3s100ms 0ms 2s959ms 3s335ms 04 6 0ms 3s507ms 3s247ms 3s47ms 3s315ms 3s507ms 05 13 0ms 11m28s 1m52s 6s108ms 3m3s 11m28s 06 22 0ms 38s38ms 5s580ms 6s812ms 22s255ms 39s800ms 07 79 0ms 10m45s 15s394ms 22s243ms 1m58s 10m49s 08 397 0ms 5m9s 3s968ms 1m 3m23s 5m57s 09 440 150ms 7m54s 2s787ms 34s254ms 54s696ms 7m58s 10 468 150ms 6m33s 2s936ms 27s655ms 3m17s 6m50s 11 354 150ms 5m37s 2s661ms 17s282ms 50s452ms 5m41s 12 230 0ms 6m53s 6s605ms 35s347ms 3m28s 6m56s 13 241 0ms 5m13s 3s821ms 18s523ms 1m8s 5m44s 14 460 150ms 8m17s 4s215ms 59s370ms 3m34s 8m50s 15 556 150ms 7m24s 4s456ms 1m27s 4m12s 7m41s 16 421 150ms 5m43s 3s998ms 53s138ms 2m5s 6m41s 17 268 0ms 5m37s 3s769ms 20s931ms 57s31ms 6m13s 18 31 0ms 5m7s 19s560ms 3s104ms 18s746ms 5m52s 19 18 0ms 5m 31s514ms 3s 3s406ms 5m43s 20 116 0ms 5m13s 9s873ms 1m3s 1m12s 6m44s 21 30 0ms 5m2s 19s634ms 5s133ms 7s659ms 5m47s 22 24 0ms 5m3s 24s758ms 4s651ms 5s711ms 5m47s 23 335 0ms 1m2s 5s842ms 1m5s 1m7s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 00 3 0 9s586ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 7 0 4s321ms 0ms 0ms 1s761ms 07 57 0 19s914ms 3s546ms 8s426ms 4m12s 08 323 0 3s852ms 18s235ms 32s950ms 4m22s 09 380 0 2s794ms 5s591ms 11s196ms 3m48s 10 413 0 2s675ms 7s211ms 17s82ms 3m49s 11 310 0 2s577ms 5s569ms 9s697ms 3m30s 12 138 0 8s289ms 3s502ms 9s675ms 5m54s 13 191 0 4s38ms 4s733ms 7s610ms 3m28s 14 366 0 4s350ms 17s799ms 32s127ms 6m4s 15 407 0 4s107ms 12s570ms 1m1s 5m52s 16 298 0 3s992ms 12s912ms 37s838ms 3m40s 17 227 0 3s948ms 18s400ms 20s931ms 3m29s 18 19 0 29s824ms 0ms 1s379ms 3m23s 19 6 0 1m30s 0ms 0ms 3m20s 20 19 80 11s237ms 21s529ms 1m1s 3m22s 21 13 0 42s437ms 0ms 0ms 3m22s 22 6 0 1m33s 0ms 0ms 3m32s 23 15 320 5s842ms 1m2s 1m5s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 28 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 28 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 6 6.00 0.00% 08 0 17 17.00 0.00% 09 0 13 13.00 0.00% 10 0 13 13.00 0.00% 11 0 12 12.00 0.00% 12 1 13 13.00 0.49% 13 0 10 10.00 0.00% 14 0 14 14.00 0.00% 15 1 13 13.00 0.19% 16 0 12 12.00 0.00% 17 0 5 5.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Sep 28 00 14 0.00/s 01 6 0.00/s 02 6 0.00/s 03 15 0.00/s 04 8 0.00/s 05 10 0.00/s 06 12 0.00/s 07 13 0.00/s 08 34 0.01/s 09 26 0.01/s 10 23 0.01/s 11 14 0.00/s 12 17 0.00/s 13 20 0.01/s 14 18 0.01/s 15 20 0.01/s 16 16 0.00/s 17 12 0.00/s 18 11 0.00/s 19 8 0.00/s 20 13 0.00/s 21 8 0.00/s 22 7 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Sep 28 00 8 1h45s 1h33s 01 13 1h55s 1h54s 02 6 1h40s 1h37s 03 13 11m33s 11m32s 04 7 1h1m51s 1h1m48s 05 8 1h45s 57m42s 06 9 57m34s 57m21s 07 12 57m29s 55m47s 08 25 31m30s 30m27s 09 26 46m18s 45m31s 10 24 53m6s 52m9s 11 20 56m22s 55m35s 12 14 53m40s 51m51s 13 18 52m36s 51m45s 14 17 59m1s 57m7s 15 21 53m41s 51m43s 16 17 56m36s 54m57s 17 14 1h31s 59m19s 18 13 1h16s 59m29s 19 12 56m2s 55m15s 20 10 43m27s 41m32s 21 9 1h54s 59m48s 22 9 1h20s 59m14s 23 12 32m43s 30m -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-28 14:45:09 Date
Connections per database
Key values
- rio Main Database
- 345 connections Total
Connections per user
Key values
- intelifix Main User
- 345 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-28 01:03:17 Date
Histogram of session times
Key values
- 266 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 337 sessions Total
Sessions per user
Key values
- intelifix Main User
- 337 sessions Total
Sessions per host
Key values
- [local] Main Host
- 337 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 20,661 buffers Checkpoint Peak
- 2026-09-28 10:04:41 Date
- 270.055 seconds Highest write time
- 0.118 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-09-28 15:29:41 Date
Checkpoints distance
Key values
- 462.39 Mo Distance Peak
- 2026-09-28 15:29:41 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 28 00 18,264 539.843s 0.009s 539.873s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.018s 0.003s 0.058s 04 0 0s 0s 0s 05 7,316 732.786s 0.085s 732.912s 06 5,778 515.239s 0.135s 515.399s 07 6,016 606.29s 0.181s 606.572s 08 48,902 2,819.549s 0.319s 2,820.071s 09 58,237 3,177.221s 0.289s 3,177.656s 10 84,552 3,239.207s 0.474s 3,239.792s 11 44,524 3,202.356s 0.186s 3,202.619s 12 33,442 2,336.203s 0.085s 2,336.412s 13 23,269 1,947.018s 0.289s 1,947.423s 14 32,333 3,116.94s 0.289s 3,117.312s 15 59,407 3,220.119s 0.393s 3,220.68s 16 37,303 3,096.272s 0.166s 3,096.541s 17 16,708 1,793.194s 0.076s 1,793.324s 18 2,979 299.029s 0.018s 299.068s 19 26 2.619s 0.003s 2.628s 20 1,126 116.455s 0.009s 116.469s 21 2,806 281.091s 0.02s 281.138s 22 2,047 205.121s 0.016s 205.158s 23 424 42.538s 0.011s 42.569s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 28 00 0 0 6 126 0.007s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.002s 0.001s 04 0 0 0 0 0s 0s 05 0 0 3 166 0.062s 0.01s 06 0 0 1 347 0.063s 0.006s 07 0 0 2 1,226 0.061s 0.014s 08 0 0 27 5,551 0.065s 0.012s 09 0 0 21 6,848 0.017s 0.012s 10 0 0 38 7,230 0.059s 0.012s 11 0 0 18 5,894 0.010s 0.012s 12 0 0 31 3,541 0.011s 0.012s 13 0 0 11 3,970 0.063s 0.012s 14 0 0 25 5,149 0.063s 0.012s 15 0 0 67 6,205 0.026s 0.012s 16 0 0 43 5,343 0.014s 0.012s 17 0 0 15 3,993 0.003s 0.012s 18 0 0 1 418 0.002s 0.008s 19 0 0 0 5 0.001s 0.002s 20 0 0 0 80 0.002s 0.003s 21 0 0 1 444 0.003s 0.008s 22 0 0 1 479 0.002s 0.007s 23 0 0 0 100 0.002s 0.008s Day Hour Count Avg time (sec) Sep 28 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 28 00 50,172.50 kB 73,828.50 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 32,040.00 kB 04 0.00 kB 0.00 kB 05 5,690.25 kB 9,883.38 kB 06 3,403.17 kB 8,652.50 kB 07 2,558.25 kB 5,433.08 kB 08 37,080.33 kB 68,612.08 kB 09 28,323.75 kB 63,427.25 kB 10 51,332.42 kB 100,009.25 kB 11 24,770.67 kB 53,786.92 kB 12 42,536.08 kB 61,802.50 kB 13 14,575.33 kB 64,472.25 kB 14 35,088.42 kB 52,561.42 kB 15 91,181.58 kB 164,119.58 kB 16 58,325.67 kB 110,814.58 kB 17 20,266.25 kB 58,947.67 kB 18 1,867.12 kB 24,023.62 kB 19 96.00 kB 14,055.00 kB 20 3,949.33 kB 11,776.33 kB 21 1,517.12 kB 7,308.50 kB 22 1,444.29 kB 4,157.43 kB 23 184.00 kB 2,357.43 kB -
Temporary Files
Size of temporary files
Key values
- 495.20 MiB Temp Files size Peak
- 2026-09-28 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-28 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.32 GiB 67.39 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.02 GiB 36.92 MiB 247.60 MiB 64.99 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-28 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-28 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 307.90 MiB 57.22 MiB 94.17 MiB 76.98 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-28 05:30:42 Duration: 39s629ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-28 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 247.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 247.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-28 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.17 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-28 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-28 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.22 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-28 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.00 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.93 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-28 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.54 sec Highest CPU-cost vacuum
Table pg_catalog.pg_attribute
Database contagem - 2026-09-28 08:22:52 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 0.54 sec Highest CPU-cost vacuum
Table pg_catalog.pg_attribute
Database contagem - 2026-09-28 08:22:52 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (121) Main table analyzed (database rio)
- 801 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 121 rio.pg_catalog.pg_class 61 rio.pg_catalog.pg_type 53 rio.public.usuarios 45 rio.public.temp0000292678 41 brasilia.pg_catalog.pg_attribute 36 rio.pg_catalog.pg_index 35 rio.public.temp0000292712 31 rio.public.temp0000292636 31 rio.pg_catalog.pg_depend 26 rio.public.temp0000292626 23 brasilia.public.temp0000241022 18 rio.public.temp0000292652 16 rio.public.temp0000292614 16 contagem.pg_catalog.pg_attribute 16 brasilia.pg_catalog.pg_class 16 contagem.public.usuarios 14 brasilia.pg_catalog.pg_type 13 rio.public.temp0000292696 12 rio.public.temp0000292734 10 contagem.public.temp0000227316 9 rio.public.temp0000292616 9 brasilia.pg_catalog.pg_index 8 contagem.pg_catalog.pg_class 8 rio.public.temp0000292632 8 brasilia.public.usuarios 7 contagem.pg_catalog.pg_type 7 rio.public.temp0000290230 7 rio.public.temp0000292698 6 contagem.public.temp0000227268 6 brasilia.public.temp0000241068 5 brasilia.pg_catalog.pg_depend 5 postgres.pg_catalog.pg_shdepend 4 contagem.pg_catalog.pg_index 4 rio.public.temp0000292686 3 contagem.public.temp0000227320 3 brasilia.public.temp0000241010 3 contagem.pg_catalog.pg_depend 3 rio.public.tmp_drill_0302 3 rio.public.temp0000292680 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000292714 3 rio.public.temp0000292640 3 brasilia.public.temp0000241012 3 brasilia.public.temp0000241014 2 brasilia.public.temp0000241060 2 rio.public.temp0000292628 2 brasilia.public.temp0000241056 2 brasilia.public.temp0000241088 2 brasilia.public.temp0000241050 2 rio.public.temp0000292620 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000292670 2 brasilia.public.temp0000241074 2 contagem.public.temp0000227324 2 brasilia.public.temp0000241026 1 brasilia.public.temp0000241064 1 rio.public.temp0000292630 1 rio.public.temp0000292726 1 rio.public.temp0000292604 1 brasilia.public.temp0000241008 1 rio.pg_catalog.pg_shdepend 1 brasilia.public.temp0000241028 1 brasilia.public.temp0000241046 1 rio.public.temp0000292690 1 brasilia.public.temp0000241102 1 brasilia.public.temp0000241040 1 rio.public.temp0000292646 1 rio.public.temp0000292700 1 rio.public.temp0000292660 1 rio.public.temp0000292722 1 brasilia.public.temp0000241016 1 contagem.public.nf_entrada 1 brasilia.public.temp0000241080 1 brasilia.public.temp0000241054 1 rio.public.temp0000292692 1 brasilia.public.temp0000241100 1 Total 801 Vacuums per table
Key values
- pg_catalog.pg_attribute (43) Main table vacuumed on database rio
- 374 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 43 42 0 0 0 0 0 22,845 6,130 9,146,547 286 7,454 rio.public.temp0000292678 42 0 0 0 0 0 0 13,813 2,472 4,024,603 0 0 rio.public.temp0000292636 26 0 0 0 0 0 0 12,401 2,129 3,420,845 0 0 rio.pg_catalog.pg_class 25 24 0 0 0 0 0 4,902 1,530 2,332,560 77 320 rio.public.temp0000292626 23 0 0 0 0 0 0 29,335 3,742 6,475,850 0 0 rio.pg_catalog.pg_type 22 21 0 0 0 0 0 2,037 581 883,088 44 151 rio.public.temp0000292712 17 0 0 0 0 0 0 5,871 221 620,721 0 0 contagem.public.usuarios 14 0 0 0 0 0 0 62 47 25,613 1 1 rio.pg_catalog.pg_index 14 14 0 0 0 0 0 735 216 234,801 37 94 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,176 1,423 2,259,308 53 606 rio.public.temp0000292614 11 0 0 0 0 0 0 541 63 40,814 0 0 brasilia.pg_catalog.pg_attribute 10 10 0 0 0 0 0 4,691 1,534 2,371,809 68 1,820 rio.public.usuarios 9 3 0 0 0 0 0 104 47 102,757 19 41 contagem.pg_catalog.pg_attribute 7 7 0 0 0 0 0 4,034 989 1,797,125 12 386 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,885 2,092 9,295,835 1,124 5,323 rio.public.temp0000292616 5 0 0 0 0 0 0 316 91 131,400 0 0 rio.public.temp0000290230 5 0 0 0 0 0 0 309 148 226,368 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 721 103 184,377 4 12 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 383 71 123,423 2 4 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 650 232 396,095 17 54 rio.public.tmp_drill_0302 4 2 0 0 0 0 0 70 27 38,577 1 47 rio.public.temp0000292714 3 0 0 0 0 0 0 16 11 2,852 0 0 brasilia.pg_catalog.pg_type 3 3 0 0 0 0 0 236 88 133,849 9 50 brasilia.public.temp0000241012 3 0 0 0 0 0 0 768 12 47,121 0 0 rio.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 572 200 362,280 31 62 contagem.public.temp0000227320 3 0 0 0 0 0 0 351 18 23,632 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,701 400 2,268,075 134 407 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 911 256 507,082 5 38 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 186 64 59,297 1 1 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 594 227 382,143 13 29 rio.public.temp0000292620 2 0 0 0 0 0 0 150 87 158,987 0 0 contagem.public.temp0000227324 2 0 0 0 0 0 0 234 12 15,754 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,259 442 1,945,986 347 2,489 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 311 72 325,662 30 71 brasilia.public.temp0000241056 2 0 0 0 0 0 0 512 8 31,414 0 0 rio.public.temp0000292628 2 0 0 0 0 0 0 1,841 9 110,013 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 133 41 27,515 6 13 rio.public.temp0000292698 2 0 0 0 0 0 0 1,917 10 114,618 0 0 rio.public.temp0000292652 2 0 0 0 0 0 0 80 12 6,335 0 0 rio.public.temp0000292640 1 0 0 0 0 0 0 66 4 4,497 0 0 brasilia.public.temp0000241022 1 0 0 0 0 0 0 256 4 15,707 0 0 brasilia.public.temp0000241016 1 0 0 0 0 0 0 256 4 15,707 0 0 rio.public.temp0000292722 1 0 0 0 0 0 0 89 6 6,171 0 0 rio.public.temp0000292670 1 0 0 0 0 0 0 83 6 5,806 0 0 rio.public.temp0000292646 1 0 0 0 0 0 0 68 4 4,615 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 128 8 42,107 2 4 brasilia.public.temp0000241074 1 0 0 0 0 0 0 256 4 15,707 0 0 contagem.public.temp0000227268 1 0 0 0 0 0 0 117 115 193,319 0 0 brasilia.public.temp0000241080 1 0 0 0 0 0 0 256 4 15,707 0 0 rio.public.temp0000292692 1 0 0 0 0 0 0 84 6 5,863 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,106 8 165,843 3 31 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 234 76 117,672 5 48 brasilia.public.temp0000241008 1 0 0 0 0 0 0 256 4 15,707 0 0 rio.public.temp0000292630 1 0 0 0 0 0 0 67 6 4,826 0 0 brasilia.public.temp0000241064 1 0 0 0 0 0 0 256 4 15,707 0 0 rio.public.temp0000292726 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000292690 1 0 0 0 0 0 0 84 6 5,863 0 0 brasilia.public.temp0000241088 1 0 0 0 0 0 0 256 4 15,707 0 0 rio.public.temp0000292734 1 0 0 0 0 0 0 80 6 5,605 0 0 Total 374 182 0 0 0 0 0 135,655 26,139 51,328,041 2,331 19,556 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (3.34) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.34 rio.public.temp0000292678 0 0 0.48 rio.public.temp0000292636 0 0 0.36 rio.pg_catalog.pg_class 0 0 0.69 rio.public.temp0000292626 0 0 1.01 rio.pg_catalog.pg_type 0 0 0.34 rio.public.temp0000292712 0 0 0.35 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_index 0 0 0.23 rio.pg_catalog.pg_depend 0 0 0.91 rio.public.temp0000292614 0 0 0.01 brasilia.pg_catalog.pg_attribute 0 0 1.19 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.93 rio.pg_catalog.pg_statistic 0 0 1.7 rio.public.temp0000292616 0 0 0.01 rio.public.temp0000290230 0 0 0 contagem.pg_catalog.pg_class 0 0 0.3 contagem.pg_catalog.pg_type 0 0 0.21 brasilia.pg_catalog.pg_class 0 0 0.7 rio.public.tmp_drill_0302 0 0 0.01 rio.public.temp0000292714 0 0 0.08 brasilia.pg_catalog.pg_type 0 0 0.32 brasilia.public.temp0000241012 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0.08 contagem.public.temp0000227320 0 0 0.01 rio.pg_toast.pg_toast_2619 0 0 0.27 contagem.pg_catalog.pg_depend 0 0 1.09 contagem.pg_catalog.pg_index 0 0 0.45 postgres.pg_catalog.pg_shdepend 0 0 0.35 rio.public.temp0000292620 0 0 0.01 contagem.public.temp0000227324 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.38 brasilia.pg_toast.pg_toast_2619 0 0 0.09 brasilia.public.temp0000241056 0 0 0 rio.public.temp0000292628 0 0 0.04 brasilia.pg_catalog.pg_index 0 0 0.21 rio.public.temp0000292698 0 0 0.04 rio.public.temp0000292652 0 0 0.01 rio.public.temp0000292640 0 0 0 brasilia.public.temp0000241022 0 0 0 brasilia.public.temp0000241016 0 0 0 rio.public.temp0000292722 0 0 0.01 rio.public.temp0000292670 0 0 0 rio.public.temp0000292646 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000241074 0 0 0 contagem.public.temp0000227268 0 0 0.01 brasilia.public.temp0000241080 0 0 0 rio.public.temp0000292692 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.08 brasilia.pg_catalog.pg_depend 0 0 0.51 brasilia.public.temp0000241008 0 0 0 rio.public.temp0000292630 0 0 0 brasilia.public.temp0000241064 0 0 0 rio.public.temp0000292726 0 0 0.04 rio.public.temp0000292690 0 0 0.01 brasilia.public.temp0000241088 0 0 0.06 rio.public.temp0000292734 0 0 0 Total 0 0 16.92 Tuples removed per table
Key values
- pg_catalog.pg_attribute (155010) Main table with removed tuples on database rio
- 277384 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 43 42 155,010 1,076,580 29,201 309 26,738 brasilia.pg_catalog.pg_attribute 10 10 33,453 220,947 0 0 5,547 contagem.pg_catalog.pg_attribute 7 7 29,537 173,057 7,553 303 3,887 rio.pg_catalog.pg_statistic 7 7 12,826 56,740 0 0 9,002 rio.pg_catalog.pg_type 22 21 7,625 52,194 2,310 16 1,629 rio.pg_catalog.pg_depend 13 13 7,388 248,523 2,750 0 2,431 brasilia.pg_catalog.pg_statistic 2 2 4,900 15,218 0 0 2,144 contagem.pg_catalog.pg_statistic 1 1 4,302 7,274 0 0 1,011 postgres.pg_catalog.pg_shdepend 3 3 3,404 41,125 458 0 375 rio.pg_catalog.pg_shdepend 3 3 3,334 40,822 5 0 375 rio.pg_catalog.pg_class 25 24 3,110 100,924 5,633 23 3,552 rio.pg_catalog.pg_index 14 14 2,476 27,257 450 8 762 contagem.pg_catalog.pg_type 4 4 1,703 9,456 728 26 266 contagem.pg_catalog.pg_depend 3 3 1,051 57,974 2,360 14 523 rio.pg_toast.pg_toast_2619 3 3 963 1,960 0 0 789 brasilia.pg_catalog.pg_depend 1 1 947 18,077 0 0 176 contagem.pg_catalog.pg_index 3 3 936 5,690 0 8 155 brasilia.pg_catalog.pg_class 4 4 827 13,553 0 0 520 contagem.public.usuarios 14 0 816 336 0 0 28 rio.public.usuarios 9 3 750 5,722 1,141 0 171 brasilia.pg_catalog.pg_type 3 3 594 6,667 0 0 181 brasilia.pg_catalog.pg_index 2 2 523 3,763 0 0 114 rio.public.tmp_drill_0302 4 2 333 44,401 21,820 0 571 contagem.pg_catalog.pg_class 4 4 296 15,629 1,783 30 549 brasilia.pg_toast.pg_toast_2619 2 2 178 279 2 0 120 contagem.pg_toast.pg_toast_2619 1 1 102 112 0 0 51 rio.public.temp0000292616 5 0 0 12,412 0 102 282 rio.public.temp0000292714 3 0 0 53,360 0 50 3,790 rio.public.temp0000292640 1 0 0 1,120 0 0 64 brasilia.public.temp0000241022 1 0 0 3,355 0 0 256 brasilia.public.temp0000241016 1 0 0 3,355 0 0 256 rio.public.temp0000292722 1 0 0 1,423 0 47 81 rio.public.temp0000292670 1 0 0 1,369 0 53 75 rio.public.temp0000292646 1 0 0 1,172 0 0 64 rio.public.temp0000292620 2 0 0 2,405 0 58 134 rio.public.temp0000292614 11 0 0 21,706 0 279 489 contagem.public.temp0000227324 2 0 0 2,794 0 38 218 rio.public.temp0000290230 5 0 0 12,108 0 78 274 brasilia.public.temp0000241074 1 0 0 3,356 0 0 256 contagem.public.temp0000227268 1 0 0 1,396 0 19 109 brasilia.public.temp0000241080 1 0 0 3,356 0 0 256 brasilia.public.temp0000241012 3 0 0 10,065 0 0 768 rio.public.temp0000292692 1 0 0 1,381 0 52 76 rio.public.temp0000292636 26 0 0 222,910 0 807 14,361 rio.public.temp0000292678 42 0 0 233,117 0 1,630 15,778 brasilia.public.temp0000241008 1 0 0 3,355 0 0 256 rio.public.temp0000292630 1 0 0 1,035 0 5 59 brasilia.public.temp0000241064 1 0 0 3,356 0 0 256 contagem.public.temp0000227320 3 0 0 4,188 0 57 327 rio.public.temp0000292726 1 0 0 25,989 0 0 1,856 rio.public.temp0000292626 23 0 0 597,489 0 0 42,688 brasilia.public.temp0000241056 2 0 0 6,711 0 0 512 rio.public.temp0000292690 1 0 0 1,381 0 52 76 rio.public.temp0000292628 2 0 0 27,036 0 5 1,915 brasilia.public.temp0000241088 1 0 0 3,356 0 0 256 rio.public.temp0000292712 17 0 0 175,855 0 373 11,915 rio.public.temp0000292698 2 0 0 27,366 0 51 1,933 rio.public.temp0000292652 2 0 0 2,865 0 32 64 rio.public.temp0000292734 1 0 0 3,193 0 56 72 Total 374 182 277,384 3,719,615 76,194 4,581 161,439 Pages removed per table
Key values
- public.temp0000292678 (1630) Main table with removed pages on database rio
- 4581 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000292678 42 0 0 1630 rio.public.temp0000292636 26 0 0 807 rio.public.temp0000292712 17 0 0 373 rio.pg_catalog.pg_attribute 43 42 155010 309 contagem.pg_catalog.pg_attribute 7 7 29537 303 rio.public.temp0000292614 11 0 0 279 rio.public.temp0000292616 5 0 0 102 rio.public.temp0000290230 5 0 0 78 rio.public.temp0000292620 2 0 0 58 contagem.public.temp0000227320 3 0 0 57 rio.public.temp0000292734 1 0 0 56 rio.public.temp0000292670 1 0 0 53 rio.public.temp0000292692 1 0 0 52 rio.public.temp0000292690 1 0 0 52 rio.public.temp0000292698 2 0 0 51 rio.public.temp0000292714 3 0 0 50 rio.public.temp0000292722 1 0 0 47 contagem.public.temp0000227324 2 0 0 38 rio.public.temp0000292652 2 0 0 32 contagem.pg_catalog.pg_class 4 4 296 30 contagem.pg_catalog.pg_type 4 4 1703 26 rio.pg_catalog.pg_class 25 24 3110 23 contagem.public.temp0000227268 1 0 0 19 rio.pg_catalog.pg_type 22 21 7625 16 contagem.pg_catalog.pg_depend 3 3 1051 14 rio.pg_catalog.pg_index 14 14 2476 8 contagem.pg_catalog.pg_index 3 3 936 8 rio.public.temp0000292630 1 0 0 5 rio.public.temp0000292628 2 0 0 5 brasilia.pg_catalog.pg_attribute 10 10 33453 0 rio.public.temp0000292640 1 0 0 0 brasilia.public.temp0000241022 1 0 0 0 brasilia.public.temp0000241016 1 0 0 0 rio.public.temp0000292646 1 0 0 0 contagem.public.usuarios 14 0 816 0 contagem.pg_toast.pg_toast_2619 1 1 102 0 brasilia.pg_catalog.pg_class 4 4 827 0 brasilia.pg_catalog.pg_type 3 3 594 0 brasilia.public.temp0000241074 1 0 0 0 rio.public.usuarios 9 3 750 0 brasilia.public.temp0000241080 1 0 0 0 brasilia.public.temp0000241012 3 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4302 0 brasilia.pg_catalog.pg_depend 1 1 947 0 brasilia.pg_catalog.pg_statistic 2 2 4900 0 brasilia.pg_toast.pg_toast_2619 2 2 178 0 brasilia.public.temp0000241008 1 0 0 0 rio.pg_catalog.pg_shdepend 3 3 3334 0 brasilia.public.temp0000241064 1 0 0 0 rio.public.temp0000292726 1 0 0 0 rio.public.temp0000292626 23 0 0 0 rio.pg_toast.pg_toast_2619 3 3 963 0 brasilia.public.temp0000241056 2 0 0 0 rio.public.tmp_drill_0302 4 2 333 0 brasilia.pg_catalog.pg_index 2 2 523 0 rio.pg_catalog.pg_depend 13 13 7388 0 brasilia.public.temp0000241088 1 0 0 0 rio.pg_catalog.pg_statistic 7 7 12826 0 postgres.pg_catalog.pg_shdepend 3 3 3404 0 Total 374 182 277,384 4,581 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 28 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 1 07 3 9 08 55 90 09 20 76 10 47 103 11 23 65 12 22 39 13 20 45 14 32 82 15 66 118 16 62 119 17 16 51 18 0 0 19 0 0 20 0 0 21 2 3 22 0 0 23 0 0 - 0.54 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000292678;-
DROP TABLE IF EXISTS temp0000292678;
Date: 2026-09-28 12:28:41 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000292678;
Date: 2026-09-28 15:58:13 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000292678;
Date: 2026-09-28 12:28:41 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s1ms DROP TABLE IF EXISTS temp0000292678;[ Date: 2026-09-28 12:28:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,198 Total read queries
- 975 Total write queries
Queries by database
Key values
- rio Main database
- 2,952 Requests
- 4h39m16s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,399 Requests
User Request type Count Duration etiquetas Total 54 15s522ms select 54 15s522ms intelifix Total 4,399 6h23m18s copy to 400 41m37s ddl 575 42m12s others 370 43m23s select 3,054 4h16m4s lenon Total 90 1m24s select 90 1m24s Duration by user
Key values
- 6h23m18s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 54 15s522ms select 54 15s522ms intelifix Total 4,399 6h23m18s copy to 400 41m37s ddl 575 42m12s others 370 43m23s select 3,054 4h16m4s lenon Total 90 1m24s select 90 1m24s Queries by host
Key values
- [local] Main host
- 4,543 Requests
- 6h24m58s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,562 Requests
- 3h42m10s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-28 15:56:49 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,002 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m28s analyze verbose;[ Date: 2026-09-28 05:11:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 07:15:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m17s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-28 14:59:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 7m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 09:12:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-28 15:45:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 7m23s analyze verbose;[ Date: 2026-09-28 05:18:54 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
7 6m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030487, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-28 12:23:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 10:11:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 15:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 16:10:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 17:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 11:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 14:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 12:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 13:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 20:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 08:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 18:10:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 22:10:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-28 21:10:04 - 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 1h40m38s 48 2s183ms 10m45s 2m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 28 07 3 11m44s 3m54s 08 3 5m28s 1m49s 09 3 8m24s 2m48s 10 3 6m57s 2m19s 11 3 5m58s 1m59s 12 3 5m42s 1m54s 13 3 5m35s 1m51s 14 3 5m46s 1m55s 15 3 6m5s 2m1s 16 3 6m3s 2m1s 17 3 5m55s 1m58s 18 3 5m25s 1m48s 19 3 5m17s 1m45s 20 3 5m31s 1m50s 21 3 5m20s 1m46s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h40m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h40m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 07:15:46 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 09:12:56 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 10:11:34 Duration: 6m33s Database: rio User: intelifix Remote: [local] Application: psql
2 1h5m26s 48 212ms 3m57s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 28 07 3 5m57s 1m59s 08 3 3m50s 1m16s 09 3 4m9s 1m23s 10 3 4m19s 1m26s 11 3 3m55s 1m18s 12 3 3m53s 1m17s 13 3 3m54s 1m18s 14 3 4m 1m20s 15 3 4m5s 1m21s 16 3 4m9s 1m23s 17 3 3m54s 1m18s 18 3 3m49s 1m16s 19 3 3m46s 1m15s 20 3 3m50s 1m16s 21 3 3m49s 1m16s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h5m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 07:22:28 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 09:17:25 Duration: 3m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 10:16:11 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
3 36m18s 169 153ms 8m17s 12s890ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 28 07 7 3s289ms 469ms 08 17 5m42s 20s121ms 09 11 53s939ms 4s903ms 10 18 26s463ms 1s470ms 11 12 19s155ms 1s596ms 12 11 7m 38s264ms 13 15 1m23s 5s550ms 14 19 8m39s 27s338ms 15 28 9m23s 20s125ms 16 18 1m55s 6s439ms 17 12 29s852ms 2s487ms 18 1 770ms 770ms [ User: intelifix - Total duration: 36m18s - Times executed: 169 ]
[ Application: [unknown] - Total duration: 36m18s - Times executed: 169 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 14:59:33 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 15:45:52 Duration: 7m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030487, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 12:23:40 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 21m56s 3 3m3s 11m28s 7m18s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 28 05 3 21m56s 7m18s [ User: intelifix - Total duration: 21m56s - Times executed: 3 ]
[ Application: psql - Total duration: 21m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-28 05:11:30 Duration: 11m28s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-28 05:18:54 Duration: 7m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-28 05:21:57 Duration: 3m3s Database: contagem User: intelifix Remote: [local] Application: psql
5 15m17s 1,223 150ms 10s209ms 750ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 28 08 122 1m17s 637ms 09 225 2m26s 649ms 10 251 2m45s 661ms 11 144 1m30s 628ms 12 29 40s915ms 1s410ms 13 62 42s373ms 683ms 14 147 1m47s 733ms 15 143 2m9s 906ms 16 59 1m20s 1s370ms 17 34 26s680ms 784ms 18 7 8s661ms 1s237ms [ User: intelifix - Total duration: 15m17s - Times executed: 1223 ]
[ Application: [unknown] - Total duration: 15m17s - Times executed: 1223 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291384, 452, '73931885850072301166,229768398282,229710948287,229645834548,229792375662,216927235979,229676839011,229642687787,229695014062,229800726679,229826318706,229799878808,229799136984,229706893852,229695432947,229732913047,229834163355,229700460823,229827430925,229773732328,229699939705', '246556822125,246532255260,246478803254,246595191010,246459510507,246459738283,246480226770,246508831325,246613375354,246623362940,246613375152,246615642041,246536201022,246509200811,246483401840,246341553641,246540771625,246626070006,246575857091,246521454857,,,,,,,,,,,,,,,,,,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-28 16:14:53 Duration: 10s209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291363, 304, '833048907000897,229988719011,229971600820,229989115368,229974830013,230041614768,229988734141,230024207681,230021280012,230020581223,230030577798,230025968707', '',0295,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-28 12:02:38 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (138555, 401, '510023161216,CC75E2BE14E1,BC644BC6713E,A89FECC16E0A,A8F5DDEBB64C,BC644BDDDEC3,2C9569F3D699,4C1265E7DEF8,A89FECC1A8D9,F8F5325924F9', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-28 12:25:07 Duration: 5s15ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 12m10s 52 997ms 2m10s 14s47ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 28 07 4 32s824ms 8s206ms 08 1 3s302ms 3s302ms 09 1 2s649ms 2s649ms 10 2 15s940ms 7s970ms 11 4 19s293ms 4s823ms 12 1 1s439ms 1s439ms 13 2 6s880ms 3s440ms 14 8 2m47s 20s919ms 15 3 2m22s 47s353ms 16 9 2m52s 19s175ms 17 17 2m46s 9s772ms [ User: intelifix - Total duration: 12m10s - Times executed: 52 ]
[ Application: [unknown] - Total duration: 12m10s - Times executed: 52 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 15:13:43 Duration: 2m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 16:20:39 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 14:17:53 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 8m53s 47 10s367ms 12s983ms 11s347ms create table temp0000292678 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 28 12 17 3m4s 10s829ms 14 6 1m7s 11s216ms 15 19 3m43s 11s741ms 16 5 58s839ms 11s767ms [ User: intelifix - Total duration: 8m53s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m53s - Times executed: 47 ]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 14:49:29 Duration: 12s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:22:03 Duration: 12s672ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 16:25:08 Duration: 12s136ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 8m30s 31 10s638ms 1m17s 16s463ms create table temp0000292626 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 28 08 11 3m8s 17s104ms 09 1 19s888ms 19s888ms 10 4 1m51s 27s924ms 11 1 12s701ms 12s701ms 13 3 48s357ms 16s119ms 15 3 34s881ms 11s627ms 16 8 1m34s 11s836ms [ User: intelifix - Total duration: 8m30s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 8m30s - Times executed: 31 ]
-
CREATE TABLE temp0000292626 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 10:12:39 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292626 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 08:15:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292626 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 13:40:12 Duration: 26s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m10s 673 150ms 13s14ms 728ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 28 07 5 11s804ms 2s360ms 08 69 59s591ms 863ms 09 73 39s985ms 547ms 10 66 44s397ms 672ms 11 87 55s153ms 633ms 12 11 11s166ms 1s15ms 13 58 39s286ms 677ms 14 70 46s132ms 659ms 15 90 1m4s 719ms 16 101 1m24s 833ms 17 43 33s933ms 789ms [ User: intelifix - Total duration: 8m10s - Times executed: 673 ]
[ Application: [unknown] - Total duration: 8m10s - Times executed: 673 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "291483", "modelo" : "319", "itens" : "9C635BEA9282,9C635BEB0ADC,9C635BEA85CE,9C635BEA9A62,BCBD84A6F19D,BCBD84A6B7AD,,9C635BF87C12,BCBD84A6F533,9C635BF86B56,9C635BF83010,9C635BF879C6,9C635BF8830E,9C635BF8A6F6,9C635BEAA5A2,9C635BF8BAEE,9C635BF8737E,9C635BF7F8AE,9C635BEA9828,9C635BEA9B5E,BCBD84A6E05D", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-28 11:38:47 Duration: 13s14ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "291121", "modelo" : "320", "itens" : "241700901728,241630826583,241660392634,241630850627,241657601116,241618199010,241672032244,241646421731,241603983840,230048556971,241691559413,241670161029,241668171418,241727552129,241646127380,241667775464,241694202533,241699267684,241673169515,230055107790,241664305866,241601057280,241592872745,241707370923,241597437892,241654896979,241676462429,230049240709,241731462230,241672405467,241637482542,241653420708,241731462533,241620770507,241703752848,241700746886,230049001112,241700693043,241664060411,241730546472,241697102446,241639380202,241616063044,241594141522,241594955877,241651030722,241677504966,241660985374", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-28 07:56:18 Duration: 3s893ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "291121", "modelo" : "320", "itens" : "241694247991,241653319710,241673160121,241714240011,241732830007,241677280220,241661568494,241674487791,241596233948,241693026267,241667581529,241714021628,241653963342,241675840416,241594071010,241664727983,241599491427,241673054655,230048051940,241651319616,241713038085,241632334048,241691078502,241635660827,241652394356,241661011213,241730405269,241607865173,241716730108,241617882234,241631018195,241713077079,241672409912,241676513747,230048208902,241680437485,241733078997,241730408300,241651656573,241730391834,241675203047,241606122635,241670368096,241677741533,241661432646,241655912141,241675654056,241694795374", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-28 08:01:21 Duration: 3s245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m1s 150 152ms 18s79ms 3s208ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 28 00 7 35s670ms 5s95ms 01 6 19s247ms 3s207ms 02 6 18s607ms 3s101ms 03 5 15s500ms 3s100ms 04 6 19s484ms 3s247ms 05 7 21s743ms 3s106ms 06 6 18s247ms 3s41ms 07 6 17s759ms 2s959ms 08 6 18s481ms 3s80ms 09 7 26s485ms 3s783ms 10 6 20s226ms 3s371ms 11 6 19s292ms 3s215ms 12 6 19s502ms 3s250ms 13 6 19s402ms 3s233ms 14 7 21s627ms 3s89ms 15 7 24s11ms 3s430ms 16 10 23s384ms 2s338ms 17 6 19s868ms 3s311ms 18 6 18s965ms 3s160ms 19 6 18s556ms 3s92ms 20 10 27s569ms 2s756ms 21 6 18s998ms 3s166ms 22 6 18s670ms 3s111ms [ User: intelifix - Total duration: 8m1s - Times executed: 150 ]
[ Application: psql - Total duration: 8m1s - Times executed: 150 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 00:05:19 Duration: 18s79ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 09:15:15 Duration: 9s300ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 20:05:09 Duration: 7s563ms Database: rio User: intelifix Remote: [local] Application: psql
11 7m24s 113 263ms 13s190ms 3s936ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 28 00 1 320ms 320ms 05 1 577ms 577ms 06 5 17s193ms 3s438ms 07 8 36s792ms 4s599ms 08 7 37s492ms 5s356ms 09 8 40s277ms 5s34ms 10 13 48s8ms 3s692ms 11 12 49s41ms 4s86ms 12 12 36s201ms 3s16ms 13 8 15s918ms 1s989ms 14 7 29s954ms 4s279ms 15 11 1m11s 6s532ms 16 9 38s513ms 4s279ms 21 5 12s130ms 2s426ms 22 6 10s602ms 1s767ms [ User: intelifix - Total duration: 7m24s - Times executed: 113 ]
[ Application: psql - Total duration: 7m24s - Times executed: 113 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 15:15:14 Duration: 13s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 14:55:13 Duration: 11s20ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 16:15:11 Duration: 10s193ms Database: rio User: intelifix Remote: [local] Application: psql
12 6m25s 36 221ms 1m28s 10s702ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 28 08 7 56s256ms 8s36ms 10 4 37s572ms 9s393ms 12 6 1m5s 10s956ms 13 1 1s89ms 1s89ms 14 4 2m2s 30s635ms 15 12 1m6s 5s579ms 16 2 35s136ms 17s568ms [ User: intelifix - Total duration: 6m25s - Times executed: 36 ]
[ Application: psql - Total duration: 6m25s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030500);
Date: 2026-09-28 14:52:15 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030487);
Date: 2026-09-28 12:17:07 Duration: 49s284ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030501);
Date: 2026-09-28 14:55:58 Duration: 27s201ms Database: rio User: intelifix Remote: [local] Application: psql
13 4m52s 41 153ms 59s251ms 7s132ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 28 08 7 1m48s 15s567ms 10 4 1m57s 29s369ms 11 1 1s506ms 1s506ms 12 7 2s683ms 383ms 13 1 3s878ms 3s878ms 14 5 9s729ms 1s945ms 15 8 7s509ms 938ms 16 7 40s290ms 5s755ms 17 1 396ms 396ms [ User: intelifix - Total duration: 4m52s - Times executed: 41 ]
[ Application: psql - Total duration: 4m52s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030483);
Date: 2026-09-28 10:17:57 Duration: 59s251ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030475);
Date: 2026-09-28 08:16:04 Duration: 45s97ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030482);
Date: 2026-09-28 10:12:02 Duration: 40s738ms Database: rio User: intelifix Remote: [local] Application: psql
14 4m28s 23 10s877ms 12s94ms 11s679ms create table temp0000292712 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 28 14 4 45s398ms 11s349ms 15 19 3m43s 11s748ms [ User: intelifix - Total duration: 4m28s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 4m28s - Times executed: 23 ]
-
CREATE TABLE temp0000292712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:20:47 Duration: 12s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:17:25 Duration: 12s57ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:06:26 Duration: 12s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m25s 18 10s679ms 14s448ms 11s393ms create table temp0000292636 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 28 14 4 45s29ms 11s257ms 16 10 1m52s 11s229ms 17 4 47s751ms 11s937ms [ User: intelifix - Total duration: 3m25s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m25s - Times executed: 18 ]
-
CREATE TABLE temp0000292636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 17:10:18 Duration: 14s448ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 16:34:56 Duration: 12s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 16:35:30 Duration: 11s844ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m2s 56 2s844ms 4s570ms 3s263ms create table temp0000292678 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 28 12 22 1m6s 3s45ms 14 1 3s254ms 3s254ms 15 13 42s775ms 3s290ms 16 20 1m9s 3s485ms [ User: intelifix - Total duration: 3m2s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 56 ]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 12:24:40 Duration: 4s570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 16:21:18 Duration: 3s974ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 16:20:23 Duration: 3s798ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m14s 4 4s367ms 1m3s 33s677ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 28 20 2 1m7s 33s869ms 23 2 1m6s 33s486ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-28 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-28 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-28 23:33:45 Duration: 4s612ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1m55s 38 710ms 8s293ms 3s37ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 28 08 3 16s842ms 5s614ms 09 3 9s303ms 3s101ms 10 2 5s939ms 2s969ms 11 2 6s715ms 3s357ms 12 3 5s773ms 1s924ms 13 3 7s477ms 2s492ms 14 3 10s74ms 3s358ms 15 3 16s225ms 5s408ms 16 3 18s742ms 6s247ms 17 2 8s669ms 4s334ms 18 2 1s748ms 874ms 19 1 846ms 846ms 20 3 2s615ms 871ms 21 3 2s786ms 928ms 22 2 1s666ms 833ms [ User: intelifix - Total duration: 1m55s - Times executed: 38 ]
[ Application: psql - Total duration: 1m55s - Times executed: 38 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-28 08:20:10 Duration: 8s293ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-28 16:20:10 Duration: 8s182ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-28 15:40:09 Duration: 7s878ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m46s 6 3s173ms 39s893ms 17s805ms 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 #19
Day Hour Count Duration Avg duration Sep 28 20 3 53s560ms 17s853ms 23 3 53s272ms 17s757ms [ 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-28 20:06:25 Duration: 39s893ms 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-28 23:14:22 Duration: 39s539ms 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-28 23:33:21 Duration: 10s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m46s 4 350ms 53s217ms 26s664ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 28 20 2 53s616ms 26s808ms 23 2 53s42ms 26s521ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-28 20:05:44 Duration: 53s217ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-28 23:13:41 Duration: 52s691ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-28 20:10:05 Duration: 398ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,223 15m17s 150ms 10s209ms 750ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 28 08 122 1m17s 637ms 09 225 2m26s 649ms 10 251 2m45s 661ms 11 144 1m30s 628ms 12 29 40s915ms 1s410ms 13 62 42s373ms 683ms 14 147 1m47s 733ms 15 143 2m9s 906ms 16 59 1m20s 1s370ms 17 34 26s680ms 784ms 18 7 8s661ms 1s237ms [ User: intelifix - Total duration: 15m17s - Times executed: 1223 ]
[ Application: [unknown] - Total duration: 15m17s - Times executed: 1223 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291384, 452, '73931885850072301166,229768398282,229710948287,229645834548,229792375662,216927235979,229676839011,229642687787,229695014062,229800726679,229826318706,229799878808,229799136984,229706893852,229695432947,229732913047,229834163355,229700460823,229827430925,229773732328,229699939705', '246556822125,246532255260,246478803254,246595191010,246459510507,246459738283,246480226770,246508831325,246613375354,246623362940,246613375152,246615642041,246536201022,246509200811,246483401840,246341553641,246540771625,246626070006,246575857091,246521454857,,,,,,,,,,,,,,,,,,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-28 16:14:53 Duration: 10s209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291363, 304, '833048907000897,229988719011,229971600820,229989115368,229974830013,230041614768,229988734141,230024207681,230021280012,230020581223,230030577798,230025968707', '',0295,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-28 12:02:38 Duration: 8s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (138555, 401, '510023161216,CC75E2BE14E1,BC644BC6713E,A89FECC16E0A,A8F5DDEBB64C,BC644BDDDEC3,2C9569F3D699,4C1265E7DEF8,A89FECC1A8D9,F8F5325924F9', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-28 12:25:07 Duration: 5s15ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
2 673 8m10s 150ms 13s14ms 728ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 28 07 5 11s804ms 2s360ms 08 69 59s591ms 863ms 09 73 39s985ms 547ms 10 66 44s397ms 672ms 11 87 55s153ms 633ms 12 11 11s166ms 1s15ms 13 58 39s286ms 677ms 14 70 46s132ms 659ms 15 90 1m4s 719ms 16 101 1m24s 833ms 17 43 33s933ms 789ms [ User: intelifix - Total duration: 8m10s - Times executed: 673 ]
[ Application: [unknown] - Total duration: 8m10s - Times executed: 673 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "291483", "modelo" : "319", "itens" : "9C635BEA9282,9C635BEB0ADC,9C635BEA85CE,9C635BEA9A62,BCBD84A6F19D,BCBD84A6B7AD,,9C635BF87C12,BCBD84A6F533,9C635BF86B56,9C635BF83010,9C635BF879C6,9C635BF8830E,9C635BF8A6F6,9C635BEAA5A2,9C635BF8BAEE,9C635BF8737E,9C635BF7F8AE,9C635BEA9828,9C635BEA9B5E,BCBD84A6E05D", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-28 11:38:47 Duration: 13s14ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "291121", "modelo" : "320", "itens" : "241700901728,241630826583,241660392634,241630850627,241657601116,241618199010,241672032244,241646421731,241603983840,230048556971,241691559413,241670161029,241668171418,241727552129,241646127380,241667775464,241694202533,241699267684,241673169515,230055107790,241664305866,241601057280,241592872745,241707370923,241597437892,241654896979,241676462429,230049240709,241731462230,241672405467,241637482542,241653420708,241731462533,241620770507,241703752848,241700746886,230049001112,241700693043,241664060411,241730546472,241697102446,241639380202,241616063044,241594141522,241594955877,241651030722,241677504966,241660985374", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-28 07:56:18 Duration: 3s893ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "291121", "modelo" : "320", "itens" : "241694247991,241653319710,241673160121,241714240011,241732830007,241677280220,241661568494,241674487791,241596233948,241693026267,241667581529,241714021628,241653963342,241675840416,241594071010,241664727983,241599491427,241673054655,230048051940,241651319616,241713038085,241632334048,241691078502,241635660827,241652394356,241661011213,241730405269,241607865173,241716730108,241617882234,241631018195,241713077079,241672409912,241676513747,230048208902,241680437485,241733078997,241730408300,241651656573,241730391834,241675203047,241606122635,241670368096,241677741533,241661432646,241655912141,241675654056,241694795374", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-28 08:01:21 Duration: 3s245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 169 36m18s 153ms 8m17s 12s890ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 28 07 7 3s289ms 469ms 08 17 5m42s 20s121ms 09 11 53s939ms 4s903ms 10 18 26s463ms 1s470ms 11 12 19s155ms 1s596ms 12 11 7m 38s264ms 13 15 1m23s 5s550ms 14 19 8m39s 27s338ms 15 28 9m23s 20s125ms 16 18 1m55s 6s439ms 17 12 29s852ms 2s487ms 18 1 770ms 770ms [ User: intelifix - Total duration: 36m18s - Times executed: 169 ]
[ Application: [unknown] - Total duration: 36m18s - Times executed: 169 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 14:59:33 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 15:45:52 Duration: 7m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030487, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 12:23:40 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 150 8m1s 152ms 18s79ms 3s208ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 28 00 7 35s670ms 5s95ms 01 6 19s247ms 3s207ms 02 6 18s607ms 3s101ms 03 5 15s500ms 3s100ms 04 6 19s484ms 3s247ms 05 7 21s743ms 3s106ms 06 6 18s247ms 3s41ms 07 6 17s759ms 2s959ms 08 6 18s481ms 3s80ms 09 7 26s485ms 3s783ms 10 6 20s226ms 3s371ms 11 6 19s292ms 3s215ms 12 6 19s502ms 3s250ms 13 6 19s402ms 3s233ms 14 7 21s627ms 3s89ms 15 7 24s11ms 3s430ms 16 10 23s384ms 2s338ms 17 6 19s868ms 3s311ms 18 6 18s965ms 3s160ms 19 6 18s556ms 3s92ms 20 10 27s569ms 2s756ms 21 6 18s998ms 3s166ms 22 6 18s670ms 3s111ms [ User: intelifix - Total duration: 8m1s - Times executed: 150 ]
[ Application: psql - Total duration: 8m1s - Times executed: 150 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 00:05:19 Duration: 18s79ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 09:15:15 Duration: 9s300ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 20:05:09 Duration: 7s563ms Database: rio User: intelifix Remote: [local] Application: psql
5 113 7m24s 263ms 13s190ms 3s936ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 28 00 1 320ms 320ms 05 1 577ms 577ms 06 5 17s193ms 3s438ms 07 8 36s792ms 4s599ms 08 7 37s492ms 5s356ms 09 8 40s277ms 5s34ms 10 13 48s8ms 3s692ms 11 12 49s41ms 4s86ms 12 12 36s201ms 3s16ms 13 8 15s918ms 1s989ms 14 7 29s954ms 4s279ms 15 11 1m11s 6s532ms 16 9 38s513ms 4s279ms 21 5 12s130ms 2s426ms 22 6 10s602ms 1s767ms [ User: intelifix - Total duration: 7m24s - Times executed: 113 ]
[ Application: psql - Total duration: 7m24s - Times executed: 113 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 15:15:14 Duration: 13s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 14:55:13 Duration: 11s20ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 16:15:11 Duration: 10s193ms Database: rio User: intelifix Remote: [local] Application: psql
6 92 21s142ms 150ms 862ms 229ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 28 07 5 1s161ms 232ms 08 15 4s5ms 267ms 09 8 1s560ms 195ms 10 10 2s132ms 213ms 11 8 1s807ms 225ms 12 5 1s264ms 252ms 13 2 425ms 212ms 14 17 4s28ms 236ms 15 14 2s782ms 198ms 16 5 1s185ms 237ms 17 1 173ms 173ms 21 2 615ms 307ms [ User: intelifix - Total duration: 21s142ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 21s142ms - Times executed: 92 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('485702872D20');
Date: 2026-09-28 08:57:09 Duration: 862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('ZTE3ANNR4N55556');
Date: 2026-09-28 10:26:39 Duration: 420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229898892635');
Date: 2026-09-28 12:06:15 Duration: 408ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 84 26s803ms 297ms 378ms 319ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 28 06 1 315ms 315ms 07 3 922ms 307ms 08 13 4s79ms 313ms 09 6 1s973ms 328ms 10 11 3s498ms 318ms 11 6 1s884ms 314ms 12 6 1s871ms 311ms 13 7 2s186ms 312ms 14 8 2s505ms 313ms 15 9 3s38ms 337ms 16 6 1s962ms 327ms 17 5 1s602ms 320ms 18 1 336ms 336ms 20 1 315ms 315ms 21 1 309ms 309ms [ User: lenon - Total duration: 26s803ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 26s803ms - Times executed: 84 ]
-
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-28 15:22:26 Duration: 378ms 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-28 09:06:36 Duration: 357ms 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-28 09:21:40 Duration: 354ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 75 29s411ms 332ms 810ms 392ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 28 07 2 880ms 440ms 08 11 4s284ms 389ms 09 5 1s939ms 387ms 10 12 4s558ms 379ms 11 6 2s186ms 364ms 12 6 2s642ms 440ms 13 7 2s819ms 402ms 14 7 2s549ms 364ms 15 8 3s281ms 410ms 16 6 2s263ms 377ms 17 3 1s236ms 412ms 18 1 397ms 397ms 21 1 371ms 371ms [ User: intelifix - Total duration: 29s411ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 29s411ms - Times executed: 75 ]
-
select * from rs_menu_grants (401, 18, 1);
Date: 2026-09-28 12:21:07 Duration: 810ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-09-28 08:16:09 Duration: 650ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (407, 5, 1);
Date: 2026-09-28 13:06:05 Duration: 637ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 72 26s818ms 150ms 1s402ms 372ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 28 17 72 26s818ms 372ms [ User: intelifix - Total duration: 26s818ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 26s818ms - Times executed: 72 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59276","seriais":"A8705D81095B,A8705D7ED483,A8705D83F454,A8705D8315F2,A8705D81C472,A8705D815320,A8705D729D35","usuario":"416","observacao":""}');
Date: 2026-09-28 17:02:36 Duration: 1s402ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59276","seriais":"4075C3999B4C,B85E7110A634,4075C3BB0980,CCF3C846EDDC,B85E71CE3DA8,ECA81F21C65C,08A7C0789914,1C9D72EF65D4","usuario":"416","observacao":""}');
Date: 2026-09-28 17:09:12 Duration: 1s91ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59276","seriais":"743AEFD940B6,840112C0B217,840112962231,1834AF28A0C8,743AEF5B95A9,840112930EAA,9877E7BA2A11,9877E77D0D17,743AEF9D3AAE","usuario":"416","observacao":""}');
Date: 2026-09-28 17:15:30 Duration: 659ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
10 67 1m3s 151ms 4s12ms 950ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 28 07 13 12s285ms 945ms 08 2 4s323ms 2s161ms 09 2 5s156ms 2s578ms 10 3 2s433ms 811ms 11 2 879ms 439ms 12 8 6s87ms 760ms 13 4 3s930ms 982ms 14 4 2s87ms 521ms 15 9 14s802ms 1s644ms 16 15 9s450ms 630ms 17 5 2s266ms 453ms [ User: intelifix - Total duration: 1m3s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 67 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0138437) LIMIT 1;
Date: 2026-09-28 08:00:01 Duration: 4s12ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288373) LIMIT 1;
Date: 2026-09-28 15:01:20 Duration: 3s945ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0291512) LIMIT 1;
Date: 2026-09-28 15:53:33 Duration: 3s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 67 27s151ms 253ms 2s172ms 405ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 28 08 16 4s555ms 284ms 09 4 1s389ms 347ms 10 4 1s122ms 280ms 11 6 3s961ms 660ms 12 5 1s405ms 281ms 13 3 819ms 273ms 14 8 4s666ms 583ms 15 11 4s548ms 413ms 16 7 3s888ms 555ms 17 3 795ms 265ms [ User: intelifix - Total duration: 27s151ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 27s151ms - Times executed: 67 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-28 16:09:42 Duration: 2s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-28 11:31:59 Duration: 1s831ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-28 14:47:46 Duration: 1s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 59 13s146ms 150ms 694ms 222ms select * from rs_lote_consiste_serial (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 28 08 4 1s416ms 354ms 09 7 1s739ms 248ms 10 5 1s76ms 215ms 11 6 1s96ms 182ms 12 3 790ms 263ms 13 6 1s239ms 206ms 14 15 2s992ms 199ms 15 11 2s299ms 209ms 16 2 495ms 247ms [ User: intelifix - Total duration: 13s146ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 13s146ms - Times executed: 59 ]
-
SELECT * FROM RS_LOTE_CONSISTE_SERIAL ('{"lote":"138622","seriais":[{"serial":"518170214950"},{"serial":""}]}');
Date: 2026-09-28 08:19:00 Duration: 694ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_CONSISTE_SERIAL ('{"lote":"291177","seriais":[{"serial":"722333069454"},{"serial":""}]}');
Date: 2026-09-28 09:33:05 Duration: 437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_CONSISTE_SERIAL ('{"lote":"138641","seriais":[]}');
Date: 2026-09-28 12:10:24 Duration: 409ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 56 3m2s 2s844ms 4s570ms 3s263ms create table temp0000292678 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 28 12 22 1m6s 3s45ms 14 1 3s254ms 3s254ms 15 13 42s775ms 3s290ms 16 20 1m9s 3s485ms [ User: intelifix - Total duration: 3m2s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 56 ]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 12:24:40 Duration: 4s570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 16:21:18 Duration: 3s974ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 16:20:23 Duration: 3s798ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 53 1m11s 160ms 16s787ms 1s340ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 28 08 3 2s704ms 901ms 09 3 2s315ms 771ms 10 4 7s175ms 1s793ms 11 4 5s602ms 1s400ms 12 3 2s927ms 975ms 13 3 2s174ms 724ms 14 4 2s434ms 608ms 15 3 2s513ms 837ms 16 3 2s275ms 758ms 17 4 9s284ms 2s321ms 18 4 18s997ms 4s749ms 19 5 3s763ms 752ms 20 3 2s186ms 728ms 21 3 3s425ms 1s141ms 22 4 3s269ms 817ms [ User: intelifix - Total duration: 1m11s - Times executed: 53 ]
[ Application: psql - Total duration: 1m11s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-28 18:00:19 Duration: 16s787ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-28 17:20:08 Duration: 6s896ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-28 10:20:06 Duration: 5s107ms Database: rio User: intelifix Remote: [local] Application: psql
15 52 12m10s 997ms 2m10s 14s47ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 28 07 4 32s824ms 8s206ms 08 1 3s302ms 3s302ms 09 1 2s649ms 2s649ms 10 2 15s940ms 7s970ms 11 4 19s293ms 4s823ms 12 1 1s439ms 1s439ms 13 2 6s880ms 3s440ms 14 8 2m47s 20s919ms 15 3 2m22s 47s353ms 16 9 2m52s 19s175ms 17 17 2m46s 9s772ms [ User: intelifix - Total duration: 12m10s - Times executed: 52 ]
[ Application: [unknown] - Total duration: 12m10s - Times executed: 52 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 15:13:43 Duration: 2m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 16:20:39 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 14:17:53 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
16 48 1h40m38s 2s183ms 10m45s 2m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 28 07 3 11m44s 3m54s 08 3 5m28s 1m49s 09 3 8m24s 2m48s 10 3 6m57s 2m19s 11 3 5m58s 1m59s 12 3 5m42s 1m54s 13 3 5m35s 1m51s 14 3 5m46s 1m55s 15 3 6m5s 2m1s 16 3 6m3s 2m1s 17 3 5m55s 1m58s 18 3 5m25s 1m48s 19 3 5m17s 1m45s 20 3 5m31s 1m50s 21 3 5m20s 1m46s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h40m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h40m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 07:15:46 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 09:12:56 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 10:11:34 Duration: 6m33s Database: rio User: intelifix Remote: [local] Application: psql
17 48 1h5m26s 212ms 3m57s 1m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 28 07 3 5m57s 1m59s 08 3 3m50s 1m16s 09 3 4m9s 1m23s 10 3 4m19s 1m26s 11 3 3m55s 1m18s 12 3 3m53s 1m17s 13 3 3m54s 1m18s 14 3 4m 1m20s 15 3 4m5s 1m21s 16 3 4m9s 1m23s 17 3 3m54s 1m18s 18 3 3m49s 1m16s 19 3 3m46s 1m15s 20 3 3m50s 1m16s 21 3 3m49s 1m16s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h5m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 07:22:28 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 09:17:25 Duration: 3m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 10:16:11 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
18 47 8m53s 10s367ms 12s983ms 11s347ms create table temp0000292678 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 28 12 17 3m4s 10s829ms 14 6 1m7s 11s216ms 15 19 3m43s 11s741ms 16 5 58s839ms 11s767ms [ User: intelifix - Total duration: 8m53s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m53s - Times executed: 47 ]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 14:49:29 Duration: 12s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:22:03 Duration: 12s672ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 16:25:08 Duration: 12s136ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 41 4m52s 153ms 59s251ms 7s132ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 28 08 7 1m48s 15s567ms 10 4 1m57s 29s369ms 11 1 1s506ms 1s506ms 12 7 2s683ms 383ms 13 1 3s878ms 3s878ms 14 5 9s729ms 1s945ms 15 8 7s509ms 938ms 16 7 40s290ms 5s755ms 17 1 396ms 396ms [ User: intelifix - Total duration: 4m52s - Times executed: 41 ]
[ Application: psql - Total duration: 4m52s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030483);
Date: 2026-09-28 10:17:57 Duration: 59s251ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030475);
Date: 2026-09-28 08:16:04 Duration: 45s97ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030482);
Date: 2026-09-28 10:12:02 Duration: 40s738ms Database: rio User: intelifix Remote: [local] Application: psql
20 41 11s152ms 156ms 2s230ms 272ms select * from rs_etiqueta (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 28 07 3 677ms 225ms 08 4 694ms 173ms 09 5 1s35ms 207ms 10 1 165ms 165ms 11 5 1s137ms 227ms 12 6 3s317ms 552ms 13 2 625ms 312ms 14 6 1s507ms 251ms 15 4 768ms 192ms 16 5 1s222ms 244ms [ User: etiquetas - Total duration: 11s152ms - Times executed: 41 ]
[ Application: [unknown] - Total duration: 11s152ms - Times executed: 41 ]
-
SELECT * FROM RS_ETIQUETA ('2841C6858F26');
Date: 2026-09-28 12:15:13 Duration: 2s230ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('ZTE3QJRPA413815');
Date: 2026-09-28 13:44:05 Duration: 448ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('C85D38E7459A');
Date: 2026-09-28 16:14:50 Duration: 444ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m3s 11m28s 7m18s 3 21m56s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 28 05 3 21m56s 7m18s [ User: intelifix - Total duration: 21m56s - Times executed: 3 ]
[ Application: psql - Total duration: 21m56s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-28 05:11:30 Duration: 11m28s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-28 05:18:54 Duration: 7m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-28 05:21:57 Duration: 3m3s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s183ms 10m45s 2m5s 48 1h40m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 28 07 3 11m44s 3m54s 08 3 5m28s 1m49s 09 3 8m24s 2m48s 10 3 6m57s 2m19s 11 3 5m58s 1m59s 12 3 5m42s 1m54s 13 3 5m35s 1m51s 14 3 5m46s 1m55s 15 3 6m5s 2m1s 16 3 6m3s 2m1s 17 3 5m55s 1m58s 18 3 5m25s 1m48s 19 3 5m17s 1m45s 20 3 5m31s 1m50s 21 3 5m20s 1m46s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h40m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h40m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 07:15:46 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 09:12:56 Duration: 7m54s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-28 10:11:34 Duration: 6m33s Database: rio User: intelifix Remote: [local] Application: psql
3 212ms 3m57s 1m21s 48 1h5m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 28 07 3 5m57s 1m59s 08 3 3m50s 1m16s 09 3 4m9s 1m23s 10 3 4m19s 1m26s 11 3 3m55s 1m18s 12 3 3m53s 1m17s 13 3 3m54s 1m18s 14 3 4m 1m20s 15 3 4m5s 1m21s 16 3 4m9s 1m23s 17 3 3m54s 1m18s 18 3 3m49s 1m16s 19 3 3m46s 1m15s 20 3 3m50s 1m16s 21 3 3m49s 1m16s 22 3 3m59s 1m19s [ User: intelifix - Total duration: 1h5m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 07:22:28 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 09:17:25 Duration: 3m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-28 10:16:11 Duration: 3m36s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s367ms 1m3s 33s677ms 4 2m14s 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 28 20 2 1m7s 33s869ms 23 2 1m6s 33s486ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-28 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-28 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-28 23:33:45 Duration: 4s612ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 350ms 53s217ms 26s664ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 28 20 2 53s616ms 26s808ms 23 2 53s42ms 26s521ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-28 20:05:44 Duration: 53s217ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-28 23:13:41 Duration: 52s691ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-28 20:10:05 Duration: 398ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 3s173ms 39s893ms 17s805ms 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 28 20 3 53s560ms 17s853ms 23 3 53s272ms 17s757ms [ 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-28 20:06:25 Duration: 39s893ms 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-28 23:14:22 Duration: 39s539ms 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-28 23:33:21 Duration: 10s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 10s638ms 1m17s 16s463ms 31 8m30s create table temp0000292626 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 28 08 11 3m8s 17s104ms 09 1 19s888ms 19s888ms 10 4 1m51s 27s924ms 11 1 12s701ms 12s701ms 13 3 48s357ms 16s119ms 15 3 34s881ms 11s627ms 16 8 1m34s 11s836ms [ User: intelifix - Total duration: 8m30s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 8m30s - Times executed: 31 ]
-
CREATE TABLE temp0000292626 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 10:12:39 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292626 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 08:15:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292626 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 13:40:12 Duration: 26s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 997ms 2m10s 14s47ms 52 12m10s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 28 07 4 32s824ms 8s206ms 08 1 3s302ms 3s302ms 09 1 2s649ms 2s649ms 10 2 15s940ms 7s970ms 11 4 19s293ms 4s823ms 12 1 1s439ms 1s439ms 13 2 6s880ms 3s440ms 14 8 2m47s 20s919ms 15 3 2m22s 47s353ms 16 9 2m52s 19s175ms 17 17 2m46s 9s772ms [ User: intelifix - Total duration: 12m10s - Times executed: 52 ]
[ Application: [unknown] - Total duration: 12m10s - Times executed: 52 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 15:13:43 Duration: 2m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 16:20:39 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-28', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-28 14:17:53 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 153ms 8m17s 12s890ms 169 36m18s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 28 07 7 3s289ms 469ms 08 17 5m42s 20s121ms 09 11 53s939ms 4s903ms 10 18 26s463ms 1s470ms 11 12 19s155ms 1s596ms 12 11 7m 38s264ms 13 15 1m23s 5s550ms 14 19 8m39s 27s338ms 15 28 9m23s 20s125ms 16 18 1m55s 6s439ms 17 12 29s852ms 2s487ms 18 1 770ms 770ms [ User: intelifix - Total duration: 36m18s - Times executed: 169 ]
[ Application: [unknown] - Total duration: 36m18s - Times executed: 169 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030500, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 14:59:33 Duration: 8m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 15:45:52 Duration: 7m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030487, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-28 12:23:40 Duration: 6m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s877ms 12s94ms 11s679ms 23 4m28s create table temp0000292712 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 28 14 4 45s398ms 11s349ms 15 19 3m43s 11s748ms [ User: intelifix - Total duration: 4m28s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 4m28s - Times executed: 23 ]
-
CREATE TABLE temp0000292712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:20:47 Duration: 12s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:17:25 Duration: 12s57ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292712 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:06:26 Duration: 12s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s679ms 14s448ms 11s393ms 18 3m25s create table temp0000292636 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 28 14 4 45s29ms 11s257ms 16 10 1m52s 11s229ms 17 4 47s751ms 11s937ms [ User: intelifix - Total duration: 3m25s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m25s - Times executed: 18 ]
-
CREATE TABLE temp0000292636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 17:10:18 Duration: 14s448ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 16:34:56 Duration: 12s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292636 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 16:35:30 Duration: 11s844ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s367ms 12s983ms 11s347ms 47 8m53s create table temp0000292678 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 28 12 17 3m4s 10s829ms 14 6 1m7s 11s216ms 15 19 3m43s 11s741ms 16 5 58s839ms 11s767ms [ User: intelifix - Total duration: 8m53s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m53s - Times executed: 47 ]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 14:49:29 Duration: 12s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 15:22:03 Duration: 12s672ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-28 16:25:08 Duration: 12s136ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 221ms 1m28s 10s702ms 36 6m25s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 28 08 7 56s256ms 8s36ms 10 4 37s572ms 9s393ms 12 6 1m5s 10s956ms 13 1 1s89ms 1s89ms 14 4 2m2s 30s635ms 15 12 1m6s 5s579ms 16 2 35s136ms 17s568ms [ User: intelifix - Total duration: 6m25s - Times executed: 36 ]
[ Application: psql - Total duration: 6m25s - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030500);
Date: 2026-09-28 14:52:15 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030487);
Date: 2026-09-28 12:17:07 Duration: 49s284ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030501);
Date: 2026-09-28 14:55:58 Duration: 27s201ms Database: rio User: intelifix Remote: [local] Application: psql
14 153ms 59s251ms 7s132ms 41 4m52s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 28 08 7 1m48s 15s567ms 10 4 1m57s 29s369ms 11 1 1s506ms 1s506ms 12 7 2s683ms 383ms 13 1 3s878ms 3s878ms 14 5 9s729ms 1s945ms 15 8 7s509ms 938ms 16 7 40s290ms 5s755ms 17 1 396ms 396ms [ User: intelifix - Total duration: 4m52s - Times executed: 41 ]
[ Application: psql - Total duration: 4m52s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030483);
Date: 2026-09-28 10:17:57 Duration: 59s251ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030475);
Date: 2026-09-28 08:16:04 Duration: 45s97ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030482);
Date: 2026-09-28 10:12:02 Duration: 40s738ms Database: rio User: intelifix Remote: [local] Application: psql
15 263ms 13s190ms 3s936ms 113 7m24s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 28 00 1 320ms 320ms 05 1 577ms 577ms 06 5 17s193ms 3s438ms 07 8 36s792ms 4s599ms 08 7 37s492ms 5s356ms 09 8 40s277ms 5s34ms 10 13 48s8ms 3s692ms 11 12 49s41ms 4s86ms 12 12 36s201ms 3s16ms 13 8 15s918ms 1s989ms 14 7 29s954ms 4s279ms 15 11 1m11s 6s532ms 16 9 38s513ms 4s279ms 21 5 12s130ms 2s426ms 22 6 10s602ms 1s767ms [ User: intelifix - Total duration: 7m24s - Times executed: 113 ]
[ Application: psql - Total duration: 7m24s - Times executed: 113 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 15:15:14 Duration: 13s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 14:55:13 Duration: 11s20ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-28 16:15:11 Duration: 10s193ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s844ms 4s570ms 3s263ms 56 3m2s create table temp0000292678 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 28 12 22 1m6s 3s45ms 14 1 3s254ms 3s254ms 15 13 42s775ms 3s290ms 16 20 1m9s 3s485ms [ User: intelifix - Total duration: 3m2s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 56 ]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 12:24:40 Duration: 4s570ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 16:21:18 Duration: 3s974ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292678 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-09-2026", "ate" :"28-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-28 16:20:23 Duration: 3s798ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 152ms 18s79ms 3s208ms 150 8m1s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 28 00 7 35s670ms 5s95ms 01 6 19s247ms 3s207ms 02 6 18s607ms 3s101ms 03 5 15s500ms 3s100ms 04 6 19s484ms 3s247ms 05 7 21s743ms 3s106ms 06 6 18s247ms 3s41ms 07 6 17s759ms 2s959ms 08 6 18s481ms 3s80ms 09 7 26s485ms 3s783ms 10 6 20s226ms 3s371ms 11 6 19s292ms 3s215ms 12 6 19s502ms 3s250ms 13 6 19s402ms 3s233ms 14 7 21s627ms 3s89ms 15 7 24s11ms 3s430ms 16 10 23s384ms 2s338ms 17 6 19s868ms 3s311ms 18 6 18s965ms 3s160ms 19 6 18s556ms 3s92ms 20 10 27s569ms 2s756ms 21 6 18s998ms 3s166ms 22 6 18s670ms 3s111ms [ User: intelifix - Total duration: 8m1s - Times executed: 150 ]
[ Application: psql - Total duration: 8m1s - Times executed: 150 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 00:05:19 Duration: 18s79ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 09:15:15 Duration: 9s300ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-28 20:05:09 Duration: 7s563ms Database: rio User: intelifix Remote: [local] Application: psql
18 710ms 8s293ms 3s37ms 38 1m55s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 28 08 3 16s842ms 5s614ms 09 3 9s303ms 3s101ms 10 2 5s939ms 2s969ms 11 2 6s715ms 3s357ms 12 3 5s773ms 1s924ms 13 3 7s477ms 2s492ms 14 3 10s74ms 3s358ms 15 3 16s225ms 5s408ms 16 3 18s742ms 6s247ms 17 2 8s669ms 4s334ms 18 2 1s748ms 874ms 19 1 846ms 846ms 20 3 2s615ms 871ms 21 3 2s786ms 928ms 22 2 1s666ms 833ms [ User: intelifix - Total duration: 1m55s - Times executed: 38 ]
[ Application: psql - Total duration: 1m55s - Times executed: 38 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-28 08:20:10 Duration: 8s293ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-28 16:20:10 Duration: 8s182ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-28 15:40:09 Duration: 7s878ms Database: rio User: intelifix Remote: [local] Application: psql
19 160ms 16s787ms 1s340ms 53 1m11s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 28 08 3 2s704ms 901ms 09 3 2s315ms 771ms 10 4 7s175ms 1s793ms 11 4 5s602ms 1s400ms 12 3 2s927ms 975ms 13 3 2s174ms 724ms 14 4 2s434ms 608ms 15 3 2s513ms 837ms 16 3 2s275ms 758ms 17 4 9s284ms 2s321ms 18 4 18s997ms 4s749ms 19 5 3s763ms 752ms 20 3 2s186ms 728ms 21 3 3s425ms 1s141ms 22 4 3s269ms 817ms [ User: intelifix - Total duration: 1m11s - Times executed: 53 ]
[ Application: psql - Total duration: 1m11s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-28 18:00:19 Duration: 16s787ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-28 17:20:08 Duration: 6s896ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-28 10:20:06 Duration: 5s107ms Database: rio User: intelifix Remote: [local] Application: psql
20 151ms 4s12ms 950ms 67 1m3s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 28 07 13 12s285ms 945ms 08 2 4s323ms 2s161ms 09 2 5s156ms 2s578ms 10 3 2s433ms 811ms 11 2 879ms 439ms 12 8 6s87ms 760ms 13 4 3s930ms 982ms 14 4 2s87ms 521ms 15 9 14s802ms 1s644ms 16 15 9s450ms 630ms 17 5 2s266ms 453ms [ User: intelifix - Total duration: 1m3s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 67 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0138437) LIMIT 1;
Date: 2026-09-28 08:00:01 Duration: 4s12ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0288373) LIMIT 1;
Date: 2026-09-28 15:01:20 Duration: 3s945ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0291512) LIMIT 1;
Date: 2026-09-28 15:53:33 Duration: 3s418ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 341ms 2 164ms 176ms 170ms SELECT pro_id, pgp_sym_decrypt(nome, $1)::varchar, pgp_sym_decrypt(descricao, $1)::varchar, pgp_sym_decrypt(classe, $1)::varchar, pgp_sym_decrypt(php, $1)::varchar, pgp_sym_decrypt(extras, $1)::varchar from progs ORDER BY PRO_ID;Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 28 12 1 176ms 176ms 15 1 164ms 164ms [ User: lenon - Total duration: 653ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 653ms - Times executed: 2 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, $1)::varchar, pgp_sym_decrypt(descricao, $1)::varchar, pgp_sym_decrypt(classe, $1)::varchar, pgp_sym_decrypt(php, $1)::varchar, pgp_sym_decrypt(extras, $1)::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-28 12:21:06 Duration: 176ms Database: postgres User: brasilia Remote: lenon Application: [local] Queryid: [unknown]
-
SELECT pro_id, pgp_sym_decrypt(nome, $1)::varchar, pgp_sym_decrypt(descricao, $1)::varchar, pgp_sym_decrypt(classe, $1)::varchar, pgp_sym_decrypt(php, $1)::varchar, pgp_sym_decrypt(extras, $1)::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-28 15:05:00 Duration: 164ms Database: postgres User: contagem Remote: lenon Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 28 12 1 0ms 0ms 13 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 2s115ms - Times executed: 5 ]
[ User: lenon - Total duration: 653ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 1s593ms - Times executed: 5 ]
[ Application: psql - Total duration: 1s176ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,940 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 15 FATAL entries
- 3649 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,626 Max number of times the same event was reported
- 3,666 Total events found
Rank Times reported Error 1 3,626 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 28 00 59 01 60 02 60 03 59 04 60 05 59 06 60 07 170 08 414 09 438 10 380 11 268 12 59 13 139 14 256 15 366 16 208 17 134 18 94 19 63 20 60 21 57 22 56 23 47 - ERROR: prepared statement "_PLAN0000000029E90300" does not exist
- ERROR: prepared statement "_PLAN0000000029E2B960" does not exist
- ERROR: prepared statement "_PLAN0000000029E2A290" does not exist
Statement: DEALLOCATE "_PLAN0000000029E90300"
Date: 2026-09-28 00:00:55 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E2B960"
Date: 2026-09-28 00:01:55 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029E2A290"
Date: 2026-09-28 00:02:55 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 10 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 28 09 3 11 2 12 2 15 1 16 2 - ERROR: column "a8705d83376c" does not exist at character 27
- ERROR: column "a8705d83376c" does not exist at character 27
- ERROR: column "a8705d83376c" does not exist at character 27
Statement: select * from rs_caixa_qr(A8705D83376C)
Date: 2026-09-28 09:49:13 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(A8705D83376C)
Date: 2026-09-28 09:49:14 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(A8705D83376C)
Date: 2026-09-28 09:49:16 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
3 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 28 00 1 03 1 05 1 06 1 07 1 12 1 15 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-28 00:02:32 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-28 03:29:53 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-28 05:53:49 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 28 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-28 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-28 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-28 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 5 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 28 08 2 13 2 15 1 - ERROR: syntax error at or near "\" at character 35
- ERROR: syntax error at or near "\" at character 35
- ERROR: syntax error at or near "3727184" at character 35
Statement: select * from rs_caixa_qr(3725383 \)
Date: 2026-09-28 08:25:27 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3725383 \)
Date: 2026-09-28 08:25:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3727184 3727184 )
Date: 2026-09-28 13:27:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 28 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-28 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-28 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-28 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
7 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 28 08 2 - ERROR: trailing junk after numeric literal at or near "5447CCCA251B" at character 27
- ERROR: trailing junk after numeric literal at or near "5447CCCA251B" at character 27
Statement: select * from rs_caixa_qr(5447CCCA251B)
Date: 2026-09-28 08:44:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(5447CCCA251B)
Date: 2026-09-28 08:44:17 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 28 12 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000292678"
Date: 2026-09-28 12:28:41
9 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 28 03 1 - LOG: database system was shut down at 2026-09-28 03:05:02 -03
Date: 2026-09-28 03:05:02
10 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 28 15 1 - ERROR: unterminated quoted string at or near "''' )" at character 44
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0189, ''' )
Date: 2026-09-28 15:02:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 28 12 1 - LOG: process 1960093 still waiting for AccessExclusiveLock on relation 5493811 of database 358220 after 1000.103 ms
Detail: Process holding the lock: 1968810. Wait queue: 1960093.
Statement: DROP TABLE IF EXISTS temp0000292678;Date: 2026-09-28 12:28:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 28 03 1 - FATAL: the database system is shutting down
Date: 2026-09-28 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]