pgBadger-
Global information
- Generated on Tue Sep 15 23:50:17 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,044 log entries in 14s
- Log start from 2026-09-15 00:00:57 to 2026-09-15 23:49:44
-
Overview
Global Stats
- 387 Number of unique normalized queries
- 4,945 Number of queries
- 7h47m32s Total query duration
- 2026-09-15 00:02:21 First query
- 2026-09-15 23:43:23 Last query
- 5 queries/s at 2026-09-15 10:15:10 Query peak
- 7h47m32s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h47m32s Execute total duration
- 5,417 Number of events
- 12 Number of unique normalized events
- 5,360 Max number of times the same event was reported
- 0 Number of cancellation
- 377 Total number of automatic vacuums
- 803 Total number of automatic analyzes
- 28 Number temporary file
- 245.76 MiB Max size of temporary file
- 77.49 MiB Average size of temporary file
- 441 Total number of sessions
- 7 sessions at 2026-09-15 09:14:21 Session peak
- 12d20h16m49s Total duration of sessions
- 41m56s Average duration of sessions
- 11 Average queries per session
- 1m3s Average queries duration per session
- 40m52s Average idle time per session
- 456 Total number of connections
- 5 connections/s at 2026-09-15 00:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-15 10:15:10 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-15 10:15:10 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-15 23:43:19 Date
Queries duration
Key values
- 7h47m32s 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 15 00 31 0ms 54s13ms 5s605ms 5s716ms 19s198ms 1m28s 01 15 0ms 7s143ms 2s779ms 3s480ms 8s471ms 9s239ms 02 14 0ms 5s735ms 2s590ms 3s922ms 6s961ms 7s809ms 03 23 0ms 8s470ms 1s866ms 3s153ms 6s729ms 10s512ms 04 15 0ms 10s313ms 2s491ms 3s23ms 4s333ms 12s377ms 05 22 0ms 11m12s 1m6s 10s707ms 3m9s 11m12s 06 26 0ms 30s293ms 3s883ms 2s152ms 23s105ms 30s293ms 07 169 0ms 9m21s 13s607ms 1m12s 5m29s 11m14s 08 460 150ms 6m7s 4s909ms 43s982ms 5m56s 9m29s 09 588 150ms 6m12s 2s967ms 1m10s 2m10s 6m24s 10 518 152ms 6m5s 4s954ms 1m27s 4m25s 9m21s 11 530 150ms 6m13s 3s999ms 1m20s 4m32s 6m18s 12 119 0ms 5m48s 7s315ms 14s282ms 1m7s 5m49s 13 288 0ms 5m39s 3s390ms 18s896ms 53s430ms 5m45s 14 482 151ms 6m1s 4s371ms 51s527ms 5m41s 6m6s 15 577 150ms 6m12s 5s544ms 1m52s 6m2s 6m30s 16 364 150ms 6m24s 4s766ms 32s218ms 4m13s 7m17s 17 146 0ms 5m48s 5s938ms 27s791ms 52s868ms 5m49s 18 24 0ms 4m55s 23s895ms 2s61ms 52s76ms 4m55s 19 21 0ms 4m54s 26s866ms 1s982ms 44s106ms 4m54s 20 110 0ms 5m3s 10s227ms 1m2s 1m16s 6m49s 21 29 0ms 4m50s 20s2ms 6s434ms 44s649ms 4m50s 22 27 0ms 4m48s 21s612ms 6s763ms 42s845ms 4m48s 23 347 0ms 1m3s 5s745ms 1m6s 1m7s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 15 00 7 0 4s339ms 0ms 0ms 1s914ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 8 0 401ms 0ms 0ms 944ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 10 0 6s554ms 0ms 0ms 26s473ms 07 114 0 17s107ms 4s187ms 44s101ms 6m51s 08 362 0 4s665ms 10s188ms 24s648ms 6m10s 09 513 0 2s871ms 24s123ms 41s488ms 4m30s 10 392 0 4s521ms 23s261ms 1m12s 5m37s 11 426 0 3s917ms 24s413ms 1m7s 5m38s 12 81 0 9s555ms 2s935ms 5s695ms 4m4s 13 219 0 4s26ms 8s227ms 16s52ms 3m45s 14 389 0 4s409ms 10s489ms 50s648ms 5m54s 15 466 0 5s567ms 59s37ms 1m52s 6m18s 16 291 0 5s372ms 10s803ms 25s11ms 6m30s 17 105 0 7s198ms 2s783ms 14s204ms 3m50s 18 9 0 1m1s 0ms 0ms 3m28s 19 6 0 1m31s 0ms 0ms 3m27s 20 13 81 11s698ms 16s401ms 1m 3m27s 21 10 0 53s931ms 0ms 0ms 3m22s 22 6 0 1m29s 0ms 0ms 3m26s 23 24 323 5s745ms 1m3s 1m6s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 15 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 15 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 4 4.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 10 10.00 0.00% 08 0 14 14.00 0.00% 09 0 15 15.00 0.00% 10 0 12 12.00 0.00% 11 0 11 11.00 0.00% 12 0 6 6.00 0.00% 13 0 10 10.00 0.00% 14 0 11 11.00 0.00% 15 0 16 16.00 0.00% 16 0 7 7.00 0.00% 17 0 8 8.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 4 4.00 0.00% Day Hour Count Average / Second Sep 15 00 17 0.00/s 01 7 0.00/s 02 7 0.00/s 03 17 0.00/s 04 7 0.00/s 05 9 0.00/s 06 14 0.00/s 07 19 0.01/s 08 22 0.01/s 09 29 0.01/s 10 32 0.01/s 11 19 0.01/s 12 14 0.00/s 13 20 0.01/s 14 22 0.01/s 15 23 0.01/s 16 15 0.00/s 17 25 0.01/s 18 20 0.01/s 19 19 0.01/s 20 30 0.01/s 21 25 0.01/s 22 23 0.01/s 23 21 0.01/s Day Hour Count Average Duration Average idle time Sep 15 00 4 47m30s 46m46s 01 13 1h1m9s 1h1m6s 02 7 1h 59m55s 03 13 24m53s 24m50s 04 9 1h2m20s 1h2m16s 05 7 1h26s 56m58s 06 9 58m20s 58m9s 07 16 52m4s 49m41s 08 18 51m16s 49m11s 09 28 48m21s 47m19s 10 33 39m10s 37m52s 11 22 50m49s 49m12s 12 19 55m39s 54m53s 13 12 51m15s 49m54s 14 21 57m47s 56m7s 15 26 49m3s 47m 16 19 50m34s 49m3s 17 27 32m54s 32m22s 18 22 33m5s 32m39s 19 19 29m10s 28m41s 20 24 23m7s 22m20s 21 23 26m3s 25m38s 22 23 28m48s 28m23s 23 27 23m13s 21m59s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-09-15 00:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 456 connections Total
Connections per user
Key values
- intelifix Main User
- 456 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-15 09:14:21 Date
Histogram of session times
Key values
- 268 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 441 sessions Total
Sessions per user
Key values
- intelifix Main User
- 441 sessions Total
Sessions per host
Key values
- [local] Main Host
- 441 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 441 sessions Total
Application Count Total Duration Average Duration [unknown] 403 12d2h59m42s 43m19s pgAdmin 4 - CONN:451435 2 4s589ms 2s294ms pgAdmin 4 - CONN:7423557 2 28m8s 14m4s pgAdmin 4 - CONN:912901 2 3s668ms 1s834ms pgAdmin 4 - DB:postgres 3 28m49s 9m36s pgAdmin 4 - DB:rio 4 28m33s 7m8s pg_dump 9 42m36s 4m44s postgres_fdw 1 45m1s 45m1s psql 15 14h23m48s 57m35s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 48,666 buffers Checkpoint Peak
- 2026-09-15 00:09:45 Date
- 270.041 seconds Highest write time
- 0.177 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-09-15 15:44:39 Date
Checkpoints distance
Key values
- 366.28 Mo Distance Peak
- 2026-09-15 15:44:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 15 00 63,400 718.461s 0.027s 718.518s 01 2,376 237.884s 0.103s 238.011s 02 2,342 234.69s 0.097s 234.991s 03 2,507 249.284s 0.187s 249.508s 04 2,552 255.58s 0.111s 255.716s 05 9,956 989.027s 0.21s 989.336s 06 6,814 484.681s 0.13s 484.832s 07 32,169 2,202.834s 0.271s 2,203.224s 08 56,006 3,204.872s 0.716s 3,205.768s 09 77,894 3,238.629s 0.908s 3,239.72s 10 50,433 3,224.949s 0.535s 3,225.642s 11 53,805 3,239.243s 0.329s 3,239.732s 12 22,437 1,732.781s 0.25s 1,733.101s 13 34,973 1,925.9s 0.254s 1,926.223s 14 52,102 3,239.218s 0.357s 3,239.78s 15 49,413 3,239.165s 0.431s 3,239.7s 16 38,448 2,923.159s 0.255s 2,923.506s 17 12,530 1,268.52s 0.321s 1,268.968s 18 1,240 124.419s 0.078s 124.517s 19 31 3.121s 0.012s 3.14s 20 460 142.043s 0.015s 142.066s 21 3,747 375.382s 0.09s 375.497s 22 3,295 329.874s 0.023s 329.985s 23 342 34.302s 0.069s 34.39s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 15 00 0 0 10 484 0.005s 0.006s 01 0 0 1 402 0.063s 0.006s 02 0 0 1 398 0.063s 0.006s 03 0 0 1 533 0.031s 0.012s 04 0 0 0 450 0.013s 0.007s 05 0 0 4 622 0.063s 0.01s 06 0 0 1 107 0.062s 0.011s 07 0 0 23 2,284 0.062s 0.013s 08 0 0 33 5,616 0.077s 0.012s 09 0 0 37 7,545 0.052s 0.012s 10 0 0 40 7,254 0.063s 0.012s 11 0 0 42 7,353 0.058s 0.012s 12 0 0 10 2,850 0.062s 0.012s 13 0 0 16 4,283 0.061s 0.012s 14 0 0 35 5,310 0.033s 0.012s 15 0 0 52 6,176 0.063s 0.012s 16 0 0 26 4,976 0.063s 0.012s 17 0 0 13 2,937 0.063s 0.011s 18 0 0 0 182 0.066s 0.006s 19 0 0 0 10 0.008s 0.005s 20 0 0 1 91 0.006s 0.003s 21 0 0 1 509 0.062s 0.006s 22 0 0 1 480 0.004s 0.007s 23 0 0 0 31 0.062s 0.013s Day Hour Count Avg time (sec) Sep 15 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 15 00 28,416.67 kB 72,798.83 kB 01 2,010.00 kB 40,433.83 kB 02 2,002.17 kB 22,369.83 kB 03 1,440.56 kB 4,039.89 kB 04 1,969.00 kB 3,091.86 kB 05 7,416.44 kB 13,563.33 kB 06 4,210.75 kB 10,750.25 kB 07 30,780.83 kB 65,440.75 kB 08 44,418.00 kB 95,562.00 kB 09 51,021.67 kB 117,807.17 kB 10 54,264.00 kB 108,953.75 kB 11 57,673.08 kB 96,393.33 kB 12 13,705.00 kB 61,104.33 kB 13 21,425.67 kB 37,934.75 kB 14 47,717.25 kB 82,795.25 kB 15 71,399.25 kB 147,361.50 kB 16 35,416.75 kB 98,706.75 kB 17 19,546.00 kB 46,457.45 kB 18 1,159.60 kB 22,481.80 kB 19 105.00 kB 15,609.50 kB 20 4,672.33 kB 13,151.00 kB 21 3,146.50 kB 9,225.67 kB 22 2,554.14 kB 6,076.43 kB 23 167.40 kB 3,862.60 kB -
Temporary Files
Size of temporary files
Key values
- 491.52 MiB Temp Files size Peak
- 2026-09-15 05:32:00 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-15 05:32:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 66.88 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 3 311.99 MiB 104.00 MiB 11 2 207.99 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 3 311.99 MiB 104.00 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.65 MiB 245.76 MiB 64.49 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-15 05:32:09 Duration: 1m25s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-15 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 8 831.97 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( 029890, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 07:28:16 Duration: 6m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029927, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 16:07:32 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029907, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 11:04:40 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 4 305.76 MiB 56.84 MiB 93.53 MiB 76.44 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-15 05:30:44 Duration: 41s783ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-15 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 245.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 245.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-15 11:54:35 - 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-15 11:48:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 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-15 15:00:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 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-15 15:24:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 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-15 10:25:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 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-15 10:21:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 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-15 15:37:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 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-15 10:34:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 93.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-15 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 93.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-15 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 61.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-15 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 56.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-15 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 40.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 40.54 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 40.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 40.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-15 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 18.09 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-15 09:16:54 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 18.09 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-15 09:16:54 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (109) Main table analyzed (database rio)
- 803 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 109 rio.pg_catalog.pg_class 52 brasilia.pg_catalog.pg_attribute 47 rio.public.usuarios 46 rio.pg_catalog.pg_type 44 rio.public.temp0000291415 44 rio.pg_catalog.pg_index 30 rio.public.temp0000291505 25 brasilia.pg_catalog.pg_class 25 brasilia.pg_catalog.pg_type 22 rio.pg_catalog.pg_depend 21 rio.public.temp0000291475 19 contagem.pg_catalog.pg_attribute 18 brasilia.pg_catalog.pg_index 15 rio.public.temp0000291411 14 brasilia.public.temp0000240160 13 rio.public.temp0000291083 13 contagem.pg_catalog.pg_class 12 rio.public.temp0000291479 12 rio.public.temp0000290026 12 rio.public.temp0000291435 11 contagem.pg_catalog.pg_type 10 brasilia.public.temp0000240232 10 brasilia.public.usuarios 9 brasilia.pg_catalog.pg_depend 9 rio.public.temp0000291425 9 rio.public.temp0000290230 9 rio.public.temp0000291257 8 rio.public.temp0000291413 7 rio.public.temp0000291547 7 rio.public.tmp_drill_0175 6 rio.public.temp0000291391 6 contagem.pg_catalog.pg_index 6 rio.public.temp0000291533 6 rio.public.tmp_drill_0320 6 contagem.public.usuarios 5 contagem.pg_catalog.pg_depend 5 brasilia.public.temp0000240166 5 rio.public.temp0000291489 4 brasilia.public.nf_entrada 3 contagem.pg_catalog.pg_shdepend 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000290787 3 rio.public.temp0000290893 3 brasilia.public.temp0000240172 2 brasilia.public.temp0000240214 2 brasilia.public.temp0000240208 2 rio.pg_catalog.pg_shdepend 2 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000291429 2 contagem.public.temp0000227170 2 brasilia.public.temp0000240218 2 brasilia.public.temp0000240206 2 rio.public.temp0000291507 2 rio.public.temp0000291515 2 brasilia.public.temp0000240204 2 contagem.public.temp0000227160 2 rio.public.temp0000291495 2 brasilia.public.temp0000240252 2 brasilia.public.temp0000240234 1 brasilia.public.temp0000240186 1 brasilia.public.temp0000240230 1 contagem.public.temp0000227155 1 rio.public.temp0000291431 1 rio.public.temp0000291427 1 brasilia.public.temp0000240198 1 rio.public.temp0000291407 1 rio.public.temp0000291535 1 brasilia.public.temp0000240248 1 brasilia.public.temp0000240244 1 brasilia.public.temp0000240216 1 rio.public.temp0000291517 1 brasilia.public.temp0000240182 1 rio.public.temp0000291417 1 rio.public.temp0000291433 1 rio.public.temp0000291449 1 rio.public.temp0000291423 1 brasilia.auditor.auditor_2026_09 1 rio.public.temp0000291437 1 contagem.public.temp0000227135 1 brasilia.public.temp0000240194 1 brasilia.public.temp0000240224 1 rio.public.temp0000291511 1 contagem.public.nf_entrada 1 brasilia.public.temp0000240222 1 brasilia.public.temp0000240190 1 Total 803 Vacuums per table
Key values
- public.temp0000291415 (44) Main table vacuumed on database rio
- 377 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000291415 44 0 0 0 0 0 0 33,463 201 2,004,862 0 0 rio.pg_catalog.pg_attribute 40 36 0 0 0 0 0 18,080 5,510 7,950,470 352 8,631 rio.pg_catalog.pg_class 23 19 0 0 0 0 0 3,705 1,322 1,968,376 69 266 rio.pg_catalog.pg_type 21 17 0 0 0 0 0 1,739 613 803,502 68 213 brasilia.pg_catalog.pg_attribute 16 16 0 0 0 0 0 8,484 1,911 3,244,466 56 1,427 rio.public.temp0000291083 13 0 0 0 0 0 0 909 311 455,805 0 0 rio.public.temp0000291479 12 0 0 0 0 0 0 12,688 3,641 5,401,539 0 0 brasilia.pg_catalog.pg_class 10 10 0 0 0 0 0 1,751 473 789,855 25 102 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 644 211 197,359 42 98 brasilia.pg_catalog.pg_type 9 9 0 0 0 0 0 773 230 321,916 14 56 rio.public.tmp_drill_0320 9 5 0 0 0 0 0 2,089 36 371,875 1 11 rio.public.temp0000291475 9 0 0 0 0 0 0 2,287 48 142,134 0 0 rio.public.tmp_drill_0175 9 4 0 0 0 0 0 341 71 126,679 1 26 rio.public.temp0000290026 8 0 0 0 0 0 0 653 102 133,845 0 0 rio.public.temp0000290230 8 0 0 0 0 0 0 604 192 269,798 0 0 rio.pg_catalog.pg_depend 8 8 0 0 0 0 0 2,788 1,055 1,607,011 61 510 contagem.pg_catalog.pg_attribute 7 7 0 0 0 0 0 3,928 1,157 1,941,374 16 377 rio.public.usuarios 7 3 0 0 0 0 0 97 38 79,283 9 24 rio.public.temp0000291547 7 0 0 0 0 0 0 3,892 157 445,666 0 0 rio.public.temp0000291391 6 0 0 0 0 0 0 3,687 24 221,457 0 0 rio.public.temp0000291505 6 0 0 0 0 0 0 251 28 19,508 0 0 rio.public.temp0000291533 6 0 0 0 0 0 0 7,213 1,820 2,754,810 0 0 contagem.public.usuarios 6 0 0 0 0 0 0 25 19 12,792 0 0 brasilia.pg_catalog.pg_index 6 6 0 0 0 0 0 259 88 66,172 11 24 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 7,855 1,932 8,411,000 1,069 5,478 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 831 242 371,332 8 29 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 398 111 164,379 4 9 rio.public.temp0000290787 3 0 0 0 0 0 0 222 113 175,461 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 835 282 570,266 6 49 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 474 165 269,331 27 60 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,177 733 2,863,020 519 3,140 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 781 175 323,968 6 75 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,762 433 2,333,477 141 479 brasilia.public.temp0000240214 2 0 0 0 0 0 0 257 8 18,361 0 0 brasilia.public.temp0000240208 2 0 0 0 0 0 0 504 257 419,782 0 0 rio.public.temp0000291515 2 0 0 0 0 0 0 133 10 9,323 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 323 76 295,976 26 56 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 118 33 38,605 3 6 contagem.public.temp0000227160 2 0 0 0 0 0 0 231 12 15,566 0 0 rio.public.temp0000291435 2 0 0 0 0 0 0 63 11 5,282 0 0 rio.public.temp0000291495 2 0 0 0 0 0 0 77 9 5,971 0 0 rio.public.temp0000291507 2 0 0 0 0 0 0 1,870 10 111,810 0 0 brasilia.public.temp0000240218 2 0 0 0 0 0 0 504 257 419,977 0 0 rio.public.temp0000291511 1 0 0 0 0 0 0 68 6 4,889 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 4,074 3,916 10,447,964 93 4,179 rio.public.temp0000291407 1 0 0 0 0 0 0 61 6 4,463 0 0 brasilia.public.temp0000240198 1 0 0 0 0 0 0 253 4 15,529 0 0 rio.public.temp0000291517 1 0 0 0 0 0 0 118 116 196,260 0 0 brasilia.public.temp0000240216 1 0 0 0 0 0 0 252 4 15,471 0 0 brasilia.public.temp0000240244 1 0 0 0 0 0 0 253 4 15,530 0 0 brasilia.public.temp0000240190 1 0 0 0 0 0 0 252 4 15,471 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 16,657 14,030 17,728,108 1,226 22,430 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 147 29 96,154 4 14 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 30,216 12,442 17,445,064 8,889 202,605 rio.public.temp0000291423 1 0 0 0 0 0 0 63 6 4,582 0 0 rio.public.temp0000291433 1 0 0 0 0 0 0 63 6 4,583 0 0 rio.public.temp0000291437 1 0 0 0 0 0 0 8 5 1,257 0 0 rio.auditor.auditor_2026_09 1 0 0 0 0 0 0 68,637 47,578 59,919,324 10,394 217,296 brasilia.public.temp0000240234 1 0 0 0 0 0 0 253 4 15,530 0 0 contagem.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 149 44 64,043 8 10 rio.public.temp0000291429 1 0 0 0 0 0 0 63 6 4,583 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,302 106 483,792 84 762 rio.public.temp0000291427 1 0 0 0 0 0 0 63 6 4,582 0 0 rio.public.temp0000291431 1 0 0 0 0 0 0 63 6 4,583 0 0 brasilia.public.temp0000240172 1 0 0 0 0 0 0 252 4 15,471 0 0 brasilia.public.temp0000240224 1 0 0 0 0 0 0 252 4 15,471 0 0 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 226 90 118,492 13 30 Total 377 188 0 0 0 0 0 256,510 102,553 154,794,637 23,245 468,472 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (18.09) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000291415 0 0 1.09 rio.pg_catalog.pg_attribute 0 0 2.78 rio.pg_catalog.pg_class 0 0 0.88 rio.pg_catalog.pg_type 0 0 0.4 brasilia.pg_catalog.pg_attribute 0 0 1.72 rio.public.temp0000291083 0 0 0.06 rio.public.temp0000291479 0 0 0.5 brasilia.pg_catalog.pg_class 0 0 0.74 rio.pg_catalog.pg_index 0 0 0.22 brasilia.pg_catalog.pg_type 0 0 0.53 rio.public.tmp_drill_0320 0 0 0.08 rio.public.temp0000291475 0 0 0.06 rio.public.tmp_drill_0175 0 0 0 rio.public.temp0000290026 0 0 0.05 rio.public.temp0000290230 0 0 0.02 rio.pg_catalog.pg_depend 0 0 0.69 contagem.pg_catalog.pg_attribute 0 0 1.41 rio.public.usuarios 0 0 0 rio.public.temp0000291547 0 0 0.11 rio.public.temp0000291391 0 0 0.21 rio.public.temp0000291505 0 0 0.02 rio.public.temp0000291533 0 0 0.31 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.33 rio.pg_catalog.pg_statistic 0 0 1.14 contagem.pg_catalog.pg_class 0 0 0.98 contagem.pg_catalog.pg_type 0 0 0.36 rio.public.temp0000290787 0 0 0.02 contagem.pg_catalog.pg_depend 0 0 0.54 postgres.pg_catalog.pg_shdepend 0 0 0.56 brasilia.pg_catalog.pg_statistic 0 0 0.48 brasilia.pg_catalog.pg_depend 0 0 0.49 rio.pg_toast.pg_toast_2619 0 0 0.22 brasilia.public.temp0000240214 0 0 0 brasilia.public.temp0000240208 0 0 0 rio.public.temp0000291515 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.03 contagem.pg_catalog.pg_index 0 0 0.19 contagem.public.temp0000227160 0 0 0 rio.public.temp0000291435 0 0 0 rio.public.temp0000291495 0 0 0.05 rio.public.temp0000291507 0 0 0.04 brasilia.public.temp0000240218 0 0 0 rio.public.temp0000291511 0 0 0.01 rio.public.nf_entrada_arquivo_erros 0 0 2.25 rio.public.temp0000291407 0 0 0 brasilia.public.temp0000240198 0 0 0 rio.public.temp0000291517 0 0 0.01 brasilia.public.temp0000240216 0 0 0 brasilia.public.temp0000240244 0 0 0 brasilia.public.temp0000240190 0 0 0 contagem.auditor.auditor_2026_09 0 0 5.94 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.auditor.auditor_2026_09 0 0 4.98 rio.public.temp0000291423 0 0 0.01 rio.public.temp0000291433 0 0 0 rio.public.temp0000291437 0 0 0 rio.auditor.auditor_2026_09 0 0 18.09 brasilia.public.temp0000240234 0 0 0 contagem.pg_catalog.pg_shdepend 0 0 0.15 rio.public.temp0000291429 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.1 rio.public.temp0000291427 0 0 0 rio.public.temp0000291431 0 0 0 brasilia.public.temp0000240172 0 0 0 brasilia.public.temp0000240224 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.15 Total 0 0 49 Tuples removed per table
Key values
- pg_catalog.pg_attribute (133165) Main table with removed tuples on database rio
- 325798 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 40 36 133,165 987,450 55,897 128 23,069 brasilia.pg_catalog.pg_attribute 16 16 73,525 368,174 8,338 352 9,298 rio.public.tmp_drill_0320 9 5 30,563 80,982 24,731 0 1,418 contagem.pg_catalog.pg_attribute 7 7 25,685 168,606 0 228 3,681 rio.pg_catalog.pg_statistic 6 6 11,115 48,476 172 0 7,716 rio.pg_catalog.pg_depend 8 8 6,960 154,307 2,288 0 1,496 brasilia.pg_catalog.pg_statistic 3 3 6,191 23,359 0 0 3,216 rio.pg_catalog.pg_type 21 17 5,415 51,085 3,606 4 1,493 contagem.pg_catalog.pg_statistic 1 1 4,298 7,274 0 0 1,011 rio.public.tmp_drill_0175 9 4 4,210 24,108 9,949 0 366 rio.pg_catalog.pg_class 23 19 3,131 89,614 9,973 26 3,031 postgres.pg_catalog.pg_shdepend 3 3 3,044 40,806 0 0 375 brasilia.pg_catalog.pg_type 9 9 2,850 20,773 806 38 594 rio.pg_catalog.pg_index 10 10 2,478 19,625 422 0 570 rio.auditor.auditor_2026_09 1 0 1,965 9,694,035 0 0 445,972 contagem.pg_catalog.pg_depend 3 3 1,576 56,381 0 0 534 brasilia.pg_catalog.pg_index 6 6 1,433 11,743 405 7 314 brasilia.pg_catalog.pg_shdepend 1 1 1,267 13,571 0 0 125 brasilia.pg_catalog.pg_class 10 10 1,191 36,073 2,060 30 1,250 contagem.pg_catalog.pg_type 4 4 1,140 9,022 0 30 246 rio.pg_toast.pg_toast_2619 3 3 968 2,161 3 0 789 brasilia.pg_catalog.pg_depend 3 3 710 57,048 2,618 17 529 contagem.pg_catalog.pg_shdepend 1 1 691 13,743 126 0 125 contagem.pg_catalog.pg_class 5 5 655 18,286 0 20 710 contagem.pg_catalog.pg_index 2 2 481 3,805 0 11 98 contagem.public.usuarios 6 0 361 144 0 0 12 rio.public.usuarios 7 3 256 4,569 1,006 0 133 brasilia.pg_toast.pg_toast_2619 2 2 230 297 0 0 144 contagem.pg_toast.pg_toast_2619 1 1 141 117 0 0 60 rio.public.nf_entrada_arquivo_erros 1 0 80 8,851,025 0 0 160,848 brasilia.auditor.auditor_2026_09 1 0 23 2,392,623 0 0 104,224 brasilia.public.temp0000240214 2 0 0 6,624 0 0 512 rio.public.temp0000290787 3 0 0 8,998 0 58 198 rio.public.temp0000291391 6 0 0 128,610 0 63 9,345 rio.public.temp0000291505 6 0 0 21,634 0 84 556 rio.public.temp0000291511 1 0 0 1,175 0 4 60 brasilia.public.temp0000240208 2 0 0 6,626 0 0 512 rio.public.temp0000291515 2 0 0 2,353 0 4 124 rio.public.temp0000291407 1 0 0 1,018 0 11 53 brasilia.public.temp0000240198 1 0 0 3,313 0 0 256 rio.public.temp0000291479 12 0 0 256,976 0 15 18,673 rio.public.temp0000291517 1 0 0 4,975 0 18 110 brasilia.public.temp0000240216 1 0 0 3,313 0 0 256 contagem.public.temp0000227160 2 0 0 2,747 0 42 214 rio.public.temp0000291435 2 0 0 3,667 0 48 80 brasilia.public.temp0000240244 1 0 0 3,317 0 0 256 brasilia.public.temp0000240190 1 0 0 3,313 0 0 256 contagem.auditor.auditor_2026_09 1 0 0 1,834,751 0 0 81,025 rio.public.temp0000291533 6 0 0 152,961 0 0 11,136 rio.public.temp0000290026 8 0 0 28,417 0 205 627 rio.public.temp0000290230 8 0 0 29,399 0 183 649 rio.public.temp0000291495 2 0 0 26,731 0 63 1,921 rio.public.temp0000291423 1 0 0 1,060 0 9 55 rio.public.temp0000291415 44 0 0 585,507 0 360 42,136 rio.public.temp0000291433 1 0 0 1,062 0 9 55 rio.public.temp0000291475 9 0 0 47,089 0 221 2,403 rio.public.temp0000291437 1 0 0 1,064 0 9 55 brasilia.public.temp0000240234 1 0 0 3,315 0 0 256 rio.public.temp0000291429 1 0 0 1,062 0 9 55 rio.public.temp0000291083 13 0 0 41,712 0 360 920 rio.public.temp0000291427 1 0 0 1,061 0 9 55 rio.public.temp0000291431 1 0 0 1,062 0 9 55 brasilia.public.temp0000240172 1 0 0 3,313 0 0 256 rio.public.temp0000291507 2 0 0 26,672 0 4 1,916 rio.public.temp0000291547 7 0 0 61,413 0 250 4,102 brasilia.public.temp0000240224 1 0 0 3,313 0 0 256 brasilia.public.temp0000240218 2 0 0 6,625 0 0 512 Total 377 188 325,798 26,565,530 122,400 2,938 953,353 Pages removed per table
Key values
- public.temp0000291415 (360) Main table with removed pages on database rio
- 2938 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291415 44 0 0 360 rio.public.temp0000291083 13 0 0 360 brasilia.pg_catalog.pg_attribute 16 16 73525 352 rio.public.temp0000291547 7 0 0 250 contagem.pg_catalog.pg_attribute 7 7 25685 228 rio.public.temp0000291475 9 0 0 221 rio.public.temp0000290026 8 0 0 205 rio.public.temp0000290230 8 0 0 183 rio.pg_catalog.pg_attribute 40 36 133165 128 rio.public.temp0000291505 6 0 0 84 rio.public.temp0000291391 6 0 0 63 rio.public.temp0000291495 2 0 0 63 rio.public.temp0000290787 3 0 0 58 rio.public.temp0000291435 2 0 0 48 contagem.public.temp0000227160 2 0 0 42 brasilia.pg_catalog.pg_type 9 9 2850 38 brasilia.pg_catalog.pg_class 10 10 1191 30 contagem.pg_catalog.pg_type 4 4 1140 30 rio.pg_catalog.pg_class 23 19 3131 26 contagem.pg_catalog.pg_class 5 5 655 20 rio.public.temp0000291517 1 0 0 18 brasilia.pg_catalog.pg_depend 3 3 710 17 rio.public.temp0000291479 12 0 0 15 rio.public.temp0000291407 1 0 0 11 contagem.pg_catalog.pg_index 2 2 481 11 rio.public.temp0000291423 1 0 0 9 rio.public.temp0000291433 1 0 0 9 rio.public.temp0000291437 1 0 0 9 rio.public.temp0000291429 1 0 0 9 rio.public.temp0000291427 1 0 0 9 rio.public.temp0000291431 1 0 0 9 brasilia.pg_catalog.pg_index 6 6 1433 7 rio.public.temp0000291511 1 0 0 4 rio.public.temp0000291515 2 0 0 4 rio.pg_catalog.pg_type 21 17 5415 4 rio.public.temp0000291507 2 0 0 4 brasilia.public.temp0000240214 2 0 0 0 rio.public.nf_entrada_arquivo_erros 1 0 80 0 contagem.pg_catalog.pg_depend 3 3 1576 0 brasilia.public.temp0000240208 2 0 0 0 brasilia.public.temp0000240198 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 230 0 brasilia.public.temp0000240216 1 0 0 0 brasilia.public.temp0000240244 1 0 0 0 brasilia.public.temp0000240190 1 0 0 0 rio.public.tmp_drill_0320 9 5 30563 0 contagem.auditor.auditor_2026_09 1 0 0 0 postgres.pg_catalog.pg_shdepend 3 3 3044 0 rio.public.temp0000291533 6 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6191 0 contagem.public.usuarios 6 0 361 0 contagem.pg_toast.pg_toast_2619 1 1 141 0 brasilia.auditor.auditor_2026_09 1 0 23 0 rio.public.usuarios 7 3 256 0 rio.auditor.auditor_2026_09 1 0 1965 0 brasilia.public.temp0000240234 1 0 0 0 contagem.pg_catalog.pg_shdepend 1 1 691 0 rio.public.tmp_drill_0175 9 4 4210 0 contagem.pg_catalog.pg_statistic 1 1 4298 0 brasilia.public.temp0000240172 1 0 0 0 rio.pg_catalog.pg_index 10 10 2478 0 rio.pg_toast.pg_toast_2619 3 3 968 0 brasilia.public.temp0000240224 1 0 0 0 brasilia.pg_catalog.pg_shdepend 1 1 1267 0 brasilia.public.temp0000240218 2 0 0 0 rio.pg_catalog.pg_depend 8 8 6960 0 rio.pg_catalog.pg_statistic 6 6 11115 0 Total 377 188 325,798 2,938 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 15 00 0 1 01 0 0 02 0 0 03 0 0 04 0 0 05 7 0 06 0 0 07 35 30 08 34 81 09 37 105 10 43 107 11 56 112 12 4 14 13 34 67 14 24 70 15 67 109 16 22 64 17 12 38 18 0 0 19 0 0 20 0 0 21 2 5 22 0 0 23 0 0 - 18.09 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 6m13s 3m1s 3m12s 3m6s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 08:58:24 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 10:18:16 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 00:06:09 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 3m12s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-15 08:58:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 3m1s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-15 10:18:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 3,451 Total read queries
- 990 Total write queries
Queries by database
Key values
- rio Main database
- 3,266 Requests
- 5h54m29s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,794 Requests
User Request type Count Duration etiquetas Total 41 15s430ms select 41 15s430ms intelifix Total 4,794 7h45m30s copy to 404 42m4s ddl 586 44m others 504 53m20s select 3,300 5h26m4s lenon Total 110 1m47s select 110 1m47s Duration by user
Key values
- 7h45m30s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 41 15s430ms select 41 15s430ms intelifix Total 4,794 7h45m30s copy to 404 42m4s ddl 586 44m others 504 53m20s select 3,300 5h26m4s lenon Total 110 1m47s select 110 1m47s Queries by host
Key values
- [local] Main host
- 4,941 Requests
- 7h47m13s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,828 Requests
- 3h54m38s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-15 09:45:08 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,093 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m12s analyze verbose;[ Date: 2026-09-15 05:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 07:14:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m12s analyze verbose;[ Date: 2026-09-15 05:18:26 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
4 6m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029890, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 07:28:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029927, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 16:07:32 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 6m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029907, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 11:04:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029923, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 15:43:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 09:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029920, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 15:20:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029897, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 08:58:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 6m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 16:11:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029900, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 10:18:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 6m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029917, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 14:53:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029896, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 08:34:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 15:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 17:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m48s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029914, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-15 14:22:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 12:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 13:10:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-15 14:10:38 - 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 1h37m33s 48 1s400ms 9m21s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 15 07 3 10m7s 3m22s 08 3 5m48s 1m56s 09 3 6m51s 2m17s 10 3 6m1s 2m 11 3 5m53s 1m57s 12 3 6m9s 2m3s 13 3 5m56s 1m58s 14 3 5m55s 1m58s 15 3 6m14s 2m4s 16 3 6m28s 2m9s 17 3 6m7s 2m2s 18 3 5m16s 1m45s 19 3 5m10s 1m43s 20 3 5m20s 1m46s 21 3 5m6s 1m42s 22 3 5m4s 1m41s [ User: intelifix - Total duration: 1h37m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 07:14:23 Duration: 9m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 09:11:13 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 16:11:08 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: psql
2 1h30m55s 213 156ms 6m50s 25s614ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 15 06 2 37s340ms 18s670ms 07 13 13m20s 1m1s 08 12 13m 1m5s 09 41 4m30s 6s600ms 10 19 10m9s 32s88ms 11 18 8m46s 29s248ms 12 2 1s470ms 735ms 13 23 25s112ms 1s91ms 14 25 12m13s 29s350ms 15 20 17m7s 51s355ms 16 24 10m5s 25s243ms 17 14 37s507ms 2s679ms [ User: intelifix - Total duration: 1h30m55s - Times executed: 213 ]
[ Application: [unknown] - Total duration: 1h30m55s - Times executed: 213 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029890, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 07:28:16 Duration: 6m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029927, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 16:07:32 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029907, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 11:04:40 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h11m46s 48 225ms 4m21s 1m29s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 15 07 3 5m44s 1m54s 08 3 4m29s 1m29s 09 3 6m1s 2m 10 3 4m34s 1m31s 11 3 4m36s 1m32s 12 3 4m34s 1m31s 13 3 4m15s 1m25s 14 3 4m27s 1m29s 15 3 4m36s 1m32s 16 3 4m30s 1m30s 17 3 4m20s 1m26s 18 3 3m56s 1m18s 19 3 3m55s 1m18s 20 3 3m56s 1m18s 21 3 3m51s 1m17s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h11m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h11m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 09:17:52 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 07:20:43 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 11:15:29 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m35s 3 3m9s 11m12s 7m11s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 15 05 3 21m35s 7m11s [ User: intelifix - Total duration: 21m35s - Times executed: 3 ]
[ Application: psql - Total duration: 21m35s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-15 05:11:14 Duration: 11m12s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-15 05:18:26 Duration: 7m12s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-15 05:21:36 Duration: 3m9s Database: contagem User: intelifix Remote: [local] Application: psql
5 20m 1,127 150ms 9s125ms 1s64ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 15 07 6 8s747ms 1s457ms 08 127 2m11s 1s33ms 09 153 2m54s 1s143ms 10 113 2m10s 1s155ms 11 175 2m51s 978ms 12 14 14s904ms 1s64ms 13 70 1m39s 1s427ms 14 148 2m35s 1s49ms 15 170 2m51s 1s9ms 16 133 2m4s 938ms 17 18 16s676ms 926ms [ User: intelifix - Total duration: 20m - Times executed: 1127 ]
[ Application: [unknown] - Total duration: 20m - Times executed: 1127 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287343, 404, '71503785850011529550,216511898788,216819812645,216520186870,216698707985,216819582746,216838890624,216357418291,216869887183,216838071116,216862419091,216756216370,216862441216,216861819707,216612623131', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 08:17:19 Duration: 9s125ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287486, 450, '723054096750,B4F2675DF3CC,6802B8AC7C6D,6802B814E6B4,6802B81434A9,6802B8CF176D,6802B850658B,6802B8A3C07B,6802B8F8A1E2,B4F267577822,6802B8BE9E75,B4F26758C9A2,6802B8A204A2,B4F267204414,6802B8A3C3FF,B4F267347726,6802B8A3C579,6802B8DBBA1D,6802B8ACB339,6802B85237D5,6802B8648BA6,6802B8A1DE29,6802B8F03C1D,6802B8DFA9AB,6802B8DFBEF0,6802B8633792,B4F2674EE1E1,B4F26734EE9C,6802B81448E0,6802B8A3D7C7,6802B8DEDB8F,6802B8F80303,B4F2675DF00F,6802B8A0F8BB,6802B8A4D86E,6802B8A28650,6802B814D874,6802B8DEB450,B4F2675DF1D1,6802B823F3A9,6802B8F7180D', '',0156,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 13:58:06 Duration: 5s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287613, 450, 'CP2439LV6BU,C4509CF3DBBC$CP2248LV8W0,B85E71D9EBBC$CP2527LV7TT,F8D2AC4904D0$CP2048LV6N4,484BD4A3BB84$CP2429LV1SK,C4509CB07924$CP2147LVAQV,D4E2CB96C95C$CP2527LV83W,F8D2AC48BFC0$CP2435LV6ND,C4509CF25D24$CP2233LV2AH,4075C3B3A4B0$CP2239LVM7U,B85E71BC2D98$CP2244LV239,B85E71D0BF10$CP2107LV4GK,E4BFFAF43C34$CP2125LV1FL,08A7C070F19C$CP2146LV25A,D4E2CB925184$CP2205LV4NY,1C9D7286616C$CP2233LV09G,4075C39C7218$CP2249LVB4M,B85E71DF1024$CP2531LV03H,3C82C08F71D0$CP2210LV4EU,3C82C0CCB57C$CP2242LV31J,B85E71C64968$CP2248LV3GV,B85E71EF1EEC$CP2110LVFY1,08A7C04B5C34$CP2218LV8GY,3C82C0C6338C$CP2120LV2YH,08A7C06D3FDC$CP2522LV3TC,B85E710C7F78$CP2429LV3FA,C4509CAED944$CP2527LV1B8,F8D2AC49BA24$CP2250LV0JB,B85E71E11BF8$CP2109LV26L,E4BFFAF62E04$CP2346LV3EZ,CCF3C848C9D4$CP2233LV0TU,4075C3B3CF1C$CP2051LV839,484BD4AAD74C$CP2432LV48J,C4509CE78A44$CP2346LV0WU,400FC17EB69C$CP2534LV3Q4,3C82C091C3F4$CP2131LVK8M,ECA81F1B035C$CP2250LV32P,B85E71E089A4$CP2529LV6GZ,3C82C08AF2B8$CP2131LV18W,ECA81F1978C4$CP2248LV5NM,B85E71DA3400', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 16:32:27 Duration: 4s643ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 17m54s 84 1s237ms 1m36s 12s788ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 15 07 2 16s320ms 8s160ms 08 3 17s69ms 5s689ms 09 3 12s633ms 4s211ms 10 11 2m45s 15s21ms 11 9 2m9s 14s334ms 12 6 1m30s 15s134ms 13 6 19s771ms 3s295ms 14 9 1m14s 8s327ms 15 16 7m13s 27s78ms 16 10 1m13s 7s356ms 17 8 38s514ms 4s814ms 18 1 3s96ms 3s96ms [ User: intelifix - Total duration: 17m54s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 84 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-15 15:21:48 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-15 15:44:02 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-15', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-15 11:22:33 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 17m21s 70 10s731ms 1m6s 14s880ms create table temp0000291415 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 15 07 8 1m28s 11s56ms 08 14 2m47s 11s976ms 10 12 3m20s 16s671ms 11 6 2m8s 21s411ms 14 15 3m44s 14s945ms 15 12 3m14s 16s224ms 16 3 38s88ms 12s696ms [ User: intelifix - Total duration: 17m21s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 17m21s - Times executed: 70 ]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 11:18:13 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 10:10:10 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:13:39 Duration: 57s665ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 12m40s 158 180ms 54s13ms 4s810ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 15 00 6 1m19s 13s167ms 01 6 29s943ms 4s990ms 02 6 24s376ms 4s62ms 03 5 27s795ms 5s559ms 04 6 25s556ms 4s259ms 05 5 18s266ms 3s653ms 07 10 50s88ms 5s8ms 08 12 1m1s 5s159ms 09 13 51s127ms 3s932ms 10 12 1m3s 5s261ms 11 12 1m15s 6s252ms 12 12 1m2s 5s190ms 13 7 12s927ms 1s846ms 14 12 39s232ms 3s269ms 15 10 1m1s 6s188ms 16 7 24s49ms 3s435ms 17 6 4s8ms 668ms 21 5 21s83ms 4s216ms 22 6 28s315ms 4s719ms [ User: intelifix - Total duration: 12m40s - Times executed: 158 ]
[ Application: psql - Total duration: 12m40s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 00:05:55 Duration: 54s13ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 15:05:15 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 11:35:15 Duration: 13s410ms Database: rio User: intelifix Remote: [local] Application: psql
9 12m4s 236 150ms 3m14s 3s70ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 15 00 12 29s709ms 2s475ms 01 9 11s749ms 1s305ms 02 8 11s888ms 1s486ms 03 10 11s931ms 1s193ms 04 9 11s816ms 1s312ms 05 11 14s646ms 1s331ms 06 12 12s487ms 1s40ms 07 12 19s976ms 1s664ms 08 12 3m26s 17s244ms 09 10 15s249ms 1s524ms 10 11 3m20s 18s233ms 11 12 15s971ms 1s330ms 12 9 12s338ms 1s370ms 13 12 19s83ms 1s590ms 14 11 18s606ms 1s691ms 15 12 18s524ms 1s543ms 16 10 14s494ms 1s449ms 17 11 13s403ms 1s218ms 18 9 11s925ms 1s325ms 19 9 11s477ms 1s275ms 20 9 19s480ms 2s164ms 21 7 10s839ms 1s548ms 22 9 11s493ms 1s277ms [ User: intelifix - Total duration: 12m4s - Times executed: 236 ]
[ Application: psql - Total duration: 12m4s - Times executed: 236 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 08:58:24 Duration: 3m14s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 10:18:16 Duration: 3m7s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 00:06:09 Duration: 14s195ms Database: rio User: intelifix Remote: [local] Application: psql
10 9m19s 720 150ms 4s891ms 776ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 15 07 1 1s287ms 1s287ms 08 111 1m27s 788ms 09 110 1m26s 790ms 10 98 1m28s 904ms 11 92 1m7s 733ms 12 21 12s764ms 607ms 13 39 30s193ms 774ms 14 64 51s469ms 804ms 15 109 1m22s 754ms 16 60 39s963ms 666ms 17 15 10s730ms 715ms [ User: intelifix - Total duration: 9m19s - Times executed: 720 ]
[ Application: [unknown] - Total duration: 9m19s - Times executed: 720 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "135757", "modelo" : "155", "itens" : "E4C0E240CF3D,E4C0E240D0A9,E4C0E240D445,E4C0E240D61A,E4C0E240D9E0,E4C0E240DCB8,E4C0E240E111,E4C0E240E619,E4C0E240EC0F", "usuario" : "414", "caixa" : "1765240", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-15 10:20:51 Duration: 4s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287388", "modelo" : "454", "itens" : "241633042131,241613420104,241613425255,241627473439,241633682530,241634317092,241613347391,241644398402,241643721333,241640159503,241627138704,241625306280,241625317594,241641494751,241642240414,241613829313,241614210013,241625244759,241611917992,241626419610,241641516672,241645059409,241640855059,241623336368,241640122227,241624507986,241643717493,241624097991,241627589814,241644880122,241641937577,241600682340,241600167889,241644788192,241611740423,241624322941,241633648990,241624601936,241611067393,241610982032,241600247089,241633644142,241640032039,241641729094,241613380123,241611537091,241600745757,241640031635", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-15 10:53:18 Duration: 3s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287654", "modelo" : "263", "itens" : "229902414359,229913581420,229886059205,229914570316,229912522237,229876766872,229871807387,229895359999,229912677582,229916332429,229909104159,229899346775,229911362741,229900963342,229897724047,229886119716,229870795257,229899230222,229900090418,229912119212,229899140112,229899433148,229897985262,229909006674,229898126061,229916379100,229902046163,229892898592,831295942002411,229910192941,229902710202,229916437893,229908222143,229909854243,229876161225,229914502228,229913910622,229898034257,229870810714,229916459108,229876113745,229897646890,229915056984,229896064446,229902134051,229902137586,229897388605,229898001022", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-15 15:54:36 Duration: 2s969ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m50s 33 245ms 37s572ms 8s815ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 15 07 3 1m12s 24s186ms 08 3 15s776ms 5s258ms 09 1 27s152ms 27s152ms 10 5 37s341ms 7s468ms 11 4 45s243ms 11s310ms 13 3 11s32ms 3s677ms 14 5 29s252ms 5s850ms 15 8 46s261ms 5s782ms 16 1 6s283ms 6s283ms [ User: intelifix - Total duration: 4m50s - Times executed: 33 ]
[ Application: psql - Total duration: 4m50s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029890);
Date: 2026-09-15 07:21:00 Duration: 37s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029889);
Date: 2026-09-15 07:14:57 Duration: 31s634ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029898);
Date: 2026-09-15 09:20:52 Duration: 27s152ms Database: rio User: intelifix Remote: [local] Application: psql
12 4m30s 37 150ms 1m31s 7s308ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 15 07 4 1m8s 17s17ms 08 5 1s291ms 258ms 09 1 246ms 246ms 10 8 38s732ms 4s841ms 11 5 53s669ms 10s733ms 14 5 1s900ms 380ms 15 8 1m46s 13s281ms 16 1 237ms 237ms [ User: intelifix - Total duration: 4m30s - Times executed: 37 ]
[ Application: psql - Total duration: 4m30s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029919);
Date: 2026-09-15 15:02:27 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029889);
Date: 2026-09-15 07:14:26 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029912);
Date: 2026-09-15 11:55:55 Duration: 35s541ms Database: rio User: intelifix Remote: [local] Application: psql
13 4m18s 20 11s830ms 25s789ms 12s944ms create table temp0000291479 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 15 10 12 2m26s 12s249ms 11 8 1m51s 13s987ms [ User: intelifix - Total duration: 4m18s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 20 ]
-
CREATE TABLE temp0000291479 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 11:18:13 Duration: 25s789ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291479 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 10:16:03 Duration: 13s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291479 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 10:36:10 Duration: 12s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m44s 9 11s379ms 1m3s 18s325ms create table temp0000291533 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 15 15 9 2m44s 18s325ms [ User: intelifix - Total duration: 2m44s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 9 ]
-
CREATE TABLE temp0000291533 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:26:34 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291533 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:38:37 Duration: 13s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291533 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:01:09 Duration: 13s7ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m16s 44 2s148ms 10s383ms 3s105ms create table temp0000291415 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 15 07 4 10s588ms 2s647ms 08 10 23s308ms 2s330ms 10 6 15s953ms 2s658ms 11 7 24s368ms 3s481ms 14 6 19s340ms 3s223ms 15 5 22s723ms 4s544ms 16 6 20s373ms 3s395ms [ User: intelifix - Total duration: 2m16s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 44 ]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 15:30:12 Duration: 10s383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 11:15:27 Duration: 8s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 14:22:29 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m15s 4 4s442ms 1m3s 33s908ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 15 20 2 1m7s 33s887ms 23 2 1m7s 33s930ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-15 23:16:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-15 20:08:36 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-15 20:10:35 Duration: 4s490ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m57s 32 592ms 12s493ms 3s675ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 15 08 2 5s301ms 2s650ms 09 3 24s499ms 8s166ms 10 3 21s480ms 7s160ms 11 2 12s176ms 6s88ms 12 2 11s920ms 5s960ms 13 3 3s631ms 1s210ms 14 1 4s636ms 4s636ms 15 3 14s394ms 4s798ms 16 1 9s949ms 9s949ms 17 2 1s662ms 831ms 18 1 592ms 592ms 19 2 1s667ms 833ms 20 2 1s436ms 718ms 21 2 1s623ms 811ms 22 3 2s629ms 876ms [ User: intelifix - Total duration: 1m57s - Times executed: 32 ]
[ Application: psql - Total duration: 1m57s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-15 10:20:13 Duration: 12s493ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-15 12:00:12 Duration: 11s119ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-15 16:00:11 Duration: 9s949ms Database: rio User: intelifix Remote: [local] Application: psql
18 1m55s 5 11s107ms 1m8s 23s185ms create table temp0000291391 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 15 07 4 1m42s 25s607ms 16 1 13s499ms 13s499ms [ User: intelifix - Total duration: 1m55s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 5 ]
-
CREATE TABLE temp0000291391 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 07:10:26 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291391 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 16:27:52 Duration: 13s499ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291391 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 07:13:30 Duration: 11s434ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m47s 57 449ms 22s71ms 1s891ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 15 08 4 7s883ms 1s970ms 09 3 5s401ms 1s800ms 10 3 1s918ms 639ms 11 4 9s3ms 2s250ms 12 4 2s694ms 673ms 13 3 2s328ms 776ms 14 5 13s318ms 2s663ms 15 4 6s463ms 1s615ms 16 4 12s529ms 3s132ms 17 3 24s380ms 8s126ms 18 5 3s766ms 753ms 19 4 4s268ms 1s67ms 20 4 3s975ms 993ms 21 4 6s920ms 1s730ms 22 3 2s963ms 987ms [ User: intelifix - Total duration: 1m47s - Times executed: 57 ]
[ Application: psql - Total duration: 1m47s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 17:40:23 Duration: 22s71ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 11:00:07 Duration: 6s454ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 16:20:08 Duration: 6s270ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m46s 4 333ms 53s596ms 26s681ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 15 20 2 52s796ms 26s398ms 23 2 53s930ms 26s965ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-15 23:13:44 Duration: 53s596ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-15 20:05:42 Duration: 52s440ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-15 20:10:00 Duration: 355ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,127 20m 150ms 9s125ms 1s64ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 15 07 6 8s747ms 1s457ms 08 127 2m11s 1s33ms 09 153 2m54s 1s143ms 10 113 2m10s 1s155ms 11 175 2m51s 978ms 12 14 14s904ms 1s64ms 13 70 1m39s 1s427ms 14 148 2m35s 1s49ms 15 170 2m51s 1s9ms 16 133 2m4s 938ms 17 18 16s676ms 926ms [ User: intelifix - Total duration: 20m - Times executed: 1127 ]
[ Application: [unknown] - Total duration: 20m - Times executed: 1127 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287343, 404, '71503785850011529550,216511898788,216819812645,216520186870,216698707985,216819582746,216838890624,216357418291,216869887183,216838071116,216862419091,216756216370,216862441216,216861819707,216612623131', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 08:17:19 Duration: 9s125ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287486, 450, '723054096750,B4F2675DF3CC,6802B8AC7C6D,6802B814E6B4,6802B81434A9,6802B8CF176D,6802B850658B,6802B8A3C07B,6802B8F8A1E2,B4F267577822,6802B8BE9E75,B4F26758C9A2,6802B8A204A2,B4F267204414,6802B8A3C3FF,B4F267347726,6802B8A3C579,6802B8DBBA1D,6802B8ACB339,6802B85237D5,6802B8648BA6,6802B8A1DE29,6802B8F03C1D,6802B8DFA9AB,6802B8DFBEF0,6802B8633792,B4F2674EE1E1,B4F26734EE9C,6802B81448E0,6802B8A3D7C7,6802B8DEDB8F,6802B8F80303,B4F2675DF00F,6802B8A0F8BB,6802B8A4D86E,6802B8A28650,6802B814D874,6802B8DEB450,B4F2675DF1D1,6802B823F3A9,6802B8F7180D', '',0156,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 13:58:06 Duration: 5s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287613, 450, 'CP2439LV6BU,C4509CF3DBBC$CP2248LV8W0,B85E71D9EBBC$CP2527LV7TT,F8D2AC4904D0$CP2048LV6N4,484BD4A3BB84$CP2429LV1SK,C4509CB07924$CP2147LVAQV,D4E2CB96C95C$CP2527LV83W,F8D2AC48BFC0$CP2435LV6ND,C4509CF25D24$CP2233LV2AH,4075C3B3A4B0$CP2239LVM7U,B85E71BC2D98$CP2244LV239,B85E71D0BF10$CP2107LV4GK,E4BFFAF43C34$CP2125LV1FL,08A7C070F19C$CP2146LV25A,D4E2CB925184$CP2205LV4NY,1C9D7286616C$CP2233LV09G,4075C39C7218$CP2249LVB4M,B85E71DF1024$CP2531LV03H,3C82C08F71D0$CP2210LV4EU,3C82C0CCB57C$CP2242LV31J,B85E71C64968$CP2248LV3GV,B85E71EF1EEC$CP2110LVFY1,08A7C04B5C34$CP2218LV8GY,3C82C0C6338C$CP2120LV2YH,08A7C06D3FDC$CP2522LV3TC,B85E710C7F78$CP2429LV3FA,C4509CAED944$CP2527LV1B8,F8D2AC49BA24$CP2250LV0JB,B85E71E11BF8$CP2109LV26L,E4BFFAF62E04$CP2346LV3EZ,CCF3C848C9D4$CP2233LV0TU,4075C3B3CF1C$CP2051LV839,484BD4AAD74C$CP2432LV48J,C4509CE78A44$CP2346LV0WU,400FC17EB69C$CP2534LV3Q4,3C82C091C3F4$CP2131LVK8M,ECA81F1B035C$CP2250LV32P,B85E71E089A4$CP2529LV6GZ,3C82C08AF2B8$CP2131LV18W,ECA81F1978C4$CP2248LV5NM,B85E71DA3400', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 16:32:27 Duration: 4s643ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 720 9m19s 150ms 4s891ms 776ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 15 07 1 1s287ms 1s287ms 08 111 1m27s 788ms 09 110 1m26s 790ms 10 98 1m28s 904ms 11 92 1m7s 733ms 12 21 12s764ms 607ms 13 39 30s193ms 774ms 14 64 51s469ms 804ms 15 109 1m22s 754ms 16 60 39s963ms 666ms 17 15 10s730ms 715ms [ User: intelifix - Total duration: 9m19s - Times executed: 720 ]
[ Application: [unknown] - Total duration: 9m19s - Times executed: 720 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "135757", "modelo" : "155", "itens" : "E4C0E240CF3D,E4C0E240D0A9,E4C0E240D445,E4C0E240D61A,E4C0E240D9E0,E4C0E240DCB8,E4C0E240E111,E4C0E240E619,E4C0E240EC0F", "usuario" : "414", "caixa" : "1765240", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-15 10:20:51 Duration: 4s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287388", "modelo" : "454", "itens" : "241633042131,241613420104,241613425255,241627473439,241633682530,241634317092,241613347391,241644398402,241643721333,241640159503,241627138704,241625306280,241625317594,241641494751,241642240414,241613829313,241614210013,241625244759,241611917992,241626419610,241641516672,241645059409,241640855059,241623336368,241640122227,241624507986,241643717493,241624097991,241627589814,241644880122,241641937577,241600682340,241600167889,241644788192,241611740423,241624322941,241633648990,241624601936,241611067393,241610982032,241600247089,241633644142,241640032039,241641729094,241613380123,241611537091,241600745757,241640031635", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-15 10:53:18 Duration: 3s361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287654", "modelo" : "263", "itens" : "229902414359,229913581420,229886059205,229914570316,229912522237,229876766872,229871807387,229895359999,229912677582,229916332429,229909104159,229899346775,229911362741,229900963342,229897724047,229886119716,229870795257,229899230222,229900090418,229912119212,229899140112,229899433148,229897985262,229909006674,229898126061,229916379100,229902046163,229892898592,831295942002411,229910192941,229902710202,229916437893,229908222143,229909854243,229876161225,229914502228,229913910622,229898034257,229870810714,229916459108,229876113745,229897646890,229915056984,229896064446,229902134051,229902137586,229897388605,229898001022", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-15 15:54:36 Duration: 2s969ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 238 49s468ms 150ms 1s960ms 207ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 15 03 1 481ms 481ms 07 19 3s580ms 188ms 08 19 6s331ms 333ms 09 61 12s131ms 198ms 10 29 5s679ms 195ms 11 26 5s208ms 200ms 12 11 2s439ms 221ms 13 6 1s287ms 214ms 14 41 7s774ms 189ms 15 18 3s270ms 181ms 16 1 188ms 188ms 17 6 1s93ms 182ms [ User: intelifix - Total duration: 49s468ms - Times executed: 238 ]
[ Application: [unknown] - Total duration: 49s468ms - Times executed: 238 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230033658087');
Date: 2026-09-15 08:20:31 Duration: 1s960ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229894889214');
Date: 2026-09-15 08:33:11 Duration: 1s446ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('9877E7C082EA');
Date: 2026-09-15 09:02:45 Duration: 529ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 236 12m4s 150ms 3m14s 3s70ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 15 00 12 29s709ms 2s475ms 01 9 11s749ms 1s305ms 02 8 11s888ms 1s486ms 03 10 11s931ms 1s193ms 04 9 11s816ms 1s312ms 05 11 14s646ms 1s331ms 06 12 12s487ms 1s40ms 07 12 19s976ms 1s664ms 08 12 3m26s 17s244ms 09 10 15s249ms 1s524ms 10 11 3m20s 18s233ms 11 12 15s971ms 1s330ms 12 9 12s338ms 1s370ms 13 12 19s83ms 1s590ms 14 11 18s606ms 1s691ms 15 12 18s524ms 1s543ms 16 10 14s494ms 1s449ms 17 11 13s403ms 1s218ms 18 9 11s925ms 1s325ms 19 9 11s477ms 1s275ms 20 9 19s480ms 2s164ms 21 7 10s839ms 1s548ms 22 9 11s493ms 1s277ms [ User: intelifix - Total duration: 12m4s - Times executed: 236 ]
[ Application: psql - Total duration: 12m4s - Times executed: 236 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 08:58:24 Duration: 3m14s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 10:18:16 Duration: 3m7s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 00:06:09 Duration: 14s195ms Database: rio User: intelifix Remote: [local] Application: psql
5 213 1h30m55s 156ms 6m50s 25s614ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 15 06 2 37s340ms 18s670ms 07 13 13m20s 1m1s 08 12 13m 1m5s 09 41 4m30s 6s600ms 10 19 10m9s 32s88ms 11 18 8m46s 29s248ms 12 2 1s470ms 735ms 13 23 25s112ms 1s91ms 14 25 12m13s 29s350ms 15 20 17m7s 51s355ms 16 24 10m5s 25s243ms 17 14 37s507ms 2s679ms [ User: intelifix - Total duration: 1h30m55s - Times executed: 213 ]
[ Application: [unknown] - Total duration: 1h30m55s - Times executed: 213 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029890, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 07:28:16 Duration: 6m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029927, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 16:07:32 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029907, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 11:04:40 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 158 12m40s 180ms 54s13ms 4s810ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 15 00 6 1m19s 13s167ms 01 6 29s943ms 4s990ms 02 6 24s376ms 4s62ms 03 5 27s795ms 5s559ms 04 6 25s556ms 4s259ms 05 5 18s266ms 3s653ms 07 10 50s88ms 5s8ms 08 12 1m1s 5s159ms 09 13 51s127ms 3s932ms 10 12 1m3s 5s261ms 11 12 1m15s 6s252ms 12 12 1m2s 5s190ms 13 7 12s927ms 1s846ms 14 12 39s232ms 3s269ms 15 10 1m1s 6s188ms 16 7 24s49ms 3s435ms 17 6 4s8ms 668ms 21 5 21s83ms 4s216ms 22 6 28s315ms 4s719ms [ User: intelifix - Total duration: 12m40s - Times executed: 158 ]
[ Application: psql - Total duration: 12m40s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 00:05:55 Duration: 54s13ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 15:05:15 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 11:35:15 Duration: 13s410ms Database: rio User: intelifix Remote: [local] Application: psql
7 100 34s489ms 304ms 481ms 344ms 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 15 00 1 337ms 337ms 03 2 641ms 320ms 06 2 628ms 314ms 07 7 2s303ms 329ms 08 10 3s484ms 348ms 09 11 3s633ms 330ms 10 11 4s30ms 366ms 11 8 2s868ms 358ms 12 5 1s702ms 340ms 13 9 3s9ms 334ms 14 9 3s36ms 337ms 15 14 5s64ms 361ms 16 4 1s464ms 366ms 17 6 1s980ms 330ms 21 1 304ms 304ms [ User: lenon - Total duration: 34s489ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 34s489ms - Times executed: 100 ]
-
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-15 15:59:13 Duration: 481ms 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-15 16:00:40 Duration: 474ms 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-15 08:25:14 Duration: 440ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 90 38s461ms 348ms 800ms 427ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 15 00 1 787ms 787ms 03 1 455ms 455ms 07 6 2s374ms 395ms 08 9 4s151ms 461ms 09 11 4s264ms 387ms 10 10 4s279ms 427ms 11 6 2s456ms 409ms 12 5 1s995ms 399ms 13 9 3s808ms 423ms 14 8 3s144ms 393ms 15 13 5s608ms 431ms 16 4 1s951ms 487ms 17 6 2s410ms 401ms 21 1 771ms 771ms [ User: intelifix - Total duration: 38s461ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 38s461ms - Times executed: 90 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-09-15 08:25:14 Duration: 800ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (397, 0, 1);
Date: 2026-09-15 00:21:09 Duration: 787ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (477, 19, 1);
Date: 2026-09-15 21:43:53 Duration: 771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 85 25s893ms 260ms 412ms 304ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 15 06 1 295ms 295ms 07 5 1s465ms 293ms 08 11 3s582ms 325ms 09 13 3s876ms 298ms 10 9 2s827ms 314ms 11 7 2s77ms 296ms 12 3 862ms 287ms 13 6 1s898ms 316ms 14 9 2s705ms 300ms 15 12 3s639ms 303ms 16 6 1s839ms 306ms 17 3 822ms 274ms [ User: intelifix - Total duration: 25s893ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 25s893ms - Times executed: 85 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-15 08:50:27 Duration: 412ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-15 13:43:54 Duration: 386ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-15 10:24:27 Duration: 371ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 84 17m54s 1s237ms 1m36s 12s788ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 15 07 2 16s320ms 8s160ms 08 3 17s69ms 5s689ms 09 3 12s633ms 4s211ms 10 11 2m45s 15s21ms 11 9 2m9s 14s334ms 12 6 1m30s 15s134ms 13 6 19s771ms 3s295ms 14 9 1m14s 8s327ms 15 16 7m13s 27s78ms 16 10 1m13s 7s356ms 17 8 38s514ms 4s814ms 18 1 3s96ms 3s96ms [ User: intelifix - Total duration: 17m54s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 84 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-15 15:21:48 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-15 15:44:02 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-15', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-15 11:22:33 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: [unknown]
11 84 54s993ms 154ms 2s731ms 654ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 15 07 12 8s511ms 709ms 08 1 941ms 941ms 09 18 8s110ms 450ms 11 6 6s125ms 1s20ms 13 15 12s876ms 858ms 14 12 8s569ms 714ms 16 12 6s455ms 537ms 17 8 3s402ms 425ms [ User: intelifix - Total duration: 54s993ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 54s993ms - Times executed: 84 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0286694) LIMIT 1;
Date: 2026-09-15 07:10:00 Duration: 2s731ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0287444) LIMIT 1;
Date: 2026-09-15 11:06:07 Duration: 2s271ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0287587) LIMIT 1;
Date: 2026-09-15 16:55:41 Duration: 1s693ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 83 23s944ms 152ms 646ms 288ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 15 07 5 1s120ms 224ms 08 13 4s237ms 325ms 09 15 4s574ms 304ms 10 19 5s991ms 315ms 11 10 2s520ms 252ms 12 2 378ms 189ms 13 1 279ms 279ms 14 3 915ms 305ms 15 10 2s335ms 233ms 16 5 1s591ms 318ms [ User: intelifix - Total duration: 23s944ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 23s944ms - Times executed: 83 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, 'C85D385F22AB,C85D38DC87EF,8C444FE5D27E,C85D380D1888,D86C5A666ACF,C85D385E2D11,C85D38A2748D,C85D38FAC697,D86C5A4A66C7,C85D38EE955A,C85D3856A52B,C85D38E7187C,C85D3864497C,D86C5A5F64D2,C85D38E92254', NULL, NULL, 0151, 00);
Date: 2026-09-15 16:25:46 Duration: 646ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229818156674,229803926172,229768977688,229788722534,229820393840,229849519309,229795932239,229867646779,229857408080,229878437282', NULL, NULL, 0145, 00);
Date: 2026-09-15 08:13:57 Duration: 624ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229802887395,229788904044,229772125762,229789859906,229867625969,229820802040,229844501738,229797388081', NULL, NULL, 0145, 00);
Date: 2026-09-15 08:05:03 Duration: 620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 70 17m21s 10s731ms 1m6s 14s880ms create table temp0000291415 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 15 07 8 1m28s 11s56ms 08 14 2m47s 11s976ms 10 12 3m20s 16s671ms 11 6 2m8s 21s411ms 14 15 3m44s 14s945ms 15 12 3m14s 16s224ms 16 3 38s88ms 12s696ms [ User: intelifix - Total duration: 17m21s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 17m21s - Times executed: 70 ]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 11:18:13 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 10:10:10 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:13:39 Duration: 57s665ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 67 30s174ms 152ms 1s12ms 450ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 15 08 7 3s580ms 511ms 09 11 5s3ms 454ms 10 7 4s608ms 658ms 11 14 6s501ms 464ms 12 1 313ms 313ms 13 4 1s306ms 326ms 14 14 6s26ms 430ms 15 6 2s204ms 367ms 16 2 416ms 208ms 17 1 212ms 212ms [ User: intelifix - Total duration: 30s174ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 30s174ms - Times executed: 67 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D83139989162,3CF9F0A946D4,F4E84F8A1E26,D831398FF53A,F4E84F896A26,5872C9947153,D89A0DA91C11,D83139900086,D831391E934E,D831399892FA,5872C98D6B33,3891484C147F,5872C98CA563,843C991FBDB5,3CF9F0AFBEBC,6C11BA654C81,3CF9F0A53AD2,14CA56D728A1,D83139A05E8A', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-15 09:09:47 Duration: 1s12ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'F42D064664BB,6877DA5BFAD3,CC29BDEDA7C5,6877DA5C32E7,6877DA59FAA7,CC29BDE64F95,D8E8448C6756,203AEBA7039A,D8E844AB488A,802D1A1EFA3C', '138;1', 'DEFAULT', 09, 0301, '','', '', 00);
Date: 2026-09-15 10:33:04 Duration: 921ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '48D68230A66C,6C11BA6ECB41,D89A0D82CEFF,F4E84F8313DA,D89A0DAC9825,C4EBFF89F8F8,3CF9F0A7DE14,C4EBFF8970EA,D831399E785A,3CF9F0ACA52A,C4EBFF8C45A0,3CF9F0A7FBD8,3CF9F0AB1510,14CA56D50B1B,5872C98D6B2D,D89A0DA650D3,C4EBFF8AE202,4896D9596066,3CF9F0AE768A,C4EBFF8F57E2', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-15 14:23:47 Duration: 825ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 61 24s47ms 150ms 1s306ms 394ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 15 07 2 493ms 246ms 08 2 727ms 363ms 09 4 968ms 242ms 10 9 3s848ms 427ms 11 8 3s79ms 384ms 12 3 1s6ms 335ms 13 5 2s285ms 457ms 14 7 2s887ms 412ms 15 17 7s375ms 433ms 16 2 787ms 393ms 17 2 588ms 294ms [ User: intelifix - Total duration: 24s47ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 24s47ms - Times executed: 61 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "382", "data-de" : "2026-09-15", "data-ate" : "2026-09-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 433 }');
Date: 2026-09-15 13:37:03 Duration: 1s306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "382", "data-de" : "2026-09-15", "data-ate" : "2026-09-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 433 }');
Date: 2026-09-15 15:01:17 Duration: 1s191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-09-15", "data-ate" : "2026-09-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 404 }');
Date: 2026-09-15 15:05:51 Duration: 1s20ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 59 1m21s 153ms 29s779ms 1s376ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 15 07 5 2s61ms 412ms 08 4 916ms 229ms 09 15 48s524ms 3s234ms 10 6 1s176ms 196ms 11 6 1s495ms 249ms 13 3 1s46ms 348ms 14 4 855ms 213ms 15 7 2s922ms 417ms 16 5 21s449ms 4s289ms 17 4 764ms 191ms [ User: intelifix - Total duration: 1m21s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 1m21s - Times executed: 59 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "227013", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "BAIXA", "data-saida" : "", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-15 09:14:53 Duration: 29s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "207113", "oficina" : "6", "cliente" : "5", "usuario" : "415", "nf" : "BAIXA", "data-saida" : "2026-01-28", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-15 16:11:05 Duration: 20s128ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "227013", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "", "data-saida" : "2026-03-30", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-15 09:15:46 Duration: 14s403ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 57 1m47s 449ms 22s71ms 1s891ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 15 08 4 7s883ms 1s970ms 09 3 5s401ms 1s800ms 10 3 1s918ms 639ms 11 4 9s3ms 2s250ms 12 4 2s694ms 673ms 13 3 2s328ms 776ms 14 5 13s318ms 2s663ms 15 4 6s463ms 1s615ms 16 4 12s529ms 3s132ms 17 3 24s380ms 8s126ms 18 5 3s766ms 753ms 19 4 4s268ms 1s67ms 20 4 3s975ms 993ms 21 4 6s920ms 1s730ms 22 3 2s963ms 987ms [ User: intelifix - Total duration: 1m47s - Times executed: 57 ]
[ Application: psql - Total duration: 1m47s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 17:40:23 Duration: 22s71ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 11:00:07 Duration: 6s454ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 16:20:08 Duration: 6s270ms Database: rio User: intelifix Remote: [local] Application: psql
18 48 1h37m33s 1s400ms 9m21s 2m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 15 07 3 10m7s 3m22s 08 3 5m48s 1m56s 09 3 6m51s 2m17s 10 3 6m1s 2m 11 3 5m53s 1m57s 12 3 6m9s 2m3s 13 3 5m56s 1m58s 14 3 5m55s 1m58s 15 3 6m14s 2m4s 16 3 6m28s 2m9s 17 3 6m7s 2m2s 18 3 5m16s 1m45s 19 3 5m10s 1m43s 20 3 5m20s 1m46s 21 3 5m6s 1m42s 22 3 5m4s 1m41s [ User: intelifix - Total duration: 1h37m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 07:14:23 Duration: 9m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 09:11:13 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 16:11:08 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: psql
19 48 1h11m46s 225ms 4m21s 1m29s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 15 07 3 5m44s 1m54s 08 3 4m29s 1m29s 09 3 6m1s 2m 10 3 4m34s 1m31s 11 3 4m36s 1m32s 12 3 4m34s 1m31s 13 3 4m15s 1m25s 14 3 4m27s 1m29s 15 3 4m36s 1m32s 16 3 4m30s 1m30s 17 3 4m20s 1m26s 18 3 3m56s 1m18s 19 3 3m55s 1m18s 20 3 3m56s 1m18s 21 3 3m51s 1m17s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h11m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h11m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 09:17:52 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 07:20:43 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 11:15:29 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
20 44 2m16s 2s148ms 10s383ms 3s105ms create table temp0000291415 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 15 07 4 10s588ms 2s647ms 08 10 23s308ms 2s330ms 10 6 15s953ms 2s658ms 11 7 24s368ms 3s481ms 14 6 19s340ms 3s223ms 15 5 22s723ms 4s544ms 16 6 20s373ms 3s395ms [ User: intelifix - Total duration: 2m16s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 44 ]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 15:30:12 Duration: 10s383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 11:15:27 Duration: 8s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 14:22:29 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m9s 11m12s 7m11s 3 21m35s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 15 05 3 21m35s 7m11s [ User: intelifix - Total duration: 21m35s - Times executed: 3 ]
[ Application: psql - Total duration: 21m35s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-15 05:11:14 Duration: 11m12s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-15 05:18:26 Duration: 7m12s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-15 05:21:36 Duration: 3m9s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s400ms 9m21s 2m1s 48 1h37m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 15 07 3 10m7s 3m22s 08 3 5m48s 1m56s 09 3 6m51s 2m17s 10 3 6m1s 2m 11 3 5m53s 1m57s 12 3 6m9s 2m3s 13 3 5m56s 1m58s 14 3 5m55s 1m58s 15 3 6m14s 2m4s 16 3 6m28s 2m9s 17 3 6m7s 2m2s 18 3 5m16s 1m45s 19 3 5m10s 1m43s 20 3 5m20s 1m46s 21 3 5m6s 1m42s 22 3 5m4s 1m41s [ User: intelifix - Total duration: 1h37m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h37m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 07:14:23 Duration: 9m21s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 09:11:13 Duration: 6m12s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-15 16:11:08 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: psql
3 225ms 4m21s 1m29s 48 1h11m46s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 15 07 3 5m44s 1m54s 08 3 4m29s 1m29s 09 3 6m1s 2m 10 3 4m34s 1m31s 11 3 4m36s 1m32s 12 3 4m34s 1m31s 13 3 4m15s 1m25s 14 3 4m27s 1m29s 15 3 4m36s 1m32s 16 3 4m30s 1m30s 17 3 4m20s 1m26s 18 3 3m56s 1m18s 19 3 3m55s 1m18s 20 3 3m56s 1m18s 21 3 3m51s 1m17s 22 3 3m54s 1m18s [ User: intelifix - Total duration: 1h11m46s - Times executed: 48 ]
[ Application: psql - Total duration: 1h11m46s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 09:17:52 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 07:20:43 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-15 11:15:29 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s442ms 1m3s 33s908ms 4 2m15s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 15 20 2 1m7s 33s887ms 23 2 1m7s 33s930ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-15 23:16:43 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-15 20:08:36 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-15 20:10:35 Duration: 4s490ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 333ms 53s596ms 26s681ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 15 20 2 52s796ms 26s398ms 23 2 53s930ms 26s965ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-15 23:13:44 Duration: 53s596ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-15 20:05:42 Duration: 52s440ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-15 20:10:00 Duration: 355ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 156ms 6m50s 25s614ms 213 1h30m55s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 15 06 2 37s340ms 18s670ms 07 13 13m20s 1m1s 08 12 13m 1m5s 09 41 4m30s 6s600ms 10 19 10m9s 32s88ms 11 18 8m46s 29s248ms 12 2 1s470ms 735ms 13 23 25s112ms 1s91ms 14 25 12m13s 29s350ms 15 20 17m7s 51s355ms 16 24 10m5s 25s243ms 17 14 37s507ms 2s679ms [ User: intelifix - Total duration: 1h30m55s - Times executed: 213 ]
[ Application: [unknown] - Total duration: 1h30m55s - Times executed: 213 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029890, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 07:28:16 Duration: 6m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029927, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 16:07:32 Duration: 6m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029907, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-15 11:04:40 Duration: 6m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11s107ms 1m8s 23s185ms 5 1m55s create table temp0000291391 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 15 07 4 1m42s 25s607ms 16 1 13s499ms 13s499ms [ User: intelifix - Total duration: 1m55s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 1m55s - Times executed: 5 ]
-
CREATE TABLE temp0000291391 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 07:10:26 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291391 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 16:27:52 Duration: 13s499ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291391 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 07:13:30 Duration: 11s434ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11s379ms 1m3s 18s325ms 9 2m44s create table temp0000291533 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 15 15 9 2m44s 18s325ms [ User: intelifix - Total duration: 2m44s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 9 ]
-
CREATE TABLE temp0000291533 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:26:34 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291533 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:38:37 Duration: 13s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291533 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:01:09 Duration: 13s7ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s731ms 1m6s 14s880ms 70 17m21s create table temp0000291415 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 15 07 8 1m28s 11s56ms 08 14 2m47s 11s976ms 10 12 3m20s 16s671ms 11 6 2m8s 21s411ms 14 15 3m44s 14s945ms 15 12 3m14s 16s224ms 16 3 38s88ms 12s696ms [ User: intelifix - Total duration: 17m21s - Times executed: 70 ]
[ Application: [unknown] - Total duration: 17m21s - Times executed: 70 ]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 11:18:13 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 10:10:10 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 15:13:39 Duration: 57s665ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 11s830ms 25s789ms 12s944ms 20 4m18s create table temp0000291479 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 15 10 12 2m26s 12s249ms 11 8 1m51s 13s987ms [ User: intelifix - Total duration: 4m18s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 20 ]
-
CREATE TABLE temp0000291479 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 11:18:13 Duration: 25s789ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291479 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 10:16:03 Duration: 13s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291479 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-15 10:36:10 Duration: 12s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 1s237ms 1m36s 12s788ms 84 17m54s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 15 07 2 16s320ms 8s160ms 08 3 17s69ms 5s689ms 09 3 12s633ms 4s211ms 10 11 2m45s 15s21ms 11 9 2m9s 14s334ms 12 6 1m30s 15s134ms 13 6 19s771ms 3s295ms 14 9 1m14s 8s327ms 15 16 7m13s 27s78ms 16 10 1m13s 7s356ms 17 8 38s514ms 4s814ms 18 1 3s96ms 3s96ms [ User: intelifix - Total duration: 17m54s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 17m54s - Times executed: 84 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-15 15:21:48 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-31', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-15 15:44:02 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-15', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-15 11:22:33 Duration: 1m14s Database: rio User: intelifix Remote: [local] Application: [unknown]
12 245ms 37s572ms 8s815ms 33 4m50s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 15 07 3 1m12s 24s186ms 08 3 15s776ms 5s258ms 09 1 27s152ms 27s152ms 10 5 37s341ms 7s468ms 11 4 45s243ms 11s310ms 13 3 11s32ms 3s677ms 14 5 29s252ms 5s850ms 15 8 46s261ms 5s782ms 16 1 6s283ms 6s283ms [ User: intelifix - Total duration: 4m50s - Times executed: 33 ]
[ Application: psql - Total duration: 4m50s - Times executed: 33 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029890);
Date: 2026-09-15 07:21:00 Duration: 37s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029889);
Date: 2026-09-15 07:14:57 Duration: 31s634ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029898);
Date: 2026-09-15 09:20:52 Duration: 27s152ms Database: rio User: intelifix Remote: [local] Application: psql
13 150ms 1m31s 7s308ms 37 4m30s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 15 07 4 1m8s 17s17ms 08 5 1s291ms 258ms 09 1 246ms 246ms 10 8 38s732ms 4s841ms 11 5 53s669ms 10s733ms 14 5 1s900ms 380ms 15 8 1m46s 13s281ms 16 1 237ms 237ms [ User: intelifix - Total duration: 4m30s - Times executed: 37 ]
[ Application: psql - Total duration: 4m30s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029919);
Date: 2026-09-15 15:02:27 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 305); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029889);
Date: 2026-09-15 07:14:26 Duration: 1m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029912);
Date: 2026-09-15 11:55:55 Duration: 35s541ms Database: rio User: intelifix Remote: [local] Application: psql
14 180ms 54s13ms 4s810ms 158 12m40s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 15 00 6 1m19s 13s167ms 01 6 29s943ms 4s990ms 02 6 24s376ms 4s62ms 03 5 27s795ms 5s559ms 04 6 25s556ms 4s259ms 05 5 18s266ms 3s653ms 07 10 50s88ms 5s8ms 08 12 1m1s 5s159ms 09 13 51s127ms 3s932ms 10 12 1m3s 5s261ms 11 12 1m15s 6s252ms 12 12 1m2s 5s190ms 13 7 12s927ms 1s846ms 14 12 39s232ms 3s269ms 15 10 1m1s 6s188ms 16 7 24s49ms 3s435ms 17 6 4s8ms 668ms 21 5 21s83ms 4s216ms 22 6 28s315ms 4s719ms [ User: intelifix - Total duration: 12m40s - Times executed: 158 ]
[ Application: psql - Total duration: 12m40s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 00:05:55 Duration: 54s13ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 15:05:15 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-15 11:35:15 Duration: 13s410ms Database: rio User: intelifix Remote: [local] Application: psql
15 592ms 12s493ms 3s675ms 32 1m57s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 15 08 2 5s301ms 2s650ms 09 3 24s499ms 8s166ms 10 3 21s480ms 7s160ms 11 2 12s176ms 6s88ms 12 2 11s920ms 5s960ms 13 3 3s631ms 1s210ms 14 1 4s636ms 4s636ms 15 3 14s394ms 4s798ms 16 1 9s949ms 9s949ms 17 2 1s662ms 831ms 18 1 592ms 592ms 19 2 1s667ms 833ms 20 2 1s436ms 718ms 21 2 1s623ms 811ms 22 3 2s629ms 876ms [ User: intelifix - Total duration: 1m57s - Times executed: 32 ]
[ Application: psql - Total duration: 1m57s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-15 10:20:13 Duration: 12s493ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-15 12:00:12 Duration: 11s119ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-15 16:00:11 Duration: 9s949ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s148ms 10s383ms 3s105ms 44 2m16s create table temp0000291415 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 15 07 4 10s588ms 2s647ms 08 10 23s308ms 2s330ms 10 6 15s953ms 2s658ms 11 7 24s368ms 3s481ms 14 6 19s340ms 3s223ms 15 5 22s723ms 4s544ms 16 6 20s373ms 3s395ms [ User: intelifix - Total duration: 2m16s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 2m16s - Times executed: 44 ]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 15:30:12 Duration: 10s383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 11:15:27 Duration: 8s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291415 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-09-2026", "ate" :"15-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-15 14:22:29 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 150ms 3m14s 3s70ms 236 12m4s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 15 00 12 29s709ms 2s475ms 01 9 11s749ms 1s305ms 02 8 11s888ms 1s486ms 03 10 11s931ms 1s193ms 04 9 11s816ms 1s312ms 05 11 14s646ms 1s331ms 06 12 12s487ms 1s40ms 07 12 19s976ms 1s664ms 08 12 3m26s 17s244ms 09 10 15s249ms 1s524ms 10 11 3m20s 18s233ms 11 12 15s971ms 1s330ms 12 9 12s338ms 1s370ms 13 12 19s83ms 1s590ms 14 11 18s606ms 1s691ms 15 12 18s524ms 1s543ms 16 10 14s494ms 1s449ms 17 11 13s403ms 1s218ms 18 9 11s925ms 1s325ms 19 9 11s477ms 1s275ms 20 9 19s480ms 2s164ms 21 7 10s839ms 1s548ms 22 9 11s493ms 1s277ms [ User: intelifix - Total duration: 12m4s - Times executed: 236 ]
[ Application: psql - Total duration: 12m4s - Times executed: 236 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 08:58:24 Duration: 3m14s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 10:18:16 Duration: 3m7s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-15 00:06:09 Duration: 14s195ms Database: rio User: intelifix Remote: [local] Application: psql
18 449ms 22s71ms 1s891ms 57 1m47s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 15 08 4 7s883ms 1s970ms 09 3 5s401ms 1s800ms 10 3 1s918ms 639ms 11 4 9s3ms 2s250ms 12 4 2s694ms 673ms 13 3 2s328ms 776ms 14 5 13s318ms 2s663ms 15 4 6s463ms 1s615ms 16 4 12s529ms 3s132ms 17 3 24s380ms 8s126ms 18 5 3s766ms 753ms 19 4 4s268ms 1s67ms 20 4 3s975ms 993ms 21 4 6s920ms 1s730ms 22 3 2s963ms 987ms [ User: intelifix - Total duration: 1m47s - Times executed: 57 ]
[ Application: psql - Total duration: 1m47s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 17:40:23 Duration: 22s71ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 11:00:07 Duration: 6s454ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-15 16:20:08 Duration: 6s270ms Database: rio User: intelifix Remote: [local] Application: psql
19 153ms 29s779ms 1s376ms 59 1m21s select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 15 07 5 2s61ms 412ms 08 4 916ms 229ms 09 15 48s524ms 3s234ms 10 6 1s176ms 196ms 11 6 1s495ms 249ms 13 3 1s46ms 348ms 14 4 855ms 213ms 15 7 2s922ms 417ms 16 5 21s449ms 4s289ms 17 4 764ms 191ms [ User: intelifix - Total duration: 1m21s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 1m21s - Times executed: 59 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "227013", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "BAIXA", "data-saida" : "", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-15 09:14:53 Duration: 29s779ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "207113", "oficina" : "6", "cliente" : "5", "usuario" : "415", "nf" : "BAIXA", "data-saida" : "2026-01-28", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-15 16:11:05 Duration: 20s128ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "227013", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "", "data-saida" : "2026-03-30", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-15 09:15:46 Duration: 14s403ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 9s125ms 1s64ms 1,127 20m select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 15 07 6 8s747ms 1s457ms 08 127 2m11s 1s33ms 09 153 2m54s 1s143ms 10 113 2m10s 1s155ms 11 175 2m51s 978ms 12 14 14s904ms 1s64ms 13 70 1m39s 1s427ms 14 148 2m35s 1s49ms 15 170 2m51s 1s9ms 16 133 2m4s 938ms 17 18 16s676ms 926ms [ User: intelifix - Total duration: 20m - Times executed: 1127 ]
[ Application: [unknown] - Total duration: 20m - Times executed: 1127 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287343, 404, '71503785850011529550,216511898788,216819812645,216520186870,216698707985,216819582746,216838890624,216357418291,216869887183,216838071116,216862419091,216756216370,216862441216,216861819707,216612623131', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 08:17:19 Duration: 9s125ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287486, 450, '723054096750,B4F2675DF3CC,6802B8AC7C6D,6802B814E6B4,6802B81434A9,6802B8CF176D,6802B850658B,6802B8A3C07B,6802B8F8A1E2,B4F267577822,6802B8BE9E75,B4F26758C9A2,6802B8A204A2,B4F267204414,6802B8A3C3FF,B4F267347726,6802B8A3C579,6802B8DBBA1D,6802B8ACB339,6802B85237D5,6802B8648BA6,6802B8A1DE29,6802B8F03C1D,6802B8DFA9AB,6802B8DFBEF0,6802B8633792,B4F2674EE1E1,B4F26734EE9C,6802B81448E0,6802B8A3D7C7,6802B8DEDB8F,6802B8F80303,B4F2675DF00F,6802B8A0F8BB,6802B8A4D86E,6802B8A28650,6802B814D874,6802B8DEB450,B4F2675DF1D1,6802B823F3A9,6802B8F7180D', '',0156,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 13:58:06 Duration: 5s49ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (287613, 450, 'CP2439LV6BU,C4509CF3DBBC$CP2248LV8W0,B85E71D9EBBC$CP2527LV7TT,F8D2AC4904D0$CP2048LV6N4,484BD4A3BB84$CP2429LV1SK,C4509CB07924$CP2147LVAQV,D4E2CB96C95C$CP2527LV83W,F8D2AC48BFC0$CP2435LV6ND,C4509CF25D24$CP2233LV2AH,4075C3B3A4B0$CP2239LVM7U,B85E71BC2D98$CP2244LV239,B85E71D0BF10$CP2107LV4GK,E4BFFAF43C34$CP2125LV1FL,08A7C070F19C$CP2146LV25A,D4E2CB925184$CP2205LV4NY,1C9D7286616C$CP2233LV09G,4075C39C7218$CP2249LVB4M,B85E71DF1024$CP2531LV03H,3C82C08F71D0$CP2210LV4EU,3C82C0CCB57C$CP2242LV31J,B85E71C64968$CP2248LV3GV,B85E71EF1EEC$CP2110LVFY1,08A7C04B5C34$CP2218LV8GY,3C82C0C6338C$CP2120LV2YH,08A7C06D3FDC$CP2522LV3TC,B85E710C7F78$CP2429LV3FA,C4509CAED944$CP2527LV1B8,F8D2AC49BA24$CP2250LV0JB,B85E71E11BF8$CP2109LV26L,E4BFFAF62E04$CP2346LV3EZ,CCF3C848C9D4$CP2233LV0TU,4075C3B3CF1C$CP2051LV839,484BD4AAD74C$CP2432LV48J,C4509CE78A44$CP2346LV0WU,400FC17EB69C$CP2534LV3Q4,3C82C091C3F4$CP2131LVK8M,ECA81F1B035C$CP2250LV32P,B85E71E089A4$CP2529LV6GZ,3C82C08AF2B8$CP2131LV18W,ECA81F1978C4$CP2248LV5NM,B85E71DA3400', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-15 16:32:27 Duration: 4s643ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 15 13 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 2s191ms - Times executed: 6 ]
[ Application: psql - Total duration: 1s292ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 899ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 19,378 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 22 FATAL entries
- 5387 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,360 Max number of times the same event was reported
- 5,417 Total events found
Rank Times reported Error 1 5,360 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 15 00 118 01 120 02 118 03 120 04 120 05 118 06 120 07 250 08 328 09 430 10 409 11 410 12 233 13 213 14 360 15 419 16 300 17 205 18 169 19 169 20 164 21 163 22 166 23 138 - ERROR: prepared statement "_PLAN0000000029DEFF40" does not exist
- ERROR: prepared statement "_PLAN0000000029CACDB0" does not exist
- ERROR: prepared statement "_PLAN0000000029DF23C0" does not exist
Statement: DEALLOCATE "_PLAN0000000029DEFF40"
Date: 2026-09-15 00:00:57 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029CACDB0"
Date: 2026-09-15 00:00:58 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DF23C0"
Date: 2026-09-15 00:01:57 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 14 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 15 00 3 03 2 06 1 18 1 20 5 21 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-15 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-15 00:22:01 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-15 00:23:17 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 12 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 15 09 2 10 4 11 1 15 5 - ERROR: syntax error at or near "]" at character 34
- ERROR: syntax error at or near "]" at character 34
- ERROR: syntax error at or near "233020163" at character 34
Statement: select * from rs_caixa_qr(398914 ])
Date: 2026-09-15 09:26:41 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(398914 ])
Date: 2026-09-15 09:26:41 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''''233020163' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''''233020163' )
Date: 2026-09-15 10:40:50 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
4 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 15 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-15 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-15 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT RS_CHMOD( cFile , '0o777' )" PL/pgSQL function rs_giga_tecnicos() line 42 at PERFORM
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-09-15 03:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
5 5 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 15 13 2 15 3 - ERROR: trailing junk after numeric literal at or near "9C635B889ED6" at character 27
- ERROR: trailing junk after numeric literal at or near "9C635B889ED6" at character 27
- ERROR: trailing junk after numeric literal at or near "98391049ceaf" at character 27
Statement: select * from rs_caixa_qr(9C635B889ED6)
Date: 2026-09-15 13:25:20 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(9C635B889ED6)
Date: 2026-09-15 13:25:21 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(98391049ceaf)
Date: 2026-09-15 15:17:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 15 08 3 10 2 - LOG: process 2680039 still waiting for ShareLock on transaction 6096903 after 1000.125 ms
- LOG: process 2680039 still waiting for ShareLock on transaction 6096903 after 8173.199 ms
- LOG: process 2680039 still waiting for ShareLock on transaction 6096903 after 10702.343 ms
Detail: Process holding the lock: 2686678. Wait queue: 2680039.
Context: while updating tuple (79855,66) 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-15 08:55:12 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2686678. Wait queue: 2680039.
Context: while updating tuple (79855,66) 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-15 08:55:19 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2686678. Wait queue: 2680039.
Context: while updating tuple (79855,66) 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-15 08:55:22 Database: rio Application: psql User: intelifix Remote: [local]
7 4 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 15 09 3 13 1 - 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-15 09:44:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-15 09:44:59 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-15 09:49:00 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 15 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-15 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-15 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-15 05:32:09 Database: contagem Application: psql User: intelifix Remote: [local]
9 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 15 15 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(V)
Date: 2026-09-15 15:14:48 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-09-15 15:14:48 Database: brasilia 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 15 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-15 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-15 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 15 10 2 - ERROR: process 2797038 detected deadlock while waiting for ShareLock on transaction 6104617 after 1000.136 ms
- ERROR: process 2797038 detected deadlock while waiting for ShareLock on transaction 6104617 after 1000.150 ms
Detail: Process holding the lock: 2808621. Wait queue: .
Context: while updating tuple (79860,52) 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,character varying,integer) line 1028 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 029900, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-09-15 10:15:15 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2808621. Wait queue: .
Context: while updating tuple (79860,47) 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 assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1028 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 029900, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-09-15 10:15:39 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 15 03 1 - LOG: database system was shut down at 2026-09-15 03:05:01 -03
Date: 2026-09-15 03:05:02