pgBadger-
Global information
- Generated on Wed Oct 14 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 16,451 log entries in 7s
- Log start from 2026-10-14 00:02:02 to 2026-10-14 23:49:55
-
Overview
Global Stats
- 261 Number of unique normalized queries
- 2,004 Number of queries
- 5h3m57s Total query duration
- 2026-10-14 00:02:07 First query
- 2026-10-14 23:43:09 Last query
- 5 queries/s at 2026-10-14 23:42:46 Query peak
- 5h3m57s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5h3m57s Execute total duration
- 1,608 Number of events
- 11 Number of unique normalized events
- 1,569 Max number of times the same event was reported
- 0 Number of cancellation
- 146 Total number of automatic vacuums
- 307 Total number of automatic analyzes
- 22 Number temporary file
- 250.38 MiB Max size of temporary file
- 71.37 MiB Average size of temporary file
- 287 Total number of sessions
- 8 sessions at 2026-10-14 01:05:02 Session peak
- 10d18h57m58s Total duration of sessions
- 54m8s Average duration of sessions
- 6 Average queries per session
- 1m3s Average queries duration per session
- 53m4s Average idle time per session
- 298 Total number of connections
- 4 connections/s at 2026-10-14 00:05:01 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-14 23:42:46 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-10-14 17:10:56 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-10-14 23:42:46 Date
Queries duration
Key values
- 5h3m57s 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) Oct 14 00 23 0ms 13s549ms 3s233ms 8s839ms 51s140ms 51s140ms 01 12 0ms 2s659ms 1s427ms 2s887ms 2s887ms 2s887ms 02 12 0ms 2s598ms 1s384ms 2s883ms 2s883ms 2s883ms 03 12 0ms 2s743ms 1s395ms 3s47ms 3s47ms 3s47ms 04 12 0ms 2s640ms 1s374ms 2s914ms 2s914ms 2s914ms 05 17 0ms 9m36s 1m16s 2m44s 6m55s 9m36s 06 19 0ms 8s655ms 2s521ms 8s809ms 25s128ms 25s128ms 07 51 0ms 7m 21s122ms 1m6s 3m54s 7m 08 144 0ms 5m3s 5s782ms 22s185ms 33s123ms 5m47s 09 134 0ms 5m9s 4s901ms 4s810ms 10s395ms 5m53s 10 156 0ms 5m9s 4s563ms 6s854ms 35s397ms 5m53s 11 212 0ms 5m14s 3s701ms 11s672ms 47s896ms 5m58s 12 74 0ms 5m10s 8s307ms 4s57ms 5s957ms 5m54s 13 121 0ms 5m6s 5s502ms 4s9ms 26s928ms 5m53s 14 100 0ms 5m8s 6s488ms 4s650ms 6s845ms 5m58s 15 73 0ms 5m6s 8s564ms 4s723ms 6s923ms 5m51s 16 112 0ms 5m7s 6s268ms 5s693ms 37s294ms 5m51s 17 154 0ms 11m53s 11s118ms 27s542ms 3m39s 13m30s 18 52 0ms 19m17s 54s149ms 1m17s 5m30s 19m17s 19 24 0ms 5m9s 24s354ms 2s932ms 3s171ms 5m53s 20 110 0ms 5m32s 10s656ms 1m5s 1m13s 6m29s 21 26 0ms 5m7s 22s239ms 2s897ms 3s518ms 5m50s 22 24 0ms 5m7s 24s591ms 2s939ms 2s998ms 5m50s 23 330 0ms 1m4s 5s993ms 1m6s 1m7s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 14 00 4 0 2s209ms 0ms 0ms 8s839ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 4 0 2s202ms 0ms 0ms 8s809ms 07 34 0 31s30ms 27s9ms 1m6s 7m 08 99 0 7s886ms 6s310ms 22s185ms 3m27s 09 103 0 6s76ms 1s885ms 2s731ms 3m28s 10 103 0 6s500ms 2s382ms 4s761ms 3m28s 11 169 0 4s385ms 2s151ms 10s594ms 3m34s 12 46 0 12s645ms 607ms 1s332ms 3m30s 13 87 0 7s275ms 976ms 2s742ms 3m26s 14 54 0 11s163ms 1s676ms 2s768ms 3m27s 15 50 0 11s982ms 1s871ms 2s986ms 3m30s 16 82 0 7s697ms 2s158ms 4s948ms 3m30s 17 102 0 15s732ms 5s668ms 19s488ms 5m44s 18 26 0 1m43s 315ms 54s918ms 10m9s 19 6 0 1m33s 0ms 0ms 3m28s 20 9 83 12s435ms 43s168ms 1m2s 3m28s 21 8 0 1m9s 0ms 0ms 3m24s 22 6 0 1m34s 0ms 0ms 3m37s 23 9 321 5s993ms 1m2s 1m6s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Oct 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Oct 14 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 3 3.00 0.00% 08 0 10 10.00 0.00% 09 0 5 5.00 0.00% 10 0 7 7.00 0.00% 11 0 9 9.00 0.00% 12 0 1 1.00 0.00% 13 0 6 6.00 0.00% 14 0 4 4.00 0.00% 15 0 5 5.00 0.00% 16 0 6 6.00 0.00% 17 0 6 6.00 0.00% 18 0 3 3.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Oct 14 00 17 0.00/s 01 10 0.00/s 02 7 0.00/s 03 12 0.00/s 04 7 0.00/s 05 7 0.00/s 06 14 0.00/s 07 14 0.00/s 08 16 0.00/s 09 18 0.01/s 10 18 0.01/s 11 17 0.00/s 12 12 0.00/s 13 15 0.00/s 14 14 0.00/s 15 15 0.00/s 16 17 0.00/s 17 16 0.00/s 18 9 0.00/s 19 7 0.00/s 20 10 0.00/s 21 8 0.00/s 22 9 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Oct 14 00 4 47m30s 47m11s 01 16 1h2m2s 1h2m1s 02 8 1h 59m58s 03 14 25m41s 25m40s 04 5 1h1m12s 1h1m9s 05 7 1h2m34s 59m29s 06 7 56m28s 56m21s 07 13 1h2m4s 1h41s 08 14 57m45s 56m46s 09 17 55m16s 54m37s 10 17 57m38s 56m56s 11 23 46m44s 46m10s 12 11 52m49s 51m53s 13 9 1h1m1s 59m47s 14 15 1h1m26s 1h43s 15 16 53m15s 52m36s 16 14 58m25s 57m35s 17 17 57m35s 55m54s 18 15 58m13s 55m5s 19 8 1h39s 59m26s 20 10 40m26s 38m29s 21 7 1h1m9s 59m47s 22 8 1h3s 58m49s 23 12 32m45s 30m -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-10-14 00:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 298 connections Total
Connections per user
Key values
- intelifix Main User
- 298 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-10-14 01:05:02 Date
Histogram of session times
Key values
- 239 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 287 sessions Total
Sessions per user
Key values
- intelifix Main User
- 287 sessions Total
Sessions per host
Key values
- [local] Main Host
- 287 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 24,260 buffers Checkpoint Peak
- 2026-10-14 00:09:47 Date
- 270.037 seconds Highest write time
- 0.018 seconds Sync time
Checkpoints Wal files
Key values
- 8 files Wal files usage Peak
- 2026-10-14 18:09:46 Date
Checkpoints distance
Key values
- 251.88 Mo Distance Peak
- 2026-10-14 18:09:46 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Oct 14 00 33,640 539.06s 0.004s 539.072s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.019s 0.002s 0.026s 04 0 0s 0s 0s 05 7,134 713.978s 0.03s 714.029s 06 2,828 269.466s 0.002s 269.47s 07 5,216 521.997s 0.027s 522.053s 08 18,504 1,686.196s 0.05s 1,686.288s 09 16,495 1,687.068s 0.05s 1,687.158s 10 16,745 1,629.173s 0.051s 1,629.272s 11 24,219 2,080.406s 0.081s 2,080.537s 12 6,875 690.642s 0.035s 690.711s 13 10,669 1,095.184s 0.049s 1,095.269s 14 11,762 1,191.216s 0.04s 1,191.293s 15 10,422 1,046.327s 0.062s 1,046.424s 16 18,085 1,577.224s 0.05s 1,577.31s 17 64,974 2,194.992s 0.093s 2,195.137s 18 47,416 1,823.882s 0.051s 1,823.958s 19 33 3.329s 0.004s 3.343s 20 608 233.457s 0.007s 233.47s 21 616 61.675s 0.013s 61.706s 22 33 3.331s 0.004s 3.341s 23 216 21.674s 0.009s 21.708s Day Hour Added Removed Recycled Synced files Longest sync Average sync Oct 14 00 0 0 8 146 0.002s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.001s 0.001s 04 0 0 0 0 0s 0s 05 0 0 3 224 0.009s 0.007s 06 0 0 0 10 0.001s 0.001s 07 0 0 2 688 0.003s 0.01s 08 0 0 6 2,914 0.004s 0.011s 09 0 0 5 3,201 0.002s 0.012s 10 0 0 7 3,325 0.002s 0.011s 11 0 0 9 4,194 0.003s 0.012s 12 0 0 3 1,821 0.002s 0.012s 13 0 0 3 3,073 0.002s 0.012s 14 0 0 4 2,725 0.002s 0.012s 15 0 0 4 2,248 0.003s 0.012s 16 0 0 7 2,906 0.003s 0.012s 17 0 0 28 3,303 0.003s 0.012s 18 0 0 24 964 0.002s 0.007s 19 0 0 0 12 0.001s 0.003s 20 0 0 1 80 0.002s 0.003s 21 0 0 0 64 0.003s 0.005s 22 0 0 0 7 0.001s 0.003s 23 0 0 0 30 0.002s 0.005s Day Hour Count Avg time (sec) Oct 14 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 Oct 14 00 57,985.00 kB 58,527.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 26,310.00 kB 04 0.00 kB 0.00 kB 05 7,911.43 kB 11,748.14 kB 06 7,577.00 kB 12,271.00 kB 07 2,236.30 kB 8,082.70 kB 08 8,715.45 kB 11,017.64 kB 09 7,407.00 kB 20,275.42 kB 10 10,419.73 kB 19,639.73 kB 11 12,484.42 kB 26,166.42 kB 12 3,237.83 kB 16,302.08 kB 13 4,831.42 kB 7,530.67 kB 14 5,907.00 kB 10,980.92 kB 15 4,903.17 kB 11,024.25 kB 16 9,614.00 kB 25,408.00 kB 17 37,677.75 kB 64,791.83 kB 18 56,802.86 kB 110,427.43 kB 19 71.00 kB 75,436.67 kB 20 4,551.00 kB 56,102.00 kB 21 494.80 kB 37,333.20 kB 22 67.67 kB 24,404.00 kB 23 126.75 kB 16,971.50 kB -
Temporary Files
Size of temporary files
Key values
- 500.75 MiB Temp Files size Peak
- 2026-10-14 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-10-14 05:32:04 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Oct 14 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.33 GiB 68.11 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 1 104.00 MiB 104.00 MiB 18 1 104.00 MiB 104.00 MiB 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.03 GiB 37.34 MiB 250.38 MiB 65.71 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-14 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-14 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 310.92 MiB 57.79 MiB 95.11 MiB 77.73 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-14 05:30:41 Duration: 39s295ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-14 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 207.99 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:22:31 Duration: 19m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 17:51:46 Duration: 11m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:25:29 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries generating the largest temporary files
Rank Size Query 1 250.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 250.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-14 17:38:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-10-14 18:01:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 95.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-14 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 95.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-14 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 62.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-14 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 57.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-10-14 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 41.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 41.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 41.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 37.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 37.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 37.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 37.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 37.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-10-14 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.32 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database brasilia - 2026-10-14 17:23:45 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 4.32 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_10
Database brasilia - 2026-10-14 17:23:45 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (35) Main table analyzed (database brasilia)
- 307 analyzes Total
Table Number of analyzes brasilia.pg_catalog.pg_attribute 35 contagem.public.usuarios 33 contagem.pg_catalog.pg_attribute 33 brasilia.pg_catalog.pg_class 18 contagem.pg_catalog.pg_class 15 brasilia.pg_catalog.pg_type 15 contagem.pg_catalog.pg_type 14 contagem.pg_catalog.pg_index 9 brasilia.pg_catalog.pg_index 9 brasilia.public.temp0000242106 8 brasilia.public.usuarios 8 contagem.public.temp0000227530 7 brasilia.pg_catalog.pg_depend 7 contagem.public.temp0000227536 7 contagem.pg_catalog.pg_depend 6 brasilia.public.temp0000242150 6 brasilia.public.temp0000242124 5 brasilia.public.temp0000242184 4 brasilia.public.temp0000242112 4 contagem.public.nf_entrada 4 rio.public.temp0000294080 4 brasilia.public.temp0000242148 4 rio.pg_catalog.pg_attribute 3 contagem.public.temp0000227524 3 postgres.pg_catalog.pg_shdepend 2 brasilia.public.nf_entrada 2 brasilia.public.temp0000242186 2 rio.pg_catalog.pg_index 2 brasilia.public.temp0000242126 2 rio.pg_catalog.pg_depend 2 brasilia.public.temp0000242120 2 brasilia.public.temp0000242166 2 rio.pg_catalog.pg_class 2 contagem.public.temp0000227532 2 rio.pg_catalog.pg_shdepend 2 rio.pg_catalog.pg_type 2 brasilia.public.temp0000242110 2 rio.public.temp0000294084 2 contagem.auditor.auditor_2026_10 1 brasilia.public.temp0000242162 1 brasilia.public.temp0000242158 1 brasilia.public.temp0000242168 1 rio.auditor.auditor_2026_10 1 rio.public.tmp_drill_0320 1 rio.public.temp0000294072 1 rio.public.temp0000294078 1 rio.public.temp0000294082 1 brasilia.public.temp0000242136 1 brasilia.public.temp0000242176 1 contagem.public.temp0000227528 1 contagem.public.temp0000227526 1 brasilia.public.temp0000242156 1 brasilia.public.temp0000242140 1 brasilia.public.temp0000242180 1 brasilia.auditor.auditor_2026_10 1 brasilia.public.temp0000242134 1 Total 307 Vacuums per table
Key values
- public.usuarios (33) Main table vacuumed on database contagem
- 146 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples contagem.public.usuarios 33 0 0 0 0 0 0 165 128 70,514 0 0 contagem.pg_catalog.pg_attribute 14 14 0 0 0 0 0 9,378 1,756 3,486,130 14 390 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,429 1,748 2,901,421 58 1,607 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 658 95 177,022 4 16 contagem.public.temp0000227530 7 0 0 0 0 0 0 833 42 55,998 0 0 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,306 122 255,571 6 16 brasilia.pg_catalog.pg_class 6 6 0 0 0 0 0 1,036 231 459,047 15 54 brasilia.pg_catalog.pg_type 5 5 0 0 0 0 0 508 178 264,798 13 48 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,291 222 542,138 5 24 brasilia.public.temp0000242148 4 0 0 0 0 0 0 784 15 48,603 0 0 rio.public.temp0000294080 4 0 0 0 0 0 0 5,596 15 332,511 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 247 39 65,997 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 110 21 25,151 3 12 rio.public.temp0000294084 2 0 0 0 0 0 0 3,728 8 221,158 0 0 brasilia.public.temp0000242126 2 0 0 0 0 0 0 264 7 16,717 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 605 176 327,620 11 90 contagem.public.temp0000227524 2 0 0 0 0 0 0 108 12 8,068 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 529 159 388,250 24 30 testes.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 544 163 392,381 6 16 rio.pg_catalog.pg_class 2 2 0 0 0 0 0 340 18 60,599 1 3 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,653 1,062 4,143,969 864 5,762 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 374 91 373,105 43 89 rio.public.temp0000294078 1 0 0 0 0 0 0 1,864 4 110,579 0 0 rio.public.temp0000294082 1 0 0 0 0 0 0 4 3 774 0 0 rio.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 844 298 1,201,430 171 448 rio.public.tmp_drill_0320 1 1 0 0 0 0 0 48 3 11,111 0 0 rio.pg_catalog.pg_statistic 1 1 0 0 0 0 0 3,362 1,319 4,489,316 1,254 7,457 rio.public.temp0000294072 1 0 0 0 0 0 0 1,864 4 110,579 0 0 rio.pg_catalog.pg_index 1 1 0 0 0 0 0 75 26 21,007 1 14 rio.pg_catalog.pg_type 1 1 0 0 0 0 0 151 43 60,163 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 151 78 129,671 4 4 brasilia.auditor.auditor_2026_10 1 0 0 0 0 0 0 26,956 14,377 18,686,895 6,190 124,104 brasilia.public.temp0000242140 1 0 0 0 0 0 0 259 4 15,884 0 0 brasilia.public.lotes_saidas 1 1 0 0 0 0 0 157 103 322,286 0 0 brasilia.public.temp0000242186 1 0 0 0 0 0 0 260 4 15,943 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,188 3 154,083 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 142 2 11,113 0 0 contagem.auditor.auditor_2026_10 1 0 0 0 0 0 0 21,176 10,115 12,973,838 5,497 107,688 rio.pg_catalog.pg_attribute 1 1 0 0 0 0 0 522 77 169,141 7 189 contagem.public.temp0000227528 1 0 0 0 0 0 0 119 6 8,000 0 0 rio.pg_catalog.pg_depend 1 1 0 0 0 0 0 555 190 237,825 6 70 brasilia.public.temp0000242184 1 0 0 0 0 0 0 260 4 15,943 0 0 Total 146 83 0 0 0 0 0 99,443 32,971 53,362,349 14,197 248,131 Vacuum throughput per table
Key values
- auditor.auditor_2026_10 (4.32) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.94 brasilia.pg_catalog.pg_attribute 0 0 0.78 contagem.pg_catalog.pg_type 0 0 0.06 contagem.public.temp0000227530 0 0 0.01 contagem.pg_catalog.pg_class 0 0 0.18 brasilia.pg_catalog.pg_class 0 0 0.12 brasilia.pg_catalog.pg_type 0 0 0.08 contagem.pg_catalog.pg_depend 0 0 0.15 brasilia.public.temp0000242148 0 0 0 rio.public.temp0000294080 0 0 0.2 contagem.pg_catalog.pg_index 0 0 0.08 brasilia.pg_catalog.pg_index 0 0 0.02 rio.public.temp0000294084 0 0 0.1 brasilia.public.temp0000242126 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.15 contagem.public.temp0000227524 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0.07 testes.pg_catalog.pg_shdepend 0 0 0.16 rio.pg_catalog.pg_class 0 0 0.15 brasilia.pg_catalog.pg_statistic 0 0 0.35 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000294078 0 0 0.05 rio.public.temp0000294082 0 0 0.05 rio.pg_toast.pg_toast_2619 0 0 0.07 rio.public.tmp_drill_0320 0 0 0 rio.pg_catalog.pg_statistic 0 0 0.3 rio.public.temp0000294072 0 0 0.05 rio.pg_catalog.pg_index 0 0 0.03 rio.pg_catalog.pg_type 0 0 0.03 contagem.public.nf_entrada 0 0 0.04 brasilia.auditor.auditor_2026_10 0 0 4.32 brasilia.public.temp0000242140 0 0 0 brasilia.public.lotes_saidas 0 0 0.13 brasilia.public.temp0000242186 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.03 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.auditor.auditor_2026_10 0 0 2.91 rio.pg_catalog.pg_attribute 0 0 0.12 contagem.public.temp0000227528 0 0 0 rio.pg_catalog.pg_depend 0 0 0.1 brasilia.public.temp0000242184 0 0 0 Total 0 0 11.85 Tuples removed per table
Key values
- pg_catalog.pg_attribute (61444) Main table with removed tuples on database contagem
- 143500 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 14 14 61,444 345,614 0 314 7,597 brasilia.pg_catalog.pg_attribute 11 11 43,375 243,931 0 142 6,148 rio.pg_catalog.pg_attribute 1 1 4,993 22,097 0 0 562 brasilia.pg_catalog.pg_statistic 2 2 4,970 15,379 0 0 2,142 rio.pg_catalog.pg_statistic 1 1 4,441 7,464 0 0 1,286 contagem.pg_catalog.pg_statistic 1 1 4,242 7,274 0 0 1,011 contagem.pg_catalog.pg_type 7 7 3,513 15,737 0 42 438 contagem.public.usuarios 33 0 2,035 792 0 0 66 testes.pg_catalog.pg_shdepend 2 2 1,919 35,983 0 0 302 contagem.pg_catalog.pg_class 6 6 1,804 22,370 0 117 785 rio.pg_catalog.pg_shdepend 2 2 1,642 36,040 0 0 302 contagem.pg_catalog.pg_index 4 4 1,545 7,587 0 14 200 brasilia.pg_catalog.pg_type 5 5 1,493 11,121 0 16 311 brasilia.pg_catalog.pg_depend 2 2 1,046 36,583 0 0 348 rio.pg_toast.pg_toast_2619 1 1 764 671 0 0 292 contagem.pg_catalog.pg_depend 4 4 719 76,014 0 0 704 brasilia.pg_catalog.pg_class 6 6 558 20,448 0 0 723 rio.public.tmp_drill_0320 1 1 552 552 0 0 15 brasilia.pg_catalog.pg_index 3 3 530 5,682 0 0 147 rio.pg_catalog.pg_type 1 1 519 2,221 0 0 73 rio.pg_catalog.pg_depend 1 1 263 18,830 0 0 188 rio.pg_catalog.pg_index 1 1 238 1,899 0 0 52 brasilia.auditor.auditor_2026_10 1 0 234 2,150,792 0 0 94,233 contagem.public.nf_entrada 1 1 225 1,494 0 0 87 brasilia.pg_toast.pg_toast_2619 2 2 210 280 0 0 130 contagem.pg_toast.pg_toast_2619 1 1 136 112 0 0 57 rio.pg_catalog.pg_class 2 2 73 6,802 0 18 216 brasilia.public.lotes_saidas 1 1 17 5,484 0 0 71 rio.public.temp0000294078 1 0 0 26,493 0 0 1,920 rio.public.temp0000294084 2 0 0 52,988 0 0 3,840 brasilia.public.temp0000242126 2 0 0 6,814 0 0 512 rio.public.temp0000294082 1 0 0 26,494 0 0 1,920 rio.public.temp0000294072 1 0 0 26,494 0 0 1,920 contagem.public.temp0000227524 2 0 0 2,240 0 36 92 brasilia.public.temp0000242140 1 0 0 3,406 0 0 256 brasilia.public.temp0000242186 1 0 0 3,410 0 0 256 brasilia.public.temp0000242148 4 0 0 13,628 0 0 1,024 rio.public.temp0000294080 4 0 0 105,973 0 0 7,680 contagem.auditor.auditor_2026_10 1 0 0 1,501,687 0 0 65,913 contagem.public.temp0000227528 1 0 0 1,417 0 17 111 contagem.public.temp0000227530 7 0 0 9,923 0 119 777 brasilia.public.temp0000242184 1 0 0 3,410 0 0 256 Total 146 83 143,500 4,883,630 0 835 204,963 Pages removed per table
Key values
- pg_catalog.pg_attribute (314) Main table with removed pages on database contagem
- 835 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_attribute 14 14 61444 314 brasilia.pg_catalog.pg_attribute 11 11 43375 142 contagem.public.temp0000227530 7 0 0 119 contagem.pg_catalog.pg_class 6 6 1804 117 contagem.pg_catalog.pg_type 7 7 3513 42 contagem.public.temp0000227524 2 0 0 36 rio.pg_catalog.pg_class 2 2 73 18 contagem.public.temp0000227528 1 0 0 17 brasilia.pg_catalog.pg_type 5 5 1493 16 contagem.pg_catalog.pg_index 4 4 1545 14 rio.public.temp0000294078 1 0 0 0 rio.public.temp0000294084 2 0 0 0 brasilia.public.temp0000242126 2 0 0 0 rio.public.temp0000294082 1 0 0 0 rio.pg_toast.pg_toast_2619 1 1 764 0 rio.public.tmp_drill_0320 1 1 552 0 brasilia.pg_catalog.pg_depend 2 2 1046 0 rio.pg_catalog.pg_statistic 1 1 4441 0 rio.public.temp0000294072 1 0 0 0 rio.pg_catalog.pg_index 1 1 238 0 brasilia.pg_catalog.pg_index 3 3 530 0 rio.pg_catalog.pg_type 1 1 519 0 contagem.public.nf_entrada 1 1 225 0 brasilia.auditor.auditor_2026_10 1 0 234 0 brasilia.public.temp0000242140 1 0 0 0 rio.pg_catalog.pg_shdepend 2 2 1642 0 contagem.pg_catalog.pg_depend 4 4 719 0 testes.pg_catalog.pg_shdepend 2 2 1919 0 brasilia.public.lotes_saidas 1 1 17 0 brasilia.public.temp0000242186 1 0 0 0 brasilia.public.temp0000242148 4 0 0 0 rio.public.temp0000294080 4 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 4970 0 contagem.pg_catalog.pg_statistic 1 1 4242 0 contagem.pg_toast.pg_toast_2619 1 1 136 0 contagem.auditor.auditor_2026_10 1 0 0 0 rio.pg_catalog.pg_attribute 1 1 4993 0 contagem.public.usuarios 33 0 2035 0 brasilia.pg_toast.pg_toast_2619 2 2 210 0 brasilia.pg_catalog.pg_class 6 6 558 0 rio.pg_catalog.pg_depend 1 1 263 0 brasilia.public.temp0000242184 1 0 0 0 Total 146 83 143,500 835 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Oct 14 00 0 2 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 0 0 08 14 35 09 9 19 10 24 48 11 15 51 12 2 5 13 10 19 14 15 29 15 6 11 16 9 21 17 27 56 18 8 10 19 0 0 20 0 0 21 1 1 22 0 0 23 0 0 - 4.32 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 8m33s 1m22s 7m10s 4m16s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:22:31 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 17:51:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:25:29 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 7m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-14 18:22:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1m22s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-14 17:51:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 1,001 Total read queries
- 567 Total write queries
Queries by database
Key values
- brasilia Main database
- 973 Requests
- 3h23m3s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 973 1h28m22s copy to 139 10m58s ddl 98 1m3s others 241 10m6s select 495 1h6m14s contagem Total 534 12m30s copy to 117 1m24s ddl 47 25s70ms others 5 3m select 365 7m39s rio Total 495 3h23m3s copy to 148 29m48s ddl 18 3m12s others 190 18m58s select 139 2h31m3s testes Total 2 761ms select 2 761ms Queries by user
Key values
- intelifix Main user
- 1,929 Requests
User Request type Count Duration etiquetas Total 6 1s834ms select 6 1s834ms intelifix Total 1,929 5h3m18s copy to 404 42m11s ddl 163 4m41s others 436 32m5s select 926 3h44m19s lenon Total 69 36s820ms select 69 36s820ms Duration by user
Key values
- 5h3m18s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 6 1s834ms select 6 1s834ms intelifix Total 1,929 5h3m18s copy to 404 42m11s ddl 163 4m41s others 436 32m5s select 926 3h44m19s lenon Total 69 36s820ms select 69 36s820ms Queries by host
Key values
- [local] Main host
- 2,004 Requests
- 5h3m57s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 1,027 Requests
- 3h7m59s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-10-14 13:31:48 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 944 100-500ms duration
Slowest individual queries
Rank Duration Query 1 19m17s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-14 18:22:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 11m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-14 17:51:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 10m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-10-14 18:25:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 9m36s analyze verbose;[ Date: 2026-10-14 05:09:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 07:12:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m55s analyze verbose;[ Date: 2026-10-14 05:16:34 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
7 5m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 20:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 18:10:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 11:10:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 12:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 17:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 10:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 19:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 09:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 14:10:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 21:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 16:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 22:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 13:10:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-10-14 15:10:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h30m25s 48 2s402ms 7m 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 14 07 3 7m41s 2m33s 08 3 5m20s 1m46s 09 3 5m27s 1m49s 10 3 5m29s 1m49s 11 3 5m35s 1m51s 12 3 5m28s 1m49s 13 3 5m24s 1m48s 14 3 5m26s 1m48s 15 3 5m23s 1m47s 16 3 5m25s 1m48s 17 3 5m36s 1m52s 18 3 5m56s 1m58s 19 3 5m27s 1m49s 20 3 5m50s 1m56s 21 3 5m25s 1m48s 22 3 5m24s 1m48s [ User: intelifix - Total duration: 1h30m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 07:12:01 Duration: 7m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 20:10:33 Duration: 5m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 18:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
2 1h3m40s 48 248ms 3m47s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 14 07 3 4m53s 1m37s 08 3 3m50s 1m16s 09 3 3m53s 1m17s 10 3 3m52s 1m17s 11 3 3m56s 1m18s 12 3 3m54s 1m18s 13 3 3m51s 1m17s 14 3 3m53s 1m17s 15 3 3m55s 1m18s 16 3 3m56s 1m18s 17 3 3m57s 1m19s 18 3 3m59s 1m19s 19 3 3m54s 1m18s 20 3 3m56s 1m18s 21 3 3m50s 1m16s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h3m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 07:17:28 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 22:14:26 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 18:14:48 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
3 59m40s 84 190ms 19m17s 42s627ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 07 14 4m46s 20s432ms 08 14 2m54s 12s460ms 09 3 1s744ms 581ms 10 7 44s954ms 6s422ms 11 12 46s390ms 3s865ms 12 2 1s551ms 775ms 13 5 47s379ms 9s475ms 14 4 7s837ms 1s959ms 15 2 4s401ms 2s200ms 16 2 2s396ms 1s198ms 17 13 15m11s 1m10s 18 6 34m12s 5m42s [ User: intelifix - Total duration: 59m40s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 59m40s - Times executed: 84 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:22:31 Duration: 19m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 17:51:46 Duration: 11m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:25:29 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 19m16s 3 2m44s 9m36s 6m25s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 14 05 3 19m16s 6m25s [ User: intelifix - Total duration: 19m16s - Times executed: 3 ]
[ Application: psql - Total duration: 19m16s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-14 05:09:38 Duration: 9m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-14 05:16:34 Duration: 6m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-14 05:19:18 Duration: 2m44s Database: contagem User: intelifix Remote: [local] Application: psql
5 6m54s 276 207ms 11s237ms 1s502ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 14 00 12 27s459ms 2s288ms 01 12 17s132ms 1s427ms 02 12 16s619ms 1s384ms 03 12 16s742ms 1s395ms 04 12 16s493ms 1s374ms 05 12 16s473ms 1s372ms 06 12 16s812ms 1s401ms 07 12 16s644ms 1s387ms 08 12 17s57ms 1s421ms 09 12 17s59ms 1s421ms 10 12 16s942ms 1s411ms 11 12 16s840ms 1s403ms 12 12 17s13ms 1s417ms 13 12 17s246ms 1s437ms 14 12 16s897ms 1s408ms 15 12 17s818ms 1s484ms 16 12 17s907ms 1s492ms 17 12 17s375ms 1s447ms 18 12 21s797ms 1s816ms 19 12 18s64ms 1s505ms 20 12 22s826ms 1s902ms 21 12 17s719ms 1s476ms 22 12 17s632ms 1s469ms [ User: intelifix - Total duration: 6m54s - Times executed: 276 ]
[ Application: psql - Total duration: 6m54s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 00:05:12 Duration: 11s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 20:15:09 Duration: 7s445ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 18:15:08 Duration: 6s255ms Database: rio User: intelifix Remote: [local] Application: psql
6 4m4s 325 151ms 3s621ms 751ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 08 23 26s119ms 1s135ms 09 56 43s219ms 771ms 10 30 12s125ms 404ms 11 72 37s512ms 521ms 12 12 5s390ms 449ms 13 54 18s209ms 337ms 14 19 21s23ms 1s106ms 15 14 22s360ms 1s597ms 16 24 28s647ms 1s193ms 17 20 29s208ms 1s460ms 18 1 276ms 276ms [ User: intelifix - Total duration: 4m4s - Times executed: 325 ]
[ Application: [unknown] - Total duration: 4m4s - Times executed: 325 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61941, 406, '270911029076108867,229670587693,229746191324,229815175564,229741696485,229726954766,229812267996,229736675860,229864928804,229750261923,229736498289,229805241823,229933324042,229743223144,229669782935,229781867083,229687037783,229737453445,216938571216,229672574352,229726616674,229690817187,229812733553,229817114463,229836586071,216939944346,229740293958,229753849815,229686223956,229747681234,216937274052,229673179393,229660653649,229816861633,229727348800,229813633349,229811033039,229686281212,229781507070,229672506466,229691557798,229691462638,229836766672,229737372730', '246515580828,246550085070,246530236881,246526784053,246547635762,246629737680,246544504862,246649721315,246490538911,246535284355,246598446366,246133371113,246539489614,246515563755,246584931322,226261076583,246569005659,246475461727,246493756284,246506938288,246516353742,226377738484,246630941323,246641237377,246477008083,246444295778,246571282021,246500144461,246550072645,246091214260,246491103040,246457219799,246628334244,246544667077,246630496273,246641024652,246502306366,246587810021,246488825971,246513655566,246514152843,246640689614,246569018589', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-10-14 17:35:58 Duration: 3s621ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61931, 407, '834164924002040,241607213942,241619591739,241608672637,241732060931,241704162237,241605368991,241654444051,241726963048,241604903739,241727010505,241708808201,241695558792,241659690916,241713745966,241728522336,241731253343,241704257576,241614516282,241660135560,241704277881,241646275577,241646420822,241727049801,241730943739,241715037091,241692609504,241731204348,241728683945,241673278694,241620744163,241689178495,241653828604,241593240211,241605369597,241708903541,241708399394,241697500117', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-14 17:32:07 Duration: 3s114ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61602, 407, '317143303751,B42A0ED3D522,BC9B689620DF,14B7F88C5922,1062D010B934,480033E9BD53,383FB3A81397,A456CCE08D2C,10C25A167663,D4B92F2DDE90,80D04AB9AC63,80D04A971F79,383FB3A7B732,80D04ABC0870,90585146EC21,A456CCDFF5DA,1062D0C78EF7,54A65C8D8133,B42A0E1906FA,90585144A95F,1062D0C76F62,D4B92F2F2051', '',046,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":""}]','$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-14 08:38:20 Duration: 3s107ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 2m18s 4 4s352ms 1m4s 34s561ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 14 20 2 1m8s 34s451ms 23 2 1m9s 34s672ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-14 23:16:42 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-14 20:08:45 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-14 20:10:45 Duration: 4s564ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 1m49s 4 342ms 55s587ms 27s412ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 14 20 2 55s936ms 27s968ms 23 2 53s712ms 26s856ms [ User: intelifix - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-14 20:05:47 Duration: 55s587ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-14 23:13:45 Duration: 53s370ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-14 20:10:10 Duration: 349ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 1m49s 6 3s266ms 40s558ms 18s189ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 14 20 3 54s460ms 18s153ms 23 3 54s675ms 18s225ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-14 20:06:29 Duration: 40s558ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-14 23:14:26 Duration: 40s381ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-14 23:33:42 Duration: 10s996ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 1m48s 32 832ms 16s230ms 3s393ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 14 07 2 11s148ms 5s574ms 08 3 6s352ms 2s117ms 09 3 7s858ms 2s619ms 10 4 28s314ms 7s78ms 11 2 6s49ms 3s24ms 12 1 1s496ms 1s496ms 13 1 2s979ms 2s979ms 14 2 5s645ms 2s822ms 15 1 3s225ms 3s225ms 17 13 35s510ms 2s731ms [ User: intelifix - Total duration: 1m48s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 32 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-14 10:40:41 Duration: 16s230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0404, '', '', 0, 7, '2026-10-01');
Date: 2026-10-14 07:04:08 Duration: 8s767ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-14 10:42:45 Duration: 8s511ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 1m24s 6 2s323ms 32s333ms 14s63ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 14 20 3 42s413ms 14s137ms 23 3 41s966ms 13s988ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-14 20:07:04 Duration: 32s333ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-14 23:15:01 Duration: 31s799ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-14 23:33:51 Duration: 7s843ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 1m24s 1 1m24s 1m24s 1m24s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 14 05 1 1m24s 1m24s [ User: intelifix - Total duration: 1m24s - Times executed: 1 ]
[ Application: psql - Total duration: 1m24s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-14 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-14 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
13 1m22s 6 2s986ms 31s892ms 13s833ms copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 14 20 3 41s506ms 13s835ms 23 3 41s491ms 13s830ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-14 20:09:18 Duration: 31s892ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-14 23:17:14 Duration: 31s821ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-14 23:34:13 Duration: 6s629ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 1m19s 57 569ms 22s240ms 1s396ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 14 08 3 2s303ms 767ms 09 3 2s447ms 815ms 10 5 4s84ms 816ms 11 3 2s406ms 802ms 12 3 5s183ms 1s727ms 13 4 3s295ms 823ms 14 3 2s222ms 740ms 15 4 2s909ms 727ms 16 3 5s458ms 1s819ms 17 4 10s488ms 2s622ms 18 5 25s354ms 5s70ms 19 5 3s662ms 732ms 20 4 3s305ms 826ms 21 4 3s75ms 768ms 22 4 3s397ms 849ms [ User: intelifix - Total duration: 1m19s - Times executed: 57 ]
[ Application: psql - Total duration: 1m19s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 18:00:24 Duration: 22s240ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 17:00:10 Duration: 8s88ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 16:40:06 Duration: 3s834ms Database: brasilia User: intelifix Remote: [local] Application: psql
15 1m12s 6 2s546ms 24s66ms 12s88ms copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 14 20 3 36s126ms 12s42ms 23 3 36s405ms 12s135ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 23:10:47 Duration: 24s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 20:02:47 Duration: 23s703ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 20:09:38 Duration: 9s842ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m11s 6 2s229ms 24s329ms 11s939ms copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 14 20 3 35s697ms 11s899ms 23 3 35s941ms 11s980ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 23:11:29 Duration: 24s329ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 20:03:28 Duration: 24s194ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 23:33:11 Duration: 9s381ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m4s 6 1s718ms 25s456ms 10s779ms copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 14 20 3 32s450ms 10s816ms 23 3 32s223ms 10s741ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-14 20:04:27 Duration: 25s456ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-14 23:12:28 Duration: 25s243ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-14 20:10:05 Duration: 5s276ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 1m1s 56 188ms 2s615ms 1s94ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 14 00 1 188ms 188ms 07 3 4s489ms 1s496ms 08 6 6s862ms 1s143ms 09 5 6s834ms 1s366ms 10 6 9s354ms 1s559ms 11 6 7s417ms 1s236ms 12 6 6s65ms 1s10ms 13 6 4s60ms 676ms 14 6 6s181ms 1s30ms 15 2 2s798ms 1s399ms 16 6 5s657ms 942ms 17 3 1s376ms 458ms [ User: intelifix - Total duration: 1m1s - Times executed: 56 ]
[ Application: psql - Total duration: 1m1s - Times executed: 56 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-14 07:25:06 Duration: 2s615ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-14 08:55:06 Duration: 2s337ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-14 11:45:05 Duration: 2s22ms Database: brasilia User: intelifix Remote: [local] Application: psql
19 59s345ms 6 5s138ms 13s549ms 9s890ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 14 00 3 37s58ms 12s352ms 06 3 22s286ms 7s428ms [ User: intelifix - Total duration: 59s345ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s345ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-14 00:05:28 Duration: 13s549ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-14 00:05:14 Duration: 12s918ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-14 00:05:38 Duration: 10s590ms Database: contagem User: intelifix Remote: [local] Application: psql
20 56s362ms 159 157ms 1s23ms 354ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 14 08 11 5s461ms 496ms 09 12 4s165ms 347ms 10 21 7s923ms 377ms 11 32 10s184ms 318ms 12 21 7s316ms 348ms 13 5 2s228ms 445ms 14 7 2s957ms 422ms 15 15 4s862ms 324ms 16 21 6s591ms 313ms 17 14 4s670ms 333ms [ User: intelifix - Total duration: 56s362ms - Times executed: 159 ]
[ Application: [unknown] - Total duration: 56s362ms - Times executed: 159 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295432", "modelo" : "126", "itens" : "602E20BE68CA,C4447D26F062,48570265F82B,8CE5EFEC3AFA,10C172CD74BE,4857028A5102,4857028A1CF2,485702679E3F,AC751D1467BE,40EEDDA41D81,C4447D0D1BE6,AC751D15BFAD,C4447D469519", "usuario" : "320", "caixa" : "3799882", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-14 08:50:38 Duration: 1s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140638", "modelo" : "323", "itens" : "3891484F0507,D83139A188DA,3891484F2097,F4E84F81D610,3CF9F0AAD586,6C11BA688B21,3891484A86CF,14CA56D02EF9,843C992C290D,843C9920328B,5872C98B0F73,D89A0D829977,5872C99520A3,D89A0DACBE9B,F4E84F88CF3A,3CF9F0A575D0,4896D956B712", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-14 11:50:43 Duration: 833ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140517", "modelo" : "312", "itens" : "10A793435D8B,F8D2ACFB8CCB,B85E71ADA593,F8D2ACF734A3,10A79334443B,F8D2ACFA6863,10A79342D9A3,CCF3C85BAFD3,48BDCE719183,B85E71AE252B", "usuario" : "428", "caixa" : "407559", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "bianca[[tela]]" }');
Date: 2026-10-14 08:18:43 Duration: 699ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 325 4m4s 151ms 3s621ms 751ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 14 08 23 26s119ms 1s135ms 09 56 43s219ms 771ms 10 30 12s125ms 404ms 11 72 37s512ms 521ms 12 12 5s390ms 449ms 13 54 18s209ms 337ms 14 19 21s23ms 1s106ms 15 14 22s360ms 1s597ms 16 24 28s647ms 1s193ms 17 20 29s208ms 1s460ms 18 1 276ms 276ms [ User: intelifix - Total duration: 4m4s - Times executed: 325 ]
[ Application: [unknown] - Total duration: 4m4s - Times executed: 325 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61941, 406, '270911029076108867,229670587693,229746191324,229815175564,229741696485,229726954766,229812267996,229736675860,229864928804,229750261923,229736498289,229805241823,229933324042,229743223144,229669782935,229781867083,229687037783,229737453445,216938571216,229672574352,229726616674,229690817187,229812733553,229817114463,229836586071,216939944346,229740293958,229753849815,229686223956,229747681234,216937274052,229673179393,229660653649,229816861633,229727348800,229813633349,229811033039,229686281212,229781507070,229672506466,229691557798,229691462638,229836766672,229737372730', '246515580828,246550085070,246530236881,246526784053,246547635762,246629737680,246544504862,246649721315,246490538911,246535284355,246598446366,246133371113,246539489614,246515563755,246584931322,226261076583,246569005659,246475461727,246493756284,246506938288,246516353742,226377738484,246630941323,246641237377,246477008083,246444295778,246571282021,246500144461,246550072645,246091214260,246491103040,246457219799,246628334244,246544667077,246630496273,246641024652,246502306366,246587810021,246488825971,246513655566,246514152843,246640689614,246569018589', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-10-14 17:35:58 Duration: 3s621ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61931, 407, '834164924002040,241607213942,241619591739,241608672637,241732060931,241704162237,241605368991,241654444051,241726963048,241604903739,241727010505,241708808201,241695558792,241659690916,241713745966,241728522336,241731253343,241704257576,241614516282,241660135560,241704277881,241646275577,241646420822,241727049801,241730943739,241715037091,241692609504,241731204348,241728683945,241673278694,241620744163,241689178495,241653828604,241593240211,241605369597,241708903541,241708399394,241697500117', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-14 17:32:07 Duration: 3s114ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (61602, 407, '317143303751,B42A0ED3D522,BC9B689620DF,14B7F88C5922,1062D010B934,480033E9BD53,383FB3A81397,A456CCE08D2C,10C25A167663,D4B92F2DDE90,80D04AB9AC63,80D04A971F79,383FB3A7B732,80D04ABC0870,90585146EC21,A456CCDFF5DA,1062D0C78EF7,54A65C8D8133,B42A0E1906FA,90585144A95F,1062D0C76F62,D4B92F2F2051', '',046,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":""}]','$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-10-14 08:38:20 Duration: 3s107ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 276 6m54s 207ms 11s237ms 1s502ms call rs_giga_triagem (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 14 00 12 27s459ms 2s288ms 01 12 17s132ms 1s427ms 02 12 16s619ms 1s384ms 03 12 16s742ms 1s395ms 04 12 16s493ms 1s374ms 05 12 16s473ms 1s372ms 06 12 16s812ms 1s401ms 07 12 16s644ms 1s387ms 08 12 17s57ms 1s421ms 09 12 17s59ms 1s421ms 10 12 16s942ms 1s411ms 11 12 16s840ms 1s403ms 12 12 17s13ms 1s417ms 13 12 17s246ms 1s437ms 14 12 16s897ms 1s408ms 15 12 17s818ms 1s484ms 16 12 17s907ms 1s492ms 17 12 17s375ms 1s447ms 18 12 21s797ms 1s816ms 19 12 18s64ms 1s505ms 20 12 22s826ms 1s902ms 21 12 17s719ms 1s476ms 22 12 17s632ms 1s469ms [ User: intelifix - Total duration: 6m54s - Times executed: 276 ]
[ Application: psql - Total duration: 6m54s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 00:05:12 Duration: 11s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 20:15:09 Duration: 7s445ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 18:15:08 Duration: 6s255ms Database: rio User: intelifix Remote: [local] Application: psql
3 159 56s362ms 157ms 1s23ms 354ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 08 11 5s461ms 496ms 09 12 4s165ms 347ms 10 21 7s923ms 377ms 11 32 10s184ms 318ms 12 21 7s316ms 348ms 13 5 2s228ms 445ms 14 7 2s957ms 422ms 15 15 4s862ms 324ms 16 21 6s591ms 313ms 17 14 4s670ms 333ms [ User: intelifix - Total duration: 56s362ms - Times executed: 159 ]
[ Application: [unknown] - Total duration: 56s362ms - Times executed: 159 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "295432", "modelo" : "126", "itens" : "602E20BE68CA,C4447D26F062,48570265F82B,8CE5EFEC3AFA,10C172CD74BE,4857028A5102,4857028A1CF2,485702679E3F,AC751D1467BE,40EEDDA41D81,C4447D0D1BE6,AC751D15BFAD,C4447D469519", "usuario" : "320", "caixa" : "3799882", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-14 08:50:38 Duration: 1s23ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140638", "modelo" : "323", "itens" : "3891484F0507,D83139A188DA,3891484F2097,F4E84F81D610,3CF9F0AAD586,6C11BA688B21,3891484A86CF,14CA56D02EF9,843C992C290D,843C9920328B,5872C98B0F73,D89A0D829977,5872C99520A3,D89A0DACBE9B,F4E84F88CF3A,3CF9F0A575D0,4896D956B712", "usuario" : "427", "caixa" : "0", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-10-14 11:50:43 Duration: 833ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "140517", "modelo" : "312", "itens" : "10A793435D8B,F8D2ACFB8CCB,B85E71ADA593,F8D2ACF734A3,10A79334443B,F8D2ACFA6863,10A79342D9A3,CCF3C85BAFD3,48BDCE719183,B85E71AE252B", "usuario" : "428", "caixa" : "407559", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "bianca[[tela]]" }');
Date: 2026-10-14 08:18:43 Duration: 699ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 84 59m40s 190ms 19m17s 42s627ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 14 07 14 4m46s 20s432ms 08 14 2m54s 12s460ms 09 3 1s744ms 581ms 10 7 44s954ms 6s422ms 11 12 46s390ms 3s865ms 12 2 1s551ms 775ms 13 5 47s379ms 9s475ms 14 4 7s837ms 1s959ms 15 2 4s401ms 2s200ms 16 2 2s396ms 1s198ms 17 13 15m11s 1m10s 18 6 34m12s 5m42s [ User: intelifix - Total duration: 59m40s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 59m40s - Times executed: 84 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:22:31 Duration: 19m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 17:51:46 Duration: 11m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:25:29 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 61 19s171ms 300ms 362ms 314ms 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 #5
Day Hour Count Duration Avg duration Oct 14 07 3 919ms 306ms 08 7 2s168ms 309ms 09 5 1s551ms 310ms 10 7 2s250ms 321ms 11 9 2s901ms 322ms 12 1 303ms 303ms 13 6 1s877ms 312ms 14 4 1s242ms 310ms 15 5 1s605ms 321ms 16 6 1s867ms 311ms 17 6 1s867ms 311ms 18 2 617ms 308ms [ User: lenon - Total duration: 19s171ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 19s171ms - Times executed: 61 ]
-
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-10-14 10:11:02 Duration: 362ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-14 11:23:27 Duration: 348ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-10-14 15:14:09 Duration: 339ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
6 57 1m19s 569ms 22s240ms 1s396ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 08 3 2s303ms 767ms 09 3 2s447ms 815ms 10 5 4s84ms 816ms 11 3 2s406ms 802ms 12 3 5s183ms 1s727ms 13 4 3s295ms 823ms 14 3 2s222ms 740ms 15 4 2s909ms 727ms 16 3 5s458ms 1s819ms 17 4 10s488ms 2s622ms 18 5 25s354ms 5s70ms 19 5 3s662ms 732ms 20 4 3s305ms 826ms 21 4 3s75ms 768ms 22 4 3s397ms 849ms [ User: intelifix - Total duration: 1m19s - Times executed: 57 ]
[ Application: psql - Total duration: 1m19s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 18:00:24 Duration: 22s240ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 17:00:10 Duration: 8s88ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 16:40:06 Duration: 3s834ms Database: brasilia User: intelifix Remote: [local] Application: psql
7 56 1m1s 188ms 2s615ms 1s94ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 14 00 1 188ms 188ms 07 3 4s489ms 1s496ms 08 6 6s862ms 1s143ms 09 5 6s834ms 1s366ms 10 6 9s354ms 1s559ms 11 6 7s417ms 1s236ms 12 6 6s65ms 1s10ms 13 6 4s60ms 676ms 14 6 6s181ms 1s30ms 15 2 2s798ms 1s399ms 16 6 5s657ms 942ms 17 3 1s376ms 458ms [ User: intelifix - Total duration: 1m1s - Times executed: 56 ]
[ Application: psql - Total duration: 1m1s - Times executed: 56 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-14 07:25:06 Duration: 2s615ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-14 08:55:06 Duration: 2s337ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-10-14 11:45:05 Duration: 2s22ms Database: brasilia User: intelifix Remote: [local] Application: psql
8 48 1h30m25s 2s402ms 7m 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 14 07 3 7m41s 2m33s 08 3 5m20s 1m46s 09 3 5m27s 1m49s 10 3 5m29s 1m49s 11 3 5m35s 1m51s 12 3 5m28s 1m49s 13 3 5m24s 1m48s 14 3 5m26s 1m48s 15 3 5m23s 1m47s 16 3 5m25s 1m48s 17 3 5m36s 1m52s 18 3 5m56s 1m58s 19 3 5m27s 1m49s 20 3 5m50s 1m56s 21 3 5m25s 1m48s 22 3 5m24s 1m48s [ User: intelifix - Total duration: 1h30m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 07:12:01 Duration: 7m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 20:10:33 Duration: 5m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 18:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
9 48 1h3m40s 248ms 3m47s 1m19s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 14 07 3 4m53s 1m37s 08 3 3m50s 1m16s 09 3 3m53s 1m17s 10 3 3m52s 1m17s 11 3 3m56s 1m18s 12 3 3m54s 1m18s 13 3 3m51s 1m17s 14 3 3m53s 1m17s 15 3 3m55s 1m18s 16 3 3m56s 1m18s 17 3 3m57s 1m19s 18 3 3m59s 1m19s 19 3 3m54s 1m18s 20 3 3m56s 1m18s 21 3 3m50s 1m16s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h3m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 07:17:28 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 22:14:26 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 18:14:48 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
10 48 17s758ms 336ms 443ms 369ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 14 07 1 368ms 368ms 08 5 1s899ms 379ms 09 5 1s815ms 363ms 10 6 2s270ms 378ms 11 8 2s958ms 369ms 12 1 364ms 364ms 13 6 2s204ms 367ms 14 2 754ms 377ms 15 3 1s71ms 357ms 16 5 1s875ms 375ms 17 5 1s829ms 365ms 18 1 347ms 347ms [ User: intelifix - Total duration: 17s758ms - Times executed: 48 ]
[ Application: [unknown] - Total duration: 17s758ms - Times executed: 48 ]
-
select * from rs_menu_grants (416, 53, 1);
Date: 2026-10-14 11:23:27 Duration: 443ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (302, 16, 1);
Date: 2026-10-14 08:17:28 Duration: 417ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-10-14 16:15:05 Duration: 401ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 32 1m48s 832ms 16s230ms 3s393ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 14 07 2 11s148ms 5s574ms 08 3 6s352ms 2s117ms 09 3 7s858ms 2s619ms 10 4 28s314ms 7s78ms 11 2 6s49ms 3s24ms 12 1 1s496ms 1s496ms 13 1 2s979ms 2s979ms 14 2 5s645ms 2s822ms 15 1 3s225ms 3s225ms 17 13 35s510ms 2s731ms [ User: intelifix - Total duration: 1m48s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 32 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-14 10:40:41 Duration: 16s230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0404, '', '', 0, 7, '2026-10-01');
Date: 2026-10-14 07:04:08 Duration: 8s767ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-14 10:42:45 Duration: 8s511ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 31 9s337ms 161ms 549ms 301ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 14 08 4 1s513ms 378ms 09 7 2s522ms 360ms 10 10 2s819ms 281ms 11 10 2s482ms 248ms [ User: intelifix - Total duration: 9s337ms - Times executed: 31 ]
[ Application: [unknown] - Total duration: 9s337ms - Times executed: 31 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '6C11BA6F70F5,3891484C0273,3CF9F0A5760C,4896D9566E2E,C4EBFF8CD864,D89A0DB03647,D8313998C8D6,843C99219323,4896D958C51A,843C992C7713,D8313921678C,D831398BEDFA,14CA56D014EF,6C11BA6BF685,5872C9937F43,843C9935037B,D89A0DB02EFD,F00C51564A6E,48D682320128,3891485300FB', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-14 08:51:54 Duration: 549ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '142004591D62,14200458625A,14200457C49A,7C7D21F1EF73,14200457CCA2,E44E12B1F8F1,14200452F036,14200457CC12,7C7D21F0D11F,7C7D21F02773,14200454DD96,E44E129302FF,E44E1292FBB7,DC5193D90A62,DC5193DA9336,14200457CCAA,DC5193DAAA1E,7C7D21F1126F,1420045863E6,14200457951A', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-10-14 09:03:29 Duration: 535ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D83139903DB8,646E6019114C,C4EBFF8FA68A,3891484B0A5D,D831391F2390,3891484A9059,6C11BA6D4031,3CF9F0AB283C,F4E84F84D98E,4896D9526CE2,D83139904436,5872C98B0F7F,D83139981A34,F00C514D586C,4896D956794A,4896D95A363E,D831399B786C,843C993602E1,843C992E7507,5872C98D939B', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-10-14 09:20:17 Duration: 500ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 31 8s795ms 263ms 389ms 283ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 14 07 3 863ms 287ms 08 6 1s647ms 274ms 09 1 270ms 270ms 10 3 828ms 276ms 11 1 281ms 281ms 12 1 266ms 266ms 14 2 559ms 279ms 15 1 264ms 264ms 16 1 274ms 274ms 17 10 2s957ms 295ms 18 2 583ms 291ms [ User: intelifix - Total duration: 8s795ms - Times executed: 31 ]
[ Application: [unknown] - Total duration: 8s795ms - Times executed: 31 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-10-14 17:25:01 Duration: 389ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-10-14 18:00:34 Duration: 307ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-10-14 17:34:18 Duration: 307ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 30 27s431ms 584ms 2s972ms 914ms 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 #14
Day Hour Count Duration Avg duration Oct 14 08 3 4s554ms 1s518ms 09 3 2s532ms 844ms 10 1 720ms 720ms 11 3 2s733ms 911ms 12 2 1s609ms 804ms 13 2 1s499ms 749ms 14 3 2s595ms 865ms 15 2 1s626ms 813ms 16 2 1s597ms 798ms 17 1 585ms 585ms 18 1 1s230ms 1s230ms 19 1 1s18ms 1s18ms 20 2 1s997ms 998ms 21 2 1s496ms 748ms 22 2 1s632ms 816ms [ User: intelifix - Total duration: 27s431ms - Times executed: 30 ]
[ Application: psql - Total duration: 27s431ms - Times executed: 30 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-14 08:00:04 Duration: 2s972ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-14 18:20:02 Duration: 1s230ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-10-14 20:20:02 Duration: 1s194ms Database: rio User: intelifix Remote: [local] Application: psql
15 20 7s395ms 343ms 437ms 369ms create table temp0000227530 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 14 10 17 6s216ms 365ms 11 3 1s178ms 392ms [ User: intelifix - Total duration: 7s395ms - Times executed: 20 ]
[ Application: [unknown] - Total duration: 7s395ms - Times executed: 20 ]
-
CREATE TABLE temp0000227530 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-10-14 11:23:28 Duration: 437ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227530 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-10-14 10:12:34 Duration: 412ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227530 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-10-14 10:15:22 Duration: 390ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
16 13 5s34ms 365ms 430ms 387ms select * from rs_menu (?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 14 07 2 803ms 401ms 08 2 809ms 404ms 10 1 408ms 408ms 11 1 384ms 384ms 14 2 744ms 372ms 15 2 770ms 385ms 16 1 370ms 370ms 17 1 365ms 365ms 18 1 378ms 378ms [ User: intelifix - Total duration: 5s34ms - Times executed: 13 ]
[ Application: [unknown] - Total duration: 5s34ms - Times executed: 13 ]
-
SELECT * FROM RS_MENU (407, 1);
Date: 2026-10-14 08:26:40 Duration: 430ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (404, 1);
Date: 2026-10-14 07:03:57 Duration: 409ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MENU (173, 1);
Date: 2026-10-14 10:40:20 Duration: 408ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 12 50s238ms 327ms 13s344ms 4s186ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 14 08 1 327ms 327ms 11 7 38s605ms 5s515ms 12 1 1s365ms 1s365ms 15 1 1s573ms 1s573ms 17 2 8s366ms 4s183ms [ User: intelifix - Total duration: 50s238ms - Times executed: 12 ]
[ Application: [unknown] - Total duration: 50s238ms - Times executed: 12 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-14 11:51:42 Duration: 13s344ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-14 11:52:08 Duration: 9s145ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-14 17:30:53 Duration: 7s441ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 11 17s635ms 438ms 2s606ms 1s603ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 14 16 11 17s635ms 1s603ms [ User: intelifix - Total duration: 17s635ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 17s635ms - Times executed: 11 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-07-01", "data-ate" : "2026-07-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-10-14 16:33:02 Duration: 2s606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-09-01", "data-ate" : "2026-09-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-10-14 16:36:02 Duration: 2s485ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-01", "data-ate" : "2026-07-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-10-14 16:33:56 Duration: 2s444ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 9 35s578ms 864ms 12s104ms 3s953ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 14 08 1 3s830ms 3s830ms 10 3 3s234ms 1s78ms 11 2 16s127ms 8s63ms 17 3 12s385ms 4s128ms [ User: intelifix - Total duration: 35s578ms - Times executed: 9 ]
[ Application: psql - Total duration: 35s578ms - Times executed: 9 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01754);
Date: 2026-10-14 11:23:39 Duration: 12s104ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04751);
Date: 2026-10-14 17:23:15 Duration: 5s577ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04750);
Date: 2026-10-14 11:37:06 Duration: 4s22ms Database: brasilia User: intelifix Remote: [local] Application: psql
20 9 2s470ms 150ms 598ms 274ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 14 13 3 1s29ms 343ms 14 6 1s440ms 240ms [ User: intelifix - Total duration: 2s470ms - Times executed: 9 ]
[ Application: [unknown] - Total duration: 2s470ms - Times executed: 9 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59277","seriais":"C85D38641B23,","usuario":"419","observacao":""}');
Date: 2026-10-14 14:02:02 Duration: 598ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59276","seriais":"840112614159,","usuario":"419","observacao":""}');
Date: 2026-10-14 13:51:22 Duration: 555ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"59276","seriais":"8C9A8F598189,","usuario":"419","observacao":""}');
Date: 2026-10-14 13:52:08 Duration: 303ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m44s 9m36s 6m25s 3 19m16s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Oct 14 05 3 19m16s 6m25s [ User: intelifix - Total duration: 19m16s - Times executed: 3 ]
[ Application: psql - Total duration: 19m16s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-10-14 05:09:38 Duration: 9m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-14 05:16:34 Duration: 6m55s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-10-14 05:19:18 Duration: 2m44s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s402ms 7m 1m53s 48 1h30m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Oct 14 07 3 7m41s 2m33s 08 3 5m20s 1m46s 09 3 5m27s 1m49s 10 3 5m29s 1m49s 11 3 5m35s 1m51s 12 3 5m28s 1m49s 13 3 5m24s 1m48s 14 3 5m26s 1m48s 15 3 5m23s 1m47s 16 3 5m25s 1m48s 17 3 5m36s 1m52s 18 3 5m56s 1m58s 19 3 5m27s 1m49s 20 3 5m50s 1m56s 21 3 5m25s 1m48s 22 3 5m24s 1m48s [ User: intelifix - Total duration: 1h30m25s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 07:12:01 Duration: 7m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 20:10:33 Duration: 5m32s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-10-14 18:10:32 Duration: 5m30s Database: rio User: intelifix Remote: [local] Application: psql
3 1m24s 1m24s 1m24s 1 1m24s refresh materialized view concurrently rs_mv_codigos_barra;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Oct 14 05 1 1m24s 1m24s [ User: intelifix - Total duration: 1m24s - Times executed: 1 ]
[ Application: psql - Total duration: 1m24s - Times executed: 1 ]
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-14 05:32:05 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-14 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 248ms 3m47s 1m19s 48 1h3m40s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Oct 14 07 3 4m53s 1m37s 08 3 3m50s 1m16s 09 3 3m53s 1m17s 10 3 3m52s 1m17s 11 3 3m56s 1m18s 12 3 3m54s 1m18s 13 3 3m51s 1m17s 14 3 3m53s 1m17s 15 3 3m55s 1m18s 16 3 3m56s 1m18s 17 3 3m57s 1m19s 18 3 3m59s 1m19s 19 3 3m54s 1m18s 20 3 3m56s 1m18s 21 3 3m50s 1m16s 22 3 4m3s 1m21s [ User: intelifix - Total duration: 1h3m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h3m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 07:17:28 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 22:14:26 Duration: 3m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-10-14 18:14:48 Duration: 3m30s Database: brasilia User: intelifix Remote: [local] Application: psql
5 190ms 19m17s 42s627ms 84 59m40s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Oct 14 07 14 4m46s 20s432ms 08 14 2m54s 12s460ms 09 3 1s744ms 581ms 10 7 44s954ms 6s422ms 11 12 46s390ms 3s865ms 12 2 1s551ms 775ms 13 5 47s379ms 9s475ms 14 4 7s837ms 1s959ms 15 2 4s401ms 2s200ms 16 2 2s396ms 1s198ms 17 13 15m11s 1m10s 18 6 34m12s 5m42s [ User: intelifix - Total duration: 59m40s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 59m40s - Times executed: 84 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:22:31 Duration: 19m17s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 17:51:46 Duration: 11m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-10-14 18:25:29 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 4s352ms 1m4s 34s561ms 4 2m18s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Oct 14 20 2 1m8s 34s451ms 23 2 1m9s 34s672ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-14 23:16:42 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-14 20:08:45 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-10-14 20:10:45 Duration: 4s564ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 342ms 55s587ms 27s412ms 4 1m49s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Oct 14 20 2 55s936ms 27s968ms 23 2 53s712ms 26s856ms [ User: intelifix - Total duration: 1m49s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-14 20:05:47 Duration: 55s587ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-14 23:13:45 Duration: 53s370ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-10-14 20:10:10 Duration: 349ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 3s266ms 40s558ms 18s189ms 6 1m49s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Oct 14 20 3 54s460ms 18s153ms 23 3 54s675ms 18s225ms [ User: intelifix - Total duration: 1m49s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m49s - Times executed: 6 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-14 20:06:29 Duration: 40s558ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-14 23:14:26 Duration: 40s381ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-10-14 23:33:42 Duration: 10s996ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 2s323ms 32s333ms 14s63ms 6 1m24s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Oct 14 20 3 42s413ms 14s137ms 23 3 41s966ms 13s988ms [ User: intelifix - Total duration: 1m24s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m24s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-14 20:07:04 Duration: 32s333ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-14 23:15:01 Duration: 31s799ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-10-14 23:33:51 Duration: 7s843ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 2s986ms 31s892ms 13s833ms 6 1m22s copy public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Oct 14 20 3 41s506ms 13s835ms 23 3 41s491ms 13s830ms [ User: intelifix - Total duration: 1m22s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m22s - Times executed: 6 ]
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-14 20:09:18 Duration: 31s892ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-14 23:17:14 Duration: 31s821ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.triagens (id, serie, mod_id, mac_address, cod_defeito, data_hora, data_criacao, status, tecnico, eq_id, tec_id, reset, temporario, mensagem, data_processo, flu_id, wifi_senha_lida, admin_password, barra3, versao, acao, ip, firmware, baixa) TO stdout;
Date: 2026-10-14 23:34:13 Duration: 6s629ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
11 2s546ms 24s66ms 12s88ms 6 1m12s copy public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Oct 14 20 3 36s126ms 12s42ms 23 3 36s405ms 12s135ms [ User: intelifix - Total duration: 1m12s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m12s - Times executed: 6 ]
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 23:10:47 Duration: 24s66ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 20:02:47 Duration: 23s703ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.codigos_barra (eq_id, eq_seq, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 20:09:38 Duration: 9s842ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
12 2s229ms 24s329ms 11s939ms 6 1m11s copy public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Oct 14 20 3 35s697ms 11s899ms 23 3 35s941ms 11s980ms [ User: intelifix - Total duration: 1m11s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m11s - Times executed: 6 ]
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 23:11:29 Duration: 24s329ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 20:03:28 Duration: 24s194ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.equipamento_codigos (eq_id, eq_sequencia, eq_codigo, eq_extra) TO stdout;
Date: 2026-10-14 23:33:11 Duration: 9s381ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
13 1s718ms 25s456ms 10s779ms 6 1m4s copy public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Oct 14 20 3 32s450ms 10s816ms 23 3 32s223ms 10s741ms [ User: intelifix - Total duration: 1m4s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m4s - Times executed: 6 ]
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-14 20:04:27 Duration: 25s456ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-14 23:12:28 Duration: 25s243ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.fluxos (flu_id, wf_id, tec_id, flu_criacao, flu_data, eq_id, flu_status, flu_final, flu_data_final, flu_garantia, flu_caixa, flu_original, flu_homologado, flu_firmware, flu_status_old) TO stdout;
Date: 2026-10-14 20:10:05 Duration: 5s276ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 5s138ms 13s549ms 9s890ms 6 59s345ms call rs_atualiza_estoque_automatico ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Oct 14 00 3 37s58ms 12s352ms 06 3 22s286ms 7s428ms [ User: intelifix - Total duration: 59s345ms - Times executed: 6 ]
[ Application: psql - Total duration: 59s345ms - Times executed: 6 ]
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-14 00:05:28 Duration: 13s549ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-14 00:05:14 Duration: 12s918ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_ATUALIZA_ESTOQUE_AUTOMATICO ();
Date: 2026-10-14 00:05:38 Duration: 10s590ms Database: contagem User: intelifix Remote: [local] Application: psql
15 327ms 13s344ms 4s186ms 12 50s238ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Oct 14 08 1 327ms 327ms 11 7 38s605ms 5s515ms 12 1 1s365ms 1s365ms 15 1 1s573ms 1s573ms 17 2 8s366ms 4s183ms [ User: intelifix - Total duration: 50s238ms - Times executed: 12 ]
[ Application: [unknown] - Total duration: 50s238ms - Times executed: 12 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059277) LIMIT 1;
Date: 2026-10-14 11:51:42 Duration: 13s344ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (059276) LIMIT 1;
Date: 2026-10-14 11:52:08 Duration: 9s145ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0139056) LIMIT 1;
Date: 2026-10-14 17:30:53 Duration: 7s441ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 864ms 12s104ms 3s953ms 9 35s578ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Oct 14 08 1 3s830ms 3s830ms 10 3 3s234ms 1s78ms 11 2 16s127ms 8s63ms 17 3 12s385ms 4s128ms [ User: intelifix - Total duration: 35s578ms - Times executed: 9 ]
[ Application: psql - Total duration: 35s578ms - Times executed: 9 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01754);
Date: 2026-10-14 11:23:39 Duration: 12s104ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04751);
Date: 2026-10-14 17:23:15 Duration: 5s577ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 398); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (04750);
Date: 2026-10-14 11:37:06 Duration: 4s22ms Database: brasilia User: intelifix Remote: [local] Application: psql
17 832ms 16s230ms 3s393ms 32 1m48s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Oct 14 07 2 11s148ms 5s574ms 08 3 6s352ms 2s117ms 09 3 7s858ms 2s619ms 10 4 28s314ms 7s78ms 11 2 6s49ms 3s24ms 12 1 1s496ms 1s496ms 13 1 2s979ms 2s979ms 14 2 5s645ms 2s822ms 15 1 3s225ms 3s225ms 17 13 35s510ms 2s731ms [ User: intelifix - Total duration: 1m48s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 32 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-14 10:40:41 Duration: 16s230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0404, '', '', 0, 7, '2026-10-01');
Date: 2026-10-14 07:04:08 Duration: 8s767ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-10-14', 0173, '', '', 0, 6, '2026-10-01');
Date: 2026-10-14 10:42:45 Duration: 8s511ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 438ms 2s606ms 1s603ms 11 17s635ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Oct 14 16 11 17s635ms 1s603ms [ User: intelifix - Total duration: 17s635ms - Times executed: 11 ]
[ Application: [unknown] - Total duration: 17s635ms - Times executed: 11 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-07-01", "data-ate" : "2026-07-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-10-14 16:33:02 Duration: 2s606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "398", "data-de" : "2026-09-01", "data-ate" : "2026-09-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 452 }');
Date: 2026-10-14 16:36:02 Duration: 2s485ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-01", "data-ate" : "2026-07-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-10-14 16:33:56 Duration: 2s444ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 207ms 11s237ms 1s502ms 276 6m54s call rs_giga_triagem (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Oct 14 00 12 27s459ms 2s288ms 01 12 17s132ms 1s427ms 02 12 16s619ms 1s384ms 03 12 16s742ms 1s395ms 04 12 16s493ms 1s374ms 05 12 16s473ms 1s372ms 06 12 16s812ms 1s401ms 07 12 16s644ms 1s387ms 08 12 17s57ms 1s421ms 09 12 17s59ms 1s421ms 10 12 16s942ms 1s411ms 11 12 16s840ms 1s403ms 12 12 17s13ms 1s417ms 13 12 17s246ms 1s437ms 14 12 16s897ms 1s408ms 15 12 17s818ms 1s484ms 16 12 17s907ms 1s492ms 17 12 17s375ms 1s447ms 18 12 21s797ms 1s816ms 19 12 18s64ms 1s505ms 20 12 22s826ms 1s902ms 21 12 17s719ms 1s476ms 22 12 17s632ms 1s469ms [ User: intelifix - Total duration: 6m54s - Times executed: 276 ]
[ Application: psql - Total duration: 6m54s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 00:05:12 Duration: 11s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 20:15:09 Duration: 7s445ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-10-14 18:15:08 Duration: 6s255ms Database: rio User: intelifix Remote: [local] Application: psql
20 569ms 22s240ms 1s396ms 57 1m19s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Oct 14 08 3 2s303ms 767ms 09 3 2s447ms 815ms 10 5 4s84ms 816ms 11 3 2s406ms 802ms 12 3 5s183ms 1s727ms 13 4 3s295ms 823ms 14 3 2s222ms 740ms 15 4 2s909ms 727ms 16 3 5s458ms 1s819ms 17 4 10s488ms 2s622ms 18 5 25s354ms 5s70ms 19 5 3s662ms 732ms 20 4 3s305ms 826ms 21 4 3s75ms 768ms 22 4 3s397ms 849ms [ User: intelifix - Total duration: 1m19s - Times executed: 57 ]
[ Application: psql - Total duration: 1m19s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 18:00:24 Duration: 22s240ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 17:00:10 Duration: 8s88ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-10-14 16:40:06 Duration: 3s834ms Database: brasilia User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Oct 14 10 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 5m11s - Times executed: 6 ]
[ Application: psql - Total duration: 5m11s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 344ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 7,324 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 1584 ERROR entries
- 0 WARNING entries
- 5 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,569 Max number of times the same event was reported
- 1,608 Total events found
Rank Times reported Error 1 1,569 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Oct 14 07 1 08 63 09 114 10 145 11 199 12 98 13 131 14 115 15 122 16 134 17 112 18 60 19 57 20 56 21 57 22 57 23 48 - ERROR: prepared statement "_PLAN000000002A2C98C0" does not exist
- ERROR: prepared statement "_PLAN0000000024113FD0" does not exist
- ERROR: prepared statement "_PLAN000000002F61D5C0" does not exist
Statement: DEALLOCATE "_PLAN000000002A2C98C0"
Date: 2026-10-14 07:26:39 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000024113FD0"
Date: 2026-10-14 08:09:48 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002F61D5C0"
Date: 2026-10-14 08:15:08 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Oct 14 01 2 06 1 07 1 11 1 12 2 17 1 22 1 - FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-10-14 01:15:37 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-14 01:15:52 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-14 06:42:37 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Oct 14 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-10-14 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-10-14 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-14 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
4 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Oct 14 05 4 - 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-10-14 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-10-14 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-10-14 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
5 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Oct 14 17 2 18 2 - LOG: process 2258239 still waiting for ShareLock on transaction 7679258 after 1000.123 ms
- LOG: process 2258239 still waiting for ShareLock on transaction 7679258 after 9550.988 ms
- LOG: process 2263729 still waiting for ShareLock on transaction 7681830 after 1000.099 ms
Detail: Process holding the lock: 2244065. Wait queue: 2258239.
Context: while updating tuple (82488,82) 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,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-14 17:50:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2244065. Wait queue: 2258239.
Context: while updating tuple (82488,82) 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,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 031106, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-14 17:50:32 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 2258239. Wait queue: 2263729.
Context: while updating tuple (82570,50) 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,boolean) line 139 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1044 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 031107, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-10-14 18:15:21 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 4 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Oct 14 11 4 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, numeric) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, numeric) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(140519,399,'919131029294,8020DA59EFE0$920111056077,A86ABBC90B91$920041043715,3093BCC62A87$919161065277,B866850C0AEC$919161044447,B866850BD1F7$920201042845,A86ABBD150FF$920061139616,F08175272F3D$919131101402,8020DA5AB50D$919451096111,34495B94A2C4$920081111663,F081752CF11D','',0129,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":""}]','$$$$$$$$$$$$$$$$$$$$$$','',0802059E0);Date: 2026-10-14 11:30:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
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(140519,399,'919131029294,8020DA59EFE0$920111056077,A86ABBC90B91$920041043715,3093BCC62A87$919161065277,B866850C0AEC$919161044447,B866850BD1F7$920201042845,A86ABBD150FF$920061139616,F08175272F3D$919131101402,8020DA5AB50D$919451096111,34495B94A2C4$920081111663,F081752CF11D','',0129,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":""}]','$$$$$$$$$$$$$$$$$$$$$$','',0802059E0);Date: 2026-10-14 11:30:11 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
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(140519,399,'919131029294,8020DA59EFE0$920111056077,A86ABBC90B91$920041043715,3093BCC62A87$919161065277,B866850C0AEC$919161044447,B866850BD1F7$920201042845,A86ABBD150FF$920061139616,F08175272F3D$919131101402,8020DA5AB50D$919451096111,34495B94A2C4$920081111663,F081752CF11D','',0129,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":""}]','$$$$$$$$$$$$$$$$$$$$$$','',0802059E0);Date: 2026-10-14 11:30:16 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Oct 14 14 3 - ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near ")" at character 34
- ERROR: syntax error at or near ")" at character 34
Statement: select * from rs_caixa_qr(407795,)
Date: 2026-10-14 14:06:58 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(407795,)
Date: 2026-10-14 14:06:58 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(407795,)
Date: 2026-10-14 14:07:00 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Oct 14 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-10-14 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-14 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-10-14 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Oct 14 11 3 - ERROR: trailing junk after numeric literal at or near "9201110560778020DA59EFE0" at character 27
- ERROR: trailing junk after numeric literal at or near "9201110560778020DA59EFE0" at character 27
- ERROR: trailing junk after numeric literal at or near "9201110560778020DA59EFE0" at character 27
Statement: select * from rs_caixa_qr(9201110560778020DA59EFE0)
Date: 2026-10-14 11:34:44 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(9201110560778020DA59EFE0)
Date: 2026-10-14 11:34:44 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(9201110560778020DA59EFE0)
Date: 2026-10-14 11:34:46 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
10 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Oct 14 15 1 - ERROR: column "fracionada" does not exist at character 27
Statement: select * from rs_caixa_qr(FRACIONADA)
Date: 2026-10-14 15:54:27 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Oct 14 03 1 - LOG: database system was shut down at 2026-10-14 03:05:01 -03
Date: 2026-10-14 03:05:02