pgBadger-
Global information
- Generated on Thu Jul 9 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 49,797 log entries in 10s
- Log start from 2026-07-08 00:00:09 to 2026-07-08 23:59:03
-
Overview
Global Stats
- 429 Number of unique normalized queries
- 7,252 Number of queries
- 9h25m5s Total query duration
- 2026-07-08 00:02:06 First query
- 2026-07-08 23:55:39 Last query
- 5 queries/s at 2026-07-08 11:38:26 Query peak
- 9h25m5s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h25m5s Execute total duration
- 4,598 Number of events
- 16 Number of unique normalized events
- 4,450 Max number of times the same event was reported
- 0 Number of cancellation
- 609 Total number of automatic vacuums
- 1,217 Total number of automatic analyzes
- 20 Number temporary file
- 233.94 MiB Max size of temporary file
- 141.48 MiB Average size of temporary file
- 378 Total number of sessions
- 9 sessions at 2026-07-08 16:51:52 Session peak
- 14d17h48m59s Total duration of sessions
- 56m9s Average duration of sessions
- 19 Average queries per session
- 1m29s Average queries duration per session
- 54m39s Average idle time per session
- 385 Total number of connections
- 5 connections/s at 2026-07-08 00:05:01 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-08 11:38:26 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-08 14:35:50 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-08 23:55:24 Date
Queries duration
Key values
- 9h25m5s 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) Jul 08 00 22 0ms 18s455ms 4s949ms 5s310ms 6s5ms 1m15s 01 18 0ms 4s690ms 1s982ms 4s468ms 5s987ms 6s590ms 02 12 0ms 4s617ms 2s564ms 4s35ms 5s137ms 6s58ms 03 15 0ms 4s614ms 2s267ms 4s893ms 5s690ms 7s771ms 04 19 0ms 3s873ms 1s680ms 3s466ms 5s82ms 5s814ms 05 41 0ms 8m44s 26s510ms 7s361ms 2m30s 8m45s 06 18 0ms 9s30ms 3s636ms 3s932ms 6s369ms 29s797ms 07 190 0ms 7m32s 10s488ms 56s790ms 4m3s 12m16s 08 574 150ms 7m1s 2s567ms 35s268ms 43s807ms 7m50s 09 855 150ms 9m12s 3s392ms 1m19s 5m38s 9m20s 10 754 150ms 9m19s 4s310ms 2m35s 6m28s 9m32s 11 763 150ms 8m37s 3s452ms 1m19s 4m42s 8m52s 12 269 0ms 7m37s 6s253ms 34s983ms 4m12s 7m44s 13 461 150ms 6m12s 2s746ms 22s271ms 2m6s 6m47s 14 910 150ms 8m19s 3s635ms 2m28s 5m1s 8m23s 15 889 150ms 9m4s 3s862ms 3m51s 5m40s 9m56s 16 549 150ms 8m34s 4s174ms 44s273ms 5m56s 10m9s 17 388 0ms 8m28s 4s815ms 45s99ms 4m25s 8m29s 18 42 0ms 6m53s 17s926ms 10s359ms 45s20ms 6m53s 19 21 0ms 5m36s 28s847ms 5s20ms 46s227ms 5m36s 20 114 0ms 5m57s 10s509ms 54s828ms 1m37s 6m54s 21 34 0ms 5m42s 18s512ms 6s888ms 45s528ms 5m42s 22 27 0ms 7m17s 29s216ms 7s467ms 1m12s 7m17s 23 267 0ms 2m9s 9s120ms 1m9s 1m57s 2m9s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 08 00 4 0 1s594ms 0ms 0ms 155ms 01 4 0 373ms 0ms 0ms 230ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 223ms 0ms 0ms 0ms 04 7 0 326ms 0ms 0ms 925ms 05 24 0 230ms 163ms 293ms 567ms 06 5 0 1s507ms 0ms 0ms 1s166ms 07 125 0 13s251ms 3s681ms 18s690ms 4m21s 08 433 0 2s711ms 17s642ms 24s19ms 4m15s 09 700 0 3s264ms 14s905ms 51s851ms 6m23s 10 605 0 4s198ms 12s999ms 1m42s 6m33s 11 555 0 3s788ms 16s60ms 1m14s 5m9s 12 188 0 7s707ms 5s717ms 20s606ms 4m29s 13 296 0 3s724ms 7s947ms 14s688ms 3m51s 14 674 0 3s827ms 26s417ms 2m7s 7m33s 15 680 0 4s191ms 16s98ms 3m51s 8m24s 16 394 0 4s996ms 7s939ms 17s801ms 8m32s 17 256 0 5s713ms 12s498ms 25s591ms 5m22s 18 25 0 28s820ms 0ms 10s359ms 3m32s 19 6 0 1m35s 0ms 0ms 3m9s 20 9 90 11s683ms 18s361ms 56s991ms 3m20s 21 15 0 39s161ms 0ms 978ms 3m15s 22 6 0 2m3s 0ms 0ms 3m53s 23 6 261 9s120ms 1m4s 1m9s 2m4s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 08 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 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 Jul 08 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 7 7.00 0.00% 08 0 21 21.00 0.00% 09 0 18 18.00 0.00% 10 0 16 16.00 0.00% 11 0 11 11.00 0.00% 12 0 6 6.00 0.00% 13 0 11 11.00 0.00% 14 0 19 19.00 0.00% 15 0 14 14.00 0.00% 16 0 11 11.00 0.00% 17 0 6 6.00 0.00% 18 0 2 2.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 08 00 17 0.00/s 01 11 0.00/s 02 9 0.00/s 03 17 0.00/s 04 11 0.00/s 05 9 0.00/s 06 17 0.00/s 07 15 0.00/s 08 24 0.01/s 09 26 0.01/s 10 23 0.01/s 11 18 0.01/s 12 18 0.01/s 13 20 0.01/s 14 26 0.01/s 15 23 0.01/s 16 23 0.01/s 17 13 0.00/s 18 13 0.00/s 19 10 0.00/s 20 12 0.00/s 21 12 0.00/s 22 11 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jul 08 00 4 1h 59m33s 01 16 1h1m7s 1h1m5s 02 11 1h17s 1h14s 03 17 20m52s 20m50s 04 9 1h4m 1h3m56s 05 11 1h33s 58m54s 06 9 57m13s 57m6s 07 17 57m43s 55m46s 08 17 54m24s 52m57s 09 26 51m20s 49m29s 10 23 56m27s 54m6s 11 24 51m56s 50m6s 12 15 55m58s 54m6s 13 16 55m58s 54m39s 14 23 56m9s 53m45s 15 26 55m51s 53m39s 16 20 52m12s 50m18s 17 20 57m55s 56m22s 18 14 1h42m48s 1h41m54s 19 12 1h43s 59m53s 20 14 52m56s 51m30s 21 10 55m 53m57s 22 12 56m5s 54m59s 23 12 52m56s 49m33s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-08 00:05:01 Date
Connections per database
Key values
- rio Main Database
- 385 connections Total
Connections per user
Key values
- intelifix Main User
- 385 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-07-08 16:51:52 Date
Histogram of session times
Key values
- 309 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 378 sessions Total
Sessions per user
Key values
- intelifix Main User
- 378 sessions Total
Sessions per host
Key values
- [local] Main Host
- 378 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 378 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,867 buffers Checkpoint Peak
- 2026-07-08 10:44:36 Date
- 270.012 seconds Highest write time
- 0.122 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-07-08 17:39:37 Date
Checkpoints distance
Key values
- 294.42 Mo Distance Peak
- 2026-07-08 10:59:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 08 00 18,796 666.017s 0.033s 666.111s 01 1,833 184.173s 0.028s 184.241s 02 1,331 133.818s 0.025s 133.877s 03 1,568 156.753s 0.038s 156.836s 04 2,292 230.158s 0.024s 230.229s 05 10,386 996.198s 0.124s 996.396s 06 6,763 538.933s 0.017s 538.981s 07 31,831 2,312.632s 0.214s 2,312.983s 08 53,886 3,057.94s 0.536s 3,058.679s 09 83,717 3,238.636s 0.719s 3,239.637s 10 81,535 3,238.803s 0.609s 3,239.695s 11 79,441 3,238.823s 0.666s 3,239.736s 12 46,366 2,821.004s 0.288s 2,821.446s 13 26,856 2,519.804s 0.46s 2,520.44s 14 87,116 3,238.629s 0.858s 3,239.757s 15 76,953 3,238.512s 0.791s 3,239.608s 16 38,158 3,079.023s 0.504s 3,079.723s 17 50,500 2,391.948s 0.327s 2,392.447s 18 2,251 226.876s 0.034s 226.956s 19 23 2.333s 0.004s 2.344s 20 1,154 178.828s 0.019s 178.878s 21 2,659 267.791s 0.046s 267.923s 22 2,119 212.871s 0.094s 213.023s 23 1,086 108.755s 0.016s 108.809s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 08 00 0 0 6 549 0.003s 0.006s 01 0 0 1 406 0.003s 0.006s 02 0 0 0 336 0.003s 0.005s 03 0 0 1 355 0.003s 0.007s 04 0 0 0 416 0.003s 0.006s 05 0 0 5 1,054 0.023s 0.009s 06 0 0 1 218 0.002s 0.004s 07 0 0 21 2,575 0.005s 0.012s 08 0 0 26 5,810 0.013s 0.012s 09 0 0 57 7,702 0.004s 0.012s 10 0 0 57 6,785 0.004s 0.012s 11 0 0 49 7,262 0.007s 0.012s 12 0 0 27 4,325 0.026s 0.012s 13 0 0 13 5,151 0.005s 0.012s 14 0 0 57 7,830 0.015s 0.012s 15 0 0 58 7,476 0.006s 0.012s 16 0 0 22 6,219 0.007s 0.012s 17 0 0 35 4,481 0.004s 0.012s 18 0 0 0 374 0.003s 0.007s 19 0 0 0 5 0.003s 0.001s 20 0 0 1 94 0.002s 0.003s 21 0 0 1 370 0.014s 0.022s 22 0 0 1 409 0.025s 0.007s 23 0 0 1 38 0.003s 0.004s Day Hour Count Avg time (sec) Jul 08 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 08 00 17,116.67 kB 52,791.83 kB 01 1,631.50 kB 33,521.83 kB 02 1,381.80 kB 19,340.00 kB 03 1,295.71 kB 3,572.71 kB 04 1,755.83 kB 2,497.83 kB 05 7,955.22 kB 16,067.78 kB 06 5,220.25 kB 12,450.75 kB 07 29,245.58 kB 60,907.17 kB 08 35,017.33 kB 64,458.92 kB 09 78,125.92 kB 110,339.50 kB 10 77,401.75 kB 110,173.00 kB 11 67,238.08 kB 118,512.67 kB 12 35,961.00 kB 76,122.33 kB 13 18,117.33 kB 43,171.75 kB 14 78,196.25 kB 100,780.08 kB 15 78,919.67 kB 124,407.92 kB 16 30,228.08 kB 76,231.75 kB 17 47,546.58 kB 95,145.08 kB 18 1,175.71 kB 70,720.86 kB 19 174.00 kB 45,530.00 kB 20 5,024.67 kB 38,218.00 kB 21 1,769.88 kB 22,674.88 kB 22 1,670.29 kB 11,197.86 kB 23 5,435.00 kB 11,688.25 kB -
Temporary Files
Size of temporary files
Key values
- 467.88 MiB Temp Files size Peak
- 2026-07-08 05:32:04 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-08 05:30:39 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 08 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.75 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 2 364.01 MiB 182.00 MiB 14 6 1.07 GiB 182.01 MiB 15 1 182.00 MiB 182.00 MiB 16 0 0 0 17 1 104.00 MiB 104.00 MiB 18 0 0 0 19 0 0 0 20 0 0 0 21 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 9 1.60 GiB 182.00 MiB 182.02 MiB 182.01 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01508);
Date: 2026-07-08 14:51:54 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01510);
Date: 2026-07-08 15:34:06 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01506);
Date: 2026-07-08 14:36:00 Duration: 1m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 8 908.67 MiB 69.78 MiB 233.94 MiB 113.58 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-08 05:32:13 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-08 05:32:04 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 178.84 MiB 89.42 MiB 89.42 MiB 89.42 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-08 05:30:43 Duration: 41s745ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-08 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-08 16:14:13 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026797, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');
Date: 2026-07-08 14:43:03 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026779, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-08 10:58:17 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Queries generating the largest temporary files
Rank Size Query 1 233.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 233.94 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01507);[ Date: 2026-07-08 14:44:15 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01506);[ Date: 2026-07-08 14:35:56 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01508);[ Date: 2026-07-08 14:51:50 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01509);[ Date: 2026-07-08 14:54:28 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01505);[ Date: 2026-07-08 14:21:14 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
8 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01504);[ Date: 2026-07-08 14:04:32 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
9 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01503);[ Date: 2026-07-08 13:55:09 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
10 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01510);[ Date: 2026-07-08 15:34:05 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
11 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01502);[ Date: 2026-07-08 13:48:48 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-08 17:18:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 89.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-08 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 89.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-08 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 77.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 77.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 77.10 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 69.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 69.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 69.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-08 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 11.67 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-08 15:13:58 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 11.67 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-08 15:13:58 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (111) Main table analyzed (database rio)
- 1,217 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 111 rio.public.temp0000284836 85 rio.pg_catalog.pg_class 59 brasilia.pg_catalog.pg_attribute 55 rio.pg_catalog.pg_type 53 rio.public.temp0000284756 51 rio.public.usuarios 48 rio.public.temp0000284782 42 rio.pg_catalog.pg_index 33 contagem.public.temp0000226520 32 brasilia.pg_catalog.pg_class 31 contagem.pg_catalog.pg_attribute 27 brasilia.pg_catalog.pg_type 27 rio.pg_catalog.pg_depend 27 contagem.public.temp0000226575 26 rio.public.temp0000284764 23 rio.public.temp0000284780 21 brasilia.pg_catalog.pg_index 19 rio.public.temp0000284754 18 brasilia.pg_catalog.pg_depend 17 contagem.public.usuarios 16 contagem.pg_catalog.pg_class 15 contagem.public.temp0000226577 15 rio.public.temp0000284832 15 rio.public.temp0000284786 15 rio.public.temp0000284828 15 rio.public.temp0000284784 13 contagem.pg_catalog.pg_type 13 brasilia.public.temp0000235622 12 rio.public.temp0000284750 11 rio.public.temp0000284752 11 rio.public.temp0000284758 11 brasilia.public.temp0000235602 11 brasilia.public.usuarios 10 brasilia.public.temp0000235560 10 rio.public.temp0000284664 10 contagem.pg_catalog.pg_index 9 rio.public.temp0000284798 9 rio.public.temp0000284556 8 rio.public.temp0000284768 8 brasilia.public.temp0000235632 7 contagem.pg_catalog.pg_depend 7 brasilia.public.temp0000235570 7 rio.public.temp0000284762 7 brasilia.public.temp0000235644 6 brasilia.public.temp0000235676 6 contagem.public.nf_entrada 6 rio.public.temp0000284856 6 rio.public.temp0000284840 6 rio.public.tmp_drill_0302 5 brasilia.public.nf_entrada 5 template1.pg_catalog.pg_shdepend 5 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000284854 5 brasilia.public.temp0000235684 4 rio.public.temp0000284778 4 rio.public.temp0000284876 4 brasilia.public.temp0000235650 4 brasilia.public.temp0000235592 3 contagem.public.temp0000226579 3 postgres.pg_catalog.pg_shdepend 3 brasilia.public.temp0000235584 3 rio.public.temp0000284802 3 rio.public.tmp_drill_0175 3 rio.public.temp0000284818 3 brasilia.public.temp0000235606 3 brasilia.public.temp0000235672 3 brasilia.public.temp0000235564 2 rio.public.temp0000284774 2 rio.public.temp0000284730 2 brasilia.public.temp0000235610 2 brasilia.public.temp0000235680 2 contagem.public.temp0000226553 2 rio.public.temp0000284624 2 brasilia.public.temp0000235554 2 rio.public.temp0000284864 1 brasilia.public.temp0000235574 1 rio.auditor.auditor_2026_07 1 rio.public.temp0000284788 1 rio.public.temp0000284776 1 contagem.pg_catalog.pg_shdepend 1 rio.public.temp0000284872 1 brasilia.public.temp0000235594 1 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000284870 1 brasilia.public.temp0000235556 1 brasilia.public.temp0000235668 1 brasilia.public.temp0000235688 1 rio.public.temp0000284760 1 brasilia.public.temp0000235568 1 contagem.auditor.auditor_2026_07 1 rio.public.temp0000284800 1 rio.public.temp0000284790 1 brasilia.public.temp0000235634 1 brasilia.public.temp0000235608 1 rio.public.temp0000284842 1 brasilia.auditor.auditor_2026_07 1 brasilia.public.temp0000235572 1 rio.public.temp0000284772 1 rio.public.temp0000284810 1 brasilia.public.temp0000235642 1 rio.public.temp0000284808 1 brasilia.public.temp0000235660 1 brasilia.public.temp0000235562 1 rio.public.temp0000284812 1 brasilia.public.temp0000235558 1 rio.public.temp0000284824 1 brasilia.public.temp0000235636 1 Total 1,217 Vacuums per table
Key values
- public.temp0000284836 (66) Main table vacuumed on database rio
- 609 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.temp0000284836 66 0 0 0 0 0 0 14,383 696 1,482,949 0 0 rio.public.temp0000284756 52 0 0 0 0 0 0 47,716 241 2,853,134 0 0 rio.pg_catalog.pg_attribute 46 41 0 0 0 0 0 22,780 5,845 8,557,746 367 9,495 rio.public.temp0000284782 40 0 0 0 0 0 0 44,379 1,785 4,738,254 0 0 rio.pg_catalog.pg_class 32 26 0 0 0 0 0 5,220 1,498 2,183,473 85 318 rio.pg_catalog.pg_type 28 23 0 0 0 0 0 2,248 658 850,816 79 298 brasilia.pg_catalog.pg_attribute 21 21 0 0 0 0 0 11,667 2,553 4,406,369 97 2,473 rio.pg_catalog.pg_index 20 15 0 0 0 0 0 882 229 235,864 44 119 contagem.public.usuarios 17 0 0 0 0 0 0 78 58 30,952 0 0 rio.public.temp0000284832 15 0 0 0 0 0 0 740 82 56,683 0 0 contagem.public.temp0000226577 15 0 0 0 0 0 0 1,061 179 233,919 0 0 brasilia.pg_catalog.pg_type 14 14 0 0 0 0 0 1,234 283 410,710 25 186 brasilia.pg_catalog.pg_class 14 14 0 0 0 0 0 2,749 633 1,162,837 34 151 rio.public.temp0000284828 12 0 0 0 0 0 0 997 152 204,982 0 0 contagem.pg_catalog.pg_attribute 12 12 0 0 0 0 0 6,406 1,640 2,937,778 23 584 rio.public.tmp_drill_0302 10 5 0 0 0 0 0 545 77 175,517 1 22 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,765 1,411 2,067,941 91 698 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 12,815 3,055 14,217,510 1,290 4,868 rio.public.temp0000284798 8 0 0 0 0 0 0 432 232 345,648 0 0 rio.public.temp0000284664 8 0 0 0 0 0 0 680 164 256,477 0 0 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,345 295 463,082 4 48 brasilia.pg_catalog.pg_index 8 8 0 0 0 0 0 404 93 91,076 21 45 rio.public.temp0000284784 7 0 0 0 0 0 0 199 36 17,894 0 0 template1.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,193 426 854,882 93 353 contagem.public.temp0000226575 7 0 0 0 0 0 0 435 39 32,120 0 0 rio.public.usuarios 7 3 0 0 0 0 0 86 38 60,751 2 2 rio.public.temp0000284762 6 0 0 0 0 0 0 274 31 21,049 0 0 brasilia.public.temp0000235570 6 0 0 0 0 0 0 1,434 268 453,724 0 0 brasilia.public.temp0000235676 6 0 0 0 0 0 0 1,436 267 451,964 0 0 brasilia.pg_catalog.pg_depend 6 6 0 0 0 0 0 2,060 611 922,879 14 214 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 514 125 205,925 1 2 rio.public.temp0000284856 5 0 0 0 0 0 0 4,930 19 295,711 0 0 rio.public.temp0000284556 5 0 0 0 0 0 0 376 160 258,507 0 0 rio.public.temp0000284750 5 0 0 0 0 0 0 172 24 13,813 0 0 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,932 869 3,664,778 452 3,018 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 218 75 75,886 4 4 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,131 430 2,386,531 157 480 rio.public.temp0000284854 3 0 0 0 0 0 0 247 17 17,424 0 0 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 501 97 425,241 35 77 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,828 1,177 4,039,851 896 5,772 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 801 223 473,658 2 33 rio.public.temp0000284876 3 0 0 0 0 0 0 4,920 12 292,089 0 0 contagem.public.temp0000226579 3 0 0 0 0 0 0 118 16 9,627 0 0 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 1,351 9 231,541 0 0 rio.public.temp0000284840 3 0 0 0 0 0 0 3,394 14 202,422 0 0 rio.public.temp0000284818 3 0 0 0 0 0 0 3,279 11 195,205 0 0 brasilia.public.temp0000235584 2 0 0 0 0 0 0 478 12 30,466 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 293 71 257,269 21 47 rio.public.temp0000284774 2 0 0 0 0 0 0 3,274 8 194,372 0 0 rio.public.temp0000284730 2 0 0 0 0 0 0 3,274 8 194,372 0 0 rio.auditor.auditor_2026_07 2 0 0 0 0 0 0 131,735 62,328 81,984,591 34,713 690,999 rio.public.temp0000284778 2 0 0 0 0 0 0 1,648 9 98,690 0 0 rio.public.temp0000284812 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000235556 1 0 0 0 0 0 0 239 6 15,238 0 0 brasilia.public.temp0000235688 1 0 0 0 0 0 0 239 6 15,235 0 0 rio.public.temp0000284824 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000284776 1 0 0 0 0 0 0 99 6 6,780 0 0 rio.public.temp0000284788 1 0 0 0 0 0 0 99 6 6,779 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 117 57 83,736 4 11 rio.public.temp0000284872 1 0 0 0 0 0 0 120 6 8,060 0 0 brasilia.public.temp0000235642 1 0 0 0 0 0 0 239 238 377,580 0 0 rio.public.temp0000284786 1 0 0 0 0 0 0 62 6 4,503 0 0 brasilia.public.temp0000235680 1 0 0 0 0 0 0 239 237 375,591 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 144 76 241,100 22 1,200 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 168 50 114,309 2 2 brasilia.public.temp0000235610 1 0 0 0 0 0 0 239 238 376,181 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 10,761 6,808 8,821,375 1,960 44,312 brasilia.public.temp0000235634 1 0 0 0 0 0 0 239 238 375,969 0 0 rio.public.temp0000284800 1 0 0 0 0 0 0 99 6 6,779 0 0 rio.public.temp0000284790 1 0 0 0 0 0 0 1,637 4 97,186 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 145 71 145,440 6 8 rio.public.temp0000284842 1 0 0 0 0 0 0 114 6 7,694 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 11,019 9,582 11,830,048 569 8,256 Total 609 256 0 0 0 0 0 388,083 106,942 169,238,080 41,114 774,095 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (20.95) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000284836 0 0 1.45 rio.public.temp0000284756 0 0 1.94 rio.pg_catalog.pg_attribute 0 0 3.29 rio.public.temp0000284782 0 0 2.09 rio.pg_catalog.pg_class 0 0 0.87 rio.pg_catalog.pg_type 0 0 0.34 brasilia.pg_catalog.pg_attribute 0 0 1.45 rio.pg_catalog.pg_index 0 0 0.11 contagem.public.usuarios 0 0 0 rio.public.temp0000284832 0 0 0.28 contagem.public.temp0000226577 0 0 0.27 brasilia.pg_catalog.pg_type 0 0 0.22 brasilia.pg_catalog.pg_class 0 0 0.31 rio.public.temp0000284828 0 0 0.21 contagem.pg_catalog.pg_attribute 0 0 0.99 rio.public.tmp_drill_0302 0 0 0.04 rio.pg_catalog.pg_depend 0 0 0.79 rio.pg_catalog.pg_statistic 0 0 1.56 rio.public.temp0000284798 0 0 0.14 rio.public.temp0000284664 0 0 0.1 contagem.pg_catalog.pg_class 0 0 0.28 brasilia.pg_catalog.pg_index 0 0 0.06 rio.public.temp0000284784 0 0 0.14 template1.pg_catalog.pg_shdepend 0 0 0.22 contagem.public.temp0000226575 0 0 0.11 rio.public.usuarios 0 0 0 rio.public.temp0000284762 0 0 0.1 brasilia.public.temp0000235570 0 0 0.12 brasilia.public.temp0000235676 0 0 0.13 brasilia.pg_catalog.pg_depend 0 0 0.35 contagem.pg_catalog.pg_type 0 0 0.11 rio.public.temp0000284856 0 0 0.25 rio.public.temp0000284556 0 0 0.1 rio.public.temp0000284750 0 0 0.06 brasilia.pg_catalog.pg_statistic 0 0 0.53 contagem.pg_catalog.pg_index 0 0 0.16 rio.pg_toast.pg_toast_2619 0 0 0.23 rio.public.temp0000284854 0 0 0.06 brasilia.pg_toast.pg_toast_2619 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.39 contagem.pg_catalog.pg_depend 0 0 0.17 rio.public.temp0000284876 0 0 0.15 contagem.public.temp0000226579 0 0 0.06 rio.public.tmp_drill_0175 0 0 0.05 rio.public.temp0000284840 0 0 0.12 rio.public.temp0000284818 0 0 0.17 brasilia.public.temp0000235584 0 0 0.05 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000284774 0 0 0.11 rio.public.temp0000284730 0 0 0.1 rio.auditor.auditor_2026_07 0 0 20.95 rio.public.temp0000284778 0 0 0.07 rio.public.temp0000284812 0 0 0.05 brasilia.public.temp0000235556 0 0 0.03 brasilia.public.temp0000235688 0 0 0.02 rio.public.temp0000284824 0 0 0.05 rio.public.temp0000284776 0 0 0.02 rio.public.temp0000284788 0 0 0.02 contagem.public.nf_entrada 0 0 0.04 rio.public.temp0000284872 0 0 0.02 brasilia.public.temp0000235642 0 0 0.02 rio.public.temp0000284786 0 0 0.02 brasilia.public.temp0000235680 0 0 0.03 brasilia.public.nf_entrada_arquivo_erros 0 0 0.06 rio.pg_catalog.pg_shdepend 0 0 0.03 brasilia.public.temp0000235610 0 0 0.02 contagem.auditor.auditor_2026_07 0 0 2.42 brasilia.public.temp0000235634 0 0 0.03 rio.public.temp0000284800 0 0 0.02 rio.public.temp0000284790 0 0 0.05 brasilia.public.nf_entrada 0 0 0.05 rio.public.temp0000284842 0 0 0.02 brasilia.auditor.auditor_2026_07 0 0 3.13 Total 0 0 48.07 Tuples removed per table
Key values
- pg_catalog.pg_attribute (178431) Main table with removed tuples on database rio
- 444664 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 46 41 178,431 1,153,818 86,397 225 29,340 brasilia.pg_catalog.pg_attribute 21 21 102,681 469,479 312 30 12,111 contagem.pg_catalog.pg_attribute 12 12 41,875 283,671 972 89 6,281 rio.public.tmp_drill_0175 3 3 19,672 20,398 0 0 512 rio.pg_catalog.pg_statistic 9 9 15,572 75,741 63 0 11,574 rio.pg_catalog.pg_depend 10 10 12,118 194,907 4,746 13 1,903 rio.pg_catalog.pg_type 28 23 8,633 71,250 7,304 21 2,050 brasilia.pg_catalog.pg_statistic 4 4 8,022 33,096 0 0 4,288 contagem.pg_catalog.pg_statistic 3 3 6,352 22,558 0 0 3,033 rio.public.tmp_drill_0302 10 5 6,268 19,802 6,280 0 357 template1.pg_catalog.pg_shdepend 7 7 6,190 95,181 177 0 805 brasilia.pg_catalog.pg_type 14 14 5,725 31,092 0 22 915 rio.pg_catalog.pg_class 32 26 4,324 131,297 19,112 42 4,363 rio.pg_catalog.pg_index 20 15 3,541 42,054 3,559 9 1,116 brasilia.auditor.auditor_2026_07 1 0 3,030 1,183,982 0 0 53,060 contagem.pg_catalog.pg_depend 3 3 2,860 57,386 180 0 524 contagem.pg_catalog.pg_class 8 8 2,835 26,397 0 8 879 brasilia.pg_catalog.pg_index 8 8 2,748 15,026 3 9 420 brasilia.pg_catalog.pg_depend 6 6 2,637 108,489 0 14 1,042 rio.auditor.auditor_2026_07 2 0 1,838 11,109,835 0 0 514,604 contagem.pg_catalog.pg_type 5 5 1,509 11,235 2 21 321 brasilia.pg_catalog.pg_class 14 14 1,238 47,464 76 39 1,604 rio.pg_toast.pg_toast_2619 4 4 1,186 2,650 7 0 1,136 rio.pg_catalog.pg_shdepend 1 1 1,141 13,623 0 0 115 contagem.pg_catalog.pg_index 4 4 1,051 7,584 0 17 195 contagem.public.usuarios 17 0 1,011 391 0 0 34 brasilia.public.nf_entrada_arquivo_erros 1 0 715 1,645,665 0 0 29,462 contagem.auditor.auditor_2026_07 1 0 396 859,145 0 0 37,612 brasilia.pg_toast.pg_toast_2619 3 3 295 421 1 0 213 brasilia.public.nf_entrada 1 1 294 3,059 0 0 91 contagem.public.nf_entrada 1 1 191 919 0 0 69 contagem.pg_toast.pg_toast_2619 2 2 164 228 0 0 110 rio.public.usuarios 7 3 121 4,603 1,040 0 119 rio.public.temp0000284854 3 0 0 6,793 0 52 332 rio.public.temp0000284828 12 0 0 44,578 0 550 986 rio.public.temp0000284836 66 0 0 457,745 0 1,322 20,118 rio.public.temp0000284798 8 0 0 27,724 0 218 614 rio.public.temp0000284812 1 0 0 23,023 0 0 1,664 brasilia.public.temp0000235556 1 0 0 3,076 0 25 231 rio.public.temp0000284762 6 0 0 22,058 0 212 492 brasilia.public.temp0000235688 1 0 0 3,084 0 25 231 rio.public.temp0000284782 40 0 0 900,211 0 31 64,993 rio.public.temp0000284824 1 0 0 23,029 0 0 1,664 rio.public.temp0000284784 7 0 0 35,313 0 367 785 brasilia.public.temp0000235584 2 0 0 6,162 0 50 462 rio.public.temp0000284776 1 0 0 1,921 0 37 91 rio.public.temp0000284788 1 0 0 1,922 0 37 91 rio.public.temp0000284664 8 0 0 33,714 0 137 759 rio.public.temp0000284872 1 0 0 2,280 0 16 112 brasilia.public.temp0000235642 1 0 0 3,083 0 25 231 rio.public.temp0000284786 1 0 0 2,440 0 10 54 brasilia.public.temp0000235680 1 0 0 3,084 0 25 231 brasilia.public.temp0000235570 6 0 0 18,474 0 150 1,386 rio.public.temp0000284856 5 0 0 115,278 0 0 8,320 rio.public.temp0000284556 5 0 0 18,049 0 108 404 rio.public.temp0000284876 3 0 0 69,189 0 0 4,992 rio.public.temp0000284774 2 0 0 46,032 0 0 3,328 rio.public.temp0000284730 2 0 0 46,040 0 0 3,328 brasilia.public.temp0000235676 6 0 0 18,501 0 150 1,386 contagem.public.temp0000226579 3 0 0 3,701 0 102 282 rio.public.temp0000284832 15 0 0 60,914 0 570 1,350 brasilia.public.temp0000235610 1 0 0 3,081 0 25 231 rio.public.temp0000284756 52 0 0 778,164 0 579 55,229 rio.public.temp0000284840 3 0 0 48,316 0 22 3,434 brasilia.public.temp0000235634 1 0 0 3,083 0 25 231 rio.public.temp0000284778 2 0 0 24,978 0 37 1,755 rio.public.temp0000284800 1 0 0 1,922 0 37 91 rio.public.temp0000284790 1 0 0 23,014 0 0 1,664 contagem.public.temp0000226575 7 0 0 8,608 0 238 658 contagem.public.temp0000226577 15 0 0 18,433 0 510 1,410 rio.public.temp0000284750 5 0 0 15,392 0 106 342 rio.public.temp0000284842 1 0 0 2,203 0 22 106 rio.public.temp0000284818 3 0 0 69,078 0 0 4,992 Total 609 256 444,664 20,736,136 130,231 6,379 909,318 Pages removed per table
Key values
- public.temp0000284836 (1322) Main table with removed pages on database rio
- 6379 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000284836 66 0 0 1322 rio.public.temp0000284756 52 0 0 579 rio.public.temp0000284832 15 0 0 570 rio.public.temp0000284828 12 0 0 550 contagem.public.temp0000226577 15 0 0 510 rio.public.temp0000284784 7 0 0 367 contagem.public.temp0000226575 7 0 0 238 rio.pg_catalog.pg_attribute 46 41 178431 225 rio.public.temp0000284798 8 0 0 218 rio.public.temp0000284762 6 0 0 212 brasilia.public.temp0000235570 6 0 0 150 brasilia.public.temp0000235676 6 0 0 150 rio.public.temp0000284664 8 0 0 137 rio.public.temp0000284556 5 0 0 108 rio.public.temp0000284750 5 0 0 106 contagem.public.temp0000226579 3 0 0 102 contagem.pg_catalog.pg_attribute 12 12 41875 89 rio.public.temp0000284854 3 0 0 52 brasilia.public.temp0000235584 2 0 0 50 rio.pg_catalog.pg_class 32 26 4324 42 brasilia.pg_catalog.pg_class 14 14 1238 39 rio.public.temp0000284776 1 0 0 37 rio.public.temp0000284788 1 0 0 37 rio.public.temp0000284778 2 0 0 37 rio.public.temp0000284800 1 0 0 37 rio.public.temp0000284782 40 0 0 31 brasilia.pg_catalog.pg_attribute 21 21 102681 30 brasilia.public.temp0000235556 1 0 0 25 brasilia.public.temp0000235688 1 0 0 25 brasilia.public.temp0000235642 1 0 0 25 brasilia.public.temp0000235680 1 0 0 25 brasilia.public.temp0000235610 1 0 0 25 brasilia.public.temp0000235634 1 0 0 25 brasilia.pg_catalog.pg_type 14 14 5725 22 rio.public.temp0000284840 3 0 0 22 rio.public.temp0000284842 1 0 0 22 contagem.pg_catalog.pg_type 5 5 1509 21 rio.pg_catalog.pg_type 28 23 8633 21 contagem.pg_catalog.pg_index 4 4 1051 17 rio.public.temp0000284872 1 0 0 16 brasilia.pg_catalog.pg_depend 6 6 2637 14 rio.pg_catalog.pg_depend 10 10 12118 13 rio.public.temp0000284786 1 0 0 10 rio.pg_catalog.pg_index 20 15 3541 9 brasilia.pg_catalog.pg_index 8 8 2748 9 contagem.pg_catalog.pg_class 8 8 2835 8 rio.public.temp0000284812 1 0 0 0 brasilia.pg_toast.pg_toast_2619 3 3 295 0 brasilia.pg_catalog.pg_statistic 4 4 8022 0 rio.public.temp0000284824 1 0 0 0 rio.pg_catalog.pg_statistic 9 9 15572 0 contagem.pg_catalog.pg_statistic 3 3 6352 0 contagem.pg_toast.pg_toast_2619 2 2 164 0 contagem.public.nf_entrada 1 1 191 0 contagem.pg_catalog.pg_depend 3 3 2860 0 rio.public.temp0000284856 5 0 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 715 0 rio.public.temp0000284876 3 0 0 0 rio.public.temp0000284774 2 0 0 0 rio.public.tmp_drill_0302 10 5 6268 0 contagem.public.usuarios 17 0 1011 0 rio.public.temp0000284730 2 0 0 0 rio.pg_catalog.pg_shdepend 1 1 1141 0 rio.auditor.auditor_2026_07 2 0 1838 0 rio.public.tmp_drill_0175 3 3 19672 0 contagem.auditor.auditor_2026_07 1 0 396 0 template1.pg_catalog.pg_shdepend 7 7 6190 0 rio.public.temp0000284790 1 0 0 0 brasilia.public.nf_entrada 1 1 294 0 rio.public.usuarios 7 3 121 0 rio.pg_toast.pg_toast_2619 4 4 1186 0 brasilia.auditor.auditor_2026_07 1 0 3030 0 rio.public.temp0000284818 3 0 0 0 Total 609 256 444,664 6,379 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 08 00 0 0 01 0 0 02 0 0 03 0 0 04 0 1 05 6 19 06 0 1 07 18 33 08 65 126 09 57 151 10 76 117 11 74 151 12 25 53 13 50 85 14 88 171 15 68 131 16 37 100 17 40 75 18 0 0 19 0 0 20 0 0 21 5 3 22 0 0 23 0 0 - 11.67 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 2m20s 2s83ms 2m18s 1m10s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264173, 184, 'F200011174B2E51,9877E7BF0C86', '',0153,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-07-08 15:07:15 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263386, 304, 'ZTE3ANNQCA43866,14CA56D648F7,14CA56D648F8,ZTEGD97210C5$ZTE3ANNQCA36909,14CA56D5A5E9,14CA56D5A5EA,ZTEGD971F598$ZTE3ANNQ8M04309,843C991F2CE9,843C991F2CEA,ZTEGD7BA5842$ZTE3ANNQ8F15132,689E29FD8585,689E29FD8586,ZTEGD7BA37EC$ZTE3ANNR1Y45196,14CA56D0CDC3,14CA56D0CDC4,ZTEGD97126E7$ZTE3ANNR1Y25630,14CA56CF032F,14CA56CF0330,ZTEGD970DA79$ZTE3ANNRCP62912,6C11BA6EED4F,6C11BA6EED50,ZTEGDC703653$ZTE3ANNQ9J16917,843C992D5DB3,843C992D5DB4,ZTEGD7BB4AC0$ZTE3ANNRCP15543,6C11BA6A9719,6C11BA6A971A,ZTEGDC6F7D4A$ZTE3ANNQ5B14654,3CF9F0AFD72E,3CF9F0AFD72F,ZTEGD642393B$ZTE3ANNQ7506256,C4EBFF8B85DC,C4EBFF8B85DD,ZTEGD70A6710$ZTE3ANNT3H77902,D831399DE56C,D831399DE56D,ZTEGDD3300ED$ZTE3ANNR8C53130,389148536443,389148536444,ZTEGDB094FFA$ZTE3ANNQCA34875,14CA56D5763D,14CA56D5763E,ZTEGD971EDA6$ZTE3ANNR8C49974,389148531A4B,389148531A4C,ZTEGDB0943A6$ZTE3ANNR9318406,D89A0D840F6F,D89A0D840F70,ZTEGDB14BBE5$ZTE3ANNRC544425,6C11BA663B0D,6C11BA663B0E,ZTEGDC6EC348$ZTE3ANNRC522479,6C11BA6438B1,6C11BA6438B2,ZTEGDC6E6D8E$ZTE3ANNR3Y60327,4896D95546A2,4896D95546A3,ZTEGD97F1C5C$ZTE3ANNT2V43807,D831398F9192,D831398F9193,ZTEGDD309D9E$ZTE3ANNR6R24784,48D68237C9A2,48D68237C9A3,ZTEGDB018BA3$ZTE3ANNR2Q54455,F4E84F85B04A,F4E84F85B04B,ZTEGD97B4771$ZTE3ANNT3H80180,D831399E1AD0,D831399E1AD1,ZTEGDD3309D3$ZTE3ANNR9W09189,D89A0DA93381,D89A0DA93382,ZTEGDB163590$ZTE3ANNR2Q12469,F4E84F81D83E,F4E84F81D83F,ZTEGD97AA36F$ZTE3ANNRB729778,5872C990F31D,5872C990F31E,ZTEGDC619F25$ZTE3ANNRC509693,6C11BA630D05,6C11BA630D06,ZTEGDC6E3B9C$ZTE3ANNR7B51587,3891484DA5B9,3891484DA5BA,ZTEGDB085AE3$ZTE3ANNRC521662,6C11BA64258B,6C11BA64258C,ZTEGDC6E6A5D$ZTE3ANNR9F57758,D89A0DA82797,D89A0DA82798,ZTEGDB1608E9$ZTE3ANNQ7911936,C4EBFF8D35D0,C4EBFF8D35D1,ZTEGD70AAF0E$ZTE3ANNQCA27621,14CA56D4CC39,14CA56D4CC3A,ZTEGD971D150$ZTE3ANNQ5N07272,3CF9F0AD6FE6,3CF9F0AD6FE7,ZTEGD641D2AF$ZTE3ANNQ3R23960,3CF9F0A4B156,3CF9F0A4B157,ZTEGD6405D97$ZTE3ANNR8C21528,389148507F97,389148507F98,ZTEGDB08D488$ZTE3ANNRAD12637,D89A0DAF0291,D89A0DAF0292,ZTEGDB172D68$ZTE3ANNQ9J19531,843C992D9AF7,843C992D9AF8,ZTEGD7BB54F6$ZTE3ANNR9W08638,D89A0DA92697,D89A0DA92698,ZTEGDB163369$ZTE3ANNR6R14117,48D68236CFA0,48D68236CFA1,ZTEGDB0161F8$ZTE3ANNR9F33718,D89A0DA5F427,D89A0DA5F428,ZTEGDB15AB01', '', 0318, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', 'SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE', 00);
Date: 2026-07-08 10:37:31 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45258, 418, 'ZTE3ANNRCB04911,D831391E4218,D831391E4219,ZTEGDD29C8C4$ZTE3ANNR8C34638,38914851B2DB,38914851B2DC,ZTEGDB0907BE$ZTE3ANNR8C35337,38914851C33D,38914851C33E,ZTEGDB090A79$ZTE3ANNRCP04044,6C11BA698997,6C11BA698998,ZTEGDC6F505F$ZTE3ANNQ8M18862,843C992081FF,843C99208200,ZTEGD7BA911B$ZTE3ANNR5W08211,48D6822F443C,48D6822F443D,ZTEGDB002012$ZTE3ANNR6R16867,48D682371014,48D682371015,ZTEGDB016CB6$ZTE3ANNT3H83618,D831399E6B64,D831399E6B65,ZTEGDD331741$ZTE3ANNQ4N01693,3CF9F0A8B95C,3CF9F0A8B95D,ZTEGD6410998$ZTE3ANNRAM54460,5872C98C34A1,5872C98C34A2,ZTEGDC60D4BB$ZTE3ANNR9F58337,D89A0DA83529,D89A0DA8352A,ZTEGDB160B2C$ZTE3ANNR3J15476,F4E84F87B918,F4E84F87B919,ZTEGD97B9E3E$ZTE3ANNQ8M41225,843C99228E21,843C99228E22,ZTEGD7BAE876$ZTE3ANNT4P14210,F00C514CF3AA,F00C514CF3AB,ZTEGDE342E18$ZTE3ANNR7B00224,38914848F1E7,38914848F1E8,ZTEGDB079240$ZTE3ANNR1Y08339,14CA56CD6DED,14CA56CD6DEE,ZTEGD97096EE$ZTE3ANNQ4N02057,3CF9F0A8C1E4,3CF9F0A8C1E5,ZTEGD6410B04$ZTE3ANNQ9J21166,843C992DC149,843C992DC14A,ZTEGD7BB5B59$ZTE3ANNQ4A00617,3CF9F0AA06BC,3CF9F0AA06BD,ZTEGD6414128$ZTE3ANNR1Y03286,14CA56CCF77F,14CA56CCF780,ZTEGD9708331$ZTE3ANNRAM22871,5872C9895043,5872C9895044,ZTEGDC605956$ZTE3ANNR4N17727,4896D956FA92,4896D956FA93,ZTEGD97F6504$ZTE3ANNQ7503061,C4EBFF8B3AFA,C4EBFF8B3AFB,ZTEGD70A5A95$ZTE3ANNT3F09262,D831399604DC,D831399604DD,ZTEGDD31B0D5$ZTE3ANNQ3608910,3CF9F0A5A642,3CF9F0A5A643,ZTEGD6408669$ZTE3ANNQ5B04873,3CF9F0AEF1F0,3CF9F0AEF1F1,ZTEGD6421306$ZTE3ANNRC551260,6C11BA66DB3F,6C11BA66DB40,ZTEGDC6EDDFB$ZTE3ANNRAM63602,5872C98D0AE5,5872C98D0AE6,ZTEGDC60F871$ZTE3ANNR7B32440,3891484BE4F7,3891484BE4F8,ZTEGDB081018$ZTE3ANNRCB23879,D831391FFEA8,D831391FFEA9,ZTEGDD2A12DC$ZTE3ANNR3Y03564,4896D9501440,4896D9501441,ZTEGD97E3EA1$ZTE3ANNQ9J08016,843C992C8D15,843C992C8D16,ZTEGD7BB27FB', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-08 13:36:32 Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000284756;-
DROP TABLE IF EXISTS temp0000284756;
Date: 2026-07-08 07:45:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
DROP TABLE IF EXISTS temp0000284756;
Date: 2026-07-08 12:49:46 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
DROP TABLE IF EXISTS temp0000284756;
Date: 2026-07-08 11:47:46 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 1 1s 1s 1s 1s drop table if exists temp0000284836;-
DROP TABLE IF EXISTS temp0000284836;
Date: 2026-07-08 17:33:49 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
DROP TABLE IF EXISTS temp0000284836;
Date: 2026-07-08 17:33:49 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Queries that waited the most
Rank Wait time Query 1 2m18s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264173, 184, 'F200011174B2E51,9877E7BF0C86', '',0153,00,'[{"item":"0","qrcode":""}]','', '', 00);[ Date: 2026-07-08 15:07:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 2s83ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45420, 407, 'CP2325323AJ,D4925EC990F7,544D4242006D0811,D4925EC990FA$CP234532WET,08C7F5066087,544D42420073B384,08C7F506608A$CP2319327BY,D4925EA09E82,544D42420069A7FC,D4925EA09E85$CP23103250E,D4925E342CF4,544D42420065C52E,D4925E342CF7$CP230132FWC,D4925E03C485,544D42420061539C,D4925E03C488$CP2310320K0,D4925E3382E7,544D42420065B249,D4925E3382EA$CP23453220W,08C7F5022068,544D424200733A9D,08C7F502206B$CP234532P9S,08C7F5054EB2,544D424200739517,08C7F5054EB5', '',0298,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":""}]','$$$$$$$$$$','', 00);[ Date: 2026-07-08 15:39:35 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s1ms DROP TABLE IF EXISTS temp0000284756;[ Date: 2026-07-08 07:45:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000284836;[ Date: 2026-07-08 17:33:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,019 Total read queries
- 1,808 Total write queries
Queries by database
Key values
- rio Main database
- 4,848 Requests
- 7h10m23s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,576 1h43m59s copy to 106 8m23s ddl 336 3m28s others 129 6m21s select 1,005 1h25m45s contagem Total 827 30m42s copy to 86 1m4s ddl 206 1m35s others 4 2m49s select 531 25m13s postgres Total 1 206ms select 1 206ms rio Total 4,848 7h10m23s copy to 159 39m54s ddl 915 1h2m11s others 292 31m48s select 3,482 4h56m28s Queries by user
Key values
- intelifix Main user
- 7,092 Requests
User Request type Count Duration etiquetas Total 47 9s315ms select 47 9s315ms intelifix Total 7,092 9h23m52s copy to 351 49m22s ddl 1,457 1h7m15s others 425 40m59s select 4,859 6h46m14s lenon Total 113 1m3s select 113 1m3s Duration by user
Key values
- 9h23m52s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 47 9s315ms select 47 9s315ms intelifix Total 7,092 9h23m52s copy to 351 49m22s ddl 1,457 1h7m15s others 425 40m59s select 4,859 6h46m14s lenon Total 113 1m3s select 113 1m3s Queries by host
Key values
- [local] Main host
- 7,251 Requests
- 9h25m5s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,215 Requests
- 4h30m3s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-08 15:17:46 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,767 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 10:14:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 09:14:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 15:14:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m44s analyze verbose;[ Date: 2026-07-08 05:08:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 11:13:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');[ Date: 2026-07-08 16:14:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 8m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 16:13:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 17:13:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 14:13:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 12:12:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 07:12:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026797, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');[ Date: 2026-07-08 14:43:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 7m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 22:12:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 7m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 08:12:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 18:11:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026779, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-08 10:58:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026762, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-08 09:10:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-08 13:11:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026774, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-08 10:23:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026808, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-08 15:07:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h8m52s 46 1s395ms 9m19s 2m48s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 08 07 3 8m10s 2m43s 08 3 7m25s 2m28s 09 3 9m53s 3m17s 10 3 9m55s 3m18s 11 2 9m12s 4m36s 12 3 8m7s 2m42s 13 3 6m34s 2m11s 14 3 8m48s 2m56s 15 2 9m33s 4m46s 16 3 9m1s 3m 17 3 8m55s 2m58s 18 3 7m20s 2m26s 19 3 5m53s 1m57s 20 3 6m18s 2m6s 21 3 5m59s 1m59s 22 3 7m43s 2m34s [ User: intelifix - Total duration: 2h8m52s - Times executed: 46 ]
[ Application: psql - Total duration: 2h8m52s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-08 10:14:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-08 09:14:14 Duration: 9m12s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-08 15:14:05 Duration: 9m4s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 2h4m54s 387 153ms 8m34s 19s365ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 08 07 19 13m36s 42s952ms 08 35 2m16s 3s904ms 09 29 14m4s 29s133ms 10 53 19m44s 22s353ms 11 33 13m15s 24s97ms 12 16 9m28s 35s527ms 13 16 23s960ms 1s497ms 14 51 9m4s 10s675ms 15 50 21m10s 25s401ms 16 39 14m42s 22s624ms 17 41 6m48s 9s952ms 18 5 19s494ms 3s898ms [ User: intelifix - Total duration: 2h4m54s - Times executed: 387 ]
[ Application: [unknown] - Total duration: 2h4m54s - Times executed: 387 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-08 16:14:13 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026797, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');
Date: 2026-07-08 14:43:03 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026779, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-08 10:58:17 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 1h12m13s 45 352ms 5m10s 1m36s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 08 07 3 4m44s 1m34s 08 3 4m58s 1m39s 09 3 6m22s 2m7s 10 3 5m42s 1m54s 11 1 1m7s 1m7s 12 2 3m40s 1m50s 13 3 4m19s 1m26s 14 3 5m29s 1m49s 15 3 5m26s 1m48s 16 3 5m9s 1m43s 17 3 4m49s 1m36s 18 3 4m11s 1m23s 19 3 3m38s 1m12s 20 3 4m8s 1m22s 21 3 3m44s 1m14s 22 3 4m40s 1m33s [ User: intelifix - Total duration: 1h12m13s - Times executed: 45 ]
[ Application: psql - Total duration: 1h12m13s - Times executed: 45 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-08 09:21:09 Duration: 5m10s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-08 10:20:31 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-08 14:19:14 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 22m49s 1,403 150ms 2m19s 975ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 08 07 10 3s142ms 314ms 08 87 1m31s 1s57ms 09 221 3m30s 950ms 10 157 3m6s 1s189ms 11 181 2m26s 809ms 12 85 1m2s 729ms 13 78 1m5s 845ms 14 171 2m40s 937ms 15 233 5m17s 1s361ms 16 115 1m19s 690ms 17 65 45s852ms 705ms [ User: intelifix - Total duration: 22m49s - Times executed: 1403 ]
[ Application: [unknown] - Total duration: 22m49s - Times executed: 1403 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264173, 184, 'F200011174B2E51,9877E7BF0C86', '',0153,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-07-08 15:07:15 Duration: 2m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263386, 304, 'ZTE3ANNQCA43866,14CA56D648F7,14CA56D648F8,ZTEGD97210C5$ZTE3ANNQCA36909,14CA56D5A5E9,14CA56D5A5EA,ZTEGD971F598$ZTE3ANNQ8M04309,843C991F2CE9,843C991F2CEA,ZTEGD7BA5842$ZTE3ANNQ8F15132,689E29FD8585,689E29FD8586,ZTEGD7BA37EC$ZTE3ANNR1Y45196,14CA56D0CDC3,14CA56D0CDC4,ZTEGD97126E7$ZTE3ANNR1Y25630,14CA56CF032F,14CA56CF0330,ZTEGD970DA79$ZTE3ANNRCP62912,6C11BA6EED4F,6C11BA6EED50,ZTEGDC703653$ZTE3ANNQ9J16917,843C992D5DB3,843C992D5DB4,ZTEGD7BB4AC0$ZTE3ANNRCP15543,6C11BA6A9719,6C11BA6A971A,ZTEGDC6F7D4A$ZTE3ANNQ5B14654,3CF9F0AFD72E,3CF9F0AFD72F,ZTEGD642393B$ZTE3ANNQ7506256,C4EBFF8B85DC,C4EBFF8B85DD,ZTEGD70A6710$ZTE3ANNT3H77902,D831399DE56C,D831399DE56D,ZTEGDD3300ED$ZTE3ANNR8C53130,389148536443,389148536444,ZTEGDB094FFA$ZTE3ANNQCA34875,14CA56D5763D,14CA56D5763E,ZTEGD971EDA6$ZTE3ANNR8C49974,389148531A4B,389148531A4C,ZTEGDB0943A6$ZTE3ANNR9318406,D89A0D840F6F,D89A0D840F70,ZTEGDB14BBE5$ZTE3ANNRC544425,6C11BA663B0D,6C11BA663B0E,ZTEGDC6EC348$ZTE3ANNRC522479,6C11BA6438B1,6C11BA6438B2,ZTEGDC6E6D8E$ZTE3ANNR3Y60327,4896D95546A2,4896D95546A3,ZTEGD97F1C5C$ZTE3ANNT2V43807,D831398F9192,D831398F9193,ZTEGDD309D9E$ZTE3ANNR6R24784,48D68237C9A2,48D68237C9A3,ZTEGDB018BA3$ZTE3ANNR2Q54455,F4E84F85B04A,F4E84F85B04B,ZTEGD97B4771$ZTE3ANNT3H80180,D831399E1AD0,D831399E1AD1,ZTEGDD3309D3$ZTE3ANNR9W09189,D89A0DA93381,D89A0DA93382,ZTEGDB163590$ZTE3ANNR2Q12469,F4E84F81D83E,F4E84F81D83F,ZTEGD97AA36F$ZTE3ANNRB729778,5872C990F31D,5872C990F31E,ZTEGDC619F25$ZTE3ANNRC509693,6C11BA630D05,6C11BA630D06,ZTEGDC6E3B9C$ZTE3ANNR7B51587,3891484DA5B9,3891484DA5BA,ZTEGDB085AE3$ZTE3ANNRC521662,6C11BA64258B,6C11BA64258C,ZTEGDC6E6A5D$ZTE3ANNR9F57758,D89A0DA82797,D89A0DA82798,ZTEGDB1608E9$ZTE3ANNQ7911936,C4EBFF8D35D0,C4EBFF8D35D1,ZTEGD70AAF0E$ZTE3ANNQCA27621,14CA56D4CC39,14CA56D4CC3A,ZTEGD971D150$ZTE3ANNQ5N07272,3CF9F0AD6FE6,3CF9F0AD6FE7,ZTEGD641D2AF$ZTE3ANNQ3R23960,3CF9F0A4B156,3CF9F0A4B157,ZTEGD6405D97$ZTE3ANNR8C21528,389148507F97,389148507F98,ZTEGDB08D488$ZTE3ANNRAD12637,D89A0DAF0291,D89A0DAF0292,ZTEGDB172D68$ZTE3ANNQ9J19531,843C992D9AF7,843C992D9AF8,ZTEGD7BB54F6$ZTE3ANNR9W08638,D89A0DA92697,D89A0DA92698,ZTEGDB163369$ZTE3ANNR6R14117,48D68236CFA0,48D68236CFA1,ZTEGDB0161F8$ZTE3ANNR9F33718,D89A0DA5F427,D89A0DA5F428,ZTEGDB15AB01', '', 0318, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', 'SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE', 00);
Date: 2026-07-08 10:37:31 Duration: 5s868ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45258, 418, 'ZTE3ANNRCB04911,D831391E4218,D831391E4219,ZTEGDD29C8C4$ZTE3ANNR8C34638,38914851B2DB,38914851B2DC,ZTEGDB0907BE$ZTE3ANNR8C35337,38914851C33D,38914851C33E,ZTEGDB090A79$ZTE3ANNRCP04044,6C11BA698997,6C11BA698998,ZTEGDC6F505F$ZTE3ANNQ8M18862,843C992081FF,843C99208200,ZTEGD7BA911B$ZTE3ANNR5W08211,48D6822F443C,48D6822F443D,ZTEGDB002012$ZTE3ANNR6R16867,48D682371014,48D682371015,ZTEGDB016CB6$ZTE3ANNT3H83618,D831399E6B64,D831399E6B65,ZTEGDD331741$ZTE3ANNQ4N01693,3CF9F0A8B95C,3CF9F0A8B95D,ZTEGD6410998$ZTE3ANNRAM54460,5872C98C34A1,5872C98C34A2,ZTEGDC60D4BB$ZTE3ANNR9F58337,D89A0DA83529,D89A0DA8352A,ZTEGDB160B2C$ZTE3ANNR3J15476,F4E84F87B918,F4E84F87B919,ZTEGD97B9E3E$ZTE3ANNQ8M41225,843C99228E21,843C99228E22,ZTEGD7BAE876$ZTE3ANNT4P14210,F00C514CF3AA,F00C514CF3AB,ZTEGDE342E18$ZTE3ANNR7B00224,38914848F1E7,38914848F1E8,ZTEGDB079240$ZTE3ANNR1Y08339,14CA56CD6DED,14CA56CD6DEE,ZTEGD97096EE$ZTE3ANNQ4N02057,3CF9F0A8C1E4,3CF9F0A8C1E5,ZTEGD6410B04$ZTE3ANNQ9J21166,843C992DC149,843C992DC14A,ZTEGD7BB5B59$ZTE3ANNQ4A00617,3CF9F0AA06BC,3CF9F0AA06BD,ZTEGD6414128$ZTE3ANNR1Y03286,14CA56CCF77F,14CA56CCF780,ZTEGD9708331$ZTE3ANNRAM22871,5872C9895043,5872C9895044,ZTEGDC605956$ZTE3ANNR4N17727,4896D956FA92,4896D956FA93,ZTEGD97F6504$ZTE3ANNQ7503061,C4EBFF8B3AFA,C4EBFF8B3AFB,ZTEGD70A5A95$ZTE3ANNT3F09262,D831399604DC,D831399604DD,ZTEGDD31B0D5$ZTE3ANNQ3608910,3CF9F0A5A642,3CF9F0A5A643,ZTEGD6408669$ZTE3ANNQ5B04873,3CF9F0AEF1F0,3CF9F0AEF1F1,ZTEGD6421306$ZTE3ANNRC551260,6C11BA66DB3F,6C11BA66DB40,ZTEGDC6EDDFB$ZTE3ANNRAM63602,5872C98D0AE5,5872C98D0AE6,ZTEGDC60F871$ZTE3ANNR7B32440,3891484BE4F7,3891484BE4F8,ZTEGDB081018$ZTE3ANNRCB23879,D831391FFEA8,D831391FFEA9,ZTEGDD2A12DC$ZTE3ANNR3Y03564,4896D9501440,4896D9501441,ZTEGD97E3EA1$ZTE3ANNQ9J08016,843C992C8D15,843C992C8D16,ZTEGD7BB27FB', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-08 13:36:32 Duration: 4s736ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 18m17s 20 1s9ms 2m8s 54s874ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 08 08 6 39s97ms 6s516ms 11 2 7s615ms 3s807ms 13 2 3m36s 1m48s 14 6 11m44s 1m57s 15 1 2m4s 2m4s 16 2 2s359ms 1s179ms 17 1 3s412ms 3s412ms [ User: intelifix - Total duration: 18m17s - Times executed: 20 ]
[ Application: psql - Total duration: 18m17s - Times executed: 20 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01508);
Date: 2026-07-08 14:51:54 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01510);
Date: 2026-07-08 15:34:06 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01506);
Date: 2026-07-08 14:36:00 Duration: 1m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 16m22s 76 9s204ms 34s506ms 12s921ms create table temp0000284756 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 08 07 13 2m39s 12s259ms 08 3 39s841ms 13s280ms 09 12 2m25s 12s92ms 10 14 3m11s 13s712ms 11 10 2m1s 12s114ms 12 7 1m14s 10s659ms 14 3 44s919ms 14s973ms 15 11 2m24s 13s145ms 16 3 1m 20s164ms [ User: intelifix - Total duration: 16m22s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 76 ]
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 07:06:05 Duration: 34s506ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 16:18:07 Duration: 33s413ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 15:01:13 Duration: 17s762ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 15m15s 3 2m23s 8m44s 5m5s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 08 05 3 15m15s 5m5s [ User: intelifix - Total duration: 15m15s - Times executed: 3 ]
[ Application: psql - Total duration: 15m15s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-08 05:08:45 Duration: 8m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-07-08 05:12:53 Duration: 4m7s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-07-08 05:15:17 Duration: 2m23s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 14m23s 67 10s180ms 16s693ms 12s883ms create table temp0000284782 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 08 08 1 11s874ms 11s874ms 09 16 3m33s 13s360ms 10 19 4m16s 13s490ms 11 11 2m23s 13s12ms 12 3 31s59ms 10s353ms 13 1 11s267ms 11s267ms 14 11 2m11s 11s930ms 15 5 1m4s 12s906ms [ User: intelifix - Total duration: 14m23s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 14m23s - Times executed: 67 ]
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 09:31:59 Duration: 16s693ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 10:00:21 Duration: 16s200ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 11:08:37 Duration: 15s641ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 12m10s 200 150ms 13s56ms 3s652ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 08 00 7 30s618ms 4s374ms 01 8 25s527ms 3s190ms 02 7 24s908ms 3s558ms 03 8 24s855ms 3s106ms 04 7 22s28ms 3s146ms 05 8 27s116ms 3s389ms 06 6 25s560ms 4s260ms 07 6 26s276ms 4s379ms 08 6 33s73ms 5s512ms 09 6 32s985ms 5s497ms 10 7 38s967ms 5s566ms 11 8 32s477ms 4s59ms 12 8 34s151ms 4s268ms 13 6 33s778ms 5s629ms 14 6 31s710ms 5s285ms 15 12 45s983ms 3s831ms 16 12 47s908ms 3s992ms 17 12 33s671ms 2s805ms 18 12 28s531ms 2s377ms 19 12 30s824ms 2s568ms 20 12 38s196ms 3s183ms 21 12 31s48ms 2s587ms 22 12 30s307ms 2s525ms [ User: intelifix - Total duration: 12m10s - Times executed: 200 ]
[ Application: psql - Total duration: 12m10s - Times executed: 200 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 16:15:17 Duration: 13s56ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 20:15:12 Duration: 11s162ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 00:05:25 Duration: 10s869ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 10m45s 137 1s66ms 18s292ms 4s714ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 08 07 3 10s303ms 3s434ms 08 10 33s148ms 3s314ms 09 16 56s283ms 3s517ms 10 14 44s221ms 3s158ms 11 16 1m46s 6s665ms 12 9 20s915ms 2s323ms 13 9 1m4s 7s171ms 14 14 1m3s 4s531ms 15 19 1m27s 4s609ms 16 13 1m9s 5s315ms 17 13 1m26s 6s635ms 18 1 3s490ms 3s490ms [ User: intelifix - Total duration: 10m45s - Times executed: 137 ]
[ Application: [unknown] - Total duration: 10m45s - Times executed: 137 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 15:19:18 Duration: 18s292ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 14:47:05 Duration: 17s313ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 11:04:04 Duration: 15s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 8m59s 1,052 150ms 3s367ms 512ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 08 07 25 14s620ms 584ms 08 137 1m2s 456ms 09 134 1m11s 534ms 10 130 1m5s 503ms 11 143 1m10s 491ms 12 9 5s915ms 657ms 13 97 51s571ms 531ms 14 184 1m40s 543ms 15 100 51s89ms 510ms 16 76 36s565ms 481ms 17 17 9s862ms 580ms [ User: intelifix - Total duration: 8m59s - Times executed: 1052 ]
[ Application: [unknown] - Total duration: 8m59s - Times executed: 1052 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264124", "modelo" : "320", "itens" : "241619675158,241665895056,241682659194,241694684959,241703950825,241664089908,241606938203,241595712528,241717088706,241661324251,241617351217,241728728999,241700303151,241614482340,241646416578,241712799701,241728794259,241608080728,241649267294,241695035577,241672339399,241691011324,241653940613,241646366472,241616898085,241731022333,241697010316,241731419295,241674421725,241703655969,241622599292,241598929395,241672416882,241619861114,241663820208,241617966787,241603050102,241659729404,241668310826,241671514157,241659791835,241672352937,241628233345,241603057778,241594043858,241732812732,241674553051,241696771123", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-08 14:05:05 Duration: 3s367ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264155", "modelo" : "320", "itens" : "241670366480,230049197696,241669935877,241682641921,241694436775,241714866771,241619353556,241651985977,241635504851,241603309295,241672934464,241672973637,241726984464,241674382428,241663286081,241619932030,241701259191,241620286991,241734111939,230047908692,241672997376,241660721028,241669688805,241659809008,241703928903,241715584754,241637522344,241653308193,241653422627,241691573960,241704380317,241667799608,241665897783,241670414667,241654536282,241715586976,230057050102,241655678908,241659816887,241690932427,241730207191,241689805762,241716577387,241634909002,241734098503,241708948595,241676848404,241597914662", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-08 14:28:27 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264124", "modelo" : "320", "itens" : "241726898091,241649284950,241649342835,241602906271,241609898806,241714399396,230040455979,241674596971,241596110424,241595285157,241693006467,241664259093,230043577282,241653281121,241630185555,241676793146,241691111132,241653837392,241653199192,241664786272,241667593247,241676324054,241631048097,241635565261,230049407189,241638231717,241649334753,241619395759,835028905003777,241652189409,230048942745,241651387377,241655581828,241597860819,241630093246,241619341737,241680281837,241673165676,230048065779,241649825766,241605400410,241615148599,241712824451,230048990202,241594654658,241635674868,241619851618,241689058204", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-08 14:02:22 Duration: 2s291ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 8m33s 43 9s400ms 14s452ms 11s951ms create table temp0000284836 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 08 14 21 4m20s 12s389ms 15 7 1m22s 11s766ms 16 5 59s319ms 11s863ms 17 10 1m52s 11s203ms [ User: intelifix - Total duration: 8m33s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m33s - Times executed: 43 ]
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 14:52:26 Duration: 14s452ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 15:40:38 Duration: 14s173ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 14:39:18 Duration: 13s869ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 7m23s 167 159ms 12s894ms 2s657ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 08 00 6 20s620ms 3s436ms 01 6 8s658ms 1s443ms 02 5 5s860ms 1s172ms 03 5 8s704ms 1s740ms 04 5 7s619ms 1s523ms 05 4 6s737ms 1s684ms 06 3 5s435ms 1s811ms 07 12 24s771ms 2s64ms 08 12 43s773ms 3s647ms 09 12 38s742ms 3s228ms 10 12 41s851ms 3s487ms 11 12 45s735ms 3s811ms 12 12 41s337ms 3s444ms 13 9 9s836ms 1s92ms 14 12 40s952ms 3s412ms 15 12 39s459ms 3s288ms 16 11 26s954ms 2s450ms 17 7 6s583ms 940ms 21 4 7s930ms 1s982ms 22 6 12s195ms 2s32ms [ User: intelifix - Total duration: 7m23s - Times executed: 167 ]
[ Application: psql - Total duration: 7m23s - Times executed: 167 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 00:05:14 Duration: 12s894ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 16:05:10 Duration: 8s89ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 14:55:09 Duration: 7s886ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 4m37s 1 4m37s 4m37s 4m37s select * from rs_smart_fiscal_saida () / 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 (/ 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 (/ 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 #14
Day Hour Count Duration Avg duration Jul 08 11 1 4m37s 4m37s [ User: intelifix - Total duration: 4m37s - Times executed: 1 ]
[ Application: psql - Total duration: 4m37s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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 (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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 (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-08 11:19:59 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 3m29s 42 3s232ms 12s583ms 4s979ms create table temp0000284756 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 08 07 17 1m16s 4s509ms 08 2 7s861ms 3s930ms 09 4 21s260ms 5s315ms 10 2 11s321ms 5s660ms 11 9 47s343ms 5s260ms 14 2 11s610ms 5s805ms 15 6 33s70ms 5s511ms [ User: intelifix - Total duration: 3m29s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 3m29s - Times executed: 42 ]
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 07:20:21 Duration: 12s583ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 10:43:57 Duration: 6s428ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 09:37:16 Duration: 6s396ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 3m25s 35 4s412ms 14s241ms 5s882ms create table temp0000284836 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 08 14 14 1m19s 5s703ms 15 5 25s991ms 5s198ms 16 3 24s148ms 8s49ms 17 13 1m15s 5s839ms [ User: intelifix - Total duration: 3m25s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 3m25s - Times executed: 35 ]
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 17:28:01 Duration: 14s241ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 16:23:29 Duration: 12s594ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 14:48:59 Duration: 6s347ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 3m6s 3 4s711ms 1m31s 1m2s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 08 20 2 1m36s 48s254ms 23 1 1m30s 1m30s [ User: intelifix - Total duration: 3m6s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-08 20:08:36 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-08 23:42:33 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-08 20:10:22 Duration: 4s711ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 2m11s 2 7s520ms 2m4s 1m5s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 08 23 2 2m11s 1m5s [ User: intelifix - Total duration: 2m11s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m11s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-08 23:15:50 Duration: 2m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-08 23:43:10 Duration: 7s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 2m9s 1 2m9s 2m9s 2m9s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 08 23 1 2m9s 2m9s [ User: intelifix - Total duration: 2m9s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 1 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-08 23:13:46 Duration: 2m9s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 2m2s 4 441ms 1m2s 30s581ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 08 20 2 59s566ms 29s783ms 23 2 1m2s 31s379ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-08 23:19:56 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-08 20:05:23 Duration: 59s122ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-08 20:09:49 Duration: 443ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,403 22m49s 150ms 2m19s 975ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 08 07 10 3s142ms 314ms 08 87 1m31s 1s57ms 09 221 3m30s 950ms 10 157 3m6s 1s189ms 11 181 2m26s 809ms 12 85 1m2s 729ms 13 78 1m5s 845ms 14 171 2m40s 937ms 15 233 5m17s 1s361ms 16 115 1m19s 690ms 17 65 45s852ms 705ms [ User: intelifix - Total duration: 22m49s - Times executed: 1403 ]
[ Application: [unknown] - Total duration: 22m49s - Times executed: 1403 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264173, 184, 'F200011174B2E51,9877E7BF0C86', '',0153,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-07-08 15:07:15 Duration: 2m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263386, 304, 'ZTE3ANNQCA43866,14CA56D648F7,14CA56D648F8,ZTEGD97210C5$ZTE3ANNQCA36909,14CA56D5A5E9,14CA56D5A5EA,ZTEGD971F598$ZTE3ANNQ8M04309,843C991F2CE9,843C991F2CEA,ZTEGD7BA5842$ZTE3ANNQ8F15132,689E29FD8585,689E29FD8586,ZTEGD7BA37EC$ZTE3ANNR1Y45196,14CA56D0CDC3,14CA56D0CDC4,ZTEGD97126E7$ZTE3ANNR1Y25630,14CA56CF032F,14CA56CF0330,ZTEGD970DA79$ZTE3ANNRCP62912,6C11BA6EED4F,6C11BA6EED50,ZTEGDC703653$ZTE3ANNQ9J16917,843C992D5DB3,843C992D5DB4,ZTEGD7BB4AC0$ZTE3ANNRCP15543,6C11BA6A9719,6C11BA6A971A,ZTEGDC6F7D4A$ZTE3ANNQ5B14654,3CF9F0AFD72E,3CF9F0AFD72F,ZTEGD642393B$ZTE3ANNQ7506256,C4EBFF8B85DC,C4EBFF8B85DD,ZTEGD70A6710$ZTE3ANNT3H77902,D831399DE56C,D831399DE56D,ZTEGDD3300ED$ZTE3ANNR8C53130,389148536443,389148536444,ZTEGDB094FFA$ZTE3ANNQCA34875,14CA56D5763D,14CA56D5763E,ZTEGD971EDA6$ZTE3ANNR8C49974,389148531A4B,389148531A4C,ZTEGDB0943A6$ZTE3ANNR9318406,D89A0D840F6F,D89A0D840F70,ZTEGDB14BBE5$ZTE3ANNRC544425,6C11BA663B0D,6C11BA663B0E,ZTEGDC6EC348$ZTE3ANNRC522479,6C11BA6438B1,6C11BA6438B2,ZTEGDC6E6D8E$ZTE3ANNR3Y60327,4896D95546A2,4896D95546A3,ZTEGD97F1C5C$ZTE3ANNT2V43807,D831398F9192,D831398F9193,ZTEGDD309D9E$ZTE3ANNR6R24784,48D68237C9A2,48D68237C9A3,ZTEGDB018BA3$ZTE3ANNR2Q54455,F4E84F85B04A,F4E84F85B04B,ZTEGD97B4771$ZTE3ANNT3H80180,D831399E1AD0,D831399E1AD1,ZTEGDD3309D3$ZTE3ANNR9W09189,D89A0DA93381,D89A0DA93382,ZTEGDB163590$ZTE3ANNR2Q12469,F4E84F81D83E,F4E84F81D83F,ZTEGD97AA36F$ZTE3ANNRB729778,5872C990F31D,5872C990F31E,ZTEGDC619F25$ZTE3ANNRC509693,6C11BA630D05,6C11BA630D06,ZTEGDC6E3B9C$ZTE3ANNR7B51587,3891484DA5B9,3891484DA5BA,ZTEGDB085AE3$ZTE3ANNRC521662,6C11BA64258B,6C11BA64258C,ZTEGDC6E6A5D$ZTE3ANNR9F57758,D89A0DA82797,D89A0DA82798,ZTEGDB1608E9$ZTE3ANNQ7911936,C4EBFF8D35D0,C4EBFF8D35D1,ZTEGD70AAF0E$ZTE3ANNQCA27621,14CA56D4CC39,14CA56D4CC3A,ZTEGD971D150$ZTE3ANNQ5N07272,3CF9F0AD6FE6,3CF9F0AD6FE7,ZTEGD641D2AF$ZTE3ANNQ3R23960,3CF9F0A4B156,3CF9F0A4B157,ZTEGD6405D97$ZTE3ANNR8C21528,389148507F97,389148507F98,ZTEGDB08D488$ZTE3ANNRAD12637,D89A0DAF0291,D89A0DAF0292,ZTEGDB172D68$ZTE3ANNQ9J19531,843C992D9AF7,843C992D9AF8,ZTEGD7BB54F6$ZTE3ANNR9W08638,D89A0DA92697,D89A0DA92698,ZTEGDB163369$ZTE3ANNR6R14117,48D68236CFA0,48D68236CFA1,ZTEGDB0161F8$ZTE3ANNR9F33718,D89A0DA5F427,D89A0DA5F428,ZTEGDB15AB01', '', 0318, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', 'SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE', 00);
Date: 2026-07-08 10:37:31 Duration: 5s868ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45258, 418, 'ZTE3ANNRCB04911,D831391E4218,D831391E4219,ZTEGDD29C8C4$ZTE3ANNR8C34638,38914851B2DB,38914851B2DC,ZTEGDB0907BE$ZTE3ANNR8C35337,38914851C33D,38914851C33E,ZTEGDB090A79$ZTE3ANNRCP04044,6C11BA698997,6C11BA698998,ZTEGDC6F505F$ZTE3ANNQ8M18862,843C992081FF,843C99208200,ZTEGD7BA911B$ZTE3ANNR5W08211,48D6822F443C,48D6822F443D,ZTEGDB002012$ZTE3ANNR6R16867,48D682371014,48D682371015,ZTEGDB016CB6$ZTE3ANNT3H83618,D831399E6B64,D831399E6B65,ZTEGDD331741$ZTE3ANNQ4N01693,3CF9F0A8B95C,3CF9F0A8B95D,ZTEGD6410998$ZTE3ANNRAM54460,5872C98C34A1,5872C98C34A2,ZTEGDC60D4BB$ZTE3ANNR9F58337,D89A0DA83529,D89A0DA8352A,ZTEGDB160B2C$ZTE3ANNR3J15476,F4E84F87B918,F4E84F87B919,ZTEGD97B9E3E$ZTE3ANNQ8M41225,843C99228E21,843C99228E22,ZTEGD7BAE876$ZTE3ANNT4P14210,F00C514CF3AA,F00C514CF3AB,ZTEGDE342E18$ZTE3ANNR7B00224,38914848F1E7,38914848F1E8,ZTEGDB079240$ZTE3ANNR1Y08339,14CA56CD6DED,14CA56CD6DEE,ZTEGD97096EE$ZTE3ANNQ4N02057,3CF9F0A8C1E4,3CF9F0A8C1E5,ZTEGD6410B04$ZTE3ANNQ9J21166,843C992DC149,843C992DC14A,ZTEGD7BB5B59$ZTE3ANNQ4A00617,3CF9F0AA06BC,3CF9F0AA06BD,ZTEGD6414128$ZTE3ANNR1Y03286,14CA56CCF77F,14CA56CCF780,ZTEGD9708331$ZTE3ANNRAM22871,5872C9895043,5872C9895044,ZTEGDC605956$ZTE3ANNR4N17727,4896D956FA92,4896D956FA93,ZTEGD97F6504$ZTE3ANNQ7503061,C4EBFF8B3AFA,C4EBFF8B3AFB,ZTEGD70A5A95$ZTE3ANNT3F09262,D831399604DC,D831399604DD,ZTEGDD31B0D5$ZTE3ANNQ3608910,3CF9F0A5A642,3CF9F0A5A643,ZTEGD6408669$ZTE3ANNQ5B04873,3CF9F0AEF1F0,3CF9F0AEF1F1,ZTEGD6421306$ZTE3ANNRC551260,6C11BA66DB3F,6C11BA66DB40,ZTEGDC6EDDFB$ZTE3ANNRAM63602,5872C98D0AE5,5872C98D0AE6,ZTEGDC60F871$ZTE3ANNR7B32440,3891484BE4F7,3891484BE4F8,ZTEGDB081018$ZTE3ANNRCB23879,D831391FFEA8,D831391FFEA9,ZTEGDD2A12DC$ZTE3ANNR3Y03564,4896D9501440,4896D9501441,ZTEGD97E3EA1$ZTE3ANNQ9J08016,843C992C8D15,843C992C8D16,ZTEGD7BB27FB', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-08 13:36:32 Duration: 4s736ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 1,052 8m59s 150ms 3s367ms 512ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 08 07 25 14s620ms 584ms 08 137 1m2s 456ms 09 134 1m11s 534ms 10 130 1m5s 503ms 11 143 1m10s 491ms 12 9 5s915ms 657ms 13 97 51s571ms 531ms 14 184 1m40s 543ms 15 100 51s89ms 510ms 16 76 36s565ms 481ms 17 17 9s862ms 580ms [ User: intelifix - Total duration: 8m59s - Times executed: 1052 ]
[ Application: [unknown] - Total duration: 8m59s - Times executed: 1052 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264124", "modelo" : "320", "itens" : "241619675158,241665895056,241682659194,241694684959,241703950825,241664089908,241606938203,241595712528,241717088706,241661324251,241617351217,241728728999,241700303151,241614482340,241646416578,241712799701,241728794259,241608080728,241649267294,241695035577,241672339399,241691011324,241653940613,241646366472,241616898085,241731022333,241697010316,241731419295,241674421725,241703655969,241622599292,241598929395,241672416882,241619861114,241663820208,241617966787,241603050102,241659729404,241668310826,241671514157,241659791835,241672352937,241628233345,241603057778,241594043858,241732812732,241674553051,241696771123", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-08 14:05:05 Duration: 3s367ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264155", "modelo" : "320", "itens" : "241670366480,230049197696,241669935877,241682641921,241694436775,241714866771,241619353556,241651985977,241635504851,241603309295,241672934464,241672973637,241726984464,241674382428,241663286081,241619932030,241701259191,241620286991,241734111939,230047908692,241672997376,241660721028,241669688805,241659809008,241703928903,241715584754,241637522344,241653308193,241653422627,241691573960,241704380317,241667799608,241665897783,241670414667,241654536282,241715586976,230057050102,241655678908,241659816887,241690932427,241730207191,241689805762,241716577387,241634909002,241734098503,241708948595,241676848404,241597914662", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-08 14:28:27 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "264124", "modelo" : "320", "itens" : "241726898091,241649284950,241649342835,241602906271,241609898806,241714399396,230040455979,241674596971,241596110424,241595285157,241693006467,241664259093,230043577282,241653281121,241630185555,241676793146,241691111132,241653837392,241653199192,241664786272,241667593247,241676324054,241631048097,241635565261,230049407189,241638231717,241649334753,241619395759,835028905003777,241652189409,230048942745,241651387377,241655581828,241597860819,241630093246,241619341737,241680281837,241673165676,230048065779,241649825766,241605400410,241615148599,241712824451,230048990202,241594654658,241635674868,241619851618,241689058204", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-08 14:02:22 Duration: 2s291ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 387 2h4m54s 153ms 8m34s 19s365ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 08 07 19 13m36s 42s952ms 08 35 2m16s 3s904ms 09 29 14m4s 29s133ms 10 53 19m44s 22s353ms 11 33 13m15s 24s97ms 12 16 9m28s 35s527ms 13 16 23s960ms 1s497ms 14 51 9m4s 10s675ms 15 50 21m10s 25s401ms 16 39 14m42s 22s624ms 17 41 6m48s 9s952ms 18 5 19s494ms 3s898ms [ User: intelifix - Total duration: 2h4m54s - Times executed: 387 ]
[ Application: [unknown] - Total duration: 2h4m54s - Times executed: 387 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-08 16:14:13 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026797, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');
Date: 2026-07-08 14:43:03 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026779, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-08 10:58:17 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 316 51s318ms 150ms 247ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 08 05 5 806ms 161ms 07 2 306ms 153ms 08 17 2s747ms 161ms 09 50 8s301ms 166ms 10 37 6s87ms 164ms 11 48 7s754ms 161ms 12 10 1s645ms 164ms 13 34 5s440ms 160ms 14 31 4s997ms 161ms 15 40 6s402ms 160ms 16 30 4s831ms 161ms 17 12 1s997ms 166ms [ User: intelifix - Total duration: 51s318ms - Times executed: 316 ]
[ Application: [unknown] - Total duration: 51s318ms - Times executed: 316 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-08 10:00:25 Duration: 247ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-07-08 09:13:20 Duration: 209ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-08 10:56:42 Duration: 202ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 226 1m46s 150ms 1s757ms 473ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 08 08 18 10s881ms 604ms 09 95 49s264ms 518ms 10 38 21s930ms 577ms 14 22 7s105ms 322ms 15 53 17s722ms 334ms [ User: intelifix - Total duration: 1m46s - Times executed: 226 ]
[ Application: [unknown] - Total duration: 1m46s - Times executed: 226 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45285","seriais":"229784727878,229670624162,229749891629,229740274764,229865173654,229865385773,229745804563,229669714062,229933915772,229815885970,229784229009,229745810827,229784139808,229859601629,229782345368,229669005272,229782932934,229808863658,229665133940,229689058889,216932466781,229691632026,229669108087,229689434460,229816886382,229781783944,216944515353,229837217479,229809223244,229816654463,229836494446,229751344969,229815796668,229661423556,229674284261,229836502326,229810919717,229691054461","usuario":"416","observacao":""}');
Date: 2026-07-08 08:57:55 Duration: 1s757ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45285","seriais":"241693231215,241728679601,241659869596,241659753447,241676173658,241695528789,241676739807,241659655053,241728530721,241700957086,241603742526,241731197074,241673344156,241620734061,241728694552,241671551434,241731238290,241707514752,241645681221,241731234351,241654643644,241727017979,241631500522,241704277780,241675553238,241617399807,241659758700,241659824464,241727094149,241695609404,241695516768,241618000304,241607229600,241676711724,241656698187,241636027180,241728672126,241713336072,241646324044,241670287886,241649637083,241659674348,241695551116,241595012224,241659675459,241668207986,241618250912,241654562626,241663842937,241730924242","usuario":"416","observacao":""}');
Date: 2026-07-08 09:47:47 Duration: 1s444ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"45285","seriais":"D8313923EBD8,48D6822FD7BA,D89A0DA63A65,F00C514D2C20,14CA56D29701,D83139236AA2,D89A0D84B45D,D831399352C4,38914850E5C7,48D68238100A,D89A0DA46CA7,F4E84F86D608,6C11BA67ACA3,F4E84F891410,D89A0DA48A77,48D6823580A2,4896D956FA20,4896D94FE85A,6C11BA691851,D8313923A180,14CA56CD67AB,F4E84F86F38A,D8313920006A,48D6822FB9E4,6C11BA69834F,C4EBFF8D6216,843C99333131,6C11BA6909F3,D83139239F6A,D89A0DA8B7A9,D83139934F40,F00C514CF33E,D831398CCB16,3891484BDED9,6C11BA68240D,6C11BA66F1B9,D89A0DAC6E4F,D83139247266,D89A0DAFC411,D89A0DAC7473,D83139A113C8","usuario":"416","observacao":""}');
Date: 2026-07-08 09:49:42 Duration: 1s123ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 200 12m10s 150ms 13s56ms 3s652ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 08 00 7 30s618ms 4s374ms 01 8 25s527ms 3s190ms 02 7 24s908ms 3s558ms 03 8 24s855ms 3s106ms 04 7 22s28ms 3s146ms 05 8 27s116ms 3s389ms 06 6 25s560ms 4s260ms 07 6 26s276ms 4s379ms 08 6 33s73ms 5s512ms 09 6 32s985ms 5s497ms 10 7 38s967ms 5s566ms 11 8 32s477ms 4s59ms 12 8 34s151ms 4s268ms 13 6 33s778ms 5s629ms 14 6 31s710ms 5s285ms 15 12 45s983ms 3s831ms 16 12 47s908ms 3s992ms 17 12 33s671ms 2s805ms 18 12 28s531ms 2s377ms 19 12 30s824ms 2s568ms 20 12 38s196ms 3s183ms 21 12 31s48ms 2s587ms 22 12 30s307ms 2s525ms [ User: intelifix - Total duration: 12m10s - Times executed: 200 ]
[ Application: psql - Total duration: 12m10s - Times executed: 200 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 16:15:17 Duration: 13s56ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 20:15:12 Duration: 11s162ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 00:05:25 Duration: 10s869ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 167 7m23s 159ms 12s894ms 2s657ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 08 00 6 20s620ms 3s436ms 01 6 8s658ms 1s443ms 02 5 5s860ms 1s172ms 03 5 8s704ms 1s740ms 04 5 7s619ms 1s523ms 05 4 6s737ms 1s684ms 06 3 5s435ms 1s811ms 07 12 24s771ms 2s64ms 08 12 43s773ms 3s647ms 09 12 38s742ms 3s228ms 10 12 41s851ms 3s487ms 11 12 45s735ms 3s811ms 12 12 41s337ms 3s444ms 13 9 9s836ms 1s92ms 14 12 40s952ms 3s412ms 15 12 39s459ms 3s288ms 16 11 26s954ms 2s450ms 17 7 6s583ms 940ms 21 4 7s930ms 1s982ms 22 6 12s195ms 2s32ms [ User: intelifix - Total duration: 7m23s - Times executed: 167 ]
[ Application: psql - Total duration: 7m23s - Times executed: 167 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 00:05:14 Duration: 12s894ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 16:05:10 Duration: 8s89ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 14:55:09 Duration: 7s886ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 137 10m45s 1s66ms 18s292ms 4s714ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 08 07 3 10s303ms 3s434ms 08 10 33s148ms 3s314ms 09 16 56s283ms 3s517ms 10 14 44s221ms 3s158ms 11 16 1m46s 6s665ms 12 9 20s915ms 2s323ms 13 9 1m4s 7s171ms 14 14 1m3s 4s531ms 15 19 1m27s 4s609ms 16 13 1m9s 5s315ms 17 13 1m26s 6s635ms 18 1 3s490ms 3s490ms [ User: intelifix - Total duration: 10m45s - Times executed: 137 ]
[ Application: [unknown] - Total duration: 10m45s - Times executed: 137 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 15:19:18 Duration: 18s292ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 14:47:05 Duration: 17s313ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 11:04:04 Duration: 15s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 134 45s374ms 150ms 7s126ms 338ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 08 08 1 170ms 170ms 09 2 322ms 161ms 10 3 2s631ms 877ms 11 7 4s323ms 617ms 12 4 757ms 189ms 13 4 706ms 176ms 14 20 17s951ms 897ms 15 52 10s30ms 192ms 16 29 5s820ms 200ms 17 12 2s660ms 221ms [ User: intelifix - Total duration: 45s374ms - Times executed: 134 ]
[ Application: [unknown] - Total duration: 45s374ms - Times executed: 134 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-08", "data-ate" : "2026-07-08", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-07-08 14:23:29 Duration: 7s126ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-08", "data-ate" : "2026-07-08", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-07-08 14:24:22 Duration: 4s233ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-08", "data-ate" : "2026-07-08", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 507 }');
Date: 2026-07-08 14:26:00 Duration: 3s243ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 131 55s377ms 150ms 752ms 422ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 08 07 4 1s491ms 372ms 08 13 5s752ms 442ms 09 13 5s599ms 430ms 10 11 4s847ms 440ms 11 14 5s879ms 419ms 12 5 1s944ms 388ms 13 3 1s407ms 469ms 14 21 8s862ms 422ms 15 18 7s956ms 442ms 16 10 3s971ms 397ms 17 14 5s631ms 402ms 18 5 2s33ms 406ms [ User: intelifix - Total duration: 55s377ms - Times executed: 131 ]
[ Application: [unknown] - Total duration: 55s377ms - Times executed: 131 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-08 14:41:04 Duration: 752ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-08 09:59:46 Duration: 672ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-08 09:26:53 Duration: 607ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 130 26s448ms 150ms 503ms 203ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 08 04 3 509ms 169ms 05 15 3s379ms 225ms 07 12 2s546ms 212ms 08 16 3s182ms 198ms 09 13 2s774ms 213ms 10 19 3s660ms 192ms 11 15 2s910ms 194ms 12 14 2s656ms 189ms 14 7 1s580ms 225ms 15 14 2s828ms 202ms 16 2 419ms 209ms [ User: intelifix - Total duration: 26s448ms - Times executed: 130 ]
[ Application: [unknown] - Total duration: 26s448ms - Times executed: 130 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229839522430,229862176279,229851780114,229840800322,229763178390,229842492731,229763232538,229840759307,229842995361,229855545273,229862075158,229856961618,229845713034', NULL, NULL, 0160, 00);
Date: 2026-07-08 05:10:53 Duration: 503ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230030082644,230031821119,230009831936,230032468285,229988051920,230010404954,230027214552,230053213038,230023116576', NULL, NULL, 0295, 00);
Date: 2026-07-08 07:30:39 Duration: 349ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241730915274,241605373841,241695586068,241617428193,241676720311,241729919105,241732088182,241715043557,241610943038,241673106478,241622495770,241637489209,241669507597,241635968891,241729516888,241616195963,241646287575,241668281025', NULL, NULL, 0320, 00);
Date: 2026-07-08 15:08:31 Duration: 320ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 112 1m9s 162ms 2s952ms 618ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 08 07 10 6s876ms 687ms 08 12 5s728ms 477ms 09 3 2s280ms 760ms 10 17 12s388ms 728ms 11 9 3s819ms 424ms 13 4 2s421ms 605ms 14 14 11s918ms 851ms 15 10 5s701ms 570ms 16 12 5s779ms 481ms 17 21 12s410ms 590ms [ User: intelifix - Total duration: 1m9s - Times executed: 112 ]
[ Application: [unknown] - Total duration: 1m9s - Times executed: 112 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0263752) LIMIT 1;
Date: 2026-07-08 10:43:07 Duration: 2s952ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0127429) LIMIT 1;
Date: 2026-07-08 14:55:05 Duration: 2s801ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0263756) LIMIT 1;
Date: 2026-07-08 14:02:30 Duration: 1s541ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 106 50s864ms 297ms 786ms 479ms 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 #13
Day Hour Count Duration Avg duration Jul 08 01 1 427ms 427ms 04 2 772ms 386ms 05 1 436ms 436ms 06 1 512ms 512ms 07 5 1s830ms 366ms 08 13 6s87ms 468ms 09 10 4s488ms 448ms 10 11 6s4ms 545ms 11 9 4s919ms 546ms 12 5 2s230ms 446ms 13 9 4s229ms 469ms 14 12 5s926ms 493ms 15 9 4s751ms 527ms 16 7 3s429ms 489ms 17 6 2s767ms 461ms 18 2 791ms 395ms 21 3 1s260ms 420ms [ User: lenon - Total duration: 50s864ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 50s864ms - Times executed: 106 ]
-
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-07-08 09:17:47 Duration: 786ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-08 10:23:19 Duration: 770ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-08 14:01:10 Duration: 767ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 98 58s356ms 370ms 956ms 595ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 08 01 1 654ms 654ms 04 2 1s2ms 501ms 05 1 549ms 549ms 07 4 1s850ms 462ms 08 11 6s357ms 577ms 09 9 5s272ms 585ms 10 11 7s97ms 645ms 11 9 5s878ms 653ms 12 4 2s325ms 581ms 13 9 5s136ms 570ms 14 11 6s738ms 612ms 15 9 5s720ms 635ms 16 7 4s255ms 607ms 17 6 3s358ms 559ms 18 2 1s117ms 558ms 21 2 1s39ms 519ms [ User: intelifix - Total duration: 58s356ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 58s356ms - Times executed: 98 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-08 14:01:10 Duration: 956ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-08 11:14:50 Duration: 934ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-07-08 10:23:19 Duration: 873ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 86 45s723ms 331ms 2s395ms 531ms create table temp0000226577 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 08 13 58 31s565ms 544ms 14 28 14s157ms 505ms [ User: intelifix - Total duration: 45s723ms - Times executed: 86 ]
[ Application: [unknown] - Total duration: 45s723ms - Times executed: 86 ]
-
CREATE TABLE temp0000226577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-08 13:45:57 Duration: 2s395ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000226577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-08 13:55:05 Duration: 810ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000226577 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-08 13:49:01 Duration: 752ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 84 20s253ms 151ms 951ms 241ms create table temp0000235622 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 08 13 14 3s721ms 265ms 14 16 3s558ms 222ms 15 11 2s783ms 253ms 16 14 3s921ms 280ms 17 29 6s268ms 216ms [ User: intelifix - Total duration: 20s253ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 20s253ms - Times executed: 84 ]
-
CREATE TABLE temp0000235622 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "03-07-2026", "data-ate" : "08-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-08 13:15:51 Duration: 951ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000235622 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "08-07-2026", "data-ate" : "08-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-08 15:24:07 Duration: 449ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000235622 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "08-07-2026", "data-ate" : "08-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-08 16:42:43 Duration: 400ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 76 16m22s 9s204ms 34s506ms 12s921ms create table temp0000284756 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 08 07 13 2m39s 12s259ms 08 3 39s841ms 13s280ms 09 12 2m25s 12s92ms 10 14 3m11s 13s712ms 11 10 2m1s 12s114ms 12 7 1m14s 10s659ms 14 3 44s919ms 14s973ms 15 11 2m24s 13s145ms 16 3 1m 20s164ms [ User: intelifix - Total duration: 16m22s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 76 ]
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 07:06:05 Duration: 34s506ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 16:18:07 Duration: 33s413ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 15:01:13 Duration: 17s762ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 70 1m36s 191ms 13s596ms 1s381ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 08 07 5 2s894ms 578ms 08 1 610ms 610ms 09 10 18s656ms 1s865ms 10 11 20s815ms 1s892ms 11 7 9s422ms 1s346ms 12 4 4s279ms 1s69ms 14 14 26s491ms 1s892ms 15 6 8s249ms 1s374ms 16 4 1s340ms 335ms 17 8 3s946ms 493ms [ User: intelifix - Total duration: 1m36s - Times executed: 70 ]
[ Application: psql - Total duration: 1m36s - Times executed: 70 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026794);
Date: 2026-07-08 14:14:56 Duration: 13s596ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026769);
Date: 2026-07-08 09:40:26 Duration: 8s60ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026795);
Date: 2026-07-08 14:19:09 Duration: 7s242ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 67 14m23s 10s180ms 16s693ms 12s883ms create table temp0000284782 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 08 08 1 11s874ms 11s874ms 09 16 3m33s 13s360ms 10 19 4m16s 13s490ms 11 11 2m23s 13s12ms 12 3 31s59ms 10s353ms 13 1 11s267ms 11s267ms 14 11 2m11s 11s930ms 15 5 1m4s 12s906ms [ User: intelifix - Total duration: 14m23s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 14m23s - Times executed: 67 ]
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 09:31:59 Duration: 16s693ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 10:00:21 Duration: 16s200ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 11:08:37 Duration: 15s641ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 67 46s753ms 457ms 1s388ms 697ms create table temp0000284836 as select * from rs_fluxos_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 08 13 29 18s616ms 641ms 14 16 11s145ms 696ms 15 17 12s539ms 737ms 16 2 2s184ms 1s92ms 17 3 2s268ms 756ms [ User: intelifix - Total duration: 46s753ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 46s753ms - Times executed: 67 ]
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '08-07-2026', '08-07-2026', 0, '', 00);
Date: 2026-07-08 16:25:49 Duration: 1s388ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '08-07-2026', '08-07-2026', 0, '', 00);
Date: 2026-07-08 13:43:07 Duration: 1s65ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_FLUXOS_LISTA (06, 00, 00, '08-07-2026', '08-07-2026', 0, '', 00);
Date: 2026-07-08 14:59:40 Duration: 1s19ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m23s 8m44s 5m5s 3 15m15s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 08 05 3 15m15s 5m5s [ User: intelifix - Total duration: 15m15s - Times executed: 3 ]
[ Application: psql - Total duration: 15m15s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-08 05:08:45 Duration: 8m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-07-08 05:12:53 Duration: 4m7s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
analyze verbose;
Date: 2026-07-08 05:15:17 Duration: 2m23s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 4m37s 4m37s 4m37s 1 4m37s select * from rs_smart_fiscal_saida () / 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 (/ 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 (/ 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 #2
Day Hour Count Duration Avg duration Jul 08 11 1 4m37s 4m37s [ User: intelifix - Total duration: 4m37s - Times executed: 1 ]
[ Application: psql - Total duration: 4m37s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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 (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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 (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: 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-07-08 11:19:59 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 1s395ms 9m19s 2m48s 46 2h8m52s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 08 07 3 8m10s 2m43s 08 3 7m25s 2m28s 09 3 9m53s 3m17s 10 3 9m55s 3m18s 11 2 9m12s 4m36s 12 3 8m7s 2m42s 13 3 6m34s 2m11s 14 3 8m48s 2m56s 15 2 9m33s 4m46s 16 3 9m1s 3m 17 3 8m55s 2m58s 18 3 7m20s 2m26s 19 3 5m53s 1m57s 20 3 6m18s 2m6s 21 3 5m59s 1m59s 22 3 7m43s 2m34s [ User: intelifix - Total duration: 2h8m52s - Times executed: 46 ]
[ Application: psql - Total duration: 2h8m52s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-08 10:14:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-08 09:14:14 Duration: 9m12s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-08 15:14:05 Duration: 9m4s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 2m9s 2m9s 2m9s 1 2m9s copy auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 08 23 1 2m9s 2m9s [ User: intelifix - Total duration: 2m9s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 2m9s - Times executed: 1 ]
-
COPY auditor.auditor_2026_05 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-08 23:13:46 Duration: 2m9s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 352ms 5m10s 1m36s 45 1h12m13s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 08 07 3 4m44s 1m34s 08 3 4m58s 1m39s 09 3 6m22s 2m7s 10 3 5m42s 1m54s 11 1 1m7s 1m7s 12 2 3m40s 1m50s 13 3 4m19s 1m26s 14 3 5m29s 1m49s 15 3 5m26s 1m48s 16 3 5m9s 1m43s 17 3 4m49s 1m36s 18 3 4m11s 1m23s 19 3 3m38s 1m12s 20 3 4m8s 1m22s 21 3 3m44s 1m14s 22 3 4m40s 1m33s [ User: intelifix - Total duration: 1h12m13s - Times executed: 45 ]
[ Application: psql - Total duration: 1h12m13s - Times executed: 45 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-08 09:21:09 Duration: 5m10s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-08 10:20:31 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-08 14:19:14 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 7s520ms 2m4s 1m5s 2 2m11s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 08 23 2 2m11s 1m5s [ User: intelifix - Total duration: 2m11s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m11s - Times executed: 2 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-08 23:15:50 Duration: 2m4s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-08 23:43:10 Duration: 7s520ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 4s711ms 1m31s 1m2s 3 3m6s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 08 20 2 1m36s 48s254ms 23 1 1m30s 1m30s [ User: intelifix - Total duration: 3m6s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 3 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-08 20:08:36 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-08 23:42:33 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-08 20:10:22 Duration: 4s711ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 1s9ms 2m8s 54s874ms 20 18m17s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 08 08 6 39s97ms 6s516ms 11 2 7s615ms 3s807ms 13 2 3m36s 1m48s 14 6 11m44s 1m57s 15 1 2m4s 2m4s 16 2 2s359ms 1s179ms 17 1 3s412ms 3s412ms [ User: intelifix - Total duration: 18m17s - Times executed: 20 ]
[ Application: psql - Total duration: 18m17s - Times executed: 20 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01508);
Date: 2026-07-08 14:51:54 Duration: 2m8s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01510);
Date: 2026-07-08 15:34:06 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01506);
Date: 2026-07-08 14:36:00 Duration: 1m59s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 441ms 1m2s 30s581ms 4 2m2s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 08 20 2 59s566ms 29s783ms 23 2 1m2s 31s379ms [ User: intelifix - Total duration: 2m2s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m2s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-08 23:19:56 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-08 20:05:23 Duration: 59s122ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-08 20:09:49 Duration: 443ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 153ms 8m34s 19s365ms 387 2h4m54s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 08 07 19 13m36s 42s952ms 08 35 2m16s 3s904ms 09 29 14m4s 29s133ms 10 53 19m44s 22s353ms 11 33 13m15s 24s97ms 12 16 9m28s 35s527ms 13 16 23s960ms 1s497ms 14 51 9m4s 10s675ms 15 50 21m10s 25s401ms 16 39 14m42s 22s624ms 17 41 6m48s 9s952ms 18 5 19s494ms 3s898ms [ User: intelifix - Total duration: 2h4m54s - Times executed: 387 ]
[ Application: [unknown] - Total duration: 2h4m54s - Times executed: 387 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2026-05-01''),DATE(''2026-05-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-08 16:14:13 Duration: 8m34s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026797, 0503 )', '/var/www/html/tmp/nf_carga_lotes_0503.xlsx');
Date: 2026-07-08 14:43:03 Duration: 7m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026779, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-08 10:58:17 Duration: 6m27s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 9s204ms 34s506ms 12s921ms 76 16m22s create table temp0000284756 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 08 07 13 2m39s 12s259ms 08 3 39s841ms 13s280ms 09 12 2m25s 12s92ms 10 14 3m11s 13s712ms 11 10 2m1s 12s114ms 12 7 1m14s 10s659ms 14 3 44s919ms 14s973ms 15 11 2m24s 13s145ms 16 3 1m 20s164ms [ User: intelifix - Total duration: 16m22s - Times executed: 76 ]
[ Application: [unknown] - Total duration: 16m22s - Times executed: 76 ]
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 07:06:05 Duration: 34s506ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 16:18:07 Duration: 33s413ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 15:01:13 Duration: 17s762ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 10s180ms 16s693ms 12s883ms 67 14m23s create table temp0000284782 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 08 08 1 11s874ms 11s874ms 09 16 3m33s 13s360ms 10 19 4m16s 13s490ms 11 11 2m23s 13s12ms 12 3 31s59ms 10s353ms 13 1 11s267ms 11s267ms 14 11 2m11s 11s930ms 15 5 1m4s 12s906ms [ User: intelifix - Total duration: 14m23s - Times executed: 67 ]
[ Application: [unknown] - Total duration: 14m23s - Times executed: 67 ]
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 09:31:59 Duration: 16s693ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 10:00:21 Duration: 16s200ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284782 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 11:08:37 Duration: 15s641ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 9s400ms 14s452ms 11s951ms 43 8m33s create table temp0000284836 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 08 14 21 4m20s 12s389ms 15 7 1m22s 11s766ms 16 5 59s319ms 11s863ms 17 10 1m52s 11s203ms [ User: intelifix - Total duration: 8m33s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m33s - Times executed: 43 ]
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 14:52:26 Duration: 14s452ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 15:40:38 Duration: 14s173ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-08 14:39:18 Duration: 13s869ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 4s412ms 14s241ms 5s882ms 35 3m25s create table temp0000284836 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 08 14 14 1m19s 5s703ms 15 5 25s991ms 5s198ms 16 3 24s148ms 8s49ms 17 13 1m15s 5s839ms [ User: intelifix - Total duration: 3m25s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 3m25s - Times executed: 35 ]
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 17:28:01 Duration: 14s241ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 16:23:29 Duration: 12s594ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284836 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 14:48:59 Duration: 6s347ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 3s232ms 12s583ms 4s979ms 42 3m29s create table temp0000284756 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 08 07 17 1m16s 4s509ms 08 2 7s861ms 3s930ms 09 4 21s260ms 5s315ms 10 2 11s321ms 5s660ms 11 9 47s343ms 5s260ms 14 2 11s610ms 5s805ms 15 6 33s70ms 5s511ms [ User: intelifix - Total duration: 3m29s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 3m29s - Times executed: 42 ]
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 07:20:21 Duration: 12s583ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 10:43:57 Duration: 6s428ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CREATE TABLE temp0000284756 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"03-07-2026", "ate" :"08-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-08 09:37:16 Duration: 6s396ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 1s66ms 18s292ms 4s714ms 137 10m45s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 08 07 3 10s303ms 3s434ms 08 10 33s148ms 3s314ms 09 16 56s283ms 3s517ms 10 14 44s221ms 3s158ms 11 16 1m46s 6s665ms 12 9 20s915ms 2s323ms 13 9 1m4s 7s171ms 14 14 1m3s 4s531ms 15 19 1m27s 4s609ms 16 13 1m9s 5s315ms 17 13 1m26s 6s635ms 18 1 3s490ms 3s490ms [ User: intelifix - Total duration: 10m45s - Times executed: 137 ]
[ Application: [unknown] - Total duration: 10m45s - Times executed: 137 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 15:19:18 Duration: 18s292ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 14:47:05 Duration: 17s313ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-08', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-08 11:04:04 Duration: 15s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
17 150ms 13s56ms 3s652ms 200 12m10s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 08 00 7 30s618ms 4s374ms 01 8 25s527ms 3s190ms 02 7 24s908ms 3s558ms 03 8 24s855ms 3s106ms 04 7 22s28ms 3s146ms 05 8 27s116ms 3s389ms 06 6 25s560ms 4s260ms 07 6 26s276ms 4s379ms 08 6 33s73ms 5s512ms 09 6 32s985ms 5s497ms 10 7 38s967ms 5s566ms 11 8 32s477ms 4s59ms 12 8 34s151ms 4s268ms 13 6 33s778ms 5s629ms 14 6 31s710ms 5s285ms 15 12 45s983ms 3s831ms 16 12 47s908ms 3s992ms 17 12 33s671ms 2s805ms 18 12 28s531ms 2s377ms 19 12 30s824ms 2s568ms 20 12 38s196ms 3s183ms 21 12 31s48ms 2s587ms 22 12 30s307ms 2s525ms [ User: intelifix - Total duration: 12m10s - Times executed: 200 ]
[ Application: psql - Total duration: 12m10s - Times executed: 200 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 16:15:17 Duration: 13s56ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 20:15:12 Duration: 11s162ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-08 00:05:25 Duration: 10s869ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
18 159ms 12s894ms 2s657ms 167 7m23s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 08 00 6 20s620ms 3s436ms 01 6 8s658ms 1s443ms 02 5 5s860ms 1s172ms 03 5 8s704ms 1s740ms 04 5 7s619ms 1s523ms 05 4 6s737ms 1s684ms 06 3 5s435ms 1s811ms 07 12 24s771ms 2s64ms 08 12 43s773ms 3s647ms 09 12 38s742ms 3s228ms 10 12 41s851ms 3s487ms 11 12 45s735ms 3s811ms 12 12 41s337ms 3s444ms 13 9 9s836ms 1s92ms 14 12 40s952ms 3s412ms 15 12 39s459ms 3s288ms 16 11 26s954ms 2s450ms 17 7 6s583ms 940ms 21 4 7s930ms 1s982ms 22 6 12s195ms 2s32ms [ User: intelifix - Total duration: 7m23s - Times executed: 167 ]
[ Application: psql - Total duration: 7m23s - Times executed: 167 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 00:05:14 Duration: 12s894ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 16:05:10 Duration: 8s89ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-08 14:55:09 Duration: 7s886ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
19 191ms 13s596ms 1s381ms 70 1m36s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 08 07 5 2s894ms 578ms 08 1 610ms 610ms 09 10 18s656ms 1s865ms 10 11 20s815ms 1s892ms 11 7 9s422ms 1s346ms 12 4 4s279ms 1s69ms 14 14 26s491ms 1s892ms 15 6 8s249ms 1s374ms 16 4 1s340ms 335ms 17 8 3s946ms 493ms [ User: intelifix - Total duration: 1m36s - Times executed: 70 ]
[ Application: psql - Total duration: 1m36s - Times executed: 70 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026794);
Date: 2026-07-08 14:14:56 Duration: 13s596ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026769);
Date: 2026-07-08 09:40:26 Duration: 8s60ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT RS_SETGLOBAL ('USUARIO', 404); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026795);
Date: 2026-07-08 14:19:09 Duration: 7s242ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-08.log
20 150ms 2m19s 975ms 1,403 22m49s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 08 07 10 3s142ms 314ms 08 87 1m31s 1s57ms 09 221 3m30s 950ms 10 157 3m6s 1s189ms 11 181 2m26s 809ms 12 85 1m2s 729ms 13 78 1m5s 845ms 14 171 2m40s 937ms 15 233 5m17s 1s361ms 16 115 1m19s 690ms 17 65 45s852ms 705ms [ User: intelifix - Total duration: 22m49s - Times executed: 1403 ]
[ Application: [unknown] - Total duration: 22m49s - Times executed: 1403 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (264173, 184, 'F200011174B2E51,9877E7BF0C86', '',0153,00,'[{"item":"0","qrcode":""}]','', '', 00);
Date: 2026-07-08 15:07:15 Duration: 2m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (263386, 304, 'ZTE3ANNQCA43866,14CA56D648F7,14CA56D648F8,ZTEGD97210C5$ZTE3ANNQCA36909,14CA56D5A5E9,14CA56D5A5EA,ZTEGD971F598$ZTE3ANNQ8M04309,843C991F2CE9,843C991F2CEA,ZTEGD7BA5842$ZTE3ANNQ8F15132,689E29FD8585,689E29FD8586,ZTEGD7BA37EC$ZTE3ANNR1Y45196,14CA56D0CDC3,14CA56D0CDC4,ZTEGD97126E7$ZTE3ANNR1Y25630,14CA56CF032F,14CA56CF0330,ZTEGD970DA79$ZTE3ANNRCP62912,6C11BA6EED4F,6C11BA6EED50,ZTEGDC703653$ZTE3ANNQ9J16917,843C992D5DB3,843C992D5DB4,ZTEGD7BB4AC0$ZTE3ANNRCP15543,6C11BA6A9719,6C11BA6A971A,ZTEGDC6F7D4A$ZTE3ANNQ5B14654,3CF9F0AFD72E,3CF9F0AFD72F,ZTEGD642393B$ZTE3ANNQ7506256,C4EBFF8B85DC,C4EBFF8B85DD,ZTEGD70A6710$ZTE3ANNT3H77902,D831399DE56C,D831399DE56D,ZTEGDD3300ED$ZTE3ANNR8C53130,389148536443,389148536444,ZTEGDB094FFA$ZTE3ANNQCA34875,14CA56D5763D,14CA56D5763E,ZTEGD971EDA6$ZTE3ANNR8C49974,389148531A4B,389148531A4C,ZTEGDB0943A6$ZTE3ANNR9318406,D89A0D840F6F,D89A0D840F70,ZTEGDB14BBE5$ZTE3ANNRC544425,6C11BA663B0D,6C11BA663B0E,ZTEGDC6EC348$ZTE3ANNRC522479,6C11BA6438B1,6C11BA6438B2,ZTEGDC6E6D8E$ZTE3ANNR3Y60327,4896D95546A2,4896D95546A3,ZTEGD97F1C5C$ZTE3ANNT2V43807,D831398F9192,D831398F9193,ZTEGDD309D9E$ZTE3ANNR6R24784,48D68237C9A2,48D68237C9A3,ZTEGDB018BA3$ZTE3ANNR2Q54455,F4E84F85B04A,F4E84F85B04B,ZTEGD97B4771$ZTE3ANNT3H80180,D831399E1AD0,D831399E1AD1,ZTEGDD3309D3$ZTE3ANNR9W09189,D89A0DA93381,D89A0DA93382,ZTEGDB163590$ZTE3ANNR2Q12469,F4E84F81D83E,F4E84F81D83F,ZTEGD97AA36F$ZTE3ANNRB729778,5872C990F31D,5872C990F31E,ZTEGDC619F25$ZTE3ANNRC509693,6C11BA630D05,6C11BA630D06,ZTEGDC6E3B9C$ZTE3ANNR7B51587,3891484DA5B9,3891484DA5BA,ZTEGDB085AE3$ZTE3ANNRC521662,6C11BA64258B,6C11BA64258C,ZTEGDC6E6A5D$ZTE3ANNR9F57758,D89A0DA82797,D89A0DA82798,ZTEGDB1608E9$ZTE3ANNQ7911936,C4EBFF8D35D0,C4EBFF8D35D1,ZTEGD70AAF0E$ZTE3ANNQCA27621,14CA56D4CC39,14CA56D4CC3A,ZTEGD971D150$ZTE3ANNQ5N07272,3CF9F0AD6FE6,3CF9F0AD6FE7,ZTEGD641D2AF$ZTE3ANNQ3R23960,3CF9F0A4B156,3CF9F0A4B157,ZTEGD6405D97$ZTE3ANNR8C21528,389148507F97,389148507F98,ZTEGDB08D488$ZTE3ANNRAD12637,D89A0DAF0291,D89A0DAF0292,ZTEGDB172D68$ZTE3ANNQ9J19531,843C992D9AF7,843C992D9AF8,ZTEGD7BB54F6$ZTE3ANNR9W08638,D89A0DA92697,D89A0DA92698,ZTEGDB163369$ZTE3ANNR6R14117,48D68236CFA0,48D68236CFA1,ZTEGDB0161F8$ZTE3ANNR9F33718,D89A0DA5F427,D89A0DA5F428,ZTEGDB15AB01', '', 0318, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', 'SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE||SEM BASE', 00);
Date: 2026-07-08 10:37:31 Duration: 5s868ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (45258, 418, 'ZTE3ANNRCB04911,D831391E4218,D831391E4219,ZTEGDD29C8C4$ZTE3ANNR8C34638,38914851B2DB,38914851B2DC,ZTEGDB0907BE$ZTE3ANNR8C35337,38914851C33D,38914851C33E,ZTEGDB090A79$ZTE3ANNRCP04044,6C11BA698997,6C11BA698998,ZTEGDC6F505F$ZTE3ANNQ8M18862,843C992081FF,843C99208200,ZTEGD7BA911B$ZTE3ANNR5W08211,48D6822F443C,48D6822F443D,ZTEGDB002012$ZTE3ANNR6R16867,48D682371014,48D682371015,ZTEGDB016CB6$ZTE3ANNT3H83618,D831399E6B64,D831399E6B65,ZTEGDD331741$ZTE3ANNQ4N01693,3CF9F0A8B95C,3CF9F0A8B95D,ZTEGD6410998$ZTE3ANNRAM54460,5872C98C34A1,5872C98C34A2,ZTEGDC60D4BB$ZTE3ANNR9F58337,D89A0DA83529,D89A0DA8352A,ZTEGDB160B2C$ZTE3ANNR3J15476,F4E84F87B918,F4E84F87B919,ZTEGD97B9E3E$ZTE3ANNQ8M41225,843C99228E21,843C99228E22,ZTEGD7BAE876$ZTE3ANNT4P14210,F00C514CF3AA,F00C514CF3AB,ZTEGDE342E18$ZTE3ANNR7B00224,38914848F1E7,38914848F1E8,ZTEGDB079240$ZTE3ANNR1Y08339,14CA56CD6DED,14CA56CD6DEE,ZTEGD97096EE$ZTE3ANNQ4N02057,3CF9F0A8C1E4,3CF9F0A8C1E5,ZTEGD6410B04$ZTE3ANNQ9J21166,843C992DC149,843C992DC14A,ZTEGD7BB5B59$ZTE3ANNQ4A00617,3CF9F0AA06BC,3CF9F0AA06BD,ZTEGD6414128$ZTE3ANNR1Y03286,14CA56CCF77F,14CA56CCF780,ZTEGD9708331$ZTE3ANNRAM22871,5872C9895043,5872C9895044,ZTEGDC605956$ZTE3ANNR4N17727,4896D956FA92,4896D956FA93,ZTEGD97F6504$ZTE3ANNQ7503061,C4EBFF8B3AFA,C4EBFF8B3AFB,ZTEGD70A5A95$ZTE3ANNT3F09262,D831399604DC,D831399604DD,ZTEGDD31B0D5$ZTE3ANNQ3608910,3CF9F0A5A642,3CF9F0A5A643,ZTEGD6408669$ZTE3ANNQ5B04873,3CF9F0AEF1F0,3CF9F0AEF1F1,ZTEGD6421306$ZTE3ANNRC551260,6C11BA66DB3F,6C11BA66DB40,ZTEGDC6EDDFB$ZTE3ANNRAM63602,5872C98D0AE5,5872C98D0AE6,ZTEGDC60F871$ZTE3ANNR7B32440,3891484BE4F7,3891484BE4F8,ZTEGDB081018$ZTE3ANNRCB23879,D831391FFEA8,D831391FFEA9,ZTEGDD2A12DC$ZTE3ANNR3Y03564,4896D9501440,4896D9501441,ZTEGD97E3EA1$ZTE3ANNQ9J08016,843C992C8D15,843C992C8D16,ZTEGD7BB27FB', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-08 13:36:32 Duration: 4s736ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 08 14 1 0ms 0ms 18 2 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 7s4ms - Times executed: 5 ]
[ Application: psql - Total duration: 5s977ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1s27ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,535 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 FATAL entries
- 4572 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,450 Max number of times the same event was reported
- 4,598 Total events found
Rank Times reported Error 1 4,450 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 08 00 118 01 118 02 118 03 120 04 119 05 119 06 120 07 213 08 308 09 392 10 322 11 491 12 182 13 184 14 328 15 415 16 291 17 141 18 59 19 60 20 59 21 60 22 59 23 54 - ERROR: prepared statement "_PLAN0000000029F76320" does not exist
- ERROR: prepared statement "_PLAN000000002A36F840" does not exist
- ERROR: prepared statement "_PLAN0000000029F1AE50" does not exist
Statement: DEALLOCATE "_PLAN0000000029F76320"
Date: 2026-07-08 00:00:09 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: DEALLOCATE "_PLAN000000002A36F840"
Date: 2026-07-08 00:00:29 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: DEALLOCATE "_PLAN0000000029F1AE50"
Date: 2026-07-08 00:01:10 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 08 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 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-07-08 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.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-07-08 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.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-07-08 01:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 08 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-08 08:00:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-08 08:20:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-08 08:40:11 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
4 12 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 08 11 12 - ERROR: trailing junk after numeric literal at or near "24E4CEDB75FA" at character 27
- ERROR: trailing junk after numeric literal at or near "24E4CEDB75FA" at character 27
- ERROR: trailing junk after numeric literal at or near "24E4CEDB75FA" at character 27
Statement: SELECT * FROM RS_ETIQUETA(24E4CEDB75FA)
Date: 2026-07-08 11:24:53 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_ETIQUETA(24E4CEDB75FA)
Date: 2026-07-08 11:24:54 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_ETIQUETA(24E4CEDB75FA)
Date: 2026-07-08 11:24:54 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 08 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-08 03:05:01 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-07-08 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-07-08 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
6 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 08 09 1 12 2 15 2 17 4 - ERROR: syntax error at or near "216726" at character 32
- ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near ")" at character 34
Statement: SELECT RS_SERIAL_TEMPORARIO( ''216726'381024' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''216726'381024' )
Date: 2026-07-08 09:33:15 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: select * from rs_caixa_qr(378135,)
Date: 2026-07-08 12:25:14 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: select * from rs_caixa_qr(378135,)
Date: 2026-07-08 12:25:14 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
7 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 08 00 1 06 1 09 1 14 1 15 1 16 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-08 00:02:08 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-07-08 06:02:08 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-07-08 09:04:28 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
8 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 08 05 4 08 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-08 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-08 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-08 05:32:13 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
9 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 08 15 4 - LOG: process 3880670 still waiting for ShareLock on transaction 2340026 after 1001.821 ms
- LOG: process 3880670 still waiting for ShareLock on transaction 2340026 after 9151.296 ms
- LOG: process 3880670 still waiting for ShareLock on transaction 2340026 after 64221.862 ms
Detail: Process holding the lock: 3814653. Wait queue: 3880670.
Context: while updating tuple (18716,39) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(264173,184,'F200011174B2E51,9877E7BF0C86','',0153,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-07-08 15:04:57 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 3814653. Wait queue: 3880670.
Context: while updating tuple (18716,39) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(264173,184,'F200011174B2E51,9877E7BF0C86','',0153,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-07-08 15:05:05 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 3814653. Wait queue: 3880670.
Context: while updating tuple (18716,39) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(264173,184,'F200011174B2E51,9877E7BF0C86','',0153,00,'[{"item":"0","qrcode":""}]','','',00);Date: 2026-07-08 15:06:00 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 08 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-08 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Date: 2026-07-08 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
11 2 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 08 09 1 15 1 - ERROR: unterminated quoted identifier at or near ""}')" at character 73
- ERROR: unterminated quoted identifier at or near ""}')" at character 73
Statement: SELECT * FROM RS_NOME_DEFEITO('{"oficina":"6","modelo":"305","codigo":"'"}')
Date: 2026-07-08 09:37:52 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Statement: SELECT * FROM RS_NOME_DEFEITO('{"oficina":"6","modelo":"320","codigo":"'"}')
Date: 2026-07-08 15:26:20 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
12 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 08 07 1 17 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000284756"
Date: 2026-07-08 07:45:44 Log file: /usr/local/pgsql/data/log/serverlog-08.log
Context: automatic vacuum of table "rio.public.temp0000284836"
Date: 2026-07-08 17:33:49 Log file: /usr/local/pgsql/data/log/serverlog-08.log
13 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 08 07 1 17 1 - LOG: process 3467666 still waiting for AccessExclusiveLock on relation 2120053 of database 358220 after 1000.200 ms
- LOG: process 3993287 still waiting for AccessExclusiveLock on relation 2180272 of database 358220 after 1000.235 ms
Detail: Process holding the lock: 3477514. Wait queue: 3467666.
Statement: DROP TABLE IF EXISTS temp0000284756;Date: 2026-07-08 07:45:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
Detail: Process holding the lock: 4012004. Wait queue: 3993287.
Statement: DROP TABLE IF EXISTS temp0000284836;Date: 2026-07-08 17:33:49 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-08.log
14 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 08 12 1 - ERROR: column c.eq_serie does not exist at character 28
Hint: Perhaps you meant to reference the column "c.li_serie".
Statement: SELECT B.FLU_ID,c.eq_id,c.eq_serie FROM LOTE_CAIXAS A INNER JOIN CAIXA_ITENS B ON B.CAI_ID = A.CAI_ID INNER JOIN LOTE_ITENS C ON C.FLU_ID = B.FLU_ID WHERE A.LOT_ID = 263804 AND EXISTS ( SELECT 1 FROM LOTE_ITENS D WHERE D.EQ_ID = C.EQ_ID AND D.LI_ID > C.LI_ID LIMIT 1 );Date: 2026-07-08 12:17:36 Database: rio Application: pgAdmin 4 - CONN:9707436 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-08.log
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 08 03 1 - LOG: database system was shut down at 2026-07-08 03:05:02 -03
Date: 2026-07-08 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-08.log
16 1 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 08 20 1 - LOG: could not receive data from client: Connection timed out
Date: 2026-07-08 20:19:03 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-08.log