pgBadger-
Global information
- Generated on Tue Sep 8 23:50:21 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,613 log entries in 19s
- Log start from 2026-09-08 00:00:48 to 2026-09-08 23:49:43
-
Overview
Global Stats
- 423 Number of unique normalized queries
- 5,875 Number of queries
- 8h56m44s Total query duration
- 2026-09-08 00:02:10 First query
- 2026-09-08 23:42:39 Last query
- 6 queries/s at 2026-09-08 23:42:16 Query peak
- 8h56m44s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h56m44s Execute total duration
- 4,245 Number of events
- 16 Number of unique normalized events
- 4,177 Max number of times the same event was reported
- 0 Number of cancellation
- 540 Total number of automatic vacuums
- 1,131 Total number of automatic analyzes
- 36 Number temporary file
- 244.71 MiB Max size of temporary file
- 83.23 MiB Average size of temporary file
- 410 Total number of sessions
- 8 sessions at 2026-09-08 11:48:04 Session peak
- 13d9h7m31s Total duration of sessions
- 46m59s Average duration of sessions
- 14 Average queries per session
- 1m18s Average queries duration per session
- 45m41s Average idle time per session
- 425 Total number of connections
- 4 connections/s at 2026-09-08 03:05:17 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-08 23:42:16 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-08 10:47:09 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-08 23:42:16 Date
Queries duration
Key values
- 8h56m44s 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 08 00 19 0ms 22s322ms 4s798ms 2s638ms 2s863ms 1m5s 01 7 0ms 2s708ms 2s247ms 2s455ms 2s669ms 2s767ms 02 10 0ms 2s682ms 1s616ms 2s529ms 2s701ms 2s875ms 03 11 0ms 2s993ms 1s595ms 2s451ms 2s842ms 4s176ms 04 10 0ms 2s661ms 1s603ms 2s562ms 2s729ms 2s815ms 05 12 0ms 11m5s 1m56s 2s769ms 2m58s 11m5s 06 17 0ms 10s645ms 3s117ms 2s801ms 2s957ms 28s452ms 07 177 0ms 10m32s 12s816ms 46s805ms 5m40s 11m58s 08 451 0ms 5m55s 5s598ms 1m23s 5m36s 6m13s 09 532 0ms 6m38s 4s3ms 1m8s 5m44s 6m43s 10 695 151ms 5m32s 4s58ms 1m40s 5m39s 7m5s 11 665 0ms 6m55s 5s650ms 1m46s 5m56s 10m41s 12 295 0ms 5m22s 5s476ms 53s456ms 4m27s 5m56s 13 455 0ms 5m16s 3s437ms 54s528ms 1m32s 5m17s 14 625 151ms 5m39s 4s618ms 1m22s 6m30s 6m58s 15 619 150ms 6m11s 3s766ms 1m3s 4m6s 7m18s 16 461 150ms 5m50s 3s893ms 1m11s 1m38s 5m54s 17 231 0ms 5m32s 5s113ms 43s488ms 1m44s 5m36s 18 47 0ms 5m16s 18s126ms 33s738ms 1m11s 6m 19 20 0ms 4m49s 28s280ms 2s643ms 52s113ms 4m49s 20 120 0ms 5m17s 9s711ms 1m6s 1m22s 6m14s 21 34 0ms 5m13s 17s900ms 7s143ms 13s759ms 5m49s 22 29 0ms 4m42s 20s201ms 5s897ms 42s4ms 4m42s 23 333 0ms 1m1s 5s849ms 1m5s 1m11s 1m24s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 08 00 3 0 3s891ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 171ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 3 0 3s476ms 0ms 0ms 0ms 07 106 0 18s557ms 3s169ms 11s821ms 11m36s 08 321 0 5s776ms 20s296ms 1m2s 5m46s 09 443 0 4s240ms 9s911ms 46s9ms 6m1s 10 535 0 4s158ms 37s658ms 1m14s 5m39s 11 474 0 5s217ms 55s553ms 1m10s 6m6s 12 198 0 5s667ms 4s707ms 8s436ms 5m16s 13 333 0 3s162ms 14s50ms 36s856ms 3m32s 14 479 0 4s369ms 27s34ms 1m3s 5m54s 15 450 0 3s452ms 11s693ms 43s812ms 5m55s 16 359 0 3s925ms 23s774ms 1m 3m55s 17 186 0 5s439ms 9s185ms 32s842ms 3m47s 18 26 0 29s466ms 0ms 22s971ms 3m30s 19 6 0 1m30s 0ms 0ms 3m23s 20 19 81 11s315ms 34s439ms 1m4s 3m25s 21 14 0 40s414ms 0ms 626ms 3m19s 22 9 0 1m 0ms 0ms 3m38s 23 12 321 5s849ms 1m3s 1m5s 1m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 08 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 1 0 13s378ms 0ms 0ms 0ms 12 0 1 0 0 159ms 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 08 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 23 23.00 0.00% 08 0 14 14.00 0.00% 09 0 21 21.00 0.00% 10 0 18 18.00 0.00% 11 0 23 23.00 0.00% 12 0 28 28.00 0.00% 13 0 16 16.00 0.00% 14 0 15 15.00 0.00% 15 0 10 10.00 0.00% 16 0 10 10.00 0.00% 17 0 6 6.00 0.00% 18 0 4 4.00 0.00% 19 0 0 0.00 0.00% 20 0 3 3.00 0.00% 21 0 2 2.00 0.00% 22 0 1 1.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Sep 08 00 16 0.00/s 01 7 0.00/s 02 9 0.00/s 03 15 0.00/s 04 7 0.00/s 05 10 0.00/s 06 17 0.00/s 07 16 0.00/s 08 26 0.01/s 09 21 0.01/s 10 21 0.01/s 11 41 0.01/s 12 42 0.01/s 13 35 0.01/s 14 20 0.01/s 15 19 0.01/s 16 22 0.01/s 17 11 0.00/s 18 15 0.00/s 19 8 0.00/s 20 16 0.00/s 21 10 0.00/s 22 11 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Sep 08 00 3 43m20s 42m50s 01 14 1h1m17s 1h1m16s 02 7 1h 59m57s 03 15 21m13s 21m11s 04 7 1h3m 1h2m57s 05 8 54m8s 51m13s 06 8 59m22s 59m16s 07 16 55m19s 52m57s 08 19 48m41s 46m28s 09 24 54m18s 52m50s 10 18 57m23s 54m46s 11 38 35m50s 34m11s 12 49 26m26s 25m53s 13 30 29m49s 28m57s 14 21 56m2s 53m45s 15 19 57m38s 55m35s 16 20 56m51s 55m21s 17 18 1h32s 59m26s 18 13 56m54s 55m49s 19 14 1h26s 59m45s 20 12 41m36s 39m58s 21 11 1h28s 59m33s 22 11 1h42s 59m49s 23 15 38m22s 36m12s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-08 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 425 connections Total
Connections per user
Key values
- intelifix Main User
- 425 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-08 11:48:04 Date
Histogram of session times
Key values
- 290 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 410 sessions Total
Sessions per user
Key values
- intelifix Main User
- 410 sessions Total
Sessions per host
Key values
- [local] Main Host
- 410 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 410 sessions Total
Application Count Total Duration Average Duration [unknown] 368 12d13h55m53s 49m13s pgAdmin 4 - CONN:1158561 3 1m5s 21s782ms pgAdmin 4 - CONN:3235847 3 4s888ms 1s629ms pgAdmin 4 - CONN:4085942 2 4s78ms 2s39ms pgAdmin 4 - CONN:4227973 1 39m50s 39m50s pgAdmin 4 - CONN:4629397 1 28m58s 28m58s pgAdmin 4 - DB:brasilia 2 3m37s 1m48s pgAdmin 4 - DB:contagem 1 9s245ms 9s245ms pgAdmin 4 - DB:postgres 2 1h9m34s 34m47s pgAdmin 4 - DB:rio 3 1h9m18s 23m6s pg_dump 9 41m47s 4m38s postgres_fdw 1 54m58s 54m58s psql 14 14h2m8s 1h9s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 25,502 buffers Checkpoint Peak
- 2026-09-08 14:24:38 Date
- 270.033 seconds Highest write time
- 0.222 seconds Sync time
Checkpoints Wal files
Key values
- 30 files Wal files usage Peak
- 2026-09-08 15:14:38 Date
Checkpoints distance
Key values
- 934.68 Mo Distance Peak
- 2026-09-08 15:14:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 08 00 8,033 269.458s 0.002s 269.465s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 12,205 0.275s 0.224s 0.526s 04 0 0s 0s 0s 05 7,343 735.483s 0.041s 735.581s 06 1,148 115.033s 0.007s 115.044s 07 26,602 1,777.649s 0.194s 1,777.903s 08 44,247 2,990.2s 0.393s 2,990.818s 09 56,571 3,201.114s 0.405s 3,201.662s 10 86,162 3,239.12s 0.492s 3,239.722s 11 100,624 3,239.161s 0.496s 3,239.795s 12 36,375 2,860.186s 0.394s 2,860.766s 13 61,837 2,806.965s 0.281s 2,807.328s 14 120,351 3,239.16s 0.453s 3,239.729s 15 81,057 3,239.034s 0.483s 3,239.698s 16 54,667 3,169.986s 0.579s 3,170.663s 17 34,209 2,180.817s 0.253s 2,181.19s 18 4,405 532.986s 0.161s 533.248s 19 83 8.33s 0.065s 8.41s 20 1,177 250.738s 0.007s 250.757s 21 3,259 326.183s 0.217s 326.459s 22 2,283 228.659s 0.213s 228.906s 23 285 28.586s 0.009s 28.611s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 08 00 0 0 3 33 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 28 0.177s 0.01s 04 0 0 0 0 0s 0s 05 0 0 3 136 0.006s 0.007s 06 0 0 0 10 0.005s 0.001s 07 0 0 16 2,450 0.062s 0.011s 08 0 0 49 6,200 0.062s 0.012s 09 0 0 33 6,959 0.064s 0.012s 10 0 0 56 7,797 0.053s 0.012s 11 0 0 93 7,255 0.058s 0.012s 12 0 0 45 4,563 0.090s 0.012s 13 0 0 39 5,716 0.061s 0.012s 14 0 0 91 7,278 0.065s 0.012s 15 0 0 94 7,606 0.063s 0.012s 16 0 0 51 6,471 0.079s 0.012s 17 0 0 20 4,203 0.062s 0.011s 18 0 0 8 496 0.063s 0.021s 19 0 0 0 12 0.062s 0.008s 20 0 0 1 90 0.001s 0.003s 21 0 0 1 647 0.062s 0.011s 22 0 0 1 539 0.062s 0.011s 23 0 0 0 35 0.003s 0.005s Day Hour Count Avg time (sec) Sep 08 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 08 00 45,376.00 kB 45,376.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 24,582.50 kB 24,582.50 kB 04 0.00 kB 0.00 kB 05 7,028.71 kB 10,241.00 kB 06 2,430.00 kB 11,096.00 kB 07 23,193.00 kB 48,542.82 kB 08 67,417.33 kB 101,952.33 kB 09 44,364.25 kB 110,845.58 kB 10 77,330.83 kB 111,069.00 kB 11 126,122.67 kB 178,623.67 kB 12 62,137.67 kB 149,207.67 kB 13 52,531.58 kB 105,896.67 kB 14 125,098.00 kB 203,418.92 kB 15 128,100.92 kB 308,407.92 kB 16 69,526.67 kB 161,766.25 kB 17 29,964.27 kB 94,177.27 kB 18 16,239.25 kB 54,553.75 kB 19 207.50 kB 34,858.00 kB 20 6,460.67 kB 28,459.00 kB 21 1,546.80 kB 15,695.80 kB 22 1,273.33 kB 6,578.22 kB 23 163.60 kB 3,494.00 kB -
Temporary Files
Size of temporary files
Key values
- 489.42 MiB Temp Files size Peak
- 2026-09-08 05:31:58 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-08 05:32:06 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.62 MiB 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 0 0 0 10 3 311.99 MiB 104.00 MiB 11 4 415.98 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 3 311.99 MiB 104.00 MiB 15 0 0 0 16 2 207.99 MiB 104.00 MiB 17 1 104.00 MiB 104.00 MiB 18 2 207.99 MiB 104.00 MiB 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.00 GiB 36.49 MiB 244.71 MiB 64.23 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-08 05:32:07 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-08 05:31:58 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 16 1.62 GiB 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( 029478, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 07:22:17 Duration: 7m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029525, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 11:52:41 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029493, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 09:04:57 Duration: 6m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 4 304.66 MiB 56.62 MiB 93.18 MiB 76.16 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-08 05:30:42 Duration: 40s143ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-08 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-08 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 244.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-08 05:31:58 - 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-08 17:19:51 - 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-08 16:48:03 - 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-08 14:54:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-08 10:55:02 - 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-08 11:32:53 - 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-08 14:09:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-08 10:28:31 - 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-08 18:05:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 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-08 11:20:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 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-08 08:41:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-08 11:06:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 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-08 11:38:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 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-08 16:38:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,450,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-09-08 10:13:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 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-08 18:01:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 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-08 14:17:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-08 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 93.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-08 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 71.47 sec Highest CPU-cost vacuum
Table public.fluxos
Database rio - 2026-09-08 15:06:22 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 71.47 sec Highest CPU-cost vacuum
Table public.fluxos
Database rio - 2026-09-08 15:06:22 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (165) Main table analyzed (database rio)
- 1,131 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 165 rio.pg_catalog.pg_class 88 rio.pg_catalog.pg_type 73 rio.public.temp0000290841 72 rio.public.temp0000290745 63 rio.public.temp0000290791 49 rio.pg_catalog.pg_index 47 rio.public.usuarios 47 brasilia.pg_catalog.pg_attribute 40 rio.pg_catalog.pg_depend 36 rio.public.temp0000290230 25 contagem.public.usuarios 24 contagem.pg_catalog.pg_attribute 24 brasilia.pg_catalog.pg_class 22 brasilia.pg_catalog.pg_type 20 rio.public.temp0000290026 20 rio.public.temp0000290769 14 rio.public.temp0000290232 14 rio.public.temp0000290775 14 rio.public.temp0000290805 14 brasilia.public.temp0000239690 12 brasilia.pg_catalog.pg_index 12 rio.public.temp0000290761 11 contagem.pg_catalog.pg_class 11 rio.public.temp0000290799 11 brasilia.pg_catalog.pg_depend 11 contagem.pg_catalog.pg_type 10 rio.public.temp0000290641 9 rio.public.temp0000290781 9 brasilia.public.usuarios 9 brasilia.public.temp0000239738 8 rio.public.temp0000290877 8 brasilia.public.temp0000239736 8 rio.public.temp0000290747 7 contagem.pg_catalog.pg_index 6 rio.public.temp0000290865 6 brasilia.public.nf_entrada 6 rio.public.temp0000290853 6 contagem.pg_catalog.pg_depend 5 rio.pg_catalog.pg_shdepend 5 brasilia.pg_catalog.pg_shdepend 4 rio.public.temp0000290226 4 postgres.pg_catalog.pg_shdepend 4 contagem.public.temp0000227077 4 brasilia.public.temp0000239764 3 brasilia.public.temp0000239686 3 rio.public.tmp_drill_0302 3 rio.public.temp0000290362 3 rio.public.temp0000290787 3 rio.public.temp0000290767 3 contagem.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0175 3 rio.public.temp0000290785 2 rio.public.temp0000290843 2 rio.public.temp0000290807 2 brasilia.auditor.auditor_2026_09 2 brasilia.public.temp0000239712 2 rio.public.temp0000290789 2 rio.auditor.auditor_2026_09 2 rio.public.temp0000290851 2 rio.public.temp0000290875 2 rio.public.temp0000290759 2 brasilia.public.temp0000239692 2 rio.public.temp0000290771 2 brasilia.public.temp0000239728 2 brasilia.public.temp0000239702 1 brasilia.public.temp0000239756 1 contagem.public.nf_entrada 1 brasilia.public.temp0000239766 1 brasilia.public.temp0000239716 1 brasilia.public.temp0000239750 1 brasilia.public.temp0000239724 1 brasilia.public.temp0000239758 1 rio.public.temp0000290765 1 brasilia.public.temp0000239694 1 contagem.public.temp0000227081 1 contagem.public.temp0000227083 1 rio.bk.tab_2026 1 rio.public.temp0000290777 1 brasilia.public.temp0000239730 1 rio.public.temp0000290847 1 rio.public.temp0000290773 1 brasilia.public.temp0000239760 1 contagem.public.temp0000227079 1 brasilia.public.temp0000239752 1 contagem.auditor.auditor_2026_09 1 brasilia.public.temp0000239700 1 contagem.public.temp0000227085 1 rio.public.temp0000290783 1 Total 1,131 Vacuums per table
Key values
- pg_catalog.pg_attribute (60) Main table vacuumed on database rio
- 540 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 60 58 0 0 0 0 0 32,929 9,187 13,566,170 504 12,493 rio.public.temp0000290841 56 0 0 0 0 0 0 17,250 2,598 4,357,109 0 0 rio.public.temp0000290745 43 0 0 0 0 0 0 42,021 2,147 5,165,790 0 0 rio.pg_catalog.pg_class 42 33 0 0 0 0 0 6,729 2,248 3,420,319 125 425 rio.pg_catalog.pg_type 32 31 0 0 0 0 0 3,106 941 1,255,436 82 228 contagem.public.usuarios 24 0 0 0 0 0 0 132 105 54,529 1 1 rio.public.temp0000290791 22 0 0 0 0 0 0 7,691 1,888 2,766,981 0 0 rio.pg_catalog.pg_index 20 19 0 0 0 0 0 1,059 318 350,555 60 126 rio.pg_catalog.pg_depend 17 17 0 0 0 0 0 5,217 1,960 2,827,697 102 833 rio.public.temp0000290230 15 0 0 0 0 0 0 868 188 214,479 0 0 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 7,982 1,357 2,797,283 48 1,255 rio.public.temp0000290805 14 0 0 0 0 0 0 19,587 1,830 3,460,672 0 0 rio.public.temp0000290026 11 0 0 0 0 0 0 413 129 163,624 0 0 brasilia.pg_catalog.pg_class 10 10 0 0 0 0 0 2,040 312 607,116 17 47 rio.pg_catalog.pg_statistic 10 10 0 0 0 0 0 12,250 3,015 13,466,997 1,403 6,311 brasilia.pg_catalog.pg_type 9 9 0 0 0 0 0 855 148 259,620 9 34 rio.public.temp0000290781 9 0 0 0 0 0 0 10,681 33 635,411 0 0 postgres.pg_catalog.pg_shdepend 9 9 0 0 0 0 0 1,480 481 765,724 67 102 contagem.pg_catalog.pg_attribute 8 8 0 0 0 0 0 4,912 1,376 2,447,786 8 205 rio.public.temp0000290877 8 0 0 0 0 0 0 12,492 3,593 5,343,778 0 0 rio.public.temp0000290769 8 0 0 0 0 0 0 363 123 165,889 0 0 brasilia.pg_catalog.pg_index 7 7 0 0 0 0 0 344 92 85,960 8 26 rio.public.temp0000290641 7 0 0 0 0 0 0 197 97 110,778 0 0 rio.public.temp0000290853 6 0 0 0 0 0 0 8,916 24 529,800 0 0 rio.public.temp0000290761 6 0 0 0 0 0 0 198 32 16,281 0 0 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,418 603 3,340,356 172 552 rio.public.tmp_drill_0175 5 3 0 0 0 0 0 1,708 95 368,875 1 67 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 713 157 253,333 5 16 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 430 125 205,904 3 6 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,169 326 518,599 14 256 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 951 223 491,204 4 20 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 153 49 63,686 2 3 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 103 28 46,067 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,040 836 3,406,706 579 3,558 rio.auditor.auditor_2026_09 3 0 0 0 0 0 0 123,961 50,926 70,750,902 36,484 871,119 rio.public.usuarios 2 2 0 0 0 0 0 63 23 47,980 3 6 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 251 62 229,342 17 29 brasilia.public.nf_entrada 2 2 0 0 0 0 0 445 183 384,762 17 24 rio.public.temp0000290843 2 0 0 0 0 0 0 72 8 7,133 0 0 rio.public.temp0000290851 2 0 0 0 0 0 0 131 12 9,467 0 0 brasilia.auditor.auditor_2026_09 2 0 0 0 0 0 0 24,508 13,833 18,119,713 5,024 106,335 brasilia.public.temp0000239712 2 0 0 0 0 0 0 503 8 30,900 0 0 rio.public.temp0000290232 2 0 0 0 0 0 0 141 12 10,081 0 0 brasilia.public.temp0000239728 2 0 0 0 0 0 0 255 7 16,186 0 0 rio.public.temp0000290747 1 0 0 0 0 0 0 33 6 2,746 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,324 312 1,229,118 289 2,214 brasilia.public.temp0000239764 1 0 0 0 0 0 0 251 4 15,412 0 0 rio.public.acessorios 1 1 0 0 0 0 0 11,994 8,547 32,053,389 358 12,916 rio.public.temp0000290773 1 0 0 0 0 0 0 1,784 4 105,859 0 0 rio.public.temp0000290875 1 0 0 0 0 0 0 66 67 132,125 0 0 brasilia.public.temp0000239756 1 0 0 0 0 0 0 251 4 15,412 0 0 brasilia.public.temp0000239766 1 0 0 0 0 0 0 251 4 15,412 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 126 27 84,355 4 12 brasilia.public.temp0000239750 1 0 0 0 0 0 0 251 4 15,412 0 0 rio.public.temp0000290771 1 0 0 0 0 0 0 98 6 6,720 0 0 rio.bk.tab_2026 1 0 0 0 0 0 0 15 6 1,643 0 0 rio.public.temp0000290847 1 0 0 0 0 0 0 64 63 117,628 0 0 rio.public.fluxos 1 1 0 0 0 0 0 195,286 131,766 458,942,940 7,081 137,643 brasilia.public.temp0000239724 1 0 0 0 0 0 0 251 4 15,412 0 0 brasilia.public.temp0000239694 1 0 0 0 0 0 0 4 3 774 0 0 contagem.public.temp0000227083 1 0 0 0 0 0 0 114 6 7,695 0 0 Total 540 268 0 0 0 0 0 574,890 242,571 655,899,032 52,491 1,156,862 Vacuum throughput per table
Key values
- public.fluxos (71.47) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.07 rio.public.temp0000290841 0 0 0.44 rio.public.temp0000290745 0 0 1.35 rio.pg_catalog.pg_class 0 0 1.17 rio.pg_catalog.pg_type 0 0 0.6 contagem.public.usuarios 0 0 0.02 rio.public.temp0000290791 0 0 0.26 rio.pg_catalog.pg_index 0 0 0.21 rio.pg_catalog.pg_depend 0 0 1.13 rio.public.temp0000290230 0 0 0.03 brasilia.pg_catalog.pg_attribute 0 0 1.55 rio.public.temp0000290805 0 0 0.59 rio.public.temp0000290026 0 0 0 brasilia.pg_catalog.pg_class 0 0 1.03 rio.pg_catalog.pg_statistic 0 0 2.22 brasilia.pg_catalog.pg_type 0 0 0.3 rio.public.temp0000290781 0 0 0.42 postgres.pg_catalog.pg_shdepend 0 0 0.82 contagem.pg_catalog.pg_attribute 0 0 1.6 rio.public.temp0000290877 0 0 0.38 rio.public.temp0000290769 0 0 0.01 brasilia.pg_catalog.pg_index 0 0 0.35 rio.public.temp0000290641 0 0 0.01 rio.public.temp0000290853 0 0 0.24 rio.public.temp0000290761 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.57 rio.public.tmp_drill_0175 0 0 0.04 contagem.pg_catalog.pg_class 0 0 0.89 contagem.pg_catalog.pg_type 0 0 0.53 brasilia.pg_catalog.pg_depend 0 0 0.52 contagem.pg_catalog.pg_depend 0 0 0.51 contagem.pg_catalog.pg_index 0 0 0.18 rio.public.tmp_drill_0302 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.6 rio.auditor.auditor_2026_09 0 0 17.6 rio.public.usuarios 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.04 brasilia.public.nf_entrada 0 0 0.17 rio.public.temp0000290843 0 0 0.04 rio.public.temp0000290851 0 0 0 brasilia.auditor.auditor_2026_09 0 0 4.51 brasilia.public.temp0000239712 0 0 0 rio.public.temp0000290232 0 0 0 brasilia.public.temp0000239728 0 0 0 rio.public.temp0000290747 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.11 brasilia.public.temp0000239764 0 0 0 rio.public.acessorios 0 0 4.02 rio.public.temp0000290773 0 0 0.04 rio.public.temp0000290875 0 0 0 brasilia.public.temp0000239756 0 0 0 brasilia.public.temp0000239766 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000239750 0 0 0 rio.public.temp0000290771 0 0 0 rio.bk.tab_2026 0 0 0 rio.public.temp0000290847 0 0 0 rio.public.fluxos 0 0 71.47 brasilia.public.temp0000239724 0 0 0 brasilia.public.temp0000239694 0 0 0 contagem.public.temp0000227083 0 0 0.01 Total 0 0 120.65 Tuples removed per table
Key values
- pg_catalog.pg_attribute (253072) Main table with removed tuples on database rio
- 531989 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 60 58 253,072 1,480,486 46,952 469 36,215 brasilia.pg_catalog.pg_attribute 15 15 72,488 333,862 470 152 8,519 rio.public.fluxos 1 1 46,872 5,246,596 78 0 65,148 contagem.pg_catalog.pg_attribute 8 8 35,031 188,829 149 209 4,189 rio.public.tmp_drill_0175 5 3 24,920 29,872 2,024 0 707 rio.pg_catalog.pg_statistic 10 10 16,949 82,643 0 0 12,860 rio.pg_catalog.pg_depend 17 17 12,522 328,782 5,358 0 3,179 rio.pg_catalog.pg_type 32 31 10,277 76,222 3,288 29 2,323 postgres.pg_catalog.pg_shdepend 9 9 8,269 123,078 806 0 1,125 rio.public.acessorios 1 1 6,135 348,410 0 0 3,160 brasilia.pg_catalog.pg_statistic 3 3 6,083 23,482 0 0 3,216 contagem.pg_catalog.pg_depend 3 3 5,593 56,668 0 14 516 rio.pg_catalog.pg_class 42 33 5,168 160,871 14,611 17 5,690 contagem.pg_catalog.pg_statistic 1 1 4,370 7,274 0 0 1,011 brasilia.pg_catalog.pg_type 9 9 4,244 19,987 4 19 597 rio.pg_catalog.pg_index 20 19 4,041 39,613 1,225 3 1,077 brasilia.pg_catalog.pg_depend 4 4 3,308 72,584 0 11 702 brasilia.pg_catalog.pg_class 10 10 2,378 34,812 8 16 1,285 brasilia.pg_catalog.pg_index 7 7 1,984 13,220 3 14 349 contagem.pg_catalog.pg_type 4 4 1,687 8,986 0 27 237 contagem.public.usuarios 24 0 1,489 576 0 0 48 rio.pg_toast.pg_toast_2619 5 5 1,296 3,338 4 3 1,318 contagem.pg_catalog.pg_index 3 3 806 5,686 0 13 138 brasilia.public.nf_entrada 2 2 726 8,767 0 0 304 rio.public.tmp_drill_0302 3 3 588 1,056 0 0 30 rio.auditor.auditor_2026_09 3 0 449 14,189,279 0 0 644,202 contagem.pg_catalog.pg_class 4 4 430 14,609 0 2 615 brasilia.auditor.auditor_2026_09 2 0 293 2,182,504 0 0 97,003 rio.public.usuarios 2 2 248 1,086 68 0 38 brasilia.pg_toast.pg_toast_2619 2 2 172 264 0 0 118 contagem.pg_toast.pg_toast_2619 1 1 101 118 0 16 37 rio.public.temp0000290853 6 0 0 151,128 0 0 10,752 rio.public.temp0000290747 1 0 0 1,130 0 7 25 rio.public.temp0000290791 22 0 0 177,337 0 278 11,338 rio.public.temp0000290843 2 0 0 26,365 0 0 1,856 brasilia.public.temp0000239764 1 0 0 3,297 0 0 256 rio.public.temp0000290781 9 0 0 226,078 0 0 16,128 rio.public.temp0000290851 2 0 0 2,064 0 13 115 rio.public.temp0000290841 56 0 0 323,780 0 1,137 19,087 rio.public.temp0000290773 1 0 0 25,217 0 0 1,792 rio.public.temp0000290745 43 0 0 698,354 0 113 49,359 rio.public.temp0000290875 1 0 0 1,116 0 0 64 brasilia.public.temp0000239756 1 0 0 3,296 0 0 256 rio.public.temp0000290761 6 0 0 11,171 0 72 248 brasilia.public.temp0000239766 1 0 0 3,297 0 0 256 brasilia.public.temp0000239750 1 0 0 3,293 0 0 256 rio.public.temp0000290771 1 0 0 1,527 0 38 90 brasilia.public.temp0000239712 2 0 0 6,582 0 0 512 rio.bk.tab_2026 1 0 0 1,251 0 1 7 rio.public.temp0000290232 2 0 0 2,232 0 67 125 brasilia.public.temp0000239728 2 0 0 6,582 0 0 512 rio.public.temp0000290847 1 0 0 1,010 0 8 56 rio.public.temp0000290641 7 0 0 10,593 0 85 235 rio.public.temp0000290877 8 0 0 201,735 0 0 14,336 rio.public.temp0000290230 15 0 0 35,845 0 297 791 brasilia.public.temp0000239724 1 0 0 3,291 0 0 256 brasilia.public.temp0000239694 1 0 0 3,291 0 0 256 rio.public.temp0000290805 14 0 0 351,931 0 0 25,088 rio.public.temp0000290769 8 0 0 20,610 0 274 462 contagem.public.temp0000227083 1 0 0 1,362 0 22 106 rio.public.temp0000290026 11 0 0 26,974 0 228 604 Total 540 268 531,989 27,415,299 75,048 3,654 1,051,180 Pages removed per table
Key values
- public.temp0000290841 (1137) Main table with removed pages on database rio
- 3654 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000290841 56 0 0 1137 rio.pg_catalog.pg_attribute 60 58 253072 469 rio.public.temp0000290230 15 0 0 297 rio.public.temp0000290791 22 0 0 278 rio.public.temp0000290769 8 0 0 274 rio.public.temp0000290026 11 0 0 228 contagem.pg_catalog.pg_attribute 8 8 35031 209 brasilia.pg_catalog.pg_attribute 15 15 72488 152 rio.public.temp0000290745 43 0 0 113 rio.public.temp0000290641 7 0 0 85 rio.public.temp0000290761 6 0 0 72 rio.public.temp0000290232 2 0 0 67 rio.public.temp0000290771 1 0 0 38 rio.pg_catalog.pg_type 32 31 10277 29 contagem.pg_catalog.pg_type 4 4 1687 27 contagem.public.temp0000227083 1 0 0 22 brasilia.pg_catalog.pg_type 9 9 4244 19 rio.pg_catalog.pg_class 42 33 5168 17 brasilia.pg_catalog.pg_class 10 10 2378 16 contagem.pg_toast.pg_toast_2619 1 1 101 16 contagem.pg_catalog.pg_depend 3 3 5593 14 brasilia.pg_catalog.pg_index 7 7 1984 14 rio.public.temp0000290851 2 0 0 13 contagem.pg_catalog.pg_index 3 3 806 13 brasilia.pg_catalog.pg_depend 4 4 3308 11 rio.public.temp0000290847 1 0 0 8 rio.public.temp0000290747 1 0 0 7 rio.pg_toast.pg_toast_2619 5 5 1296 3 rio.pg_catalog.pg_index 20 19 4041 3 contagem.pg_catalog.pg_class 4 4 430 2 rio.bk.tab_2026 1 0 0 1 rio.public.temp0000290853 6 0 0 0 rio.public.usuarios 2 2 248 0 rio.pg_catalog.pg_depend 17 17 12522 0 brasilia.pg_toast.pg_toast_2619 2 2 172 0 brasilia.public.nf_entrada 2 2 726 0 contagem.pg_catalog.pg_statistic 1 1 4370 0 rio.public.temp0000290843 2 0 0 0 brasilia.public.temp0000239764 1 0 0 0 rio.public.temp0000290781 9 0 0 0 rio.public.acessorios 1 1 6135 0 rio.public.temp0000290773 1 0 0 0 rio.public.temp0000290875 1 0 0 0 brasilia.public.temp0000239756 1 0 0 0 postgres.pg_catalog.pg_shdepend 9 9 8269 0 brasilia.public.temp0000239766 1 0 0 0 brasilia.public.temp0000239750 1 0 0 0 brasilia.auditor.auditor_2026_09 2 0 293 0 brasilia.public.temp0000239712 2 0 0 0 rio.public.tmp_drill_0302 3 3 588 0 brasilia.public.temp0000239728 2 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6083 0 rio.auditor.auditor_2026_09 3 0 449 0 rio.public.tmp_drill_0175 5 3 24920 0 rio.public.temp0000290877 8 0 0 0 rio.public.fluxos 1 1 46872 0 rio.pg_catalog.pg_statistic 10 10 16949 0 contagem.public.usuarios 24 0 1489 0 brasilia.public.temp0000239724 1 0 0 0 brasilia.public.temp0000239694 1 0 0 0 rio.public.temp0000290805 14 0 0 0 Total 540 268 531,989 3,654 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 08 00 1 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 10 24 08 50 116 09 25 83 10 62 148 11 73 150 12 26 61 13 38 76 14 64 131 15 77 145 16 63 121 17 31 64 18 11 10 19 0 0 20 0 0 21 3 1 22 0 1 23 0 0 - 71.47 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m59s 2m59s 2m59s 2m59s call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:28:41 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 07:55:16 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:15:16 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 2 2m12s 55s493ms 1m17s 1m6s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 15:26:27 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 14:36:07 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 00:05:24 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
Queries that waited the most
Rank Wait time Query 1 2m59s CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-09-08 11:28:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m17s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-08 15:26:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 55s493ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-08 14:36:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 3,977 Total read queries
- 1,435 Total write queries
Queries by database
Key values
- rio Main database
- 4,124 Requests
- 7h4m53s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,208 1h40m23s copy to 139 10m46s ddl 134 2m58s others 190 10m54s select 745 1h15m44s contagem Total 540 11m27s copy to 115 1m20s ddl 78 49s875ms others 10 3m18s select 337 5m57s postgres Total 3 528ms select 3 528ms rio Total 4,124 7h4m53s copy to 148 29m11s ddl 817 1h18m54s delete 1 13s378ms others 263 36m51s select 2,892 4h39m41s tcl 2 611ms update 1 159ms Queries by user
Key values
- intelifix Main user
- 6,498 Requests
User Request type Count Duration etiquetas Total 117 39s70ms select 117 39s70ms intelifix Total 6,498 12h47m41s copy to 803 1h23m25s ddl 1,026 1h21m57s others 765 1h22m47s select 3,902 8h39m30s tcl 2 611ms lenon Total 128 4m29s ddl 3 46s311ms delete 1 13s378ms select 123 3m29s update 1 159ms Duration by user
Key values
- 12h47m41s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 117 39s70ms select 117 39s70ms intelifix Total 6,498 12h47m41s copy to 803 1h23m25s ddl 1,026 1h21m57s others 765 1h22m47s select 3,902 8h39m30s tcl 2 611ms lenon Total 128 4m29s ddl 3 46s311ms delete 1 13s378ms select 123 3m29s update 1 159ms Queries by host
Key values
- [local] Main host
- 6,726 Requests
- 12h49m34s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,721 Requests
- 4h12m7s ([unknown])
- Main time consuming application
Application Request type Count Duration [unknown] Total 4,721 4h12m7s ddl 1,026 1h21m57s select 3,693 2h50m9s tcl 2 611ms pgAdmin 4 - CONN:1158561 Total 2 14s456ms ddl 1 14s267ms select 1 188ms pgAdmin 4 - CONN:4227973 Total 10 2m7s ddl 2 32s44ms delete 1 13s378ms select 6 1m21s update 1 159ms pgAdmin 4 - CONN:4629397 Total 2 53s371ms select 2 53s371ms pgAdmin 4 - DB:postgres Total 3 528ms select 3 528ms pg_dump Total 418 41m23s copy to 402 41m19s select 16 4s405ms psql Total 719 3h59m58s others 463 51m4s select 256 3h8m54s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-08 06:31:15 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,710 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m5s analyze verbose;[ Date: 2026-09-08 05:11:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-08 07:15:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029478, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 07:22:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 6m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029525, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 11:52:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m50s analyze verbose;[ Date: 2026-09-08 05:17:57 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 6m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029493, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 09:04:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-08 15:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029516, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 11:28:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029489, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 08:49:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-08 09:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029574, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 15:26:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-08 16:10:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029483, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 08:07:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029480, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 07:48:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029568, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 14:36:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029570, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 14:54:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029495, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 09:34:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-08 14:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029497, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-08 10:13:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-08 17:10:33 - 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 1h55m11s 238 153ms 7m11s 29s41ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 08 07 7 13m5s 1m52s 08 27 14m10s 31s495ms 09 30 13m26s 26s867ms 10 31 17m12s 33s318ms 11 21 18m4s 51s648ms 12 9 5m45s 38s379ms 13 21 1m7s 3s232ms 14 24 14m46s 36s928ms 15 23 7m17s 19s16ms 16 29 5m23s 11s140ms 17 13 3m 13s853ms 18 3 1m52s 37s477ms [ User: intelifix - Total duration: 1h55m11s - Times executed: 238 ]
[ Application: [unknown] - Total duration: 1h55m11s - Times executed: 238 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029478, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 07:22:17 Duration: 7m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029525, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 11:52:41 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029493, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 09:04:57 Duration: 6m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 1h38m16s 48 1s340ms 10m32s 2m2s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 08 07 3 11m23s 3m47s 08 3 5m54s 1m58s 09 3 6m44s 2m14s 10 3 5m48s 1m56s 11 3 5m44s 1m54s 12 3 5m48s 1m56s 13 3 5m35s 1m51s 14 3 5m58s 1m59s 15 3 6m34s 2m11s 16 3 6m10s 2m3s 17 3 5m52s 1m57s 18 3 5m33s 1m51s 19 3 5m4s 1m41s 20 3 5m37s 1m52s 21 3 5m28s 1m49s 22 3 4m57s 1m39s [ User: intelifix - Total duration: 1h38m16s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m16s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-08 07:15:34 Duration: 10m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-08 15:11:13 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-08 09:10:55 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 1h14m32s 48 295ms 4m21s 1m33s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 08 07 3 6m14s 2m4s 08 3 4m30s 1m30s 09 3 5m56s 1m58s 10 3 4m14s 1m24s 11 3 4m9s 1m23s 12 3 4m51s 1m37s 13 3 4m39s 1m33s 14 3 4m52s 1m37s 15 3 5m11s 1m43s 16 3 4m44s 1m34s 17 3 4m45s 1m35s 18 3 4m8s 1m22s 19 3 4m 1m20s 20 3 4m14s 1m24s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h14m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h14m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-08 07:22:27 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-08 09:17:30 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-08 15:16:43 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 20m54s 3 2m58s 11m5s 6m58s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 08 05 3 20m54s 6m58s [ User: intelifix - Total duration: 20m54s - Times executed: 3 ]
[ Application: psql - Total duration: 20m54s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-08 05:11:07 Duration: 11m5s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-09-08 05:17:57 Duration: 6m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-09-08 05:20:56 Duration: 2m58s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 20m28s 102 9s999ms 43s260ms 12s43ms create table temp0000290745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 08 07 13 2m25s 11s200ms 08 19 3m47s 11s991ms 09 6 1m37s 16s226ms 10 12 2m20s 11s681ms 11 10 1m44s 10s420ms 12 18 3m10s 10s580ms 14 12 2m41s 13s460ms 15 6 1m9s 11s621ms 16 6 1m31s 15s251ms [ User: intelifix - Total duration: 20m28s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 20m28s - Times executed: 102 ]
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 09:27:15 Duration: 43s260ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 14:47:03 Duration: 40s55ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 16:30:00 Duration: 37s765ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 15m15s 1,167 150ms 7s88ms 784ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 08 07 1 445ms 445ms 08 66 1m1s 931ms 09 156 2m23s 916ms 10 141 2m15s 962ms 11 94 1m13s 784ms 12 59 52s753ms 894ms 13 89 1m1s 686ms 14 171 2m13s 780ms 15 201 2m16s 680ms 16 127 1m21s 641ms 17 62 35s114ms 566ms [ User: intelifix - Total duration: 15m15s - Times executed: 1167 ]
[ Application: [unknown] - Total duration: 15m15s - Times executed: 1167 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285349, 507, 'CP2317320H8,D4925E947261,544D424200681AFB,D4925E947264$CP2322323GL,D4925EB35BAD,544D4242006B9AA5,D4925EB35BB0$CP2404322NC,08C7F525537D,544D4242007721E6,08C7F5255380$CP2335320N3,D4925EE974F6,544D4242006F4D9F,D4925EE974F9', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$$$','', 00);
Date: 2026-09-08 12:48:44 Duration: 7s88ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285135, 304, '929240742534,2035435A7C5A,B0924A123D8F,94988F2EF7B5,B0924A116F40,CC5830FEC311,CC5830017067,20354314A8C6,D8CF616300BC,20B82B25EF0E,2035435A887E,8C9A8F5D9C07,94988F2F10BA,3817B1981DAF', '',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-08 11:25:32 Duration: 5s39ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (56900, 406, 'ZTE3ANNT3H66991,D831399CE5B2,D831399CE5B3,ZTEGDD32D64E$ZTE3ANNR9325888,D89A0D84BECB,D89A0D84BECC,ZTEGDB14D91F$ZTE3ANNR7B32791,3891484BED31,3891484BED32,ZTEGDB081177$ZTE3ANNRC558920,6C11BA678EC7,6C11BA678EC8,ZTEGDC6EFBE7$ZTE3ANNRC556523,6C11BA675699,6C11BA67569A,ZTEGDC6EF28A$ZTE3ANNQ8M40295,843C99227855,843C99227856,ZTEGD7BAE4D4$ZTE3ANNR4N48130,4896D959C324,4896D959C325,ZTEGD97FDBC7$ZTE3ANNRCP03617,6C11BA697F95,ZTEGDC6F4EB4,6C11BA697F96$ZTE3ANNR6R50732,48D6823A29CA,48D6823A29CB,ZTEGDB01F0FF$ZTE3ANNR5W17942,48D68230284E,48D68230284F,ZTEGDB004615$ZTE3ANNQ4N00461,3CF9F0A89C7C,3CF9F0A89C7D,ZTEGD64104C8$ZTE3ANNR5W00945,48D6822E99F0,48D6822E99F1,ZTEGDB0003B0$ZTE3ANNR3J07138,F4E84F86F5AC,F4E84F86F5AD,ZTEGD97B7DAC$ZTE3ANNQ7504843,C4EBFF8B64BE,C4EBFF8B64BF,ZTEGD70A618B$ZTE3ANNQ4A03375,3CF9F0AA4760,3CF9F0AA4761,ZTEGD6414BEE$ZTE3ANNQCA39975,14CA56D5EDC5,14CA56D5EDC6,ZTEGD9720192$ZTE3ANNRB747606,5872C99294F5,5872C99294F6,ZTEGDC61E4C9$ZTE3ANNR7B32811,3891484BEDA9,3891484BEDAA,ZTEGDB08118B$ZTE3ANNQ9J21901,843C992DD283,843C992DD284,ZTEGD7BB5E38$ZTE3ANNRC554049,6C11BA671C9D,6C11BA671C9E,ZTEGDC6EE8E0$ZTE3ANNR1Y08383,14CA56CD6EF5,14CA56CD6EF6,ZTEGD970971A$ZTE3ANNRC560201,6C11BA67ACCD,6C11BA67ACCE,ZTEGDC6F00E8$ZTE3ANNR9W44822,D89A0DAC76A7,D89A0DAC76A8,ZTEGDB16C0C1$ZTE3ANNQ4N02161,3CF9F0A8C454,3CF9F0A8C455,ZTEGD6410B6C$ZTE3ANNR1Y02291,14CA56CCE02D,14CA56CCE02E,ZTEGD9707F4E$ZTE3ANNR9W20330,D89A0DAA389F,D89A0DAA38A0,ZTEGDB166115$ZTE3ANNT2V21862,D831398D8F3C,D831398D8F3D,ZTEGDD3047E5$ZTE3ANNQ8M07966,843C991F829F,843C991F82A0,ZTEGD7BA668B$ZTE3ANNR5W08000,48D6822F3F4A,48D6822F3F4B,ZTEGDB001F3F$ZTE3ANNQ8M42972,843C9922B713,843C9922B714,ZTEGD7BAEF49$ZTE3ANNR3Y22386,4896D951CD64,4896D951CD65,ZTEGD97E8827$ZTE3ANNR5W08231,48D6822F44B4,48D6822F44B5,ZTEGDB002026$ZTE3ANNT3J10829,D83139A0E920,D83139A0E921,ZTEGDD33818B$ZTE3ANNT2V51666,D831399049C4,D831399049C5,ZTEGDD30BC51$ZTE3ANNR2Q02188,F4E84F80E748,F4E84F80E749,ZTEGD97A7B46$ZTE3ANNR7B32068,3891484BDC3F,3891484BDC40,ZTEGDB080EA4$ZTE3ANNQ6M08485,C4EBFF8928AE,C4EBFF8928AF,ZTEGD70A0233$ZTE3ANNR5W69099,48D68234D74C,48D68234D74D,ZTEGDB010DEA$ZTE3ANNR1Y45648,14CA56D0D85B,14CA56D0D85C,ZTEGD97128AB$ZTE3ANNR9F20366,D89A0DA4BB37,D89A0DA4BB38,ZTEGDB1576D9$ZTE3ANNQ6M10191,C4EBFF8950AA,C4EBFF8950AB,ZTEGD70A08DD$ZTE3ANNT3H23500,D8313998EA60,D8313998EA61,ZTEGDD322C6B$ZTE3ANNQ7903820,C4EBFF8C7798,C4EBFF8C7799,ZTEGD70A8F5A$ZTE3ANNR9F40707,D89A0DA697F5,D89A0DA697F6,ZTEGDB15C64E', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-08 10:14:10 Duration: 4s762ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 13m14s 137 177ms 3m39s 5s799ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 08 00 1 353ms 353ms 07 11 47s358ms 4s305ms 08 12 1m 5s41ms 09 12 54s269ms 4s522ms 10 12 1m8s 5s717ms 11 13 4m48s 22s161ms 12 13 53s461ms 4s112ms 13 10 15s685ms 1s568ms 14 12 57s859ms 4s821ms 15 11 50s744ms 4s613ms 16 11 41s999ms 3s818ms 17 5 13s628ms 2s725ms 20 2 577ms 288ms 21 6 21s469ms 3s578ms 22 6 19s905ms 3s317ms [ User: intelifix - Total duration: 13m14s - Times executed: 137 ]
[ Application: psql - Total duration: 13m14s - Times executed: 137 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:28:41 Duration: 3m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 07:55:16 Duration: 15s430ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:15:16 Duration: 15s256ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 12m 61 10s340ms 35s229ms 11s813ms create table temp0000290841 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 08 13 19 3m53s 12s290ms 14 11 1m57s 10s724ms 15 28 5m35s 11s994ms 16 3 33s253ms 11s84ms [ User: intelifix - Total duration: 12m - Times executed: 61 ]
[ Application: [unknown] - Total duration: 12m - Times executed: 61 ]
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 15:18:23 Duration: 35s229ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 13:21:10 Duration: 34s983ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 15:35:33 Duration: 12s466ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 11m28s 958 150ms 9s504ms 718ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 08 07 13 12s477ms 959ms 08 104 1m17s 745ms 09 107 1m15s 709ms 10 147 1m50s 752ms 11 112 1m34s 846ms 12 8 7s880ms 985ms 13 109 1m16s 699ms 14 135 1m21s 600ms 15 99 1m5s 662ms 16 89 59s469ms 668ms 17 35 26s919ms 769ms [ User: intelifix - Total duration: 11m28s - Times executed: 958 ]
[ Application: [unknown] - Total duration: 11m28s - Times executed: 958 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "155", "itens" : "CC5830E2A8CB,D833B7C9B8B5,345D9EBE15A6,44D4549537DB,CC5830E2BF45,841EA38E8E85,C03C0480B6A4", "usuario" : "414", "caixa" : "2754147", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-08 10:38:17 Duration: 9s504ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285154", "modelo" : "155", "itens" : "C03C04867015,E8D2FFA5B407,186A81D580F7,B0BBE54D1FA8,E4C0E240BCC1,64FD9653EDE5,8CC5B4E32D6D,94988F949E0B,CC5830E3F27A,ACD75BB56FE1", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-08 11:45:54 Duration: 9s263ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285292", "modelo" : "185", "itens" : "C4509CAB402C,B85E71E18228,08A7C04E8ACC,F8D2AC4BECB8,CCF3C836DDBC,B85E71E4672C,3C82C067311C,B85E71E44684,8C6A8DBEF6BC,C4509CAB61A4,3C82C06D3CC4,E4BFFAFC5174,B85E71E55178,B85E710F7804", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-08 11:46:27 Duration: 7s433ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 10m1s 83 151ms 49s71ms 7s245ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 08 07 3 623ms 207ms 08 4 983ms 245ms 09 8 3s839ms 479ms 10 11 1m24s 7s654ms 11 18 2m50s 9s444ms 12 1 5s495ms 5s495ms 13 11 1m43s 9s394ms 14 11 2m39s 14s470ms 15 6 40s136ms 6s689ms 16 2 32s11ms 16s5ms 17 8 1s533ms 191ms [ User: intelifix - Total duration: 10m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 10m1s - Times executed: 83 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "243112", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "BAIXA", "data-saida" : "2026-05-21", "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-08 11:51:30 Duration: 49s71ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "229989", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "BAIXA", "data-saida" : "2026-04-10", "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-08 10:39:58 Duration: 41s369ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "103107", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "BAIXA", "data-saida" : "2025-01-03", "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-08 15:04:47 Duration: 38s847ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 9m46s 214 150ms 1m20s 2s738ms call rs_giga_triagem (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 08 00 9 41s213ms 4s579ms 01 7 15s731ms 2s247ms 02 10 16s165ms 1s616ms 03 9 16s610ms 1s845ms 04 10 16s37ms 1s603ms 05 7 15s599ms 2s228ms 06 11 16s903ms 1s536ms 07 8 19s641ms 2s455ms 08 11 24s744ms 2s249ms 09 10 20s731ms 2s73ms 10 10 19s912ms 1s991ms 11 10 30s74ms 3s7ms 12 9 18s726ms 2s80ms 13 9 15s975ms 1s775ms 14 10 1m13s 7s330ms 15 11 1m35s 8s690ms 16 11 21s97ms 1s917ms 17 11 17s785ms 1s616ms 18 8 16s629ms 2s78ms 19 8 15s881ms 1s985ms 20 9 26s59ms 2s895ms 21 8 15s746ms 1s968ms 22 8 15s911ms 1s988ms [ User: intelifix - Total duration: 9m46s - Times executed: 214 ]
[ Application: psql - Total duration: 9m46s - Times executed: 214 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 15:26:27 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 14:36:07 Duration: 58s804ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 00:05:24 Duration: 22s322ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 9m29s 69 513ms 1m1s 8s255ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 08 07 2 1m4s 32s392ms 08 6 1m11s 11s891ms 09 1 16s418ms 16s418ms 10 7 1m21s 11s713ms 11 14 1m32s 6s605ms 12 7 23s626ms 3s375ms 13 7 41s679ms 5s954ms 14 8 1m5s 8s214ms 15 9 36s112ms 4s12ms 16 6 53s224ms 8s870ms 18 2 22s247ms 11s123ms [ User: intelifix - Total duration: 9m29s - Times executed: 69 ]
[ Application: psql - Total duration: 9m29s - Times executed: 69 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029478);
Date: 2026-09-08 07:15:36 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029500);
Date: 2026-09-08 10:44:05 Duration: 43s273ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029493);
Date: 2026-09-08 08:58:19 Duration: 33s31ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 9m2s 82 1s58ms 1m3s 6s613ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 08 07 4 12s253ms 3s63ms 08 2 41s765ms 20s882ms 09 7 15s877ms 2s268ms 10 7 1m13s 10s526ms 11 6 1m19s 13s251ms 12 1 1s410ms 1s410ms 13 4 42s739ms 10s684ms 14 4 42s22ms 10s505ms 15 10 1m10s 7s53ms 16 17 1m23s 4s923ms 17 19 1m16s 4s13ms 18 1 2s551ms 2s551ms [ User: intelifix - Total duration: 9m2s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 9m2s - Times executed: 82 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 11:48:49 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 10:02:33 Duration: 38s598ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 13:17:28 Duration: 36s605ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 7m38s 40 10s224ms 38s287ms 11s452ms create table temp0000290791 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 08 10 7 1m18s 11s237ms 11 21 4m9s 11s883ms 12 12 2m9s 10s822ms [ User: intelifix - Total duration: 7m38s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 7m38s - Times executed: 40 ]
-
CREATE TABLE temp0000290791 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 11:53:18 Duration: 38s287ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290791 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 10:43:13 Duration: 12s450ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290791 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 12:15:03 Duration: 11s640ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 4m49s 71 157ms 39s875ms 4s75ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 08 07 5 3s185ms 637ms 08 11 1m9s 6s360ms 09 2 602ms 301ms 10 8 42s826ms 5s353ms 11 13 46s172ms 3s551ms 12 8 2s578ms 322ms 13 7 1s546ms 220ms 14 8 31s479ms 3s934ms 15 2 1s415ms 707ms 16 4 23s209ms 5s802ms 17 1 23s92ms 23s92ms 18 2 43s309ms 21s654ms [ User: intelifix - Total duration: 4m49s - Times executed: 71 ]
[ Application: psql - Total duration: 4m49s - Times executed: 71 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029490);
Date: 2026-09-08 08:51:17 Duration: 39s875ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029519);
Date: 2026-09-08 11:33:52 Duration: 31s264ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029600);
Date: 2026-09-08 18:06:34 Duration: 28s294ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 4m36s 21 10s250ms 53s452ms 13s161ms create table temp0000290805 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 08 10 8 1m34s 11s846ms 11 13 3m1s 13s971ms [ User: intelifix - Total duration: 4m36s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m36s - Times executed: 21 ]
-
CREATE TABLE temp0000290805 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 11:26:44 Duration: 53s452ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290805 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 10:13:25 Duration: 14s546ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290805 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 10:28:51 Duration: 13s178ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 3m35s 31 186ms 39s985ms 6s937ms create table temp0000290230 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 08 10 9 49s576ms 5s508ms 11 10 1m12s 7s233ms 12 1 6s348ms 6s348ms 13 8 49s115ms 6s139ms 15 2 1s52ms 526ms 16 1 36s618ms 36s618ms [ User: intelifix - Total duration: 3m35s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 31 ]
-
CREATE TABLE temp0000290230 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 10:31:06 Duration: 39s985ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290230 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "204252 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 16:45:21 Duration: 36s618ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290230 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "243112 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 11:50:13 Duration: 33s718ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 2m56s 15 10s160ms 24s924ms 11s790ms create table temp0000290877 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 08 16 5 55s46ms 11s9ms 17 4 57s800ms 14s450ms 18 6 1m4s 10s668ms [ User: intelifix - Total duration: 2m56s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m56s - Times executed: 15 ]
-
CREATE TABLE temp0000290877 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 17:20:46 Duration: 24s924ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290877 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 18:01:25 Duration: 11s644ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290877 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 16:39:15 Duration: 11s629ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 2m46s 49 2s109ms 20s981ms 3s391ms create table temp0000290841 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 08 13 15 52s725ms 3s515ms 14 10 37s381ms 3s738ms 15 22 1m8s 3s101ms 16 2 7s855ms 3s927ms [ User: intelifix - Total duration: 2m46s - Times executed: 49 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 49 ]
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 13:19:32 Duration: 20s981ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 14:13:37 Duration: 16s603ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 15:19:23 Duration: 14s971ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 2m29s 23 168ms 29s595ms 6s506ms create table temp0000290026 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 08 08 1 27s275ms 27s275ms 10 6 20s201ms 3s366ms 11 2 23s305ms 11s652ms 13 7 49s66ms 7s9ms 15 6 27s128ms 4s521ms 16 1 2s668ms 2s668ms [ User: intelifix - Total duration: 2m29s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 2m29s - Times executed: 23 ]
-
CREATE TABLE temp0000290026 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "241493 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 13:16:00 Duration: 29s595ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290026 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 08:06:48 Duration: 27s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290026 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "103107 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 15:02:48 Duration: 24s689ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,167 15m15s 150ms 7s88ms 784ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 08 07 1 445ms 445ms 08 66 1m1s 931ms 09 156 2m23s 916ms 10 141 2m15s 962ms 11 94 1m13s 784ms 12 59 52s753ms 894ms 13 89 1m1s 686ms 14 171 2m13s 780ms 15 201 2m16s 680ms 16 127 1m21s 641ms 17 62 35s114ms 566ms [ User: intelifix - Total duration: 15m15s - Times executed: 1167 ]
[ Application: [unknown] - Total duration: 15m15s - Times executed: 1167 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285349, 507, 'CP2317320H8,D4925E947261,544D424200681AFB,D4925E947264$CP2322323GL,D4925EB35BAD,544D4242006B9AA5,D4925EB35BB0$CP2404322NC,08C7F525537D,544D4242007721E6,08C7F5255380$CP2335320N3,D4925EE974F6,544D4242006F4D9F,D4925EE974F9', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$$$','', 00);
Date: 2026-09-08 12:48:44 Duration: 7s88ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285135, 304, '929240742534,2035435A7C5A,B0924A123D8F,94988F2EF7B5,B0924A116F40,CC5830FEC311,CC5830017067,20354314A8C6,D8CF616300BC,20B82B25EF0E,2035435A887E,8C9A8F5D9C07,94988F2F10BA,3817B1981DAF', '',0302,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-08 11:25:32 Duration: 5s39ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (56900, 406, 'ZTE3ANNT3H66991,D831399CE5B2,D831399CE5B3,ZTEGDD32D64E$ZTE3ANNR9325888,D89A0D84BECB,D89A0D84BECC,ZTEGDB14D91F$ZTE3ANNR7B32791,3891484BED31,3891484BED32,ZTEGDB081177$ZTE3ANNRC558920,6C11BA678EC7,6C11BA678EC8,ZTEGDC6EFBE7$ZTE3ANNRC556523,6C11BA675699,6C11BA67569A,ZTEGDC6EF28A$ZTE3ANNQ8M40295,843C99227855,843C99227856,ZTEGD7BAE4D4$ZTE3ANNR4N48130,4896D959C324,4896D959C325,ZTEGD97FDBC7$ZTE3ANNRCP03617,6C11BA697F95,ZTEGDC6F4EB4,6C11BA697F96$ZTE3ANNR6R50732,48D6823A29CA,48D6823A29CB,ZTEGDB01F0FF$ZTE3ANNR5W17942,48D68230284E,48D68230284F,ZTEGDB004615$ZTE3ANNQ4N00461,3CF9F0A89C7C,3CF9F0A89C7D,ZTEGD64104C8$ZTE3ANNR5W00945,48D6822E99F0,48D6822E99F1,ZTEGDB0003B0$ZTE3ANNR3J07138,F4E84F86F5AC,F4E84F86F5AD,ZTEGD97B7DAC$ZTE3ANNQ7504843,C4EBFF8B64BE,C4EBFF8B64BF,ZTEGD70A618B$ZTE3ANNQ4A03375,3CF9F0AA4760,3CF9F0AA4761,ZTEGD6414BEE$ZTE3ANNQCA39975,14CA56D5EDC5,14CA56D5EDC6,ZTEGD9720192$ZTE3ANNRB747606,5872C99294F5,5872C99294F6,ZTEGDC61E4C9$ZTE3ANNR7B32811,3891484BEDA9,3891484BEDAA,ZTEGDB08118B$ZTE3ANNQ9J21901,843C992DD283,843C992DD284,ZTEGD7BB5E38$ZTE3ANNRC554049,6C11BA671C9D,6C11BA671C9E,ZTEGDC6EE8E0$ZTE3ANNR1Y08383,14CA56CD6EF5,14CA56CD6EF6,ZTEGD970971A$ZTE3ANNRC560201,6C11BA67ACCD,6C11BA67ACCE,ZTEGDC6F00E8$ZTE3ANNR9W44822,D89A0DAC76A7,D89A0DAC76A8,ZTEGDB16C0C1$ZTE3ANNQ4N02161,3CF9F0A8C454,3CF9F0A8C455,ZTEGD6410B6C$ZTE3ANNR1Y02291,14CA56CCE02D,14CA56CCE02E,ZTEGD9707F4E$ZTE3ANNR9W20330,D89A0DAA389F,D89A0DAA38A0,ZTEGDB166115$ZTE3ANNT2V21862,D831398D8F3C,D831398D8F3D,ZTEGDD3047E5$ZTE3ANNQ8M07966,843C991F829F,843C991F82A0,ZTEGD7BA668B$ZTE3ANNR5W08000,48D6822F3F4A,48D6822F3F4B,ZTEGDB001F3F$ZTE3ANNQ8M42972,843C9922B713,843C9922B714,ZTEGD7BAEF49$ZTE3ANNR3Y22386,4896D951CD64,4896D951CD65,ZTEGD97E8827$ZTE3ANNR5W08231,48D6822F44B4,48D6822F44B5,ZTEGDB002026$ZTE3ANNT3J10829,D83139A0E920,D83139A0E921,ZTEGDD33818B$ZTE3ANNT2V51666,D831399049C4,D831399049C5,ZTEGDD30BC51$ZTE3ANNR2Q02188,F4E84F80E748,F4E84F80E749,ZTEGD97A7B46$ZTE3ANNR7B32068,3891484BDC3F,3891484BDC40,ZTEGDB080EA4$ZTE3ANNQ6M08485,C4EBFF8928AE,C4EBFF8928AF,ZTEGD70A0233$ZTE3ANNR5W69099,48D68234D74C,48D68234D74D,ZTEGDB010DEA$ZTE3ANNR1Y45648,14CA56D0D85B,14CA56D0D85C,ZTEGD97128AB$ZTE3ANNR9F20366,D89A0DA4BB37,D89A0DA4BB38,ZTEGDB1576D9$ZTE3ANNQ6M10191,C4EBFF8950AA,C4EBFF8950AB,ZTEGD70A08DD$ZTE3ANNT3H23500,D8313998EA60,D8313998EA61,ZTEGDD322C6B$ZTE3ANNQ7903820,C4EBFF8C7798,C4EBFF8C7799,ZTEGD70A8F5A$ZTE3ANNR9F40707,D89A0DA697F5,D89A0DA697F6,ZTEGDB15C64E', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-08 10:14:10 Duration: 4s762ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 958 11m28s 150ms 9s504ms 718ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 08 07 13 12s477ms 959ms 08 104 1m17s 745ms 09 107 1m15s 709ms 10 147 1m50s 752ms 11 112 1m34s 846ms 12 8 7s880ms 985ms 13 109 1m16s 699ms 14 135 1m21s 600ms 15 99 1m5s 662ms 16 89 59s469ms 668ms 17 35 26s919ms 769ms [ User: intelifix - Total duration: 11m28s - Times executed: 958 ]
[ Application: [unknown] - Total duration: 11m28s - Times executed: 958 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "155", "itens" : "CC5830E2A8CB,D833B7C9B8B5,345D9EBE15A6,44D4549537DB,CC5830E2BF45,841EA38E8E85,C03C0480B6A4", "usuario" : "414", "caixa" : "2754147", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-08 10:38:17 Duration: 9s504ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285154", "modelo" : "155", "itens" : "C03C04867015,E8D2FFA5B407,186A81D580F7,B0BBE54D1FA8,E4C0E240BCC1,64FD9653EDE5,8CC5B4E32D6D,94988F949E0B,CC5830E3F27A,ACD75BB56FE1", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-08 11:45:54 Duration: 9s263ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "285292", "modelo" : "185", "itens" : "C4509CAB402C,B85E71E18228,08A7C04E8ACC,F8D2AC4BECB8,CCF3C836DDBC,B85E71E4672C,3C82C067311C,B85E71E44684,8C6A8DBEF6BC,C4509CAB61A4,3C82C06D3CC4,E4BFFAFC5174,B85E71E55178,B85E710F7804", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-08 11:46:27 Duration: 7s433ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 238 1h55m11s 153ms 7m11s 29s41ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 08 07 7 13m5s 1m52s 08 27 14m10s 31s495ms 09 30 13m26s 26s867ms 10 31 17m12s 33s318ms 11 21 18m4s 51s648ms 12 9 5m45s 38s379ms 13 21 1m7s 3s232ms 14 24 14m46s 36s928ms 15 23 7m17s 19s16ms 16 29 5m23s 11s140ms 17 13 3m 13s853ms 18 3 1m52s 37s477ms [ User: intelifix - Total duration: 1h55m11s - Times executed: 238 ]
[ Application: [unknown] - Total duration: 1h55m11s - Times executed: 238 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029478, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 07:22:17 Duration: 7m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029525, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 11:52:41 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029493, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 09:04:57 Duration: 6m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 214 9m46s 150ms 1m20s 2s738ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 08 00 9 41s213ms 4s579ms 01 7 15s731ms 2s247ms 02 10 16s165ms 1s616ms 03 9 16s610ms 1s845ms 04 10 16s37ms 1s603ms 05 7 15s599ms 2s228ms 06 11 16s903ms 1s536ms 07 8 19s641ms 2s455ms 08 11 24s744ms 2s249ms 09 10 20s731ms 2s73ms 10 10 19s912ms 1s991ms 11 10 30s74ms 3s7ms 12 9 18s726ms 2s80ms 13 9 15s975ms 1s775ms 14 10 1m13s 7s330ms 15 11 1m35s 8s690ms 16 11 21s97ms 1s917ms 17 11 17s785ms 1s616ms 18 8 16s629ms 2s78ms 19 8 15s881ms 1s985ms 20 9 26s59ms 2s895ms 21 8 15s746ms 1s968ms 22 8 15s911ms 1s988ms [ User: intelifix - Total duration: 9m46s - Times executed: 214 ]
[ Application: psql - Total duration: 9m46s - Times executed: 214 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 15:26:27 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 14:36:07 Duration: 58s804ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 00:05:24 Duration: 22s322ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 137 13m14s 177ms 3m39s 5s799ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 08 00 1 353ms 353ms 07 11 47s358ms 4s305ms 08 12 1m 5s41ms 09 12 54s269ms 4s522ms 10 12 1m8s 5s717ms 11 13 4m48s 22s161ms 12 13 53s461ms 4s112ms 13 10 15s685ms 1s568ms 14 12 57s859ms 4s821ms 15 11 50s744ms 4s613ms 16 11 41s999ms 3s818ms 17 5 13s628ms 2s725ms 20 2 577ms 288ms 21 6 21s469ms 3s578ms 22 6 19s905ms 3s317ms [ User: intelifix - Total duration: 13m14s - Times executed: 137 ]
[ Application: psql - Total duration: 13m14s - Times executed: 137 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:28:41 Duration: 3m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 07:55:16 Duration: 15s430ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:15:16 Duration: 15s256ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 120 1m54s 156ms 5s487ms 956ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 08 08 18 14s974ms 831ms 09 24 22s2ms 916ms 10 10 8s737ms 873ms 11 5 7s313ms 1s462ms 13 18 18s177ms 1s9ms 14 16 11s417ms 713ms 15 11 8s805ms 800ms 16 13 12s10ms 923ms 17 5 11s308ms 2s261ms [ User: intelifix - Total duration: 1m54s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 120 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0284502) LIMIT 1;
Date: 2026-09-08 09:42:15 Duration: 5s487ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135713) LIMIT 1;
Date: 2026-09-08 17:21:56 Duration: 4s789ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136138) LIMIT 1;
Date: 2026-09-08 16:25:37 Duration: 4s424ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 109 32s162ms 253ms 559ms 295ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 08 07 3 904ms 301ms 08 19 5s938ms 312ms 09 10 2s902ms 290ms 10 13 3s658ms 281ms 11 11 3s285ms 298ms 12 7 1s988ms 284ms 13 6 1s725ms 287ms 14 9 2s739ms 304ms 15 11 3s277ms 297ms 16 13 3s751ms 288ms 17 4 1s206ms 301ms 18 3 783ms 261ms [ User: intelifix - Total duration: 32s162ms - Times executed: 109 ]
[ Application: [unknown] - Total duration: 32s162ms - Times executed: 109 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-08 11:18:42 Duration: 559ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-08 15:17:05 Duration: 394ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-09-08 08:37:58 Duration: 368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 102 20m28s 9s999ms 43s260ms 12s43ms create table temp0000290745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 08 07 13 2m25s 11s200ms 08 19 3m47s 11s991ms 09 6 1m37s 16s226ms 10 12 2m20s 11s681ms 11 10 1m44s 10s420ms 12 18 3m10s 10s580ms 14 12 2m41s 13s460ms 15 6 1m9s 11s621ms 16 6 1m31s 15s251ms [ User: intelifix - Total duration: 20m28s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 20m28s - Times executed: 102 ]
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 09:27:15 Duration: 43s260ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 14:47:03 Duration: 40s55ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 16:30:00 Duration: 37s765ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 101 22s198ms 150ms 1s81ms 219ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 08 07 2 374ms 187ms 08 4 786ms 196ms 09 8 1s720ms 215ms 10 13 2s782ms 214ms 11 36 8s888ms 246ms 12 14 2s750ms 196ms 13 5 1s110ms 222ms 14 7 1s291ms 184ms 15 5 1s164ms 232ms 16 4 734ms 183ms 17 2 347ms 173ms 21 1 247ms 247ms [ User: intelifix - Total duration: 22s198ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 22s198ms - Times executed: 101 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('11804085850050802300');
Date: 2026-09-08 11:45:07 Duration: 1s81ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('48570270AD0C');
Date: 2026-09-08 11:46:48 Duration: 703ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('5039551235B6');
Date: 2026-09-08 11:25:52 Duration: 419ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 99 31s535ms 293ms 469ms 318ms 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 #10
Day Hour Count Duration Avg duration Sep 08 07 10 3s207ms 320ms 08 9 3s180ms 353ms 09 10 3s142ms 314ms 10 10 3s283ms 328ms 11 9 2s834ms 314ms 12 4 1s198ms 299ms 13 10 3s109ms 310ms 14 10 3s107ms 310ms 15 7 2s307ms 329ms 16 7 2s149ms 307ms 17 5 1s565ms 313ms 18 4 1s232ms 308ms 20 1 298ms 298ms 21 2 596ms 298ms 22 1 321ms 321ms [ User: lenon - Total duration: 31s535ms - Times executed: 99 ]
[ Application: [unknown] - Total duration: 31s535ms - Times executed: 99 ]
-
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-08 08:51:26 Duration: 469ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
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-08 15:29:43 Duration: 400ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
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-08 08:35:31 Duration: 396ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 95 36s78ms 164ms 1s71ms 379ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 08 07 7 2s620ms 374ms 08 8 3s337ms 417ms 09 10 3s706ms 370ms 10 10 3s962ms 396ms 11 9 3s767ms 418ms 12 4 1s501ms 375ms 13 10 3s815ms 381ms 14 10 3s606ms 360ms 15 7 2s706ms 386ms 16 8 2s680ms 335ms 17 6 2s215ms 369ms 18 3 1s53ms 351ms 21 2 682ms 341ms 22 1 421ms 421ms [ User: intelifix - Total duration: 36s78ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 36s78ms - Times executed: 95 ]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-09-08 11:25:34 Duration: 1s71ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
select * from rs_menu_grants (414, 21, 1);
Date: 2026-09-08 10:56:37 Duration: 566ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
select * from rs_menu_grants (406, 53, 1);
Date: 2026-09-08 13:04:04 Duration: 562ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 83 10m1s 151ms 49s71ms 7s245ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 08 07 3 623ms 207ms 08 4 983ms 245ms 09 8 3s839ms 479ms 10 11 1m24s 7s654ms 11 18 2m50s 9s444ms 12 1 5s495ms 5s495ms 13 11 1m43s 9s394ms 14 11 2m39s 14s470ms 15 6 40s136ms 6s689ms 16 2 32s11ms 16s5ms 17 8 1s533ms 191ms [ User: intelifix - Total duration: 10m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 10m1s - Times executed: 83 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "243112", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "BAIXA", "data-saida" : "2026-05-21", "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-08 11:51:30 Duration: 49s71ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "229989", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "BAIXA", "data-saida" : "2026-04-10", "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-08 10:39:58 Duration: 41s369ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "103107", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "BAIXA", "data-saida" : "2025-01-03", "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-08 15:04:47 Duration: 38s847ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 82 9m2s 1s58ms 1m3s 6s613ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 08 07 4 12s253ms 3s63ms 08 2 41s765ms 20s882ms 09 7 15s877ms 2s268ms 10 7 1m13s 10s526ms 11 6 1m19s 13s251ms 12 1 1s410ms 1s410ms 13 4 42s739ms 10s684ms 14 4 42s22ms 10s505ms 15 10 1m10s 7s53ms 16 17 1m23s 4s923ms 17 19 1m16s 4s13ms 18 1 2s551ms 2s551ms [ User: intelifix - Total duration: 9m2s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 9m2s - Times executed: 82 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 11:48:49 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 10:02:33 Duration: 38s598ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 13:17:28 Duration: 36s605ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 77 21s324ms 150ms 3s487ms 276ms select * from rs_etiqueta (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 08 07 13 2s512ms 193ms 08 5 1s868ms 373ms 09 10 1s978ms 197ms 10 4 771ms 192ms 11 9 6s455ms 717ms 12 22 4s930ms 224ms 13 5 1s64ms 212ms 14 3 624ms 208ms 15 3 574ms 191ms 16 3 544ms 181ms [ User: etiquetas - Total duration: 21s324ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 21s324ms - Times executed: 77 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-08 11:46:32 Duration: 3s487ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_ETIQUETA ('1834AF2845EB');
Date: 2026-09-08 08:09:51 Duration: 1s132ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_ETIQUETA ('186A81D512C5');
Date: 2026-09-08 11:47:29 Duration: 1s98ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 71 4m49s 157ms 39s875ms 4s75ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 08 07 5 3s185ms 637ms 08 11 1m9s 6s360ms 09 2 602ms 301ms 10 8 42s826ms 5s353ms 11 13 46s172ms 3s551ms 12 8 2s578ms 322ms 13 7 1s546ms 220ms 14 8 31s479ms 3s934ms 15 2 1s415ms 707ms 16 4 23s209ms 5s802ms 17 1 23s92ms 23s92ms 18 2 43s309ms 21s654ms [ User: intelifix - Total duration: 4m49s - Times executed: 71 ]
[ Application: psql - Total duration: 4m49s - Times executed: 71 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029490);
Date: 2026-09-08 08:51:17 Duration: 39s875ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029519);
Date: 2026-09-08 11:33:52 Duration: 31s264ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029600);
Date: 2026-09-08 18:06:34 Duration: 28s294ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 69 9m29s 513ms 1m1s 8s255ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 08 07 2 1m4s 32s392ms 08 6 1m11s 11s891ms 09 1 16s418ms 16s418ms 10 7 1m21s 11s713ms 11 14 1m32s 6s605ms 12 7 23s626ms 3s375ms 13 7 41s679ms 5s954ms 14 8 1m5s 8s214ms 15 9 36s112ms 4s12ms 16 6 53s224ms 8s870ms 18 2 22s247ms 11s123ms [ User: intelifix - Total duration: 9m29s - Times executed: 69 ]
[ Application: psql - Total duration: 9m29s - Times executed: 69 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029478);
Date: 2026-09-08 07:15:36 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029500);
Date: 2026-09-08 10:44:05 Duration: 43s273ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029493);
Date: 2026-09-08 08:58:19 Duration: 33s31ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 66 17s344ms 162ms 1s511ms 262ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 08 07 1 211ms 211ms 09 1 1s167ms 1s167ms 10 35 6s984ms 199ms 11 12 4s624ms 385ms 12 1 282ms 282ms 13 4 920ms 230ms 14 8 1s685ms 210ms 15 3 1s263ms 421ms 16 1 203ms 203ms [ User: intelifix - Total duration: 17s344ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 17s344ms - Times executed: 66 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (284506);
Date: 2026-09-08 11:25:26 Duration: 1s511ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (135616);
Date: 2026-09-08 09:13:15 Duration: 1s167ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0285154);
Date: 2026-09-08 11:45:55 Duration: 476ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 61 12m 10s340ms 35s229ms 11s813ms create table temp0000290841 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 08 13 19 3m53s 12s290ms 14 11 1m57s 10s724ms 15 28 5m35s 11s994ms 16 3 33s253ms 11s84ms [ User: intelifix - Total duration: 12m - Times executed: 61 ]
[ Application: [unknown] - Total duration: 12m - Times executed: 61 ]
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 15:18:23 Duration: 35s229ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 13:21:10 Duration: 34s983ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 15:35:33 Duration: 12s466ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 61 28s38ms 159ms 1s550ms 459ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 08 08 2 499ms 249ms 09 14 6s357ms 454ms 10 25 13s499ms 539ms 11 8 4s108ms 513ms 12 1 191ms 191ms 14 9 3s11ms 334ms 15 2 371ms 185ms [ User: intelifix - Total duration: 28s38ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 28s38ms - Times executed: 61 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '5872C99514E5,14CA56CD45FD,D89A0DA49FA7,D831399344D2,48D682305CDA,D89A0DA686B5,3CF9F0AADA4E,48D682388882,F4E84F889F88,C4EBFF8BEC3C,4896D957C032,48D682305FCE,689E29FC2CD9,843C99331523,689E29BCBCDD,48D682387A3C,F4E84F8683A6,14CA56D4C68D,D89A0DA45285,5872C98AC5D5,843C9932C591,C4EBFF8BF344,843C99329843,3CF9F0AA5750,14CA56D05E93,C4EBFF8C341E,843C99330DC1,48D682338182,F4E84F896E6A,D89A0DACF55B,D89A0DA44F7F,D89A0D84DFFB,14CA56D67A0B,5872C994CBD1,6C11BA6E57C7,D89A0D858489,4896D9557684,D89A0DA4AB11,3CF9F0A93A08,D8313993061A,843C9932CA4D', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-08 10:13:27 Duration: 1s550ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '389148516B71,48D682321D30,D831399039FE,843C992F568B,3891484A8B1F,843C992FA3F5,D89A0DACCCE7,D89A0DA490D1,D89A0DAA256D,3CF9F0AE54B2,3CF9F0A2B2F6,6C11BA654E25,5872C9935C6F,843C99216D2B,843C992C6933,D831391E5DAE,48D682387A0C,F4E84F81DB74,48D682306D54,843C992C7B15,5872C98D720B,689E29FC2E9B,C4EBFF8C2C7A,3CF9F0AC05A0,C4EBFF89B9D4,3CF9F0A95934,14CA56CD4951,D89A0DA486B7,F4E84F86967E,843C992E06EB,F4E84F81D5F8,5872C98B5A43,6C11BA6587C1,D83139A03172,48D68232304A,4896D957F76A,D89A0DA983E5,4896D9557162,C4EBFF8ED9DC', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-08 09:55:41 Duration: 1s187ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_BAIXA_EXECUTA (430, 5, 2, 28, '229935310421,229997243030,229928937878,229957928788,229936241735,229934917171,229994083642,229949332036,229947196271,229949416566,229931900627,229955451724,229921295876,229963964047,229927385359,229936931735,229998063548,229930843441,230005053557,229945551925,229997621732,229937829813,229930392533,229938914150,229948390317,229931006767,229998066376,229994518588,229997531016,229985648093,229957227575,229960482630,230002684863,230016980928,229907593742,229929245361,229926349613,229997644057,229945016384,229994751620,229926131231', '','DEFAULT',00,0287,'', '','', 00);
Date: 2026-09-08 11:32:44 Duration: 1s101ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 60 2m14s 1s606ms 5s160ms 2s239ms create table temp0000290745 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 08 08 9 15s807ms 1s756ms 09 6 10s914ms 1s819ms 10 10 23s907ms 2s390ms 11 2 4s259ms 2s129ms 12 16 34s673ms 2s167ms 14 4 11s696ms 2s924ms 15 11 28s320ms 2s574ms 16 2 4s772ms 2s386ms [ User: intelifix - Total duration: 2m14s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 60 ]
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 10:20:30 Duration: 5s160ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 14:55:37 Duration: 4s503ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 15:28:13 Duration: 2s738ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m58s 11m5s 6m58s 3 20m54s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 08 05 3 20m54s 6m58s [ User: intelifix - Total duration: 20m54s - Times executed: 3 ]
[ Application: psql - Total duration: 20m54s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-08 05:11:07 Duration: 11m5s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-09-08 05:17:57 Duration: 6m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-09-08 05:20:56 Duration: 2m58s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 1s340ms 10m32s 2m2s 48 1h38m16s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 08 07 3 11m23s 3m47s 08 3 5m54s 1m58s 09 3 6m44s 2m14s 10 3 5m48s 1m56s 11 3 5m44s 1m54s 12 3 5m48s 1m56s 13 3 5m35s 1m51s 14 3 5m58s 1m59s 15 3 6m34s 2m11s 16 3 6m10s 2m3s 17 3 5m52s 1m57s 18 3 5m33s 1m51s 19 3 5m4s 1m41s 20 3 5m37s 1m52s 21 3 5m28s 1m49s 22 3 4m57s 1m39s [ User: intelifix - Total duration: 1h38m16s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m16s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-08 07:15:34 Duration: 10m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-08 15:11:13 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-08 09:10:55 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 295ms 4m21s 1m33s 48 1h14m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 08 07 3 6m14s 2m4s 08 3 4m30s 1m30s 09 3 5m56s 1m58s 10 3 4m14s 1m24s 11 3 4m9s 1m23s 12 3 4m51s 1m37s 13 3 4m39s 1m33s 14 3 4m52s 1m37s 15 3 5m11s 1m43s 16 3 4m44s 1m34s 17 3 4m45s 1m35s 18 3 4m8s 1m22s 19 3 4m 1m20s 20 3 4m14s 1m24s 21 3 3m54s 1m18s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h14m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h14m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-08 07:22:27 Duration: 4m21s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-08 09:17:30 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-08 15:16:43 Duration: 3m56s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 153ms 7m11s 29s41ms 238 1h55m11s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 08 07 7 13m5s 1m52s 08 27 14m10s 31s495ms 09 30 13m26s 26s867ms 10 31 17m12s 33s318ms 11 21 18m4s 51s648ms 12 9 5m45s 38s379ms 13 21 1m7s 3s232ms 14 24 14m46s 36s928ms 15 23 7m17s 19s16ms 16 29 5m23s 11s140ms 17 13 3m 13s853ms 18 3 1m52s 37s477ms [ User: intelifix - Total duration: 1h55m11s - Times executed: 238 ]
[ Application: [unknown] - Total duration: 1h55m11s - Times executed: 238 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029478, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 07:22:17 Duration: 7m11s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029525, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 11:52:41 Duration: 6m55s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029493, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-08 09:04:57 Duration: 6m38s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 10s250ms 53s452ms 13s161ms 21 4m36s create table temp0000290805 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 08 10 8 1m34s 11s846ms 11 13 3m1s 13s971ms [ User: intelifix - Total duration: 4m36s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m36s - Times executed: 21 ]
-
CREATE TABLE temp0000290805 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 11:26:44 Duration: 53s452ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290805 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 10:13:25 Duration: 14s546ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290805 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 10:28:51 Duration: 13s178ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 9s999ms 43s260ms 12s43ms 102 20m28s create table temp0000290745 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 08 07 13 2m25s 11s200ms 08 19 3m47s 11s991ms 09 6 1m37s 16s226ms 10 12 2m20s 11s681ms 11 10 1m44s 10s420ms 12 18 3m10s 10s580ms 14 12 2m41s 13s460ms 15 6 1m9s 11s621ms 16 6 1m31s 15s251ms [ User: intelifix - Total duration: 20m28s - Times executed: 102 ]
[ Application: [unknown] - Total duration: 20m28s - Times executed: 102 ]
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 09:27:15 Duration: 43s260ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 14:47:03 Duration: 40s55ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 16:30:00 Duration: 37s765ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 10s340ms 35s229ms 11s813ms 61 12m create table temp0000290841 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 08 13 19 3m53s 12s290ms 14 11 1m57s 10s724ms 15 28 5m35s 11s994ms 16 3 33s253ms 11s84ms [ User: intelifix - Total duration: 12m - Times executed: 61 ]
[ Application: [unknown] - Total duration: 12m - Times executed: 61 ]
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 15:18:23 Duration: 35s229ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 13:21:10 Duration: 34s983ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 15:35:33 Duration: 12s466ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 10s160ms 24s924ms 11s790ms 15 2m56s create table temp0000290877 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 08 16 5 55s46ms 11s9ms 17 4 57s800ms 14s450ms 18 6 1m4s 10s668ms [ User: intelifix - Total duration: 2m56s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m56s - Times executed: 15 ]
-
CREATE TABLE temp0000290877 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 17:20:46 Duration: 24s924ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290877 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 18:01:25 Duration: 11s644ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290877 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 16:39:15 Duration: 11s629ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 10s224ms 38s287ms 11s452ms 40 7m38s create table temp0000290791 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 08 10 7 1m18s 11s237ms 11 21 4m9s 11s883ms 12 12 2m9s 10s822ms [ User: intelifix - Total duration: 7m38s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 7m38s - Times executed: 40 ]
-
CREATE TABLE temp0000290791 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 11:53:18 Duration: 38s287ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290791 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 10:43:13 Duration: 12s450ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290791 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-08 12:15:03 Duration: 11s640ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 513ms 1m1s 8s255ms 69 9m29s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 08 07 2 1m4s 32s392ms 08 6 1m11s 11s891ms 09 1 16s418ms 16s418ms 10 7 1m21s 11s713ms 11 14 1m32s 6s605ms 12 7 23s626ms 3s375ms 13 7 41s679ms 5s954ms 14 8 1m5s 8s214ms 15 9 36s112ms 4s12ms 16 6 53s224ms 8s870ms 18 2 22s247ms 11s123ms [ User: intelifix - Total duration: 9m29s - Times executed: 69 ]
[ Application: psql - Total duration: 9m29s - Times executed: 69 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029478);
Date: 2026-09-08 07:15:36 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029500);
Date: 2026-09-08 10:44:05 Duration: 43s273ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029493);
Date: 2026-09-08 08:58:19 Duration: 33s31ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 151ms 49s71ms 7s245ms 83 10m1s select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 08 07 3 623ms 207ms 08 4 983ms 245ms 09 8 3s839ms 479ms 10 11 1m24s 7s654ms 11 18 2m50s 9s444ms 12 1 5s495ms 5s495ms 13 11 1m43s 9s394ms 14 11 2m39s 14s470ms 15 6 40s136ms 6s689ms 16 2 32s11ms 16s5ms 17 8 1s533ms 191ms [ User: intelifix - Total duration: 10m1s - Times executed: 83 ]
[ Application: [unknown] - Total duration: 10m1s - Times executed: 83 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "243112", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "BAIXA", "data-saida" : "2026-05-21", "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-08 11:51:30 Duration: 49s71ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "229989", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "BAIXA", "data-saida" : "2026-04-10", "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-08 10:39:58 Duration: 41s369ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "103107", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "BAIXA", "data-saida" : "2025-01-03", "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-08 15:04:47 Duration: 38s847ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 186ms 39s985ms 6s937ms 31 3m35s create table temp0000290230 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 08 10 9 49s576ms 5s508ms 11 10 1m12s 7s233ms 12 1 6s348ms 6s348ms 13 8 49s115ms 6s139ms 15 2 1s52ms 526ms 16 1 36s618ms 36s618ms [ User: intelifix - Total duration: 3m35s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 31 ]
-
CREATE TABLE temp0000290230 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "229989 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 10:31:06 Duration: 39s985ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290230 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "204252 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 16:45:21 Duration: 36s618ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290230 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "243112 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 11:50:13 Duration: 33s718ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 1s58ms 1m3s 6s613ms 82 9m2s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 08 07 4 12s253ms 3s63ms 08 2 41s765ms 20s882ms 09 7 15s877ms 2s268ms 10 7 1m13s 10s526ms 11 6 1m19s 13s251ms 12 1 1s410ms 1s410ms 13 4 42s739ms 10s684ms 14 4 42s22ms 10s505ms 15 10 1m10s 7s53ms 16 17 1m23s 4s923ms 17 19 1m16s 4s13ms 18 1 2s551ms 2s551ms [ User: intelifix - Total duration: 9m2s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 9m2s - Times executed: 82 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 11:48:49 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 10:02:33 Duration: 38s598ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-08', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-08 13:17:28 Duration: 36s605ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 168ms 29s595ms 6s506ms 23 2m29s create table temp0000290026 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 08 08 1 27s275ms 27s275ms 10 6 20s201ms 3s366ms 11 2 23s305ms 11s652ms 13 7 49s66ms 7s9ms 15 6 27s128ms 4s521ms 16 1 2s668ms 2s668ms [ User: intelifix - Total duration: 2m29s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 2m29s - Times executed: 23 ]
-
CREATE TABLE temp0000290026 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "241493 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 13:16:00 Duration: 29s595ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290026 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 08:06:48 Duration: 27s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290026 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "103107 ", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "03-09-2026", "data-ate" : "08-09-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-09-08 15:02:48 Duration: 24s689ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 177ms 3m39s 5s799ms 137 13m14s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 08 00 1 353ms 353ms 07 11 47s358ms 4s305ms 08 12 1m 5s41ms 09 12 54s269ms 4s522ms 10 12 1m8s 5s717ms 11 13 4m48s 22s161ms 12 13 53s461ms 4s112ms 13 10 15s685ms 1s568ms 14 12 57s859ms 4s821ms 15 11 50s744ms 4s613ms 16 11 41s999ms 3s818ms 17 5 13s628ms 2s725ms 20 2 577ms 288ms 21 6 21s469ms 3s578ms 22 6 19s905ms 3s317ms [ User: intelifix - Total duration: 13m14s - Times executed: 137 ]
[ Application: psql - Total duration: 13m14s - Times executed: 137 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:28:41 Duration: 3m39s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 07:55:16 Duration: 15s430ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-08 11:15:16 Duration: 15s256ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 157ms 39s875ms 4s75ms 71 4m49s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 08 07 5 3s185ms 637ms 08 11 1m9s 6s360ms 09 2 602ms 301ms 10 8 42s826ms 5s353ms 11 13 46s172ms 3s551ms 12 8 2s578ms 322ms 13 7 1s546ms 220ms 14 8 31s479ms 3s934ms 15 2 1s415ms 707ms 16 4 23s209ms 5s802ms 17 1 23s92ms 23s92ms 18 2 43s309ms 21s654ms [ User: intelifix - Total duration: 4m49s - Times executed: 71 ]
[ Application: psql - Total duration: 4m49s - Times executed: 71 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029490);
Date: 2026-09-08 08:51:17 Duration: 39s875ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029519);
Date: 2026-09-08 11:33:52 Duration: 31s264ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029600);
Date: 2026-09-08 18:06:34 Duration: 28s294ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 2s109ms 20s981ms 3s391ms 49 2m46s create table temp0000290841 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 08 13 15 52s725ms 3s515ms 14 10 37s381ms 3s738ms 15 22 1m8s 3s101ms 16 2 7s855ms 3s927ms [ User: intelifix - Total duration: 2m46s - Times executed: 49 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 49 ]
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 13:19:32 Duration: 20s981ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 14:13:37 Duration: 16s603ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290841 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 15:19:23 Duration: 14s971ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 150ms 1m20s 2s738ms 214 9m46s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 08 00 9 41s213ms 4s579ms 01 7 15s731ms 2s247ms 02 10 16s165ms 1s616ms 03 9 16s610ms 1s845ms 04 10 16s37ms 1s603ms 05 7 15s599ms 2s228ms 06 11 16s903ms 1s536ms 07 8 19s641ms 2s455ms 08 11 24s744ms 2s249ms 09 10 20s731ms 2s73ms 10 10 19s912ms 1s991ms 11 10 30s74ms 3s7ms 12 9 18s726ms 2s80ms 13 9 15s975ms 1s775ms 14 10 1m13s 7s330ms 15 11 1m35s 8s690ms 16 11 21s97ms 1s917ms 17 11 17s785ms 1s616ms 18 8 16s629ms 2s78ms 19 8 15s881ms 1s985ms 20 9 26s59ms 2s895ms 21 8 15s746ms 1s968ms 22 8 15s911ms 1s988ms [ User: intelifix - Total duration: 9m46s - Times executed: 214 ]
[ Application: psql - Total duration: 9m46s - Times executed: 214 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 15:26:27 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 14:36:07 Duration: 58s804ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-08 00:05:24 Duration: 22s322ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 1s606ms 5s160ms 2s239ms 60 2m14s create table temp0000290745 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 08 08 9 15s807ms 1s756ms 09 6 10s914ms 1s819ms 10 10 23s907ms 2s390ms 11 2 4s259ms 2s129ms 12 16 34s673ms 2s167ms 14 4 11s696ms 2s924ms 15 11 28s320ms 2s574ms 16 2 4s772ms 2s386ms [ User: intelifix - Total duration: 2m14s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 60 ]
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 10:20:30 Duration: 5s160ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 14:55:37 Duration: 4s503ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000290745 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-09-2026", "ate" :"08-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-08 15:28:13 Duration: 2s738ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 156ms 5s487ms 956ms 120 1m54s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 08 08 18 14s974ms 831ms 09 24 22s2ms 916ms 10 10 8s737ms 873ms 11 5 7s313ms 1s462ms 13 18 18s177ms 1s9ms 14 16 11s417ms 713ms 15 11 8s805ms 800ms 16 13 12s10ms 923ms 17 5 11s308ms 2s261ms [ User: intelifix - Total duration: 1m54s - Times executed: 120 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 120 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0284502) LIMIT 1;
Date: 2026-09-08 09:42:15 Duration: 5s487ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0135713) LIMIT 1;
Date: 2026-09-08 17:21:56 Duration: 4s789ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136138) LIMIT 1;
Date: 2026-09-08 16:25:37 Duration: 4s424ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 385ms 2 189ms 196ms 192ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 08 20 1 189ms 189ms 23 1 196ms 196ms [ User: etiquetas - Total duration: 819ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 819ms - Times executed: 2 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-07 23:48:41 Duration: 196ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
-
select * from rs_caixa_qr ();
Date: 2026-09-07 20:29:18 Duration: 189ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 16 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 07 08 1 0ms 0ms 10 2 0ms 0ms 11 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 21 2 0ms 0ms 22 2 0ms 0ms Sep 08 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 3m49s - Times executed: 16 ]
[ Application: psql - Total duration: 3m48s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 376ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,307 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 4217 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,177 Max number of times the same event was reported
- 4,245 Total events found
Rank Times reported Error 1 4,177 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 08 00 59 01 60 02 60 03 59 04 60 05 59 06 60 07 191 08 320 09 335 10 387 11 386 12 361 13 282 14 393 15 352 16 270 17 136 18 59 19 59 20 60 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN00000000297D9F20" does not exist
- ERROR: prepared statement "_PLAN00000000297D9F20" does not exist
- ERROR: prepared statement "_PLAN0000000029963E70" does not exist
Statement: DEALLOCATE "_PLAN00000000297D9F20"
Date: 2026-09-08 00:00:48 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: DEALLOCATE "_PLAN00000000297D9F20"
Date: 2026-09-08 00:01:48 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: DEALLOCATE "_PLAN0000000029963E70"
Date: 2026-09-08 00:02:48 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 13 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 08 08 1 09 1 11 8 12 1 13 2 - ERROR: syntax error at or near "diagnostics" at character 42
- ERROR: syntax error at or near "ZTEGDB158357" at character 32
- ERROR: syntax error at or near "1" at character 95
Statement: select * from rs_caixa_qr(SeagullMessage diagnostics:)
Date: 2026-09-08 08:56:36 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT RS_SERIAL_TEMPORARIO( ''ZTEGDB158357' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''ZTEGDB158357' )
Date: 2026-09-08 09:14:27 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'1","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-09-08 11:36:59 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 11 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 08 00 1 02 2 05 1 06 3 09 1 13 1 16 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-08 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-09-08 02:12:20 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-09-08 02:20:22 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 9 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 08 08 3 10 4 11 2 - ERROR: column "d1g" does not exist at character 27
- ERROR: column "d1g" does not exist at character 27
- ERROR: column "d1g" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(D1G)
Date: 2026-09-08 08:43:50 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_ETIQUETA(D1G)
Date: 2026-09-08 08:43:50 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_ETIQUETA(D1G)
Date: 2026-09-08 08:43:51 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 08 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-08 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-09-08 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-09-08 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 7 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 08 11 2 14 2 15 3 - LOG: process 52160 still waiting for ShareLock on transaction 5729941 after 1000.084 ms
- LOG: process 52160 still waiting for ShareLock on transaction 5729941 after 60148.342 ms
- LOG: process 783090 still waiting for ShareLock on transaction 5742151 after 1000.080 ms
Detail: Process holding the lock: 38061. Wait queue: 52160.
Context: while updating tuple (78561,32) 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,integer) line 128 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-09-08 11:25:42 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 38061. Wait queue: 52160.
Context: while updating tuple (78561,32) 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,integer) line 128 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-09-08 11:26:41 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 777886. Wait queue: 783090.
Context: while updating tuple (79077,2) 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-08 14:35:12 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 08 05 4 11 1 12 1 - 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-08 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-08 05:32:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-08 05:32:07 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 3 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 08 10 3 - ERROR: invalid input syntax for type integer: ""
- ERROR: invalid input syntax for type integer: ""
- ERROR: invalid input syntax for type integer: ""
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"CLARO_B0CAC9","barra2":"","barra3":"","lote":""}');Date: 2026-09-08 10:19:26 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"CLARO_B0CAC9","barra2":"","barra3":"","lote":""}');Date: 2026-09-08 10:19:26 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"CLARO_B0CAC9","barra2":"","barra3":"","lote":""}');Date: 2026-09-08 10:19:48 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 2 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 08 12 2 - ERROR: canceling statement due to user request
- ERROR: canceling statement due to user request
Statement: UPDATE LOTE_ITENS SET FLU_ID = 6257281; DELETE FROM EQUIP_DEFEITOS WHERE FLU_ID= 6263508; DELETE FROM FLUXOS WHERE FLU_ID= 6263508;
Date: 2026-09-08 12:17:02 Database: rio Application: pgAdmin 4 - CONN:4227973 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: UPDATE LOTE_ITENS SET FLU_ID = 6257281;
Date: 2026-09-08 12:17:15 Database: rio Application: pgAdmin 4 - CONN:4227973 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 08 09 1 11 1 - ERROR: unterminated quoted string at or near "'22222222222'');" at character 39
- ERROR: unterminated quoted string at or near "'229948278587'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('22222222222'');
Date: 2026-09-08 09:22:53 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229948278587'');
Date: 2026-09-08 11:26:21 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 08 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-08 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-09-08 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 08 14 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(11111111111111111111111111111111111111111111111111111135436)Date: 2026-09-08 14:21:08 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(11111111111111111111111111111111111111111111111111111135436)Date: 2026-09-08 14:21:08 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 1 ERROR: cannot open relation "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 08 11 1 - ERROR: cannot open relation "lote_trans_itens" at character 15
Detail: This operation is not supported for indexes.
Statement: select * from lote_trans_itens where flu_id= 6284731Date: 2026-09-08 11:19:31 Database: rio Application: pgAdmin 4 - CONN:4629397 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 1 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 08 11 1 - ERROR: update or delete on table "fluxos" violates foreign key constraint "lote_itens_flu_id_fkey" on table "lote_itens"
Detail: Key (flu_id)=(6284731) is still referenced from table "lote_itens".
Statement: DELETE FROM EQUIP_DEFEITOS WHERE FLU_ID= 6284731; DELETE FROM FLUXO_PASSOS WHERE FLU_ID=6284731; DELETE FROM FLUXOS WHERE FLU_ID= 6284731Date: 2026-09-08 11:43:12 Database: rio Application: pgAdmin 4 - CONN:4227973 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 1 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 08 12 1 - ERROR: missing FROM-clause entry for table "a" at character 66
Statement: SELECT Y.*,B.FLU_DATA FROM Y INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID ORDER BY B.FLU_DATA
Date: 2026-09-08 12:11:09 Database: rio Application: pgAdmin 4 - CONN:4227973 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 08 03 1 - LOG: database system was shut down at 2026-09-08 03:05:02 -03
Date: 2026-09-08 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-08.log