pgBadger-
Global information
- Generated on Mon Sep 21 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 40,249 log entries in 14s
- Log start from 2026-09-21 00:02:03 to 2026-09-21 23:49:53
-
Overview
Global Stats
- 387 Number of unique normalized queries
- 4,779 Number of queries
- 8h25m19s Total query duration
- 2026-09-21 00:02:23 First query
- 2026-09-21 23:42:51 Last query
- 7 queries/s at 2026-09-21 10:45:50 Query peak
- 8h25m19s Total query duration
- 162ms Prepare/parse total duration
- 0ms Bind total duration
- 8h25m19s Execute total duration
- 4,806 Number of events
- 14 Number of unique normalized events
- 4,453 Max number of times the same event was reported
- 0 Number of cancellation
- 392 Total number of automatic vacuums
- 784 Total number of automatic analyzes
- 23 Number temporary file
- 531.03 MiB Max size of temporary file
- 87.10 MiB Average size of temporary file
- 370 Total number of sessions
- 7 sessions at 2026-09-21 19:07:33 Session peak
- 12d11h32m52s Total duration of sessions
- 48m34s Average duration of sessions
- 12 Average queries per session
- 1m21s Average queries duration per session
- 47m12s Average idle time per session
- 431 Total number of connections
- 4 connections/s at 2026-09-21 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2026-09-21 10:45:50 Date
SELECT Traffic
Key values
- 7 queries/s Query Peak
- 2026-09-21 10:45:50 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-21 23:42:33 Date
Queries duration
Key values
- 8h25m19s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 21 00 17 0ms 21s881ms 5s983ms 1m5s 1m5s 1m5s 01 6 0ms 2s34ms 1s774ms 2s34ms 2s34ms 2s34ms 02 7 0ms 1s762ms 1s440ms 1s493ms 1s716ms 1s762ms 03 6 0ms 1s731ms 1s395ms 202ms 1s612ms 1s731ms 04 6 0ms 1s762ms 1s582ms 1s474ms 1s580ms 1s762ms 05 13 0ms 11m42s 1m53s 2s277ms 3m2s 11m42s 06 16 0ms 17s487ms 3s754ms 1s546ms 9s556ms 23s995ms 07 139 0ms 10m38s 14s49ms 47s618ms 4m18s 11m18s 08 408 0ms 5m32s 5s565ms 1m11s 4m57s 6m6s 09 459 150ms 6m16s 5s782ms 1m36s 6m4s 7m21s 10 698 150ms 5m37s 3s507ms 1m 4m37s 11m29s 11 523 151ms 20m41s 7s445ms 3m54s 6m26s 20m46s 12 176 0ms 6m7s 5s995ms 20s308ms 1m38s 7m12s 13 255 0ms 5m12s 3s717ms 18s439ms 31s447ms 5m58s 14 476 150ms 5m53s 4s404ms 56s320ms 5m47s 5m58s 15 427 150ms 6m 5s682ms 1m26s 6m2s 6m11s 16 336 150ms 5m51s 5s240ms 24s122ms 5m44s 6m1s 17 243 0ms 7m38s 6s650ms 49s875ms 4m5s 7m50s 18 26 0ms 5m17s 23s147ms 3s29ms 15s180ms 5m48s 19 19 0ms 5m18s 31s333ms 2s956ms 14s967ms 5m49s 20 121 0ms 5m32s 9s833ms 1m6s 1m20s 6m30s 21 26 0ms 5m3s 22s652ms 7s103ms 9s219ms 5m47s 22 31 0ms 5m4s 19s417ms 6s916ms 9s260ms 5m48s 23 345 0ms 1m3s 5s646ms 1m5s 1m6s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 21 00 3 0 9s146ms 0ms 27s438ms 27s438ms 01 0 0 0ms 0ms 0ms 0ms 02 1 0 501ms 0ms 0ms 501ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 6 0 4s235ms 0ms 0ms 1s417ms 07 81 0 20s42ms 4s813ms 47s618ms 6m56s 08 298 0 5s885ms 12s898ms 46s504ms 5m27s 09 346 0 6s187ms 13s610ms 1m36s 5m43s 10 538 0 3s247ms 9s972ms 25s874ms 5m34s 11 431 0 7s878ms 16s902ms 3m54s 6m26s 12 137 0 7s3ms 3s793ms 20s308ms 4m11s 13 202 0 4s313ms 12s46ms 14s922ms 3m31s 14 395 0 4s311ms 15s502ms 27s718ms 5m48s 15 324 0 6s389ms 15s145ms 53s44ms 6m2s 16 270 0 5s952ms 15s569ms 19s823ms 5m51s 17 197 0 7s386ms 10s18ms 31s574ms 5m57s 18 12 0 48s191ms 0ms 812ms 3m31s 19 6 0 1m35s 0ms 0ms 3m28s 20 18 84 11s371ms 42s447ms 1m1s 3m41s 21 9 0 1m 0ms 0ms 3m16s 22 11 0 50s28ms 0ms 0ms 3m20s 23 24 321 5s646ms 1m3s 1m5s 1m13s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 21 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 21 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 1 1.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 16 16.00 0.00% 08 1 16 16.00 0.26% 09 0 12 12.00 0.00% 10 0 16 16.00 0.00% 11 0 15 15.00 0.00% 12 0 6 6.00 0.00% 13 0 7 7.00 0.00% 14 0 15 15.00 0.00% 15 0 12 12.00 0.00% 16 0 11 11.00 0.00% 17 0 7 7.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 2 2.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Sep 21 00 14 0.00/s 01 4 0.00/s 02 7 0.00/s 03 13 0.00/s 04 7 0.00/s 05 14 0.00/s 06 22 0.01/s 07 15 0.00/s 08 25 0.01/s 09 23 0.01/s 10 27 0.01/s 11 20 0.01/s 12 25 0.01/s 13 30 0.01/s 14 29 0.01/s 15 20 0.01/s 16 25 0.01/s 17 16 0.00/s 18 17 0.00/s 19 12 0.00/s 20 23 0.01/s 21 14 0.00/s 22 14 0.00/s 23 15 0.00/s Day Hour Count Average Duration Average idle time Sep 21 00 1 10m1s 8m20s 01 12 1h1m30s 1h1m29s 02 4 1h 59m57s 03 13 26m31s 26m31s 04 6 1h2m59s 1h2m57s 05 7 53m27s 49m57s 06 9 58m20s 58m13s 07 13 1h43s 58m13s 08 19 49m57s 47m57s 09 21 55m15s 53m9s 10 24 52m44s 51m2s 11 21 55m29s 52m23s 12 29 34m42s 34m5s 13 25 31m41s 31m3s 14 29 39m27s 38m15s 15 20 52m31s 50m30s 16 22 48m32s 47m12s 17 21 49m40s 48m23s 18 12 57m16s 56m26s 19 12 1h6m47s 1h5m58s 20 14 44m28s 43m3s 21 9 56m59s 55m54s 22 9 1h34s 59m27s 23 18 42m8s 40m20s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-21 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 431 connections Total
Connections per user
Key values
- intelifix Main User
- 431 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-21 19:07:33 Date
Histogram of session times
Key values
- 272 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 370 sessions Total
Sessions per user
Key values
- intelifix Main User
- 370 sessions Total
Sessions per host
Key values
- [local] Main Host
- 370 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,794 buffers Checkpoint Peak
- 2026-09-21 08:44:39 Date
- 270.056 seconds Highest write time
- 0.213 seconds Sync time
Checkpoints Wal files
Key values
- 14 files Wal files usage Peak
- 2026-09-21 08:44:39 Date
Checkpoints distance
Key values
- 418.51 Mo Distance Peak
- 2026-09-21 08:44:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 21 00 9,466 269.173s 0.039s 269.216s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 7,894 0.187s 0.076s 0.281s 04 0 0s 0s 0s 05 7,353 735.905s 0.108s 736.065s 06 3,265 327.046s 0.01s 327.063s 07 16,195 1,416.177s 0.189s 1,416.534s 08 62,340 3,219.786s 0.477s 3,220.347s 09 63,275 3,229.859s 0.871s 3,230.815s 10 58,784 3,238.803s 0.591s 3,239.547s 11 62,138 3,160.101s 0.514s 3,160.708s 12 16,139 1,751.128s 0.274s 1,751.464s 13 23,838 2,060.271s 0.327s 2,060.707s 14 48,663 3,230.236s 0.695s 3,231.011s 15 48,423 3,239.029s 0.501s 3,239.678s 16 45,794 3,147.663s 0.506s 3,148.433s 17 53,027 2,274.719s 0.554s 2,275.344s 18 2,048 208.324s 0.203s 208.553s 19 131 13.159s 0.145s 13.323s 20 1,781 180.174s 0.018s 180.216s 21 3,892 389.726s 0.08s 389.835s 22 4,745 475.274s 0.13s 475.433s 23 393 39.408s 0.083s 39.509s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 21 00 0 0 3 33 0.038s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 26 0.072s 0.005s 04 0 0 0 0 0s 0s 05 0 0 3 156 0.060s 0.013s 06 0 0 1 47 0.004s 0.002s 07 0 0 10 2,023 0.054s 0.011s 08 0 0 53 5,261 0.064s 0.012s 09 0 0 46 5,347 0.078s 0.012s 10 0 0 57 6,855 0.064s 0.012s 11 0 0 56 6,406 0.047s 0.012s 12 0 0 6 3,459 0.058s 0.012s 13 0 0 8 4,114 0.075s 0.012s 14 0 0 34 6,065 0.065s 0.012s 15 0 0 38 6,106 0.064s 0.012s 16 0 0 27 5,792 0.068s 0.012s 17 0 0 25 4,724 0.121s 0.011s 18 0 0 1 304 0.065s 0.017s 19 0 0 0 77 0.063s 0.016s 20 0 0 0 87 0.008s 0.003s 21 0 0 1 470 0.046s 0.007s 22 0 0 2 567 0.065s 0.008s 23 0 0 0 43 0.064s 0.013s Day Hour Count Avg time (sec) Sep 21 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 21 00 49,911.00 kB 49,911.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 22,871.50 kB 24,747.00 kB 04 0.00 kB 0.00 kB 05 6,106.50 kB 9,828.12 kB 06 5,176.00 kB 9,698.50 kB 07 14,922.27 kB 47,312.91 kB 08 72,108.58 kB 105,642.50 kB 09 63,475.92 kB 133,715.83 kB 10 78,180.00 kB 126,819.50 kB 11 76,316.42 kB 132,152.67 kB 12 7,866.00 kB 60,833.17 kB 13 11,607.42 kB 29,523.67 kB 14 45,774.83 kB 68,532.83 kB 15 52,123.00 kB 98,314.83 kB 16 36,117.42 kB 61,677.58 kB 17 37,931.00 kB 76,473.64 kB 18 1,215.88 kB 64,010.75 kB 19 145.00 kB 33,566.25 kB 20 3,497.00 kB 23,990.67 kB 21 2,605.71 kB 15,232.00 kB 22 3,460.14 kB 9,065.57 kB 23 291.60 kB 5,603.60 kB -
Temporary Files
Size of temporary files
Key values
- 531.03 MiB Temp Files size Peak
- 2026-09-21 11:51:28 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-21 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 21 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 67.12 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 3 660.87 MiB 220.29 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.77 MiB 246.58 MiB 64.72 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-21 05:32:05 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-21 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 306.78 MiB 57.02 MiB 93.83 MiB 76.69 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-21 05:30:43 Duration: 39s527ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-21 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 3 660.87 MiB 4.35 MiB 531.03 MiB 220.29 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,'''','''',DATE(''2026-09-17''),DATE(''2026-09-21'')) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF ().xlsx');
Date: 2026-09-21 11:51:36 Duration: 20m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030153, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-21 17:39:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030088, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-21 07:25:39 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 531.03 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,'''','''',DATE(''2026-09-17''),DATE(''2026-09-21'')) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF ().xlsx');[ Date: 2026-09-21 11:51:28 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 246.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 246.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 125.50 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,'''','''',DATE(''2026-09-17''),DATE(''2026-09-21'')) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF ().xlsx');[ Date: 2026-09-21 11:39:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 93.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-21 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 93.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-21 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 62.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-21 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 57.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-21 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 40.68 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.85 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-21 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.86 sec Highest CPU-cost vacuum
Table pg_catalog.pg_class
Database contagem - 2026-09-21 21:26:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 0.86 sec Highest CPU-cost vacuum
Table pg_catalog.pg_class
Database contagem - 2026-09-21 21:26:01 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (101) Main table analyzed (database rio)
- 784 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 101 rio.pg_catalog.pg_class 54 rio.public.usuarios 52 rio.public.temp0000291925 46 rio.pg_catalog.pg_type 45 brasilia.pg_catalog.pg_attribute 38 rio.pg_catalog.pg_index 30 rio.public.temp0000291941 29 rio.public.temp0000292016 26 rio.pg_catalog.pg_depend 22 rio.public.temp0000291755 21 contagem.public.usuarios 20 rio.public.temp0000291998 17 rio.public.temp0000291083 16 brasilia.pg_catalog.pg_class 16 contagem.pg_catalog.pg_attribute 14 brasilia.pg_catalog.pg_type 13 brasilia.public.temp0000240528 11 rio.public.temp0000291977 10 brasilia.public.usuarios 10 rio.public.temp0000290026 10 rio.public.temp0000292020 9 rio.public.temp0000291935 8 brasilia.public.temp0000240592 8 brasilia.pg_catalog.pg_index 8 contagem.pg_catalog.pg_class 7 rio.public.temp0000290230 7 rio.public.temp0000291943 6 contagem.pg_catalog.pg_type 5 brasilia.public.temp0000240562 5 brasilia.pg_catalog.pg_depend 5 rio.public.temp0000292030 5 rio.public.temp0000291947 5 contagem.public.temp0000227234 5 rio.public.temp0000291937 5 contagem.pg_catalog.pg_shdepend 5 contagem.pg_catalog.pg_index 4 rio.public.temp0000291955 4 brasilia.public.temp0000240612 4 brasilia.public.temp0000240598 4 contagem.public.temp0000227230 4 rio.public.tmp_drill_0320 3 rio.public.temp0000291945 3 rio.public.temp0000290921 3 rio.public.temp0000292036 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000291963 3 contagem.pg_catalog.pg_depend 3 rio.public.temp0000292032 3 brasilia.public.temp0000240546 2 contagem.public.temp0000227236 2 brasilia.public.temp0000240614 2 brasilia.public.temp0000240532 2 contagem.public.nf_entrada 2 brasilia.public.temp0000240530 2 brasilia.public.temp0000240626 2 rio.public.temp0000291949 2 brasilia.public.temp0000240584 2 brasilia.public.temp0000240536 2 brasilia.public.temp0000240552 1 rio.public.temp0000291931 1 rio.public.temp0000292024 1 contagem.public.temp0000227238 1 brasilia.public.temp0000240600 1 rio.public.temp0000292006 1 brasilia.public.temp0000240625 1 brasilia.public.temp0000240554 1 brasilia.public.temp0000240616 1 contagem.public.temp0000227242 1 contagem.public.temp0000227246 1 brasilia.public.temp0000240608 1 brasilia.public.temp0000240618 1 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000291939 1 rio.public.temp0000292038 1 rio.public.temp0000291951 1 contagem.public.temp0000227244 1 brasilia.public.temp0000240610 1 brasilia.public.temp0000240630 1 rio.public.temp0000291989 1 rio.public.temp0000291987 1 contagem.public.temp0000227228 1 brasilia.public.temp0000240540 1 rio.public.temp0000292012 1 rio.public.tmp_dias_291991 1 Total 784 Vacuums per table
Key values
- public.temp0000291925 (46) Main table vacuumed on database rio
- 392 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000291925 46 0 0 0 0 0 0 32,264 5,774 9,215,836 0 0 rio.pg_catalog.pg_attribute 39 36 0 0 0 0 0 18,091 5,317 7,634,420 300 7,669 rio.pg_catalog.pg_class 28 21 0 0 0 0 0 3,884 1,283 1,918,088 76 286 rio.public.temp0000292016 26 0 0 0 0 0 0 22,690 130 1,358,575 0 0 rio.public.temp0000291755 21 0 0 0 0 0 0 11,079 1,884 3,005,855 0 0 rio.pg_catalog.pg_type 20 18 0 0 0 0 0 1,799 588 799,614 59 255 rio.public.temp0000291941 19 0 0 0 0 0 0 13,013 76 780,668 0 0 contagem.public.usuarios 19 0 0 0 0 0 0 90 67 34,582 0 0 rio.pg_catalog.pg_index 13 12 0 0 0 0 0 700 208 209,486 25 56 rio.public.usuarios 11 6 0 0 0 0 0 210 77 171,499 20 47 brasilia.pg_catalog.pg_attribute 10 10 0 0 0 0 0 4,776 1,546 2,320,233 61 1,638 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 3,047 1,149 1,769,324 61 528 rio.public.temp0000291083 9 0 0 0 0 0 0 321 49 25,932 0 0 rio.public.temp0000290026 8 0 0 0 0 0 0 377 184 273,734 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,109 2,259 10,041,500 1,121 5,028 contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 3,725 887 1,614,945 16 372 rio.public.temp0000290230 5 0 0 0 0 0 0 195 28 15,558 0 0 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 802 273 461,616 35 101 brasilia.pg_catalog.pg_type 4 4 0 0 0 0 0 296 141 202,170 7 18 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,294 551 3,279,042 165 577 brasilia.public.temp0000240598 4 0 0 0 0 0 0 1,017 267 454,256 0 0 contagem.public.temp0000227234 4 0 0 0 0 0 0 460 132 214,998 0 0 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 658 282 442,079 22 66 brasilia.public.temp0000240562 4 0 0 0 0 0 0 1,017 769 1,235,428 0 0 contagem.pg_catalog.pg_class 3 3 0 0 0 0 0 633 96 163,358 0 0 rio.public.temp0000292032 3 0 0 0 0 0 0 1,978 16 119,119 0 0 rio.public.temp0000292036 3 0 0 0 0 0 0 5,444 1,823 2,666,287 0 0 rio.public.temp0000291963 3 0 0 0 0 0 0 1,819 10 109,000 0 0 rio.public.temp0000291945 3 0 0 0 0 0 0 113 67 94,015 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,144 1,434 5,389,517 1,210 7,807 rio.public.temp0000290921 3 0 0 0 0 0 0 5,437 1,820 2,661,362 0 0 rio.public.temp0000291977 3 0 0 0 0 0 0 107 17 8,717 0 0 rio.public.temp0000291998 3 0 0 0 0 0 0 179 67 95,309 0 0 brasilia.public.temp0000240536 2 0 0 0 0 0 0 509 8 31,264 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 347 106 506,577 42 107 rio.public.temp0000291949 2 0 0 0 0 0 0 137 12 9,846 0 0 brasilia.public.temp0000240584 2 0 0 0 0 0 0 509 8 31,236 0 0 rio.public.temp0000291937 2 0 0 0 0 0 0 16 10 2,532 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 75 31 18,199 5 11 contagem.pg_catalog.pg_type 2 2 0 0 0 0 0 246 32 71,694 1 4 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 111 21 30,341 0 0 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 68 6 15,951 0 0 contagem.pg_catalog.pg_depend 1 1 0 0 0 0 0 444 131 260,720 2 18 rio.public.temp0000291987 1 0 0 0 0 0 0 8 5 1,290 0 0 rio.public.temp0000291989 1 0 0 0 0 0 0 79 6 5,560 0 0 contagem.public.temp0000227230 1 0 0 0 0 0 0 116 6 7,815 0 0 brasilia.public.temp0000240630 1 0 0 0 0 0 0 254 4 15,589 0 0 rio.public.tmp_dias_291991 1 0 0 0 0 0 0 75 6 5,307 0 0 rio.public.temp0000292012 1 0 0 0 0 0 0 79 6 5,561 0 0 rio.public.temp0000291943 1 0 0 0 0 0 0 8 5 1,266 0 0 brasilia.public.temp0000240618 1 0 0 0 0 0 0 255 4 15,659 0 0 rio.public.temp0000291951 1 0 0 0 0 0 0 74 6 5,256 0 0 rio.public.temp0000292038 1 0 0 0 0 0 0 86 84 140,949 0 0 rio.public.temp0000291939 1 0 0 0 0 0 0 8 5 1,266 0 0 rio.public.temp0000292030 1 0 0 0 0 0 0 81 6 5,667 0 0 rio.public.temp0000291955 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.temp0000291947 1 0 0 0 0 0 0 8 5 1,265 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 119 10 48,291 3 9 brasilia.public.temp0000240532 1 0 0 0 0 0 0 254 4 15,589 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 226 101 145,775 1 8 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,132 7 162,772 4 39 rio.public.temp0000292024 1 0 0 0 0 0 0 78 6 5,485 0 0 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 322 138 154,640 11 84 rio.public.temp0000292006 1 0 0 0 0 0 0 79 6 5,560 0 0 Total 392 163 0 0 0 0 0 158,636 30,060 60,519,482 3,247 24,728 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (2.85) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000291925 0 0 1.13 rio.pg_catalog.pg_attribute 0 0 2.85 rio.pg_catalog.pg_class 0 0 0.85 rio.public.temp0000292016 0 0 0.59 rio.public.temp0000291755 0 0 0.76 rio.pg_catalog.pg_type 0 0 0.33 rio.public.temp0000291941 0 0 0.43 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_index 0 0 0.34 rio.public.usuarios 0 0 0.06 brasilia.pg_catalog.pg_attribute 0 0 1.85 rio.pg_catalog.pg_depend 0 0 0.86 rio.public.temp0000291083 0 0 0 rio.public.temp0000290026 0 0 0.01 rio.pg_catalog.pg_statistic 0 0 1.58 contagem.pg_catalog.pg_attribute 0 0 1.12 rio.public.temp0000290230 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.59 brasilia.pg_catalog.pg_type 0 0 0.79 rio.pg_toast.pg_toast_2619 0 0 0.42 brasilia.public.temp0000240598 0 0 0 contagem.public.temp0000227234 0 0 0.02 brasilia.pg_catalog.pg_class 0 0 0.83 brasilia.public.temp0000240562 0 0 0.06 contagem.pg_catalog.pg_class 0 0 1.57 rio.public.temp0000292032 0 0 0.05 rio.public.temp0000292036 0 0 0.17 rio.public.temp0000291963 0 0 0.13 rio.public.temp0000291945 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.45 rio.public.temp0000290921 0 0 0.16 rio.public.temp0000291977 0 0 0 rio.public.temp0000291998 0 0 0.01 brasilia.public.temp0000240536 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.08 rio.public.temp0000291949 0 0 0 brasilia.public.temp0000240584 0 0 0 rio.public.temp0000291937 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.25 contagem.pg_catalog.pg_type 0 0 0.32 contagem.pg_catalog.pg_index 0 0 0.21 rio.public.tmp_drill_0320 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.28 rio.public.temp0000291987 0 0 0 rio.public.temp0000291989 0 0 0 contagem.public.temp0000227230 0 0 0 brasilia.public.temp0000240630 0 0 0 rio.public.tmp_dias_291991 0 0 0.01 rio.public.temp0000292012 0 0 0 rio.public.temp0000291943 0 0 0 brasilia.public.temp0000240618 0 0 0 rio.public.temp0000291951 0 0 0 rio.public.temp0000292038 0 0 0.01 rio.public.temp0000291939 0 0 0 rio.public.temp0000292030 0 0 0 rio.public.temp0000291955 0 0 0 rio.public.temp0000291947 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000240532 0 0 0 contagem.public.nf_entrada 0 0 0.11 contagem.pg_catalog.pg_statistic 0 0 0.04 rio.public.temp0000292024 0 0 0.01 brasilia.pg_catalog.pg_depend 0 0 0.55 rio.public.temp0000292006 0 0 0 Total 0 0 19.88 Tuples removed per table
Key values
- pg_catalog.pg_attribute (121029) Main table with removed tuples on database rio
- 234857 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 39 36 121,029 970,531 55,490 193 22,863 brasilia.pg_catalog.pg_attribute 10 10 35,290 214,752 198 0 5,650 contagem.pg_catalog.pg_attribute 6 6 26,016 143,078 0 126 3,318 rio.pg_catalog.pg_statistic 7 7 12,422 56,400 317 0 9,002 rio.pg_catalog.pg_depend 9 9 7,027 172,516 2,580 0 1,683 rio.pg_catalog.pg_type 20 18 6,070 48,634 3,348 5 1,440 brasilia.pg_catalog.pg_statistic 3 3 5,679 23,956 0 0 3,216 contagem.pg_catalog.pg_statistic 1 1 4,255 7,274 0 0 1,011 brasilia.pg_catalog.pg_shdepend 5 5 4,197 68,393 465 0 625 rio.pg_catalog.pg_class 28 21 2,512 112,380 14,148 74 3,417 rio.pg_catalog.pg_index 13 12 2,081 25,793 952 0 741 contagem.pg_catalog.pg_type 2 2 1,348 4,500 0 0 141 contagem.public.usuarios 19 0 1,235 456 0 0 38 rio.pg_toast.pg_toast_2619 4 4 1,151 3,059 13 0 1,040 brasilia.pg_catalog.pg_depend 1 1 903 17,704 0 16 168 brasilia.pg_catalog.pg_class 4 4 815 13,552 8 0 520 contagem.pg_catalog.pg_index 2 2 688 3,795 0 6 100 rio.public.usuarios 11 6 578 6,752 1,153 0 209 brasilia.pg_catalog.pg_type 4 4 395 8,812 6 0 228 rio.public.tmp_drill_0320 2 2 360 712 0 0 20 contagem.pg_catalog.pg_class 3 3 282 11,916 0 99 380 brasilia.pg_toast.pg_toast_2619 2 2 175 291 0 0 122 brasilia.pg_catalog.pg_index 2 2 131 3,782 6 5 94 contagem.pg_catalog.pg_depend 1 1 122 19,203 0 0 189 contagem.pg_toast.pg_toast_2619 1 1 95 114 0 0 52 contagem.public.nf_entrada 1 1 1 1,104 0 0 87 brasilia.public.temp0000240536 2 0 0 6,668 0 0 512 rio.public.temp0000291755 21 0 0 465,305 0 118 33,610 rio.public.temp0000291987 1 0 0 1,235 0 57 71 rio.public.temp0000291989 1 0 0 1,235 0 57 71 contagem.public.temp0000227230 1 0 0 1,384 0 20 108 rio.public.temp0000292016 26 0 0 325,512 0 760 23,304 brasilia.public.temp0000240630 1 0 0 3,334 0 0 256 rio.public.temp0000290230 5 0 0 10,645 0 116 236 rio.public.temp0000292032 3 0 0 28,176 0 108 2,004 rio.public.tmp_dias_291991 1 0 0 3,346 0 61 67 rio.public.temp0000292012 1 0 0 1,235 0 57 71 rio.public.temp0000292036 3 0 0 77,049 0 0 5,568 rio.public.temp0000291943 1 0 0 1,015 0 4 60 brasilia.public.temp0000240618 1 0 0 3,334 0 0 256 rio.public.temp0000291941 19 0 0 266,333 0 128 19,104 rio.public.temp0000291951 1 0 0 1,156 0 62 66 rio.public.temp0000291963 3 0 0 76,908 0 0 5,568 rio.public.temp0000292038 1 0 0 3,496 0 50 78 rio.public.temp0000291939 1 0 0 1,015 0 4 60 rio.public.temp0000290026 8 0 0 23,192 0 250 518 rio.public.temp0000292030 1 0 0 3,264 0 55 73 rio.public.temp0000291955 1 0 0 1,050 0 0 64 rio.public.temp0000291949 2 0 0 2,030 0 8 120 brasilia.public.temp0000240598 4 0 0 13,336 0 0 1,024 brasilia.public.temp0000240584 2 0 0 6,668 0 0 512 rio.public.temp0000291937 2 0 0 2,030 0 8 120 rio.public.temp0000291947 1 0 0 1,015 0 4 60 contagem.public.temp0000227234 4 0 0 5,531 0 84 428 rio.public.temp0000291945 3 0 0 5,757 0 65 127 rio.public.temp0000291925 46 0 0 616,529 0 1,032 44,216 brasilia.public.temp0000240532 1 0 0 3,334 0 0 256 rio.public.temp0000290921 3 0 0 76,968 0 0 5,568 rio.public.temp0000292024 1 0 0 3,142 0 58 70 brasilia.public.temp0000240562 4 0 0 13,336 0 0 1,024 rio.public.temp0000291977 3 0 0 5,490 0 71 121 rio.public.temp0000292006 1 0 0 1,235 0 57 71 rio.public.temp0000291998 3 0 0 6,931 0 37 155 rio.public.temp0000291083 9 0 0 17,259 0 129 383 Total 392 163 234,857 4,025,937 78,684 3,984 202,334 Pages removed per table
Key values
- public.temp0000291925 (1032) Main table with removed pages on database rio
- 3984 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291925 46 0 0 1032 rio.public.temp0000292016 26 0 0 760 rio.public.temp0000290026 8 0 0 250 rio.pg_catalog.pg_attribute 39 36 121029 193 rio.public.temp0000291083 9 0 0 129 rio.public.temp0000291941 19 0 0 128 contagem.pg_catalog.pg_attribute 6 6 26016 126 rio.public.temp0000291755 21 0 0 118 rio.public.temp0000290230 5 0 0 116 rio.public.temp0000292032 3 0 0 108 contagem.pg_catalog.pg_class 3 3 282 99 contagem.public.temp0000227234 4 0 0 84 rio.pg_catalog.pg_class 28 21 2512 74 rio.public.temp0000291977 3 0 0 71 rio.public.temp0000291945 3 0 0 65 rio.public.temp0000291951 1 0 0 62 rio.public.tmp_dias_291991 1 0 0 61 rio.public.temp0000292024 1 0 0 58 rio.public.temp0000291987 1 0 0 57 rio.public.temp0000291989 1 0 0 57 rio.public.temp0000292012 1 0 0 57 rio.public.temp0000292006 1 0 0 57 rio.public.temp0000292030 1 0 0 55 rio.public.temp0000292038 1 0 0 50 rio.public.temp0000291998 3 0 0 37 contagem.public.temp0000227230 1 0 0 20 brasilia.pg_catalog.pg_depend 1 1 903 16 rio.public.temp0000291949 2 0 0 8 rio.public.temp0000291937 2 0 0 8 contagem.pg_catalog.pg_index 2 2 688 6 brasilia.pg_catalog.pg_index 2 2 131 5 rio.pg_catalog.pg_type 20 18 6070 5 rio.public.temp0000291943 1 0 0 4 rio.public.temp0000291939 1 0 0 4 rio.public.temp0000291947 1 0 0 4 brasilia.public.temp0000240536 2 0 0 0 contagem.pg_catalog.pg_depend 1 1 122 0 rio.pg_catalog.pg_statistic 7 7 12422 0 brasilia.public.temp0000240630 1 0 0 0 brasilia.pg_catalog.pg_shdepend 5 5 4197 0 rio.public.temp0000292036 3 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 175 0 brasilia.public.temp0000240618 1 0 0 0 brasilia.pg_catalog.pg_type 4 4 395 0 rio.public.temp0000291963 3 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1151 0 brasilia.pg_catalog.pg_attribute 10 10 35290 0 rio.public.temp0000291955 1 0 0 0 brasilia.public.temp0000240598 4 0 0 0 brasilia.public.temp0000240584 2 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 95 0 brasilia.public.temp0000240532 1 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 5679 0 brasilia.pg_catalog.pg_class 4 4 815 0 rio.public.usuarios 11 6 578 0 contagem.public.nf_entrada 1 1 1 0 rio.public.temp0000290921 3 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4255 0 contagem.public.usuarios 19 0 1235 0 rio.pg_catalog.pg_depend 9 9 7027 0 contagem.pg_catalog.pg_type 2 2 1348 0 brasilia.public.temp0000240562 4 0 0 0 rio.public.tmp_drill_0320 2 2 360 0 rio.pg_catalog.pg_index 13 12 2081 0 Total 392 163 234,857 3,984 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 21 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 11 21 08 53 94 09 52 93 10 63 124 11 48 84 12 9 21 13 19 50 14 31 71 15 40 89 16 30 70 17 26 61 18 1 1 19 0 0 20 0 0 21 2 3 22 1 2 23 0 0 - 0.86 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 3m21s 1m30s 1m51s 1m40s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 09:56:59 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 11:16:46 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 00:05:25 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s 1s 1s 1s drop table if exists temp0000291755;-
DROP TABLE IF EXISTS temp0000291755;
Date: 2026-09-21 11:13:31 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291755;
Date: 2026-09-21 11:13:31 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m51s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-21 09:56:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m30s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-21 11:16:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s DROP TABLE IF EXISTS temp0000291755;[ Date: 2026-09-21 11:13:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,309 Total read queries
- 1,074 Total write queries
Queries by database
Key values
- rio Main database
- 3,130 Requests
- 6h33m43s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,627 Requests
User Request type Count Duration etiquetas Total 57 21s845ms select 57 21s845ms intelifix Total 4,627 8h23m37s copy to 405 41m30s ddl 669 45m55s others 396 47m8s select 3,157 6h9m4s lenon Total 95 1m19s select 95 1m19s Duration by user
Key values
- 8h23m37s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 57 21s845ms select 57 21s845ms intelifix Total 4,627 8h23m37s copy to 405 41m30s ddl 669 45m55s others 396 47m8s select 3,157 6h9m4s lenon Total 95 1m19s select 95 1m19s Queries by host
Key values
- [local] Main host
- 4,779 Requests
- 8h25m19s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,758 Requests
- 3h59m20s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-21 16:52:04 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,053 100-500ms duration
Slowest individual queries
Rank Duration Query 1 20m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,'''','''',DATE(''2026-09-17''),DATE(''2026-09-21'')) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF ().xlsx');[ Date: 2026-09-21 11:51:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 11m42s analyze verbose;[ Date: 2026-09-21 05:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-21 07:15:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 7m38s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030153, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');[ Date: 2026-09-21 17:39:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 7m32s analyze verbose;[ Date: 2026-09-21 05:19:16 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
6 6m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030088, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 07:25:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 6m22s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,''5418'','''',NULL,NULL) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF (5418).xlsx');[ Date: 2026-09-21 11:41:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 6m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030110, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 09:17:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-21 12:11:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030148, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 15:19:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030136, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 11:16:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030140, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 14:26:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m51s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030151, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 16:04:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030152, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 16:46:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030150, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 15:41:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030146, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 15:02:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030142, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 14:44:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-21 14:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030112, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-21 09:36:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-21 17:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h21m12s 189 153ms 20m41s 44s827ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 21 07 5 7m39s 1m31s 08 22 15m25s 42s52ms 09 16 17m34s 1m5s 10 38 13m27s 21s253ms 11 21 34m7s 1m37s 12 9 5s486ms 609ms 13 15 46s205ms 3s80ms 14 10 11m48s 1m10s 15 18 17m53s 59s635ms 16 14 12m14s 52s492ms 17 20 10m7s 30s362ms 18 1 1s69ms 1s69ms [ User: intelifix - Total duration: 2h21m12s - Times executed: 189 ]
[ Application: [unknown] - Total duration: 2h21m12s - Times executed: 189 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,'''','''',DATE(''2026-09-17''),DATE(''2026-09-21'')) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF ().xlsx');
Date: 2026-09-21 11:51:36 Duration: 20m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030153, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-21 17:39:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030088, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-21 07:25:39 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h38m33s 48 1s457ms 10m38s 2m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 21 07 3 11m42s 3m54s 08 3 5m19s 1m46s 09 3 6m31s 2m10s 10 3 5m33s 1m51s 11 3 5m51s 1m57s 12 3 6m51s 2m17s 13 3 5m29s 1m49s 14 3 5m58s 1m59s 15 3 5m58s 1m59s 16 3 5m33s 1m51s 17 3 5m58s 1m59s 18 3 5m36s 1m52s 19 3 5m34s 1m51s 20 3 5m52s 1m57s 21 3 5m19s 1m46s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h38m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 07:15:40 Duration: 10m38s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 12:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 14:10:42 Duration: 5m40s Database: rio User: intelifix Remote: [local] Application: psql
3 1h7m42s 48 254ms 4m5s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 21 07 3 5m51s 1m57s 08 3 3m52s 1m17s 09 3 5m7s 1m42s 10 3 3m52s 1m17s 11 3 4m 1m20s 12 3 4m48s 1m36s 13 3 3m49s 1m16s 14 3 4m12s 1m24s 15 3 4m12s 1m24s 16 3 4m2s 1m20s 17 3 4m9s 1m23s 18 3 3m59s 1m19s 19 3 3m58s 1m19s 20 3 4m12s 1m24s 21 3 3m44s 1m14s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h7m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 12:16:36 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 07:22:20 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 09:16:27 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
4 22m18s 3 3m2s 11m42s 7m26s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 21 05 3 22m18s 7m26s [ User: intelifix - Total duration: 22m18s - Times executed: 3 ]
[ Application: psql - Total duration: 22m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-21 05:11:44 Duration: 11m42s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-21 05:19:16 Duration: 7m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-21 05:22:19 Duration: 3m2s Database: contagem User: intelifix Remote: [local] Application: psql
5 16m49s 1,119 150ms 5s175ms 902ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 21 07 5 1s391ms 278ms 08 56 55s590ms 992ms 09 121 1m38s 814ms 10 168 1m48s 648ms 11 158 2m41s 1s19ms 12 58 40s604ms 700ms 13 75 1m2s 832ms 14 189 2m56s 932ms 15 142 2m31s 1s69ms 16 89 1m43s 1s161ms 17 58 49s195ms 848ms [ User: intelifix - Total duration: 16m49s - Times executed: 1119 ]
[ Application: [unknown] - Total duration: 16m49s - Times executed: 1119 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58536, 406, '835197929003801,241695423853,241606047778,241608693245,241627966270,241620728606,241660130914,241620705270,241731026373,241695517273,241672183044,241715487797,241673349813,241727510509,241661329504,241649691736,241599315876,241622641419,241664737984,241698720808,241659655255,241727066166,241680303455,241632295862,241695119300,241711210714,241680403543,241622461424,241663000117,241700944459,241692691432,241728719100,241660109395,241607249197,241647382341,241692617787,241728646163,241594968808,241727047881,241646144453,241614473248,241680411827,241654353941,241614464964,241598837692,241704293035,241711161113,241659766175,241599243546,241617451530,241670533545', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-21 17:06:14 Duration: 5s175ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58501, 407, '270911029146103297,229744538692,229750288389,229685674755,229726668396,216944946787,229690654343,229661552738,229740497490,229781735353,229670119511,229752865970,229808618606,229808869214,229812674658,229753956873,229812923246,229815330204,229812155056,229690806984,229689928201,216944640215,229815289414,216938486684,229925601426,229933339598,229754685463,229932311228,229781782227,229808474450,229816200727,229672209715,229783412532,229859541522,229660481332,229808886970,216943172933,229814836687,229932955465,229684437597,216931760619,229662906068,229736465761,229780474254,229783964460', '246538841111,246530239407,246490844451,246506931319,246492077085,246516180011,246487120609,246536008095,246596070423,246515445460,246531783845,246611919612,246611881427,246612015861,246230206769,246630002937,246636079310,246627811837,246514137386,246516658800,246456980507,246631726988,246463332844,246103940407,246050544567,246571063739,246127746175,246597887793,246613128002,246631409000,246495094058,246586214567,246648813639,246487186170,246612923133,246471604055,246637820715,226136883958,246516516384,246436090208,246487279614,246535426265,246585838693,246585226378,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-21 15:03:54 Duration: 4s556ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289272, 450, 'CP2308332QL,10A793426EF3$CP2305334WN,10A7932DB8EB$CP230733MFS,10A793401BD3$CP2304337YG,48BDCE672C6B$CP23043353H,48BDCE6675FB$CP23103379J,CCF3C853DF7B$CP230733KR4,10A7933F6C23$CP230733EFA,10A7933D4F93$CP2303332GP,48BDCE6E4ABB$CP2312336TM,CCF3C85AD6FB$CP2315332HP,CCF3C87EF933$CP230233AF9,48BDCE6C408B$CP2247338N8,F8D2ACEAE223$CP230233173,F8D2ACFBEA2B$CP2315337AL,CCF3C880E24B$CP230533129,48BDCE68175B$CP2311330UW,CCF3C854FD53$CP2250333P8,F8D2ACF6223B$CP230233CZC,48BDCE6D410B$CP2312333VM,CCF3C859A7CB$CP230633QQ8,10A79337683B$CP2304331TU,48BDCE734E2B$CP230733KUC,10A7933F75E3$CP2249333JC,F8D2ACF0C7B3$CP2248334V0,F8D2ACED4A43$CP2308330W4,10A79341B41B$CP2304331W9,48BDCE7353B3$CP23133332S,CCF3C85CBC83$CP2303332RG,48BDCE6E65BB$CP230733L86,10A7933F9E33$CP231133504,CCF3C856A213$CP2311330M8,CCF3C854E703$CP230333CEQ,48BDCE7241AB$CP2248339TF,F8D2ACEFD963$CP2247335UY,F8D2AC596C83$CP230633BCG,10A7933215F3$CP22453325M,F8D2AC56ED53$CP23123367M,CCF3C85A997B$CP2309332CL,B85E71AFB2AB$CP2306333K1,10A7932EF86B', '',0312,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-21 14:04:13 Duration: 4s102ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 16m47s 96 984ms 1m49s 10s492ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 21 07 4 30s24ms 7s506ms 08 3 18s275ms 6s91ms 09 4 35s423ms 8s855ms 10 5 14s819ms 2s963ms 11 14 6m24s 27s487ms 12 3 18s898ms 6s299ms 13 17 1m56s 6s855ms 14 7 1m9s 9s955ms 15 14 2m17s 9s802ms 16 9 1m27s 9s733ms 17 16 1m33s 5s868ms [ User: intelifix - Total duration: 16m47s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 16m47s - Times executed: 96 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:29:05 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:44:53 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:29:05 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 12m33s 65 9s968ms 1m10s 11s588ms create table temp0000291925 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 21 07 8 2m24s 18s83ms 08 3 30s351ms 10s117ms 09 15 2m46s 11s89ms 10 27 4m42s 10s460ms 11 12 2m9s 10s785ms [ User: intelifix - Total duration: 12m33s - Times executed: 65 ]
[ Application: [unknown] - Total duration: 12m33s - Times executed: 65 ]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 07:17:07 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 09:28:41 Duration: 20s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 11:08:05 Duration: 11s169ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m28s 151 153ms 1m54s 3s765ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 21 00 7 33s57ms 4s722ms 01 6 10s647ms 1s774ms 02 6 9s581ms 1s596ms 03 5 8s170ms 1s634ms 04 6 9s492ms 1s582ms 05 7 10s84ms 1s440ms 06 6 9s173ms 1s528ms 07 7 12s691ms 1s813ms 08 7 15s409ms 2s201ms 09 8 2m8s 16s52ms 10 7 22s39ms 3s148ms 11 9 1m53s 12s617ms 12 6 14s345ms 2s390ms 13 6 13s735ms 2s289ms 14 6 15s398ms 2s566ms 15 7 16s950ms 2s421ms 16 6 18s203ms 3s33ms 17 7 18s421ms 2s631ms 18 6 17s735ms 2s955ms 19 6 17s404ms 2s900ms 20 8 22s933ms 2s866ms 21 6 15s572ms 2s595ms 22 6 15s494ms 2s582ms [ User: intelifix - Total duration: 9m28s - Times executed: 151 ]
[ Application: psql - Total duration: 9m28s - Times executed: 151 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 09:56:59 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 11:16:46 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 00:05:25 Duration: 21s881ms Database: rio User: intelifix Remote: [local] Application: psql
9 8m50s 133 176ms 14s680ms 3s990ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 21 00 1 1s480ms 1s480ms 05 1 241ms 241ms 06 1 6s642ms 6s642ms 07 11 58s731ms 5s339ms 08 12 58s810ms 4s900ms 09 13 57s483ms 4s421ms 10 12 55s270ms 4s605ms 11 12 1m6s 5s578ms 12 12 37s474ms 3s122ms 13 6 10s636ms 1s772ms 14 11 38s522ms 3s502ms 15 12 50s377ms 4s198ms 16 11 36s859ms 3s350ms 17 5 3s511ms 702ms 19 1 270ms 270ms 20 1 602ms 602ms 21 5 22s408ms 4s481ms 22 6 24s506ms 4s84ms [ User: intelifix - Total duration: 8m50s - Times executed: 133 ]
[ Application: psql - Total duration: 8m50s - Times executed: 133 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 07:25:16 Duration: 14s680ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 07:45:14 Duration: 13s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 11:45:12 Duration: 11s801ms Database: rio User: intelifix Remote: [local] Application: psql
10 8m30s 755 150ms 3s265ms 675ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 21 07 2 4s412ms 2s206ms 08 100 1m5s 659ms 09 102 1m8s 676ms 10 105 1m12s 686ms 11 95 1m6s 702ms 12 20 9s189ms 459ms 13 34 30s536ms 898ms 14 100 55s782ms 557ms 15 66 50s474ms 764ms 16 88 1m4s 727ms 17 43 21s813ms 507ms [ User: intelifix - Total duration: 8m30s - Times executed: 755 ]
[ Application: [unknown] - Total duration: 8m30s - Times executed: 755 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289027", "modelo" : "320", "itens" : "241594972243,241607638810,241703549113,241649135463,241667097182,241703639705,241698542227,241620291515,241656356381,241637473147,241593912330,241618215779,241615239090,241696800722,241653339813,241694996078,241673009094,241700769616,241673061222,241592888403,241674493247,241732912843,241601540617,241668218189,241726967189,241656796581,241619507992,241610909903,241610937986,241710360418,241654504259,241595694041,241638222345,241645566888,241594199810,230043648805,241674285067,241637432133,241617531212,241609975154,241657002337,241597837280,241653415353,241617952847,241660436577,241672193045,241726992546,241647919395", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-21 13:50:06 Duration: 3s265ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289320", "modelo" : "463", "itens" : "241752375157,241790275253,241794484250,241736405877,241750394863,241737072138,241722417474,241734574060,241734623638,241735039616,241751873840,241735317779,241752400716,241736450203,241754164647,241748221823,241751053749,241752421728,241724060004,241735510931,241789636672,241758059719,241719180830,241751860506,241781655467,241722973848,241720900212,241736627997,241751040718,241755656072,241737420107,241751188991,241704926385,241757311734,241758042041,241736489195,241735104448,241706239611,241721583645,241794521931,241782108698,241735520303,241735608795,241751161313,241725863333,241750027475,241718797682,241781863142,241751734253,241758247997,241723750827,241735039818,241781431933,241737079815,241782494045,241758906681,241751117088,241758958404,241722187474,241736452425", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-21 16:30:04 Duration: 3s166ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289306", "modelo" : "463", "itens" : "241789665362,241719247479,241725699905,241722439294,241758106468,241753495659,241751701826,241721537781,241735424861,241722043847,241756928586,241724389811,241758904560,241718974445,241789453647,241704955153,241724057073,241783279509,241722992436,241754110423,241757719304,241750514953,241782320415,241753514752,241751464350,241748414647,241784584350,241751953949,241734594668,241754211016,241719035966,241757701525,241794315872,241748512132,241750534652,241753710507,241751868182,241750482425,241721757780,241737130404,241722896769,241758603240,241735382433,241758315961,241724984448,241781731435,241751086984,241723020722,241780494658,241756867896,241725590221,241787760003,241784564045,241722573753,241736018790,241725675256,241758304243,241751230916,241723004962,241789661322", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-21 15:40:12 Duration: 3s101ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7m44s 35 10s234ms 1m9s 13s259ms create table temp0000292016 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 21 14 18 4m18s 14s358ms 15 15 2m59s 11s936ms 16 2 26s605ms 13s302ms [ User: intelifix - Total duration: 7m44s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m44s - Times executed: 35 ]
-
CREATE TABLE temp0000292016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 14:19:46 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 15:10:54 Duration: 20s917ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 16:39:56 Duration: 14s499ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 6m3s 31 9s891ms 53s963ms 11s724ms create table temp0000291941 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 21 08 20 3m24s 10s203ms 10 11 2m39s 14s491ms [ User: intelifix - Total duration: 6m3s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m3s - Times executed: 31 ]
-
CREATE TABLE temp0000291941 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 10:12:24 Duration: 53s963ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291941 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 10:14:19 Duration: 10s796ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291941 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 10:08:27 Duration: 10s766ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5m47s 39 222ms 47s618ms 8s921ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 21 07 2 51s629ms 25s814ms 08 7 54s194ms 7s742ms 09 5 1m17s 15s475ms 10 11 1m25s 7s729ms 11 5 45s874ms 9s174ms 13 1 3s104ms 3s104ms 14 4 17s636ms 4s409ms 15 3 12s874ms 4s291ms 17 1 222ms 222ms [ User: intelifix - Total duration: 5m47s - Times executed: 39 ]
[ Application: psql - Total duration: 5m47s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030088);
Date: 2026-09-21 07:19:13 Duration: 47s618ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030110);
Date: 2026-09-21 09:11:02 Duration: 31s898ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030118);
Date: 2026-09-21 10:09:06 Duration: 29s235ms Database: rio User: intelifix Remote: [local] Application: psql
14 3m50s 43 162ms 54s51ms 5s352ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 21 07 3 1s267ms 422ms 08 5 43s460ms 8s692ms 09 6 1m22s 13s676ms 10 10 21s510ms 2s151ms 11 7 48s285ms 6s897ms 14 5 1s202ms 240ms 15 5 1s615ms 323ms 16 1 200ms 200ms 17 1 30s543ms 30s543ms [ User: intelifix - Total duration: 3m50s - Times executed: 43 ]
[ Application: psql - Total duration: 3m50s - Times executed: 43 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030107);
Date: 2026-09-21 09:01:09 Duration: 54s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030133);
Date: 2026-09-21 11:05:21 Duration: 45s155ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030153);
Date: 2026-09-21 17:31:19 Duration: 30s543ms Database: rio User: intelifix Remote: [local] Application: psql
15 3m21s 19 10s162ms 11s671ms 10s627ms create table temp0000291755 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 21 08 5 53s467ms 10s693ms 09 3 30s938ms 10s312ms 10 4 42s839ms 10s709ms 11 6 1m3s 10s501ms 15 1 11s671ms 11s671ms [ User: intelifix - Total duration: 3m21s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m21s - Times executed: 19 ]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 15:29:03 Duration: 11s671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 08:08:22 Duration: 11s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 11:13:03 Duration: 10s838ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m16s 41 1s955ms 47s360ms 4s803ms create table temp0000291925 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 21 07 9 1m3s 7s60ms 08 2 4s303ms 2s151ms 09 10 56s782ms 5s678ms 10 12 29s957ms 2s496ms 11 8 42s361ms 5s295ms [ User: intelifix - Total duration: 3m16s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m16s - Times executed: 41 ]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-09-2026", "ate" :"21-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-21 07:31:47 Duration: 47s360ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-09-2026", "ate" :"21-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-21 09:17:54 Duration: 35s505ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-09-2026", "ate" :"21-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-21 11:20:22 Duration: 23s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 3m8s 14 788ms 1m34s 13s442ms select * from rs_resumo_lote_entrada (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 21 12 5 2m16s 27s299ms 13 1 21s869ms 21s869ms 14 3 24s176ms 8s58ms 15 5 5s647ms 1s129ms [ User: intelifix - Total duration: 3m8s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 14 ]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-09-01', '2026-09-21', 00, 00);
Date: 2026-09-21 12:20:26 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-09-01', '2026-09-21', 00, 00);
Date: 2026-09-21 14:57:04 Duration: 21s941ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-09-01', '2026-09-21', 00, 00);
Date: 2026-09-21 13:55:29 Duration: 21s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m18s 4 4s863ms 1m5s 34s604ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 21 20 2 1m10s 35s165ms 23 2 1m8s 34s43ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-21 20:08:44 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-21 23:16:35 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-21 20:10:47 Duration: 5s289ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 2m 33 613ms 12s942ms 3s658ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 21 08 1 4s749ms 4s749ms 09 3 13s272ms 4s424ms 10 3 16s994ms 5s664ms 11 1 7s601ms 7s601ms 12 3 4s516ms 1s505ms 13 3 9s61ms 3s20ms 14 3 11s890ms 3s963ms 15 3 14s850ms 4s950ms 16 3 11s8ms 3s669ms 17 2 19s889ms 9s944ms 18 1 741ms 741ms 19 2 1s541ms 770ms 20 2 2s26ms 1s13ms 21 2 1s868ms 934ms 22 1 711ms 711ms [ User: intelifix - Total duration: 2m - Times executed: 33 ]
[ Application: psql - Total duration: 2m - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-21 17:20:14 Duration: 12s942ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-21 11:40:09 Duration: 7s601ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-21 10:00:08 Duration: 6s977ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m46s 4 331ms 53s817ms 26s680ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 21 20 2 54s185ms 27s92ms 23 2 52s538ms 26s269ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-21 20:05:46 Duration: 53s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-21 23:13:41 Duration: 52s206ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-21 20:10:10 Duration: 367ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,119 16m49s 150ms 5s175ms 902ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 21 07 5 1s391ms 278ms 08 56 55s590ms 992ms 09 121 1m38s 814ms 10 168 1m48s 648ms 11 158 2m41s 1s19ms 12 58 40s604ms 700ms 13 75 1m2s 832ms 14 189 2m56s 932ms 15 142 2m31s 1s69ms 16 89 1m43s 1s161ms 17 58 49s195ms 848ms [ User: intelifix - Total duration: 16m49s - Times executed: 1119 ]
[ Application: [unknown] - Total duration: 16m49s - Times executed: 1119 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58536, 406, '835197929003801,241695423853,241606047778,241608693245,241627966270,241620728606,241660130914,241620705270,241731026373,241695517273,241672183044,241715487797,241673349813,241727510509,241661329504,241649691736,241599315876,241622641419,241664737984,241698720808,241659655255,241727066166,241680303455,241632295862,241695119300,241711210714,241680403543,241622461424,241663000117,241700944459,241692691432,241728719100,241660109395,241607249197,241647382341,241692617787,241728646163,241594968808,241727047881,241646144453,241614473248,241680411827,241654353941,241614464964,241598837692,241704293035,241711161113,241659766175,241599243546,241617451530,241670533545', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-21 17:06:14 Duration: 5s175ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58501, 407, '270911029146103297,229744538692,229750288389,229685674755,229726668396,216944946787,229690654343,229661552738,229740497490,229781735353,229670119511,229752865970,229808618606,229808869214,229812674658,229753956873,229812923246,229815330204,229812155056,229690806984,229689928201,216944640215,229815289414,216938486684,229925601426,229933339598,229754685463,229932311228,229781782227,229808474450,229816200727,229672209715,229783412532,229859541522,229660481332,229808886970,216943172933,229814836687,229932955465,229684437597,216931760619,229662906068,229736465761,229780474254,229783964460', '246538841111,246530239407,246490844451,246506931319,246492077085,246516180011,246487120609,246536008095,246596070423,246515445460,246531783845,246611919612,246611881427,246612015861,246230206769,246630002937,246636079310,246627811837,246514137386,246516658800,246456980507,246631726988,246463332844,246103940407,246050544567,246571063739,246127746175,246597887793,246613128002,246631409000,246495094058,246586214567,246648813639,246487186170,246612923133,246471604055,246637820715,226136883958,246516516384,246436090208,246487279614,246535426265,246585838693,246585226378,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-21 15:03:54 Duration: 4s556ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289272, 450, 'CP2308332QL,10A793426EF3$CP2305334WN,10A7932DB8EB$CP230733MFS,10A793401BD3$CP2304337YG,48BDCE672C6B$CP23043353H,48BDCE6675FB$CP23103379J,CCF3C853DF7B$CP230733KR4,10A7933F6C23$CP230733EFA,10A7933D4F93$CP2303332GP,48BDCE6E4ABB$CP2312336TM,CCF3C85AD6FB$CP2315332HP,CCF3C87EF933$CP230233AF9,48BDCE6C408B$CP2247338N8,F8D2ACEAE223$CP230233173,F8D2ACFBEA2B$CP2315337AL,CCF3C880E24B$CP230533129,48BDCE68175B$CP2311330UW,CCF3C854FD53$CP2250333P8,F8D2ACF6223B$CP230233CZC,48BDCE6D410B$CP2312333VM,CCF3C859A7CB$CP230633QQ8,10A79337683B$CP2304331TU,48BDCE734E2B$CP230733KUC,10A7933F75E3$CP2249333JC,F8D2ACF0C7B3$CP2248334V0,F8D2ACED4A43$CP2308330W4,10A79341B41B$CP2304331W9,48BDCE7353B3$CP23133332S,CCF3C85CBC83$CP2303332RG,48BDCE6E65BB$CP230733L86,10A7933F9E33$CP231133504,CCF3C856A213$CP2311330M8,CCF3C854E703$CP230333CEQ,48BDCE7241AB$CP2248339TF,F8D2ACEFD963$CP2247335UY,F8D2AC596C83$CP230633BCG,10A7933215F3$CP22453325M,F8D2AC56ED53$CP23123367M,CCF3C85A997B$CP2309332CL,B85E71AFB2AB$CP2306333K1,10A7932EF86B', '',0312,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-21 14:04:13 Duration: 4s102ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 755 8m30s 150ms 3s265ms 675ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 21 07 2 4s412ms 2s206ms 08 100 1m5s 659ms 09 102 1m8s 676ms 10 105 1m12s 686ms 11 95 1m6s 702ms 12 20 9s189ms 459ms 13 34 30s536ms 898ms 14 100 55s782ms 557ms 15 66 50s474ms 764ms 16 88 1m4s 727ms 17 43 21s813ms 507ms [ User: intelifix - Total duration: 8m30s - Times executed: 755 ]
[ Application: [unknown] - Total duration: 8m30s - Times executed: 755 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289027", "modelo" : "320", "itens" : "241594972243,241607638810,241703549113,241649135463,241667097182,241703639705,241698542227,241620291515,241656356381,241637473147,241593912330,241618215779,241615239090,241696800722,241653339813,241694996078,241673009094,241700769616,241673061222,241592888403,241674493247,241732912843,241601540617,241668218189,241726967189,241656796581,241619507992,241610909903,241610937986,241710360418,241654504259,241595694041,241638222345,241645566888,241594199810,230043648805,241674285067,241637432133,241617531212,241609975154,241657002337,241597837280,241653415353,241617952847,241660436577,241672193045,241726992546,241647919395", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-21 13:50:06 Duration: 3s265ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289320", "modelo" : "463", "itens" : "241752375157,241790275253,241794484250,241736405877,241750394863,241737072138,241722417474,241734574060,241734623638,241735039616,241751873840,241735317779,241752400716,241736450203,241754164647,241748221823,241751053749,241752421728,241724060004,241735510931,241789636672,241758059719,241719180830,241751860506,241781655467,241722973848,241720900212,241736627997,241751040718,241755656072,241737420107,241751188991,241704926385,241757311734,241758042041,241736489195,241735104448,241706239611,241721583645,241794521931,241782108698,241735520303,241735608795,241751161313,241725863333,241750027475,241718797682,241781863142,241751734253,241758247997,241723750827,241735039818,241781431933,241737079815,241782494045,241758906681,241751117088,241758958404,241722187474,241736452425", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-21 16:30:04 Duration: 3s166ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "289306", "modelo" : "463", "itens" : "241789665362,241719247479,241725699905,241722439294,241758106468,241753495659,241751701826,241721537781,241735424861,241722043847,241756928586,241724389811,241758904560,241718974445,241789453647,241704955153,241724057073,241783279509,241722992436,241754110423,241757719304,241750514953,241782320415,241753514752,241751464350,241748414647,241784584350,241751953949,241734594668,241754211016,241719035966,241757701525,241794315872,241748512132,241750534652,241753710507,241751868182,241750482425,241721757780,241737130404,241722896769,241758603240,241735382433,241758315961,241724984448,241781731435,241751086984,241723020722,241780494658,241756867896,241725590221,241787760003,241784564045,241722573753,241736018790,241725675256,241758304243,241751230916,241723004962,241789661322", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-21 15:40:12 Duration: 3s101ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 189 2h21m12s 153ms 20m41s 44s827ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 21 07 5 7m39s 1m31s 08 22 15m25s 42s52ms 09 16 17m34s 1m5s 10 38 13m27s 21s253ms 11 21 34m7s 1m37s 12 9 5s486ms 609ms 13 15 46s205ms 3s80ms 14 10 11m48s 1m10s 15 18 17m53s 59s635ms 16 14 12m14s 52s492ms 17 20 10m7s 30s362ms 18 1 1s69ms 1s69ms [ User: intelifix - Total duration: 2h21m12s - Times executed: 189 ]
[ Application: [unknown] - Total duration: 2h21m12s - Times executed: 189 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,'''','''',DATE(''2026-09-17''),DATE(''2026-09-21'')) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF ().xlsx');
Date: 2026-09-21 11:51:36 Duration: 20m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030153, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-21 17:39:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030088, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-21 07:25:39 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 151 9m28s 153ms 1m54s 3s765ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 21 00 7 33s57ms 4s722ms 01 6 10s647ms 1s774ms 02 6 9s581ms 1s596ms 03 5 8s170ms 1s634ms 04 6 9s492ms 1s582ms 05 7 10s84ms 1s440ms 06 6 9s173ms 1s528ms 07 7 12s691ms 1s813ms 08 7 15s409ms 2s201ms 09 8 2m8s 16s52ms 10 7 22s39ms 3s148ms 11 9 1m53s 12s617ms 12 6 14s345ms 2s390ms 13 6 13s735ms 2s289ms 14 6 15s398ms 2s566ms 15 7 16s950ms 2s421ms 16 6 18s203ms 3s33ms 17 7 18s421ms 2s631ms 18 6 17s735ms 2s955ms 19 6 17s404ms 2s900ms 20 8 22s933ms 2s866ms 21 6 15s572ms 2s595ms 22 6 15s494ms 2s582ms [ User: intelifix - Total duration: 9m28s - Times executed: 151 ]
[ Application: psql - Total duration: 9m28s - Times executed: 151 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 09:56:59 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 11:16:46 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 00:05:25 Duration: 21s881ms Database: rio User: intelifix Remote: [local] Application: psql
5 133 8m50s 176ms 14s680ms 3s990ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 21 00 1 1s480ms 1s480ms 05 1 241ms 241ms 06 1 6s642ms 6s642ms 07 11 58s731ms 5s339ms 08 12 58s810ms 4s900ms 09 13 57s483ms 4s421ms 10 12 55s270ms 4s605ms 11 12 1m6s 5s578ms 12 12 37s474ms 3s122ms 13 6 10s636ms 1s772ms 14 11 38s522ms 3s502ms 15 12 50s377ms 4s198ms 16 11 36s859ms 3s350ms 17 5 3s511ms 702ms 19 1 270ms 270ms 20 1 602ms 602ms 21 5 22s408ms 4s481ms 22 6 24s506ms 4s84ms [ User: intelifix - Total duration: 8m50s - Times executed: 133 ]
[ Application: psql - Total duration: 8m50s - Times executed: 133 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 07:25:16 Duration: 14s680ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 07:45:14 Duration: 13s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 11:45:12 Duration: 11s801ms Database: rio User: intelifix Remote: [local] Application: psql
6 96 16m47s 984ms 1m49s 10s492ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 21 07 4 30s24ms 7s506ms 08 3 18s275ms 6s91ms 09 4 35s423ms 8s855ms 10 5 14s819ms 2s963ms 11 14 6m24s 27s487ms 12 3 18s898ms 6s299ms 13 17 1m56s 6s855ms 14 7 1m9s 9s955ms 15 14 2m17s 9s802ms 16 9 1m27s 9s733ms 17 16 1m33s 5s868ms [ User: intelifix - Total duration: 16m47s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 16m47s - Times executed: 96 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:29:05 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:44:53 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:29:05 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 96 23s627ms 150ms 1s462ms 246ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 21 07 2 937ms 468ms 08 14 5s251ms 375ms 09 13 3s124ms 240ms 10 32 6s391ms 199ms 11 9 1s992ms 221ms 12 4 1s141ms 285ms 13 10 2s22ms 202ms 14 5 972ms 194ms 15 2 509ms 254ms 16 2 501ms 250ms 17 2 582ms 291ms 22 1 201ms 201ms [ User: intelifix - Total duration: 23s627ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 23s627ms - Times executed: 96 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('2150088860EGS3016672');
Date: 2026-09-21 08:07:45 Duration: 1s462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('216944597583');
Date: 2026-09-21 08:48:16 Duration: 1s120ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('CC5830E2AD55');
Date: 2026-09-21 07:07:21 Duration: 774ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 94 26s616ms 251ms 470ms 283ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 21 07 2 583ms 291ms 08 14 3s912ms 279ms 09 7 1s892ms 270ms 10 17 4s864ms 286ms 11 19 5s605ms 295ms 12 9 2s470ms 274ms 13 3 933ms 311ms 14 4 1s111ms 277ms 15 6 1s627ms 271ms 16 4 1s126ms 281ms 17 8 2s224ms 278ms 18 1 263ms 263ms [ User: intelifix - Total duration: 26s616ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 26s616ms - Times executed: 94 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-21 08:08:22 Duration: 470ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 081;
Date: 2026-09-21 11:29:54 Duration: 470ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-21 10:42:02 Duration: 443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 89 28s374ms 297ms 506ms 318ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 21 06 1 302ms 302ms 07 8 2s458ms 307ms 08 9 2s879ms 319ms 09 10 3s107ms 310ms 10 8 2s456ms 307ms 11 8 2s538ms 317ms 12 5 1s599ms 319ms 13 7 2s156ms 308ms 14 10 3s222ms 322ms 15 7 2s395ms 342ms 16 6 2s1ms 333ms 17 7 2s207ms 315ms 18 1 424ms 424ms 22 2 623ms 311ms [ User: lenon - Total duration: 28s374ms - Times executed: 89 ]
[ Application: [unknown] - Total duration: 28s374ms - Times executed: 89 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-21 15:59:44 Duration: 506ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-21 16:40:02 Duration: 436ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-21 18:13:50 Duration: 424ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 84 31s673ms 179ms 664ms 377ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 21 07 7 2s743ms 391ms 08 8 3s159ms 394ms 09 11 3s758ms 341ms 10 8 2s849ms 356ms 11 9 3s438ms 382ms 12 5 1s927ms 385ms 13 7 2s600ms 371ms 14 8 2s938ms 367ms 15 7 2s872ms 410ms 16 6 2s537ms 422ms 17 7 2s484ms 354ms 22 1 362ms 362ms [ User: intelifix - Total duration: 31s673ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 31s673ms - Times executed: 84 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-09-21 11:43:50 Duration: 664ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-09-21 08:07:40 Duration: 621ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (99, 0, 1);
Date: 2026-09-21 15:59:44 Duration: 541ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 75 57s782ms 170ms 5s448ms 770ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 21 07 10 5s51ms 505ms 08 5 4s788ms 957ms 09 6 2s505ms 417ms 10 12 9s236ms 769ms 11 6 9s739ms 1s623ms 13 8 4s900ms 612ms 14 4 2s396ms 599ms 15 7 6s966ms 995ms 16 11 9s375ms 852ms 17 6 2s821ms 470ms [ User: intelifix - Total duration: 57s782ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 57s782ms - Times executed: 75 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137918) LIMIT 1;
Date: 2026-09-21 11:44:17 Duration: 5s448ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0137918) LIMIT 1;
Date: 2026-09-21 16:37:19 Duration: 4s506ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0289290) LIMIT 1;
Date: 2026-09-21 15:52:30 Duration: 3s354ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 65 12m33s 9s968ms 1m10s 11s588ms create table temp0000291925 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 21 07 8 2m24s 18s83ms 08 3 30s351ms 10s117ms 09 15 2m46s 11s89ms 10 27 4m42s 10s460ms 11 12 2m9s 10s785ms [ User: intelifix - Total duration: 12m33s - Times executed: 65 ]
[ Application: [unknown] - Total duration: 12m33s - Times executed: 65 ]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 07:17:07 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 09:28:41 Duration: 20s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 11:08:05 Duration: 11s169ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 56 1m22s 575ms 20s930ms 1s476ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 21 08 5 11s31ms 2s206ms 09 3 2s153ms 717ms 10 3 4s692ms 1s564ms 11 4 12s950ms 3s237ms 12 3 2s333ms 777ms 13 3 2s121ms 707ms 14 3 2s184ms 728ms 15 3 2s27ms 675ms 16 3 1s994ms 664ms 17 4 22s996ms 5s749ms 18 5 3s688ms 737ms 19 4 3s193ms 798ms 20 4 2s950ms 737ms 21 4 3s456ms 864ms 22 5 4s922ms 984ms [ User: intelifix - Total duration: 1m22s - Times executed: 56 ]
[ Application: psql - Total duration: 1m22s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-21 17:40:22 Duration: 20s930ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-21 11:20:08 Duration: 7s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-21 08:00:07 Duration: 5s969ms Database: rio User: intelifix Remote: [local] Application: psql
14 53 15s559ms 151ms 760ms 293ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 21 08 7 1s680ms 240ms 09 15 4s692ms 312ms 10 17 5s442ms 320ms 11 6 1s165ms 194ms 13 3 604ms 201ms 15 5 1s973ms 394ms [ User: intelifix - Total duration: 15s559ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 15s559ms - Times executed: 53 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'B85E71CFB00C,ECA81FF89D54,B85E71C25F4C,C4509CBF24AC,8C6A8DC3459C,08A7C06B7B54,B85E71C027F4,CCF3C8459704,4075C3C14E58,B85E71EF0574,08A7C0507A2C,B85E71C1D590,400FC18348B4,C4509CF47024,C4509CAB5B74', '87;1', 'DEFAULT', 09, 0185, '','', '', 00);
Date: 2026-09-21 15:23:45 Duration: 760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '7C7D21F0A323,E44E12AFA011,7C7D21EEDA8B,E44E1293BEDB,DC5193DC2526,DC5193DA9532,DC5193DA9FDA,E44E1293C38B,E44E1293BF7B,7C7D21EED863,DC5193DBF9FE,E44E1293C35F,38165A47DC80,ZTE3A8TR6D02077,E44E1293BECF,DC5193DA9F96,7C7D21F1EB9B,7C7D21F0A2FB,14200454E55A,7C7D21F0A50F', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-09-21 10:21:03 Duration: 657ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '743AEF74ADDF,84011282E916,1834AF641883,840112BFC601,9877E7BA5AD2,9877E77C788F,743AEF5C6DE5,743AEFC54630,8401125F4458,9877E7083A95,743AEFD8EC69,9877E701FD93,743AEFDBDCF2', '95;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-09-21 10:07:07 Duration: 514ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 48 1h38m33s 1s457ms 10m38s 2m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 21 07 3 11m42s 3m54s 08 3 5m19s 1m46s 09 3 6m31s 2m10s 10 3 5m33s 1m51s 11 3 5m51s 1m57s 12 3 6m51s 2m17s 13 3 5m29s 1m49s 14 3 5m58s 1m59s 15 3 5m58s 1m59s 16 3 5m33s 1m51s 17 3 5m58s 1m59s 18 3 5m36s 1m52s 19 3 5m34s 1m51s 20 3 5m52s 1m57s 21 3 5m19s 1m46s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h38m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 07:15:40 Duration: 10m38s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 12:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 14:10:42 Duration: 5m40s Database: rio User: intelifix Remote: [local] Application: psql
16 48 1h7m42s 254ms 4m5s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 21 07 3 5m51s 1m57s 08 3 3m52s 1m17s 09 3 5m7s 1m42s 10 3 3m52s 1m17s 11 3 4m 1m20s 12 3 4m48s 1m36s 13 3 3m49s 1m16s 14 3 4m12s 1m24s 15 3 4m12s 1m24s 16 3 4m2s 1m20s 17 3 4m9s 1m23s 18 3 3m59s 1m19s 19 3 3m58s 1m19s 20 3 4m12s 1m24s 21 3 3m44s 1m14s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h7m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 12:16:36 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 07:22:20 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 09:16:27 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
17 47 14s663ms 151ms 796ms 311ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 21 08 9 3s276ms 364ms 10 4 1s123ms 280ms 11 10 3s689ms 368ms 12 5 1s375ms 275ms 14 3 957ms 319ms 15 8 2s109ms 263ms 16 7 1s759ms 251ms 17 1 372ms 372ms [ User: intelifix - Total duration: 14s663ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 14s663ms - Times executed: 47 ]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241653178608,241606097177,241676567388,241688916775,241703833136,241711172023,241704665271,241606191733,241666808893,241618182241,241607279504,241629282830,241660764466,241653330116,241637638897', NULL, NULL, 0320, 00);
Date: 2026-09-21 11:39:37 Duration: 796ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241629104148,241622711931,241595694041,241654504259,230043648805,241594199810,241645566888,241638222345', NULL, NULL, 0320, 00);
Date: 2026-09-21 11:17:04 Duration: 573ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '63', 2, '229868364156,229770667999,229795352833,229848568295,229858782121,229788979708', NULL, NULL, 0145, 00);
Date: 2026-09-21 11:53:09 Duration: 533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 44 11s583ms 150ms 983ms 263ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 21 10 44 11s583ms 263ms [ User: intelifix - Total duration: 11s583ms - Times executed: 44 ]
[ Application: [unknown] - Total duration: 11s583ms - Times executed: 44 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57787","seriais":"6802B862DB28,6802B8A3FB7C,6802B8F09800,6802B823B5F6,6802B8BE8FBA,6802B8A48762","usuario":"416","observacao":""}');
Date: 2026-09-21 10:32:28 Duration: 983ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57787","seriais":"3C82C08DE4A0,D4E2CB8F1F5C,484BD4A783F4,B85E71E43748,B85E71BFA0E0,B85E71C64350,3C82C093839C,3C82C0C60F9C,400FC186DC14,1C9D7285EE34,B85E71DFCF28,3C82C09242FC","usuario":"416","observacao":""}');
Date: 2026-09-21 10:35:11 Duration: 576ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57787","seriais":"CC5830E1CC44,38A65923A005,64FD96568A57,20B82BFA166D,44D454938FC1,3C585D78A131,5CFA25AB92B6,582FF79BEFA2,CC5830E0899C","usuario":"416","observacao":""}');
Date: 2026-09-21 10:38:32 Duration: 497ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 43 3m50s 162ms 54s51ms 5s352ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 21 07 3 1s267ms 422ms 08 5 43s460ms 8s692ms 09 6 1m22s 13s676ms 10 10 21s510ms 2s151ms 11 7 48s285ms 6s897ms 14 5 1s202ms 240ms 15 5 1s615ms 323ms 16 1 200ms 200ms 17 1 30s543ms 30s543ms [ User: intelifix - Total duration: 3m50s - Times executed: 43 ]
[ Application: psql - Total duration: 3m50s - Times executed: 43 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030107);
Date: 2026-09-21 09:01:09 Duration: 54s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030133);
Date: 2026-09-21 11:05:21 Duration: 45s155ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030153);
Date: 2026-09-21 17:31:19 Duration: 30s543ms Database: rio User: intelifix Remote: [local] Application: psql
20 42 8s195ms 150ms 326ms 195ms select * from rs_lote_consiste_serial (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 21 08 3 534ms 178ms 09 4 695ms 173ms 10 5 852ms 170ms 11 10 1s961ms 196ms 13 7 1s367ms 195ms 14 4 891ms 222ms 15 4 872ms 218ms 16 2 446ms 223ms 17 3 573ms 191ms [ User: intelifix - Total duration: 8s195ms - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8s195ms - Times executed: 42 ]
-
SELECT * FROM RS_LOTE_CONSISTE_SERIAL ('{"lote":"137761","seriais":[{"serial":"920391028766"},{"serial":""}]}');
Date: 2026-09-21 14:56:38 Duration: 326ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_CONSISTE_SERIAL ('{"lote":"289051","seriais":[{"serial":"11816485850054906235"},{"serial":""}]}');
Date: 2026-09-21 11:26:57 Duration: 313ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_CONSISTE_SERIAL ('{"lote":"58509","seriais":[{"serial":"518095145058"},{"serial":""}]}');
Date: 2026-09-21 16:08:01 Duration: 270ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m2s 11m42s 7m26s 3 22m18s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 21 05 3 22m18s 7m26s [ User: intelifix - Total duration: 22m18s - Times executed: 3 ]
[ Application: psql - Total duration: 22m18s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-21 05:11:44 Duration: 11m42s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-21 05:19:16 Duration: 7m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-21 05:22:19 Duration: 3m2s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s457ms 10m38s 2m3s 48 1h38m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 21 07 3 11m42s 3m54s 08 3 5m19s 1m46s 09 3 6m31s 2m10s 10 3 5m33s 1m51s 11 3 5m51s 1m57s 12 3 6m51s 2m17s 13 3 5m29s 1m49s 14 3 5m58s 1m59s 15 3 5m58s 1m59s 16 3 5m33s 1m51s 17 3 5m58s 1m59s 18 3 5m36s 1m52s 19 3 5m34s 1m51s 20 3 5m52s 1m57s 21 3 5m19s 1m46s 22 3 5m20s 1m46s [ User: intelifix - Total duration: 1h38m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h38m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 07:15:40 Duration: 10m38s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 12:11:08 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-21 14:10:42 Duration: 5m40s Database: rio User: intelifix Remote: [local] Application: psql
3 254ms 4m5s 1m24s 48 1h7m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 21 07 3 5m51s 1m57s 08 3 3m52s 1m17s 09 3 5m7s 1m42s 10 3 3m52s 1m17s 11 3 4m 1m20s 12 3 4m48s 1m36s 13 3 3m49s 1m16s 14 3 4m12s 1m24s 15 3 4m12s 1m24s 16 3 4m2s 1m20s 17 3 4m9s 1m23s 18 3 3m59s 1m19s 19 3 3m58s 1m19s 20 3 4m12s 1m24s 21 3 3m44s 1m14s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h7m42s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m42s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 12:16:36 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 07:22:20 Duration: 4m3s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-21 09:16:27 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
4 153ms 20m41s 44s827ms 189 2h21m12s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 21 07 5 7m39s 1m31s 08 22 15m25s 42s52ms 09 16 17m34s 1m5s 10 38 13m27s 21s253ms 11 21 34m7s 1m37s 12 9 5s486ms 609ms 13 15 46s205ms 3s80ms 14 10 11m48s 1m10s 15 18 17m53s 59s635ms 16 14 12m14s 52s492ms 17 20 10m7s 30s362ms 18 1 1s69ms 1s69ms [ User: intelifix - Total duration: 2h21m12s - Times executed: 189 ]
[ Application: [unknown] - Total duration: 2h21m12s - Times executed: 189 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_nao_recebidos_pre_alerta(6,'''','''',DATE(''2026-09-17''),DATE(''2026-09-21'')) ;', '/var/www/html/tmp/Seriais nao recebidos - Pre Alerta NF ().xlsx');
Date: 2026-09-21 11:51:36 Duration: 20m41s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030153, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-21 17:39:39 Duration: 7m38s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 030088, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-21 07:25:39 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 4s863ms 1m5s 34s604ms 4 2m18s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 21 20 2 1m10s 35s165ms 23 2 1m8s 34s43ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-21 20:08:44 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-21 23:16:35 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-21 20:10:47 Duration: 5s289ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 331ms 53s817ms 26s680ms 4 1m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 21 20 2 54s185ms 27s92ms 23 2 52s538ms 26s269ms [ User: intelifix - Total duration: 1m46s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m46s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-21 20:05:46 Duration: 53s817ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-21 23:13:41 Duration: 52s206ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-21 20:10:10 Duration: 367ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 788ms 1m34s 13s442ms 14 3m8s select * from rs_resumo_lote_entrada (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 21 12 5 2m16s 27s299ms 13 1 21s869ms 21s869ms 14 3 24s176ms 8s58ms 15 5 5s647ms 1s129ms [ User: intelifix - Total duration: 3m8s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 14 ]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-09-01', '2026-09-21', 00, 00);
Date: 2026-09-21 12:20:26 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-09-01', '2026-09-21', 00, 00);
Date: 2026-09-21 14:57:04 Duration: 21s941ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_LOTE_ENTRADA (00, 06, ' ', '2026-09-01', '2026-09-21', 00, 00);
Date: 2026-09-21 13:55:29 Duration: 21s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s234ms 1m9s 13s259ms 35 7m44s create table temp0000292016 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 21 14 18 4m18s 14s358ms 15 15 2m59s 11s936ms 16 2 26s605ms 13s302ms [ User: intelifix - Total duration: 7m44s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m44s - Times executed: 35 ]
-
CREATE TABLE temp0000292016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 14:19:46 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 15:10:54 Duration: 20s917ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000292016 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 16:39:56 Duration: 14s499ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s891ms 53s963ms 11s724ms 31 6m3s create table temp0000291941 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 21 08 20 3m24s 10s203ms 10 11 2m39s 14s491ms [ User: intelifix - Total duration: 6m3s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m3s - Times executed: 31 ]
-
CREATE TABLE temp0000291941 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 10:12:24 Duration: 53s963ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291941 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 10:14:19 Duration: 10s796ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291941 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 10:08:27 Duration: 10s766ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s968ms 1m10s 11s588ms 65 12m33s create table temp0000291925 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 21 07 8 2m24s 18s83ms 08 3 30s351ms 10s117ms 09 15 2m46s 11s89ms 10 27 4m42s 10s460ms 11 12 2m9s 10s785ms [ User: intelifix - Total duration: 12m33s - Times executed: 65 ]
[ Application: [unknown] - Total duration: 12m33s - Times executed: 65 ]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 07:17:07 Duration: 1m10s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 09:28:41 Duration: 20s124ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 11:08:05 Duration: 11s169ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s162ms 11s671ms 10s627ms 19 3m21s create table temp0000291755 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 21 08 5 53s467ms 10s693ms 09 3 30s938ms 10s312ms 10 4 42s839ms 10s709ms 11 6 1m3s 10s501ms 15 1 11s671ms 11s671ms [ User: intelifix - Total duration: 3m21s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m21s - Times executed: 19 ]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 15:29:03 Duration: 11s671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 08:08:22 Duration: 11s113ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291755 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-21 11:13:03 Duration: 10s838ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 984ms 1m49s 10s492ms 96 16m47s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 21 07 4 30s24ms 7s506ms 08 3 18s275ms 6s91ms 09 4 35s423ms 8s855ms 10 5 14s819ms 2s963ms 11 14 6m24s 27s487ms 12 3 18s898ms 6s299ms 13 17 1m56s 6s855ms 14 7 1m9s 9s955ms 15 14 2m17s 9s802ms 16 9 1m27s 9s733ms 17 16 1m33s 5s868ms [ User: intelifix - Total duration: 16m47s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 16m47s - Times executed: 96 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:29:05 Duration: 1m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:44:53 Duration: 1m47s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-21', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-21 11:29:05 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
13 222ms 47s618ms 8s921ms 39 5m47s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 21 07 2 51s629ms 25s814ms 08 7 54s194ms 7s742ms 09 5 1m17s 15s475ms 10 11 1m25s 7s729ms 11 5 45s874ms 9s174ms 13 1 3s104ms 3s104ms 14 4 17s636ms 4s409ms 15 3 12s874ms 4s291ms 17 1 222ms 222ms [ User: intelifix - Total duration: 5m47s - Times executed: 39 ]
[ Application: psql - Total duration: 5m47s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030088);
Date: 2026-09-21 07:19:13 Duration: 47s618ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030110);
Date: 2026-09-21 09:11:02 Duration: 31s898ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (030118);
Date: 2026-09-21 10:09:06 Duration: 29s235ms Database: rio User: intelifix Remote: [local] Application: psql
14 162ms 54s51ms 5s352ms 43 3m50s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 21 07 3 1s267ms 422ms 08 5 43s460ms 8s692ms 09 6 1m22s 13s676ms 10 10 21s510ms 2s151ms 11 7 48s285ms 6s897ms 14 5 1s202ms 240ms 15 5 1s615ms 323ms 16 1 200ms 200ms 17 1 30s543ms 30s543ms [ User: intelifix - Total duration: 3m50s - Times executed: 43 ]
[ Application: psql - Total duration: 3m50s - Times executed: 43 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030107);
Date: 2026-09-21 09:01:09 Duration: 54s51ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030133);
Date: 2026-09-21 11:05:21 Duration: 45s155ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (030153);
Date: 2026-09-21 17:31:19 Duration: 30s543ms Database: rio User: intelifix Remote: [local] Application: psql
15 1s955ms 47s360ms 4s803ms 41 3m16s create table temp0000291925 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 21 07 9 1m3s 7s60ms 08 2 4s303ms 2s151ms 09 10 56s782ms 5s678ms 10 12 29s957ms 2s496ms 11 8 42s361ms 5s295ms [ User: intelifix - Total duration: 3m16s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m16s - Times executed: 41 ]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-09-2026", "ate" :"21-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-21 07:31:47 Duration: 47s360ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-09-2026", "ate" :"21-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-21 09:17:54 Duration: 35s505ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291925 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-09-2026", "ate" :"21-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-21 11:20:22 Duration: 23s294ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 176ms 14s680ms 3s990ms 133 8m50s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 21 00 1 1s480ms 1s480ms 05 1 241ms 241ms 06 1 6s642ms 6s642ms 07 11 58s731ms 5s339ms 08 12 58s810ms 4s900ms 09 13 57s483ms 4s421ms 10 12 55s270ms 4s605ms 11 12 1m6s 5s578ms 12 12 37s474ms 3s122ms 13 6 10s636ms 1s772ms 14 11 38s522ms 3s502ms 15 12 50s377ms 4s198ms 16 11 36s859ms 3s350ms 17 5 3s511ms 702ms 19 1 270ms 270ms 20 1 602ms 602ms 21 5 22s408ms 4s481ms 22 6 24s506ms 4s84ms [ User: intelifix - Total duration: 8m50s - Times executed: 133 ]
[ Application: psql - Total duration: 8m50s - Times executed: 133 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 07:25:16 Duration: 14s680ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 07:45:14 Duration: 13s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-21 11:45:12 Duration: 11s801ms Database: rio User: intelifix Remote: [local] Application: psql
17 153ms 1m54s 3s765ms 151 9m28s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 21 00 7 33s57ms 4s722ms 01 6 10s647ms 1s774ms 02 6 9s581ms 1s596ms 03 5 8s170ms 1s634ms 04 6 9s492ms 1s582ms 05 7 10s84ms 1s440ms 06 6 9s173ms 1s528ms 07 7 12s691ms 1s813ms 08 7 15s409ms 2s201ms 09 8 2m8s 16s52ms 10 7 22s39ms 3s148ms 11 9 1m53s 12s617ms 12 6 14s345ms 2s390ms 13 6 13s735ms 2s289ms 14 6 15s398ms 2s566ms 15 7 16s950ms 2s421ms 16 6 18s203ms 3s33ms 17 7 18s421ms 2s631ms 18 6 17s735ms 2s955ms 19 6 17s404ms 2s900ms 20 8 22s933ms 2s866ms 21 6 15s572ms 2s595ms 22 6 15s494ms 2s582ms [ User: intelifix - Total duration: 9m28s - Times executed: 151 ]
[ Application: psql - Total duration: 9m28s - Times executed: 151 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 09:56:59 Duration: 1m54s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 11:16:46 Duration: 1m35s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-21 00:05:25 Duration: 21s881ms Database: rio User: intelifix Remote: [local] Application: psql
18 613ms 12s942ms 3s658ms 33 2m call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 21 08 1 4s749ms 4s749ms 09 3 13s272ms 4s424ms 10 3 16s994ms 5s664ms 11 1 7s601ms 7s601ms 12 3 4s516ms 1s505ms 13 3 9s61ms 3s20ms 14 3 11s890ms 3s963ms 15 3 14s850ms 4s950ms 16 3 11s8ms 3s669ms 17 2 19s889ms 9s944ms 18 1 741ms 741ms 19 2 1s541ms 770ms 20 2 2s26ms 1s13ms 21 2 1s868ms 934ms 22 1 711ms 711ms [ User: intelifix - Total duration: 2m - Times executed: 33 ]
[ Application: psql - Total duration: 2m - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-21 17:20:14 Duration: 12s942ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-21 11:40:09 Duration: 7s601ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-21 10:00:08 Duration: 6s977ms Database: rio User: intelifix Remote: [local] Application: psql
19 575ms 20s930ms 1s476ms 56 1m22s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 21 08 5 11s31ms 2s206ms 09 3 2s153ms 717ms 10 3 4s692ms 1s564ms 11 4 12s950ms 3s237ms 12 3 2s333ms 777ms 13 3 2s121ms 707ms 14 3 2s184ms 728ms 15 3 2s27ms 675ms 16 3 1s994ms 664ms 17 4 22s996ms 5s749ms 18 5 3s688ms 737ms 19 4 3s193ms 798ms 20 4 2s950ms 737ms 21 4 3s456ms 864ms 22 5 4s922ms 984ms [ User: intelifix - Total duration: 1m22s - Times executed: 56 ]
[ Application: psql - Total duration: 1m22s - Times executed: 56 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-21 17:40:22 Duration: 20s930ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-21 11:20:08 Duration: 7s572ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-21 08:00:07 Duration: 5s969ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 5s175ms 902ms 1,119 16m49s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 21 07 5 1s391ms 278ms 08 56 55s590ms 992ms 09 121 1m38s 814ms 10 168 1m48s 648ms 11 158 2m41s 1s19ms 12 58 40s604ms 700ms 13 75 1m2s 832ms 14 189 2m56s 932ms 15 142 2m31s 1s69ms 16 89 1m43s 1s161ms 17 58 49s195ms 848ms [ User: intelifix - Total duration: 16m49s - Times executed: 1119 ]
[ Application: [unknown] - Total duration: 16m49s - Times executed: 1119 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58536, 406, '835197929003801,241695423853,241606047778,241608693245,241627966270,241620728606,241660130914,241620705270,241731026373,241695517273,241672183044,241715487797,241673349813,241727510509,241661329504,241649691736,241599315876,241622641419,241664737984,241698720808,241659655255,241727066166,241680303455,241632295862,241695119300,241711210714,241680403543,241622461424,241663000117,241700944459,241692691432,241728719100,241660109395,241607249197,241647382341,241692617787,241728646163,241594968808,241727047881,241646144453,241614473248,241680411827,241654353941,241614464964,241598837692,241704293035,241711161113,241659766175,241599243546,241617451530,241670533545', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-21 17:06:14 Duration: 5s175ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (58501, 407, '270911029146103297,229744538692,229750288389,229685674755,229726668396,216944946787,229690654343,229661552738,229740497490,229781735353,229670119511,229752865970,229808618606,229808869214,229812674658,229753956873,229812923246,229815330204,229812155056,229690806984,229689928201,216944640215,229815289414,216938486684,229925601426,229933339598,229754685463,229932311228,229781782227,229808474450,229816200727,229672209715,229783412532,229859541522,229660481332,229808886970,216943172933,229814836687,229932955465,229684437597,216931760619,229662906068,229736465761,229780474254,229783964460', '246538841111,246530239407,246490844451,246506931319,246492077085,246516180011,246487120609,246536008095,246596070423,246515445460,246531783845,246611919612,246611881427,246612015861,246230206769,246630002937,246636079310,246627811837,246514137386,246516658800,246456980507,246631726988,246463332844,246103940407,246050544567,246571063739,246127746175,246597887793,246613128002,246631409000,246495094058,246586214567,246648813639,246487186170,246612923133,246471604055,246637820715,226136883958,246516516384,246436090208,246487279614,246535426265,246585838693,246585226378,,,,,,', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-21 15:03:54 Duration: 4s556ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (289272, 450, 'CP2308332QL,10A793426EF3$CP2305334WN,10A7932DB8EB$CP230733MFS,10A793401BD3$CP2304337YG,48BDCE672C6B$CP23043353H,48BDCE6675FB$CP23103379J,CCF3C853DF7B$CP230733KR4,10A7933F6C23$CP230733EFA,10A7933D4F93$CP2303332GP,48BDCE6E4ABB$CP2312336TM,CCF3C85AD6FB$CP2315332HP,CCF3C87EF933$CP230233AF9,48BDCE6C408B$CP2247338N8,F8D2ACEAE223$CP230233173,F8D2ACFBEA2B$CP2315337AL,CCF3C880E24B$CP230533129,48BDCE68175B$CP2311330UW,CCF3C854FD53$CP2250333P8,F8D2ACF6223B$CP230233CZC,48BDCE6D410B$CP2312333VM,CCF3C859A7CB$CP230633QQ8,10A79337683B$CP2304331TU,48BDCE734E2B$CP230733KUC,10A7933F75E3$CP2249333JC,F8D2ACF0C7B3$CP2248334V0,F8D2ACED4A43$CP2308330W4,10A79341B41B$CP2304331W9,48BDCE7353B3$CP23133332S,CCF3C85CBC83$CP2303332RG,48BDCE6E65BB$CP230733L86,10A7933F9E33$CP231133504,CCF3C856A213$CP2311330M8,CCF3C854E703$CP230333CEQ,48BDCE7241AB$CP2248339TF,F8D2ACEFD963$CP2247335UY,F8D2AC596C83$CP230633BCG,10A7933215F3$CP22453325M,F8D2AC56ED53$CP23123367M,CCF3C85A997B$CP2309332CL,B85E71AFB2AB$CP2306333K1,10A7932EF86B', '',0312,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-21 14:04:13 Duration: 4s102ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 21 18 1 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 3m48s - Times executed: 6 ]
[ Application: psql - Total duration: 3m48s - Times executed: 6 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,719 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 62 FATAL entries
- 4736 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,453 Max number of times the same event was reported
- 4,806 Total events found
Rank Times reported Error 1 4,453 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 21 02 38 03 60 04 59 05 60 06 62 07 206 08 402 09 470 10 515 11 438 12 290 13 205 14 416 15 412 16 296 17 176 18 60 19 60 20 59 21 59 22 60 23 50 - ERROR: prepared statement "_PLAN0000000029CA96F0" does not exist
- ERROR: prepared statement "_PLAN0000000029AE5570" does not exist
- ERROR: prepared statement "_PLAN0000000029DE76C0" does not exist
Statement: DEALLOCATE "_PLAN0000000029CA96F0"
Date: 2026-09-21 02:22:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029AE5570"
Date: 2026-09-21 02:23:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DE76C0"
Date: 2026-09-21 02:24:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 272 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 21 09 2 13 14 14 60 15 60 16 61 17 59 18 16 - ERROR: syntax error at or near "230010327393" at character 41
- ERROR: syntax error at or near "229938760421" at character 41
- ERROR: syntax error at or near "," at character 28
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''230010327393');
Date: 2026-09-21 09:31:10 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''229938760421');
Date: 2026-09-21 09:32:31 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(-,)
Date: 2026-09-21 13:48:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
3 53 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 21 00 1 03 1 04 1 05 4 06 9 09 3 10 3 11 2 15 1 16 1 17 1 18 6 19 1 20 10 21 5 22 2 23 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-21 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-21 03:14:56 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-21 04:20:45 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
4 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 21 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-21 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-21 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-21 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 6 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 21 09 3 11 3 - LOG: process 2351412 still waiting for ShareLock on transaction 6492104 after 1000.077 ms
- LOG: process 2351412 still waiting for ShareLock on transaction 6492104 after 8324.804 ms
- LOG: process 2351412 still waiting for ShareLock on transaction 6492104 after 20159.670 ms
Detail: Process holding the lock: 2372984. Wait queue: 2351412.
Context: while updating tuple (80347,76) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-21 09:55:08 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2372984. Wait queue: 2351412.
Context: while updating tuple (80347,76) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-21 09:55:15 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2372984. Wait queue: 2351412.
Context: while updating tuple (80347,76) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-21 09:55:27 Database: rio Application: psql User: intelifix Remote: [local]
6 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 21 05 4 13 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-21 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-21 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-21 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
7 3 ERROR: operator does not exist: & integer
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 21 09 3 - ERROR: operator does not exist: & integer at character 27
- ERROR: operator does not exist: & integer at character 27
- ERROR: operator does not exist: & integer at character 27
Hint: No operator matches the given name and argument type. You might need to add an explicit type cast.
Statement: SELECT * FROM RS_ETIQUETA(&57)Date: 2026-09-21 09:03:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No operator matches the given name and argument type. You might need to add an explicit type cast.
Statement: SELECT * FROM RS_ETIQUETA(&57)Date: 2026-09-21 09:03:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No operator matches the given name and argument type. You might need to add an explicit type cast.
Statement: SELECT * FROM RS_ETIQUETA(&57)Date: 2026-09-21 09:03:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 21 11 1 - LOG: process 2457683 still waiting for AccessExclusiveLock on relation 5228242 of database 358220 after 1000.084 ms
Detail: Process holding the lock: 2466445. Wait queue: 2457683.
Statement: DROP TABLE IF EXISTS temp0000291755;Date: 2026-09-21 11:13:31 Database: rio Application: [unknown] User: intelifix Remote: [local]
9 1 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 21 16 1 - FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn( /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-09-21 16:00:02 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
10 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 21 16 1 - ERROR: column "mar_id" does not exist at character 41
Hint: Perhaps you meant to reference the column "modelos.mod_id" or the column "modelos.for_id".
Statement: SELECT mod_id, mod_nome, mod_mnemonico, mar_id FROM modelos WHERE mod_nome = $1 OR mod_mnemonico = $1 LIMIT 5Date: 2026-09-21 16:25:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
11 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 21 11 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000291755"
Date: 2026-09-21 11:13:31
12 1 ERROR: prepared statement "..." does not existNOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 21 09 1 - ERROR: prepared statement "_PLAN0000000029F48DA0" does not existNOTICE: table "tmp_entrada" does not exist, skipping
Statement: DEALLOCATE "_PLAN0000000029F48DA0"
Date: 2026-09-21 09:30:00 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 21 03 1 - LOG: database system was shut down at 2026-09-21 03:05:02 -03
Date: 2026-09-21 03:05:03
14 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 21 03 1 - FATAL: the database system is shutting down
Date: 2026-09-21 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]