pgBadger-
Global information
- Generated on Wed Sep 16 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 45,697 log entries in 14s
- Log start from 2026-09-16 00:00:45 to 2026-09-16 23:49:16
-
Overview
Global Stats
- 364 Number of unique normalized queries
- 5,053 Number of queries
- 6h53m27s Total query duration
- 2026-09-16 00:02:19 First query
- 2026-09-16 23:42:57 Last query
- 4 queries/s at 2026-09-16 23:42:38 Query peak
- 6h53m27s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h53m27s Execute total duration
- 5,630 Number of events
- 14 Number of unique normalized events
- 5,564 Max number of times the same event was reported
- 0 Number of cancellation
- 436 Total number of automatic vacuums
- 990 Total number of automatic analyzes
- 20 Number temporary file
- 245.97 MiB Max size of temporary file
- 66.94 MiB Average size of temporary file
- 456 Total number of sessions
- 8 sessions at 2026-09-16 22:05:03 Session peak
- 13d18h51m19s Total duration of sessions
- 43m32s Average duration of sessions
- 11 Average queries per session
- 54s402ms Average queries duration per session
- 42m37s Average idle time per session
- 466 Total number of connections
- 7 connections/s at 2026-09-16 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-16 23:42:38 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-16 15:07:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-16 23:42:38 Date
Queries duration
Key values
- 6h53m27s 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 16 00 25 0ms 38s65ms 5s670ms 4s446ms 10s605ms 1m26s 01 15 0ms 6s476ms 2s440ms 4s100ms 6s819ms 8s190ms 02 17 0ms 7s356ms 2s259ms 2s485ms 8s48ms 9s292ms 03 17 0ms 9s635ms 2s405ms 3s390ms 7s65ms 11s635ms 04 25 0ms 18s764ms 2s728ms 5s772ms 8s44ms 24s873ms 05 18 0ms 11m26s 1m22s 12s270ms 3m7s 11m26s 06 18 0ms 14s98ms 2s969ms 1s889ms 2s366ms 24s739ms 07 166 0ms 9m11s 12s862ms 1m34s 5m21s 9m11s 08 443 150ms 5m11s 3s418ms 41s753ms 1m15s 6m11s 09 519 0ms 7m30s 3s845ms 48s381ms 3m42s 7m36s 10 537 150ms 6m6s 4s740ms 1m25s 5m55s 7m4s 11 456 150ms 5m22s 2s794ms 33s721ms 1m3s 6m2s 12 130 0ms 5m50s 5s873ms 10s880ms 52s529ms 5m52s 13 308 0ms 4m58s 4s349ms 55s542ms 3m40s 4m58s 14 501 150ms 6m1s 3s888ms 52s596ms 4m1s 6m6s 15 498 150ms 5m46s 3s22ms 35s703ms 3m57s 5m48s 16 532 150ms 5m20s 2s5ms 24s150ms 32s141ms 6m7s 17 209 0ms 5m12s 6s67ms 54s22ms 3m41s 6m4s 18 77 0ms 5m5s 8s872ms 6s184ms 25s200ms 6m25s 19 24 0ms 4m47s 23s130ms 1s762ms 43s52ms 4m47s 20 119 0ms 5m47s 10s52ms 1m6s 1m15s 6m48s 21 28 0ms 5m19s 21s523ms 6s350ms 14s340ms 5m47s 22 28 0ms 4m50s 20s932ms 7s450ms 43s193ms 4m50s 23 343 0ms 1m3s 5s730ms 1m5s 1m8s 1m15s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 16 00 3 0 7s 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 261ms 0ms 0ms 0ms 04 6 0 410ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 6s94ms 0ms 0ms 0ms 07 88 0 19s737ms 3s148ms 41s405ms 6m24s 08 327 0 3s161ms 13s901ms 23s495ms 3m43s 09 414 0 3s808ms 11s778ms 44s46ms 6m31s 10 440 0 5s101ms 23s718ms 1m25s 6m7s 11 386 0 2s893ms 18s990ms 24s794ms 3m57s 12 95 0 7s334ms 2s902ms 5s141ms 3m37s 13 208 0 5s370ms 5s221ms 41s746ms 4m25s 14 399 0 3s962ms 10s362ms 34s563ms 5m28s 15 401 0 3s109ms 7s951ms 19s229ms 5m44s 16 400 0 2s427ms 10s536ms 23s571ms 3m47s 17 158 0 6s857ms 6s252ms 34s209ms 3m39s 18 41 0 15s856ms 0ms 6s168ms 3m34s 19 10 0 53s928ms 0ms 0ms 3m26s 20 15 86 11s495ms 42s739ms 1m1s 3m30s 21 8 0 1m10s 0ms 0ms 3m21s 22 6 0 1m30s 0ms 0ms 3m27s 23 22 321 5s730ms 1m3s 1m5s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 16 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 16 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 8 8.00 0.00% 08 0 11 11.00 0.00% 09 0 12 12.00 0.00% 10 0 15 15.00 0.00% 11 0 12 12.00 0.00% 12 0 6 6.00 0.00% 13 0 11 11.00 0.00% 14 0 10 10.00 0.00% 15 0 11 11.00 0.00% 16 0 8 8.00 0.00% 17 0 6 6.00 0.00% 18 0 2 2.00 0.00% 19 0 1 1.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Sep 16 00 30 0.01/s 01 23 0.01/s 02 19 0.01/s 03 33 0.01/s 04 22 0.01/s 05 19 0.01/s 06 26 0.01/s 07 28 0.01/s 08 19 0.01/s 09 23 0.01/s 10 24 0.01/s 11 20 0.01/s 12 12 0.00/s 13 20 0.01/s 14 22 0.01/s 15 24 0.01/s 16 21 0.01/s 17 18 0.01/s 18 10 0.00/s 19 11 0.00/s 20 12 0.00/s 21 10 0.00/s 22 10 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Sep 16 00 18 16m46s 16m38s 01 29 31m41s 31m40s 02 19 28m14s 28m12s 03 31 15m57s 15m56s 04 20 27m52s 27m48s 05 18 32m57s 31m35s 06 20 37m11s 37m8s 07 28 32m48s 31m32s 08 15 56m49s 55m8s 09 22 54m51s 53m20s 10 23 55m22s 53m31s 11 23 52m49s 51m53s 12 18 58m52s 58m9s 13 15 50m20s 48m51s 14 18 57m53s 56m5s 15 25 50m15s 49m15s 16 22 51m21s 50m33s 17 18 58m4s 56m53s 18 16 1h10s 59m27s 19 10 1h25s 59m30s 20 14 48m25s 47m 21 9 1h36s 59m29s 22 10 57m59s 57m1s 23 15 38m35s 36m24s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-09-16 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 466 connections Total
Connections per user
Key values
- etiquetas Main User
- 466 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-16 22:05:03 Date
Histogram of session times
Key values
- 295 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 456 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 456 sessions Total
Sessions per host
Key values
- [local] Main Host
- 456 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 45,706 buffers Checkpoint Peak
- 2026-09-16 00:09:46 Date
- 270.043 seconds Highest write time
- 0.207 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-09-16 08:39:34 Date
Checkpoints distance
Key values
- 371.14 Mo Distance Peak
- 2026-09-16 08:39:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 16 00 59,508 683.495s 0.081s 683.605s 01 2,416 242.115s 0.095s 242.354s 02 2,470 247.469s 0.031s 247.527s 03 2,350 234.484s 0.157s 234.68s 04 2,484 248.856s 0.157s 249.037s 05 11,239 1,124.221s 0.093s 1,124.352s 06 5,220 269.814s 0.002s 269.82s 07 28,228 1,964.212s 0.195s 1,964.458s 08 49,612 3,012.225s 0.329s 3,012.695s 09 58,282 3,238.991s 0.522s 3,239.669s 10 66,761 3,239.007s 0.605s 3,239.701s 11 54,114 3,239.294s 0.3s 3,239.692s 12 22,854 2,001.428s 0.149s 2,001.695s 13 26,082 2,458.214s 0.178s 2,458.462s 14 48,064 3,238.665s 0.508s 3,239.267s 15 50,586 3,198.168s 0.375s 3,198.705s 16 45,928 3,207.116s 0.363s 3,207.572s 17 36,484 2,396.024s 0.289s 2,396.383s 18 12,143 673.995s 0.271s 674.294s 19 115 11.548s 0.009s 11.567s 20 1,243 189.661s 0.012s 189.688s 21 3,333 333.481s 0.17s 333.679s 22 3,195 320.136s 0.05s 320.215s 23 294 29.693s 0.068s 29.78s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 16 00 0 0 11 457 0.063s 0.006s 01 0 0 0 395 0.063s 0.006s 02 0 0 1 429 0.006s 0.006s 03 0 0 1 346 0.061s 0.008s 04 0 0 1 390 0.062s 0.006s 05 0 0 5 760 0.058s 0.008s 06 0 0 0 10 0.002s 0.001s 07 0 0 20 2,250 0.062s 0.011s 08 0 0 44 5,427 0.064s 0.012s 09 0 0 49 7,362 0.062s 0.012s 10 0 0 33 7,000 0.053s 0.012s 11 0 0 28 6,738 0.045s 0.012s 12 0 0 7 3,394 0.062s 0.012s 13 0 0 11 5,195 0.059s 0.012s 14 0 0 33 7,239 0.059s 0.012s 15 0 0 33 7,734 0.062s 0.012s 16 0 0 23 6,637 0.073s 0.012s 17 0 0 30 4,917 0.062s 0.012s 18 0 0 8 661 0.064s 0.014s 19 0 0 0 63 0.002s 0.003s 20 0 0 1 87 0.002s 0.003s 21 0 0 1 435 0.063s 0.005s 22 0 0 1 415 0.018s 0.007s 23 0 0 0 34 0.059s 0.011s Day Hour Count Avg time (sec) Sep 16 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 16 00 27,643.50 kB 72,417.00 kB 01 2,177.50 kB 40,187.00 kB 02 2,145.67 kB 22,366.50 kB 03 1,949.29 kB 4,864.00 kB 04 2,435.17 kB 3,611.00 kB 05 9,654.62 kB 15,327.62 kB 06 7,202.00 kB 13,979.00 kB 07 29,095.36 kB 64,857.91 kB 08 60,952.17 kB 115,867.08 kB 09 67,085.50 kB 120,343.50 kB 10 45,221.67 kB 89,868.50 kB 11 37,068.00 kB 83,955.67 kB 12 10,661.75 kB 38,182.00 kB 13 14,367.92 kB 25,385.08 kB 14 45,315.08 kB 85,024.92 kB 15 45,279.00 kB 100,810.92 kB 16 31,455.17 kB 56,724.17 kB 17 40,612.42 kB 81,509.25 kB 18 19,249.14 kB 76,132.00 kB 19 146.33 kB 49,130.33 kB 20 4,053.00 kB 36,750.00 kB 21 3,301.40 kB 25,352.60 kB 22 2,545.00 kB 14,836.57 kB 23 214.20 kB 8,435.60 kB -
Temporary Files
Size of temporary files
Key values
- 491.94 MiB Temp Files size Peak
- 2026-09-16 05:31:57 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-16 05:32:05 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 16 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 66.94 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.68 MiB 245.97 MiB 64.55 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-16 05:32:06 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-16 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 306.03 MiB 56.89 MiB 93.62 MiB 76.51 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-16 05:30:42 Duration: 39s642ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-16 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 245.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 245.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-16 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-16 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-16 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-16 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.75 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-16 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 18.79 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-16 10:43:26 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 18.79 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-16 10:43:26 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (123) Main table analyzed (database rio)
- 990 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 123 rio.pg_catalog.pg_class 64 rio.pg_catalog.pg_type 57 rio.public.temp0000291577 50 rio.public.usuarios 49 contagem.pg_catalog.pg_attribute 43 brasilia.pg_catalog.pg_attribute 40 rio.pg_catalog.pg_index 37 contagem.public.usuarios 35 rio.pg_catalog.pg_depend 30 rio.public.temp0000291561 29 contagem.pg_catalog.pg_class 26 contagem.pg_catalog.pg_type 22 contagem.public.temp0000227184 20 rio.public.temp0000291583 20 brasilia.pg_catalog.pg_class 19 rio.public.temp0000291581 18 rio.public.temp0000291315 17 brasilia.pg_catalog.pg_type 17 rio.public.temp0000291585 15 contagem.public.temp0000227188 15 rio.public.temp0000291615 14 contagem.pg_catalog.pg_index 14 rio.public.temp0000291639 13 brasilia.pg_catalog.pg_index 12 contagem.pg_catalog.pg_depend 11 brasilia.public.usuarios 10 brasilia.public.temp0000240310 10 rio.public.temp0000291603 10 rio.public.temp0000291083 9 brasilia.pg_catalog.pg_depend 9 contagem.public.temp0000227194 8 brasilia.pg_catalog.pg_shdepend 7 rio.public.temp0000291553 7 rio.public.temp0000290026 6 rio.public.temp0000291663 5 rio.public.temp0000290230 5 rio.public.temp0000291657 5 rio.public.temp0000291575 5 brasilia.public.temp0000240330 4 contagem.pg_catalog.pg_shdepend 4 contagem.public.nf_entrada 4 rio.public.temp0000291555 4 rio.pg_catalog.pg_shdepend 4 brasilia.public.temp0000240326 4 brasilia.public.nf_entrada 4 contagem.public.temp0000227190 4 rio.public.temp0000291643 3 brasilia.public.temp0000240260 3 rio.public.temp0000291619 3 rio.public.temp0000290893 3 brasilia.public.temp0000240272 2 rio.public.temp0000291571 2 brasilia.public.temp0000240294 2 brasilia.public.temp0000240284 2 rio.public.tmp_drill_0302 2 rio.public.tmp_drill_0320 2 rio.public.temp0000291567 2 brasilia.public.temp0000240348 2 rio.public.temp0000291637 1 postgres.pg_catalog.pg_shdepend 1 brasilia.public.temp0000240334 1 rio.public.temp0000291587 1 brasilia.public.temp0000240314 1 rio.public.temp0000291625 1 brasilia.public.temp0000240290 1 rio.public.temp0000291635 1 contagem.public.parametros 1 contagem.public.temp0000227176 1 rio.public.temp0000291489 1 contagem.public.temp0000227186 1 rio.public.temp0000291565 1 brasilia.public.temp0000240346 1 brasilia.public.temp0000240342 1 brasilia.public.temp0000240296 1 brasilia.public.temp0000240332 1 rio.public.temp0000291591 1 rio.public.temp0000291617 1 brasilia.public.temp0000240302 1 brasilia.public.temp0000240308 1 contagem.public.temp0000227198 1 brasilia.public.temp0000240266 1 brasilia.auditor.auditor_2026_09 1 Total 990 Vacuums per table
Key values
- pg_catalog.pg_attribute (50) Main table vacuumed on database rio
- 436 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 50 46 0 0 0 0 0 24,445 6,375 9,482,935 333 7,969 contagem.public.usuarios 35 0 0 0 0 0 0 168 124 69,861 0 0 rio.pg_catalog.pg_class 34 27 0 0 0 0 0 5,424 1,564 2,355,473 91 326 rio.public.temp0000291561 27 0 0 0 0 0 0 17,071 2,050 3,600,354 0 0 rio.pg_catalog.pg_type 25 22 0 0 0 0 0 2,312 672 901,171 60 187 rio.public.temp0000291585 18 0 0 0 0 0 0 6,236 281 734,318 0 0 rio.pg_catalog.pg_index 18 14 0 0 0 0 0 925 282 267,171 55 111 rio.public.temp0000291315 17 0 0 0 0 0 0 25,251 66 1,500,873 0 0 rio.pg_catalog.pg_depend 17 13 0 0 0 0 0 4,253 1,481 2,321,735 74 596 brasilia.pg_catalog.pg_attribute 16 14 0 0 0 0 0 7,652 1,419 2,719,326 50 1,272 contagem.pg_catalog.pg_attribute 15 15 0 0 0 0 0 8,696 2,317 4,169,275 33 908 rio.public.temp0000291639 13 0 0 0 0 0 0 7,832 274 865,424 0 0 brasilia.pg_catalog.pg_type 10 8 0 0 0 0 0 660 121 219,568 9 22 brasilia.pg_catalog.pg_class 10 8 0 0 0 0 0 1,676 289 550,505 10 30 brasilia.pg_catalog.pg_index 8 6 0 0 0 0 0 304 60 80,482 9 20 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,451 316 507,181 10 36 contagem.pg_catalog.pg_type 8 8 0 0 0 0 0 738 194 310,771 7 18 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 8,329 1,980 8,212,198 1,127 5,317 rio.public.temp0000291083 7 0 0 0 0 0 0 823 149 242,144 0 0 contagem.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 1,023 333 558,433 37 59 rio.public.temp0000290026 6 0 0 0 0 0 0 453 75 103,443 0 0 rio.public.usuarios 5 5 0 0 0 0 0 152 69 174,269 7 10 rio.public.temp0000291663 5 0 0 0 0 0 0 7,220 1,819 2,756,333 0 0 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,362 335 729,474 12 87 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,130 298 507,645 15 120 rio.public.temp0000290230 4 0 0 0 0 0 0 279 24 19,901 0 0 brasilia.public.temp0000240330 4 0 0 0 0 0 0 1,012 16 62,120 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,818 448 2,084,437 128 325 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 192 50 65,462 5 8 contagem.public.temp0000227184 4 0 0 0 0 0 0 462 24 31,199 0 0 rio.public.temp0000291575 4 0 0 0 0 0 0 3,760 1,820 2,552,872 0 0 brasilia.public.nf_entrada 3 1 0 0 0 0 0 266 129 219,159 10 15 rio.public.temp0000291619 3 0 0 0 0 0 0 3,616 1,814 2,545,230 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 298 58 106,785 5 10 rio.public.temp0000291643 2 0 0 0 0 0 0 120 9 8,569 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,265 438 1,981,067 324 2,275 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,814 187 847,188 140 1,233 brasilia.public.temp0000240348 2 0 0 0 0 0 0 257 7 16,304 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 77 16 24,500 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 312 69 296,987 22 49 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 1,933 28 357,767 0 0 rio.auditor.auditor_2026_09 1 0 0 0 0 0 0 86,187 54,889 69,424,591 15,601 322,550 brasilia.public.temp0000240294 1 0 0 0 0 0 0 253 4 15,530 0 0 rio.public.temp0000291577 1 0 0 0 0 0 0 62 6 4,522 0 0 rio.public.temp0000291625 1 0 0 0 0 0 0 4 4 3,033 0 0 brasilia.public.temp0000240290 1 0 0 0 0 0 0 253 4 15,530 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 154 15 62,609 3 6 rio.public.temp0000291637 1 0 0 0 0 0 0 75 73 134,001 0 0 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 157 57 83,452 12 32 rio.public.temp0000291615 1 0 0 0 0 0 0 8 5 1,334 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 127 52 94,075 2 13 rio.pg_catalog.pg_attrdef 1 1 0 0 0 0 0 19 5 3,117 0 0 brasilia.public.temp0000240346 1 0 0 0 0 0 0 253 4 15,530 0 0 brasilia.public.temp0000240296 1 0 0 0 0 0 0 253 4 15,530 0 0 brasilia.public.temp0000240332 1 0 0 0 0 0 0 253 4 15,530 0 0 contagem.public.temp0000227186 1 0 0 0 0 0 0 115 6 7,755 0 0 Total 436 242 0 0 0 0 0 244,240 83,212 125,056,048 18,191 343,604 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (18.79) 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.12 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 1.19 rio.public.temp0000291561 0 0 0.54 rio.pg_catalog.pg_type 0 0 0.35 rio.public.temp0000291585 0 0 0.22 rio.pg_catalog.pg_index 0 0 0.16 rio.public.temp0000291315 0 0 0.76 rio.pg_catalog.pg_depend 0 0 0.87 brasilia.pg_catalog.pg_attribute 0 0 1.77 contagem.pg_catalog.pg_attribute 0 0 1.62 rio.public.temp0000291639 0 0 0.2 brasilia.pg_catalog.pg_type 0 0 0.19 brasilia.pg_catalog.pg_class 0 0 0.54 brasilia.pg_catalog.pg_index 0 0 0.33 contagem.pg_catalog.pg_class 0 0 0.49 contagem.pg_catalog.pg_type 0 0 0.48 rio.pg_catalog.pg_statistic 0 0 1.07 rio.public.temp0000291083 0 0 0.11 contagem.pg_catalog.pg_shdepend 0 0 0.35 rio.public.temp0000290026 0 0 0.03 rio.public.usuarios 0 0 0 rio.public.temp0000291663 0 0 0.23 contagem.pg_catalog.pg_depend 0 0 0.41 brasilia.pg_catalog.pg_depend 0 0 0.65 rio.public.temp0000290230 0 0 0.02 brasilia.public.temp0000240330 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.22 contagem.pg_catalog.pg_index 0 0 0.11 contagem.public.temp0000227184 0 0 0 rio.public.temp0000291575 0 0 0.1 brasilia.public.nf_entrada 0 0 0.17 rio.public.temp0000291619 0 0 0.1 rio.pg_catalog.pg_shdepend 0 0 0.03 rio.public.temp0000291643 0 0 0.01 brasilia.pg_catalog.pg_statistic 0 0 0.29 contagem.pg_catalog.pg_statistic 0 0 0.2 brasilia.public.temp0000240348 0 0 0 rio.public.tmp_drill_0302 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.01 rio.public.tmp_drill_0320 0 0 0.05 rio.auditor.auditor_2026_09 0 0 18.79 brasilia.public.temp0000240294 0 0 0 rio.public.temp0000291577 0 0 0.01 rio.public.temp0000291625 0 0 0.05 brasilia.public.temp0000240290 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000291637 0 0 0.01 brasilia.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000291615 0 0 0 contagem.public.nf_entrada 0 0 0.06 rio.pg_catalog.pg_attrdef 0 0 0.03 brasilia.public.temp0000240346 0 0 0.03 brasilia.public.temp0000240296 0 0 0.05 brasilia.public.temp0000240332 0 0 0 contagem.public.temp0000227186 0 0 0 Total 0 0 36.05 Tuples removed per table
Key values
- pg_catalog.pg_attribute (190518) Main table with removed tuples on database rio
- 438610 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 50 46 190,518 1,268,608 63,715 313 31,312 brasilia.pg_catalog.pg_attribute 16 14 70,862 386,415 34,141 342 9,584 contagem.pg_catalog.pg_attribute 15 15 56,203 359,233 24 167 8,124 rio.public.tmp_drill_0320 2 2 29,165 29,552 0 0 744 rio.pg_catalog.pg_depend 17 13 13,721 339,235 17,704 0 3,179 rio.pg_catalog.pg_statistic 8 8 13,618 65,188 427 0 10,288 rio.pg_catalog.pg_type 25 22 8,643 61,577 5,082 18 1,832 rio.auditor.auditor_2026_09 1 0 6,773 10,699,497 0 0 496,560 contagem.pg_catalog.pg_statistic 2 2 5,583 14,956 0 0 2,022 contagem.pg_catalog.pg_shdepend 6 6 5,425 81,922 517 0 750 brasilia.pg_catalog.pg_statistic 2 2 5,108 15,396 0 0 2,144 rio.pg_catalog.pg_index 18 14 4,197 37,110 2,742 9 1,024 contagem.pg_catalog.pg_depend 5 5 3,791 93,987 0 0 890 rio.pg_catalog.pg_class 34 27 3,741 141,756 17,049 81 4,380 rio.pg_catalog.pg_shdepend 2 2 2,489 27,811 581 0 250 brasilia.pg_catalog.pg_type 10 8 2,295 25,682 3,358 30 730 contagem.pg_catalog.pg_type 8 8 2,291 18,056 0 17 506 contagem.public.usuarios 35 0 2,198 840 0 0 70 contagem.pg_catalog.pg_class 8 8 2,175 28,255 0 11 997 brasilia.pg_catalog.pg_class 10 8 2,157 42,480 8,389 58 1,398 brasilia.pg_catalog.pg_index 8 6 1,774 16,537 1,399 19 433 brasilia.pg_catalog.pg_depend 4 4 1,627 74,864 1,505 0 706 rio.pg_toast.pg_toast_2619 4 4 1,180 2,210 0 0 1,136 contagem.pg_catalog.pg_index 4 4 981 7,606 0 8 209 brasilia.pg_catalog.pg_shdepend 1 1 713 13,913 312 0 125 rio.public.usuarios 5 5 524 2,902 340 0 95 brasilia.public.nf_entrada 3 1 374 16,833 2,252 0 456 brasilia.pg_toast.pg_toast_2619 2 2 218 276 0 12 120 contagem.public.nf_entrada 1 1 122 1,067 0 0 79 contagem.pg_toast.pg_toast_2619 1 1 119 114 0 29 31 rio.pg_catalog.pg_attrdef 1 1 25 316 0 3 10 rio.public.temp0000291643 2 0 0 10,556 0 20 236 rio.public.temp0000291083 7 0 0 34,613 0 310 778 rio.public.temp0000291315 17 0 0 433,700 0 0 31,552 brasilia.public.temp0000240294 1 0 0 3,317 0 0 256 rio.public.temp0000290230 4 0 0 11,183 0 73 247 rio.public.temp0000291577 1 0 0 1,032 0 10 54 rio.public.temp0000291639 13 0 0 114,319 0 540 8,036 rio.public.temp0000291625 1 0 0 25,524 0 0 1,856 brasilia.public.temp0000240290 1 0 0 3,317 0 0 256 brasilia.public.temp0000240330 4 0 0 13,276 0 0 1,024 rio.public.temp0000291663 5 0 0 127,643 0 0 9,280 rio.public.temp0000291637 1 0 0 1,354 0 61 67 rio.public.temp0000291615 1 0 0 4,969 0 18 110 rio.public.temp0000291585 18 0 0 123,385 0 309 8,267 rio.public.temp0000291561 27 0 0 300,925 0 282 21,414 brasilia.public.temp0000240348 2 0 0 6,643 0 0 512 rio.public.temp0000290026 6 0 0 23,838 0 96 544 rio.public.tmp_drill_0302 2 2 0 932 0 0 25 brasilia.public.temp0000240346 1 0 0 3,319 0 0 256 contagem.public.temp0000227184 4 0 0 5,501 0 84 428 brasilia.public.temp0000240296 1 0 0 3,317 0 0 256 brasilia.public.temp0000240332 1 0 0 3,318 0 0 256 rio.public.temp0000291575 4 0 0 53,777 0 120 3,848 rio.public.temp0000291619 3 0 0 52,391 0 62 3,778 contagem.public.temp0000227186 1 0 0 1,376 0 21 107 Total 436 242 438,610 15,237,719 159,537 3,123 673,627 Pages removed per table
Key values
- public.temp0000291639 (540) Main table with removed pages on database rio
- 3123 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291639 13 0 0 540 brasilia.pg_catalog.pg_attribute 16 14 70862 342 rio.pg_catalog.pg_attribute 50 46 190518 313 rio.public.temp0000291083 7 0 0 310 rio.public.temp0000291585 18 0 0 309 rio.public.temp0000291561 27 0 0 282 contagem.pg_catalog.pg_attribute 15 15 56203 167 rio.public.temp0000291575 4 0 0 120 rio.public.temp0000290026 6 0 0 96 contagem.public.temp0000227184 4 0 0 84 rio.pg_catalog.pg_class 34 27 3741 81 rio.public.temp0000290230 4 0 0 73 rio.public.temp0000291619 3 0 0 62 rio.public.temp0000291637 1 0 0 61 brasilia.pg_catalog.pg_class 10 8 2157 58 brasilia.pg_catalog.pg_type 10 8 2295 30 contagem.pg_toast.pg_toast_2619 1 1 119 29 contagem.public.temp0000227186 1 0 0 21 rio.public.temp0000291643 2 0 0 20 brasilia.pg_catalog.pg_index 8 6 1774 19 rio.pg_catalog.pg_type 25 22 8643 18 rio.public.temp0000291615 1 0 0 18 contagem.pg_catalog.pg_type 8 8 2291 17 brasilia.pg_toast.pg_toast_2619 2 2 218 12 contagem.pg_catalog.pg_class 8 8 2175 11 rio.public.temp0000291577 1 0 0 10 rio.pg_catalog.pg_index 18 14 4197 9 contagem.pg_catalog.pg_index 4 4 981 8 rio.pg_catalog.pg_attrdef 1 1 25 3 rio.pg_catalog.pg_shdepend 2 2 2489 0 rio.public.usuarios 5 5 524 0 rio.auditor.auditor_2026_09 1 0 6773 0 brasilia.pg_catalog.pg_depend 4 4 1627 0 rio.public.temp0000291315 17 0 0 0 brasilia.public.temp0000240294 1 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 5108 0 contagem.pg_catalog.pg_statistic 2 2 5583 0 rio.public.temp0000291625 1 0 0 0 brasilia.public.temp0000240290 1 0 0 0 brasilia.public.temp0000240330 4 0 0 0 contagem.pg_catalog.pg_shdepend 6 6 5425 0 rio.public.temp0000291663 5 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1180 0 brasilia.pg_catalog.pg_shdepend 1 1 713 0 contagem.public.nf_entrada 1 1 122 0 contagem.public.usuarios 35 0 2198 0 brasilia.public.temp0000240348 2 0 0 0 contagem.pg_catalog.pg_depend 5 5 3791 0 rio.public.tmp_drill_0302 2 2 0 0 brasilia.public.temp0000240346 1 0 0 0 brasilia.public.nf_entrada 3 1 374 0 brasilia.public.temp0000240296 1 0 0 0 brasilia.public.temp0000240332 1 0 0 0 rio.public.tmp_drill_0320 2 2 29165 0 rio.pg_catalog.pg_depend 17 13 13721 0 rio.pg_catalog.pg_statistic 8 8 13618 0 Total 436 242 438,610 3,123 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 16 00 0 1 01 0 0 02 0 0 03 0 0 04 2 2 05 8 0 06 0 0 07 10 23 08 63 118 09 82 116 10 36 89 11 21 83 12 2 19 13 19 47 14 44 112 15 41 130 16 45 152 17 30 64 18 32 30 19 0 0 20 0 0 21 1 4 22 0 0 23 0 0 - 18.79 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 59s233ms 59s233ms 59s233ms 59s233ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 07:26:15 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 00:05:51 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 20:05:10 Database: rio User: intelifix Remote: [local] Application: psql
2 3 3s9ms 1s 1s9ms 1s3ms drop table if exists temp0000291585;-
DROP TABLE IF EXISTS temp0000291585;
Date: 2026-09-16 15:47:12 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291585;
Date: 2026-09-16 10:58:09 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291585;
Date: 2026-09-16 08:34:07 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s 1s 1s 1s drop table if exists temp0000291561;-
DROP TABLE IF EXISTS temp0000291561;
Date: 2026-09-16 07:19:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291561;
Date: 2026-09-16 07:19:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 59s233ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-16 07:26:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s9ms DROP TABLE IF EXISTS temp0000291585;[ Date: 2026-09-16 15:47:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s DROP TABLE IF EXISTS temp0000291585;[ Date: 2026-09-16 10:58:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000291585;[ Date: 2026-09-16 08:34:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s DROP TABLE IF EXISTS temp0000291561;[ Date: 2026-09-16 07:19:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,432 Total read queries
- 1,130 Total write queries
Queries by database
Key values
- rio Main database
- 3,250 Requests
- 4h58m21s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,923 Requests
User Request type Count Duration etiquetas Total 29 9s477ms select 29 9s477ms intelifix Total 4,923 6h52m7s copy to 407 41m42s ddl 723 36m17s others 490 46m1s select 3,302 4h48m5s lenon Total 101 1m10s select 101 1m10s Duration by user
Key values
- 6h52m7s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 29 9s477ms select 29 9s477ms intelifix Total 4,923 6h52m7s copy to 407 41m42s ddl 723 36m17s others 490 46m1s select 3,302 4h48m5s lenon Total 101 1m10s select 101 1m10s Queries by host
Key values
- [local] Main host
- 5,053 Requests
- 6h53m27s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,938 Requests
- 3h38m27s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-16 04:05:53 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,268 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m26s analyze verbose;[ Date: 2026-09-16 05:11:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 07:14:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m31s analyze verbose;[ Date: 2026-09-16 05:18:59 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 7m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 09:12:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029955, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-16 09:43:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029929, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-16 07:26:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029958, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-16 10:52:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 10:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029964, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-16 14:46:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 12:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 20:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029957, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-16 10:01:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 15:10:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029967, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-16 15:19:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 14:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 11:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 16:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029931, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-16 07:52:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 21:10:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-16 17:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h37m40s 48 1s431ms 9m11s 2m2s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 16 07 3 9m59s 3m19s 08 3 5m34s 1m51s 09 3 8m12s 2m44s 10 3 6m23s 2m7s 11 3 5m42s 1m54s 12 3 6m10s 2m3s 13 3 5m15s 1m45s 14 3 5m51s 1m57s 15 3 6m3s 2m1s 16 3 5m39s 1m53s 17 3 5m29s 1m49s 18 3 5m25s 1m48s 19 3 5m3s 1m41s 20 3 6m6s 2m2s 21 3 5m35s 1m51s 22 3 5m7s 1m42s [ User: intelifix - Total duration: 1h37m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 07:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 09:12:31 Duration: 7m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 10:11:04 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
2 1h10m44s 203 150ms 6m29s 20s907ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 16 07 10 11m53s 1m11s 08 23 1m42s 4s439ms 09 24 7m42s 19s262ms 10 32 18m27s 34s609ms 11 12 1m19s 6s660ms 12 4 18s918ms 4s729ms 13 15 6m34s 26s297ms 14 20 11m8s 33s436ms 15 16 5m53s 22s86ms 16 29 46s393ms 1s599ms 17 10 4m32s 27s261ms 18 7 23s412ms 3s344ms 19 1 1s20ms 1s20ms [ User: intelifix - Total duration: 1h10m44s - Times executed: 203 ]
[ Application: [unknown] - Total duration: 1h10m44s - Times executed: 203 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029955, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 09:43:53 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029929, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 07:26:14 Duration: 6m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029958, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 10:52:42 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h7m52s 48 261ms 4m 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 16 07 3 5m32s 1m50s 08 3 4m4s 1m21s 09 3 4m50s 1m36s 10 3 4m22s 1m27s 11 3 4m21s 1m27s 12 3 4m 1m20s 13 3 4m2s 1m20s 14 3 4m14s 1m24s 15 3 4m11s 1m23s 16 3 4m19s 1m26s 17 3 4m8s 1m22s 18 3 4m 1m20s 19 3 3m53s 1m17s 20 3 4m6s 1m22s 21 3 3m47s 1m15s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h7m52s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m52s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 07:20:22 Duration: 4m Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 11:15:01 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 10:15:45 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
4 22m5s 3 3m7s 11m26s 7m21s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 16 05 3 22m5s 7m21s [ User: intelifix - Total duration: 22m5s - Times executed: 3 ]
[ Application: psql - Total duration: 22m5s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-16 05:11:28 Duration: 11m26s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-16 05:18:59 Duration: 7m31s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-16 05:22:06 Duration: 3m7s Database: contagem User: intelifix Remote: [local] Application: psql
5 18m50s 1,404 150ms 4s791ms 805ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 16 07 2 672ms 336ms 08 69 50s849ms 736ms 09 156 2m3s 789ms 10 189 3m2s 966ms 11 180 3m3s 1s21ms 12 42 41s795ms 995ms 13 76 1m11s 940ms 14 194 2m35s 801ms 15 209 2m6s 607ms 16 223 2m32s 683ms 17 64 41s296ms 645ms [ User: intelifix - Total duration: 18m50s - Times executed: 1404 ]
[ Application: [unknown] - Total duration: 18m50s - Times executed: 1404 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (57992, 406, '836051908001689,241730938081,241727040104,241726858390,241728554864,241636039808,241692618696,241704290409,241731214753,241704363547,241622542038,241600967799,241730926161,241695582937,241676730312,241656810927,241695495779,241692689310,241700946479,230049403654,241676676164,241708853536,241676756879,241713690103,241713748895,241653874141,241717160307,241651612529,241622543250,241654350709,241680478803,241601115064,241680013954,241653124966,241646314144,241727490810,241606698303,241713044349,241728649294,241659799007,241731250010,241729485471,241647375471,241680341517,241728718695,241717127575,241731246978,241598860928,241704164358,241689204761', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-16 13:13:36 Duration: 4s791ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287611, 450, '921131014669,582FF79732AA,345D9EB42B1B,44D454C31C6D,582FF700FF4A,E8D2FFAA7651,8CC5B4D855EA,582FF716B67A,841EA3693ED9,D833B7C9AE90,64FD966C9218,B0BBE54BFC64,D833B753CF84,D0CF0EFDE64A,506F0C3B8806,8CFDDE865964,943C96AAF993,D833B71EBD74,345D9EBD7D5F,8CFDDE985E24,CC5830E26D44,6CBAB8F193D2,94988F93D898,44D454C2CC64,582FF7168438,E4C0E23FE4F5,5CFA251695C7,D833B7A35D3B,943C96AA6B2B,94988F95C11E,64FD9653C892,5CFA2515F5CA,64FD96563C1C,582FF78CDDEE,64FD966BCB08,E8D2FF97339D,20B82BF96C8A,D0CF0EFDD2CB,44D45494287F,44D454608DA4', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-16 14:34:33 Duration: 4s313ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287613, 450, 'CP2133LV0PH,ECA81F1FA06C$CP2130LV3KJ,8C6A8DBEB2DC$CP2236LV01F,4075C3B96490$CP2218LV89W,00CB7ADBE2FC$CP2235LV0B4,4075C3B8C828$CP2239LV5PM,4075C3C238F4$CP2239LV35L,4075C3C06B3C$CP2238LV312,4075C3BD8E94$CP2120LV3FG,08A7C06B7194$CP2205LV4PZ,1C9D72859F8C$CP2529LV1ZB,3C82C08E50AC$CP2347LV5FC,400FC17EBFB4$CP2218LV1JT,00CB7ADC6FEC$CP2522LV2EZ,B85E710DB3C0$CP2207LV7WH,3C82C06AAF2C$CP2127LV50Z,08A7C07B4B8C$CP2131LVDAM,ECA81F1CA804$CP2218LV5BT,00CB7ADE5F50$CP2147LV876,D4E2CB92D11C$CP2435LV5RH,C4509CF1B344$CP2120LV4SE,08A7C06C3884$CP2131LV54T,8C6A8DC33BAC$CP2051LV4LD,484BD4A64774$CP2218LV905,00CB7ADDC608$CP2233LV6FJ,4075C3B2DAF8$CP2238LV00C,4075C3BE5414$CP2436LV432,C4509CF17F0C$CP2147LV6LZ,D4E2CB92D794$CP2134LV8PN,ECA81F6AE05C$CP2239LV32N,4075C3C184CC$CP2439LV24A,C4509CF423A4$CP2522LV4JR,B85E710DB8FC$CP2106LV6V8,484BD4B4BC24$CP2522LV0MY,B85E710CA070$CP2248LVKNC,B85E71E34DEC$CP2439LV97H,C4509CF3C4AC$CP2218LV3YZ,00CB7ADDB460$CP2131LV8GM,8C6A8DC352EC$CP2248LVA9J,B85E71E2DE5C$CP2128LV55T,08A7C07AEED4', '',0185,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-16 10:17:22 Duration: 4s91ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 11m16s 160 163ms 38s65ms 4s226ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 16 00 6 1m3s 10s621ms 01 6 25s360ms 4s226ms 02 6 27s272ms 4s545ms 03 5 28s174ms 5s634ms 04 6 32s560ms 5s426ms 05 5 23s994ms 4s798ms 07 10 49s299ms 4s929ms 08 12 44s316ms 3s693ms 09 11 52s533ms 4s775ms 10 12 56s807ms 4s733ms 11 12 44s834ms 3s736ms 12 12 41s828ms 3s485ms 13 7 8s371ms 1s195ms 14 12 47s50ms 3s920ms 15 11 48s252ms 4s386ms 16 8 24s204ms 3s25ms 17 6 5s136ms 856ms 20 2 1s161ms 580ms 21 5 22s662ms 4s532ms 22 6 28s607ms 4s767ms [ User: intelifix - Total duration: 11m16s - Times executed: 160 ]
[ Application: psql - Total duration: 11m16s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 00:05:39 Duration: 38s65ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 10:15:12 Duration: 11s25ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 05:05:12 Duration: 10s531ms Database: rio User: intelifix Remote: [local] Application: psql
7 9m47s 74 1s252ms 1m16s 7s936ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 16 07 2 17s911ms 8s955ms 08 2 4s946ms 2s473ms 09 4 28s981ms 7s245ms 10 9 2m4s 13s888ms 11 9 1m34s 10s487ms 12 6 9s181ms 1s530ms 13 7 40s298ms 5s756ms 14 8 56s200ms 7s25ms 15 6 1m8s 11s435ms 16 12 1m20s 6s666ms 17 9 1m1s 6s861ms [ User: intelifix - Total duration: 9m47s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 9m47s - Times executed: 74 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 10:04:46 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 15:38:39 Duration: 18s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 14:54:24 Duration: 18s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m34s 44 9s929ms 50s742ms 13s48ms create table temp0000291561 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 16 07 11 2m37s 14s314ms 08 12 2m10s 10s834ms 09 15 3m9s 12s644ms 10 6 1m36s 16s166ms [ User: intelifix - Total duration: 9m34s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 9m34s - Times executed: 44 ]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 07:16:35 Duration: 50s742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 10:45:43 Duration: 37s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 09:21:46 Duration: 35s954ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 7m48s 750 150ms 4s804ms 624ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 16 07 11 9s443ms 858ms 08 113 1m11s 630ms 09 125 1m18s 627ms 10 108 1m10s 650ms 11 94 1m 642ms 12 12 8s6ms 667ms 13 49 33s204ms 677ms 14 84 46s301ms 551ms 15 77 49s537ms 643ms 16 50 27s579ms 551ms 17 27 14s271ms 528ms [ User: intelifix - Total duration: 7m48s - Times executed: 750 ]
[ Application: [unknown] - Total duration: 7m48s - Times executed: 750 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287687", "modelo" : "463", "itens" : "241725634343,241755890619,241721702748,241721560108,241722476369,241758252241,241757068297,241721629912,241722345167,241706251229,241751967081,241723264359,241720701326,241719054554,241720108305,241781503556,241748363857,241737377576,241735831826,241751516981,241720724560,241721722222,241736537685,241781916076,241749943551,241734539107,241753638704,241779554858,241779527380,241757976478,241754613535,241723870917,241751883841,241794375171,241722530820,241735405869,241748933744,241735791822,241758815056,241720764867,241748209902,241736060715,241754755771,241754595374,241755910621,241749931025,241755545556,241784486585,241705946069,241722567287,241750510206,241755999191,241750454162,241781505172,241723209505,241722532032,241748496574,241705074155,241756847086,241750303238", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-16 16:51:47 Duration: 4s804ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287687", "modelo" : "463", "itens" : "241721804149,241737430916,241783434552,241754288699,241748773953,241723107373,241736626785,241758299898,241736511017,241758227490,241719997384,241721610618,241748257078,241789449303,241794257381,241736700508,241753619813,241781972648,241753547179,241750533541,241722491119,241758292323,241723032945,241752327374,241724411834,241752245672,241758035070,241781708907,241754707584,241748216973,241735400415,241755828894,241725656163,241754607597,241719293040,241783455160,241752302547,241725846384,241737156870,241735106973,241722319205,241779517783,241722476672,241721644358,241719051524,241782336678,241734529409,241724124959,241735991213,241720344747,241722596987,241720242437,241736980109,241722311326,241782170827,241790251840,241752128084,241725763245,241720267388,241786754057", "usuario" : "414", "caixa" : "3662115", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-16 17:10:07 Duration: 2s370ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288140", "modelo" : "160", "itens" : "229842314251,229841595157,229838119801,229846488698,229841897386,229845689900,229842663960,229845925557,229842225353,229843699100,229853125968,229851978190,229846441624,229852522139,229846050015,229845845269,229853102330,229846943446,229854352340,229853869913,229848292938,229852596264,229862053237,229847735678,229838578386,229760748704,229759433536,229851710208,229855575859,229839918709,229861916579,229840844141,229851841029,229856829809,229847340006,229843467079,229757278702,229756393251,229846391013,229839448809,229853751114,229839395571,229680381119,229762133755,229854692631,229843555775,229852164449,229851820320", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-16 15:02:33 Duration: 2s230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 6m10s 222 150ms 1m4s 1s668ms call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 16 00 10 23s517ms 2s351ms 01 9 11s245ms 1s249ms 02 11 11s141ms 1s12ms 03 9 11s745ms 1s305ms 04 10 10s771ms 1s77ms 05 8 10s407ms 1s300ms 06 12 12s503ms 1s41ms 07 8 1m14s 9s353ms 08 8 11s113ms 1s389ms 09 11 15s865ms 1s442ms 10 12 15s94ms 1s257ms 11 9 12s735ms 1s415ms 12 9 11s140ms 1s237ms 13 8 11s517ms 1s439ms 14 11 16s9ms 1s455ms 15 11 12s205ms 1s109ms 16 11 13s418ms 1s219ms 17 9 13s849ms 1s538ms 18 11 11s563ms 1s51ms 19 7 10s864ms 1s552ms 20 9 26s202ms 2s911ms 21 9 11s240ms 1s248ms 22 10 11s352ms 1s135ms [ User: intelifix - Total duration: 6m10s - Times executed: 222 ]
[ Application: psql - Total duration: 6m10s - Times executed: 222 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 07:26:15 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 00:05:51 Duration: 10s997ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 20:05:10 Duration: 8s150ms Database: rio User: intelifix Remote: [local] Application: psql
11 3m53s 21 10s535ms 14s829ms 11s138ms create table temp0000291315 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 16 08 13 2m21s 10s905ms 09 5 54s431ms 10s886ms 14 3 37s707ms 12s569ms [ User: intelifix - Total duration: 3m53s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 3m53s - Times executed: 21 ]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:00:58 Duration: 14s829ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:01:29 Duration: 11s491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:02:23 Duration: 11s386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 2m43s 14 10s493ms 14s512ms 11s647ms create table temp0000291585 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 16 08 6 1m4s 10s786ms 09 2 21s917ms 10s958ms 10 3 38s26ms 12s675ms 15 3 38s398ms 12s799ms [ User: intelifix - Total duration: 2m43s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m43s - Times executed: 14 ]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 15:46:35 Duration: 14s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 10:57:44 Duration: 13s215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 10:58:21 Duration: 12s806ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2m41s 90 151ms 18s525ms 1s789ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 16 07 6 5s489ms 914ms 08 4 2s410ms 602ms 09 6 4s423ms 737ms 10 16 1m8s 4s260ms 11 7 55s341ms 7s905ms 13 5 2s815ms 563ms 14 17 10s688ms 628ms 15 8 2s662ms 332ms 16 21 9s32ms 430ms [ User: intelifix - Total duration: 2m41s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 2m41s - Times executed: 90 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056928) LIMIT 1;
Date: 2026-09-16 10:14:58 Duration: 18s525ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056928) LIMIT 1;
Date: 2026-09-16 11:58:07 Duration: 17s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056927) LIMIT 1;
Date: 2026-09-16 10:15:55 Duration: 17s78ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 2m25s 33 206ms 37s557ms 4s416ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 16 07 2 40s547ms 20s273ms 08 12 38s104ms 3s175ms 09 5 15s909ms 3s181ms 10 1 18s613ms 18s613ms 14 2 9s164ms 4s582ms 15 1 4s146ms 4s146ms 16 4 6s778ms 1s694ms 18 6 12s464ms 2s77ms [ User: intelifix - Total duration: 2m25s - Times executed: 33 ]
[ Application: psql - Total duration: 2m25s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029929);
Date: 2026-09-16 07:19:46 Duration: 37s557ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029958);
Date: 2026-09-16 10:46:25 Duration: 18s613ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029964);
Date: 2026-09-16 14:39:59 Duration: 8s263ms Database: rio User: intelifix Remote: [local] Application: psql
15 2m22s 59 159ms 7s617ms 2s408ms create table temp0000291619 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 16 13 58 2m21s 2s447ms 15 1 159ms 159ms [ User: intelifix - Total duration: 2m22s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 2m22s - Times executed: 59 ]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:35:16 Duration: 7s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:36:00 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:35:31 Duration: 2s485ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m19s 12 10s520ms 13s194ms 11s664ms create table temp0000291639 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 16 14 7 1m24s 12s101ms 15 5 55s257ms 11s51ms [ User: intelifix - Total duration: 2m19s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m19s - Times executed: 12 ]
-
CREATE TABLE temp0000291639 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:58:39 Duration: 13s194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291639 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:59:00 Duration: 12s583ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291639 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:38:35 Duration: 12s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m19s 40 152ms 16s600ms 3s494ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 16 07 4 1s460ms 365ms 08 15 1m21s 5s434ms 09 8 29s760ms 3s720ms 10 3 1s91ms 363ms 14 5 7s830ms 1s566ms 15 3 587ms 195ms 17 2 17s551ms 8s775ms [ User: intelifix - Total duration: 2m19s - Times executed: 40 ]
[ Application: psql - Total duration: 2m19s - Times executed: 40 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029951);
Date: 2026-09-16 09:08:48 Duration: 16s600ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029940);
Date: 2026-09-16 08:36:12 Duration: 14s317ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 403); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029969);
Date: 2026-09-16 17:29:33 Duration: 13s132ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m14s 4 4s423ms 1m3s 33s593ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 16 20 2 1m6s 33s471ms 23 2 1m7s 33s715ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-16 23:16:38 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-16 20:08:41 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-16 20:10:39 Duration: 4s826ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m56s 35 611ms 10s134ms 3s320ms 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 #19
Day Hour Count Duration Avg duration Sep 16 08 2 8s229ms 4s114ms 09 2 11s857ms 5s928ms 10 3 19s522ms 6s507ms 11 2 12s822ms 6s411ms 12 2 5s396ms 2s698ms 13 2 7s845ms 3s922ms 14 3 11s305ms 3s768ms 15 2 11s618ms 5s809ms 16 3 10s266ms 3s422ms 17 2 7s476ms 3s738ms 18 2 1s527ms 763ms 19 2 1s837ms 918ms 20 2 1s703ms 851ms 21 3 2s508ms 836ms 22 3 2s308ms 769ms [ User: intelifix - Total duration: 1m56s - Times executed: 35 ]
[ Application: psql - Total duration: 1m56s - Times executed: 35 ]
-
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-16 11:20:11 Duration: 10s134ms 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-16 10:00:10 Duration: 8s890ms 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-16 15:40:10 Duration: 8s564ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m47s 4 329ms 53s893ms 26s910ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 16 20 2 54s255ms 27s127ms 23 2 53s385ms 26s692ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-16 20:05:47 Duration: 53s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-16 23:13:42 Duration: 53s56ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-16 20:10:05 Duration: 362ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,404 18m50s 150ms 4s791ms 805ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 16 07 2 672ms 336ms 08 69 50s849ms 736ms 09 156 2m3s 789ms 10 189 3m2s 966ms 11 180 3m3s 1s21ms 12 42 41s795ms 995ms 13 76 1m11s 940ms 14 194 2m35s 801ms 15 209 2m6s 607ms 16 223 2m32s 683ms 17 64 41s296ms 645ms [ User: intelifix - Total duration: 18m50s - Times executed: 1404 ]
[ Application: [unknown] - Total duration: 18m50s - Times executed: 1404 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (57992, 406, '836051908001689,241730938081,241727040104,241726858390,241728554864,241636039808,241692618696,241704290409,241731214753,241704363547,241622542038,241600967799,241730926161,241695582937,241676730312,241656810927,241695495779,241692689310,241700946479,230049403654,241676676164,241708853536,241676756879,241713690103,241713748895,241653874141,241717160307,241651612529,241622543250,241654350709,241680478803,241601115064,241680013954,241653124966,241646314144,241727490810,241606698303,241713044349,241728649294,241659799007,241731250010,241729485471,241647375471,241680341517,241728718695,241717127575,241731246978,241598860928,241704164358,241689204761', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-16 13:13:36 Duration: 4s791ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287611, 450, '921131014669,582FF79732AA,345D9EB42B1B,44D454C31C6D,582FF700FF4A,E8D2FFAA7651,8CC5B4D855EA,582FF716B67A,841EA3693ED9,D833B7C9AE90,64FD966C9218,B0BBE54BFC64,D833B753CF84,D0CF0EFDE64A,506F0C3B8806,8CFDDE865964,943C96AAF993,D833B71EBD74,345D9EBD7D5F,8CFDDE985E24,CC5830E26D44,6CBAB8F193D2,94988F93D898,44D454C2CC64,582FF7168438,E4C0E23FE4F5,5CFA251695C7,D833B7A35D3B,943C96AA6B2B,94988F95C11E,64FD9653C892,5CFA2515F5CA,64FD96563C1C,582FF78CDDEE,64FD966BCB08,E8D2FF97339D,20B82BF96C8A,D0CF0EFDD2CB,44D45494287F,44D454608DA4', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-16 14:34:33 Duration: 4s313ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287613, 450, 'CP2133LV0PH,ECA81F1FA06C$CP2130LV3KJ,8C6A8DBEB2DC$CP2236LV01F,4075C3B96490$CP2218LV89W,00CB7ADBE2FC$CP2235LV0B4,4075C3B8C828$CP2239LV5PM,4075C3C238F4$CP2239LV35L,4075C3C06B3C$CP2238LV312,4075C3BD8E94$CP2120LV3FG,08A7C06B7194$CP2205LV4PZ,1C9D72859F8C$CP2529LV1ZB,3C82C08E50AC$CP2347LV5FC,400FC17EBFB4$CP2218LV1JT,00CB7ADC6FEC$CP2522LV2EZ,B85E710DB3C0$CP2207LV7WH,3C82C06AAF2C$CP2127LV50Z,08A7C07B4B8C$CP2131LVDAM,ECA81F1CA804$CP2218LV5BT,00CB7ADE5F50$CP2147LV876,D4E2CB92D11C$CP2435LV5RH,C4509CF1B344$CP2120LV4SE,08A7C06C3884$CP2131LV54T,8C6A8DC33BAC$CP2051LV4LD,484BD4A64774$CP2218LV905,00CB7ADDC608$CP2233LV6FJ,4075C3B2DAF8$CP2238LV00C,4075C3BE5414$CP2436LV432,C4509CF17F0C$CP2147LV6LZ,D4E2CB92D794$CP2134LV8PN,ECA81F6AE05C$CP2239LV32N,4075C3C184CC$CP2439LV24A,C4509CF423A4$CP2522LV4JR,B85E710DB8FC$CP2106LV6V8,484BD4B4BC24$CP2522LV0MY,B85E710CA070$CP2248LVKNC,B85E71E34DEC$CP2439LV97H,C4509CF3C4AC$CP2218LV3YZ,00CB7ADDB460$CP2131LV8GM,8C6A8DC352EC$CP2248LVA9J,B85E71E2DE5C$CP2128LV55T,08A7C07AEED4', '',0185,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-16 10:17:22 Duration: 4s91ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 750 7m48s 150ms 4s804ms 624ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 16 07 11 9s443ms 858ms 08 113 1m11s 630ms 09 125 1m18s 627ms 10 108 1m10s 650ms 11 94 1m 642ms 12 12 8s6ms 667ms 13 49 33s204ms 677ms 14 84 46s301ms 551ms 15 77 49s537ms 643ms 16 50 27s579ms 551ms 17 27 14s271ms 528ms [ User: intelifix - Total duration: 7m48s - Times executed: 750 ]
[ Application: [unknown] - Total duration: 7m48s - Times executed: 750 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287687", "modelo" : "463", "itens" : "241725634343,241755890619,241721702748,241721560108,241722476369,241758252241,241757068297,241721629912,241722345167,241706251229,241751967081,241723264359,241720701326,241719054554,241720108305,241781503556,241748363857,241737377576,241735831826,241751516981,241720724560,241721722222,241736537685,241781916076,241749943551,241734539107,241753638704,241779554858,241779527380,241757976478,241754613535,241723870917,241751883841,241794375171,241722530820,241735405869,241748933744,241735791822,241758815056,241720764867,241748209902,241736060715,241754755771,241754595374,241755910621,241749931025,241755545556,241784486585,241705946069,241722567287,241750510206,241755999191,241750454162,241781505172,241723209505,241722532032,241748496574,241705074155,241756847086,241750303238", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-16 16:51:47 Duration: 4s804ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287687", "modelo" : "463", "itens" : "241721804149,241737430916,241783434552,241754288699,241748773953,241723107373,241736626785,241758299898,241736511017,241758227490,241719997384,241721610618,241748257078,241789449303,241794257381,241736700508,241753619813,241781972648,241753547179,241750533541,241722491119,241758292323,241723032945,241752327374,241724411834,241752245672,241758035070,241781708907,241754707584,241748216973,241735400415,241755828894,241725656163,241754607597,241719293040,241783455160,241752302547,241725846384,241737156870,241735106973,241722319205,241779517783,241722476672,241721644358,241719051524,241782336678,241734529409,241724124959,241735991213,241720344747,241722596987,241720242437,241736980109,241722311326,241782170827,241790251840,241752128084,241725763245,241720267388,241786754057", "usuario" : "414", "caixa" : "3662115", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-16 17:10:07 Duration: 2s370ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "288140", "modelo" : "160", "itens" : "229842314251,229841595157,229838119801,229846488698,229841897386,229845689900,229842663960,229845925557,229842225353,229843699100,229853125968,229851978190,229846441624,229852522139,229846050015,229845845269,229853102330,229846943446,229854352340,229853869913,229848292938,229852596264,229862053237,229847735678,229838578386,229760748704,229759433536,229851710208,229855575859,229839918709,229861916579,229840844141,229851841029,229856829809,229847340006,229843467079,229757278702,229756393251,229846391013,229839448809,229853751114,229839395571,229680381119,229762133755,229854692631,229843555775,229852164449,229851820320", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-16 15:02:33 Duration: 2s230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 222 6m10s 150ms 1m4s 1s668ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 16 00 10 23s517ms 2s351ms 01 9 11s245ms 1s249ms 02 11 11s141ms 1s12ms 03 9 11s745ms 1s305ms 04 10 10s771ms 1s77ms 05 8 10s407ms 1s300ms 06 12 12s503ms 1s41ms 07 8 1m14s 9s353ms 08 8 11s113ms 1s389ms 09 11 15s865ms 1s442ms 10 12 15s94ms 1s257ms 11 9 12s735ms 1s415ms 12 9 11s140ms 1s237ms 13 8 11s517ms 1s439ms 14 11 16s9ms 1s455ms 15 11 12s205ms 1s109ms 16 11 13s418ms 1s219ms 17 9 13s849ms 1s538ms 18 11 11s563ms 1s51ms 19 7 10s864ms 1s552ms 20 9 26s202ms 2s911ms 21 9 11s240ms 1s248ms 22 10 11s352ms 1s135ms [ User: intelifix - Total duration: 6m10s - Times executed: 222 ]
[ Application: psql - Total duration: 6m10s - Times executed: 222 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 07:26:15 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 00:05:51 Duration: 10s997ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 20:05:10 Duration: 8s150ms Database: rio User: intelifix Remote: [local] Application: psql
4 203 1h10m44s 150ms 6m29s 20s907ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 16 07 10 11m53s 1m11s 08 23 1m42s 4s439ms 09 24 7m42s 19s262ms 10 32 18m27s 34s609ms 11 12 1m19s 6s660ms 12 4 18s918ms 4s729ms 13 15 6m34s 26s297ms 14 20 11m8s 33s436ms 15 16 5m53s 22s86ms 16 29 46s393ms 1s599ms 17 10 4m32s 27s261ms 18 7 23s412ms 3s344ms 19 1 1s20ms 1s20ms [ User: intelifix - Total duration: 1h10m44s - Times executed: 203 ]
[ Application: [unknown] - Total duration: 1h10m44s - Times executed: 203 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029955, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 09:43:53 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029929, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 07:26:14 Duration: 6m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029958, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 10:52:42 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 160 11m16s 163ms 38s65ms 4s226ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 16 00 6 1m3s 10s621ms 01 6 25s360ms 4s226ms 02 6 27s272ms 4s545ms 03 5 28s174ms 5s634ms 04 6 32s560ms 5s426ms 05 5 23s994ms 4s798ms 07 10 49s299ms 4s929ms 08 12 44s316ms 3s693ms 09 11 52s533ms 4s775ms 10 12 56s807ms 4s733ms 11 12 44s834ms 3s736ms 12 12 41s828ms 3s485ms 13 7 8s371ms 1s195ms 14 12 47s50ms 3s920ms 15 11 48s252ms 4s386ms 16 8 24s204ms 3s25ms 17 6 5s136ms 856ms 20 2 1s161ms 580ms 21 5 22s662ms 4s532ms 22 6 28s607ms 4s767ms [ User: intelifix - Total duration: 11m16s - Times executed: 160 ]
[ Application: psql - Total duration: 11m16s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 00:05:39 Duration: 38s65ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 10:15:12 Duration: 11s25ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 05:05:12 Duration: 10s531ms Database: rio User: intelifix Remote: [local] Application: psql
6 95 31s338ms 299ms 452ms 329ms 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 #6
Day Hour Count Duration Avg duration Sep 16 04 2 629ms 314ms 07 6 1s840ms 306ms 08 9 2s913ms 323ms 09 11 3s529ms 320ms 10 12 4s113ms 342ms 11 7 2s391ms 341ms 12 4 1s258ms 314ms 13 9 2s917ms 324ms 14 9 3s89ms 343ms 15 9 2s953ms 328ms 16 8 2s780ms 347ms 17 6 1s970ms 328ms 18 2 641ms 320ms 19 1 308ms 308ms [ User: lenon - Total duration: 31s338ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 31s338ms - Times executed: 95 ]
-
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-16 16:11:03 Duration: 452ms 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-16 10:05:07 Duration: 399ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-16 14:38:36 Duration: 397ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 90 2m41s 151ms 18s525ms 1s789ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 16 07 6 5s489ms 914ms 08 4 2s410ms 602ms 09 6 4s423ms 737ms 10 16 1m8s 4s260ms 11 7 55s341ms 7s905ms 13 5 2s815ms 563ms 14 17 10s688ms 628ms 15 8 2s662ms 332ms 16 21 9s32ms 430ms [ User: intelifix - Total duration: 2m41s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 2m41s - Times executed: 90 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056928) LIMIT 1;
Date: 2026-09-16 10:14:58 Duration: 18s525ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056928) LIMIT 1;
Date: 2026-09-16 11:58:07 Duration: 17s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056927) LIMIT 1;
Date: 2026-09-16 10:15:55 Duration: 17s78ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 89 28s6ms 254ms 1s439ms 314ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 16 07 2 568ms 284ms 08 18 5s42ms 280ms 09 11 3s61ms 278ms 10 6 2s891ms 481ms 11 5 1s459ms 291ms 12 3 1s68ms 356ms 13 9 3s626ms 402ms 14 7 2s140ms 305ms 15 7 2s255ms 322ms 16 6 1s799ms 299ms 17 7 1s895ms 270ms 18 7 1s925ms 275ms 19 1 270ms 270ms [ User: intelifix - Total duration: 28s6ms - Times executed: 89 ]
[ Application: [unknown] - Total duration: 28s6ms - Times executed: 89 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-16 10:16:12 Duration: 1s439ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-09-16 13:35:52 Duration: 1s368ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-16 15:55:00 Duration: 534ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 85 34s193ms 170ms 813ms 402ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 16 04 1 813ms 813ms 07 2 1s 500ms 08 8 3s15ms 376ms 09 10 3s839ms 383ms 10 12 4s881ms 406ms 11 5 2s64ms 412ms 12 4 1s499ms 374ms 13 9 3s599ms 399ms 14 9 3s768ms 418ms 15 9 3s577ms 397ms 16 9 3s414ms 379ms 17 6 2s273ms 378ms 18 1 444ms 444ms [ User: intelifix - Total duration: 34s193ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 34s193ms - Times executed: 85 ]
-
select * from rs_menu_grants (477, 18, 1);
Date: 2026-09-16 04:57:11 Duration: 813ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (476, 19, 1);
Date: 2026-09-16 07:49:33 Duration: 627ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (415, 21, 1);
Date: 2026-09-16 13:45:37 Duration: 614ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 74 9m47s 1s252ms 1m16s 7s936ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 16 07 2 17s911ms 8s955ms 08 2 4s946ms 2s473ms 09 4 28s981ms 7s245ms 10 9 2m4s 13s888ms 11 9 1m34s 10s487ms 12 6 9s181ms 1s530ms 13 7 40s298ms 5s756ms 14 8 56s200ms 7s25ms 15 6 1m8s 11s435ms 16 12 1m20s 6s666ms 17 9 1m1s 6s861ms [ User: intelifix - Total duration: 9m47s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 9m47s - Times executed: 74 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 10:04:46 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 15:38:39 Duration: 18s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 14:54:24 Duration: 18s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 63 15s618ms 151ms 506ms 247ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 16 07 8 1s937ms 242ms 08 5 1s141ms 228ms 09 9 1s840ms 204ms 10 11 3s62ms 278ms 11 8 2s345ms 293ms 12 2 508ms 254ms 13 4 1s297ms 324ms 14 7 1s592ms 227ms 15 7 1s553ms 221ms 16 2 337ms 168ms [ User: intelifix - Total duration: 15s618ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 15s618ms - Times executed: 63 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '87', 2, 'C85D38886107,C85D3860961B,C85D388C41C5,C85D387115AF,D86C5A4ECFF0,C85D38F0235E,8C444FD749F7,8C444FE548D8,C85D38A7229E,C85D38F39EF7', NULL, NULL, 0151, 00);
Date: 2026-09-16 11:19:15 Duration: 506ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, 'E8D2FFA5B44D,6CFFCE693C35,582FF797437B,64FD96559152,943C96ACC9B5,D833B7C943F3,D833B73116A8,582FF70A8ED1,3C585D7922CD,841EA3973B3D,44D454606794,B0FC88E99CA8,841EA38E7ECC', NULL, NULL, 0155, 00);
Date: 2026-09-16 13:47:23 Duration: 502ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229954594356,230002836976,230015459195,230018478794,229930565355,229969752738,229991756164,229926166991,229996717692,230018204649', NULL, NULL, 0287, 00);
Date: 2026-09-16 10:30:48 Duration: 487ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 60 12s352ms 150ms 2s28ms 205ms create table temp0000291583 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 16 08 1 2s28ms 2s28ms 10 9 1s564ms 173ms 11 1 181ms 181ms 12 1 195ms 195ms 13 1 160ms 160ms 14 7 1s543ms 220ms 15 13 2s56ms 158ms 16 27 4s622ms 171ms [ User: intelifix - Total duration: 12s352ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 12s352ms - Times executed: 60 ]
-
CREATE TABLE temp0000291583 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 08:22:08 Duration: 2s28ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291583 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"2151", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 14:18:04 Duration: 578ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291583 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"2151", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 16:34:08 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 59 2m22s 159ms 7s617ms 2s408ms create table temp0000291619 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 16 13 58 2m21s 2s447ms 15 1 159ms 159ms [ User: intelifix - Total duration: 2m22s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 2m22s - Times executed: 59 ]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:35:16 Duration: 7s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:36:00 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:35:31 Duration: 2s485ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 53 1m24s 568ms 20s494ms 1s589ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 16 08 4 4s846ms 1s211ms 09 3 4s521ms 1s507ms 10 3 2s608ms 869ms 11 4 10s253ms 2s563ms 12 4 3s165ms 791ms 13 4 5s80ms 1s270ms 14 3 2s342ms 780ms 15 4 8s934ms 2s233ms 16 3 2s423ms 807ms 17 3 22s903ms 7s634ms 18 4 4s264ms 1s66ms 19 4 2s878ms 719ms 20 4 5s415ms 1s353ms 21 3 2s281ms 760ms 22 3 2s322ms 774ms [ User: intelifix - Total duration: 1m24s - Times executed: 53 ]
[ Application: psql - Total duration: 1m24s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-16 17:40:23 Duration: 20s494ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-16 11:40:09 Duration: 8s111ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-16 15:20:07 Duration: 5s891ms Database: rio User: intelifix Remote: [local] Application: psql
15 50 10s966ms 150ms 2s732ms 219ms create table temp0000291577 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 16 08 1 2s732ms 2s732ms 09 1 160ms 160ms 15 11 1s719ms 156ms 16 37 6s354ms 171ms [ User: intelifix - Total duration: 10s966ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 10s966ms - Times executed: 50 ]
-
CREATE TABLE temp0000291577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 08:17:16 Duration: 2s732ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"2151", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 16:48:59 Duration: 203ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291577 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"2151", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 16:10:02 Duration: 202ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 48 1h37m40s 1s431ms 9m11s 2m2s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 16 07 3 9m59s 3m19s 08 3 5m34s 1m51s 09 3 8m12s 2m44s 10 3 6m23s 2m7s 11 3 5m42s 1m54s 12 3 6m10s 2m3s 13 3 5m15s 1m45s 14 3 5m51s 1m57s 15 3 6m3s 2m1s 16 3 5m39s 1m53s 17 3 5m29s 1m49s 18 3 5m25s 1m48s 19 3 5m3s 1m41s 20 3 6m6s 2m2s 21 3 5m35s 1m51s 22 3 5m7s 1m42s [ User: intelifix - Total duration: 1h37m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 07:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 09:12:31 Duration: 7m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 10:11:04 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
17 48 1h7m52s 261ms 4m 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 16 07 3 5m32s 1m50s 08 3 4m4s 1m21s 09 3 4m50s 1m36s 10 3 4m22s 1m27s 11 3 4m21s 1m27s 12 3 4m 1m20s 13 3 4m2s 1m20s 14 3 4m14s 1m24s 15 3 4m11s 1m23s 16 3 4m19s 1m26s 17 3 4m8s 1m22s 18 3 4m 1m20s 19 3 3m53s 1m17s 20 3 4m6s 1m22s 21 3 3m47s 1m15s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h7m52s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m52s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 07:20:22 Duration: 4m Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 11:15:01 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 10:15:45 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
18 44 9m34s 9s929ms 50s742ms 13s48ms create table temp0000291561 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 16 07 11 2m37s 14s314ms 08 12 2m10s 10s834ms 09 15 3m9s 12s644ms 10 6 1m36s 16s166ms [ User: intelifix - Total duration: 9m34s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 9m34s - Times executed: 44 ]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 07:16:35 Duration: 50s742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 10:45:43 Duration: 37s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 09:21:46 Duration: 35s954ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 41 9s261ms 150ms 479ms 225ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 16 04 1 479ms 479ms 07 1 248ms 248ms 08 2 400ms 200ms 09 1 203ms 203ms 10 5 1s157ms 231ms 11 9 2s89ms 232ms 12 3 685ms 228ms 13 2 736ms 368ms 14 7 1s321ms 188ms 15 5 1s77ms 215ms 16 4 711ms 177ms 17 1 151ms 151ms [ User: intelifix - Total duration: 9s261ms - Times executed: 41 ]
[ Application: [unknown] - Total duration: 9s261ms - Times executed: 41 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('3C82C0CA8450');
Date: 2026-09-16 04:57:42 Duration: 479ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('318213043845');
Date: 2026-09-16 13:17:10 Duration: 452ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('246572285968');
Date: 2026-09-16 11:19:00 Duration: 434ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 40 2m19s 152ms 16s600ms 3s494ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 16 07 4 1s460ms 365ms 08 15 1m21s 5s434ms 09 8 29s760ms 3s720ms 10 3 1s91ms 363ms 14 5 7s830ms 1s566ms 15 3 587ms 195ms 17 2 17s551ms 8s775ms [ User: intelifix - Total duration: 2m19s - Times executed: 40 ]
[ Application: psql - Total duration: 2m19s - Times executed: 40 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029951);
Date: 2026-09-16 09:08:48 Duration: 16s600ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029940);
Date: 2026-09-16 08:36:12 Duration: 14s317ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 403); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029969);
Date: 2026-09-16 17:29:33 Duration: 13s132ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m7s 11m26s 7m21s 3 22m5s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 16 05 3 22m5s 7m21s [ User: intelifix - Total duration: 22m5s - Times executed: 3 ]
[ Application: psql - Total duration: 22m5s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-16 05:11:28 Duration: 11m26s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-16 05:18:59 Duration: 7m31s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-16 05:22:06 Duration: 3m7s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s431ms 9m11s 2m2s 48 1h37m40s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 16 07 3 9m59s 3m19s 08 3 5m34s 1m51s 09 3 8m12s 2m44s 10 3 6m23s 2m7s 11 3 5m42s 1m54s 12 3 6m10s 2m3s 13 3 5m15s 1m45s 14 3 5m51s 1m57s 15 3 6m3s 2m1s 16 3 5m39s 1m53s 17 3 5m29s 1m49s 18 3 5m25s 1m48s 19 3 5m3s 1m41s 20 3 6m6s 2m2s 21 3 5m35s 1m51s 22 3 5m7s 1m42s [ User: intelifix - Total duration: 1h37m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 07:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 09:12:31 Duration: 7m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-16 10:11:04 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
3 261ms 4m 1m24s 48 1h7m52s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 16 07 3 5m32s 1m50s 08 3 4m4s 1m21s 09 3 4m50s 1m36s 10 3 4m22s 1m27s 11 3 4m21s 1m27s 12 3 4m 1m20s 13 3 4m2s 1m20s 14 3 4m14s 1m24s 15 3 4m11s 1m23s 16 3 4m19s 1m26s 17 3 4m8s 1m22s 18 3 4m 1m20s 19 3 3m53s 1m17s 20 3 4m6s 1m22s 21 3 3m47s 1m15s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h7m52s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m52s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 07:20:22 Duration: 4m Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 11:15:01 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-16 10:15:45 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s423ms 1m3s 33s593ms 4 2m14s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 16 20 2 1m6s 33s471ms 23 2 1m7s 33s715ms [ User: intelifix - Total duration: 2m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-16 23:16:38 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-16 20:08:41 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-16 20:10:39 Duration: 4s826ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 329ms 53s893ms 26s910ms 4 1m47s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 16 20 2 54s255ms 27s127ms 23 2 53s385ms 26s692ms [ User: intelifix - Total duration: 1m47s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m47s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-16 20:05:47 Duration: 53s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-16 23:13:42 Duration: 53s56ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-16 20:10:05 Duration: 362ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 6m29s 20s907ms 203 1h10m44s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 16 07 10 11m53s 1m11s 08 23 1m42s 4s439ms 09 24 7m42s 19s262ms 10 32 18m27s 34s609ms 11 12 1m19s 6s660ms 12 4 18s918ms 4s729ms 13 15 6m34s 26s297ms 14 20 11m8s 33s436ms 15 16 5m53s 22s86ms 16 29 46s393ms 1s599ms 17 10 4m32s 27s261ms 18 7 23s412ms 3s344ms 19 1 1s20ms 1s20ms [ User: intelifix - Total duration: 1h10m44s - Times executed: 203 ]
[ Application: [unknown] - Total duration: 1h10m44s - Times executed: 203 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029955, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 09:43:53 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029929, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 07:26:14 Duration: 6m23s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029958, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-16 10:52:42 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 9s929ms 50s742ms 13s48ms 44 9m34s create table temp0000291561 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 16 07 11 2m37s 14s314ms 08 12 2m10s 10s834ms 09 15 3m9s 12s644ms 10 6 1m36s 16s166ms [ User: intelifix - Total duration: 9m34s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 9m34s - Times executed: 44 ]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 07:16:35 Duration: 50s742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 10:45:43 Duration: 37s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291561 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 09:21:46 Duration: 35s954ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s520ms 13s194ms 11s664ms 12 2m19s create table temp0000291639 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 16 14 7 1m24s 12s101ms 15 5 55s257ms 11s51ms [ User: intelifix - Total duration: 2m19s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m19s - Times executed: 12 ]
-
CREATE TABLE temp0000291639 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:58:39 Duration: 13s194ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291639 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:59:00 Duration: 12s583ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291639 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:38:35 Duration: 12s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s493ms 14s512ms 11s647ms 14 2m43s create table temp0000291585 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 16 08 6 1m4s 10s786ms 09 2 21s917ms 10s958ms 10 3 38s26ms 12s675ms 15 3 38s398ms 12s799ms [ User: intelifix - Total duration: 2m43s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m43s - Times executed: 14 ]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 15:46:35 Duration: 14s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 10:57:44 Duration: 13s215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291585 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 10:58:21 Duration: 12s806ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s535ms 14s829ms 11s138ms 21 3m53s create table temp0000291315 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 16 08 13 2m21s 10s905ms 09 5 54s431ms 10s886ms 14 3 37s707ms 12s569ms [ User: intelifix - Total duration: 3m53s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 3m53s - Times executed: 21 ]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:00:58 Duration: 14s829ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:01:29 Duration: 11s491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-16 14:02:23 Duration: 11s386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 1s252ms 1m16s 7s936ms 74 9m47s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 16 07 2 17s911ms 8s955ms 08 2 4s946ms 2s473ms 09 4 28s981ms 7s245ms 10 9 2m4s 13s888ms 11 9 1m34s 10s487ms 12 6 9s181ms 1s530ms 13 7 40s298ms 5s756ms 14 8 56s200ms 7s25ms 15 6 1m8s 11s435ms 16 12 1m20s 6s666ms 17 9 1m1s 6s861ms [ User: intelifix - Total duration: 9m47s - Times executed: 74 ]
[ Application: [unknown] - Total duration: 9m47s - Times executed: 74 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 10:04:46 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 15:38:39 Duration: 18s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-16', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-16 14:54:24 Duration: 18s573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 206ms 37s557ms 4s416ms 33 2m25s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 16 07 2 40s547ms 20s273ms 08 12 38s104ms 3s175ms 09 5 15s909ms 3s181ms 10 1 18s613ms 18s613ms 14 2 9s164ms 4s582ms 15 1 4s146ms 4s146ms 16 4 6s778ms 1s694ms 18 6 12s464ms 2s77ms [ User: intelifix - Total duration: 2m25s - Times executed: 33 ]
[ Application: psql - Total duration: 2m25s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029929);
Date: 2026-09-16 07:19:46 Duration: 37s557ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029958);
Date: 2026-09-16 10:46:25 Duration: 18s613ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029964);
Date: 2026-09-16 14:39:59 Duration: 8s263ms Database: rio User: intelifix Remote: [local] Application: psql
13 163ms 38s65ms 4s226ms 160 11m16s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 16 00 6 1m3s 10s621ms 01 6 25s360ms 4s226ms 02 6 27s272ms 4s545ms 03 5 28s174ms 5s634ms 04 6 32s560ms 5s426ms 05 5 23s994ms 4s798ms 07 10 49s299ms 4s929ms 08 12 44s316ms 3s693ms 09 11 52s533ms 4s775ms 10 12 56s807ms 4s733ms 11 12 44s834ms 3s736ms 12 12 41s828ms 3s485ms 13 7 8s371ms 1s195ms 14 12 47s50ms 3s920ms 15 11 48s252ms 4s386ms 16 8 24s204ms 3s25ms 17 6 5s136ms 856ms 20 2 1s161ms 580ms 21 5 22s662ms 4s532ms 22 6 28s607ms 4s767ms [ User: intelifix - Total duration: 11m16s - Times executed: 160 ]
[ Application: psql - Total duration: 11m16s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 00:05:39 Duration: 38s65ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 10:15:12 Duration: 11s25ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-16 05:05:12 Duration: 10s531ms Database: rio User: intelifix Remote: [local] Application: psql
14 152ms 16s600ms 3s494ms 40 2m19s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 16 07 4 1s460ms 365ms 08 15 1m21s 5s434ms 09 8 29s760ms 3s720ms 10 3 1s91ms 363ms 14 5 7s830ms 1s566ms 15 3 587ms 195ms 17 2 17s551ms 8s775ms [ User: intelifix - Total duration: 2m19s - Times executed: 40 ]
[ Application: psql - Total duration: 2m19s - Times executed: 40 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029951);
Date: 2026-09-16 09:08:48 Duration: 16s600ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 508); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029940);
Date: 2026-09-16 08:36:12 Duration: 14s317ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 403); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029969);
Date: 2026-09-16 17:29:33 Duration: 13s132ms Database: rio User: intelifix Remote: [local] Application: psql
15 611ms 10s134ms 3s320ms 35 1m56s 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 #15
Day Hour Count Duration Avg duration Sep 16 08 2 8s229ms 4s114ms 09 2 11s857ms 5s928ms 10 3 19s522ms 6s507ms 11 2 12s822ms 6s411ms 12 2 5s396ms 2s698ms 13 2 7s845ms 3s922ms 14 3 11s305ms 3s768ms 15 2 11s618ms 5s809ms 16 3 10s266ms 3s422ms 17 2 7s476ms 3s738ms 18 2 1s527ms 763ms 19 2 1s837ms 918ms 20 2 1s703ms 851ms 21 3 2s508ms 836ms 22 3 2s308ms 769ms [ User: intelifix - Total duration: 1m56s - Times executed: 35 ]
[ Application: psql - Total duration: 1m56s - Times executed: 35 ]
-
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-16 11:20:11 Duration: 10s134ms 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-16 10:00:10 Duration: 8s890ms 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-16 15:40:10 Duration: 8s564ms Database: rio User: intelifix Remote: [local] Application: psql
16 159ms 7s617ms 2s408ms 59 2m22s create table temp0000291619 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 16 13 58 2m21s 2s447ms 15 1 159ms 159ms [ User: intelifix - Total duration: 2m22s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 2m22s - Times executed: 59 ]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:35:16 Duration: 7s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:36:00 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291619 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-09-2026", "ate" :"16-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-16 13:35:31 Duration: 2s485ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 151ms 18s525ms 1s789ms 90 2m41s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 16 07 6 5s489ms 914ms 08 4 2s410ms 602ms 09 6 4s423ms 737ms 10 16 1m8s 4s260ms 11 7 55s341ms 7s905ms 13 5 2s815ms 563ms 14 17 10s688ms 628ms 15 8 2s662ms 332ms 16 21 9s32ms 430ms [ User: intelifix - Total duration: 2m41s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 2m41s - Times executed: 90 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056928) LIMIT 1;
Date: 2026-09-16 10:14:58 Duration: 18s525ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056928) LIMIT 1;
Date: 2026-09-16 11:58:07 Duration: 17s225ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056927) LIMIT 1;
Date: 2026-09-16 10:15:55 Duration: 17s78ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 150ms 1m4s 1s668ms 222 6m10s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 16 00 10 23s517ms 2s351ms 01 9 11s245ms 1s249ms 02 11 11s141ms 1s12ms 03 9 11s745ms 1s305ms 04 10 10s771ms 1s77ms 05 8 10s407ms 1s300ms 06 12 12s503ms 1s41ms 07 8 1m14s 9s353ms 08 8 11s113ms 1s389ms 09 11 15s865ms 1s442ms 10 12 15s94ms 1s257ms 11 9 12s735ms 1s415ms 12 9 11s140ms 1s237ms 13 8 11s517ms 1s439ms 14 11 16s9ms 1s455ms 15 11 12s205ms 1s109ms 16 11 13s418ms 1s219ms 17 9 13s849ms 1s538ms 18 11 11s563ms 1s51ms 19 7 10s864ms 1s552ms 20 9 26s202ms 2s911ms 21 9 11s240ms 1s248ms 22 10 11s352ms 1s135ms [ User: intelifix - Total duration: 6m10s - Times executed: 222 ]
[ Application: psql - Total duration: 6m10s - Times executed: 222 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 07:26:15 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 00:05:51 Duration: 10s997ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-16 20:05:10 Duration: 8s150ms Database: rio User: intelifix Remote: [local] Application: psql
19 568ms 20s494ms 1s589ms 53 1m24s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 16 08 4 4s846ms 1s211ms 09 3 4s521ms 1s507ms 10 3 2s608ms 869ms 11 4 10s253ms 2s563ms 12 4 3s165ms 791ms 13 4 5s80ms 1s270ms 14 3 2s342ms 780ms 15 4 8s934ms 2s233ms 16 3 2s423ms 807ms 17 3 22s903ms 7s634ms 18 4 4s264ms 1s66ms 19 4 2s878ms 719ms 20 4 5s415ms 1s353ms 21 3 2s281ms 760ms 22 3 2s322ms 774ms [ User: intelifix - Total duration: 1m24s - Times executed: 53 ]
[ Application: psql - Total duration: 1m24s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-16 17:40:23 Duration: 20s494ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-16 11:40:09 Duration: 8s111ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-16 15:20:07 Duration: 5s891ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 4s791ms 805ms 1,404 18m50s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 16 07 2 672ms 336ms 08 69 50s849ms 736ms 09 156 2m3s 789ms 10 189 3m2s 966ms 11 180 3m3s 1s21ms 12 42 41s795ms 995ms 13 76 1m11s 940ms 14 194 2m35s 801ms 15 209 2m6s 607ms 16 223 2m32s 683ms 17 64 41s296ms 645ms [ User: intelifix - Total duration: 18m50s - Times executed: 1404 ]
[ Application: [unknown] - Total duration: 18m50s - Times executed: 1404 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (57992, 406, '836051908001689,241730938081,241727040104,241726858390,241728554864,241636039808,241692618696,241704290409,241731214753,241704363547,241622542038,241600967799,241730926161,241695582937,241676730312,241656810927,241695495779,241692689310,241700946479,230049403654,241676676164,241708853536,241676756879,241713690103,241713748895,241653874141,241717160307,241651612529,241622543250,241654350709,241680478803,241601115064,241680013954,241653124966,241646314144,241727490810,241606698303,241713044349,241728649294,241659799007,241731250010,241729485471,241647375471,241680341517,241728718695,241717127575,241731246978,241598860928,241704164358,241689204761', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-16 13:13:36 Duration: 4s791ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287611, 450, '921131014669,582FF79732AA,345D9EB42B1B,44D454C31C6D,582FF700FF4A,E8D2FFAA7651,8CC5B4D855EA,582FF716B67A,841EA3693ED9,D833B7C9AE90,64FD966C9218,B0BBE54BFC64,D833B753CF84,D0CF0EFDE64A,506F0C3B8806,8CFDDE865964,943C96AAF993,D833B71EBD74,345D9EBD7D5F,8CFDDE985E24,CC5830E26D44,6CBAB8F193D2,94988F93D898,44D454C2CC64,582FF7168438,E4C0E23FE4F5,5CFA251695C7,D833B7A35D3B,943C96AA6B2B,94988F95C11E,64FD9653C892,5CFA2515F5CA,64FD96563C1C,582FF78CDDEE,64FD966BCB08,E8D2FF97339D,20B82BF96C8A,D0CF0EFDD2CB,44D45494287F,44D454608DA4', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-16 14:34:33 Duration: 4s313ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287613, 450, 'CP2133LV0PH,ECA81F1FA06C$CP2130LV3KJ,8C6A8DBEB2DC$CP2236LV01F,4075C3B96490$CP2218LV89W,00CB7ADBE2FC$CP2235LV0B4,4075C3B8C828$CP2239LV5PM,4075C3C238F4$CP2239LV35L,4075C3C06B3C$CP2238LV312,4075C3BD8E94$CP2120LV3FG,08A7C06B7194$CP2205LV4PZ,1C9D72859F8C$CP2529LV1ZB,3C82C08E50AC$CP2347LV5FC,400FC17EBFB4$CP2218LV1JT,00CB7ADC6FEC$CP2522LV2EZ,B85E710DB3C0$CP2207LV7WH,3C82C06AAF2C$CP2127LV50Z,08A7C07B4B8C$CP2131LVDAM,ECA81F1CA804$CP2218LV5BT,00CB7ADE5F50$CP2147LV876,D4E2CB92D11C$CP2435LV5RH,C4509CF1B344$CP2120LV4SE,08A7C06C3884$CP2131LV54T,8C6A8DC33BAC$CP2051LV4LD,484BD4A64774$CP2218LV905,00CB7ADDC608$CP2233LV6FJ,4075C3B2DAF8$CP2238LV00C,4075C3BE5414$CP2436LV432,C4509CF17F0C$CP2147LV6LZ,D4E2CB92D794$CP2134LV8PN,ECA81F6AE05C$CP2239LV32N,4075C3C184CC$CP2439LV24A,C4509CF423A4$CP2522LV4JR,B85E710DB8FC$CP2106LV6V8,484BD4B4BC24$CP2522LV0MY,B85E710CA070$CP2248LVKNC,B85E71E34DEC$CP2439LV97H,C4509CF3C4AC$CP2218LV3YZ,00CB7ADDB460$CP2131LV8GM,8C6A8DC352EC$CP2248LVA9J,B85E71E2DE5C$CP2128LV55T,08A7C07AEED4', '',0185,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-16 10:17:22 Duration: 4s91ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 16 19 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 441ms - Times executed: 2 ]
[ Application: psql - Total duration: 441ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,164 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 23 FATAL entries
- 5600 ERROR entries
- 0 WARNING entries
- 7 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,564 Max number of times the same event was reported
- 5,630 Total events found
Rank Times reported Error 1 5,564 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 16 00 164 01 164 02 168 03 149 04 165 05 164 06 169 07 273 08 425 09 462 10 494 11 444 12 241 13 211 14 348 15 394 16 232 17 201 18 120 19 120 20 118 21 120 22 120 23 98 - ERROR: prepared statement "_PLAN0000000029DE96B0" does not exist
- ERROR: prepared statement "_PLAN0000000029C26700" does not exist
- ERROR: prepared statement "_PLAN000000003347D720" does not exist
Statement: DEALLOCATE "_PLAN0000000029DE96B0"
Date: 2026-09-16 00:00:45 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C26700"
Date: 2026-09-16 00:00:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003347D720"
Date: 2026-09-16 00:00:55 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 11 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 16 00 2 03 2 06 3 15 1 16 1 17 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-16 00:02:23 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-16 00:47:39 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-16 03:36:18 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 11 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 16 10 1 11 2 13 2 15 2 16 4 - ERROR: syntax error at or near "CC29BDEB15BD" at character 41
- ERROR: syntax error at or near "]" at character 33
- ERROR: syntax error at or near "]" at character 33
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''CC29BDEB15BD');
Date: 2026-09-16 10:38:54 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(399484])
Date: 2026-09-16 11:31:51 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(399484])
Date: 2026-09-16 11:31:51 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 16 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-16 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-16 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-16 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 6 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 16 07 3 10 3 - ERROR: trailing junk after numeric literal at or near "8W3040906001113" at character 27
- ERROR: trailing junk after numeric literal at or near "8W3040906001113" at character 27
- ERROR: trailing junk after numeric literal at or near "8W3040906001113" at character 27
Statement: SELECT * FROM RS_ETIQUETA(8W3040906001113)
Date: 2026-09-16 07:58:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(8W3040906001113)
Date: 2026-09-16 07:58:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(8W3040906001113)
Date: 2026-09-16 07:58:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 4 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 16 07 1 08 1 10 1 15 1 - LOG: process 3665274 still waiting for AccessExclusiveLock on relation 5052047 of database 358220 after 1000.105 ms
- LOG: process 3681963 still waiting for AccessExclusiveLock on relation 5059874 of database 358220 after 1000.137 ms
- LOG: process 3837939 still waiting for AccessExclusiveLock on relation 5077974 of database 358220 after 1000.131 ms
Detail: Process holding the lock: 3671040. Wait queue: 3665274.
Statement: DROP TABLE IF EXISTS temp0000291561;Date: 2026-09-16 07:19:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3697552. Wait queue: 3681963.
Statement: DROP TABLE IF EXISTS temp0000291585;Date: 2026-09-16 08:34:07 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3856650. Wait queue: 3837939.
Statement: DROP TABLE IF EXISTS temp0000291585;Date: 2026-09-16 10:58:09 Database: rio Application: [unknown] User: intelifix Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 16 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-16 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-16 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-16 05:32:06 Database: contagem Application: psql User: intelifix Remote: [local]
8 4 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 16 07 1 08 1 10 1 15 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000291561"
Date: 2026-09-16 07:19:36
Context: automatic vacuum of table "rio.public.temp0000291585"
Date: 2026-09-16 08:34:07
Context: automatic vacuum of table "rio.public.temp0000291585"
Date: 2026-09-16 10:58:09
9 4 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 16 14 4 - 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,}', 181 ));Date: 2026-09-16 14:41:53 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,}', 181 ));Date: 2026-09-16 14:41:54 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,}', 181 ));Date: 2026-09-16 14:41:55 Database: contagem Application: [unknown] User: intelifix Remote: [local]
10 4 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 16 08 2 11 2 - ERROR: unterminated quoted identifier at or near ""}]}')" at character 171
- ERROR: unterminated quoted identifier at or near ""}]}');" at character 162
- ERROR: unterminated quoted identifier at or near ""}]}');" at character 85
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"286948","seriais":[{"serial":"2102313BFARYN7900981"},{"serial":"ECA1D1F2A6D1"},{"serial":"48575443A68C0BAA"},{"serial":"'"}]}')
Date: 2026-09-16 08:51:06 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"189","seriais":[{"serial":"2102313BFARYN7900981"},{"serial":"ECA1D1F2A6D1"},{"serial":"48575443A68C0BAA"},{"serial":"'"}]}');
Date: 2026-09-16 08:51:06 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"39","seriais":[{"serial":""},{"serial":"'"}]}');
Date: 2026-09-16 11:30:20 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 16 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-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-16 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-16 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 16 09 1 10 1 16 1 - ERROR: column "f200012255b6c75" does not exist at character 27
- ERROR: column "controle" does not exist at character 36
- ERROR: column "a0b53cc3492e" does not exist at character 27
Statement: select * from rs_caixa_qr(F200012255B6C75)
Date: 2026-09-16 09:47:22 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM temp0000227184 WHERE CONTROLE='L'
Date: 2026-09-16 10:34:16 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(A0B53CC3492E)
Date: 2026-09-16 16:21:07 Database: rio Application: [unknown] User: etiquetas Remote: [local]
13 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 16 07 2 - LOG: process 3668517 still waiting for ShareLock on transaction 6154018 after 1000.104 ms
- LOG: process 3668517 still waiting for ShareLock on transaction 6154018 after 5368.925 ms
Detail: Process holding the lock: 3665274. Wait queue: 3668517.
Context: while updating tuple (79968,67) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-16 07:25:16 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3665274. Wait queue: 3668517.
Context: while updating tuple (79968,67) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-16 07:25:20 Database: rio Application: psql User: intelifix Remote: [local]
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 16 03 1 - LOG: database system was shut down at 2026-09-16 03:05:01 -03
Date: 2026-09-16 03:05:02