pgBadger-
Global information
- Generated on Thu Sep 3 23:50:15 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 46,533 log entries in 14s
- Log start from 2026-09-03 00:00:22 to 2026-09-03 23:50:11
-
Overview
Global Stats
- 388 Number of unique normalized queries
- 5,424 Number of queries
- 13h30m50s Total query duration
- 2026-09-03 00:02:08 First query
- 2026-09-03 23:49:42 Last query
- 6 queries/s at 2026-09-03 09:25:05 Query peak
- 13h30m50s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 13h30m50s Execute total duration
- 4,798 Number of events
- 12 Number of unique normalized events
- 4,724 Max number of times the same event was reported
- 0 Number of cancellation
- 3,408 Total number of automatic vacuums
- 1,015 Total number of automatic analyzes
- 14 Number temporary file
- 244.02 MiB Max size of temporary file
- 107.85 MiB Average size of temporary file
- 363 Total number of sessions
- 8 sessions at 2026-09-03 00:05:12 Session peak
- 13d6h16m57s Total duration of sessions
- 52m36s Average duration of sessions
- 14 Average queries per session
- 2m14s Average queries duration per session
- 50m22s Average idle time per session
- 381 Total number of connections
- 4 connections/s at 2026-09-03 00:05:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-03 09:25:05 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-03 09:25:05 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-03 20:08:31 Date
Queries duration
Key values
- 13h30m50s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 03 00 46 0ms 21s894ms 2s137ms 3s350ms 6s334ms 1m 01 34 0ms 3s902ms 963ms 2s821ms 5s169ms 7s100ms 02 19 0ms 3s294ms 1s519ms 3s849ms 4s791ms 6s129ms 03 20 0ms 3s884ms 1s478ms 3s638ms 4s293ms 6s777ms 04 26 0ms 3s512ms 1s116ms 2s760ms 4s968ms 6s364ms 05 27 0ms 10m17s 49s171ms 4s251ms 3m2s 10m17s 06 28 0ms 7s108ms 1s940ms 2s823ms 5s663ms 21s786ms 07 123 0ms 6m13s 14s916ms 49s842ms 5m44s 7m48s 08 472 0ms 6m19s 4s130ms 1m3s 4m54s 6m28s 09 564 150ms 5m44s 3s568ms 44s152ms 5m15s 6m 10 534 150ms 5m27s 4s78ms 58s18ms 5m23s 6m 11 514 150ms 5m33s 4s834ms 3m21s 5m29s 6m3s 12 192 0ms 5m5s 3s887ms 11s237ms 19s831ms 5m53s 13 301 0ms 4m51s 2s899ms 16s864ms 1m3s 4m59s 14 809 150ms 5m25s 2s810ms 1m22s 5m43s 6m9s 15 490 152ms 6m10s 5s87ms 1m9s 5m21s 11m33s 16 410 150ms 6m10s 4s130ms 58s146ms 4m31s 6m14s 17 251 0ms 6m7s 5s762ms 45s857ms 4m5s 6m54s 18 25 0ms 5m39s 27s683ms 3s80ms 54s628ms 5m39s 19 19 0ms 4m47s 29s532ms 2s718ms 41s713ms 4m47s 20 119 0ms 6m 10s237ms 1m2s 1m23s 6m7s 21 33 0ms 5h58m10s 11m9s 5s485ms 3m31s 5h58m10s 22 26 0ms 4m42s 22s391ms 5s844ms 41s527ms 4m42s 23 342 0ms 1m 5s622ms 1m5s 1m11s 1m31s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 03 00 24 0 498ms 242ms 461ms 969ms 01 16 0 258ms 0ms 291ms 791ms 02 1 0 223ms 0ms 0ms 0ms 03 2 0 324ms 0ms 0ms 0ms 04 10 0 271ms 0ms 150ms 652ms 05 8 0 287ms 0ms 153ms 683ms 06 11 0 1s254ms 0ms 0ms 5s663ms 07 69 0 19s893ms 2s534ms 29s338ms 5m44s 08 369 0 4s545ms 14s918ms 59s214ms 5m6s 09 462 0 3s490ms 8s560ms 13s764ms 5m33s 10 448 0 4s169ms 10s989ms 39s690ms 5m30s 11 400 0 5s320ms 13s618ms 2m30s 5m37s 12 144 0 4s619ms 3s107ms 3s905ms 3m45s 13 244 0 3s54ms 4s546ms 9s117ms 3m34s 14 689 0 2s707ms 13s819ms 1m11s 5m29s 15 373 0 5s473ms 12s905ms 41s90ms 6m19s 16 334 0 4s460ms 17s9ms 28s759ms 6m9s 17 204 0 6s217ms 9s624ms 25s538ms 4m39s 18 9 0 1m11s 0ms 0ms 3m42s 19 6 0 1m30s 0ms 0ms 3m31s 20 15 86 11s762ms 35s383ms 1m2s 3m30s 21 12 0 30m37s 0ms 0ms 5m50s 22 6 0 1m31s 0ms 0ms 3m42s 23 22 320 5s622ms 1m2s 1m4s 1m12s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 03 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 03 00 0 2 2.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 12 12.00 0.00% 08 0 16 16.00 0.00% 09 0 12 12.00 0.00% 10 0 11 11.00 0.00% 11 0 11 11.00 0.00% 12 0 5 5.00 0.00% 13 0 10 10.00 0.00% 14 0 21 21.00 0.00% 15 0 15 15.00 0.00% 16 0 11 11.00 0.00% 17 0 7 7.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Sep 03 00 19 0.01/s 01 9 0.00/s 02 8 0.00/s 03 17 0.00/s 04 9 0.00/s 05 8 0.00/s 06 14 0.00/s 07 18 0.01/s 08 24 0.01/s 09 22 0.01/s 10 20 0.01/s 11 22 0.01/s 12 14 0.00/s 13 21 0.01/s 14 25 0.01/s 15 22 0.01/s 16 18 0.01/s 17 18 0.01/s 18 11 0.00/s 19 10 0.00/s 20 17 0.00/s 21 12 0.00/s 22 9 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Sep 03 00 3 43m25s 42m52s 01 14 1h1m17s 1h1m14s 02 9 1h20s 1h17s 03 14 24m38s 24m36s 04 9 1h2m20s 1h2m17s 05 9 1h45s 58m18s 06 8 56m53s 56m46s 07 15 54m31s 52m28s 08 18 50m43s 48m55s 09 22 55m10s 53m38s 10 23 50m36s 49m1s 11 18 54m48s 52m30s 12 20 59m53s 59m16s 13 17 51m57s 51m6s 14 22 50m35s 48m51s 15 24 54m42s 52m58s 16 20 55m11s 53m47s 17 23 46m5s 45m2s 18 14 51m47s 50m58s 19 10 48m 47m4s 20 14 39m13s 37m46s 21 12 1h20m8s 49m27s 22 11 1h16s 59m23s 23 14 36m35s 34m17s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-03 00:05:02 Date
Connections per database
Key values
- rio Main Database
- 381 connections Total
Connections per user
Key values
- intelifix Main User
- 381 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-03 00:05:12 Date
Histogram of session times
Key values
- 282 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 363 sessions Total
Sessions per user
Key values
- intelifix Main User
- 363 sessions Total
Sessions per host
Key values
- [local] Main Host
- 363 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,870 buffers Checkpoint Peak
- 2026-09-03 11:24:35 Date
- 270.021 seconds Highest write time
- 0.189 seconds Sync time
Checkpoints Wal files
Key values
- 9 files Wal files usage Peak
- 2026-09-03 15:14:37 Date
Checkpoints distance
Key values
- 284.89 Mo Distance Peak
- 2026-09-03 15:29:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 03 00 27,541 755.641s 0.222s 755.922s 01 2,812 281.796s 0.112s 282.115s 02 1,609 161.209s 0.107s 161.343s 03 1,605 160.719s 0.121s 160.914s 04 2,536 254.408s 0.256s 254.701s 05 9,276 932.145s 0.283s 932.485s 06 3,125 269.112s 0.002s 269.127s 07 28,317 1,893.094s 0.061s 1,893.208s 08 70,452 3,192.45s 0.362s 3,192.932s 09 57,906 3,239.32s 0.373s 3,239.801s 10 70,227 3,239.043s 0.537s 3,239.673s 11 82,084 3,239.145s 0.373s 3,239.644s 12 25,736 2,336.041s 0.331s 2,336.421s 13 34,374 2,781.778s 0.19s 2,782.141s 14 66,094 3,239.112s 0.484s 3,239.72s 15 54,176 3,217.641s 0.259s 3,218.068s 16 44,506 2,993.148s 0.251s 2,993.542s 17 42,779 2,463.658s 0.411s 2,464.152s 18 3,659 389.197s 0.072s 389.299s 19 27 2.725s 0.007s 2.741s 20 1,468 160.413s 0.021s 160.442s 21 4,481 449.136s 0.149s 449.449s 22 2,907 291.181s 0.135s 291.502s 23 420 134.184s 0.029s 134.254s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 03 00 0 0 7 676 0.064s 0.013s 01 0 0 1 591 0.059s 0.014s 02 0 0 0 392 0.062s 0.007s 03 0 0 1 339 0.063s 0.01s 04 0 0 1 535 0.062s 0.025s 05 0 0 4 736 0.073s 0.01s 06 0 0 1 8 0.001s 0.001s 07 0 0 18 2,713 0.005s 0.011s 08 0 0 46 6,752 0.072s 0.012s 09 0 0 38 7,266 0.056s 0.012s 10 0 0 38 7,522 0.062s 0.012s 11 0 0 45 7,443 0.050s 0.012s 12 0 0 10 3,898 0.062s 0.012s 13 0 0 15 5,409 0.056s 0.012s 14 0 0 49 8,067 0.057s 0.012s 15 0 0 46 7,092 0.034s 0.012s 16 0 0 26 6,677 0.013s 0.012s 17 0 0 25 4,518 0.063s 0.012s 18 0 0 1 262 0.061s 0.009s 19 0 0 0 7 0.002s 0.004s 20 0 0 1 81 0.013s 0.003s 21 0 0 2 479 0.071s 0.024s 22 0 0 1 448 0.063s 0.022s 23 0 0 1 60 0.007s 0.014s Day Hour Count Avg time (sec) Sep 03 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 03 00 12,896.00 kB 44,359.22 kB 01 1,511.50 kB 18,476.60 kB 02 1,205.29 kB 7,992.14 kB 03 1,113.75 kB 3,076.00 kB 04 1,359.78 kB 2,539.67 kB 05 8,181.56 kB 13,896.33 kB 06 6,886.00 kB 11,663.00 kB 07 28,187.27 kB 55,819.36 kB 08 62,143.17 kB 98,264.42 kB 09 51,275.92 kB 95,134.08 kB 10 51,922.00 kB 94,518.33 kB 11 61,912.75 kB 97,553.83 kB 12 13,505.92 kB 66,710.33 kB 13 20,158.08 kB 34,083.67 kB 14 67,092.67 kB 93,578.17 kB 15 62,972.42 kB 122,033.75 kB 16 35,434.67 kB 84,759.67 kB 17 34,051.08 kB 69,640.00 kB 18 3,690.20 kB 52,272.20 kB 19 64.00 kB 34,185.67 kB 20 6,246.00 kB 26,448.67 kB 21 3,779.20 kB 17,315.70 kB 22 1,359.20 kB 14,065.10 kB 23 1,498.57 kB 7,785.86 kB -
Temporary Files
Size of temporary files
Key values
- 488.05 MiB Temp Files size Peak
- 2026-09-03 05:31:52 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-09-03 05:31:52 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 03 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.31 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 1 104.00 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 1 154.22 MiB 154.22 MiB 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 947.90 MiB 72.78 MiB 244.02 MiB 118.49 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-03 05:32:00 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-03 05:31:52 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 303.83 MiB 56.48 MiB 92.95 MiB 75.96 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-03 05:30:40 Duration: 37s496ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-03 05:30:36 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( 029376, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 08:56:53 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 07:28:49 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-03 15:05:24 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 154.22 MiB 154.22 MiB 154.22 MiB 154.22 MiB select * from rs_entradas_diarias (?, ?);-
SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');
Date: 2026-09-03 21:42:22 Duration: 5h58m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');
Date: 2026-09-03 21:42:22 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 244.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:31:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 244.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:31:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 154.22 MiB SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');[ Date: 2026-09-03 21:42:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 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-09-03 17:24:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 92.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-03 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 92.95 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-03 05:30:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 80.44 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 80.44 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 72.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 72.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-03 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 61.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-03 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 56.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-03 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 5.95 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-03 21:35:21 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 5.95 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-03 21:35:21 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (131) Main table analyzed (database rio)
- 1,015 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 131 rio.pg_catalog.pg_class 62 rio.pg_catalog.pg_type 54 brasilia.pg_catalog.pg_attribute 52 rio.public.usuarios 48 contagem.pg_catalog.pg_attribute 41 rio.public.temp0000290576 35 rio.pg_catalog.pg_index 32 rio.public.temp0000290502 32 contagem.public.usuarios 27 rio.pg_catalog.pg_depend 26 brasilia.pg_catalog.pg_class 25 rio.public.temp0000290532 23 brasilia.pg_catalog.pg_type 22 contagem.pg_catalog.pg_class 21 rio.public.temp0000290588 21 brasilia.public.temp0000239520 17 contagem.pg_catalog.pg_type 17 brasilia.pg_catalog.pg_index 15 rio.public.temp0000290606 12 brasilia.pg_catalog.pg_depend 12 rio.public.temp0000290512 11 rio.public.temp0000290230 11 rio.public.temp0000290504 11 rio.public.temp0000290496 10 rio.public.temp0000290026 10 contagem.pg_catalog.pg_index 10 rio.public.temp0000290520 10 rio.public.temp0000290584 10 rio.public.temp0000290514 10 brasilia.public.usuarios 9 rio.public.temp0000290482 9 rio.public.temp0000290612 8 contagem.pg_catalog.pg_depend 8 rio.public.temp0000290490 8 brasilia.public.temp0000239546 7 brasilia.auditor.auditor_2026_09 7 brasilia.public.temp0000239572 7 rio.public.temp0000290234 7 contagem.public.nf_entrada 7 rio.public.temp0000290500 6 rio.public.temp0000290518 6 contagem.pg_catalog.pg_shdepend 6 rio.public.temp0000290206 5 brasilia.public.temp0000239464 5 contagem.auditor.auditor_2026_09 4 rio.public.temp0000290614 4 contagem.public.temp0000227063 4 rio.public.temp0000290488 4 rio.pg_catalog.pg_shdepend 4 brasilia.public.nf_entrada 4 rio.public.tmp_drill_0175 4 brasilia.public.temp0000239564 3 rio.public.temp0000290232 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000290546 3 rio.public.tmp_drill_0320 3 rio.public.temp0000290412 3 contagem.public.temp0000227037 3 rio.auditor.auditor_2026_09 3 brasilia.public.temp0000239468 2 brasilia.public.temp0000239538 2 rio.public.temp0000290578 2 brasilia.public.temp0000239556 2 rio.public.temp0000290530 2 brasilia.public.temp0000239482 2 brasilia.public.temp0000239504 2 brasilia.public.temp0000239582 1 brasilia.public.temp0000239526 1 rio.public.tmp_drill_0302 1 contagem.public.temp0000227049 1 rio.public.temp0000290552 1 brasilia.public.temp0000239514 1 brasilia.public.temp0000239470 1 rio.public.temp0000290572 1 brasilia.public.temp0000239484 1 contagem.public.temp0000227053 1 rio.public.temp0000290604 1 brasilia.public.temp0000239502 1 contagem.public.temp0000227057 1 rio.public.temp0000290570 1 rio.public.temp0000290580 1 brasilia.public.temp0000239480 1 brasilia.public.temp0000239536 1 contagem.public.temp0000227055 1 rio.public.temp0000290558 1 contagem.public.temp0000227043 1 brasilia.public.temp0000239474 1 rio.public.temp0000290516 1 brasilia.pg_catalog.pg_shdepend 1 brasilia.public.temp0000239544 1 rio.public.temp0000290534 1 brasilia.public.temp0000239476 1 Total 1,015 Vacuums per table
Key values
- pg_catalog.pg_attribute (383) Main table vacuumed on database rio
- 3,408 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 383 40 0 0 0 0 0 23,410 6,847 10,071,331 293 7,094 rio.pg_catalog.pg_class 351 24 0 0 0 0 0 4,945 1,592 2,417,578 67 219 rio.public.usuarios 347 7 0 0 0 0 0 243 101 192,554 24 51 rio.pg_catalog.pg_type 343 20 0 0 0 0 0 2,108 754 905,825 62 205 rio.pg_catalog.pg_statistic 319 8 0 0 0 0 0 9,134 2,943 10,838,242 1,622 7,830 rio.pg_catalog.pg_index 317 15 0 0 0 0 0 1,017 338 318,240 39 94 rio.public.tmp_drill_0175 297 1 0 0 0 0 0 111 9 19,789 0 0 rio.pg_catalog.pg_depend 269 11 0 0 0 0 0 3,753 1,423 2,053,071 60 564 rio.public.tmp_drill_0320 254 1 0 0 0 0 0 316 7 59,406 0 0 rio.public.tmp_drill_0302 246 0 0 0 0 0 0 3 2 655 0 0 contagem.public.usuarios 27 0 0 0 0 0 0 103 76 41,178 0 0 rio.public.temp0000290502 26 0 0 0 0 0 0 25,488 102 1,519,340 0 0 rio.public.temp0000290588 19 0 0 0 0 0 0 14,534 85 873,122 0 0 brasilia.pg_catalog.pg_attribute 17 17 0 0 0 0 0 9,265 2,499 4,115,140 89 2,389 contagem.pg_catalog.pg_attribute 14 14 0 0 0 0 0 8,550 2,111 3,884,183 33 834 brasilia.pg_catalog.pg_class 12 12 0 0 0 0 0 2,350 704 1,119,265 37 109 rio.public.temp0000290026 10 0 0 0 0 0 0 526 56 39,587 0 0 rio.public.temp0000290584 10 0 0 0 0 0 0 8,891 1,805 2,816,450 0 0 rio.public.temp0000290576 9 0 0 0 0 0 0 4,119 48 252,271 0 0 brasilia.pg_catalog.pg_type 8 8 0 0 0 0 0 796 255 378,847 28 88 rio.public.temp0000290230 8 0 0 0 0 0 0 513 93 108,960 0 0 rio.public.temp0000290482 8 0 0 0 0 0 0 8,878 1,798 2,813,119 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,344 233 395,596 11 36 rio.public.temp0000290234 7 0 0 0 0 0 0 445 37 32,253 0 0 brasilia.pg_catalog.pg_index 6 6 0 0 0 0 0 345 113 79,699 16 32 brasilia.public.temp0000239546 6 0 0 0 0 0 0 1,254 23 77,539 0 0 rio.public.temp0000290206 5 0 0 0 0 0 0 123 27 13,880 0 0 rio.public.temp0000290532 5 0 0 0 0 0 0 252 30 19,010 0 0 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 796 274 475,671 43 97 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 585 130 226,857 3 6 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 222 48 65,197 3 5 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,090 314 486,471 16 122 brasilia.auditor.auditor_2026_09 4 0 0 0 0 0 0 22,770 13,101 17,351,049 4,554 95,200 rio.public.temp0000290614 4 0 0 0 0 0 0 16 12 3,096 0 0 rio.auditor.auditor_2026_09 4 0 0 0 0 0 0 127,703 58,025 76,083,105 34,918 673,075 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,122 248 568,635 4 24 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,727 492 2,589,132 152 511 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,118 996 3,698,245 774 4,691 contagem.public.temp0000227037 3 0 0 0 0 0 0 340 18 22,965 0 0 rio.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 485 166 319,466 3 8 contagem.public.temp0000227063 3 0 0 0 0 0 0 344 18 23,255 0 0 brasilia.public.temp0000239564 2 0 0 0 0 0 0 501 8 30,796 0 0 contagem.auditor.auditor_2026_09 2 0 0 0 0 0 0 16,497 9,035 12,092,194 3,614 67,400 rio.public.temp0000290578 2 0 0 0 0 0 0 144 78 149,069 0 0 rio.public.temp0000290412 2 0 0 0 0 0 0 129 7 8,752 0 0 brasilia.public.temp0000239504 2 0 0 0 0 0 0 500 8 30,706 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 290 74 298,549 25 65 rio.public.temp0000290612 1 0 0 0 0 0 0 8 5 1,384 0 0 brasilia.public.temp0000239526 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000290232 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000290606 1 0 0 0 0 0 0 8 5 1,289 0 0 brasilia.public.temp0000239582 1 0 0 0 0 0 0 250 4 15,353 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,480 1,051 3,234,599 1,006 7,274 rio.public.temp0000290604 1 0 0 0 0 0 0 79 6 5,558 0 0 rio.public.temp0000290572 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000290546 1 0 0 0 0 0 0 4 3 774 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 123 60 186,711 4 5 brasilia.public.temp0000239514 1 0 0 0 0 0 0 251 4 15,411 0 0 brasilia.public.temp0000239480 1 0 0 0 0 0 0 250 4 15,353 0 0 rio.public.temp0000290580 1 0 0 0 0 0 0 68 4 4,615 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 223 82 133,985 5 9 brasilia.public.temp0000239476 1 0 0 0 0 0 0 250 4 15,353 0 0 rio.public.temp0000290534 1 0 0 0 0 0 0 1,775 4 105,328 0 0 contagem.public.lotes 1 1 0 0 0 0 0 1,232 891 2,399,044 46 2,166 contagem.public.temp0000227043 1 0 0 0 0 0 0 113 6 7,637 0 0 Total 3,408 227 0 0 0 0 0 319,321 109,305 166,124,056 47,551 870,203 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (20.95) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 9.59999999999989 rio.pg_catalog.pg_class 0 0 0.96 rio.public.usuarios 0 0 0.05 rio.pg_catalog.pg_type 0 0 0.36 rio.pg_catalog.pg_statistic 0 0 5.04999999999995 rio.pg_catalog.pg_index 0 0 0.3 rio.public.tmp_drill_0175 0 0 0.02 rio.pg_catalog.pg_depend 0 0 1.88 rio.public.tmp_drill_0320 0 0 0.01 rio.public.tmp_drill_0302 0 0 0 contagem.public.usuarios 0 0 0.1 rio.public.temp0000290502 0 0 0.66 rio.public.temp0000290588 0 0 0.54 brasilia.pg_catalog.pg_attribute 0 0 1.32 contagem.pg_catalog.pg_attribute 0 0 1.37 brasilia.pg_catalog.pg_class 0 0 0.5 rio.public.temp0000290026 0 0 0.02 rio.public.temp0000290584 0 0 0.43 rio.public.temp0000290576 0 0 0.13 brasilia.pg_catalog.pg_type 0 0 0.16 rio.public.temp0000290230 0 0 0.03 rio.public.temp0000290482 0 0 0.75 contagem.pg_catalog.pg_class 0 0 0.34 rio.public.temp0000290234 0 0 0.02 brasilia.pg_catalog.pg_index 0 0 0.07 brasilia.public.temp0000239546 0 0 0 rio.public.temp0000290206 0 0 0.02 rio.public.temp0000290532 0 0 0.02 brasilia.pg_catalog.pg_shdepend 0 0 0.15 contagem.pg_catalog.pg_type 0 0 0.31 contagem.pg_catalog.pg_index 0 0 0.11 brasilia.pg_catalog.pg_depend 0 0 0.33 brasilia.auditor.auditor_2026_09 0 0 4.47 rio.public.temp0000290614 0 0 0.17 rio.auditor.auditor_2026_09 0 0 20.95 contagem.pg_catalog.pg_depend 0 0 0.41 rio.pg_toast.pg_toast_2619 0 0 0.21 brasilia.pg_catalog.pg_statistic 0 0 0.4 contagem.public.temp0000227037 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0.15 contagem.public.temp0000227063 0 0 0 brasilia.public.temp0000239564 0 0 0 contagem.auditor.auditor_2026_09 0 0 3.44 rio.public.temp0000290578 0 0 0.01 rio.public.temp0000290412 0 0 0 brasilia.public.temp0000239504 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000290612 0 0 0.01 brasilia.public.temp0000239526 0 0 0 rio.public.temp0000290232 0 0 0.05 rio.public.temp0000290606 0 0 0 brasilia.public.temp0000239582 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.09 rio.public.temp0000290604 0 0 0.01 rio.public.temp0000290572 0 0 0.04 rio.public.temp0000290546 0 0 0.04 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000239514 0 0 0 brasilia.public.temp0000239480 0 0 0 rio.public.temp0000290580 0 0 0 contagem.public.nf_entrada 0 0 0.04 brasilia.public.temp0000239476 0 0 0 rio.public.temp0000290534 0 0 0.04 contagem.public.lotes 0 0 0.55 contagem.public.temp0000227043 0 0 0 Total 0 0 56.6999999999998 Tuples removed per table
Key values
- pg_catalog.pg_attribute (191502) Main table with removed tuples on database rio
- 433687 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 383 40 191,502 19,457,466 13,512,408 878 422,319 brasilia.pg_catalog.pg_attribute 17 17 78,900 378,503 0 194 9,863 contagem.pg_catalog.pg_attribute 14 14 59,355 342,060 0 545 7,524 rio.pg_catalog.pg_statistic 319 8 15,763 3,783,832 1,014,777 0 410,234 rio.pg_catalog.pg_depend 269 11 14,508 6,247,305 1,799,722 23 53,844 rio.pg_catalog.pg_type 343 20 8,387 1,423,891 633,672 48 33,752 rio.auditor.auditor_2026_09 4 0 6,402 9,876,979 0 0 472,875 brasilia.pg_catalog.pg_statistic 3 3 6,211 23,557 0 0 3,216 brasilia.pg_catalog.pg_shdepend 5 5 4,683 68,633 690 0 625 rio.public.tmp_drill_0320 254 1 4,450 285,514 140,532 0 3,874 contagem.pg_catalog.pg_statistic 1 1 4,280 7,274 0 0 1,011 rio.pg_catalog.pg_index 317 15 4,224 938,485 322,116 22 21,530 contagem.pg_catalog.pg_depend 3 3 3,592 55,839 0 13 534 contagem.public.lotes 1 1 3,423 48,061 0 0 753 brasilia.pg_catalog.pg_class 12 12 3,230 49,352 0 22 1,791 brasilia.pg_catalog.pg_type 8 8 3,110 17,720 0 23 578 rio.pg_catalog.pg_class 351 24 3,105 2,639,210 1,398,182 62 63,803 contagem.pg_catalog.pg_type 5 5 2,763 11,277 0 44 331 contagem.pg_catalog.pg_class 7 7 2,711 25,793 0 49 961 brasilia.pg_catalog.pg_depend 4 4 2,648 71,881 0 0 715 rio.pg_catalog.pg_shdepend 3 3 2,324 42,611 1,887 0 375 brasilia.pg_catalog.pg_index 6 6 1,718 11,276 0 20 331 contagem.public.usuarios 27 0 1,638 648 0 0 54 contagem.pg_catalog.pg_index 4 4 1,300 7,602 0 14 200 brasilia.auditor.auditor_2026_09 4 0 1,100 1,990,399 0 0 92,326 rio.pg_toast.pg_toast_2619 3 3 968 2,316 21 18 783 rio.public.usuarios 347 7 920 357,356 180,733 2 7,285 contagem.public.nf_entrada 1 1 181 1,054 0 0 79 brasilia.pg_toast.pg_toast_2619 2 2 170 276 0 26 88 contagem.pg_toast.pg_toast_2619 1 1 121 118 0 0 57 rio.public.temp0000290612 1 0 0 5,858 0 61 131 rio.public.tmp_drill_0302 246 0 0 236,652 118,326 0 3,198 brasilia.public.temp0000239526 1 0 0 3,287 0 0 256 rio.public.temp0000290206 5 0 0 17,567 0 185 391 brasilia.public.temp0000239564 2 0 0 6,574 0 0 512 rio.public.temp0000290232 1 0 0 25,043 0 0 1,792 rio.public.temp0000290606 1 0 0 1,180 0 57 71 brasilia.public.temp0000239582 1 0 0 3,287 0 0 256 rio.public.temp0000290604 1 0 0 1,180 0 57 71 contagem.auditor.auditor_2026_09 2 0 0 1,128,952 0 0 53,709 rio.public.temp0000290026 10 0 0 35,048 0 243 781 rio.public.temp0000290578 2 0 0 2,155 0 60 132 rio.public.temp0000290572 1 0 0 25,046 0 0 1,792 rio.public.temp0000290576 9 0 0 90,269 0 251 5,893 rio.public.temp0000290546 1 0 0 25,060 0 0 1,792 brasilia.public.temp0000239514 1 0 0 3,285 0 0 256 brasilia.public.temp0000239546 6 0 0 19,722 0 0 1,536 contagem.public.temp0000227037 3 0 0 4,077 0 69 315 rio.public.temp0000290230 8 0 0 23,956 0 238 530 rio.public.temp0000290412 2 0 0 10,901 0 0 256 rio.public.temp0000290532 5 0 0 9,652 0 108 212 brasilia.public.temp0000239480 1 0 0 3,282 0 0 256 rio.public.temp0000290580 1 0 0 1,031 0 0 64 rio.public.temp0000290614 4 0 0 100,247 0 0 7,168 contagem.public.temp0000227063 3 0 0 4,082 0 67 317 rio.public.temp0000290584 10 0 0 250,518 0 0 17,920 rio.public.temp0000290482 8 0 0 200,284 0 0 14,336 rio.public.temp0000290588 19 0 0 308,434 0 421 21,979 brasilia.public.temp0000239476 1 0 0 3,285 0 0 256 brasilia.public.temp0000239504 2 0 0 6,570 0 0 512 rio.public.temp0000290534 1 0 0 25,060 0 0 1,792 rio.public.temp0000290234 7 0 0 33,197 0 148 748 rio.public.temp0000290502 26 0 0 410,768 0 0 29,312 rio.public.tmp_drill_0175 297 1 0 718,208 358,400 0 9,417 contagem.public.temp0000227043 1 0 0 1,359 0 23 105 Total 3,408 227 433,687 51,911,364 19,481,466 3,991 1,789,775 Pages removed per table
Key values
- pg_catalog.pg_attribute (878) Main table with removed pages on database rio
- 3991 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 383 40 191502 878 contagem.pg_catalog.pg_attribute 14 14 59355 545 rio.public.temp0000290588 19 0 0 421 rio.public.temp0000290576 9 0 0 251 rio.public.temp0000290026 10 0 0 243 rio.public.temp0000290230 8 0 0 238 brasilia.pg_catalog.pg_attribute 17 17 78900 194 rio.public.temp0000290206 5 0 0 185 rio.public.temp0000290234 7 0 0 148 rio.public.temp0000290532 5 0 0 108 contagem.public.temp0000227037 3 0 0 69 contagem.public.temp0000227063 3 0 0 67 rio.pg_catalog.pg_class 351 24 3105 62 rio.public.temp0000290612 1 0 0 61 rio.public.temp0000290578 2 0 0 60 rio.public.temp0000290606 1 0 0 57 rio.public.temp0000290604 1 0 0 57 contagem.pg_catalog.pg_class 7 7 2711 49 rio.pg_catalog.pg_type 343 20 8387 48 contagem.pg_catalog.pg_type 5 5 2763 44 brasilia.pg_toast.pg_toast_2619 2 2 170 26 rio.pg_catalog.pg_depend 269 11 14508 23 brasilia.pg_catalog.pg_type 8 8 3110 23 contagem.public.temp0000227043 1 0 0 23 brasilia.pg_catalog.pg_class 12 12 3230 22 rio.pg_catalog.pg_index 317 15 4224 22 brasilia.pg_catalog.pg_index 6 6 1718 20 rio.pg_toast.pg_toast_2619 3 3 968 18 contagem.pg_catalog.pg_index 4 4 1300 14 contagem.pg_catalog.pg_depend 3 3 3592 13 rio.public.usuarios 347 7 920 2 rio.public.tmp_drill_0302 246 0 0 0 brasilia.public.temp0000239526 1 0 0 0 brasilia.public.temp0000239564 2 0 0 0 rio.public.temp0000290232 1 0 0 0 brasilia.public.temp0000239582 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4280 0 brasilia.pg_catalog.pg_statistic 3 3 6211 0 rio.public.tmp_drill_0320 254 1 4450 0 contagem.auditor.auditor_2026_09 2 0 0 0 rio.public.temp0000290572 1 0 0 0 rio.public.temp0000290546 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 121 0 brasilia.public.temp0000239514 1 0 0 0 brasilia.public.temp0000239546 6 0 0 0 contagem.public.usuarios 27 0 1638 0 brasilia.pg_catalog.pg_depend 4 4 2648 0 brasilia.auditor.auditor_2026_09 4 0 1100 0 rio.pg_catalog.pg_shdepend 3 3 2324 0 rio.public.temp0000290412 2 0 0 0 brasilia.public.temp0000239480 1 0 0 0 rio.public.temp0000290580 1 0 0 0 rio.public.temp0000290614 4 0 0 0 rio.public.temp0000290584 10 0 0 0 contagem.public.nf_entrada 1 1 181 0 rio.public.temp0000290482 8 0 0 0 rio.pg_catalog.pg_statistic 319 8 15763 0 brasilia.public.temp0000239476 1 0 0 0 brasilia.public.temp0000239504 2 0 0 0 rio.public.temp0000290534 1 0 0 0 contagem.public.lotes 1 1 3423 0 rio.public.temp0000290502 26 0 0 0 brasilia.pg_catalog.pg_shdepend 5 5 4683 0 rio.public.tmp_drill_0175 297 1 0 0 rio.auditor.auditor_2026_09 4 0 6402 0 Total 3,408 227 433,687 3,991 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 03 00 1 4 01 0 5 02 0 0 03 0 0 04 0 3 05 7 5 06 0 2 07 10 25 08 60 126 09 43 104 10 37 89 11 41 110 12 6 28 13 25 79 14 73 121 15 64 119 16 296 110 17 556 79 18 602 1 19 600 0 20 600 0 21 387 5 22 0 0 23 0 0 - 5.95 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 3m53s 1m5s 2m48s 1m56s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 07:47:59 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 17:36:11 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 15:45:10 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 2m48s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-03 07:47:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m5s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-03 17:36:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 3,878 Total read queries
- 1,040 Total write queries
Queries by database
Key values
- rio Main database
- 3,304 Requests
- 11h37m51s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,270 Requests
User Request type Count Duration etiquetas Total 38 12s849ms select 38 12s849ms intelifix Total 5,270 13h29m51s copy to 406 40m42s ddl 634 37m22s others 506 45m43s select 3,724 11h26m2s lenon Total 116 46s582ms select 116 46s582ms Duration by user
Key values
- 13h29m51s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 38 12s849ms select 38 12s849ms intelifix Total 5,270 13h29m51s copy to 406 40m42s ddl 634 37m22s others 506 45m43s select 3,724 11h26m2s lenon Total 116 46s582ms select 116 46s582ms Queries by host
Key values
- [local] Main host
- 5,424 Requests
- 13h30m50s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,289 Requests
- 9h14m49s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-03 14:46:15 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,653 100-500ms duration
Slowest individual queries
Rank Duration Query 1 5h58m10s SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');[ Date: 2026-09-03 21:42:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 10m17s analyze verbose;[ Date: 2026-09-03 05:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m29s analyze verbose;[ Date: 2026-09-03 05:16:48 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029376, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 08:56:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 07:28:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-03 16:11:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');[ Date: 2026-09-03 15:05:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-03 17:11:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-03 20:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-03 09:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-03 07:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-03 18:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029390, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 11:18:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029411, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 16:21:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029387, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 10:56:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029401, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 14:59:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029379, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 09:24:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029403, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 15:10:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029385, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-03 10:12:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-03 11:10: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 5h58m10s 1 5h58m10s 5h58m10s 5h58m10s select * from rs_entradas_diarias (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 03 21 1 5h58m10s 5h58m10s [ User: intelifix - Total duration: 5h58m10s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 5h58m10s - Times executed: 1 ]
-
SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');
Date: 2026-09-03 21:42:22 Duration: 5h58m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');
Date: 2026-09-03 21:42:22 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h56m46s 259 151ms 6m19s 27s52ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 03 07 5 11m15s 2m15s 08 35 12m7s 20s786ms 09 23 10m44s 28s39ms 10 27 16m20s 36s304ms 11 23 18m54s 49s342ms 12 9 3s611ms 401ms 13 13 9s687ms 745ms 14 37 13m49s 22s421ms 15 31 17m53s 34s618ms 16 34 8m10s 14s415ms 17 22 7m17s 19s875ms [ User: intelifix - Total duration: 1h56m46s - Times executed: 259 ]
[ Application: [unknown] - Total duration: 1h56m46s - Times executed: 259 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029376, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 08:56:53 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 07:28:49 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-03 15:05:24 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h31m9s 48 1s286ms 6m10s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 03 07 3 6m12s 2m4s 08 3 5m10s 1m43s 09 3 6m12s 2m4s 10 3 5m31s 1m50s 11 3 5m38s 1m52s 12 3 5m22s 1m47s 13 3 5m8s 1m42s 14 3 5m21s 1m47s 15 3 5m22s 1m47s 16 3 6m47s 2m15s 17 3 6m29s 2m9s 18 3 6m6s 2m2s 19 3 5m2s 1m40s 20 3 6m21s 2m7s 21 3 5m23s 1m47s 22 3 4m58s 1m39s [ User: intelifix - Total duration: 1h31m9s - Times executed: 48 ]
[ Application: psql - Total duration: 1h31m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 16:11:12 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 17:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 20:11:02 Duration: 6m Database: rio User: intelifix Remote: [local] Application: psql
4 1h9m30s 47 252ms 4m18s 1m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 03 07 3 4m23s 1m27s 08 3 4m12s 1m24s 09 3 5m8s 1m42s 10 3 4m17s 1m25s 11 3 4m33s 1m31s 12 3 4m11s 1m23s 13 2 3m29s 1m44s 14 3 4m9s 1m23s 15 3 4m15s 1m25s 16 3 5m21s 1m47s 17 3 4m13s 1m24s 18 3 4m35s 1m31s 19 3 3m57s 1m19s 20 3 4m33s 1m31s 21 3 3m58s 1m19s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h9m30s - Times executed: 47 ]
[ Application: psql - Total duration: 1h9m30s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 16:17:00 Duration: 4m18s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 11:15:09 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 10:14:45 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
5 19m49s 3 3m2s 10m17s 6m36s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 03 05 3 19m49s 6m36s [ User: intelifix - Total duration: 19m49s - Times executed: 3 ]
[ Application: psql - Total duration: 19m49s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-03 05:10:19 Duration: 10m17s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-03 05:16:48 Duration: 6m29s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-03 05:19:51 Duration: 3m2s Database: contagem User: intelifix Remote: [local] Application: psql
6 17m14s 1,358 150ms 4s200ms 761ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 03 07 2 525ms 262ms 08 122 1m35s 782ms 09 196 2m25s 743ms 10 205 2m25s 709ms 11 165 2m18s 841ms 12 67 1m1s 916ms 13 69 1m12s 1s56ms 14 163 1m57s 720ms 15 155 1m53s 733ms 16 148 1m43s 696ms 17 66 39s700ms 601ms [ User: intelifix - Total duration: 17m14s - Times executed: 1358 ]
[ Application: [unknown] - Total duration: 17m14s - Times executed: 1358 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (135693, 399, '246266070607', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 09:08:24 Duration: 4s200ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (56827, 406, '246195578395', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 13:48:05 Duration: 3s154ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (135867, 398, '226106760121', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 13:13:41 Duration: 3s144ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 11m3s 243 153ms 2m51s 2s730ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 03 00 12 22s34ms 1s836ms 01 12 17s536ms 1s461ms 02 12 17s77ms 1s423ms 03 12 17s197ms 1s433ms 04 12 16s708ms 1s392ms 05 12 16s993ms 1s416ms 06 12 17s1ms 1s416ms 07 12 3m6s 15s547ms 08 12 19s132ms 1s594ms 09 12 20s200ms 1s683ms 10 12 21s294ms 1s774ms 11 12 21s197ms 1s766ms 12 9 17s367ms 1s929ms 13 7 16s810ms 2s401ms 14 11 18s451ms 1s677ms 15 11 24s943ms 2s267ms 16 11 18s890ms 1s717ms 17 8 1m24s 10s576ms 18 9 17s180ms 1s908ms 19 7 16s273ms 2s324ms 20 8 22s598ms 2s824ms 21 10 16s927ms 1s692ms 22 8 16s569ms 2s71ms [ User: intelifix - Total duration: 11m3s - Times executed: 243 ]
[ Application: psql - Total duration: 11m3s - Times executed: 243 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 07:47:59 Duration: 2m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 17:36:11 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 15:45:10 Duration: 5s231ms Database: rio User: intelifix Remote: [local] Application: psql
8 10m41s 56 9s927ms 30s218ms 11s462ms create table temp0000290502 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 03 07 15 2m33s 10s238ms 08 6 1m6s 11s34ms 09 13 2m17s 10s604ms 10 11 2m21s 12s879ms 11 11 2m22s 12s961ms [ User: intelifix - Total duration: 10m41s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 10m41s - Times executed: 56 ]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 10:49:08 Duration: 30s218ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 11:50:02 Duration: 27s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 11:12:06 Duration: 16s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10m12s 109 1s175ms 1m22s 5s621ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 03 06 2 5s600ms 2s800ms 07 3 3s744ms 1s248ms 08 5 24s960ms 4s992ms 09 5 8s867ms 1s773ms 10 4 40s379ms 10s94ms 11 8 2m14s 16s851ms 12 4 7s271ms 1s817ms 13 11 40s768ms 3s706ms 14 8 45s117ms 5s639ms 15 12 2m29s 12s488ms 16 10 57s775ms 5s777ms 17 37 1m33s 2s528ms [ User: intelifix - Total duration: 10m12s - Times executed: 109 ]
[ Application: [unknown] - Total duration: 10m12s - Times executed: 109 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 11:47:48 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 15:44:53 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 15:51:24 Duration: 26s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m6s 154 173ms 21s894ms 3s156ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 03 00 5 32s685ms 6s537ms 01 4 10s275ms 2s568ms 02 6 11s563ms 1s927ms 03 5 11s103ms 2s220ms 04 4 9s603ms 2s400ms 05 2 1s244ms 622ms 07 11 39s390ms 3s580ms 08 13 41s16ms 3s155ms 09 12 44s344ms 3s695ms 10 12 43s490ms 3s624ms 11 12 49s586ms 4s132ms 12 12 41s436ms 3s453ms 13 10 10s529ms 1s52ms 14 12 43s597ms 3s633ms 15 12 41s689ms 3s474ms 16 7 25s19ms 3s574ms 17 3 2s84ms 694ms 20 1 361ms 361ms 21 5 13s23ms 2s604ms 22 6 14s78ms 2s346ms [ User: intelifix - Total duration: 8m6s - Times executed: 154 ]
[ Application: psql - Total duration: 8m6s - Times executed: 154 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 00:05:23 Duration: 21s894ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 12:15:11 Duration: 10s601ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 14:45:10 Duration: 9s328ms Database: rio User: intelifix Remote: [local] Application: psql
11 6m53s 800 150ms 3s287ms 516ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 03 07 6 5s470ms 911ms 08 78 39s426ms 505ms 09 136 1m20s 593ms 10 101 51s737ms 512ms 11 96 42s602ms 443ms 12 20 8s859ms 442ms 13 86 39s610ms 460ms 14 115 54s661ms 475ms 15 77 44s716ms 580ms 16 58 33s296ms 574ms 17 27 11s983ms 443ms [ User: intelifix - Total duration: 6m53s - Times executed: 800 ]
[ Application: [unknown] - Total duration: 6m53s - Times executed: 800 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "97999", "modelo" : "287", "itens" : "229948856680,229949055768,229949432427,229949540721,229949590524,229949622850,229949642526,229949698793,229949835373,229949882426,229949944452,229950123538,229952560522,229952567390,229952609516,229952644446,229952682531,229952766276,229952864647", "usuario" : "414", "caixa" : "1143431", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-03 09:23:22 Duration: 3s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284431", "modelo" : "320", "itens" : "241676601433,241615200323,241629384355,241617106265,241657190111,241708291327,241676782943,241638230000,230048573337,241645530926,241600772326,241677353335,241608104646,241676569510,241663282950,241679525769,241621301019,241631474458,241706542626,241667749502,241658217191,241673309910,241728855959,241651214151,241664978187,241689532223,241694477486,241691449402,241616190509,241650535061,241732491635,241706788081,241667699395,241616293044,241658786977,241672851426,241593229401,241651741431,241732819196,241671475163,241693021419,241604662526,241649515455,241730288085,241649600313,241691439704,241689255372,241689968607", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-03 15:38:19 Duration: 3s98ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284289", "modelo" : "320", "itens" : "241704240707,241699999103,241694804668,241691086179,241616923240,241658387084,241675425773,241715525556,241691397073,241672018303,241694553454,241674498499,241667218080,241654299817,241600860618,241712744971,241674127475,241655114756,241691387981,241680715066,241631178693,241651416471,241603143949,241630756980,241594957594,241665833838,241616115372,241593059003,241690972431,230049154763,241594185465,241679493645,241727414764,241730405673,241730409209,241658449919,241712566771,230048235571,241607681317,241608579293,241715201530,241651170612,241639372042,241699882728,241699173658,241726158389,241656371636,241639147597", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-03 13:59:58 Duration: 3s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m21s 29 10s123ms 15s983ms 11s89ms create table temp0000290588 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 03 14 17 2m58s 10s490ms 15 9 1m45s 11s717ms 16 3 37s794ms 12s598ms [ User: intelifix - Total duration: 5m21s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 29 ]
-
CREATE TABLE temp0000290588 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 15:05:05 Duration: 15s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290588 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 16:15:28 Duration: 15s350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290588 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 15:56:05 Duration: 13s810ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m24s 41 209ms 37s249ms 6s444ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 03 07 3 33s795ms 11s265ms 08 10 1m24s 8s448ms 09 4 16s92ms 4s23ms 10 4 18s863ms 4s715ms 11 4 17s111ms 4s277ms 13 3 3s839ms 1s279ms 14 5 26s433ms 5s286ms 15 6 42s221ms 7s36ms 16 2 21s375ms 10s687ms [ User: intelifix - Total duration: 4m24s - Times executed: 41 ]
[ Application: psql - Total duration: 4m24s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029376);
Date: 2026-09-03 08:50:40 Duration: 37s249ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029374);
Date: 2026-09-03 08:33:15 Duration: 31s131ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029367);
Date: 2026-09-03 07:22:32 Duration: 28s860ms Database: rio User: intelifix Remote: [local] Application: psql
14 2m38s 32 2s225ms 25s483ms 4s949ms create table temp0000290502 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 03 07 4 27s47ms 6s761ms 08 4 10s40ms 2s510ms 09 20 1m15s 3s756ms 10 2 25s306ms 12s653ms 11 2 20s855ms 10s427ms [ User: intelifix - Total duration: 2m38s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 2m38s - Times executed: 32 ]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-08-2026", "ate" :"03-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-03 09:32:25 Duration: 25s483ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-08-2026", "ate" :"03-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-03 10:20:40 Duration: 22s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-08-2026", "ate" :"03-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-03 07:31:07 Duration: 20s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m27s 12 10s184ms 23s769ms 12s319ms create table temp0000290584 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 03 13 3 44s248ms 14s749ms 14 5 53s862ms 10s772ms 15 3 32s650ms 10s883ms 16 1 17s70ms 17s70ms [ User: intelifix - Total duration: 2m27s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 12 ]
-
CREATE TABLE temp0000290584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 13:48:42 Duration: 23s769ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 16:15:28 Duration: 17s70ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 14:07:48 Duration: 11s168ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m16s 240 151ms 2s70ms 567ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 03 14 240 2m16s 567ms [ User: intelifix - Total duration: 2m16s - Times executed: 240 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 240 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241764449108,241767857487,241740589696,241776516065,241778725978,241742969200,241813977476,241767935071,241775304163,241771266170,241767873146,241768005156,241742959502,241768037987,241776812436,241776517378,241739485762,241771303346,241739516876,241814555771,241762563447,241814529910,241743237486,241776628197,241813271011,241771373454,241765618099,241778789395,241776877795,241769213445,241778627382,241814377594,241768050717,241776830216,241813972527,241742960311,241771217478,241775575154,241814539002,241744357685","usuario":"399","observacao":""}');
Date: 2026-09-03 14:20:11 Duration: 2s70ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241814722028,241738851122,241767867488,241814360321,241776647391,241747415066,241762519907,241764611021,241813328692,241769277996,241747358999,241772885060,241778696682,241744504041,241744505556,241747343342,241771092944,241740729105,241764498709,241742792943,241771425658,241747390721,241769206070,241777482939,241764494163,241764142535,241762804862,241771239703,241738878801,241767922848,241771154263,241764142030,241777937584,241745726169,241777822849,241762547889,241739524352,241762528089,241762836885","usuario":"399","observacao":""}');
Date: 2026-09-03 14:33:07 Duration: 2s40ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241725593453,241752375965,241780560423,241757327997,241720235264,241787275151,241704879007,241780506982,241780578303,241755674559,241704929517,241754235462,241787338591,241791616989,241757359819,241784655872,241754307085,241780548299,241788873153,241725461016,241724954849,241780562241,241749088305,241791614565,241722320216,241791348399,241784660823,241784502648,241791633759,241725447579,241749968402,241780562039,241757385960,241781992930,241789297997,241758229309,241780569615,241780558806,241757385657,241736954348","usuario":"399","observacao":""}');
Date: 2026-09-03 14:46:03 Duration: 1s950ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
17 2m15s 41 152ms 58s888ms 3s302ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 03 07 6 1s679ms 279ms 08 5 1m4s 12s990ms 09 4 3s520ms 880ms 10 5 2s924ms 584ms 11 4 995ms 248ms 13 1 1s716ms 1s716ms 14 8 31s768ms 3s971ms 15 5 9s76ms 1s815ms 16 1 525ms 525ms 17 2 18s234ms 9s117ms [ User: intelifix - Total duration: 2m15s - Times executed: 41 ]
[ Application: psql - Total duration: 2m15s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029374);
Date: 2026-09-03 08:32:44 Duration: 58s888ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029394);
Date: 2026-09-03 14:07:59 Duration: 22s426ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029412);
Date: 2026-09-03 17:26:45 Duration: 12s714ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m12s 57 579ms 25s471ms 2s333ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 03 08 3 22s873ms 7s624ms 09 4 4s225ms 1s56ms 10 3 2s501ms 833ms 11 5 16s232ms 3s246ms 12 4 5s867ms 1s466ms 13 3 2s306ms 768ms 14 4 9s253ms 2s313ms 15 5 18s666ms 3s733ms 16 4 7s987ms 1s996ms 17 3 2s106ms 702ms 18 4 28s90ms 7s22ms 19 5 3s932ms 786ms 20 4 4s214ms 1s53ms 21 3 2s463ms 821ms 22 3 2s263ms 754ms [ User: intelifix - Total duration: 2m12s - Times executed: 57 ]
[ Application: psql - Total duration: 2m12s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 18:00:28 Duration: 25s471ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 08:00:21 Duration: 18s310ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 11:40:10 Duration: 9s850ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m9s 4 3s813ms 1m1s 32s390ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 03 20 2 1m5s 32s638ms 23 2 1m4s 32s141ms [ User: intelifix - Total duration: 2m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-03 20:08:30 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-03 23:16:27 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-03 20:10:25 Duration: 3s979ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m43s 6 2s947ms 39s99ms 17s263ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 03 20 3 51s375ms 17s125ms 23 3 52s205ms 17s401ms [ User: intelifix - Total duration: 1m43s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m43s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-03 23:14:17 Duration: 39s99ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-03 20:06:20 Duration: 38s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-03 23:32:58 Duration: 10s158ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,358 17m14s 150ms 4s200ms 761ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 03 07 2 525ms 262ms 08 122 1m35s 782ms 09 196 2m25s 743ms 10 205 2m25s 709ms 11 165 2m18s 841ms 12 67 1m1s 916ms 13 69 1m12s 1s56ms 14 163 1m57s 720ms 15 155 1m53s 733ms 16 148 1m43s 696ms 17 66 39s700ms 601ms [ User: intelifix - Total duration: 17m14s - Times executed: 1358 ]
[ Application: [unknown] - Total duration: 17m14s - Times executed: 1358 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (135693, 399, '246266070607', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 09:08:24 Duration: 4s200ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (56827, 406, '246195578395', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 13:48:05 Duration: 3s154ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (135867, 398, '226106760121', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 13:13:41 Duration: 3s144ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
2 800 6m53s 150ms 3s287ms 516ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 03 07 6 5s470ms 911ms 08 78 39s426ms 505ms 09 136 1m20s 593ms 10 101 51s737ms 512ms 11 96 42s602ms 443ms 12 20 8s859ms 442ms 13 86 39s610ms 460ms 14 115 54s661ms 475ms 15 77 44s716ms 580ms 16 58 33s296ms 574ms 17 27 11s983ms 443ms [ User: intelifix - Total duration: 6m53s - Times executed: 800 ]
[ Application: [unknown] - Total duration: 6m53s - Times executed: 800 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "97999", "modelo" : "287", "itens" : "229948856680,229949055768,229949432427,229949540721,229949590524,229949622850,229949642526,229949698793,229949835373,229949882426,229949944452,229950123538,229952560522,229952567390,229952609516,229952644446,229952682531,229952766276,229952864647", "usuario" : "414", "caixa" : "1143431", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-03 09:23:22 Duration: 3s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284431", "modelo" : "320", "itens" : "241676601433,241615200323,241629384355,241617106265,241657190111,241708291327,241676782943,241638230000,230048573337,241645530926,241600772326,241677353335,241608104646,241676569510,241663282950,241679525769,241621301019,241631474458,241706542626,241667749502,241658217191,241673309910,241728855959,241651214151,241664978187,241689532223,241694477486,241691449402,241616190509,241650535061,241732491635,241706788081,241667699395,241616293044,241658786977,241672851426,241593229401,241651741431,241732819196,241671475163,241693021419,241604662526,241649515455,241730288085,241649600313,241691439704,241689255372,241689968607", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-03 15:38:19 Duration: 3s98ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284289", "modelo" : "320", "itens" : "241704240707,241699999103,241694804668,241691086179,241616923240,241658387084,241675425773,241715525556,241691397073,241672018303,241694553454,241674498499,241667218080,241654299817,241600860618,241712744971,241674127475,241655114756,241691387981,241680715066,241631178693,241651416471,241603143949,241630756980,241594957594,241665833838,241616115372,241593059003,241690972431,230049154763,241594185465,241679493645,241727414764,241730405673,241730409209,241658449919,241712566771,230048235571,241607681317,241608579293,241715201530,241651170612,241639372042,241699882728,241699173658,241726158389,241656371636,241639147597", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-03 13:59:58 Duration: 3s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 259 1h56m46s 151ms 6m19s 27s52ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 03 07 5 11m15s 2m15s 08 35 12m7s 20s786ms 09 23 10m44s 28s39ms 10 27 16m20s 36s304ms 11 23 18m54s 49s342ms 12 9 3s611ms 401ms 13 13 9s687ms 745ms 14 37 13m49s 22s421ms 15 31 17m53s 34s618ms 16 34 8m10s 14s415ms 17 22 7m17s 19s875ms [ User: intelifix - Total duration: 1h56m46s - Times executed: 259 ]
[ Application: [unknown] - Total duration: 1h56m46s - Times executed: 259 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029376, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 08:56:53 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 07:28:49 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-03 15:05:24 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 243 11m3s 153ms 2m51s 2s730ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 03 00 12 22s34ms 1s836ms 01 12 17s536ms 1s461ms 02 12 17s77ms 1s423ms 03 12 17s197ms 1s433ms 04 12 16s708ms 1s392ms 05 12 16s993ms 1s416ms 06 12 17s1ms 1s416ms 07 12 3m6s 15s547ms 08 12 19s132ms 1s594ms 09 12 20s200ms 1s683ms 10 12 21s294ms 1s774ms 11 12 21s197ms 1s766ms 12 9 17s367ms 1s929ms 13 7 16s810ms 2s401ms 14 11 18s451ms 1s677ms 15 11 24s943ms 2s267ms 16 11 18s890ms 1s717ms 17 8 1m24s 10s576ms 18 9 17s180ms 1s908ms 19 7 16s273ms 2s324ms 20 8 22s598ms 2s824ms 21 10 16s927ms 1s692ms 22 8 16s569ms 2s71ms [ User: intelifix - Total duration: 11m3s - Times executed: 243 ]
[ Application: psql - Total duration: 11m3s - Times executed: 243 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 07:47:59 Duration: 2m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 17:36:11 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 15:45:10 Duration: 5s231ms Database: rio User: intelifix Remote: [local] Application: psql
5 240 2m16s 151ms 2s70ms 567ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 03 14 240 2m16s 567ms [ User: intelifix - Total duration: 2m16s - Times executed: 240 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 240 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241764449108,241767857487,241740589696,241776516065,241778725978,241742969200,241813977476,241767935071,241775304163,241771266170,241767873146,241768005156,241742959502,241768037987,241776812436,241776517378,241739485762,241771303346,241739516876,241814555771,241762563447,241814529910,241743237486,241776628197,241813271011,241771373454,241765618099,241778789395,241776877795,241769213445,241778627382,241814377594,241768050717,241776830216,241813972527,241742960311,241771217478,241775575154,241814539002,241744357685","usuario":"399","observacao":""}');
Date: 2026-09-03 14:20:11 Duration: 2s70ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241814722028,241738851122,241767867488,241814360321,241776647391,241747415066,241762519907,241764611021,241813328692,241769277996,241747358999,241772885060,241778696682,241744504041,241744505556,241747343342,241771092944,241740729105,241764498709,241742792943,241771425658,241747390721,241769206070,241777482939,241764494163,241764142535,241762804862,241771239703,241738878801,241767922848,241771154263,241764142030,241777937584,241745726169,241777822849,241762547889,241739524352,241762528089,241762836885","usuario":"399","observacao":""}');
Date: 2026-09-03 14:33:07 Duration: 2s40ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241725593453,241752375965,241780560423,241757327997,241720235264,241787275151,241704879007,241780506982,241780578303,241755674559,241704929517,241754235462,241787338591,241791616989,241757359819,241784655872,241754307085,241780548299,241788873153,241725461016,241724954849,241780562241,241749088305,241791614565,241722320216,241791348399,241784660823,241784502648,241791633759,241725447579,241749968402,241780562039,241757385960,241781992930,241789297997,241758229309,241780569615,241780558806,241757385657,241736954348","usuario":"399","observacao":""}');
Date: 2026-09-03 14:46:03 Duration: 1s950ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 154 8m6s 173ms 21s894ms 3s156ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 03 00 5 32s685ms 6s537ms 01 4 10s275ms 2s568ms 02 6 11s563ms 1s927ms 03 5 11s103ms 2s220ms 04 4 9s603ms 2s400ms 05 2 1s244ms 622ms 07 11 39s390ms 3s580ms 08 13 41s16ms 3s155ms 09 12 44s344ms 3s695ms 10 12 43s490ms 3s624ms 11 12 49s586ms 4s132ms 12 12 41s436ms 3s453ms 13 10 10s529ms 1s52ms 14 12 43s597ms 3s633ms 15 12 41s689ms 3s474ms 16 7 25s19ms 3s574ms 17 3 2s84ms 694ms 20 1 361ms 361ms 21 5 13s23ms 2s604ms 22 6 14s78ms 2s346ms [ User: intelifix - Total duration: 8m6s - Times executed: 154 ]
[ Application: psql - Total duration: 8m6s - Times executed: 154 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 00:05:23 Duration: 21s894ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 12:15:11 Duration: 10s601ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 14:45:10 Duration: 9s328ms Database: rio User: intelifix Remote: [local] Application: psql
7 110 34s869ms 292ms 545ms 316ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 03 00 2 653ms 326ms 01 2 612ms 306ms 03 1 294ms 294ms 04 2 596ms 298ms 05 2 620ms 310ms 06 2 601ms 300ms 07 4 1s218ms 304ms 08 12 3s689ms 307ms 09 9 2s900ms 322ms 10 10 3s220ms 322ms 11 10 3s192ms 319ms 12 3 928ms 309ms 13 10 3s64ms 306ms 14 14 4s392ms 313ms 15 10 3s258ms 325ms 16 8 2s758ms 344ms 17 7 2s232ms 318ms 20 1 321ms 321ms 23 1 312ms 312ms [ User: lenon - Total duration: 34s869ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 34s869ms - Times executed: 110 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-03 16:06:37 Duration: 545ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-03 15:56:06 Duration: 420ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-03 10:17:03 Duration: 373ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 109 10m12s 1s175ms 1m22s 5s621ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 03 06 2 5s600ms 2s800ms 07 3 3s744ms 1s248ms 08 5 24s960ms 4s992ms 09 5 8s867ms 1s773ms 10 4 40s379ms 10s94ms 11 8 2m14s 16s851ms 12 4 7s271ms 1s817ms 13 11 40s768ms 3s706ms 14 8 45s117ms 5s639ms 15 12 2m29s 12s488ms 16 10 57s775ms 5s777ms 17 37 1m33s 2s528ms [ User: intelifix - Total duration: 10m12s - Times executed: 109 ]
[ Application: [unknown] - Total duration: 10m12s - Times executed: 109 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 11:47:48 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 15:44:53 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 15:51:24 Duration: 26s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 103 40s394ms 328ms 1s96ms 392ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 03 00 2 983ms 491ms 01 2 706ms 353ms 03 1 353ms 353ms 04 1 358ms 358ms 05 2 783ms 391ms 07 4 1s577ms 394ms 08 11 3s872ms 352ms 09 9 3s610ms 401ms 10 10 3s831ms 383ms 11 10 3s876ms 387ms 12 3 1s171ms 390ms 13 10 3s714ms 371ms 14 13 4s729ms 363ms 15 10 4s180ms 418ms 16 7 2s925ms 417ms 17 7 2s621ms 374ms 23 1 1s96ms 1s96ms [ User: intelifix - Total duration: 40s394ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 40s394ms - Times executed: 103 ]
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-09-03 23:49:42 Duration: 1s96ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (452, 18, 1);
Date: 2026-09-03 16:06:37 Duration: 673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-09-03 00:28:56 Duration: 634ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 98 26s730ms 242ms 664ms 272ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 03 07 4 1s28ms 257ms 08 15 3s825ms 255ms 09 12 3s189ms 265ms 10 9 2s434ms 270ms 11 6 1s720ms 286ms 12 5 1s292ms 258ms 13 3 766ms 255ms 14 16 4s269ms 266ms 15 10 3s249ms 324ms 16 7 2s10ms 287ms 17 11 2s943ms 267ms [ User: intelifix - Total duration: 26s730ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 26s730ms - Times executed: 98 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-03 15:03:11 Duration: 664ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-09-03 17:15:39 Duration: 357ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-09-03 15:03:17 Duration: 349ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 89 1m5s 151ms 11s609ms 732ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 03 08 22 11s673ms 530ms 09 12 5s295ms 441ms 10 8 4s381ms 547ms 11 2 1s398ms 699ms 13 8 8s416ms 1s52ms 14 17 22s219ms 1s307ms 15 6 5s908ms 984ms 16 14 5s911ms 422ms [ User: intelifix - Total duration: 1m5s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 1m5s - Times executed: 89 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135973) LIMIT 1;
Date: 2026-09-03 14:55:14 Duration: 11s609ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0284086) LIMIT 1;
Date: 2026-09-03 13:23:48 Duration: 2s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0284102) LIMIT 1;
Date: 2026-09-03 15:08:36 Duration: 2s442ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 77 19s786ms 150ms 530ms 256ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 03 00 8 2s174ms 271ms 01 7 1s590ms 227ms 04 5 1s249ms 249ms 05 3 527ms 175ms 07 3 860ms 286ms 08 4 767ms 191ms 09 2 449ms 224ms 10 18 5s116ms 284ms 11 11 3s157ms 287ms 12 6 1s510ms 251ms 14 1 249ms 249ms 15 7 1s712ms 244ms 16 2 420ms 210ms [ User: intelifix - Total duration: 19s786ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 19s786ms - Times executed: 77 ]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '229988993942,229971216483,229981875660,230053042034,229974973236,230032505057,230017525761,230050179801', NULL, NULL, 0295, 00);
Date: 2026-09-03 10:31:27 Duration: 530ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229817243847,229818568083,229772854150,229820219603,229819685757,229851499198,229796262832,229818114852,229771076378,229795627079', NULL, NULL, 0145, 00);
Date: 2026-09-03 11:38:24 Duration: 466ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229937936366,229961119011,229953433244,230015519404,229955502537,229935747286,230008726990', NULL, NULL, 0287, 00);
Date: 2026-09-03 00:51:28 Duration: 461ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 74 18s406ms 150ms 2s268ms 248ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 03 00 8 1s776ms 222ms 01 3 773ms 257ms 02 1 223ms 223ms 04 1 154ms 154ms 05 1 366ms 366ms 08 3 938ms 312ms 09 3 1s31ms 343ms 10 13 2s434ms 187ms 11 3 606ms 202ms 12 10 1s934ms 193ms 13 2 407ms 203ms 14 8 1s333ms 166ms 15 5 871ms 174ms 16 5 983ms 196ms 17 2 334ms 167ms 21 2 453ms 226ms 23 4 3s783ms 945ms [ User: intelifix - Total duration: 18s406ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 18s406ms - Times executed: 74 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230029133550');
Date: 2026-09-03 23:33:38 Duration: 2s268ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229975841032');
Date: 2026-09-03 23:40:34 Duration: 1s37ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('942CB3BD3D7C');
Date: 2026-09-03 08:22:36 Duration: 579ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 63 25s435ms 154ms 2s554ms 403ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 03 00 1 317ms 317ms 07 4 5s51ms 1s262ms 08 2 586ms 293ms 09 2 508ms 254ms 10 3 694ms 231ms 11 9 1s895ms 210ms 12 3 1s166ms 388ms 13 5 1s616ms 323ms 14 4 2s84ms 521ms 15 14 6s207ms 443ms 16 14 4s948ms 353ms 17 2 358ms 179ms [ User: intelifix - Total duration: 25s435ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 25s435ms - Times executed: 63 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "363", "data-de" : "2026-09-02", "data-ate" : "2026-09-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 415 }');
Date: 2026-09-03 07:02:53 Duration: 2s554ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "366", "data-de" : "2026-09-02", "data-ate" : "2026-09-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 418 }');
Date: 2026-09-03 07:46:19 Duration: 1s446ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "331", "data-de" : "2026-09-03", "data-ate" : "2026-09-03", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 399 }');
Date: 2026-09-03 15:04:51 Duration: 1s277ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 57 2m12s 579ms 25s471ms 2s333ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 03 08 3 22s873ms 7s624ms 09 4 4s225ms 1s56ms 10 3 2s501ms 833ms 11 5 16s232ms 3s246ms 12 4 5s867ms 1s466ms 13 3 2s306ms 768ms 14 4 9s253ms 2s313ms 15 5 18s666ms 3s733ms 16 4 7s987ms 1s996ms 17 3 2s106ms 702ms 18 4 28s90ms 7s22ms 19 5 3s932ms 786ms 20 4 4s214ms 1s53ms 21 3 2s463ms 821ms 22 3 2s263ms 754ms [ User: intelifix - Total duration: 2m12s - Times executed: 57 ]
[ Application: psql - Total duration: 2m12s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 18:00:28 Duration: 25s471ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 08:00:21 Duration: 18s310ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 11:40:10 Duration: 9s850ms Database: rio User: intelifix Remote: [local] Application: psql
16 56 10m41s 9s927ms 30s218ms 11s462ms create table temp0000290502 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 03 07 15 2m33s 10s238ms 08 6 1m6s 11s34ms 09 13 2m17s 10s604ms 10 11 2m21s 12s879ms 11 11 2m22s 12s961ms [ User: intelifix - Total duration: 10m41s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 10m41s - Times executed: 56 ]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 10:49:08 Duration: 30s218ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 11:50:02 Duration: 27s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 11:12:06 Duration: 16s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 48 1h31m9s 1s286ms 6m10s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 03 07 3 6m12s 2m4s 08 3 5m10s 1m43s 09 3 6m12s 2m4s 10 3 5m31s 1m50s 11 3 5m38s 1m52s 12 3 5m22s 1m47s 13 3 5m8s 1m42s 14 3 5m21s 1m47s 15 3 5m22s 1m47s 16 3 6m47s 2m15s 17 3 6m29s 2m9s 18 3 6m6s 2m2s 19 3 5m2s 1m40s 20 3 6m21s 2m7s 21 3 5m23s 1m47s 22 3 4m58s 1m39s [ User: intelifix - Total duration: 1h31m9s - Times executed: 48 ]
[ Application: psql - Total duration: 1h31m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 16:11:12 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 17:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 20:11:02 Duration: 6m Database: rio User: intelifix Remote: [local] Application: psql
18 47 1h9m30s 252ms 4m18s 1m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 03 07 3 4m23s 1m27s 08 3 4m12s 1m24s 09 3 5m8s 1m42s 10 3 4m17s 1m25s 11 3 4m33s 1m31s 12 3 4m11s 1m23s 13 2 3m29s 1m44s 14 3 4m9s 1m23s 15 3 4m15s 1m25s 16 3 5m21s 1m47s 17 3 4m13s 1m24s 18 3 4m35s 1m31s 19 3 3m57s 1m19s 20 3 4m33s 1m31s 21 3 3m58s 1m19s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h9m30s - Times executed: 47 ]
[ Application: psql - Total duration: 1h9m30s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 16:17:00 Duration: 4m18s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 11:15:09 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 10:14:45 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
19 41 4m24s 209ms 37s249ms 6s444ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 03 07 3 33s795ms 11s265ms 08 10 1m24s 8s448ms 09 4 16s92ms 4s23ms 10 4 18s863ms 4s715ms 11 4 17s111ms 4s277ms 13 3 3s839ms 1s279ms 14 5 26s433ms 5s286ms 15 6 42s221ms 7s36ms 16 2 21s375ms 10s687ms [ User: intelifix - Total duration: 4m24s - Times executed: 41 ]
[ Application: psql - Total duration: 4m24s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029376);
Date: 2026-09-03 08:50:40 Duration: 37s249ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029374);
Date: 2026-09-03 08:33:15 Duration: 31s131ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029367);
Date: 2026-09-03 07:22:32 Duration: 28s860ms Database: rio User: intelifix Remote: [local] Application: psql
20 41 2m15s 152ms 58s888ms 3s302ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 03 07 6 1s679ms 279ms 08 5 1m4s 12s990ms 09 4 3s520ms 880ms 10 5 2s924ms 584ms 11 4 995ms 248ms 13 1 1s716ms 1s716ms 14 8 31s768ms 3s971ms 15 5 9s76ms 1s815ms 16 1 525ms 525ms 17 2 18s234ms 9s117ms [ User: intelifix - Total duration: 2m15s - Times executed: 41 ]
[ Application: psql - Total duration: 2m15s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029374);
Date: 2026-09-03 08:32:44 Duration: 58s888ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029394);
Date: 2026-09-03 14:07:59 Duration: 22s426ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029412);
Date: 2026-09-03 17:26:45 Duration: 12s714ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 5h58m10s 5h58m10s 5h58m10s 1 5h58m10s select * from rs_entradas_diarias (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 03 21 1 5h58m10s 5h58m10s [ User: intelifix - Total duration: 5h58m10s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 5h58m10s - Times executed: 1 ]
-
SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');
Date: 2026-09-03 21:42:22 Duration: 5h58m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_ENTRADAS_DIARIAS ('026-8--01', '2026-09-03');
Date: 2026-09-03 21:42:22 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 3m2s 10m17s 6m36s 3 19m49s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 03 05 3 19m49s 6m36s [ User: intelifix - Total duration: 19m49s - Times executed: 3 ]
[ Application: psql - Total duration: 19m49s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-03 05:10:19 Duration: 10m17s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-03 05:16:48 Duration: 6m29s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-03 05:19:51 Duration: 3m2s Database: contagem User: intelifix Remote: [local] Application: psql
3 1s286ms 6m10s 1m53s 48 1h31m9s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 03 07 3 6m12s 2m4s 08 3 5m10s 1m43s 09 3 6m12s 2m4s 10 3 5m31s 1m50s 11 3 5m38s 1m52s 12 3 5m22s 1m47s 13 3 5m8s 1m42s 14 3 5m21s 1m47s 15 3 5m22s 1m47s 16 3 6m47s 2m15s 17 3 6m29s 2m9s 18 3 6m6s 2m2s 19 3 5m2s 1m40s 20 3 6m21s 2m7s 21 3 5m23s 1m47s 22 3 4m58s 1m39s [ User: intelifix - Total duration: 1h31m9s - Times executed: 48 ]
[ Application: psql - Total duration: 1h31m9s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 16:11:12 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 17:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-03 20:11:02 Duration: 6m Database: rio User: intelifix Remote: [local] Application: psql
4 252ms 4m18s 1m28s 47 1h9m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 03 07 3 4m23s 1m27s 08 3 4m12s 1m24s 09 3 5m8s 1m42s 10 3 4m17s 1m25s 11 3 4m33s 1m31s 12 3 4m11s 1m23s 13 2 3m29s 1m44s 14 3 4m9s 1m23s 15 3 4m15s 1m25s 16 3 5m21s 1m47s 17 3 4m13s 1m24s 18 3 4m35s 1m31s 19 3 3m57s 1m19s 20 3 4m33s 1m31s 21 3 3m58s 1m19s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h9m30s - Times executed: 47 ]
[ Application: psql - Total duration: 1h9m30s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 16:17:00 Duration: 4m18s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 11:15:09 Duration: 3m58s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-03 10:14:45 Duration: 3m46s Database: brasilia User: intelifix Remote: [local] Application: psql
5 3s813ms 1m1s 32s390ms 4 2m9s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 03 20 2 1m5s 32s638ms 23 2 1m4s 32s141ms [ User: intelifix - Total duration: 2m9s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-03 20:08:30 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-03 23:16:27 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-03 20:10:25 Duration: 3s979ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 151ms 6m19s 27s52ms 259 1h56m46s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 03 07 5 11m15s 2m15s 08 35 12m7s 20s786ms 09 23 10m44s 28s39ms 10 27 16m20s 36s304ms 11 23 18m54s 49s342ms 12 9 3s611ms 401ms 13 13 9s687ms 745ms 14 37 13m49s 22s421ms 15 31 17m53s 34s618ms 16 34 8m10s 14s415ms 17 22 7m17s 19s875ms [ User: intelifix - Total duration: 1h56m46s - Times executed: 259 ]
[ Application: [unknown] - Total duration: 1h56m46s - Times executed: 259 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029376, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 08:56:53 Duration: 6m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-03 07:28:49 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-08-03''),DATE(''2026-08-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-09-03 15:05:24 Duration: 6m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 2s947ms 39s99ms 17s263ms 6 1m43s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 03 20 3 51s375ms 17s125ms 23 3 52s205ms 17s401ms [ User: intelifix - Total duration: 1m43s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m43s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-03 23:14:17 Duration: 39s99ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-03 20:06:20 Duration: 38s314ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-09-03 23:32:58 Duration: 10s158ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 10s184ms 23s769ms 12s319ms 12 2m27s create table temp0000290584 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 03 13 3 44s248ms 14s749ms 14 5 53s862ms 10s772ms 15 3 32s650ms 10s883ms 16 1 17s70ms 17s70ms [ User: intelifix - Total duration: 2m27s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 12 ]
-
CREATE TABLE temp0000290584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 13:48:42 Duration: 23s769ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 16:15:28 Duration: 17s70ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 14:07:48 Duration: 11s168ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s927ms 30s218ms 11s462ms 56 10m41s create table temp0000290502 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 03 07 15 2m33s 10s238ms 08 6 1m6s 11s34ms 09 13 2m17s 10s604ms 10 11 2m21s 12s879ms 11 11 2m22s 12s961ms [ User: intelifix - Total duration: 10m41s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 10m41s - Times executed: 56 ]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 10:49:08 Duration: 30s218ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 11:50:02 Duration: 27s803ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 11:12:06 Duration: 16s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s123ms 15s983ms 11s89ms 29 5m21s create table temp0000290588 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 03 14 17 2m58s 10s490ms 15 9 1m45s 11s717ms 16 3 37s794ms 12s598ms [ User: intelifix - Total duration: 5m21s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 29 ]
-
CREATE TABLE temp0000290588 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 15:05:05 Duration: 15s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290588 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 16:15:28 Duration: 15s350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290588 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-03 15:56:05 Duration: 13s810ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 209ms 37s249ms 6s444ms 41 4m24s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 03 07 3 33s795ms 11s265ms 08 10 1m24s 8s448ms 09 4 16s92ms 4s23ms 10 4 18s863ms 4s715ms 11 4 17s111ms 4s277ms 13 3 3s839ms 1s279ms 14 5 26s433ms 5s286ms 15 6 42s221ms 7s36ms 16 2 21s375ms 10s687ms [ User: intelifix - Total duration: 4m24s - Times executed: 41 ]
[ Application: psql - Total duration: 4m24s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029376);
Date: 2026-09-03 08:50:40 Duration: 37s249ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029374);
Date: 2026-09-03 08:33:15 Duration: 31s131ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029367);
Date: 2026-09-03 07:22:32 Duration: 28s860ms Database: rio User: intelifix Remote: [local] Application: psql
12 1s175ms 1m22s 5s621ms 109 10m12s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 03 06 2 5s600ms 2s800ms 07 3 3s744ms 1s248ms 08 5 24s960ms 4s992ms 09 5 8s867ms 1s773ms 10 4 40s379ms 10s94ms 11 8 2m14s 16s851ms 12 4 7s271ms 1s817ms 13 11 40s768ms 3s706ms 14 8 45s117ms 5s639ms 15 12 2m29s 12s488ms 16 10 57s775ms 5s777ms 17 37 1m33s 2s528ms [ User: intelifix - Total duration: 10m12s - Times executed: 109 ]
[ Application: [unknown] - Total duration: 10m12s - Times executed: 109 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 11:47:48 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 15:44:53 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-03 15:51:24 Duration: 26s100ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2s225ms 25s483ms 4s949ms 32 2m38s create table temp0000290502 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 03 07 4 27s47ms 6s761ms 08 4 10s40ms 2s510ms 09 20 1m15s 3s756ms 10 2 25s306ms 12s653ms 11 2 20s855ms 10s427ms [ User: intelifix - Total duration: 2m38s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 2m38s - Times executed: 32 ]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-08-2026", "ate" :"03-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-03 09:32:25 Duration: 25s483ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-08-2026", "ate" :"03-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-03 10:20:40 Duration: 22s490ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290502 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-08-2026", "ate" :"03-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-03 07:31:07 Duration: 20s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 152ms 58s888ms 3s302ms 41 2m15s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 03 07 6 1s679ms 279ms 08 5 1m4s 12s990ms 09 4 3s520ms 880ms 10 5 2s924ms 584ms 11 4 995ms 248ms 13 1 1s716ms 1s716ms 14 8 31s768ms 3s971ms 15 5 9s76ms 1s815ms 16 1 525ms 525ms 17 2 18s234ms 9s117ms [ User: intelifix - Total duration: 2m15s - Times executed: 41 ]
[ Application: psql - Total duration: 2m15s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029374);
Date: 2026-09-03 08:32:44 Duration: 58s888ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029394);
Date: 2026-09-03 14:07:59 Duration: 22s426ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029412);
Date: 2026-09-03 17:26:45 Duration: 12s714ms Database: rio User: intelifix Remote: [local] Application: psql
15 173ms 21s894ms 3s156ms 154 8m6s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 03 00 5 32s685ms 6s537ms 01 4 10s275ms 2s568ms 02 6 11s563ms 1s927ms 03 5 11s103ms 2s220ms 04 4 9s603ms 2s400ms 05 2 1s244ms 622ms 07 11 39s390ms 3s580ms 08 13 41s16ms 3s155ms 09 12 44s344ms 3s695ms 10 12 43s490ms 3s624ms 11 12 49s586ms 4s132ms 12 12 41s436ms 3s453ms 13 10 10s529ms 1s52ms 14 12 43s597ms 3s633ms 15 12 41s689ms 3s474ms 16 7 25s19ms 3s574ms 17 3 2s84ms 694ms 20 1 361ms 361ms 21 5 13s23ms 2s604ms 22 6 14s78ms 2s346ms [ User: intelifix - Total duration: 8m6s - Times executed: 154 ]
[ Application: psql - Total duration: 8m6s - Times executed: 154 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 00:05:23 Duration: 21s894ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 12:15:11 Duration: 10s601ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-03 14:45:10 Duration: 9s328ms Database: rio User: intelifix Remote: [local] Application: psql
16 153ms 2m51s 2s730ms 243 11m3s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 03 00 12 22s34ms 1s836ms 01 12 17s536ms 1s461ms 02 12 17s77ms 1s423ms 03 12 17s197ms 1s433ms 04 12 16s708ms 1s392ms 05 12 16s993ms 1s416ms 06 12 17s1ms 1s416ms 07 12 3m6s 15s547ms 08 12 19s132ms 1s594ms 09 12 20s200ms 1s683ms 10 12 21s294ms 1s774ms 11 12 21s197ms 1s766ms 12 9 17s367ms 1s929ms 13 7 16s810ms 2s401ms 14 11 18s451ms 1s677ms 15 11 24s943ms 2s267ms 16 11 18s890ms 1s717ms 17 8 1m24s 10s576ms 18 9 17s180ms 1s908ms 19 7 16s273ms 2s324ms 20 8 22s598ms 2s824ms 21 10 16s927ms 1s692ms 22 8 16s569ms 2s71ms [ User: intelifix - Total duration: 11m3s - Times executed: 243 ]
[ Application: psql - Total duration: 11m3s - Times executed: 243 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 07:47:59 Duration: 2m51s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 17:36:11 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-03 15:45:10 Duration: 5s231ms Database: rio User: intelifix Remote: [local] Application: psql
17 579ms 25s471ms 2s333ms 57 2m12s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 03 08 3 22s873ms 7s624ms 09 4 4s225ms 1s56ms 10 3 2s501ms 833ms 11 5 16s232ms 3s246ms 12 4 5s867ms 1s466ms 13 3 2s306ms 768ms 14 4 9s253ms 2s313ms 15 5 18s666ms 3s733ms 16 4 7s987ms 1s996ms 17 3 2s106ms 702ms 18 4 28s90ms 7s22ms 19 5 3s932ms 786ms 20 4 4s214ms 1s53ms 21 3 2s463ms 821ms 22 3 2s263ms 754ms [ User: intelifix - Total duration: 2m12s - Times executed: 57 ]
[ Application: psql - Total duration: 2m12s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 18:00:28 Duration: 25s471ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 08:00:21 Duration: 18s310ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-03 11:40:10 Duration: 9s850ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 4s200ms 761ms 1,358 17m14s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 03 07 2 525ms 262ms 08 122 1m35s 782ms 09 196 2m25s 743ms 10 205 2m25s 709ms 11 165 2m18s 841ms 12 67 1m1s 916ms 13 69 1m12s 1s56ms 14 163 1m57s 720ms 15 155 1m53s 733ms 16 148 1m43s 696ms 17 66 39s700ms 601ms [ User: intelifix - Total duration: 17m14s - Times executed: 1358 ]
[ Application: [unknown] - Total duration: 17m14s - Times executed: 1358 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (135693, 399, '246266070607', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 09:08:24 Duration: 4s200ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (56827, 406, '246195578395', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 13:48:05 Duration: 3s154ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (135867, 398, '226106760121', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-03 13:13:41 Duration: 3s144ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
19 151ms 11s609ms 732ms 89 1m5s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 03 08 22 11s673ms 530ms 09 12 5s295ms 441ms 10 8 4s381ms 547ms 11 2 1s398ms 699ms 13 8 8s416ms 1s52ms 14 17 22s219ms 1s307ms 15 6 5s908ms 984ms 16 14 5s911ms 422ms [ User: intelifix - Total duration: 1m5s - Times executed: 89 ]
[ Application: [unknown] - Total duration: 1m5s - Times executed: 89 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135973) LIMIT 1;
Date: 2026-09-03 14:55:14 Duration: 11s609ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0284086) LIMIT 1;
Date: 2026-09-03 13:23:48 Duration: 2s556ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0284102) LIMIT 1;
Date: 2026-09-03 15:08:36 Duration: 2s442ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 151ms 2s70ms 567ms 240 2m16s select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 03 14 240 2m16s 567ms [ User: intelifix - Total duration: 2m16s - Times executed: 240 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 240 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241764449108,241767857487,241740589696,241776516065,241778725978,241742969200,241813977476,241767935071,241775304163,241771266170,241767873146,241768005156,241742959502,241768037987,241776812436,241776517378,241739485762,241771303346,241739516876,241814555771,241762563447,241814529910,241743237486,241776628197,241813271011,241771373454,241765618099,241778789395,241776877795,241769213445,241778627382,241814377594,241768050717,241776830216,241813972527,241742960311,241771217478,241775575154,241814539002,241744357685","usuario":"399","observacao":""}');
Date: 2026-09-03 14:20:11 Duration: 2s70ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241814722028,241738851122,241767867488,241814360321,241776647391,241747415066,241762519907,241764611021,241813328692,241769277996,241747358999,241772885060,241778696682,241744504041,241744505556,241747343342,241771092944,241740729105,241764498709,241742792943,241771425658,241747390721,241769206070,241777482939,241764494163,241764142535,241762804862,241771239703,241738878801,241767922848,241771154263,241764142030,241777937584,241745726169,241777822849,241762547889,241739524352,241762528089,241762836885","usuario":"399","observacao":""}');
Date: 2026-09-03 14:33:07 Duration: 2s40ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135973","seriais":"241725593453,241752375965,241780560423,241757327997,241720235264,241787275151,241704879007,241780506982,241780578303,241755674559,241704929517,241754235462,241787338591,241791616989,241757359819,241784655872,241754307085,241780548299,241788873153,241725461016,241724954849,241780562241,241749088305,241791614565,241722320216,241791348399,241784660823,241784502648,241791633759,241725447579,241749968402,241780562039,241757385960,241781992930,241789297997,241758229309,241780569615,241780558806,241757385657,241736954348","usuario":"399","observacao":""}');
Date: 2026-09-03 14:46:03 Duration: 1s950ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 03 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 2s551ms - Times executed: 4 ]
[ Application: psql - Total duration: 2s551ms - Times executed: 4 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 21,556 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 4773 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,724 Max number of times the same event was reported
- 4,798 Total events found
Rank Times reported Error 1 4,724 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 03 00 118 01 119 02 119 03 118 04 119 05 119 06 119 07 299 08 395 09 395 10 413 11 417 12 225 13 209 14 420 15 396 16 233 17 144 18 59 19 60 20 59 21 60 22 60 23 49 - ERROR: prepared statement "_PLAN00000000354FB4A0" does not exist
- ERROR: prepared statement "_PLAN00000000296B2400" does not exist
- ERROR: prepared statement "_PLAN00000000354FA6F0" does not exist
Statement: DEALLOCATE "_PLAN00000000354FB4A0"
Date: 2026-09-03 00:00:22 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000296B2400"
Date: 2026-09-03 00:00:37 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000354FA6F0"
Date: 2026-09-03 00:01:22 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 28 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 03 14 5 15 23 - ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-03 14:34:38 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-03 14:39:11 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-03 14:39:22 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 11 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 03 00 4 02 1 03 1 06 1 07 1 08 1 09 1 21 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-03 00:02:09 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-03 00:03:19 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-03 00:03:34 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 03 09 1 10 4 13 2 14 2 - ERROR: syntax error at or near "241666263757" at character 41
- ERROR: syntax error at or near ""},{"" at character 81
- ERROR: syntax error at or near ""},{"" at character 81
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241666263757');
Date: 2026-09-03 09:51:17 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"282889","seriais":[{"serial":"'"},{"serial":"216940030416"}]}')
Date: 2026-09-03 10:44:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"282889","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-09-03 10:44:36 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 03 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-03 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 5 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 03 12 2 14 3 - ERROR: trailing junk after numeric literal at or near "395948 " at character 27
- ERROR: trailing junk after numeric literal at or near "395948 " at character 27
- ERROR: trailing junk after numeric literal at or near "34Ç53ÇD2ÇAAÇ94Ç43" at character 27
Statement: select * from rs_caixa_qr(395948 )
Date: 2026-09-03 12:25:36 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(395948 )
Date: 2026-09-03 12:25:37 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(34Ç53ÇD2ÇAAÇ94Ç43)
Date: 2026-09-03 14:59:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 03 07 2 17 2 - LOG: process 336058 still waiting for ShareLock on transaction 5507984 after 1000.092 ms
- LOG: process 336058 still waiting for ShareLock on transaction 5507984 after 7360.247 ms
- LOG: process 874519 still waiting for ShareLock on transaction 5558393 after 1000.139 ms
Detail: Process holding the lock: 330824. Wait queue: 336058.
Context: while updating tuple (78752,6) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-03 07:45:12 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 330824. Wait queue: 336058.
Context: while updating tuple (78752,6) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-03 07:45:18 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 877495. Wait queue: 874519.
Context: while updating tuple (78858,72) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-03 17:35:05 Database: rio Application: psql User: intelifix Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 03 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-03 05:32:00 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-03 05:32:00 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-03 05:32:00 Database: contagem Application: psql User: intelifix Remote: [local]
9 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 03 14 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(.3596149 )Date: 2026-09-03 14:59:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(.3596149 )Date: 2026-09-03 14:59:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 03 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-03 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 03 03 1 - LOG: database system was shut down at 2026-09-03 03:05:01 -03
Date: 2026-09-03 03:05:02
12 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 03 08 1 - ERROR: column "pas_id" does not exist at character 66 2026-09-03 08:58:58 -03 [383800]: [14-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
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(0135725);Date: 2026-09-03 08:58:58 Database: brasilia Application: [unknown] User: intelifix Remote: [local]