pgBadger-
Global information
- Generated on Thu Oct 1 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 40,378 log entries in 9s
- Log start from 2026-10-01 00:00:04 to 2026-10-01 23:50:05
-
Overview
Global Stats
- 328 Number of unique normalized queries
- 4,333 Number of queries
- 6h23m10s Total query duration
- 2026-10-01 00:00:12 First query
- 2026-10-01 23:42:38 Last query
- 6 queries/s at 2026-10-01 00:27:36 Query peak
- 6h23m10s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h23m10s Execute total duration
- 5,300 Number of events
- 12 Number of unique normalized events
- 5,246 Max number of times the same event was reported
- 0 Number of cancellation
- 371 Total number of automatic vacuums
- 871 Total number of automatic analyzes
- 20 Number temporary file
- 248.44 MiB Max size of temporary file
- 67.60 MiB Average size of temporary file
- 377 Total number of sessions
- 9 sessions at 2026-10-01 01:02:09 Session peak
- 13d20h37m9s Total duration of sessions
- 52m56s Average duration of sessions
- 11 Average queries per session
- 1m Average queries duration per session
- 51m55s Average idle time per session
- 380 Total number of connections
- 5 connections/s at 2026-10-01 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-10-01 00:27:36 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-10-01 09:23:41 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2026-10-01 00:27:36 Date
Queries duration
Key values
- 6h23m10s 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) Oct 01 00 331 0ms 1m3s 5s280ms 1m7s 1m11s 1m56s 01 33 0ms 2s939ms 826ms 3s477ms 3s869ms 4s967ms 02 18 0ms 2s861ms 1s287ms 3s75ms 4s204ms 4s742ms 03 17 0ms 4s42ms 1s420ms 3s173ms 4s362ms 4s675ms 04 18 0ms 2s785ms 1s366ms 3s397ms 4s24ms 5s420ms 05 30 0ms 9m15s 41s605ms 6s458ms 2m44s 9m15s 06 15 0ms 9s79ms 2s670ms 2s950ms 2s995ms 25s137ms 07 126 0ms 6m15s 10s860ms 35s787ms 3m41s 6m15s 08 319 0ms 5m30s 4s248ms 38s654ms 3m27s 5m53s 09 679 150ms 6m7s 3s172ms 56s739ms 4m26s 7m 10 458 151ms 5m31s 3s187ms 43s392ms 3m53s 6m26s 11 356 0ms 5m21s 2s963ms 27s703ms 31s35ms 6m8s 12 86 0ms 5m33s 12s443ms 19s875ms 3m31s 5m48s 13 219 0ms 5m17s 3s370ms 7s918ms 19s359ms 5m47s 14 364 150ms 5m38s 4s878ms 39s938ms 5m35s 5m55s 15 334 0ms 5m31s 3s970ms 27s43ms 3m35s 5m56s 16 241 0ms 5m21s 3s587ms 17s633ms 36s121ms 5m52s 17 129 0ms 6m48s 9s311ms 19s362ms 3m38s 7m1s 18 39 0ms 5m21s 16s298ms 3s168ms 23s744ms 5m52s 19 24 0ms 5m12s 24s373ms 3s96ms 3s370ms 5m56s 20 110 0ms 5m13s 10s330ms 1m1s 1m20s 6m55s 21 33 0ms 5m8s 17s791ms 3s936ms 5s611ms 5m52s 22 30 0ms 5m15s 19s808ms 4s382ms 15s579ms 5m45s 23 324 0ms 1m1s 6s12ms 1m5s 1m6s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 01 00 8 298 5s433ms 1m 1m4s 1m8s 01 14 0 245ms 0ms 196ms 668ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 8 0 262ms 0ms 153ms 669ms 06 0 0 0ms 0ms 0ms 0ms 07 58 0 18s544ms 1s556ms 3s942ms 5m55s 08 238 0 4s531ms 3s966ms 6s219ms 5m36s 09 552 0 2s926ms 12s385ms 34s670ms 5m32s 10 397 0 3s174ms 8s276ms 23s850ms 5m33s 11 263 0 3s124ms 6s505ms 19s189ms 3m40s 12 41 0 22s750ms 923ms 2s137ms 5m34s 13 176 0 3s814ms 2s846ms 4s708ms 3m31s 14 286 0 5s151ms 7s 23s767ms 5m39s 15 270 0 4s341ms 9s46ms 21s384ms 5m33s 16 187 0 4s153ms 6s343ms 17s633ms 3m30s 17 91 0 12s557ms 4s627ms 18s378ms 6m2s 18 19 0 31s1ms 0ms 676ms 3m36s 19 6 0 1m33s 0ms 0ms 3m25s 20 11 79 12s305ms 13s702ms 1m1s 3m25s 21 10 0 55s703ms 0ms 0ms 3m23s 22 6 0 1m34s 0ms 0ms 3m23s 23 4 320 6s12ms 1m1s 1m5s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 01 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 Oct 01 00 0 1 1.00 0.00% 01 0 2 2.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 2 2.00 0.00% 06 0 0 0.00 0.00% 07 0 8 8.00 0.00% 08 0 10 10.00 0.00% 09 0 10 10.00 0.00% 10 0 7 7.00 0.00% 11 0 7 7.00 0.00% 12 0 3 3.00 0.00% 13 0 10 10.00 0.00% 14 0 9 9.00 0.00% 15 0 9 9.00 0.00% 16 0 8 8.00 0.00% 17 0 3 3.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.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 Oct 01 00 22 0.01/s 01 12 0.00/s 02 10 0.00/s 03 17 0.00/s 04 9 0.00/s 05 11 0.00/s 06 11 0.00/s 07 17 0.00/s 08 22 0.01/s 09 24 0.01/s 10 22 0.01/s 11 17 0.00/s 12 17 0.00/s 13 21 0.01/s 14 18 0.01/s 15 22 0.01/s 16 24 0.01/s 17 14 0.00/s 18 11 0.00/s 19 11 0.00/s 20 15 0.00/s 21 10 0.00/s 22 9 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Oct 01 00 16 39m43s 37m54s 01 19 59m25s 59m24s 02 11 1h16s 1h14s 03 20 22m30s 22m29s 04 7 1h3m 1h2m56s 05 9 54m27s 52m8s 06 10 58m48s 58m44s 07 13 53m55s 52m10s 08 16 57m11s 55m46s 09 24 55m41s 54m11s 10 23 52m6s 51m2s 11 21 55m46s 54m56s 12 16 54m28s 53m21s 13 16 57m18s 56m31s 14 21 58m18s 56m53s 15 19 56m12s 55m2s 16 22 49m42s 49m2s 17 21 55m43s 54m46s 18 12 58m52s 57m59s 19 11 1h45s 59m51s 20 14 48m23s 47m2s 21 11 1h 59m6s 22 10 1h49s 59m50s 23 15 38m10s 36m -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-10-01 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 380 connections Total
Connections per user
Key values
- intelifix Main User
- 380 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-10-01 01:02:09 Date
Histogram of session times
Key values
- 304 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 377 sessions Total
Sessions per user
Key values
- intelifix Main User
- 377 sessions Total
Sessions per host
Key values
- [local] Main Host
- 377 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,436 buffers Checkpoint Peak
- 2026-10-01 17:04:39 Date
- 270.073 seconds Highest write time
- 0.029 seconds Sync time
Checkpoints Wal files
Key values
- 8 files Wal files usage Peak
- 2026-10-01 17:04:39 Date
Checkpoints distance
Key values
- 250.10 Mo Distance Peak
- 2026-10-01 10:04:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 01 00 3,987 372.335s 0.015s 372.37s 01 2,945 295.037s 0.027s 295.087s 02 2,861 286.786s 0.017s 286.819s 03 1,720 172.356s 0.023s 172.398s 04 2,184 218.844s 0.013s 218.875s 05 9,884 989.418s 0.029s 989.478s 06 1,685 168.404s 0.001s 168.408s 07 21,254 1,643.312s 0.051s 1,643.419s 08 47,015 3,097.414s 0.114s 3,097.602s 09 53,703 3,239.432s 0.167s 3,239.688s 10 56,005 3,239.504s 0.141s 3,239.72s 11 46,382 3,183.437s 0.139s 3,183.649s 12 19,861 1,594.94s 0.048s 1,595.038s 13 24,505 1,932.005s 0.083s 1,932.133s 14 45,538 3,225.493s 0.174s 3,225.737s 15 44,994 3,147.515s 0.117s 3,147.702s 16 29,757 2,858.507s 0.109s 2,858.68s 17 43,596 2,293.153s 0.104s 2,293.307s 18 5,317 539.073s 0.027s 539.124s 19 31 3.114s 0.002s 3.117s 20 1,447 151.103s 0.008s 151.119s 21 2,910 291.621s 0.021s 291.673s 22 2,344 234.679s 0.012s 234.715s 23 281 28.204s 0.01s 28.233s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 01 00 0 0 6 562 0.002s 0.007s 01 0 0 1 681 0.005s 0.009s 02 0 0 1 395 0.003s 0.006s 03 0 0 0 369 0.003s 0.007s 04 0 0 1 392 0.002s 0.006s 05 0 0 4 712 0.011s 0.009s 06 0 0 1 16 0.001s 0.001s 07 0 0 20 2,342 0.002s 0.012s 08 0 0 30 5,882 0.003s 0.012s 09 0 0 49 7,633 0.003s 0.012s 10 0 0 33 6,976 0.008s 0.012s 11 0 0 29 6,756 0.003s 0.012s 12 0 0 15 2,822 0.002s 0.012s 13 0 0 10 4,091 0.002s 0.012s 14 0 0 31 6,828 0.004s 0.012s 15 0 0 29 6,797 0.005s 0.012s 16 0 0 14 5,801 0.003s 0.012s 17 0 0 22 4,002 0.007s 0.012s 18 0 0 1 761 0.002s 0.01s 19 0 0 0 7 0.002s 0.001s 20 0 0 1 86 0.002s 0.003s 21 0 0 1 481 0.002s 0.011s 22 0 0 0 408 0.002s 0.008s 23 0 0 1 35 0.002s 0.007s Day Hour Count Avg time (sec) Oct 01 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 Oct 01 00 14,478.14 kB 41,005.86 kB 01 1,537.67 kB 19,237.22 kB 02 1,735.83 kB 9,537.33 kB 03 1,009.12 kB 2,069.00 kB 04 1,413.83 kB 1,831.50 kB 05 7,813.22 kB 15,211.00 kB 06 6,385.00 kB 12,872.00 kB 07 28,507.00 kB 55,537.33 kB 08 39,751.17 kB 78,884.00 kB 09 67,089.58 kB 101,139.50 kB 10 46,020.17 kB 93,385.17 kB 11 38,708.83 kB 76,253.33 kB 12 21,340.67 kB 56,818.17 kB 13 12,427.00 kB 26,765.50 kB 14 42,941.67 kB 72,903.25 kB 15 40,206.50 kB 88,660.92 kB 16 18,601.00 kB 49,418.75 kB 17 29,880.17 kB 85,024.92 kB 18 2,384.80 kB 30,748.90 kB 19 206.00 kB 16,842.00 kB 20 2,866.00 kB 14,347.00 kB 21 1,210.64 kB 7,798.91 kB 22 1,483.25 kB 3,650.25 kB 23 135.00 kB 2,077.57 kB -
Temporary Files
Size of temporary files
Key values
- 496.88 MiB Temp Files size Peak
- 2026-10-01 05:31:54 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-01 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 01 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.60 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 37.05 MiB 248.44 MiB 65.20 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-01 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-01 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 308.75 MiB 57.39 MiB 94.45 MiB 77.19 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-01 05:30:40 Duration: 38s602ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-01 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 248.44 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 248.44 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 94.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-01 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 94.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-01 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 62.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-01 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 57.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-01 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 41.04 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 37.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 37.06 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-01 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.55 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-01 16:39:41 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 1.55 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database rio - 2026-10-01 16:39:41 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (94) Main table analyzed (database rio)
- 871 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 94 rio.pg_catalog.pg_class 48 rio.public.usuarios 46 contagem.public.temp0000227370 44 rio.pg_catalog.pg_type 40 rio.public.temp0000292986 39 rio.public.temp0000293068 39 brasilia.pg_catalog.pg_attribute 38 rio.auditor.auditor_2026_10 28 contagem.pg_catalog.pg_attribute 28 rio.pg_catalog.pg_index 25 brasilia.auditor.auditor_2026_10 23 contagem.public.usuarios 20 contagem.auditor.auditor_2026_10 18 brasilia.pg_catalog.pg_class 17 rio.pg_catalog.pg_depend 17 rio.public.temp0000293138 16 contagem.pg_catalog.pg_class 15 rio.public.temp0000293120 15 brasilia.pg_catalog.pg_type 15 rio.public.temp0000293094 14 contagem.pg_catalog.pg_type 13 brasilia.public.temp0000241340 11 contagem.public.temp0000227256 11 brasilia.public.usuarios 10 rio.public.temp0000293060 9 brasilia.pg_catalog.pg_index 9 contagem.pg_catalog.pg_index 8 rio.public.temp0000293070 7 brasilia.public.temp0000241338 7 brasilia.pg_catalog.pg_depend 7 rio.public.temp0000293116 7 rio.public.temp0000293058 7 rio.public.temp0000292754 6 contagem.pg_catalog.pg_depend 6 rio.public.temp0000293100 5 rio.public.temp0000292760 5 rio.public.tmp_drill_0175 5 contagem.public.temp0000227376 4 brasilia.public.temp0000241346 4 brasilia.public.temp0000241408 4 rio.public.tmp_drill_0302 4 rio.public.temp0000293128 4 contagem.public.temp0000227384 4 rio.pg_catalog.pg_shdepend 4 brasilia.public.temp0000241360 4 brasilia.public.temp0000241404 3 brasilia.public.temp0000241376 3 brasilia.public.nf_entrada 3 brasilia.public.temp0000241384 3 brasilia.public.temp0000241422 3 rio.public.temp0000293000 3 brasilia.public.temp0000241374 3 contagem.public.nf_entrada 3 rio.public.temp0000293098 2 brasilia.public.temp0000241368 2 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000293084 2 brasilia.public.temp0000241400 2 brasilia.public.temp0000241348 2 rio.public.temp0000293080 2 rio.public.temp0000293040 2 contagem.public.temp0000227380 2 contagem.public.temp0000227388 2 rio.public.temp0000293126 1 rio.public.temp0000293062 1 brasilia.public.temp0000241418 1 rio.public.temp0000293118 1 rio.public.temp0000293082 1 brasilia.public.temp0000241420 1 brasilia.public.temp0000241398 1 rio.public.temp0000293064 1 rio.public.temp0000293086 1 contagem.public.temp0000227378 1 brasilia.public.temp0000241354 1 brasilia.public.temp0000241424 1 brasilia.public.temp0000241378 1 rio.public.temp0000293066 1 contagem.public.temp0000227372 1 rio.public.temp0000293102 1 rio.public.temp0000293088 1 brasilia.public.temp0000241394 1 template1.pg_catalog.pg_shdepend 1 contagem.public.temp0000227392 1 rio.public.temp0000293090 1 contagem.pg_catalog.pg_shdepend 1 brasilia.public.temp0000241342 1 Total 871 Vacuums per table
Key values
- public.temp0000293068 (39) Main table vacuumed on database rio
- 371 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000293068 39 0 0 0 0 0 0 32,723 405 2,387,595 0 0 rio.pg_catalog.pg_attribute 30 30 0 0 0 0 0 16,962 4,794 7,110,213 251 6,197 rio.public.temp0000292986 28 0 0 0 0 0 0 8,717 348 871,410 0 0 contagem.public.usuarios 20 0 0 0 0 0 0 90 69 39,730 2 2 rio.pg_catalog.pg_class 16 16 0 0 0 0 0 3,180 1,108 1,651,894 61 268 rio.auditor.auditor_2026_10 15 0 0 0 0 0 0 48,790 31,640 38,829,018 7,006 129,995 rio.public.temp0000293120 14 0 0 0 0 0 0 23,942 3,731 6,178,443 0 0 rio.pg_catalog.pg_type 14 14 0 0 0 0 0 1,502 468 705,255 43 175 brasilia.pg_catalog.pg_attribute 12 12 0 0 0 0 0 6,820 1,548 2,735,778 49 1,540 brasilia.auditor.auditor_2026_10 12 0 0 0 0 0 0 19,684 10,081 12,995,398 3,264 63,999 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 7,024 1,723 3,101,212 31 794 contagem.auditor.auditor_2026_10 9 0 0 0 0 0 0 10,089 5,450 6,748,580 1,074 18,967 rio.pg_catalog.pg_index 8 8 0 0 0 0 0 543 151 170,477 33 65 rio.pg_catalog.pg_depend 7 7 0 0 0 0 0 2,691 946 1,470,177 62 475 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 541 131 208,683 11 33 rio.public.temp0000292754 6 0 0 0 0 0 0 545 159 258,002 0 0 brasilia.pg_catalog.pg_class 6 6 0 0 0 0 0 1,139 245 454,435 20 60 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,217 259 423,300 13 35 rio.public.temp0000293070 6 0 0 0 0 0 0 279 79 93,023 0 0 testes.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 1,291 393 910,414 50 84 rio.public.temp0000292760 5 0 0 0 0 0 0 415 23 27,987 0 0 rio.public.tmp_drill_0175 5 5 0 0 0 0 0 894 71 226,520 1 38 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 516 114 197,987 8 20 rio.pg_catalog.pg_statistic 5 5 0 0 0 0 0 7,137 1,517 6,886,289 797 3,635 rio.public.temp0000293094 5 0 0 0 0 0 0 2,094 28 127,566 0 0 rio.public.usuarios 4 4 0 0 0 0 0 120 72 179,808 15 20 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 218 54 88,055 2 7 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,267 333 752,844 13 113 brasilia.public.temp0000241408 4 0 0 0 0 0 0 1,028 16 63,064 0 0 rio.public.tmp_drill_0302 4 3 0 0 0 0 0 134 28 49,399 1 74 contagem.public.temp0000227376 4 0 0 0 0 0 0 468 24 31,509 0 0 brasilia.public.temp0000241346 4 0 0 0 0 0 0 1,025 16 62,930 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 127 25 37,840 7 21 brasilia.public.temp0000241384 3 0 0 0 0 0 0 772 265 442,060 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 946 266 435,454 11 220 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,320 1,445 5,093,366 1,168 7,421 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,596 305 1,679,197 107 340 rio.public.temp0000293000 2 0 0 0 0 0 0 172 10 11,575 0 0 rio.public.temp0000293080 2 0 0 0 0 0 0 85 11 6,726 0 0 rio.public.temp0000293040 2 0 0 0 0 0 0 1,918 1,847 2,491,858 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,929 184 774,003 157 1,358 contagem.public.temp0000227388 2 0 0 0 0 0 0 235 122 202,587 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 218 25 109,708 6 11 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 366 110 471,320 38 103 rio.public.temp0000293084 2 0 0 0 0 0 0 159 12 11,174 0 0 brasilia.public.temp0000241400 2 0 0 0 0 0 0 514 8 31,532 0 0 rio.public.temp0000293138 2 0 0 0 0 0 0 241 10 15,758 0 0 contagem.public.temp0000227392 1 0 0 0 0 0 0 118 6 7,940 0 0 brasilia.public.temp0000241378 1 0 0 0 0 0 0 256 4 15,707 0 0 rio.public.temp0000293088 1 0 0 0 0 0 0 8 5 1,285 0 0 rio.public.temp0000293102 1 0 0 0 0 0 0 62 6 4,508 0 0 contagem.public.temp0000227370 1 0 0 0 0 0 0 117 6 7,880 0 0 brasilia.public.temp0000241394 1 0 0 0 0 0 0 68 4 4,615 0 0 rio.public.temp0000293082 1 0 0 0 0 0 0 77 6 5,438 0 0 rio.public.temp0000293064 1 0 0 0 0 0 0 8 5 1,284 0 0 brasilia.public.temp0000241398 1 0 0 0 0 0 0 257 4 15,766 0 0 contagem.public.temp0000227384 1 0 0 0 0 0 0 117 6 7,880 0 0 brasilia.public.temp0000241424 1 0 0 0 0 0 0 257 4 15,766 0 0 contagem.public.temp0000227378 1 0 0 0 0 0 0 117 6 7,880 0 0 rio.public.temp0000293086 1 0 0 0 0 0 0 77 75 144,144 0 0 brasilia.public.temp0000241368 1 0 0 0 0 0 0 256 4 15,707 0 0 Total 371 168 0 0 0 0 0 219,478 70,810 108,106,953 14,301 236,070 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (8.54) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000293068 0 0 0.85 rio.pg_catalog.pg_attribute 0 0 2.1 rio.public.temp0000292986 0 0 0.24 contagem.public.usuarios 0 0 0.01 rio.pg_catalog.pg_class 0 0 0.61 rio.auditor.auditor_2026_10 0 0 8.54 rio.public.temp0000293120 0 0 0.61 rio.pg_catalog.pg_type 0 0 0.14 brasilia.pg_catalog.pg_attribute 0 0 1.1 brasilia.auditor.auditor_2026_10 0 0 2.69 contagem.pg_catalog.pg_attribute 0 0 1.02 contagem.auditor.auditor_2026_10 0 0 1.45 rio.pg_catalog.pg_index 0 0 0.18 rio.pg_catalog.pg_depend 0 0 0.49 brasilia.pg_catalog.pg_type 0 0 0.06 rio.public.temp0000292754 0 0 0.01 brasilia.pg_catalog.pg_class 0 0 0.17 contagem.pg_catalog.pg_class 0 0 0.49 rio.public.temp0000293070 0 0 0 testes.pg_catalog.pg_shdepend 0 0 0.49 rio.public.temp0000292760 0 0 0 rio.public.tmp_drill_0175 0 0 0.01 contagem.pg_catalog.pg_type 0 0 0.29 rio.pg_catalog.pg_statistic 0 0 0.9 rio.public.temp0000293094 0 0 0.05 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_index 0 0 0.17 contagem.pg_catalog.pg_depend 0 0 0.39 brasilia.public.temp0000241408 0 0 0 rio.public.tmp_drill_0302 0 0 0.02 contagem.public.temp0000227376 0 0 0 brasilia.public.temp0000241346 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.03 brasilia.public.temp0000241384 0 0 0.06 brasilia.pg_catalog.pg_depend 0 0 0.21 brasilia.pg_catalog.pg_statistic 0 0 0.44 rio.pg_toast.pg_toast_2619 0 0 0.17 rio.public.temp0000293000 0 0 0 rio.public.temp0000293080 0 0 0 rio.public.temp0000293040 0 0 0.06 contagem.pg_catalog.pg_statistic 0 0 0.22 contagem.public.temp0000227388 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000293084 0 0 0.01 brasilia.public.temp0000241400 0 0 0 rio.public.temp0000293138 0 0 0 contagem.public.temp0000227392 0 0 0 brasilia.public.temp0000241378 0 0 0 rio.public.temp0000293088 0 0 0 rio.public.temp0000293102 0 0 0 contagem.public.temp0000227370 0 0 0 brasilia.public.temp0000241394 0 0 0 rio.public.temp0000293082 0 0 0 rio.public.temp0000293064 0 0 0 brasilia.public.temp0000241398 0 0 0 contagem.public.temp0000227384 0 0 0 brasilia.public.temp0000241424 0 0 0 contagem.public.temp0000227378 0 0 0 rio.public.temp0000293086 0 0 0 brasilia.public.temp0000241368 0 0 0 Total 0 0 24.32 Tuples removed per table
Key values
- pg_catalog.pg_attribute (116592) Main table with removed tuples on database rio
- 275846 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 30 30 116,592 719,462 5,749 0 17,332 brasilia.pg_catalog.pg_attribute 12 12 51,044 279,949 34 38 7,326 contagem.pg_catalog.pg_attribute 10 10 45,341 244,302 0 39 5,565 rio.pg_catalog.pg_statistic 5 5 9,850 40,772 0 0 6,430 rio.public.tmp_drill_0175 5 5 9,230 13,130 0 0 334 brasilia.pg_catalog.pg_statistic 3 3 6,027 23,735 0 1 3,214 rio.pg_catalog.pg_depend 7 7 5,621 134,173 32 0 1,253 contagem.pg_catalog.pg_statistic 2 2 5,411 14,760 0 0 2,022 testes.pg_catalog.pg_shdepend 5 5 4,432 90,550 375 0 750 rio.pg_catalog.pg_type 14 14 3,948 32,102 298 4 988 contagem.pg_catalog.pg_type 5 5 2,675 11,265 0 0 349 rio.pg_catalog.pg_class 16 16 2,432 58,242 855 10 2,085 rio.pg_catalog.pg_index 8 8 1,880 15,414 38 7 448 contagem.pg_catalog.pg_depend 4 4 1,703 76,195 0 0 712 brasilia.pg_catalog.pg_type 6 6 1,555 13,272 2 10 395 contagem.public.usuarios 20 0 1,208 480 0 0 40 contagem.pg_catalog.pg_index 4 4 1,150 7,597 0 0 206 contagem.pg_catalog.pg_class 6 6 1,122 20,940 0 22 869 rio.pg_toast.pg_toast_2619 3 3 1,045 1,973 1 13 835 brasilia.pg_catalog.pg_depend 3 3 787 55,498 6 0 506 brasilia.pg_catalog.pg_index 3 3 775 5,652 1 0 155 brasilia.pg_catalog.pg_class 6 6 661 23,333 4 37 803 rio.public.usuarios 4 4 590 2,054 18 0 76 rio.public.tmp_drill_0302 4 3 331 53,269 25,801 0 694 brasilia.pg_toast.pg_toast_2619 2 2 216 279 1 10 134 contagem.pg_toast.pg_toast_2619 2 2 181 239 0 0 118 brasilia.auditor.auditor_2026_10 12 0 39 1,283,721 0 0 55,934 contagem.public.temp0000227392 1 0 0 1,404 0 18 110 rio.public.temp0000292760 5 0 0 20,283 0 55 457 rio.public.temp0000293000 2 0 0 7,206 0 25 167 rio.public.temp0000293068 39 0 0 521,867 0 1,155 36,669 rio.public.temp0000293080 2 0 0 2,555 0 117 139 brasilia.public.temp0000241378 1 0 0 3,365 0 0 256 rio.public.temp0000293088 1 0 0 1,277 0 59 69 rio.public.temp0000293102 1 0 0 2,446 0 10 54 rio.public.temp0000293040 2 0 0 27,392 0 59 1,925 rio.public.temp0000292754 6 0 0 22,715 0 132 508 brasilia.public.temp0000241384 3 0 0 10,107 0 0 768 contagem.public.temp0000227370 1 0 0 1,401 0 19 109 contagem.public.temp0000227388 2 0 0 2,806 0 37 219 rio.public.temp0000293120 14 0 0 365,697 0 0 25,984 brasilia.public.temp0000241394 1 0 0 3,032 0 0 64 brasilia.public.temp0000241408 4 0 0 13,476 0 0 1,024 contagem.auditor.auditor_2026_10 9 0 0 716,626 0 0 29,851 rio.public.temp0000293082 1 0 0 1,275 0 59 69 rio.public.temp0000293094 5 0 0 36,035 0 35 2,077 rio.public.temp0000293064 1 0 0 1,271 0 60 68 rio.public.temp0000292986 28 0 0 185,986 0 986 10,982 brasilia.public.temp0000241398 1 0 0 3,369 0 0 256 rio.public.temp0000293084 2 0 0 2,580 0 113 143 brasilia.public.temp0000241400 2 0 0 6,738 0 0 512 contagem.public.temp0000227384 1 0 0 1,402 0 19 109 brasilia.public.temp0000241424 1 0 0 3,369 0 0 256 contagem.public.temp0000227378 1 0 0 1,402 0 19 109 rio.public.temp0000293086 1 0 0 1,277 0 59 69 contagem.public.temp0000227376 4 0 0 5,606 0 76 436 rio.public.temp0000293138 2 0 0 10,298 0 26 230 rio.auditor.auditor_2026_10 15 0 0 3,375,256 0 0 173,038 brasilia.public.temp0000241346 4 0 0 13,460 0 0 1,024 rio.public.temp0000293070 6 0 0 10,432 0 121 231 brasilia.public.temp0000241368 1 0 0 3,365 0 0 256 Total 371 168 275,846 8,609,134 33,215 3,450 397,811 Pages removed per table
Key values
- public.temp0000293068 (1155) Main table with removed pages on database rio
- 3450 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000293068 39 0 0 1155 rio.public.temp0000292986 28 0 0 986 rio.public.temp0000292754 6 0 0 132 rio.public.temp0000293070 6 0 0 121 rio.public.temp0000293080 2 0 0 117 rio.public.temp0000293084 2 0 0 113 contagem.public.temp0000227376 4 0 0 76 rio.public.temp0000293064 1 0 0 60 rio.public.temp0000293088 1 0 0 59 rio.public.temp0000293040 2 0 0 59 rio.public.temp0000293082 1 0 0 59 rio.public.temp0000293086 1 0 0 59 rio.public.temp0000292760 5 0 0 55 contagem.pg_catalog.pg_attribute 10 10 45341 39 brasilia.pg_catalog.pg_attribute 12 12 51044 38 brasilia.pg_catalog.pg_class 6 6 661 37 contagem.public.temp0000227388 2 0 0 37 rio.public.temp0000293094 5 0 0 35 rio.public.temp0000293138 2 0 0 26 rio.public.temp0000293000 2 0 0 25 contagem.pg_catalog.pg_class 6 6 1122 22 contagem.public.temp0000227370 1 0 0 19 contagem.public.temp0000227384 1 0 0 19 contagem.public.temp0000227378 1 0 0 19 contagem.public.temp0000227392 1 0 0 18 rio.pg_toast.pg_toast_2619 3 3 1045 13 brasilia.pg_catalog.pg_type 6 6 1555 10 rio.pg_catalog.pg_class 16 16 2432 10 rio.public.temp0000293102 1 0 0 10 brasilia.pg_toast.pg_toast_2619 2 2 216 10 rio.pg_catalog.pg_index 8 8 1880 7 rio.pg_catalog.pg_type 14 14 3948 4 brasilia.pg_catalog.pg_statistic 3 3 6027 1 testes.pg_catalog.pg_shdepend 5 5 4432 0 brasilia.pg_catalog.pg_index 3 3 775 0 rio.public.usuarios 4 4 590 0 rio.pg_catalog.pg_depend 7 7 5621 0 rio.public.tmp_drill_0175 5 5 9230 0 contagem.pg_catalog.pg_type 5 5 2675 0 brasilia.public.temp0000241378 1 0 0 0 contagem.pg_catalog.pg_index 4 4 1150 0 contagem.pg_catalog.pg_depend 4 4 1703 0 contagem.pg_catalog.pg_statistic 2 2 5411 0 brasilia.public.temp0000241384 3 0 0 0 rio.pg_catalog.pg_statistic 5 5 9850 0 rio.public.temp0000293120 14 0 0 0 brasilia.public.temp0000241394 1 0 0 0 contagem.pg_toast.pg_toast_2619 2 2 181 0 brasilia.public.temp0000241408 4 0 0 0 contagem.auditor.auditor_2026_10 9 0 0 0 contagem.public.usuarios 20 0 1208 0 brasilia.pg_catalog.pg_depend 3 3 787 0 rio.public.tmp_drill_0302 4 3 331 0 brasilia.public.temp0000241398 1 0 0 0 brasilia.public.temp0000241400 2 0 0 0 brasilia.public.temp0000241424 1 0 0 0 rio.pg_catalog.pg_attribute 30 30 116592 0 brasilia.auditor.auditor_2026_10 12 0 39 0 rio.auditor.auditor_2026_10 15 0 0 0 brasilia.public.temp0000241346 4 0 0 0 brasilia.public.temp0000241368 1 0 0 0 Total 371 168 275,846 3,450 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 01 00 3 3 01 1 7 02 0 1 03 0 1 04 1 0 05 6 3 06 0 0 07 21 33 08 42 103 09 66 169 10 33 90 11 51 112 12 5 16 13 11 40 14 45 91 15 38 81 16 25 76 17 21 41 18 1 1 19 0 0 20 0 0 21 1 3 22 0 0 23 0 0 - 1.55 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 6s326ms 6s326ms 6s326ms 6s326ms select * from rs_auditor_novas_tabelas ();-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-01 00:02:08 Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-01 00:02:09 Database: contagem User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-10-01 00:02:09 Database: brasilia User: lenon Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 6s326ms SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-10-01 00:02:08 - Database: rio - User: lenon - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 2,645 Total read queries
- 1,142 Total write queries
Queries by database
Key values
- rio Main database
- 2,141 Requests
- 4h32m6s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,399 1h39m51s copy to 249 20m10s ddl 128 1m34s others 253 9m34s select 769 1h8m31s contagem Total 792 11m12s copy to 213 2m14s ddl 38 28s979ms others 6 2m58s select 535 5m29s rio Total 2,141 4h32m6s copy to 235 46m36s ddl 279 27m7s others 287 24m30s select 1,340 2h53m52s testes Total 1 159ms select 1 159ms Queries by user
Key values
- intelifix Main user
- 4,232 Requests
User Request type Count Duration etiquetas Total 9 3s66ms select 9 3s66ms intelifix Total 4,232 6h22m32s copy to 697 1h9m2s ddl 445 29m10s others 546 37m3s select 2,544 4h7m15s lenon Total 92 34s921ms select 92 34s921ms Duration by user
Key values
- 6h22m32s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 9 3s66ms select 9 3s66ms intelifix Total 4,232 6h22m32s copy to 697 1h9m2s ddl 445 29m10s others 546 37m3s select 2,544 4h7m15s lenon Total 92 34s921ms select 92 34s921ms Queries by host
Key values
- [local] Main host
- 4,333 Requests
- 6h23m10s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 2,920 Requests
- 3h15m36s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-01 10:31:31 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,305 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m15s analyze verbose;[ Date: 2026-10-01 05:09:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 6m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030682, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');[ Date: 2026-10-01 17:04:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 6m18s analyze verbose;[ Date: 2026-10-01 05:15:35 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 07:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 09:11:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 5m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030642, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 07:53:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030676, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 14:48:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030671, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 14:22:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030668, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 12:02:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030663, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 10:20:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030678, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 15:02:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030647, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 09:01:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030646, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-10-01 08:30:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 10:10:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 15:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 17:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 16:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 11:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 18:10:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-01 14:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h32m 48 2s132ms 6m15s 1m55s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 01 07 3 6m45s 2m15s 08 3 5m33s 1m51s 09 3 6m25s 2m8s 10 3 5m50s 1m56s 11 3 5m41s 1m53s 12 3 5m37s 1m52s 13 3 5m34s 1m51s 14 3 5m36s 1m52s 15 3 5m43s 1m54s 16 3 5m41s 1m53s 17 3 5m50s 1m56s 18 3 5m41s 1m53s 19 3 5m29s 1m49s 20 3 5m30s 1m50s 21 3 5m25s 1m48s 22 3 5m33s 1m51s [ User: intelifix - Total duration: 1h32m - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 07:11:17 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 09:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 10:10:31 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
2 1h3m50s 48 233ms 3m35s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 01 07 3 4m26s 1m28s 08 3 3m51s 1m17s 09 3 4m 1m20s 10 3 4m3s 1m21s 11 3 4m6s 1m22s 12 3 3m59s 1m19s 13 3 3m57s 1m19s 14 3 3m58s 1m19s 15 3 4m2s 1m20s 16 3 3m56s 1m18s 17 3 3m59s 1m19s 18 3 4m1s 1m20s 19 3 3m51s 1m17s 20 3 3m53s 1m17s 21 3 3m50s 1m16s 22 3 3m50s 1m16s [ User: intelifix - Total duration: 1h3m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 07:16:07 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 11:14:44 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 18:14:40 Duration: 3m31s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1h2m20s 130 169ms 6m48s 28s771ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 01 07 4 5m58s 1m29s 08 8 6m30s 48s759ms 09 13 11m3s 51s42ms 10 24 6m24s 16s4ms 11 16 44s602ms 2s787ms 12 1 5m33s 5m33s 13 13 8s210ms 631ms 14 18 11m25s 38s89ms 15 12 5m48s 29s65ms 16 8 53s84ms 6s635ms 17 12 7m50s 39s196ms 18 1 315ms 315ms [ User: intelifix - Total duration: 1h2m20s - Times executed: 130 ]
[ Application: [unknown] - Total duration: 1h2m20s - Times executed: 130 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030682, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-10-01 17:04:34 Duration: 6m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030642, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-01 07:53:59 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030676, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-01 14:48:53 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m18s 3 2m44s 9m15s 6m6s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 01 05 3 18m18s 6m6s [ User: intelifix - Total duration: 18m18s - Times executed: 3 ]
[ Application: psql - Total duration: 18m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-01 05:09:16 Duration: 9m15s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-01 05:15:35 Duration: 6m18s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-01 05:18:19 Duration: 2m44s Database: contagem User: intelifix Remote: [local] Application: psql
5 12m44s 67 10s609ms 22s80ms 11s408ms create table temp0000293068 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 01 07 14 2m43s 11s668ms 08 13 2m22s 10s940ms 09 11 2m5s 11s418ms 10 6 1m13s 12s239ms 11 3 33s423ms 11s141ms 12 6 1m7s 11s225ms 14 12 2m15s 11s320ms 15 2 23s87ms 11s543ms [ User: intelifix - Total duration: 12m44s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 12m44s - Times executed: 67 ]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 07:19:22 Duration: 22s80ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 10:09:05 Duration: 16s252ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 09:46:19 Duration: 13s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 8m59s 76 1s597ms 39s492ms 7s104ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 01 07 2 5s368ms 2s684ms 08 1 1s597ms 1s597ms 09 7 1m2s 8s914ms 10 9 1m44s 11s569ms 11 10 1m1s 6s156ms 12 5 9s329ms 1s865ms 13 4 17s471ms 4s367ms 14 6 1m16s 12s734ms 15 15 1m57s 7s835ms 16 10 1m2s 6s213ms 17 7 22s19ms 3s145ms [ User: intelifix - Total duration: 8m59s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 8m59s - Times executed: 76 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 09:45:45 Duration: 39s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 10:50:32 Duration: 36s86ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-01', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 15:42:18 Duration: 23s523ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 7m58s 820 150ms 3s547ms 583ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 01 07 9 2s939ms 326ms 08 70 46s463ms 663ms 09 145 1m29s 619ms 10 124 1m10s 572ms 11 97 48s840ms 503ms 12 12 6s879ms 573ms 13 61 38s224ms 626ms 14 105 57s444ms 547ms 15 79 43s233ms 547ms 16 78 36s626ms 469ms 17 33 32s931ms 997ms 18 7 3s755ms 536ms [ User: intelifix - Total duration: 7m58s - Times executed: 820 ]
[ Application: [unknown] - Total duration: 7m58s - Times executed: 820 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291879, 503, '517144003746,B0DAF94C20ED,CC75E2BB93AB,F8F53255EDF2,5819F840D94D,BC644BE1C060,BC644BC1B752,F8F53258AB5F,2C584F35F725,2C9569F63132,BC644BCCC0B1,B0935BECA0BA,5819F84610B1,BC644BC3E6E4,5819F84298E1,2C584F33C49B,B0DAF9516C29,2C584F2F61FD', '',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":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-01 08:30:13 Duration: 3s547ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (138862, 397, '254293117675465,216368366565,216451335976,216840236377,216671310711,216564826771,216667982440,216728839602,216662356267,216855235978,216847377489,216841871330,216665371321,216645452845,216368324665', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-01 13:31:42 Duration: 3s373ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291854, 317, '71821285850057303454,216875606069,216400004356,216701557287,216908645152,216704304660H010954896,216631264647,216701004753,216837201626H011600346,216628217593,216832008100,216355774955H010977693,216633544264', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-01 16:00:58 Duration: 3s246ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 7m33s 276 183ms 6s515ms 1s643ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 01 00 12 34s283ms 2s856ms 01 12 17s696ms 1s474ms 02 12 17s680ms 1s473ms 03 12 18s848ms 1s570ms 04 12 17s449ms 1s454ms 05 12 18s109ms 1s509ms 06 12 17s896ms 1s491ms 07 12 18s137ms 1s511ms 08 12 21s354ms 1s779ms 09 12 19s957ms 1s663ms 10 12 19s202ms 1s600ms 11 12 19s46ms 1s587ms 12 12 18s783ms 1s565ms 13 12 18s900ms 1s575ms 14 12 19s859ms 1s654ms 15 12 19s732ms 1s644ms 16 12 19s88ms 1s590ms 17 12 19s619ms 1s634ms 18 12 18s669ms 1s555ms 19 12 18s985ms 1s582ms 20 12 22s848ms 1s904ms 21 12 18s573ms 1s547ms 22 12 18s866ms 1s572ms [ User: intelifix - Total duration: 7m33s - Times executed: 276 ]
[ Application: psql - Total duration: 7m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:25:07 Duration: 6s515ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:05:18 Duration: 6s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:15:09 Duration: 5s749ms Database: rio User: intelifix Remote: [local] Application: psql
9 4m57s 164 155ms 10s378ms 1s816ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 01 00 6 17s614ms 2s935ms 01 6 5s775ms 962ms 02 6 5s499ms 916ms 03 5 5s293ms 1s58ms 04 6 7s143ms 1s190ms 05 5 8s114ms 1s622ms 07 11 24s641ms 2s240ms 08 12 28s855ms 2s404ms 09 12 32s916ms 2s743ms 10 12 25s617ms 2s134ms 11 12 25s498ms 2s124ms 12 12 25s374ms 2s114ms 13 8 6s194ms 774ms 14 11 20s713ms 1s883ms 15 12 26s144ms 2s178ms 16 10 14s988ms 1s498ms 17 6 3s783ms 630ms 20 1 698ms 698ms 21 5 6s448ms 1s289ms 22 6 6s595ms 1s99ms [ User: intelifix - Total duration: 4m57s - Times executed: 164 ]
[ Application: psql - Total duration: 4m57s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 00:05:12 Duration: 10s378ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 09:25:06 Duration: 5s591ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 09:05:06 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: psql
10 4m33s 637 150ms 2s23ms 428ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 01 07 3 3s338ms 1s112ms 08 87 41s782ms 480ms 09 77 29s43ms 377ms 10 87 35s494ms 407ms 11 73 34s453ms 471ms 12 7 2s781ms 397ms 13 57 22s29ms 386ms 14 83 38s393ms 462ms 15 92 37s745ms 410ms 16 56 22s257ms 397ms 17 15 5s711ms 380ms [ User: intelifix - Total duration: 4m33s - Times executed: 637 ]
[ Application: [unknown] - Total duration: 4m33s - Times executed: 637 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "139066", "modelo" : "153", "itens" : "840112EC3D27,840112619AB5,1834AF99A273,840112DD3A54,8401122AE407,840112C12AD7,1834AF9B5F78,1834AF259D2B,8401125FC990,743AEF75297E", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-01 08:37:46 Duration: 2s23ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292644", "modelo" : "320", "itens" : "241616924654,241714038700,241658403450,241660307092,241619560726,241732513051,241661653857,241616297993,241667789809,230040276264,241706984869,241706716683,241658770108,241711589415,241679506979,241727895877,241645835152,241606197692,241664978490,241616301025,241629535054,241607695459,241629500910,241614671629,241635967578,241680747190,241712803237,241704794756,241667730208,241710915454,241598656182,241592937071,241680777193,241635502124,241658323139,241655452848,241607468994,241672089701,241618766573,241663060022,241700324062,241669776366,241663851120,241709800206,241597466885,241731875154,241658155266,241637873141", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-01 07:57:03 Duration: 1s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292807", "modelo" : "461", "itens" : "14200458C112,7C7D21F21DDB,142004573D32,7C7D21ED3D83,DC5193DB26EA,7C7D21F08D3B,E44E12B3D8C9,1420045999FE,E44E12AFA865,142004599C8A,E44E12AFA861,142004572EE2,142004570352,7C7D21EFACEB,E44E1293D3E7,1420045720DA,14200457339A,B47CA60857BA,DC5193DB38A2,142004572D96,142004570686,14200457B15A,142004572EDA,142004573DC2,DC5193DB6CEE,142004570346,14200457302A,14200457B09E", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-01 15:11:55 Duration: 1s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 3m50s 19 11s227ms 15s904ms 12s135ms create table temp0000293120 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 01 11 9 1m46s 11s820ms 14 5 59s414ms 11s882ms 15 3 38s808ms 12s936ms 16 1 14s24ms 14s24ms 17 1 11s943ms 11s943ms [ User: intelifix - Total duration: 3m50s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m50s - Times executed: 19 ]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 15:22:46 Duration: 15s904ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 16:57:42 Duration: 14s24ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 11:07:02 Duration: 13s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m19s 6 4s126ms 1m3s 33s250ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 01 00 2 1m7s 33s715ms 20 2 1m6s 33s58ms 23 2 1m5s 32s977ms [ User: intelifix - Total duration: 3m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3m19s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-01 00:01:36 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-10-01 23:16:35 Duration: 1m1s 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-10-01 20:08:35 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
13 3m1s 16 10s902ms 13s540ms 11s364ms create table temp0000292986 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 01 09 12 2m14s 11s216ms 10 2 24s459ms 12s229ms 14 2 22s784ms 11s392ms [ User: intelifix - Total duration: 3m1s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m1s - Times executed: 16 ]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 10:38:26 Duration: 13s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 09:40:16 Duration: 11s723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 09:30:37 Duration: 11s503ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m3s 9 2s957ms 31s613ms 13s690ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 01 00 3 40s975ms 13s658ms 20 3 41s95ms 13s698ms 23 3 41s141ms 13s713ms [ User: intelifix - Total duration: 2m3s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 9 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-01 20:09:07 Duration: 31s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-01 23:17:06 Duration: 31s607ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-01 00:02:08 Duration: 31s562ms Database: rio User: intelifix Remote: [local] Application: pg_dump
15 2m 8 3s176ms 39s773ms 15s76ms 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 #15
Day Hour Count Duration Avg duration Oct 01 00 2 13s654ms 6s827ms 20 3 53s485ms 17s828ms 23 3 53s468ms 17s822ms [ User: intelifix - Total duration: 2m - Times executed: 8 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 8 ]
-
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-10-01 20:06:23 Duration: 39s773ms 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-10-01 23:14:23 Duration: 39s768ms 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-10-01 20:10:08 Duration: 10s534ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m46s 5 343ms 53s71ms 21s339ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 01 00 1 343ms 343ms 20 2 52s933ms 26s466ms 23 2 53s420ms 26s710ms [ User: intelifix - Total duration: 1m46s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-01 23:13:42 Duration: 53s71ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-01 20:05:42 Duration: 52s580ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-01 20:09:57 Duration: 353ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m45s 33 703ms 9s268ms 3s206ms 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 #17
Day Hour Count Duration Avg duration Oct 01 08 2 8s423ms 4s211ms 09 3 11s796ms 3s932ms 10 2 9s283ms 4s641ms 11 3 9s306ms 3s102ms 12 2 1s572ms 786ms 13 2 2s531ms 1s265ms 14 2 13s823ms 6s911ms 15 3 14s460ms 4s820ms 16 3 16s697ms 5s565ms 17 2 10s274ms 5s137ms 18 2 1s684ms 842ms 19 1 1s54ms 1s54ms 20 2 1s735ms 867ms 21 1 768ms 768ms 22 3 2s400ms 800ms [ User: intelifix - Total duration: 1m45s - Times executed: 33 ]
[ Application: psql - Total duration: 1m45s - Times executed: 33 ]
-
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-10-01 17:00:10 Duration: 9s268ms 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-10-01 14:20:10 Duration: 8s788ms 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-10-01 15:20:09 Duration: 7s791ms Database: rio User: intelifix Remote: [local] Application: psql
18 1m43s 324 150ms 1s178ms 319ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 01 08 12 5s822ms 485ms 09 225 1m15s 337ms 10 87 22s 252ms [ User: intelifix - Total duration: 1m43s - Times executed: 324 ]
[ Application: [unknown] - Total duration: 1m43s - Times executed: 324 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241814165677,241759961016,241747482121,241746470014,241744164659,241742809813,241746390713,241814174163,241747466081,241778712745,241761267293,241814157494,241814176486,241759956267,241740243244,241814360220,241746371014,241778709108,241739578296,241778694359,241747483232","usuario":"399","observacao":""}');
Date: 2026-10-01 09:41:19 Duration: 1s178ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241658465880,241593850001,241675373344,241603930626,241732881123,241716436565,241727295358,241689829502,241665241525,241616879801,241608772849,241645933849,241616874245,241712630819,241595263034,241674097900,241730273741,241675376475,241630023542,241707087583,241649512021,241675395669,241709315051,241609298690,241712623343,241599349718,241645930011,241709397079","usuario":"399","observacao":""}');
Date: 2026-10-01 09:42:07 Duration: 1s109ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59276","seriais":"ACD75BB6E224,6CFFCE68D9B0,582FF79BE171,841EA397160D,D833B7CBEE26","usuario":"416","observacao":""}');
Date: 2026-10-01 09:05:55 Duration: 1s94ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 1m37s 35 2s452ms 4s109ms 2s786ms create table temp0000293068 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 01 07 12 31s152ms 2s596ms 08 4 10s304ms 2s576ms 09 12 34s904ms 2s908ms 12 5 14s802ms 2s960ms 15 2 6s350ms 3s175ms [ User: intelifix - Total duration: 1m37s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1m37s - Times executed: 35 ]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 09:24:19 Duration: 4s109ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 09:47:58 Duration: 3s934ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 15:48:00 Duration: 3s397ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m32s 8 2s233ms 31s643ms 11s623ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 01 00 2 9s880ms 4s940ms 20 3 41s561ms 13s853ms 23 3 41s544ms 13s848ms [ User: intelifix - Total duration: 1m32s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m32s - Times executed: 8 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-01 23:14:57 Duration: 31s643ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-01 20:06:57 Duration: 31s498ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-01 20:10:17 Duration: 7s807ms 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 820 7m58s 150ms 3s547ms 583ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 01 07 9 2s939ms 326ms 08 70 46s463ms 663ms 09 145 1m29s 619ms 10 124 1m10s 572ms 11 97 48s840ms 503ms 12 12 6s879ms 573ms 13 61 38s224ms 626ms 14 105 57s444ms 547ms 15 79 43s233ms 547ms 16 78 36s626ms 469ms 17 33 32s931ms 997ms 18 7 3s755ms 536ms [ User: intelifix - Total duration: 7m58s - Times executed: 820 ]
[ Application: [unknown] - Total duration: 7m58s - Times executed: 820 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291879, 503, '517144003746,B0DAF94C20ED,CC75E2BB93AB,F8F53255EDF2,5819F840D94D,BC644BE1C060,BC644BC1B752,F8F53258AB5F,2C584F35F725,2C9569F63132,BC644BCCC0B1,B0935BECA0BA,5819F84610B1,BC644BC3E6E4,5819F84298E1,2C584F33C49B,B0DAF9516C29,2C584F2F61FD', '',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":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-01 08:30:13 Duration: 3s547ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (138862, 397, '254293117675465,216368366565,216451335976,216840236377,216671310711,216564826771,216667982440,216728839602,216662356267,216855235978,216847377489,216841871330,216665371321,216645452845,216368324665', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-01 13:31:42 Duration: 3s373ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (291854, 317, '71821285850057303454,216875606069,216400004356,216701557287,216908645152,216704304660H010954896,216631264647,216701004753,216837201626H011600346,216628217593,216832008100,216355774955H010977693,216633544264', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-01 16:00:58 Duration: 3s246ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 637 4m33s 150ms 2s23ms 428ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 01 07 3 3s338ms 1s112ms 08 87 41s782ms 480ms 09 77 29s43ms 377ms 10 87 35s494ms 407ms 11 73 34s453ms 471ms 12 7 2s781ms 397ms 13 57 22s29ms 386ms 14 83 38s393ms 462ms 15 92 37s745ms 410ms 16 56 22s257ms 397ms 17 15 5s711ms 380ms [ User: intelifix - Total duration: 4m33s - Times executed: 637 ]
[ Application: [unknown] - Total duration: 4m33s - Times executed: 637 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "139066", "modelo" : "153", "itens" : "840112EC3D27,840112619AB5,1834AF99A273,840112DD3A54,8401122AE407,840112C12AD7,1834AF9B5F78,1834AF259D2B,8401125FC990,743AEF75297E", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-01 08:37:46 Duration: 2s23ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292644", "modelo" : "320", "itens" : "241616924654,241714038700,241658403450,241660307092,241619560726,241732513051,241661653857,241616297993,241667789809,230040276264,241706984869,241706716683,241658770108,241711589415,241679506979,241727895877,241645835152,241606197692,241664978490,241616301025,241629535054,241607695459,241629500910,241614671629,241635967578,241680747190,241712803237,241704794756,241667730208,241710915454,241598656182,241592937071,241680777193,241635502124,241658323139,241655452848,241607468994,241672089701,241618766573,241663060022,241700324062,241669776366,241663851120,241709800206,241597466885,241731875154,241658155266,241637873141", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-01 07:57:03 Duration: 1s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "292807", "modelo" : "461", "itens" : "14200458C112,7C7D21F21DDB,142004573D32,7C7D21ED3D83,DC5193DB26EA,7C7D21F08D3B,E44E12B3D8C9,1420045999FE,E44E12AFA865,142004599C8A,E44E12AFA861,142004572EE2,142004570352,7C7D21EFACEB,E44E1293D3E7,1420045720DA,14200457339A,B47CA60857BA,DC5193DB38A2,142004572D96,142004570686,14200457B15A,142004572EDA,142004573DC2,DC5193DB6CEE,142004570346,14200457302A,14200457B09E", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-01 15:11:55 Duration: 1s458ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 324 1m43s 150ms 1s178ms 319ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 01 08 12 5s822ms 485ms 09 225 1m15s 337ms 10 87 22s 252ms [ User: intelifix - Total duration: 1m43s - Times executed: 324 ]
[ Application: [unknown] - Total duration: 1m43s - Times executed: 324 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241814165677,241759961016,241747482121,241746470014,241744164659,241742809813,241746390713,241814174163,241747466081,241778712745,241761267293,241814157494,241814176486,241759956267,241740243244,241814360220,241746371014,241778709108,241739578296,241778694359,241747483232","usuario":"399","observacao":""}');
Date: 2026-10-01 09:41:19 Duration: 1s178ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"139056","seriais":"241658465880,241593850001,241675373344,241603930626,241732881123,241716436565,241727295358,241689829502,241665241525,241616879801,241608772849,241645933849,241616874245,241712630819,241595263034,241674097900,241730273741,241675376475,241630023542,241707087583,241649512021,241675395669,241709315051,241609298690,241712623343,241599349718,241645930011,241709397079","usuario":"399","observacao":""}');
Date: 2026-10-01 09:42:07 Duration: 1s109ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59276","seriais":"ACD75BB6E224,6CFFCE68D9B0,582FF79BE171,841EA397160D,D833B7CBEE26","usuario":"416","observacao":""}');
Date: 2026-10-01 09:05:55 Duration: 1s94ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 276 7m33s 183ms 6s515ms 1s643ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 01 00 12 34s283ms 2s856ms 01 12 17s696ms 1s474ms 02 12 17s680ms 1s473ms 03 12 18s848ms 1s570ms 04 12 17s449ms 1s454ms 05 12 18s109ms 1s509ms 06 12 17s896ms 1s491ms 07 12 18s137ms 1s511ms 08 12 21s354ms 1s779ms 09 12 19s957ms 1s663ms 10 12 19s202ms 1s600ms 11 12 19s46ms 1s587ms 12 12 18s783ms 1s565ms 13 12 18s900ms 1s575ms 14 12 19s859ms 1s654ms 15 12 19s732ms 1s644ms 16 12 19s88ms 1s590ms 17 12 19s619ms 1s634ms 18 12 18s669ms 1s555ms 19 12 18s985ms 1s582ms 20 12 22s848ms 1s904ms 21 12 18s573ms 1s547ms 22 12 18s866ms 1s572ms [ User: intelifix - Total duration: 7m33s - Times executed: 276 ]
[ Application: psql - Total duration: 7m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:25:07 Duration: 6s515ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:05:18 Duration: 6s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:15:09 Duration: 5s749ms Database: rio User: intelifix Remote: [local] Application: psql
5 164 4m57s 155ms 10s378ms 1s816ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 01 00 6 17s614ms 2s935ms 01 6 5s775ms 962ms 02 6 5s499ms 916ms 03 5 5s293ms 1s58ms 04 6 7s143ms 1s190ms 05 5 8s114ms 1s622ms 07 11 24s641ms 2s240ms 08 12 28s855ms 2s404ms 09 12 32s916ms 2s743ms 10 12 25s617ms 2s134ms 11 12 25s498ms 2s124ms 12 12 25s374ms 2s114ms 13 8 6s194ms 774ms 14 11 20s713ms 1s883ms 15 12 26s144ms 2s178ms 16 10 14s988ms 1s498ms 17 6 3s783ms 630ms 20 1 698ms 698ms 21 5 6s448ms 1s289ms 22 6 6s595ms 1s99ms [ User: intelifix - Total duration: 4m57s - Times executed: 164 ]
[ Application: psql - Total duration: 4m57s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 00:05:12 Duration: 10s378ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 09:25:06 Duration: 5s591ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 09:05:06 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: psql
6 130 1h2m20s 169ms 6m48s 28s771ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 01 07 4 5m58s 1m29s 08 8 6m30s 48s759ms 09 13 11m3s 51s42ms 10 24 6m24s 16s4ms 11 16 44s602ms 2s787ms 12 1 5m33s 5m33s 13 13 8s210ms 631ms 14 18 11m25s 38s89ms 15 12 5m48s 29s65ms 16 8 53s84ms 6s635ms 17 12 7m50s 39s196ms 18 1 315ms 315ms [ User: intelifix - Total duration: 1h2m20s - Times executed: 130 ]
[ Application: [unknown] - Total duration: 1h2m20s - Times executed: 130 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030682, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-10-01 17:04:34 Duration: 6m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030642, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-01 07:53:59 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030676, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-01 14:48:53 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 88 27s398ms 295ms 341ms 311ms 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 Oct 01 01 2 625ms 312ms 05 2 597ms 298ms 07 8 2s449ms 306ms 08 9 2s790ms 310ms 09 10 3s108ms 310ms 10 6 1s904ms 317ms 11 7 2s241ms 320ms 12 3 923ms 307ms 13 10 3s81ms 308ms 14 9 2s822ms 313ms 15 8 2s467ms 308ms 16 8 2s535ms 316ms 17 3 912ms 304ms 18 1 306ms 306ms 20 1 316ms 316ms 21 1 316ms 316ms [ User: lenon - Total duration: 27s398ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 27s398ms - Times executed: 88 ]
-
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-10-01 16:43:06 Duration: 341ms Database: contagem 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-10-01 10:31:03 Duration: 336ms Database: contagem 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-10-01 11:19:00 Duration: 331ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 83 30s860ms 329ms 556ms 371ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 01 01 2 876ms 438ms 05 2 796ms 398ms 07 5 1s710ms 342ms 08 9 3s594ms 399ms 09 10 3s614ms 361ms 10 6 2s245ms 374ms 11 7 2s570ms 367ms 12 3 1s113ms 371ms 13 9 3s250ms 361ms 14 9 3s277ms 364ms 15 8 2s923ms 365ms 16 8 3s65ms 383ms 17 2 695ms 347ms 18 1 370ms 370ms 20 1 404ms 404ms 21 1 349ms 349ms [ User: intelifix - Total duration: 30s860ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 30s860ms - Times executed: 83 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-10-01 08:17:03 Duration: 556ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-10-01 01:17:49 Duration: 513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 81, 1);
Date: 2026-10-01 08:08:00 Duration: 435ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 76 8m59s 1s597ms 39s492ms 7s104ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 01 07 2 5s368ms 2s684ms 08 1 1s597ms 1s597ms 09 7 1m2s 8s914ms 10 9 1m44s 11s569ms 11 10 1m1s 6s156ms 12 5 9s329ms 1s865ms 13 4 17s471ms 4s367ms 14 6 1m16s 12s734ms 15 15 1m57s 7s835ms 16 10 1m2s 6s213ms 17 7 22s19ms 3s145ms [ User: intelifix - Total duration: 8m59s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 8m59s - Times executed: 76 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 09:45:45 Duration: 39s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 10:50:32 Duration: 36s86ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-01', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 15:42:18 Duration: 23s523ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 75 22s241ms 153ms 952ms 296ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 01 08 4 1s263ms 315ms 09 15 5s115ms 341ms 10 13 3s944ms 303ms 11 5 963ms 192ms 13 1 240ms 240ms 14 10 2s674ms 267ms 15 26 7s841ms 301ms 16 1 197ms 197ms [ User: intelifix - Total duration: 22s241ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 22s241ms - Times executed: 75 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '9C635B8C5CC6,9C635B8F2C18,689E29870200,F4E84FAC83AA,9C635B905D58,9C635B8C5C42,9C635B8DF3B2,9C635B8DBC6E,9C635B8F3392', '138;1', 'DEFAULT', 09, 0318, '','', '', 00);
Date: 2026-10-01 09:12:23 Duration: 952ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'BCBD84A6FAB5,BCBD84A705A1,BCBD84A6F6E9,BCBD84A70D33,BCBD84A70A93,9C635BF7EB10,BCBD84A7108D,BCBD84A711AD,BCBD84A70E9B,BCBD84A6F311,9C635BF7AF8E,BCBD84A70019,BCBD84A6DBE3', '138;1', 'DEFAULT', 09, 0322, '','', '', 00);
Date: 2026-10-01 09:59:36 Duration: 817ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '484BD496EF24,484BD49F7754,5C7D7D5C032C,5C7D7D5CE36C,484BD49CBC6C,A0FF7086B4C4,5C7D7D635374,484BD4917444,5C7D7D62A154,484BD483BEA4', '138;1', 'DEFAULT', 09, 0154, '','', '', 00);
Date: 2026-10-01 10:33:03 Duration: 563ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 67 12m44s 10s609ms 22s80ms 11s408ms create table temp0000293068 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 01 07 14 2m43s 11s668ms 08 13 2m22s 10s940ms 09 11 2m5s 11s418ms 10 6 1m13s 12s239ms 11 3 33s423ms 11s141ms 12 6 1m7s 11s225ms 14 12 2m15s 11s320ms 15 2 23s87ms 11s543ms [ User: intelifix - Total duration: 12m44s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 12m44s - Times executed: 67 ]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 07:19:22 Duration: 22s80ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 10:09:05 Duration: 16s252ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 09:46:19 Duration: 13s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 56 1m29s 570ms 22s38ms 1s604ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 01 08 4 10s21ms 2s505ms 09 3 2s286ms 762ms 10 4 5s282ms 1s320ms 11 3 5s209ms 1s736ms 12 4 6s910ms 1s727ms 13 4 4s483ms 1s120ms 14 4 6s778ms 1s694ms 15 3 2s470ms 823ms 16 3 2s60ms 686ms 17 3 6s425ms 2s141ms 18 4 24s342ms 6s85ms 19 5 3s574ms 714ms 20 4 3s363ms 840ms 21 5 4s306ms 861ms 22 3 2s338ms 779ms [ User: intelifix - Total duration: 1m29s - Times executed: 56 ]
[ Application: psql - Total duration: 1m29s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-01 18:00:24 Duration: 22s38ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-01 08:20:09 Duration: 7s770ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-01 17:20:07 Duration: 4s805ms Database: brasilia User: intelifix Remote: [local] Application: psql
13 53 15s341ms 258ms 631ms 289ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 01 07 3 843ms 281ms 08 7 1s901ms 271ms 09 8 2s254ms 281ms 10 3 932ms 310ms 11 9 2s505ms 278ms 12 1 283ms 283ms 14 6 1s721ms 286ms 15 7 2s22ms 288ms 16 5 1s765ms 353ms 17 4 1s112ms 278ms [ User: intelifix - Total duration: 15s341ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 15s341ms - Times executed: 53 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-10-01 16:37:23 Duration: 631ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-01 10:30:37 Duration: 371ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-10-01 15:46:39 Duration: 333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 48 1h32m 2s132ms 6m15s 1m55s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 01 07 3 6m45s 2m15s 08 3 5m33s 1m51s 09 3 6m25s 2m8s 10 3 5m50s 1m56s 11 3 5m41s 1m53s 12 3 5m37s 1m52s 13 3 5m34s 1m51s 14 3 5m36s 1m52s 15 3 5m43s 1m54s 16 3 5m41s 1m53s 17 3 5m50s 1m56s 18 3 5m41s 1m53s 19 3 5m29s 1m49s 20 3 5m30s 1m50s 21 3 5m25s 1m48s 22 3 5m33s 1m51s [ User: intelifix - Total duration: 1h32m - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 07:11:17 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 09:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 10:10:31 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
15 48 1h3m50s 233ms 3m35s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 01 07 3 4m26s 1m28s 08 3 3m51s 1m17s 09 3 4m 1m20s 10 3 4m3s 1m21s 11 3 4m6s 1m22s 12 3 3m59s 1m19s 13 3 3m57s 1m19s 14 3 3m58s 1m19s 15 3 4m2s 1m20s 16 3 3m56s 1m18s 17 3 3m59s 1m19s 18 3 4m1s 1m20s 19 3 3m51s 1m17s 20 3 3m53s 1m17s 21 3 3m50s 1m16s 22 3 3m50s 1m16s [ User: intelifix - Total duration: 1h3m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 07:16:07 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 11:14:44 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 18:14:40 Duration: 3m31s Database: brasilia User: intelifix Remote: [local] Application: psql
16 35 1m37s 2s452ms 4s109ms 2s786ms create table temp0000293068 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 01 07 12 31s152ms 2s596ms 08 4 10s304ms 2s576ms 09 12 34s904ms 2s908ms 12 5 14s802ms 2s960ms 15 2 6s350ms 3s175ms [ User: intelifix - Total duration: 1m37s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1m37s - Times executed: 35 ]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 09:24:19 Duration: 4s109ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 09:47:58 Duration: 3s934ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 15:48:00 Duration: 3s397ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 34 39s729ms 159ms 6s973ms 1s168ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 01 09 3 1s617ms 539ms 10 15 25s375ms 1s691ms 13 10 4s832ms 483ms 14 3 2s764ms 921ms 16 2 3s261ms 1s630ms 17 1 1s878ms 1s878ms [ User: intelifix - Total duration: 39s729ms - Times executed: 34 ]
[ Application: [unknown] - Total duration: 39s729ms - Times executed: 34 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-01 10:10:14 Duration: 6s973ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-01 10:45:28 Duration: 6s373ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-01 10:10:00 Duration: 6s212ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 33 1m45s 703ms 9s268ms 3s206ms 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 Oct 01 08 2 8s423ms 4s211ms 09 3 11s796ms 3s932ms 10 2 9s283ms 4s641ms 11 3 9s306ms 3s102ms 12 2 1s572ms 786ms 13 2 2s531ms 1s265ms 14 2 13s823ms 6s911ms 15 3 14s460ms 4s820ms 16 3 16s697ms 5s565ms 17 2 10s274ms 5s137ms 18 2 1s684ms 842ms 19 1 1s54ms 1s54ms 20 2 1s735ms 867ms 21 1 768ms 768ms 22 3 2s400ms 800ms [ User: intelifix - Total duration: 1m45s - Times executed: 33 ]
[ Application: psql - Total duration: 1m45s - Times executed: 33 ]
-
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-10-01 17:00:10 Duration: 9s268ms 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-10-01 14:20:10 Duration: 8s788ms 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-10-01 15:20:09 Duration: 7s791ms Database: rio User: intelifix Remote: [local] Application: psql
19 28 1m29s 250ms 17s420ms 3s182ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 01 07 3 24s279ms 8s93ms 08 3 10s328ms 3s442ms 09 4 19s486ms 4s871ms 10 1 3s997ms 3s997ms 11 7 7s360ms 1s51ms 14 5 14s401ms 2s880ms 15 4 7s707ms 1s926ms 17 1 1s541ms 1s541ms [ User: intelifix - Total duration: 1m29s - Times executed: 28 ]
[ Application: psql - Total duration: 1m29s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030637);
Date: 2026-10-01 07:19:54 Duration: 17s420ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030658);
Date: 2026-10-01 09:56:53 Duration: 7s287ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030651);
Date: 2026-10-01 09:23:47 Duration: 6s28ms Database: rio User: intelifix Remote: [local] Application: psql
20 25 24s607ms 156ms 11s363ms 984ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 01 07 3 656ms 218ms 08 5 1s690ms 338ms 09 2 394ms 197ms 10 1 169ms 169ms 11 4 2s863ms 715ms 14 7 4s473ms 639ms 15 2 2s997ms 1s498ms 16 1 11s363ms 11s363ms [ User: intelifix - Total duration: 24s607ms - Times executed: 25 ]
[ Application: psql - Total duration: 24s607ms - Times executed: 25 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030682);
Date: 2026-10-01 16:57:37 Duration: 11s363ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030673);
Date: 2026-10-01 14:32:55 Duration: 2s629ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030681);
Date: 2026-10-01 15:49:39 Duration: 2s292ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m44s 9m15s 6m6s 3 18m18s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 01 05 3 18m18s 6m6s [ User: intelifix - Total duration: 18m18s - Times executed: 3 ]
[ Application: psql - Total duration: 18m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-01 05:09:16 Duration: 9m15s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-01 05:15:35 Duration: 6m18s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-01 05:18:19 Duration: 2m44s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s132ms 6m15s 1m55s 48 1h32m select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 01 07 3 6m45s 2m15s 08 3 5m33s 1m51s 09 3 6m25s 2m8s 10 3 5m50s 1m56s 11 3 5m41s 1m53s 12 3 5m37s 1m52s 13 3 5m34s 1m51s 14 3 5m36s 1m52s 15 3 5m43s 1m54s 16 3 5m41s 1m53s 17 3 5m50s 1m56s 18 3 5m41s 1m53s 19 3 5m29s 1m49s 20 3 5m30s 1m50s 21 3 5m25s 1m48s 22 3 5m33s 1m51s [ User: intelifix - Total duration: 1h32m - Times executed: 48 ]
[ Application: psql - Total duration: 1h32m - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 07:11:17 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 09:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-01 10:10:31 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
3 233ms 3m35s 1m19s 48 1h3m50s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 01 07 3 4m26s 1m28s 08 3 3m51s 1m17s 09 3 4m 1m20s 10 3 4m3s 1m21s 11 3 4m6s 1m22s 12 3 3m59s 1m19s 13 3 3m57s 1m19s 14 3 3m58s 1m19s 15 3 4m2s 1m20s 16 3 3m56s 1m18s 17 3 3m59s 1m19s 18 3 4m1s 1m20s 19 3 3m51s 1m17s 20 3 3m53s 1m17s 21 3 3m50s 1m16s 22 3 3m50s 1m16s [ User: intelifix - Total duration: 1h3m50s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m50s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 07:16:07 Duration: 3m35s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 11:14:44 Duration: 3m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-01 18:14:40 Duration: 3m31s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s126ms 1m3s 33s250ms 6 3m19s 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 Oct 01 00 2 1m7s 33s715ms 20 2 1m6s 33s58ms 23 2 1m5s 32s977ms [ User: intelifix - Total duration: 3m19s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 3m19s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-01 00:01:36 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-10-01 23:16:35 Duration: 1m1s 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-10-01 20:08:35 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
5 169ms 6m48s 28s771ms 130 1h2m20s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 01 07 4 5m58s 1m29s 08 8 6m30s 48s759ms 09 13 11m3s 51s42ms 10 24 6m24s 16s4ms 11 16 44s602ms 2s787ms 12 1 5m33s 5m33s 13 13 8s210ms 631ms 14 18 11m25s 38s89ms 15 12 5m48s 29s65ms 16 8 53s84ms 6s635ms 17 12 7m50s 39s196ms 18 1 315ms 315ms [ User: intelifix - Total duration: 1h2m20s - Times executed: 130 ]
[ Application: [unknown] - Total duration: 1h2m20s - Times executed: 130 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030682, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-10-01 17:04:34 Duration: 6m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030642, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-01 07:53:59 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030676, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-10-01 14:48:53 Duration: 5m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 343ms 53s71ms 21s339ms 5 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 01 00 1 343ms 343ms 20 2 52s933ms 26s466ms 23 2 53s420ms 26s710ms [ User: intelifix - Total duration: 1m46s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-01 23:13:42 Duration: 53s71ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-01 20:05:42 Duration: 52s580ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-01 20:09:57 Duration: 353ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 3s176ms 39s773ms 15s76ms 8 2m 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 #7
Day Hour Count Duration Avg duration Oct 01 00 2 13s654ms 6s827ms 20 3 53s485ms 17s828ms 23 3 53s468ms 17s822ms [ User: intelifix - Total duration: 2m - Times executed: 8 ]
[ Application: pg_dump - Total duration: 2m - Times executed: 8 ]
-
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-10-01 20:06:23 Duration: 39s773ms 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-10-01 23:14:23 Duration: 39s768ms 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-10-01 20:10:08 Duration: 10s534ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s957ms 31s613ms 13s690ms 9 2m3s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 01 00 3 40s975ms 13s658ms 20 3 41s95ms 13s698ms 23 3 41s141ms 13s713ms [ User: intelifix - Total duration: 2m3s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 2m3s - Times executed: 9 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-01 20:09:07 Duration: 31s613ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-01 23:17:06 Duration: 31s607ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-01 00:02:08 Duration: 31s562ms Database: rio User: intelifix Remote: [local] Application: pg_dump
9 11s227ms 15s904ms 12s135ms 19 3m50s create table temp0000293120 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 01 11 9 1m46s 11s820ms 14 5 59s414ms 11s882ms 15 3 38s808ms 12s936ms 16 1 14s24ms 14s24ms 17 1 11s943ms 11s943ms [ User: intelifix - Total duration: 3m50s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m50s - Times executed: 19 ]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 15:22:46 Duration: 15s904ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 16:57:42 Duration: 14s24ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293120 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 11:07:02 Duration: 13s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 2s233ms 31s643ms 11s623ms 8 1m32s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 01 00 2 9s880ms 4s940ms 20 3 41s561ms 13s853ms 23 3 41s544ms 13s848ms [ User: intelifix - Total duration: 1m32s - Times executed: 8 ]
[ Application: pg_dump - Total duration: 1m32s - Times executed: 8 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-01 23:14:57 Duration: 31s643ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-01 20:06:57 Duration: 31s498ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-01 20:10:17 Duration: 7s807ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 10s609ms 22s80ms 11s408ms 67 12m44s create table temp0000293068 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 01 07 14 2m43s 11s668ms 08 13 2m22s 10s940ms 09 11 2m5s 11s418ms 10 6 1m13s 12s239ms 11 3 33s423ms 11s141ms 12 6 1m7s 11s225ms 14 12 2m15s 11s320ms 15 2 23s87ms 11s543ms [ User: intelifix - Total duration: 12m44s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 12m44s - Times executed: 67 ]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 07:19:22 Duration: 22s80ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 10:09:05 Duration: 16s252ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 09:46:19 Duration: 13s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s902ms 13s540ms 11s364ms 16 3m1s create table temp0000292986 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 01 09 12 2m14s 11s216ms 10 2 24s459ms 12s229ms 14 2 22s784ms 11s392ms [ User: intelifix - Total duration: 3m1s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m1s - Times executed: 16 ]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 10:38:26 Duration: 13s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 09:40:16 Duration: 11s723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292986 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-10-01 09:30:37 Duration: 11s503ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s597ms 39s492ms 7s104ms 76 8m59s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 01 07 2 5s368ms 2s684ms 08 1 1s597ms 1s597ms 09 7 1m2s 8s914ms 10 9 1m44s 11s569ms 11 10 1m1s 6s156ms 12 5 9s329ms 1s865ms 13 4 17s471ms 4s367ms 14 6 1m16s 12s734ms 15 15 1m57s 7s835ms 16 10 1m2s 6s213ms 17 7 22s19ms 3s145ms [ User: intelifix - Total duration: 8m59s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 8m59s - Times executed: 76 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 09:45:45 Duration: 39s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-30', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 10:50:32 Duration: 36s86ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-01', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-10-01 15:42:18 Duration: 23s523ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 703ms 9s268ms 3s206ms 33 1m45s 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 #14
Day Hour Count Duration Avg duration Oct 01 08 2 8s423ms 4s211ms 09 3 11s796ms 3s932ms 10 2 9s283ms 4s641ms 11 3 9s306ms 3s102ms 12 2 1s572ms 786ms 13 2 2s531ms 1s265ms 14 2 13s823ms 6s911ms 15 3 14s460ms 4s820ms 16 3 16s697ms 5s565ms 17 2 10s274ms 5s137ms 18 2 1s684ms 842ms 19 1 1s54ms 1s54ms 20 2 1s735ms 867ms 21 1 768ms 768ms 22 3 2s400ms 800ms [ User: intelifix - Total duration: 1m45s - Times executed: 33 ]
[ Application: psql - Total duration: 1m45s - Times executed: 33 ]
-
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-10-01 17:00:10 Duration: 9s268ms 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-10-01 14:20:10 Duration: 8s788ms 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-10-01 15:20:09 Duration: 7s791ms Database: rio User: intelifix Remote: [local] Application: psql
15 250ms 17s420ms 3s182ms 28 1m29s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 01 07 3 24s279ms 8s93ms 08 3 10s328ms 3s442ms 09 4 19s486ms 4s871ms 10 1 3s997ms 3s997ms 11 7 7s360ms 1s51ms 14 5 14s401ms 2s880ms 15 4 7s707ms 1s926ms 17 1 1s541ms 1s541ms [ User: intelifix - Total duration: 1m29s - Times executed: 28 ]
[ Application: psql - Total duration: 1m29s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030637);
Date: 2026-10-01 07:19:54 Duration: 17s420ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030658);
Date: 2026-10-01 09:56:53 Duration: 7s287ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030651);
Date: 2026-10-01 09:23:47 Duration: 6s28ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s452ms 4s109ms 2s786ms 35 1m37s create table temp0000293068 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 01 07 12 31s152ms 2s596ms 08 4 10s304ms 2s576ms 09 12 34s904ms 2s908ms 12 5 14s802ms 2s960ms 15 2 6s350ms 3s175ms [ User: intelifix - Total duration: 1m37s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 1m37s - Times executed: 35 ]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 09:24:19 Duration: 4s109ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 09:47:58 Duration: 3s934ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000293068 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-09-2026", "ate" :"01-10-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-10-01 15:48:00 Duration: 3s397ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 155ms 10s378ms 1s816ms 164 4m57s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 01 00 6 17s614ms 2s935ms 01 6 5s775ms 962ms 02 6 5s499ms 916ms 03 5 5s293ms 1s58ms 04 6 7s143ms 1s190ms 05 5 8s114ms 1s622ms 07 11 24s641ms 2s240ms 08 12 28s855ms 2s404ms 09 12 32s916ms 2s743ms 10 12 25s617ms 2s134ms 11 12 25s498ms 2s124ms 12 12 25s374ms 2s114ms 13 8 6s194ms 774ms 14 11 20s713ms 1s883ms 15 12 26s144ms 2s178ms 16 10 14s988ms 1s498ms 17 6 3s783ms 630ms 20 1 698ms 698ms 21 5 6s448ms 1s289ms 22 6 6s595ms 1s99ms [ User: intelifix - Total duration: 4m57s - Times executed: 164 ]
[ Application: psql - Total duration: 4m57s - Times executed: 164 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 00:05:12 Duration: 10s378ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 09:25:06 Duration: 5s591ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-01 09:05:06 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: psql
18 183ms 6s515ms 1s643ms 276 7m33s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 01 00 12 34s283ms 2s856ms 01 12 17s696ms 1s474ms 02 12 17s680ms 1s473ms 03 12 18s848ms 1s570ms 04 12 17s449ms 1s454ms 05 12 18s109ms 1s509ms 06 12 17s896ms 1s491ms 07 12 18s137ms 1s511ms 08 12 21s354ms 1s779ms 09 12 19s957ms 1s663ms 10 12 19s202ms 1s600ms 11 12 19s46ms 1s587ms 12 12 18s783ms 1s565ms 13 12 18s900ms 1s575ms 14 12 19s859ms 1s654ms 15 12 19s732ms 1s644ms 16 12 19s88ms 1s590ms 17 12 19s619ms 1s634ms 18 12 18s669ms 1s555ms 19 12 18s985ms 1s582ms 20 12 22s848ms 1s904ms 21 12 18s573ms 1s547ms 22 12 18s866ms 1s572ms [ User: intelifix - Total duration: 7m33s - Times executed: 276 ]
[ Application: psql - Total duration: 7m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:25:07 Duration: 6s515ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:05:18 Duration: 6s71ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-01 00:15:09 Duration: 5s749ms Database: rio User: intelifix Remote: [local] Application: psql
19 570ms 22s38ms 1s604ms 56 1m29s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 01 08 4 10s21ms 2s505ms 09 3 2s286ms 762ms 10 4 5s282ms 1s320ms 11 3 5s209ms 1s736ms 12 4 6s910ms 1s727ms 13 4 4s483ms 1s120ms 14 4 6s778ms 1s694ms 15 3 2s470ms 823ms 16 3 2s60ms 686ms 17 3 6s425ms 2s141ms 18 4 24s342ms 6s85ms 19 5 3s574ms 714ms 20 4 3s363ms 840ms 21 5 4s306ms 861ms 22 3 2s338ms 779ms [ User: intelifix - Total duration: 1m29s - Times executed: 56 ]
[ Application: psql - Total duration: 1m29s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-01 18:00:24 Duration: 22s38ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-01 08:20:09 Duration: 7s770ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-01 17:20:07 Duration: 4s805ms Database: brasilia User: intelifix Remote: [local] Application: psql
20 159ms 6s973ms 1s168ms 34 39s729ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 01 09 3 1s617ms 539ms 10 15 25s375ms 1s691ms 13 10 4s832ms 483ms 14 3 2s764ms 921ms 16 2 3s261ms 1s630ms 17 1 1s878ms 1s878ms [ User: intelifix - Total duration: 39s729ms - Times executed: 34 ]
[ Application: [unknown] - Total duration: 39s729ms - Times executed: 34 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-01 10:10:14 Duration: 6s973ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-01 10:45:28 Duration: 6s373ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-01 10:10:00 Duration: 6s212ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 01 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 2s759ms - Times executed: 4 ]
[ Application: psql - Total duration: 2s759ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,280 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 5279 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,246 Max number of times the same event was reported
- 5,300 Total events found
Rank Times reported Error 1 5,246 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 01 00 120 01 118 02 120 03 108 04 120 05 118 06 120 07 239 08 384 09 474 10 429 11 454 12 154 13 234 14 454 15 462 16 233 17 201 18 128 19 118 20 120 21 118 22 120 23 100 - ERROR: prepared statement "_PLAN0000000029D9A1A0" does not exist
- ERROR: prepared statement "_PLAN0000000029BB52E0" does not exist
- ERROR: prepared statement "_PLAN0000000029B61FF0" does not exist
Statement: DEALLOCATE "_PLAN0000000029D9A1A0"
Date: 2026-10-01 00:00:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029BB52E0"
Date: 2026-10-01 00:00:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029B61FF0"
Date: 2026-10-01 00:01:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 12 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 01 14 12 - ERROR: trailing junk after numeric literal at or near "203543560ACC" at character 27
- ERROR: trailing junk after numeric literal at or near "203543560ACC" at character 27
- ERROR: trailing junk after numeric literal at or near "203543560ACC" at character 27
Statement: select * from rs_caixa_qr(203543560ACC)
Date: 2026-10-01 14:12:49 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(203543560ACC)
Date: 2026-10-01 14:12:49 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(203543560ACC)
Date: 2026-10-01 14:12:52 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
3 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 01 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-01 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-01 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-01 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
4 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 01 15 3 17 6 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "diagnostics" at character 42
Statement: select * from rs_caixa_qr(3750849 ])
Date: 2026-10-01 15:04:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3750849 ])
Date: 2026-10-01 15:04:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SeagullMessage diagnostics:)
Date: 2026-10-01 15:28:13 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 01 04 1 10 1 12 1 16 2 17 1 21 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-01 04:43:59 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-01 10:36:55 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-01 12:42:46 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
6 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 01 05 4 08 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-01 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-01 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-01 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
7 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 01 09 2 11 1 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
- ERROR: column "cai_id" does not exist at character 39
Statement: select * from rs_caixa_qr(v)
Date: 2026-10-01 09:04:00 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-10-01 09:04:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: Perhaps you meant to reference the column "temp0000227370.cli_id".
Statement: SELECT * FROM temp0000227370 ORDER BY CAI_ID DESCDate: 2026-10-01 11:14:44 Database: contagem Application: [unknown] User: intelifix Remote: [local]
8 2 ERROR: upper bound of FOR loop cannot be null
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 01 17 2 - ERROR: upper bound of FOR loop cannot be null
- ERROR: upper bound of FOR loop cannot be null
Context: PL/pgSQL function rs_numeros(character varying) line 19 at FOR with integer loop variable PL/pgSQL function rs_pre_alerta_tela(text) line 32 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"464164100102","barra2":"184291015","barra3":"","lote":"59984"}');Date: 2026-10-01 17:08:47 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_numeros(character varying) line 19 at FOR with integer loop variable PL/pgSQL function rs_pre_alerta_tela(text) line 32 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"464164100102","barra2":"184291015","barra3":"","lote":"59984"}');Date: 2026-10-01 17:09:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
9 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 01 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-01 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-01 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 01 14 2 - ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-10-01 14:39:21 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-10-01 14:46:54 Database: contagem 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 Oct 01 00 1 - LOG: process 537675 still waiting for AccessExclusiveLock on relation 362317 of database 358220 after 1000.094 ms
Detail: Process holding the lock: 534807. Wait queue: 537675.
Context: SQL statement "DROP TABLE IF EXISTS auditor.AUDITOR_2026_06" PL/pgSQL function rs_auditor_novas_tabelas(date) line 75 at EXECUTE
Statement: SELECT * FROM RS_AUDITOR_NOVAS_TABELAS()Date: 2026-10-01 00:02:03 Database: rio Application: psql User: lenon Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Oct 01 03 1 - LOG: database system was shut down at 2026-10-01 03:05:01 -03
Date: 2026-10-01 03:05:02