pgBadger-
Global information
- Generated on Thu Jul 2 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 50,439 log entries in 10s
- Log start from 2026-07-01 00:00:19 to 2026-07-01 23:59:53
-
Overview
Global Stats
- 394 Number of unique normalized queries
- 6,672 Number of queries
- 8h33m31s Total query duration
- 2026-07-01 00:00:25 First query
- 2026-07-01 23:51:14 Last query
- 6 queries/s at 2026-07-01 10:47:01 Query peak
- 8h33m31s Total query duration
- 0ms Prepare/parse total duration
- 182ms Bind total duration
- 8h33m31s Execute total duration
- 5,288 Number of events
- 24 Number of unique normalized events
- 5,026 Max number of times the same event was reported
- 0 Number of cancellation
- 550 Total number of automatic vacuums
- 1,275 Total number of automatic analyzes
- 29 Number temporary file
- 232.68 MiB Max size of temporary file
- 105.45 MiB Average size of temporary file
- 367 Total number of sessions
- 11 sessions at 2026-07-01 01:04:54 Session peak
- 13d12h23m33s Total duration of sessions
- 53m2s Average duration of sessions
- 18 Average queries per session
- 1m23s Average queries duration per session
- 51m38s Average idle time per session
- 372 Total number of connections
- 5 connections/s at 2026-07-01 00:07:21 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-01 10:47:01 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-01 10:47:01 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-01 23:51:04 Date
Queries duration
Key values
- 8h33m31s 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 01 00 68 0ms 5m18s 13s475ms 1m 1m56s 5m43s 01 17 0ms 2s434ms 1s298ms 2s473ms 3s784ms 4s5ms 02 12 0ms 2s378ms 1s578ms 2s67ms 3s208ms 4s373ms 03 20 0ms 7s664ms 1s497ms 2s999ms 3s742ms 8s252ms 04 20 0ms 2s403ms 1s166ms 2s633ms 3s810ms 4s402ms 05 24 0ms 8m11s 42s125ms 7s13ms 2m12s 8m11s 06 15 0ms 10s347ms 3s36ms 2s323ms 3s562ms 29s403ms 07 161 0ms 7m7s 10s2ms 50s489ms 3m41s 7m52s 08 580 150ms 6m42s 4s703ms 1m18s 5m35s 8m34s 09 783 150ms 9m17s 4s351ms 1m46s 6m16s 9m31s 10 884 150ms 8m28s 2s283ms 42s563ms 5m3s 8m36s 11 611 150ms 8m1s 3s407ms 1m8s 4m23s 8m56s 12 183 0ms 7m27s 6s896ms 24s423ms 3m49s 7m29s 13 486 0ms 5m54s 2s630ms 57s904ms 1m58s 5m54s 14 648 150ms 7m37s 3s588ms 1m 3m51s 9m26s 15 730 150ms 8m2s 3s638ms 53s317ms 4m54s 9m52s 16 557 150ms 7m43s 2s775ms 1m1s 1m32s 7m54s 17 372 0ms 7m40s 4s363ms 1m7s 2m 7m55s 18 33 0ms 5m52s 18s828ms 2s790ms 46s99ms 5m52s 19 20 0ms 5m35s 29s402ms 2s651ms 44s763ms 5m35s 20 114 0ms 7m44s 11s423ms 1m5s 2m1s 7m44s 21 29 0ms 5m25s 20s126ms 5s28ms 13s477ms 5m54s 22 31 0ms 6m2s 22s726ms 4s549ms 1m2s 6m53s 23 274 0ms 1m58s 8s784ms 1m15s 1m31s 2m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 01 00 13 38 16s297ms 425ms 59s929ms 1m56s 01 5 0 318ms 0ms 0ms 319ms 02 0 0 0ms 0ms 0ms 0ms 03 6 0 302ms 0ms 0ms 361ms 04 8 0 355ms 0ms 158ms 874ms 05 9 0 289ms 0ms 0ms 895ms 06 2 0 440ms 0ms 0ms 0ms 07 94 0 13s280ms 2s944ms 18s798ms 4m5s 08 456 0 4s953ms 19s333ms 1m8s 6m46s 09 608 0 4s491ms 38s967ms 1m46s 6m4s 10 686 0 2s461ms 12s712ms 19s547ms 5m10s 11 493 0 3s536ms 12s249ms 57s99ms 4m36s 12 116 0 9s756ms 3s976ms 5s569ms 4m45s 13 379 0 2s902ms 10s731ms 57s904ms 3m16s 14 496 0 3s223ms 10s370ms 31s715ms 6m38s 15 546 0 3s668ms 16s160ms 45s44ms 5m18s 16 430 0 3s89ms 13s494ms 58s168ms 4m9s 17 221 0 5s724ms 11s397ms 54s720ms 4m23s 18 16 0 37s307ms 0ms 1s216ms 3m14s 19 6 0 1m34s 0ms 0ms 3m8s 20 9 89 12s982ms 435ms 1m5s 3m39s 21 11 0 50s492ms 0ms 0ms 3m5s 22 11 0 1m1s 0ms 0ms 3m16s 23 18 255 8s815ms 1m2s 1m15s 1m58s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 01 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 01 00 0 3 3.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 1 1.00 0.00% 07 0 12 12.00 0.00% 08 0 18 18.00 0.00% 09 0 16 16.00 0.00% 10 0 14 14.00 0.00% 11 0 11 11.00 0.00% 12 0 6 6.00 0.00% 13 0 9 9.00 0.00% 14 0 12 12.00 0.00% 15 0 17 17.00 0.00% 16 0 11 11.00 0.00% 17 0 5 5.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 1 1.00 0.00% 22 0 1 1.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jul 01 00 15 0.00/s 01 6 0.00/s 02 7 0.00/s 03 19 0.01/s 04 6 0.00/s 05 13 0.00/s 06 19 0.01/s 07 15 0.00/s 08 24 0.01/s 09 20 0.01/s 10 23 0.01/s 11 21 0.01/s 12 15 0.00/s 13 20 0.01/s 14 20 0.01/s 15 23 0.01/s 16 23 0.01/s 17 13 0.00/s 18 11 0.00/s 19 11 0.00/s 20 13 0.00/s 21 12 0.00/s 22 12 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Jul 01 00 9 52m2s 50m20s 01 14 1h1m4s 1h1m2s 02 6 1h30s 1h27s 03 16 21m32s 21m30s 04 9 1h2m40s 1h2m37s 05 7 52m52s 50m27s 06 18 36m40s 36m38s 07 12 55m59s 53m45s 08 18 48m27s 45m55s 09 22 54m45s 52m10s 10 21 54m30s 52m54s 11 22 55m10s 53m35s 12 21 54m38s 53m38s 13 14 51m51s 50m19s 14 19 1h1m29s 59m26s 15 22 55m47s 53m47s 16 24 53m29s 52m25s 17 21 55m22s 54m5s 18 11 1h1m22s 1h25s 19 12 56m30s 55m41s 20 13 47m37s 45m57s 21 10 1h54s 59m56s 22 12 1h30s 59m31s 23 14 50m31s 47m39s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-01 00:07:21 Date
Connections per database
Key values
- rio Main Database
- 372 connections Total
Connections per user
Key values
- intelifix Main User
- 372 connections Total
-
Sessions
Simultaneous sessions
Key values
- 11 sessions Session Peak
- 2026-07-01 01:04:54 Date
Histogram of session times
Key values
- 298 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 367 sessions Total
Sessions per user
Key values
- intelifix Main User
- 367 sessions Total
Sessions per host
Key values
- [local] Main Host
- 367 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 367 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 22,237 buffers Checkpoint Peak
- 2026-07-01 09:24:35 Date
- 270.005 seconds Highest write time
- 0.118 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-07-01 09:49:35 Date
Checkpoints distance
Key values
- 391.62 Mo Distance Peak
- 2026-07-01 09:49:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 01 00 16,134 658.485s 0.099s 658.643s 01 2,092 210.413s 0.071s 210.556s 02 3,222 323.206s 0.059s 323.312s 03 1,858 186.914s 0.085s 187.073s 04 3,622 364.101s 0.09s 364.272s 05 9,574 955.083s 0.097s 955.235s 06 3,104 311.378s 0.036s 311.457s 07 30,256 2,294.618s 0.245s 2,294.997s 08 96,602 3,238.867s 0.634s 3,239.745s 09 122,936 3,238.631s 0.75s 3,239.636s 10 87,125 3,238.721s 0.749s 3,239.701s 11 74,863 3,238.957s 0.511s 3,239.65s 12 36,179 2,142.395s 0.216s 2,142.738s 13 20,864 2,008.317s 0.37s 2,008.819s 14 68,575 3,238.804s 0.573s 3,239.636s 15 64,325 3,238.666s 0.746s 3,239.656s 16 53,604 3,121.958s 0.49s 3,122.683s 17 46,605 2,699.203s 0.346s 2,699.722s 18 2,292 230.203s 0.02s 230.269s 19 26 2.633s 0.004s 2.643s 20 1,414 324.346s 0.031s 324.396s 21 2,701 272.323s 0.057s 272.482s 22 2,456 247.199s 0.046s 247.498s 23 654 113.262s 0.032s 113.513s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 01 00 0 0 6 705 0.008s 0.007s 01 0 0 1 467 0.008s 0.013s 02 0 0 0 419 0.008s 0.007s 03 0 0 1 418 0.012s 0.013s 04 0 0 1 741 0.007s 0.012s 05 0 0 4 666 0.009s 0.007s 06 0 0 0 259 0.008s 0.005s 07 0 0 21 2,584 0.008s 0.012s 08 0 0 56 6,314 0.017s 0.012s 09 0 0 67 8,156 0.006s 0.012s 10 0 0 39 8,153 0.011s 0.012s 11 0 0 35 6,751 0.006s 0.012s 12 0 0 17 3,254 0.006s 0.012s 13 0 0 8 4,656 0.007s 0.012s 14 0 0 51 7,046 0.010s 0.012s 15 0 0 39 7,254 0.011s 0.012s 16 0 0 29 6,366 0.005s 0.012s 17 0 0 36 4,417 0.004s 0.01s 18 0 0 1 347 0.002s 0.005s 19 0 0 0 7 0.002s 0.001s 20 0 0 1 98 0.006s 0.003s 21 0 0 1 362 0.024s 0.01s 22 0 0 1 470 0.003s 0.013s 23 0 0 0 76 0.009s 0.009s Day Hour Count Avg time (sec) Jul 01 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 01 00 13,537.57 kB 48,888.14 kB 01 1,008.70 kB 23,294.50 kB 02 1,357.57 kB 10,097.00 kB 03 862.00 kB 2,416.00 kB 04 1,463.27 kB 2,687.36 kB 05 8,733.14 kB 15,978.29 kB 06 2,425.20 kB 12,743.60 kB 07 28,783.92 kB 56,029.33 kB 08 76,400.50 kB 123,453.25 kB 09 90,621.17 kB 154,640.83 kB 10 53,031.00 kB 120,120.17 kB 11 47,926.42 kB 71,816.67 kB 12 24,116.33 kB 67,662.25 kB 13 10,392.00 kB 26,845.50 kB 14 69,847.83 kB 92,133.67 kB 15 53,650.50 kB 111,650.50 kB 16 39,315.08 kB 102,342.17 kB 17 58,493.70 kB 72,860.80 kB 18 3,295.60 kB 98,934.80 kB 19 184.00 kB 71,782.00 kB 20 8,078.33 kB 60,382.33 kB 21 1,535.22 kB 33,918.89 kB 22 1,220.73 kB 12,878.91 kB 23 861.71 kB 5,372.29 kB -
Temporary Files
Size of temporary files
Key values
- 465.36 MiB Temp Files size Peak
- 2026-07-01 05:31:57 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-01 05:31:57 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 01 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.19 MiB 06 0 0 0 07 0 0 0 08 1 104.00 MiB 104.00 MiB 09 5 520.00 MiB 104.00 MiB 10 0 0 0 11 3 312.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 2 208.00 MiB 104.00 MiB 15 1 104.00 MiB 104.00 MiB 16 3 312.00 MiB 104.00 MiB 17 4 416.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 19 1.93 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026435, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 14:47:52 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026409, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 08:52:50 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026442, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 15:59:14 Duration: 5m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 8 903.88 MiB 69.40 MiB 232.68 MiB 112.98 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-01 05:32:04 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-01 05:31:57 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 178.03 MiB 89.02 MiB 89.02 MiB 89.02 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-01 05:30:40 Duration: 39s176ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-01 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 232.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-01 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 232.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-01 05:31:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 17:40:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 08:21:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 09:16:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 14:47:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 09:24:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 09:59:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 11:39:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,504,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 11:57:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 17:13:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 11:46:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 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-01 09:54:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,404,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 17:21:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 16:23:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 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-01 16:28:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 16:32:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 09:38:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 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-01 15:58:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-01 14:03:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 2.90 sec Highest CPU-cost vacuum
Table public.nf_entrada_itens
Database brasilia - 2026-07-01 10:59:10 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 2.90 sec Highest CPU-cost vacuum
Table public.nf_entrada_itens
Database brasilia - 2026-07-01 10:59:10 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (121) Main table analyzed (database rio)
- 1,275 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 121 rio.pg_catalog.pg_class 67 rio.pg_catalog.pg_type 58 rio.public.temp0000284094 58 brasilia.pg_catalog.pg_attribute 56 rio.public.usuarios 47 brasilia.public.temp0000235012 40 rio.pg_catalog.pg_index 40 brasilia.public.temp0000235050 38 brasilia.pg_catalog.pg_class 33 rio.pg_catalog.pg_depend 31 rio.auditor.auditor_2026_07 29 brasilia.pg_catalog.pg_type 28 contagem.public.temp0000226520 24 contagem.pg_catalog.pg_attribute 24 rio.public.temp0000284084 21 brasilia.auditor.auditor_2026_07 21 brasilia.pg_catalog.pg_index 20 contagem.public.usuarios 20 brasilia.public.temp0000235062 19 brasilia.pg_catalog.pg_depend 17 rio.public.temp0000284196 16 rio.public.temp0000284132 16 contagem.pg_catalog.pg_class 16 rio.public.temp0000283986 15 contagem.auditor.auditor_2026_07 15 rio.public.temp0000284092 14 rio.public.temp0000283956 13 contagem.pg_catalog.pg_type 13 rio.public.temp0000284110 13 rio.public.temp0000284126 11 brasilia.public.temp0000235014 11 rio.public.temp0000283932 11 rio.public.temp0000284190 11 rio.public.temp0000281789 10 brasilia.public.usuarios 10 rio.public.temp0000284090 10 rio.public.temp0000283996 10 rio.public.temp0000284096 10 contagem.pg_catalog.pg_index 9 contagem.public.temp0000226514 9 brasilia.public.temp0000235052 9 contagem.pg_catalog.pg_depend 9 brasilia.public.temp0000235060 9 brasilia.public.temp0000235072 8 brasilia.public.temp0000235002 8 rio.public.temp0000283990 8 rio.public.temp0000284192 8 rio.public.temp0000284112 7 rio.public.temp0000284182 7 rio.public.temp0000284124 7 rio.public.temp0000284162 7 rio.public.temp0000284164 7 brasilia.public.temp0000235078 6 contagem.public.temp0000226529 6 contagem.public.nf_entrada 6 postgres.pg_catalog.pg_shdepend 5 contagem.pg_catalog.pg_shdepend 5 rio.public.temp0000284184 5 brasilia.public.temp0000235010 5 rio.public.temp0000284042 5 brasilia.public.nf_entrada 5 rio.public.temp0000284134 4 rio.public.temp0000284114 4 rio.public.temp0000284104 4 rio.public.temp0000284186 3 brasilia.public.temp0000235044 3 brasilia.public.temp0000235084 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000235020 3 template1.pg_catalog.pg_shdepend 3 brasilia.public.temp0000235018 2 brasilia.public.temp0000235096 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000235076 2 brasilia.public.temp0000235042 2 brasilia.public.temp0000235008 2 rio.public.temp0000284202 2 rio.public.temp0000284178 2 rio.public.temp0000284128 2 rio.public.temp0000284172 2 brasilia.public.temp0000235074 2 rio.public.temp0000284138 2 rio.public.temp0000284206 2 brasilia.public.temp0000235026 2 rio.public.temp0000284118 2 rio.public.temp0000284130 1 rio.public.temp0000284122 1 contagem.public.temp0000226527 1 brasilia.public.temp0000235090 1 rio.public.temp0000284214 1 rio.public.temp0000284142 1 rio.public.temp0000284102 1 rio.public.temp0000284194 1 brasilia.public.temp0000235094 1 rio.public.temp0000284106 1 rio.public.temp0000284144 1 brasilia.public.temp0000235032 1 rio.public.temp0000284150 1 brasilia.public.temp0000235056 1 contagem.public.temp0000226531 1 brasilia.public.temp0000235034 1 rio.public.temp0000283808 1 brasilia.public.temp0000235046 1 Total 1,275 Vacuums per table
Key values
- pg_catalog.pg_attribute (50) Main table vacuumed on database rio
- 550 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 50 43 0 0 0 0 0 24,564 6,342 9,260,561 424 10,909 rio.public.temp0000284094 46 0 0 0 0 0 0 39,642 1,792 4,429,279 0 0 rio.pg_catalog.pg_class 34 30 0 0 0 0 0 6,107 1,823 2,663,196 114 461 rio.pg_catalog.pg_type 25 24 0 0 0 0 0 2,343 689 916,389 63 190 brasilia.pg_catalog.pg_attribute 24 21 0 0 0 0 0 11,585 2,464 4,172,278 72 2,243 contagem.public.usuarios 20 0 0 0 0 0 0 102 80 43,390 0 0 rio.auditor.auditor_2026_07 17 0 0 0 0 0 0 71,967 42,152 54,357,962 9,990 198,952 rio.public.temp0000284196 17 0 0 0 0 0 0 27,538 68 1,634,993 0 0 rio.pg_catalog.pg_index 15 15 0 0 0 0 0 993 247 241,260 50 94 brasilia.pg_catalog.pg_class 15 14 0 0 0 0 0 3,269 735 1,203,351 67 908 rio.public.temp0000283986 14 0 0 0 0 0 0 1,544 181 265,636 0 0 brasilia.pg_catalog.pg_type 13 11 0 0 0 0 0 1,155 289 409,965 33 141 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,645 1,611 2,529,511 84 692 rio.public.temp0000284126 11 0 0 0 0 0 0 9,730 39 580,378 0 0 rio.public.temp0000283932 11 0 0 0 0 0 0 927 140 188,675 0 0 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,468 1,513 2,906,233 16 476 rio.public.temp0000283996 10 0 0 0 0 0 0 925 52 62,692 0 0 brasilia.auditor.auditor_2026_07 10 0 0 0 0 0 0 13,248 8,210 10,385,994 1,521 30,289 rio.public.temp0000284192 9 0 0 0 0 0 0 11,341 1,650 2,741,862 0 0 rio.public.temp0000284124 8 0 0 0 0 0 0 12,960 1,648 2,835,876 0 0 rio.public.temp0000281789 8 0 0 0 0 0 0 741 46 51,015 0 0 brasilia.public.temp0000235072 8 0 0 0 0 0 0 1,897 737 1,194,076 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 11,159 2,453 11,504,474 1,068 4,784 rio.public.temp0000283990 8 0 0 0 0 0 0 597 43 42,143 0 0 rio.public.temp0000284182 7 0 0 0 0 0 0 11,333 28 672,868 0 0 brasilia.pg_catalog.pg_index 7 7 0 0 0 0 0 403 71 73,699 19 37 contagem.auditor.auditor_2026_07 7 0 0 0 0 0 0 6,714 3,909 4,747,311 783 13,043 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 746 151 267,278 6 16 contagem.public.temp0000226514 7 0 0 0 0 0 0 698 42 47,833 0 0 brasilia.pg_catalog.pg_statistic 7 7 0 0 0 0 0 7,193 1,506 6,063,106 722 4,202 brasilia.pg_catalog.pg_depend 7 7 0 0 0 0 0 1,938 520 866,302 22 178 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,450 275 474,633 4 12 rio.public.temp0000284162 7 0 0 0 0 0 0 11,334 1,643 2,737,770 0 0 template1.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 831 262 537,678 82 233 rio.public.usuarios 6 3 0 0 0 0 0 71 23 41,843 2 3 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,470 544 3,430,202 162 583 rio.public.temp0000284184 5 0 0 0 0 0 0 1,790 26 109,639 0 0 rio.public.temp0000284114 4 0 0 0 0 0 0 4,858 15 288,969 0 0 postgres.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 583 216 385,868 23 45 brasilia.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 717 169 742,018 39 97 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 206 74 81,277 5 12 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,064 271 544,157 3 28 rio.public.temp0000284132 3 0 0 0 0 0 0 284 115 178,473 0 0 rio.public.temp0000284186 3 0 0 0 0 0 0 1,627 10 97,672 0 0 rio.public.temp0000284042 3 0 0 0 0 0 0 12 9 2,322 0 0 rio.public.temp0000284172 2 0 0 0 0 0 0 1,695 10 101,501 0 0 brasilia.public.temp0000235096 2 0 0 0 0 0 0 474 12 30,218 0 0 rio.public.temp0000284178 2 0 0 0 0 0 0 152 12 10,752 0 0 brasilia.public.temp0000235010 2 0 0 0 0 0 0 472 241 387,569 0 0 brasilia.public.temp0000235074 2 0 0 0 0 0 0 474 241 387,395 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,864 186 840,366 145 1,316 brasilia.public.nf_entrada 2 2 0 0 0 0 0 263 69 150,435 8 12 brasilia.public.temp0000235094 1 0 0 0 0 0 0 237 6 15,108 0 0 rio.public.notas_fiscais 1 0 0 0 0 0 0 21 16 47,749 2 369 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 1,111 793 2,144,129 143 6,845 brasilia.public.temp0000235050 1 0 0 0 0 0 0 237 6 15,117 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 219 163 554,196 26 4,799 brasilia.public.temp0000235020 1 0 0 0 0 0 0 236 6 15,052 0 0 rio.public.temp0000284164 1 0 0 0 0 0 0 120 6 8,023 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 105 50 111,549 3 6 brasilia.public.nf_entrada_itens 1 1 0 0 0 0 0 5,985 5,424 22,261,529 6 348 contagem.public.temp0000226529 1 0 0 0 0 0 0 247 6 15,811 0 0 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 165 78 247,454 34 1,799 brasilia.public.temp0000235032 1 0 0 0 0 0 0 237 6 15,117 0 0 brasilia.public.temp0000235026 1 0 0 0 0 0 0 236 6 15,051 0 0 rio.public.temp0000284118 1 0 0 0 0 0 0 1,619 4 96,124 0 0 contagem.public.temp0000226531 1 0 0 0 0 0 0 100 6 6,839 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 166 5 13,881 0 0 rio.public.temp0000284138 1 0 0 0 0 0 0 1,620 4 96,183 0 0 Total 550 262 0 0 0 0 0 340,824 92,239 164,599,255 15,741 284,122 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (13.4) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.34 rio.public.temp0000284094 0 0 1.69 rio.pg_catalog.pg_class 0 0 1.09 rio.pg_catalog.pg_type 0 0 0.3 brasilia.pg_catalog.pg_attribute 0 0 1.42 contagem.public.usuarios 0 0 0 rio.auditor.auditor_2026_07 0 0 13.4 rio.public.temp0000284196 0 0 0.85 rio.pg_catalog.pg_index 0 0 0.26 brasilia.pg_catalog.pg_class 0 0 0.37 rio.public.temp0000283986 0 0 0.25 brasilia.pg_catalog.pg_type 0 0 0.17 rio.pg_catalog.pg_depend 0 0 0.95 rio.public.temp0000284126 0 0 0.52 rio.public.temp0000283932 0 0 0.18 contagem.pg_catalog.pg_attribute 0 0 0.83 rio.public.temp0000283996 0 0 0.12 brasilia.auditor.auditor_2026_07 0 0 2.43 rio.public.temp0000284192 0 0 0.49 rio.public.temp0000284124 0 0 0.49 rio.public.temp0000281789 0 0 0.13 brasilia.public.temp0000235072 0 0 0.16 rio.pg_catalog.pg_statistic 0 0 1.43 rio.public.temp0000283990 0 0 0.12 rio.public.temp0000284182 0 0 0.36 brasilia.pg_catalog.pg_index 0 0 0.01 contagem.auditor.auditor_2026_07 0 0 1.27 contagem.pg_catalog.pg_type 0 0 0.12 contagem.public.temp0000226514 0 0 0.1 brasilia.pg_catalog.pg_statistic 0 0 0.82 brasilia.pg_catalog.pg_depend 0 0 0.32 contagem.pg_catalog.pg_class 0 0 0.2 rio.public.temp0000284162 0 0 0.39 template1.pg_catalog.pg_shdepend 0 0 0.31 rio.public.usuarios 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.32 rio.public.temp0000284184 0 0 0.13 rio.public.temp0000284114 0 0 0.18 postgres.pg_catalog.pg_shdepend 0 0 0.24 brasilia.pg_toast.pg_toast_2619 0 0 0.05 contagem.pg_catalog.pg_index 0 0 0.22 contagem.pg_catalog.pg_depend 0 0 0.16 rio.public.temp0000284132 0 0 0.05 rio.public.temp0000284186 0 0 0.14 rio.public.temp0000284042 0 0 0 rio.public.temp0000284172 0 0 0.06 brasilia.public.temp0000235096 0 0 0.05 rio.public.temp0000284178 0 0 0.04 brasilia.public.temp0000235010 0 0 0.04 brasilia.public.temp0000235074 0 0 0.04 contagem.pg_catalog.pg_statistic 0 0 0.14 brasilia.public.nf_entrada 0 0 0.04 brasilia.public.temp0000235094 0 0 0.02 rio.public.notas_fiscais 0 0 0.03 rio.public.nf_entrada_arquivo_erros 0 0 0.43 brasilia.public.temp0000235050 0 0 0.03 rio.public.equipamentos_referencia 0 0 0.06 brasilia.public.temp0000235020 0 0 0.02 rio.public.temp0000284164 0 0 0.02 contagem.public.nf_entrada 0 0 0.02 brasilia.public.nf_entrada_itens 0 0 2.9 contagem.public.temp0000226529 0 0 0.02 brasilia.public.nf_entrada_arquivo_erros 0 0 0.07 brasilia.public.temp0000235032 0 0 0.02 brasilia.public.temp0000235026 0 0 0.03 rio.public.temp0000284118 0 0 0.05 contagem.public.temp0000226531 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000284138 0 0 0.05 Total 0 0 40.59 Tuples removed per table
Key values
- pg_catalog.pg_attribute (185109) Main table with removed tuples on database rio
- 454865 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 50 43 185,109 1,273,442 61,861 229 31,292 brasilia.pg_catalog.pg_attribute 24 21 103,219 572,733 46,342 444 15,474 contagem.pg_catalog.pg_attribute 11 11 47,473 262,551 34 140 6,022 rio.pg_catalog.pg_statistic 8 8 14,387 66,738 0 0 10,288 brasilia.pg_catalog.pg_depend 7 7 13,248 124,079 0 20 1,252 brasilia.pg_catalog.pg_statistic 7 7 11,534 59,735 0 0 7,504 rio.pg_catalog.pg_depend 13 13 10,265 251,783 2,882 0 2,353 brasilia.pg_catalog.pg_class 15 14 9,278 53,478 1,976 13 2,087 rio.pg_catalog.pg_type 25 24 9,264 59,189 2,066 12 1,852 brasilia.pg_catalog.pg_type 13 11 6,952 32,917 4,074 41 1,031 rio.pg_catalog.pg_class 34 30 6,935 127,653 8,174 52 4,228 contagem.pg_catalog.pg_statistic 2 2 5,560 14,916 0 0 2,022 template1.pg_catalog.pg_shdepend 6 6 5,215 81,824 417 0 690 rio.pg_catalog.pg_index 15 15 4,283 28,828 39 0 885 brasilia.pg_catalog.pg_index 7 7 2,877 13,153 0 0 395 contagem.pg_catalog.pg_class 7 7 2,798 23,956 3 29 829 contagem.pg_catalog.pg_type 7 7 2,773 15,735 0 12 452 postgres.pg_catalog.pg_shdepend 4 4 2,759 55,511 1,166 0 460 brasilia.public.nf_entrada 2 2 2,534 7,594 0 0 182 contagem.pg_catalog.pg_index 4 4 1,286 7,585 1 8 204 contagem.public.usuarios 20 0 1,254 460 0 0 40 rio.pg_toast.pg_toast_2619 5 5 1,181 3,400 0 124 833 rio.auditor.auditor_2026_07 17 0 1,168 5,431,749 0 0 256,755 brasilia.public.nf_entrada_arquivo_erros 1 0 1,154 1,638,352 0 0 29,290 brasilia.auditor.auditor_2026_07 10 0 835 946,746 0 0 41,654 contagem.pg_catalog.pg_depend 4 4 524 75,793 6 11 699 brasilia.pg_toast.pg_toast_2619 4 4 375 558 0 0 276 contagem.public.nf_entrada 1 1 208 1,360 0 0 69 rio.public.usuarios 6 3 126 4,153 1,105 0 102 contagem.pg_toast.pg_toast_2619 1 1 113 112 0 12 48 brasilia.public.nf_entrada_itens 1 1 103 1,620,825 0 0 16,867 rio.public.nf_entrada_arquivo_erros 1 0 64 8,422,635 0 0 150,364 rio.public.equipamentos_referencia 1 0 11 5,134,065 0 0 27,753 brasilia.public.temp0000235094 1 0 0 3,057 0 27 229 rio.public.temp0000283996 10 0 0 46,121 0 234 1,046 rio.public.temp0000284182 7 0 0 159,376 0 0 11,648 rio.public.notas_fiscais 1 0 0 170,159 0 0 922 rio.public.temp0000284114 4 0 0 90,996 0 0 6,656 brasilia.public.temp0000235050 1 0 0 3,046 0 27 229 rio.public.temp0000284132 3 0 0 11,571 0 124 260 rio.public.temp0000284192 9 0 0 204,922 0 0 14,976 rio.public.temp0000284124 8 0 0 182,224 0 0 13,312 rio.public.temp0000284172 2 0 0 23,953 0 60 1,732 brasilia.public.temp0000235096 2 0 0 6,114 0 54 458 contagem.auditor.auditor_2026_07 7 0 0 418,671 0 0 16,917 rio.public.temp0000283986 14 0 0 70,007 0 480 1,568 rio.public.temp0000284178 2 0 0 2,372 0 120 136 rio.public.temp0000281789 8 0 0 37,782 0 308 844 rio.public.temp0000284126 11 0 0 250,337 0 0 18,304 rio.public.temp0000284094 46 0 0 744,183 0 174 54,162 rio.public.temp0000284186 3 0 0 68,303 0 0 4,992 brasilia.public.temp0000235010 2 0 0 6,090 0 56 456 rio.public.temp0000283932 11 0 0 39,844 0 387 893 brasilia.public.temp0000235020 1 0 0 3,044 0 28 228 rio.public.temp0000284042 3 0 0 16,209 0 0 384 rio.public.temp0000284164 1 0 0 5,008 0 16 112 contagem.public.temp0000226514 7 0 0 8,355 0 256 640 brasilia.public.temp0000235072 8 0 0 24,391 0 216 1,832 contagem.public.temp0000226529 1 0 0 1,698 0 17 239 brasilia.public.temp0000235074 2 0 0 6,114 0 54 458 brasilia.public.temp0000235032 1 0 0 3,046 0 27 229 rio.public.temp0000284184 5 0 0 27,642 0 233 1,943 rio.public.temp0000284162 7 0 0 159,356 0 0 11,648 brasilia.public.temp0000235026 1 0 0 3,045 0 28 228 rio.public.temp0000284118 1 0 0 22,763 0 0 1,664 contagem.public.temp0000226531 1 0 0 1,200 0 36 92 rio.public.temp0000284138 1 0 0 22,776 0 0 1,664 rio.public.temp0000283990 8 0 0 38,211 0 164 860 rio.public.temp0000284196 17 0 0 387,199 0 0 28,288 Total 550 262 454,865 29,682,793 130,146 4,273 814,501 Pages removed per table
Key values
- public.temp0000283986 (480) Main table with removed pages on database rio
- 4273 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000283986 14 0 0 480 brasilia.pg_catalog.pg_attribute 24 21 103219 444 rio.public.temp0000283932 11 0 0 387 rio.public.temp0000281789 8 0 0 308 contagem.public.temp0000226514 7 0 0 256 rio.public.temp0000283996 10 0 0 234 rio.public.temp0000284184 5 0 0 233 rio.pg_catalog.pg_attribute 50 43 185109 229 brasilia.public.temp0000235072 8 0 0 216 rio.public.temp0000284094 46 0 0 174 rio.public.temp0000283990 8 0 0 164 contagem.pg_catalog.pg_attribute 11 11 47473 140 rio.public.temp0000284132 3 0 0 124 rio.pg_toast.pg_toast_2619 5 5 1181 124 rio.public.temp0000284178 2 0 0 120 rio.public.temp0000284172 2 0 0 60 brasilia.public.temp0000235010 2 0 0 56 brasilia.public.temp0000235096 2 0 0 54 brasilia.public.temp0000235074 2 0 0 54 rio.pg_catalog.pg_class 34 30 6935 52 brasilia.pg_catalog.pg_type 13 11 6952 41 contagem.public.temp0000226531 1 0 0 36 contagem.pg_catalog.pg_class 7 7 2798 29 brasilia.public.temp0000235020 1 0 0 28 brasilia.public.temp0000235026 1 0 0 28 brasilia.public.temp0000235094 1 0 0 27 brasilia.public.temp0000235050 1 0 0 27 brasilia.public.temp0000235032 1 0 0 27 brasilia.pg_catalog.pg_depend 7 7 13248 20 contagem.public.temp0000226529 1 0 0 17 rio.public.temp0000284164 1 0 0 16 brasilia.pg_catalog.pg_class 15 14 9278 13 contagem.pg_catalog.pg_type 7 7 2773 12 rio.pg_catalog.pg_type 25 24 9264 12 contagem.pg_toast.pg_toast_2619 1 1 113 12 contagem.pg_catalog.pg_depend 4 4 524 11 contagem.pg_catalog.pg_index 4 4 1286 8 rio.public.temp0000284182 7 0 0 0 rio.public.notas_fiscais 1 0 0 0 brasilia.pg_catalog.pg_index 7 7 2877 0 rio.public.temp0000284114 4 0 0 0 rio.public.nf_entrada_arquivo_erros 1 0 64 0 postgres.pg_catalog.pg_shdepend 4 4 2759 0 rio.public.temp0000284192 9 0 0 0 rio.public.equipamentos_referencia 1 0 11 0 rio.public.temp0000284124 8 0 0 0 contagem.auditor.auditor_2026_07 7 0 0 0 rio.public.temp0000284126 11 0 0 0 brasilia.pg_toast.pg_toast_2619 4 4 375 0 rio.public.temp0000284186 3 0 0 0 rio.auditor.auditor_2026_07 17 0 1168 0 brasilia.auditor.auditor_2026_07 10 0 835 0 rio.public.temp0000284042 3 0 0 0 contagem.public.nf_entrada 1 1 208 0 brasilia.public.nf_entrada_itens 1 1 103 0 brasilia.pg_catalog.pg_statistic 7 7 11534 0 contagem.public.usuarios 20 0 1254 0 rio.pg_catalog.pg_statistic 8 8 14387 0 contagem.pg_catalog.pg_statistic 2 2 5560 0 brasilia.public.nf_entrada_arquivo_erros 1 0 1154 0 rio.pg_catalog.pg_index 15 15 4283 0 template1.pg_catalog.pg_shdepend 6 6 5215 0 brasilia.public.nf_entrada 2 2 2534 0 rio.pg_catalog.pg_depend 13 13 10265 0 rio.public.temp0000284162 7 0 0 0 rio.public.temp0000284118 1 0 0 0 rio.public.usuarios 6 3 126 0 rio.public.temp0000284138 1 0 0 0 rio.public.temp0000284196 17 0 0 0 Total 550 262 454,865 4,273 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 01 00 3 5 01 0 7 02 1 0 03 0 5 04 3 10 05 6 4 06 0 0 07 20 43 08 44 128 09 86 176 10 65 164 11 59 130 12 6 40 13 22 76 14 64 120 15 88 190 16 32 89 17 46 83 18 1 1 19 0 0 20 0 0 21 4 3 22 0 0 23 0 1 - 2.90 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 9 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 4 9m53s 1m 4m4s 2m28s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 15:59:14 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 14:47:52 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 09:47:17 Database: rio User: intelifix Remote: [local] Application: psql
2 1 5m18s 5m18s 5m18s 5m18s select * from rs_auditor_novas_tabelas ();-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:21 Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:21 Database: contagem User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:20 Database: rio User: lenon Remote: [local] Application: psql
3 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000284192;-
DROP TABLE IF EXISTS temp0000284192;
Date: 2026-07-01 14:36:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000284192;
Date: 2026-07-01 14:36:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000284124;-
DROP TABLE IF EXISTS temp0000284124;
Date: 2026-07-01 17:29:50 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000284124;
Date: 2026-07-01 17:29:50 Database: rio User: intelifix Remote: [local] Application: [unknown]
5 1 1s 1s 1s 1s drop table if exists temp0000284196;-
DROP TABLE IF EXISTS temp0000284196;
Date: 2026-07-01 17:43:49 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000284196;
Date: 2026-07-01 17:43:49 Database: rio User: intelifix Remote: [local] Application: [unknown]
6 1 1s 1s 1s 1s drop table if exists temp0000284094;-
DROP TABLE IF EXISTS temp0000284094;
Date: 2026-07-01 08:11:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000284094;
Date: 2026-07-01 07:09:43 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000284094;
Date: 2026-07-01 15:53:49 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 5m18s SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-07-01 00:07:20 - Database: rio - User: lenon - Remote: [local] - Application: psql ]
2 4m4s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-01 15:59:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 2m43s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-01 14:47:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 2m5s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-01 09:47:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 1m CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-01 11:06:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 1s1ms DROP TABLE IF EXISTS temp0000284192;[ Date: 2026-07-01 14:36:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 1s DROP TABLE IF EXISTS temp0000284124;[ Date: 2026-07-01 17:29:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 1s DROP TABLE IF EXISTS temp0000284196;[ Date: 2026-07-01 17:43:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 1s DROP TABLE IF EXISTS temp0000284094;[ Date: 2026-07-01 08:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,639 Total read queries
- 1,602 Total write queries
Queries by database
Key values
- rio Main database
- 4,450 Requests
- 6h35m3s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,523 Requests
User Request type Count Duration etiquetas Total 37 6s796ms select 37 6s796ms intelifix Total 6,523 8h27m16s copy to 382 57m10s ddl 1,220 52m45s others 431 43m53s select 4,490 5h53m27s lenon Total 112 6m8s select 112 6m8s Duration by user
Key values
- 8h27m16s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 37 6s796ms select 37 6s796ms intelifix Total 6,523 8h27m16s copy to 382 57m10s ddl 1,220 52m45s others 431 43m53s select 4,490 5h53m27s lenon Total 112 6m8s select 112 6m8s Queries by host
Key values
- [local] Main host
- 6,672 Requests
- 8h33m31s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,632 Requests
- 4h10m29s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-01 09:54:46 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,174 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 09:14:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 10:13:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m11s analyze verbose;[ Date: 2026-07-01 05:08:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 15:13:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 11:13:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 20:12:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 16:12:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 17:12:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 14:12:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 12:12:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 07:12:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 08:11:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 22:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 13:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 18:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026435, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-01 14:47:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 19:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026409, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-01 08:52:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-01 21:10:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m18s SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();[ Date: 2026-07-01 00:07:21 - Database: rio - User: lenon - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h2m17s 48 1s191ms 9m17s 2m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 01 07 3 7m39s 2m33s 08 3 7m3s 2m21s 09 3 9m56s 3m18s 10 3 9m3s 3m1s 11 3 8m43s 2m54s 12 3 7m59s 2m39s 13 3 6m13s 2m4s 14 3 8m11s 2m43s 15 3 8m41s 2m53s 16 3 8m17s 2m45s 17 3 8m10s 2m43s 18 3 6m13s 2m4s 19 3 5m52s 1m57s 20 3 8m9s 2m43s 21 3 5m39s 1m53s 22 3 6m22s 2m7s [ User: intelifix - Total duration: 2h2m17s - Times executed: 48 ]
[ Application: psql - Total duration: 2h2m17s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 09:14:18 Duration: 9m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 10:13:29 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 15:13:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: psql
2 1h43m17s 415 151ms 5m35s 14s933ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 01 07 10 8m14s 49s495ms 08 35 20m33s 35s233ms 09 48 20m10s 25s220ms 10 30 5m26s 10s894ms 11 37 10m12s 16s547ms 12 6 4m49s 48s273ms 13 94 2m52s 1s834ms 14 41 8m20s 12s209ms 15 46 12m43s 16s604ms 16 37 3m10s 5s152ms 17 28 5m39s 12s128ms 18 2 517ms 258ms 22 1 1m2s 1m2s [ User: intelifix - Total duration: 1h43m17s - Times executed: 415 ]
[ Application: [unknown] - Total duration: 1h43m17s - Times executed: 415 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026435, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 14:47:52 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026409, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 08:52:50 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026442, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 15:59:14 Duration: 5m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h12m22s 47 193ms 4m57s 1m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 01 07 3 4m12s 1m24s 08 3 4m27s 1m29s 09 3 5m43s 1m54s 10 2 5m53s 2m56s 11 3 5m5s 1m41s 12 3 4m35s 1m31s 13 3 3m46s 1m15s 14 3 4m37s 1m32s 15 3 5m19s 1m46s 16 3 5m 1m40s 17 3 4m39s 1m33s 18 3 3m38s 1m12s 19 3 3m36s 1m12s 20 3 4m22s 1m27s 21 3 3m33s 1m11s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h12m22s - Times executed: 47 ]
[ Application: psql - Total duration: 1h12m22s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 10:19:54 Duration: 4m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 09:20:34 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 15:18:56 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql
4 19m13s 1,477 150ms 4s914ms 781ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 01 07 8 2s128ms 266ms 08 150 2m10s 873ms 09 244 3m5s 759ms 10 285 3m16s 690ms 11 135 1m49s 814ms 12 63 48s176ms 764ms 13 60 57s61ms 951ms 14 139 1m53s 819ms 15 138 1m47s 778ms 16 165 2m9s 787ms 17 90 1m12s 802ms [ User: intelifix - Total duration: 19m13s - Times executed: 1477 ]
[ Application: [unknown] - Total duration: 19m13s - Times executed: 1477 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44286, 418, '834351951001516,241646162435,241672183650,241730910729,241673349005,230048471734,241609921940,241671569314,241654587476,241692626172,241676718794,241635019696,241609882744,241609881128,230048471431,241695653247,241713737884,241732100710,241616241221,230048492443,241649638801,241646325862,241727276770,241731247382,241652018506,241599441624,241654606468,241660127478,241647347185,241637720725,241622487183,241689209004,241692680825,241731233543,241727039496,241669282020,241730933233,241654495773,241656679701,241708868587,241728678691,241607301931,241727039799,241692679915,241654498298,241614454559,241656403737', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 16:38:09 Duration: 4s914ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (126193, 397, '226008668290', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 13:42:05 Duration: 4s194ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260494, 508, '836015903003663,241726965472,241656657072,241671509005,241728685359,241711220109,241649641125,241654355557,241728677883,241692670723,241631091840,241607236267,241656700714,241593319410,241649677996,241689133340,230043590214,230049002223,241727021920,241653474753,241609909817,241704724951,241711202430,230057328994,241604773244,241656744051,241714931930,241654531838,241646427892,241636058496,241676735564,241603064042,241622605354,241676755768', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 16:02:31 Duration: 3s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 16m21s 209 152ms 4m7s 4s697ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 01 00 8 18s434ms 2s304ms 01 6 12s744ms 2s124ms 02 7 13s219ms 1s888ms 03 8 19s812ms 2s476ms 04 6 13s318ms 2s219ms 05 6 14s479ms 2s413ms 06 6 13s719ms 2s286ms 07 6 14s188ms 2s364ms 08 6 24s876ms 4s146ms 09 10 2m27s 14s729ms 10 7 16s798ms 2s399ms 11 7 1m15s 10s814ms 12 11 14s825ms 1s347ms 13 12 15s753ms 1s312ms 14 12 3m 15s24ms 15 12 4m22s 21s856ms 16 12 18s250ms 1s520ms 17 12 17s28ms 1s419ms 18 11 16s471ms 1s497ms 19 11 15s967ms 1s451ms 20 12 26s5ms 2s167ms 21 11 15s542ms 1s412ms 22 10 14s753ms 1s475ms [ User: intelifix - Total duration: 16m21s - Times executed: 209 ]
[ Application: psql - Total duration: 16m21s - Times executed: 209 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 15:59:14 Duration: 4m7s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 14:47:52 Duration: 2m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 09:47:17 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: psql
6 16m9s 82 8s531ms 29s873ms 11s823ms create table temp0000284094 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 01 07 16 2m53s 10s850ms 08 14 2m51s 12s235ms 09 15 3m6s 12s443ms 10 6 1m19s 13s209ms 11 3 33s400ms 11s133ms 12 6 1m4s 10s688ms 14 6 1m8s 11s494ms 15 16 3m12s 12s14ms [ User: intelifix - Total duration: 16m9s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 16m9s - Times executed: 82 ]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 07:08:09 Duration: 29s873ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 15:52:11 Duration: 19s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 10:16:22 Duration: 15s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 14m20s 3 2m12s 8m11s 4m46s analyze verbose;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 01 05 3 14m20s 4m46s [ User: intelifix - Total duration: 14m20s - Times executed: 3 ]
[ Application: psql - Total duration: 14m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-01 05:08:13 Duration: 8m11s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-01 05:12:09 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-01 05:14:21 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
8 9m53s 168 543ms 47s717ms 3s535ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 01 08 6 39s234ms 6s539ms 09 11 1m37s 8s840ms 10 5 23s652ms 4s730ms 11 20 40s386ms 2s19ms 12 9 17s345ms 1s927ms 13 11 49s221ms 4s474ms 14 27 1m3s 2s357ms 15 37 1m36s 2s619ms 16 29 2m5s 4s321ms 17 13 40s950ms 3s150ms [ User: intelifix - Total duration: 9m53s - Times executed: 168 ]
[ Application: [unknown] - Total duration: 9m53s - Times executed: 168 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-07-01 09:05:11 Duration: 47s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-01', 0408, '07:00', '21:00', 1, 2, '2025-05-01');
Date: 2026-07-01 09:02:50 Duration: 23s623ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-01', 0408, '', '', 0, 2, '2026-01-01');
Date: 2026-07-01 08:43:09 Duration: 13s590ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 8m43s 1,059 150ms 2s513ms 494ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 01 07 6 2s710ms 451ms 08 92 57s505ms 625ms 09 112 1m7s 603ms 10 202 1m43s 514ms 11 181 1m28s 491ms 12 6 3s771ms 628ms 13 73 33s259ms 455ms 14 158 1m3s 402ms 15 136 58s645ms 431ms 16 82 38s177ms 465ms 17 11 5s774ms 524ms [ User: intelifix - Total duration: 8m43s - Times executed: 1059 ]
[ Application: [unknown] - Total duration: 8m43s - Times executed: 1059 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "260624", "modelo" : "463", "itens" : "241751688894,241735448297,241748458085,241720852328,241721664461,241718984244,241750461032,241755849301,241737150810,241750510711,241748415253,241754620203,241755013350,241719145270,241751484958,241718919816,241737944153,241735101418,241720768099,241757890612,241782314656,241735055880,241725695662,241737388890,241753670829,241753561424,241753681941,241720863541,241722599412,241719017075,241706095960,241723262137,241750491012,241724793240,241719302940,241734655863,241720519108,241750284953,241750341626,241748345370,241723227082,241736742835,241720915869,241725453641,241722919701,241737006171,241737088907,241757347090,241748346279,241723032844,241721567885,241719919700,241725489503,241705032737,241725689904,241749985979,241750187390,241753679920,241751713140,241723955066", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-01 10:46:14 Duration: 2s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249092", "modelo" : "295", "itens" : "230028254261,230027596789,230028671328,229982667488,229977142135,229974600215,230032495561,230031640114,229970607882,230036919506,229991216078,229991029517,230035317486,230044877779,229962704968,229965068890,229975693441,230015159919,229980082130,229990561436", "usuario" : "414", "caixa" : "3017684", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-01 10:12:38 Duration: 2s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "260625", "modelo" : "463", "itens" : "241757636669,241718989395,241758633950,241736721015,241705557086,241748438487,241752272746,241755926278,241718810614,241751471725,241783353860,241748903842,241751191518,241750506972,241755630818,241782053845,241784173446,241722435052,241748337692,241754290115,241704896079,241736979502,241782059502,241737953952,241705006269,241783360000,241735631627,241735624858,241718934565,241753531825,241754329815,241782061119,241720054764,241784707089,241705409495,241737113051,241784750506,241722392445,241720297290,241750334655,241737900513,241782548797,241754262536,241724990611,241757283448,241737042640,241780616061,241752447790,241704957476,241724800413,241750425472,241757300824,241724346877,241755692137,241752937187,241751494757,241749925872,241721794047,241749993051,241750097381", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-01 10:49:04 Duration: 2s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m3s 162 208ms 9s904ms 2s616ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 01 00 5 15s233ms 3s46ms 01 6 7s733ms 1s288ms 02 5 5s717ms 1s143ms 03 5 8s147ms 1s629ms 04 6 7s163ms 1s193ms 05 4 10s754ms 2s688ms 06 4 3s615ms 903ms 07 10 33s178ms 3s317ms 08 12 52s247ms 4s353ms 09 12 47s619ms 3s968ms 10 11 31s403ms 2s854ms 11 12 46s424ms 3s868ms 12 12 28s924ms 2s410ms 13 9 9s527ms 1s58ms 14 12 33s228ms 2s769ms 15 12 37s550ms 3s129ms 16 11 21s614ms 1s964ms 17 4 2s527ms 631ms 21 4 9s468ms 2s367ms 22 6 11s739ms 1s956ms [ User: intelifix - Total duration: 7m3s - Times executed: 162 ]
[ Application: psql - Total duration: 7m3s - Times executed: 162 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 11:15:11 Duration: 9s904ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 00:05:11 Duration: 9s877ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 09:45:09 Duration: 8s151ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m20s 29 8s911ms 17s390ms 11s56ms create table temp0000284196 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 01 14 3 35s997ms 11s999ms 15 2 21s698ms 10s849ms 16 8 1m39s 12s492ms 17 16 2m43s 10s187ms [ User: intelifix - Total duration: 5m20s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 5m20s - Times executed: 29 ]
-
CREATE TABLE temp0000284196 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 16:23:33 Duration: 17s390ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284196 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 16:33:04 Duration: 14s265ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284196 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:51:22 Duration: 13s486ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m19s 2 363ms 5m18s 2m39s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 01 00 2 5m19s 2m39s [ User: lenon - Total duration: 5m19s - Times executed: 2 ]
[ Application: psql - Total duration: 5m19s - Times executed: 2 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:21 Duration: 5m18s Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:21 Duration: 363ms Database: contagem User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:20 Duration: 0ms Database: rio User: lenon Remote: [local] Application: psql
13 4m50s 204 157ms 12s408ms 1s423ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 01 08 9 4s327ms 480ms 09 19 9s522ms 501ms 10 4 6s356ms 1s589ms 11 17 15s387ms 905ms 13 91 2m54s 1s922ms 14 20 19s750ms 987ms 15 14 39s231ms 2s802ms 16 25 14s993ms 599ms 17 5 5s847ms 1s169ms [ User: intelifix - Total duration: 4m50s - Times executed: 204 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 204 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-07-01 15:31:00 Duration: 12s408ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-07-01 15:31:23 Duration: 7s844ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (043764) LIMIT 1;
Date: 2026-07-01 15:30:12 Duration: 5s360ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 4m42s 22 9s810ms 31s497ms 12s857ms create table temp0000284126 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 01 08 6 1m8s 11s482ms 09 13 2m54s 13s455ms 10 3 39s39ms 13s13ms [ User: intelifix - Total duration: 4m42s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m42s - Times executed: 22 ]
-
CREATE TABLE temp0000284126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 09:17:59 Duration: 31s497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 08:22:51 Duration: 14s122ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 09:56:06 Duration: 13s835ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m33s 54 158ms 1m10s 3s953ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 01 07 8 8s139ms 1s17ms 08 8 19s127ms 2s390ms 09 9 1m55s 12s885ms 10 3 13s340ms 4s446ms 11 4 15s159ms 3s789ms 12 2 1s903ms 951ms 14 9 26s482ms 2s942ms 15 6 3s666ms 611ms 16 2 5s449ms 2s724ms 17 3 4s261ms 1s420ms [ User: intelifix - Total duration: 3m33s - Times executed: 54 ]
[ Application: psql - Total duration: 3m33s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026412);
Date: 2026-07-01 09:19:29 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026417);
Date: 2026-07-01 09:42:44 Duration: 27s478ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026437);
Date: 2026-07-01 14:50:26 Duration: 23s283ms Database: rio User: intelifix Remote: [local] Application: psql
16 3m25s 3 5s369ms 1m43s 1m8s 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 #16
Day Hour Count Duration Avg duration Jul 01 00 1 1m36s 1m36s 23 2 1m49s 54s649ms [ User: intelifix - Total duration: 3m25s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m25s - Times executed: 3 ]
-
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-01 23:15:17 Duration: 1m43s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-01 00:00:25 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-01 23:39:10 Duration: 5s369ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 3m24s 17 9s680ms 13s847ms 12s43ms create table temp0000284192 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 01 14 17 3m24s 12s43ms [ User: intelifix - Total duration: 3m24s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m24s - Times executed: 17 ]
-
CREATE TABLE temp0000284192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:42:22 Duration: 13s847ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:40:12 Duration: 13s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:33:10 Duration: 13s53ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 3m2s 55 2s88ms 6s896ms 3s310ms create table temp0000284094 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 01 07 10 24s326ms 2s432ms 08 8 22s495ms 2s811ms 09 14 51s337ms 3s666ms 10 15 52s294ms 3s486ms 14 4 15s842ms 3s960ms 15 4 15s757ms 3s939ms [ User: intelifix - Total duration: 3m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 55 ]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 09:08:16 Duration: 6s896ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 15:11:00 Duration: 4s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 14:49:02 Duration: 4s543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m59s 4 4s456ms 1m32s 44s773ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 01 20 2 1m37s 48s710ms 23 2 1m21s 40s836ms [ User: intelifix - Total duration: 2m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-01 20:08:24 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-01 23:38:39 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-01 20:10:14 Duration: 5s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2m36s 5 332ms 53s252ms 31s351ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 01 00 1 51s676ms 51s676ms 20 2 53s584ms 26s792ms 23 2 51s495ms 25s747ms [ User: intelifix - Total duration: 2m36s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m36s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-01 20:05:12 Duration: 53s252ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-01 00:03:36 Duration: 51s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-01 23:18:55 Duration: 51s47ms Database: rio User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,477 19m13s 150ms 4s914ms 781ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 01 07 8 2s128ms 266ms 08 150 2m10s 873ms 09 244 3m5s 759ms 10 285 3m16s 690ms 11 135 1m49s 814ms 12 63 48s176ms 764ms 13 60 57s61ms 951ms 14 139 1m53s 819ms 15 138 1m47s 778ms 16 165 2m9s 787ms 17 90 1m12s 802ms [ User: intelifix - Total duration: 19m13s - Times executed: 1477 ]
[ Application: [unknown] - Total duration: 19m13s - Times executed: 1477 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44286, 418, '834351951001516,241646162435,241672183650,241730910729,241673349005,230048471734,241609921940,241671569314,241654587476,241692626172,241676718794,241635019696,241609882744,241609881128,230048471431,241695653247,241713737884,241732100710,241616241221,230048492443,241649638801,241646325862,241727276770,241731247382,241652018506,241599441624,241654606468,241660127478,241647347185,241637720725,241622487183,241689209004,241692680825,241731233543,241727039496,241669282020,241730933233,241654495773,241656679701,241708868587,241728678691,241607301931,241727039799,241692679915,241654498298,241614454559,241656403737', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 16:38:09 Duration: 4s914ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (126193, 397, '226008668290', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 13:42:05 Duration: 4s194ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260494, 508, '836015903003663,241726965472,241656657072,241671509005,241728685359,241711220109,241649641125,241654355557,241728677883,241692670723,241631091840,241607236267,241656700714,241593319410,241649677996,241689133340,230043590214,230049002223,241727021920,241653474753,241609909817,241704724951,241711202430,230057328994,241604773244,241656744051,241714931930,241654531838,241646427892,241636058496,241676735564,241603064042,241622605354,241676755768', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 16:02:31 Duration: 3s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,059 8m43s 150ms 2s513ms 494ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 01 07 6 2s710ms 451ms 08 92 57s505ms 625ms 09 112 1m7s 603ms 10 202 1m43s 514ms 11 181 1m28s 491ms 12 6 3s771ms 628ms 13 73 33s259ms 455ms 14 158 1m3s 402ms 15 136 58s645ms 431ms 16 82 38s177ms 465ms 17 11 5s774ms 524ms [ User: intelifix - Total duration: 8m43s - Times executed: 1059 ]
[ Application: [unknown] - Total duration: 8m43s - Times executed: 1059 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "260624", "modelo" : "463", "itens" : "241751688894,241735448297,241748458085,241720852328,241721664461,241718984244,241750461032,241755849301,241737150810,241750510711,241748415253,241754620203,241755013350,241719145270,241751484958,241718919816,241737944153,241735101418,241720768099,241757890612,241782314656,241735055880,241725695662,241737388890,241753670829,241753561424,241753681941,241720863541,241722599412,241719017075,241706095960,241723262137,241750491012,241724793240,241719302940,241734655863,241720519108,241750284953,241750341626,241748345370,241723227082,241736742835,241720915869,241725453641,241722919701,241737006171,241737088907,241757347090,241748346279,241723032844,241721567885,241719919700,241725489503,241705032737,241725689904,241749985979,241750187390,241753679920,241751713140,241723955066", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-01 10:46:14 Duration: 2s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249092", "modelo" : "295", "itens" : "230028254261,230027596789,230028671328,229982667488,229977142135,229974600215,230032495561,230031640114,229970607882,230036919506,229991216078,229991029517,230035317486,230044877779,229962704968,229965068890,229975693441,230015159919,229980082130,229990561436", "usuario" : "414", "caixa" : "3017684", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-01 10:12:38 Duration: 2s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "260625", "modelo" : "463", "itens" : "241757636669,241718989395,241758633950,241736721015,241705557086,241748438487,241752272746,241755926278,241718810614,241751471725,241783353860,241748903842,241751191518,241750506972,241755630818,241782053845,241784173446,241722435052,241748337692,241754290115,241704896079,241736979502,241782059502,241737953952,241705006269,241783360000,241735631627,241735624858,241718934565,241753531825,241754329815,241782061119,241720054764,241784707089,241705409495,241737113051,241784750506,241722392445,241720297290,241750334655,241737900513,241782548797,241754262536,241724990611,241757283448,241737042640,241780616061,241752447790,241704957476,241724800413,241750425472,241757300824,241724346877,241755692137,241752937187,241751494757,241749925872,241721794047,241749993051,241750097381", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-01 10:49:04 Duration: 2s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 415 1h43m17s 151ms 5m35s 14s933ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 01 07 10 8m14s 49s495ms 08 35 20m33s 35s233ms 09 48 20m10s 25s220ms 10 30 5m26s 10s894ms 11 37 10m12s 16s547ms 12 6 4m49s 48s273ms 13 94 2m52s 1s834ms 14 41 8m20s 12s209ms 15 46 12m43s 16s604ms 16 37 3m10s 5s152ms 17 28 5m39s 12s128ms 18 2 517ms 258ms 22 1 1m2s 1m2s [ User: intelifix - Total duration: 1h43m17s - Times executed: 415 ]
[ Application: [unknown] - Total duration: 1h43m17s - Times executed: 415 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026435, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 14:47:52 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026409, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 08:52:50 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026442, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 15:59:14 Duration: 5m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 209 16m21s 152ms 4m7s 4s697ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 01 00 8 18s434ms 2s304ms 01 6 12s744ms 2s124ms 02 7 13s219ms 1s888ms 03 8 19s812ms 2s476ms 04 6 13s318ms 2s219ms 05 6 14s479ms 2s413ms 06 6 13s719ms 2s286ms 07 6 14s188ms 2s364ms 08 6 24s876ms 4s146ms 09 10 2m27s 14s729ms 10 7 16s798ms 2s399ms 11 7 1m15s 10s814ms 12 11 14s825ms 1s347ms 13 12 15s753ms 1s312ms 14 12 3m 15s24ms 15 12 4m22s 21s856ms 16 12 18s250ms 1s520ms 17 12 17s28ms 1s419ms 18 11 16s471ms 1s497ms 19 11 15s967ms 1s451ms 20 12 26s5ms 2s167ms 21 11 15s542ms 1s412ms 22 10 14s753ms 1s475ms [ User: intelifix - Total duration: 16m21s - Times executed: 209 ]
[ Application: psql - Total duration: 16m21s - Times executed: 209 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 15:59:14 Duration: 4m7s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 14:47:52 Duration: 2m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 09:47:17 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: psql
5 204 4m50s 157ms 12s408ms 1s423ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 01 08 9 4s327ms 480ms 09 19 9s522ms 501ms 10 4 6s356ms 1s589ms 11 17 15s387ms 905ms 13 91 2m54s 1s922ms 14 20 19s750ms 987ms 15 14 39s231ms 2s802ms 16 25 14s993ms 599ms 17 5 5s847ms 1s169ms [ User: intelifix - Total duration: 4m50s - Times executed: 204 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 204 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-07-01 15:31:00 Duration: 12s408ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-07-01 15:31:23 Duration: 7s844ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (043764) LIMIT 1;
Date: 2026-07-01 15:30:12 Duration: 5s360ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 168 9m53s 543ms 47s717ms 3s535ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 01 08 6 39s234ms 6s539ms 09 11 1m37s 8s840ms 10 5 23s652ms 4s730ms 11 20 40s386ms 2s19ms 12 9 17s345ms 1s927ms 13 11 49s221ms 4s474ms 14 27 1m3s 2s357ms 15 37 1m36s 2s619ms 16 29 2m5s 4s321ms 17 13 40s950ms 3s150ms [ User: intelifix - Total duration: 9m53s - Times executed: 168 ]
[ Application: [unknown] - Total duration: 9m53s - Times executed: 168 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-07-01 09:05:11 Duration: 47s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-01', 0408, '07:00', '21:00', 1, 2, '2025-05-01');
Date: 2026-07-01 09:02:50 Duration: 23s623ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-01', 0408, '', '', 0, 2, '2026-01-01');
Date: 2026-07-01 08:43:09 Duration: 13s590ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 162 7m3s 208ms 9s904ms 2s616ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 01 00 5 15s233ms 3s46ms 01 6 7s733ms 1s288ms 02 5 5s717ms 1s143ms 03 5 8s147ms 1s629ms 04 6 7s163ms 1s193ms 05 4 10s754ms 2s688ms 06 4 3s615ms 903ms 07 10 33s178ms 3s317ms 08 12 52s247ms 4s353ms 09 12 47s619ms 3s968ms 10 11 31s403ms 2s854ms 11 12 46s424ms 3s868ms 12 12 28s924ms 2s410ms 13 9 9s527ms 1s58ms 14 12 33s228ms 2s769ms 15 12 37s550ms 3s129ms 16 11 21s614ms 1s964ms 17 4 2s527ms 631ms 21 4 9s468ms 2s367ms 22 6 11s739ms 1s956ms [ User: intelifix - Total duration: 7m3s - Times executed: 162 ]
[ Application: psql - Total duration: 7m3s - Times executed: 162 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 11:15:11 Duration: 9s904ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 00:05:11 Duration: 9s877ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 09:45:09 Duration: 8s151ms Database: rio User: intelifix Remote: [local] Application: psql
8 134 22s13ms 150ms 210ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 01 01 1 150ms 150ms 03 1 165ms 165ms 04 2 332ms 166ms 05 2 334ms 167ms 08 23 3s765ms 163ms 09 18 2s964ms 164ms 10 24 3s944ms 164ms 11 18 2s926ms 162ms 13 6 929ms 154ms 14 11 1s879ms 170ms 15 16 2s590ms 161ms 16 9 1s537ms 170ms 17 3 492ms 164ms [ User: intelifix - Total duration: 22s13ms - Times executed: 134 ]
[ Application: [unknown] - Total duration: 22s13ms - Times executed: 134 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-07-01 09:34:47 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0287;
Date: 2026-07-01 14:43:06 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-01 10:18:47 Duration: 200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 110 49s15ms 279ms 738ms 445ms 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 #9
Day Hour Count Duration Avg duration Jul 01 00 2 960ms 480ms 01 1 463ms 463ms 03 1 386ms 386ms 04 2 801ms 400ms 05 2 756ms 378ms 06 1 368ms 368ms 07 8 3s85ms 385ms 08 12 5s457ms 454ms 09 10 5s248ms 524ms 10 9 4s100ms 455ms 11 9 3s830ms 425ms 12 5 2s293ms 458ms 13 8 3s101ms 387ms 14 9 4s483ms 498ms 15 12 5s394ms 449ms 16 9 3s949ms 438ms 17 5 2s219ms 443ms 18 2 933ms 466ms 21 1 384ms 384ms 22 1 428ms 428ms 23 1 367ms 367ms [ User: lenon - Total duration: 49s15ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 49s15ms - Times executed: 110 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-01 14:13:05 Duration: 738ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-01 09:38:41 Duration: 714ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-01 09:32:25 Duration: 704ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 110 44s399ms 150ms 1s42ms 403ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 01 07 5 1s635ms 327ms 08 9 2s989ms 332ms 09 10 4s894ms 489ms 10 10 3s801ms 380ms 11 10 4s635ms 463ms 12 1 349ms 349ms 13 2 923ms 461ms 14 16 6s767ms 422ms 15 20 7s908ms 395ms 16 8 3s428ms 428ms 17 16 6s25ms 376ms 18 2 691ms 345ms 22 1 347ms 347ms [ User: intelifix - Total duration: 44s399ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 44s399ms - Times executed: 110 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-01 09:15:18 Duration: 1s42ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-01 14:01:06 Duration: 700ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-07-01 16:00:47 Duration: 594ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 105 32s661ms 150ms 4s919ms 311ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 01 00 1 156ms 156ms 03 1 158ms 158ms 07 3 611ms 203ms 08 9 15s266ms 1s696ms 09 1 183ms 183ms 10 6 970ms 161ms 11 6 1s98ms 183ms 12 2 316ms 158ms 13 6 1s61ms 176ms 14 8 1s514ms 189ms 15 21 3s762ms 179ms 16 17 3s325ms 195ms 17 24 4s234ms 176ms [ User: intelifix - Total duration: 32s661ms - Times executed: 105 ]
[ Application: [unknown] - Total duration: 32s661ms - Times executed: 105 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "363", "data-de" : "2026-06-01", "data-ate" : "2026-07-01", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 415 }');
Date: 2026-07-01 08:02:44 Duration: 4s919ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-06-01", "data-ate" : "2026-07-01", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 415 }');
Date: 2026-07-01 08:04:09 Duration: 3s655ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "365", "data-de" : "2026-06-01", "data-ate" : "2026-07-01", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 415 }');
Date: 2026-07-01 08:04:21 Duration: 2s998ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 104 20s651ms 150ms 514ms 198ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 01 00 4 795ms 198ms 01 1 169ms 169ms 03 1 361ms 361ms 04 1 514ms 514ms 05 2 339ms 169ms 07 13 2s352ms 180ms 08 17 3s468ms 204ms 09 15 3s4ms 200ms 10 15 2s874ms 191ms 11 8 1s474ms 184ms 12 1 176ms 176ms 14 3 602ms 200ms 15 14 2s656ms 189ms 16 9 1s860ms 206ms [ User: intelifix - Total duration: 20s651ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 20s651ms - Times executed: 104 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229761035353,229650615273,229652175571,229760114646,229683153039,229762897678,229762859415,229679904046,229680284364,216917292237,229683138087,229654380007,229654541717,229757011628,229651979211,229653169696,229681999200,229654568183,229682915260,229683161222,229682608989,229757743450,229683325053,229683216681,229756683941,229682413741,229683156877,229682826587,229759376785,229684052532,229682610001,229760111414,216917560019,229682151718,229651212840,229684078695,229762170931', NULL, NULL, 0159, 00);
Date: 2026-07-01 04:04:59 Duration: 514ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '229928031416,230003816679,229948352535,229992808602,230015483643,229937680910,229996246277,229963835471,229937542939,230005067373,229931153146,230016877280,230013737591,229937269601,230017204260,229957379005', NULL, NULL, 0287, 00);
Date: 2026-07-01 16:12:22 Duration: 373ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229839923434,229839936162,229839032023,229854036371,229853498787,229848271623,229839508791,229855937791,229855294160,229851578297,229842628603,229840004856,229846669704,229837340422,229839093039,229845692729,229856226181,229855367275,229842251619,229851569105', NULL, NULL, 0160, 00);
Date: 2026-07-01 03:57:16 Duration: 361ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 101 57s60ms 363ms 946ms 564ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 01 00 2 1s268ms 634ms 01 1 622ms 622ms 03 1 544ms 544ms 04 2 1s14ms 507ms 05 2 1s1ms 500ms 07 5 2s398ms 479ms 08 12 6s845ms 570ms 09 10 6s212ms 621ms 10 9 5s168ms 574ms 11 9 4s798ms 533ms 12 5 2s898ms 579ms 13 5 2s582ms 516ms 14 9 5s581ms 620ms 15 12 6s542ms 545ms 16 9 5s115ms 568ms 17 5 2s758ms 551ms 18 2 1s143ms 571ms 23 1 564ms 564ms [ User: intelifix - Total duration: 57s60ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 57s60ms - Times executed: 101 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-01 14:13:05 Duration: 946ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-01 09:32:25 Duration: 835ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (469, 19, 1);
Date: 2026-07-01 09:38:41 Duration: 811ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 82 16m9s 8s531ms 29s873ms 11s823ms create table temp0000284094 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 01 07 16 2m53s 10s850ms 08 14 2m51s 12s235ms 09 15 3m6s 12s443ms 10 6 1m19s 13s209ms 11 3 33s400ms 11s133ms 12 6 1m4s 10s688ms 14 6 1m8s 11s494ms 15 16 3m12s 12s14ms [ User: intelifix - Total duration: 16m9s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 16m9s - Times executed: 82 ]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 07:08:09 Duration: 29s873ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 15:52:11 Duration: 19s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 10:16:22 Duration: 15s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 63 21s361ms 150ms 1s54ms 339ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 01 08 24 8s563ms 356ms 09 16 6s467ms 404ms 10 6 1s742ms 290ms 11 3 603ms 201ms 13 1 191ms 191ms 14 1 205ms 205ms 15 10 2s690ms 269ms 16 2 898ms 449ms [ User: intelifix - Total duration: 21s361ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 21s361ms - Times executed: 63 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '6C11BA685A85,C4EBFF89D738,F4E84F838CB2,D89A0DAD0197,D831399C8CF0,843C99356B4F,5872C98CE80B,C4EBFF8A973E,843C992D1E89,843C993413B7,3CF9F0AB1BDC,D89A0DAD06D1,3CF9F0ADF188,3891484F06E7,F4E84F81F77C,843C99331D75,C4EBFF8C1F8A,C4EBFF8BBE9A,F4E84F8975DE,4896D9564188', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-01 09:42:37 Duration: 1s54ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '843C9936963B,C4EBFF89CFE8,C4EBFF8BC248,C4EBFF8F22FC,C4EBFF8D19B0,F4E84F81BFA2,843C992F17D9,4896D95892AA,4896D9588CE0,F4E84F818D44,C4EBFF8AFD32,5872C98F6C81,4896D94FFCC4,C4EBFF8D440A,843C99369B6F,C4EBFF89DBB2,4896D957D68E,843C993383D5,5872C98D4CA3,D8313998C3E4', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-01 09:28:22 Duration: 982ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '4896D958658C,3CF9F0A47784,6C11BA6C142B,C4EBFF8A14B8,D89A0D85CD49,6C11BA65247F,D89A0DAA63B3,F4E84F8486CC,689E29BCD54F,843C992C3903,14CA56D4BAF9,843C9935D659,D89A0DA8BC3B,C4EBFF8C2B84,689E29BE973D,C4EBFF8D3450,D89A0DA449B5,14CA56D2753B,D89A0DA4EA41', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-01 08:58:12 Duration: 953ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 55 3m2s 2s88ms 6s896ms 3s310ms create table temp0000284094 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 01 07 10 24s326ms 2s432ms 08 8 22s495ms 2s811ms 09 14 51s337ms 3s666ms 10 15 52s294ms 3s486ms 14 4 15s842ms 3s960ms 15 4 15s757ms 3s939ms [ User: intelifix - Total duration: 3m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 55 ]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 09:08:16 Duration: 6s896ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 15:11:00 Duration: 4s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 14:49:02 Duration: 4s543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 54 3m33s 158ms 1m10s 3s953ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 01 07 8 8s139ms 1s17ms 08 8 19s127ms 2s390ms 09 9 1m55s 12s885ms 10 3 13s340ms 4s446ms 11 4 15s159ms 3s789ms 12 2 1s903ms 951ms 14 9 26s482ms 2s942ms 15 6 3s666ms 611ms 16 2 5s449ms 2s724ms 17 3 4s261ms 1s420ms [ User: intelifix - Total duration: 3m33s - Times executed: 54 ]
[ Application: psql - Total duration: 3m33s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026412);
Date: 2026-07-01 09:19:29 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026417);
Date: 2026-07-01 09:42:44 Duration: 27s478ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026437);
Date: 2026-07-01 14:50:26 Duration: 23s283ms Database: rio User: intelifix Remote: [local] Application: psql
18 49 12s430ms 153ms 719ms 253ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 01 09 10 3s449ms 344ms 10 1 280ms 280ms 11 10 2s431ms 243ms 13 6 1s228ms 204ms 14 9 2s224ms 247ms 15 5 1s101ms 220ms 16 3 662ms 220ms 17 5 1s52ms 210ms [ User: intelifix - Total duration: 12s430ms - Times executed: 49 ]
[ Application: [unknown] - Total duration: 12s430ms - Times executed: 49 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "125887", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-07-01", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "Cosmético Pintura D= 2-2", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-01 09:57:10 Duration: 719ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "124981", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-07-01", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "DEFEITO BGA D= 7-4", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-01 14:11:16 Duration: 638ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "259268", "oficina" : "6", "cliente" : "5", "usuario" : "405", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-01 09:24:18 Duration: 472ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 48 2h2m17s 1s191ms 9m17s 2m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 01 07 3 7m39s 2m33s 08 3 7m3s 2m21s 09 3 9m56s 3m18s 10 3 9m3s 3m1s 11 3 8m43s 2m54s 12 3 7m59s 2m39s 13 3 6m13s 2m4s 14 3 8m11s 2m43s 15 3 8m41s 2m53s 16 3 8m17s 2m45s 17 3 8m10s 2m43s 18 3 6m13s 2m4s 19 3 5m52s 1m57s 20 3 8m9s 2m43s 21 3 5m39s 1m53s 22 3 6m22s 2m7s [ User: intelifix - Total duration: 2h2m17s - Times executed: 48 ]
[ Application: psql - Total duration: 2h2m17s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 09:14:18 Duration: 9m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 10:13:29 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 15:13:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: psql
20 47 1h12m22s 193ms 4m57s 1m32s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 01 07 3 4m12s 1m24s 08 3 4m27s 1m29s 09 3 5m43s 1m54s 10 2 5m53s 2m56s 11 3 5m5s 1m41s 12 3 4m35s 1m31s 13 3 3m46s 1m15s 14 3 4m37s 1m32s 15 3 5m19s 1m46s 16 3 5m 1m40s 17 3 4m39s 1m33s 18 3 3m38s 1m12s 19 3 3m36s 1m12s 20 3 4m22s 1m27s 21 3 3m33s 1m11s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h12m22s - Times executed: 47 ]
[ Application: psql - Total duration: 1h12m22s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 10:19:54 Duration: 4m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 09:20:34 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 15:18:56 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m12s 8m11s 4m46s 3 14m20s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 01 05 3 14m20s 4m46s [ User: intelifix - Total duration: 14m20s - Times executed: 3 ]
[ Application: psql - Total duration: 14m20s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-01 05:08:13 Duration: 8m11s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-01 05:12:09 Duration: 3m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-01 05:14:21 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
2 363ms 5m18s 2m39s 2 5m19s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 01 00 2 5m19s 2m39s [ User: lenon - Total duration: 5m19s - Times executed: 2 ]
[ Application: psql - Total duration: 5m19s - Times executed: 2 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:21 Duration: 5m18s Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:21 Duration: 363ms Database: contagem User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-01 00:07:20 Duration: 0ms Database: rio User: lenon Remote: [local] Application: psql
3 1s191ms 9m17s 2m32s 48 2h2m17s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 01 07 3 7m39s 2m33s 08 3 7m3s 2m21s 09 3 9m56s 3m18s 10 3 9m3s 3m1s 11 3 8m43s 2m54s 12 3 7m59s 2m39s 13 3 6m13s 2m4s 14 3 8m11s 2m43s 15 3 8m41s 2m53s 16 3 8m17s 2m45s 17 3 8m10s 2m43s 18 3 6m13s 2m4s 19 3 5m52s 1m57s 20 3 8m9s 2m43s 21 3 5m39s 1m53s 22 3 6m22s 2m7s [ User: intelifix - Total duration: 2h2m17s - Times executed: 48 ]
[ Application: psql - Total duration: 2h2m17s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 09:14:18 Duration: 9m17s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 10:13:29 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-01 15:13:04 Duration: 8m2s Database: rio User: intelifix Remote: [local] Application: psql
4 193ms 4m57s 1m32s 47 1h12m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 01 07 3 4m12s 1m24s 08 3 4m27s 1m29s 09 3 5m43s 1m54s 10 2 5m53s 2m56s 11 3 5m5s 1m41s 12 3 4m35s 1m31s 13 3 3m46s 1m15s 14 3 4m37s 1m32s 15 3 5m19s 1m46s 16 3 5m 1m40s 17 3 4m39s 1m33s 18 3 3m38s 1m12s 19 3 3m36s 1m12s 20 3 4m22s 1m27s 21 3 3m33s 1m11s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h12m22s - Times executed: 47 ]
[ Application: psql - Total duration: 1h12m22s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 10:19:54 Duration: 4m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 09:20:34 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-01 15:18:56 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql
5 5s369ms 1m43s 1m8s 3 3m25s 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 #5
Day Hour Count Duration Avg duration Jul 01 00 1 1m36s 1m36s 23 2 1m49s 54s649ms [ User: intelifix - Total duration: 3m25s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 3m25s - Times executed: 3 ]
-
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-01 23:15:17 Duration: 1m43s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-01 00:00:25 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
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-01 23:39:10 Duration: 5s369ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 4s456ms 1m32s 44s773ms 4 2m59s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 01 20 2 1m37s 48s710ms 23 2 1m21s 40s836ms [ User: intelifix - Total duration: 2m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-01 20:08:24 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-01 23:38:39 Duration: 1m17s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-01 20:10:14 Duration: 5s244ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 332ms 53s252ms 31s351ms 5 2m36s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 01 00 1 51s676ms 51s676ms 20 2 53s584ms 26s792ms 23 2 51s495ms 25s747ms [ User: intelifix - Total duration: 2m36s - Times executed: 5 ]
[ Application: pg_dump - Total duration: 2m36s - Times executed: 5 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-01 20:05:12 Duration: 53s252ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-01 00:03:36 Duration: 51s676ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-01 23:18:55 Duration: 51s47ms Database: rio User: intelifix Remote: [local] Application: pg_dump
8 151ms 5m35s 14s933ms 415 1h43m17s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 01 07 10 8m14s 49s495ms 08 35 20m33s 35s233ms 09 48 20m10s 25s220ms 10 30 5m26s 10s894ms 11 37 10m12s 16s547ms 12 6 4m49s 48s273ms 13 94 2m52s 1s834ms 14 41 8m20s 12s209ms 15 46 12m43s 16s604ms 16 37 3m10s 5s152ms 17 28 5m39s 12s128ms 18 2 517ms 258ms 22 1 1m2s 1m2s [ User: intelifix - Total duration: 1h43m17s - Times executed: 415 ]
[ Application: [unknown] - Total duration: 1h43m17s - Times executed: 415 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026435, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 14:47:52 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026409, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 08:52:50 Duration: 5m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026442, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-01 15:59:14 Duration: 5m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s810ms 31s497ms 12s857ms 22 4m42s create table temp0000284126 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 01 08 6 1m8s 11s482ms 09 13 2m54s 13s455ms 10 3 39s39ms 13s13ms [ User: intelifix - Total duration: 4m42s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m42s - Times executed: 22 ]
-
CREATE TABLE temp0000284126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 09:17:59 Duration: 31s497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 08:22:51 Duration: 14s122ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284126 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 09:56:06 Duration: 13s835ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s680ms 13s847ms 12s43ms 17 3m24s create table temp0000284192 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 01 14 17 3m24s 12s43ms [ User: intelifix - Total duration: 3m24s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m24s - Times executed: 17 ]
-
CREATE TABLE temp0000284192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:42:22 Duration: 13s847ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:40:12 Duration: 13s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284192 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:33:10 Duration: 13s53ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s531ms 29s873ms 11s823ms 82 16m9s create table temp0000284094 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 01 07 16 2m53s 10s850ms 08 14 2m51s 12s235ms 09 15 3m6s 12s443ms 10 6 1m19s 13s209ms 11 3 33s400ms 11s133ms 12 6 1m4s 10s688ms 14 6 1m8s 11s494ms 15 16 3m12s 12s14ms [ User: intelifix - Total duration: 16m9s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 16m9s - Times executed: 82 ]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 07:08:09 Duration: 29s873ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 15:52:11 Duration: 19s542ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 10:16:22 Duration: 15s61ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s911ms 17s390ms 11s56ms 29 5m20s create table temp0000284196 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 01 14 3 35s997ms 11s999ms 15 2 21s698ms 10s849ms 16 8 1m39s 12s492ms 17 16 2m43s 10s187ms [ User: intelifix - Total duration: 5m20s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 5m20s - Times executed: 29 ]
-
CREATE TABLE temp0000284196 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 16:23:33 Duration: 17s390ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284196 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 16:33:04 Duration: 14s265ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284196 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-01 14:51:22 Duration: 13s486ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 152ms 4m7s 4s697ms 209 16m21s call rs_giga_triagem (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 01 00 8 18s434ms 2s304ms 01 6 12s744ms 2s124ms 02 7 13s219ms 1s888ms 03 8 19s812ms 2s476ms 04 6 13s318ms 2s219ms 05 6 14s479ms 2s413ms 06 6 13s719ms 2s286ms 07 6 14s188ms 2s364ms 08 6 24s876ms 4s146ms 09 10 2m27s 14s729ms 10 7 16s798ms 2s399ms 11 7 1m15s 10s814ms 12 11 14s825ms 1s347ms 13 12 15s753ms 1s312ms 14 12 3m 15s24ms 15 12 4m22s 21s856ms 16 12 18s250ms 1s520ms 17 12 17s28ms 1s419ms 18 11 16s471ms 1s497ms 19 11 15s967ms 1s451ms 20 12 26s5ms 2s167ms 21 11 15s542ms 1s412ms 22 10 14s753ms 1s475ms [ User: intelifix - Total duration: 16m21s - Times executed: 209 ]
[ Application: psql - Total duration: 16m21s - Times executed: 209 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 15:59:14 Duration: 4m7s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 14:47:52 Duration: 2m46s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-01 09:47:17 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: psql
14 158ms 1m10s 3s953ms 54 3m33s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 01 07 8 8s139ms 1s17ms 08 8 19s127ms 2s390ms 09 9 1m55s 12s885ms 10 3 13s340ms 4s446ms 11 4 15s159ms 3s789ms 12 2 1s903ms 951ms 14 9 26s482ms 2s942ms 15 6 3s666ms 611ms 16 2 5s449ms 2s724ms 17 3 4s261ms 1s420ms [ User: intelifix - Total duration: 3m33s - Times executed: 54 ]
[ Application: psql - Total duration: 3m33s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026412);
Date: 2026-07-01 09:19:29 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026417);
Date: 2026-07-01 09:42:44 Duration: 27s478ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026437);
Date: 2026-07-01 14:50:26 Duration: 23s283ms Database: rio User: intelifix Remote: [local] Application: psql
15 543ms 47s717ms 3s535ms 168 9m53s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 01 08 6 39s234ms 6s539ms 09 11 1m37s 8s840ms 10 5 23s652ms 4s730ms 11 20 40s386ms 2s19ms 12 9 17s345ms 1s927ms 13 11 49s221ms 4s474ms 14 27 1m3s 2s357ms 15 37 1m36s 2s619ms 16 29 2m5s 4s321ms 17 13 40s950ms 3s150ms [ User: intelifix - Total duration: 9m53s - Times executed: 168 ]
[ Application: [unknown] - Total duration: 9m53s - Times executed: 168 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-06-29', 0302, '', '', 0, 6, '2026-06-01');
Date: 2026-07-01 09:05:11 Duration: 47s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-01', 0408, '07:00', '21:00', 1, 2, '2025-05-01');
Date: 2026-07-01 09:02:50 Duration: 23s623ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-01', 0408, '', '', 0, 2, '2026-01-01');
Date: 2026-07-01 08:43:09 Duration: 13s590ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 2s88ms 6s896ms 3s310ms 55 3m2s create table temp0000284094 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 01 07 10 24s326ms 2s432ms 08 8 22s495ms 2s811ms 09 14 51s337ms 3s666ms 10 15 52s294ms 3s486ms 14 4 15s842ms 3s960ms 15 4 15s757ms 3s939ms [ User: intelifix - Total duration: 3m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 3m2s - Times executed: 55 ]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 09:08:16 Duration: 6s896ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 15:11:00 Duration: 4s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284094 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-06-2026", "ate" :"01-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-01 14:49:02 Duration: 4s543ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 208ms 9s904ms 2s616ms 162 7m3s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 01 00 5 15s233ms 3s46ms 01 6 7s733ms 1s288ms 02 5 5s717ms 1s143ms 03 5 8s147ms 1s629ms 04 6 7s163ms 1s193ms 05 4 10s754ms 2s688ms 06 4 3s615ms 903ms 07 10 33s178ms 3s317ms 08 12 52s247ms 4s353ms 09 12 47s619ms 3s968ms 10 11 31s403ms 2s854ms 11 12 46s424ms 3s868ms 12 12 28s924ms 2s410ms 13 9 9s527ms 1s58ms 14 12 33s228ms 2s769ms 15 12 37s550ms 3s129ms 16 11 21s614ms 1s964ms 17 4 2s527ms 631ms 21 4 9s468ms 2s367ms 22 6 11s739ms 1s956ms [ User: intelifix - Total duration: 7m3s - Times executed: 162 ]
[ Application: psql - Total duration: 7m3s - Times executed: 162 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 11:15:11 Duration: 9s904ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 00:05:11 Duration: 9s877ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-01 09:45:09 Duration: 8s151ms Database: rio User: intelifix Remote: [local] Application: psql
18 157ms 12s408ms 1s423ms 204 4m50s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 01 08 9 4s327ms 480ms 09 19 9s522ms 501ms 10 4 6s356ms 1s589ms 11 17 15s387ms 905ms 13 91 2m54s 1s922ms 14 20 19s750ms 987ms 15 14 39s231ms 2s802ms 16 25 14s993ms 599ms 17 5 5s847ms 1s169ms [ User: intelifix - Total duration: 4m50s - Times executed: 204 ]
[ Application: [unknown] - Total duration: 4m50s - Times executed: 204 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042960) LIMIT 1;
Date: 2026-07-01 15:31:00 Duration: 12s408ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (042959) LIMIT 1;
Date: 2026-07-01 15:31:23 Duration: 7s844ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (043764) LIMIT 1;
Date: 2026-07-01 15:30:12 Duration: 5s360ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 4s914ms 781ms 1,477 19m13s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 01 07 8 2s128ms 266ms 08 150 2m10s 873ms 09 244 3m5s 759ms 10 285 3m16s 690ms 11 135 1m49s 814ms 12 63 48s176ms 764ms 13 60 57s61ms 951ms 14 139 1m53s 819ms 15 138 1m47s 778ms 16 165 2m9s 787ms 17 90 1m12s 802ms [ User: intelifix - Total duration: 19m13s - Times executed: 1477 ]
[ Application: [unknown] - Total duration: 19m13s - Times executed: 1477 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (44286, 418, '834351951001516,241646162435,241672183650,241730910729,241673349005,230048471734,241609921940,241671569314,241654587476,241692626172,241676718794,241635019696,241609882744,241609881128,230048471431,241695653247,241713737884,241732100710,241616241221,230048492443,241649638801,241646325862,241727276770,241731247382,241652018506,241599441624,241654606468,241660127478,241647347185,241637720725,241622487183,241689209004,241692680825,241731233543,241727039496,241669282020,241730933233,241654495773,241656679701,241708868587,241728678691,241607301931,241727039799,241692679915,241654498298,241614454559,241656403737', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 16:38:09 Duration: 4s914ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (126193, 397, '226008668290', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 13:42:05 Duration: 4s194ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260494, 508, '836015903003663,241726965472,241656657072,241671509005,241728685359,241711220109,241649641125,241654355557,241728677883,241692670723,241631091840,241607236267,241656700714,241593319410,241649677996,241689133340,230043590214,230049002223,241727021920,241653474753,241609909817,241704724951,241711202430,230057328994,241604773244,241656744051,241714931930,241654531838,241646427892,241636058496,241676735564,241603064042,241622605354,241676755768', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-01 16:02:31 Duration: 3s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 363ms 946ms 564ms 101 57s60ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 01 00 2 1s268ms 634ms 01 1 622ms 622ms 03 1 544ms 544ms 04 2 1s14ms 507ms 05 2 1s1ms 500ms 07 5 2s398ms 479ms 08 12 6s845ms 570ms 09 10 6s212ms 621ms 10 9 5s168ms 574ms 11 9 4s798ms 533ms 12 5 2s898ms 579ms 13 5 2s582ms 516ms 14 9 5s581ms 620ms 15 12 6s542ms 545ms 16 9 5s115ms 568ms 17 5 2s758ms 551ms 18 2 1s143ms 571ms 23 1 564ms 564ms [ User: intelifix - Total duration: 57s60ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 57s60ms - Times executed: 101 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-01 14:13:05 Duration: 946ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-01 09:32:25 Duration: 835ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (469, 19, 1);
Date: 2026-07-01 09:38:41 Duration: 811ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 01 12 1 0ms 0ms 14 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms [ User: intelifix - Total duration: 19s176ms - Times executed: 5 ]
[ Application: psql - Total duration: 17s493ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1s683ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 21,386 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 14 FATAL entries
- 5256 ERROR entries
- 0 WARNING entries
- 18 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,026 Max number of times the same event was reported
- 5,288 Total events found
Rank Times reported Error 1 5,026 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 01 00 60 01 59 02 60 03 59 04 60 05 59 06 66 07 273 08 540 09 501 10 498 11 484 12 306 13 181 14 447 15 570 16 347 17 101 18 60 19 59 20 60 21 58 22 59 23 59 - ERROR: prepared statement "_PLAN0000000029F3BEE0" does not exist
- ERROR: prepared statement "_PLAN0000000029F18C10" does not exist
- ERROR: prepared statement "_PLAN0000000029C42470" does not exist
Statement: DEALLOCATE "_PLAN0000000029F3BEE0"
Date: 2026-07-01 00:00:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029F18C10"
Date: 2026-07-01 00:01:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C42470"
Date: 2026-07-01 00:02:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 75 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 01 08 12 09 12 10 12 11 15 12 18 13 2 14 2 15 2 - ERROR: trailing junk after numeric literal at or near "9A" at character 39
- ERROR: trailing junk after numeric literal at or near "9A" at character 39
- ERROR: trailing junk after numeric literal at or near "9A" at character 39
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-83-9A-69)
Date: 2026-07-01 08:11:52 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-83-9A-69)
Date: 2026-07-01 08:11:53 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-83-9A-69)
Date: 2026-07-01 08:11:53 Database: rio Application: [unknown] User: etiquetas Remote: [local]
3 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 01 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 1 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-01 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
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-01 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
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-01 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 01 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-01 08:00:04 Database: brasilia Application: psql User: intelifix Remote: [local]
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-01 08:20:09 Database: brasilia Application: psql User: intelifix Remote: [local]
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-01 08:40:04 Database: brasilia Application: psql User: intelifix Remote: [local]
5 27 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 01 08 6 09 3 10 6 11 6 12 6 - ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-93-A1-D2)
Date: 2026-07-01 08:10:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-93-A1-D2)
Date: 2026-07-01 08:10:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-93-A1-D2)
Date: 2026-07-01 08:10:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 14 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 01 07 3 09 3 10 2 11 2 13 2 14 2 - ERROR: syntax error at or near "[" at character 27
- ERROR: syntax error at or near "[" at character 27
- ERROR: syntax error at or near "[" at character 27
Statement: SELECT * FROM RS_ETIQUETA([I%)
Date: 2026-07-01 07:44:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA([I%)
Date: 2026-07-01 07:44:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA([I%)
Date: 2026-07-01 07:44:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 10 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 01 09 2 11 2 14 3 15 3 - LOG: process 1284236 still waiting for ShareLock on transaction 1934282 after 1000.095 ms
- LOG: process 1284236 still waiting for ShareLock on transaction 1934282 after 27125.358 ms
- LOG: process 1386939 still waiting for ShareLock on transaction 1942237 after 1000.097 ms
Detail: Process holding the lock: 1220914. Wait queue: 1284236.
Context: while updating tuple (72253,44) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-01 09:45:12 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1220914. Wait queue: 1284236.
Context: while updating tuple (72253,44) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-01 09:45:38 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1378758. Wait queue: 1386939.
Context: while updating tuple (72297,37) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-01 11:05:08 Database: rio Application: psql User: intelifix Remote: [local]
8 7 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 01 05 4 06 1 11 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-01 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-01 05:32:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-01 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local]
9 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 01 00 1 03 1 05 1 06 1 17 1 22 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-01 00:07:21 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-01 03:36:43 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-01 05:07:30 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
10 5 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 01 00 1 08 1 14 1 17 2 - LOG: process 687312 still waiting for AccessExclusiveLock on relation 362299 of database 358220 after 1000.111 ms
- LOG: process 1168110 still waiting for AccessExclusiveLock on relation 1798719 of database 358220 after 1000.193 ms
- LOG: process 1495677 still waiting for AccessExclusiveLock on relation 1837109 of database 358220 after 1000.154 ms
Detail: Process holding the lock: 684461. Wait queue: 687312.
Context: SQL statement "DROP TABLE IF EXISTS auditor.AUDITOR_2026_03" PL/pgSQL function rs_auditor_novas_tabelas(date) line 75 at EXECUTE
Statement: SELECT * FROM RS_AUDITOR_NOVAS_TABELAS()Date: 2026-07-01 00:02:03 Database: rio Application: psql User: lenon Remote: [local]
Detail: Process holding the lock: 1184706. Wait queue: 1168110.
Statement: DROP TABLE IF EXISTS temp0000284094;Date: 2026-07-01 08:11:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1524915. Wait queue: 1495677.
Statement: DROP TABLE IF EXISTS temp0000284192;Date: 2026-07-01 14:36:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 01 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-01 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-01 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-01 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 4 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 01 08 1 14 1 17 2 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000284094"
Date: 2026-07-01 08:11:44
Context: automatic vacuum of table "rio.public.temp0000284192"
Date: 2026-07-01 14:36:48
Context: automatic vacuum of table "rio.public.temp0000284124"
Date: 2026-07-01 17:29:50
13 3 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 01 14 1 16 2 - ERROR: unterminated quoted string at or near "'44D454C1F3B8'');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('44D454C1F3B8'');
Date: 2026-07-01 14:43:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-01 16:29:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-01 16:30:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 3 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 01 09 3 - ERROR: invalid byte sequence for encoding "UTF8": 0x89
- ERROR: invalid byte sequence for encoding "UTF8": 0x89
- ERROR: invalid byte sequence for encoding "UTF8": 0x89
Date: 2026-07-01 09:06:39 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-01 09:06:40 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-01 09:06:40 Database: contagem Application: [unknown] User: intelifix Remote: [local]
15 2 ERROR: prepared statement "..." does not exist/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(
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 01 21 1 22 1 - ERROR: prepared statement "_PLAN0000000029F3F5D0" does not exist/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(
- ERROR: prepared statement "_PLAN00000000299291D0" does not exist/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(
Statement: DEALLOCATE "_PLAN0000000029F3F5D0"
Date: 2026-07-01 21:39:53 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000299291D0"
Date: 2026-07-01 22:00:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
16 2 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 01 16 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73932585850072303726)Date: 2026-07-01 16:36:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73932585850072303726)Date: 2026-07-01 16:36:47 Database: rio Application: [unknown] User: etiquetas Remote: [local]
17 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 01 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-01 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-01 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 01 03 1 - LOG: database system was shut down at 2026-07-01 03:05:01 -03
Date: 2026-07-01 03:05:03
19 1 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 01 00 1 - FATAL: connection to client lost
Date: 2026-07-01 00:07:20 Database: rio Application: pg_dump User: intelifix Remote: [local]
20 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #20
Day Hour Count Jul 01 00 1 - LOG: could not send data to client: Broken pipe
Statement: COPY public.posicao_estoque13 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-07-01 00:07:20 Database: rio Application: pg_dump User: intelifix Remote: [local]
21 1 ERROR: value "..." is out of range for type integer
Times Reported Most Frequent Error / Event #21
Day Hour Count Jul 01 17 1 - ERROR: value "9897969594" is out of range for type integer
Context: PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 165 at assignment
Statement: SELECT RS_SETGLOBAL('USUARIO',433);SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO( 026449 ); ERROR: value "9897969594" is out of range for type integer CONTEXT: PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 165 at assignmentDate: 2026-07-01 17:40:59 Database: rio Application: psql User: intelifix Remote: [local]
22 1 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #22
Day Hour Count Jul 01 00 1 - ERROR: canceling statement due to user request
Statement: COPY public.posicao_estoque13 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-07-01 00:07:20 Database: rio Application: pg_dump User: intelifix Remote: [local]
23 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #23
Day Hour Count Jul 01 10 1 - LOG: skipping analyze of "temp0000235010" --- lock not available
Date: 2026-07-01 10:50:07
24 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #24
Day Hour Count Jul 01 18 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' 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
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-01 18:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]