pgBadger-
Global information
- Generated on Sat Aug 22 23:50:18 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 44,388 log entries in 15s
- Log start from 2026-08-21 00:00:19 to 2026-08-21 23:16:01
-
Overview
Global Stats
- 314 Number of unique normalized queries
- 6,570 Number of queries
- 8h17m38s Total query duration
- 2026-08-21 00:02:27 First query
- 2026-08-21 22:16:04 Last query
- 5 queries/s at 2026-08-21 13:55:09 Query peak
- 8h17m38s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h17m38s Execute total duration
- 4,062 Number of events
- 21 Number of unique normalized events
- 3,924 Max number of times the same event was reported
- 0 Number of cancellation
- 576 Total number of automatic vacuums
- 1,064 Total number of automatic analyzes
- 14 Number temporary file
- 242.09 MiB Max size of temporary file
- 103.58 MiB Average size of temporary file
- 357 Total number of sessions
- 13 sessions at 2026-08-21 08:20:38 Session peak
- 12d19h13m33s Total duration of sessions
- 51m38s Average duration of sessions
- 18 Average queries per session
- 1m23s Average queries duration per session
- 50m14s Average idle time per session
- 368 Total number of connections
- 10 connections/s at 2026-08-21 08:20:29 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-21 13:55:09 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-21 14:12:42 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-21 20:08:29 Date
Queries duration
Key values
- 8h17m38s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 21 00 27 0ms 25s566ms 5s553ms 6s231ms 22s423ms 1m5s 01 20 0ms 3s884ms 1s666ms 4s711ms 5s277ms 7s90ms 02 18 0ms 3s856ms 1s884ms 4s676ms 6s56ms 6s754ms 03 20 0ms 12s269ms 2s457ms 5s853ms 7s46ms 14s815ms 04 20 0ms 3s984ms 1s752ms 5s192ms 5s409ms 6s954ms 05 20 0ms 10m36s 1m7s 9s18ms 2m41s 10m36s 06 25 0ms 23s482ms 3s706ms 4s34ms 5s115ms 37s710ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 443 151ms 7m12s 3s230ms 55s831ms 1m8s 10m1s 09 601 150ms 8m36s 5s96ms 1m22s 6m40s 8m38s 10 799 150ms 7m42s 3s293ms 1m16s 5m58s 8m13s 11 872 150ms 9m31s 3s303ms 1m13s 6m19s 9m37s 12 182 0ms 7m6s 8s190ms 46s597ms 4m11s 7m50s 13 690 0ms 6m13s 2s842ms 1m1s 1m45s 6m58s 14 932 150ms 10m28s 3s269ms 1m18s 5m47s 11m12s 15 976 150ms 8m52s 4s586ms 4m43s 6m44s 10m23s 16 517 0ms 10m20s 4s64ms 56s70ms 4m57s 10m38s 17 171 0ms 7m20s 5s604ms 10s969ms 1m14s 7m22s 18 24 0ms 5m53s 26s812ms 7s394ms 49s811ms 5m53s 19 24 0ms 6m6s 28s368ms 5s68ms 8s601ms 6m58s 20 138 0ms 6m40s 9s293ms 56s856ms 1m52s 6m40s 21 36 0ms 6m23s 21s669ms 8s771ms 1m2s 6m23s 22 15 0ms 6m23s 45s695ms 6s954ms 54s199ms 6m23s 23 0 0ms 0ms 0ms 0ms 0ms 0ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 21 00 6 0 5s367ms 0ms 0ms 374ms 01 2 0 201ms 0ms 0ms 199ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 326ms 0ms 0ms 194ms 04 2 0 231ms 0ms 0ms 214ms 05 0 0 0ms 0ms 0ms 0ms 06 9 0 3s807ms 0ms 0ms 3s826ms 07 0 0 0ms 0ms 0ms 0ms 08 304 0 2s527ms 13s193ms 35s82ms 7m18s 09 462 0 5s587ms 25s742ms 1m3s 7m5s 10 606 0 3s529ms 17s903ms 1m16s 6m37s 11 650 0 3s869ms 27s884ms 55s750ms 7m4s 12 115 0 10s296ms 4s628ms 12s419ms 5m31s 13 481 0 2s689ms 19s350ms 32s540ms 3m35s 14 655 0 3s341ms 19s232ms 47s499ms 7m18s 15 731 0 4s672ms 44s737ms 4m42s 6m51s 16 375 0 4s977ms 23s889ms 49s548ms 5m33s 17 108 0 8s104ms 3s763ms 5s991ms 4m3s 18 7 0 1m25s 0ms 0ms 3m12s 19 6 0 1m45s 0ms 0ms 3m34s 20 27 91 10s360ms 23s686ms 55s20ms 3m24s 21 11 0 1m4s 0ms 246ms 4m23s 22 7 0 1m34s 0ms 0ms 6m23s 23 0 0 0ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 21 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 21 00 0 2 2.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 0 0.00 0.00% 06 0 2 2.00 0.00% 07 0 0 0.00 0.00% 08 0 16 16.00 0.00% 09 0 17 17.00 0.00% 10 0 17 17.00 0.00% 11 0 22 22.00 0.00% 12 0 7 7.00 0.00% 13 0 20 20.00 0.00% 14 0 15 15.00 0.00% 15 0 24 24.00 0.00% 16 0 13 13.00 0.00% 17 0 4 4.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Aug 21 00 15 0.00/s 01 10 0.00/s 02 10 0.00/s 03 17 0.00/s 04 10 0.00/s 05 8 0.00/s 06 15 0.00/s 07 0 0.00/s 08 28 0.01/s 09 21 0.01/s 10 31 0.01/s 11 32 0.01/s 12 12 0.00/s 13 24 0.01/s 14 22 0.01/s 15 24 0.01/s 16 23 0.01/s 17 12 0.00/s 18 10 0.00/s 19 10 0.00/s 20 15 0.00/s 21 10 0.00/s 22 9 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Aug 21 00 8 1h22s 1h4s 01 14 1h48s 1h46s 02 9 1h 59m56s 03 20 22m9s 22m7s 04 7 1h3m 1h2m55s 05 8 1h48s 57m59s 06 8 56m52s 56m41s 07 11 1h49s 1h49s 08 7 10m3s 6m38s 09 24 58m29s 56m21s 10 27 39m24s 37m47s 11 29 49m23s 47m44s 12 21 57m4s 55m53s 13 14 54m14s 51m54s 14 22 55m59s 53m41s 15 25 50m54s 47m55s 16 23 48m35s 47m4s 17 19 57m29s 56m38s 18 12 55m59s 55m6s 19 9 1h3s 58m47s 20 13 47m21s 45m42s 21 11 56m38s 55m27s 22 11 1h51s 59m49s 23 5 1h 1h -
Connections
Established Connections
Key values
- 10 connections Connection Peak
- 2026-08-21 08:20:29 Date
Connections per database
Key values
- rio Main Database
- 368 connections Total
Connections per user
Key values
- intelifix Main User
- 368 connections Total
-
Sessions
Simultaneous sessions
Key values
- 13 sessions Session Peak
- 2026-08-21 08:20:38 Date
Histogram of session times
Key values
- 272 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 357 sessions Total
Sessions per user
Key values
- intelifix Main User
- 357 sessions Total
Sessions per host
Key values
- [local] Main Host
- 357 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 357 sessions Total
Application Count Total Duration Average Duration [unknown] 330 12d3h47s 52m54s pgAdmin 4 - CONN:2817541 2 19s226ms 9s613ms pgAdmin 4 - CONN:4534880 2 4s747ms 2s373ms pgAdmin 4 - DB:brasilia 1 25s93ms 25s93ms pgAdmin 4 - DB:postgres 1 42s497ms 42s497ms pgAdmin 4 - DB:rio 1 10s153ms 10s153ms pg_dump 3 8m57s 2m59s postgres_fdw 1 34m59s 34m59s psql 16 15h27m7s 57m56s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 61,815 buffers Checkpoint Peak
- 2026-08-21 00:09:49 Date
- 270.043 seconds Highest write time
- 0.627 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-08-21 10:09:47 Date
Checkpoints distance
Key values
- 405.55 Mo Distance Peak
- 2026-08-21 10:09:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 21 00 75,591 672.263s 0.035s 672.368s 01 2,113 212.404s 0.032s 212.493s 02 2,106 211.456s 0.032s 211.528s 03 2,157 216.553s 0.036s 216.649s 04 2,320 233.282s 0.036s 233.371s 05 8,958 877.232s 0.111s 877.401s 06 5,463 269.856s 0.004s 269.867s 07 0 0s 0s 0s 08 66,319 1,795.398s 0.679s 1,796.288s 09 93,478 3,238.24s 1.186s 3,239.706s 10 81,639 3,237.887s 1.47s 3,239.696s 11 76,018 3,237.649s 1.588s 3,239.589s 12 31,021 2,045.778s 0.383s 2,046.347s 13 41,300 2,523.852s 1.597s 2,525.727s 14 65,436 3,237.143s 1.932s 3,239.41s 15 82,841 3,236.837s 2.371s 3,239.641s 16 56,296 3,167.916s 1.351s 3,169.542s 17 18,002 1,594.113s 0.428s 1,594.663s 18 708 71.136s 0.133s 71.355s 19 35 3.537s 0.042s 3.602s 20 1,596 188.398s 0.072s 188.542s 21 2,968 298.257s 0.178s 298.572s 22 689 69.247s 0.023s 69.293s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 21 00 0 0 11 482 0.002s 0.01s 01 0 0 0 441 0.002s 0.014s 02 0 0 1 433 0.003s 0.008s 03 0 0 1 414 0.002s 0.009s 04 0 0 0 457 0.002s 0.01s 05 0 0 5 531 0.023s 0.008s 06 0 0 0 11 0.002s 0.001s 07 0 0 0 0 0s 0s 08 0 0 33 4,363 0.154s 0.01s 09 0 0 53 7,182 0.035s 0.012s 10 0 0 48 8,391 0.034s 0.012s 11 0 0 37 7,847 0.068s 0.012s 12 0 0 20 2,775 0.031s 0.011s 13 0 0 42 5,953 0.042s 0.012s 14 0 0 62 7,990 0.062s 0.012s 15 0 0 69 8,072 0.049s 0.012s 16 0 0 28 5,608 0.065s 0.012s 17 0 0 7 3,097 0.055s 0.01s 18 0 0 0 165 0.049s 0.028s 19 0 0 0 7 0.024s 0.013s 20 0 0 1 93 0.013s 0.004s 21 0 0 1 507 0.095s 0.104s 22 0 0 0 143 0.007s 0.003s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Aug 21 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 21 00 22,088.62 kB 72,600.00 kB 01 1,097.10 kB 35,790.80 kB 02 1,585.14 kB 14,954.43 kB 03 1,336.33 kB 2,865.56 kB 04 1,477.33 kB 2,309.00 kB 05 8,997.88 kB 15,409.75 kB 06 9,431.00 kB 15,349.00 kB 07 0.00 kB 0.00 kB 08 65,674.00 kB 83,573.50 kB 09 72,372.58 kB 134,406.42 kB 10 65,843.08 kB 147,578.67 kB 11 50,397.17 kB 90,135.83 kB 12 30,839.82 kB 81,999.45 kB 13 57,058.92 kB 77,074.42 kB 14 84,116.75 kB 146,491.08 kB 15 94,170.42 kB 158,873.50 kB 16 38,716.75 kB 88,369.83 kB 17 11,715.50 kB 43,708.50 kB 18 418.50 kB 21,017.67 kB 19 109.00 kB 13,638.00 kB 20 5,131.67 kB 11,736.33 kB 21 1,748.12 kB 7,356.88 kB 22 1,193.33 kB 4,954.67 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 484.19 MiB Temp Files size Peak
- 2026-08-21 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-21 05:32:06 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 21 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.21 GiB 103.51 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 1 104.00 MiB 104.00 MiB 15 1 104.00 MiB 104.00 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 940.34 MiB 72.21 MiB 242.09 MiB 117.54 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-21 05:32:08 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-21 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 301.73 MiB 56.09 MiB 92.30 MiB 75.43 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-21 05:30:41 Duration: 40s18ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-21 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 208.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028774, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 08:57:33 Duration: 7m12s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 14:29:51 Duration: 7m10s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028803, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 11:58:53 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Queries generating the largest temporary files
Rank Size Query 1 242.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 242.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-21 15:43:37 - 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-08-21 14:57:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 92.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-21 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 92.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-21 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.87 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 79.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 79.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 72.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 72.21 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-21 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 61.03 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-21 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 56.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-21 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.27 sec Highest CPU-cost vacuum
Table pg_catalog.pg_attribute
Database brasilia - 2026-08-21 16:06:48 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 0.27 sec Highest CPU-cost vacuum
Table pg_catalog.pg_attribute
Database brasilia - 2026-08-21 16:06:48 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (124) Main table analyzed (database rio)
- 1,064 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 124 rio.public.temp0000289297 73 rio.pg_catalog.pg_class 69 rio.pg_catalog.pg_type 59 rio.public.usuarios 46 brasilia.pg_catalog.pg_attribute 43 rio.pg_catalog.pg_index 40 contagem.public.temp0000226895 36 rio.pg_catalog.pg_depend 33 contagem.public.usuarios 33 contagem.pg_catalog.pg_attribute 31 rio.public.temp0000289172 24 rio.public.temp0000289287 23 rio.public.temp0000289261 22 rio.public.temp0000289249 21 contagem.public.temp0000226889 19 brasilia.pg_catalog.pg_class 19 rio.public.temp0000289245 18 brasilia.pg_catalog.pg_type 17 rio.public.temp0000289243 17 contagem.public.temp0000226897 16 rio.public.temp0000289223 14 contagem.pg_catalog.pg_class 14 brasilia.public.temp0000238644 14 brasilia.public.temp0000238686 13 rio.public.temp0000289285 13 contagem.pg_catalog.pg_type 12 rio.public.temp0000289239 11 rio.public.temp0000289269 11 brasilia.pg_catalog.pg_index 10 brasilia.public.usuarios 10 brasilia.pg_catalog.pg_depend 8 contagem.pg_catalog.pg_index 8 rio.public.temp0000289235 7 contagem.pg_catalog.pg_shdepend 6 rio.public.temp0000289247 6 rio.public.temp0000289255 6 contagem.pg_catalog.pg_depend 5 rio.public.tmp_drill_0302 5 contagem.public.temp0000226899 5 brasilia.pg_catalog.pg_shdepend 5 brasilia.public.temp0000238638 4 brasilia.public.temp0000238696 4 contagem.public.temp0000226874 4 rio.public.tmp_drill_0175 4 brasilia.public.temp0000238692 4 brasilia.public.temp0000238658 4 contagem.public.temp0000226903 4 rio.public.temp0000289225 4 rio.public.temp0000289233 3 rio.public.temp0000289334 3 contagem.public.nf_entrada 3 brasilia.public.temp0000238642 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000289241 3 rio.public.temp0000289302 2 rio.public.temp0000289326 2 rio.public.temp0000289281 2 postgres.pg_catalog.pg_shdepend 2 brasilia.public.temp0000238702 2 brasilia.public.temp0000238680 2 brasilia.public.temp0000238668 2 rio.public.tmp_drill_0320 2 brasilia.public.temp0000238678 2 contagem.public.temp0000226901 2 rio.public.temp0000289306 1 brasilia.public.temp0000238666 1 rio.public.temp0000289320 1 rio.public.temp0000289221 1 contagem.public.temp0000226891 1 brasilia.public.temp0000238706 1 rio.public.temp0000289299 1 brasilia.public.temp0000238684 1 brasilia.public.temp0000238672 1 brasilia.public.temp0000238728 1 brasilia.public.temp0000238720 1 rio.public.temp0000289219 1 rio.public.temp0000289277 1 brasilia.public.nf_entrada 1 rio.public.temp0000289227 1 brasilia.public.temp0000238664 1 brasilia.public.temp0000238646 1 brasilia.public.temp0000238722 1 rio.public.temp0000289263 1 rio.public.temp0000289295 1 brasilia.public.temp0000238640 1 brasilia.public.temp0000238662 1 rio.public.temp0000289271 1 rio.public.temp0000289231 1 rio.public.temp0000289318 1 brasilia.public.temp0000238732 1 rio.public.temp0000289310 1 rio.public.temp0000289308 1 Total 1,064 Vacuums per table
Key values
- public.temp0000289297 (66) Main table vacuumed on database rio
- 576 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000289297 66 0 0 0 0 0 0 37,767 569 2,690,586 0 0 rio.pg_catalog.pg_attribute 62 48 0 0 0 0 0 26,421 7,472 11,002,061 384 9,211 rio.pg_catalog.pg_class 49 34 0 0 0 0 0 6,546 1,966 2,779,636 75 302 rio.pg_catalog.pg_type 32 27 0 0 0 0 0 2,718 858 1,166,063 77 265 contagem.public.usuarios 31 0 0 0 0 0 0 162 128 64,304 0 0 rio.public.temp0000289287 24 0 0 0 0 0 0 16,888 204 1,187,485 0 0 rio.public.temp0000289172 23 0 0 0 0 0 0 28,041 5,314 8,411,823 0 0 rio.public.temp0000289261 21 0 0 0 0 0 0 16,371 3,649 5,620,134 0 0 rio.pg_catalog.pg_index 18 18 0 0 0 0 0 1,204 389 351,400 49 97 rio.public.temp0000289245 16 0 0 0 0 0 0 843 243 336,216 0 0 rio.pg_catalog.pg_depend 15 15 0 0 0 0 0 4,816 1,875 2,538,347 94 801 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 7,180 1,725 2,977,489 58 1,646 contagem.pg_catalog.pg_attribute 12 12 0 0 0 0 0 7,239 1,692 3,252,546 32 789 rio.public.tmp_drill_0320 11 2 0 0 0 0 0 1,789 29 320,663 1 15 rio.public.temp0000289223 11 0 0 0 0 0 0 660 174 249,203 0 0 rio.public.usuarios 11 7 0 0 0 0 0 204 68 132,156 17 28 rio.public.temp0000289285 9 0 0 0 0 0 0 5,335 99 428,109 0 0 rio.public.tmp_drill_0175 9 4 0 0 0 0 0 684 267 412,377 1 27 rio.public.temp0000289235 7 0 0 0 0 0 0 348 38 26,013 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,768 2,637 10,881,152 1,459 7,130 brasilia.pg_catalog.pg_class 6 6 0 0 0 0 0 1,380 387 628,205 23 75 rio.public.temp0000289243 6 0 0 0 0 0 0 264 68 74,124 0 0 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,188 230 377,440 9 33 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 619 175 252,563 13 29 rio.public.temp0000289269 6 0 0 0 0 0 0 366 189 294,998 0 0 rio.public.temp0000289239 6 0 0 0 0 0 0 409 35 29,270 0 0 rio.public.temp0000289247 5 0 0 0 0 0 0 250 168 263,004 0 0 rio.public.tmp_drill_0302 5 5 0 0 0 0 0 2,490 15 431,098 0 0 contagem.public.temp0000226899 5 0 0 0 0 0 0 555 30 37,564 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 623 166 266,320 7 18 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,247 607 2,976,799 168 526 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,144 272 431,540 19 138 contagem.public.temp0000226903 4 0 0 0 0 0 0 444 24 30,046 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 210 49 48,235 14 24 rio.public.temp0000289334 3 0 0 0 0 0 0 12 9 2,322 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,103 238 516,886 6 48 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 475 162 251,160 29 61 brasilia.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 507 192 268,359 27 50 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 197 49 63,243 5 8 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,339 342 1,284,493 232 1,513 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,181 901 3,634,928 669 4,331 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 393 92 391,230 34 89 brasilia.public.temp0000238678 2 0 0 0 0 0 0 494 8 30,432 0 0 brasilia.public.temp0000238658 2 0 0 0 0 0 0 250 250 394,261 0 0 rio.public.temp0000289326 2 0 0 0 0 0 0 3,496 8 207,470 0 0 rio.public.temp0000289281 2 0 0 0 0 0 0 1,831 10 109,547 0 0 rio.public.temp0000289302 2 0 0 0 0 0 0 1,840 10 110,087 0 0 rio.public.temp0000289310 1 0 0 0 0 0 0 91 6 6,293 0 0 brasilia.public.temp0000238732 1 0 0 0 0 0 0 247 4 15,176 0 0 rio.public.temp0000289308 1 0 0 0 0 0 0 91 6 6,291 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 153 3 17,975 0 0 rio.public.temp0000289231 1 0 0 0 0 0 0 73 6 5,195 0 0 brasilia.public.temp0000238680 1 0 0 0 0 0 0 246 4 15,117 0 0 rio.public.temp0000289318 1 0 0 0 0 0 0 91 89 174,015 0 0 rio.public.temp0000289271 1 0 0 0 0 0 0 78 6 5,493 0 0 rio.public.temp0000289225 1 0 0 0 0 0 0 68 6 4,882 0 0 brasilia.public.temp0000238728 1 0 0 0 0 0 0 246 4 15,117 0 0 rio.public.temp0000289299 1 0 0 0 0 0 0 8 5 1,254 0 0 rio.public.temp0000289295 1 0 0 0 0 0 0 91 6 6,293 0 0 rio.public.temp0000289263 1 0 0 0 0 0 0 74 73 142,197 0 0 brasilia.public.temp0000238642 1 0 0 0 0 0 0 248 4 15,223 0 0 rio.public.temp0000289320 1 0 0 0 0 0 0 91 6 6,293 0 0 rio.public.temp0000289221 1 0 0 0 0 0 0 73 6 5,195 0 0 rio.public.temp0000289306 1 0 0 0 0 0 0 8 5 1,313 0 0 rio.public.temp0000289227 1 0 0 0 0 0 0 73 6 5,191 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 119 41 124,306 1 1 rio.public.temp0000289277 1 0 0 0 0 0 0 8 5 1,317 0 0 contagem.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 148 45 80,022 9 17 brasilia.public.temp0000238666 1 0 0 0 0 0 0 246 4 15,117 0 0 brasilia.public.temp0000238646 1 0 0 0 0 0 0 246 4 15,117 0 0 Total 576 251 0 0 0 0 0 208,108 34,426 68,917,779 3,512 27,272 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (4.44) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000289297 0 0 2.12 rio.pg_catalog.pg_attribute 0 0 4.44 rio.pg_catalog.pg_class 0 0 1.16 rio.pg_catalog.pg_type 0 0 0.4 contagem.public.usuarios 0 0 0 rio.public.temp0000289287 0 0 0.83 rio.public.temp0000289172 0 0 1.25 rio.public.temp0000289261 0 0 0.86 rio.pg_catalog.pg_index 0 0 0.26 rio.public.temp0000289245 0 0 0.18 rio.pg_catalog.pg_depend 0 0 1.41 brasilia.pg_catalog.pg_attribute 0 0 1.45 contagem.pg_catalog.pg_attribute 0 0 1.43 rio.public.tmp_drill_0320 0 0 0.09 rio.public.temp0000289223 0 0 0.17 rio.public.usuarios 0 0 0.01 rio.public.temp0000289285 0 0 0.3 rio.public.tmp_drill_0175 0 0 0.04 rio.public.temp0000289235 0 0 0.07 rio.pg_catalog.pg_statistic 0 0 1.48 brasilia.pg_catalog.pg_class 0 0 0.54 rio.public.temp0000289243 0 0 0.06 contagem.pg_catalog.pg_class 0 0 0.52 brasilia.pg_catalog.pg_type 0 0 0.34 rio.public.temp0000289269 0 0 0.08 rio.public.temp0000289239 0 0 0.1 rio.public.temp0000289247 0 0 0.07 rio.public.tmp_drill_0302 0 0 0.1 contagem.public.temp0000226899 0 0 0.07 contagem.pg_catalog.pg_type 0 0 0.25 rio.pg_toast.pg_toast_2619 0 0 0.37 brasilia.pg_catalog.pg_depend 0 0 0.49 contagem.public.temp0000226903 0 0 0.05 brasilia.pg_catalog.pg_index 0 0 0.08 rio.public.temp0000289334 0 0 0.15 contagem.pg_catalog.pg_depend 0 0 0.4 postgres.pg_catalog.pg_shdepend 0 0 0.38 brasilia.pg_catalog.pg_shdepend 0 0 0.22 contagem.pg_catalog.pg_index 0 0 0.17 contagem.pg_catalog.pg_statistic 0 0 0.38 brasilia.pg_catalog.pg_statistic 0 0 0.57 brasilia.pg_toast.pg_toast_2619 0 0 0.11 brasilia.public.temp0000238678 0 0 0 brasilia.public.temp0000238658 0 0 0.03 rio.public.temp0000289326 0 0 0.12 rio.public.temp0000289281 0 0 0.06 rio.public.temp0000289302 0 0 0.07 rio.public.temp0000289310 0 0 0.02 brasilia.public.temp0000238732 0 0 0.01 rio.public.temp0000289308 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000289231 0 0 0.01 brasilia.public.temp0000238680 0 0 0 rio.public.temp0000289318 0 0 0.02 rio.public.temp0000289271 0 0 0.02 rio.public.temp0000289225 0 0 0.01 brasilia.public.temp0000238728 0 0 0 rio.public.temp0000289299 0 0 0.02 rio.public.temp0000289295 0 0 0.02 rio.public.temp0000289263 0 0 0.02 brasilia.public.temp0000238642 0 0 0 rio.public.temp0000289320 0 0 0.02 rio.public.temp0000289221 0 0 0.02 rio.public.temp0000289306 0 0 0.01 rio.public.temp0000289227 0 0 0.02 brasilia.public.nf_entrada 0 0 0.08 rio.public.temp0000289277 0 0 0.02 contagem.pg_catalog.pg_shdepend 0 0 0.16 brasilia.public.temp0000238666 0 0 0 brasilia.public.temp0000238646 0 0 0 Total 0 0 24.23 Tuples removed per table
Key values
- pg_catalog.pg_attribute (193684) Main table with removed tuples on database rio
- 469397 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 62 48 193,684 1,563,327 130,782 253 37,552 brasilia.pg_catalog.pg_attribute 14 14 60,592 328,267 750 60 9,389 contagem.pg_catalog.pg_attribute 12 12 52,171 289,221 0 262 6,527 rio.public.tmp_drill_0302 5 5 36,744 37,561 0 0 946 rio.public.tmp_drill_0320 11 2 27,226 35,164 3,969 0 793 rio.pg_catalog.pg_statistic 7 7 13,048 58,348 0 0 9,002 rio.pg_catalog.pg_depend 15 15 11,746 289,396 4,398 0 2,787 rio.pg_catalog.pg_type 32 27 10,762 77,106 4,284 11 2,285 rio.public.tmp_drill_0175 9 4 8,862 77,825 34,005 0 1,110 contagem.pg_catalog.pg_statistic 3 3 6,777 22,691 0 0 3,033 brasilia.pg_catalog.pg_depend 4 4 6,387 69,110 0 0 752 brasilia.pg_catalog.pg_statistic 3 3 6,120 23,982 42 0 3,216 rio.pg_catalog.pg_index 18 18 4,318 35,013 491 0 1,046 rio.pg_catalog.pg_class 49 34 4,206 192,832 23,953 23 5,966 postgres.pg_catalog.pg_shdepend 3 3 3,914 40,841 71 0 372 brasilia.pg_catalog.pg_shdepend 3 3 3,632 40,941 269 0 372 brasilia.pg_catalog.pg_class 6 6 3,535 23,682 0 0 897 contagem.pg_catalog.pg_type 5 5 2,911 11,297 26 46 357 brasilia.pg_catalog.pg_type 6 6 2,450 13,270 0 0 468 contagem.public.usuarios 31 0 2,008 782 38 0 62 contagem.pg_catalog.pg_depend 3 3 1,268 55,662 0 24 541 rio.pg_toast.pg_toast_2619 4 4 1,260 3,207 3 0 1,120 brasilia.pg_catalog.pg_index 4 4 1,245 7,531 0 0 224 contagem.pg_catalog.pg_index 3 3 1,164 5,700 0 4 164 contagem.pg_catalog.pg_shdepend 1 1 945 13,846 248 0 124 contagem.pg_catalog.pg_class 6 6 902 21,939 0 88 784 brasilia.public.nf_entrada 1 1 674 4,638 0 0 152 rio.public.usuarios 11 7 485 7,038 1,439 0 231 brasilia.pg_toast.pg_toast_2619 2 2 228 273 0 0 142 contagem.pg_toast.pg_toast_2619 1 1 133 116 0 0 59 rio.public.temp0000289243 6 0 0 11,338 0 135 249 rio.public.temp0000289334 3 0 0 74,039 0 0 5,376 rio.public.temp0000289310 1 0 0 1,581 0 45 83 brasilia.public.temp0000238732 1 0 0 3,234 0 0 256 rio.public.temp0000289287 24 0 0 297,516 0 525 20,851 rio.public.temp0000289308 1 0 0 1,581 0 45 83 rio.public.temp0000289231 1 0 0 1,099 0 63 65 rio.public.temp0000289297 66 0 0 715,872 0 1,867 46,517 brasilia.public.temp0000238680 1 0 0 3,232 0 0 256 rio.public.temp0000289318 1 0 0 1,583 0 45 83 rio.public.temp0000289271 1 0 0 1,280 0 58 70 rio.public.temp0000289269 6 0 0 16,617 0 207 369 rio.public.temp0000289225 1 0 0 1,136 0 4 60 rio.public.temp0000289261 21 0 0 330,884 0 436 23,884 brasilia.public.temp0000238678 2 0 0 6,464 0 0 512 brasilia.public.temp0000238728 1 0 0 3,232 0 0 256 contagem.public.temp0000226903 4 0 0 5,357 0 100 412 rio.public.temp0000289235 7 0 0 16,736 0 204 372 rio.public.temp0000289239 6 0 0 17,828 0 178 398 rio.public.temp0000289299 1 0 0 1,062 0 8 56 rio.public.temp0000289247 5 0 0 13,678 0 144 304 brasilia.public.temp0000238658 2 0 0 6,464 0 0 512 rio.public.temp0000289295 1 0 0 1,576 0 45 83 rio.public.temp0000289326 2 0 0 49,326 0 0 3,584 rio.public.temp0000289263 1 0 0 1,144 0 62 66 rio.public.temp0000289285 9 0 0 132,122 0 149 9,259 rio.public.temp0000289172 23 0 0 543,040 0 46 39,506 rio.public.temp0000289281 2 0 0 26,108 0 50 1,870 rio.public.temp0000289223 11 0 0 36,669 0 275 813 brasilia.public.temp0000238642 1 0 0 3,232 0 0 256 rio.public.temp0000289245 16 0 0 42,181 0 207 945 rio.public.temp0000289302 2 0 0 26,260 0 45 1,875 rio.public.temp0000289320 1 0 0 1,583 0 45 83 rio.public.temp0000289221 1 0 0 1,099 0 63 65 contagem.public.temp0000226899 5 0 0 6,689 0 125 515 rio.public.temp0000289306 1 0 0 1,584 0 44 84 rio.public.temp0000289227 1 0 0 1,099 0 63 65 rio.public.temp0000289277 1 0 0 1,615 0 42 86 brasilia.public.temp0000238666 1 0 0 3,231 0 0 256 brasilia.public.temp0000238646 1 0 0 3,232 0 0 256 Total 576 251 469,397 5,764,209 204,768 6,096 251,164 Pages removed per table
Key values
- public.temp0000289297 (1867) Main table with removed pages on database rio
- 6096 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000289297 66 0 0 1867 rio.public.temp0000289287 24 0 0 525 rio.public.temp0000289261 21 0 0 436 rio.public.temp0000289223 11 0 0 275 contagem.pg_catalog.pg_attribute 12 12 52171 262 rio.pg_catalog.pg_attribute 62 48 193684 253 rio.public.temp0000289269 6 0 0 207 rio.public.temp0000289245 16 0 0 207 rio.public.temp0000289235 7 0 0 204 rio.public.temp0000289239 6 0 0 178 rio.public.temp0000289285 9 0 0 149 rio.public.temp0000289247 5 0 0 144 rio.public.temp0000289243 6 0 0 135 contagem.public.temp0000226899 5 0 0 125 contagem.public.temp0000226903 4 0 0 100 contagem.pg_catalog.pg_class 6 6 902 88 rio.public.temp0000289231 1 0 0 63 rio.public.temp0000289221 1 0 0 63 rio.public.temp0000289227 1 0 0 63 rio.public.temp0000289263 1 0 0 62 brasilia.pg_catalog.pg_attribute 14 14 60592 60 rio.public.temp0000289271 1 0 0 58 rio.public.temp0000289281 2 0 0 50 rio.public.temp0000289172 23 0 0 46 contagem.pg_catalog.pg_type 5 5 2911 46 rio.public.temp0000289310 1 0 0 45 rio.public.temp0000289308 1 0 0 45 rio.public.temp0000289318 1 0 0 45 rio.public.temp0000289295 1 0 0 45 rio.public.temp0000289302 2 0 0 45 rio.public.temp0000289320 1 0 0 45 rio.public.temp0000289306 1 0 0 44 rio.public.temp0000289277 1 0 0 42 contagem.pg_catalog.pg_depend 3 3 1268 24 rio.pg_catalog.pg_class 49 34 4206 23 rio.pg_catalog.pg_type 32 27 10762 11 rio.public.temp0000289299 1 0 0 8 rio.public.temp0000289225 1 0 0 4 contagem.pg_catalog.pg_index 3 3 1164 4 brasilia.pg_catalog.pg_class 6 6 3535 0 rio.public.temp0000289334 3 0 0 0 brasilia.public.temp0000238732 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 133 0 rio.pg_toast.pg_toast_2619 4 4 1260 0 brasilia.pg_toast.pg_toast_2619 2 2 228 0 postgres.pg_catalog.pg_shdepend 3 3 3914 0 brasilia.public.temp0000238680 1 0 0 0 brasilia.pg_catalog.pg_type 6 6 2450 0 brasilia.public.temp0000238678 2 0 0 0 brasilia.pg_catalog.pg_shdepend 3 3 3632 0 brasilia.pg_catalog.pg_depend 4 4 6387 0 brasilia.public.temp0000238728 1 0 0 0 rio.pg_catalog.pg_depend 15 15 11746 0 rio.pg_catalog.pg_statistic 7 7 13048 0 brasilia.public.temp0000238658 2 0 0 0 rio.public.temp0000289326 2 0 0 0 rio.pg_catalog.pg_index 18 18 4318 0 brasilia.pg_catalog.pg_index 4 4 1245 0 rio.public.tmp_drill_0320 11 2 27226 0 brasilia.public.temp0000238642 1 0 0 0 rio.public.tmp_drill_0302 5 5 36744 0 rio.public.usuarios 11 7 485 0 rio.public.tmp_drill_0175 9 4 8862 0 contagem.pg_catalog.pg_statistic 3 3 6777 0 brasilia.pg_catalog.pg_statistic 3 3 6120 0 brasilia.public.nf_entrada 1 1 674 0 contagem.pg_catalog.pg_shdepend 1 1 945 0 brasilia.public.temp0000238666 1 0 0 0 brasilia.public.temp0000238646 1 0 0 0 contagem.public.usuarios 31 0 2008 0 Total 576 251 469,397 6,096 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 21 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 45 96 09 98 136 10 59 168 11 50 125 12 18 26 13 62 116 14 75 157 15 94 130 16 50 80 17 18 28 18 0 0 19 0 0 20 0 0 21 1 2 22 0 0 23 0 0 - 0.27 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 5m40s 2m25s 3m15s 2m50s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 15:18:42 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 08:57:34 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 03:05:28 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
2 1 2m 2m 2m 2m select * from rs_lote_exclui (?);-
SELECT * FROM RS_LOTE_EXCLUI (0133780);
Date: 2026-08-21 10:09:29 Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
3 1 1s 1s 1s 1s drop table if exists temp0000289287;-
DROP TABLE IF EXISTS temp0000289287;
Date: 2026-08-21 15:01:34 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
DROP TABLE IF EXISTS temp0000289287;
Date: 2026-08-21 15:01:34 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Queries that waited the most
Rank Wait time Query 1 3m15s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-21 15:18:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 2m25s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-21 08:57:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 2m SELECT * FROM RS_LOTE_EXCLUI (0280542);[ Date: 2026-08-21 15:18:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000289287;[ Date: 2026-08-21 15:01:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,566 Total read queries
- 1,514 Total write queries
Queries by database
Key values
- rio Main database
- 4,321 Requests
- 6h21m38s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,395 Requests
User Request type Count Duration etiquetas Total 74 21s920ms select 74 21s920ms intelifix Total 6,395 8h15m29s copy to 91 8m34s ddl 1,423 1h4m12s others 490 54m44s select 4,391 6h7m57s lenon Total 101 1m46s select 101 1m46s Duration by user
Key values
- 8h15m29s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 74 21s920ms select 74 21s920ms intelifix Total 6,395 8h15m29s copy to 91 8m34s ddl 1,423 1h4m12s others 490 54m44s select 4,391 6h7m57s lenon Total 101 1m46s select 101 1m46s Queries by host
Key values
- [local] Main host
- 6,570 Requests
- 8h17m38s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,713 Requests
- 4h10m26s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-21 15:16:40 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,359 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m36s analyze verbose;[ Date: 2026-08-21 05:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 14:15:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 16:15:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 11:14:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 15:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 09:13:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 10:12:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 17:12:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028774, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-21 08:57:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 7m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-21 14:29:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 7m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 12:12:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m57s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028803, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-21 11:58:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 6m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 20:11:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028858, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-21 15:18:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028868, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-21 15:33:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m30s analyze verbose;[ Date: 2026-08-21 05:17:08 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
17 6m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028869, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-21 15:49:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 21:11:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 6m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 22:11:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 6m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-21 13:11:15 - 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 1h55m22s 42 1s517ms 10m28s 2m44s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 21 09 3 9m23s 3m7s 10 3 8m10s 2m43s 11 3 10m25s 3m28s 12 3 7m39s 2m33s 13 3 6m32s 2m10s 14 3 11m15s 3m45s 15 3 9m21s 3m7s 16 3 11m23s 3m47s 17 3 7m52s 2m37s 18 3 6m12s 2m4s 19 3 6m26s 2m8s 20 3 7m8s 2m22s 21 3 6m44s 2m14s 22 3 6m45s 2m15s [ User: intelifix - Total duration: 1h55m22s - Times executed: 42 ]
[ Application: psql - Total duration: 1h55m22s - Times executed: 42 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-21 14:15:30 Duration: 10m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-21 16:15:22 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-21 11:14:33 Duration: 9m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
2 1h49m40s 334 152ms 7m12s 19s701ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 21 06 1 849ms 849ms 08 33 8m20s 15s160ms 09 42 20m29s 29s277ms 10 40 14m55s 22s392ms 11 19 14m36s 46s140ms 12 14 5m52s 25s186ms 13 44 1m13s 1s661ms 14 49 9m20s 11s441ms 15 61 28m 27s555ms 16 18 6m15s 20s845ms 17 13 34s586ms 2s660ms [ User: intelifix - Total duration: 1h49m40s - Times executed: 334 ]
[ Application: [unknown] - Total duration: 1h49m40s - Times executed: 334 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028774, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 08:57:33 Duration: 7m12s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 14:29:51 Duration: 7m10s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028803, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 11:58:53 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
3 1h11m7s 42 292ms 5m33s 1m41s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 21 09 3 6m3s 2m1s 10 3 4m53s 1m37s 11 3 7m2s 2m20s 12 3 4m44s 1m34s 13 3 4m7s 1m22s 14 3 5m57s 1m59s 15 3 5m27s 1m49s 16 3 6m25s 2m8s 17 3 4m41s 1m33s 18 3 3m42s 1m14s 19 3 4m6s 1m22s 20 3 4m30s 1m30s 21 3 5m5s 1m41s 22 3 4m17s 1m25s [ User: intelifix - Total duration: 1h11m7s - Times executed: 42 ]
[ Application: psql - Total duration: 1h11m7s - Times executed: 42 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-21 11:22:18 Duration: 5m33s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-21 16:22:29 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-21 09:20:19 Duration: 4m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
4 25m 1,407 150ms 8s949ms 1s66ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 21 08 33 32s625ms 988ms 09 100 1m37s 972ms 10 216 2m48s 781ms 11 251 3m51s 923ms 12 49 42s364ms 864ms 13 126 2m39s 1s266ms 14 240 4m57s 1s239ms 15 242 5m2s 1s248ms 16 100 1m56s 1s162ms 17 50 52s254ms 1s45ms [ User: intelifix - Total duration: 25m - Times executed: 1407 ]
[ Application: [unknown] - Total duration: 25m - Times executed: 1407 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (279983, 433, '835169925004574,241691294056,230049002829,241732830007,241619826385,241693026267,241661050005,241694830305,241595796980,241637436173,230049001112,241700746886,241693217879,241697053754,241596233948,241653319710,241702194143,241673160121,241714240011,241700693043,241607379817,241712204054,241605092647,230048042646,241653842949,241730546472,241617933148,241714021628,241620659609,241646144756,241669517676,241699260513,241645491831,230048051940,241698574957,241703752848', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-21 13:52:54 Duration: 8s949ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54265, 406, '835116917000153,241672181327,241704179006,241695613849,241622508802,241604296979,241679914449,241692559903,241712756767,241714078300,241732158593,241631622026,241618244547,241680317800,241689110207,241599303148,241649479313,241704178501,241729493957,241713719903,241712978204,241656774963,230048439407,241646309597,241689120006,241680476681,230048441731,230048996060,241669621425,241711246272,241727467901,241599315472,241658691133,241689122531,241700934054,241656807693,241712549901,241693229800,241680399401,241689152534,241620824552,230048474562,241620801823,241659743547,241712509112,241728709806,241700953046,241637734463,241638308693,241704377487,241712550104', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-21 15:18:02 Duration: 7s535ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54219, 406, '270911029165100340,229734785979,229739799712,229786692942,229864845967,229816607286,229753045662,229865215981,229741468809,229668523048,229670039705,229737329213,229756099507,229673502030,216937393940,229817186366,229669691131,229668002436,216939742026,229837120625,229781167789,229786788810,229736139815,229805865576,229726275777,229782887272,229812804244,216944850011,229670102338,229816963842,229691638995,229747803445,229671602125,229860217277,229786384651,229742929501,229785031321,229812866674,229743082850,216943472233,229739950513,216939785262,229746158996,216944728910,216945205353,229687847997,229879748285,229752596471,229740264864,229661296270,229783351213', '246543061523,246527561537,246598221216,246651723553,246628305072,246563065461,246648800709,246569561629,246514762633,246515449096,246548867689,246559318383,246501722842,246474639514,246630840404,246515870710,246467586670,246464381319,246640079801,246588501435,246598586178,246529594664,246595793549,246507145559,246597874459,246629648098,246498161013,246515156060,246627220410,246506994658,246558124867,246518436268,246651594045,246597416075,246549004347,246583708990,246627978800,246544147677,246472764561,246568932544,246476999800,246548340714,246456915977,246487885666,246516952140,246652922020,246633364971,246523996979,246465179511,246586112234', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-21 11:46:39 Duration: 7s404ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
5 19m49s 3 2m41s 10m36s 6m36s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 21 05 3 19m49s 6m36s [ User: intelifix - Total duration: 19m49s - Times executed: 3 ]
[ Application: psql - Total duration: 19m49s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-21 05:10:37 Duration: 10m36s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
analyze verbose;
Date: 2026-08-21 05:17:08 Duration: 6m30s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
analyze verbose;
Date: 2026-08-21 05:19:50 Duration: 2m41s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
6 18m37s 85 10s369ms 18s950ms 13s146ms create table temp0000289297 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 21 13 35 7m19s 12s547ms 14 29 6m19s 13s82ms 15 21 4m58s 14s233ms [ User: intelifix - Total duration: 18m37s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 18m37s - Times executed: 85 ]
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 14:05:23 Duration: 18s950ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:25:22 Duration: 17s356ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 14:50:51 Duration: 17s151ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
7 17m42s 75 1s645ms 49s998ms 14s166ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 21 08 2 18s257ms 9s128ms 09 6 1m32s 15s350ms 10 6 1m11s 11s888ms 11 7 1m49s 15s682ms 12 2 10s557ms 5s278ms 13 12 2m39s 13s288ms 14 9 1m57s 13s2ms 15 18 5m17s 17s638ms 16 13 2m46s 12s804ms [ User: intelifix - Total duration: 17m42s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 17m42s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 10:38:11 Duration: 49s998ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 11:31:13 Duration: 44s398ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 09:06:17 Duration: 43s812ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
8 16m4s 249 173ms 3m27s 3s872ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 21 00 12 31s421ms 2s618ms 01 12 22s662ms 1s888ms 02 12 23s139ms 1s928ms 03 12 34s921ms 2s910ms 04 12 22s954ms 1s912ms 05 12 24s887ms 2s73ms 06 12 25s338ms 2s111ms 08 8 2m52s 21s524ms 09 12 35s934ms 2s994ms 10 12 29s372ms 2s447ms 11 12 31s386ms 2s615ms 12 11 27s25ms 2s456ms 13 12 28s552ms 2s379ms 14 12 34s912ms 2s909ms 15 12 3m57s 19s827ms 16 11 30s23ms 2s729ms 17 12 27s727ms 2s310ms 18 11 25s421ms 2s311ms 19 12 25s249ms 2s104ms 20 12 35s860ms 2s988ms 21 12 27s696ms 2s308ms 22 4 9s679ms 2s419ms [ User: intelifix - Total duration: 16m4s - Times executed: 249 ]
[ Application: psql - Total duration: 16m4s - Times executed: 249 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 15:18:42 Duration: 3m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 08:57:34 Duration: 2m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 03:05:28 Duration: 12s269ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
9 10m7s 1,062 151ms 4s386ms 571ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 21 08 101 1m17s 762ms 09 158 1m23s 527ms 10 137 1m9s 506ms 11 155 1m30s 585ms 12 3 2s420ms 806ms 13 118 1m4s 550ms 14 149 1m14s 503ms 15 144 1m29s 618ms 16 95 54s268ms 571ms 17 2 1s290ms 645ms [ User: intelifix - Total duration: 10m7s - Times executed: 1062 ]
[ Application: [unknown] - Total duration: 10m7s - Times executed: 1062 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "305", "itens" : "230013192533,241670621231,241656009096,229999449003,241681495355,229999183040,230029669416,241670742028,230013328809,230054518080,229999024259", "usuario" : "414", "caixa" : "2755052", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-21 08:29:14 Duration: 4s386ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "133900", "modelo" : "155", "itens" : "506F0C3D3F93,C4EB42EC3E25,B0BBE54D90F1,20B82BF9AA95,5447CC496659,186A81D6276F,64FD965F6EF5,D06DC9642C89,5447CC490253,48295245E428", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "RANI[[tela]]" }');
Date: 2026-08-21 16:07:09 Duration: 3s623ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280082", "modelo" : "464", "itens" : "241771325974,241774193235,241777845858,241774101128,241778991414,241760119718,241761219713,241742758191,241813785763,241767520609,241767388193,241762486166,241688041427,241687504651,241767715274,241767513638,241745406183,241760148889,241761474766,241762781426,863400604213732,241774191821,241813881127,241767713557,241738532527,241761178698,241761179709,241762954147,241763936678,241742379210,241767696383,241747991419,241813722828,241738890520,241740698394,241764602838,241746073353,241762857392,241738290405,241814099206,241742819107,241763503348,241759669820,241761226986,241815412634,241813803846,241815428493,241739803650,241778813944,241739436060,241762780517,241739791932,241740731934,241738672440,241744485274,241771177171,241771363453,241740918595,241743673343", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-21 08:58:47 Duration: 2s461ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
10 9m16s 138 225ms 48s574ms 4s33ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 21 00 5 22s925ms 4s585ms 01 6 10s272ms 1s712ms 02 6 10s772ms 1s795ms 03 5 13s125ms 2s625ms 04 6 11s636ms 1s939ms 05 3 8s647ms 2s882ms 08 8 1m13s 9s191ms 09 12 45s752ms 3s812ms 10 12 42s750ms 3s562ms 11 12 1m1s 5s152ms 12 13 43s30ms 3s310ms 13 6 13s184ms 2s197ms 14 11 1m5s 5s973ms 15 12 1m10s 5s853ms 16 9 35s329ms 3s925ms 17 5 5s314ms 1s62ms 21 5 16s995ms 3s399ms 22 2 5s635ms 2s817ms [ User: intelifix - Total duration: 9m16s - Times executed: 138 ]
[ Application: psql - Total duration: 9m16s - Times executed: 138 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 08:45:50 Duration: 48s574ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 15:15:15 Duration: 13s971ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 14:25:14 Duration: 12s943ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
11 7m27s 36 9s808ms 15s568ms 12s433ms create table temp0000289261 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 21 08 6 1m12s 12s135ms 09 14 2m42s 11s589ms 10 16 3m32s 13s284ms [ User: intelifix - Total duration: 7m27s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 7m27s - Times executed: 36 ]
-
CREATE TABLE temp0000289261 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 10:53:57 Duration: 15s568ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289261 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 10:22:16 Duration: 15s521ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289261 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 10:52:37 Duration: 14s683ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
12 7m17s 30 11s98ms 47s813ms 14s577ms create table temp0000289172 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 21 08 7 1m56s 16s615ms 09 9 1m47s 11s980ms 10 4 49s75ms 12s268ms 11 2 1m1s 30s766ms 14 2 24s540ms 12s270ms 15 2 27s61ms 13s530ms 16 4 50s974ms 12s743ms [ User: intelifix - Total duration: 7m17s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 7m17s - Times executed: 30 ]
-
CREATE TABLE temp0000289172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 11:41:10 Duration: 47s813ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 08:31:53 Duration: 38s990ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:13:02 Duration: 14s775ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
13 6m35s 29 11s212ms 16s612ms 13s625ms create table temp0000289287 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 21 11 9 2m3s 13s738ms 12 3 35s111ms 11s703ms 14 5 1m3s 12s644ms 15 12 2m53s 14s430ms [ User: intelifix - Total duration: 6m35s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 6m35s - Times executed: 29 ]
-
CREATE TABLE temp0000289287 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:42:35 Duration: 16s612ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289287 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:01:51 Duration: 16s263ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289287 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 11:49:59 Duration: 15s707ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
14 4m2s 102 160ms 28s252ms 2s374ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 21 08 8 57s4ms 7s125ms 09 14 1m23s 5s935ms 10 8 10s126ms 1s265ms 11 5 36s113ms 7s222ms 12 7 3s242ms 463ms 13 20 6s350ms 317ms 14 22 12s489ms 567ms 15 17 19s190ms 1s128ms 16 1 14s618ms 14s618ms [ User: intelifix - Total duration: 4m2s - Times executed: 102 ]
[ Application: psql - Total duration: 4m2s - Times executed: 102 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028785);
Date: 2026-08-21 09:36:22 Duration: 28s252ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 450); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028800);
Date: 2026-08-21 11:40:47 Duration: 24s564ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028769);
Date: 2026-08-21 08:32:48 Duration: 23s627ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
15 3m18s 43 3s585ms 11s388ms 4s618ms create table temp0000289297 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 21 13 16 1m15s 4s728ms 14 20 1m28s 4s400ms 15 7 34s946ms 4s992ms [ User: intelifix - Total duration: 3m18s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 3m18s - Times executed: 43 ]
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 13:20:39 Duration: 11s388ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 15:27:06 Duration: 7s110ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 13:43:49 Duration: 5s36ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
16 3m6s 58 208ms 29s9ms 3s216ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 21 08 7 37s422ms 5s346ms 09 10 21s186ms 2s118ms 10 6 15s772ms 2s628ms 11 3 15s37ms 5s12ms 12 2 11s686ms 5s843ms 13 9 27s419ms 3s46ms 14 9 23s803ms 2s644ms 15 9 30s472ms 3s385ms 16 1 1s149ms 1s149ms 17 2 2s631ms 1s315ms [ User: intelifix - Total duration: 3m6s - Times executed: 58 ]
[ Application: psql - Total duration: 3m6s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028774);
Date: 2026-08-21 08:50:16 Duration: 29s9ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028803);
Date: 2026-08-21 11:51:33 Duration: 10s811ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028841);
Date: 2026-08-21 14:22:07 Duration: 9s107ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
17 3m5s 49 3s148ms 5s353ms 3s791ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 21 08 1 3s763ms 3s763ms 09 3 12s292ms 4s97ms 10 4 13s727ms 3s431ms 11 4 14s377ms 3s594ms 12 4 15s985ms 3s996ms 13 3 10s360ms 3s453ms 14 5 20s408ms 4s81ms 15 3 11s799ms 3s933ms 16 3 11s488ms 3s829ms 17 4 13s734ms 3s433ms 18 3 11s83ms 3s694ms 19 4 15s679ms 3s919ms 20 4 15s551ms 3s887ms 21 3 11s874ms 3s958ms 22 1 3s636ms 3s636ms [ User: intelifix - Total duration: 3m5s - Times executed: 49 ]
[ Application: psql - Total duration: 3m5s - Times executed: 49 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-21 09:20:10 Duration: 5s353ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-21 19:20:06 Duration: 4s904ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-21 14:20:10 Duration: 4s670ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
18 2m15s 9 9s646ms 22s423ms 15s44ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 21 00 3 1m3s 21s57ms 06 3 32s783ms 10s927ms 08 3 39s448ms 13s149ms [ User: intelifix - Total duration: 2m15s - Times executed: 9 ]
[ Application: psql - Total duration: 2m15s - Times executed: 9 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-21 00:06:04 Duration: 22s423ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-21 00:05:42 Duration: 21s481ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-21 00:05:21 Duration: 19s267ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
19 2m9s 10 10s644ms 14s604ms 12s907ms create table temp0000289285 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 21 12 10 2m9s 12s907ms [ User: intelifix - Total duration: 2m9s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 10 ]
-
CREATE TABLE temp0000289285 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 12:07:09 Duration: 14s604ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289285 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 12:01:09 Duration: 14s582ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289285 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 12:06:28 Duration: 14s216ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
20 1m59s 32 3s89ms 4s388ms 3s724ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 21 08 1 4s388ms 4s388ms 09 2 7s23ms 3s511ms 10 2 7s155ms 3s577ms 11 2 7s332ms 3s666ms 12 2 8s119ms 4s59ms 13 3 11s129ms 3s709ms 14 1 3s863ms 3s863ms 15 3 11s254ms 3s751ms 16 3 10s714ms 3s571ms 17 2 6s944ms 3s472ms 18 3 11s464ms 3s821ms 19 2 7s214ms 3s607ms 20 2 7s927ms 3s963ms 21 3 11s320ms 3s773ms 22 1 3s318ms 3s318ms [ User: intelifix - Total duration: 1m59s - Times executed: 32 ]
[ Application: psql - Total duration: 1m59s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-21 08:40:05 Duration: 4s388ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-21 21:20:06 Duration: 4s294ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-21 12:20:05 Duration: 4s176ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,407 25m 150ms 8s949ms 1s66ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 21 08 33 32s625ms 988ms 09 100 1m37s 972ms 10 216 2m48s 781ms 11 251 3m51s 923ms 12 49 42s364ms 864ms 13 126 2m39s 1s266ms 14 240 4m57s 1s239ms 15 242 5m2s 1s248ms 16 100 1m56s 1s162ms 17 50 52s254ms 1s45ms [ User: intelifix - Total duration: 25m - Times executed: 1407 ]
[ Application: [unknown] - Total duration: 25m - Times executed: 1407 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (279983, 433, '835169925004574,241691294056,230049002829,241732830007,241619826385,241693026267,241661050005,241694830305,241595796980,241637436173,230049001112,241700746886,241693217879,241697053754,241596233948,241653319710,241702194143,241673160121,241714240011,241700693043,241607379817,241712204054,241605092647,230048042646,241653842949,241730546472,241617933148,241714021628,241620659609,241646144756,241669517676,241699260513,241645491831,230048051940,241698574957,241703752848', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-21 13:52:54 Duration: 8s949ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54265, 406, '835116917000153,241672181327,241704179006,241695613849,241622508802,241604296979,241679914449,241692559903,241712756767,241714078300,241732158593,241631622026,241618244547,241680317800,241689110207,241599303148,241649479313,241704178501,241729493957,241713719903,241712978204,241656774963,230048439407,241646309597,241689120006,241680476681,230048441731,230048996060,241669621425,241711246272,241727467901,241599315472,241658691133,241689122531,241700934054,241656807693,241712549901,241693229800,241680399401,241689152534,241620824552,230048474562,241620801823,241659743547,241712509112,241728709806,241700953046,241637734463,241638308693,241704377487,241712550104', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-21 15:18:02 Duration: 7s535ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54219, 406, '270911029165100340,229734785979,229739799712,229786692942,229864845967,229816607286,229753045662,229865215981,229741468809,229668523048,229670039705,229737329213,229756099507,229673502030,216937393940,229817186366,229669691131,229668002436,216939742026,229837120625,229781167789,229786788810,229736139815,229805865576,229726275777,229782887272,229812804244,216944850011,229670102338,229816963842,229691638995,229747803445,229671602125,229860217277,229786384651,229742929501,229785031321,229812866674,229743082850,216943472233,229739950513,216939785262,229746158996,216944728910,216945205353,229687847997,229879748285,229752596471,229740264864,229661296270,229783351213', '246543061523,246527561537,246598221216,246651723553,246628305072,246563065461,246648800709,246569561629,246514762633,246515449096,246548867689,246559318383,246501722842,246474639514,246630840404,246515870710,246467586670,246464381319,246640079801,246588501435,246598586178,246529594664,246595793549,246507145559,246597874459,246629648098,246498161013,246515156060,246627220410,246506994658,246558124867,246518436268,246651594045,246597416075,246549004347,246583708990,246627978800,246544147677,246472764561,246568932544,246476999800,246548340714,246456915977,246487885666,246516952140,246652922020,246633364971,246523996979,246465179511,246586112234', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-21 11:46:39 Duration: 7s404ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
2 1,062 10m7s 151ms 4s386ms 571ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 21 08 101 1m17s 762ms 09 158 1m23s 527ms 10 137 1m9s 506ms 11 155 1m30s 585ms 12 3 2s420ms 806ms 13 118 1m4s 550ms 14 149 1m14s 503ms 15 144 1m29s 618ms 16 95 54s268ms 571ms 17 2 1s290ms 645ms [ User: intelifix - Total duration: 10m7s - Times executed: 1062 ]
[ Application: [unknown] - Total duration: 10m7s - Times executed: 1062 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "305", "itens" : "230013192533,241670621231,241656009096,229999449003,241681495355,229999183040,230029669416,241670742028,230013328809,230054518080,229999024259", "usuario" : "414", "caixa" : "2755052", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-21 08:29:14 Duration: 4s386ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "133900", "modelo" : "155", "itens" : "506F0C3D3F93,C4EB42EC3E25,B0BBE54D90F1,20B82BF9AA95,5447CC496659,186A81D6276F,64FD965F6EF5,D06DC9642C89,5447CC490253,48295245E428", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "RANI[[tela]]" }');
Date: 2026-08-21 16:07:09 Duration: 3s623ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "280082", "modelo" : "464", "itens" : "241771325974,241774193235,241777845858,241774101128,241778991414,241760119718,241761219713,241742758191,241813785763,241767520609,241767388193,241762486166,241688041427,241687504651,241767715274,241767513638,241745406183,241760148889,241761474766,241762781426,863400604213732,241774191821,241813881127,241767713557,241738532527,241761178698,241761179709,241762954147,241763936678,241742379210,241767696383,241747991419,241813722828,241738890520,241740698394,241764602838,241746073353,241762857392,241738290405,241814099206,241742819107,241763503348,241759669820,241761226986,241815412634,241813803846,241815428493,241739803650,241778813944,241739436060,241762780517,241739791932,241740731934,241738672440,241744485274,241771177171,241771363453,241740918595,241743673343", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-21 08:58:47 Duration: 2s461ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
3 334 1h49m40s 152ms 7m12s 19s701ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 21 06 1 849ms 849ms 08 33 8m20s 15s160ms 09 42 20m29s 29s277ms 10 40 14m55s 22s392ms 11 19 14m36s 46s140ms 12 14 5m52s 25s186ms 13 44 1m13s 1s661ms 14 49 9m20s 11s441ms 15 61 28m 27s555ms 16 18 6m15s 20s845ms 17 13 34s586ms 2s660ms [ User: intelifix - Total duration: 1h49m40s - Times executed: 334 ]
[ Application: [unknown] - Total duration: 1h49m40s - Times executed: 334 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028774, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 08:57:33 Duration: 7m12s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 14:29:51 Duration: 7m10s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028803, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 11:58:53 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
4 249 16m4s 173ms 3m27s 3s872ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 21 00 12 31s421ms 2s618ms 01 12 22s662ms 1s888ms 02 12 23s139ms 1s928ms 03 12 34s921ms 2s910ms 04 12 22s954ms 1s912ms 05 12 24s887ms 2s73ms 06 12 25s338ms 2s111ms 08 8 2m52s 21s524ms 09 12 35s934ms 2s994ms 10 12 29s372ms 2s447ms 11 12 31s386ms 2s615ms 12 11 27s25ms 2s456ms 13 12 28s552ms 2s379ms 14 12 34s912ms 2s909ms 15 12 3m57s 19s827ms 16 11 30s23ms 2s729ms 17 12 27s727ms 2s310ms 18 11 25s421ms 2s311ms 19 12 25s249ms 2s104ms 20 12 35s860ms 2s988ms 21 12 27s696ms 2s308ms 22 4 9s679ms 2s419ms [ User: intelifix - Total duration: 16m4s - Times executed: 249 ]
[ Application: psql - Total duration: 16m4s - Times executed: 249 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 15:18:42 Duration: 3m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 08:57:34 Duration: 2m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 03:05:28 Duration: 12s269ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
5 194 41s213ms 150ms 966ms 212ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 21 08 1 289ms 289ms 09 2 348ms 174ms 10 9 2s600ms 288ms 11 9 1s684ms 187ms 12 4 924ms 231ms 13 9 3s449ms 383ms 14 21 4s84ms 194ms 15 70 14s484ms 206ms 16 55 10s319ms 187ms 17 14 3s27ms 216ms [ User: intelifix - Total duration: 41s213ms - Times executed: 194 ]
[ Application: [unknown] - Total duration: 41s213ms - Times executed: 194 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "365", "data-de" : "2026-08-21", "data-ate" : "2026-08-21", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 414 }');
Date: 2026-08-21 13:00:05 Duration: 966ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-08-21", "data-ate" : "2026-08-21", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 398 }');
Date: 2026-08-21 17:07:19 Duration: 707ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-08-21", "data-ate" : "2026-08-21", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-08-21 15:40:03 Duration: 677ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
6 165 1m35s 156ms 1s788ms 579ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 21 10 66 32s713ms 495ms 11 97 1m 625ms 13 2 2s248ms 1s124ms [ User: intelifix - Total duration: 1m35s - Times executed: 165 ]
[ Application: [unknown] - Total duration: 1m35s - Times executed: 165 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52975","seriais":"230041687782,230036066078,230028857888,230030369191,230044976375,230014692949,230049702830,230001015261,230051067979,229985272244,229980104455,229968747173,230050149292,229971783441,230030538401,230030132020,230051108993,230014318085,229971872238,229972145676,230034403346,229974467800,230026418302,230027725264,230050065267,230031636072,230034445471,230041425052,230026404260,229989897980,230031553236,229982710322,230042842632,230027299510,230045050828,229963433434,230051082931,230021042334","usuario":"416","observacao":""}');
Date: 2026-08-21 11:37:12 Duration: 1s788ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52975","seriais":"216929261733,229836224869,229773833954,229821998889,229711532341,229701006666,229826735065,229703486785,229699451824,229700685468,216923938799,229715144960,216931348401,229826925970,229830078084,229798462845,229697574143,229692425975,229638618401,229700849906,229646797077,229710675455,229716349915,216930858195,229702226976,229699504051,229775053456,229675131931,229715071721,229641780416,229639707687,216929005669,229775844352,229678621935,229713826986","usuario":"416","observacao":""}');
Date: 2026-08-21 11:34:11 Duration: 1s714ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"52975","seriais":"3CF9F0A8EC56,14CA56D28459,D83139202218,5872C9952B29,D83139936DEE,F4E84F86FDC2,3CF9F06FE2E3,6C11BA6ED87F,4896D9519536,D8313924A164,6C11BA6D2D2F,D831399023F0,D89A0DAA42E9,F4E84F86FFC0,6C11BA6C5BD7,14CA56CE0825,D89A0DAFBFAF,D83139A0E794,C4EBFF8F11C2,4896D95AEA74,4896D9540F68,843C9921F491,D83139936F6E,48D68237AE42,4896D9578108,48D68237D87E,4896D95AEB22,D83139936C14","usuario":"416","observacao":""}');
Date: 2026-08-21 10:29:28 Duration: 1s493ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
7 138 9m16s 225ms 48s574ms 4s33ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 21 00 5 22s925ms 4s585ms 01 6 10s272ms 1s712ms 02 6 10s772ms 1s795ms 03 5 13s125ms 2s625ms 04 6 11s636ms 1s939ms 05 3 8s647ms 2s882ms 08 8 1m13s 9s191ms 09 12 45s752ms 3s812ms 10 12 42s750ms 3s562ms 11 12 1m1s 5s152ms 12 13 43s30ms 3s310ms 13 6 13s184ms 2s197ms 14 11 1m5s 5s973ms 15 12 1m10s 5s853ms 16 9 35s329ms 3s925ms 17 5 5s314ms 1s62ms 21 5 16s995ms 3s399ms 22 2 5s635ms 2s817ms [ User: intelifix - Total duration: 9m16s - Times executed: 138 ]
[ Application: psql - Total duration: 9m16s - Times executed: 138 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 08:45:50 Duration: 48s574ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 15:15:15 Duration: 13s971ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 14:25:14 Duration: 12s943ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
8 113 49s31ms 243ms 850ms 433ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 21 08 11 4s576ms 416ms 09 27 11s768ms 435ms 10 16 6s966ms 435ms 11 7 3s2ms 428ms 12 4 1s764ms 441ms 13 9 3s624ms 402ms 14 13 5s852ms 450ms 15 15 6s723ms 448ms 16 6 2s857ms 476ms 17 5 1s896ms 379ms [ User: intelifix - Total duration: 49s31ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 49s31ms - Times executed: 113 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-21 15:20:09 Duration: 850ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-08-21 16:54:50 Duration: 729ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-21 10:29:00 Duration: 671ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
9 102 4m2s 160ms 28s252ms 2s374ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 21 08 8 57s4ms 7s125ms 09 14 1m23s 5s935ms 10 8 10s126ms 1s265ms 11 5 36s113ms 7s222ms 12 7 3s242ms 463ms 13 20 6s350ms 317ms 14 22 12s489ms 567ms 15 17 19s190ms 1s128ms 16 1 14s618ms 14s618ms [ User: intelifix - Total duration: 4m2s - Times executed: 102 ]
[ Application: psql - Total duration: 4m2s - Times executed: 102 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028785);
Date: 2026-08-21 09:36:22 Duration: 28s252ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 450); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028800);
Date: 2026-08-21 11:40:47 Duration: 24s564ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028769);
Date: 2026-08-21 08:32:48 Duration: 23s627ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
10 96 1m25s 152ms 5s142ms 893ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 21 06 1 1s939ms 1s939ms 08 18 8s63ms 447ms 09 13 4s568ms 351ms 10 2 5s737ms 2s868ms 11 2 6s791ms 3s395ms 12 3 5s495ms 1s831ms 13 23 13s298ms 578ms 14 11 7s646ms 695ms 15 21 28s349ms 1s349ms 16 2 3s916ms 1s958ms [ User: intelifix - Total duration: 1m25s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 1m25s - Times executed: 96 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133420) LIMIT 1;
Date: 2026-08-21 15:25:09 Duration: 5s142ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133429) LIMIT 1;
Date: 2026-08-21 15:06:51 Duration: 4s714ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0132789) LIMIT 1;
Date: 2026-08-21 15:38:56 Duration: 4s242ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
11 95 45s662ms 280ms 722ms 480ms 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 #11
Day Hour Count Duration Avg duration Aug 21 06 2 783ms 391ms 08 10 4s981ms 498ms 09 9 4s142ms 460ms 10 10 4s938ms 493ms 11 15 8s87ms 539ms 12 3 1s98ms 366ms 13 15 6s938ms 462ms 14 9 4s295ms 477ms 15 9 4s320ms 480ms 16 9 4s360ms 484ms 17 3 1s298ms 432ms 20 1 416ms 416ms [ User: lenon - Total duration: 45s662ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 45s662ms - Times executed: 95 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-21 10:44:19 Duration: 722ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-21.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-08-21 11:01:51 Duration: 697ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-21.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-08-21 11:18:06 Duration: 670ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-21.log
12 86 51s553ms 356ms 896ms 599ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 21 06 2 1s128ms 564ms 08 4 2s242ms 560ms 09 9 5s251ms 583ms 10 10 6s134ms 613ms 11 15 9s820ms 654ms 12 2 815ms 407ms 13 15 8s842ms 589ms 14 9 5s373ms 597ms 15 9 5s221ms 580ms 16 8 5s139ms 642ms 17 3 1s583ms 527ms [ User: intelifix - Total duration: 51s553ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 51s553ms - Times executed: 86 ]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-08-21 10:44:19 Duration: 896ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
select * from rs_menu_grants (406, 5, 1);
Date: 2026-08-21 11:18:06 Duration: 862ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-21 13:22:00 Duration: 816ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
13 85 18m37s 10s369ms 18s950ms 13s146ms create table temp0000289297 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 21 13 35 7m19s 12s547ms 14 29 6m19s 13s82ms 15 21 4m58s 14s233ms [ User: intelifix - Total duration: 18m37s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 18m37s - Times executed: 85 ]
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 14:05:23 Duration: 18s950ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:25:22 Duration: 17s356ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 14:50:51 Duration: 17s151ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
14 75 17m42s 1s645ms 49s998ms 14s166ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 21 08 2 18s257ms 9s128ms 09 6 1m32s 15s350ms 10 6 1m11s 11s888ms 11 7 1m49s 15s682ms 12 2 10s557ms 5s278ms 13 12 2m39s 13s288ms 14 9 1m57s 13s2ms 15 18 5m17s 17s638ms 16 13 2m46s 12s804ms [ User: intelifix - Total duration: 17m42s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 17m42s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 10:38:11 Duration: 49s998ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 11:31:13 Duration: 44s398ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 09:06:17 Duration: 43s812ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
15 75 12s59ms 150ms 183ms 160ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 21 08 10 1s616ms 161ms 09 7 1s106ms 158ms 10 5 787ms 157ms 11 11 1s761ms 160ms 12 1 156ms 156ms 13 5 801ms 160ms 14 15 2s457ms 163ms 15 15 2s394ms 159ms 16 6 977ms 162ms [ User: intelifix - Total duration: 12s59ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 12s59ms - Times executed: 75 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0298;
Date: 2026-08-21 14:38:11 Duration: 183ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-08-21 15:28:01 Duration: 179ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-08-21 13:35:24 Duration: 177ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
16 74 18s204ms 150ms 663ms 246ms create table temp0000238686 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 21 13 13 2s938ms 226ms 14 12 2s748ms 229ms 15 15 4s246ms 283ms 16 30 7s376ms 245ms 17 4 894ms 223ms [ User: intelifix - Total duration: 18s204ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 18s204ms - Times executed: 74 ]
-
CREATE TABLE temp0000238686 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "21-08-2026", "data-ate" : "21-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-21 15:23:34 Duration: 663ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000238686 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "16-08-2026", "data-ate" : "21-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-21 13:14:26 Duration: 606ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000238686 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "21-08-2026", "data-ate" : "21-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-21 15:20:34 Duration: 456ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
17 73 19s558ms 154ms 3s736ms 267ms create table temp0000289271 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 21 09 1 3s736ms 3s736ms 10 13 2s377ms 182ms 11 14 3s182ms 227ms 12 5 1s158ms 231ms 13 3 753ms 251ms 14 11 2s175ms 197ms 15 21 5s120ms 243ms 16 5 1s53ms 210ms [ User: intelifix - Total duration: 19s558ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 19s558ms - Times executed: 73 ]
-
CREATE TABLE temp0000289271 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 09:17:19 Duration: 3s736ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289271 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"1065389", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 15:03:43 Duration: 343ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289271 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"2142", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 11:32:04 Duration: 331ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
18 71 27s710ms 150ms 2s383ms 390ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 21 08 5 1s251ms 250ms 09 10 2s704ms 270ms 10 8 3s934ms 491ms 11 2 464ms 232ms 13 15 8s831ms 588ms 14 13 6s343ms 487ms 15 16 3s528ms 220ms 16 2 652ms 326ms [ User: intelifix - Total duration: 27s710ms - Times executed: 71 ]
[ Application: [unknown] - Total duration: 27s710ms - Times executed: 71 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (173, 5, 2, 28, 'ZTEGD6417EB7', '','DEFAULT',00,0318,'', '','', 00);
Date: 2026-08-21 10:09:29 Duration: 2s383ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '9877E70C4966,9877E700D9A7,84011206B66A,9877E74AEF62,840112960F29,840112603641,840112603AD2,743AEF950194,840112C0C27F,743AEF5C1611,9877E7B90220,840112294276,8401129812D6,743AEF959A60,9877E74B38CD,9877E74E9C9C,9877E74EC816,84011205B7D8,743AEF33B1DB,743AEF760135,9877E70A3D31,743AEF757964', '77;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-08-21 14:50:28 Duration: 1s863ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, 'B4F2670BC0E8,6802B8BE602C,6802B8ACC17C,6802B8DECF62,6802B862DE46,B4F26757BCEF,6802B8F8A971,6802B8A3C6D5,6802B8651C84,6802B8DBFF56', '','DEFAULT',056,0156,'', '','', 00);
Date: 2026-08-21 14:07:01 Duration: 1s567ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
19 58 3m6s 208ms 29s9ms 3s216ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 21 08 7 37s422ms 5s346ms 09 10 21s186ms 2s118ms 10 6 15s772ms 2s628ms 11 3 15s37ms 5s12ms 12 2 11s686ms 5s843ms 13 9 27s419ms 3s46ms 14 9 23s803ms 2s644ms 15 9 30s472ms 3s385ms 16 1 1s149ms 1s149ms 17 2 2s631ms 1s315ms [ User: intelifix - Total duration: 3m6s - Times executed: 58 ]
[ Application: psql - Total duration: 3m6s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028774);
Date: 2026-08-21 08:50:16 Duration: 29s9ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028803);
Date: 2026-08-21 11:51:33 Duration: 10s811ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028841);
Date: 2026-08-21 14:22:07 Duration: 9s107ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
20 57 12s431ms 152ms 351ms 218ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 21 08 10 2s363ms 236ms 09 9 1s920ms 213ms 10 9 1s976ms 219ms 11 10 2s130ms 213ms 12 1 183ms 183ms 13 3 707ms 235ms 14 10 2s159ms 215ms 15 2 351ms 175ms 16 3 639ms 213ms [ User: intelifix - Total duration: 12s431ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 12s431ms - Times executed: 57 ]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230007841517,230001255767,229982019412,230041102541,230020598698,230017426784,230001305873,230049522532,229971316369,229990384549', NULL, NULL, 0295, 00);
Date: 2026-08-21 08:32:39 Duration: 351ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241626679714,241642029203,241642279508,241640670519,241634175967,241633610425,241611849804,241632935476,241626575461,241625309412,241643786972', NULL, NULL, 0454, 00);
Date: 2026-08-21 10:13:33 Duration: 341ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241625494559,241614292142,241613374768,241612171228,241613856464,241626680624,241633527183,241611917487,241613838607,241614242440,241613851515,241613777893', NULL, NULL, 0454, 00);
Date: 2026-08-21 13:44:51 Duration: 338ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m41s 10m36s 6m36s 3 19m49s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 21 05 3 19m49s 6m36s [ User: intelifix - Total duration: 19m49s - Times executed: 3 ]
[ Application: psql - Total duration: 19m49s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-21 05:10:37 Duration: 10m36s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
analyze verbose;
Date: 2026-08-21 05:17:08 Duration: 6m30s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
analyze verbose;
Date: 2026-08-21 05:19:50 Duration: 2m41s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
2 1s517ms 10m28s 2m44s 42 1h55m22s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 21 09 3 9m23s 3m7s 10 3 8m10s 2m43s 11 3 10m25s 3m28s 12 3 7m39s 2m33s 13 3 6m32s 2m10s 14 3 11m15s 3m45s 15 3 9m21s 3m7s 16 3 11m23s 3m47s 17 3 7m52s 2m37s 18 3 6m12s 2m4s 19 3 6m26s 2m8s 20 3 7m8s 2m22s 21 3 6m44s 2m14s 22 3 6m45s 2m15s [ User: intelifix - Total duration: 1h55m22s - Times executed: 42 ]
[ Application: psql - Total duration: 1h55m22s - Times executed: 42 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-21 14:15:30 Duration: 10m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-21 16:15:22 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-21 11:14:33 Duration: 9m31s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
3 292ms 5m33s 1m41s 42 1h11m7s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 21 09 3 6m3s 2m1s 10 3 4m53s 1m37s 11 3 7m2s 2m20s 12 3 4m44s 1m34s 13 3 4m7s 1m22s 14 3 5m57s 1m59s 15 3 5m27s 1m49s 16 3 6m25s 2m8s 17 3 4m41s 1m33s 18 3 3m42s 1m14s 19 3 4m6s 1m22s 20 3 4m30s 1m30s 21 3 5m5s 1m41s 22 3 4m17s 1m25s [ User: intelifix - Total duration: 1h11m7s - Times executed: 42 ]
[ Application: psql - Total duration: 1h11m7s - Times executed: 42 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-21 11:22:18 Duration: 5m33s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-21 16:22:29 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-21 09:20:19 Duration: 4m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
4 152ms 7m12s 19s701ms 334 1h49m40s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 21 06 1 849ms 849ms 08 33 8m20s 15s160ms 09 42 20m29s 29s277ms 10 40 14m55s 22s392ms 11 19 14m36s 46s140ms 12 14 5m52s 25s186ms 13 44 1m13s 1s661ms 14 49 9m20s 11s441ms 15 61 28m 27s555ms 16 18 6m15s 20s845ms 17 13 34s586ms 2s660ms [ User: intelifix - Total duration: 1h49m40s - Times executed: 334 ]
[ Application: [unknown] - Total duration: 1h49m40s - Times executed: 334 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028774, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 08:57:33 Duration: 7m12s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 14:29:51 Duration: 7m10s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028803, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-21 11:58:53 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
5 9s646ms 22s423ms 15s44ms 9 2m15s call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 21 00 3 1m3s 21s57ms 06 3 32s783ms 10s927ms 08 3 39s448ms 13s149ms [ User: intelifix - Total duration: 2m15s - Times executed: 9 ]
[ Application: psql - Total duration: 2m15s - Times executed: 9 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-21 00:06:04 Duration: 22s423ms Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-21 00:05:42 Duration: 21s481ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-08-21 00:05:21 Duration: 19s267ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
6 11s98ms 47s813ms 14s577ms 30 7m17s create table temp0000289172 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 21 08 7 1m56s 16s615ms 09 9 1m47s 11s980ms 10 4 49s75ms 12s268ms 11 2 1m1s 30s766ms 14 2 24s540ms 12s270ms 15 2 27s61ms 13s530ms 16 4 50s974ms 12s743ms [ User: intelifix - Total duration: 7m17s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 7m17s - Times executed: 30 ]
-
CREATE TABLE temp0000289172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 11:41:10 Duration: 47s813ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 08:31:53 Duration: 38s990ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289172 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:13:02 Duration: 14s775ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
7 1s645ms 49s998ms 14s166ms 75 17m42s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 21 08 2 18s257ms 9s128ms 09 6 1m32s 15s350ms 10 6 1m11s 11s888ms 11 7 1m49s 15s682ms 12 2 10s557ms 5s278ms 13 12 2m39s 13s288ms 14 9 1m57s 13s2ms 15 18 5m17s 17s638ms 16 13 2m46s 12s804ms [ User: intelifix - Total duration: 17m42s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 17m42s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 10:38:11 Duration: 49s998ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 11:31:13 Duration: 44s398ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-21', 0302, '', '', 0, 6, '2026-08-01');
Date: 2026-08-21 09:06:17 Duration: 43s812ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
8 11s212ms 16s612ms 13s625ms 29 6m35s create table temp0000289287 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 21 11 9 2m3s 13s738ms 12 3 35s111ms 11s703ms 14 5 1m3s 12s644ms 15 12 2m53s 14s430ms [ User: intelifix - Total duration: 6m35s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 6m35s - Times executed: 29 ]
-
CREATE TABLE temp0000289287 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:42:35 Duration: 16s612ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289287 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:01:51 Duration: 16s263ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289287 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 11:49:59 Duration: 15s707ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
9 10s369ms 18s950ms 13s146ms 85 18m37s create table temp0000289297 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 21 13 35 7m19s 12s547ms 14 29 6m19s 13s82ms 15 21 4m58s 14s233ms [ User: intelifix - Total duration: 18m37s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 18m37s - Times executed: 85 ]
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 14:05:23 Duration: 18s950ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 15:25:22 Duration: 17s356ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 14:50:51 Duration: 17s151ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
10 10s644ms 14s604ms 12s907ms 10 2m9s create table temp0000289285 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 21 12 10 2m9s 12s907ms [ User: intelifix - Total duration: 2m9s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 10 ]
-
CREATE TABLE temp0000289285 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 12:07:09 Duration: 14s604ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289285 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 12:01:09 Duration: 14s582ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289285 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 12:06:28 Duration: 14s216ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
11 9s808ms 15s568ms 12s433ms 36 7m27s create table temp0000289261 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 21 08 6 1m12s 12s135ms 09 14 2m42s 11s589ms 10 16 3m32s 13s284ms [ User: intelifix - Total duration: 7m27s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 7m27s - Times executed: 36 ]
-
CREATE TABLE temp0000289261 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 10:53:57 Duration: 15s568ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289261 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 10:22:16 Duration: 15s521ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289261 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-21 10:52:37 Duration: 14s683ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
12 3s585ms 11s388ms 4s618ms 43 3m18s create table temp0000289297 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 21 13 16 1m15s 4s728ms 14 20 1m28s 4s400ms 15 7 34s946ms 4s992ms [ User: intelifix - Total duration: 3m18s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 3m18s - Times executed: 43 ]
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 13:20:39 Duration: 11s388ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 15:27:06 Duration: 7s110ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CREATE TABLE temp0000289297 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"16-08-2026", "ate" :"21-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-21 13:43:49 Duration: 5s36ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
13 225ms 48s574ms 4s33ms 138 9m16s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 21 00 5 22s925ms 4s585ms 01 6 10s272ms 1s712ms 02 6 10s772ms 1s795ms 03 5 13s125ms 2s625ms 04 6 11s636ms 1s939ms 05 3 8s647ms 2s882ms 08 8 1m13s 9s191ms 09 12 45s752ms 3s812ms 10 12 42s750ms 3s562ms 11 12 1m1s 5s152ms 12 13 43s30ms 3s310ms 13 6 13s184ms 2s197ms 14 11 1m5s 5s973ms 15 12 1m10s 5s853ms 16 9 35s329ms 3s925ms 17 5 5s314ms 1s62ms 21 5 16s995ms 3s399ms 22 2 5s635ms 2s817ms [ User: intelifix - Total duration: 9m16s - Times executed: 138 ]
[ Application: psql - Total duration: 9m16s - Times executed: 138 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 08:45:50 Duration: 48s574ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 15:15:15 Duration: 13s971ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-21 14:25:14 Duration: 12s943ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
14 173ms 3m27s 3s872ms 249 16m4s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 21 00 12 31s421ms 2s618ms 01 12 22s662ms 1s888ms 02 12 23s139ms 1s928ms 03 12 34s921ms 2s910ms 04 12 22s954ms 1s912ms 05 12 24s887ms 2s73ms 06 12 25s338ms 2s111ms 08 8 2m52s 21s524ms 09 12 35s934ms 2s994ms 10 12 29s372ms 2s447ms 11 12 31s386ms 2s615ms 12 11 27s25ms 2s456ms 13 12 28s552ms 2s379ms 14 12 34s912ms 2s909ms 15 12 3m57s 19s827ms 16 11 30s23ms 2s729ms 17 12 27s727ms 2s310ms 18 11 25s421ms 2s311ms 19 12 25s249ms 2s104ms 20 12 35s860ms 2s988ms 21 12 27s696ms 2s308ms 22 4 9s679ms 2s419ms [ User: intelifix - Total duration: 16m4s - Times executed: 249 ]
[ Application: psql - Total duration: 16m4s - Times executed: 249 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 15:18:42 Duration: 3m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 08:57:34 Duration: 2m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-21 03:05:28 Duration: 12s269ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
15 3s148ms 5s353ms 3s791ms 49 3m5s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 21 08 1 3s763ms 3s763ms 09 3 12s292ms 4s97ms 10 4 13s727ms 3s431ms 11 4 14s377ms 3s594ms 12 4 15s985ms 3s996ms 13 3 10s360ms 3s453ms 14 5 20s408ms 4s81ms 15 3 11s799ms 3s933ms 16 3 11s488ms 3s829ms 17 4 13s734ms 3s433ms 18 3 11s83ms 3s694ms 19 4 15s679ms 3s919ms 20 4 15s551ms 3s887ms 21 3 11s874ms 3s958ms 22 1 3s636ms 3s636ms [ User: intelifix - Total duration: 3m5s - Times executed: 49 ]
[ Application: psql - Total duration: 3m5s - Times executed: 49 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-21 09:20:10 Duration: 5s353ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-21 19:20:06 Duration: 4s904ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-21 14:20:10 Duration: 4s670ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
16 3s89ms 4s388ms 3s724ms 32 1m59s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 21 08 1 4s388ms 4s388ms 09 2 7s23ms 3s511ms 10 2 7s155ms 3s577ms 11 2 7s332ms 3s666ms 12 2 8s119ms 4s59ms 13 3 11s129ms 3s709ms 14 1 3s863ms 3s863ms 15 3 11s254ms 3s751ms 16 3 10s714ms 3s571ms 17 2 6s944ms 3s472ms 18 3 11s464ms 3s821ms 19 2 7s214ms 3s607ms 20 2 7s927ms 3s963ms 21 3 11s320ms 3s773ms 22 1 3s318ms 3s318ms [ User: intelifix - Total duration: 1m59s - Times executed: 32 ]
[ Application: psql - Total duration: 1m59s - Times executed: 32 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-21 08:40:05 Duration: 4s388ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-21 21:20:06 Duration: 4s294ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-21 12:20:05 Duration: 4s176ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
17 208ms 29s9ms 3s216ms 58 3m6s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 21 08 7 37s422ms 5s346ms 09 10 21s186ms 2s118ms 10 6 15s772ms 2s628ms 11 3 15s37ms 5s12ms 12 2 11s686ms 5s843ms 13 9 27s419ms 3s46ms 14 9 23s803ms 2s644ms 15 9 30s472ms 3s385ms 16 1 1s149ms 1s149ms 17 2 2s631ms 1s315ms [ User: intelifix - Total duration: 3m6s - Times executed: 58 ]
[ Application: psql - Total duration: 3m6s - Times executed: 58 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028774);
Date: 2026-08-21 08:50:16 Duration: 29s9ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028803);
Date: 2026-08-21 11:51:33 Duration: 10s811ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028841);
Date: 2026-08-21 14:22:07 Duration: 9s107ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
18 160ms 28s252ms 2s374ms 102 4m2s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 21 08 8 57s4ms 7s125ms 09 14 1m23s 5s935ms 10 8 10s126ms 1s265ms 11 5 36s113ms 7s222ms 12 7 3s242ms 463ms 13 20 6s350ms 317ms 14 22 12s489ms 567ms 15 17 19s190ms 1s128ms 16 1 14s618ms 14s618ms [ User: intelifix - Total duration: 4m2s - Times executed: 102 ]
[ Application: psql - Total duration: 4m2s - Times executed: 102 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028785);
Date: 2026-08-21 09:36:22 Duration: 28s252ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 450); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028800);
Date: 2026-08-21 11:40:47 Duration: 24s564ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028769);
Date: 2026-08-21 08:32:48 Duration: 23s627ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-21.log
19 150ms 8s949ms 1s66ms 1,407 25m select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 21 08 33 32s625ms 988ms 09 100 1m37s 972ms 10 216 2m48s 781ms 11 251 3m51s 923ms 12 49 42s364ms 864ms 13 126 2m39s 1s266ms 14 240 4m57s 1s239ms 15 242 5m2s 1s248ms 16 100 1m56s 1s162ms 17 50 52s254ms 1s45ms [ User: intelifix - Total duration: 25m - Times executed: 1407 ]
[ Application: [unknown] - Total duration: 25m - Times executed: 1407 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (279983, 433, '835169925004574,241691294056,230049002829,241732830007,241619826385,241693026267,241661050005,241694830305,241595796980,241637436173,230049001112,241700746886,241693217879,241697053754,241596233948,241653319710,241702194143,241673160121,241714240011,241700693043,241607379817,241712204054,241605092647,230048042646,241653842949,241730546472,241617933148,241714021628,241620659609,241646144756,241669517676,241699260513,241645491831,230048051940,241698574957,241703752848', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-21 13:52:54 Duration: 8s949ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54265, 406, '835116917000153,241672181327,241704179006,241695613849,241622508802,241604296979,241679914449,241692559903,241712756767,241714078300,241732158593,241631622026,241618244547,241680317800,241689110207,241599303148,241649479313,241704178501,241729493957,241713719903,241712978204,241656774963,230048439407,241646309597,241689120006,241680476681,230048441731,230048996060,241669621425,241711246272,241727467901,241599315472,241658691133,241689122531,241700934054,241656807693,241712549901,241693229800,241680399401,241689152534,241620824552,230048474562,241620801823,241659743547,241712509112,241728709806,241700953046,241637734463,241638308693,241704377487,241712550104', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-21 15:18:02 Duration: 7s535ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54219, 406, '270911029165100340,229734785979,229739799712,229786692942,229864845967,229816607286,229753045662,229865215981,229741468809,229668523048,229670039705,229737329213,229756099507,229673502030,216937393940,229817186366,229669691131,229668002436,216939742026,229837120625,229781167789,229786788810,229736139815,229805865576,229726275777,229782887272,229812804244,216944850011,229670102338,229816963842,229691638995,229747803445,229671602125,229860217277,229786384651,229742929501,229785031321,229812866674,229743082850,216943472233,229739950513,216939785262,229746158996,216944728910,216945205353,229687847997,229879748285,229752596471,229740264864,229661296270,229783351213', '246543061523,246527561537,246598221216,246651723553,246628305072,246563065461,246648800709,246569561629,246514762633,246515449096,246548867689,246559318383,246501722842,246474639514,246630840404,246515870710,246467586670,246464381319,246640079801,246588501435,246598586178,246529594664,246595793549,246507145559,246597874459,246629648098,246498161013,246515156060,246627220410,246506994658,246558124867,246518436268,246651594045,246597416075,246549004347,246583708990,246627978800,246544147677,246472764561,246568932544,246476999800,246548340714,246456915977,246487885666,246516952140,246652922020,246633364971,246523996979,246465179511,246586112234', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-21 11:46:39 Duration: 7s404ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
20 152ms 5s142ms 893ms 96 1m25s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 21 06 1 1s939ms 1s939ms 08 18 8s63ms 447ms 09 13 4s568ms 351ms 10 2 5s737ms 2s868ms 11 2 6s791ms 3s395ms 12 3 5s495ms 1s831ms 13 23 13s298ms 578ms 14 11 7s646ms 695ms 15 21 28s349ms 1s349ms 16 2 3s916ms 1s958ms [ User: intelifix - Total duration: 1m25s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 1m25s - Times executed: 96 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133420) LIMIT 1;
Date: 2026-08-21 15:25:09 Duration: 5s142ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133429) LIMIT 1;
Date: 2026-08-21 15:06:51 Duration: 4s714ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0132789) LIMIT 1;
Date: 2026-08-21 15:38:56 Duration: 4s242ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 21 12 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 24s145ms - Times executed: 2 ]
[ Application: psql - Total duration: 23s686ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 458ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,353 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 33 FATAL entries
- 4015 ERROR entries
- 0 WARNING entries
- 14 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,924 Max number of times the same event was reported
- 4,062 Total events found
Rank Times reported Error 1 3,924 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 21 00 115 01 110 02 64 03 110 04 103 05 72 06 59 07 8 08 178 09 443 10 474 11 415 12 165 13 251 14 347 15 385 16 193 17 149 18 59 19 59 20 60 21 59 22 46 - ERROR: prepared statement "_PLAN000000002A5BC060" does not exist
- ERROR: prepared statement "_PLAN0000000029A0E580" does not exist
- ERROR: prepared statement "_PLAN000000002A5B9BE0" does not exist
Statement: DEALLOCATE "_PLAN000000002A5BC060"
Date: 2026-08-21 00:00:31 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: DEALLOCATE "_PLAN0000000029A0E580"
Date: 2026-08-21 00:00:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: DEALLOCATE "_PLAN000000002A5B9BE0"
Date: 2026-08-21 00:01:35 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
2 55 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 21 08 3 11 2 12 43 13 4 14 1 16 2 - ERROR: syntax error at or near ";" at character 22
- ERROR: syntax error at or near "AS" at character 23
- ERROR: syntax error at or near "WHERE" at character 16
Statement: DROP TABLE IF EXISTS ;
Date: 2026-08-21 08:21:37 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: CREATE TABLE AS SELECT * FROM RS_LOTES_SAIDA_LISTA( '{ "id" : "", "oficina" : "6", "cliente" : "5", "nf" : "", "data-de" : "16-08-2026", "data-ate" : "21-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }' )
Date: 2026-08-21 08:21:37 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: SELECT * FROM WHERE CONTROLE='L'
Date: 2026-08-21 08:21:37 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
3 19 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 21 00 2 01 2 02 2 03 2 04 2 05 2 06 2 08 1 09 2 10 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-21 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-21 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-21 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
4 15 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 21 00 1 01 1 04 2 06 2 10 1 11 2 15 1 16 1 22 4 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-21 00:02:33 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 01:36:38 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 04:05:54 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
5 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 21 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-21 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
6 8 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 21 08 3 15 5 - LOG: process 12981 still waiting for ShareLock on transaction 4810252 after 1000.064 ms
- LOG: process 12981 still waiting for ShareLock on transaction 4810252 after 6442.990 ms
- LOG: process 12981 still waiting for ShareLock on transaction 4810252 after 46411.102 ms
Detail: Process holding the lock: 13023. Wait queue: 12981.
Context: while updating tuple (77259,78) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-21 08:55:09 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Detail: Process holding the lock: 13023. Wait queue: 12981.
Context: while updating tuple (77259,78) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-21 08:55:14 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Detail: Process holding the lock: 13023. Wait queue: 12981.
Context: while updating tuple (77259,78) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-21 08:55:54 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
7 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 21 05 4 16 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-21 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-21 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-21 05:32:09 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
8 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 21 13 4 - ERROR: column "undefined" does not exist at character 36
- ERROR: column "undefined" does not exist at character 37
- ERROR: column "v" does not exist at character 27
Statement: SELECT * FROM RS_MODELO_COMPATIVEL(undefined,00);
Date: 2026-08-21 13:37:07 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: SELECT * FROM RS_MODELO_PRINT_SAIDA(undefined);
Date: 2026-08-21 13:37:07 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: select * from rs_caixa_qr(V)
Date: 2026-08-21 13:45:16 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
9 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 21 08 2 13 1 - ERROR: trailing junk after numeric literal at or near "345840F8A906" at character 27
- ERROR: trailing junk after numeric literal at or near "345840F8A906" at character 27
- ERROR: trailing junk after numeric literal at or near "0undefined" at character 58
Statement: select * from rs_caixa_qr(345840F8A906)
Date: 2026-08-21 08:44:44 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: select * from rs_caixa_qr(345840F8A906)
Date: 2026-08-21 08:44:45 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Statement: SELECT * FROM RS_MODELOS_LISTA(NULL,NULL) WHERE MOD_ID = 0undefined
Date: 2026-08-21 13:37:07 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
10 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 21 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-21 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
11 2 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 21 11 2 - FATAL: connection to client lost
- FATAL: connection to client lost
Context: PL/pgSQL function rs_pre_alerta(integer,character varying[],boolean) line 208 at RAISE PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 837 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028798, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-21 11:00:31 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 11:01:03 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
12 2 ERROR: query string argument of EXECUTE is null
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 21 13 2 - ERROR: query string argument of EXECUTE is null
- ERROR: query string argument of EXECUTE is null
Context: PL/pgSQL function rs_lote_saida_manutencao_itens(character varying) line 785 at EXECUTE
Statement: SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS('{ "lote" : "133990", "modelo" : "299", "itens" : "24E4CE8C6508", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');Date: 2026-08-21 13:37:06 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Context: PL/pgSQL function rs_lote_saida_manutencao_itens(character varying) line 785 at EXECUTE
Statement: SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS('{ "lote" : "133990", "modelo" : "299", "itens" : "24E4CE8C6508", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');Date: 2026-08-21 13:37:06 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
13 2 FATAL: database "..." does not exist NOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 21 11 1 13 1 - FATAL: database "jaboatao" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
- FATAL: database "jaboatao" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-08-21 11:51:19 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 13:23:39 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
14 2 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 21 11 2 - LOG: could not send data to client: Broken pipe
- LOG: could not send data to client: Broken pipe
Context: PL/pgSQL function rs_pre_alerta(integer,character varying[],boolean) line 208 at RAISE PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 837 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028798, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-21 11:00:31 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
Date: 2026-08-21 11:01:03 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
15 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 21 15 1 - LOG: process 467034 still waiting for AccessExclusiveLock on relation 4148015 of database 358220 after 1000.190 ms
Detail: Process holding the lock: 483425. Wait queue: 467034.
Statement: DROP TABLE IF EXISTS temp0000289287;Date: 2026-08-21 15:01:34 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
16 1 LOG: database system was interrupted; last known up at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 21 08 1 - LOG: database system was interrupted; last known up at 2026-08-21 06:09:34 -03
Date: 2026-08-21 08:20:14 Log file: /usr/local/pgsql/data/log/serverlog-21.log
17 1 FATAL: the database system is not yet accepting connections
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 21 08 1 - FATAL: the database system is not yet accepting connections
Detail: Consistent recovery state has not been yet reached.
Date: 2026-08-21 08:20:16 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
18 1 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #18
Day Hour Count Aug 21 15 1 - ERROR: update or delete on table "lotes" violates foreign key constraint "ref_lote_itens_to_lotes" on table "lote_itens"
Detail: Key (lot_id)=(280542) is still referenced from table "lote_itens".
Context: SQL statement "DELETE FROM LOTES WHERE LOT_ID = nLote" PL/pgSQL function rs_lote_exclui(integer) line 100 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0280542);Date: 2026-08-21 15:18:40 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-21.log
19 1 LOG: database system was not properly shut down; automatic recovery in progress
Times Reported Most Frequent Error / Event #19
Day Hour Count Aug 21 08 1 - LOG: database system was not properly shut down; automatic recovery in progress
Date: 2026-08-21 08:20:16 Log file: /usr/local/pgsql/data/log/serverlog-21.log
20 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #20
Day Hour Count Aug 21 03 1 - LOG: database system was shut down at 2026-08-21 03:05:01 -03
Date: 2026-08-21 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-21.log
21 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #21
Day Hour Count Aug 21 15 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000289287"
Date: 2026-08-21 15:01:34 Log file: /usr/local/pgsql/data/log/serverlog-21.log