pgBadger-
Global information
- Generated on Tue Sep 1 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,147 log entries in 14s
- Log start from 2026-09-01 00:00:01 to 2026-09-01 23:50:13
-
Overview
Global Stats
- 377 Number of unique normalized queries
- 6,388 Number of queries
- 7h56m46s Total query duration
- 2026-09-01 00:00:10 First query
- 2026-09-01 23:49:34 Last query
- 5 queries/s at 2026-09-01 12:05:09 Query peak
- 7h56m46s Total query duration
- 168ms Prepare/parse total duration
- 0ms Bind total duration
- 7h56m46s Execute total duration
- 4,045 Number of events
- 14 Number of unique normalized events
- 3,858 Max number of times the same event was reported
- 0 Number of cancellation
- 449 Total number of automatic vacuums
- 982 Total number of automatic analyzes
- 12 Number temporary file
- 243.58 MiB Max size of temporary file
- 104.13 MiB Average size of temporary file
- 385 Total number of sessions
- 8 sessions at 2026-09-01 00:58:58 Session peak
- 13d14h40m3s Total duration of sessions
- 50m54s Average duration of sessions
- 16 Average queries per session
- 1m14s Average queries duration per session
- 49m40s Average idle time per session
- 400 Total number of connections
- 7 connections/s at 2026-09-01 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-01 12:05:09 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-01 12:05:09 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-01 00:29:22 Date
Queries duration
Key values
- 7h56m46s 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 01 00 357 0ms 1m30s 5s780ms 1m9s 1m44s 2m44s 01 56 0ms 23s29ms 1s532ms 8s711ms 9s172ms 23s29ms 02 18 0ms 5s580ms 2s682ms 5s817ms 8s662ms 9s58ms 03 17 0ms 7s903ms 3s412ms 5s984ms 9s688ms 12s938ms 04 28 0ms 6s359ms 2s82ms 6s410ms 9s360ms 11s217ms 05 69 0ms 10m25s 20s671ms 22s494ms 2m56s 10m25s 06 34 0ms 11s743ms 2s635ms 6s442ms 8s542ms 37s563ms 07 179 0ms 13m4s 14s400ms 1m20s 5m24s 13m4s 08 525 150ms 6m20s 4s230ms 1m45s 6m1s 7m 09 585 150ms 6m48s 2s402ms 32s684ms 1m16s 6m59s 10 594 150ms 7m20s 3s57ms 51s108ms 3m47s 7m27s 11 698 150ms 7m46s 2s903ms 37s969ms 5m40s 8m16s 12 134 0ms 6m14s 5s804ms 15s846ms 19s613ms 6m49s 13 483 0ms 6m 2s601ms 42s9ms 1m30s 6m53s 14 608 150ms 6m41s 2s527ms 35s155ms 3m37s 6m50s 15 546 150ms 10m37s 4s678ms 57s927ms 6m22s 10m41s 16 539 150ms 6m30s 2s370ms 29s706ms 1m18s 6m33s 17 320 0ms 6m25s 3s353ms 23s570ms 1m4s 6m28s 18 26 0ms 5m52s 24s455ms 5s494ms 51s713ms 5m52s 19 24 0ms 5m37s 25s273ms 5s511ms 45s523ms 5m37s 20 132 0ms 6m46s 10s110ms 1m9s 2m7s 7m33s 21 36 0ms 6m6s 18s603ms 6s233ms 13s21ms 6m55s 22 30 0ms 5m30s 21s534ms 10s591ms 47s205ms 5m30s 23 350 0ms 1m30s 6s744ms 1m6s 1m12s 1m30s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 01 00 25 301 5s593ms 1m 1m5s 1m9s 01 29 0 367ms 284ms 643ms 1s552ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 9 0 361ms 0ms 0ms 922ms 05 43 0 327ms 553ms 965ms 1s492ms 06 12 0 314ms 0ms 0ms 914ms 07 112 0 19s882ms 3s577ms 58s814ms 8m29s 08 380 0 4s677ms 10s916ms 1m8s 6m 09 468 0 2s495ms 10s408ms 20s718ms 4m9s 10 477 0 3s237ms 9s932ms 18s825ms 6m59s 11 558 0 3s11ms 17s590ms 24s118ms 6m2s 12 87 0 7s697ms 1s768ms 3s553ms 3m19s 13 296 0 3s153ms 7s311ms 21s959ms 3m23s 14 461 0 2s856ms 10s311ms 23s925ms 3m37s 15 383 0 5s952ms 9s970ms 57s287ms 6m53s 16 369 0 2s825ms 11s820ms 14s113ms 3m39s 17 216 0 4s399ms 9s154ms 17s358ms 3m41s 18 7 0 1m25s 0ms 0ms 3m11s 19 6 0 1m34s 0ms 0ms 3m3s 20 27 84 11s297ms 36s543ms 1m5s 3m20s 21 12 0 50s539ms 0ms 0ms 3m8s 22 6 0 1m36s 0ms 0ms 3m22s 23 25 325 6s744ms 1m2s 1m6s 1m22s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 01 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 01 00 0 3 3.00 0.00% 01 0 4 4.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 2 2.00 0.00% 05 0 3 3.00 0.00% 06 0 2 2.00 0.00% 07 0 10 10.00 0.00% 08 0 14 14.00 0.00% 09 0 11 11.00 0.00% 10 0 12 12.00 0.00% 11 0 10 10.00 0.00% 12 0 5 5.00 0.00% 13 0 13 13.00 0.00% 14 0 14 14.00 0.00% 15 0 12 12.00 0.00% 16 0 12 12.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 1 2 2.00 0.29% Day Hour Count Average / Second Sep 01 00 21 0.01/s 01 9 0.00/s 02 9 0.00/s 03 17 0.00/s 04 11 0.00/s 05 11 0.00/s 06 14 0.00/s 07 19 0.01/s 08 22 0.01/s 09 23 0.01/s 10 22 0.01/s 11 22 0.01/s 12 19 0.01/s 13 26 0.01/s 14 23 0.01/s 15 23 0.01/s 16 19 0.01/s 17 21 0.01/s 18 9 0.00/s 19 9 0.00/s 20 15 0.00/s 21 10 0.00/s 22 11 0.00/s 23 15 0.00/s Day Hour Count Average Duration Average idle time Sep 01 00 17 41m24s 39m22s 01 15 1h36s 1h30s 02 9 1h20s 1h15s 03 19 22m13s 22m10s 04 7 1h3m 1h2m51s 05 10 56m23s 54m1s 06 10 57m49s 57m40s 07 17 49m19s 46m47s 08 17 52m9s 49m59s 09 22 54m11s 53m7s 10 23 52m27s 51m8s 11 23 51m42s 50m14s 12 24 43m9s 42m36s 13 16 44m38s 43m20s 14 22 54m57s 53m47s 15 21 57m47s 55m45s 16 16 57m57s 56m37s 17 24 52m19s 51m34s 18 16 58m16s 57m36s 19 10 55m 53m59s 20 11 44m38s 42m37s 21 11 1h17s 59m16s 22 12 56m5s 55m11s 23 13 35m21s 32m19s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-09-01 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 400 connections Total
Connections per user
Key values
- intelifix Main User
- 400 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-01 00:58:58 Date
Histogram of session times
Key values
- 299 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 385 sessions Total
Sessions per user
Key values
- intelifix Main User
- 385 sessions Total
Sessions per host
Key values
- [local] Main Host
- 385 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,400 buffers Checkpoint Peak
- 2026-09-01 14:59:40 Date
- 270.032 seconds Highest write time
- 0.115 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-09-01 13:44:40 Date
Checkpoints distance
Key values
- 296.92 Mo Distance Peak
- 2026-09-01 13:44:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 01 00 3,809 428.439s 0.112s 428.599s 01 4,467 447.991s 0.169s 448.196s 02 1,740 174.55s 0.04s 174.625s 03 2,011 200.899s 0.272s 201.221s 04 2,768 277.505s 0.1s 277.636s 05 12,919 1,245.091s 0.156s 1,245.306s 06 1,211 121.359s 0.003s 121.368s 07 26,073 2,219.064s 0.301s 2,219.448s 08 47,754 3,044.081s 0.335s 3,044.6s 09 49,532 3,238.854s 0.504s 3,239.597s 10 54,661 3,239.066s 0.529s 3,239.772s 11 72,062 3,239.121s 0.457s 3,239.756s 12 17,375 1,773.055s 0.151s 1,773.275s 13 32,371 2,071.583s 0.38s 2,072.219s 14 63,254 3,238.679s 0.542s 3,239.472s 15 50,432 3,239.039s 0.464s 3,239.707s 16 34,663 3,083.067s 0.306s 3,083.557s 17 33,764 2,729.751s 0.241s 2,730.096s 18 690 69.282s 0.101s 69.403s 19 30 3.034s 0.015s 3.059s 20 1,075 111.286s 0.024s 111.324s 21 3,105 311.055s 0.241s 311.507s 22 2,554 256.06s 0.107s 256.213s 23 265 26.631s 0.01s 26.665s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 01 00 0 0 6 572 0.062s 0.008s 01 0 0 1 712 0.063s 0.008s 02 0 0 0 399 0.019s 0.007s 03 0 0 1 379 0.064s 0.01s 04 0 0 0 399 0.061s 0.006s 05 0 0 6 990 0.056s 0.009s 06 0 0 0 10 0.003s 0.001s 07 0 0 19 2,685 0.077s 0.012s 08 0 0 27 5,817 0.065s 0.012s 09 0 0 22 6,935 0.060s 0.012s 10 0 0 37 7,527 0.043s 0.012s 11 0 0 43 8,266 0.034s 0.012s 12 0 0 5 2,445 0.050s 0.011s 13 0 0 26 5,915 0.063s 0.012s 14 0 0 25 6,924 0.064s 0.012s 15 0 0 27 6,630 0.061s 0.012s 16 0 0 17 5,929 0.062s 0.012s 17 0 0 17 4,721 0.060s 0.011s 18 0 0 0 199 0.063s 0.007s 19 0 0 0 7 0.009s 0.006s 20 0 0 1 88 0.011s 0.003s 21 0 0 1 495 0.069s 0.008s 22 0 0 1 409 0.066s 0.008s 23 0 0 0 27 0.003s 0.005s Day Hour Count Avg time (sec) Sep 01 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 01 00 12,272.62 kB 41,917.00 kB 01 2,240.62 kB 20,454.50 kB 02 1,181.71 kB 10,209.86 kB 03 1,250.75 kB 2,648.00 kB 04 1,900.50 kB 2,516.50 kB 05 9,563.67 kB 15,679.89 kB 06 4,802.00 kB 13,272.00 kB 07 25,834.50 kB 52,476.33 kB 08 37,488.17 kB 85,673.92 kB 09 29,091.33 kB 55,077.33 kB 10 50,609.92 kB 79,227.50 kB 11 58,466.08 kB 102,522.92 kB 12 8,050.09 kB 70,093.64 kB 13 35,752.17 kB 71,528.75 kB 14 34,248.83 kB 82,165.08 kB 15 36,497.75 kB 74,045.17 kB 16 23,627.17 kB 62,095.67 kB 17 25,255.36 kB 57,929.45 kB 18 688.80 kB 39,819.20 kB 19 102.50 kB 27,363.50 kB 20 3,521.00 kB 21,894.67 kB 21 2,124.00 kB 13,865.57 kB 22 1,890.14 kB 7,785.14 kB 23 180.00 kB 4,536.80 kB -
Temporary Files
Size of temporary files
Key values
- 487.16 MiB Temp Files size Peak
- 2026-09-01 05:32:07 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-09-01 05:32:13 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 01 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 104.13 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 8 946.19 MiB 72.65 MiB 243.58 MiB 118.27 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-01 05:32:16 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-01 05:32:07 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 303.36 MiB 56.39 MiB 92.80 MiB 75.84 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-01 05:30:45 Duration: 42s687ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-01 05:30:41 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 243.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 243.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 92.80 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-01 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 92.80 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-01 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 80.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 72.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.65 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-01 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 61.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-01 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 56.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-01 05:30:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.79 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-01 16:56:34 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 1.79 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-01 16:56:34 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (111) Main table analyzed (database rio)
- 982 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 111 rio.pg_catalog.pg_class 55 brasilia.pg_catalog.pg_attribute 47 rio.pg_catalog.pg_type 47 rio.public.usuarios 46 contagem.pg_catalog.pg_attribute 37 rio.public.temp0000290284 33 contagem.public.usuarios 31 rio.pg_catalog.pg_index 28 rio.auditor.auditor_2026_09 27 contagem.auditor.auditor_2026_09 23 rio.public.temp0000290158 23 rio.pg_catalog.pg_depend 23 brasilia.pg_catalog.pg_class 21 brasilia.auditor.auditor_2026_09 20 contagem.pg_catalog.pg_class 19 contagem.pg_catalog.pg_type 18 rio.public.temp0000290228 18 brasilia.pg_catalog.pg_type 17 rio.public.temp0000290260 16 rio.public.temp0000290218 15 rio.public.temp0000290230 15 rio.public.temp0000290252 14 brasilia.public.temp0000239342 13 contagem.pg_catalog.pg_index 13 rio.public.temp0000290236 12 rio.public.temp0000290026 11 contagem.pg_catalog.pg_depend 10 rio.public.temp0000290204 10 brasilia.pg_catalog.pg_index 10 rio.public.temp0000290322 10 contagem.public.temp0000227031 9 brasilia.public.usuarios 9 brasilia.public.temp0000239284 9 rio.public.temp0000290226 9 rio.public.temp0000290316 8 brasilia.pg_catalog.pg_depend 8 contagem.public.nf_entrada 7 rio.public.temp0000290210 7 rio.public.temp0000290232 7 brasilia.public.temp0000239280 6 contagem.pg_catalog.pg_shdepend 5 contagem.public.temp0000227005 5 rio.public.temp0000290206 5 rio.public.temp0000290234 5 rio.public.temp0000290192 5 rio.public.temp0000290264 4 brasilia.pg_catalog.pg_shdepend 4 rio.public.temp0000290188 4 rio.public.temp0000290208 4 brasilia.public.temp0000239298 3 rio.public.temp0000290334 3 postgres.pg_catalog.pg_shdepend 3 brasilia.public.temp0000239354 3 rio.public.tmp_drill_0175 3 rio.public.temp0000290306 3 contagem.public.temp0000227033 3 rio.public.temp0000290202 3 rio.public.temp0000290338 2 rio.public.temp0000290190 2 contagem.public.temp0000227029 2 brasilia.public.temp0000239314 2 contagem.public.temp0000227039 2 rio.public.tmp_drill_0302 2 rio.public.tmp_drill_0320 2 brasilia.public.temp0000239324 2 rio.public.temp0000290312 1 brasilia.public.temp0000239380 1 rio.public.temp0000290298 1 rio.public.temp0000290290 1 rio.public.temp0000290180 1 rio.public.temp0000290332 1 rio.public.temp0000290224 1 rio.public.temp0000290296 1 rio.public.temp0000290308 1 brasilia.public.temp0000239334 1 brasilia.public.temp0000239286 1 contagem.public.temp0000227013 1 brasilia.public.temp0000239322 1 brasilia.public.temp0000239358 1 brasilia.public.temp0000239312 1 brasilia.public.temp0000239360 1 brasilia.public.temp0000239332 1 rio.public.temp0000290254 1 rio.public.temp0000290256 1 brasilia.public.temp0000239374 1 brasilia.public.temp0000239370 1 brasilia.public.nf_entrada 1 rio.public.temp0000290222 1 rio.pg_catalog.pg_shdepend 1 rio.public.temp0000290216 1 rio.public.temp0000290220 1 rio.public.temp0000290328 1 contagem.public.temp0000227027 1 contagem.public.nf_entrada_modelos 1 Total 982 Vacuums per table
Key values
- pg_catalog.pg_attribute (39) Main table vacuumed on database rio
- 449 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 39 39 0 0 0 0 0 21,264 5,888 8,318,180 333 8,609 contagem.public.usuarios 30 0 0 0 0 0 0 144 103 56,307 0 0 contagem.pg_catalog.pg_attribute 22 22 0 0 0 0 0 22,617 3,926 8,021,415 47 962 rio.pg_catalog.pg_class 20 19 0 0 0 0 0 4,068 1,337 2,013,535 70 280 rio.public.temp0000290228 18 0 0 0 0 0 0 28,314 70 1,681,250 0 0 rio.pg_catalog.pg_type 18 18 0 0 0 0 0 1,737 524 721,022 54 176 rio.auditor.auditor_2026_09 16 0 0 0 0 0 0 52,547 32,908 42,523,824 7,274 142,995 rio.public.temp0000290252 14 0 0 0 0 0 0 979 72 68,799 0 0 contagem.pg_catalog.pg_class 14 14 0 0 0 0 0 5,520 793 1,508,832 11 36 contagem.pg_catalog.pg_type 14 14 0 0 0 0 0 2,785 501 957,909 16 36 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 6,509 1,825 2,933,641 68 1,774 contagem.auditor.auditor_2026_09 12 2 0 0 0 0 0 18,220 10,174 12,708,720 2,091 38,075 rio.pg_catalog.pg_index 12 12 0 0 0 0 0 644 203 229,451 30 85 contagem.pg_catalog.pg_depend 11 11 0 0 0 0 0 5,637 973 2,235,918 19 121 contagem.pg_catalog.pg_index 11 11 0 0 0 0 0 1,138 226 307,719 10 17 rio.public.temp0000290322 10 0 0 0 0 0 0 2,262 55 141,892 0 0 postgres.pg_catalog.pg_shdepend 10 10 0 0 0 0 0 1,526 351 600,763 72 139 contagem.public.temp0000227031 9 0 0 0 0 0 0 909 263 416,835 0 0 brasilia.auditor.auditor_2026_09 9 0 0 0 0 0 0 8,669 5,789 7,231,418 842 16,108 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,966 895 1,318,758 61 499 rio.public.temp0000290026 9 0 0 0 0 0 0 827 43 55,202 0 0 rio.public.temp0000290284 8 0 0 0 0 0 0 4,161 42 251,947 0 0 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 556 179 270,037 7 34 rio.public.temp0000290158 7 0 0 0 0 0 0 891 40 58,952 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,600 2,649 10,376,608 1,612 7,505 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,293 449 765,440 20 84 rio.public.tmp_drill_0175 6 2 0 0 0 0 0 81 28 44,822 1 12 rio.public.temp0000290230 6 0 0 0 0 0 0 485 96 135,615 0 0 rio.public.usuarios 6 5 0 0 0 0 0 123 51 96,097 7 9 rio.public.temp0000290204 6 0 0 0 0 0 0 5,316 21 317,067 0 0 rio.public.temp0000290264 4 0 0 0 0 0 0 7,076 1,782 2,700,782 0 0 rio.public.temp0000290260 4 0 0 0 0 0 0 356 24 24,564 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 218 63 50,764 14 29 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,137 892 3,439,136 640 4,027 rio.public.tmp_drill_0302 3 2 0 0 0 0 0 65 23 32,754 0 0 brasilia.public.temp0000239354 3 0 0 0 0 0 0 749 12 46,000 0 0 brasilia.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 433 118 199,562 20 28 rio.public.temp0000290234 3 0 0 0 0 0 0 334 18 22,500 0 0 contagem.public.temp0000227033 3 0 0 0 0 0 0 339 18 23,013 0 0 rio.public.temp0000290334 3 0 0 0 0 0 0 94 16 8,079 0 0 rio.public.temp0000290206 3 0 0 0 0 0 0 287 18 19,640 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,752 479 2,316,065 156 482 rio.public.temp0000290306 3 0 0 0 0 0 0 219 84 158,669 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 296 75 340,392 28 69 brasilia.public.temp0000239314 2 0 0 0 0 0 0 498 8 30,588 0 0 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 1,649 6 283,621 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 543 176 240,224 13 124 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 277 72 205,228 14 37 contagem.public.temp0000227039 2 0 0 0 0 0 0 226 117 193,249 0 0 brasilia.public.temp0000239324 2 0 0 0 0 0 0 498 8 30,588 0 0 rio.public.temp0000290224 1 0 0 0 0 0 0 1,768 4 104,915 0 0 rio.public.temp0000290296 1 0 0 0 0 0 0 73 6 5,194 0 0 rio.public.temp0000290218 1 0 0 0 0 0 0 67 6 4,803 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,411 854 2,656,291 809 5,726 rio.public.temp0000290290 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000290298 1 0 0 0 0 0 0 73 6 5,195 0 0 rio.public.temp0000290256 1 0 0 0 0 0 0 73 72 149,975 0 0 brasilia.public.temp0000239332 1 0 0 0 0 0 0 249 4 15,294 0 0 rio.public.temp0000290312 1 0 0 0 0 0 0 73 6 5,196 0 0 rio.public.temp0000290216 1 0 0 0 0 0 0 8 5 1,194 0 0 brasilia.public.temp0000239312 1 0 0 0 0 0 0 249 4 15,294 0 0 brasilia.public.temp0000239358 1 0 0 0 0 0 0 250 4 15,353 0 0 brasilia.public.temp0000239370 1 0 0 0 0 0 0 250 4 15,353 0 0 Total 449 246 0 0 0 0 0 236,382 75,461 119,728,224 14,339 228,078 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (9.63) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.29 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 1.95 rio.pg_catalog.pg_class 0 0 1.06 rio.public.temp0000290228 0 0 0.9 rio.pg_catalog.pg_type 0 0 0.36 rio.auditor.auditor_2026_09 0 0 9.63 rio.public.temp0000290252 0 0 0.1 contagem.pg_catalog.pg_class 0 0 0.51 contagem.pg_catalog.pg_type 0 0 0.3 brasilia.pg_catalog.pg_attribute 0 0 1.06 contagem.auditor.auditor_2026_09 0 0 3.29 rio.pg_catalog.pg_index 0 0 0.26 contagem.pg_catalog.pg_depend 0 0 0.61 contagem.pg_catalog.pg_index 0 0 0.15 rio.public.temp0000290322 0 0 0.11 postgres.pg_catalog.pg_shdepend 0 0 0.37 contagem.public.temp0000227031 0 0 0.07 brasilia.auditor.auditor_2026_09 0 0 1.65 rio.pg_catalog.pg_depend 0 0 0.51 rio.public.temp0000290026 0 0 0.02 rio.public.temp0000290284 0 0 0.14 brasilia.pg_catalog.pg_type 0 0 0.36 rio.public.temp0000290158 0 0 0.06 rio.pg_catalog.pg_statistic 0 0 1.2 brasilia.pg_catalog.pg_class 0 0 0.38 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000290230 0 0 0.09 rio.public.usuarios 0 0 0 rio.public.temp0000290204 0 0 0.29 rio.public.temp0000290264 0 0 0.24 rio.public.temp0000290260 0 0 0.03 brasilia.pg_catalog.pg_index 0 0 0.3 brasilia.pg_catalog.pg_statistic 0 0 0.54 rio.public.tmp_drill_0302 0 0 0 brasilia.public.temp0000239354 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.06 rio.public.temp0000290234 0 0 0.03 contagem.public.temp0000227033 0 0 0.02 rio.public.temp0000290334 0 0 0.03 rio.public.temp0000290206 0 0 0.03 rio.pg_toast.pg_toast_2619 0 0 0.18 rio.public.temp0000290306 0 0 0.03 brasilia.pg_toast.pg_toast_2619 0 0 0.04 brasilia.public.temp0000239314 0 0 0 rio.public.tmp_drill_0320 0 0 0.06 brasilia.pg_catalog.pg_depend 0 0 0.44 contagem.pg_toast.pg_toast_2619 0 0 0.05 contagem.public.temp0000227039 0 0 0.02 brasilia.public.temp0000239324 0 0 0 rio.public.temp0000290224 0 0 0.05 rio.public.temp0000290296 0 0 0.01 rio.public.temp0000290218 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.11 rio.public.temp0000290290 0 0 0 rio.public.temp0000290298 0 0 0.01 rio.public.temp0000290256 0 0 0.01 brasilia.public.temp0000239332 0 0 0 rio.public.temp0000290312 0 0 0.01 rio.public.temp0000290216 0 0 0.01 brasilia.public.temp0000239312 0 0 0 brasilia.public.temp0000239358 0 0 0 brasilia.public.temp0000239370 0 0 0 Total 0 0 31.04 Tuples removed per table
Key values
- pg_catalog.pg_attribute (212020) Main table with removed tuples on database contagem
- 627476 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 22 22 212,020 524,066 68 1,323 14,857 rio.pg_catalog.pg_attribute 39 39 158,940 963,777 14,514 204 24,391 contagem.pg_catalog.pg_depend 11 11 51,836 201,744 12 63 2,320 brasilia.pg_catalog.pg_attribute 13 13 50,970 288,740 0 203 7,153 rio.public.tmp_drill_0320 2 2 24,628 25,200 0 0 636 contagem.pg_catalog.pg_type 14 14 20,118 33,040 2 244 1,149 contagem.auditor.auditor_2026_09 12 2 15,300 1,155,366 0 0 53,791 postgres.pg_catalog.pg_shdepend 10 10 13,177 136,192 384 0 1,250 rio.pg_catalog.pg_statistic 7 7 12,930 58,461 185 0 9,002 rio.auditor.auditor_2026_09 16 0 10,666 4,039,516 0 0 195,119 contagem.pg_catalog.pg_index 11 11 8,975 20,889 1 35 785 rio.pg_catalog.pg_depend 9 9 7,341 171,883 181 0 1,647 brasilia.pg_catalog.pg_statistic 3 3 6,072 23,300 0 0 3,216 rio.pg_catalog.pg_type 18 18 6,054 41,426 538 11 1,314 contagem.pg_catalog.pg_class 14 14 4,952 51,415 4 496 2,329 contagem.pg_catalog.pg_statistic 1 1 4,107 7,274 0 0 1,011 rio.pg_catalog.pg_class 20 19 3,647 72,271 1,774 17 2,647 brasilia.pg_catalog.pg_shdepend 3 3 2,672 41,512 796 0 375 brasilia.pg_catalog.pg_class 7 7 2,488 24,554 0 22 880 rio.pg_catalog.pg_index 12 12 2,242 23,177 106 10 628 contagem.public.usuarios 30 0 1,837 720 0 0 60 brasilia.pg_catalog.pg_depend 2 2 1,661 35,954 12 13 344 brasilia.pg_catalog.pg_type 7 7 1,022 15,461 4 27 419 rio.pg_toast.pg_toast_2619 3 3 988 2,263 18 0 822 brasilia.pg_catalog.pg_index 4 4 911 7,556 2 0 216 rio.public.tmp_drill_0175 6 2 862 4,376 1,757 0 72 rio.public.tmp_drill_0302 3 2 441 1,616 441 0 32 rio.public.usuarios 6 5 228 3,656 602 0 126 contagem.pg_toast.pg_toast_2619 2 2 213 234 0 0 126 brasilia.pg_toast.pg_toast_2619 2 2 178 271 0 0 122 rio.public.temp0000290224 1 0 0 24,971 0 0 1,792 brasilia.public.temp0000239314 2 0 0 6,548 0 0 512 rio.public.temp0000290296 1 0 0 1,058 0 63 65 rio.public.temp0000290252 14 0 0 54,758 0 372 1,228 contagem.public.temp0000227031 9 0 0 12,159 0 210 942 rio.public.temp0000290284 8 0 0 74,131 0 125 4,163 rio.public.temp0000290218 1 0 0 2,689 0 5 59 rio.public.temp0000290322 10 0 0 34,983 0 523 2,421 brasilia.auditor.auditor_2026_09 9 0 0 597,352 0 0 27,317 rio.public.temp0000290290 1 0 0 1,014 0 0 64 brasilia.public.temp0000239354 3 0 0 9,827 0 0 768 rio.public.temp0000290158 7 0 0 37,393 0 313 839 rio.public.temp0000290264 4 0 0 99,914 0 0 7,168 rio.public.temp0000290298 1 0 0 1,058 0 63 65 rio.public.temp0000290256 1 0 0 1,061 0 63 65 brasilia.public.temp0000239332 1 0 0 3,274 0 0 256 rio.public.temp0000290312 1 0 0 1,061 0 63 65 rio.public.temp0000290234 3 0 0 13,918 0 138 310 contagem.public.temp0000227033 3 0 0 4,046 0 71 313 rio.public.temp0000290260 4 0 0 14,718 0 188 324 rio.public.temp0000290230 6 0 0 19,904 0 196 444 rio.public.temp0000290216 1 0 0 1,490 0 31 33 rio.public.temp0000290228 18 0 0 449,601 0 0 32,256 rio.public.temp0000290334 3 0 0 3,342 0 174 210 rio.public.temp0000290206 3 0 0 11,853 0 121 263 brasilia.public.temp0000239312 1 0 0 3,274 0 0 256 contagem.public.temp0000227039 2 0 0 2,711 0 46 210 brasilia.public.temp0000239358 1 0 0 3,278 0 0 256 rio.public.temp0000290306 3 0 0 3,180 0 189 195 brasilia.public.temp0000239324 2 0 0 6,548 0 0 512 rio.public.temp0000290204 6 0 0 149,790 0 0 10,752 brasilia.public.temp0000239370 1 0 0 3,278 0 0 256 rio.public.temp0000290026 9 0 0 40,256 0 108 916 Total 449 246 627,476 9,670,348 21,401 5,730 422,134 Pages removed per table
Key values
- pg_catalog.pg_attribute (1323) Main table with removed pages on database contagem
- 5730 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_attribute 22 22 212020 1323 rio.public.temp0000290322 10 0 0 523 contagem.pg_catalog.pg_class 14 14 4952 496 rio.public.temp0000290252 14 0 0 372 rio.public.temp0000290158 7 0 0 313 contagem.pg_catalog.pg_type 14 14 20118 244 contagem.public.temp0000227031 9 0 0 210 rio.pg_catalog.pg_attribute 39 39 158940 204 brasilia.pg_catalog.pg_attribute 13 13 50970 203 rio.public.temp0000290230 6 0 0 196 rio.public.temp0000290306 3 0 0 189 rio.public.temp0000290260 4 0 0 188 rio.public.temp0000290334 3 0 0 174 rio.public.temp0000290234 3 0 0 138 rio.public.temp0000290284 8 0 0 125 rio.public.temp0000290206 3 0 0 121 rio.public.temp0000290026 9 0 0 108 contagem.public.temp0000227033 3 0 0 71 rio.public.temp0000290296 1 0 0 63 contagem.pg_catalog.pg_depend 11 11 51836 63 rio.public.temp0000290298 1 0 0 63 rio.public.temp0000290256 1 0 0 63 rio.public.temp0000290312 1 0 0 63 contagem.public.temp0000227039 2 0 0 46 contagem.pg_catalog.pg_index 11 11 8975 35 rio.public.temp0000290216 1 0 0 31 brasilia.pg_catalog.pg_type 7 7 1022 27 brasilia.pg_catalog.pg_class 7 7 2488 22 rio.pg_catalog.pg_class 20 19 3647 17 brasilia.pg_catalog.pg_depend 2 2 1661 13 rio.pg_catalog.pg_type 18 18 6054 11 rio.pg_catalog.pg_index 12 12 2242 10 rio.public.temp0000290218 1 0 0 5 brasilia.pg_toast.pg_toast_2619 2 2 178 0 rio.public.temp0000290224 1 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6072 0 contagem.public.usuarios 30 0 1837 0 brasilia.public.temp0000239314 2 0 0 0 rio.public.tmp_drill_0320 2 2 24628 0 rio.public.tmp_drill_0175 6 2 862 0 contagem.pg_catalog.pg_statistic 1 1 4107 0 brasilia.auditor.auditor_2026_09 9 0 0 0 rio.public.temp0000290290 1 0 0 0 contagem.auditor.auditor_2026_09 12 2 15300 0 rio.public.tmp_drill_0302 3 2 441 0 rio.pg_catalog.pg_depend 9 9 7341 0 brasilia.public.temp0000239354 3 0 0 0 brasilia.pg_catalog.pg_shdepend 3 3 2672 0 rio.public.temp0000290264 4 0 0 0 rio.pg_catalog.pg_statistic 7 7 12930 0 brasilia.public.temp0000239332 1 0 0 0 postgres.pg_catalog.pg_shdepend 10 10 13177 0 brasilia.pg_catalog.pg_index 4 4 911 0 contagem.pg_toast.pg_toast_2619 2 2 213 0 rio.public.usuarios 6 5 228 0 rio.public.temp0000290228 18 0 0 0 brasilia.public.temp0000239312 1 0 0 0 brasilia.public.temp0000239358 1 0 0 0 rio.pg_toast.pg_toast_2619 3 3 988 0 brasilia.public.temp0000239324 2 0 0 0 rio.public.temp0000290204 6 0 0 0 brasilia.public.temp0000239370 1 0 0 0 rio.auditor.auditor_2026_09 16 0 10666 0 Total 449 246 627,476 5,730 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 01 00 3 4 01 2 5 02 0 1 03 0 1 04 1 1 05 9 9 06 0 3 07 11 28 08 32 99 09 46 104 10 77 104 11 78 147 12 5 13 13 41 95 14 38 91 15 43 105 16 32 96 17 28 68 18 0 1 19 0 0 20 0 0 21 3 7 22 0 0 23 0 0 - 1.79 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 32s937ms 32s937ms 32s937ms 32s937ms select * from rs_auditor_novas_tabelas ();-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-01 00:02:37 Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-01 00:02:40 Database: contagem User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-09-01 00:02:38 Database: brasilia User: lenon Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 32s937ms SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-09-01 00:02:37 - Database: rio - User: lenon - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,008 Total read queries
- 1,827 Total write queries
Queries by database
Key values
- rio Main database
- 3,982 Requests
- 5h44m4s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,240 Requests
User Request type Count Duration etiquetas Total 39 15s768ms select 39 15s768ms intelifix Total 6,240 7h55m8s copy to 710 1h18m20s ddl 1,117 31m33s others 552 55m3s select 3,860 5h10m10s lenon Total 109 1m22s select 109 1m22s Duration by user
Key values
- 7h55m8s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 39 15s768ms select 39 15s768ms intelifix Total 6,240 7h55m8s copy to 710 1h18m20s ddl 1,117 31m33s others 552 55m3s select 3,860 5h10m10s lenon Total 109 1m22s select 109 1m22s Queries by host
Key values
- [local] Main host
- 6,388 Requests
- 7h56m46s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,887 Requests
- 4h7m14s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-01 17:35:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,996 100-500ms duration
Slowest individual queries
Rank Duration Query 1 13m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 07:18:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-09-01 15:51:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 10m25s analyze verbose;[ Date: 2026-09-01 05:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029286, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-01 07:23:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 7m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 11:12:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 10:12:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029300, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-01 10:30:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m54s analyze verbose;[ Date: 2026-09-01 05:17:21 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
9 6m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 09:11:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 15:11:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 20:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 14:11:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 16:11:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 17:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 08:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029319, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-01 15:44:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 12:11:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 21:11:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-01 13:11:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m57s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029307, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-01 11:50:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h56m38s 48 1s428ms 13m4s 2m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 01 07 3 14m10s 4m43s 08 3 6m44s 2m14s 09 3 7m18s 2m26s 10 3 7m44s 2m34s 11 3 8m23s 2m47s 12 3 6m35s 2m11s 13 3 6m19s 2m6s 14 3 7m6s 2m22s 15 3 7m9s 2m23s 16 3 6m51s 2m17s 17 3 6m44s 2m14s 18 3 6m11s 2m3s 19 3 5m55s 1m58s 20 3 7m10s 2m23s 21 3 6m25s 2m8s 22 3 5m48s 1m56s [ User: intelifix - Total duration: 1h56m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 07:18:05 Duration: 13m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 11:12:48 Duration: 7m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 10:12:22 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: psql
2 1h11m32s 211 151ms 10m37s 20s345ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 01 07 6 14m5s 2m20s 08 14 13m58s 59s881ms 09 26 50s614ms 1s946ms 10 49 7m34s 9s277ms 11 34 6m58s 12s298ms 12 2 1s434ms 717ms 13 30 39s821ms 1s327ms 14 18 4m37s 15s399ms 15 12 21m47s 1m48s 16 9 30s253ms 3s361ms 17 11 29s665ms 2s696ms [ User: intelifix - Total duration: 1h11m32s - Times executed: 211 ]
[ Application: [unknown] - Total duration: 1h11m32s - Times executed: 211 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-09-01 15:51:07 Duration: 10m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029286, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-01 07:23:52 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029300, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-01 10:30:17 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h8m11s 48 262ms 4m59s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 01 07 3 7m6s 2m22s 08 3 4m9s 1m23s 09 3 4m30s 1m30s 10 3 4m9s 1m23s 11 3 5m9s 1m43s 12 3 3m49s 1m16s 13 3 3m53s 1m17s 14 3 4m5s 1m21s 15 3 4m 1m20s 16 3 4m11s 1m23s 17 3 4m11s 1m23s 18 3 3m44s 1m14s 19 3 3m31s 1m10s 20 3 4m7s 1m22s 21 3 3m38s 1m12s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h8m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 07:26:05 Duration: 4m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 11:18:24 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 09:16:42 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
4 24m52s 1,469 150ms 7s850ms 1s16ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 01 08 137 2m27s 1s80ms 09 204 3m7s 916ms 10 172 3m5s 1s78ms 11 209 2m52s 825ms 12 47 30s692ms 653ms 13 95 1m14s 781ms 14 227 3m54s 1s34ms 15 163 2m23s 878ms 16 118 2m52s 1s459ms 17 97 2m24s 1s489ms [ User: intelifix - Total duration: 24m52s - Times executed: 1469 ]
[ Application: [unknown] - Total duration: 24m52s - Times executed: 1469 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55248, 413, '834121918001676,241598156279,241704326977,241622586587,241668293652,241646273052,241656301023,230049379106,241601082435,241695608191,241659800725,241617366571,241609830820,241622532340,241659712736,241598852644,241713349710,241649698908,241668029911,241637660618,241714026779,241622478697,230043576979,241689131926,241712511032,241700951531,241712553235,241659667478,241698672442,241727450728,241609857387,241676759102,241727495557,241659821131,241676341228,241654433242,241647389715,241732103942,241647389311,230043536470,241649249717', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 08:44:46 Duration: 7s850ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55203, 406, '226334320208', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 16:27:09 Duration: 7s841ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55249, 413, '246220233350', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 08:57:50 Duration: 7s301ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 20m15s 3 2m55s 10m25s 6m45s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 01 05 3 20m15s 6m45s [ User: intelifix - Total duration: 20m15s - Times executed: 3 ]
[ Application: psql - Total duration: 20m15s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-01 05:10:27 Duration: 10m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-01 05:17:21 Duration: 6m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-01 05:20:17 Duration: 2m55s Database: contagem User: intelifix Remote: [local] Application: psql
6 16m2s 278 171ms 23s206ms 3s461ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 01 00 14 2m4s 8s925ms 01 12 32s809ms 2s734ms 02 12 32s157ms 2s679ms 03 12 33s838ms 2s819ms 04 12 32s411ms 2s700ms 05 12 39s468ms 3s289ms 06 12 36s557ms 3s46ms 07 12 45s318ms 3s776ms 08 12 43s180ms 3s598ms 09 12 35s826ms 2s985ms 10 12 38s955ms 3s246ms 11 12 37s185ms 3s98ms 12 12 33s795ms 2s816ms 13 12 37s404ms 3s117ms 14 12 39s716ms 3s309ms 15 12 39s598ms 3s299ms 16 12 41s796ms 3s483ms 17 12 36s541ms 3s45ms 18 12 32s819ms 2s734ms 19 12 33s655ms 2s804ms 20 12 1m 5s14ms 21 12 35s782ms 2s981ms 22 12 38s380ms 3s198ms [ User: intelifix - Total duration: 16m2s - Times executed: 278 ]
[ Application: psql - Total duration: 16m2s - Times executed: 278 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:25:29 Duration: 23s206ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:15:33 Duration: 22s934ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:05:48 Duration: 22s782ms Database: rio User: intelifix Remote: [local] Application: psql
7 11m1s 166 165ms 24s789ms 3s982ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 01 00 10 53s421ms 5s342ms 01 6 16s426ms 2s737ms 02 6 16s121ms 2s686ms 03 5 24s169ms 4s833ms 04 6 20s414ms 3s402ms 05 4 21s351ms 5s337ms 07 10 49s444ms 4s944ms 08 12 54s537ms 4s544ms 09 12 56s882ms 4s740ms 10 12 50s376ms 4s198ms 11 12 57s483ms 4s790ms 12 12 56s785ms 4s732ms 13 9 11s201ms 1s244ms 14 10 39s791ms 3s979ms 15 12 55s207ms 4s600ms 16 9 29s51ms 3s227ms 17 5 5s282ms 1s56ms 20 3 1s88ms 362ms 21 5 19s945ms 3s989ms 22 6 22s120ms 3s686ms [ User: intelifix - Total duration: 11m1s - Times executed: 166 ]
[ Application: psql - Total duration: 11m1s - Times executed: 166 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 00:05:25 Duration: 24s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 14:45:12 Duration: 11s840ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 07:55:13 Duration: 11s794ms Database: rio User: intelifix Remote: [local] Application: psql
8 10m6s 929 150ms 3s161ms 652ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 01 07 34 27s276ms 802ms 08 94 1m8s 733ms 09 104 1m6s 636ms 10 111 1m3s 569ms 11 150 1m36s 645ms 12 6 3s103ms 517ms 13 61 35s858ms 587ms 14 102 1m4s 630ms 15 106 1m19s 751ms 16 134 1m23s 621ms 17 27 17s319ms 641ms [ User: intelifix - Total duration: 10m6s - Times executed: 929 ]
[ Application: [unknown] - Total duration: 10m6s - Times executed: 929 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "283074", "modelo" : "137", "itens" : "229765309306,229643077275,229731773048,229825051624,229713855272,229829632531,229828039704,229713136279,229647055060,229679149618,229700710421,229645425361,229676041021,229730950914,229714218696,229708604647,229708526379,229715754548,216924075861,229707833349", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246559184757,246479263557,246565738001,246220730122,246532396890,246626649613,246633751025,246533451326,246453030728,246493727796,246521569212,246475786281,246443671621,246564983247,246528806472,246541112343,246539044161,246551987073,246440454954,246537582941,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-01 15:47:45 Duration: 3s161ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "283178", "modelo" : "454", "itens" : "241613823353,241625488700,241612211131,241627172445,241627224144,241614442841,241612164257,241625145153,241624634363,241624618199,241625091737,241640769292,241640673145,241613710312,241624603653,241611823337,241632391125,241632387891,241624640930,241627186385,241624228789,241634154046,241625425966,241640826167,241600573642,241632699819,241611667081,241625023346,241633522335,241623374655,241633708188,241632747982,241644757179,241624022833,241632975659,241627848807,241623888397,241611519413,241613581029,241624994757,241624605370,241625415561,241642225058,241640090305,241627247681,241641452222,241613378102,241625003546", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-01 11:12:14 Duration: 3s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "283074", "modelo" : "137", "itens" : "229697430415,229880891821,229641203737,229691858186,229828192020,229640467997,229775979113,229714281431,229714050522,229705442633,229778520708,216929741028,229695441130,229826709810,216924741213,229699134060,216929466174,229764619811,229715096369,229830435572", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246512928794,226232936878,246479170013,246493473855,246632472123,246448481215,246576824346,246525951234,246526049503,246557849509,246577840821,246445710507,246501366364,246624755567,246441124144,246522454360,246541763753,246561114968,246533856572,246633538096,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-01 15:29:54 Duration: 3s64ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 4m55s 21 10s248ms 37s636ms 14s71ms create table temp0000290228 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 01 08 3 41s251ms 13s750ms 09 5 1m1s 12s394ms 10 2 22s901ms 11s450ms 11 5 1m31s 18s313ms 13 4 51s219ms 12s804ms 14 2 26s600ms 13s300ms [ User: intelifix - Total duration: 4m55s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m55s - Times executed: 21 ]
-
CREATE TABLE temp0000290228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 11:18:44 Duration: 37s636ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 14:47:41 Duration: 15s237ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 08:31:53 Duration: 14s714ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 4m54s 20 10s251ms 1m10s 14s718ms create table temp0000290204 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 01 07 12 3m20s 16s713ms 08 8 1m33s 11s724ms [ User: intelifix - Total duration: 4m54s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 20 ]
-
CREATE TABLE temp0000290204 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 07:12:52 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290204 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 07:34:42 Duration: 14s880ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290204 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 08:25:46 Duration: 13s920ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m48s 6 6s393ms 1m30s 48s101ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 01 00 2 1m36s 48s459ms 20 2 1m34s 47s455ms 23 2 1m36s 48s389ms [ User: intelifix - Total duration: 4m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 4m48s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-01 00:02:10 Duration: 1m30s 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-01 23:16:53 Duration: 1m30s 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-01 20:09:09 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
12 4m29s 81 967ms 8s75ms 3s332ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 01 07 4 7s519ms 1s879ms 08 3 5s112ms 1s704ms 09 4 11s195ms 2s798ms 10 6 20s496ms 3s416ms 11 18 51s845ms 2s880ms 12 1 1s793ms 1s793ms 13 7 28s312ms 4s44ms 14 5 20s972ms 4s194ms 15 7 24s749ms 3s535ms 16 13 54s545ms 4s195ms 17 13 43s411ms 3s339ms [ User: intelifix - Total duration: 4m29s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 4m29s - Times executed: 81 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 15:15:37 Duration: 8s75ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 15:40:40 Duration: 7s116ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 16:46:10 Duration: 6s536ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m46s 13 11s655ms 14s945ms 12s834ms create table temp0000290264 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 01 10 6 1m19s 13s177ms 11 7 1m27s 12s539ms [ User: intelifix - Total duration: 2m46s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 13 ]
-
CREATE TABLE temp0000290264 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 10:21:24 Duration: 14s945ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290264 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 10:21:44 Duration: 13s576ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290264 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 11:41:14 Duration: 13s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m44s 33 367ms 44s156ms 4s982ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 01 07 2 47s867ms 23s933ms 08 4 11s472ms 2s868ms 09 5 13s557ms 2s711ms 10 3 17s770ms 5s923ms 11 6 24s965ms 4s160ms 13 6 38s22ms 6s337ms 15 5 7s762ms 1s552ms 17 2 3s18ms 1s509ms [ User: intelifix - Total duration: 2m44s - Times executed: 33 ]
[ Application: psql - Total duration: 2m44s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029286);
Date: 2026-09-01 07:15:40 Duration: 44s156ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029309);
Date: 2026-09-01 13:24:19 Duration: 18s96ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029312);
Date: 2026-09-01 13:37:29 Duration: 14s635ms Database: rio User: intelifix Remote: [local] Application: psql
15 2m40s 35 215ms 49s228ms 4s591ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 01 07 4 3s395ms 848ms 08 5 7s325ms 1s465ms 09 5 20s997ms 4s199ms 10 3 22s28ms 7s342ms 11 6 25s196ms 4s199ms 13 8 1m8s 8s527ms 14 1 11s71ms 11s71ms 15 2 1s763ms 881ms 16 1 700ms 700ms [ User: intelifix - Total duration: 2m40s - Times executed: 35 ]
[ Application: psql - Total duration: 2m40s - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029312);
Date: 2026-09-01 13:37:14 Duration: 49s228ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029301);
Date: 2026-09-01 10:45:52 Duration: 20s806ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029316);
Date: 2026-09-01 13:46:03 Duration: 17s408ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m18s 38 659ms 10s461ms 3s632ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 01 08 3 12s727ms 4s242ms 09 1 6s142ms 6s142ms 10 3 21s555ms 7s185ms 11 2 11s333ms 5s666ms 12 3 7s304ms 2s434ms 13 3 7s210ms 2s403ms 14 3 11s103ms 3s701ms 15 3 17s220ms 5s740ms 16 3 19s95ms 6s365ms 17 2 10s376ms 5s188ms 18 3 3s479ms 1s159ms 19 3 3s104ms 1s34ms 20 1 1s339ms 1s339ms 21 2 3s160ms 1s580ms 22 3 2s881ms 960ms [ User: intelifix - Total duration: 2m18s - Times executed: 38 ]
[ Application: psql - Total duration: 2m18s - Times executed: 38 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-01 11:20:12 Duration: 10s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-01 10:40:11 Duration: 10s148ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-01 16:00:11 Duration: 9s875ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m9s 11 10s722ms 14s872ms 11s800ms create table temp0000290284 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 01 13 11 2m9s 11s800ms [ User: intelifix - Total duration: 2m9s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 11 ]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 13:23:28 Duration: 14s872ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 13:33:53 Duration: 12s423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 13:23:51 Duration: 12s68ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 1m56s 5 472ms 57s738ms 23s346ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 01 00 1 472ms 472ms 20 2 58s311ms 29s155ms 23 2 57s946ms 28s973ms [ User: intelifix - Total duration: 1m56s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-01 20:05:50 Duration: 57s738ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-01 23:13:31 Duration: 57s339ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-01 23:37:39 Duration: 606ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m52s 9 11s646ms 13s856ms 12s518ms create table temp0000290322 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 01 15 6 1m16s 12s719ms 16 3 36s352ms 12s117ms [ User: intelifix - Total duration: 1m52s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 9 ]
-
CREATE TABLE temp0000290322 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 15:37:38 Duration: 13s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290322 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 15:36:05 Duration: 13s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290322 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 15:36:43 Duration: 12s691ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m48s 9 2s742ms 28s605ms 12s82ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 01 00 3 34s613ms 11s537ms 20 3 36s936ms 12s312ms 23 3 37s189ms 12s396ms [ User: intelifix - Total duration: 1m48s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 9 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-01 20:09:38 Duration: 28s605ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-01 23:17:21 Duration: 27s402ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-01 00:02:36 Duration: 25s744ms Database: rio 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,469 24m52s 150ms 7s850ms 1s16ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 01 08 137 2m27s 1s80ms 09 204 3m7s 916ms 10 172 3m5s 1s78ms 11 209 2m52s 825ms 12 47 30s692ms 653ms 13 95 1m14s 781ms 14 227 3m54s 1s34ms 15 163 2m23s 878ms 16 118 2m52s 1s459ms 17 97 2m24s 1s489ms [ User: intelifix - Total duration: 24m52s - Times executed: 1469 ]
[ Application: [unknown] - Total duration: 24m52s - Times executed: 1469 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55248, 413, '834121918001676,241598156279,241704326977,241622586587,241668293652,241646273052,241656301023,230049379106,241601082435,241695608191,241659800725,241617366571,241609830820,241622532340,241659712736,241598852644,241713349710,241649698908,241668029911,241637660618,241714026779,241622478697,230043576979,241689131926,241712511032,241700951531,241712553235,241659667478,241698672442,241727450728,241609857387,241676759102,241727495557,241659821131,241676341228,241654433242,241647389715,241732103942,241647389311,230043536470,241649249717', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 08:44:46 Duration: 7s850ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55203, 406, '226334320208', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 16:27:09 Duration: 7s841ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55249, 413, '246220233350', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 08:57:50 Duration: 7s301ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 929 10m6s 150ms 3s161ms 652ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 01 07 34 27s276ms 802ms 08 94 1m8s 733ms 09 104 1m6s 636ms 10 111 1m3s 569ms 11 150 1m36s 645ms 12 6 3s103ms 517ms 13 61 35s858ms 587ms 14 102 1m4s 630ms 15 106 1m19s 751ms 16 134 1m23s 621ms 17 27 17s319ms 641ms [ User: intelifix - Total duration: 10m6s - Times executed: 929 ]
[ Application: [unknown] - Total duration: 10m6s - Times executed: 929 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "283074", "modelo" : "137", "itens" : "229765309306,229643077275,229731773048,229825051624,229713855272,229829632531,229828039704,229713136279,229647055060,229679149618,229700710421,229645425361,229676041021,229730950914,229714218696,229708604647,229708526379,229715754548,216924075861,229707833349", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246559184757,246479263557,246565738001,246220730122,246532396890,246626649613,246633751025,246533451326,246453030728,246493727796,246521569212,246475786281,246443671621,246564983247,246528806472,246541112343,246539044161,246551987073,246440454954,246537582941,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-01 15:47:45 Duration: 3s161ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "283178", "modelo" : "454", "itens" : "241613823353,241625488700,241612211131,241627172445,241627224144,241614442841,241612164257,241625145153,241624634363,241624618199,241625091737,241640769292,241640673145,241613710312,241624603653,241611823337,241632391125,241632387891,241624640930,241627186385,241624228789,241634154046,241625425966,241640826167,241600573642,241632699819,241611667081,241625023346,241633522335,241623374655,241633708188,241632747982,241644757179,241624022833,241632975659,241627848807,241623888397,241611519413,241613581029,241624994757,241624605370,241625415561,241642225058,241640090305,241627247681,241641452222,241613378102,241625003546", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-01 11:12:14 Duration: 3s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "283074", "modelo" : "137", "itens" : "229697430415,229880891821,229641203737,229691858186,229828192020,229640467997,229775979113,229714281431,229714050522,229705442633,229778520708,216929741028,229695441130,229826709810,216924741213,229699134060,216929466174,229764619811,229715096369,229830435572", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246512928794,226232936878,246479170013,246493473855,246632472123,246448481215,246576824346,246525951234,246526049503,246557849509,246577840821,246445710507,246501366364,246624755567,246441124144,246522454360,246541763753,246561114968,246533856572,246633538096,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-01 15:29:54 Duration: 3s64ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 278 16m2s 171ms 23s206ms 3s461ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 01 00 14 2m4s 8s925ms 01 12 32s809ms 2s734ms 02 12 32s157ms 2s679ms 03 12 33s838ms 2s819ms 04 12 32s411ms 2s700ms 05 12 39s468ms 3s289ms 06 12 36s557ms 3s46ms 07 12 45s318ms 3s776ms 08 12 43s180ms 3s598ms 09 12 35s826ms 2s985ms 10 12 38s955ms 3s246ms 11 12 37s185ms 3s98ms 12 12 33s795ms 2s816ms 13 12 37s404ms 3s117ms 14 12 39s716ms 3s309ms 15 12 39s598ms 3s299ms 16 12 41s796ms 3s483ms 17 12 36s541ms 3s45ms 18 12 32s819ms 2s734ms 19 12 33s655ms 2s804ms 20 12 1m 5s14ms 21 12 35s782ms 2s981ms 22 12 38s380ms 3s198ms [ User: intelifix - Total duration: 16m2s - Times executed: 278 ]
[ Application: psql - Total duration: 16m2s - Times executed: 278 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:25:29 Duration: 23s206ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:15:33 Duration: 22s934ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:05:48 Duration: 22s782ms Database: rio User: intelifix Remote: [local] Application: psql
4 211 1h11m32s 151ms 10m37s 20s345ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 01 07 6 14m5s 2m20s 08 14 13m58s 59s881ms 09 26 50s614ms 1s946ms 10 49 7m34s 9s277ms 11 34 6m58s 12s298ms 12 2 1s434ms 717ms 13 30 39s821ms 1s327ms 14 18 4m37s 15s399ms 15 12 21m47s 1m48s 16 9 30s253ms 3s361ms 17 11 29s665ms 2s696ms [ User: intelifix - Total duration: 1h11m32s - Times executed: 211 ]
[ Application: [unknown] - Total duration: 1h11m32s - Times executed: 211 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-09-01 15:51:07 Duration: 10m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029286, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-01 07:23:52 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029300, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-01 10:30:17 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 180 37s630ms 150ms 824ms 209ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 01 01 3 1s570ms 523ms 05 9 3s61ms 340ms 06 2 372ms 186ms 07 15 2s956ms 197ms 08 30 5s902ms 196ms 09 34 6s570ms 193ms 10 13 2s322ms 178ms 11 17 3s152ms 185ms 12 2 357ms 178ms 13 7 1s383ms 197ms 14 24 4s916ms 204ms 15 12 2s342ms 195ms 16 6 1s178ms 196ms 17 4 834ms 208ms 20 1 517ms 517ms 21 1 192ms 192ms [ User: intelifix - Total duration: 37s630ms - Times executed: 180 ]
[ Application: [unknown] - Total duration: 37s630ms - Times executed: 180 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241606873045');
Date: 2026-09-01 01:47:42 Duration: 824ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241617109700');
Date: 2026-09-01 05:16:50 Duration: 695ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('216909642332');
Date: 2026-09-01 05:36:32 Duration: 563ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 166 11m1s 165ms 24s789ms 3s982ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 01 00 10 53s421ms 5s342ms 01 6 16s426ms 2s737ms 02 6 16s121ms 2s686ms 03 5 24s169ms 4s833ms 04 6 20s414ms 3s402ms 05 4 21s351ms 5s337ms 07 10 49s444ms 4s944ms 08 12 54s537ms 4s544ms 09 12 56s882ms 4s740ms 10 12 50s376ms 4s198ms 11 12 57s483ms 4s790ms 12 12 56s785ms 4s732ms 13 9 11s201ms 1s244ms 14 10 39s791ms 3s979ms 15 12 55s207ms 4s600ms 16 9 29s51ms 3s227ms 17 5 5s282ms 1s56ms 20 3 1s88ms 362ms 21 5 19s945ms 3s989ms 22 6 22s120ms 3s686ms [ User: intelifix - Total duration: 11m1s - Times executed: 166 ]
[ Application: psql - Total duration: 11m1s - Times executed: 166 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 00:05:25 Duration: 24s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 14:45:12 Duration: 11s840ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 07:55:13 Duration: 11s794ms Database: rio User: intelifix Remote: [local] Application: psql
7 134 40s377ms 151ms 827ms 301ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 01 01 15 3s976ms 265ms 04 5 1s530ms 306ms 05 23 7s392ms 321ms 07 9 3s2ms 333ms 08 16 4s879ms 304ms 09 7 2s176ms 310ms 10 14 4s852ms 346ms 11 17 5s157ms 303ms 12 8 2s289ms 286ms 14 5 1s724ms 344ms 15 9 2s113ms 234ms 16 6 1s282ms 213ms [ User: intelifix - Total duration: 40s377ms - Times executed: 134 ]
[ Application: [unknown] - Total duration: 40s377ms - Times executed: 134 ]
-
SELECT * FROM RS_TRIAGEM (1, 1, '113', 3, 'ZTEAH7VQ5H00403,ZTEKH7VP3A10224,ZTEAH7VPBU25437,ZTEAH7VQAQ27138,ZTEYH7VP7M11155,ZTEAH7VPBU27795,ZTEAH7VQAQ27040,ZTEKH7VP3A10222,ZTEAH7VQ5H02242,ZTEEH7VP2M04881,ZTEAH7VQ6H05505,ZTEAH7VQAQ26298,ZTEAH7VQ5H00726,ZTEAH7VQ1Y14893,ZTEAH7VQ2V03250,ZTEAH7VPBU12154,ZTEAH7VQAQ23708,ZTEKH7VP3Q02642,ZTEAH7VPBU29754,ZTEAH7VQ2F05548,ZTEAH7VQAQ31720,ZTEKH7VP3706196,ZTEKH7VP3703002,ZTEEH7VP3H09257,ZTEAH7VQA301649,ZTEAH7VQ5H06927,ZTEAH7VQ6H05494,ZTEAH7VQ1Y14994,ZTEKH7VP3A11254,ZTEAH7VQ8P20136,ZTEAH7VQAQ19141,ZTEAH7VQ5H02414,ZTEAH7VQ5A01014,ZTEKH7VP3708501,ZTEAH7VQ1Y27341,ZTEAH7VQAQ19426,ZTEAH7VQ3L04749,ZTEKH7VP3706147,ZTEAH7VQ2V03169,ZTEKH7VP3C13110', NULL, NULL, 0301, 00);
Date: 2026-09-01 10:31:04 Duration: 827ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '63', 2, '229711933951,229880889597,229708233141,229707086171,229833459212,229695415268,229701865471,229778023252,229642034963,229763967289,229709534749,229798436074', NULL, NULL, 0137, 00);
Date: 2026-09-01 07:47:25 Duration: 690ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229804600515,229795504161,229725101331,229858856269,229797653439,229804303841,229879175570,229771009604,229795693248', NULL, NULL, 0145, 00);
Date: 2026-09-01 11:40:17 Duration: 639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 106 1m23s 161ms 6s626ms 783ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 01 09 11 15s921ms 1s447ms 10 41 26s916ms 656ms 11 20 14s512ms 725ms 13 23 14s706ms 639ms 14 7 7s197ms 1s28ms 15 2 811ms 405ms 16 2 2s938ms 1s469ms [ User: intelifix - Total duration: 1m23s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 1m23s - Times executed: 106 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0279926) LIMIT 1;
Date: 2026-09-01 09:28:43 Duration: 6s626ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135349) LIMIT 1;
Date: 2026-09-01 10:45:24 Duration: 3s536ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0282810) LIMIT 1;
Date: 2026-09-01 14:06:46 Duration: 2s676ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 103 45s288ms 266ms 681ms 439ms 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 01 01 3 1s391ms 463ms 04 2 767ms 383ms 05 3 1s186ms 395ms 06 2 754ms 377ms 07 8 3s533ms 441ms 08 12 5s488ms 457ms 09 10 4s491ms 449ms 10 9 3s614ms 401ms 11 7 3s158ms 451ms 12 3 1s165ms 388ms 13 11 4s591ms 417ms 14 9 4s244ms 471ms 15 8 3s667ms 458ms 16 7 2s931ms 418ms 17 7 3s381ms 483ms 20 1 445ms 445ms 21 1 474ms 474ms [ User: lenon - Total duration: 45s288ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 45s288ms - Times executed: 103 ]
-
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-01 09:13:51 Duration: 681ms 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-01 17:09:29 Duration: 680ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-01 11:07:30 Duration: 666ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 98 20s187ms 150ms 2s929ms 205ms create table temp0000290254 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 01 09 4 3s507ms 876ms 10 9 1s755ms 195ms 11 4 768ms 192ms 12 5 796ms 159ms 13 7 1s144ms 163ms 14 27 4s657ms 172ms 15 28 5s80ms 181ms 16 14 2s476ms 176ms [ User: intelifix - Total duration: 20s187ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 20s187ms - Times executed: 98 ]
-
CREATE TABLE temp0000290254 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-08-2026", "ate" :"01-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-01 09:11:29 Duration: 2s929ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290254 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-08-2026", "ate" :"01-09-2026", "nota-fiscal":"1065396", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-01 11:07:11 Duration: 241ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290254 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"27-08-2026", "ate" :"01-09-2026", "nota-fiscal":"422", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-01 14:42:47 Duration: 230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 96 17s261ms 150ms 456ms 179ms create table temp0000290158 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 01 13 80 14s103ms 176ms 16 16 3s158ms 197ms [ User: intelifix - Total duration: 17s261ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 17s261ms - Times executed: 96 ]
-
CREATE TABLE temp0000290158 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, 'D4925EF8E3CE', '2026-08-30', '2026-09-01');
Date: 2026-09-01 16:45:19 Duration: 456ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290158 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, 'B85E71D2D7F0', '2026-08-30', '2026-09-01');
Date: 2026-09-01 13:20:37 Duration: 349ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290158 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0310, 00, 'C4509CF2228C', '2026-08-30', '2026-09-01');
Date: 2026-09-01 13:17:46 Duration: 313ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 94 51s349ms 356ms 972ms 546ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 01 01 3 2s122ms 707ms 04 2 958ms 479ms 05 3 1s490ms 496ms 06 1 522ms 522ms 07 6 3s255ms 542ms 08 11 6s67ms 551ms 09 10 5s502ms 550ms 10 9 4s494ms 499ms 11 7 3s905ms 557ms 12 2 1s51ms 525ms 13 10 5s142ms 514ms 14 9 5s141ms 571ms 15 8 4s383ms 547ms 16 7 3s750ms 535ms 17 6 3s563ms 593ms [ User: intelifix - Total duration: 51s349ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 51s349ms - Times executed: 94 ]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-09-01 01:31:30 Duration: 972ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-09-01 17:33:13 Duration: 840ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (404, 21, 1);
Date: 2026-09-01 09:13:51 Duration: 751ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 83 18s995ms 153ms 760ms 228ms create table temp0000290284 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 01 13 15 3s40ms 202ms 14 29 6s543ms 225ms 15 4 798ms 199ms 16 35 8s612ms 246ms [ User: intelifix - Total duration: 18s995ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 18s995ms - Times executed: 83 ]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '48575443779416B8', '2026-08-30', '2026-09-01');
Date: 2026-09-01 16:38:37 Duration: 760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '216506192935', '2026-08-30', '2026-09-01');
Date: 2026-09-01 16:25:11 Duration: 654ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '2035435676CE', '2026-08-30', '2026-09-01');
Date: 2026-09-01 14:21:11 Duration: 474ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 81 4m29s 967ms 8s75ms 3s332ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 01 07 4 7s519ms 1s879ms 08 3 5s112ms 1s704ms 09 4 11s195ms 2s798ms 10 6 20s496ms 3s416ms 11 18 51s845ms 2s880ms 12 1 1s793ms 1s793ms 13 7 28s312ms 4s44ms 14 5 20s972ms 4s194ms 15 7 24s749ms 3s535ms 16 13 54s545ms 4s195ms 17 13 43s411ms 3s339ms [ User: intelifix - Total duration: 4m29s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 4m29s - Times executed: 81 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 15:15:37 Duration: 8s75ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 15:40:40 Duration: 7s116ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 16:46:10 Duration: 6s536ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 74 16s217ms 151ms 757ms 219ms create table temp0000239342 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 01 13 8 2s117ms 264ms 14 5 1s154ms 230ms 15 9 2s30ms 225ms 16 16 3s135ms 195ms 17 36 7s779ms 216ms [ User: intelifix - Total duration: 16s217ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 16s217ms - Times executed: 74 ]
-
CREATE TABLE temp0000239342 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "27-08-2026", "data-ate" : "01-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-01 13:29:50 Duration: 757ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000239342 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "01-09-2026", "data-ate" : "01-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-01 17:21:14 Duration: 352ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000239342 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "01-09-2026", "data-ate" : "01-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-01 15:12:28 Duration: 318ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 67 27s923ms 181ms 1s339ms 416ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 01 07 2 746ms 373ms 08 8 3s153ms 394ms 09 10 4s497ms 449ms 10 6 2s542ms 423ms 11 6 3s1ms 500ms 12 2 648ms 324ms 13 10 3s800ms 380ms 14 5 2s187ms 437ms 15 9 3s764ms 418ms 16 2 920ms 460ms 17 7 2s659ms 379ms [ User: intelifix - Total duration: 27s923ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 27s923ms - Times executed: 67 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-01 11:18:14 Duration: 1s339ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-09-01 17:04:34 Duration: 618ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-01 14:30:49 Duration: 612ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
17 51 1m37s 588ms 21s100ms 1s903ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 01 08 3 2s655ms 885ms 09 5 13s598ms 2s719ms 10 3 2s558ms 852ms 11 4 12s925ms 3s231ms 12 3 2s553ms 851ms 13 3 2s808ms 936ms 14 3 2s775ms 925ms 15 3 2s271ms 757ms 16 3 2s597ms 865ms 17 3 22s718ms 7s572ms 18 3 2s605ms 868ms 19 3 2s783ms 927ms 20 5 17s904ms 3s580ms 21 4 3s753ms 938ms 22 3 2s547ms 849ms [ User: intelifix - Total duration: 1m37s - Times executed: 51 ]
[ Application: psql - Total duration: 1m37s - Times executed: 51 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-01 17:40:23 Duration: 21s100ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-01 20:00:14 Duration: 13s59ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-01 11:40:10 Duration: 9s43ms Database: rio User: intelifix Remote: [local] Application: psql
18 48 1h56m38s 1s428ms 13m4s 2m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 01 07 3 14m10s 4m43s 08 3 6m44s 2m14s 09 3 7m18s 2m26s 10 3 7m44s 2m34s 11 3 8m23s 2m47s 12 3 6m35s 2m11s 13 3 6m19s 2m6s 14 3 7m6s 2m22s 15 3 7m9s 2m23s 16 3 6m51s 2m17s 17 3 6m44s 2m14s 18 3 6m11s 2m3s 19 3 5m55s 1m58s 20 3 7m10s 2m23s 21 3 6m25s 2m8s 22 3 5m48s 1m56s [ User: intelifix - Total duration: 1h56m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 07:18:05 Duration: 13m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 11:12:48 Duration: 7m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 10:12:22 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: psql
19 48 1h8m11s 262ms 4m59s 1m25s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 01 07 3 7m6s 2m22s 08 3 4m9s 1m23s 09 3 4m30s 1m30s 10 3 4m9s 1m23s 11 3 5m9s 1m43s 12 3 3m49s 1m16s 13 3 3m53s 1m17s 14 3 4m5s 1m21s 15 3 4m 1m20s 16 3 4m11s 1m23s 17 3 4m11s 1m23s 18 3 3m44s 1m14s 19 3 3m31s 1m10s 20 3 4m7s 1m22s 21 3 3m38s 1m12s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h8m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 07:26:05 Duration: 4m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 11:18:24 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 09:16:42 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
20 46 12s647ms 150ms 761ms 274ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 01 07 1 455ms 455ms 11 3 629ms 209ms 14 15 3s507ms 233ms 15 1 193ms 193ms 16 23 7s322ms 318ms 17 3 538ms 179ms [ User: intelifix - Total duration: 12s647ms - Times executed: 46 ]
[ Application: [unknown] - Total duration: 12s647ms - Times executed: 46 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3574755 ORDER BY A.CAI_ORDEM;
Date: 2026-09-01 14:39:20 Duration: 761ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3576769 ORDER BY A.CAI_ORDEM;
Date: 2026-09-01 16:27:14 Duration: 573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3576782 ORDER BY A.CAI_ORDEM;
Date: 2026-09-01 16:36:58 Duration: 515ms 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 2m55s 10m25s 6m45s 3 20m15s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 01 05 3 20m15s 6m45s [ User: intelifix - Total duration: 20m15s - Times executed: 3 ]
[ Application: psql - Total duration: 20m15s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-01 05:10:27 Duration: 10m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-01 05:17:21 Duration: 6m54s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-01 05:20:17 Duration: 2m55s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s428ms 13m4s 2m25s 48 1h56m38s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 01 07 3 14m10s 4m43s 08 3 6m44s 2m14s 09 3 7m18s 2m26s 10 3 7m44s 2m34s 11 3 8m23s 2m47s 12 3 6m35s 2m11s 13 3 6m19s 2m6s 14 3 7m6s 2m22s 15 3 7m9s 2m23s 16 3 6m51s 2m17s 17 3 6m44s 2m14s 18 3 6m11s 2m3s 19 3 5m55s 1m58s 20 3 7m10s 2m23s 21 3 6m25s 2m8s 22 3 5m48s 1m56s [ User: intelifix - Total duration: 1h56m38s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m38s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 07:18:05 Duration: 13m4s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 11:12:48 Duration: 7m46s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-01 10:12:22 Duration: 7m20s Database: rio User: intelifix Remote: [local] Application: psql
3 262ms 4m59s 1m25s 48 1h8m11s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 01 07 3 7m6s 2m22s 08 3 4m9s 1m23s 09 3 4m30s 1m30s 10 3 4m9s 1m23s 11 3 5m9s 1m43s 12 3 3m49s 1m16s 13 3 3m53s 1m17s 14 3 4m5s 1m21s 15 3 4m 1m20s 16 3 4m11s 1m23s 17 3 4m11s 1m23s 18 3 3m44s 1m14s 19 3 3m31s 1m10s 20 3 4m7s 1m22s 21 3 3m38s 1m12s 22 3 3m51s 1m17s [ User: intelifix - Total duration: 1h8m11s - Times executed: 48 ]
[ Application: psql - Total duration: 1h8m11s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 07:26:05 Duration: 4m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 11:18:24 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-01 09:16:42 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
4 6s393ms 1m30s 48s101ms 6 4m48s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 01 00 2 1m36s 48s459ms 20 2 1m34s 47s455ms 23 2 1m36s 48s389ms [ User: intelifix - Total duration: 4m48s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 4m48s - Times executed: 6 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-01 00:02:10 Duration: 1m30s 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-01 23:16:53 Duration: 1m30s 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-01 20:09:09 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump
5 472ms 57s738ms 23s346ms 5 1m56s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 01 00 1 472ms 472ms 20 2 58s311ms 29s155ms 23 2 57s946ms 28s973ms [ User: intelifix - Total duration: 1m56s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-01 20:05:50 Duration: 57s738ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-01 23:13:31 Duration: 57s339ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-01 23:37:39 Duration: 606ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 151ms 10m37s 20s345ms 211 1h11m32s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 01 07 6 14m5s 2m20s 08 14 13m58s 59s881ms 09 26 50s614ms 1s946ms 10 49 7m34s 9s277ms 11 34 6m58s 12s298ms 12 2 1s434ms 717ms 13 30 39s821ms 1s327ms 14 18 4m37s 15s399ms 15 12 21m47s 1m48s 16 9 30s253ms 3s361ms 17 11 29s665ms 2s696ms [ User: intelifix - Total duration: 1h11m32s - Times executed: 211 ]
[ Application: [unknown] - Total duration: 1h11m32s - Times executed: 211 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-09-01 15:51:07 Duration: 10m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029286, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-01 07:23:52 Duration: 8m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029300, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-01 10:30:17 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s251ms 1m10s 14s718ms 20 4m54s create table temp0000290204 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 01 07 12 3m20s 16s713ms 08 8 1m33s 11s724ms [ User: intelifix - Total duration: 4m54s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m54s - Times executed: 20 ]
-
CREATE TABLE temp0000290204 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 07:12:52 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290204 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 07:34:42 Duration: 14s880ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290204 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 08:25:46 Duration: 13s920ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s248ms 37s636ms 14s71ms 21 4m55s create table temp0000290228 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 01 08 3 41s251ms 13s750ms 09 5 1m1s 12s394ms 10 2 22s901ms 11s450ms 11 5 1m31s 18s313ms 13 4 51s219ms 12s804ms 14 2 26s600ms 13s300ms [ User: intelifix - Total duration: 4m55s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m55s - Times executed: 21 ]
-
CREATE TABLE temp0000290228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 11:18:44 Duration: 37s636ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 14:47:41 Duration: 15s237ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290228 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 08:31:53 Duration: 14s714ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11s655ms 14s945ms 12s834ms 13 2m46s create table temp0000290264 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 01 10 6 1m19s 13s177ms 11 7 1m27s 12s539ms [ User: intelifix - Total duration: 2m46s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 13 ]
-
CREATE TABLE temp0000290264 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 10:21:24 Duration: 14s945ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290264 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 10:21:44 Duration: 13s576ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290264 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 11:41:14 Duration: 13s492ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 11s646ms 13s856ms 12s518ms 9 1m52s create table temp0000290322 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 01 15 6 1m16s 12s719ms 16 3 36s352ms 12s117ms [ User: intelifix - Total duration: 1m52s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m52s - Times executed: 9 ]
-
CREATE TABLE temp0000290322 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 15:37:38 Duration: 13s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290322 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 15:36:05 Duration: 13s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290322 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 15:36:43 Duration: 12s691ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 2s742ms 28s605ms 12s82ms 9 1m48s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 01 00 3 34s613ms 11s537ms 20 3 36s936ms 12s312ms 23 3 37s189ms 12s396ms [ User: intelifix - Total duration: 1m48s - Times executed: 9 ]
[ Application: pg_dump - Total duration: 1m48s - Times executed: 9 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-01 20:09:38 Duration: 28s605ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-01 23:17:21 Duration: 27s402ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-09-01 00:02:36 Duration: 25s744ms Database: rio User: intelifix Remote: [local] Application: pg_dump
12 10s722ms 14s872ms 11s800ms 11 2m9s create table temp0000290284 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 01 13 11 2m9s 11s800ms [ User: intelifix - Total duration: 2m9s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 11 ]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 13:23:28 Duration: 14s872ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 13:33:53 Duration: 12s423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290284 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-01 13:23:51 Duration: 12s68ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 367ms 44s156ms 4s982ms 33 2m44s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 01 07 2 47s867ms 23s933ms 08 4 11s472ms 2s868ms 09 5 13s557ms 2s711ms 10 3 17s770ms 5s923ms 11 6 24s965ms 4s160ms 13 6 38s22ms 6s337ms 15 5 7s762ms 1s552ms 17 2 3s18ms 1s509ms [ User: intelifix - Total duration: 2m44s - Times executed: 33 ]
[ Application: psql - Total duration: 2m44s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029286);
Date: 2026-09-01 07:15:40 Duration: 44s156ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029309);
Date: 2026-09-01 13:24:19 Duration: 18s96ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029312);
Date: 2026-09-01 13:37:29 Duration: 14s635ms Database: rio User: intelifix Remote: [local] Application: psql
14 215ms 49s228ms 4s591ms 35 2m40s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 01 07 4 3s395ms 848ms 08 5 7s325ms 1s465ms 09 5 20s997ms 4s199ms 10 3 22s28ms 7s342ms 11 6 25s196ms 4s199ms 13 8 1m8s 8s527ms 14 1 11s71ms 11s71ms 15 2 1s763ms 881ms 16 1 700ms 700ms [ User: intelifix - Total duration: 2m40s - Times executed: 35 ]
[ Application: psql - Total duration: 2m40s - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029312);
Date: 2026-09-01 13:37:14 Duration: 49s228ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029301);
Date: 2026-09-01 10:45:52 Duration: 20s806ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029316);
Date: 2026-09-01 13:46:03 Duration: 17s408ms Database: rio User: intelifix Remote: [local] Application: psql
15 165ms 24s789ms 3s982ms 166 11m1s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 01 00 10 53s421ms 5s342ms 01 6 16s426ms 2s737ms 02 6 16s121ms 2s686ms 03 5 24s169ms 4s833ms 04 6 20s414ms 3s402ms 05 4 21s351ms 5s337ms 07 10 49s444ms 4s944ms 08 12 54s537ms 4s544ms 09 12 56s882ms 4s740ms 10 12 50s376ms 4s198ms 11 12 57s483ms 4s790ms 12 12 56s785ms 4s732ms 13 9 11s201ms 1s244ms 14 10 39s791ms 3s979ms 15 12 55s207ms 4s600ms 16 9 29s51ms 3s227ms 17 5 5s282ms 1s56ms 20 3 1s88ms 362ms 21 5 19s945ms 3s989ms 22 6 22s120ms 3s686ms [ User: intelifix - Total duration: 11m1s - Times executed: 166 ]
[ Application: psql - Total duration: 11m1s - Times executed: 166 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 00:05:25 Duration: 24s789ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 14:45:12 Duration: 11s840ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-01 07:55:13 Duration: 11s794ms Database: rio User: intelifix Remote: [local] Application: psql
16 659ms 10s461ms 3s632ms 38 2m18s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 01 08 3 12s727ms 4s242ms 09 1 6s142ms 6s142ms 10 3 21s555ms 7s185ms 11 2 11s333ms 5s666ms 12 3 7s304ms 2s434ms 13 3 7s210ms 2s403ms 14 3 11s103ms 3s701ms 15 3 17s220ms 5s740ms 16 3 19s95ms 6s365ms 17 2 10s376ms 5s188ms 18 3 3s479ms 1s159ms 19 3 3s104ms 1s34ms 20 1 1s339ms 1s339ms 21 2 3s160ms 1s580ms 22 3 2s881ms 960ms [ User: intelifix - Total duration: 2m18s - Times executed: 38 ]
[ Application: psql - Total duration: 2m18s - Times executed: 38 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-01 11:20:12 Duration: 10s461ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-01 10:40:11 Duration: 10s148ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-01 16:00:11 Duration: 9s875ms Database: rio User: intelifix Remote: [local] Application: psql
17 171ms 23s206ms 3s461ms 278 16m2s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 01 00 14 2m4s 8s925ms 01 12 32s809ms 2s734ms 02 12 32s157ms 2s679ms 03 12 33s838ms 2s819ms 04 12 32s411ms 2s700ms 05 12 39s468ms 3s289ms 06 12 36s557ms 3s46ms 07 12 45s318ms 3s776ms 08 12 43s180ms 3s598ms 09 12 35s826ms 2s985ms 10 12 38s955ms 3s246ms 11 12 37s185ms 3s98ms 12 12 33s795ms 2s816ms 13 12 37s404ms 3s117ms 14 12 39s716ms 3s309ms 15 12 39s598ms 3s299ms 16 12 41s796ms 3s483ms 17 12 36s541ms 3s45ms 18 12 32s819ms 2s734ms 19 12 33s655ms 2s804ms 20 12 1m 5s14ms 21 12 35s782ms 2s981ms 22 12 38s380ms 3s198ms [ User: intelifix - Total duration: 16m2s - Times executed: 278 ]
[ Application: psql - Total duration: 16m2s - Times executed: 278 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:25:29 Duration: 23s206ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:15:33 Duration: 22s934ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-01 00:05:48 Duration: 22s782ms Database: rio User: intelifix Remote: [local] Application: psql
18 967ms 8s75ms 3s332ms 81 4m29s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 01 07 4 7s519ms 1s879ms 08 3 5s112ms 1s704ms 09 4 11s195ms 2s798ms 10 6 20s496ms 3s416ms 11 18 51s845ms 2s880ms 12 1 1s793ms 1s793ms 13 7 28s312ms 4s44ms 14 5 20s972ms 4s194ms 15 7 24s749ms 3s535ms 16 13 54s545ms 4s195ms 17 13 43s411ms 3s339ms [ User: intelifix - Total duration: 4m29s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 4m29s - Times executed: 81 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 15:15:37 Duration: 8s75ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 15:40:40 Duration: 7s116ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-01', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-01 16:46:10 Duration: 6s536ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 588ms 21s100ms 1s903ms 51 1m37s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 01 08 3 2s655ms 885ms 09 5 13s598ms 2s719ms 10 3 2s558ms 852ms 11 4 12s925ms 3s231ms 12 3 2s553ms 851ms 13 3 2s808ms 936ms 14 3 2s775ms 925ms 15 3 2s271ms 757ms 16 3 2s597ms 865ms 17 3 22s718ms 7s572ms 18 3 2s605ms 868ms 19 3 2s783ms 927ms 20 5 17s904ms 3s580ms 21 4 3s753ms 938ms 22 3 2s547ms 849ms [ User: intelifix - Total duration: 1m37s - Times executed: 51 ]
[ Application: psql - Total duration: 1m37s - Times executed: 51 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-01 17:40:23 Duration: 21s100ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-01 20:00:14 Duration: 13s59ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-01 11:40:10 Duration: 9s43ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 7s850ms 1s16ms 1,469 24m52s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 01 08 137 2m27s 1s80ms 09 204 3m7s 916ms 10 172 3m5s 1s78ms 11 209 2m52s 825ms 12 47 30s692ms 653ms 13 95 1m14s 781ms 14 227 3m54s 1s34ms 15 163 2m23s 878ms 16 118 2m52s 1s459ms 17 97 2m24s 1s489ms [ User: intelifix - Total duration: 24m52s - Times executed: 1469 ]
[ Application: [unknown] - Total duration: 24m52s - Times executed: 1469 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55248, 413, '834121918001676,241598156279,241704326977,241622586587,241668293652,241646273052,241656301023,230049379106,241601082435,241695608191,241659800725,241617366571,241609830820,241622532340,241659712736,241598852644,241713349710,241649698908,241668029911,241637660618,241714026779,241622478697,230043576979,241689131926,241712511032,241700951531,241712553235,241659667478,241698672442,241727450728,241609857387,241676759102,241727495557,241659821131,241676341228,241654433242,241647389715,241732103942,241647389311,230043536470,241649249717', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 08:44:46 Duration: 7s850ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55203, 406, '226334320208', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 16:27:09 Duration: 7s841ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55249, 413, '246220233350', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-01 08:57:50 Duration: 7s301ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 168ms 1 168ms 168ms 168ms SELECT * FROM RS_ETIQUETA ('');Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 01 23 1 168ms 168ms [ User: etiquetas - Total duration: 2s438ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2s438ms - Times executed: 1 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-01 23:36:57 Duration: 168ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 01 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 1s317ms - Times executed: 3 ]
[ Application: psql - Total duration: 1s317ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,240 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 29 FATAL entries
- 4014 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,858 Max number of times the same event was reported
- 4,045 Total events found
Rank Times reported Error 1 3,858 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 01 00 60 01 59 02 59 03 55 04 59 05 59 06 59 07 152 08 312 09 339 10 369 11 404 12 162 13 254 14 382 15 298 16 231 17 201 18 59 19 59 20 58 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN00000000354FA260" does not exist
- ERROR: prepared statement "_PLAN00000000354FE240" does not exist
- ERROR: prepared statement "_PLAN00000000354FE240" does not exist
Statement: DEALLOCATE "_PLAN00000000354FA260"
Date: 2026-09-01 00:00:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000354FE240"
Date: 2026-09-01 00:01:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000354FE240"
Date: 2026-09-01 00:02:04 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 129 ERROR: out of shared memory
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 01 10 129 - ERROR: out of shared memory at character 30
- ERROR: out of shared memory at character 61
- ERROR: out of shared memory at character 35 2026-09-01 10:49:53 -03 [2444343]: [91-1] user=intelifix,db=rio,app=[unknown],client=[local] QUERY: SELECT PAR_VALOR FROM PARAMETROS WHERE PAR_NOME = cParam
Hint: You might need to increase "max_locks_per_transaction".
Statement: select oid, typbasetype from pg_type where typname = 'lo'Date: 2026-09-01 10:49:53 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = current_database();Date: 2026-09-01 10:49:53 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_parametro(character varying) line 20 at SQL statement
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT RS_PARAMETRO AS VALOR FROM RS_PARAMETRO('RECEPCAO_LOTES_LINHAS_POR_TELA')Date: 2026-09-01 10:49:53 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 18 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 01 00 1 04 2 06 1 08 1 12 2 13 2 15 6 22 1 23 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-01 00:02:40 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-01 04:23:03 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-01 04:23:18 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 01 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-01 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-01 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-01 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 8 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 01 11 4 15 1 16 3 - ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near "721294008052" at character 33
- ERROR: syntax error at or near "721294008052" at character 81
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"56218","seriais":[{"serial":"' "},{"serial":""}]}')
Date: 2026-09-01 11:17:03 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( '' 721294008052' ) OR RS_SERIAL_TEMPORARIO_VIVO( '' 721294008052' )
Date: 2026-09-01 11:17:14 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"56218","seriais":[{"serial":"' 721294008052"},{"serial":"6802B8E024DE"}]}')
Date: 2026-09-01 11:17:16 Database: contagem Application: [unknown] User: intelifix Remote: [local]
6 5 ERROR: spiexceptions.OutOfMemory: out of shared memory
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 01 10 5 - ERROR: spiexceptions.OutOfMemory: out of shared memory
- ERROR: spiexceptions.OutOfMemory: out of shared memory
- ERROR: spiexceptions.OutOfMemory: out of shared memory
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,420,''/var/www/html/uploads/NF 582 -579-602-612-235-85-83- Query 29.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-09-01 10:49:56 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,420,''/var/www/html/uploads/NF 582 -579-602-612-235-85-83- Query 29.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-09-01 10:52:28 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,420,''/var/www/html/uploads/NF 582 -579-602-612-235-85-83- Query 29.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-09-01 10:53:42 Database: contagem Application: [unknown] User: intelifix Remote: [local]
7 5 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 01 17 5 - ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 172 ));Date: 2026-09-01 17:25:37 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 172 ));Date: 2026-09-01 17:25:40 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 172 ));Date: 2026-09-01 17:25:41 Database: contagem Application: [unknown] User: intelifix Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 01 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-01 05:32:16 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-01 05:32:16 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-01 05:32:16 Database: contagem Application: psql User: intelifix Remote: [local]
9 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 01 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-01 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-01 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-01 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 01 10 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(v)
Date: 2026-09-01 10:36:44 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-09-01 10:36:44 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
11 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 01 14 2 - ERROR: trailing junk after numeric literal at or near "58238C61578B" at character 27
- ERROR: trailing junk after numeric literal at or near "58238C61578B" at character 27
Statement: select * from rs_caixa_qr(58238C61578B)
Date: 2026-09-01 14:36:48 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(58238C61578B)
Date: 2026-09-01 14:36:48 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 01 03 1 - LOG: database system was shut down at 2026-09-01 03:05:01 -03
Date: 2026-09-01 03:05:02
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 01 00 1 - LOG: process 1704529 still waiting for AccessExclusiveLock on relation 362311 of database 358220 after 1000.112 ms
Detail: Process holding the lock: 1726730. Wait queue: 1704529.
Context: SQL statement "DROP TABLE IF EXISTS auditor.AUDITOR_2026_05" PL/pgSQL function rs_auditor_novas_tabelas(date) line 75 at EXECUTE
Statement: SELECT * FROM RS_AUDITOR_NOVAS_TABELAS()Date: 2026-09-01 00:02:05 Database: rio Application: psql User: lenon Remote: [local]
14 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 01 17 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(55203,406,'246279356280$246212779401$246273947783$226302023655$246195641130$226268833749$246147750317$226292082034$246112332943$226020398694$246194603340$246188945167$246264129104$246264114961$246053754667$226031364748$246215542432$246018733045$226289208587$246324170621$226087826779$246336042733$226018993743$226061076166$226274078693$246309618088$246277202636$226142227273$246021274561$246297691123$226337202240$246156164347$246154742121$246154742020$246156165862$226185743642$226317717778$226077946477$226292300417$246097216181$226005921323$226296679003$246242596890$246081537591$246164771125$246206446179$246321237494$246342865374$226150940325$226207896376','',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0226005921323);Date: 2026-09-01 17:26:54 Database: contagem Application: [unknown] User: intelifix Remote: [local]