pgBadger-
Global information
- Generated on Mon Jul 20 23:50:12 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 42,837 log entries in 11s
- Log start from 2026-07-20 00:00:18 to 2026-07-20 23:49:36
-
Overview
Global Stats
- 405 Number of unique normalized queries
- 6,826 Number of queries
- 10h24m10s Total query duration
- 2026-07-20 00:02:13 First query
- 2026-07-20 23:45:34 Last query
- 5 queries/s at 2026-07-20 08:53:43 Query peak
- 10h24m10s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 10h24m10s Execute total duration
- 3,881 Number of events
- 15 Number of unique normalized events
- 3,717 Max number of times the same event was reported
- 0 Number of cancellation
- 456 Total number of automatic vacuums
- 901 Total number of automatic analyzes
- 17 Number temporary file
- 236.02 MiB Max size of temporary file
- 128.81 MiB Average size of temporary file
- 351 Total number of sessions
- 9 sessions at 2026-07-20 13:08:19 Session peak
- 12d17h2m29s Total duration of sessions
- 52m8s Average duration of sessions
- 19 Average queries per session
- 1m46s Average queries duration per session
- 50m21s Average idle time per session
- 361 Total number of connections
- 5 connections/s at 2026-07-20 00:05:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-20 08:53:43 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-20 08:53:43 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-20 20:08:46 Date
Queries duration
Key values
- 10h24m10s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 20 00 23 0ms 21s111ms 5s446ms 4s327ms 4s476ms 1m21s 01 11 0ms 4s353ms 2s297ms 3s643ms 4s207ms 4s652ms 02 11 0ms 4s836ms 2s376ms 3s784ms 4s240ms 5s321ms 03 13 0ms 4s306ms 1s709ms 692ms 4s260ms 4s538ms 04 12 0ms 4s444ms 2s197ms 4s33ms 4s437ms 4s771ms 05 17 0ms 9m15s 1m3s 4s723ms 2m26s 9m15s 06 24 0ms 31s209ms 4s939ms 4s680ms 18s571ms 31s838ms 07 206 0ms 13m53s 12s834ms 2m16s 4m35s 14m48s 08 436 151ms 6m35s 2s825ms 41s513ms 59s668ms 6m40s 09 867 150ms 13m46s 3s758ms 1m20s 6m35s 14m3s 10 677 150ms 10m1s 4s846ms 2m1s 5m9s 11m15s 11 676 150ms 10m15s 4s433ms 1m45s 7m36s 10m34s 12 250 0ms 10m9s 6s739ms 36s271ms 4m25s 11m6s 13 429 0ms 7m31s 4s6ms 40s945ms 3m40s 7m41s 14 709 150ms 10m42s 3s573ms 1m4s 5m36s 10m59s 15 918 150ms 10m34s 6s258ms 7m9s 9m2s 11m32s 16 612 150ms 14m11s 3s418ms 30s936ms 2m30s 14m19s 17 373 0ms 12m14s 5s528ms 1m15s 2m37s 12m51s 18 23 0ms 10m47s 43s144ms 5s507ms 1m7s 10m51s 19 21 0ms 5m57s 30s763ms 4s439ms 48s583ms 5m57s 20 126 0ms 12m51s 13s528ms 1m15s 2m6s 12m51s 21 35 0ms 6m20s 19s261ms 5s728ms 16s889ms 6m52s 22 27 0ms 5m38s 23s925ms 6s615ms 45s456ms 5m38s 23 330 0ms 1m30s 6s425ms 1m5s 1m11s 1m30s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 20 00 4 0 5s494ms 0ms 0ms 491ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 302ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 6 0 3s305ms 0ms 0ms 1s259ms 07 156 0 14s782ms 6s386ms 1m45s 7m10s 08 347 0 2s806ms 7s385ms 14s374ms 3m25s 09 729 0 3s705ms 20s242ms 52s59ms 7m8s 10 549 0 5s289ms 31s873ms 1m49s 8m50s 11 515 0 4s743ms 15s317ms 1m41s 7m35s 12 191 0 7s894ms 8s846ms 10s553ms 6m14s 13 347 0 4s277ms 12s442ms 27s458ms 5m58s 14 560 0 3s868ms 16s203ms 54s856ms 8m19s 15 700 0 6s702ms 47s184ms 6m45s 9m2s 16 492 0 3s763ms 22s302ms 29s136ms 4m46s 17 247 0 7s229ms 17s791ms 59s249ms 4m44s 18 7 0 2m15s 0ms 0ms 3m33s 19 6 0 1m42s 0ms 0ms 3m28s 20 19 90 15s226ms 16s176ms 1m8s 3m40s 21 15 0 42s258ms 0ms 0ms 3m22s 22 6 0 1m41s 0ms 0ms 3m42s 23 7 323 6s425ms 1m3s 1m5s 1m30s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 20 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 1 0 0 177ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 20 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.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 8 8.00 0.00% 08 0 13 13.00 0.00% 09 0 23 23.00 0.00% 10 0 14 14.00 0.00% 11 0 13 13.00 0.00% 12 0 10 10.00 0.00% 13 0 11 11.00 0.00% 14 0 18 18.00 0.00% 15 0 22 22.00 0.00% 16 0 15 15.00 0.00% 17 0 14 14.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 20 00 16 0.00/s 01 7 0.00/s 02 8 0.00/s 03 13 0.00/s 04 7 0.00/s 05 9 0.00/s 06 15 0.00/s 07 14 0.00/s 08 18 0.01/s 09 30 0.01/s 10 21 0.01/s 11 22 0.01/s 12 17 0.00/s 13 25 0.01/s 14 22 0.01/s 15 24 0.01/s 16 22 0.01/s 17 18 0.01/s 18 8 0.00/s 19 7 0.00/s 20 13 0.00/s 21 8 0.00/s 22 7 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Jul 20 00 3 43m20s 42m38s 01 14 1h1m17s 1h1m15s 02 7 1h1s 59m57s 03 13 26m18s 26m16s 04 8 1h2m37s 1h2m34s 05 8 53m45s 51m31s 06 8 58m8s 57m53s 07 15 57m26s 54m30s 08 16 52m 50m43s 09 23 43m35s 41m13s 10 24 55m19s 53m2s 11 22 50m40s 48m24s 12 21 55m23s 54m2s 13 15 49m56s 48m1s 14 24 56m56s 55m10s 15 25 48m16s 44m26s 16 21 53m26s 51m46s 17 23 53m50s 52m20s 18 14 59m4s 57m53s 19 8 1h44s 59m24s 20 10 42m25s 39m35s 21 8 1h49s 59m25s 22 9 1h57s 59m45s 23 12 33m12s 30m16s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-20 00:05:02 Date
Connections per database
Key values
- rio Main Database
- 361 connections Total
Connections per user
Key values
- intelifix Main User
- 361 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-07-20 13:08:19 Date
Histogram of session times
Key values
- 273 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 351 sessions Total
Sessions per user
Key values
- intelifix Main User
- 351 sessions Total
Sessions per host
Key values
- [local] Main Host
- 351 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 351 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 13,303 buffers Checkpoint Peak
- 2026-07-20 03:05:02 Date
- 270.014 seconds Highest write time
- 0.165 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-07-20 15:24:40 Date
Checkpoints distance
Key values
- 378.41 Mo Distance Peak
- 2026-07-20 15:24:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 20 00 5,733 269.724s 0.008s 269.757s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 13,303 0.724s 0.023s 0.768s 04 0 0s 0s 0s 05 6,232 623.936s 0.036s 624.032s 06 5,212 482.909s 0.029s 482.964s 07 37,197 2,296.094s 0.195s 2,296.412s 08 33,344 2,834.772s 0.441s 2,835.368s 09 60,857 3,238.737s 0.797s 3,239.741s 10 75,598 3,238.808s 0.605s 3,239.621s 11 65,946 3,179.899s 0.604s 3,180.709s 12 39,924 2,274.169s 0.266s 2,274.558s 13 29,241 2,285.577s 0.385s 2,286.089s 14 64,138 3,238.755s 0.81s 3,239.772s 15 74,747 3,238.211s 1.075s 3,239.596s 16 41,551 3,166.891s 0.562s 3,167.641s 17 39,906 2,341.505s 0.346s 2,342.019s 18 1,250 125.733s 0.022s 125.803s 19 23 2.324s 0.004s 2.334s 20 938 204.909s 0.04s 204.97s 21 2,764 277.561s 0.034s 277.694s 22 1,833 184.269s 0.03s 184.348s 23 426 42.801s 0.011s 42.846s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 20 00 0 0 1 29 0.001s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 4 35 0.015s 0.008s 04 0 0 0 0 0s 0s 05 0 0 3 125 0.009s 0.006s 06 0 0 1 204 0.006s 0.004s 07 0 0 24 1,829 0.007s 0.012s 08 0 0 15 4,882 0.014s 0.012s 09 0 0 37 6,260 0.037s 0.012s 10 0 0 38 7,208 0.016s 0.012s 11 0 0 37 6,970 0.018s 0.012s 12 0 0 17 3,395 0.010s 0.012s 13 0 0 13 4,874 0.008s 0.012s 14 0 0 30 7,335 0.012s 0.012s 15 0 0 72 8,047 0.012s 0.012s 16 0 0 18 5,315 0.009s 0.012s 17 0 0 26 4,458 0.006s 0.012s 18 0 0 1 196 0.003s 0.008s 19 0 0 0 5 0.003s 0.001s 20 0 0 1 94 0.011s 0.003s 21 0 0 0 439 0.003s 0.01s 22 0 0 1 417 0.003s 0.008s 23 0 0 0 32 0.004s 0.005s Day Hour Count Avg time (sec) Jul 20 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 20 00 27,755.00 kB 27,755.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 32,782.00 kB 32,782.00 kB 04 0.00 kB 0.00 kB 05 6,870.83 kB 10,394.33 kB 06 4,325.00 kB 10,595.25 kB 07 33,023.08 kB 58,029.00 kB 08 19,749.75 kB 63,982.83 kB 09 50,774.33 kB 82,117.92 kB 10 51,881.33 kB 89,855.58 kB 11 50,247.92 kB 101,100.08 kB 12 23,190.75 kB 69,628.00 kB 13 17,779.92 kB 45,003.25 kB 14 41,087.92 kB 60,532.00 kB 15 98,425.75 kB 143,896.08 kB 16 24,351.83 kB 86,614.75 kB 17 36,628.33 kB 74,566.25 kB 18 832.14 kB 51,025.43 kB 19 173.00 kB 32,899.00 kB 20 4,920.00 kB 27,944.33 kB 21 1,397.67 kB 15,916.11 kB 22 1,154.75 kB 7,241.12 kB 23 184.40 kB 3,954.60 kB -
Temporary Files
Size of temporary files
Key values
- 472.03 MiB Temp Files size Peak
- 2026-07-20 05:31:55 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-20 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.76 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 156.01 MiB 156.01 MiB 11 4 624.02 MiB 156.00 MiB 12 0 0 0 13 0 0 0 14 0 0 0 15 2 312.07 MiB 156.04 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 917.06 MiB 70.40 MiB 236.02 MiB 114.63 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-20 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-20 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 7 1.07 GiB 155.98 MiB 156.06 MiB 156.01 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01574);
Date: 2026-07-20 15:48:25 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01573);
Date: 2026-07-20 15:41:49 Duration: 1m44s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01571);
Date: 2026-07-20 11:34:51 Duration: 1m39s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 2 180.58 MiB 90.29 MiB 90.29 MiB 90.29 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-20 05:30:41 Duration: 38s917ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-20 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 236.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 236.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 156.06 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01574);[ Date: 2026-07-20 15:48:05 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 156.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01571);[ Date: 2026-07-20 11:34:45 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01572);[ Date: 2026-07-20 11:39:01 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01570);[ Date: 2026-07-20 11:30:20 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01573);[ Date: 2026-07-20 15:41:45 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
8 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01568);[ Date: 2026-07-20 10:58:47 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
9 155.98 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01569);[ Date: 2026-07-20 11:27:00 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
10 90.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-20 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 90.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-20 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 77.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 77.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 77.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 70.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 70.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 70.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-20 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 5.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database contagem - 2026-07-20 11:28:01 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 5.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database contagem - 2026-07-20 11:28:01 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (121) Main table analyzed (database rio)
- 901 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 121 rio.pg_catalog.pg_class 62 rio.pg_catalog.pg_type 52 rio.public.temp0000285796 50 rio.public.usuarios 47 brasilia.pg_catalog.pg_attribute 43 rio.pg_catalog.pg_index 36 rio.pg_catalog.pg_depend 27 rio.public.temp0000285774 25 rio.public.temp0000285868 24 rio.public.temp0000285800 23 brasilia.pg_catalog.pg_class 21 rio.public.temp0000285790 21 rio.public.temp0000284750 19 brasilia.pg_catalog.pg_type 18 rio.public.temp0000285792 17 contagem.public.temp0000226660 16 contagem.pg_catalog.pg_attribute 16 brasilia.public.temp0000236492 15 rio.public.temp0000285820 13 contagem.public.temp0000226658 13 contagem.public.usuarios 12 rio.public.temp0000285906 12 rio.public.temp0000285866 12 brasilia.pg_catalog.pg_index 11 brasilia.public.usuarios 11 brasilia.pg_catalog.pg_depend 9 brasilia.public.temp0000236426 9 contagem.pg_catalog.pg_class 8 contagem.pg_catalog.pg_type 8 rio.public.temp0000285860 7 rio.public.temp0000285808 6 contagem.public.nf_entrada 6 contagem.public.temp0000226664 6 rio.public.temp0000285788 5 rio.public.temp0000285404 5 rio.public.temp0000285812 4 contagem.pg_catalog.pg_shdepend 4 contagem.pg_catalog.pg_index 4 rio.public.temp0000285900 4 rio.public.temp0000285910 4 contagem.pg_catalog.pg_depend 4 rio.public.tmp_drill_0302 3 brasilia.public.temp0000236486 3 rio.public.temp0000285810 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000285918 3 rio.public.temp0000285770 3 rio.public.temp0000285854 3 rio.public.tmp_drill_0175 2 contagem.public.temp0000226662 2 rio.public.temp0000285806 2 brasilia.public.temp0000236482 2 brasilia.public.temp0000236430 2 brasilia.public.nf_entrada 2 brasilia.public.temp0000236484 2 rio.public.temp0000285892 2 template1.pg_catalog.pg_shdepend 2 brasilia.public.temp0000236458 2 rio.public.temp0000285824 2 brasilia.public.temp0000236504 1 rio.public.temp0000285838 1 brasilia.public.temp0000236434 1 rio.public.temp0000285914 1 brasilia.public.temp0000236520 1 rio.public.temp0000285880 1 rio.public.temp0000285858 1 brasilia.public.temp0000236428 1 rio.public.temp0000285616 1 contagem.public.temp0000226612 1 rio.public.temp0000285878 1 rio.public.temp0000285786 1 rio.public.temp0000285874 1 rio.public.temp0000285844 1 rio.public.temp0000285882 1 rio.public.temp0000285862 1 brasilia.public.temp0000236424 1 postgres.pg_catalog.pg_shdepend 1 rio.public.temp0000285916 1 rio.public.temp0000285832 1 brasilia.public.temp0000236510 1 brasilia.pg_catalog.pg_shdepend 1 rio.public.temp0000285282 1 rio.public.temp0000285834 1 rio.public.temp0000285814 1 brasilia.public.temp0000236452 1 brasilia.public.temp0000236524 1 rio.public.temp0000285902 1 Total 901 Vacuums per table
Key values
- pg_catalog.pg_attribute (65) Main table vacuumed on database rio
- 456 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 65 44 0 0 0 0 0 23,480 7,026 10,061,890 452 10,811 rio.public.temp0000285796 50 0 0 0 0 0 0 39,262 5,268 8,889,985 0 0 rio.pg_catalog.pg_class 45 27 0 0 0 0 0 5,164 1,556 2,274,196 79 383 rio.pg_catalog.pg_type 37 25 0 0 0 0 0 2,398 761 993,379 93 337 rio.public.temp0000285868 17 0 0 0 0 0 0 5,416 86 333,302 0 0 contagem.public.temp0000226660 16 0 0 0 0 0 0 1,001 89 73,694 0 0 rio.pg_catalog.pg_index 15 14 0 0 0 0 0 949 290 259,720 52 120 rio.public.usuarios 15 5 0 0 0 0 0 150 67 142,493 4 9 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 6,602 1,761 2,807,138 62 1,595 rio.public.temp0000284750 13 0 0 0 0 0 0 441 72 36,476 0 0 rio.pg_catalog.pg_depend 13 12 0 0 0 0 0 3,550 1,385 2,016,094 67 583 rio.public.temp0000285866 12 0 0 0 0 0 0 11,670 43 695,441 0 0 contagem.public.usuarios 12 0 0 0 0 0 0 51 39 23,366 0 0 rio.public.temp0000285906 11 0 0 0 0 0 0 11,674 40 695,139 0 0 brasilia.pg_catalog.pg_class 8 8 0 0 0 0 0 1,373 429 675,424 22 76 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,227 2,011 9,587,905 833 4,164 contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 3,454 817 1,494,914 11 356 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 504 188 254,050 16 84 contagem.public.temp0000226664 5 0 0 0 0 0 0 273 28 20,578 0 0 rio.public.temp0000285404 4 0 0 0 0 0 0 259 23 18,775 0 0 template1.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 545 178 301,530 51 150 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 705 215 299,248 9 19 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 429 147 193,771 4 8 rio.public.temp0000285900 4 0 0 0 0 0 0 1,677 13 101,160 0 0 rio.public.temp0000285770 3 0 0 0 0 0 0 213 107 169,896 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,674 340 1,883,908 112 341 rio.public.temp0000285854 3 0 0 0 0 0 0 4,989 12 296,160 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 150 37 34,588 12 20 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 1,556 73 344,974 0 0 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 354 115 206,435 20 50 rio.public.temp0000285810 3 0 0 0 0 0 0 1,753 13 105,483 0 0 rio.public.temp0000285918 3 0 0 0 0 0 0 4,998 12 296,691 0 0 rio.public.temp0000285806 2 0 0 0 0 0 0 1,750 88 252,753 0 0 rio.public.temp0000285820 2 0 0 0 0 0 0 46 11 4,268 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,115 267 1,227,845 186 1,628 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 308 53 243,255 24 65 rio.public.temp0000285824 2 0 0 0 0 0 0 172 12 11,975 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 575 154 314,415 6 269 contagem.public.nf_entrada 2 2 0 0 0 0 0 158 47 101,383 3 6 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 614 177 237,152 10 101 rio.public.temp0000285812 2 0 0 0 0 0 0 127 12 9,204 0 0 rio.public.temp0000285808 2 0 0 0 0 0 0 106 103 169,961 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 106 32 29,877 1 1 rio.public.tmp_drill_0175 2 2 0 0 0 0 0 140 6 30,004 0 0 contagem.public.temp0000226662 2 0 0 0 0 0 0 210 12 14,294 0 0 rio.public.logs 1 0 0 0 0 0 0 3,135 2,842 3,458,603 136 3,390 rio.public.temp0000285880 1 0 0 0 0 0 0 8 5 1,316 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 128 32 105,438 13 31 rio.public.temp0000285878 1 0 0 0 0 0 0 92 6 6,353 0 0 contagem.public.temp0000226612 1 0 0 0 0 0 0 106 6 7,207 0 0 brasilia.public.temp0000236458 1 0 0 0 0 0 0 243 6 15,485 0 0 brasilia.public.temp0000236452 1 0 0 0 0 0 0 243 6 15,473 0 0 brasilia.public.temp0000236524 1 0 0 0 0 0 0 242 6 15,411 0 0 rio.public.temp0000285814 1 0 0 0 0 0 0 8 5 1,302 0 0 brasilia.public.temp0000236504 1 0 0 0 0 0 0 242 6 15,411 0 0 rio.public.temp0000285838 1 0 0 0 0 0 0 1,663 4 98,720 0 0 rio.public.temp0000285874 1 0 0 0 0 0 0 8 5 1,267 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 17,315 15,106 18,856,267 1,012 25,044 rio.public.temp0000285862 1 0 0 0 0 0 0 90 6 6,231 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,296 550 1,900,520 522 3,821 rio.public.temp0000285882 1 0 0 0 0 0 0 1,664 4 98,779 0 0 contagem.public.temp0000226658 1 0 0 0 0 0 0 105 6 7,147 0 0 rio.public.temp0000285916 1 0 0 0 0 0 0 8 5 1,332 0 0 rio.public.temp0000285832 1 0 0 0 0 0 0 86 6 5,983 0 0 Total 456 208 0 0 0 0 0 181,050 42,827 72,852,434 3,812 53,462 Vacuum throughput per table
Key values
- public.usuarios (10.77) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.27 rio.public.temp0000285796 0 0 2.01 rio.pg_catalog.pg_class 0 0 1.55 rio.pg_catalog.pg_type 0 0 0.44 rio.public.temp0000285868 0 0 0.41 contagem.public.temp0000226660 0 0 0.3 rio.pg_catalog.pg_index 0 0 0.26 rio.public.usuarios 0 0 10.77 brasilia.pg_catalog.pg_attribute 0 0 1.2 rio.public.temp0000284750 0 0 0.19 rio.pg_catalog.pg_depend 0 0 1.09 rio.public.temp0000285866 0 0 0.59 contagem.public.usuarios 0 0 0.03 rio.public.temp0000285906 0 0 0.55 brasilia.pg_catalog.pg_class 0 0 0.29 rio.pg_catalog.pg_statistic 0 0 1.7 contagem.pg_catalog.pg_attribute 0 0 0.74 brasilia.pg_catalog.pg_type 0 0 0.14 contagem.public.temp0000226664 0 0 0.09 rio.public.temp0000285404 0 0 0.06 template1.pg_catalog.pg_shdepend 0 0 0.3 contagem.pg_catalog.pg_class 0 0 0.28 contagem.pg_catalog.pg_type 0 0 0.22 rio.public.temp0000285900 0 0 0.2 rio.public.temp0000285770 0 0 0.04 rio.pg_toast.pg_toast_2619 0 0 0.17 rio.public.temp0000285854 0 0 0.14 brasilia.pg_catalog.pg_index 0 0 0.03 rio.public.tmp_drill_0302 0 0 0.07 postgres.pg_catalog.pg_shdepend 0 0 0.15 rio.public.temp0000285810 0 0 0.1 rio.public.temp0000285918 0 0 0.18 rio.public.temp0000285806 0 0 0.08 rio.public.temp0000285820 0 0 0.03 brasilia.pg_catalog.pg_statistic 0 0 0.26 brasilia.pg_toast.pg_toast_2619 0 0 0.03 rio.public.temp0000285824 0 0 0.03 contagem.pg_catalog.pg_depend 0 0 0.2 contagem.public.nf_entrada 0 0 0.08 brasilia.pg_catalog.pg_depend 0 0 0.26 rio.public.temp0000285812 0 0 0.04 rio.public.temp0000285808 0 0 0.02 contagem.pg_catalog.pg_index 0 0 0.21 rio.public.tmp_drill_0175 0 0 0.02 contagem.public.temp0000226662 0 0 0.03 rio.public.logs 0 0 1.36 rio.public.temp0000285880 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000285878 0 0 0.01 contagem.public.temp0000226612 0 0 0.02 brasilia.public.temp0000236458 0 0 0.02 brasilia.public.temp0000236452 0 0 0.03 brasilia.public.temp0000236524 0 0 0.03 rio.public.temp0000285814 0 0 0.02 brasilia.public.temp0000236504 0 0 0.03 rio.public.temp0000285838 0 0 0.05 rio.public.temp0000285874 0 0 0.02 contagem.auditor.auditor_2026_07 0 0 5.47 rio.public.temp0000285862 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.1 rio.public.temp0000285882 0 0 0.05 contagem.public.temp0000226658 0 0 0.02 rio.public.temp0000285916 0 0 0.02 rio.public.temp0000285832 0 0 0.02 Total 0 0 37.15 Tuples removed per table
Key values
- pg_catalog.pg_attribute (187642) Main table with removed tuples on database rio
- 352304 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 65 44 187,642 1,771,225 225,414 58 43,659 brasilia.pg_catalog.pg_attribute 14 14 51,472 307,883 0 0 7,628 contagem.pg_catalog.pg_attribute 6 6 24,981 141,613 0 112 3,251 rio.public.tmp_drill_0302 3 3 21,941 23,489 0 0 594 rio.pg_catalog.pg_statistic 7 7 12,407 59,313 553 0 9,002 rio.pg_catalog.pg_depend 13 12 11,460 248,887 12,621 0 2,431 rio.pg_catalog.pg_type 37 25 8,333 98,351 13,144 0 2,975 brasilia.pg_catalog.pg_statistic 2 2 5,064 15,497 0 0 2,144 contagem.pg_catalog.pg_statistic 1 1 4,272 7,274 0 0 1,011 rio.pg_catalog.pg_index 15 14 4,245 31,232 2,221 0 925 rio.pg_catalog.pg_class 45 27 3,524 212,499 38,866 33 6,452 template1.pg_catalog.pg_shdepend 4 4 2,735 54,370 74 0 460 postgres.pg_catalog.pg_shdepend 3 3 2,732 41,274 440 0 345 brasilia.pg_catalog.pg_depend 2 2 1,446 35,757 0 0 358 brasilia.pg_catalog.pg_type 6 6 1,411 13,300 20 4 379 brasilia.pg_catalog.pg_class 8 8 1,410 27,027 0 0 952 rio.public.tmp_drill_0175 2 2 1,076 1,899 0 0 50 rio.pg_toast.pg_toast_2619 3 3 949 2,004 4 0 780 brasilia.pg_catalog.pg_index 3 3 874 5,635 0 0 159 contagem.pg_catalog.pg_type 4 4 812 8,998 0 21 266 contagem.pg_catalog.pg_class 4 4 762 13,890 8 11 521 contagem.pg_catalog.pg_depend 2 2 724 37,805 0 0 351 contagem.public.usuarios 12 0 701 276 0 0 24 contagem.pg_catalog.pg_index 2 2 470 3,794 0 5 101 contagem.public.nf_entrada 2 2 330 2,373 0 0 138 rio.public.usuarios 15 5 257 9,997 2,362 1 246 brasilia.pg_toast.pg_toast_2619 2 2 174 275 0 0 118 contagem.pg_toast.pg_toast_2619 1 1 100 121 0 0 53 rio.public.temp0000285806 2 0 0 24,979 0 50 1,742 rio.public.logs 1 0 0 16,154,388 0 0 645,455 rio.public.temp0000285880 1 0 0 1,669 0 44 84 rio.public.temp0000285404 4 0 0 14,055 0 188 324 rio.public.temp0000285820 2 0 0 2,941 0 29 67 rio.public.temp0000285906 11 0 0 257,899 0 0 18,304 rio.public.temp0000285770 3 0 0 10,408 0 80 240 rio.public.temp0000285878 1 0 0 1,643 0 44 84 contagem.public.temp0000226612 1 0 0 1,276 0 30 98 rio.public.temp0000284750 13 0 0 34,386 0 363 757 brasilia.public.temp0000236458 1 0 0 3,115 0 22 234 rio.public.temp0000285824 2 0 0 3,127 0 100 156 brasilia.public.temp0000236452 1 0 0 3,115 0 22 234 brasilia.public.temp0000236524 1 0 0 3,118 0 22 234 rio.public.temp0000285866 12 0 0 281,127 0 0 19,968 rio.public.temp0000285814 1 0 0 1,563 0 50 78 rio.public.temp0000285854 3 0 0 70,245 0 0 4,992 brasilia.public.temp0000236504 1 0 0 3,118 0 22 234 rio.public.temp0000285838 1 0 0 23,410 0 0 1,664 rio.public.temp0000285874 1 0 0 3,080 0 57 71 rio.public.temp0000285812 2 0 0 4,821 0 81 111 contagem.auditor.auditor_2026_07 1 0 0 2,139,294 0 0 90,399 rio.public.temp0000285862 1 0 0 1,627 0 46 82 rio.public.temp0000285882 1 0 0 23,424 0 0 1,664 rio.public.temp0000285808 2 0 0 5,486 0 34 126 rio.public.temp0000285868 17 0 0 108,682 0 618 6,166 rio.public.temp0000285810 3 0 0 48,374 0 50 3,406 contagem.public.temp0000226658 1 0 0 1,273 0 31 97 rio.public.temp0000285918 3 0 0 70,343 0 0 4,992 rio.public.temp0000285916 1 0 0 1,865 0 35 93 contagem.public.temp0000226664 5 0 0 6,150 0 148 428 rio.public.temp0000285796 50 0 0 844,533 0 676 59,484 rio.public.temp0000285900 4 0 0 93,738 0 0 6,656 rio.public.temp0000285832 1 0 0 1,565 0 50 78 contagem.public.temp0000226660 16 0 0 20,371 0 496 1,552 contagem.public.temp0000226662 2 0 0 2,548 0 62 194 Total 456 208 352,304 23,448,814 295,727 3,695 955,921 Pages removed per table
Key values
- public.temp0000285796 (676) Main table with removed pages on database rio
- 3695 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000285796 50 0 0 676 rio.public.temp0000285868 17 0 0 618 contagem.public.temp0000226660 16 0 0 496 rio.public.temp0000284750 13 0 0 363 rio.public.temp0000285404 4 0 0 188 contagem.public.temp0000226664 5 0 0 148 contagem.pg_catalog.pg_attribute 6 6 24981 112 rio.public.temp0000285824 2 0 0 100 rio.public.temp0000285812 2 0 0 81 rio.public.temp0000285770 3 0 0 80 contagem.public.temp0000226662 2 0 0 62 rio.pg_catalog.pg_attribute 65 44 187642 58 rio.public.temp0000285874 1 0 0 57 rio.public.temp0000285806 2 0 0 50 rio.public.temp0000285814 1 0 0 50 rio.public.temp0000285810 3 0 0 50 rio.public.temp0000285832 1 0 0 50 rio.public.temp0000285862 1 0 0 46 rio.public.temp0000285880 1 0 0 44 rio.public.temp0000285878 1 0 0 44 rio.public.temp0000285916 1 0 0 35 rio.public.temp0000285808 2 0 0 34 rio.pg_catalog.pg_class 45 27 3524 33 contagem.public.temp0000226658 1 0 0 31 contagem.public.temp0000226612 1 0 0 30 rio.public.temp0000285820 2 0 0 29 brasilia.public.temp0000236458 1 0 0 22 brasilia.public.temp0000236452 1 0 0 22 brasilia.public.temp0000236524 1 0 0 22 brasilia.public.temp0000236504 1 0 0 22 contagem.pg_catalog.pg_type 4 4 812 21 contagem.pg_catalog.pg_class 4 4 762 11 contagem.pg_catalog.pg_index 2 2 470 5 brasilia.pg_catalog.pg_type 6 6 1411 4 rio.public.usuarios 15 5 257 1 rio.public.logs 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 100 0 rio.pg_catalog.pg_statistic 7 7 12407 0 brasilia.pg_catalog.pg_class 8 8 1410 0 rio.pg_catalog.pg_index 15 14 4245 0 rio.public.temp0000285906 11 0 0 0 template1.pg_catalog.pg_shdepend 4 4 2735 0 brasilia.pg_catalog.pg_statistic 2 2 5064 0 brasilia.pg_toast.pg_toast_2619 2 2 174 0 rio.pg_toast.pg_toast_2619 3 3 949 0 contagem.pg_catalog.pg_depend 2 2 724 0 rio.public.temp0000285866 12 0 0 0 contagem.public.nf_entrada 2 2 330 0 brasilia.pg_catalog.pg_attribute 14 14 51472 0 rio.public.temp0000285854 3 0 0 0 brasilia.pg_catalog.pg_index 3 3 874 0 brasilia.pg_catalog.pg_depend 2 2 1446 0 rio.public.temp0000285838 1 0 0 0 rio.public.tmp_drill_0302 3 3 21941 0 contagem.auditor.auditor_2026_07 1 0 0 0 postgres.pg_catalog.pg_shdepend 3 3 2732 0 contagem.pg_catalog.pg_statistic 1 1 4272 0 rio.public.temp0000285882 1 0 0 0 rio.pg_catalog.pg_type 37 25 8333 0 contagem.public.usuarios 12 0 701 0 rio.public.temp0000285918 3 0 0 0 rio.public.temp0000285900 4 0 0 0 rio.public.tmp_drill_0175 2 2 1076 0 rio.pg_catalog.pg_depend 13 12 11460 0 Total 456 208 352,304 3,695 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 20 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 1 07 12 19 08 27 71 09 29 86 10 40 92 11 48 104 12 11 39 13 46 70 14 37 99 15 119 162 16 23 90 17 56 64 18 1 1 19 0 0 20 0 0 21 1 3 22 0 0 23 0 0 - 5.47 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m9s 2m9s 2m9s 2m9s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 11:07:24 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 00:05:23 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 09:45:30 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 1 34s745ms 34s745ms 34s745ms 34s745ms call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 15:55:44 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 07:35:13 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 09:45:13 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 1 1s571ms 1s571ms 1s571ms 1s571ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027272);
Date: 2026-07-20 10:47:50 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027295);
Date: 2026-07-20 15:20:58 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027282);
Date: 2026-07-20 13:57:05 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000285868;-
DROP TABLE IF EXISTS temp0000285868;
Date: 2026-07-20 15:36:50 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
DROP TABLE IF EXISTS temp0000285868;
Date: 2026-07-20 15:36:50 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Queries that waited the most
Rank Wait time Query 1 2m9s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-20 11:07:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 34s745ms CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-07-20 15:55:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s571ms SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027296);[ Date: 2026-07-20 15:20:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 1s1ms DROP TABLE IF EXISTS temp0000285868;[ Date: 2026-07-20 15:36:50 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,904 Total read queries
- 1,457 Total write queries
Queries by database
Key values
- rio Main database
- 4,635 Requests
- 8h10m57s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,500 Requests
User Request type Count Duration etiquetas Total 74 18s844ms select 74 18s844ms intelifix Total 7,500 14h21m42s copy to 814 1h25m7s ddl 1,044 53m28s others 791 1h17m27s select 4,850 10h45m38s lenon Total 122 2m32s select 121 2m32s update 1 177ms Duration by user
Key values
- 14h21m42s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 74 18s844ms select 74 18s844ms intelifix Total 7,500 14h21m42s copy to 814 1h25m7s ddl 1,044 53m28s others 791 1h17m27s select 4,850 10h45m38s lenon Total 122 2m32s select 121 2m32s update 1 177ms Queries by host
Key values
- [local] Main host
- 7,693 Requests
- 14h24m7s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,713 Requests
- 5h16m35s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-20 14:35:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,218 100-500ms duration
Slowest individual queries
Rank Duration Query 1 14m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 16:19:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 13m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 07:18:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 13m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 09:18:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 12m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 20:17:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 12m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 17:17:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 10m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 18:15:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 10m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 14:15:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 10m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 15:15:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 10m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 11:15:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 10m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 12:15:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 10m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-20 10:15:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 9m15s analyze verbose;[ Date: 2026-07-20 05:09:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 8m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027266, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-20 10:03:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 8m47s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027305, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-20 15:55:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 8m14s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2025-01-01''),DATE(''2025-01-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');[ Date: 2026-07-20 15:07:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 8m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027283, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-20 14:29:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 7m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027286, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-20 15:16:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 7m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-19'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-07-20 13:45:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 7m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027255, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-20 07:28:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027260, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-20 09:10:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h47m40s 47 1s328ms 14m11s 3m34s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 20 07 3 14m37s 4m52s 08 3 6m56s 2m18s 09 3 14m27s 4m49s 10 3 10m31s 3m30s 11 3 10m46s 3m35s 12 3 10m52s 3m37s 13 3 6m13s 2m4s 14 3 11m18s 3m46s 15 3 11m18s 3m46s 16 3 14m52s 4m57s 17 3 12m49s 4m16s 18 3 11m13s 3m44s 19 3 6m15s 2m5s 20 2 12m54s 6m27s 21 3 6m39s 2m13s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 2h47m40s - Times executed: 47 ]
[ Application: psql - Total duration: 2h47m40s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-20 16:19:13 Duration: 14m11s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-20 07:18:55 Duration: 13m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-20 09:18:48 Duration: 13m46s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 2h23m3s 342 151ms 8m47s 25s98ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 20 07 31 16m34s 32s94ms 08 24 1m34s 3s952ms 09 27 14m5s 31s331ms 10 31 21m5s 40s806ms 11 23 11m46s 30s729ms 12 19 6m30s 20s546ms 13 15 9m16s 37s84ms 14 35 9m57s 17s75ms 15 68 43m48s 38s649ms 16 43 1m40s 2s332ms 17 26 6m43s 15s512ms [ User: intelifix - Total duration: 2h23m3s - Times executed: 342 ]
[ Application: [unknown] - Total duration: 2h23m3s - Times executed: 342 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027266, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-20 10:03:52 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027305, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-20 15:55:40 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2025-01-01''),DATE(''2025-01-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-20 15:07:04 Duration: 8m14s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 1h22m1s 48 283ms 5m9s 1m42s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 20 07 3 5m29s 1m49s 08 3 3m55s 1m18s 09 3 6m43s 2m14s 10 3 5m31s 1m50s 11 3 5m12s 1m44s 12 3 4m54s 1m38s 13 3 4m3s 1m21s 14 3 5m25s 1m48s 15 3 6m23s 2m7s 16 3 6m25s 2m8s 17 3 5m55s 1m58s 18 3 4m37s 1m32s 19 3 4m 1m20s 20 3 5m20s 1m46s 21 3 3m51s 1m17s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h22m1s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m1s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-20 15:22:29 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-20 09:26:02 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-20 16:26:15 Duration: 4m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 28m41s 1,321 150ms 8s368ms 1s302ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 20 07 2 869ms 434ms 08 63 52s696ms 836ms 09 126 3m29s 1s660ms 10 206 4m23s 1s281ms 11 165 3m16s 1s193ms 12 72 1m40s 1s394ms 13 108 2m9s 1s197ms 14 194 4m7s 1s274ms 15 205 4m7s 1s209ms 16 118 3m12s 1s627ms 17 62 1m20s 1s293ms [ User: intelifix - Total duration: 28m41s - Times executed: 1321 ]
[ Application: [unknown] - Total duration: 28m41s - Times executed: 1321 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267742, 508, 'CP2127LV0FN,08A7C077093C$CP2120LV4HH,08A7C06C839C$CP2203LV0M3,1C9D726BBEC4$CP2120LV2VN,08A7C06BFD74$CP2301LV3FR,B85E71E636D8$CP2228LV10J,4075C32867B8$CP2203LV0AW,1C9D7269EB9C$CP2134LV2TG,ECA81F22463C$CP2120LV012,08A7C06BA44C$CP2301LV614,B85E71E6A258$CP2204LV0P2,1C9D726BC08C$CP2134LV5LD,ECA81F23D2FC$CP2125LV25Y,08A7C0712304$CP2242LV5VT,B85E71C83160$CP2125LV5SY,08A7C071AA7C$CP2534LV1M7,3C82C0905820$CP2239LVRST,B85E71BE4204$CP2528LVCTC,F8D2AC4C65D0$CP2439LV7WW,C4509CF4235C$CP2435LV03W,C4509CF14444$CP2528LV34G,F8D2AC49DC98$CP2134LV5SC,ECA81F233D2C$CP2239LV1HA,4075C3C32C8C$CP2534LV31Q,3C82C090C2D8$CP2527LV91H,F8D2AC490D2C$CP2531LV2T7,3C82C08D3B2C$CP2051LV43T,08A7C070679C$CP2242LVAHM,B85E71CCB618$CP2302LV7Z1,B85E71EA4B4C$CP2531LV12F,3C82C08DE52C$CP2139LV772,ECA81F6D45C4$CP2534LV2TS,3C82C090EFC4$CP2231LV28M,4075C32973B0$CP2534LV31P,3C82C090C224$CP2048LV57W,484BD4930614$CP2528LVCJE,F8D2AC4C818C$CP2436LV3CR,C4509CF359B4$CP2527LV90R,F8D2AC490D04$CP2239LVEYK,B85E71BA8754$CP2133LV0U3,ECA81F1FA564', '',0185,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-07-20 16:58:20 Duration: 8s368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267733, 450, '73917785850068803145,229714269813,229640316366,229766201829,229733392140,229704041419,229728846768,229716706975,229693783448,229701333545,229766310022,229714397075,229641828703,229831974151,229640374958,229678645169,229714157478,229777871520,229715005676,229677095152,229696114764,229826570628,229695435068,229775048607,229708674553,229732691836,229702307994,229824817885,229800732438,229641307181,229708992340,229638688687,229767585869,229707174463,229766377883,216927066063,229695750408,229641341125', '246553029510,246487719107,246555397901,246565636172,246505024769,246551764145,246552337893,246500712429,246521366666,246554267980,246553021934,246481200918,246644817289,226310992948,246459455473,226208444668,246595504755,246535637172,246459137888,246513199910,246623447291,246500716368,246506971323,246538132445,246565461330,246535523043,246624539003,246614004664,246480129208,246537503337,246449480011,246554861934,246539037190,246556590610,246451065058,246501301735,246481885058,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-20 13:43:28 Duration: 7s861ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267733, 450, '73903585850065105183,229676147596,229678335767,229732797580,229833820819,229713007781,229646158294,229826279510,229823977085,229695865469,229827253253,229678628298,229712810614,229707321930,229774790120,229678029395,229708255567,229798556568,229733170222,216949655664,229701476162,229646275152,229778564752,229704861432,229716183434,229778419710,229825747280,229704948790,229694330202,229694506582,229728711627,229733623352,229729451531,229700675164,229704944043,229676554662,229707323647,229827469817,216927562431,229793109707', '246460341834,246493275474,246568765254,246183356069,246346275370,246537767178,246623710000,246623245375,246509182425,246636398487,246460569308,246593279308,246538068701,246575699297,246459213755,246538435661,246616821718,246566921214,246448213355,246507996484,246466445459,246595248792,246507837074,246550448292,246595210204,226053119913,246507839296,246500690609,246534492628,246551281315,246565401324,246565937492,246503716066,246507842833,246489898791,246541828406,246626099199,246451746370,246601665760,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-20 11:13:13 Duration: 7s844ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 16m54s 78 9s595ms 51s974ms 13s3ms create table temp0000285796 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 20 07 16 3m23s 12s694ms 09 20 4m37s 13s863ms 10 9 1m49s 12s135ms 11 11 2m17s 12s520ms 12 2 24s824ms 12s412ms 14 2 26s164ms 13s82ms 15 18 3m56s 13s111ms [ User: intelifix - Total duration: 16m54s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 16m54s - Times executed: 78 ]
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 09:53:12 Duration: 51s974ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 07:18:40 Duration: 47s831ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:45:06 Duration: 15s498ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 15m28s 3 2m21s 9m15s 5m9s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 20 05 3 15m28s 5m9s [ User: intelifix - Total duration: 15m28s - Times executed: 3 ]
[ Application: psql - Total duration: 15m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-20 05:09:16 Duration: 9m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-07-20 05:13:07 Duration: 3m51s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-07-20 05:15:29 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 14m31s 271 155ms 2m16s 3s217ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 20 00 12 44s810ms 3s734ms 01 11 25s271ms 2s297ms 02 11 26s145ms 2s376ms 03 10 21s533ms 2s153ms 04 12 26s370ms 2s197ms 05 12 25s465ms 2s122ms 06 11 24s831ms 2s257ms 07 12 27s602ms 2s300ms 08 12 33s278ms 2s773ms 09 12 49s588ms 4s132ms 10 12 38s118ms 3s176ms 11 12 2m44s 13s672ms 12 12 31s562ms 2s630ms 13 12 30s887ms 2s573ms 14 12 36s897ms 3s74ms 15 12 45s556ms 3s796ms 16 12 33s397ms 2s783ms 17 12 33s207ms 2s767ms 18 12 28s545ms 2s378ms 19 12 28s299ms 2s358ms 20 12 40s588ms 3s382ms 21 12 27s915ms 2s326ms 22 12 28s41ms 2s336ms [ User: intelifix - Total duration: 14m31s - Times executed: 271 ]
[ Application: psql - Total duration: 14m31s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 11:07:24 Duration: 2m16s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 00:05:23 Duration: 21s111ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 09:45:30 Duration: 17s171ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 12m46s 1,051 150ms 7s392ms 729ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 20 08 128 1m50s 864ms 09 143 1m36s 674ms 10 132 1m41s 771ms 11 135 1m28s 656ms 12 12 6s434ms 536ms 13 72 58s600ms 813ms 14 149 1m46s 717ms 15 112 1m25s 764ms 16 134 1m33s 699ms 17 34 18s120ms 532ms [ User: intelifix - Total duration: 12m46s - Times executed: 1051 ]
[ Application: [unknown] - Total duration: 12m46s - Times executed: 1051 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "62", "itens" : "216837005467,216802388485,216836786276,184332078604,216910263335,216812149910,216336108805,216396962533,216612112240,216513681433,216703345767", "usuario" : "414", "caixa" : "2727517", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-20 13:25:53 Duration: 7s392ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "128690", "modelo" : "39", "itens" : "E820E271966D,E820E20C42D3,90F305577D6F,8C444F1ECA11,8C444FA81380,8C444F5AEE95,942CB37AD2AA,942CB3DF5610,8C444F16745A,11733185850048601059", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "emilly[[tela]]" }');
Date: 2026-07-20 09:41:10 Duration: 4s704ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "268166", "modelo" : "464", "itens" : "241743321738,241770245173,241742719400,241759475962,241768767587,241764397587,241742708489,241760035871,241743181017,241767540005,241740930719,241744001535,241763831921,241760805172,241739034955,241741060103,241743596264,241759802437,241740930113,241740915161,241742406788,241765242429,241764634255,241777881418,241770186682,241767846880,241738796368,241770227999,241769932640,241759537180,241764507474,241767855770,241760237585,241739491622,241778450924,241739592238,241765605876,241779234748,241738690422,241770140012,241742697579,241742665556,241761180215,241771275565,241768691318,241746008497,241762761525,241739389008,241770162337,241767565057,241764417387,241762858100,241745673033,241767800109,241742967280,241738451229,241688006675,241740801234,241764793339,241767736162", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-20 08:05:21 Duration: 4s561ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 12m11s 110 968ms 56s796ms 6s650ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 20 07 2 11s744ms 5s872ms 08 5 10s723ms 2s144ms 09 5 20s647ms 4s129ms 10 10 1m28s 8s803ms 11 11 28s893ms 2s626ms 12 7 9s354ms 1s336ms 13 7 24s234ms 3s462ms 14 12 1m53s 9s440ms 15 24 3m25s 8s570ms 16 13 1m55s 8s919ms 17 14 1m42s 7s355ms [ User: intelifix - Total duration: 12m11s - Times executed: 110 ]
[ Application: [unknown] - Total duration: 12m11s - Times executed: 110 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 10:17:59 Duration: 56s796ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 15:29:51 Duration: 52s105ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 15:06:17 Duration: 37s433ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 12m9s 12 2s354ms 2m4s 1m select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 20 08 1 7s516ms 7s516ms 09 1 3s697ms 3s697ms 10 1 1m30s 1m30s 11 4 6m22s 1m35s 13 3 17s186ms 5s728ms 15 2 3m48s 1m54s [ User: intelifix - Total duration: 12m9s - Times executed: 12 ]
[ Application: psql - Total duration: 12m9s - Times executed: 12 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01574);
Date: 2026-07-20 15:48:25 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01573);
Date: 2026-07-20 15:41:49 Duration: 1m44s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01571);
Date: 2026-07-20 11:34:51 Duration: 1m39s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 9m21s 132 161ms 42s910ms 4s250ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 20 00 2 650ms 325ms 03 1 183ms 183ms 06 3 14s959ms 4s986ms 07 8 47s418ms 5s927ms 08 12 1m8s 5s681ms 09 12 1m3s 5s278ms 10 12 47s204ms 3s933ms 11 12 1m2s 5s196ms 12 12 38s885ms 3s240ms 13 9 14s335ms 1s592ms 14 11 43s175ms 3s925ms 15 12 1m39s 8s258ms 16 11 41s468ms 3s769ms 17 4 3s740ms 935ms 21 5 8s224ms 1s644ms 22 6 7s833ms 1s305ms [ User: intelifix - Total duration: 9m21s - Times executed: 132 ]
[ Application: psql - Total duration: 9m21s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 15:55:44 Duration: 42s910ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 07:35:13 Duration: 11s980ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 09:45:13 Duration: 11s761ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 4m30s 46 169ms 42s121ms 5s890ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 20 07 3 34s464ms 11s488ms 08 1 320ms 320ms 09 4 1m25s 21s354ms 10 6 12s10ms 2s1ms 11 7 20s332ms 2s904ms 12 3 15s951ms 5s317ms 13 5 5s885ms 1s177ms 14 1 20s891ms 20s891ms 15 13 1m12s 5s613ms 17 3 2s716ms 905ms [ User: intelifix - Total duration: 4m30s - Times executed: 46 ]
[ Application: psql - Total duration: 4m30s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027266);
Date: 2026-07-20 09:55:13 Duration: 42s121ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027255);
Date: 2026-07-20 07:21:01 Duration: 30s733ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027260);
Date: 2026-07-20 09:03:11 Duration: 23s185ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 3m56s 18 11s23ms 15s828ms 13s166ms create table temp0000285868 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 20 15 18 3m56s 13s166ms [ User: intelifix - Total duration: 3m56s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 18 ]
-
CREATE TABLE temp0000285868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:28:24 Duration: 15s828ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:34:31 Duration: 15s639ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:34:54 Duration: 14s590ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 3m39s 15 9s747ms 50s916ms 14s608ms create table temp0000285906 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 20 16 3 1m19s 26s648ms 17 12 2m19s 11s598ms [ User: intelifix - Total duration: 3m39s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m39s - Times executed: 15 ]
-
CREATE TABLE temp0000285906 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 16:52:10 Duration: 50s916ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285906 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 17:10:16 Duration: 15s671ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285906 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 16:00:17 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 3m13s 14 10s424ms 24s737ms 13s799ms create table temp0000285866 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 20 12 4 51s367ms 12s841ms 13 3 37s549ms 12s516ms 14 4 1m4s 16s42ms 15 3 40s111ms 13s370ms [ User: intelifix - Total duration: 3m13s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 14 ]
-
CREATE TABLE temp0000285866 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 14:42:31 Duration: 24s737ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285866 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 12:24:51 Duration: 15s812ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285866 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 14:51:11 Duration: 15s349ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 3m12s 4 4s562ms 1m32s 48s191ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 20 20 2 1m37s 48s602ms 23 2 1m35s 47s779ms [ User: intelifix - Total duration: 3m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-20 20:08:44 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-20 23:16:55 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-20 23:35:54 Duration: 4s644ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 3m7s 30 3s17ms 30s40ms 6s263ms create table temp0000285796 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 20 07 4 31s220ms 7s805ms 08 9 32s351ms 3s594ms 11 5 41s683ms 8s336ms 14 4 44s425ms 11s106ms 15 8 38s237ms 4s779ms [ User: intelifix - Total duration: 3m7s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 30 ]
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-07-2026", "ate" :"20-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-20 14:30:33 Duration: 30s40ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-07-2026", "ate" :"20-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-20 11:11:23 Duration: 25s972ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-07-2026", "ate" :"20-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-20 07:29:02 Duration: 21s746ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 2m28s 56 208ms 16s207ms 2s650ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 20 07 6 4s146ms 691ms 09 7 4s189ms 598ms 10 6 29s344ms 4s890ms 11 4 2s170ms 542ms 12 3 8s911ms 2s970ms 13 2 20s209ms 10s104ms 14 2 2s922ms 1s461ms 15 20 52s608ms 2s630ms 16 1 2s552ms 2s552ms 17 5 21s397ms 4s279ms [ User: intelifix - Total duration: 2m28s - Times executed: 56 ]
[ Application: psql - Total duration: 2m28s - Times executed: 56 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027272);
Date: 2026-07-20 10:47:50 Duration: 16s207ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027295);
Date: 2026-07-20 15:20:58 Duration: 14s980ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027282);
Date: 2026-07-20 13:57:05 Duration: 13s939ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 2m22s 34 650ms 11s52ms 4s180ms 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 Jul 20 08 2 10s440ms 5s220ms 09 2 5s971ms 2s985ms 10 3 24s755ms 8s251ms 11 3 20s879ms 6s959ms 12 2 7s632ms 3s816ms 13 3 6s265ms 2s88ms 14 1 8s568ms 8s568ms 15 3 24s591ms 8s197ms 16 1 4s240ms 4s240ms 17 2 16s132ms 8s66ms 18 1 1s95ms 1s95ms 19 3 2s658ms 886ms 20 3 3s928ms 1s309ms 21 2 1s930ms 965ms 22 3 3s46ms 1s15ms [ User: intelifix - Total duration: 2m22s - Times executed: 34 ]
[ Application: psql - Total duration: 2m22s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-20 15:20:12 Duration: 11s52ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-20 10:40:12 Duration: 10s798ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-20 10:00:11 Duration: 10s244ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 2m10s 4 389ms 1m5s 32s583ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 20 20 2 1m4s 32s21ms 23 2 1m6s 33s144ms [ User: intelifix - Total duration: 2m10s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m10s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-20 23:13:38 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-20 20:05:30 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-20 23:35:23 Duration: 446ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,321 28m41s 150ms 8s368ms 1s302ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 20 07 2 869ms 434ms 08 63 52s696ms 836ms 09 126 3m29s 1s660ms 10 206 4m23s 1s281ms 11 165 3m16s 1s193ms 12 72 1m40s 1s394ms 13 108 2m9s 1s197ms 14 194 4m7s 1s274ms 15 205 4m7s 1s209ms 16 118 3m12s 1s627ms 17 62 1m20s 1s293ms [ User: intelifix - Total duration: 28m41s - Times executed: 1321 ]
[ Application: [unknown] - Total duration: 28m41s - Times executed: 1321 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267742, 508, 'CP2127LV0FN,08A7C077093C$CP2120LV4HH,08A7C06C839C$CP2203LV0M3,1C9D726BBEC4$CP2120LV2VN,08A7C06BFD74$CP2301LV3FR,B85E71E636D8$CP2228LV10J,4075C32867B8$CP2203LV0AW,1C9D7269EB9C$CP2134LV2TG,ECA81F22463C$CP2120LV012,08A7C06BA44C$CP2301LV614,B85E71E6A258$CP2204LV0P2,1C9D726BC08C$CP2134LV5LD,ECA81F23D2FC$CP2125LV25Y,08A7C0712304$CP2242LV5VT,B85E71C83160$CP2125LV5SY,08A7C071AA7C$CP2534LV1M7,3C82C0905820$CP2239LVRST,B85E71BE4204$CP2528LVCTC,F8D2AC4C65D0$CP2439LV7WW,C4509CF4235C$CP2435LV03W,C4509CF14444$CP2528LV34G,F8D2AC49DC98$CP2134LV5SC,ECA81F233D2C$CP2239LV1HA,4075C3C32C8C$CP2534LV31Q,3C82C090C2D8$CP2527LV91H,F8D2AC490D2C$CP2531LV2T7,3C82C08D3B2C$CP2051LV43T,08A7C070679C$CP2242LVAHM,B85E71CCB618$CP2302LV7Z1,B85E71EA4B4C$CP2531LV12F,3C82C08DE52C$CP2139LV772,ECA81F6D45C4$CP2534LV2TS,3C82C090EFC4$CP2231LV28M,4075C32973B0$CP2534LV31P,3C82C090C224$CP2048LV57W,484BD4930614$CP2528LVCJE,F8D2AC4C818C$CP2436LV3CR,C4509CF359B4$CP2527LV90R,F8D2AC490D04$CP2239LVEYK,B85E71BA8754$CP2133LV0U3,ECA81F1FA564', '',0185,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-07-20 16:58:20 Duration: 8s368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267733, 450, '73917785850068803145,229714269813,229640316366,229766201829,229733392140,229704041419,229728846768,229716706975,229693783448,229701333545,229766310022,229714397075,229641828703,229831974151,229640374958,229678645169,229714157478,229777871520,229715005676,229677095152,229696114764,229826570628,229695435068,229775048607,229708674553,229732691836,229702307994,229824817885,229800732438,229641307181,229708992340,229638688687,229767585869,229707174463,229766377883,216927066063,229695750408,229641341125', '246553029510,246487719107,246555397901,246565636172,246505024769,246551764145,246552337893,246500712429,246521366666,246554267980,246553021934,246481200918,246644817289,226310992948,246459455473,226208444668,246595504755,246535637172,246459137888,246513199910,246623447291,246500716368,246506971323,246538132445,246565461330,246535523043,246624539003,246614004664,246480129208,246537503337,246449480011,246554861934,246539037190,246556590610,246451065058,246501301735,246481885058,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-20 13:43:28 Duration: 7s861ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267733, 450, '73903585850065105183,229676147596,229678335767,229732797580,229833820819,229713007781,229646158294,229826279510,229823977085,229695865469,229827253253,229678628298,229712810614,229707321930,229774790120,229678029395,229708255567,229798556568,229733170222,216949655664,229701476162,229646275152,229778564752,229704861432,229716183434,229778419710,229825747280,229704948790,229694330202,229694506582,229728711627,229733623352,229729451531,229700675164,229704944043,229676554662,229707323647,229827469817,216927562431,229793109707', '246460341834,246493275474,246568765254,246183356069,246346275370,246537767178,246623710000,246623245375,246509182425,246636398487,246460569308,246593279308,246538068701,246575699297,246459213755,246538435661,246616821718,246566921214,246448213355,246507996484,246466445459,246595248792,246507837074,246550448292,246595210204,226053119913,246507839296,246500690609,246534492628,246551281315,246565401324,246565937492,246503716066,246507842833,246489898791,246541828406,246626099199,246451746370,246601665760,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-20 11:13:13 Duration: 7s844ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 1,051 12m46s 150ms 7s392ms 729ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 20 08 128 1m50s 864ms 09 143 1m36s 674ms 10 132 1m41s 771ms 11 135 1m28s 656ms 12 12 6s434ms 536ms 13 72 58s600ms 813ms 14 149 1m46s 717ms 15 112 1m25s 764ms 16 134 1m33s 699ms 17 34 18s120ms 532ms [ User: intelifix - Total duration: 12m46s - Times executed: 1051 ]
[ Application: [unknown] - Total duration: 12m46s - Times executed: 1051 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "62", "itens" : "216837005467,216802388485,216836786276,184332078604,216910263335,216812149910,216336108805,216396962533,216612112240,216513681433,216703345767", "usuario" : "414", "caixa" : "2727517", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-20 13:25:53 Duration: 7s392ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "128690", "modelo" : "39", "itens" : "E820E271966D,E820E20C42D3,90F305577D6F,8C444F1ECA11,8C444FA81380,8C444F5AEE95,942CB37AD2AA,942CB3DF5610,8C444F16745A,11733185850048601059", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "emilly[[tela]]" }');
Date: 2026-07-20 09:41:10 Duration: 4s704ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "268166", "modelo" : "464", "itens" : "241743321738,241770245173,241742719400,241759475962,241768767587,241764397587,241742708489,241760035871,241743181017,241767540005,241740930719,241744001535,241763831921,241760805172,241739034955,241741060103,241743596264,241759802437,241740930113,241740915161,241742406788,241765242429,241764634255,241777881418,241770186682,241767846880,241738796368,241770227999,241769932640,241759537180,241764507474,241767855770,241760237585,241739491622,241778450924,241739592238,241765605876,241779234748,241738690422,241770140012,241742697579,241742665556,241761180215,241771275565,241768691318,241746008497,241762761525,241739389008,241770162337,241767565057,241764417387,241762858100,241745673033,241767800109,241742967280,241738451229,241688006675,241740801234,241764793339,241767736162", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-20 08:05:21 Duration: 4s561ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 342 2h23m3s 151ms 8m47s 25s98ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 20 07 31 16m34s 32s94ms 08 24 1m34s 3s952ms 09 27 14m5s 31s331ms 10 31 21m5s 40s806ms 11 23 11m46s 30s729ms 12 19 6m30s 20s546ms 13 15 9m16s 37s84ms 14 35 9m57s 17s75ms 15 68 43m48s 38s649ms 16 43 1m40s 2s332ms 17 26 6m43s 15s512ms [ User: intelifix - Total duration: 2h23m3s - Times executed: 342 ]
[ Application: [unknown] - Total duration: 2h23m3s - Times executed: 342 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027266, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-20 10:03:52 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027305, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-20 15:55:40 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2025-01-01''),DATE(''2025-01-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-20 15:07:04 Duration: 8m14s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 271 14m31s 155ms 2m16s 3s217ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 20 00 12 44s810ms 3s734ms 01 11 25s271ms 2s297ms 02 11 26s145ms 2s376ms 03 10 21s533ms 2s153ms 04 12 26s370ms 2s197ms 05 12 25s465ms 2s122ms 06 11 24s831ms 2s257ms 07 12 27s602ms 2s300ms 08 12 33s278ms 2s773ms 09 12 49s588ms 4s132ms 10 12 38s118ms 3s176ms 11 12 2m44s 13s672ms 12 12 31s562ms 2s630ms 13 12 30s887ms 2s573ms 14 12 36s897ms 3s74ms 15 12 45s556ms 3s796ms 16 12 33s397ms 2s783ms 17 12 33s207ms 2s767ms 18 12 28s545ms 2s378ms 19 12 28s299ms 2s358ms 20 12 40s588ms 3s382ms 21 12 27s915ms 2s326ms 22 12 28s41ms 2s336ms [ User: intelifix - Total duration: 14m31s - Times executed: 271 ]
[ Application: psql - Total duration: 14m31s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 11:07:24 Duration: 2m16s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 00:05:23 Duration: 21s111ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 09:45:30 Duration: 17s171ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 228 1m14s 150ms 2s231ms 325ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 20 09 228 1m14s 325ms [ User: intelifix - Total duration: 1m14s - Times executed: 228 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 228 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46986","seriais":"2CD8AE4FC695,2CD8AE4FE7AB,2CD8AE4FC556,2CD8AE4FCF0C,2CD8AE4F7B2C,2CD8AE4FC648,2CD8AE4FB73E,2CD8AE4FCFBC,2CD8AE4FC745,2CD8AE4FBE55,2CD8AE4FA8C3","usuario":"416","observacao":""}');
Date: 2026-07-20 09:09:12 Duration: 2s231ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46986","seriais":"241676663234,241671993553,241679910207,241695585260,241676633759,241704374457,241703818184,241704268688,241663849301,241704257778,241654362326,241714931728,241629525356,241597540911,241714926070,241680315577,241713716670,241728730516,241604788700,241649653651,241695594049,241695611223,241646327175,241605360204,241659722939,241622547189,241599300522,241598814761,241656687681,241727021415","usuario":"416","observacao":""}');
Date: 2026-07-20 09:11:31 Duration: 1s439ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46986","seriais":"3891484A57E3,6C11BA6C6D9B,6C11BA6F0213,3CF9F0AFB19C,F4E84F8A7928,C4EBFF8F01CC,14CA56CE4BA5,14CA56D28837,843C9921F13D,D89A0DAC6555,F4E84F8701E8,5872C9952AE1,C4EBFF88ECAE,6C11BA692AAB,14CA56D28B1F,6C11BA67507B,D89A0DA8B43D,D83139936B24,F4E84F80CB40,6C11BA692A27,48D682323632,D8313990203C,D89A0DA6E1A5,6C11BA67DC85,5872C99365F3,389148510115,C4EBFF8F2BFC,D831399D0CA6","usuario":"416","observacao":""}');
Date: 2026-07-20 09:10:43 Duration: 1s369ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 186 30s151ms 150ms 220ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 20 07 2 318ms 159ms 08 14 2s273ms 162ms 09 35 5s649ms 161ms 10 24 3s950ms 164ms 11 16 2s535ms 158ms 12 3 456ms 152ms 13 12 1s895ms 157ms 14 24 3s900ms 162ms 15 22 3s597ms 163ms 16 29 4s754ms 163ms 17 5 819ms 163ms [ User: intelifix - Total duration: 30s151ms - Times executed: 186 ]
[ Application: [unknown] - Total duration: 30s151ms - Times executed: 186 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-07-20 09:42:34 Duration: 220ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-07-20 10:36:56 Duration: 219ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-07-20 16:09:02 Duration: 195ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 179 58s368ms 150ms 1s53ms 326ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 20 07 18 6s537ms 363ms 08 22 8s581ms 390ms 09 23 10s506ms 456ms 10 21 5s992ms 285ms 11 21 6s600ms 314ms 12 19 5s562ms 292ms 13 2 326ms 163ms 14 18 4s554ms 253ms 15 28 8s172ms 291ms 16 7 1s535ms 219ms [ User: intelifix - Total duration: 58s368ms - Times executed: 179 ]
[ Application: [unknown] - Total duration: 58s368ms - Times executed: 179 ]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230035447173,229985844454,230010769210,229990621621,230026319908,230027127091', NULL, NULL, 0295, 00);
Date: 2026-07-20 09:41:13 Duration: 1s53ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_TRIAGEM (403, 5, '70', 2, '229963283139,230053637276,229964629296,230022074870,229976118487,230019614147,229968555460,230051188800,229987729004,229990405763', NULL, NULL, 0295, 00);
Date: 2026-07-20 08:52:02 Duration: 837ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230001057386,230044514759,230047051528,230014045253,230044513850,229986554961,229976940017,229977685375,230031495273,229990267085', NULL, NULL, 0295, 00);
Date: 2026-07-20 08:42:16 Duration: 810ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 138 47s439ms 150ms 6s646ms 343ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 20 07 1 198ms 198ms 08 7 4s861ms 694ms 09 6 1s407ms 234ms 10 3 539ms 179ms 11 8 2s8ms 251ms 12 7 2s199ms 314ms 13 2 316ms 158ms 14 12 3s101ms 258ms 15 34 19s900ms 585ms 16 35 6s683ms 190ms 17 23 6s224ms 270ms [ User: intelifix - Total duration: 47s439ms - Times executed: 138 ]
[ Application: [unknown] - Total duration: 47s439ms - Times executed: 138 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-20", "data-ate" : "2026-07-20", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-07-20 15:32:53 Duration: 6s646ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-20", "data-ate" : "2026-07-20", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-07-20 15:33:15 Duration: 5s127ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-07-17", "data-ate" : "2026-07-17", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-07-20 08:55:45 Duration: 1s222ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 132 9m21s 161ms 42s910ms 4s250ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 20 00 2 650ms 325ms 03 1 183ms 183ms 06 3 14s959ms 4s986ms 07 8 47s418ms 5s927ms 08 12 1m8s 5s681ms 09 12 1m3s 5s278ms 10 12 47s204ms 3s933ms 11 12 1m2s 5s196ms 12 12 38s885ms 3s240ms 13 9 14s335ms 1s592ms 14 11 43s175ms 3s925ms 15 12 1m39s 8s258ms 16 11 41s468ms 3s769ms 17 4 3s740ms 935ms 21 5 8s224ms 1s644ms 22 6 7s833ms 1s305ms [ User: intelifix - Total duration: 9m21s - Times executed: 132 ]
[ Application: psql - Total duration: 9m21s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 15:55:44 Duration: 42s910ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 07:35:13 Duration: 11s980ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 09:45:13 Duration: 11s761ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 120 51s257ms 246ms 1s399ms 427ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 20 07 3 1s196ms 398ms 08 9 3s148ms 349ms 09 13 6s637ms 510ms 10 12 4s465ms 372ms 11 9 3s395ms 377ms 12 7 2s695ms 385ms 13 13 5s154ms 396ms 14 11 5s931ms 539ms 15 21 9s18ms 429ms 16 10 4s654ms 465ms 17 12 4s960ms 413ms [ User: intelifix - Total duration: 51s257ms - Times executed: 120 ]
[ Application: [unknown] - Total duration: 51s257ms - Times executed: 120 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-20 09:51:11 Duration: 1s399ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-07-20 14:17:31 Duration: 1s162ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-20 14:41:27 Duration: 1s107ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 117 24s82ms 150ms 854ms 205ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 20 07 29 5s889ms 203ms 08 5 1s25ms 205ms 09 17 3s604ms 212ms 10 6 1s149ms 191ms 11 13 2s223ms 171ms 12 5 929ms 185ms 13 4 817ms 204ms 14 12 2s191ms 182ms 15 9 1s972ms 219ms 16 9 1s746ms 194ms 17 4 937ms 234ms 20 1 440ms 440ms 21 2 301ms 150ms 23 1 854ms 854ms [ User: intelifix - Total duration: 24s82ms - Times executed: 117 ]
[ Application: [unknown] - Total duration: 24s82ms - Times executed: 117 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229679905864');
Date: 2026-07-20 23:26:08 Duration: 854ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229999556970');
Date: 2026-07-20 20:59:47 Duration: 440ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('CCF3C846EDDC');
Date: 2026-07-20 07:13:59 Duration: 352ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 110 12m11s 968ms 56s796ms 6s650ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 20 07 2 11s744ms 5s872ms 08 5 10s723ms 2s144ms 09 5 20s647ms 4s129ms 10 10 1m28s 8s803ms 11 11 28s893ms 2s626ms 12 7 9s354ms 1s336ms 13 7 24s234ms 3s462ms 14 12 1m53s 9s440ms 15 24 3m25s 8s570ms 16 13 1m55s 8s919ms 17 14 1m42s 7s355ms [ User: intelifix - Total duration: 12m11s - Times executed: 110 ]
[ Application: [unknown] - Total duration: 12m11s - Times executed: 110 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 10:17:59 Duration: 56s796ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 15:29:51 Duration: 52s105ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 15:06:17 Duration: 37s433ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 106 1m39s 159ms 3s810ms 937ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 20 07 25 27s584ms 1s103ms 08 10 8s857ms 885ms 09 2 1s166ms 583ms 10 8 8s303ms 1s37ms 11 6 6s996ms 1s166ms 12 8 9s184ms 1s148ms 14 7 7s786ms 1s112ms 15 16 15s553ms 972ms 16 24 13s920ms 580ms [ User: intelifix - Total duration: 1m39s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 1m39s - Times executed: 106 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267757) LIMIT 1;
Date: 2026-07-20 07:08:46 Duration: 3s810ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267520) LIMIT 1;
Date: 2026-07-20 07:48:40 Duration: 3s513ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128418) LIMIT 1;
Date: 2026-07-20 15:14:14 Duration: 3s447ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 106 48s276ms 263ms 791ms 455ms 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 #14
Day Hour Count Duration Avg duration Jul 20 06 1 419ms 419ms 07 5 2s113ms 422ms 08 9 3s525ms 391ms 09 13 6s196ms 476ms 10 8 4s131ms 516ms 11 9 3s535ms 392ms 12 5 2s507ms 501ms 13 11 5s351ms 486ms 14 12 5s762ms 480ms 15 12 5s225ms 435ms 16 10 4s801ms 480ms 17 8 3s470ms 433ms 20 1 424ms 424ms 21 2 811ms 405ms [ User: lenon - Total duration: 48s276ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 48s276ms - Times executed: 106 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-20 13:49:10 Duration: 791ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-20 09:54:41 Duration: 741ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-20 10:58:05 Duration: 738ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 97 56s317ms 342ms 959ms 580ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 20 07 3 1s676ms 558ms 08 9 4s572ms 508ms 09 13 7s960ms 612ms 10 8 5s234ms 654ms 11 9 4s619ms 513ms 12 5 2s987ms 597ms 13 10 6s104ms 610ms 14 12 7s347ms 612ms 15 11 5s837ms 530ms 16 8 5s20ms 627ms 17 8 4s444ms 555ms 21 1 513ms 513ms [ User: intelifix - Total duration: 56s317ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 56s317ms - Times executed: 97 ]
-
select * from rs_menu_grants (401, 53, 1);
Date: 2026-07-20 13:49:10 Duration: 959ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
select * from rs_menu_grants (366, 81, 1);
Date: 2026-07-20 11:55:02 Duration: 871ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
select * from rs_menu_grants (414, 19, 1);
Date: 2026-07-20 09:42:33 Duration: 849ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 78 16m54s 9s595ms 51s974ms 13s3ms create table temp0000285796 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 20 07 16 3m23s 12s694ms 09 20 4m37s 13s863ms 10 9 1m49s 12s135ms 11 11 2m17s 12s520ms 12 2 24s824ms 12s412ms 14 2 26s164ms 13s82ms 15 18 3m56s 13s111ms [ User: intelifix - Total duration: 16m54s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 16m54s - Times executed: 78 ]
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 09:53:12 Duration: 51s974ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 07:18:40 Duration: 47s831ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:45:06 Duration: 15s498ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 74 19s221ms 162ms 890ms 259ms create table temp0000236492 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 20 14 18 5s406ms 300ms 15 17 4s587ms 269ms 16 8 2s23ms 252ms 17 31 7s204ms 232ms [ User: intelifix - Total duration: 19s221ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 19s221ms - Times executed: 74 ]
-
CREATE TABLE temp0000236492 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "15-07-2026", "data-ate" : "20-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-20 14:05:15 Duration: 890ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000236492 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "15-07-2026", "data-ate" : "20-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-20 14:07:17 Duration: 727ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000236492 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "20-07-2026", "data-ate" : "20-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-20 17:11:09 Duration: 422ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 72 19s111ms 150ms 767ms 265ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 20 07 1 273ms 273ms 08 11 2s556ms 232ms 09 5 1s355ms 271ms 10 12 3s563ms 296ms 11 7 2s199ms 314ms 13 4 1s397ms 349ms 14 7 1s561ms 223ms 15 8 2s72ms 259ms 16 5 1s242ms 248ms 17 12 2s889ms 240ms [ User: intelifix - Total duration: 19s111ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 19s111ms - Times executed: 72 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "268174", "oficina" : "6", "cliente" : "5", "usuario" : "414", "nf" : "", "data-saida" : "2026-07-20", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-20 11:31:10 Duration: 767ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "268276", "oficina" : "6", "cliente" : "5", "usuario" : "418", "nf" : "", "data-saida" : "2026-07-20", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-20 15:11:41 Duration: 573ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "268203", "oficina" : "6", "cliente" : "5", "usuario" : "417", "nf" : "", "data-saida" : "2026-07-20", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-20 13:46:51 Duration: 565ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 59 22s8ms 155ms 1s826ms 373ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 20 07 4 1s109ms 277ms 08 2 379ms 189ms 09 6 3s425ms 570ms 10 7 2s854ms 407ms 11 11 3s160ms 287ms 13 2 557ms 278ms 14 9 2s5ms 222ms 15 8 1s850ms 231ms 16 6 3s185ms 530ms 17 4 3s479ms 869ms [ User: intelifix - Total duration: 22s8ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 22s8ms - Times executed: 59 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '743AEF9D3686,8401120408D3,9877E707127A,743AEF96470D,743AEFABC183,8401122B38D2,9877E74E44C1,84011280811D,743AEF72E6A7,1834AF2879FB,743AEFC5B335,84011282792B,8401125FA12D,9877E702F9A8,9877E77C1EA0,1834AF252D01,9877E70311D4,743AEF9C7470,9877E7C07ABD,9877E70BAA8F,84011206F762,1834AF28DF43,840112962112,9877E74E354E,840112C29120,840112378F11', '87;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-07-20 16:21:56 Duration: 1s826ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '230050050620,229980247072,229962729415,230025859605,229982379199,230032422143,229980426686,230005526969,230010014153,230027573555,230027633538,229977499699,230032423153,229985243150,229972286879,229989828704,230022101517,229965068890,229965018505,229976118487,230019614147,229968555460,230051188800,229987729004,229990405763,229985816168,230032602744,230052814256,230025986082,230029652344,230023304148,230022173140,229971430422,230006266166,230008004462,229989518796,230006840623,230014110210,229979891427,229982583137,229982812834,230032605774,229989535162,229970544566,229971172641,229986535060,230026993038,229988914361,230045049817,229971173449,229991313641,230022987697,229988704363,230023096473,230022057494,230010451929,229977030508,229990238698,229988690928,229976095556,230026000203,230032425779,230006254852,229976655566,230005524848,230014872540,229977308390,230021964859,229975158406,230035548597,229963283139,230053637276,229964629296,230022074870,229976038503,230022951735,230021910309,229963480106,229989630829,229989012833', '113;1', 'DEFAULT', 00, 0295, '','', '', 00);
Date: 2026-07-20 17:08:55 Duration: 1s669ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_BAIXA_EXECUTA (430, 5, 2, 28, '9877E7BA1AAC,9877E7B86835,8401125F1F6E,743AEF5BFEEF,743AEFC50B97,840112E0F326,9877E709A481,9877E7BB5979,9877E74944F5,1834AF2518A9,9877E7B9EA31,743AEF75DF2A,743AEFC59C52,84011280ADA1,743AEFABFCD9,8401127FE923,743AEF723B0B,9877E70971C1,9877E700B454,8401128371B2,9877E77E3AF0,743AEF30C766,8401122A37AE,8401122AD0DC,743AEFDC4A28,9877E7B9C413,840112C15CA9,8401125F9771,1834AF28391F,9877E70CAF95,84011280AE3B,9877E7BFAF00,84011280624C,84011280DCA2,9877E77C4C82,9877E7052689,840112BFFCB1,84011261B94E', '','DEFAULT',00,0153,'', '','', 00);
Date: 2026-07-20 09:44:17 Duration: 1s19ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 58 25s668ms 151ms 915ms 442ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 20 09 4 1s68ms 267ms 10 1 187ms 187ms 11 4 640ms 160ms 13 48 23s500ms 489ms 15 1 272ms 272ms [ User: intelifix - Total duration: 25s668ms - Times executed: 58 ]
[ Application: [unknown] - Total duration: 25s668ms - Times executed: 58 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-07-20 13:33:08 Duration: 915ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-07-20 13:32:09 Duration: 832ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-07-20 13:31:41 Duration: 716ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m21s 9m15s 5m9s 3 15m28s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 20 05 3 15m28s 5m9s [ User: intelifix - Total duration: 15m28s - Times executed: 3 ]
[ Application: psql - Total duration: 15m28s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-20 05:09:16 Duration: 9m15s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-07-20 05:13:07 Duration: 3m51s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-07-20 05:15:29 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 1s328ms 14m11s 3m34s 47 2h47m40s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 20 07 3 14m37s 4m52s 08 3 6m56s 2m18s 09 3 14m27s 4m49s 10 3 10m31s 3m30s 11 3 10m46s 3m35s 12 3 10m52s 3m37s 13 3 6m13s 2m4s 14 3 11m18s 3m46s 15 3 11m18s 3m46s 16 3 14m52s 4m57s 17 3 12m49s 4m16s 18 3 11m13s 3m44s 19 3 6m15s 2m5s 20 2 12m54s 6m27s 21 3 6m39s 2m13s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 2h47m40s - Times executed: 47 ]
[ Application: psql - Total duration: 2h47m40s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-20 16:19:13 Duration: 14m11s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-20 07:18:55 Duration: 13m53s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-20 09:18:48 Duration: 13m46s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 283ms 5m9s 1m42s 48 1h22m1s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 20 07 3 5m29s 1m49s 08 3 3m55s 1m18s 09 3 6m43s 2m14s 10 3 5m31s 1m50s 11 3 5m12s 1m44s 12 3 4m54s 1m38s 13 3 4m3s 1m21s 14 3 5m25s 1m48s 15 3 6m23s 2m7s 16 3 6m25s 2m8s 17 3 5m55s 1m58s 18 3 4m37s 1m32s 19 3 4m 1m20s 20 3 5m20s 1m46s 21 3 3m51s 1m17s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h22m1s - Times executed: 48 ]
[ Application: psql - Total duration: 1h22m1s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-20 15:22:29 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-20 09:26:02 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-20 16:26:15 Duration: 4m36s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 2s354ms 2m4s 1m 12 12m9s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 20 08 1 7s516ms 7s516ms 09 1 3s697ms 3s697ms 10 1 1m30s 1m30s 11 4 6m22s 1m35s 13 3 17s186ms 5s728ms 15 2 3m48s 1m54s [ User: intelifix - Total duration: 12m9s - Times executed: 12 ]
[ Application: psql - Total duration: 12m9s - Times executed: 12 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01574);
Date: 2026-07-20 15:48:25 Duration: 2m4s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01573);
Date: 2026-07-20 15:41:49 Duration: 1m44s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01571);
Date: 2026-07-20 11:34:51 Duration: 1m39s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 4s562ms 1m32s 48s191ms 4 3m12s 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 Jul 20 20 2 1m37s 48s602ms 23 2 1m35s 47s779ms [ User: intelifix - Total duration: 3m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-20 20:08:44 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-20 23:16:55 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-20 23:35:54 Duration: 4s644ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 389ms 1m5s 32s583ms 4 2m10s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 20 20 2 1m4s 32s21ms 23 2 1m6s 33s144ms [ User: intelifix - Total duration: 2m10s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m10s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-20 23:13:38 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-20 20:05:30 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-20 23:35:23 Duration: 446ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 151ms 8m47s 25s98ms 342 2h23m3s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 20 07 31 16m34s 32s94ms 08 24 1m34s 3s952ms 09 27 14m5s 31s331ms 10 31 21m5s 40s806ms 11 23 11m46s 30s729ms 12 19 6m30s 20s546ms 13 15 9m16s 37s84ms 14 35 9m57s 17s75ms 15 68 43m48s 38s649ms 16 43 1m40s 2s332ms 17 26 6m43s 15s512ms [ User: intelifix - Total duration: 2h23m3s - Times executed: 342 ]
[ Application: [unknown] - Total duration: 2h23m3s - Times executed: 342 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027266, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-20 10:03:52 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027305, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-20 15:55:40 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_seriais_expedidos(6,DATE(''2025-01-01''),DATE(''2025-01-31'')) ;', '/var/www/html/tmp/temp_54.xlsx');
Date: 2026-07-20 15:07:04 Duration: 8m14s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 9s747ms 50s916ms 14s608ms 15 3m39s create table temp0000285906 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 20 16 3 1m19s 26s648ms 17 12 2m19s 11s598ms [ User: intelifix - Total duration: 3m39s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m39s - Times executed: 15 ]
-
CREATE TABLE temp0000285906 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 16:52:10 Duration: 50s916ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285906 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 17:10:16 Duration: 15s671ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285906 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 16:00:17 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 10s424ms 24s737ms 13s799ms 14 3m13s create table temp0000285866 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 20 12 4 51s367ms 12s841ms 13 3 37s549ms 12s516ms 14 4 1m4s 16s42ms 15 3 40s111ms 13s370ms [ User: intelifix - Total duration: 3m13s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 14 ]
-
CREATE TABLE temp0000285866 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 14:42:31 Duration: 24s737ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285866 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 12:24:51 Duration: 15s812ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285866 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 14:51:11 Duration: 15s349ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 11s23ms 15s828ms 13s166ms 18 3m56s create table temp0000285868 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 20 15 18 3m56s 13s166ms [ User: intelifix - Total duration: 3m56s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 18 ]
-
CREATE TABLE temp0000285868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:28:24 Duration: 15s828ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:34:31 Duration: 15s639ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:34:54 Duration: 14s590ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 9s595ms 51s974ms 13s3ms 78 16m54s create table temp0000285796 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 20 07 16 3m23s 12s694ms 09 20 4m37s 13s863ms 10 9 1m49s 12s135ms 11 11 2m17s 12s520ms 12 2 24s824ms 12s412ms 14 2 26s164ms 13s82ms 15 18 3m56s 13s111ms [ User: intelifix - Total duration: 16m54s - Times executed: 78 ]
[ Application: [unknown] - Total duration: 16m54s - Times executed: 78 ]
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 09:53:12 Duration: 51s974ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 07:18:40 Duration: 47s831ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-20 15:45:06 Duration: 15s498ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 968ms 56s796ms 6s650ms 110 12m11s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 20 07 2 11s744ms 5s872ms 08 5 10s723ms 2s144ms 09 5 20s647ms 4s129ms 10 10 1m28s 8s803ms 11 11 28s893ms 2s626ms 12 7 9s354ms 1s336ms 13 7 24s234ms 3s462ms 14 12 1m53s 9s440ms 15 24 3m25s 8s570ms 16 13 1m55s 8s919ms 17 14 1m42s 7s355ms [ User: intelifix - Total duration: 12m11s - Times executed: 110 ]
[ Application: [unknown] - Total duration: 12m11s - Times executed: 110 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 10:17:59 Duration: 56s796ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 15:29:51 Duration: 52s105ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-20', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-20 15:06:17 Duration: 37s433ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 3s17ms 30s40ms 6s263ms 30 3m7s create table temp0000285796 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 20 07 4 31s220ms 7s805ms 08 9 32s351ms 3s594ms 11 5 41s683ms 8s336ms 14 4 44s425ms 11s106ms 15 8 38s237ms 4s779ms [ User: intelifix - Total duration: 3m7s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 30 ]
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-07-2026", "ate" :"20-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-20 14:30:33 Duration: 30s40ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-07-2026", "ate" :"20-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-20 11:11:23 Duration: 25s972ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000285796 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-07-2026", "ate" :"20-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-20 07:29:02 Duration: 21s746ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 169ms 42s121ms 5s890ms 46 4m30s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 20 07 3 34s464ms 11s488ms 08 1 320ms 320ms 09 4 1m25s 21s354ms 10 6 12s10ms 2s1ms 11 7 20s332ms 2s904ms 12 3 15s951ms 5s317ms 13 5 5s885ms 1s177ms 14 1 20s891ms 20s891ms 15 13 1m12s 5s613ms 17 3 2s716ms 905ms [ User: intelifix - Total duration: 4m30s - Times executed: 46 ]
[ Application: psql - Total duration: 4m30s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027266);
Date: 2026-07-20 09:55:13 Duration: 42s121ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027255);
Date: 2026-07-20 07:21:01 Duration: 30s733ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027260);
Date: 2026-07-20 09:03:11 Duration: 23s185ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 161ms 42s910ms 4s250ms 132 9m21s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 20 00 2 650ms 325ms 03 1 183ms 183ms 06 3 14s959ms 4s986ms 07 8 47s418ms 5s927ms 08 12 1m8s 5s681ms 09 12 1m3s 5s278ms 10 12 47s204ms 3s933ms 11 12 1m2s 5s196ms 12 12 38s885ms 3s240ms 13 9 14s335ms 1s592ms 14 11 43s175ms 3s925ms 15 12 1m39s 8s258ms 16 11 41s468ms 3s769ms 17 4 3s740ms 935ms 21 5 8s224ms 1s644ms 22 6 7s833ms 1s305ms [ User: intelifix - Total duration: 9m21s - Times executed: 132 ]
[ Application: psql - Total duration: 9m21s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 15:55:44 Duration: 42s910ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 07:35:13 Duration: 11s980ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-20 09:45:13 Duration: 11s761ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 650ms 11s52ms 4s180ms 34 2m22s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 20 08 2 10s440ms 5s220ms 09 2 5s971ms 2s985ms 10 3 24s755ms 8s251ms 11 3 20s879ms 6s959ms 12 2 7s632ms 3s816ms 13 3 6s265ms 2s88ms 14 1 8s568ms 8s568ms 15 3 24s591ms 8s197ms 16 1 4s240ms 4s240ms 17 2 16s132ms 8s66ms 18 1 1s95ms 1s95ms 19 3 2s658ms 886ms 20 3 3s928ms 1s309ms 21 2 1s930ms 965ms 22 3 3s46ms 1s15ms [ User: intelifix - Total duration: 2m22s - Times executed: 34 ]
[ Application: psql - Total duration: 2m22s - Times executed: 34 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-20 15:20:12 Duration: 11s52ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-20 10:40:12 Duration: 10s798ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-20 10:00:11 Duration: 10s244ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 155ms 2m16s 3s217ms 271 14m31s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 20 00 12 44s810ms 3s734ms 01 11 25s271ms 2s297ms 02 11 26s145ms 2s376ms 03 10 21s533ms 2s153ms 04 12 26s370ms 2s197ms 05 12 25s465ms 2s122ms 06 11 24s831ms 2s257ms 07 12 27s602ms 2s300ms 08 12 33s278ms 2s773ms 09 12 49s588ms 4s132ms 10 12 38s118ms 3s176ms 11 12 2m44s 13s672ms 12 12 31s562ms 2s630ms 13 12 30s887ms 2s573ms 14 12 36s897ms 3s74ms 15 12 45s556ms 3s796ms 16 12 33s397ms 2s783ms 17 12 33s207ms 2s767ms 18 12 28s545ms 2s378ms 19 12 28s299ms 2s358ms 20 12 40s588ms 3s382ms 21 12 27s915ms 2s326ms 22 12 28s41ms 2s336ms [ User: intelifix - Total duration: 14m31s - Times executed: 271 ]
[ Application: psql - Total duration: 14m31s - Times executed: 271 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 11:07:24 Duration: 2m16s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 00:05:23 Duration: 21s111ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-20 09:45:30 Duration: 17s171ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 208ms 16s207ms 2s650ms 56 2m28s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 20 07 6 4s146ms 691ms 09 7 4s189ms 598ms 10 6 29s344ms 4s890ms 11 4 2s170ms 542ms 12 3 8s911ms 2s970ms 13 2 20s209ms 10s104ms 14 2 2s922ms 1s461ms 15 20 52s608ms 2s630ms 16 1 2s552ms 2s552ms 17 5 21s397ms 4s279ms [ User: intelifix - Total duration: 2m28s - Times executed: 56 ]
[ Application: psql - Total duration: 2m28s - Times executed: 56 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027272);
Date: 2026-07-20 10:47:50 Duration: 16s207ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027295);
Date: 2026-07-20 15:20:58 Duration: 14s980ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027282);
Date: 2026-07-20 13:57:05 Duration: 13s939ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 150ms 8s368ms 1s302ms 1,321 28m41s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 20 07 2 869ms 434ms 08 63 52s696ms 836ms 09 126 3m29s 1s660ms 10 206 4m23s 1s281ms 11 165 3m16s 1s193ms 12 72 1m40s 1s394ms 13 108 2m9s 1s197ms 14 194 4m7s 1s274ms 15 205 4m7s 1s209ms 16 118 3m12s 1s627ms 17 62 1m20s 1s293ms [ User: intelifix - Total duration: 28m41s - Times executed: 1321 ]
[ Application: [unknown] - Total duration: 28m41s - Times executed: 1321 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267742, 508, 'CP2127LV0FN,08A7C077093C$CP2120LV4HH,08A7C06C839C$CP2203LV0M3,1C9D726BBEC4$CP2120LV2VN,08A7C06BFD74$CP2301LV3FR,B85E71E636D8$CP2228LV10J,4075C32867B8$CP2203LV0AW,1C9D7269EB9C$CP2134LV2TG,ECA81F22463C$CP2120LV012,08A7C06BA44C$CP2301LV614,B85E71E6A258$CP2204LV0P2,1C9D726BC08C$CP2134LV5LD,ECA81F23D2FC$CP2125LV25Y,08A7C0712304$CP2242LV5VT,B85E71C83160$CP2125LV5SY,08A7C071AA7C$CP2534LV1M7,3C82C0905820$CP2239LVRST,B85E71BE4204$CP2528LVCTC,F8D2AC4C65D0$CP2439LV7WW,C4509CF4235C$CP2435LV03W,C4509CF14444$CP2528LV34G,F8D2AC49DC98$CP2134LV5SC,ECA81F233D2C$CP2239LV1HA,4075C3C32C8C$CP2534LV31Q,3C82C090C2D8$CP2527LV91H,F8D2AC490D2C$CP2531LV2T7,3C82C08D3B2C$CP2051LV43T,08A7C070679C$CP2242LVAHM,B85E71CCB618$CP2302LV7Z1,B85E71EA4B4C$CP2531LV12F,3C82C08DE52C$CP2139LV772,ECA81F6D45C4$CP2534LV2TS,3C82C090EFC4$CP2231LV28M,4075C32973B0$CP2534LV31P,3C82C090C224$CP2048LV57W,484BD4930614$CP2528LVCJE,F8D2AC4C818C$CP2436LV3CR,C4509CF359B4$CP2527LV90R,F8D2AC490D04$CP2239LVEYK,B85E71BA8754$CP2133LV0U3,ECA81F1FA564', '',0185,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-07-20 16:58:20 Duration: 8s368ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267733, 450, '73917785850068803145,229714269813,229640316366,229766201829,229733392140,229704041419,229728846768,229716706975,229693783448,229701333545,229766310022,229714397075,229641828703,229831974151,229640374958,229678645169,229714157478,229777871520,229715005676,229677095152,229696114764,229826570628,229695435068,229775048607,229708674553,229732691836,229702307994,229824817885,229800732438,229641307181,229708992340,229638688687,229767585869,229707174463,229766377883,216927066063,229695750408,229641341125', '246553029510,246487719107,246555397901,246565636172,246505024769,246551764145,246552337893,246500712429,246521366666,246554267980,246553021934,246481200918,246644817289,226310992948,246459455473,226208444668,246595504755,246535637172,246459137888,246513199910,246623447291,246500716368,246506971323,246538132445,246565461330,246535523043,246624539003,246614004664,246480129208,246537503337,246449480011,246554861934,246539037190,246556590610,246451065058,246501301735,246481885058,,,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-20 13:43:28 Duration: 7s861ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267733, 450, '73903585850065105183,229676147596,229678335767,229732797580,229833820819,229713007781,229646158294,229826279510,229823977085,229695865469,229827253253,229678628298,229712810614,229707321930,229774790120,229678029395,229708255567,229798556568,229733170222,216949655664,229701476162,229646275152,229778564752,229704861432,229716183434,229778419710,229825747280,229704948790,229694330202,229694506582,229728711627,229733623352,229729451531,229700675164,229704944043,229676554662,229707323647,229827469817,216927562431,229793109707', '246460341834,246493275474,246568765254,246183356069,246346275370,246537767178,246623710000,246623245375,246509182425,246636398487,246460569308,246593279308,246538068701,246575699297,246459213755,246538435661,246616821718,246566921214,246448213355,246507996484,246466445459,246595248792,246507837074,246550448292,246595210204,226053119913,246507839296,246500690609,246534492628,246551281315,246565401324,246565937492,246503716066,246507842833,246489898791,246541828406,246626099199,246451746370,246601665760,', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-20 11:13:13 Duration: 7s844ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 159ms 3s810ms 937ms 106 1m39s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 20 07 25 27s584ms 1s103ms 08 10 8s857ms 885ms 09 2 1s166ms 583ms 10 8 8s303ms 1s37ms 11 6 6s996ms 1s166ms 12 8 9s184ms 1s148ms 14 7 7s786ms 1s112ms 15 16 15s553ms 972ms 16 24 13s920ms 580ms [ User: intelifix - Total duration: 1m39s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 1m39s - Times executed: 106 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267757) LIMIT 1;
Date: 2026-07-20 07:08:46 Duration: 3s810ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267520) LIMIT 1;
Date: 2026-07-20 07:48:40 Duration: 3s513ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128418) LIMIT 1;
Date: 2026-07-20 15:14:14 Duration: 3s447ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 13 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 19 11 2 0ms 0ms 12 1 0ms 0ms 13 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms Jul 20 16 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 4m20s - Times executed: 13 ]
[ Application: psql - Total duration: 4m20s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 237ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,053 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 17 FATAL entries
- 3856 ERROR entries
- 0 WARNING entries
- 8 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,717 Max number of times the same event was reported
- 3,881 Total events found
Rank Times reported Error 1 3,717 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 20 00 59 01 60 02 59 03 60 04 59 05 59 06 60 07 155 08 269 09 381 10 406 11 389 12 190 13 138 14 325 15 305 16 262 17 134 18 59 19 60 20 60 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029A50E40" does not exist
- ERROR: prepared statement "_PLAN0000000029A564F0" does not exist
- ERROR: prepared statement "_PLAN0000000029A53750" does not exist
Statement: DEALLOCATE "_PLAN0000000029A50E40"
Date: 2026-07-20 00:00:18 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: DEALLOCATE "_PLAN0000000029A564F0"
Date: 2026-07-20 00:01:19 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: DEALLOCATE "_PLAN0000000029A53750"
Date: 2026-07-20 00:02:19 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 20 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 1 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-20 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-20 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-20 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 20 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-20 08:00:07 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-20 08:20:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-20 08:40:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 26 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 20 10 7 12 3 13 12 15 4 - ERROR: syntax error at or near "1" at character 95
- ERROR: syntax error at or near "10" at character 95
- ERROR: syntax error at or near "104" at character 95
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'1","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-07-20 10:19:57 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'10","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-07-20 10:19:59 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'104","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-07-20 10:20:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 14 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 20 09 2 11 3 14 3 15 2 16 4 - ERROR: column b.cai_criacao does not exist at character 19
- ERROR: column "acai_id" does not exist at character 8
- ERROR: column "d87d7f2be13b" does not exist at character 27
Hint: Perhaps you meant to reference the column "a.cai_criacao".
Statement: select b.cai_data,b.cai_criacao from lote_caixas a inner join caixa_itens b on b.cai_id = a.cai_id where a.lot_id= 158913Date: 2026-07-20 09:43:35 Database: rio Application: pgAdmin 4 - CONN:6227070 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-20.log
Hint: Perhaps you meant to reference the column "a.cai_id" or the column "b.cai_id".
Statement: select acai_id,b.flu_id,b.cai_data,b.cai_data_hora from lote_caixas a inner join caixa_itens b on b.cai_id = a.cai_id where a.lot_id= 158913Date: 2026-07-20 09:44:17 Database: rio Application: pgAdmin 4 - CONN:6227070 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: SELECT * FROM RS_ETIQUETA(D87D7F2BE13B)
Date: 2026-07-20 11:47:45 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 20 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-20 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-07-20 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-07-20 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 20 00 1 06 1 12 3 15 1 20 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-20 00:02:23 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-07-20 06:02:20 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-07-20 12:45:00 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 6 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 20 05 4 17 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-20 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-20 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-20 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 6 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 20 11 3 15 3 - LOG: process 3441747 still waiting for ShareLock on transaction 2967063 after 1000.112 ms
- LOG: process 3441747 still waiting for ShareLock on transaction 2967063 after 3977.595 ms
- LOG: process 3441747 still waiting for ShareLock on transaction 2967063 after 43219.395 ms
Detail: Process holding the lock: 3493363. Wait queue: 3441747.
Context: while updating tuple (74141,83) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-20 11:05:15 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Detail: Process holding the lock: 3493363. Wait queue: 3441747.
Context: while updating tuple (74141,83) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-20 11:05:18 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Detail: Process holding the lock: 3493363. Wait queue: 3441747.
Context: while updating tuple (74141,83) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-20 11:05:57 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 20 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-20 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-07-20 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 20 03 1 - LOG: database system was shut down at 2026-07-20 03:05:02 -03
Date: 2026-07-20 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 20 15 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(128768,401,'517109442933,B0DAF94A098E','',042,00,'[{"item":"0","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0381819517339378700);Date: 2026-07-20 15:03:59 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 20 18 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-20 18:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 20 15 1 - LOG: process 3692525 still waiting for AccessExclusiveLock on relation 2682734 of database 358220 after 1000.229 ms
Detail: Process holding the lock: 3730517. Wait queue: 3692525.
Statement: DROP TABLE IF EXISTS temp0000285868;Date: 2026-07-20 15:36:50 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 20 15 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000285868"
Date: 2026-07-20 15:36:50 Log file: /usr/local/pgsql/data/log/serverlog-20.log