pgBadger-
Global information
- Generated on Thu Sep 17 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 39,014 log entries in 14s
- Log start from 2026-09-17 00:00:21 to 2026-09-17 23:50:00
-
Overview
Global Stats
- 352 Number of unique normalized queries
- 4,938 Number of queries
- 7h43m8s Total query duration
- 2026-09-17 00:02:19 First query
- 2026-09-17 23:43:37 Last query
- 5 queries/s at 2026-09-17 23:42:57 Query peak
- 7h43m8s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h43m8s Execute total duration
- 4,584 Number of events
- 13 Number of unique normalized events
- 4,535 Max number of times the same event was reported
- 0 Number of cancellation
- 349 Total number of automatic vacuums
- 768 Total number of automatic analyzes
- 20 Number temporary file
- 246.23 MiB Max size of temporary file
- 67.01 MiB Average size of temporary file
- 339 Total number of sessions
- 8 sessions at 2026-09-17 11:57:40 Session peak
- 12d17h49m40s Total duration of sessions
- 54m7s Average duration of sessions
- 14 Average queries per session
- 1m21s Average queries duration per session
- 52m45s Average idle time per session
- 354 Total number of connections
- 4 connections/s at 2026-09-17 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-17 23:42:57 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-17 10:31:43 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-17 23:42:57 Date
Queries duration
Key values
- 7h43m8s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 17 00 22 0ms 42s825ms 6s602ms 5s428ms 7s388ms 1m32s 01 12 0ms 6s254ms 2s942ms 4s514ms 6s47ms 7s633ms 02 12 0ms 5s526ms 2s527ms 4s71ms 4s723ms 6s985ms 03 12 0ms 8s531ms 3s17ms 2s233ms 6s457ms 10s52ms 04 12 0ms 8s595ms 3s426ms 4s648ms 6s862ms 9s991ms 05 16 0ms 11m56s 1m40s 17s449ms 3m38s 11m56s 06 19 0ms 30s58ms 6s47ms 1s640ms 21s712ms 46s96ms 07 152 0ms 9m7s 14s874ms 1m7s 6m36s 9m8s 08 409 0ms 5m47s 2s803ms 30s325ms 52s161ms 5m47s 09 501 150ms 6m49s 4s302ms 1m5s 1m54s 11m43s 10 502 151ms 6m44s 4s918ms 54s181ms 6m8s 10m41s 11 483 150ms 5m40s 3s348ms 46s411ms 4m15s 5m47s 12 143 0ms 5m55s 11s148ms 46s353ms 5m25s 5m59s 13 354 0ms 5m25s 3s739ms 38s799ms 54s99ms 6m 14 796 150ms 6m13s 3s333ms 58s750ms 5m39s 6m58s 15 458 150ms 5m42s 6s111ms 4m36s 5m50s 6m 16 302 0ms 5m25s 3s322ms 22s952ms 53s293ms 5m25s 17 160 0ms 5m44s 7s132ms 46s69ms 3m30s 5m44s 18 21 0ms 5m28s 29s749ms 1s631ms 49s863ms 5m28s 19 18 0ms 5m11s 32s485ms 1s636ms 1s774ms 5m57s 20 111 0ms 5m31s 10s552ms 1m4s 1m15s 6m28s 21 29 0ms 5m26s 21s375ms 3s756ms 15s320ms 5m57s 22 26 0ms 5m11s 23s308ms 5s247ms 6s318ms 5m56s 23 368 0ms 1m5s 5s440ms 1m6s 1m7s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 17 00 3 0 7s665ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 368ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 8 0 6s719ms 0ms 0ms 6s175ms 07 100 0 18s205ms 4s268ms 44s27ms 6m36s 08 323 0 2s815ms 6s920ms 18s331ms 3m57s 09 399 0 4s267ms 10s754ms 29s425ms 6m 10 402 0 5s393ms 9s952ms 41s841ms 6m14s 11 375 0 3s675ms 10s384ms 34s483ms 5m44s 12 94 0 15s118ms 3s904ms 31s669ms 5m42s 13 253 0 3s866ms 13s852ms 21s450ms 3m35s 14 645 0 3s92ms 22s772ms 40s727ms 5m51s 15 358 0 6s753ms 22s956ms 3m53s 5m50s 16 250 0 3s655ms 10s176ms 20s551ms 3m46s 17 126 0 8s389ms 5s121ms 22s679ms 3m50s 18 9 0 1m7s 0ms 0ms 3m48s 19 6 0 1m35s 0ms 0ms 3m32s 20 13 82 12s116ms 42s597ms 1m2s 3m35s 21 11 0 53s789ms 0ms 0ms 3m36s 22 8 0 1m11s 0ms 0ms 3m31s 23 44 322 5s466ms 1m3s 1m6s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 17 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 17 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 11 11.00 0.00% 08 0 12 12.00 0.00% 09 0 16 16.00 0.00% 10 0 8 8.00 0.00% 11 0 12 12.00 0.00% 12 0 4 4.00 0.00% 13 0 9 9.00 0.00% 14 0 14 14.00 0.00% 15 0 11 11.00 0.00% 16 0 8 8.00 0.00% 17 0 3 3.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 1 1.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Sep 17 00 18 0.01/s 01 9 0.00/s 02 9 0.00/s 03 15 0.00/s 04 6 0.00/s 05 8 0.00/s 06 14 0.00/s 07 17 0.00/s 08 21 0.01/s 09 20 0.01/s 10 20 0.01/s 11 19 0.01/s 12 14 0.00/s 13 22 0.01/s 14 25 0.01/s 15 19 0.01/s 16 21 0.01/s 17 10 0.00/s 18 10 0.00/s 19 9 0.00/s 20 13 0.00/s 21 13 0.00/s 22 10 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Sep 17 00 5 50m 49m31s 01 16 1h1m6s 1h1m4s 02 9 1h 59m57s 03 17 24m19s 24m16s 04 7 1h2m34s 1h2m28s 05 7 52m51s 49m1s 06 7 57m51s 57m35s 07 15 55m20s 52m49s 08 14 59m37s 58m15s 09 23 56m18s 54m44s 10 17 57m12s 54m47s 11 19 55m26s 54m1s 12 20 56m3s 54m44s 13 11 51m49s 49m49s 14 23 55m42s 53m47s 15 22 59m40s 57m33s 16 22 51m59s 51m14s 17 16 1h10s 58m59s 18 11 57m23s 56m27s 19 10 1h4s 59m5s 20 12 46m14s 44m37s 21 11 55m27s 54m31s 22 12 1h32s 59m42s 23 13 34m52s 32m18s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-17 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 354 connections Total
Connections per user
Key values
- intelifix Main User
- 354 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-17 11:57:40 Date
Histogram of session times
Key values
- 278 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 339 sessions Total
Sessions per user
Key values
- intelifix Main User
- 339 sessions Total
Sessions per host
Key values
- [local] Main Host
- 339 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 48,726 buffers Checkpoint Peak
- 2026-09-17 00:09:40 Date
- 270.031 seconds Highest write time
- 0.126 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-09-17 15:24:35 Date
Checkpoints distance
Key values
- 298.80 Mo Distance Peak
- 2026-09-17 15:24:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 17 00 66,590 711.953s 0.151s 712.166s 01 2,727 273.156s 0.212s 273.512s 02 2,347 234.879s 0.03s 234.935s 03 2,274 227.083s 0.185s 227.296s 04 2,806 281.066s 0.117s 281.211s 05 10,576 1,058.402s 0.109s 1,058.567s 06 6,517 414.502s 0.006s 414.514s 07 26,443 1,931.262s 0.205s 1,931.531s 08 35,131 2,934.059s 0.323s 2,934.507s 09 49,156 3,187.345s 0.23s 3,187.665s 10 60,755 3,238.176s 0.401s 3,238.682s 11 57,750 3,239.211s 0.329s 3,239.622s 12 31,241 2,381.931s 0.196s 2,382.184s 13 37,195 2,435.887s 0.344s 2,436.312s 14 52,133 3,121.001s 0.528s 3,121.665s 15 69,852 3,238.093s 0.342s 3,238.534s 16 48,127 3,097.27s 0.29s 3,097.635s 17 38,508 2,336.455s 0.216s 2,336.729s 18 2,272 228.611s 0.021s 228.651s 19 28 2.813s 0.002s 2.819s 20 1,296 131.99s 0.011s 132.011s 21 2,877 288.217s 0.144s 288.39s 22 2,670 267.496s 0.07s 267.661s 23 293 29.397s 0.083s 29.499s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 17 00 0 0 11 490 0.063s 0.007s 01 0 0 1 431 0.063s 0.006s 02 0 0 1 397 0.006s 0.006s 03 0 0 0 343 0.062s 0.008s 04 0 0 1 426 0.063s 0.006s 05 0 0 5 717 0.036s 0.008s 06 0 0 1 95 0.002s 0.002s 07 0 0 22 2,352 0.062s 0.012s 08 0 0 14 5,044 0.062s 0.012s 09 0 0 38 5,724 0.025s 0.012s 10 0 0 42 5,649 0.052s 0.012s 11 0 0 31 5,416 0.060s 0.012s 12 0 0 19 3,454 0.057s 0.012s 13 0 0 30 5,031 0.062s 0.011s 14 0 0 66 7,377 0.063s 0.012s 15 0 0 56 6,798 0.060s 0.012s 16 0 0 20 5,601 0.063s 0.012s 17 0 0 21 3,998 0.063s 0.012s 18 0 0 0 311 0.007s 0.005s 19 0 0 0 7 0.002s 0.001s 20 0 0 1 85 0.003s 0.003s 21 0 0 1 495 0.063s 0.008s 22 0 0 1 422 0.033s 0.011s 23 0 0 0 78 0.062s 0.008s Day Hour Count Avg time (sec) Sep 17 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 17 00 29,366.50 kB 76,680.50 kB 01 2,375.83 kB 44,594.33 kB 02 2,058.17 kB 24,717.00 kB 03 1,913.29 kB 5,110.43 kB 04 2,674.83 kB 3,783.83 kB 05 9,462.50 kB 13,945.00 kB 06 6,979.00 kB 12,907.00 kB 07 29,775.17 kB 68,453.25 kB 08 19,375.92 kB 62,450.67 kB 09 52,641.08 kB 82,391.92 kB 10 56,678.25 kB 90,698.75 kB 11 42,947.58 kB 85,410.17 kB 12 25,118.50 kB 52,063.08 kB 13 44,863.91 kB 75,755.45 kB 14 89,546.67 kB 128,744.08 kB 15 77,636.92 kB 124,393.50 kB 16 26,820.00 kB 72,578.25 kB 17 28,532.33 kB 85,705.75 kB 18 1,690.60 kB 58,004.60 kB 19 205.00 kB 42,066.00 kB 20 2,648.33 kB 34,804.33 kB 21 1,926.71 kB 21,680.00 kB 22 1,380.80 kB 9,949.90 kB 23 191.17 kB 4,597.17 kB -
Temporary Files
Size of temporary files
Key values
- 492.47 MiB Temp Files size Peak
- 2026-09-17 05:31:59 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-17 05:32:06 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 17 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.01 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.72 MiB 246.23 MiB 64.62 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-17 05:32:08 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-17 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 306.31 MiB 56.94 MiB 93.70 MiB 76.58 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-17 05:30:43 Duration: 40s243ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-17 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 246.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 246.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-17 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-17 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-17 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-17 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-17 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 26.20 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-17 15:35:37 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 26.20 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-17 15:35:37 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (104) Main table analyzed (database rio)
- 768 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 104 rio.public.temp0000291669 55 rio.pg_catalog.pg_class 52 rio.public.usuarios 50 rio.public.temp0000291745 46 rio.pg_catalog.pg_type 43 brasilia.pg_catalog.pg_attribute 38 rio.pg_catalog.pg_index 27 rio.public.temp0000291585 27 rio.public.temp0000291687 25 rio.public.temp0000291677 21 contagem.public.usuarios 20 rio.pg_catalog.pg_depend 19 brasilia.pg_catalog.pg_class 16 contagem.pg_catalog.pg_attribute 14 rio.public.temp0000291717 14 brasilia.public.temp0000240360 13 brasilia.pg_catalog.pg_type 13 rio.public.temp0000291721 11 rio.public.temp0000291083 11 brasilia.public.usuarios 10 brasilia.pg_catalog.pg_index 7 rio.public.temp0000290026 7 rio.public.temp0000291755 6 contagem.pg_catalog.pg_class 6 contagem.public.temp0000227202 6 rio.public.temp0000290230 6 brasilia.pg_catalog.pg_depend 5 brasilia.public.temp0000240424 5 brasilia.public.temp0000240382 4 rio.public.tmp_drill_0302 4 brasilia.public.temp0000240396 4 contagem.pg_catalog.pg_type 4 rio.public.temp0000291781 4 rio.public.tmp_drill_0175 4 brasilia.public.temp0000240406 4 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000291575 3 brasilia.public.temp0000240364 3 rio.public.temp0000291643 3 contagem.public.temp0000227186 3 rio.public.temp0000291777 3 contagem.public.temp0000227188 3 rio.public.temp0000291689 3 rio.public.temp0000291691 3 contagem.pg_catalog.pg_index 3 contagem.pg_catalog.pg_shdepend 2 brasilia.public.temp0000240416 2 brasilia.public.temp0000240388 2 rio.public.temp0000291673 2 brasilia.public.temp0000240426 2 contagem.pg_catalog.pg_depend 2 rio.public.temp0000291685 2 contagem.public.temp0000227206 1 rio.public.temp0000291683 1 brasilia.public.temp0000240400 1 brasilia.public.temp0000240408 1 rio.public.temp0000291699 1 rio.public.temp0000291703 1 brasilia.public.temp0000240410 1 brasilia.pg_catalog.pg_shdepend 1 contagem.public.temp0000227204 1 rio.public.temp0000291671 1 brasilia.public.temp0000240372 1 rio.public.temp0000291759 1 rio.public.temp0000291757 1 rio.public.temp0000291681 1 rio.public.temp0000290893 1 rio.public.temp0000290921 1 contagem.public.nf_entrada 1 brasilia.public.temp0000240428 1 Total 768 Vacuums per table
Key values
- public.temp0000291669 (56) Main table vacuumed on database rio
- 349 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.temp0000291669 56 0 0 0 0 0 0 32,972 365 2,229,418 0 0 rio.pg_catalog.pg_attribute 31 31 0 0 0 0 0 16,950 4,835 6,809,810 285 7,128 rio.public.temp0000291745 30 0 0 0 0 0 0 21,334 2,053 3,777,485 0 0 rio.public.temp0000291585 23 0 0 0 0 0 0 8,228 111 502,707 0 0 contagem.public.usuarios 21 0 0 0 0 0 0 105 81 40,715 0 0 rio.pg_catalog.pg_class 15 15 0 0 0 0 0 3,138 1,271 1,830,634 91 337 rio.pg_catalog.pg_type 14 14 0 0 0 0 0 1,345 510 637,958 54 185 rio.public.temp0000291083 11 0 0 0 0 0 0 809 59 56,784 0 0 rio.public.temp0000291721 10 0 0 0 0 0 0 748 209 305,576 0 0 brasilia.pg_catalog.pg_attribute 10 10 0 0 0 0 0 4,735 1,396 2,188,815 43 1,087 rio.public.temp0000291687 8 0 0 0 0 0 0 453 43 33,013 0 0 rio.pg_catalog.pg_index 8 8 0 0 0 0 0 477 149 147,817 23 49 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,499 2,023 8,635,246 1,027 4,866 rio.public.temp0000290026 7 0 0 0 0 0 0 510 37 35,631 0 0 rio.public.temp0000291755 6 0 0 0 0 0 0 10,839 3,632 5,309,393 0 0 rio.pg_catalog.pg_depend 6 6 0 0 0 0 0 2,223 861 1,130,335 47 372 contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 3,921 893 1,637,942 16 399 rio.public.temp0000290230 6 0 0 0 0 0 0 347 34 25,690 0 0 rio.public.tmp_drill_0302 5 4 0 0 0 0 0 4,301 12 705,869 0 0 rio.public.usuarios 5 5 0 0 0 0 0 136 50 116,604 7 18 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 689 271 434,783 22 64 brasilia.pg_catalog.pg_type 4 4 0 0 0 0 0 304 139 197,136 6 24 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,261 509 3,117,641 166 588 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 1,538 12 265,974 0 0 brasilia.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 501 167 264,359 32 58 contagem.pg_catalog.pg_class 3 3 0 0 0 0 0 642 112 183,000 7 18 rio.public.temp0000291575 3 0 0 0 0 0 0 198 12 13,491 0 0 rio.public.temp0000291777 3 0 0 0 0 0 0 5,424 12 321,825 0 0 brasilia.public.temp0000240416 2 0 0 0 0 0 0 506 8 31,060 0 0 brasilia.public.temp0000240364 2 0 0 0 0 0 0 506 8 31,060 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 76 35 22,277 5 16 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,687 1,280 4,714,558 1,129 7,359 contagem.pg_catalog.pg_type 2 2 0 0 0 0 0 287 59 95,080 2 4 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 329 97 443,249 36 93 brasilia.public.temp0000240406 2 0 0 0 0 0 0 159 12 11,245 0 0 rio.public.temp0000291685 2 0 0 0 0 0 0 8 6 1,548 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 153 33 37,132 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 603 231 282,747 10 74 rio.public.temp0000291673 1 0 0 0 0 0 0 65 4 4,438 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,308 9 177,460 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 28,517 17,068 21,350,165 5,647 120,590 contagem.public.temp0000227204 1 0 0 0 0 0 0 115 114 191,081 0 0 contagem.public.temp0000227206 1 0 0 0 0 0 0 115 6 7,756 0 0 brasilia.public.temp0000240408 1 0 0 0 0 0 0 253 4 15,530 0 0 rio.public.temp0000291699 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.temp0000291683 1 0 0 0 0 0 0 4 3 774 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 128 6 23,190 0 0 brasilia.public.temp0000240400 1 0 0 0 0 0 0 253 4 15,530 0 0 contagem.pg_catalog.pg_depend 1 1 0 0 0 0 0 560 118 256,169 0 0 rio.public.temp0000291757 1 0 0 0 0 0 0 74 6 5,257 0 0 rio.public.temp0000291681 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.temp0000291691 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.auditor.auditor_2026_09 1 0 0 0 0 0 0 134,045 65,366 83,111,568 34,356 648,935 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 22,369 16,108 20,822,617 3,181 58,193 Total 349 143 0 0 0 0 0 328,945 120,455 172,620,633 46,192 850,457 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (26.2) 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.temp0000291669 0 0 1.21 rio.pg_catalog.pg_attribute 0 0 2.52 rio.public.temp0000291745 0 0 0.59 rio.public.temp0000291585 0 0 0.29 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.72 rio.pg_catalog.pg_type 0 0 0.21 rio.public.temp0000291083 0 0 0.02 rio.public.temp0000291721 0 0 0.03 brasilia.pg_catalog.pg_attribute 0 0 1.52 rio.public.temp0000291687 0 0 0.01 rio.pg_catalog.pg_index 0 0 0.26 rio.pg_catalog.pg_statistic 0 0 0.98 rio.public.temp0000290026 0 0 0.01 rio.public.temp0000291755 0 0 0.31 rio.pg_catalog.pg_depend 0 0 0.76 contagem.pg_catalog.pg_attribute 0 0 0.65 rio.public.temp0000290230 0 0 0.01 rio.public.tmp_drill_0302 0 0 0.11 rio.public.usuarios 0 0 0.06 brasilia.pg_catalog.pg_class 0 0 0.34 brasilia.pg_catalog.pg_type 0 0 0.33 rio.pg_toast.pg_toast_2619 0 0 0.34 rio.public.tmp_drill_0175 0 0 0.04 brasilia.pg_catalog.pg_shdepend 0 0 0.8 contagem.pg_catalog.pg_class 0 0 0.32 rio.public.temp0000291575 0 0 0 rio.public.temp0000291777 0 0 0.13 brasilia.public.temp0000240416 0 0 0 brasilia.public.temp0000240364 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.22 brasilia.pg_catalog.pg_statistic 0 0 0.36 contagem.pg_catalog.pg_type 0 0 0.2 brasilia.pg_toast.pg_toast_2619 0 0 0.01 brasilia.public.temp0000240406 0 0 0 rio.public.temp0000291685 0 0 0.08 contagem.pg_catalog.pg_index 0 0 0.17 brasilia.pg_catalog.pg_depend 0 0 0.56 rio.public.temp0000291673 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.06 contagem.auditor.auditor_2026_09 0 0 5.35 contagem.public.temp0000227204 0 0 0.01 contagem.public.temp0000227206 0 0 0 brasilia.public.temp0000240408 0 0 0 rio.public.temp0000291699 0 0 0 rio.public.temp0000291683 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000240400 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.24 rio.public.temp0000291757 0 0 0 rio.public.temp0000291681 0 0 0 rio.public.temp0000291691 0 0 0 rio.auditor.auditor_2026_09 0 0 26.2 brasilia.auditor.auditor_2026_09 0 0 5.51 Total 0 0 51.54 Tuples removed per table
Key values
- pg_catalog.pg_attribute (119074) Main table with removed tuples on database rio
- 324308 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 31 31 119,074 738,645 8,501 105 17,922 rio.public.tmp_drill_0302 5 4 65,205 66,995 680 0 1,668 brasilia.pg_catalog.pg_attribute 10 10 35,042 220,565 0 53 5,413 contagem.pg_catalog.pg_attribute 6 6 29,597 145,807 68 215 3,370 rio.public.tmp_drill_0175 4 4 20,817 23,073 0 0 584 rio.pg_catalog.pg_statistic 7 7 12,450 56,737 414 0 9,002 rio.pg_catalog.pg_depend 6 6 6,972 114,678 503 0 1,122 brasilia.pg_catalog.pg_statistic 2 2 4,949 15,368 0 0 2,144 rio.auditor.auditor_2026_09 1 0 4,586 11,892,521 0 0 557,294 contagem.pg_catalog.pg_statistic 1 1 4,294 7,274 0 0 1,011 rio.pg_catalog.pg_type 14 14 3,548 32,076 246 8 987 brasilia.pg_catalog.pg_shdepend 3 3 3,520 40,772 16 0 375 rio.pg_catalog.pg_class 15 15 3,414 64,261 240 0 2,131 contagem.pg_catalog.pg_type 2 2 1,702 5,320 4 35 153 rio.pg_catalog.pg_index 8 8 1,473 15,431 53 7 420 contagem.public.usuarios 21 0 1,320 504 0 0 42 brasilia.auditor.auditor_2026_09 1 0 1,270 2,732,212 0 0 119,724 rio.pg_toast.pg_toast_2619 4 4 1,095 2,717 8 98 744 contagem.pg_catalog.pg_index 2 2 908 3,795 2 5 108 brasilia.pg_catalog.pg_depend 2 2 773 35,736 0 23 336 brasilia.pg_catalog.pg_class 4 4 578 13,553 24 0 492 rio.public.usuarios 5 5 447 2,879 334 0 95 brasilia.pg_catalog.pg_type 4 4 365 8,814 2 13 228 contagem.pg_catalog.pg_class 3 3 295 10,212 8 0 480 brasilia.pg_toast.pg_toast_2619 2 2 207 291 0 0 138 contagem.pg_catalog.pg_depend 1 1 145 18,778 12 0 199 brasilia.pg_catalog.pg_index 2 2 135 3,766 0 6 92 contagem.pg_toast.pg_toast_2619 1 1 127 112 0 0 57 rio.public.temp0000291673 1 0 0 1,222 0 0 64 rio.public.temp0000291745 30 0 0 335,577 0 835 22,013 brasilia.public.temp0000240416 2 0 0 6,651 0 0 512 rio.public.temp0000291755 6 0 0 153,408 0 0 11,136 brasilia.public.temp0000240364 2 0 0 6,650 0 0 512 rio.public.temp0000291687 8 0 0 20,634 0 112 464 contagem.auditor.auditor_2026_09 1 0 0 2,146,358 0 0 97,831 rio.public.temp0000291083 11 0 0 42,591 0 316 964 contagem.public.temp0000227204 1 0 0 1,378 0 21 107 rio.public.temp0000291669 56 0 0 628,365 0 625 44,815 rio.public.temp0000291575 3 0 0 3,681 0 0 192 contagem.public.temp0000227206 1 0 0 1,379 0 21 107 rio.public.temp0000291721 10 0 0 38,224 0 364 852 brasilia.public.temp0000240408 1 0 0 3,325 0 0 256 rio.public.temp0000291699 1 0 0 1,233 0 0 64 rio.public.temp0000291683 1 0 0 1,227 0 0 64 brasilia.public.temp0000240400 1 0 0 3,325 0 0 256 rio.public.temp0000291585 23 0 0 164,807 0 689 10,575 rio.public.temp0000291757 1 0 0 1,248 0 62 66 rio.public.temp0000291681 1 0 0 1,227 0 0 64 rio.public.temp0000290230 6 0 0 21,109 0 234 470 rio.public.temp0000291691 1 0 0 1,227 0 0 64 brasilia.public.temp0000240406 2 0 0 2,077 0 115 141 rio.public.temp0000291685 2 0 0 51,174 0 0 3,712 rio.public.temp0000291777 3 0 0 76,766 0 0 5,568 rio.public.temp0000290026 7 0 0 24,094 0 157 547 Total 349 143 324,308 20,011,849 11,115 4,119 927,747 Pages removed per table
Key values
- public.temp0000291745 (835) Main table with removed pages on database rio
- 4119 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291745 30 0 0 835 rio.public.temp0000291585 23 0 0 689 rio.public.temp0000291669 56 0 0 625 rio.public.temp0000291721 10 0 0 364 rio.public.temp0000291083 11 0 0 316 rio.public.temp0000290230 6 0 0 234 contagem.pg_catalog.pg_attribute 6 6 29597 215 rio.public.temp0000290026 7 0 0 157 brasilia.public.temp0000240406 2 0 0 115 rio.public.temp0000291687 8 0 0 112 rio.pg_catalog.pg_attribute 31 31 119074 105 rio.pg_toast.pg_toast_2619 4 4 1095 98 rio.public.temp0000291757 1 0 0 62 brasilia.pg_catalog.pg_attribute 10 10 35042 53 contagem.pg_catalog.pg_type 2 2 1702 35 brasilia.pg_catalog.pg_depend 2 2 773 23 contagem.public.temp0000227204 1 0 0 21 contagem.public.temp0000227206 1 0 0 21 brasilia.pg_catalog.pg_type 4 4 365 13 rio.pg_catalog.pg_type 14 14 3548 8 rio.pg_catalog.pg_index 8 8 1473 7 brasilia.pg_catalog.pg_index 2 2 135 6 contagem.pg_catalog.pg_index 2 2 908 5 rio.public.temp0000291673 1 0 0 0 brasilia.public.temp0000240416 2 0 0 0 rio.public.temp0000291755 6 0 0 0 brasilia.public.temp0000240364 2 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4294 0 contagem.auditor.auditor_2026_09 1 0 0 0 contagem.public.usuarios 21 0 1320 0 brasilia.pg_catalog.pg_shdepend 3 3 3520 0 rio.public.tmp_drill_0302 5 4 65205 0 contagem.pg_catalog.pg_class 3 3 295 0 brasilia.pg_catalog.pg_class 4 4 578 0 rio.public.temp0000291575 3 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 4949 0 rio.pg_catalog.pg_class 15 15 3414 0 brasilia.public.temp0000240408 1 0 0 0 rio.public.temp0000291699 1 0 0 0 rio.public.temp0000291683 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 127 0 brasilia.public.temp0000240400 1 0 0 0 rio.public.usuarios 5 5 447 0 rio.pg_catalog.pg_depend 6 6 6972 0 contagem.pg_catalog.pg_depend 1 1 145 0 rio.public.tmp_drill_0175 4 4 20817 0 rio.pg_catalog.pg_statistic 7 7 12450 0 rio.public.temp0000291681 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 207 0 rio.public.temp0000291691 1 0 0 0 rio.public.temp0000291685 2 0 0 0 rio.public.temp0000291777 3 0 0 0 rio.auditor.auditor_2026_09 1 0 4586 0 brasilia.auditor.auditor_2026_09 1 0 1270 0 Total 349 143 324,308 4,119 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 17 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 18 31 08 31 73 09 35 80 10 36 87 11 31 70 12 9 32 13 50 92 14 47 101 15 40 99 16 22 57 17 22 42 18 0 0 19 0 0 20 0 0 21 2 4 22 0 0 23 0 0 - 26.20 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1m54s 1m54s 1m54s 1m54s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:57:05 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 00:05:56 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:25:13 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s4ms 1s4ms 1s4ms 1s4ms drop table if exists temp0000291669;-
DROP TABLE IF EXISTS temp0000291669;
Date: 2026-09-17 11:05:40 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291669;
Date: 2026-09-17 10:07:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m54s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-17 07:57:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s4ms DROP TABLE IF EXISTS temp0000291669;[ Date: 2026-09-17 11:05:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,428 Total read queries
- 1,092 Total write queries
Queries by database
Key values
- rio Main database
- 3,200 Requests
- 5h50m2s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,814 Requests
User Request type Count Duration etiquetas Total 32 15s126ms select 32 15s126ms intelifix Total 4,814 7h41m16s copy to 404 42m9s ddl 688 43m43s others 418 47m14s select 3,304 5h28m9s lenon Total 92 1m36s select 92 1m36s Duration by user
Key values
- 7h41m16s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 32 15s126ms select 32 15s126ms intelifix Total 4,814 7h41m16s copy to 404 42m9s ddl 688 43m43s others 418 47m14s select 3,304 5h28m9s lenon Total 92 1m36s select 92 1m36s Queries by host
Key values
- [local] Main host
- 4,938 Requests
- 7h43m8s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,910 Requests
- 3h41m58s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-17 09:45:10 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,147 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m56s analyze verbose;[ Date: 2026-09-17 05:11:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 07:14:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m37s analyze verbose;[ Date: 2026-09-17 05:20:35 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029977, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 09:17:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m44s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 10:14:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029972, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 07:24:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030031, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 14:57:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029987, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 10:57:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029985, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 10:33:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 09:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 12:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 08:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 14:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 17:10:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030036, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 15:21:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029992, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 12:46:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029990, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-17 11:12:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 11:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 15:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-17 20:10:33 - 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 1h44m5s 220 150ms 6m49s 28s389ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 17 06 1 1s452ms 1s452ms 07 11 12m18s 1m7s 08 4 1m27s 21s926ms 09 24 8m17s 20s739ms 10 22 19m46s 53s927ms 11 14 7m12s 30s876ms 12 13 12m16s 56s630ms 13 28 2m20s 5s7ms 14 49 9m41s 11s868ms 15 28 24m40s 52s869ms 16 15 58s370ms 3s891ms 17 11 5m5s 27s749ms [ User: intelifix - Total duration: 1h44m5s - Times executed: 220 ]
[ Application: [unknown] - Total duration: 1h44m5s - Times executed: 220 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029977, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 09:17:18 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 10:14:40 Duration: 6m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029972, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 07:24:29 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h38m30s 48 1s497ms 9m7s 2m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 17 07 3 9m56s 3m18s 08 3 6m13s 2m4s 09 3 6m24s 2m8s 10 3 5m40s 1m53s 11 3 5m59s 1m59s 12 3 6m16s 2m5s 13 3 5m42s 1m54s 14 3 6m4s 2m1s 15 3 5m55s 1m58s 16 3 5m46s 1m55s 17 3 6m7s 2m2s 18 3 5m50s 1m56s 19 3 5m28s 1m49s 20 3 5m51s 1m57s 21 3 5m43s 1m54s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h38m30s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 07:14:09 Duration: 9m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 09:10:57 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 12:10:56 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: psql
3 1h10m19s 48 247ms 4m7s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 17 07 3 5m59s 1m59s 08 3 4m13s 1m24s 09 3 5m41s 1m53s 10 3 4m19s 1m26s 11 3 4m19s 1m26s 12 3 4m3s 1m21s 13 3 4m3s 1m21s 14 3 4m24s 1m28s 15 3 4m13s 1m24s 16 3 4m11s 1m23s 17 3 4m16s 1m25s 18 3 4m16s 1m25s 19 3 4m1s 1m20s 20 3 4m6s 1m22s 21 3 4m6s 1m22s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h10m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 07:20:46 Duration: 4m7s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 09:17:05 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 14:15:28 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
4 24m12s 3 3m38s 11m56s 8m4s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 17 05 3 24m12s 8m4s [ User: intelifix - Total duration: 24m12s - Times executed: 3 ]
[ Application: psql - Total duration: 24m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-17 05:11:57 Duration: 11m56s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-17 05:20:35 Duration: 8m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-17 05:24:13 Duration: 3m38s Database: contagem User: intelifix Remote: [local] Application: psql
5 17m17s 1,127 150ms 8s883ms 920ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 17 07 18 12s90ms 671ms 08 84 1m10s 837ms 09 151 2m11s 868ms 10 141 2m13s 949ms 11 150 2m15s 906ms 12 33 32s27ms 970ms 13 64 1m6s 1s36ms 14 177 2m51s 971ms 15 139 2m9s 931ms 16 115 1m47s 935ms 17 55 46s841ms 851ms [ User: intelifix - Total duration: 17m17s - Times executed: 1127 ]
[ Application: [unknown] - Total duration: 17m17s - Times executed: 1127 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (137422, 397, 'CP230232TC6,D4925E0A389E,544D424200620A73,D4925E0A38A1$CP240332353,08C7F52146F8,544D42420076AEBD,08C7F52146FB$CP230132DE9,D4925E036551,544D424200614908,D4925E036554$CP223932104,A0B53CC03DEC,544D4242005E7149,A0B53CC03DEF$CP23303247G,D4925EE2774F,544D4242006E5B88,D4925EE27752$CP2239320A1,A0B53CC02322,544D4242005E6E4F,A0B53CC02325$CP240332EEK,08C7F522F71C,544D42420076DEC1,08C7F522F71F$CP2327321VT,D4925ED4E4ED,544D4242006DA5F2,D4925ED4E4F0$CP234532763,08C7F502E5D8,544D42420073508D,08C7F502E5DB', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-17 09:12:15 Duration: 8s883ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286897, 304, '833124918002921,230003236768,229930282747,229926656062,229938785473,229907442639,230004338100,229947381621,229997676080,229948074247,229931777280,229927097575,229936671631,230002728605,229957146580,230004056579,229958210108,229993289816,229984958801,229994363344,229997267577,229931707172', '',0287,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-17 11:48:29 Duration: 7s145ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287603, 452, '464246048283,216325887077,216386090911,216744393758,216376611535,216424645167,216575894855,216677211231,216428974860,216457722335,216677926283,216692668080,216380649504', '',034,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-09-17 15:59:13 Duration: 6s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 15m40s 71 10s651ms 1m5s 13s253ms create table temp0000291669 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 17 07 10 2m46s 16s676ms 08 2 21s950ms 10s975ms 09 19 4m39s 14s697ms 10 13 2m39s 12s245ms 11 7 1m20s 11s474ms 12 9 1m47s 11s948ms 14 2 23s801ms 11s900ms 15 9 1m42s 11s350ms [ User: intelifix - Total duration: 15m40s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 15m40s - Times executed: 71 ]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 07:15:54 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 09:26:36 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 09:10:24 Duration: 21s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 12m1s 69 1s570ms 1m28s 10s454ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 17 07 2 30s856ms 15s428ms 08 2 12s113ms 6s56ms 09 10 3m12s 19s291ms 10 4 1m28s 22s99ms 11 8 1m34s 11s832ms 12 2 7s675ms 3s837ms 13 5 20s123ms 4s24ms 14 6 1m3s 10s625ms 15 11 1m37s 8s821ms 16 11 1m14s 6s784ms 17 8 39s202ms 4s900ms [ User: intelifix - Total duration: 12m1s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m1s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 09:09:53 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0395, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 10:23:56 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 09:36:49 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10m27s 161 178ms 42s825ms 3s896ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 17 00 6 1m5s 10s882ms 01 6 26s220ms 4s370ms 02 6 21s373ms 3s562ms 03 5 26s631ms 5s326ms 04 6 32s801ms 5s466ms 05 5 25s630ms 5s126ms 07 10 44s371ms 4s437ms 08 13 55s420ms 4s263ms 09 12 50s553ms 4s212ms 10 12 43s839ms 3s653ms 11 12 44s115ms 3s676ms 12 11 30s448ms 2s768ms 13 6 9s318ms 1s553ms 14 12 35s536ms 2s961ms 15 12 51s959ms 4s329ms 16 9 24s213ms 2s690ms 17 5 2s995ms 599ms 20 1 641ms 641ms 21 6 14s90ms 2s348ms 22 6 21s857ms 3s642ms [ User: intelifix - Total duration: 10m27s - Times executed: 161 ]
[ Application: psql - Total duration: 10m27s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 00:05:44 Duration: 42s825ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 05:15:17 Duration: 15s773ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 07:35:12 Duration: 11s795ms Database: rio User: intelifix Remote: [local] Application: psql
9 8m40s 44 10s754ms 13s322ms 11s822ms create table temp0000291745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 17 13 15 3m4s 12s273ms 14 29 5m36s 11s589ms [ User: intelifix - Total duration: 8m40s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 8m40s - Times executed: 44 ]
-
CREATE TABLE temp0000291745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 13:49:22 Duration: 13s322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 13:50:08 Duration: 13s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 14:08:04 Duration: 13s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m29s 700 151ms 5s759ms 642ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 17 07 1 2s203ms 2s203ms 08 94 59s878ms 637ms 09 92 53s154ms 577ms 10 131 1m16s 583ms 11 105 1m2s 595ms 12 12 6s70ms 505ms 13 68 42s203ms 620ms 14 51 44s546ms 873ms 15 75 50s679ms 675ms 16 55 43s786ms 796ms 17 16 8s375ms 523ms [ User: intelifix - Total duration: 7m29s - Times executed: 700 ]
[ Application: [unknown] - Total duration: 7m29s - Times executed: 700 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288337", "modelo" : "463", "itens" : "241752240420,241736513946,241750243535,241757397173,241755145461,241781631728,241752104850,241787450523,241750172440,241719060010,241794314357,241750145972,241794165779,241718917189,241754704756,241757980520,241749965169,241787545660,241753197493,241748324661,241755068103,241721651935,241753645573,241721569401,241779570719,241748394567,241721548691,241783460414,241720053350,241736501016,241755621928,241784087174,241722370322,241754615555,241755905973,241784504365,241790285153,241791627495,241782078089,241790242748,241756890627,241720775272,241754702837,241723781234,241735982626,241757962437,241736601834,241721043233,241754135475,241782508591,241784080508,241750457293,241783445866,241724300914,241758964465,241705956373,241755964262,241748842950,241725853759,241720458899", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 14:11:59 Duration: 5s759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288346", "modelo" : "463", "itens" : "241794085569,241750014040,241783398588,241722357794,241757013949,241722508594,241750095765,241735320912,241782568597,241720094061,241748286677,241721341321,241722075062,241750552937,241784467290,241794064860,241782491621,241720879603,241752382936,241737812547,241724321623,241720303655,241722359310,241754303651,241758627585,241784485777,241781711635,241784137381,241720346262,241750601225,241784078082,241780565978,241736072231,241722083548,241755678903,241782336476,241783318200,241782070211,241753203656,241748442832,241706146975,241757193338,241755783638,241755890013,241723273350,241753544553,241784686784,241794161941,241723820609,241704907595,241794325469,241750264547,241734608686,241784742828,241748778195,241752224155,241784452037,241750240202,241782096576,241784638799", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 14:25:49 Duration: 3s958ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288337", "modelo" : "463", "itens" : "241787444461,241748895053,241750207897,241736839511,241723501128,241736588195,241784440723,241781433751,241758928097,241720743855,241794145373,241736859210,241724226282,241781503152,241751123958,241784506082,241723117071,241751487786,241753189614,241755965373,241753678506,241748403636,241735052345,241751051022,241750453960,241721607182,241724404964,241754121939,241784144049,241758062323,241735755353,241722484552,241790054850,241721594252,241724181430,241784453249,241722343147,241782319707,241753696262,241748506676,241758555457,241757020011,241781795660,241750494648,241755974970,241757644751,241724184965,241722517888,241724053235,241755134248,241735068787,241758065353,241779570820,241754711222,241705949908,241722910004,241784125663,241752388289,241720492843,241705005966", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 13:57:14 Duration: 3s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m2s 147 176ms 1m56s 2s463ms call rs_giga_triagem (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 17 00 7 21s639ms 3s91ms 01 6 9s88ms 1s514ms 02 6 8s960ms 1s493ms 03 6 9s209ms 1s534ms 04 6 8s322ms 1s387ms 05 6 9s620ms 1s603ms 06 6 9s371ms 1s561ms 07 7 2m8s 18s367ms 08 6 9s803ms 1s633ms 09 7 14s37ms 2s5ms 10 8 13s718ms 1s714ms 11 7 11s188ms 1s598ms 12 6 9s338ms 1s556ms 13 6 9s566ms 1s594ms 14 7 10s26ms 1s432ms 15 6 9s275ms 1s545ms 16 6 9s304ms 1s550ms 17 6 9s629ms 1s604ms 18 6 9s143ms 1s523ms 19 6 9s619ms 1s603ms 20 8 13s777ms 1s722ms 21 6 9s63ms 1s510ms 22 6 9s886ms 1s647ms [ User: intelifix - Total duration: 6m2s - Times executed: 147 ]
[ Application: psql - Total duration: 6m2s - Times executed: 147 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:57:05 Duration: 1m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 00:05:56 Duration: 11s727ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:25:13 Duration: 5s166ms Database: rio User: intelifix Remote: [local] Application: psql
12 4m37s 1 4m37s 4m37s 4m37s select * from rs_fast_excel (?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 17 14 1 4m37s 4m37s [ User: intelifix - Total duration: 4m37s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 4m37s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-09-01''),DATE(''2026-09-16'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-17 14:09:49 Duration: 4m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m30s 35 158ms 38s607ms 6s22ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 17 07 2 43s395ms 21s697ms 08 2 4s928ms 2s464ms 09 4 38s345ms 9s586ms 10 4 29s412ms 7s353ms 11 1 4s276ms 4s276ms 12 2 11s507ms 5s753ms 13 7 45s723ms 6s531ms 14 9 20s43ms 2s227ms 15 4 13s162ms 3s290ms [ User: intelifix - Total duration: 3m30s - Times executed: 35 ]
[ Application: psql - Total duration: 3m30s - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029972);
Date: 2026-09-17 07:18:03 Duration: 38s607ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029978);
Date: 2026-09-17 09:31:06 Duration: 22s940ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029994);
Date: 2026-09-17 13:41:19 Duration: 18s365ms Database: rio User: intelifix Remote: [local] Application: psql
14 3m4s 16 11s20ms 13s760ms 11s548ms create table temp0000291585 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 17 08 2 25s455ms 12s727ms 14 8 1m31s 11s404ms 15 4 44s922ms 11s230ms 16 2 23s155ms 11s577ms [ User: intelifix - Total duration: 3m4s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m4s - Times executed: 16 ]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 08:56:53 Duration: 13s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 14:52:41 Duration: 12s136ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 14:52:12 Duration: 11s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m38s 58 2s146ms 17s72ms 2s734ms create table temp0000291669 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 17 07 11 25s145ms 2s285ms 08 13 29s536ms 2s272ms 09 14 48s134ms 3s438ms 10 4 12s979ms 3s244ms 11 11 28s804ms 2s618ms 15 5 14s3ms 2s800ms [ User: intelifix - Total duration: 2m38s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 2m38s - Times executed: 58 ]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 09:27:01 Duration: 17s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 10:35:37 Duration: 5s348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 11:13:03 Duration: 3s466ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m18s 4 4s504ms 1m5s 34s517ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 17 20 2 1m8s 34s92ms 23 2 1m9s 34s941ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-17 23:16:41 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-17 20:08:44 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-17 23:34:12 Duration: 4s622ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m9s 273 150ms 2s353ms 473ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 17 08 74 26s442ms 357ms 13 4 4s190ms 1s47ms 14 195 1m38s 506ms [ User: intelifix - Total duration: 2m9s - Times executed: 273 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 273 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"137647","seriais":"241742850424,241738682542,241771371030,241771289203,241747589000,241778719715,241778746283,241814556680,241775599095,241744334653,241742969806,241767942850,241765540618,241778764747,241778744869,241768013743,241768082336,241764494365,241740252841,241814552943,241738427892,241742805671,241767906684,241771152142,241742824259,241743276581,241746522342,241746638491,241746520120,241778627079,241740816060,241813979092,241778748405,241771158910,241739545061,241762621736,241738478908,241743269409,241776813951,241746634956","usuario":"399","observacao":""}');
Date: 2026-09-17 14:08:26 Duration: 2s353ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"137645","seriais":"241787178396,241721774247,241720473548,241784661126,241720426371,241791497482,241790534852,241754102341,241789979613,241724355464,241791788599,241722967584,241754144567,241793798391,241782044450,241797785672,241791523243,241782046268,241797782844,241787105460,241737107393,241780467584,241780467685,241704892443,241791635274,241737113152,241791542538,241757293348,241790553743,241791780721,241794962737,241757333453,241791644343,241793405065,241722981728,241754229401,241794552641,241793478911,241723034662,241780589718","usuario":"399","observacao":""}');
Date: 2026-09-17 13:55:15 Duration: 2s243ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"137647","seriais":"241743342323,241814539406,241776753743,241814372645,241826747185,241778629100,241738234159,241738783135,241746616873,241743349393,241814380424,241771230511,241776881332,241776520006,241814269199,241762630828,241814548295,241765583349,241762345468,241745721321,241775644757,241814539204,241762333447,241745442023,241771298193,241739840927,241762340216,241759725762,241745442124,241813277980,241820866061,241765579308,241771275767,241778557476,241744551319,241813982932,241814386989,241814247076,241775628088,241778557173","usuario":"399","observacao":""}');
Date: 2026-09-17 14:45:04 Duration: 2s10ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 1m47s 4 360ms 54s320ms 26s908ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 17 20 2 54s685ms 27s342ms 23 2 52s947ms 26s473ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-17 20:05:47 Duration: 54s320ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-17 23:13:43 Duration: 52s586ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-17 20:10:09 Duration: 365ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m47s 59 155ms 20s7ms 1s819ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 17 08 4 8s205ms 2s51ms 09 4 5s994ms 1s498ms 10 4 2s479ms 619ms 11 4 2s496ms 624ms 12 4 11s269ms 2s817ms 13 5 13s202ms 2s640ms 14 4 5s672ms 1s418ms 15 3 7s737ms 2s579ms 16 4 10s461ms 2s615ms 17 3 21s423ms 7s141ms 18 4 4s508ms 1s127ms 19 5 3s955ms 791ms 20 4 3s911ms 977ms 21 3 2s628ms 876ms 22 4 3s405ms 851ms [ User: intelifix - Total duration: 1m47s - Times executed: 59 ]
[ Application: psql - Total duration: 1m47s - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 17:40:21 Duration: 20s7ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 16:20:09 Duration: 7s882ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 13:40:09 Duration: 7s752ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m47s 6 3s128ms 39s962ms 17s874ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 17 20 3 53s767ms 17s922ms 23 3 53s476ms 17s825ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-17 20:06:29 Duration: 39s962ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-17 23:14:24 Duration: 39s584ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-17 20:10:20 Duration: 10s676ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,127 17m17s 150ms 8s883ms 920ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 17 07 18 12s90ms 671ms 08 84 1m10s 837ms 09 151 2m11s 868ms 10 141 2m13s 949ms 11 150 2m15s 906ms 12 33 32s27ms 970ms 13 64 1m6s 1s36ms 14 177 2m51s 971ms 15 139 2m9s 931ms 16 115 1m47s 935ms 17 55 46s841ms 851ms [ User: intelifix - Total duration: 17m17s - Times executed: 1127 ]
[ Application: [unknown] - Total duration: 17m17s - Times executed: 1127 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (137422, 397, 'CP230232TC6,D4925E0A389E,544D424200620A73,D4925E0A38A1$CP240332353,08C7F52146F8,544D42420076AEBD,08C7F52146FB$CP230132DE9,D4925E036551,544D424200614908,D4925E036554$CP223932104,A0B53CC03DEC,544D4242005E7149,A0B53CC03DEF$CP23303247G,D4925EE2774F,544D4242006E5B88,D4925EE27752$CP2239320A1,A0B53CC02322,544D4242005E6E4F,A0B53CC02325$CP240332EEK,08C7F522F71C,544D42420076DEC1,08C7F522F71F$CP2327321VT,D4925ED4E4ED,544D4242006DA5F2,D4925ED4E4F0$CP234532763,08C7F502E5D8,544D42420073508D,08C7F502E5DB', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-17 09:12:15 Duration: 8s883ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286897, 304, '833124918002921,230003236768,229930282747,229926656062,229938785473,229907442639,230004338100,229947381621,229997676080,229948074247,229931777280,229927097575,229936671631,230002728605,229957146580,230004056579,229958210108,229993289816,229984958801,229994363344,229997267577,229931707172', '',0287,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-17 11:48:29 Duration: 7s145ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287603, 452, '464246048283,216325887077,216386090911,216744393758,216376611535,216424645167,216575894855,216677211231,216428974860,216457722335,216677926283,216692668080,216380649504', '',034,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-09-17 15:59:13 Duration: 6s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 700 7m29s 151ms 5s759ms 642ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 17 07 1 2s203ms 2s203ms 08 94 59s878ms 637ms 09 92 53s154ms 577ms 10 131 1m16s 583ms 11 105 1m2s 595ms 12 12 6s70ms 505ms 13 68 42s203ms 620ms 14 51 44s546ms 873ms 15 75 50s679ms 675ms 16 55 43s786ms 796ms 17 16 8s375ms 523ms [ User: intelifix - Total duration: 7m29s - Times executed: 700 ]
[ Application: [unknown] - Total duration: 7m29s - Times executed: 700 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288337", "modelo" : "463", "itens" : "241752240420,241736513946,241750243535,241757397173,241755145461,241781631728,241752104850,241787450523,241750172440,241719060010,241794314357,241750145972,241794165779,241718917189,241754704756,241757980520,241749965169,241787545660,241753197493,241748324661,241755068103,241721651935,241753645573,241721569401,241779570719,241748394567,241721548691,241783460414,241720053350,241736501016,241755621928,241784087174,241722370322,241754615555,241755905973,241784504365,241790285153,241791627495,241782078089,241790242748,241756890627,241720775272,241754702837,241723781234,241735982626,241757962437,241736601834,241721043233,241754135475,241782508591,241784080508,241750457293,241783445866,241724300914,241758964465,241705956373,241755964262,241748842950,241725853759,241720458899", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 14:11:59 Duration: 5s759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288346", "modelo" : "463", "itens" : "241794085569,241750014040,241783398588,241722357794,241757013949,241722508594,241750095765,241735320912,241782568597,241720094061,241748286677,241721341321,241722075062,241750552937,241784467290,241794064860,241782491621,241720879603,241752382936,241737812547,241724321623,241720303655,241722359310,241754303651,241758627585,241784485777,241781711635,241784137381,241720346262,241750601225,241784078082,241780565978,241736072231,241722083548,241755678903,241782336476,241783318200,241782070211,241753203656,241748442832,241706146975,241757193338,241755783638,241755890013,241723273350,241753544553,241784686784,241794161941,241723820609,241704907595,241794325469,241750264547,241734608686,241784742828,241748778195,241752224155,241784452037,241750240202,241782096576,241784638799", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 14:25:49 Duration: 3s958ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288337", "modelo" : "463", "itens" : "241787444461,241748895053,241750207897,241736839511,241723501128,241736588195,241784440723,241781433751,241758928097,241720743855,241794145373,241736859210,241724226282,241781503152,241751123958,241784506082,241723117071,241751487786,241753189614,241755965373,241753678506,241748403636,241735052345,241751051022,241750453960,241721607182,241724404964,241754121939,241784144049,241758062323,241735755353,241722484552,241790054850,241721594252,241724181430,241784453249,241722343147,241782319707,241753696262,241748506676,241758555457,241757020011,241781795660,241750494648,241755974970,241757644751,241724184965,241722517888,241724053235,241755134248,241735068787,241758065353,241779570820,241754711222,241705949908,241722910004,241784125663,241752388289,241720492843,241705005966", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 13:57:14 Duration: 3s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 273 2m9s 150ms 2s353ms 473ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 17 08 74 26s442ms 357ms 13 4 4s190ms 1s47ms 14 195 1m38s 506ms [ User: intelifix - Total duration: 2m9s - Times executed: 273 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 273 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"137647","seriais":"241742850424,241738682542,241771371030,241771289203,241747589000,241778719715,241778746283,241814556680,241775599095,241744334653,241742969806,241767942850,241765540618,241778764747,241778744869,241768013743,241768082336,241764494365,241740252841,241814552943,241738427892,241742805671,241767906684,241771152142,241742824259,241743276581,241746522342,241746638491,241746520120,241778627079,241740816060,241813979092,241778748405,241771158910,241739545061,241762621736,241738478908,241743269409,241776813951,241746634956","usuario":"399","observacao":""}');
Date: 2026-09-17 14:08:26 Duration: 2s353ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"137645","seriais":"241787178396,241721774247,241720473548,241784661126,241720426371,241791497482,241790534852,241754102341,241789979613,241724355464,241791788599,241722967584,241754144567,241793798391,241782044450,241797785672,241791523243,241782046268,241797782844,241787105460,241737107393,241780467584,241780467685,241704892443,241791635274,241737113152,241791542538,241757293348,241790553743,241791780721,241794962737,241757333453,241791644343,241793405065,241722981728,241754229401,241794552641,241793478911,241723034662,241780589718","usuario":"399","observacao":""}');
Date: 2026-09-17 13:55:15 Duration: 2s243ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"137647","seriais":"241743342323,241814539406,241776753743,241814372645,241826747185,241778629100,241738234159,241738783135,241746616873,241743349393,241814380424,241771230511,241776881332,241776520006,241814269199,241762630828,241814548295,241765583349,241762345468,241745721321,241775644757,241814539204,241762333447,241745442023,241771298193,241739840927,241762340216,241759725762,241745442124,241813277980,241820866061,241765579308,241771275767,241778557476,241744551319,241813982932,241814386989,241814247076,241775628088,241778557173","usuario":"399","observacao":""}');
Date: 2026-09-17 14:45:04 Duration: 2s10ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 220 1h44m5s 150ms 6m49s 28s389ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 17 06 1 1s452ms 1s452ms 07 11 12m18s 1m7s 08 4 1m27s 21s926ms 09 24 8m17s 20s739ms 10 22 19m46s 53s927ms 11 14 7m12s 30s876ms 12 13 12m16s 56s630ms 13 28 2m20s 5s7ms 14 49 9m41s 11s868ms 15 28 24m40s 52s869ms 16 15 58s370ms 3s891ms 17 11 5m5s 27s749ms [ User: intelifix - Total duration: 1h44m5s - Times executed: 220 ]
[ Application: [unknown] - Total duration: 1h44m5s - Times executed: 220 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029977, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 09:17:18 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 10:14:40 Duration: 6m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029972, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 07:24:29 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 161 10m27s 178ms 42s825ms 3s896ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 17 00 6 1m5s 10s882ms 01 6 26s220ms 4s370ms 02 6 21s373ms 3s562ms 03 5 26s631ms 5s326ms 04 6 32s801ms 5s466ms 05 5 25s630ms 5s126ms 07 10 44s371ms 4s437ms 08 13 55s420ms 4s263ms 09 12 50s553ms 4s212ms 10 12 43s839ms 3s653ms 11 12 44s115ms 3s676ms 12 11 30s448ms 2s768ms 13 6 9s318ms 1s553ms 14 12 35s536ms 2s961ms 15 12 51s959ms 4s329ms 16 9 24s213ms 2s690ms 17 5 2s995ms 599ms 20 1 641ms 641ms 21 6 14s90ms 2s348ms 22 6 21s857ms 3s642ms [ User: intelifix - Total duration: 10m27s - Times executed: 161 ]
[ Application: psql - Total duration: 10m27s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 00:05:44 Duration: 42s825ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 05:15:17 Duration: 15s773ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 07:35:12 Duration: 11s795ms Database: rio User: intelifix Remote: [local] Application: psql
6 147 6m2s 176ms 1m56s 2s463ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 17 00 7 21s639ms 3s91ms 01 6 9s88ms 1s514ms 02 6 8s960ms 1s493ms 03 6 9s209ms 1s534ms 04 6 8s322ms 1s387ms 05 6 9s620ms 1s603ms 06 6 9s371ms 1s561ms 07 7 2m8s 18s367ms 08 6 9s803ms 1s633ms 09 7 14s37ms 2s5ms 10 8 13s718ms 1s714ms 11 7 11s188ms 1s598ms 12 6 9s338ms 1s556ms 13 6 9s566ms 1s594ms 14 7 10s26ms 1s432ms 15 6 9s275ms 1s545ms 16 6 9s304ms 1s550ms 17 6 9s629ms 1s604ms 18 6 9s143ms 1s523ms 19 6 9s619ms 1s603ms 20 8 13s777ms 1s722ms 21 6 9s63ms 1s510ms 22 6 9s886ms 1s647ms [ User: intelifix - Total duration: 6m2s - Times executed: 147 ]
[ Application: psql - Total duration: 6m2s - Times executed: 147 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:57:05 Duration: 1m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 00:05:56 Duration: 11s727ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:25:13 Duration: 5s166ms Database: rio User: intelifix Remote: [local] Application: psql
7 90 32s541ms 150ms 4s271ms 361ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 17 07 4 1s687ms 421ms 08 8 3s309ms 413ms 09 5 2s542ms 508ms 10 6 1s442ms 240ms 11 9 1s982ms 220ms 12 4 825ms 206ms 13 5 965ms 193ms 14 17 4s128ms 242ms 15 15 2s846ms 189ms 16 4 735ms 183ms 17 1 292ms 292ms 21 1 254ms 254ms 23 11 11s529ms 1s48ms [ User: intelifix - Total duration: 32s541ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 32s541ms - Times executed: 90 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('CCB1827F65A1');
Date: 2026-09-17 23:40:18 Duration: 4s271ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('48575443EB815EA8');
Date: 2026-09-17 23:30:28 Duration: 1s500ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('F82E3F83655A');
Date: 2026-09-17 23:20:33 Duration: 1s299ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 86 1m43s 159ms 8s809ms 1s205ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 17 06 1 4s723ms 4s723ms 07 13 14s30ms 1s79ms 09 10 5s877ms 587ms 10 5 6s450ms 1s290ms 11 1 720ms 720ms 13 9 8s881ms 986ms 14 26 51s507ms 1s981ms 15 9 6s147ms 683ms 16 8 3s255ms 406ms 17 4 2s79ms 519ms [ User: intelifix - Total duration: 1m43s - Times executed: 86 ]
[ Application: [unknown] - Total duration: 1m43s - Times executed: 86 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137647) LIMIT 1;
Date: 2026-09-17 14:56:50 Duration: 8s809ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137647) LIMIT 1;
Date: 2026-09-17 14:58:23 Duration: 8s250ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137647) LIMIT 1;
Date: 2026-09-17 14:57:07 Duration: 8s177ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 86 27s706ms 300ms 403ms 322ms 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 #9
Day Hour Count Duration Avg duration Sep 17 06 1 306ms 306ms 07 7 2s284ms 326ms 08 9 2s794ms 310ms 09 9 2s859ms 317ms 10 7 2s253ms 321ms 11 7 2s387ms 341ms 12 3 970ms 323ms 13 8 2s600ms 325ms 14 11 3s643ms 331ms 15 10 3s207ms 320ms 16 8 2s495ms 311ms 17 3 938ms 312ms 21 1 312ms 312ms 22 1 318ms 318ms 23 1 333ms 333ms [ User: lenon - Total duration: 27s706ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 27s706ms - Times executed: 86 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-17 15:56:36 Duration: 403ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-17 13:35:03 Duration: 383ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-17 11:10:38 Duration: 361ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 81 32s444ms 335ms 734ms 400ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 17 07 5 1s905ms 381ms 08 8 2s936ms 367ms 09 9 3s660ms 406ms 10 7 3s123ms 446ms 11 6 2s742ms 457ms 12 3 1s175ms 391ms 13 8 3s167ms 395ms 14 11 4s198ms 381ms 15 10 3s821ms 382ms 16 8 2s932ms 366ms 17 3 1s381ms 460ms 21 1 612ms 612ms 22 1 385ms 385ms 23 1 400ms 400ms [ User: intelifix - Total duration: 32s444ms - Times executed: 81 ]
[ Application: [unknown] - Total duration: 32s444ms - Times executed: 81 ]
-
select * from rs_menu_grants (416, 53, 1);
Date: 2026-09-17 10:30:24 Duration: 734ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 53, 1);
Date: 2026-09-17 09:49:44 Duration: 718ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (477, 81, 1);
Date: 2026-09-17 21:54:35 Duration: 612ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 72 26s569ms 151ms 1s644ms 369ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 17 07 2 573ms 286ms 08 2 438ms 219ms 09 9 4s389ms 487ms 10 17 6s731ms 395ms 11 20 6s462ms 323ms 13 2 598ms 299ms 14 13 5s409ms 416ms 15 7 1s965ms 280ms [ User: intelifix - Total duration: 26s569ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 26s569ms - Times executed: 72 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (173, 5, 2, 23, '9877E7B9CE3F', '','DEFAULT',00,0153,'', '','', 00);
Date: 2026-09-17 09:21:36 Duration: 1s644ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '840112C32750,840112C3E3C0,24E4CE8D9DB0,840112C43858,840112C32E88', '77;1', 'DEFAULT', 09, 0299, '','', '', 00);
Date: 2026-09-17 14:14:19 Duration: 1s89ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '98006A6A5696,C0B101FBCF98,C0B101FC1462,C0B101FBBC2A,C0B101FB7A60,C0B101EA6004,C0B101FB209C,C0B101E4EED2,C0B101F8BCA2,98006A6A139A,C0B101F88540,C0B101EA701E,C0B101EA8FC2,C0B101F939F4,C0B101E4AA9E', '138;1', 'DEFAULT', 09, 0271, '','', '', 00);
Date: 2026-09-17 10:57:49 Duration: 964ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 71 15m40s 10s651ms 1m5s 13s253ms create table temp0000291669 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 17 07 10 2m46s 16s676ms 08 2 21s950ms 10s975ms 09 19 4m39s 14s697ms 10 13 2m39s 12s245ms 11 7 1m20s 11s474ms 12 9 1m47s 11s948ms 14 2 23s801ms 11s900ms 15 9 1m42s 11s350ms [ User: intelifix - Total duration: 15m40s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 15m40s - Times executed: 71 ]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 07:15:54 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 09:26:36 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 09:10:24 Duration: 21s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 70 20s853ms 254ms 416ms 297ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 17 07 2 555ms 277ms 08 5 1s419ms 283ms 09 9 2s721ms 302ms 10 8 2s457ms 307ms 11 4 1s154ms 288ms 12 4 1s186ms 296ms 13 10 3s147ms 314ms 14 13 3s792ms 291ms 15 6 1s863ms 310ms 16 3 930ms 310ms 17 6 1s625ms 270ms [ User: intelifix - Total duration: 20s853ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 20s853ms - Times executed: 70 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-09-17 09:16:52 Duration: 416ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-17 15:41:30 Duration: 414ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-09-17 13:21:36 Duration: 400ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 69 12m1s 1s570ms 1m28s 10s454ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 17 07 2 30s856ms 15s428ms 08 2 12s113ms 6s56ms 09 10 3m12s 19s291ms 10 4 1m28s 22s99ms 11 8 1m34s 11s832ms 12 2 7s675ms 3s837ms 13 5 20s123ms 4s24ms 14 6 1m3s 10s625ms 15 11 1m37s 8s821ms 16 11 1m14s 6s784ms 17 8 39s202ms 4s900ms [ User: intelifix - Total duration: 12m1s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m1s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 09:09:53 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0395, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 10:23:56 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 09:36:49 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
15 59 1m47s 155ms 20s7ms 1s819ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 17 08 4 8s205ms 2s51ms 09 4 5s994ms 1s498ms 10 4 2s479ms 619ms 11 4 2s496ms 624ms 12 4 11s269ms 2s817ms 13 5 13s202ms 2s640ms 14 4 5s672ms 1s418ms 15 3 7s737ms 2s579ms 16 4 10s461ms 2s615ms 17 3 21s423ms 7s141ms 18 4 4s508ms 1s127ms 19 5 3s955ms 791ms 20 4 3s911ms 977ms 21 3 2s628ms 876ms 22 4 3s405ms 851ms [ User: intelifix - Total duration: 1m47s - Times executed: 59 ]
[ Application: psql - Total duration: 1m47s - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 17:40:21 Duration: 20s7ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 16:20:09 Duration: 7s882ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 13:40:09 Duration: 7s752ms Database: rio User: intelifix Remote: [local] Application: psql
16 58 2m38s 2s146ms 17s72ms 2s734ms create table temp0000291669 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 17 07 11 25s145ms 2s285ms 08 13 29s536ms 2s272ms 09 14 48s134ms 3s438ms 10 4 12s979ms 3s244ms 11 11 28s804ms 2s618ms 15 5 14s3ms 2s800ms [ User: intelifix - Total duration: 2m38s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 2m38s - Times executed: 58 ]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 09:27:01 Duration: 17s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 10:35:37 Duration: 5s348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 11:13:03 Duration: 3s466ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 54 11s503ms 150ms 2s254ms 213ms create table temp0000291691 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 17 08 1 2s254ms 2s254ms 10 1 164ms 164ms 11 17 2s711ms 159ms 12 2 341ms 170ms 13 4 744ms 186ms 14 14 2s536ms 181ms 15 15 2s750ms 183ms [ User: intelifix - Total duration: 11s503ms - Times executed: 54 ]
[ Application: [unknown] - Total duration: 11s503ms - Times executed: 54 ]
-
CREATE TABLE temp0000291691 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 08:16:58 Duration: 2s254ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291691 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"84411", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 14:55:40 Duration: 224ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291691 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"84411", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 15:07:59 Duration: 219ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 48 1h38m30s 1s497ms 9m7s 2m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 17 07 3 9m56s 3m18s 08 3 6m13s 2m4s 09 3 6m24s 2m8s 10 3 5m40s 1m53s 11 3 5m59s 1m59s 12 3 6m16s 2m5s 13 3 5m42s 1m54s 14 3 6m4s 2m1s 15 3 5m55s 1m58s 16 3 5m46s 1m55s 17 3 6m7s 2m2s 18 3 5m50s 1m56s 19 3 5m28s 1m49s 20 3 5m51s 1m57s 21 3 5m43s 1m54s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h38m30s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 07:14:09 Duration: 9m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 09:10:57 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 12:10:56 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: psql
19 48 1h10m19s 247ms 4m7s 1m27s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 17 07 3 5m59s 1m59s 08 3 4m13s 1m24s 09 3 5m41s 1m53s 10 3 4m19s 1m26s 11 3 4m19s 1m26s 12 3 4m3s 1m21s 13 3 4m3s 1m21s 14 3 4m24s 1m28s 15 3 4m13s 1m24s 16 3 4m11s 1m23s 17 3 4m16s 1m25s 18 3 4m16s 1m25s 19 3 4m1s 1m20s 20 3 4m6s 1m22s 21 3 4m6s 1m22s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h10m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 07:20:46 Duration: 4m7s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 09:17:05 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 14:15:28 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
20 45 10s613ms 156ms 497ms 235ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 17 07 4 1s43ms 260ms 08 1 251ms 251ms 09 6 1s202ms 200ms 10 7 1s233ms 176ms 11 10 2s772ms 277ms 12 4 838ms 209ms 13 1 202ms 202ms 14 3 905ms 301ms 15 9 2s162ms 240ms [ User: intelifix - Total duration: 10s613ms - Times executed: 45 ]
[ Application: [unknown] - Total duration: 10s613ms - Times executed: 45 ]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229788686974,229791541530,229904461630,229821506586,229789948905,229788344764,229879056164,229857437982,229878618489', NULL, NULL, 0145, 00);
Date: 2026-09-17 15:33:36 Duration: 497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '229968825868,230037555763,230034387182,230020045154,229976587882,229989116479,230052796981,230009959399,230019907587', NULL, NULL, 0295, 00);
Date: 2026-09-17 14:59:11 Duration: 402ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '229954418098,230008263152,229921441424,229995713139,229984050520,229970212435,229928905777,229952956777,229969985768,229925998489', NULL, NULL, 0287, 00);
Date: 2026-09-17 11:57:49 Duration: 356ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m38s 11m56s 8m4s 3 24m12s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 17 05 3 24m12s 8m4s [ User: intelifix - Total duration: 24m12s - Times executed: 3 ]
[ Application: psql - Total duration: 24m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-17 05:11:57 Duration: 11m56s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-17 05:20:35 Duration: 8m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-17 05:24:13 Duration: 3m38s Database: contagem User: intelifix Remote: [local] Application: psql
2 4m37s 4m37s 4m37s 1 4m37s select * from rs_fast_excel (?, ?) notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 17 14 1 4m37s 4m37s [ User: intelifix - Total duration: 4m37s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 4m37s - Times executed: 1 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-09-01''),DATE(''2026-09-16'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx') NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-09-17 14:09:49 Duration: 4m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1s497ms 9m7s 2m3s 48 1h38m30s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 17 07 3 9m56s 3m18s 08 3 6m13s 2m4s 09 3 6m24s 2m8s 10 3 5m40s 1m53s 11 3 5m59s 1m59s 12 3 6m16s 2m5s 13 3 5m42s 1m54s 14 3 6m4s 2m1s 15 3 5m55s 1m58s 16 3 5m46s 1m55s 17 3 6m7s 2m2s 18 3 5m50s 1m56s 19 3 5m28s 1m49s 20 3 5m51s 1m57s 21 3 5m43s 1m54s 22 3 5m28s 1m49s [ User: intelifix - Total duration: 1h38m30s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 07:14:09 Duration: 9m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 09:10:57 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-17 12:10:56 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: psql
4 247ms 4m7s 1m27s 48 1h10m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 17 07 3 5m59s 1m59s 08 3 4m13s 1m24s 09 3 5m41s 1m53s 10 3 4m19s 1m26s 11 3 4m19s 1m26s 12 3 4m3s 1m21s 13 3 4m3s 1m21s 14 3 4m24s 1m28s 15 3 4m13s 1m24s 16 3 4m11s 1m23s 17 3 4m16s 1m25s 18 3 4m16s 1m25s 19 3 4m1s 1m20s 20 3 4m6s 1m22s 21 3 4m6s 1m22s 22 3 4m 1m20s [ User: intelifix - Total duration: 1h10m19s - Times executed: 48 ]
[ Application: psql - Total duration: 1h10m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 07:20:46 Duration: 4m7s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 09:17:05 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-17 14:15:28 Duration: 3m49s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s504ms 1m5s 34s517ms 4 2m18s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 17 20 2 1m8s 34s92ms 23 2 1m9s 34s941ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-17 23:16:41 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-17 20:08:44 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-17 23:34:12 Duration: 4s622ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 6m49s 28s389ms 220 1h44m5s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 17 06 1 1s452ms 1s452ms 07 11 12m18s 1m7s 08 4 1m27s 21s926ms 09 24 8m17s 20s739ms 10 22 19m46s 53s927ms 11 14 7m12s 30s876ms 12 13 12m16s 56s630ms 13 28 2m20s 5s7ms 14 49 9m41s 11s868ms 15 28 24m40s 52s869ms 16 15 58s370ms 3s891ms 17 11 5m5s 27s749ms [ User: intelifix - Total duration: 1h44m5s - Times executed: 220 ]
[ Application: [unknown] - Total duration: 1h44m5s - Times executed: 220 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029977, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 09:17:18 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029984, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 10:14:40 Duration: 6m44s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029972, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-17 07:24:29 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 360ms 54s320ms 26s908ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 17 20 2 54s685ms 27s342ms 23 2 52s947ms 26s473ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-17 20:05:47 Duration: 54s320ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-17 23:13:43 Duration: 52s586ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-17 20:10:09 Duration: 365ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s128ms 39s962ms 17s874ms 6 1m47s 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 #8
Day Hour Count Duration Avg duration Sep 17 20 3 53s767ms 17s922ms 23 3 53s476ms 17s825ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-17 20:06:29 Duration: 39s962ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-17 23:14:24 Duration: 39s584ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-17 20:10:20 Duration: 10s676ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 10s651ms 1m5s 13s253ms 71 15m40s create table temp0000291669 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 17 07 10 2m46s 16s676ms 08 2 21s950ms 10s975ms 09 19 4m39s 14s697ms 10 13 2m39s 12s245ms 11 7 1m20s 11s474ms 12 9 1m47s 11s948ms 14 2 23s801ms 11s900ms 15 9 1m42s 11s350ms [ User: intelifix - Total duration: 15m40s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 15m40s - Times executed: 71 ]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 07:15:54 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 09:26:36 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 09:10:24 Duration: 21s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s754ms 13s322ms 11s822ms 44 8m40s create table temp0000291745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 17 13 15 3m4s 12s273ms 14 29 5m36s 11s589ms [ User: intelifix - Total duration: 8m40s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 8m40s - Times executed: 44 ]
-
CREATE TABLE temp0000291745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 13:49:22 Duration: 13s322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 13:50:08 Duration: 13s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 14:08:04 Duration: 13s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 11s20ms 13s760ms 11s548ms 16 3m4s create table temp0000291585 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 17 08 2 25s455ms 12s727ms 14 8 1m31s 11s404ms 15 4 44s922ms 11s230ms 16 2 23s155ms 11s577ms [ User: intelifix - Total duration: 3m4s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m4s - Times executed: 16 ]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 08:56:53 Duration: 13s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 14:52:41 Duration: 12s136ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-17 14:52:12 Duration: 11s949ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s570ms 1m28s 10s454ms 69 12m1s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 17 07 2 30s856ms 15s428ms 08 2 12s113ms 6s56ms 09 10 3m12s 19s291ms 10 4 1m28s 22s99ms 11 8 1m34s 11s832ms 12 2 7s675ms 3s837ms 13 5 20s123ms 4s24ms 14 6 1m3s 10s625ms 15 11 1m37s 8s821ms 16 11 1m14s 6s784ms 17 8 39s202ms 4s900ms [ User: intelifix - Total duration: 12m1s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m1s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 09:09:53 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0395, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 10:23:56 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-17', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-17 09:36:49 Duration: 1m12s Database: rio User: intelifix Remote: [local] Application: [unknown]
13 158ms 38s607ms 6s22ms 35 3m30s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 17 07 2 43s395ms 21s697ms 08 2 4s928ms 2s464ms 09 4 38s345ms 9s586ms 10 4 29s412ms 7s353ms 11 1 4s276ms 4s276ms 12 2 11s507ms 5s753ms 13 7 45s723ms 6s531ms 14 9 20s43ms 2s227ms 15 4 13s162ms 3s290ms [ User: intelifix - Total duration: 3m30s - Times executed: 35 ]
[ Application: psql - Total duration: 3m30s - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029972);
Date: 2026-09-17 07:18:03 Duration: 38s607ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029978);
Date: 2026-09-17 09:31:06 Duration: 22s940ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029994);
Date: 2026-09-17 13:41:19 Duration: 18s365ms Database: rio User: intelifix Remote: [local] Application: psql
14 178ms 42s825ms 3s896ms 161 10m27s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 17 00 6 1m5s 10s882ms 01 6 26s220ms 4s370ms 02 6 21s373ms 3s562ms 03 5 26s631ms 5s326ms 04 6 32s801ms 5s466ms 05 5 25s630ms 5s126ms 07 10 44s371ms 4s437ms 08 13 55s420ms 4s263ms 09 12 50s553ms 4s212ms 10 12 43s839ms 3s653ms 11 12 44s115ms 3s676ms 12 11 30s448ms 2s768ms 13 6 9s318ms 1s553ms 14 12 35s536ms 2s961ms 15 12 51s959ms 4s329ms 16 9 24s213ms 2s690ms 17 5 2s995ms 599ms 20 1 641ms 641ms 21 6 14s90ms 2s348ms 22 6 21s857ms 3s642ms [ User: intelifix - Total duration: 10m27s - Times executed: 161 ]
[ Application: psql - Total duration: 10m27s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 00:05:44 Duration: 42s825ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 05:15:17 Duration: 15s773ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-17 07:35:12 Duration: 11s795ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s146ms 17s72ms 2s734ms 58 2m38s create table temp0000291669 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 17 07 11 25s145ms 2s285ms 08 13 29s536ms 2s272ms 09 14 48s134ms 3s438ms 10 4 12s979ms 3s244ms 11 11 28s804ms 2s618ms 15 5 14s3ms 2s800ms [ User: intelifix - Total duration: 2m38s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 2m38s - Times executed: 58 ]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 09:27:01 Duration: 17s72ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 10:35:37 Duration: 5s348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291669 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-09-2026", "ate" :"17-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-17 11:13:03 Duration: 3s466ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 176ms 1m56s 2s463ms 147 6m2s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 17 00 7 21s639ms 3s91ms 01 6 9s88ms 1s514ms 02 6 8s960ms 1s493ms 03 6 9s209ms 1s534ms 04 6 8s322ms 1s387ms 05 6 9s620ms 1s603ms 06 6 9s371ms 1s561ms 07 7 2m8s 18s367ms 08 6 9s803ms 1s633ms 09 7 14s37ms 2s5ms 10 8 13s718ms 1s714ms 11 7 11s188ms 1s598ms 12 6 9s338ms 1s556ms 13 6 9s566ms 1s594ms 14 7 10s26ms 1s432ms 15 6 9s275ms 1s545ms 16 6 9s304ms 1s550ms 17 6 9s629ms 1s604ms 18 6 9s143ms 1s523ms 19 6 9s619ms 1s603ms 20 8 13s777ms 1s722ms 21 6 9s63ms 1s510ms 22 6 9s886ms 1s647ms [ User: intelifix - Total duration: 6m2s - Times executed: 147 ]
[ Application: psql - Total duration: 6m2s - Times executed: 147 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:57:05 Duration: 1m56s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 00:05:56 Duration: 11s727ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-17 07:25:13 Duration: 5s166ms Database: rio User: intelifix Remote: [local] Application: psql
17 155ms 20s7ms 1s819ms 59 1m47s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 17 08 4 8s205ms 2s51ms 09 4 5s994ms 1s498ms 10 4 2s479ms 619ms 11 4 2s496ms 624ms 12 4 11s269ms 2s817ms 13 5 13s202ms 2s640ms 14 4 5s672ms 1s418ms 15 3 7s737ms 2s579ms 16 4 10s461ms 2s615ms 17 3 21s423ms 7s141ms 18 4 4s508ms 1s127ms 19 5 3s955ms 791ms 20 4 3s911ms 977ms 21 3 2s628ms 876ms 22 4 3s405ms 851ms [ User: intelifix - Total duration: 1m47s - Times executed: 59 ]
[ Application: psql - Total duration: 1m47s - Times executed: 59 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 17:40:21 Duration: 20s7ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 16:20:09 Duration: 7s882ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-17 13:40:09 Duration: 7s752ms Database: rio User: intelifix Remote: [local] Application: psql
18 159ms 8s809ms 1s205ms 86 1m43s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 17 06 1 4s723ms 4s723ms 07 13 14s30ms 1s79ms 09 10 5s877ms 587ms 10 5 6s450ms 1s290ms 11 1 720ms 720ms 13 9 8s881ms 986ms 14 26 51s507ms 1s981ms 15 9 6s147ms 683ms 16 8 3s255ms 406ms 17 4 2s79ms 519ms [ User: intelifix - Total duration: 1m43s - Times executed: 86 ]
[ Application: [unknown] - Total duration: 1m43s - Times executed: 86 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137647) LIMIT 1;
Date: 2026-09-17 14:56:50 Duration: 8s809ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137647) LIMIT 1;
Date: 2026-09-17 14:58:23 Duration: 8s250ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137647) LIMIT 1;
Date: 2026-09-17 14:57:07 Duration: 8s177ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
19 150ms 8s883ms 920ms 1,127 17m17s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 17 07 18 12s90ms 671ms 08 84 1m10s 837ms 09 151 2m11s 868ms 10 141 2m13s 949ms 11 150 2m15s 906ms 12 33 32s27ms 970ms 13 64 1m6s 1s36ms 14 177 2m51s 971ms 15 139 2m9s 931ms 16 115 1m47s 935ms 17 55 46s841ms 851ms [ User: intelifix - Total duration: 17m17s - Times executed: 1127 ]
[ Application: [unknown] - Total duration: 17m17s - Times executed: 1127 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (137422, 397, 'CP230232TC6,D4925E0A389E,544D424200620A73,D4925E0A38A1$CP240332353,08C7F52146F8,544D42420076AEBD,08C7F52146FB$CP230132DE9,D4925E036551,544D424200614908,D4925E036554$CP223932104,A0B53CC03DEC,544D4242005E7149,A0B53CC03DEF$CP23303247G,D4925EE2774F,544D4242006E5B88,D4925EE27752$CP2239320A1,A0B53CC02322,544D4242005E6E4F,A0B53CC02325$CP240332EEK,08C7F522F71C,544D42420076DEC1,08C7F522F71F$CP2327321VT,D4925ED4E4ED,544D4242006DA5F2,D4925ED4E4F0$CP234532763,08C7F502E5D8,544D42420073508D,08C7F502E5DB', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-17 09:12:15 Duration: 8s883ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286897, 304, '833124918002921,230003236768,229930282747,229926656062,229938785473,229907442639,230004338100,229947381621,229997676080,229948074247,229931777280,229927097575,229936671631,230002728605,229957146580,230004056579,229958210108,229993289816,229984958801,229994363344,229997267577,229931707172', '',0287,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-17 11:48:29 Duration: 7s145ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287603, 452, '464246048283,216325887077,216386090911,216744393758,216376611535,216424645167,216575894855,216677211231,216428974860,216457722335,216677926283,216692668080,216380649504', '',034,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-09-17 15:59:13 Duration: 6s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 151ms 5s759ms 642ms 700 7m29s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 17 07 1 2s203ms 2s203ms 08 94 59s878ms 637ms 09 92 53s154ms 577ms 10 131 1m16s 583ms 11 105 1m2s 595ms 12 12 6s70ms 505ms 13 68 42s203ms 620ms 14 51 44s546ms 873ms 15 75 50s679ms 675ms 16 55 43s786ms 796ms 17 16 8s375ms 523ms [ User: intelifix - Total duration: 7m29s - Times executed: 700 ]
[ Application: [unknown] - Total duration: 7m29s - Times executed: 700 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288337", "modelo" : "463", "itens" : "241752240420,241736513946,241750243535,241757397173,241755145461,241781631728,241752104850,241787450523,241750172440,241719060010,241794314357,241750145972,241794165779,241718917189,241754704756,241757980520,241749965169,241787545660,241753197493,241748324661,241755068103,241721651935,241753645573,241721569401,241779570719,241748394567,241721548691,241783460414,241720053350,241736501016,241755621928,241784087174,241722370322,241754615555,241755905973,241784504365,241790285153,241791627495,241782078089,241790242748,241756890627,241720775272,241754702837,241723781234,241735982626,241757962437,241736601834,241721043233,241754135475,241782508591,241784080508,241750457293,241783445866,241724300914,241758964465,241705956373,241755964262,241748842950,241725853759,241720458899", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 14:11:59 Duration: 5s759ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288346", "modelo" : "463", "itens" : "241794085569,241750014040,241783398588,241722357794,241757013949,241722508594,241750095765,241735320912,241782568597,241720094061,241748286677,241721341321,241722075062,241750552937,241784467290,241794064860,241782491621,241720879603,241752382936,241737812547,241724321623,241720303655,241722359310,241754303651,241758627585,241784485777,241781711635,241784137381,241720346262,241750601225,241784078082,241780565978,241736072231,241722083548,241755678903,241782336476,241783318200,241782070211,241753203656,241748442832,241706146975,241757193338,241755783638,241755890013,241723273350,241753544553,241784686784,241794161941,241723820609,241704907595,241794325469,241750264547,241734608686,241784742828,241748778195,241752224155,241784452037,241750240202,241782096576,241784638799", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 14:25:49 Duration: 3s958ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288337", "modelo" : "463", "itens" : "241787444461,241748895053,241750207897,241736839511,241723501128,241736588195,241784440723,241781433751,241758928097,241720743855,241794145373,241736859210,241724226282,241781503152,241751123958,241784506082,241723117071,241751487786,241753189614,241755965373,241753678506,241748403636,241735052345,241751051022,241750453960,241721607182,241724404964,241754121939,241784144049,241758062323,241735755353,241722484552,241790054850,241721594252,241724181430,241784453249,241722343147,241782319707,241753696262,241748506676,241758555457,241757020011,241781795660,241750494648,241755974970,241757644751,241724184965,241722517888,241724053235,241755134248,241735068787,241758065353,241779570820,241754711222,241705949908,241722910004,241784125663,241752388289,241720492843,241705005966", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-17 13:57:14 Duration: 3s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 17 13 1 0ms 0ms 16 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 18s496ms - Times executed: 6 ]
[ Application: psql - Total duration: 17s657ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 839ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,177 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 23 FATAL entries
- 4558 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,535 Max number of times the same event was reported
- 4,584 Total events found
Rank Times reported Error 1 4,535 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 17 00 120 01 118 02 120 03 108 04 120 05 120 06 118 07 216 08 388 09 466 10 392 11 349 12 164 13 161 14 328 15 395 16 279 17 201 18 84 19 59 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN0000000029C23040" does not exist
- ERROR: prepared statement "_PLAN0000000029CAA010" does not exist
- ERROR: prepared statement "_PLAN0000000029A03DD0" does not exist
Statement: DEALLOCATE "_PLAN0000000029C23040"
Date: 2026-09-17 00:00:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CAA010"
Date: 2026-09-17 00:00:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A03DD0"
Date: 2026-09-17 00:01:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 11 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 17 00 1 06 1 08 2 09 1 12 4 14 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-17 00:02:26 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-17 06:02:48 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-17 08:49:24 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 10 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 17 08 2 09 5 16 3 - ERROR: column "d86c5a06a8a3663815" does not exist at character 27
- ERROR: column "d86c5a06a8a3663815" does not exist at character 27
- ERROR: column "w" does not exist at character 27
Statement: select * from rs_caixa_qr(D86C5A06A8A3663815 )
Date: 2026-09-17 08:37:46 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(D86C5A06A8A3663815 )
Date: 2026-09-17 08:37:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(W>ku)
Date: 2026-09-17 09:31:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 17 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-17 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-17 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-17 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 17 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-17 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-17 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-17 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local]
6 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 17 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-17 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-17 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-17 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
7 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 17 11 3 - ERROR: trailing junk after numeric literal at or near "9922Ç175" at character 27
- ERROR: trailing junk after numeric literal at or near "9922Ç175" at character 27
- ERROR: trailing junk after numeric literal at or near "9922Ç175" at character 27
Statement: SELECT * FROM RS_ETIQUETA(9922Ç175)
Date: 2026-09-17 11:12:29 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(9922Ç175)
Date: 2026-09-17 11:12:29 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(9922Ç175)
Date: 2026-09-17 11:12:30 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 17 09 2 11 1 - ERROR: syntax error at or near "," at character 27
- ERROR: syntax error at or near "," at character 27
- ERROR: syntax error at or near "241695066668" at character 41
Statement: select * from rs_caixa_qr(,)
Date: 2026-09-17 09:59:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(,)
Date: 2026-09-17 09:59:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241695066668');
Date: 2026-09-17 11:21:31 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 17 08 1 11 1 - ERROR: unterminated quoted string at or near "'230053699000'');" at character 39
- ERROR: unterminated quoted string at or near "''''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('230053699000'');
Date: 2026-09-17 08:25:10 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''''');
Date: 2026-09-17 11:01:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 17 03 1 - LOG: database system was shut down at 2026-09-17 03:05:01 -03
Date: 2026-09-17 03:05:02
11 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 17 11 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000291669"
Date: 2026-09-17 11:05:40
12 1 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 17 07 1 - LOG: process 541731 still waiting for ShareLock on transaction 6224225 after 1000.109 ms
Detail: Process holding the lock: 534574. Wait queue: 541731.
Context: while updating tuple (80050,49) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-17 07:55:11 Database: rio Application: psql User: intelifix Remote: [local]
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 17 11 1 - LOG: process 660238 still waiting for AccessExclusiveLock on relation 5123879 of database 358220 after 1000.090 ms
Detail: Process holding the lock: 722470. Wait queue: 660238.
Statement: DROP TABLE IF EXISTS temp0000291669;Date: 2026-09-17 11:05:40 Database: rio Application: [unknown] User: intelifix Remote: [local]