pgBadger-
Global information
- Generated on Fri Sep 11 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 37,472 log entries in 11s
- Log start from 2026-09-11 00:00:50 to 2026-09-11 23:50:07
-
Overview
Global Stats
- 347 Number of unique normalized queries
- 4,589 Number of queries
- 6h11m58s Total query duration
- 2026-09-11 00:02:09 First query
- 2026-09-11 23:46:49 Last query
- 6 queries/s at 2026-09-11 11:00:37 Query peak
- 6h11m58s Total query duration
- 254ms Prepare/parse total duration
- 0ms Bind total duration
- 6h11m58s Execute total duration
- 3,942 Number of events
- 14 Number of unique normalized events
- 3,898 Max number of times the same event was reported
- 0 Number of cancellation
- 286 Total number of automatic vacuums
- 772 Total number of automatic analyzes
- 20 Number temporary file
- 245.35 MiB Max size of temporary file
- 66.77 MiB Average size of temporary file
- 528 Total number of sessions
- 9 sessions at 2026-09-11 16:00:43 Session peak
- 12d22h6m26s Total duration of sessions
- 35m14s Average duration of sessions
- 8 Average queries per session
- 42s270ms Average queries duration per session
- 34m32s Average idle time per session
- 545 Total number of connections
- 4 connections/s at 2026-09-11 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-11 11:00:37 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-11 11:00:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-11 23:43:22 Date
Queries duration
Key values
- 6h11m58s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 11 00 24 0ms 16s859ms 4s57ms 4s587ms 6s430ms 59s944ms 01 33 0ms 3s942ms 907ms 2s113ms 4s740ms 6s72ms 02 14 0ms 3s738ms 1s882ms 2s157ms 5s711ms 5s897ms 03 19 0ms 3s829ms 1s507ms 2s484ms 5s220ms 5s856ms 04 24 0ms 2s901ms 1s220ms 3s992ms 4s551ms 5s160ms 05 25 0ms 10m 51s250ms 5s726ms 2m45s 10m 06 25 0ms 8s49ms 2s53ms 2s252ms 4s355ms 22s121ms 07 313 150ms 7m3s 4s705ms 37s16ms 3m14s 7m20s 08 440 153ms 5m46s 3s713ms 47s791ms 3m36s 6m13s 09 647 150ms 5m42s 3s132ms 45s322ms 5m34s 5m53s 10 508 150ms 5m21s 4s345ms 1m1s 5m20s 5m54s 11 676 150ms 6m2s 3s57ms 47s495ms 5m27s 7m37s 12 131 0ms 5m 5s781ms 9s802ms 34s428ms 5m54s 13 285 0ms 5m22s 3s7ms 14s871ms 29s721ms 5m58s 14 404 151ms 5m29s 3s226ms 31s814ms 3m50s 5m43s 15 287 0ms 5m1s 3s307ms 25s521ms 1m6s 5m46s 16 117 0ms 6m11s 9s969ms 26s896ms 3m23s 6m32s 17 61 0ms 4m53s 9s915ms 3s510ms 50s43ms 4m53s 18 30 0ms 5m4s 20s242ms 2s467ms 11s86ms 5m50s 19 23 0ms 5m12s 26s237ms 2s546ms 2s717ms 5m58s 20 111 0ms 6m1s 11s305ms 1m1s 1m51s 7m49s 21 28 0ms 5m17s 22s426ms 5s613ms 15s593ms 5m49s 22 27 0ms 5m18s 23s36ms 5s381ms 15s268ms 5m49s 23 337 0ms 1m4s 5s973ms 1m5s 1m7s 1m8s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 11 00 4 0 3s133ms 0ms 0ms 605ms 01 18 0 253ms 181ms 283ms 360ms 02 0 0 0ms 0ms 0ms 0ms 03 5 0 325ms 0ms 0ms 651ms 04 10 0 283ms 0ms 213ms 651ms 05 8 0 264ms 0ms 150ms 659ms 06 12 0 1s336ms 0ms 0ms 3s99ms 07 250 0 4s825ms 5s508ms 31s530ms 3m55s 08 343 0 3s770ms 12s793ms 25s96ms 5m50s 09 535 0 3s155ms 13s980ms 28s97ms 5m44s 10 397 0 4s656ms 10s270ms 30s451ms 5m22s 11 557 0 3s257ms 13s590ms 38s912ms 6m40s 12 96 0 7s158ms 2s702ms 5s686ms 4m 13 235 0 3s326ms 5s57ms 14s871ms 3m48s 14 332 0 3s464ms 9s346ms 16s812ms 4m56s 15 203 0 4s91ms 8s413ms 19s52ms 3m28s 16 83 0 12s693ms 2s508ms 10s724ms 5m52s 17 42 0 13s578ms 849ms 3s288ms 3m19s 18 14 0 41s416ms 0ms 0ms 3m43s 19 6 0 1m37s 0ms 0ms 3m44s 20 10 83 13s219ms 11s235ms 1m1s 3m50s 21 9 0 1m6s 0ms 0ms 3m49s 22 6 0 1m37s 0ms 0ms 3m42s 23 17 320 5s973ms 1m1s 1m5s 1m7s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 11 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 11 00 0 0 0.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 7 7.00 0.00% 08 0 15 15.00 0.00% 09 0 15 15.00 0.00% 10 0 10 10.00 0.00% 11 0 10 10.00 0.00% 12 0 5 5.00 0.00% 13 0 10 10.00 0.00% 14 0 12 12.00 0.00% 15 0 8 8.00 0.00% 16 0 6 6.00 0.00% 17 0 1 1.00 0.00% 18 0 1 1.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 1 9 9.00 0.30% Day Hour Count Average / Second Sep 11 00 23 0.01/s 01 15 0.00/s 02 13 0.00/s 03 27 0.01/s 04 14 0.00/s 05 19 0.01/s 06 28 0.01/s 07 29 0.01/s 08 28 0.01/s 09 29 0.01/s 10 24 0.01/s 11 31 0.01/s 12 19 0.01/s 13 24 0.01/s 14 31 0.01/s 15 41 0.01/s 16 27 0.01/s 17 19 0.01/s 18 17 0.00/s 19 16 0.00/s 20 17 0.00/s 21 20 0.01/s 22 16 0.00/s 23 18 0.01/s Day Hour Count Average Duration Average idle time Sep 11 00 10 13m8s 12m58s 01 20 42m57s 42m55s 02 15 36m13s 36m12s 03 24 14m55s 14m54s 04 14 41m43s 41m41s 05 18 30m40s 29m29s 06 20 29m17s 29m15s 07 23 38m37s 37m33s 08 27 39m58s 38m58s 09 27 39m10s 37m55s 10 26 40m20s 38m55s 11 29 33m18s 32m6s 12 26 39m49s 39m20s 13 20 33m6s 32m23s 14 25 39m23s 38m31s 15 42 31m57s 31m35s 16 28 35m13s 34m32s 17 24 40m5s 39m39s 18 21 55m23s 54m54s 19 16 37m38s 37m 20 18 31m45s 30m36s 21 18 30m2s 29m27s 22 16 33m48s 33m9s 23 21 26m38s 25m2s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-11 03:05:16 Date
Connections per database
Key values
- brasilia Main Database
- 545 connections Total
Connections per user
Key values
- etiquetas Main User
- 545 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-09-11 16:00:43 Date
Histogram of session times
Key values
- 255 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 528 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 528 sessions Total
Sessions per host
Key values
- [local] Main Host
- 528 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 528 sessions Total
Application Count Total Duration Average Duration [unknown] 499 11d22h1m3s 34m23s pgAdmin 4 - CONN:3065655 1 2h40m4s 2h40m4s pgAdmin 4 - DB:contagem 2 5s43ms 2s521ms pgAdmin 4 - DB:postgres 1 2h40m47s 2h40m47s pgAdmin 4 - DB:rio 1 2h40m6s 2h40m6s pg_dump 9 43m37s 4m50s postgres_fdw 1 45m2s 45m2s psql 14 14h35m39s 1h2m32s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 29,862 buffers Checkpoint Peak
- 2026-09-11 00:09:47 Date
- 270.052 seconds Highest write time
- 0.102 seconds Sync time
Checkpoints Wal files
Key values
- 10 files Wal files usage Peak
- 2026-09-11 11:19:34 Date
Checkpoints distance
Key values
- 310.82 Mo Distance Peak
- 2026-09-11 11:19:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 11 00 39,405 658.621s 0.019s 658.674s 01 3,232 323.764s 0.045s 323.836s 02 1,821 182.35s 0.076s 182.446s 03 1,552 154.621s 0.095s 154.756s 04 4,014 402.189s 0.165s 402.39s 05 9,786 971.362s 0.217s 971.663s 06 5,300 444.017s 0.005s 444.029s 07 52,803 2,685.512s 0.219s 2,685.792s 08 57,047 3,239.198s 0.35s 3,239.67s 09 78,966 3,239.311s 0.388s 3,239.794s 10 56,655 3,239.212s 0.367s 3,239.676s 11 57,546 3,239.304s 0.256s 3,239.713s 12 21,102 1,627.821s 0.15s 1,628.023s 13 25,243 2,173.271s 0.296s 2,173.63s 14 44,099 3,143.326s 0.235s 3,143.629s 15 31,030 3,079.265s 0.125s 3,079.573s 16 35,715 1,736.438s 0.065s 1,736.549s 17 9,300 974.582s 0.116s 974.757s 18 2,053 205.752s 0.012s 205.83s 19 35 3.515s 0.017s 3.536s 20 1,063 171.685s 0.009s 171.706s 21 2,881 288.435s 0.028s 288.552s 22 3,021 302.499s 0.168s 302.694s 23 185 18.578s 0.009s 18.606s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 11 00 0 0 8 492 0.007s 0.006s 01 0 0 1 588 0.016s 0.008s 02 0 0 1 369 0.062s 0.005s 03 0 0 0 397 0.014s 0.011s 04 0 0 1 607 0.062s 0.012s 05 0 0 5 736 0.062s 0.01s 06 0 0 1 188 0.001s 0.002s 07 0 0 26 3,432 0.039s 0.012s 08 0 0 32 5,196 0.060s 0.012s 09 0 0 55 6,269 0.060s 0.012s 10 0 0 40 6,549 0.057s 0.012s 11 0 0 40 6,843 0.009s 0.012s 12 0 0 9 2,478 0.062s 0.012s 13 0 0 12 3,836 0.063s 0.013s 14 0 0 25 6,200 0.063s 0.012s 15 0 0 15 5,541 0.004s 0.012s 16 0 0 21 3,235 0.003s 0.011s 17 0 0 3 2,323 0.062s 0.01s 18 0 0 0 256 0.002s 0.006s 19 0 0 0 7 0.017s 0.003s 20 0 0 1 82 0.003s 0.003s 21 0 0 1 339 0.008s 0.006s 22 0 0 1 408 0.064s 0.014s 23 0 0 0 24 0.003s 0.005s Day Hour Count Avg time (sec) Sep 11 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 11 00 22,060.00 kB 63,599.00 kB 01 1,965.62 kB 32,182.75 kB 02 1,789.40 kB 16,890.80 kB 03 1,036.12 kB 3,186.00 kB 04 2,015.80 kB 2,906.90 kB 05 9,224.50 kB 15,764.88 kB 06 7,526.50 kB 14,092.00 kB 07 35,653.42 kB 39,321.42 kB 08 43,489.75 kB 90,833.17 kB 09 75,923.92 kB 124,323.92 kB 10 54,049.08 kB 107,020.25 kB 11 54,851.83 kB 111,943.08 kB 12 12,189.33 kB 56,218.50 kB 13 15,863.33 kB 31,600.17 kB 14 33,872.58 kB 61,922.00 kB 15 21,049.67 kB 43,315.08 kB 16 30,815.91 kB 77,839.64 kB 17 4,956.00 kB 39,361.50 kB 18 1,669.40 kB 19,400.60 kB 19 224.00 kB 14,140.00 kB 20 3,631.00 kB 12,295.00 kB 21 2,384.67 kB 8,555.33 kB 22 2,378.29 kB 5,522.43 kB 23 157.80 kB 3,502.80 kB -
Temporary Files
Size of temporary files
Key values
- 490.70 MiB Temp Files size Peak
- 2026-09-11 05:31:56 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-11 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 11 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.77 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 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 16 1.01 GiB 36.59 MiB 245.35 MiB 64.39 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-11 05:32:05 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-11 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 305.28 MiB 56.74 MiB 93.38 MiB 76.32 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-11 05:30:41 Duration: 38s684ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-11 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 245.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 245.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-11 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-11 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-11 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-11 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.46 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.61 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-11 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 11.40 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-11 09:41:49 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 11.40 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-11 09:41:49 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (89) Main table analyzed (database rio)
- 772 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 89 contagem.public.temp0000227117 46 rio.public.usuarios 45 rio.pg_catalog.pg_class 43 brasilia.pg_catalog.pg_attribute 40 contagem.public.temp0000227093 36 rio.pg_catalog.pg_type 35 rio.public.temp0000291177 32 rio.pg_catalog.pg_index 22 rio.public.temp0000291151 21 contagem.pg_catalog.pg_attribute 19 brasilia.pg_catalog.pg_class 19 brasilia.public.temp0000240020 18 brasilia.pg_catalog.pg_type 17 rio.pg_catalog.pg_depend 17 rio.public.temp0000291121 13 brasilia.pg_catalog.pg_depend 10 contagem.public.temp0000227115 10 rio.public.temp0000291083 10 brasilia.pg_catalog.pg_index 10 rio.public.temp0000291181 10 contagem.pg_catalog.pg_class 10 contagem.pg_catalog.pg_type 9 brasilia.public.usuarios 9 rio.public.temp0000290026 9 rio.public.temp0000290226 9 contagem.public.temp0000227129 8 rio.public.temp0000291159 8 rio.public.temp0000291147 8 contagem.public.usuarios 7 rio.public.temp0000290230 7 brasilia.public.temp0000240038 6 rio.public.temp0000291231 6 rio.public.temp0000291169 6 brasilia.public.temp0000239984 6 brasilia.public.temp0000239972 6 rio.public.temp0000291089 5 contagem.pg_catalog.pg_index 5 brasilia.public.temp0000240030 5 contagem.pg_catalog.pg_depend 4 rio.public.temp0000290787 4 rio.public.temp0000291215 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000291163 3 rio.public.tmp_drill_0302 3 rio.public.temp0000291161 3 brasilia.public.temp0000240036 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000291233 3 brasilia.public.temp0000239996 3 brasilia.public.temp0000240016 2 brasilia.public.nf_entrada 2 rio.public.temp0000291203 2 brasilia.public.temp0000240004 2 contagem.pg_catalog.pg_shdepend 2 brasilia.public.temp0000240022 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.public.temp0000240000 2 rio.public.temp0000291167 1 contagem.public.nf_entrada 1 brasilia.public.temp0000240018 1 rio.public.temp0000291221 1 brasilia.public.temp0000239968 1 rio.public.temp0000291227 1 brasilia.public.temp0000240008 1 rio.public.temp0000291223 1 rio.public.temp0000291153 1 rio.public.temp0000291155 1 rio.public.temp0000291173 1 brasilia.public.temp0000239964 1 brasilia.public.temp0000240012 1 rio.public.temp0000290893 1 brasilia.public.temp0000240044 1 brasilia.public.temp0000239978 1 rio.public.temp0000291165 1 brasilia.public.temp0000239982 1 rio.public.temp0000291171 1 rio.public.temp0000291027 1 rio.public.temp0000291183 1 contagem.public.temp0000227097 1 brasilia.public.temp0000240032 1 contagem.public.temp0000227127 1 rio.public.temp0000291149 1 rio.public.temp0000291199 1 brasilia.public.temp0000239962 1 contagem.auditor.auditor_2026_09 1 rio.public.temp0000291195 1 rio.auditor.auditor_2026_09 1 Total 772 Vacuums per table
Key values
- public.temp0000291177 (33) Main table vacuumed on database rio
- 286 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.public.temp0000291177 33 0 0 0 0 0 0 29,818 5,604 8,868,742 0 0 rio.pg_catalog.pg_attribute 30 29 0 0 0 0 0 16,278 4,414 6,349,616 253 6,367 rio.pg_catalog.pg_class 16 15 0 0 0 0 0 3,098 1,053 1,542,509 58 190 rio.pg_catalog.pg_type 15 14 0 0 0 0 0 1,385 435 568,436 51 179 brasilia.pg_catalog.pg_attribute 14 12 0 0 0 0 0 6,164 1,820 2,801,450 67 1,727 rio.public.temp0000291121 13 0 0 0 0 0 0 19,761 50 1,173,642 0 0 rio.pg_catalog.pg_index 9 8 0 0 0 0 0 380 120 138,759 24 81 rio.public.temp0000290026 9 0 0 0 0 0 0 765 157 230,924 0 0 brasilia.pg_catalog.pg_type 8 6 0 0 0 0 0 545 171 235,555 8 34 rio.pg_catalog.pg_depend 8 7 0 0 0 0 0 2,454 866 1,242,887 46 450 brasilia.pg_catalog.pg_class 8 6 0 0 0 0 0 1,054 279 526,727 16 49 rio.public.temp0000291083 7 0 0 0 0 0 0 317 40 24,512 0 0 contagem.public.usuarios 7 0 0 0 0 0 0 34 27 15,608 0 0 contagem.pg_catalog.pg_attribute 6 6 0 0 0 0 0 3,585 926 1,636,290 15 343 brasilia.public.temp0000239984 6 0 0 0 0 0 0 1,512 273 480,187 0 0 brasilia.pg_catalog.pg_index 6 5 0 0 0 0 0 190 56 45,010 9 20 rio.pg_catalog.pg_statistic 5 5 0 0 0 0 0 6,574 2,169 8,372,561 1,543 7,997 rio.public.temp0000290230 5 0 0 0 0 0 0 300 133 200,700 0 0 brasilia.pg_catalog.pg_depend 5 4 0 0 0 0 0 988 364 562,661 23 417 contagem.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 621 199 305,976 32 58 rio.public.usuarios 4 4 0 0 0 0 0 103 47 98,262 5 8 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 1,691 25 299,226 0 0 brasilia.public.temp0000239996 3 0 0 0 0 0 0 756 12 46,413 0 0 brasilia.public.temp0000240036 3 0 0 0 0 0 0 508 11 31,716 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,552 367 1,552,149 218 1,823 brasilia.public.nf_entrada 3 2 0 0 0 0 0 314 146 349,383 11 18 rio.public.temp0000291233 3 0 0 0 0 0 0 3,673 14 218,818 0 0 rio.public.temp0000291151 3 0 0 0 0 0 0 225 16 15,703 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,589 1,411 5,304,502 1,082 6,762 contagem.pg_catalog.pg_class 3 3 0 0 0 0 0 526 113 178,237 3 12 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,733 506 2,533,571 162 508 contagem.public.temp0000227129 2 0 0 0 0 0 0 228 12 15,392 0 0 rio.public.temp0000290787 2 0 0 0 0 0 0 139 12 9,921 0 0 brasilia.public.temp0000240022 2 0 0 0 0 0 0 504 257 418,402 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 310 73 345,893 30 84 contagem.pg_catalog.pg_type 2 2 0 0 0 0 0 245 68 101,602 2 4 rio.public.temp0000291163 2 0 0 0 0 0 0 1,800 1,799 2,423,012 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 630 198 417,503 7 35 rio.public.temp0000291203 2 0 0 0 0 0 0 1,799 7 107,282 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 114 30 33,697 1 1 rio.public.temp0000291027 1 0 0 0 0 0 0 8 5 1,295 0 0 brasilia.public.temp0000240000 1 0 0 0 0 0 0 252 4 15,471 0 0 rio.public.temp0000291227 1 0 0 0 0 0 0 80 6 5,622 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 151 9 30,947 0 0 brasilia.public.temp0000240032 1 0 0 0 0 0 0 252 4 15,471 0 0 rio.public.temp0000291155 1 0 0 0 0 0 0 4 3 774 0 0 contagem.public.temp0000227127 1 0 0 0 0 0 0 114 6 7,696 0 0 brasilia.public.temp0000239964 1 0 0 0 0 0 0 252 4 15,471 0 0 brasilia.public.temp0000240012 1 0 0 0 0 0 0 252 4 15,471 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 17,622 10,725 14,627,456 3,436 108,477 rio.public.temp0000291195 1 0 0 0 0 0 0 59 6 4,328 0 0 rio.auditor.auditor_2026_09 1 0 0 0 0 0 0 66,938 30,749 41,706,924 18,114 362,584 brasilia.public.temp0000240016 1 0 0 0 0 0 0 252 4 15,471 0 0 rio.public.temp0000291167 1 0 0 0 0 0 0 65 4 4,438 0 0 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 17,751 10,388 13,708,154 3,699 71,608 contagem.public.acessorios 1 1 0 0 0 0 0 604 322 1,145,417 8 486 rio.public.temp0000291165 1 0 0 0 0 0 0 4 3 774 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 213 84 130,110 7 7 rio.public.temp0000291221 1 0 0 0 0 0 0 80 6 5,620 0 0 brasilia.public.temp0000239968 1 0 0 0 0 0 0 252 4 15,471 0 0 Total 286 153 0 0 0 0 0 224,467 76,620 121,295,817 28,930 570,329 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (11.4) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.public.temp0000291177 0 0 0.74 rio.pg_catalog.pg_attribute 0 0 2.41 rio.pg_catalog.pg_class 0 0 0.68 rio.pg_catalog.pg_type 0 0 0.23 brasilia.pg_catalog.pg_attribute 0 0 0.92 rio.public.temp0000291121 0 0 0.53 rio.pg_catalog.pg_index 0 0 0.23 rio.public.temp0000290026 0 0 0.02 brasilia.pg_catalog.pg_type 0 0 0.15 rio.pg_catalog.pg_depend 0 0 0.58 brasilia.pg_catalog.pg_class 0 0 0.26 rio.public.temp0000291083 0 0 0.01 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 0.75 brasilia.public.temp0000239984 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.14 rio.pg_catalog.pg_statistic 0 0 0.88 rio.public.temp0000290230 0 0 0.02 brasilia.pg_catalog.pg_depend 0 0 0.53 contagem.pg_catalog.pg_shdepend 0 0 0.32 rio.public.usuarios 0 0 0 rio.public.tmp_drill_0302 0 0 0.04 brasilia.public.temp0000239996 0 0 0 brasilia.public.temp0000240036 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.28 brasilia.public.nf_entrada 0 0 0.12 rio.public.temp0000291233 0 0 0.08 rio.public.temp0000291151 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.39 contagem.pg_catalog.pg_class 0 0 0.38 rio.pg_toast.pg_toast_2619 0 0 0.2 contagem.public.temp0000227129 0 0 0 rio.public.temp0000290787 0 0 0 brasilia.public.temp0000240022 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.02 contagem.pg_catalog.pg_type 0 0 0.16 rio.public.temp0000291163 0 0 0.06 contagem.pg_catalog.pg_depend 0 0 0.25 rio.public.temp0000291203 0 0 0.08 contagem.pg_catalog.pg_index 0 0 0.23 rio.public.temp0000291027 0 0 0 brasilia.public.temp0000240000 0 0 0 rio.public.temp0000291227 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 brasilia.public.temp0000240032 0 0 0 rio.public.temp0000291155 0 0 0 contagem.public.temp0000227127 0 0 0 brasilia.public.temp0000239964 0 0 0 brasilia.public.temp0000240012 0 0 0 contagem.auditor.auditor_2026_09 0 0 3.82 rio.public.temp0000291195 0 0 0.01 rio.auditor.auditor_2026_09 0 0 11.4 brasilia.public.temp0000240016 0 0 0 rio.public.temp0000291167 0 0 0 brasilia.auditor.auditor_2026_09 0 0 3.42 contagem.public.acessorios 0 0 0.59 rio.public.temp0000291165 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0.19 rio.public.temp0000291221 0 0 0 brasilia.public.temp0000239968 0 0 0 Total 0 0 31.12 Tuples removed per table
Key values
- pg_catalog.pg_attribute (122402) Main table with removed tuples on database rio
- 280705 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 30 29 122,402 724,821 22,444 358 17,614 brasilia.pg_catalog.pg_attribute 14 12 50,527 330,215 29,122 169 8,090 rio.public.tmp_drill_0302 3 3 25,090 25,598 0 0 644 contagem.pg_catalog.pg_attribute 6 6 22,303 142,047 0 141 3,321 rio.pg_catalog.pg_statistic 5 5 9,620 39,921 107 0 6,430 contagem.pg_catalog.pg_statistic 3 3 6,671 22,785 0 0 3,033 rio.pg_catalog.pg_depend 8 7 6,492 154,755 2,973 0 1,496 brasilia.pg_catalog.pg_statistic 3 3 6,171 23,430 0 0 3,216 brasilia.pg_catalog.pg_depend 5 4 6,032 98,062 7,929 17 877 rio.pg_catalog.pg_type 15 14 4,822 36,033 1,934 14 1,074 contagem.pg_catalog.pg_shdepend 4 4 3,309 54,809 465 0 500 rio.pg_catalog.pg_class 16 15 2,761 62,504 4,884 52 2,001 brasilia.pg_catalog.pg_type 8 6 2,351 20,430 2,758 17 559 rio.pg_catalog.pg_index 9 8 1,576 18,218 918 13 470 rio.auditor.auditor_2026_09 1 0 1,503 8,110,499 0 0 365,933 brasilia.public.nf_entrada 3 2 1,353 16,385 2,174 0 456 rio.pg_catalog.pg_shdepend 1 1 1,136 13,603 41 0 125 brasilia.pg_catalog.pg_index 6 5 1,106 12,511 1,230 14 320 contagem.pg_catalog.pg_type 2 2 1,018 4,500 0 4 139 rio.pg_toast.pg_toast_2619 3 3 982 2,136 0 21 780 contagem.pg_catalog.pg_depend 2 2 539 37,806 0 0 353 brasilia.pg_catalog.pg_class 8 6 515 35,742 6,835 0 1,144 contagem.pg_catalog.pg_index 2 2 501 3,795 0 8 100 contagem.public.usuarios 7 0 427 168 0 0 14 brasilia.auditor.auditor_2026_09 1 0 375 1,820,222 0 0 79,664 rio.public.usuarios 4 4 283 2,384 348 0 76 contagem.pg_catalog.pg_class 3 3 273 10,588 0 0 400 contagem.public.acessorios 1 1 258 23,252 0 0 227 brasilia.pg_toast.pg_toast_2619 2 2 178 276 0 17 102 contagem.pg_toast.pg_toast_2619 1 1 131 112 0 6 56 contagem.public.temp0000227129 2 0 0 2,738 0 44 212 rio.public.temp0000291027 1 0 0 1,222 0 55 73 brasilia.public.temp0000240000 1 0 0 3,306 0 0 256 rio.public.temp0000291227 1 0 0 1,220 0 56 72 rio.public.temp0000290787 2 0 0 5,458 0 69 123 brasilia.public.temp0000239996 3 0 0 9,906 0 0 768 brasilia.public.temp0000240032 1 0 0 3,306 0 0 256 rio.public.temp0000291155 1 0 0 1,077 0 0 64 brasilia.public.temp0000240022 2 0 0 6,612 0 0 512 contagem.public.temp0000227127 1 0 0 1,368 0 22 106 brasilia.public.temp0000239964 1 0 0 3,306 0 0 256 brasilia.public.temp0000240012 1 0 0 3,306 0 0 256 contagem.auditor.auditor_2026_09 1 0 0 1,479,706 0 0 67,874 rio.public.temp0000291195 1 0 0 2,267 0 13 51 rio.public.temp0000291121 13 0 0 330,217 0 0 23,296 brasilia.public.temp0000240036 3 0 0 9,921 0 0 768 rio.public.temp0000291083 7 0 0 18,379 0 228 412 rio.public.temp0000291177 33 0 0 428,234 0 1,006 29,842 brasilia.public.temp0000240016 1 0 0 3,306 0 0 256 brasilia.public.temp0000239984 6 0 0 19,806 0 0 1,536 rio.public.temp0000290230 5 0 0 15,101 0 173 339 rio.public.temp0000291167 1 0 0 1,077 0 0 64 rio.public.temp0000291165 1 0 0 1,077 0 0 64 rio.public.temp0000291221 1 0 0 1,220 0 56 72 rio.public.temp0000291233 3 0 0 52,035 0 55 3,657 rio.public.temp0000291151 3 0 0 9,178 0 82 206 brasilia.public.temp0000239968 1 0 0 3,301 0 0 256 rio.public.temp0000291163 2 0 0 26,482 0 0 1,856 rio.public.temp0000291203 2 0 0 50,801 0 0 3,584 rio.public.temp0000290026 9 0 0 34,796 0 307 781 Total 286 153 280,705 14,377,336 84,162 3,017 637,082 Pages removed per table
Key values
- public.temp0000291177 (1006) Main table with removed pages on database rio
- 3017 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291177 33 0 0 1006 rio.pg_catalog.pg_attribute 30 29 122402 358 rio.public.temp0000290026 9 0 0 307 rio.public.temp0000291083 7 0 0 228 rio.public.temp0000290230 5 0 0 173 brasilia.pg_catalog.pg_attribute 14 12 50527 169 contagem.pg_catalog.pg_attribute 6 6 22303 141 rio.public.temp0000291151 3 0 0 82 rio.public.temp0000290787 2 0 0 69 rio.public.temp0000291227 1 0 0 56 rio.public.temp0000291221 1 0 0 56 rio.public.temp0000291027 1 0 0 55 rio.public.temp0000291233 3 0 0 55 rio.pg_catalog.pg_class 16 15 2761 52 contagem.public.temp0000227129 2 0 0 44 contagem.public.temp0000227127 1 0 0 22 rio.pg_toast.pg_toast_2619 3 3 982 21 brasilia.pg_catalog.pg_type 8 6 2351 17 brasilia.pg_toast.pg_toast_2619 2 2 178 17 brasilia.pg_catalog.pg_depend 5 4 6032 17 brasilia.pg_catalog.pg_index 6 5 1106 14 rio.pg_catalog.pg_type 15 14 4822 14 rio.pg_catalog.pg_index 9 8 1576 13 rio.public.temp0000291195 1 0 0 13 contagem.pg_catalog.pg_index 2 2 501 8 contagem.pg_toast.pg_toast_2619 1 1 131 6 contagem.pg_catalog.pg_type 2 2 1018 4 rio.public.tmp_drill_0302 3 3 25090 0 brasilia.public.temp0000240000 1 0 0 0 brasilia.public.temp0000239996 3 0 0 0 contagem.pg_catalog.pg_shdepend 4 4 3309 0 brasilia.public.temp0000240032 1 0 0 0 rio.public.temp0000291155 1 0 0 0 rio.public.usuarios 4 4 283 0 brasilia.public.temp0000240022 2 0 0 0 rio.pg_catalog.pg_depend 8 7 6492 0 brasilia.public.temp0000239964 1 0 0 0 brasilia.public.temp0000240012 1 0 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 brasilia.pg_catalog.pg_class 8 6 515 0 rio.auditor.auditor_2026_09 1 0 1503 0 rio.public.temp0000291121 13 0 0 0 brasilia.public.temp0000240036 3 0 0 0 rio.pg_catalog.pg_statistic 5 5 9620 0 brasilia.public.temp0000240016 1 0 0 0 brasilia.public.temp0000239984 6 0 0 0 contagem.public.usuarios 7 0 427 0 contagem.pg_catalog.pg_statistic 3 3 6671 0 rio.public.temp0000291167 1 0 0 0 brasilia.auditor.auditor_2026_09 1 0 375 0 brasilia.public.nf_entrada 3 2 1353 0 contagem.public.acessorios 1 1 258 0 rio.public.temp0000291165 1 0 0 0 rio.pg_catalog.pg_shdepend 1 1 1136 0 brasilia.public.temp0000239968 1 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6171 0 contagem.pg_catalog.pg_class 3 3 273 0 rio.public.temp0000291163 2 0 0 0 contagem.pg_catalog.pg_depend 2 2 539 0 rio.public.temp0000291203 2 0 0 0 Total 286 153 280,705 3,017 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 11 00 0 1 01 0 6 02 0 0 03 0 0 04 0 1 05 8 4 06 1 2 07 22 59 08 25 72 09 35 103 10 35 106 11 65 138 12 3 13 13 19 55 14 31 88 15 10 63 16 30 38 17 2 19 18 0 0 19 0 0 20 0 0 21 0 4 22 0 0 23 0 0 - 11.40 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s584ms 1s584ms 1s584ms 1s584ms select * from rs_lote_manutencao (?);-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"46", "usuario" :"413", "tipo" :"N", "itens" :"02", "nota-fiscal" :"11484", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-09-11 13:30:25 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"006", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-09-11 09:08:21 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"303", "usuario" :"413", "tipo" :"N", "itens" :"01", "nota-fiscal" :"11484", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-09-11 11:46:44 Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1 1s 1s 1s 1s drop table if exists temp0000291177;-
DROP TABLE IF EXISTS temp0000291177;
Date: 2026-09-11 09:34:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291177;
Date: 2026-09-11 08:04:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s584ms SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"46", "usuario" :"413", "tipo" :"N", "itens" :"02", "nota-fiscal" :"11484", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');[ Date: 2026-09-11 13:30:25 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000291177;[ Date: 2026-09-11 09:34:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,192 Total read queries
- 941 Total write queries
Queries by database
Key values
- rio Main database
- 2,679 Requests
- 4h27m57s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,458 Requests
User Request type Count Duration etiquetas Total 27 10s185ms select 27 10s185ms intelifix Total 4,458 6h10m13s copy to 403 43m11s ddl 538 25m27s others 456 37m19s select 3,061 4h24m15s lenon Total 104 1m35s select 104 1m35s Duration by user
Key values
- 6h10m13s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 27 10s185ms select 27 10s185ms intelifix Total 4,458 6h10m13s copy to 403 43m11s ddl 538 25m27s others 456 37m19s select 3,061 4h24m15s lenon Total 104 1m35s select 104 1m35s Queries by host
Key values
- [local] Main host
- 4,586 Requests
- 6h11m16s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,549 Requests
- 3h19m27s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-11 13:34:58 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,316 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m analyze verbose;[ Date: 2026-09-11 05:10:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 07:12:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029819, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');[ Date: 2026-09-11 16:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 6m8s analyze verbose;[ Date: 2026-09-11 05:16:10 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
5 6m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 11:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 20:11:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 5m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029812, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 11:02:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029798, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 08:34:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m42s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029804, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 09:41:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029816, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 14:22:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029800, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 09:04:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029814, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 11:31:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 13:10:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029808, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 10:09:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 09:10:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 22:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m17s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 21:10:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m17s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029810, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-11 10:30:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 19:10:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-11 08:10:12 - 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 1h30m45s 48 1s415ms 7m3s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 11 07 3 7m39s 2m33s 08 3 5m31s 1m50s 09 3 5m38s 1m52s 10 3 5m18s 1m46s 11 3 6m19s 2m6s 12 3 5m18s 1m46s 13 3 5m39s 1m53s 14 3 5m10s 1m43s 15 3 5m16s 1m45s 16 3 5m21s 1m47s 17 3 5m11s 1m43s 18 3 5m23s 1m47s 19 3 5m28s 1m49s 20 3 6m20s 2m6s 21 3 5m34s 1m51s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h30m45s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m45s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 07:12:05 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 11:11:03 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 20:11:02 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
2 1h7m21s 48 251ms 3m57s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 11 07 3 4m53s 1m37s 08 3 3m57s 1m19s 09 3 4m17s 1m25s 10 3 3m56s 1m18s 11 3 4m26s 1m28s 12 3 4m29s 1m29s 13 3 4m18s 1m26s 14 3 4m8s 1m22s 15 3 3m52s 1m17s 16 3 3m50s 1m16s 17 3 3m49s 1m16s 18 3 4m10s 1m23s 19 3 4m14s 1m24s 20 3 4m24s 1m28s 21 3 4m20s 1m26s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h7m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 12:14:47 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 21:14:54 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 20:15:43 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1h5m36s 155 150ms 6m11s 25s396ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 11 07 13 3m48s 17s588ms 08 18 6m59s 23s297ms 09 27 11m38s 25s884ms 10 17 16m26s 58s53ms 11 20 11m45s 35s261ms 12 6 23s190ms 3s865ms 13 8 51s59ms 6s382ms 14 19 6m9s 19s428ms 15 15 24s401ms 1s626ms 16 9 7m4s 47s199ms 17 2 4s252ms 2s126ms 18 1 655ms 655ms [ User: intelifix - Total duration: 1h5m36s - Times executed: 155 ]
[ Application: [unknown] - Total duration: 1h5m36s - Times executed: 155 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029819, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-11 16:32:04 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029812, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-11 11:02:40 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029798, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-11 08:34:42 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m54s 3 2m45s 10m 6m18s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 11 05 3 18m54s 6m18s [ User: intelifix - Total duration: 18m54s - Times executed: 3 ]
[ Application: psql - Total duration: 18m54s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-11 05:10:02 Duration: 10m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-11 05:16:10 Duration: 6m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-11 05:18:55 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql
5 13m34s 1,084 150ms 5s251ms 751ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 11 07 73 1m7s 924ms 08 150 1m56s 776ms 09 179 2m13s 748ms 10 136 1m41s 749ms 11 175 2m15s 774ms 12 55 41s471ms 754ms 13 94 1m3s 672ms 14 112 1m18s 703ms 15 83 55s915ms 673ms 16 12 10s366ms 863ms 17 15 9s606ms 640ms [ User: intelifix - Total duration: 13m34s - Times executed: 1084 ]
[ Application: [unknown] - Total duration: 13m34s - Times executed: 1084 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286612, 503, '48575443A04467B6,4827C56204D8,2150088860LDRA004722,4827C56204DBB6,2426D658A530,2150088860EGRB029233,2426D658AF8DCB6,2426D658AF76,2150088860EGRB029256,2426D658A867ABC66B6,2426D601BF3C,2150088860EGRB001298,2426D60231D1B6,B89FCC05E4D4,2150088860LDR9003644,B89FCC05E4D7F7BB6,B89FCC058318,2150088860LDR9001083,B89FCC05831BA7B6,B89FCC0516D0,2150088860LDR9005195,B89FCC0516D3CCB6,B89FCC05E042,2150088860LDR9006990,B89FCC05E045AEEB8,FC180394E495,2150088860EGS3064642,FC180394E498D6CB8,FC1803931D81,2150088860EGS3053265,FC1803931D84E25B8,68F5431DA734,2150088860EGS2037389,68F5431DA8F9A0306AB6,4827C5613CF6,2150088860LDRA004014,4827C5613CF9A04455B6,4827C5620424,2150088860LDRA003489,4827C5620427B8,68F5437BEECC,2150088860EGS2026874,68F5437BE6C3', '',0466,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":""}]','$$$$$$$$$$$$$','', 00);
Date: 2026-09-11 12:15:13 Duration: 5s251ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286259, 304, '12728485850045800923,942CB3C3854A,942CB3588DCA,E820E225432C,942CB35AA308', '',0117,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','', 00);
Date: 2026-09-11 09:25:11 Duration: 4s68ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (136564, 397, '919361004743,ECBEDDB9D947,F08175280BE7,A86ABBD10B1B,84A06E666D1F,302478653A51,981E19BD973B,981E19BA145C,B866850C1DCA,3093BCB1ADBB,A86ABBC8DB63', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-11 13:10:05 Duration: 3s660ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
6 10m58s 85 1s74ms 25s531ms 7s747ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 11 07 5 16s40ms 3s208ms 08 7 1m36s 13s760ms 09 7 1m1s 8s777ms 10 10 1m43s 10s373ms 11 14 2m22s 10s173ms 12 2 4s824ms 2s412ms 13 3 9s611ms 3s203ms 14 10 1m5s 6s573ms 15 16 1m51s 6s950ms 16 6 32s603ms 5s433ms 17 4 11s404ms 2s851ms 18 1 3s200ms 3s200ms [ User: intelifix - Total duration: 10m58s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 10m58s - Times executed: 85 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 08:55:08 Duration: 25s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-11', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 10:50:18 Duration: 22s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-11', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 09:51:08 Duration: 22s133ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10m2s 52 10s259ms 41s28ms 11s587ms create table temp0000291177 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 11 07 6 1m35s 15s959ms 08 16 2m50s 10s673ms 09 10 1m47s 10s718ms 10 14 2m34s 11s10ms 11 6 1m14s 12s449ms [ User: intelifix - Total duration: 10m2s - Times executed: 52 ]
[ Application: [unknown] - Total duration: 10m2s - Times executed: 52 ]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 07:43:11 Duration: 41s28ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 10:56:03 Duration: 15s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 11:10:51 Duration: 14s491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 6m32s 145 211ms 16s859ms 2s706ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 11 00 6 31s321ms 5s220ms 01 5 12s212ms 2s442ms 02 5 13s368ms 2s673ms 03 5 13s676ms 2s735ms 04 6 14s144ms 2s357ms 05 3 8s961ms 2s987ms 07 10 30s361ms 3s36ms 08 12 40s260ms 3s355ms 09 12 44s635ms 3s719ms 10 12 44s532ms 3s711ms 11 12 32s171ms 2s680ms 12 7 9s85ms 1s297ms 13 6 7s843ms 1s307ms 14 12 25s592ms 2s132ms 15 12 25s925ms 2s160ms 16 5 6s50ms 1s210ms 17 4 3s113ms 778ms 20 1 405ms 405ms 21 4 13s296ms 3s324ms 22 6 15s498ms 2s583ms [ User: intelifix - Total duration: 6m32s - Times executed: 145 ]
[ Application: psql - Total duration: 6m32s - Times executed: 145 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 00:05:18 Duration: 16s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 10:45:09 Duration: 7s903ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 08:25:09 Duration: 7s779ms Database: rio User: intelifix Remote: [local] Application: psql
9 5m47s 205 150ms 10s354ms 1s697ms call rs_giga_triagem (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 11 00 9 23s125ms 2s569ms 01 10 13s176ms 1s317ms 02 9 12s990ms 1s443ms 03 9 13s338ms 1s482ms 04 8 12s303ms 1s537ms 05 8 13s543ms 1s692ms 06 7 13s290ms 1s898ms 07 8 13s442ms 1s680ms 08 11 20s385ms 1s853ms 09 11 17s568ms 1s597ms 10 11 17s59ms 1s550ms 11 11 16s406ms 1s491ms 12 8 13s541ms 1s692ms 13 10 15s375ms 1s537ms 14 8 13s938ms 1s742ms 15 8 14s544ms 1s818ms 16 6 13s334ms 2s222ms 17 6 12s851ms 2s141ms 18 9 14s558ms 1s617ms 19 11 15s339ms 1s394ms 20 9 18s865ms 2s96ms 21 9 14s747ms 1s638ms 22 9 14s244ms 1s582ms [ User: intelifix - Total duration: 5m47s - Times executed: 205 ]
[ Application: psql - Total duration: 5m47s - Times executed: 205 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 00:05:28 Duration: 10s354ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 20:05:06 Duration: 4s975ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 08:15:10 Duration: 4s337ms Database: rio User: intelifix Remote: [local] Application: psql
10 4m59s 579 150ms 3s467ms 516ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 11 06 3 2s875ms 958ms 07 106 58s153ms 548ms 08 92 47s923ms 520ms 09 94 45s685ms 486ms 10 79 34s494ms 436ms 11 80 56s367ms 704ms 12 2 1s107ms 553ms 13 5 2s564ms 512ms 14 58 23s805ms 410ms 15 30 13s626ms 454ms 16 21 9s181ms 437ms 17 9 3s262ms 362ms [ User: intelifix - Total duration: 4m59s - Times executed: 579 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 579 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286496", "modelo" : "463", "itens" : "241719321528,241719985262,241720710014,241782532534,241752011632,241718773135,241756872847,241720899201,241736651233,241723846671,241752952543,241722499301,241748281526,241757591739,241735389403,241782341225,241753525864,241755957291,241794031524,241723256681,241781613039,241737917382,241781675671,241705902934,241720086282,241783331535,241752244359,241719447880,241782037176,241780543956,241758185668,241782523644,241724259898,241704887795,241782314757,241724230122,241719293343,241722555973,241754740922,241785819005,241748527587,241755578084,241754707685,241782341326,241789457788,241735822734,241722507382,241754734254,241781475371,241722507079,241748412930,241784554347,241736402544,241758077778,241757596688,241724240830,241749975170,241723270421,241756852845,241723068807", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-11 08:57:17 Duration: 3s467ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286598", "modelo" : "463", "itens" : "241721782834,241787268911,241720076887,241755851423,241779517783,241722530820,241781623343,241794074356,241723972139,241782682021,241705906469,241720327899,241757832222,241705884851,241757049306,241789484054,241748742839,241781840413,241781706078,241725539508,241724406681,241734711122,241782065664,241704883553,241758010018,241750558290,241755714361,241706262442,241785839916,241784591523,241757935060,241722474854,241758629000,241719945662,241757699099,241721370718,241736413757,241785854867,241755950524,241736852442,241753198302,241719292232,241749086183,241724248709,241723897888,241794157697,241748242633,241751179798,241784090105,241720269510,241754585676,241781929209,241755998383,241790249213,241748772034,241757377373,241722339813,241758657891,241722465156,241754760520", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-11 11:27:03 Duration: 3s171ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "136754", "modelo" : "42", "itens" : "F8F5325337EC,A8F5DDEA6D37,4C1265E59995,5819F8406648,4C126539750C,A8F5DDE60E59,5819F8456C24,CC75E2BD533A,BC644BE36F19,4C1265340CD9", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "rani[[tela]]" }');
Date: 2026-09-11 15:40:22 Duration: 2s759ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 3m35s 19 10s25ms 16s463ms 11s341ms create table temp0000291121 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 11 07 5 53s239ms 10s647ms 08 1 16s463ms 16s463ms 09 2 24s135ms 12s67ms 11 2 24s797ms 12s398ms 15 1 13s14ms 13s14ms 16 8 1m23s 10s479ms [ User: intelifix - Total duration: 3m35s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 19 ]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 08:56:05 Duration: 16s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 11:53:45 Duration: 13s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 09:28:16 Duration: 13s275ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 2m27s 500 150ms 1s427ms 295ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 11 09 119 32s708ms 274ms 10 73 24s754ms 339ms 11 161 47s441ms 294ms 13 79 23s653ms 299ms 14 67 19s69ms 284ms 16 1 280ms 280ms [ User: intelifix - Total duration: 2m27s - Times executed: 500 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 500 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57390","seriais":"176650893341,177301389609,181476190930,181372511720,181281050112,176601648186,177111417791,177115579814,177129745461,176666218608,176658901014,176660316572,181284115573,181283998995,177225902938,181281332642,177299511626,177236433943,177297399904,177228044561,181284811635,176601477485,177304789503,181227777291,177134886580,177237374955,177226693251","usuario":"406","observacao":""}');
Date: 2026-09-11 10:21:03 Duration: 1s427ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"56926","seriais":"F42D0646EEFB,D8E844898C9E,6877DA60F85F,203AEBA72262,802D1A1F925C,6877DA5FADF3,802D1A209C10,6877DA620167,6877DA62CC7B,D8E8448D3C56,6877DA5ECA83,203AEBA72B52,6877DA62B487,802D1A1F18A8,802D1A01B6C4,203AEBA7206A,802D1A208638,F42D0645C3CB,D8E8448A91C2,6877DA6096B3,203AEBA6B7FE,6877DA5DA0D7,6877DA6096CF,802D1A20A264,203AEBA626B2,D8E8448B4422,F42D0645A027,203AEBA72C2E,D8E844898C3E,203AEBA77966,6877DA5BC07B,D8E844898C1E,D8E8448CB946,D8E844898BC6,6877DA61C9A7,D8E844897576,30424090F3F4,802D1A1F1700,203AEBA72F86,6877DA5E2ACB,203AEBA6B5FA,203AEBA69A96,203AEBA73096,203AEBA730CE,D8E8448CB94A,203AEBA6BA0A,6877DA60F7EB,C094AD9A08EF","usuario":"416","observacao":""}');
Date: 2026-09-11 11:03:32 Duration: 1s211ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"56928","seriais":"6802B8E024DE,6802B8A4C6C8,6802B85A953A,6802B8DF7141,6802B8A4E8CA,6802B8E01A7C","usuario":"406","observacao":""}');
Date: 2026-09-11 09:22:37 Duration: 1s64ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 2m22s 4 4s54ms 1m9s 35s595ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 11 20 2 1m14s 37s31ms 23 2 1m8s 34s159ms [ User: intelifix - Total duration: 2m22s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m22s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-11 20:09:11 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-11 23:16:44 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-09-11 20:11:14 Duration: 4s366ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2m13s 24 3s377ms 17s428ms 5s563ms create table temp0000291177 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 11 09 9 56s318ms 6s257ms 10 5 31s28ms 6s205ms 11 10 46s186ms 4s618ms [ User: intelifix - Total duration: 2m13s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 2m13s - Times executed: 24 ]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 09:07:58 Duration: 17s428ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 10:37:53 Duration: 16s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 09:54:42 Duration: 14s170ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 1m56s 4 337ms 59s937ms 29s16ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 11 20 2 1m 30s137ms 23 2 55s790ms 27s895ms [ User: intelifix - Total duration: 1m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-11 20:06:02 Duration: 59s937ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-11 23:13:47 Duration: 55s425ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-11 23:34:01 Duration: 364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m49s 6 3s108ms 41s873ms 18s304ms 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 #16
Day Hour Count Duration Avg duration Sep 11 20 3 56s110ms 18s703ms 23 3 53s715ms 17s905ms [ 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-09-11 20:06:46 Duration: 41s873ms 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-09-11 23:14:29 Duration: 40s96ms 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-09-11 20:10:49 Duration: 10s969ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 1m49s 24 195ms 27s123ms 4s565ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 11 07 2 28s598ms 14s299ms 08 3 17s211ms 5s737ms 09 4 21s573ms 5s393ms 10 4 15s196ms 3s799ms 11 7 18s594ms 2s656ms 13 1 2s114ms 2s114ms 14 2 5s397ms 2s698ms 16 1 895ms 895ms [ User: intelifix - Total duration: 1m49s - Times executed: 24 ]
[ Application: psql - Total duration: 1m49s - Times executed: 24 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029792);
Date: 2026-09-11 07:43:49 Duration: 27s123ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029798);
Date: 2026-09-11 08:28:38 Duration: 11s377ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029804);
Date: 2026-09-11 09:35:37 Duration: 6s666ms Database: rio User: intelifix Remote: [local] Application: psql
18 1m38s 35 598ms 19s29ms 2s814ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 11 08 2 22s762ms 11s381ms 09 3 18s450ms 6s150ms 10 1 7s716ms 7s716ms 11 2 12s658ms 6s329ms 12 2 1s669ms 834ms 13 3 2s457ms 819ms 14 3 7s374ms 2s458ms 15 2 10s290ms 5s145ms 16 3 3s130ms 1s43ms 17 2 1s522ms 761ms 18 2 1s796ms 898ms 19 2 1s760ms 880ms 20 2 1s784ms 892ms 21 3 2s168ms 722ms 22 3 2s952ms 984ms [ User: intelifix - Total duration: 1m38s - Times executed: 35 ]
[ Application: psql - Total duration: 1m38s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 08:00:20 Duration: 19s29ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 09:00:09 Duration: 8s166ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 09:40:09 Duration: 7s916ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m26s 6 2s269ms 33s892ms 14s414ms copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 11 20 3 44s550ms 14s850ms 23 3 41s936ms 13s978ms [ User: intelifix - Total duration: 1m26s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-11 20:07:23 Duration: 33s892ms 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-09-11 23:15:03 Duration: 31s896ms 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-09-11 20:10:58 Duration: 8s209ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m25s 6 3s127ms 33s251ms 14s221ms 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 #20
Day Hour Count Duration Avg duration Sep 11 20 3 43s472ms 14s490ms 23 3 41s857ms 13s952ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m25s - 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-09-11 20:09:45 Duration: 33s251ms 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-09-11 23:17:16 Duration: 32s237ms 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-09-11 20:11:21 Duration: 7s1ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,084 13m34s 150ms 5s251ms 751ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 11 07 73 1m7s 924ms 08 150 1m56s 776ms 09 179 2m13s 748ms 10 136 1m41s 749ms 11 175 2m15s 774ms 12 55 41s471ms 754ms 13 94 1m3s 672ms 14 112 1m18s 703ms 15 83 55s915ms 673ms 16 12 10s366ms 863ms 17 15 9s606ms 640ms [ User: intelifix - Total duration: 13m34s - Times executed: 1084 ]
[ Application: [unknown] - Total duration: 13m34s - Times executed: 1084 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286612, 503, '48575443A04467B6,4827C56204D8,2150088860LDRA004722,4827C56204DBB6,2426D658A530,2150088860EGRB029233,2426D658AF8DCB6,2426D658AF76,2150088860EGRB029256,2426D658A867ABC66B6,2426D601BF3C,2150088860EGRB001298,2426D60231D1B6,B89FCC05E4D4,2150088860LDR9003644,B89FCC05E4D7F7BB6,B89FCC058318,2150088860LDR9001083,B89FCC05831BA7B6,B89FCC0516D0,2150088860LDR9005195,B89FCC0516D3CCB6,B89FCC05E042,2150088860LDR9006990,B89FCC05E045AEEB8,FC180394E495,2150088860EGS3064642,FC180394E498D6CB8,FC1803931D81,2150088860EGS3053265,FC1803931D84E25B8,68F5431DA734,2150088860EGS2037389,68F5431DA8F9A0306AB6,4827C5613CF6,2150088860LDRA004014,4827C5613CF9A04455B6,4827C5620424,2150088860LDRA003489,4827C5620427B8,68F5437BEECC,2150088860EGS2026874,68F5437BE6C3', '',0466,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":""}]','$$$$$$$$$$$$$','', 00);
Date: 2026-09-11 12:15:13 Duration: 5s251ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286259, 304, '12728485850045800923,942CB3C3854A,942CB3588DCA,E820E225432C,942CB35AA308', '',0117,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','', 00);
Date: 2026-09-11 09:25:11 Duration: 4s68ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (136564, 397, '919361004743,ECBEDDB9D947,F08175280BE7,A86ABBD10B1B,84A06E666D1F,302478653A51,981E19BD973B,981E19BA145C,B866850C1DCA,3093BCB1ADBB,A86ABBC8DB63', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-11 13:10:05 Duration: 3s660ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
2 579 4m59s 150ms 3s467ms 516ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 11 06 3 2s875ms 958ms 07 106 58s153ms 548ms 08 92 47s923ms 520ms 09 94 45s685ms 486ms 10 79 34s494ms 436ms 11 80 56s367ms 704ms 12 2 1s107ms 553ms 13 5 2s564ms 512ms 14 58 23s805ms 410ms 15 30 13s626ms 454ms 16 21 9s181ms 437ms 17 9 3s262ms 362ms [ User: intelifix - Total duration: 4m59s - Times executed: 579 ]
[ Application: [unknown] - Total duration: 4m59s - Times executed: 579 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286496", "modelo" : "463", "itens" : "241719321528,241719985262,241720710014,241782532534,241752011632,241718773135,241756872847,241720899201,241736651233,241723846671,241752952543,241722499301,241748281526,241757591739,241735389403,241782341225,241753525864,241755957291,241794031524,241723256681,241781613039,241737917382,241781675671,241705902934,241720086282,241783331535,241752244359,241719447880,241782037176,241780543956,241758185668,241782523644,241724259898,241704887795,241782314757,241724230122,241719293343,241722555973,241754740922,241785819005,241748527587,241755578084,241754707685,241782341326,241789457788,241735822734,241722507382,241754734254,241781475371,241722507079,241748412930,241784554347,241736402544,241758077778,241757596688,241724240830,241749975170,241723270421,241756852845,241723068807", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-11 08:57:17 Duration: 3s467ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286598", "modelo" : "463", "itens" : "241721782834,241787268911,241720076887,241755851423,241779517783,241722530820,241781623343,241794074356,241723972139,241782682021,241705906469,241720327899,241757832222,241705884851,241757049306,241789484054,241748742839,241781840413,241781706078,241725539508,241724406681,241734711122,241782065664,241704883553,241758010018,241750558290,241755714361,241706262442,241785839916,241784591523,241757935060,241722474854,241758629000,241719945662,241757699099,241721370718,241736413757,241785854867,241755950524,241736852442,241753198302,241719292232,241749086183,241724248709,241723897888,241794157697,241748242633,241751179798,241784090105,241720269510,241754585676,241781929209,241755998383,241790249213,241748772034,241757377373,241722339813,241758657891,241722465156,241754760520", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-11 11:27:03 Duration: 3s171ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "136754", "modelo" : "42", "itens" : "F8F5325337EC,A8F5DDEA6D37,4C1265E59995,5819F8406648,4C126539750C,A8F5DDE60E59,5819F8456C24,CC75E2BD533A,BC644BE36F19,4C1265340CD9", "usuario" : "428", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "rani[[tela]]" }');
Date: 2026-09-11 15:40:22 Duration: 2s759ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
3 500 2m27s 150ms 1s427ms 295ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 11 09 119 32s708ms 274ms 10 73 24s754ms 339ms 11 161 47s441ms 294ms 13 79 23s653ms 299ms 14 67 19s69ms 284ms 16 1 280ms 280ms [ User: intelifix - Total duration: 2m27s - Times executed: 500 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 500 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57390","seriais":"176650893341,177301389609,181476190930,181372511720,181281050112,176601648186,177111417791,177115579814,177129745461,176666218608,176658901014,176660316572,181284115573,181283998995,177225902938,181281332642,177299511626,177236433943,177297399904,177228044561,181284811635,176601477485,177304789503,181227777291,177134886580,177237374955,177226693251","usuario":"406","observacao":""}');
Date: 2026-09-11 10:21:03 Duration: 1s427ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"56926","seriais":"F42D0646EEFB,D8E844898C9E,6877DA60F85F,203AEBA72262,802D1A1F925C,6877DA5FADF3,802D1A209C10,6877DA620167,6877DA62CC7B,D8E8448D3C56,6877DA5ECA83,203AEBA72B52,6877DA62B487,802D1A1F18A8,802D1A01B6C4,203AEBA7206A,802D1A208638,F42D0645C3CB,D8E8448A91C2,6877DA6096B3,203AEBA6B7FE,6877DA5DA0D7,6877DA6096CF,802D1A20A264,203AEBA626B2,D8E8448B4422,F42D0645A027,203AEBA72C2E,D8E844898C3E,203AEBA77966,6877DA5BC07B,D8E844898C1E,D8E8448CB946,D8E844898BC6,6877DA61C9A7,D8E844897576,30424090F3F4,802D1A1F1700,203AEBA72F86,6877DA5E2ACB,203AEBA6B5FA,203AEBA69A96,203AEBA73096,203AEBA730CE,D8E8448CB94A,203AEBA6BA0A,6877DA60F7EB,C094AD9A08EF","usuario":"416","observacao":""}');
Date: 2026-09-11 11:03:32 Duration: 1s211ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"56928","seriais":"6802B8E024DE,6802B8A4C6C8,6802B85A953A,6802B8DF7141,6802B8A4E8CA,6802B8E01A7C","usuario":"406","observacao":""}');
Date: 2026-09-11 09:22:37 Duration: 1s64ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 205 5m47s 150ms 10s354ms 1s697ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 11 00 9 23s125ms 2s569ms 01 10 13s176ms 1s317ms 02 9 12s990ms 1s443ms 03 9 13s338ms 1s482ms 04 8 12s303ms 1s537ms 05 8 13s543ms 1s692ms 06 7 13s290ms 1s898ms 07 8 13s442ms 1s680ms 08 11 20s385ms 1s853ms 09 11 17s568ms 1s597ms 10 11 17s59ms 1s550ms 11 11 16s406ms 1s491ms 12 8 13s541ms 1s692ms 13 10 15s375ms 1s537ms 14 8 13s938ms 1s742ms 15 8 14s544ms 1s818ms 16 6 13s334ms 2s222ms 17 6 12s851ms 2s141ms 18 9 14s558ms 1s617ms 19 11 15s339ms 1s394ms 20 9 18s865ms 2s96ms 21 9 14s747ms 1s638ms 22 9 14s244ms 1s582ms [ User: intelifix - Total duration: 5m47s - Times executed: 205 ]
[ Application: psql - Total duration: 5m47s - Times executed: 205 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 00:05:28 Duration: 10s354ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 20:05:06 Duration: 4s975ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 08:15:10 Duration: 4s337ms Database: rio User: intelifix Remote: [local] Application: psql
5 155 1h5m36s 150ms 6m11s 25s396ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 11 07 13 3m48s 17s588ms 08 18 6m59s 23s297ms 09 27 11m38s 25s884ms 10 17 16m26s 58s53ms 11 20 11m45s 35s261ms 12 6 23s190ms 3s865ms 13 8 51s59ms 6s382ms 14 19 6m9s 19s428ms 15 15 24s401ms 1s626ms 16 9 7m4s 47s199ms 17 2 4s252ms 2s126ms 18 1 655ms 655ms [ User: intelifix - Total duration: 1h5m36s - Times executed: 155 ]
[ Application: [unknown] - Total duration: 1h5m36s - Times executed: 155 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029819, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-11 16:32:04 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029812, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-11 11:02:40 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029798, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-11 08:34:42 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 145 6m32s 211ms 16s859ms 2s706ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 11 00 6 31s321ms 5s220ms 01 5 12s212ms 2s442ms 02 5 13s368ms 2s673ms 03 5 13s676ms 2s735ms 04 6 14s144ms 2s357ms 05 3 8s961ms 2s987ms 07 10 30s361ms 3s36ms 08 12 40s260ms 3s355ms 09 12 44s635ms 3s719ms 10 12 44s532ms 3s711ms 11 12 32s171ms 2s680ms 12 7 9s85ms 1s297ms 13 6 7s843ms 1s307ms 14 12 25s592ms 2s132ms 15 12 25s925ms 2s160ms 16 5 6s50ms 1s210ms 17 4 3s113ms 778ms 20 1 405ms 405ms 21 4 13s296ms 3s324ms 22 6 15s498ms 2s583ms [ User: intelifix - Total duration: 6m32s - Times executed: 145 ]
[ Application: psql - Total duration: 6m32s - Times executed: 145 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 00:05:18 Duration: 16s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 10:45:09 Duration: 7s903ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 08:25:09 Duration: 7s779ms Database: rio User: intelifix Remote: [local] Application: psql
7 95 30s337ms 294ms 418ms 319ms 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 #7
Day Hour Count Duration Avg duration Sep 11 01 1 331ms 331ms 03 2 625ms 312ms 04 2 599ms 299ms 05 2 598ms 299ms 06 2 602ms 301ms 07 7 2s166ms 309ms 08 12 3s862ms 321ms 09 9 2s826ms 314ms 10 8 2s487ms 310ms 11 10 3s476ms 347ms 12 5 1s712ms 342ms 13 10 3s287ms 328ms 14 11 3s449ms 313ms 15 6 1s845ms 307ms 16 6 1s845ms 307ms 17 1 309ms 309ms 18 1 308ms 308ms [ User: lenon - Total duration: 30s337ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 30s337ms - Times executed: 95 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-11 12:10:08 Duration: 418ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-11 11:24:18 Duration: 406ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-11 11:11:18 Duration: 384ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 89 35s256ms 327ms 1s92ms 396ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 11 01 1 703ms 703ms 03 1 355ms 355ms 04 2 691ms 345ms 05 2 720ms 360ms 06 2 757ms 378ms 07 6 2s123ms 353ms 08 11 5s30ms 457ms 09 8 3s288ms 411ms 10 8 2s925ms 365ms 11 10 4s414ms 441ms 12 5 2s2ms 400ms 13 9 3s438ms 382ms 14 11 4s10ms 364ms 15 7 2s572ms 367ms 16 5 1s849ms 369ms 17 1 373ms 373ms [ User: intelifix - Total duration: 35s256ms - Times executed: 89 ]
[ Application: [unknown] - Total duration: 35s256ms - Times executed: 89 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-09-11 08:14:50 Duration: 1s92ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 19, 1);
Date: 2026-09-11 01:21:20 Duration: 703ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 18, 1);
Date: 2026-09-11 09:14:08 Duration: 641ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 85 10m58s 1s74ms 25s531ms 7s747ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 11 07 5 16s40ms 3s208ms 08 7 1m36s 13s760ms 09 7 1m1s 8s777ms 10 10 1m43s 10s373ms 11 14 2m22s 10s173ms 12 2 4s824ms 2s412ms 13 3 9s611ms 3s203ms 14 10 1m5s 6s573ms 15 16 1m51s 6s950ms 16 6 32s603ms 5s433ms 17 4 11s404ms 2s851ms 18 1 3s200ms 3s200ms [ User: intelifix - Total duration: 10m58s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 10m58s - Times executed: 85 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 08:55:08 Duration: 25s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-11', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 10:50:18 Duration: 22s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-11', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 09:51:08 Duration: 22s133ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 72 22s353ms 248ms 887ms 310ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 11 07 5 1s380ms 276ms 08 10 2s694ms 269ms 09 11 4s106ms 373ms 10 9 3s131ms 347ms 11 13 4s323ms 332ms 12 6 1s795ms 299ms 13 2 664ms 332ms 14 5 1s380ms 276ms 15 2 527ms 263ms 16 6 1s587ms 264ms 17 2 506ms 253ms 18 1 255ms 255ms [ User: intelifix - Total duration: 22s353ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 22s353ms - Times executed: 72 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-11 09:05:05 Duration: 887ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-11 09:43:01 Duration: 759ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-11 11:14:31 Duration: 574ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 68 57s610ms 151ms 13s200ms 847ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 11 07 11 4s967ms 451ms 08 3 1s461ms 487ms 09 14 6s232ms 445ms 10 5 2s800ms 560ms 11 9 6s320ms 702ms 12 2 12s155ms 6s77ms 13 2 555ms 277ms 14 10 3s481ms 348ms 15 11 17s34ms 1s548ms 16 1 2s602ms 2s602ms [ User: intelifix - Total duration: 57s610ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 57s610ms - Times executed: 68 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056927) LIMIT 1;
Date: 2026-09-11 15:21:42 Duration: 13s200ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136735) LIMIT 1;
Date: 2026-09-11 12:11:25 Duration: 6s320ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136735) LIMIT 1;
Date: 2026-09-11 12:11:12 Duration: 5s834ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 54 1m22s 172ms 13s198ms 1s535ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 11 08 3 4s577ms 1s525ms 09 3 2s215ms 738ms 10 6 9s756ms 1s626ms 11 4 9s668ms 2s417ms 12 4 8s543ms 2s135ms 13 3 2s389ms 796ms 14 3 2s305ms 768ms 15 4 4s36ms 1s9ms 16 3 2s524ms 841ms 17 3 14s755ms 4s918ms 18 4 10s860ms 2s715ms 19 4 3s72ms 768ms 20 4 3s257ms 814ms 21 3 2s224ms 741ms 22 3 2s745ms 915ms [ User: intelifix - Total duration: 1m22s - Times executed: 54 ]
[ Application: psql - Total duration: 1m22s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-11 17:40:15 Duration: 13s198ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-11 18:00:10 Duration: 8s822ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-11 11:00:09 Duration: 7s377ms Database: rio User: intelifix Remote: [local] Application: psql
13 52 10m2s 10s259ms 41s28ms 11s587ms create table temp0000291177 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 11 07 6 1m35s 15s959ms 08 16 2m50s 10s673ms 09 10 1m47s 10s718ms 10 14 2m34s 11s10ms 11 6 1m14s 12s449ms [ User: intelifix - Total duration: 10m2s - Times executed: 52 ]
[ Application: [unknown] - Total duration: 10m2s - Times executed: 52 ]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 07:43:11 Duration: 41s28ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 10:56:03 Duration: 15s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 11:10:51 Duration: 14s491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 48 1h30m45s 1s415ms 7m3s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 11 07 3 7m39s 2m33s 08 3 5m31s 1m50s 09 3 5m38s 1m52s 10 3 5m18s 1m46s 11 3 6m19s 2m6s 12 3 5m18s 1m46s 13 3 5m39s 1m53s 14 3 5m10s 1m43s 15 3 5m16s 1m45s 16 3 5m21s 1m47s 17 3 5m11s 1m43s 18 3 5m23s 1m47s 19 3 5m28s 1m49s 20 3 6m20s 2m6s 21 3 5m34s 1m51s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h30m45s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m45s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 07:12:05 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 11:11:03 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 20:11:02 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
15 48 1h7m21s 251ms 3m57s 1m24s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 11 07 3 4m53s 1m37s 08 3 3m57s 1m19s 09 3 4m17s 1m25s 10 3 3m56s 1m18s 11 3 4m26s 1m28s 12 3 4m29s 1m29s 13 3 4m18s 1m26s 14 3 4m8s 1m22s 15 3 3m52s 1m17s 16 3 3m50s 1m16s 17 3 3m49s 1m16s 18 3 4m10s 1m23s 19 3 4m14s 1m24s 20 3 4m24s 1m28s 21 3 4m20s 1m26s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h7m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 12:14:47 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 21:14:54 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 20:15:43 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
16 39 8s838ms 150ms 501ms 226ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 11 01 10 2s392ms 239ms 04 6 1s543ms 257ms 05 3 593ms 197ms 07 1 218ms 218ms 08 2 418ms 209ms 09 3 586ms 195ms 10 3 696ms 232ms 11 4 794ms 198ms 14 4 774ms 193ms 15 3 820ms 273ms [ User: intelifix - Total duration: 8s838ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 8s838ms - Times executed: 39 ]
-
SELECT * FROM RS_TRIAGEM (409, 5, '80', 2, '241743559819,241777597900', NULL, NULL, 0464, 00);
Date: 2026-09-11 15:40:55 Duration: 501ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241770920829,241770806574,241813164457,241767512224,241742385372,241760158486,241744555460,241762852645,241747469112,241772394148,241773548390,241748038089,241759861130,241744446078,241740605153,241741056869,241772282948,241768331126,241772877180,241759813549,241766620005,241766201827,241769545273,241748082640,241765448082,241738486585,241744603647,241766262843,241769451628,241748000915,241748006773,241747988892,241770927394', NULL, NULL, 0464, 00);
Date: 2026-09-11 04:26:18 Duration: 421ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229858278402,229867585965,229850054647,229725130425,229790815364,229770321625,229797351637,229725419497,229788714452', NULL, NULL, 0145, 00);
Date: 2026-09-11 10:04:05 Duration: 333ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 36 10s126ms 180ms 2s5ms 281ms create table temp0000290226 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 11 07 7 1s333ms 190ms 08 7 1s510ms 215ms 09 9 2s6ms 222ms 10 8 3s783ms 472ms 11 5 1s491ms 298ms [ User: intelifix - Total duration: 10s126ms - Times executed: 36 ]
[ Application: [unknown] - Total duration: 10s126ms - Times executed: 36 ]
-
CREATE TABLE temp0000290226 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"84308", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 10:27:20 Duration: 2s5ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290226 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"84308", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 11:08:39 Duration: 368ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290226 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"84308", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 10:57:14 Duration: 332ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 35 1m38s 598ms 19s29ms 2s814ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 11 08 2 22s762ms 11s381ms 09 3 18s450ms 6s150ms 10 1 7s716ms 7s716ms 11 2 12s658ms 6s329ms 12 2 1s669ms 834ms 13 3 2s457ms 819ms 14 3 7s374ms 2s458ms 15 2 10s290ms 5s145ms 16 3 3s130ms 1s43ms 17 2 1s522ms 761ms 18 2 1s796ms 898ms 19 2 1s760ms 880ms 20 2 1s784ms 892ms 21 3 2s168ms 722ms 22 3 2s952ms 984ms [ User: intelifix - Total duration: 1m38s - Times executed: 35 ]
[ Application: psql - Total duration: 1m38s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 08:00:20 Duration: 19s29ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 09:00:09 Duration: 8s166ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 09:40:09 Duration: 7s916ms Database: rio User: intelifix Remote: [local] Application: psql
19 35 11s129ms 179ms 2s927ms 317ms create table temp0000291159 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 11 07 8 4s313ms 539ms 08 3 605ms 201ms 09 10 2s319ms 231ms 10 5 1s494ms 298ms 11 9 2s396ms 266ms [ User: intelifix - Total duration: 11s129ms - Times executed: 35 ]
[ Application: [unknown] - Total duration: 11s129ms - Times executed: 35 ]
-
CREATE TABLE temp0000291159 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 07:09:01 Duration: 2s927ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291159 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"84308", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 10:58:36 Duration: 466ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291159 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"84308", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 11:52:52 Duration: 311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 30 8s464ms 150ms 538ms 282ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 11 09 6 1s855ms 309ms 10 7 1s289ms 184ms 11 9 2s707ms 300ms 13 2 368ms 184ms 14 6 2s243ms 373ms [ User: intelifix - Total duration: 8s464ms - Times executed: 30 ]
[ Application: [unknown] - Total duration: 8s464ms - Times executed: 30 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3638931 ORDER BY A.CAI_ORDEM;
Date: 2026-09-11 11:41:45 Duration: 538ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3643078 ORDER BY A.CAI_ORDEM;
Date: 2026-09-11 14:13:16 Duration: 521ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3643078 ORDER BY A.CAI_ORDEM;
Date: 2026-09-11 14:19:41 Duration: 504ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m45s 10m 6m18s 3 18m54s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 11 05 3 18m54s 6m18s [ User: intelifix - Total duration: 18m54s - Times executed: 3 ]
[ Application: psql - Total duration: 18m54s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-11 05:10:02 Duration: 10m Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-11 05:16:10 Duration: 6m8s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-11 05:18:55 Duration: 2m45s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s415ms 7m3s 1m53s 48 1h30m45s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 11 07 3 7m39s 2m33s 08 3 5m31s 1m50s 09 3 5m38s 1m52s 10 3 5m18s 1m46s 11 3 6m19s 2m6s 12 3 5m18s 1m46s 13 3 5m39s 1m53s 14 3 5m10s 1m43s 15 3 5m16s 1m45s 16 3 5m21s 1m47s 17 3 5m11s 1m43s 18 3 5m23s 1m47s 19 3 5m28s 1m49s 20 3 6m20s 2m6s 21 3 5m34s 1m51s 22 3 5m34s 1m51s [ User: intelifix - Total duration: 1h30m45s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m45s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 07:12:05 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 11:11:03 Duration: 6m2s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-11 20:11:02 Duration: 6m1s Database: rio User: intelifix Remote: [local] Application: psql
3 251ms 3m57s 1m24s 48 1h7m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 11 07 3 4m53s 1m37s 08 3 3m57s 1m19s 09 3 4m17s 1m25s 10 3 3m56s 1m18s 11 3 4m26s 1m28s 12 3 4m29s 1m29s 13 3 4m18s 1m26s 14 3 4m8s 1m22s 15 3 3m52s 1m17s 16 3 3m50s 1m16s 17 3 3m49s 1m16s 18 3 4m10s 1m23s 19 3 4m14s 1m24s 20 3 4m24s 1m28s 21 3 4m20s 1m26s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h7m21s - Times executed: 48 ]
[ Application: psql - Total duration: 1h7m21s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 12:14:47 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 21:14:54 Duration: 3m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-11 20:15:43 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s54ms 1m9s 35s595ms 4 2m22s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 11 20 2 1m14s 37s31ms 23 2 1m8s 34s159ms [ User: intelifix - Total duration: 2m22s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m22s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-11 20:09:11 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-11 23:16:44 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-09-11 20:11:14 Duration: 4s366ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 337ms 59s937ms 29s16ms 4 1m56s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 11 20 2 1m 30s137ms 23 2 55s790ms 27s895ms [ User: intelifix - Total duration: 1m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m56s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-11 20:06:02 Duration: 59s937ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-11 23:13:47 Duration: 55s425ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-11 23:34:01 Duration: 364ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 6m11s 25s396ms 155 1h5m36s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 11 07 13 3m48s 17s588ms 08 18 6m59s 23s297ms 09 27 11m38s 25s884ms 10 17 16m26s 58s53ms 11 20 11m45s 35s261ms 12 6 23s190ms 3s865ms 13 8 51s59ms 6s382ms 14 19 6m9s 19s428ms 15 15 24s401ms 1s626ms 16 9 7m4s 47s199ms 17 2 4s252ms 2s126ms 18 1 655ms 655ms [ User: intelifix - Total duration: 1h5m36s - Times executed: 155 ]
[ Application: [unknown] - Total duration: 1h5m36s - Times executed: 155 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029819, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-09-11 16:32:04 Duration: 6m11s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029812, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-11 11:02:40 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029798, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-11 08:34:42 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 3s108ms 41s873ms 18s304ms 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 #7
Day Hour Count Duration Avg duration Sep 11 20 3 56s110ms 18s703ms 23 3 53s715ms 17s905ms [ 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-09-11 20:06:46 Duration: 41s873ms 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-09-11 23:14:29 Duration: 40s96ms 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-09-11 20:10:49 Duration: 10s969ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 2s269ms 33s892ms 14s414ms 6 1m26s copy public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 11 20 3 44s550ms 14s850ms 23 3 41s936ms 13s978ms [ User: intelifix - Total duration: 1m26s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m26s - Times executed: 6 ]
-
COPY public.nf_entrada_arquivo_erros (nea_id, linha, dado, erro, criacao, nota, serial, sap) TO stdout;
Date: 2026-09-11 20:07:23 Duration: 33s892ms 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-09-11 23:15:03 Duration: 31s896ms 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-09-11 20:10:58 Duration: 8s209ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
9 3s127ms 33s251ms 14s221ms 6 1m25s 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 #9
Day Hour Count Duration Avg duration Sep 11 20 3 43s472ms 14s490ms 23 3 41s857ms 13s952ms [ User: intelifix - Total duration: 1m25s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m25s - 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-09-11 20:09:45 Duration: 33s251ms 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-09-11 23:17:16 Duration: 32s237ms 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-09-11 20:11:21 Duration: 7s1ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
10 10s259ms 41s28ms 11s587ms 52 10m2s create table temp0000291177 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 11 07 6 1m35s 15s959ms 08 16 2m50s 10s673ms 09 10 1m47s 10s718ms 10 14 2m34s 11s10ms 11 6 1m14s 12s449ms [ User: intelifix - Total duration: 10m2s - Times executed: 52 ]
[ Application: [unknown] - Total duration: 10m2s - Times executed: 52 ]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 07:43:11 Duration: 41s28ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 10:56:03 Duration: 15s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 11:10:51 Duration: 14s491ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s25ms 16s463ms 11s341ms 19 3m35s create table temp0000291121 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 11 07 5 53s239ms 10s647ms 08 1 16s463ms 16s463ms 09 2 24s135ms 12s67ms 11 2 24s797ms 12s398ms 15 1 13s14ms 13s14ms 16 8 1m23s 10s479ms [ User: intelifix - Total duration: 3m35s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 19 ]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 08:56:05 Duration: 16s463ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 11:53:45 Duration: 13s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-11 09:28:16 Duration: 13s275ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s74ms 25s531ms 7s747ms 85 10m58s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 11 07 5 16s40ms 3s208ms 08 7 1m36s 13s760ms 09 7 1m1s 8s777ms 10 10 1m43s 10s373ms 11 14 2m22s 10s173ms 12 2 4s824ms 2s412ms 13 3 9s611ms 3s203ms 14 10 1m5s 6s573ms 15 16 1m51s 6s950ms 16 6 32s603ms 5s433ms 17 4 11s404ms 2s851ms 18 1 3s200ms 3s200ms [ User: intelifix - Total duration: 10m58s - Times executed: 85 ]
[ Application: [unknown] - Total duration: 10m58s - Times executed: 85 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 08:55:08 Duration: 25s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-11', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 10:50:18 Duration: 22s519ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-11', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-11 09:51:08 Duration: 22s133ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3s377ms 17s428ms 5s563ms 24 2m13s create table temp0000291177 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 11 09 9 56s318ms 6s257ms 10 5 31s28ms 6s205ms 11 10 46s186ms 4s618ms [ User: intelifix - Total duration: 2m13s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 2m13s - Times executed: 24 ]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 09:07:58 Duration: 17s428ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 10:37:53 Duration: 16s545ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291177 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"06-09-2026", "ate" :"11-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-11 09:54:42 Duration: 14s170ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 195ms 27s123ms 4s565ms 24 1m49s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 11 07 2 28s598ms 14s299ms 08 3 17s211ms 5s737ms 09 4 21s573ms 5s393ms 10 4 15s196ms 3s799ms 11 7 18s594ms 2s656ms 13 1 2s114ms 2s114ms 14 2 5s397ms 2s698ms 16 1 895ms 895ms [ User: intelifix - Total duration: 1m49s - Times executed: 24 ]
[ Application: psql - Total duration: 1m49s - Times executed: 24 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029792);
Date: 2026-09-11 07:43:49 Duration: 27s123ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029798);
Date: 2026-09-11 08:28:38 Duration: 11s377ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029804);
Date: 2026-09-11 09:35:37 Duration: 6s666ms Database: rio User: intelifix Remote: [local] Application: psql
15 598ms 19s29ms 2s814ms 35 1m38s 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 #15
Day Hour Count Duration Avg duration Sep 11 08 2 22s762ms 11s381ms 09 3 18s450ms 6s150ms 10 1 7s716ms 7s716ms 11 2 12s658ms 6s329ms 12 2 1s669ms 834ms 13 3 2s457ms 819ms 14 3 7s374ms 2s458ms 15 2 10s290ms 5s145ms 16 3 3s130ms 1s43ms 17 2 1s522ms 761ms 18 2 1s796ms 898ms 19 2 1s760ms 880ms 20 2 1s784ms 892ms 21 3 2s168ms 722ms 22 3 2s952ms 984ms [ User: intelifix - Total duration: 1m38s - Times executed: 35 ]
[ Application: psql - Total duration: 1m38s - Times executed: 35 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 08:00:20 Duration: 19s29ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 09:00:09 Duration: 8s166ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-11 09:40:09 Duration: 7s916ms Database: rio User: intelifix Remote: [local] Application: psql
16 211ms 16s859ms 2s706ms 145 6m32s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 11 00 6 31s321ms 5s220ms 01 5 12s212ms 2s442ms 02 5 13s368ms 2s673ms 03 5 13s676ms 2s735ms 04 6 14s144ms 2s357ms 05 3 8s961ms 2s987ms 07 10 30s361ms 3s36ms 08 12 40s260ms 3s355ms 09 12 44s635ms 3s719ms 10 12 44s532ms 3s711ms 11 12 32s171ms 2s680ms 12 7 9s85ms 1s297ms 13 6 7s843ms 1s307ms 14 12 25s592ms 2s132ms 15 12 25s925ms 2s160ms 16 5 6s50ms 1s210ms 17 4 3s113ms 778ms 20 1 405ms 405ms 21 4 13s296ms 3s324ms 22 6 15s498ms 2s583ms [ User: intelifix - Total duration: 6m32s - Times executed: 145 ]
[ Application: psql - Total duration: 6m32s - Times executed: 145 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 00:05:18 Duration: 16s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 10:45:09 Duration: 7s903ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-11 08:25:09 Duration: 7s779ms Database: rio User: intelifix Remote: [local] Application: psql
17 150ms 10s354ms 1s697ms 205 5m47s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 11 00 9 23s125ms 2s569ms 01 10 13s176ms 1s317ms 02 9 12s990ms 1s443ms 03 9 13s338ms 1s482ms 04 8 12s303ms 1s537ms 05 8 13s543ms 1s692ms 06 7 13s290ms 1s898ms 07 8 13s442ms 1s680ms 08 11 20s385ms 1s853ms 09 11 17s568ms 1s597ms 10 11 17s59ms 1s550ms 11 11 16s406ms 1s491ms 12 8 13s541ms 1s692ms 13 10 15s375ms 1s537ms 14 8 13s938ms 1s742ms 15 8 14s544ms 1s818ms 16 6 13s334ms 2s222ms 17 6 12s851ms 2s141ms 18 9 14s558ms 1s617ms 19 11 15s339ms 1s394ms 20 9 18s865ms 2s96ms 21 9 14s747ms 1s638ms 22 9 14s244ms 1s582ms [ User: intelifix - Total duration: 5m47s - Times executed: 205 ]
[ Application: psql - Total duration: 5m47s - Times executed: 205 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 00:05:28 Duration: 10s354ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 20:05:06 Duration: 4s975ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-11 08:15:10 Duration: 4s337ms Database: rio User: intelifix Remote: [local] Application: psql
18 172ms 13s198ms 1s535ms 54 1m22s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 11 08 3 4s577ms 1s525ms 09 3 2s215ms 738ms 10 6 9s756ms 1s626ms 11 4 9s668ms 2s417ms 12 4 8s543ms 2s135ms 13 3 2s389ms 796ms 14 3 2s305ms 768ms 15 4 4s36ms 1s9ms 16 3 2s524ms 841ms 17 3 14s755ms 4s918ms 18 4 10s860ms 2s715ms 19 4 3s72ms 768ms 20 4 3s257ms 814ms 21 3 2s224ms 741ms 22 3 2s745ms 915ms [ User: intelifix - Total duration: 1m22s - Times executed: 54 ]
[ Application: psql - Total duration: 1m22s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-11 17:40:15 Duration: 13s198ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-11 18:00:10 Duration: 8s822ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-11 11:00:09 Duration: 7s377ms Database: rio User: intelifix Remote: [local] Application: psql
19 151ms 13s200ms 847ms 68 57s610ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 11 07 11 4s967ms 451ms 08 3 1s461ms 487ms 09 14 6s232ms 445ms 10 5 2s800ms 560ms 11 9 6s320ms 702ms 12 2 12s155ms 6s77ms 13 2 555ms 277ms 14 10 3s481ms 348ms 15 11 17s34ms 1s548ms 16 1 2s602ms 2s602ms [ User: intelifix - Total duration: 57s610ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 57s610ms - Times executed: 68 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (056927) LIMIT 1;
Date: 2026-09-11 15:21:42 Duration: 13s200ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136735) LIMIT 1;
Date: 2026-09-11 12:11:25 Duration: 6s320ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136735) LIMIT 1;
Date: 2026-09-11 12:11:12 Duration: 5s834ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 150ms 5s251ms 751ms 1,084 13m34s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 11 07 73 1m7s 924ms 08 150 1m56s 776ms 09 179 2m13s 748ms 10 136 1m41s 749ms 11 175 2m15s 774ms 12 55 41s471ms 754ms 13 94 1m3s 672ms 14 112 1m18s 703ms 15 83 55s915ms 673ms 16 12 10s366ms 863ms 17 15 9s606ms 640ms [ User: intelifix - Total duration: 13m34s - Times executed: 1084 ]
[ Application: [unknown] - Total duration: 13m34s - Times executed: 1084 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286612, 503, '48575443A04467B6,4827C56204D8,2150088860LDRA004722,4827C56204DBB6,2426D658A530,2150088860EGRB029233,2426D658AF8DCB6,2426D658AF76,2150088860EGRB029256,2426D658A867ABC66B6,2426D601BF3C,2150088860EGRB001298,2426D60231D1B6,B89FCC05E4D4,2150088860LDR9003644,B89FCC05E4D7F7BB6,B89FCC058318,2150088860LDR9001083,B89FCC05831BA7B6,B89FCC0516D0,2150088860LDR9005195,B89FCC0516D3CCB6,B89FCC05E042,2150088860LDR9006990,B89FCC05E045AEEB8,FC180394E495,2150088860EGS3064642,FC180394E498D6CB8,FC1803931D81,2150088860EGS3053265,FC1803931D84E25B8,68F5431DA734,2150088860EGS2037389,68F5431DA8F9A0306AB6,4827C5613CF6,2150088860LDRA004014,4827C5613CF9A04455B6,4827C5620424,2150088860LDRA003489,4827C5620427B8,68F5437BEECC,2150088860EGS2026874,68F5437BE6C3', '',0466,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":""}]','$$$$$$$$$$$$$','', 00);
Date: 2026-09-11 12:15:13 Duration: 5s251ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286259, 304, '12728485850045800923,942CB3C3854A,942CB3588DCA,E820E225432C,942CB35AA308', '',0117,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""}]','$$$','', 00);
Date: 2026-09-11 09:25:11 Duration: 4s68ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (136564, 397, '919361004743,ECBEDDB9D947,F08175280BE7,A86ABBD10B1B,84A06E666D1F,302478653A51,981E19BD973B,981E19BA145C,B866850C1DCA,3093BCB1ADBB,A86ABBC8DB63', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-11 13:10:05 Duration: 3s660ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 254ms 1 254ms 254ms 254ms SELECT * FROM RS_ETIQUETA ('');Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 11 23 1 254ms 254ms [ User: etiquetas - Total duration: 457ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 457ms - Times executed: 1 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-11 23:31:07 Duration: 254ms Database: postgres User: brasilia Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 11 18 1 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 10s375ms - Times executed: 3 ]
[ Application: psql - Total duration: 10s375ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 16,263 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 23 FATAL entries
- 3912 ERROR entries
- 0 WARNING entries
- 7 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,898 Max number of times the same event was reported
- 3,942 Total events found
Rank Times reported Error 1 3,898 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 11 00 48 01 50 02 48 03 44 04 48 05 46 06 48 07 264 08 274 09 323 10 269 11 221 12 75 13 119 14 250 15 348 16 221 17 219 18 168 19 170 20 168 21 168 22 169 23 140 - ERROR: prepared statement "_PLAN00000000569BBE50" does not exist
- ERROR: prepared statement "_PLAN00000000569BDE40" does not exist
- ERROR: prepared statement "_PLAN00000000569BCC00" does not exist
Statement: DEALLOCATE "_PLAN00000000569BBE50"
Date: 2026-09-11 00:00:50 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000569BDE40"
Date: 2026-09-11 00:01:51 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000569BCC00"
Date: 2026-09-11 00:03:53 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 11 00 1 03 1 06 3 07 4 09 1 10 1 21 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-09-11 00:02:14 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-11 03:03:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-11 06:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
3 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 11 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-11 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-11 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-11 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
4 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 11 08 1 15 3 - ERROR: column "pas_id" does not exist at character 66 2026-09-11 08:36:47 -03 [3596519]: [25-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "cai_id" does not exist at character 39
- ERROR: column "cai_id" does not exist at character 39
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0136746);Date: 2026-09-11 08:36:47 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: Perhaps you meant to reference the column "temp0000227093.cli_id".
Statement: SELECT * FROM temp0000227093 ORDER BY CAI_ID DESCDate: 2026-09-11 15:16:06 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Hint: Perhaps you meant to reference the column "temp0000227093.cli_id".
Statement: SELECT * FROM temp0000227093 ORDER BY CAI_ID DESCDate: 2026-09-11 15:16:15 Database: contagem Application: [unknown] User: intelifix Remote: [local]
5 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 11 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-09-11 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-11 05:32:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-11 05:32:05 Database: contagem Application: psql User: intelifix Remote: [local]
6 4 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 11 15 4 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73926185850070402955)Date: 2026-09-11 15:16:20 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73926185850070402955)Date: 2026-09-11 15:16:20 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73926185850070402955)Date: 2026-09-11 15:16:30 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 11 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-09-11 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-11 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-11 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 11 18 3 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-09-11 18:15:23 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3
Date: 2026-09-11 18:15:23 Database: rio Application: pgAdmin 4 - CONN:3065655 User: lenon Remote: 172.20.0.3
Date: 2026-09-11 18:15:55 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
9 2 LOG: process ... still waiting for ExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 11 13 2 - LOG: process 3886809 still waiting for ExclusiveLock on relation 374564 of database 358222 after 1000.106 ms
- LOG: process 3886809 still waiting for ExclusiveLock on relation 374564 of database 358222 after 1578.105 ms
Detail: Process holding the lock: 3890678. Wait queue: 3886809.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"46", "usuario" :"413", "tipo" :"N", "itens" :"02", "nota-fiscal" :"11484", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-09-11 13:30:24 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3890678. Wait queue: 3886809.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"46", "usuario" :"413", "tipo" :"N", "itens" :"02", "nota-fiscal" :"11484", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-09-11 13:30:25 Database: contagem Application: [unknown] User: intelifix Remote: [local]
10 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 11 03 1 - LOG: database system was shut down at 2026-09-11 03:05:01 -03
Date: 2026-09-11 03:05:02
11 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 11 09 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000291177"
Date: 2026-09-11 09:34:38
12 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 11 09 1 - LOG: process 3701878 still waiting for AccessExclusiveLock on relation 4908201 of database 358220 after 1000.116 ms
Detail: Process holding the lock: 3709750. Wait queue: 3701878.
Statement: DROP TABLE IF EXISTS temp0000291177;Date: 2026-09-11 09:34:38 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 11 21 1 - FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-09-11 21:19:57 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
14 1 ERROR: prepared statement "..." does not exist/usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 11 11 1 - ERROR: prepared statement "_PLAN000000002F8807F0" does not exist/usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Statement: DEALLOCATE "_PLAN000000002F8807F0"
Date: 2026-09-11 11:00:08 Database: rio Application: [unknown] User: etiquetas Remote: [local]