pgBadger-
Global information
- Generated on Mon Aug 31 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 38,338 log entries in 11s
- Log start from 2026-08-31 00:00:25 to 2026-08-31 23:49:52
-
Overview
Global Stats
- 391 Number of unique normalized queries
- 5,663 Number of queries
- 9h41m24s Total query duration
- 2026-08-31 00:02:54 First query
- 2026-08-31 23:49:28 Last query
- 6 queries/s at 2026-08-31 11:40:04 Query peak
- 9h41m24s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h41m24s Execute total duration
- 3,791 Number of events
- 13 Number of unique normalized events
- 3,724 Max number of times the same event was reported
- 0 Number of cancellation
- 386 Total number of automatic vacuums
- 770 Total number of automatic analyzes
- 13 Number temporary file
- 243.33 MiB Max size of temporary file
- 104.05 MiB Average size of temporary file
- 347 Total number of sessions
- 8 sessions at 2026-08-31 21:10:18 Session peak
- 12d17h6m28s Total duration of sessions
- 52m45s Average duration of sessions
- 16 Average queries per session
- 1m40s Average queries duration per session
- 51m4s Average idle time per session
- 376 Total number of connections
- 4 connections/s at 2026-08-31 08:31:13 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-08-31 11:40:04 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-31 10:04:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-31 20:10:34 Date
Queries duration
Key values
- 9h41m24s 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) Aug 31 00 23 0ms 52s391ms 9s447ms 52s391ms 1m27s 1m27s 01 12 0ms 4s922ms 2s493ms 5s189ms 5s189ms 5s189ms 02 12 0ms 5s725ms 2s630ms 5s984ms 5s984ms 5s984ms 03 14 0ms 6s594ms 2s528ms 8s879ms 8s879ms 8s879ms 04 12 0ms 6s249ms 2s713ms 6s604ms 6s604ms 6s604ms 05 17 0ms 11m2s 1m23s 7m1s 11m2s 11m2s 06 21 0ms 48s503ms 6s995ms 40s786ms 48s503ms 48s503ms 07 208 0ms 17m11s 8s872ms 28s792ms 2m37s 17m11s 08 496 0ms 9m54s 5s896ms 2m 5m39s 10m13s 09 760 150ms 11m44s 3s909ms 1m20s 4m33s 12m11s 10 653 0ms 11m50s 4s410ms 1m5s 8m17s 11m54s 11 472 0ms 7m23s 5s612ms 2m 5m20s 9m3s 12 157 0ms 8m28s 6s574ms 16s123ms 1m15s 8m40s 13 368 0ms 6m20s 3s490ms 43s229ms 1m8s 6m57s 14 525 150ms 8m5s 3s15ms 32s168ms 1m59s 8m55s 15 681 150ms 31m8s 9s488ms 2m41s 7m48s 54m26s 16 413 0ms 9m17s 3s494ms 26s622ms 1m35s 9m59s 17 214 0ms 6m19s 5s88ms 27s256ms 41s181ms 6m54s 18 31 0ms 6m2s 22s405ms 6s163ms 26s480ms 6m55s 19 24 0ms 5m49s 26s249ms 5s642ms 47s569ms 5m49s 20 132 0ms 8m5s 12s263ms 1m27s 1m58s 9m2s 21 38 0ms 7m42s 21s233ms 11s480ms 49s920ms 7m42s 22 30 0ms 5m42s 23s177ms 9s298ms 49s19ms 5m42s 23 350 0ms 1m44s 6s737ms 1m6s 1m12s 2m32s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 31 00 3 0 27s107ms 0ms 28s930ms 52s391ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 6 0 13s354ms 1s892ms 29s727ms 48s503ms 07 149 0 10s990ms 5s85ms 17s338ms 4m7s 08 377 0 6s169ms 11s751ms 2m 5m59s 09 617 0 3s828ms 20s330ms 48s500ms 8m42s 10 542 0 4s357ms 17s882ms 32s373ms 10m10s 11 386 0 5s830ms 16s603ms 2m 7m26s 12 118 0 7s828ms 3s736ms 8s909ms 3m44s 13 248 0 4s201ms 9s697ms 31s395ms 3m40s 14 427 0 3s212ms 13s771ms 25s765ms 4m37s 15 515 0 11s432ms 44s913ms 2m11s 8m46s 16 332 0 3s791ms 9s951ms 17s307ms 4m7s 17 153 0 6s564ms 11s564ms 27s256ms 3m33s 18 12 0 52s616ms 0ms 0ms 3m27s 19 6 0 1m38s 0ms 0ms 3m13s 20 20 90 14s34ms 44s751ms 1m27s 4m18s 21 14 0 50s977ms 0ms 562ms 3m16s 22 6 0 1m45s 0ms 0ms 3m58s 23 25 325 6s737ms 1m3s 1m6s 2m30s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 31 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 Aug 31 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 11 11.00 0.00% 08 0 26 26.00 0.00% 09 0 23 23.00 0.00% 10 0 20 20.00 0.00% 11 0 19 19.00 0.00% 12 0 4 4.00 0.00% 13 0 12 12.00 0.00% 14 0 15 15.00 0.00% 15 0 23 23.00 0.00% 16 0 14 14.00 0.00% 17 0 7 7.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Aug 31 00 15 0.00/s 01 3 0.00/s 02 9 0.00/s 03 11 0.00/s 04 6 0.00/s 05 6 0.00/s 06 13 0.00/s 07 18 0.01/s 08 26 0.01/s 09 27 0.01/s 10 23 0.01/s 11 22 0.01/s 12 14 0.00/s 13 23 0.01/s 14 22 0.01/s 15 26 0.01/s 16 22 0.01/s 17 14 0.00/s 18 12 0.00/s 19 10 0.00/s 20 11 0.00/s 21 14 0.00/s 22 12 0.00/s 23 17 0.00/s Day Hour Count Average Duration Average idle time Aug 31 00 6 56m 55m24s 01 12 1h1m 1h58s 02 3 1h 59m49s 03 11 19m6s 19m3s 04 5 1h1m12s 1h1m5s 05 5 1h36s 55m52s 06 6 55m51s 55m27s 07 15 55m20s 53m17s 08 18 50m25s 47m43s 09 23 55m24s 53m15s 10 28 54m17s 52m35s 11 25 48m49s 47m3s 12 18 54m47s 53m50s 13 13 53m1s 51m22s 14 22 54m17s 53m5s 15 22 51m55s 47m1s 16 24 51m57s 50m57s 17 19 1h36s 59m38s 18 14 1h 59m10s 19 12 56m4s 55m11s 20 12 45m59s 43m44s 21 9 54m43s 53m14s 22 11 1h16s 59m13s 23 14 37m6s 34m17s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-08-31 08:31:13 Date
Connections per database
Key values
- rio Main Database
- 376 connections Total
Connections per user
Key values
- intelifix Main User
- 376 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-31 21:10:18 Date
Histogram of session times
Key values
- 272 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 347 sessions Total
Sessions per user
Key values
- intelifix Main User
- 347 sessions Total
Sessions per host
Key values
- [local] Main Host
- 347 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 20,231 buffers Checkpoint Peak
- 2026-08-31 15:44:40 Date
- 270.029 seconds Highest write time
- 0.154 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-08-31 15:44:40 Date
Checkpoints distance
Key values
- 399.62 Mo Distance Peak
- 2026-08-31 15:34:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 31 00 20,503 538.781s 0.075s 538.901s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.034s 0.003s 0.056s 04 0 0s 0s 0s 05 7,600 762.053s 0.177s 762.284s 06 4,610 461.87s 0.013s 461.894s 07 9,839 991.599s 0.151s 991.814s 08 51,550 3,045.899s 0.342s 3,046.346s 09 44,166 3,233.178s 0.306s 3,233.645s 10 52,384 3,194.396s 0.408s 3,194.925s 11 66,970 3,238.796s 0.485s 3,239.416s 12 18,830 1,809.908s 0.302s 1,810.342s 13 21,156 2,126.443s 0.359s 2,126.911s 14 40,479 3,113.253s 0.379s 3,113.751s 15 111,129 3,142.524s 0.701s 3,143.485s 16 36,504 2,917.027s 0.343s 2,917.546s 17 17,799 1,742.945s 0.188s 1,743.307s 18 1,272 127.662s 0.184s 127.875s 19 23 2.319s 0.012s 2.339s 20 1,674 169.573s 0.066s 169.655s 21 2,678 268.306s 0.214s 268.644s 22 2,124 212.855s 0.096s 213.05s 23 380 38.173s 0.2s 38.419s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 31 00 0 0 6 66 0.059s 0.004s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.002s 0.001s 04 0 0 0 0 0s 0s 05 0 0 3 157 0.062s 0.013s 06 0 0 1 33 0.010s 0.002s 07 0 0 3 2,104 0.062s 0.011s 08 0 0 34 4,757 0.063s 0.012s 09 0 0 28 6,318 0.027s 0.012s 10 0 0 32 5,350 0.062s 0.012s 11 0 0 43 6,232 0.063s 0.012s 12 0 0 6 2,553 0.061s 0.012s 13 0 0 10 5,386 0.063s 0.012s 14 0 0 16 5,763 0.036s 0.012s 15 0 0 81 7,560 0.051s 0.012s 16 0 0 13 5,388 0.061s 0.012s 17 0 0 9 3,294 0.013s 0.012s 18 0 0 0 149 0.068s 0.017s 19 0 0 0 3 0.011s 0.004s 20 0 0 1 87 0.059s 0.009s 21 0 0 1 441 0.081s 0.015s 22 0 0 0 406 0.063s 0.012s 23 0 0 1 90 0.114s 0.022s Day Hour Count Avg time (sec) Aug 31 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 Aug 31 00 32,780.00 kB 32,996.67 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 28,521.00 kB 04 0.00 kB 0.00 kB 05 6,720.29 kB 9,840.57 kB 06 7,825.50 kB 10,991.00 kB 07 5,357.00 kB 9,504.00 kB 08 45,660.92 kB 66,111.67 kB 09 38,819.75 kB 94,906.83 kB 10 42,550.25 kB 82,564.17 kB 11 58,832.67 kB 127,766.17 kB 12 8,498.00 kB 56,852.75 kB 13 14,118.83 kB 25,645.33 kB 14 21,418.25 kB 42,789.83 kB 15 110,928.08 kB 156,685.50 kB 16 18,239.58 kB 99,857.17 kB 17 11,251.92 kB 37,792.25 kB 18 778.43 kB 16,205.71 kB 19 184.00 kB 10,495.00 kB 20 4,885.67 kB 9,696.00 kB 21 1,694.38 kB 6,270.38 kB 22 1,582.00 kB 3,815.86 kB 23 218.83 kB 2,254.67 kB -
Temporary Files
Size of temporary files
Key values
- 486.66 MiB Temp Files size Peak
- 2026-08-31 05:32:02 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-31 05:32:10 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 31 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 104.05 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 1 104.00 MiB 104.00 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 945.47 MiB 72.58 MiB 243.33 MiB 118.18 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-31 05:32:11 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-31 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 303.18 MiB 56.35 MiB 92.73 MiB 75.79 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-31 05:30:43 Duration: 40s319ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-31 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:48 Duration: 31m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:51 Duration: 17m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-31 08:20:36 Duration: 9m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 243.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 243.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-31 15:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 92.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-31 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 92.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-31 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.31 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 80.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 72.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-31 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 61.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-31 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 56.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-31 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 24.09 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database contagem - 2026-08-31 15:40:20 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 24.09 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database contagem - 2026-08-31 15:40:20 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (91) Main table analyzed (database rio)
- 770 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 91 rio.pg_catalog.pg_class 44 rio.public.usuarios 43 rio.public.temp0000290046 41 rio.pg_catalog.pg_type 36 contagem.public.temp0000227003 34 brasilia.pg_catalog.pg_attribute 32 rio.public.temp0000290114 27 contagem.pg_catalog.pg_attribute 27 contagem.public.temp0000227005 23 rio.pg_catalog.pg_index 22 rio.public.temp0000290088 20 contagem.pg_catalog.pg_class 20 brasilia.pg_catalog.pg_class 17 rio.pg_catalog.pg_depend 16 brasilia.pg_catalog.pg_type 16 contagem.public.temp0000227007 15 contagem.pg_catalog.pg_type 15 rio.public.temp0000290158 12 brasilia.pg_catalog.pg_index 11 contagem.public.temp0000227013 10 brasilia.pg_catalog.pg_depend 9 contagem.pg_catalog.pg_index 9 rio.public.temp0000290058 9 contagem.public.usuarios 9 brasilia.public.temp0000239240 9 contagem.public.temp0000227017 8 rio.public.temp0000290178 7 rio.public.temp0000290024 7 contagem.pg_catalog.pg_depend 7 rio.public.temp0000290026 6 rio.public.temp0000290054 6 brasilia.public.usuarios 6 rio.public.temp0000290106 6 rio.public.tmp_drill_0175 4 rio.public.temp0000290140 4 rio.public.temp0000290176 4 contagem.public.temp0000227021 4 rio.public.temp0000290172 4 brasilia.public.temp0000239254 4 brasilia.public.temp0000239248 3 rio.public.temp0000290124 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000290152 3 rio.public.temp0000290162 3 rio.public.temp0000290074 3 brasilia.public.nf_entrada 3 rio.public.temp0000290060 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000290168 2 brasilia.public.temp0000239210 2 rio.public.tmp_drill_0302 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000290028 2 brasilia.public.temp0000239196 2 brasilia.public.temp0000239244 2 rio.public.temp0000290118 2 brasilia.public.temp0000239220 2 rio.public.temp0000290154 2 brasilia.public.temp0000239274 1 rio.public.temp0000290036 1 brasilia.public.temp0000239216 1 contagem.public.temp0000227025 1 rio.public.temp0000290064 1 rio.public.tmp_drill_0320 1 contagem.public.temp0000227019 1 rio.public.temp0000290136 1 rio.public.temp0000290160 1 rio.public.temp0000290182 1 rio.public.temp0000290170 1 rio.public.temp0000290120 1 rio.public.temp0000290082 1 rio.public.temp0000290052 1 contagem.public.nf_entrada 1 brasilia.public.temp0000239198 1 rio.public.temp0000290050 1 brasilia.public.temp0000239204 1 rio.public.temp0000290126 1 brasilia.public.temp0000239200 1 brasilia.public.temp0000239230 1 brasilia.public.temp0000239236 1 brasilia.public.temp0000239264 1 rio.public.temp0000290066 1 brasilia.public.temp0000239226 1 rio.public.temp0000290042 1 contagem.pg_catalog.pg_shdepend 1 rio.public.temp0000290132 1 rio.public.temp0000290094 1 Total 770 Vacuums per table
Key values
- pg_catalog.pg_attribute (55) Main table vacuumed on database rio
- 386 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 55 29 0 0 0 0 0 15,216 4,259 6,432,315 214 5,953 rio.public.usuarios 39 8 0 0 0 0 0 257 103 234,802 15 25 rio.pg_catalog.pg_class 26 14 0 0 0 0 0 2,440 806 1,298,177 53 200 rio.pg_catalog.pg_type 17 13 0 0 0 0 0 1,117 395 517,328 37 128 rio.public.tmp_drill_0175 16 3 0 0 0 0 0 858 60 201,799 1 49 rio.public.temp0000290046 15 0 0 0 0 0 0 19,450 1,819 3,432,398 0 0 brasilia.pg_catalog.pg_attribute 13 12 0 0 0 0 0 7,176 1,422 2,552,015 52 1,438 postgres.pg_catalog.pg_shdepend 12 4 0 0 0 0 0 574 202 365,117 25 69 contagem.public.usuarios 10 0 0 0 0 0 0 40 31 20,303 0 0 rio.pg_catalog.pg_shdepend 9 0 0 0 0 0 0 20 17 28,276 0 0 brasilia.pg_catalog.pg_shdepend 9 1 0 0 0 0 0 99 32 67,234 2 4 rio.public.temp0000290114 9 0 0 0 0 0 0 2,034 113 244,313 0 0 contagem.pg_catalog.pg_attribute 9 9 0 0 0 0 0 5,056 1,359 2,400,636 18 421 contagem.pg_catalog.pg_shdepend 8 0 0 0 0 0 0 1 1 2,311 0 0 brasilia.pg_catalog.pg_type 7 6 0 0 0 0 0 723 149 245,898 15 44 brasilia.pg_catalog.pg_class 7 6 0 0 0 0 0 1,815 347 627,975 26 89 rio.pg_catalog.pg_index 7 7 0 0 0 0 0 305 104 129,985 19 58 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 7,982 2,082 9,143,064 1,187 6,006 rio.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,953 790 1,101,503 51 444 contagem.pg_catalog.pg_depend 5 4 0 0 0 0 0 1,006 279 624,878 5 36 rio.public.temp0000290158 5 0 0 0 0 0 0 211 27 16,715 0 0 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 1,015 230 392,993 12 36 rio.public.temp0000290106 5 0 0 0 0 0 0 5,309 18 316,116 0 0 rio.public.temp0000290058 5 0 0 0 0 0 0 187 66 79,974 0 0 contagem.pg_catalog.pg_index 5 4 0 0 0 0 0 160 35 54,677 3 5 brasilia.public.nf_entrada 4 2 0 0 0 0 0 347 90 285,695 5 7 rio.public.temp0000290088 4 0 0 0 0 0 0 184 24 14,137 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,291 261 485,422 11 120 rio.public.temp0000290026 4 0 0 0 0 0 0 99 21 9,089 0 0 contagem.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,317 751 3,007,417 434 2,867 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 411 112 187,967 5 14 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 278 50 55,390 7 22 rio.public.temp0000290162 3 0 0 0 0 0 0 12 9 2,322 0 0 contagem.public.temp0000227021 3 0 0 0 0 0 0 232 17 16,507 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,401 386 1,902,539 122 296 rio.public.temp0000290024 3 0 0 0 0 0 0 195 17 14,137 0 0 rio.public.temp0000290124 3 0 0 0 0 0 0 152 79 85,102 0 0 brasilia.public.temp0000239254 3 0 0 0 0 0 0 747 12 45,882 0 0 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 70 6 16,862 0 0 rio.public.temp0000290074 2 0 0 0 0 0 0 118 12 8,666 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 237 55 268,880 11 21 brasilia.public.temp0000239248 2 0 0 0 0 0 0 253 7 16,068 0 0 rio.public.temp0000290168 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.public.temp0000290154 2 0 0 0 0 0 0 1,771 7 105,630 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 233 97 134,664 23 41 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,404 483 2,118,080 377 2,744 brasilia.public.temp0000239220 2 0 0 0 0 0 0 498 8 30,588 0 0 rio.public.tmp_drill_0320 1 1 0 0 0 0 0 45 3 10,894 0 0 rio.public.temp0000290160 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000290054 1 0 0 0 0 0 0 61 6 4,455 0 0 rio.public.temp0000290120 1 0 0 0 0 0 0 92 6 6,339 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 126 27 95,708 7 21 brasilia.public.temp0000239274 1 0 0 0 0 0 0 249 4 15,294 0 0 brasilia.public.temp0000239210 1 0 0 0 0 0 0 249 4 15,294 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 60,260 56,748 70,749,683 1,758 42,052 brasilia.public.temp0000239230 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000239200 1 0 0 0 0 0 0 249 4 15,294 0 0 rio.public.temp0000290172 1 0 0 0 0 0 0 94 6 6,450 0 0 brasilia.public.temp0000239226 1 0 0 0 0 0 0 4 4 1,717 0 0 Total 386 168 0 0 0 0 0 152,699 74,074 110,266,070 4,495 63,210 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (24.09) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.34 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.71 rio.pg_catalog.pg_type 0 0 0.33 rio.public.tmp_drill_0175 0 0 0.04 rio.public.temp0000290046 0 0 0.8 brasilia.pg_catalog.pg_attribute 0 0 1.63 postgres.pg_catalog.pg_shdepend 0 0 0.76 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.14 rio.public.temp0000290114 0 0 0.17 contagem.pg_catalog.pg_attribute 0 0 1.63 contagem.pg_catalog.pg_shdepend 0 0 0 brasilia.pg_catalog.pg_type 0 0 0.22 brasilia.pg_catalog.pg_class 0 0 0.35 rio.pg_catalog.pg_index 0 0 0.53 rio.pg_catalog.pg_statistic 0 0 1.67 rio.pg_catalog.pg_depend 0 0 1.45 contagem.pg_catalog.pg_depend 0 0 0.76 rio.public.temp0000290158 0 0 0.04 contagem.pg_catalog.pg_class 0 0 0.9 rio.public.temp0000290106 0 0 0.25 rio.public.temp0000290058 0 0 0.03 contagem.pg_catalog.pg_index 0 0 0.25 brasilia.public.nf_entrada 0 0 0.11 rio.public.temp0000290088 0 0 0.01 brasilia.pg_catalog.pg_depend 0 0 0.39 rio.public.temp0000290026 0 0 0.04 contagem.pg_catalog.pg_statistic 0 0 0.75 contagem.pg_catalog.pg_type 0 0 0.56 brasilia.pg_catalog.pg_index 0 0 0.09 rio.public.temp0000290162 0 0 0.15 contagem.public.temp0000227021 0 0 0.03 rio.pg_toast.pg_toast_2619 0 0 0.37 rio.public.temp0000290024 0 0 0.02 rio.public.temp0000290124 0 0 0.03 brasilia.public.temp0000239254 0 0 0 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000290074 0 0 0.02 brasilia.pg_toast.pg_toast_2619 0 0 0.04 brasilia.public.temp0000239248 0 0 0.01 rio.public.temp0000290168 0 0 0.11 rio.public.temp0000290154 0 0 0.09 contagem.public.nf_entrada 0 0 0.14 brasilia.pg_catalog.pg_statistic 0 0 0.4 brasilia.public.temp0000239220 0 0 0.01 rio.public.tmp_drill_0320 0 0 0 rio.public.temp0000290160 0 0 0.06 rio.public.temp0000290054 0 0 0.01 rio.public.temp0000290120 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000239274 0 0 0 brasilia.public.temp0000239210 0 0 0 contagem.auditor.auditor_2026_08 0 0 24.09 brasilia.public.temp0000239230 0 0 0 brasilia.public.temp0000239200 0 0 0 rio.public.temp0000290172 0 0 0.01 brasilia.public.temp0000239226 0 0 0 Total 0 0 43.55 Tuples removed per table
Key values
- pg_catalog.pg_attribute (114424) Main table with removed tuples on database rio
- 333741 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 55 29 114,424 1,484,053 229,821 91 33,573 brasilia.pg_catalog.pg_attribute 13 12 71,205 294,468 6,735 264 7,956 contagem.pg_catalog.pg_attribute 9 9 38,616 216,598 0 214 4,940 brasilia.pg_catalog.pg_depend 4 4 15,073 72,184 0 0 724 rio.public.tmp_drill_0175 16 3 11,782 39,298 13,286 0 674 rio.pg_catalog.pg_statistic 6 6 10,941 49,486 579 0 7,716 brasilia.pg_catalog.pg_class 7 6 10,542 29,535 1,581 53 1,121 rio.pg_catalog.pg_depend 6 6 7,785 114,625 96 0 1,098 contagem.pg_catalog.pg_statistic 4 4 7,263 31,468 0 0 4,044 contagem.pg_catalog.pg_depend 5 4 5,874 98,274 9,410 0 925 postgres.pg_catalog.pg_shdepend 12 4 5,405 188,498 25,388 0 1,467 brasilia.pg_catalog.pg_statistic 2 2 5,138 15,293 0 0 2,144 brasilia.pg_catalog.pg_type 7 6 4,536 16,177 638 17 509 contagem.pg_catalog.pg_class 5 5 4,202 18,145 0 0 719 contagem.public.nf_entrada 2 2 3,299 5,372 3,290 0 158 brasilia.public.nf_entrada 4 2 3,047 23,777 1,946 0 608 rio.pg_catalog.pg_type 17 13 2,873 41,421 2,674 0 1,173 rio.pg_catalog.pg_class 26 14 2,523 105,757 14,894 0 3,120 brasilia.pg_catalog.pg_index 4 4 2,341 7,528 0 22 222 contagem.pg_catalog.pg_type 4 4 1,718 9,020 0 0 267 rio.pg_catalog.pg_index 7 7 1,071 13,952 473 0 368 rio.pg_toast.pg_toast_2619 3 3 918 1,865 23 0 768 contagem.pg_catalog.pg_index 5 4 836 10,955 1,451 0 272 rio.public.usuarios 39 8 655 27,399 7,548 0 819 contagem.public.usuarios 10 0 591 240 0 0 20 rio.public.tmp_drill_0320 1 1 502 502 0 0 14 brasilia.pg_catalog.pg_shdepend 9 1 319 148,807 26,386 0 1,114 brasilia.pg_toast.pg_toast_2619 2 2 162 263 0 0 118 contagem.pg_toast.pg_toast_2619 1 1 100 117 0 0 53 rio.public.tmp_drill_0302 2 2 0 866 0 0 24 rio.pg_catalog.pg_shdepend 9 0 0 150,530 28,107 0 1,121 rio.public.temp0000290160 1 0 0 24,960 0 0 1,792 rio.public.temp0000290054 1 0 0 2,347 0 11 53 rio.public.temp0000290120 1 0 0 3,731 0 44 84 rio.public.temp0000290162 3 0 0 74,886 0 0 5,376 rio.public.temp0000290046 15 0 0 374,184 0 0 26,880 rio.public.temp0000290074 2 0 0 4,522 0 26 102 contagem.public.temp0000227021 3 0 0 4,043 0 72 312 brasilia.public.temp0000239274 1 0 0 3,274 0 0 256 rio.public.temp0000290114 9 0 0 72,896 0 379 4,101 rio.public.temp0000290088 4 0 0 6,804 0 40 152 brasilia.public.temp0000239248 2 0 0 6,548 0 0 512 rio.public.temp0000290158 5 0 0 18,095 0 233 407 rio.public.temp0000290026 4 0 0 11,722 0 185 263 rio.public.temp0000290168 2 0 0 49,925 0 0 3,584 rio.public.temp0000290024 3 0 0 11,296 0 131 253 rio.public.temp0000290124 3 0 0 5,946 0 64 128 brasilia.public.temp0000239210 1 0 0 3,268 0 0 256 contagem.pg_catalog.pg_shdepend 8 0 0 134,303 25,479 0 1,000 brasilia.public.temp0000239254 3 0 0 9,816 0 0 768 rio.public.temp0000290154 2 0 0 49,910 0 0 3,584 contagem.auditor.auditor_2026_08 1 0 0 4,120,597 0 0 184,464 rio.public.temp0000290106 5 0 0 124,749 0 0 8,960 rio.public.temp0000290058 5 0 0 14,150 0 195 317 brasilia.public.temp0000239230 1 0 0 3,268 0 0 256 brasilia.public.temp0000239200 1 0 0 3,268 0 0 256 rio.public.temp0000290172 1 0 0 3,805 0 42 86 brasilia.public.temp0000239220 2 0 0 6,536 0 0 512 brasilia.public.temp0000239226 1 0 0 3,272 0 0 256 Total 386 168 333,741 8,368,594 399,805 2,083 322,819 Pages removed per table
Key values
- public.temp0000290114 (379) Main table with removed pages on database rio
- 2083 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000290114 9 0 0 379 brasilia.pg_catalog.pg_attribute 13 12 71205 264 rio.public.temp0000290158 5 0 0 233 contagem.pg_catalog.pg_attribute 9 9 38616 214 rio.public.temp0000290058 5 0 0 195 rio.public.temp0000290026 4 0 0 185 rio.public.temp0000290024 3 0 0 131 rio.pg_catalog.pg_attribute 55 29 114424 91 contagem.public.temp0000227021 3 0 0 72 rio.public.temp0000290124 3 0 0 64 brasilia.pg_catalog.pg_class 7 6 10542 53 rio.public.temp0000290120 1 0 0 44 rio.public.temp0000290172 1 0 0 42 rio.public.temp0000290088 4 0 0 40 rio.public.temp0000290074 2 0 0 26 brasilia.pg_catalog.pg_index 4 4 2341 22 brasilia.pg_catalog.pg_type 7 6 4536 17 rio.public.temp0000290054 1 0 0 11 rio.public.tmp_drill_0302 2 2 0 0 rio.pg_catalog.pg_shdepend 9 0 0 0 brasilia.pg_catalog.pg_shdepend 9 1 319 0 rio.public.tmp_drill_0320 1 1 502 0 contagem.pg_catalog.pg_depend 5 4 5874 0 rio.public.temp0000290160 1 0 0 0 rio.public.temp0000290162 3 0 0 0 rio.public.temp0000290046 15 0 0 0 brasilia.public.nf_entrada 4 2 3047 0 contagem.pg_toast.pg_toast_2619 1 1 100 0 brasilia.public.temp0000239274 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 162 0 rio.public.tmp_drill_0175 16 3 11782 0 brasilia.pg_catalog.pg_depend 4 4 15073 0 rio.pg_catalog.pg_type 17 13 2873 0 brasilia.public.temp0000239248 2 0 0 0 contagem.pg_catalog.pg_class 5 5 4202 0 rio.pg_toast.pg_toast_2619 3 3 918 0 rio.public.temp0000290168 2 0 0 0 brasilia.public.temp0000239210 1 0 0 0 rio.pg_catalog.pg_statistic 6 6 10941 0 rio.public.usuarios 39 8 655 0 contagem.pg_catalog.pg_statistic 4 4 7263 0 contagem.pg_catalog.pg_shdepend 8 0 0 0 postgres.pg_catalog.pg_shdepend 12 4 5405 0 brasilia.public.temp0000239254 3 0 0 0 rio.public.temp0000290154 2 0 0 0 contagem.pg_catalog.pg_type 4 4 1718 0 contagem.auditor.auditor_2026_08 1 0 0 0 contagem.public.nf_entrada 2 2 3299 0 rio.public.temp0000290106 5 0 0 0 contagem.pg_catalog.pg_index 5 4 836 0 brasilia.public.temp0000239230 1 0 0 0 brasilia.public.temp0000239200 1 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 5138 0 rio.pg_catalog.pg_index 7 7 1071 0 brasilia.public.temp0000239220 2 0 0 0 rio.pg_catalog.pg_class 26 14 2523 0 contagem.public.usuarios 10 0 591 0 rio.pg_catalog.pg_depend 6 6 7785 0 brasilia.public.temp0000239226 1 0 0 0 Total 386 168 333,741 2,083 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 31 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 6 16 08 15 70 09 24 98 10 22 69 11 53 68 12 2 11 13 23 85 14 15 81 15 185 162 16 26 76 17 9 30 18 0 0 19 0 0 20 0 0 21 0 3 22 0 0 23 0 1 - 24.09 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 6 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 22m44s 3s179ms 17m13s 7m34s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:51 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-31 08:20:36 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 2 3m57s 1m39s 2m17s 1m58s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 09:57:48 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 10:46:56 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 00:05:35 Database: rio User: intelifix Remote: [local] Application: psql
3 1 5s430ms 5s430ms 5s430ms 5s430ms select * from rs_lote_manutencao (?);-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"156", "usuario" :"413", "tipo" :"N", "itens" :"08", "nota-fiscal" :"11486", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-31 15:37:41 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"151", "usuario" :"413", "tipo" :"N", "itens" :"05", "nota-fiscal" :"11486", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-31 10:56:04 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-31 08:20:56 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 17m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-31 15:45:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 5m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-31 15:45:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 2m17s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-31 09:57:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 1m39s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-31 10:46:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 5s430ms SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"156", "usuario" :"413", "tipo" :"N", "itens" :"08", "nota-fiscal" :"11486", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');[ Date: 2026-08-31 15:37:41 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
6 3s179ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-31 15:45:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,956 Total read queries
- 1,203 Total write queries
Queries by database
Key values
- rio Main database
- 3,507 Requests
- 7h25m41s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,470 Requests
User Request type Count Duration etiquetas Total 84 23s354ms select 84 23s354ms intelifix Total 5,470 9h37m36s copy to 415 50m38s ddl 788 36m11s others 504 1h56s select 3,763 7h9m49s lenon Total 109 3m24s select 109 3m24s Duration by user
Key values
- 9h37m36s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 84 23s354ms select 84 23s354ms intelifix Total 5,470 9h37m36s copy to 415 50m38s ddl 788 36m11s others 504 1h56s select 3,763 7h9m49s lenon Total 109 3m24s select 109 3m24s Queries by host
Key values
- [local] Main host
- 5,663 Requests
- 9h41m24s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,546 Requests
- 4h50m34s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-31 18:05:28 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,495 100-500ms duration
Slowest individual queries
Rank Duration Query 1 31m8s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-31 15:45:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 17m17s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-31 15:45:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 17m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 07:22:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 11m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 10:16:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 11m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 09:16:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 11m2s analyze verbose;[ Date: 2026-08-31 05:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 9m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-31 08:20:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 9m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 16:14:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 15:13:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 8m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 12:13:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 8m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029265, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-31 09:57:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 8m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 14:13:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 8m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 20:13:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 7m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 21:12:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029282, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-31 15:41:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 11:12:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 7m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029271, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-31 11:19:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 7m1s analyze verbose;[ Date: 2026-08-31 05:18:04 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
19 6m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 13:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 6m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-31 17:11:20 - 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 2h22m33s 48 1s554ms 17m11s 2m58s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 31 07 3 18m22s 6m7s 08 3 6m27s 2m9s 09 3 12m21s 4m7s 10 3 12m14s 4m4s 11 3 7m47s 2m35s 12 3 8m52s 2m57s 13 3 6m44s 2m14s 14 3 8m40s 2m53s 15 3 9m20s 3m6s 16 3 9m47s 3m15s 17 3 6m39s 2m13s 18 3 6m22s 2m7s 19 3 6m7s 2m2s 20 3 8m42s 2m54s 21 3 8m 2m40s 22 3 6m1s 2m [ User: intelifix - Total duration: 2h22m33s - Times executed: 48 ]
[ Application: psql - Total duration: 2h22m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-31 07:22:12 Duration: 17m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-31 10:16:51 Duration: 11m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-31 09:16:46 Duration: 11m44s Database: rio User: intelifix Remote: [local] Application: psql
2 2h16m13s 201 151ms 31m8s 40s663ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 31 08 18 22m27s 1m14s 09 41 11m4s 16s198ms 10 23 14m32s 37s941ms 11 17 14m4s 49s676ms 12 1 292ms 292ms 13 14 34s155ms 2s439ms 14 31 46s179ms 1s489ms 15 42 1h11m28s 1m42s 16 4 6s285ms 1s571ms 17 9 1m3s 7s83ms 18 1 5s955ms 5s955ms [ User: intelifix - Total duration: 2h16m13s - Times executed: 201 ]
[ Application: [unknown] - Total duration: 2h16m13s - Times executed: 201 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:48 Duration: 31m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:51 Duration: 17m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-31 08:20:36 Duration: 9m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h13m35s 48 238ms 4m16s 1m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 31 07 3 6m47s 2m15s 08 3 4m13s 1m24s 09 3 5m1s 1m40s 10 3 4m49s 1m36s 11 3 4m11s 1m23s 12 3 4m27s 1m29s 13 3 4m10s 1m23s 14 3 4m58s 1m39s 15 3 4m49s 1m36s 16 3 4m35s 1m31s 17 3 4m4s 1m21s 18 3 4m 1m20s 19 3 3m43s 1m14s 20 3 5m24s 1m48s 21 3 3m48s 1m16s 22 3 4m29s 1m29s [ User: intelifix - Total duration: 1h13m35s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m35s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-31 14:18:38 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-31 20:19:02 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-31 15:19:07 Duration: 4m6s Database: brasilia User: intelifix Remote: [local] Application: psql
4 23m50s 987 150ms 13s57ms 1s448ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 31 08 34 55s994ms 1s646ms 09 210 3m37s 1s37ms 10 156 3m29s 1s341ms 11 121 3m7s 1s553ms 12 41 1m21s 1s984ms 13 72 1m41s 1s414ms 14 97 2m26s 1s506ms 15 80 2m32s 1s900ms 16 114 3m3s 1s612ms 17 62 1m33s 1s511ms [ User: intelifix - Total duration: 23m50s - Times executed: 987 ]
[ Application: [unknown] - Total duration: 23m50s - Times executed: 987 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282316, 450, '831343949003608,229915935162,229900617595,229900982435,229902113645,229895225767,229895263852,229895871016,229896001433,229876247091,229896001130,229895988805,229895998200,229892714254,229909086682,229911749501,229886013948,229871526574,229913936280,229909085773,229909699200,229897902325,229897234246,229893731840,229897969907,229920771729,229898315171,229893645669,229909732436,229910277999,229876552531,229913839705,229893629708,229914862948,229893635870,229910236985,229898089616,229876107481', '',0263,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-31 16:02:56 Duration: 13s57ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282923, 508, '465066023038,216486108708,216571701214,216438336267,216458097578,216490681635,216378037778', '',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-31 14:51:51 Duration: 8s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282319, 450, '835230934003089,241706619401,241593577291,241663082930,241708322239,241703482945,241712221430,241629341523,241608728197,241666229410,230055029095,241651668998,241731906975,241657197080,241668697989,241691290420,241601746674,241682691421,241666071920,241682653841,241714086280,241700006780,241716571428,241682711726,241679497685,241610126886,241603112229,241679498392,241631815759,241716646687,241615277175,241663248906,241637855058,241712206781,241715467391,241708227885,241731919502,241630679396,241709785456,241609008708,241728023847', '',0320,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-08-31 12:10:43 Duration: 7s893ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 21m3s 3 3m 11m2s 7m1s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 31 05 3 21m3s 7m1s [ User: intelifix - Total duration: 21m3s - Times executed: 3 ]
[ Application: psql - Total duration: 21m3s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-31 05:11:03 Duration: 11m2s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-31 05:18:04 Duration: 7m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-31 05:21:05 Duration: 3m Database: contagem User: intelifix Remote: [local] Application: psql
6 19m16s 276 166ms 2m28s 4s190ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 31 00 12 1m4s 5s404ms 01 12 29s924ms 2s493ms 02 12 31s560ms 2s630ms 03 12 33s838ms 2s819ms 04 12 32s559ms 2s713ms 05 12 30s780ms 2s565ms 06 12 32s296ms 2s691ms 07 12 32s438ms 2s703ms 08 12 54s678ms 4s556ms 09 12 3m13s 16s90ms 10 12 2m20s 11s672ms 11 12 42s569ms 3s547ms 12 12 34s31ms 2s835ms 13 12 36s418ms 3s34ms 14 12 40s285ms 3s357ms 15 12 50s744ms 4s228ms 16 12 37s737ms 3s144ms 17 12 38s943ms 3s245ms 18 12 33s972ms 2s831ms 19 12 34s27ms 2s835ms 20 12 59s285ms 4s940ms 21 12 35s75ms 2s922ms 22 12 37s501ms 3s125ms [ User: intelifix - Total duration: 19m16s - Times executed: 276 ]
[ Application: psql - Total duration: 19m16s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 09:57:48 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 10:46:56 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 00:05:35 Duration: 32s797ms Database: rio User: intelifix Remote: [local] Application: psql
7 17m2s 88 785ms 2m3s 11s615ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 31 07 7 42s595ms 6s85ms 08 1 28s460ms 28s460ms 09 4 2m58s 44s504ms 10 4 21s720ms 5s430ms 11 6 2m38s 26s352ms 12 4 15s987ms 3s996ms 13 6 1m13s 12s193ms 14 4 2m11s 32s998ms 15 13 2m13s 10s252ms 16 12 1m4s 5s368ms 17 27 2m54s 6s460ms [ User: intelifix - Total duration: 17m2s - Times executed: 88 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 88 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 09:25:58 Duration: 2m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 11:51:27 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 14:27:06 Duration: 1m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 12m29s 877 151ms 15s977ms 854ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 31 07 34 55s516ms 1s632ms 08 97 1m27s 897ms 09 145 1m52s 774ms 10 111 1m16s 688ms 11 88 1m9s 787ms 12 19 12s56ms 634ms 13 54 57s799ms 1s70ms 14 116 1m54s 988ms 15 136 1m33s 690ms 16 69 1m5s 951ms 17 8 5s5ms 625ms [ User: intelifix - Total duration: 12m29s - Times executed: 877 ]
[ Application: [unknown] - Total duration: 12m29s - Times executed: 877 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "89503", "modelo" : "295", "itens" : "230049923738,230041313650,230023189008,229975377192,230038134058,229968649914,229975685056,229971951516,230032356580,230034826877,230051166777,230006909797,229986779203,230028602028,230038178810,230050070117,230006028185,229966327992,229973517089", "usuario" : "414", "caixa" : "982964", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-31 09:44:55 Duration: 15s977ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241655249517,241660599196,241607102944,241638263235,241710960914,241674153034,241691789211,241635503336,241597390717,241693034551,241628023751,241637381522,241601584055,241606452342,241630883233,241606111321,241660478298,241716546778,241603986163,241658428199,241597495575,241694543958,241677419199,241635725658,241675476687,241631586264,241663219812,241660434153,241716458284,241679326984,241628164247,241605971835,241619465463,241645959407,241609185167,241712814551,241599447583,241607675053,241679406565,241599504862,241713925456,241614565355,241606101320,241638215172,241595319403,241691734559,241716484853", "usuario" : "414", "caixa" : "2880599", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-31 16:09:27 Duration: 10s729ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241660405968,241652147182,241620577782,241691706172,241649473757,241635739093,241691558100,241652154153,241714533754,241709099800,241652213957,241637368489,241716388200,241691672735,241598130621,241654419199,241628204453,241594098486,241606085762,241658655775,241710924950,241709220722,241675531014,241691563252,241700718095,241622434148,241727299500,241628203847,241636907984,241596162931,241668155759,241628183542,241667712125,241710954650,241674207786,241635563241,241632286871,241599462232,241677863744,241647549102,241715607382,241619904047,241690552940,241658637591,241645861014,241629480729,241690970209", "usuario" : "414", "caixa" : "2880969", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-31 14:56:27 Duration: 10s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 12m28s 119 159ms 21s500ms 6s292ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 31 00 2 742ms 371ms 07 11 1m15s 6s848ms 08 12 1m47s 8s948ms 09 12 1m34s 7s906ms 10 12 1m37s 8s111ms 11 12 1m34s 7s876ms 12 8 1m1s 7s686ms 13 5 5s94ms 1s18ms 14 6 58s240ms 9s706ms 15 10 1m3s 6s308ms 16 9 33s741ms 3s749ms 17 7 14s639ms 2s91ms 20 2 398ms 199ms 21 5 22s92ms 4s418ms 22 6 19s896ms 3s316ms [ User: intelifix - Total duration: 12m28s - Times executed: 119 ]
[ Application: psql - Total duration: 12m28s - Times executed: 119 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 08:45:22 Duration: 21s500ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 09:55:20 Duration: 19s132ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 07:55:20 Duration: 18s728ms Database: rio User: intelifix Remote: [local] Application: psql
10 10m52s 44 10s532ms 1m16s 14s822ms create table temp0000290046 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 31 08 16 4m10s 15s657ms 09 11 2m44s 14s955ms 10 12 2m51s 14s275ms 11 5 1m5s 13s168ms [ User: intelifix - Total duration: 10m52s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 10m52s - Times executed: 44 ]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 08:07:03 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 10:13:44 Duration: 37s419ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 09:47:20 Duration: 35s396ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m38s 28 188ms 1m45s 9s932ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 31 08 6 5s55ms 842ms 09 4 2s937ms 734ms 10 4 2s761ms 690ms 11 4 2m39s 39s792ms 13 2 521ms 260ms 15 8 1m47s 13s457ms [ User: intelifix - Total duration: 4m38s - Times executed: 28 ]
[ Application: psql - Total duration: 4m38s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029276);
Date: 2026-08-31 15:10:54 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029270);
Date: 2026-08-31 11:02:27 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029272);
Date: 2026-08-31 11:19:04 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: psql
12 4m6s 25 273ms 57s774ms 9s867ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 31 08 3 1m5s 21s731ms 09 2 24s208ms 12s104ms 10 2 24s725ms 12s362ms 11 4 53s170ms 13s292ms 13 2 33s202ms 16s601ms 15 12 46s183ms 3s848ms [ User: intelifix - Total duration: 4m6s - Times executed: 25 ]
[ Application: psql - Total duration: 4m6s - Times executed: 25 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029257);
Date: 2026-08-31 08:11:09 Duration: 57s774ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029274);
Date: 2026-08-31 13:55:01 Duration: 27s366ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029273);
Date: 2026-08-31 11:36:47 Duration: 16s910ms Database: rio User: intelifix Remote: [local] Application: psql
13 4m1s 83 169ms 46s191ms 2s904ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 31 08 7 6s267ms 895ms 09 24 39s494ms 1s645ms 10 21 34s155ms 1s626ms 13 4 58s412ms 14s603ms 14 20 1m7s 3s359ms 15 4 20s228ms 5s57ms 16 3 15s311ms 5s103ms [ User: intelifix - Total duration: 4m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 4m1s - Times executed: 83 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-31 13:21:25 Duration: 46s191ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (055082) LIMIT 1;
Date: 2026-08-31 09:33:49 Duration: 14s494ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (055082) LIMIT 1;
Date: 2026-08-31 15:24:23 Duration: 13s128ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 3m55s 4 6s196ms 1m56s 58s928ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 31 20 2 2m4s 1m2s 23 2 1m50s 55s491ms [ User: intelifix - Total duration: 3m55s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m55s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-31 20:10:32 Duration: 1m56s 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-08-31 23:18:10 Duration: 1m44s 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-08-31 20:13:00 Duration: 8s247ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
15 2m48s 12 9s949ms 38s697ms 14s82ms create table temp0000290114 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 31 13 5 1m27s 17s464ms 15 7 1m21s 11s666ms [ User: intelifix - Total duration: 2m48s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m48s - Times executed: 12 ]
-
CREATE TABLE temp0000290114 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 13:53:32 Duration: 38s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290114 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 15:22:08 Duration: 13s774ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290114 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 13:54:22 Duration: 12s947ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m42s 4 485ms 1m25s 40s695ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 31 20 2 1m26s 43s171ms 23 2 1m16s 38s218ms [ User: intelifix - Total duration: 2m42s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m42s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-31 20:06:23 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-31 23:14:17 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-31 20:12:13 Duration: 556ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m39s 6 11s873ms 52s391ms 26s592ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 31 00 3 1m21s 27s107ms 06 3 1m18s 26s77ms [ User: lenon - Total duration: 2m39s - Times executed: 6 ]
[ Application: psql - Total duration: 2m39s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-31 00:02:54 Duration: 52s391ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-31 06:02:51 Duration: 48s503ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-31 06:03:20 Duration: 17s253ms Database: contagem User: lenon Remote: [local] Application: psql
18 2m21s 33 637ms 11s226ms 4s273ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 31 08 2 18s269ms 9s134ms 09 2 12s149ms 6s74ms 10 2 12s13ms 6s6ms 11 1 6s231ms 6s231ms 12 2 3s632ms 1s816ms 13 3 12s949ms 4s316ms 14 1 3s782ms 3s782ms 15 3 26s247ms 8s749ms 16 3 17s616ms 5s872ms 17 3 11s281ms 3s760ms 18 2 1s872ms 936ms 19 3 2s867ms 955ms 20 3 8s578ms 2s859ms 21 1 637ms 637ms 22 2 2s880ms 1s440ms [ User: intelifix - Total duration: 2m21s - Times executed: 33 ]
[ Application: psql - Total duration: 2m21s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-31 08:00:13 Duration: 11s226ms 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-08-31 15:20:11 Duration: 9s862ms 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-08-31 17:00:11 Duration: 9s637ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m 38 2s289ms 9s706ms 3s176ms create table temp0000290046 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 31 08 10 27s237ms 2s723ms 09 18 55s381ms 3s76ms 10 10 38s70ms 3s807ms [ User: intelifix - Total duration: 2m - Times executed: 38 ]
[ Application: [unknown] - Total duration: 2m - Times executed: 38 ]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 10:30:05 Duration: 9s706ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 09:22:20 Duration: 6s499ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 10:02:02 Duration: 3s618ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m57s 8 2s380ms 43s654ms 14s625ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 31 15 8 1m57s 14s625ms [ User: intelifix - Total duration: 1m57s - Times executed: 8 ]
[ Application: psql - Total duration: 1m57s - Times executed: 8 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01658);
Date: 2026-08-31 15:38:57 Duration: 43s654ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04598);
Date: 2026-08-31 15:25:30 Duration: 28s488ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04600);
Date: 2026-08-31 15:41:05 Duration: 12s733ms Database: brasilia User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 987 23m50s 150ms 13s57ms 1s448ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 31 08 34 55s994ms 1s646ms 09 210 3m37s 1s37ms 10 156 3m29s 1s341ms 11 121 3m7s 1s553ms 12 41 1m21s 1s984ms 13 72 1m41s 1s414ms 14 97 2m26s 1s506ms 15 80 2m32s 1s900ms 16 114 3m3s 1s612ms 17 62 1m33s 1s511ms [ User: intelifix - Total duration: 23m50s - Times executed: 987 ]
[ Application: [unknown] - Total duration: 23m50s - Times executed: 987 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282316, 450, '831343949003608,229915935162,229900617595,229900982435,229902113645,229895225767,229895263852,229895871016,229896001433,229876247091,229896001130,229895988805,229895998200,229892714254,229909086682,229911749501,229886013948,229871526574,229913936280,229909085773,229909699200,229897902325,229897234246,229893731840,229897969907,229920771729,229898315171,229893645669,229909732436,229910277999,229876552531,229913839705,229893629708,229914862948,229893635870,229910236985,229898089616,229876107481', '',0263,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-31 16:02:56 Duration: 13s57ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282923, 508, '465066023038,216486108708,216571701214,216438336267,216458097578,216490681635,216378037778', '',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-31 14:51:51 Duration: 8s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282319, 450, '835230934003089,241706619401,241593577291,241663082930,241708322239,241703482945,241712221430,241629341523,241608728197,241666229410,230055029095,241651668998,241731906975,241657197080,241668697989,241691290420,241601746674,241682691421,241666071920,241682653841,241714086280,241700006780,241716571428,241682711726,241679497685,241610126886,241603112229,241679498392,241631815759,241716646687,241615277175,241663248906,241637855058,241712206781,241715467391,241708227885,241731919502,241630679396,241709785456,241609008708,241728023847', '',0320,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-08-31 12:10:43 Duration: 7s893ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 877 12m29s 151ms 15s977ms 854ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 31 07 34 55s516ms 1s632ms 08 97 1m27s 897ms 09 145 1m52s 774ms 10 111 1m16s 688ms 11 88 1m9s 787ms 12 19 12s56ms 634ms 13 54 57s799ms 1s70ms 14 116 1m54s 988ms 15 136 1m33s 690ms 16 69 1m5s 951ms 17 8 5s5ms 625ms [ User: intelifix - Total duration: 12m29s - Times executed: 877 ]
[ Application: [unknown] - Total duration: 12m29s - Times executed: 877 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "89503", "modelo" : "295", "itens" : "230049923738,230041313650,230023189008,229975377192,230038134058,229968649914,229975685056,229971951516,230032356580,230034826877,230051166777,230006909797,229986779203,230028602028,230038178810,230050070117,230006028185,229966327992,229973517089", "usuario" : "414", "caixa" : "982964", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-31 09:44:55 Duration: 15s977ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241655249517,241660599196,241607102944,241638263235,241710960914,241674153034,241691789211,241635503336,241597390717,241693034551,241628023751,241637381522,241601584055,241606452342,241630883233,241606111321,241660478298,241716546778,241603986163,241658428199,241597495575,241694543958,241677419199,241635725658,241675476687,241631586264,241663219812,241660434153,241716458284,241679326984,241628164247,241605971835,241619465463,241645959407,241609185167,241712814551,241599447583,241607675053,241679406565,241599504862,241713925456,241614565355,241606101320,241638215172,241595319403,241691734559,241716484853", "usuario" : "414", "caixa" : "2880599", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-31 16:09:27 Duration: 10s729ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241660405968,241652147182,241620577782,241691706172,241649473757,241635739093,241691558100,241652154153,241714533754,241709099800,241652213957,241637368489,241716388200,241691672735,241598130621,241654419199,241628204453,241594098486,241606085762,241658655775,241710924950,241709220722,241675531014,241691563252,241700718095,241622434148,241727299500,241628203847,241636907984,241596162931,241668155759,241628183542,241667712125,241710954650,241674207786,241635563241,241632286871,241599462232,241677863744,241647549102,241715607382,241619904047,241690552940,241658637591,241645861014,241629480729,241690970209", "usuario" : "414", "caixa" : "2880969", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-31 14:56:27 Duration: 10s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 366 1m18s 150ms 562ms 213ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 31 07 72 16s289ms 226ms 08 74 15s635ms 211ms 09 31 6s134ms 197ms 10 36 7s478ms 207ms 11 23 4s888ms 212ms 12 22 4s269ms 194ms 13 3 712ms 237ms 14 52 11s85ms 213ms 15 30 6s258ms 208ms 16 13 2s874ms 221ms 17 9 2s62ms 229ms 21 1 562ms 562ms [ User: intelifix - Total duration: 1m18s - Times executed: 366 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 366 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229998847193');
Date: 2026-08-31 21:07:00 Duration: 562ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('6877DA5BD4DF');
Date: 2026-08-31 07:59:20 Duration: 475ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('802D1A1FF74C');
Date: 2026-08-31 07:48:26 Duration: 455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 276 19m16s 166ms 2m28s 4s190ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 31 00 12 1m4s 5s404ms 01 12 29s924ms 2s493ms 02 12 31s560ms 2s630ms 03 12 33s838ms 2s819ms 04 12 32s559ms 2s713ms 05 12 30s780ms 2s565ms 06 12 32s296ms 2s691ms 07 12 32s438ms 2s703ms 08 12 54s678ms 4s556ms 09 12 3m13s 16s90ms 10 12 2m20s 11s672ms 11 12 42s569ms 3s547ms 12 12 34s31ms 2s835ms 13 12 36s418ms 3s34ms 14 12 40s285ms 3s357ms 15 12 50s744ms 4s228ms 16 12 37s737ms 3s144ms 17 12 38s943ms 3s245ms 18 12 33s972ms 2s831ms 19 12 34s27ms 2s835ms 20 12 59s285ms 4s940ms 21 12 35s75ms 2s922ms 22 12 37s501ms 3s125ms [ User: intelifix - Total duration: 19m16s - Times executed: 276 ]
[ Application: psql - Total duration: 19m16s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 09:57:48 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 10:46:56 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 00:05:35 Duration: 32s797ms Database: rio User: intelifix Remote: [local] Application: psql
5 201 2h16m13s 151ms 31m8s 40s663ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 31 08 18 22m27s 1m14s 09 41 11m4s 16s198ms 10 23 14m32s 37s941ms 11 17 14m4s 49s676ms 12 1 292ms 292ms 13 14 34s155ms 2s439ms 14 31 46s179ms 1s489ms 15 42 1h11m28s 1m42s 16 4 6s285ms 1s571ms 17 9 1m3s 7s83ms 18 1 5s955ms 5s955ms [ User: intelifix - Total duration: 2h16m13s - Times executed: 201 ]
[ Application: [unknown] - Total duration: 2h16m13s - Times executed: 201 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:48 Duration: 31m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:51 Duration: 17m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-31 08:20:36 Duration: 9m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 162 1m54s 150ms 3s201ms 706ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 31 08 34 34s785ms 1s23ms 09 40 35s651ms 891ms 10 80 41s557ms 519ms 13 8 2s479ms 309ms [ User: intelifix - Total duration: 1m54s - Times executed: 162 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 162 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55078","seriais":"241680430011,241680428898,241637724967,241629823848,241729506180,241605365254,241668289005,241676183535,241620871426,241660138287,241676728391,241708971629,241704356980,241649375464,241708980721,230048462137,241635292328,230048991717,241667653657,241732159199,241692658802,241696876789,241703739008,241732056687,241711069813,241695562531,241595426888,241618268993,241664789909,241637705167,241680409806,241676752839,241708809110,241692633648,241632324451,241672210926,241660134247,241728734152,241714060824,241593305166,230048922844,241708915461,241673332842,241637733150,241695116976,241704371730,241671540726,241676746373,241610945866,241656726877","usuario":"416","observacao":""}');
Date: 2026-08-31 08:40:24 Duration: 3s201ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55078","seriais":"229811601535,229934053642,229749576468,229737277490,229866014353,229668335274,229780356565,229865950509,229781328691,229668251327,216940124061,229751492739,216936058388,229787397690,229663003048,229809125153,229812692943,229812993051,229691435463,229661564355,229787175772,229865826175,229865964449,229782928690,229745739506,229726608592,229669679311,229815844754,229805285160,229812179907,229816162642,229814464350,229670229600,229748983246,216932251127,216945195476,229812448901,229781854557,229741501012,229884603945,229785220509,229668418996,229815752950,229817190812,229811366988,229865856683,216942317888,229665191421,229737799921,229661313848","usuario":"416","observacao":""}');
Date: 2026-08-31 08:41:25 Duration: 2s937ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"55078","seriais":"5872C98CA689,D831398F24C0,5872C98B1843,D831399E570C,F00C514D1F0C,F00C514F5822,6C11BA632CCD,5872C98FAB39,6C11BA6248A3,6C11BA6EAC2D,48D682357F70,D89A0DAC90B1,C4EBFF8918AC,689E29BCE107,C4EBFF8B7F4C,D8313923F028,D89A0DAC3F63,6C11BA658209,14CA56D499AB,843C9922D6E1,D89A0DB002CF,F00C5153C00A,6C11BA62907F,D831398D8E9A,48D6822F427A,3CF9F0A39FB4,D83139A0E188,6C11BA671BEF,689E29BCEDFD,C4EBFF89FC28,6C11BA6F0D05,D8313996E8D6,F00C514EAB96","usuario":"416","observacao":""}');
Date: 2026-08-31 09:45:12 Duration: 2s355ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 119 12m28s 159ms 21s500ms 6s292ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 31 00 2 742ms 371ms 07 11 1m15s 6s848ms 08 12 1m47s 8s948ms 09 12 1m34s 7s906ms 10 12 1m37s 8s111ms 11 12 1m34s 7s876ms 12 8 1m1s 7s686ms 13 5 5s94ms 1s18ms 14 6 58s240ms 9s706ms 15 10 1m3s 6s308ms 16 9 33s741ms 3s749ms 17 7 14s639ms 2s91ms 20 2 398ms 199ms 21 5 22s92ms 4s418ms 22 6 19s896ms 3s316ms [ User: intelifix - Total duration: 12m28s - Times executed: 119 ]
[ Application: psql - Total duration: 12m28s - Times executed: 119 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 08:45:22 Duration: 21s500ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 09:55:20 Duration: 19s132ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 07:55:20 Duration: 18s728ms Database: rio User: intelifix Remote: [local] Application: psql
8 103 44s894ms 268ms 789ms 435ms 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 #8
Day Hour Count Duration Avg duration Aug 31 06 1 406ms 406ms 07 5 1s925ms 385ms 08 14 5s906ms 421ms 09 12 4s656ms 388ms 10 8 3s504ms 438ms 11 11 4s920ms 447ms 12 4 1s790ms 447ms 13 9 3s835ms 426ms 14 10 4s822ms 482ms 15 13 5s870ms 451ms 16 9 4s57ms 450ms 17 4 1s842ms 460ms 18 1 385ms 385ms 21 1 468ms 468ms 23 1 501ms 501ms [ User: lenon - Total duration: 44s894ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 44s894ms - Times executed: 103 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-31 11:36:42 Duration: 789ms 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-08-31 15:12:55 Duration: 690ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-31 13:07:43 Duration: 682ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 95 26s850ms 150ms 5s599ms 282ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 31 08 5 1s627ms 325ms 09 6 1s236ms 206ms 10 7 2s313ms 330ms 11 13 3s241ms 249ms 12 1 336ms 336ms 13 26 5s183ms 199ms 14 21 4s46ms 192ms 15 8 7s237ms 904ms 16 5 1s30ms 206ms 17 3 595ms 198ms [ User: intelifix - Total duration: 26s850ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 26s850ms - Times executed: 95 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"156", "usuario" :"413", "tipo" :"N", "itens" :"08", "nota-fiscal" :"11486", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-31 15:37:41 Duration: 5s599ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"151", "usuario" :"413", "tipo" :"N", "itens" :"05", "nota-fiscal" :"11486", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-31 10:56:04 Duration: 820ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-31 08:20:56 Duration: 797ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 91 50s522ms 347ms 957ms 555ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 31 07 3 1s502ms 500ms 08 10 5s327ms 532ms 09 12 6s118ms 509ms 10 7 3s991ms 570ms 11 10 5s359ms 535ms 12 4 2s227ms 556ms 13 8 4s288ms 536ms 14 10 6s296ms 629ms 15 13 7s188ms 552ms 16 9 5s187ms 576ms 17 4 2s332ms 583ms 23 1 701ms 701ms [ User: intelifix - Total duration: 50s522ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 50s522ms - Times executed: 91 ]
-
select * from rs_menu_grants (416, 81, 1);
Date: 2026-08-31 14:25:13 Duration: 957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (452, 18, 1);
Date: 2026-08-31 11:36:42 Duration: 861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-08-31 13:07:43 Duration: 816ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 88 17m2s 785ms 2m3s 11s615ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 31 07 7 42s595ms 6s85ms 08 1 28s460ms 28s460ms 09 4 2m58s 44s504ms 10 4 21s720ms 5s430ms 11 6 2m38s 26s352ms 12 4 15s987ms 3s996ms 13 6 1m13s 12s193ms 14 4 2m11s 32s998ms 15 13 2m13s 10s252ms 16 12 1m4s 5s368ms 17 27 2m54s 6s460ms [ User: intelifix - Total duration: 17m2s - Times executed: 88 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 88 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 09:25:58 Duration: 2m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 11:51:27 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 14:27:06 Duration: 1m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 84 38s329ms 153ms 1s864ms 456ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 31 08 3 670ms 223ms 09 3 1s398ms 466ms 10 10 7s731ms 773ms 11 20 9s40ms 452ms 13 2 497ms 248ms 14 8 3s192ms 399ms 15 26 9s988ms 384ms 16 11 5s583ms 507ms 17 1 226ms 226ms [ User: intelifix - Total duration: 38s329ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 38s329ms - Times executed: 84 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '3891484D0E3F,5872C98F88D1,D831398FF660,14CA56CDB99B,3CF9F0A56B3E,D83139A152EC,14CA56D4E007,3CF9F0AA804E,6C11BA6873FF,5872C9950567,D831391E43DA,48D68238738E,48D682329434,4896D953D6DA,14CA56CDB95F,F4E84F83844E,D89A0D82E075,14CA56D2BFDB', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-31 15:39:34 Duration: 1s864ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '802D1A1FFE70,CC29BD20CEF7,CC29BDED7181,6877DA61B57B,203AEBA87106,6877DA61BBD7,6877DA616567,6877DA5D70CB,802D1A1EC7AC,D8E844AB7042,CC29BDEB2439,D8E8448ACD52,802D1A00A630,6877DA600063,802D1A1FADF0,6877DA5ED5FF,203AEBA832FA', '138;1', 'DEFAULT', 09, 0301, '','', '', 00);
Date: 2026-08-31 11:44:09 Duration: 1s590ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229858098888,229725343756,229725103856,229879142739,229788724453,229770187795,229791580120,229844930119,229789441729,229849714760,229904275169,229770153550,229803161519,229771398384,229818709916', '','DEFAULT',056,0145,'', '','', 00);
Date: 2026-08-31 10:19:50 Duration: 1s587ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 83 4m1s 169ms 46s191ms 2s904ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 31 08 7 6s267ms 895ms 09 24 39s494ms 1s645ms 10 21 34s155ms 1s626ms 13 4 58s412ms 14s603ms 14 20 1m7s 3s359ms 15 4 20s228ms 5s57ms 16 3 15s311ms 5s103ms [ User: intelifix - Total duration: 4m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 4m1s - Times executed: 83 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-31 13:21:25 Duration: 46s191ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (055082) LIMIT 1;
Date: 2026-08-31 09:33:49 Duration: 14s494ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (055082) LIMIT 1;
Date: 2026-08-31 15:24:23 Duration: 13s128ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 69 28s898ms 155ms 791ms 418ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 31 08 7 3s2ms 428ms 09 9 3s361ms 373ms 10 7 2s900ms 414ms 11 6 2s639ms 439ms 12 2 724ms 362ms 13 5 2s54ms 410ms 14 4 2s33ms 508ms 15 24 10s34ms 418ms 17 4 1s776ms 444ms 18 1 371ms 371ms [ User: intelifix - Total duration: 28s898ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 28s898ms - Times executed: 69 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-31 15:04:33 Duration: 791ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-08-31 08:29:05 Duration: 668ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-31 15:40:59 Duration: 634ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 63 18s674ms 150ms 881ms 296ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 31 07 2 1s41ms 520ms 08 1 403ms 403ms 09 5 1s204ms 240ms 10 6 1s642ms 273ms 11 10 3s618ms 361ms 13 1 412ms 412ms 14 5 1s895ms 379ms 15 16 4s200ms 262ms 16 15 3s863ms 257ms 17 2 392ms 196ms [ User: intelifix - Total duration: 18s674ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 18s674ms - Times executed: 63 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "366", "data-de" : "2026-08-31", "data-ate" : "2026-08-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 418 }');
Date: 2026-08-31 07:06:21 Duration: 881ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-08-31", "data-ate" : "2026-08-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-08-31 16:14:58 Duration: 775ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "382", "data-de" : "2026-08-31", "data-ate" : "2026-08-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 433 }');
Date: 2026-08-31 11:26:18 Duration: 755ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 61 17s219ms 151ms 1s264ms 282ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 31 07 4 1s110ms 277ms 08 2 399ms 199ms 09 7 2s770ms 395ms 10 5 1s314ms 262ms 11 9 3s44ms 338ms 12 1 182ms 182ms 13 5 1s277ms 255ms 14 9 1s994ms 221ms 15 10 2s848ms 284ms 16 5 1s415ms 283ms 17 4 858ms 214ms [ User: intelifix - Total duration: 17s219ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 17s219ms - Times executed: 61 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "282435", "oficina" : "6", "cliente" : "5", "usuario" : "405", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-31 11:31:47 Duration: 1s264ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "135342", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-31", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "COSMÉTICO CHOCALHO", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-31 09:29:30 Duration: 864ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "282810", "oficina" : "6", "cliente" : "5", "usuario" : "415", "nf" : "", "data-saida" : "2026-08-31", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-31 09:25:42 Duration: 779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 58 16s690ms 150ms 789ms 287ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 31 07 1 704ms 704ms 08 9 2s416ms 268ms 09 5 1s50ms 210ms 10 7 1s826ms 260ms 11 3 735ms 245ms 12 8 1s780ms 222ms 13 2 391ms 195ms 14 3 972ms 324ms 15 7 2s113ms 301ms 16 13 4s698ms 361ms [ User: intelifix - Total duration: 16s690ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 16s690ms - Times executed: 58 ]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '230053976479,230027011727,229967201524,229968484971,230050723042,230036924052', NULL, NULL, 0295, 00);
Date: 2026-08-31 16:00:01 Duration: 789ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230010446473,230029993241,229972919500,229973511130,229975507687,230044547691,230053270822,230006045258,230052223233,230046974247,230014139202,229989670103,230051713857,229971250909,230011983739', NULL, NULL, 0295, 00);
Date: 2026-08-31 07:59:36 Duration: 704ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '229976822429,230027189599,230051918298,229981115676,230014601627,230014532428,230010374850,230023143347', NULL, NULL, 0295, 00);
Date: 2026-08-31 16:00:55 Duration: 643ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 56 1m43s 600ms 23s899ms 1s854ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 31 08 4 4s243ms 1s60ms 09 3 6s488ms 2s162ms 10 4 7s614ms 1s903ms 11 5 10s130ms 2s26ms 12 4 3s575ms 893ms 13 3 2s812ms 937ms 14 5 15s637ms 3s127ms 15 3 2s682ms 894ms 16 3 2s314ms 771ms 17 3 2s301ms 767ms 18 4 26s975ms 6s743ms 19 3 2s428ms 809ms 20 3 6s283ms 2s94ms 21 5 5s664ms 1s132ms 22 4 4s696ms 1s174ms [ User: intelifix - Total duration: 1m43s - Times executed: 56 ]
[ Application: psql - Total duration: 1m43s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-31 18:00:27 Duration: 23s899ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-31 14:40:09 Duration: 7s887ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-31 09:40:13 Duration: 4s953ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 51 30s512ms 331ms 2s544ms 598ms create table temp0000227005 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 31 08 2 2s462ms 1s231ms 13 21 10s995ms 523ms 14 24 11s170ms 465ms 15 2 3s133ms 1s566ms 16 2 2s750ms 1s375ms [ User: intelifix - Total duration: 30s512ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 30s512ms - Times executed: 51 ]
-
CREATE TABLE temp0000227005 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 15:18:36 Duration: 2s544ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227005 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 16:07:51 Duration: 2s341ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227005 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 08:47:09 Duration: 2s70ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 51 14s424ms 150ms 1s325ms 282ms select * from rs_etiqueta (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 31 07 6 1s990ms 331ms 08 8 2s639ms 329ms 09 7 1s425ms 203ms 10 5 1s126ms 225ms 11 7 1s666ms 238ms 14 3 533ms 177ms 15 8 1s564ms 195ms 16 3 805ms 268ms 17 1 660ms 660ms 20 1 534ms 534ms 23 2 1s477ms 738ms [ User: etiquetas - Total duration: 14s424ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 14s424ms - Times executed: 51 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-31 23:18:28 Duration: 1s325ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('90AAC39A81D0');
Date: 2026-08-31 08:24:20 Duration: 1s229ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('921061144534');
Date: 2026-08-31 07:10:14 Duration: 878ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m 11m2s 7m1s 3 21m3s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 31 05 3 21m3s 7m1s [ User: intelifix - Total duration: 21m3s - Times executed: 3 ]
[ Application: psql - Total duration: 21m3s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-31 05:11:03 Duration: 11m2s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-31 05:18:04 Duration: 7m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-08-31 05:21:05 Duration: 3m Database: contagem User: intelifix Remote: [local] Application: psql
2 1s554ms 17m11s 2m58s 48 2h22m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 31 07 3 18m22s 6m7s 08 3 6m27s 2m9s 09 3 12m21s 4m7s 10 3 12m14s 4m4s 11 3 7m47s 2m35s 12 3 8m52s 2m57s 13 3 6m44s 2m14s 14 3 8m40s 2m53s 15 3 9m20s 3m6s 16 3 9m47s 3m15s 17 3 6m39s 2m13s 18 3 6m22s 2m7s 19 3 6m7s 2m2s 20 3 8m42s 2m54s 21 3 8m 2m40s 22 3 6m1s 2m [ User: intelifix - Total duration: 2h22m33s - Times executed: 48 ]
[ Application: psql - Total duration: 2h22m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-31 07:22:12 Duration: 17m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-31 10:16:51 Duration: 11m50s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-31 09:16:46 Duration: 11m44s Database: rio User: intelifix Remote: [local] Application: psql
3 238ms 4m16s 1m31s 48 1h13m35s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 31 07 3 6m47s 2m15s 08 3 4m13s 1m24s 09 3 5m1s 1m40s 10 3 4m49s 1m36s 11 3 4m11s 1m23s 12 3 4m27s 1m29s 13 3 4m10s 1m23s 14 3 4m58s 1m39s 15 3 4m49s 1m36s 16 3 4m35s 1m31s 17 3 4m4s 1m21s 18 3 4m 1m20s 19 3 3m43s 1m14s 20 3 5m24s 1m48s 21 3 3m48s 1m16s 22 3 4m29s 1m29s [ User: intelifix - Total duration: 1h13m35s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m35s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-31 14:18:38 Duration: 4m16s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-31 20:19:02 Duration: 4m12s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-31 15:19:07 Duration: 4m6s Database: brasilia User: intelifix Remote: [local] Application: psql
4 6s196ms 1m56s 58s928ms 4 3m55s 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 Aug 31 20 2 2m4s 1m2s 23 2 1m50s 55s491ms [ User: intelifix - Total duration: 3m55s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m55s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-31 20:10:32 Duration: 1m56s 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-08-31 23:18:10 Duration: 1m44s 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-08-31 20:13:00 Duration: 8s247ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 485ms 1m25s 40s695ms 4 2m42s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 31 20 2 1m26s 43s171ms 23 2 1m16s 38s218ms [ User: intelifix - Total duration: 2m42s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m42s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-31 20:06:23 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-31 23:14:17 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-31 20:12:13 Duration: 556ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 151ms 31m8s 40s663ms 201 2h16m13s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 31 08 18 22m27s 1m14s 09 41 11m4s 16s198ms 10 23 14m32s 37s941ms 11 17 14m4s 49s676ms 12 1 292ms 292ms 13 14 34s155ms 2s439ms 14 31 46s179ms 1s489ms 15 42 1h11m28s 1m42s 16 4 6s285ms 1s571ms 17 9 1m3s 7s83ms 18 1 5s955ms 5s955ms [ User: intelifix - Total duration: 2h16m13s - Times executed: 201 ]
[ Application: [unknown] - Total duration: 2h16m13s - Times executed: 201 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:48 Duration: 31m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-31 15:45:51 Duration: 17m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029257, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-31 08:20:36 Duration: 9m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11s873ms 52s391ms 26s592ms 6 2m39s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 31 00 3 1m21s 27s107ms 06 3 1m18s 26s77ms [ User: lenon - Total duration: 2m39s - Times executed: 6 ]
[ Application: psql - Total duration: 2m39s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-31 00:02:54 Duration: 52s391ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-31 06:02:51 Duration: 48s503ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-31 06:03:20 Duration: 17s253ms Database: contagem User: lenon Remote: [local] Application: psql
8 10s532ms 1m16s 14s822ms 44 10m52s create table temp0000290046 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 31 08 16 4m10s 15s657ms 09 11 2m44s 14s955ms 10 12 2m51s 14s275ms 11 5 1m5s 13s168ms [ User: intelifix - Total duration: 10m52s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 10m52s - Times executed: 44 ]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 08:07:03 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 10:13:44 Duration: 37s419ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 09:47:20 Duration: 35s396ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 2s380ms 43s654ms 14s625ms 8 1m57s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 31 15 8 1m57s 14s625ms [ User: intelifix - Total duration: 1m57s - Times executed: 8 ]
[ Application: psql - Total duration: 1m57s - Times executed: 8 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01658);
Date: 2026-08-31 15:38:57 Duration: 43s654ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04598);
Date: 2026-08-31 15:25:30 Duration: 28s488ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04600);
Date: 2026-08-31 15:41:05 Duration: 12s733ms Database: brasilia User: intelifix Remote: [local] Application: psql
10 9s949ms 38s697ms 14s82ms 12 2m48s create table temp0000290114 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 31 13 5 1m27s 17s464ms 15 7 1m21s 11s666ms [ User: intelifix - Total duration: 2m48s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m48s - Times executed: 12 ]
-
CREATE TABLE temp0000290114 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 13:53:32 Duration: 38s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290114 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 15:22:08 Duration: 13s774ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290114 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-31 13:54:22 Duration: 12s947ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 785ms 2m3s 11s615ms 88 17m2s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 31 07 7 42s595ms 6s85ms 08 1 28s460ms 28s460ms 09 4 2m58s 44s504ms 10 4 21s720ms 5s430ms 11 6 2m38s 26s352ms 12 4 15s987ms 3s996ms 13 6 1m13s 12s193ms 14 4 2m11s 32s998ms 15 13 2m13s 10s252ms 16 12 1m4s 5s368ms 17 27 2m54s 6s460ms [ User: intelifix - Total duration: 17m2s - Times executed: 88 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 88 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 09:25:58 Duration: 2m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 11:51:27 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-31 14:27:06 Duration: 1m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 188ms 1m45s 9s932ms 28 4m38s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 31 08 6 5s55ms 842ms 09 4 2s937ms 734ms 10 4 2s761ms 690ms 11 4 2m39s 39s792ms 13 2 521ms 260ms 15 8 1m47s 13s457ms [ User: intelifix - Total duration: 4m38s - Times executed: 28 ]
[ Application: psql - Total duration: 4m38s - Times executed: 28 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029276);
Date: 2026-08-31 15:10:54 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029270);
Date: 2026-08-31 11:02:27 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029272);
Date: 2026-08-31 11:19:04 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: psql
13 273ms 57s774ms 9s867ms 25 4m6s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 31 08 3 1m5s 21s731ms 09 2 24s208ms 12s104ms 10 2 24s725ms 12s362ms 11 4 53s170ms 13s292ms 13 2 33s202ms 16s601ms 15 12 46s183ms 3s848ms [ User: intelifix - Total duration: 4m6s - Times executed: 25 ]
[ Application: psql - Total duration: 4m6s - Times executed: 25 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029257);
Date: 2026-08-31 08:11:09 Duration: 57s774ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029274);
Date: 2026-08-31 13:55:01 Duration: 27s366ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029273);
Date: 2026-08-31 11:36:47 Duration: 16s910ms Database: rio User: intelifix Remote: [local] Application: psql
14 159ms 21s500ms 6s292ms 119 12m28s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 31 00 2 742ms 371ms 07 11 1m15s 6s848ms 08 12 1m47s 8s948ms 09 12 1m34s 7s906ms 10 12 1m37s 8s111ms 11 12 1m34s 7s876ms 12 8 1m1s 7s686ms 13 5 5s94ms 1s18ms 14 6 58s240ms 9s706ms 15 10 1m3s 6s308ms 16 9 33s741ms 3s749ms 17 7 14s639ms 2s91ms 20 2 398ms 199ms 21 5 22s92ms 4s418ms 22 6 19s896ms 3s316ms [ User: intelifix - Total duration: 12m28s - Times executed: 119 ]
[ Application: psql - Total duration: 12m28s - Times executed: 119 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 08:45:22 Duration: 21s500ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 09:55:20 Duration: 19s132ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-31 07:55:20 Duration: 18s728ms Database: rio User: intelifix Remote: [local] Application: psql
15 637ms 11s226ms 4s273ms 33 2m21s 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 Aug 31 08 2 18s269ms 9s134ms 09 2 12s149ms 6s74ms 10 2 12s13ms 6s6ms 11 1 6s231ms 6s231ms 12 2 3s632ms 1s816ms 13 3 12s949ms 4s316ms 14 1 3s782ms 3s782ms 15 3 26s247ms 8s749ms 16 3 17s616ms 5s872ms 17 3 11s281ms 3s760ms 18 2 1s872ms 936ms 19 3 2s867ms 955ms 20 3 8s578ms 2s859ms 21 1 637ms 637ms 22 2 2s880ms 1s440ms [ User: intelifix - Total duration: 2m21s - Times executed: 33 ]
[ Application: psql - Total duration: 2m21s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-31 08:00:13 Duration: 11s226ms 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-08-31 15:20:11 Duration: 9s862ms 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-08-31 17:00:11 Duration: 9s637ms Database: rio User: intelifix Remote: [local] Application: psql
16 166ms 2m28s 4s190ms 276 19m16s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 31 00 12 1m4s 5s404ms 01 12 29s924ms 2s493ms 02 12 31s560ms 2s630ms 03 12 33s838ms 2s819ms 04 12 32s559ms 2s713ms 05 12 30s780ms 2s565ms 06 12 32s296ms 2s691ms 07 12 32s438ms 2s703ms 08 12 54s678ms 4s556ms 09 12 3m13s 16s90ms 10 12 2m20s 11s672ms 11 12 42s569ms 3s547ms 12 12 34s31ms 2s835ms 13 12 36s418ms 3s34ms 14 12 40s285ms 3s357ms 15 12 50s744ms 4s228ms 16 12 37s737ms 3s144ms 17 12 38s943ms 3s245ms 18 12 33s972ms 2s831ms 19 12 34s27ms 2s835ms 20 12 59s285ms 4s940ms 21 12 35s75ms 2s922ms 22 12 37s501ms 3s125ms [ User: intelifix - Total duration: 19m16s - Times executed: 276 ]
[ Application: psql - Total duration: 19m16s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 09:57:48 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 10:46:56 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-31 00:05:35 Duration: 32s797ms Database: rio User: intelifix Remote: [local] Application: psql
17 2s289ms 9s706ms 3s176ms 38 2m create table temp0000290046 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 31 08 10 27s237ms 2s723ms 09 18 55s381ms 3s76ms 10 10 38s70ms 3s807ms [ User: intelifix - Total duration: 2m - Times executed: 38 ]
[ Application: [unknown] - Total duration: 2m - Times executed: 38 ]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 10:30:05 Duration: 9s706ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 09:22:20 Duration: 6s499ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290046 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-08-2026", "ate" :"31-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-31 10:02:02 Duration: 3s618ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 169ms 46s191ms 2s904ms 83 4m1s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 31 08 7 6s267ms 895ms 09 24 39s494ms 1s645ms 10 21 34s155ms 1s626ms 13 4 58s412ms 14s603ms 14 20 1m7s 3s359ms 15 4 20s228ms 5s57ms 16 3 15s311ms 5s103ms [ User: intelifix - Total duration: 4m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 4m1s - Times executed: 83 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-31 13:21:25 Duration: 46s191ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (055082) LIMIT 1;
Date: 2026-08-31 09:33:49 Duration: 14s494ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (055082) LIMIT 1;
Date: 2026-08-31 15:24:23 Duration: 13s128ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 600ms 23s899ms 1s854ms 56 1m43s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 31 08 4 4s243ms 1s60ms 09 3 6s488ms 2s162ms 10 4 7s614ms 1s903ms 11 5 10s130ms 2s26ms 12 4 3s575ms 893ms 13 3 2s812ms 937ms 14 5 15s637ms 3s127ms 15 3 2s682ms 894ms 16 3 2s314ms 771ms 17 3 2s301ms 767ms 18 4 26s975ms 6s743ms 19 3 2s428ms 809ms 20 3 6s283ms 2s94ms 21 5 5s664ms 1s132ms 22 4 4s696ms 1s174ms [ User: intelifix - Total duration: 1m43s - Times executed: 56 ]
[ Application: psql - Total duration: 1m43s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-31 18:00:27 Duration: 23s899ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-31 14:40:09 Duration: 7s887ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-31 09:40:13 Duration: 4s953ms Database: brasilia User: intelifix Remote: [local] Application: psql
20 150ms 13s57ms 1s448ms 987 23m50s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 31 08 34 55s994ms 1s646ms 09 210 3m37s 1s37ms 10 156 3m29s 1s341ms 11 121 3m7s 1s553ms 12 41 1m21s 1s984ms 13 72 1m41s 1s414ms 14 97 2m26s 1s506ms 15 80 2m32s 1s900ms 16 114 3m3s 1s612ms 17 62 1m33s 1s511ms [ User: intelifix - Total duration: 23m50s - Times executed: 987 ]
[ Application: [unknown] - Total duration: 23m50s - Times executed: 987 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282316, 450, '831343949003608,229915935162,229900617595,229900982435,229902113645,229895225767,229895263852,229895871016,229896001433,229876247091,229896001130,229895988805,229895998200,229892714254,229909086682,229911749501,229886013948,229871526574,229913936280,229909085773,229909699200,229897902325,229897234246,229893731840,229897969907,229920771729,229898315171,229893645669,229909732436,229910277999,229876552531,229913839705,229893629708,229914862948,229893635870,229910236985,229898089616,229876107481', '',0263,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-31 16:02:56 Duration: 13s57ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282923, 508, '465066023038,216486108708,216571701214,216438336267,216458097578,216490681635,216378037778', '',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-31 14:51:51 Duration: 8s681ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282319, 450, '835230934003089,241706619401,241593577291,241663082930,241708322239,241703482945,241712221430,241629341523,241608728197,241666229410,230055029095,241651668998,241731906975,241657197080,241668697989,241691290420,241601746674,241682691421,241666071920,241682653841,241714086280,241700006780,241716571428,241682711726,241679497685,241610126886,241603112229,241679498392,241631815759,241716646687,241615277175,241663248906,241637855058,241712206781,241715467391,241708227885,241731919502,241630679396,241709785456,241609008708,241728023847', '',0320,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-08-31 12:10:43 Duration: 7s893ms 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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 31 11 1 0ms 0ms 12 1 0ms 0ms 21 1 0ms 0ms 22 2 0ms 0ms [ User: intelifix - Total duration: 3s207ms - Times executed: 4 ]
[ User: lenon - Total duration: 463ms - Times executed: 1 ]
[ Application: psql - Total duration: 2s690ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 981ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 16,408 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 30 FATAL entries
- 3746 ERROR entries
- 0 WARNING entries
- 15 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,724 Max number of times the same event was reported
- 3,791 Total events found
Rank Times reported Error 1 3,724 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 31 07 237 08 338 09 490 10 621 11 458 12 227 13 143 14 269 15 297 16 185 17 115 18 59 19 59 20 59 21 58 22 59 23 50 - ERROR: prepared statement "_PLAN000000003DBD1BC0" does not exist
- ERROR: prepared statement "_PLAN0000000043586E70" does not exist
- ERROR: prepared statement "_PLAN00000000296F2B50" does not exist
Statement: DEALLOCATE "_PLAN000000003DBD1BC0"
Date: 2026-08-31 07:10:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000043586E70"
Date: 2026-08-31 07:10:51 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000296F2B50"
Date: 2026-08-31 07:10:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 23 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 31 00 3 02 4 04 1 06 1 07 1 08 1 12 2 13 2 14 1 15 1 18 1 21 2 22 2 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-31 00:03:23 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-08-31 00:08:49 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-31 00:14:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 31 11 7 14 2 - ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near ""},{"" at character 72
- ERROR: syntax error at or near ""},{"" at character 81
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"282660","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-08-31 11:10:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"131","seriais":[{"serial":"'"},{"serial":""}]}');
Date: 2026-08-31 11:10:03 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"282660","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-08-31 11:10:03 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 9 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 31 09 2 10 3 15 4 - LOG: process 1321946 still waiting for ShareLock on transaction 5315614 after 1000.082 ms
- LOG: process 1321946 still waiting for ShareLock on transaction 5315614 after 87488.324 ms
- LOG: process 1321946 still waiting for ShareLock on transaction 5320240 after 1000.135 ms
Detail: Process holding the lock: 1276897. Wait queue: 1321946.
Context: while updating tuple (78256,17) 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-08-31 09:55:30 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1276897. Wait queue: 1321946.
Context: while updating tuple (78256,17) 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-08-31 09:56:57 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1343063. Wait queue: 1321946.
Context: while updating tuple (78260,102) 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-08-31 10:45:16 Database: rio Application: psql User: intelifix Remote: [local]
5 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 31 05 4 12 2 - 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-08-31 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-31 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-31 05:32:11 Database: contagem Application: psql User: intelifix Remote: [local]
6 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 31 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-31 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-31 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT RS_CHMOD( cFile , '0o777' )" PL/pgSQL function rs_giga_tecnicos() line 42 at PERFORM
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-31 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
7 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 31 11 4 - ERROR: trailing junk after numeric literal at or near "840112EA4176" at character 27
- ERROR: trailing junk after numeric literal at or near "840112EA4176" at character 27
- ERROR: trailing junk after numeric literal at or near "840112EA4176" at character 27
Statement: select * from rs_caixa_qr(840112EA4176)
Date: 2026-08-31 11:04:25 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(840112EA4176)
Date: 2026-08-31 11:04:25 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(840112EA4176)
Date: 2026-08-31 11:05:15 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 3 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 31 15 3 - LOG: process 1553561 still waiting for ExclusiveLock on tuple (78392,27) of relation 363850 of database 358220 after 1000.064 ms
- LOG: process 1553561 still waiting for ExclusiveLock on tuple (78392,27) of relation 363850 of database 358220 after 9108.384 ms
- LOG: process 1553561 still waiting for ExclusiveLock on tuple (78392,27) of relation 363850 of database 358220 after 20501.638 ms
Detail: Process holding the lock: 1525510. Wait queue: 1553561.
Context: 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-31 15:40:21 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1525510. Wait queue: 1553561.
Context: 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-31 15:40:29 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1525510. Wait queue: 1553561.
Context: 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 029276, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-08-31 15:40:40 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 31 10 1 15 1 - ERROR: column "cai_id" does not exist at character 39
- ERROR: column "pas_id" does not exist at character 66 2026-08-31 15:54:42 -03 [1541294]: [71-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
Hint: Perhaps you meant to reference the column "temp0000227003.cli_id".
Statement: SELECT * FROM temp0000227003 ORDER BY CAI_ID DESCDate: 2026-08-31 10:40:37 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0135354);Date: 2026-08-31 15:54:42 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
10 2 LOG: process ... still waiting for ExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 31 15 2 - LOG: process 1529009 still waiting for ExclusiveLock on relation 374564 of database 358222 after 1000.106 ms
- LOG: process 1529009 still waiting for ExclusiveLock on relation 374564 of database 358222 after 2187.296 ms
Detail: Process holding the lock: 1525247. Wait queue: 1529009.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"156", "usuario" :"413", "tipo" :"N", "itens" :"08", "nota-fiscal" :"11486", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-08-31 15:37:36 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1525247. Wait queue: 1529009.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"156", "usuario" :"413", "tipo" :"N", "itens" :"08", "nota-fiscal" :"11486", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-08-31 15:37:37 Database: contagem Application: [unknown] User: intelifix Remote: [local]
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 31 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-31 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-08-31 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 31 11 1 - ERROR: unterminated quoted string at or near "''' )" at character 44
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0131, ''' )
Date: 2026-08-31 11:10:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 31 03 1 - LOG: database system was shut down at 2026-08-31 03:05:01 -03
Date: 2026-08-31 03:05:02