pgBadger-
Global information
- Generated on Mon Sep 14 23:50:17 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 48,379 log entries in 15s
- Log start from 2026-09-14 00:00:32 to 2026-09-14 23:49:54
-
Overview
Global Stats
- 394 Number of unique normalized queries
- 5,269 Number of queries
- 7h22m35s Total query duration
- 2026-09-14 00:02:17 First query
- 2026-09-14 23:44:42 Last query
- 5 queries/s at 2026-09-14 23:44:18 Query peak
- 7h22m35s Total query duration
- 240ms Prepare/parse total duration
- 0ms Bind total duration
- 7h22m34s Execute total duration
- 6,170 Number of events
- 15 Number of unique normalized events
- 6,095 Max number of times the same event was reported
- 0 Number of cancellation
- 433 Total number of automatic vacuums
- 975 Total number of automatic analyzes
- 20 Number temporary file
- 245.55 MiB Max size of temporary file
- 66.84 MiB Average size of temporary file
- 489 Total number of sessions
- 8 sessions at 2026-09-14 08:20:09 Session peak
- 13d18h42m47s Total duration of sessions
- 40m34s Average duration of sessions
- 10 Average queries per session
- 54s305ms Average queries duration per session
- 39m40s Average idle time per session
- 504 Total number of connections
- 3 connections/s at 2026-09-14 15:49:05 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-14 23:44:18 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-14 10:21:47 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-14 23:44:18 Date
Queries duration
Key values
- 7h22m35s 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 14 00 26 0ms 19s814ms 3s999ms 2s155ms 2s361ms 1m12s 01 9 0ms 2s11ms 1s354ms 1s877ms 2s132ms 2s194ms 02 9 0ms 2s44ms 1s366ms 1s940ms 2s44ms 2s209ms 03 14 0ms 2s213ms 839ms 1s127ms 2s142ms 2s404ms 04 8 0ms 1s977ms 1s478ms 1s858ms 1s977ms 2s109ms 05 12 0ms 11m27s 1m57s 1s993ms 2m56s 11m27s 06 18 0ms 13s347ms 2s972ms 1s976ms 2s145ms 22s938ms 07 96 0ms 10m14s 12s356ms 13s880ms 2m42s 10m23s 08 372 0ms 7m3s 4s664ms 1m3s 3m22s 7m6s 09 551 150ms 8m51s 4s71ms 1m 4m40s 8m56s 10 537 150ms 8m55s 4s538ms 1m24s 4m50s 8m56s 11 487 0ms 8m4s 4s401ms 1m20s 4m21s 8m35s 12 153 0ms 8m6s 7s620ms 29s341ms 1m45s 8m9s 13 399 0ms 5m23s 2s783ms 19s786ms 1m22s 5m25s 14 603 150ms 8m2s 4s521ms 1m7s 5m39s 8m51s 15 548 153ms 5m52s 2s378ms 37s180ms 1m1s 6m4s 16 508 151ms 5m16s 2s331ms 28s559ms 47s756ms 6m3s 17 304 0ms 7m40s 6s157ms 1m10s 3m6s 7m41s 18 68 0ms 5m12s 9s955ms 7s735ms 38s544ms 6m1s 19 26 0ms 4m56s 21s830ms 2s190ms 44s770ms 4m56s 20 113 0ms 5m11s 10s512ms 1m2s 1m36s 6m9s 21 30 0ms 6m41s 23s560ms 6s760ms 1m 6m41s 22 31 0ms 5m10s 20s158ms 7s653ms 10s254ms 5m55s 23 347 0ms 1m6s 5s963ms 1m6s 1m10s 2m1s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 14 00 6 0 3s414ms 0ms 0ms 408ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 4 0 203ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 6 0 3s379ms 0ms 0ms 1s424ms 07 73 0 14s793ms 1s828ms 5s219ms 3m57s 08 289 0 4s711ms 8s938ms 44s257ms 4m58s 09 427 0 4s40ms 12s781ms 47s511ms 5m39s 10 449 0 4s481ms 31s389ms 1m17s 5m58s 11 399 0 4s195ms 12s832ms 48s27ms 5m54s 12 101 0 10s95ms 2s976ms 28s633ms 4m24s 13 342 0 2s919ms 9s829ms 17s273ms 3m42s 14 461 0 4s520ms 23s147ms 58s599ms 5m37s 15 457 0 2s333ms 8s948ms 27s547ms 3m42s 16 422 0 2s344ms 12s631ms 18s487ms 3m42s 17 206 0 6s958ms 18s965ms 52s156ms 3m49s 18 35 0 18s412ms 0ms 7s735ms 3m29s 19 11 0 49s986ms 0ms 244ms 3m27s 20 17 80 11s991ms 34s430ms 1m2s 3m47s 21 9 0 1m13s 0ms 0ms 3m22s 22 9 0 1m3s 0ms 0ms 3m38s 23 24 322 5s979ms 1m1s 1m6s 2m Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 14 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 14 14.00 0.00% 08 1 14 14.00 0.29% 09 0 19 19.00 0.00% 10 0 19 19.00 0.00% 11 0 13 13.00 0.00% 12 0 8 8.00 0.00% 13 0 17 17.00 0.00% 14 0 16 16.00 0.00% 15 0 13 13.00 0.00% 16 0 11 11.00 0.00% 17 0 8 8.00 0.00% 18 0 1 1.00 0.00% 19 0 1 1.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 1 1.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Sep 14 00 26 0.01/s 01 19 0.01/s 02 19 0.01/s 03 31 0.01/s 04 20 0.01/s 05 17 0.00/s 06 21 0.01/s 07 23 0.01/s 08 34 0.01/s 09 30 0.01/s 10 33 0.01/s 11 26 0.01/s 12 20 0.01/s 13 29 0.01/s 14 26 0.01/s 15 25 0.01/s 16 21 0.01/s 17 20 0.01/s 18 9 0.00/s 19 15 0.00/s 20 11 0.00/s 21 9 0.00/s 22 9 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Sep 14 00 15 23m17s 23m10s 01 25 38m44s 38m43s 02 19 31m22s 31m21s 03 25 13m40s 13m40s 04 18 31m27s 31m26s 05 16 37m15s 35m47s 06 14 40m42s 40m38s 07 26 37m39s 36m54s 08 26 30m38s 29m31s 09 31 41m20s 40m8s 10 32 38m32s 37m16s 11 30 39m4s 37m52s 12 21 44m25s 43m29s 13 22 41m47s 40m56s 14 27 43m26s 41m45s 15 27 42m54s 42m5s 16 22 48m37s 47m44s 17 19 49m54s 48m15s 18 16 1h22s 59m40s 19 11 49m33s 48m41s 20 13 47m29s 45m58s 21 8 1h11s 58m43s 22 11 1h31m8s 1h30m11s 23 15 38m30s 36m12s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-09-14 15:49:05 Date
Connections per database
Key values
- brasilia Main Database
- 504 connections Total
Connections per user
Key values
- etiquetas Main User
- 504 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-09-14 08:20:09 Date
Histogram of session times
Key values
- 285 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 489 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 489 sessions Total
Sessions per host
Key values
- [local] Main Host
- 489 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 489 sessions Total
Application Count Total Duration Average Duration [unknown] 456 12d15h25m8s 39m55s pgAdmin 4 - CONN:4051712 1 2h52m5s 2h52m5s pgAdmin 4 - DB:contagem 2 5s587ms 2s793ms pgAdmin 4 - DB:postgres 1 2h52m15s 2h52m15s pgAdmin 4 - DB:rio 1 2h52m7s 2h52m7s pg_dump 9 43m54s 4m52s postgres_fdw 1 34m58s 34m58s psql 18 17h22m12s 57m54s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 16,766 buffers Checkpoint Peak
- 2026-09-14 10:44:37 Date
- 270.016 seconds Highest write time
- 1.040 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-09-14 14:54:39 Date
Checkpoints distance
Key values
- 426.95 Mo Distance Peak
- 2026-09-14 14:54:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 14 00 8,232 269.388s 0.004s 269.397s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 7,708 0.17s 1.033s 1.248s 04 0 0s 0s 0s 05 7,628 763.254s 0.281s 763.601s 06 3,209 320.593s 0.006s 320.627s 07 5,870 588.039s 0.172s 588.289s 08 42,026 2,747.082s 0.541s 2,747.701s 09 61,075 3,238.84s 0.841s 3,239.785s 10 67,832 3,238.471s 1.048s 3,239.619s 11 59,728 3,238.872s 1.71s 3,240.743s 12 19,726 1,902.45s 0.303s 1,902.812s 13 28,628 2,348.888s 0.662s 2,349.659s 14 53,151 3,196.511s 1.046s 3,197.663s 15 51,249 3,238.472s 1.068s 3,239.706s 16 44,803 3,230.799s 0.88s 3,231.816s 17 35,436 2,615.474s 0.603s 2,616.231s 18 7,133 545.498s 0.149s 545.793s 19 180 18.086s 0.151s 18.311s 20 1,167 154.506s 0.038s 154.556s 21 2,824 282.76s 0.078s 282.955s 22 2,785 278.918s 0.204s 279.214s 23 316 32.108s 0.102s 32.293s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 14 00 0 0 3 32 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 3 26 1.017s 0.046s 04 0 0 0 0 0s 0s 05 0 0 3 149 0.063s 0.021s 06 0 0 0 32 0.002s 0.002s 07 0 0 2 1,384 0.037s 0.012s 08 0 0 25 5,488 0.061s 0.012s 09 0 0 34 7,552 0.083s 0.012s 10 0 0 43 7,409 0.101s 0.012s 11 0 0 35 7,403 0.246s 0.013s 12 0 0 9 3,148 0.083s 0.012s 13 0 0 11 5,400 0.067s 0.012s 14 0 0 50 7,493 0.063s 0.012s 15 0 0 36 7,490 0.063s 0.012s 16 0 0 24 6,810 0.064s 0.012s 17 0 0 46 5,141 0.058s 0.011s 18 0 0 7 870 0.063s 0.007s 19 0 0 0 103 0.065s 0.029s 20 0 0 1 84 0.015s 0.003s 21 0 0 1 408 0.052s 0.005s 22 0 0 1 417 0.075s 0.011s 23 0 0 0 31 0.071s 0.022s Day Hour Count Avg time (sec) Sep 14 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 14 00 44,839.00 kB 44,839.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 22,883.00 kB 22,883.00 kB 04 0.00 kB 0.00 kB 05 6,997.57 kB 10,226.43 kB 06 5,216.50 kB 10,937.50 kB 07 2,568.08 kB 6,808.17 kB 08 34,690.50 kB 51,347.92 kB 09 46,309.33 kB 97,556.83 kB 10 58,530.17 kB 105,376.17 kB 11 47,592.42 kB 112,128.17 kB 12 12,287.08 kB 60,071.25 kB 13 15,162.00 kB 27,617.17 kB 14 68,084.58 kB 86,777.92 kB 15 48,592.83 kB 140,818.33 kB 16 32,667.33 kB 81,570.50 kB 17 69,173.27 kB 111,490.91 kB 18 23,148.40 kB 102,052.60 kB 19 207.33 kB 60,268.33 kB 20 4,973.67 kB 38,311.00 kB 21 2,749.20 kB 26,170.40 kB 22 2,128.00 kB 15,106.29 kB 23 202.40 kB 8,494.20 kB -
Temporary Files
Size of temporary files
Key values
- 491.11 MiB Temp Files size Peak
- 2026-09-14 05:31:54 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-14 05:31:59 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 14 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.31 GiB 66.84 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.62 MiB 245.55 MiB 64.46 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-14 05:32:02 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-14 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 305.55 MiB 56.79 MiB 93.45 MiB 76.39 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-14 05:30:41 Duration: 38s581ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-14 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 245.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 245.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-14 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-14 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-14 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.79 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-14 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.60 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.54 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:31:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.62 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-14 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 16.00 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-14 09:29:53 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 16.00 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-14 09:29:53 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (117) Main table analyzed (database rio)
- 975 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 117 rio.pg_catalog.pg_class 61 rio.pg_catalog.pg_type 55 contagem.pg_catalog.pg_attribute 50 rio.public.usuarios 48 brasilia.pg_catalog.pg_attribute 42 rio.pg_catalog.pg_index 38 rio.public.temp0000291267 30 contagem.pg_catalog.pg_class 29 contagem.public.usuarios 29 rio.pg_catalog.pg_depend 29 rio.public.temp0000291339 28 rio.public.temp0000291315 27 contagem.pg_catalog.pg_type 25 brasilia.pg_catalog.pg_class 22 brasilia.pg_catalog.pg_type 18 contagem.pg_catalog.pg_index 17 rio.public.temp0000291309 17 rio.public.temp0000291083 16 contagem.public.temp0000227135 14 brasilia.public.temp0000240088 14 rio.public.temp0000291375 14 rio.public.temp0000290026 13 brasilia.pg_catalog.pg_index 13 contagem.pg_catalog.pg_depend 13 rio.public.temp0000290230 11 contagem.public.temp0000227141 9 brasilia.pg_catalog.pg_depend 9 contagem.public.temp0000227133 9 rio.pg_catalog.pg_shdepend 9 rio.public.temp0000291281 8 brasilia.public.usuarios 8 contagem.public.temp0000227137 7 rio.public.temp0000291257 7 rio.public.temp0000291265 6 rio.public.temp0000291373 6 rio.public.temp0000291255 5 rio.public.temp0000290787 5 rio.public.temp0000291343 4 contagem.pg_catalog.pg_shdepend 4 brasilia.public.temp0000240062 4 brasilia.public.temp0000240136 4 rio.public.temp0000291369 4 brasilia.public.temp0000240076 3 rio.public.temp0000291253 3 brasilia.public.temp0000240086 3 brasilia.public.temp0000240154 3 rio.public.tmp_drill_0302 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.nf_entrada 3 contagem.public.temp0000227143 3 contagem.public.temp0000227147 3 brasilia.public.temp0000240066 2 brasilia.public.temp0000240074 2 rio.public.temp0000291283 2 brasilia.public.temp0000240124 2 contagem.public.nf_entrada 2 rio.public.tmp_drill_0320 2 rio.public.temp0000291323 2 rio.public.temp0000291121 2 rio.public.temp0000291329 2 brasilia.public.temp0000240072 1 rio.public.temp0000291287 1 contagem.public.temp0000227145 1 rio.public.temp0000291313 1 rio.public.temp0000291295 1 brasilia.public.temp0000240070 1 rio.public.temp0000291279 1 brasilia.public.temp0000240120 1 brasilia.public.temp0000240082 1 rio.public.temp0000291327 1 rio.public.temp0000291359 1 brasilia.public.temp0000240102 1 rio.public.temp0000291273 1 brasilia.public.temp0000240134 1 rio.public.temp0000291371 1 brasilia.public.temp0000240100 1 rio.public.temp0000291271 1 rio.public.temp0000291341 1 rio.public.temp0000291349 1 rio.public.temp0000291317 1 brasilia.public.temp0000240094 1 rio.public.temp0000291285 1 rio.public.temp0000291385 1 brasilia.public.temp0000240152 1 brasilia.public.temp0000240064 1 rio.public.temp0000290893 1 rio.public.temp0000290921 1 brasilia.public.temp0000240114 1 contagem.auditor.auditor_2026_09 1 brasilia.public.temp0000240098 1 contagem.public.temp0000227151 1 brasilia.public.temp0000240122 1 Total 975 Vacuums per table
Key values
- pg_catalog.pg_attribute (46) Main table vacuumed on database rio
- 433 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 46 44 0 0 0 0 0 24,620 6,295 9,420,821 364 9,086 rio.pg_catalog.pg_class 34 29 0 0 0 0 0 5,534 1,566 2,378,080 85 298 contagem.public.usuarios 29 0 0 0 0 0 0 138 100 53,227 0 0 rio.public.temp0000291315 26 0 0 0 0 0 0 32,393 97 1,928,836 0 0 rio.pg_catalog.pg_type 25 24 0 0 0 0 0 2,298 657 921,154 71 225 contagem.pg_catalog.pg_attribute 22 22 0 0 0 0 0 12,016 2,517 4,883,150 21 506 rio.public.temp0000291267 22 0 0 0 0 0 0 20,166 3,738 5,970,096 0 0 rio.public.temp0000291339 18 0 0 0 0 0 0 14,844 76 887,469 0 0 rio.pg_catalog.pg_index 15 15 0 0 0 0 0 842 237 230,897 36 81 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 7,811 1,581 2,901,691 61 1,578 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 4,098 1,494 2,219,591 68 667 contagem.pg_catalog.pg_class 11 11 0 0 0 0 0 2,076 336 591,080 11 31 rio.public.temp0000290026 11 0 0 0 0 0 0 664 108 119,567 0 0 contagem.pg_catalog.pg_type 10 10 0 0 0 0 0 1,082 222 376,680 6 16 rio.public.temp0000291083 10 0 0 0 0 0 0 514 106 116,311 0 0 brasilia.pg_catalog.pg_class 9 9 0 0 0 0 0 1,926 405 717,328 25 107 brasilia.pg_catalog.pg_type 9 9 0 0 0 0 0 816 172 292,687 14 62 rio.public.temp0000291375 8 0 0 0 0 0 0 4,051 41 245,281 0 0 rio.public.temp0000290230 8 0 0 0 0 0 0 467 46 34,334 0 0 contagem.pg_catalog.pg_index 7 7 0 0 0 0 0 366 100 112,324 5 8 contagem.pg_catalog.pg_depend 7 7 0 0 0 0 0 1,974 370 858,601 6 36 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 8,082 1,940 8,790,662 995 5,376 brasilia.pg_catalog.pg_index 6 6 0 0 0 0 0 272 68 68,429 14 36 rio.public.temp0000291369 5 0 0 0 0 0 0 8,995 20 533,720 0 0 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 804 252 395,249 33 68 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,308 393 572,989 10 113 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,872 460 2,631,177 133 353 rio.public.usuarios 4 4 0 0 0 0 0 100 40 86,129 5 5 rio.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 660 201 363,110 30 74 brasilia.public.temp0000240136 4 0 0 0 0 0 0 1,008 264 448,794 0 0 contagem.public.temp0000227137 4 0 0 0 0 0 0 351 23 24,505 0 0 brasilia.public.temp0000240154 3 0 0 0 0 0 0 756 12 46,413 0 0 rio.public.temp0000290787 3 0 0 0 0 0 0 223 18 15,744 0 0 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 91 9 20,299 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,283 515 2,196,869 403 2,845 rio.public.temp0000291121 2 0 0 0 0 0 0 3,592 8 213,134 0 0 brasilia.public.temp0000240124 2 0 0 0 0 0 0 504 8 30,942 0 0 brasilia.public.temp0000240074 2 0 0 0 0 0 0 504 8 30,942 0 0 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 58 6 12,898 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,866 331 1,315,664 238 1,773 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 257 64 274,333 18 38 rio.public.temp0000291341 1 0 0 0 0 0 0 68 6 4,887 0 0 brasilia.public.temp0000240100 1 0 0 0 0 0 0 252 4 15,471 0 0 rio.public.temp0000291371 1 0 0 0 0 0 0 67 4 4,556 0 0 brasilia.public.temp0000240114 1 0 0 0 0 0 0 4 3 774 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 116 25 90,606 9 12 rio.public.temp0000291283 1 0 0 0 0 0 0 1,796 4 106,567 0 0 brasilia.public.temp0000240152 1 0 0 0 0 0 0 252 4 15,471 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 173 105 252,901 9 9 rio.auditor.auditor_2026_09 1 0 0 0 0 0 0 54,185 40,071 49,097,523 6,896 134,248 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 25,657 13,341 17,696,722 6,025 115,732 contagem.public.nf_entrada 1 1 0 0 0 0 0 191 91 111,154 5 13 Total 433 260 0 0 0 0 0 257,043 78,562 120,727,839 15,596 273,396 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (16) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.48 rio.pg_catalog.pg_class 0 0 1.03 contagem.public.usuarios 0 0 0.06 rio.public.temp0000291315 0 0 1.56 rio.pg_catalog.pg_type 0 0 0.28 contagem.pg_catalog.pg_attribute 0 0 1.75 rio.public.temp0000291267 0 0 0.76 rio.public.temp0000291339 0 0 0.34 rio.pg_catalog.pg_index 0 0 0.33 brasilia.pg_catalog.pg_attribute 0 0 1.78 rio.pg_catalog.pg_depend 0 0 1.1 contagem.pg_catalog.pg_class 0 0 0.45 rio.public.temp0000290026 0 0 0.01 contagem.pg_catalog.pg_type 0 0 0.45 rio.public.temp0000291083 0 0 0.02 brasilia.pg_catalog.pg_class 0 0 0.83 brasilia.pg_catalog.pg_type 0 0 0.56 rio.public.temp0000291375 0 0 0.13 rio.public.temp0000290230 0 0 0 contagem.pg_catalog.pg_index 0 0 0.24 contagem.pg_catalog.pg_depend 0 0 0.57 rio.pg_catalog.pg_statistic 0 0 1.45 brasilia.pg_catalog.pg_index 0 0 0.16 rio.public.temp0000291369 0 0 0.22 brasilia.pg_catalog.pg_shdepend 0 0 0.59 brasilia.pg_catalog.pg_depend 0 0 0.77 rio.pg_toast.pg_toast_2619 0 0 0.42 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0.12 brasilia.public.temp0000240136 0 0 0.01 contagem.public.temp0000227137 0 0 0 brasilia.public.temp0000240154 0 0 0 rio.public.temp0000290787 0 0 0.01 rio.public.tmp_drill_0302 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.45 rio.public.temp0000291121 0 0 0.08 brasilia.public.temp0000240124 0 0 0 brasilia.public.temp0000240074 0 0 0 rio.public.tmp_drill_0320 0 0 0 contagem.pg_catalog.pg_statistic 0 0 0.34 brasilia.pg_toast.pg_toast_2619 0 0 0.03 rio.public.temp0000291341 0 0 0 brasilia.public.temp0000240100 0 0 0 rio.public.temp0000291371 0 0 0 brasilia.public.temp0000240114 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000291283 0 0 0.04 brasilia.public.temp0000240152 0 0 0 brasilia.public.nf_entrada 0 0 0.27 rio.auditor.auditor_2026_09 0 0 16 brasilia.auditor.auditor_2026_09 0 0 5.06 contagem.public.nf_entrada 0 0 0.04 Total 0 0 41.79 Tuples removed per table
Key values
- pg_catalog.pg_attribute (191116) Main table with removed tuples on database rio
- 423775 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 46 44 191,116 1,137,840 42,842 400 28,064 brasilia.pg_catalog.pg_attribute 14 14 72,930 313,633 192 142 8,046 contagem.pg_catalog.pg_attribute 22 22 72,556 563,099 119 186 13,614 rio.pg_catalog.pg_statistic 6 6 11,073 49,368 251 0 7,716 rio.pg_catalog.pg_type 25 24 8,715 59,105 2,130 16 1,806 rio.pg_catalog.pg_depend 12 12 8,494 231,649 3,516 0 2,244 contagem.pg_catalog.pg_depend 7 7 5,782 131,373 12 0 1,246 contagem.pg_catalog.pg_statistic 2 2 5,372 14,930 0 0 2,022 rio.pg_catalog.pg_shdepend 4 4 4,941 54,422 0 0 500 brasilia.pg_catalog.pg_statistic 2 2 4,731 15,322 0 0 2,144 contagem.pg_catalog.pg_type 10 10 4,587 22,500 4 48 723 brasilia.pg_catalog.pg_class 9 9 4,193 34,418 1 45 1,251 rio.pg_catalog.pg_class 34 29 4,088 129,415 10,191 74 4,311 brasilia.pg_catalog.pg_shdepend 5 5 3,944 68,606 702 0 625 brasilia.pg_catalog.pg_type 9 9 3,873 20,143 36 19 582 contagem.pg_catalog.pg_class 11 11 3,671 38,600 8 28 1,509 rio.pg_catalog.pg_index 15 15 3,395 29,339 455 6 815 contagem.public.usuarios 29 0 1,769 696 0 0 58 brasilia.pg_catalog.pg_index 6 6 1,738 11,369 0 6 305 contagem.pg_catalog.pg_index 7 7 1,683 13,283 2 25 366 brasilia.pg_catalog.pg_depend 4 4 1,350 72,685 0 15 702 rio.pg_toast.pg_toast_2619 4 4 1,097 2,559 0 0 1,012 brasilia.public.nf_entrada 1 1 839 4,841 0 0 152 rio.auditor.auditor_2026_09 1 0 526 8,760,261 0 0 403,522 brasilia.auditor.auditor_2026_09 1 0 420 2,110,292 0 0 92,126 rio.public.usuarios 4 4 312 2,353 317 0 76 contagem.public.nf_entrada 1 1 293 1,062 0 0 79 brasilia.pg_toast.pg_toast_2619 2 2 190 282 0 0 120 contagem.pg_toast.pg_toast_2619 1 1 97 113 0 0 51 rio.public.temp0000291341 1 0 0 1,066 0 4 60 brasilia.public.temp0000240100 1 0 0 3,307 0 0 256 rio.public.temp0000291375 8 0 0 91,001 0 234 5,974 rio.public.temp0000290230 8 0 0 24,711 0 192 544 brasilia.public.temp0000240154 3 0 0 9,929 0 0 768 rio.public.temp0000291121 2 0 0 50,821 0 0 3,584 rio.public.temp0000291371 1 0 0 1,116 0 0 64 brasilia.public.temp0000240114 1 0 0 3,307 0 0 256 brasilia.public.temp0000240124 2 0 0 6,618 0 0 512 rio.public.temp0000291315 26 0 0 661,368 0 0 47,936 rio.public.temp0000291283 1 0 0 25,411 0 0 1,792 brasilia.public.temp0000240074 2 0 0 6,614 0 0 512 brasilia.public.temp0000240152 1 0 0 3,309 0 0 256 rio.public.temp0000291083 10 0 0 24,204 0 267 533 rio.public.temp0000291369 5 0 0 127,267 0 0 9,280 rio.public.temp0000290787 3 0 0 9,019 0 121 199 rio.public.tmp_drill_0320 2 2 0 589 0 0 16 rio.public.temp0000291339 18 0 0 223,243 0 224 15,520 rio.public.temp0000291267 22 0 0 440,557 0 110 31,442 rio.public.temp0000290026 11 0 0 30,523 0 255 673 rio.public.tmp_drill_0302 3 3 0 974 0 0 27 brasilia.public.temp0000240136 4 0 0 13,236 0 0 1,024 contagem.public.temp0000227137 4 0 0 5,484 0 88 424 Total 433 260 423,775 15,657,232 60,778 2,505 697,439 Pages removed per table
Key values
- pg_catalog.pg_attribute (400) Main table with removed pages on database rio
- 2505 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 46 44 191116 400 rio.public.temp0000291083 10 0 0 267 rio.public.temp0000290026 11 0 0 255 rio.public.temp0000291375 8 0 0 234 rio.public.temp0000291339 18 0 0 224 rio.public.temp0000290230 8 0 0 192 contagem.pg_catalog.pg_attribute 22 22 72556 186 brasilia.pg_catalog.pg_attribute 14 14 72930 142 rio.public.temp0000290787 3 0 0 121 rio.public.temp0000291267 22 0 0 110 contagem.public.temp0000227137 4 0 0 88 rio.pg_catalog.pg_class 34 29 4088 74 contagem.pg_catalog.pg_type 10 10 4587 48 brasilia.pg_catalog.pg_class 9 9 4193 45 contagem.pg_catalog.pg_class 11 11 3671 28 contagem.pg_catalog.pg_index 7 7 1683 25 brasilia.pg_catalog.pg_type 9 9 3873 19 rio.pg_catalog.pg_type 25 24 8715 16 brasilia.pg_catalog.pg_depend 4 4 1350 15 rio.pg_catalog.pg_index 15 15 3395 6 brasilia.pg_catalog.pg_index 6 6 1738 6 rio.public.temp0000291341 1 0 0 4 rio.pg_catalog.pg_depend 12 12 8494 0 brasilia.public.temp0000240100 1 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 4731 0 contagem.pg_catalog.pg_depend 7 7 5782 0 brasilia.public.temp0000240154 3 0 0 0 rio.public.temp0000291121 2 0 0 0 rio.public.temp0000291371 1 0 0 0 brasilia.public.temp0000240114 1 0 0 0 brasilia.public.temp0000240124 2 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1097 0 rio.public.temp0000291315 26 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 97 0 rio.public.usuarios 4 4 312 0 rio.pg_catalog.pg_shdepend 4 4 4941 0 rio.public.temp0000291283 1 0 0 0 brasilia.public.temp0000240074 2 0 0 0 brasilia.public.temp0000240152 1 0 0 0 rio.public.temp0000291369 5 0 0 0 rio.pg_catalog.pg_statistic 6 6 11073 0 rio.public.tmp_drill_0320 2 2 0 0 contagem.public.usuarios 29 0 1769 0 brasilia.public.nf_entrada 1 1 839 0 rio.auditor.auditor_2026_09 1 0 526 0 brasilia.pg_catalog.pg_shdepend 5 5 3944 0 brasilia.auditor.auditor_2026_09 1 0 420 0 contagem.pg_catalog.pg_statistic 2 2 5372 0 contagem.public.nf_entrada 1 1 293 0 rio.public.tmp_drill_0302 3 3 0 0 brasilia.pg_toast.pg_toast_2619 2 2 190 0 brasilia.public.temp0000240136 4 0 0 0 Total 433 260 423,775 2,505 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 14 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 1 6 08 30 78 09 66 134 10 47 111 11 58 104 12 4 19 13 15 55 14 59 128 15 39 117 16 38 101 17 46 84 18 22 36 19 0 1 20 0 0 21 2 1 22 0 0 23 0 0 - 16.00 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 4m32s 2m8s 2m24s 2m16s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 11:47:36 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 09:17:19 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 00:05:21 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s10ms 1s10ms 1s10ms 1s10ms drop table if exists temp0000291369;-
DROP TABLE IF EXISTS temp0000291369;
Date: 2026-09-14 15:14:43 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291369;
Date: 2026-09-14 15:14:43 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m24s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-14 11:47:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 2m8s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-14 09:17:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s10ms DROP TABLE IF EXISTS temp0000291369;[ Date: 2026-09-14 15:14:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,747 Total read queries
- 1,069 Total write queries
Queries by database
Key values
- rio Main database
- 3,250 Requests
- 5h23m7s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,202 1h45m copy to 140 11m19s ddl 139 2m12s others 185 11m3s select 738 1h20m25s contagem Total 816 14m27s copy to 116 1m25s ddl 82 54s780ms others 8 3m19s select 610 8m47s postgres Total 1 154ms others 1 154ms rio Total 3,250 5h23m7s copy to 146 30m35s ddl 446 38m9s others 259 34m20s select 2,399 3h40m1s Queries by user
Key values
- intelifix Main user
- 5,091 Requests
User Request type Count Duration etiquetas Total 77 24s837ms others 1 172ms select 76 24s664ms intelifix Total 5,091 7h21m copy to 402 43m19s ddl 667 41m16s others 451 48m43s select 3,571 5h7m40s lenon Total 101 1m9s others 1 154ms select 100 1m9s Duration by user
Key values
- 7h21m (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 77 24s837ms others 1 172ms select 76 24s664ms intelifix Total 5,091 7h21m copy to 402 43m19s ddl 667 41m16s others 451 48m43s select 3,571 5h7m40s lenon Total 101 1m9s others 1 154ms select 100 1m9s Queries by host
Key values
- [local] Main host
- 5,267 Requests
- 7h22m34s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,182 Requests
- 4h15m34s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 4,182 2h23m31s ddl 667 41m16s others 1 172ms select 3,514 1h42m14s pgAdmin 4 - CONN:4051712 Total 1 772ms select 1 772ms pgAdmin 4 - DB:postgres Total 1 154ms others 1 154ms pg_dump Total 431 43m27s copy to 402 43m19s others 1 172ms select 28 8s248ms psql Total 654 4h15m34s others 450 48m43s select 204 3h26m50s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-14 09:20:47 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,203 100-500ms duration
Slowest individual queries
Rank Duration Query 1 11m27s analyze verbose;[ Date: 2026-09-14 05:11:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 07:15:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 10:13:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 09:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 12:13:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 11:13:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 14:13:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 17:12:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m3s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-14 08:50:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 6m52s analyze verbose;[ Date: 2026-09-14 05:18:21 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
11 6m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 21:11:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029835, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-14 10:44:31 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 15:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-14 11:47:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029826, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-14 09:17:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029846, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-14 14:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029856, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-14 14:53:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 13:10:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 16:10:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-14 18:10:13 - 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 1h56m33s 48 1s378ms 10m14s 2m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 14 07 3 11m4s 3m41s 08 3 5m11s 1m43s 09 3 9m50s 3m16s 10 3 9m40s 3m13s 11 3 8m53s 2m57s 12 3 8m52s 2m57s 13 3 5m40s 1m53s 14 3 8m53s 2m57s 15 3 6m11s 2m3s 16 3 5m32s 1m50s 17 3 7m59s 2m39s 18 3 5m30s 1m50s 19 3 5m12s 1m44s 20 3 5m36s 1m52s 21 3 6m57s 2m19s 22 3 5m26s 1m48s [ User: intelifix - Total duration: 1h56m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 07:15:16 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 10:13:57 Duration: 8m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 09:13:53 Duration: 8m51s Database: rio User: intelifix Remote: [local] Application: psql
2 1h17m51s 48 212ms 4m26s 1m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 14 07 3 5m59s 1m59s 08 3 3m46s 1m15s 09 3 5m54s 1m58s 10 3 6m14s 2m4s 11 3 5m50s 1m56s 12 3 5m57s 1m59s 13 3 4m7s 1m22s 14 3 5m46s 1m55s 15 3 4m8s 1m22s 16 3 4m6s 1m22s 17 3 5m6s 1m42s 18 3 3m57s 1m19s 19 3 3m55s 1m18s 20 3 4m45s 1m35s 21 3 4m7s 1m22s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h17m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h17m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 10:20:47 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 12:19:40 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 09:20:30 Duration: 4m10s Database: brasilia User: intelifix Remote: [local] Application: psql
3 52m31s 198 152ms 7m3s 15s914ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 14 07 8 2s797ms 349ms 08 12 8m17s 41s454ms 09 21 7m1s 20s89ms 10 20 6m20s 19s44ms 11 21 6m59s 19s955ms 12 2 27s626ms 13s813ms 13 17 1m57s 6s938ms 14 32 12m16s 23s23ms 15 24 1m29s 3s713ms 16 12 29s65ms 2s422ms 17 22 6m45s 18s409ms 18 7 23s430ms 3s347ms [ User: intelifix - Total duration: 52m31s - Times executed: 198 ]
[ Application: [unknown] - Total duration: 52m31s - Times executed: 198 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 08:50:07 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029835, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 10:44:31 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 11:47:36 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 21m16s 3 2m56s 11m27s 7m5s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 14 05 3 21m16s 7m5s [ User: intelifix - Total duration: 21m16s - Times executed: 3 ]
[ Application: psql - Total duration: 21m16s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-14 05:11:29 Duration: 11m27s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-14 05:18:21 Duration: 6m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-14 05:21:18 Duration: 2m56s Database: contagem User: intelifix Remote: [local] Application: psql
5 20m45s 1,412 151ms 6s215ms 881ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 14 08 64 1m6s 1s37ms 09 187 2m38s 849ms 10 176 2m51s 975ms 11 157 2m7s 809ms 12 40 33s164ms 829ms 13 113 1m58s 1s52ms 14 186 2m50s 916ms 15 244 3m28s 853ms 16 174 2m26s 844ms 17 71 43s78ms 606ms [ User: intelifix - Total duration: 20m45s - Times executed: 1412 ]
[ Application: [unknown] - Total duration: 20m45s - Times executed: 1412 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (57472, 413, '270911021146105320,229837205357,229812026278,229741749699,229669496767,229816139104,229666637992,229784241839,229932257989,229726496382,229745738293,229665137778,229809018802,229880053748,229879573645,229812022945,229740524463,229815899103,229809113637,229865826680,229807835768,229684444848,229747738690,229812600611,229879298488,229742919499,229754055368,229925137081,229745748698,229810970609,216945002124,229660025170', '246642230214,246628608591,246526645173,246515086985,246630531025,246467798486,246587602222,226027627896,246523647697,246558723747,246469755973,226324956072,246652477576,246652541725,246628614552,246535446267,246629037376,246627571836,246653670309,246619735571,246513553435,246549720916,246628526081,246652542028,246552200507,246557772027,246504258397,246558723545,246642261328,246498147071,246487349800', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-14 08:33:09 Duration: 6s215ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286313, 304, '920331065512,209A7DB67CB1,ACD75BB5DCCA,6CBAB8F1D381,3C585D79D394,8CFDDE7A6892,20B82BF9C53E,D0CF0EFDE310,ACD75BB6D4B0,D833B7541F78,186A81D56D8D,B0BBE54D23DE,482952461ED6,4C195DCCEE41,943C9678A050,44D4546A585B,ACD75BB5AE16,38A6592515B3,209A7DBC23A0,209A7DBB1937,F081751CB52D,64FD965E5A83,5CFA25AD3892,D0CF0EFCD2DB,CC5830E36324,ACD75BB8277A,8CFDDE87819B,B0FC88E98DBA,6CBAB8EA8195,841EA39211F5,C03C04870331,8CC5B4EDDCF3,CC5830E1F9C4,B0FC88EABBF5,841EA38D7F8B,E4C0E297DF66,44D45494B210,5447CC494C04,841EA3753C6E,44D454AC0319,48295245AD39', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-14 16:25:10 Duration: 5s225ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286312, 304, 'F200011196B964E,840112050C89$F200010336E21D9,9877E70065FD$F200011334B23A6,840112846A6A$F200011314B1341,84011280A0C0$F200012311B7322,1834AF617F4B$F200011251B43F6,8401123767F0$F200010284B61A0,743AEFAD7D9A$F200011333B1C35,84011284505B$F200010290B9DE7,743AEFAEFD5F$F200012311B7352,1834AF617F60$F200013234B1399,1834AF9A1743$F200011119B4B80,9877E7B83FEE$F200010287BBEFE,743AEFADFE9C$F200010349B11F5,9877E70313B7$F200010253B0E4C,743AEF96C664$F200011328B7EF1,840112838A40$F200011302B85C0,840112803F37$F200010079100AC,743AEF2F9A04$F200012189B4DF7,1834AF24E25B$F200012074B9EB3,840112DD4F7E$F200011050E65C3,9877E70C858E$F200012061B918B,840112C2C6FE$F200010275B291C,743AEF9CDD77$F200013236B0026,1834AF9A7D41$F200010349B4D4E,9877E705247C$F200013234B3345,1834AF9A2520$F200011118BCC83,9877E7B81D7A$F200011057E75F9,9877E74E0BEF$F200012213B3BDB,1834AF262EDB$F200010272B7101,743AEF9C64BE$F200010330BAA9B,743AEFDC8960$F200010275B2D1C,743AEF9CDF37$F200011208B52E8,840112070A5C$F200010284B5E70,743AEFAD7C35$F200012074B58E8,840112DD30F3$F200010287B0E3B,743AEFADB148$F200012321B31CF,1834AF62996D$F200012031B4EB1,840112BFE637$F200011105B6644,9877E77C69EE$F200012073BA4B3,840112DD04DF', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-14 14:56:36 Duration: 4s773ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 10m51s 72 1s39ms 1m13s 9s50ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 14 07 2 16s722ms 8s361ms 08 5 1m7s 13s590ms 09 5 21s648ms 4s329ms 10 6 2m5s 20s915ms 11 7 48s820ms 6s974ms 12 1 29s341ms 29s341ms 13 6 46s476ms 7s746ms 14 9 1m32s 10s276ms 15 8 31s504ms 3s938ms 16 11 1m42s 9s353ms 17 12 1m8s 5s690ms [ User: intelifix - Total duration: 10m51s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 10m51s - Times executed: 72 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 10:18:47 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 08:52:45 Duration: 58s811ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 14:27:46 Duration: 30s493ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10m23s 132 152ms 14s859ms 4s725ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 14 00 1 352ms 352ms 07 10 39s831ms 3s983ms 08 12 53s415ms 4s451ms 09 12 1m6s 5s556ms 10 11 1m8s 6s269ms 11 12 1m22s 6s874ms 12 12 1m5s 5s489ms 13 11 19s339ms 1s758ms 14 12 1m4s 5s403ms 15 12 1m2s 5s167ms 16 11 41s561ms 3s778ms 17 4 5s372ms 1s343ms 20 1 190ms 190ms 21 5 22s494ms 4s498ms 22 6 30s386ms 5s64ms [ User: intelifix - Total duration: 10m23s - Times executed: 132 ]
[ Application: psql - Total duration: 10m23s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:35:16 Duration: 14s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:55:15 Duration: 13s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:25:13 Duration: 11s376ms Database: rio User: intelifix Remote: [local] Application: psql
8 10m16s 211 150ms 2m27s 2s920ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 14 00 12 35s212ms 2s934ms 01 9 12s187ms 1s354ms 02 9 12s297ms 1s366ms 03 10 10s943ms 1s94ms 04 8 11s824ms 1s478ms 05 7 11s361ms 1s623ms 06 8 11s989ms 1s498ms 07 7 11s227ms 1s603ms 08 8 19s182ms 2s397ms 09 10 2m22s 14s243ms 10 10 14s309ms 1s430ms 11 10 2m41s 16s160ms 12 8 12s900ms 1s612ms 13 9 13s134ms 1s459ms 14 11 18s636ms 1s694ms 15 9 15s643ms 1s738ms 16 10 14s407ms 1s440ms 17 11 14s232ms 1s293ms 18 9 13s362ms 1s484ms 19 8 12s784ms 1s598ms 20 8 18s491ms 2s311ms 21 10 13s816ms 1s381ms 22 10 14s273ms 1s427ms [ User: intelifix - Total duration: 10m16s - Times executed: 211 ]
[ Application: psql - Total duration: 10m16s - Times executed: 211 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 11:47:36 Duration: 2m27s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 09:17:19 Duration: 2m11s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 00:05:21 Duration: 19s814ms Database: rio User: intelifix Remote: [local] Application: psql
9 9m29s 719 151ms 9s462ms 792ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 14 07 5 6s821ms 1s364ms 08 112 1m30s 811ms 09 106 1m30s 856ms 10 98 1m7s 690ms 11 93 1m18s 840ms 12 11 9s816ms 892ms 13 47 47s578ms 1s12ms 14 68 57s93ms 839ms 15 76 50s19ms 658ms 16 83 55s890ms 673ms 17 20 15s267ms 763ms [ User: intelifix - Total duration: 9m29s - Times executed: 719 ]
[ Application: [unknown] - Total duration: 9m29s - Times executed: 719 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "96938", "modelo" : "185", "itens" : "00CB7AE27A54,400FC1842384,08A7C0771254,E4BFFAF6422C,00CB7AE2B6CC,3C82C0CDB440,B85E71D34000,8C6A8DC1197C,00CB7AE25204,B85E71BFF4C8,08A7C0706874,ECA81F241C64", "usuario" : "414", "caixa" : "1122032", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-14 11:27:23 Duration: 9s462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286790", "modelo" : "320", "itens" : "241691364040,241602974965,241635793140,241699850324,241609077984,241635884260,241711490618,241731202833,241712100408,241658929012,241630098195,241599585173,241653326781,241674373740,241708593051,241679622345,241708495061,241691677987,241709314849,241672810210,241672965656,241663259614,241631415159,241631637481,241694630207,241631839195,241607434042,241713001517,241713000608,241668069915,241677482439,241728043849,241622578304,241603385970,241665772138,241682787793,241730467272,241637578184,241621222627,241731788401,241598561527,241675814150,241698491818,241620270122,241712249412,241714234353,241708442531,241592730004", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-14 09:11:34 Duration: 2s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287153", "modelo" : "320", "itens" : "241637362934,241731792442,241646140615,241675801119,241708475968,241655296064,241657109596,241634549517,241694116385,241639360627,241699990820,241653991325,241646516161,241691288095,241695242141,241691352850,241730886887,241593358909,241699350118,241657176977,241679458994,241727415471,241647687476,241731778602,241714639903,241706651728,241700918193,241709610917,241666255574,241731079409,241731108098,241731751933,241598866281,241716642950,241731363758,241630726068,241670051624,241694719912,241597789396,241608937286,241674191220,241637803033,241615212748,241651258296,241651074463,241712208802,241670088495,241651190917", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-14 14:43:23 Duration: 2s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m52s 42 10s354ms 1m9s 12s672ms create table temp0000291267 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 14 08 8 2m27s 18s413ms 09 6 1m6s 11s82ms 10 9 1m48s 12s89ms 11 3 32s779ms 10s926ms 12 2 21s729ms 10s864ms 14 8 1m29s 11s136ms 16 6 1m6s 11s3ms [ User: intelifix - Total duration: 8m52s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8m52s - Times executed: 42 ]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 08:38:33 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:13:34 Duration: 13s805ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 16:16:24 Duration: 12s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7m46s 34 10s326ms 1m15s 13s721ms create table temp0000291315 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 14 09 3 1m37s 32s522ms 10 7 1m44s 14s970ms 11 7 1m19s 11s325ms 14 2 22s660ms 11s330ms 16 1 10s696ms 10s696ms 17 14 2m31s 10s823ms [ User: intelifix - Total duration: 7m46s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 7m46s - Times executed: 34 ]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 09:58:41 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 10:22:07 Duration: 31s372ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 10:56:07 Duration: 16s498ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m45s 45 220ms 50s802ms 7s673ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 14 08 3 55s134ms 18s378ms 09 4 20s97ms 5s24ms 10 8 1m30s 11s327ms 11 6 32s831ms 5s471ms 12 1 13s809ms 13s809ms 14 10 1m13s 7s367ms 15 3 7s386ms 2s462ms 16 2 10s143ms 5s71ms 17 5 36s563ms 7s312ms 18 3 5s49ms 1s683ms [ User: intelifix - Total duration: 5m45s - Times executed: 45 ]
[ Application: psql - Total duration: 5m45s - Times executed: 45 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029823);
Date: 2026-09-14 08:43:21 Duration: 50s802ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029847);
Date: 2026-09-14 14:36:19 Duration: 34s841ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029831);
Date: 2026-09-14 10:31:21 Duration: 30s299ms Database: rio User: intelifix Remote: [local] Application: psql
13 5m36s 31 10s358ms 13s592ms 10s870ms create table temp0000291339 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 14 14 31 5m36s 10s870ms [ User: intelifix - Total duration: 5m36s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m36s - Times executed: 31 ]
-
CREATE TABLE temp0000291339 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:35:35 Duration: 13s592ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291339 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:49:55 Duration: 11s353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291339 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:42:04 Duration: 11s213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m33s 41 150ms 1m19s 6s679ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 14 08 5 17s743ms 3s548ms 09 2 732ms 366ms 10 10 2m40s 16s96ms 11 6 42s82ms 7s13ms 12 1 281ms 281ms 14 5 9s741ms 1s948ms 15 2 5s632ms 2s816ms 16 3 6s562ms 2s187ms 17 7 30s131ms 4s304ms [ User: intelifix - Total duration: 4m33s - Times executed: 41 ]
[ Application: psql - Total duration: 4m33s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029833);
Date: 2026-09-14 10:37:55 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029832);
Date: 2026-09-14 10:32:42 Duration: 43s249ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029836);
Date: 2026-09-14 10:56:10 Duration: 19s249ms Database: rio User: intelifix Remote: [local] Application: psql
15 2m46s 15 10s208ms 13s616ms 11s117ms create table temp0000291375 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 14 17 15 2m46s 11s117ms [ User: intelifix - Total duration: 2m46s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 15 ]
-
CREATE TABLE temp0000291375 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 17:14:32 Duration: 13s616ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291375 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 17:21:17 Duration: 11s749ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291375 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 17:30:17 Duration: 11s636ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m27s 23 2s808ms 33s105ms 6s432ms create table temp0000291267 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 14 08 2 6s193ms 3s96ms 09 4 41s777ms 10s444ms 10 7 44s851ms 6s407ms 11 2 12s449ms 6s224ms 12 2 13s946ms 6s973ms 14 2 10s822ms 5s411ms 16 4 17s899ms 4s474ms [ User: intelifix - Total duration: 2m27s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 23 ]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"09-09-2026", "ate" :"14-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-14 09:27:20 Duration: 33s105ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"09-09-2026", "ate" :"14-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-14 10:31:45 Duration: 24s984ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"09-09-2026", "ate" :"14-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-14 12:29:44 Duration: 10s349ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m18s 4 4s731ms 1m6s 34s583ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 14 20 2 1m7s 33s574ms 23 2 1m11s 35s592ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-14 23:17:03 Duration: 1m6s 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-14 20:08:32 Duration: 1m2s 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-14 20:10:32 Duration: 4s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2m18s 37 705ms 10s426ms 3s736ms 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 14 08 2 11s336ms 5s668ms 09 2 8s428ms 4s214ms 10 2 16s139ms 8s69ms 11 3 12s336ms 4s112ms 12 3 3s867ms 1s289ms 13 3 17s137ms 5s712ms 14 3 18s437ms 6s145ms 15 2 13s4ms 6s502ms 16 3 11s834ms 3s944ms 17 2 15s5ms 7s502ms 18 1 762ms 762ms 19 3 2s498ms 832ms 20 2 2s543ms 1s271ms 21 3 2s456ms 818ms 22 3 2s452ms 817ms [ User: intelifix - Total duration: 2m18s - Times executed: 37 ]
[ Application: psql - Total duration: 2m18s - Times executed: 37 ]
-
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-14 13:40:11 Duration: 10s426ms 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-14 10:20:09 Duration: 8s783ms 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-14 15:00:10 Duration: 8s649ms Database: rio User: intelifix Remote: [local] Application: psql
19 1m52s 4 358ms 59s196ms 28s171ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 14 20 2 53s130ms 26s565ms 23 2 59s555ms 29s777ms [ User: intelifix - Total duration: 1m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-14 23:13:59 Duration: 59s196ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-14 20:05:41 Duration: 52s765ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-14 20:09:56 Duration: 365ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 1m47s 6 3s82ms 41s210ms 17s954ms 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 #20
Day Hour Count Duration Avg duration Sep 14 20 3 52s346ms 17s448ms 23 3 55s381ms 18s460ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-14 23:14:42 Duration: 41s210ms 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-14 20:06:21 Duration: 38s924ms 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-14 23:34:53 Duration: 10s944ms 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,412 20m45s 151ms 6s215ms 881ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 14 08 64 1m6s 1s37ms 09 187 2m38s 849ms 10 176 2m51s 975ms 11 157 2m7s 809ms 12 40 33s164ms 829ms 13 113 1m58s 1s52ms 14 186 2m50s 916ms 15 244 3m28s 853ms 16 174 2m26s 844ms 17 71 43s78ms 606ms [ User: intelifix - Total duration: 20m45s - Times executed: 1412 ]
[ Application: [unknown] - Total duration: 20m45s - Times executed: 1412 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (57472, 413, '270911021146105320,229837205357,229812026278,229741749699,229669496767,229816139104,229666637992,229784241839,229932257989,229726496382,229745738293,229665137778,229809018802,229880053748,229879573645,229812022945,229740524463,229815899103,229809113637,229865826680,229807835768,229684444848,229747738690,229812600611,229879298488,229742919499,229754055368,229925137081,229745748698,229810970609,216945002124,229660025170', '246642230214,246628608591,246526645173,246515086985,246630531025,246467798486,246587602222,226027627896,246523647697,246558723747,246469755973,226324956072,246652477576,246652541725,246628614552,246535446267,246629037376,246627571836,246653670309,246619735571,246513553435,246549720916,246628526081,246652542028,246552200507,246557772027,246504258397,246558723545,246642261328,246498147071,246487349800', 0141, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-09-14 08:33:09 Duration: 6s215ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286313, 304, '920331065512,209A7DB67CB1,ACD75BB5DCCA,6CBAB8F1D381,3C585D79D394,8CFDDE7A6892,20B82BF9C53E,D0CF0EFDE310,ACD75BB6D4B0,D833B7541F78,186A81D56D8D,B0BBE54D23DE,482952461ED6,4C195DCCEE41,943C9678A050,44D4546A585B,ACD75BB5AE16,38A6592515B3,209A7DBC23A0,209A7DBB1937,F081751CB52D,64FD965E5A83,5CFA25AD3892,D0CF0EFCD2DB,CC5830E36324,ACD75BB8277A,8CFDDE87819B,B0FC88E98DBA,6CBAB8EA8195,841EA39211F5,C03C04870331,8CC5B4EDDCF3,CC5830E1F9C4,B0FC88EABBF5,841EA38D7F8B,E4C0E297DF66,44D45494B210,5447CC494C04,841EA3753C6E,44D454AC0319,48295245AD39', '',0155,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-14 16:25:10 Duration: 5s225ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286312, 304, 'F200011196B964E,840112050C89$F200010336E21D9,9877E70065FD$F200011334B23A6,840112846A6A$F200011314B1341,84011280A0C0$F200012311B7322,1834AF617F4B$F200011251B43F6,8401123767F0$F200010284B61A0,743AEFAD7D9A$F200011333B1C35,84011284505B$F200010290B9DE7,743AEFAEFD5F$F200012311B7352,1834AF617F60$F200013234B1399,1834AF9A1743$F200011119B4B80,9877E7B83FEE$F200010287BBEFE,743AEFADFE9C$F200010349B11F5,9877E70313B7$F200010253B0E4C,743AEF96C664$F200011328B7EF1,840112838A40$F200011302B85C0,840112803F37$F200010079100AC,743AEF2F9A04$F200012189B4DF7,1834AF24E25B$F200012074B9EB3,840112DD4F7E$F200011050E65C3,9877E70C858E$F200012061B918B,840112C2C6FE$F200010275B291C,743AEF9CDD77$F200013236B0026,1834AF9A7D41$F200010349B4D4E,9877E705247C$F200013234B3345,1834AF9A2520$F200011118BCC83,9877E7B81D7A$F200011057E75F9,9877E74E0BEF$F200012213B3BDB,1834AF262EDB$F200010272B7101,743AEF9C64BE$F200010330BAA9B,743AEFDC8960$F200010275B2D1C,743AEF9CDF37$F200011208B52E8,840112070A5C$F200010284B5E70,743AEFAD7C35$F200012074B58E8,840112DD30F3$F200010287B0E3B,743AEFADB148$F200012321B31CF,1834AF62996D$F200012031B4EB1,840112BFE637$F200011105B6644,9877E77C69EE$F200012073BA4B3,840112DD04DF', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-14 14:56:36 Duration: 4s773ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 719 9m29s 151ms 9s462ms 792ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 14 07 5 6s821ms 1s364ms 08 112 1m30s 811ms 09 106 1m30s 856ms 10 98 1m7s 690ms 11 93 1m18s 840ms 12 11 9s816ms 892ms 13 47 47s578ms 1s12ms 14 68 57s93ms 839ms 15 76 50s19ms 658ms 16 83 55s890ms 673ms 17 20 15s267ms 763ms [ User: intelifix - Total duration: 9m29s - Times executed: 719 ]
[ Application: [unknown] - Total duration: 9m29s - Times executed: 719 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "96938", "modelo" : "185", "itens" : "00CB7AE27A54,400FC1842384,08A7C0771254,E4BFFAF6422C,00CB7AE2B6CC,3C82C0CDB440,B85E71D34000,8C6A8DC1197C,00CB7AE25204,B85E71BFF4C8,08A7C0706874,ECA81F241C64", "usuario" : "414", "caixa" : "1122032", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-14 11:27:23 Duration: 9s462ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286790", "modelo" : "320", "itens" : "241691364040,241602974965,241635793140,241699850324,241609077984,241635884260,241711490618,241731202833,241712100408,241658929012,241630098195,241599585173,241653326781,241674373740,241708593051,241679622345,241708495061,241691677987,241709314849,241672810210,241672965656,241663259614,241631415159,241631637481,241694630207,241631839195,241607434042,241713001517,241713000608,241668069915,241677482439,241728043849,241622578304,241603385970,241665772138,241682787793,241730467272,241637578184,241621222627,241731788401,241598561527,241675814150,241698491818,241620270122,241712249412,241714234353,241708442531,241592730004", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-14 09:11:34 Duration: 2s869ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "287153", "modelo" : "320", "itens" : "241637362934,241731792442,241646140615,241675801119,241708475968,241655296064,241657109596,241634549517,241694116385,241639360627,241699990820,241653991325,241646516161,241691288095,241695242141,241691352850,241730886887,241593358909,241699350118,241657176977,241679458994,241727415471,241647687476,241731778602,241714639903,241706651728,241700918193,241709610917,241666255574,241731079409,241731108098,241731751933,241598866281,241716642950,241731363758,241630726068,241670051624,241694719912,241597789396,241608937286,241674191220,241637803033,241615212748,241651258296,241651074463,241712208802,241670088495,241651190917", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-14 14:43:23 Duration: 2s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 211 10m16s 150ms 2m27s 2s920ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 14 00 12 35s212ms 2s934ms 01 9 12s187ms 1s354ms 02 9 12s297ms 1s366ms 03 10 10s943ms 1s94ms 04 8 11s824ms 1s478ms 05 7 11s361ms 1s623ms 06 8 11s989ms 1s498ms 07 7 11s227ms 1s603ms 08 8 19s182ms 2s397ms 09 10 2m22s 14s243ms 10 10 14s309ms 1s430ms 11 10 2m41s 16s160ms 12 8 12s900ms 1s612ms 13 9 13s134ms 1s459ms 14 11 18s636ms 1s694ms 15 9 15s643ms 1s738ms 16 10 14s407ms 1s440ms 17 11 14s232ms 1s293ms 18 9 13s362ms 1s484ms 19 8 12s784ms 1s598ms 20 8 18s491ms 2s311ms 21 10 13s816ms 1s381ms 22 10 14s273ms 1s427ms [ User: intelifix - Total duration: 10m16s - Times executed: 211 ]
[ Application: psql - Total duration: 10m16s - Times executed: 211 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 11:47:36 Duration: 2m27s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 09:17:19 Duration: 2m11s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 00:05:21 Duration: 19s814ms Database: rio User: intelifix Remote: [local] Application: psql
4 198 52m31s 152ms 7m3s 15s914ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 14 07 8 2s797ms 349ms 08 12 8m17s 41s454ms 09 21 7m1s 20s89ms 10 20 6m20s 19s44ms 11 21 6m59s 19s955ms 12 2 27s626ms 13s813ms 13 17 1m57s 6s938ms 14 32 12m16s 23s23ms 15 24 1m29s 3s713ms 16 12 29s65ms 2s422ms 17 22 6m45s 18s409ms 18 7 23s430ms 3s347ms [ User: intelifix - Total duration: 52m31s - Times executed: 198 ]
[ Application: [unknown] - Total duration: 52m31s - Times executed: 198 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 08:50:07 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029835, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 10:44:31 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 11:47:36 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 143 1m23s 159ms 2s533ms 581ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 14 13 72 42s956ms 596ms 14 11 3s955ms 359ms 15 15 10s12ms 667ms 16 45 26s251ms 583ms [ User: intelifix - Total duration: 1m23s - Times executed: 143 ]
[ Application: [unknown] - Total duration: 1m23s - Times executed: 143 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57391","seriais":"215779105151","usuario":"416","observacao":""}');
Date: 2026-09-14 13:38:13 Duration: 2s533ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57785","seriais":"229775481736,229821993334,229715640823,229641700509,216930695273,229731455362,229729100408,229714127071,229793371731,229715874459,229800037588,229691956782,229698340010,229642651825,229696187879,229833182440,229731960923,229711722034,229731238595,216931427880,229640106368,229800736276,229703736686,229712351119,229646977274,229692709011,229638390018,229638170120,229693687175,229826549413,229829883240,229793506973,229643436177,229833657491","usuario":"416","observacao":""}');
Date: 2026-09-14 16:14:59 Duration: 1s384ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"57785","seriais":"229837205357,229812026278,229741749699,229669496767,229816139104,229666637992,229784241839,229932257989,229726496382,229745738293,229665137778,229809018802,229880053748,229879573645,229812022945,229740524463,229815899103,229809113637,229865826680,229807835768,229684444848,229747738690,229812600611,229879298488,229742919499,229754055368,229925137081,229745748698,229810970609,216945002124,229660025170","usuario":"416","observacao":""}');
Date: 2026-09-14 15:35:08 Duration: 1s226ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 132 10m23s 152ms 14s859ms 4s725ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 14 00 1 352ms 352ms 07 10 39s831ms 3s983ms 08 12 53s415ms 4s451ms 09 12 1m6s 5s556ms 10 11 1m8s 6s269ms 11 12 1m22s 6s874ms 12 12 1m5s 5s489ms 13 11 19s339ms 1s758ms 14 12 1m4s 5s403ms 15 12 1m2s 5s167ms 16 11 41s561ms 3s778ms 17 4 5s372ms 1s343ms 20 1 190ms 190ms 21 5 22s494ms 4s498ms 22 6 30s386ms 5s64ms [ User: intelifix - Total duration: 10m23s - Times executed: 132 ]
[ Application: psql - Total duration: 10m23s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:35:16 Duration: 14s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:55:15 Duration: 13s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:25:13 Duration: 11s376ms Database: rio User: intelifix Remote: [local] Application: psql
7 108 31s320ms 246ms 1s622ms 290ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 14 08 8 2s132ms 266ms 09 2 548ms 274ms 10 12 4s900ms 408ms 11 17 4s659ms 274ms 12 3 801ms 267ms 13 5 1s481ms 296ms 14 22 6s160ms 280ms 15 8 2s103ms 262ms 16 6 1s630ms 271ms 17 18 5s106ms 283ms 18 7 1s796ms 256ms [ User: intelifix - Total duration: 31s320ms - Times executed: 108 ]
[ Application: [unknown] - Total duration: 31s320ms - Times executed: 108 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-09-14 10:21:14 Duration: 1s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-14 13:40:24 Duration: 318ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-14 14:00:55 Duration: 318ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 93 29s589ms 293ms 428ms 318ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 14 06 1 295ms 295ms 07 5 1s515ms 303ms 08 10 3s111ms 311ms 09 10 3s114ms 311ms 10 12 4s45ms 337ms 11 9 2s872ms 319ms 12 4 1s330ms 332ms 13 11 3s450ms 313ms 14 9 2s886ms 320ms 15 7 2s230ms 318ms 16 7 2s243ms 320ms 17 5 1s577ms 315ms 18 1 310ms 310ms 19 1 300ms 300ms 22 1 305ms 305ms [ User: lenon - Total duration: 29s589ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 29s589ms - Times executed: 93 ]
-
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-14 10:36:51 Duration: 428ms 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-14 16:41:55 Duration: 410ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-14 10:15:08 Duration: 389ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 87 27s257ms 152ms 947ms 313ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 14 07 7 3s313ms 473ms 08 9 2s397ms 266ms 09 17 4s167ms 245ms 10 22 8s100ms 368ms 11 8 2s566ms 320ms 12 1 244ms 244ms 13 1 152ms 152ms 14 4 755ms 188ms 15 5 1s862ms 372ms 16 13 3s697ms 284ms [ User: intelifix - Total duration: 27s257ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 27s257ms - Times executed: 87 ]
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '229994376072,229945457695,229993322850,230002477794,229936946887,229930415262,229959163747,230012616584,229997154357,229928342939,229993234659,229993160410', NULL, NULL, 0287, 00);
Date: 2026-09-14 07:38:15 Duration: 947ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229849579618,229819988895,229820957587,229819968388,229803995270,229817514255,229820113050,229849719609,229804276565,229725892530', NULL, NULL, 0145, 00);
Date: 2026-09-14 10:06:28 Duration: 750ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (404, 5, '63', 2, '229819693637,229771539813,229790770714,229864637080,229805119914,229796540817,229858932136', NULL, NULL, 0145, 00);
Date: 2026-09-14 10:35:29 Duration: 617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 83 31s668ms 207ms 538ms 381ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 14 07 2 700ms 350ms 08 9 3s295ms 366ms 09 9 3s137ms 348ms 10 12 4s751ms 395ms 11 9 3s267ms 363ms 12 3 1s192ms 397ms 13 11 4s338ms 394ms 14 9 3s700ms 411ms 15 7 2s611ms 373ms 16 6 2s390ms 398ms 17 5 1s908ms 381ms 18 1 374ms 374ms [ User: intelifix - Total duration: 31s668ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 31s668ms - Times executed: 83 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-09-14 13:01:25 Duration: 538ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-09-14 16:25:11 Duration: 488ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-09-14 16:41:55 Duration: 484ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 83 18s467ms 150ms 796ms 222ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 14 00 1 183ms 183ms 07 4 760ms 190ms 08 8 1s539ms 192ms 09 10 1s905ms 190ms 10 3 789ms 263ms 11 11 2s68ms 188ms 12 8 1s969ms 246ms 13 4 1s197ms 299ms 14 11 2s892ms 262ms 15 7 1s384ms 197ms 16 11 2s302ms 209ms 17 4 980ms 245ms 22 1 496ms 496ms [ User: intelifix - Total duration: 18s467ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 18s467ms - Times executed: 83 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('E44E12B0D111');
Date: 2026-09-14 14:45:04 Duration: 796ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('3CF9F0ABFFAC');
Date: 2026-09-14 22:25:26 Duration: 496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('840112BFEA2E');
Date: 2026-09-14 13:28:50 Duration: 464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 72 10m51s 1s39ms 1m13s 9s50ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 14 07 2 16s722ms 8s361ms 08 5 1m7s 13s590ms 09 5 21s648ms 4s329ms 10 6 2m5s 20s915ms 11 7 48s820ms 6s974ms 12 1 29s341ms 29s341ms 13 6 46s476ms 7s746ms 14 9 1m32s 10s276ms 15 8 31s504ms 3s938ms 16 11 1m42s 9s353ms 17 12 1m8s 5s690ms [ User: intelifix - Total duration: 10m51s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 10m51s - Times executed: 72 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 10:18:47 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 08:52:45 Duration: 58s811ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 14:27:46 Duration: 30s493ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 69 1m7s 152ms 3s693ms 982ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 14 07 12 12s443ms 1s36ms 08 2 3s573ms 1s786ms 09 3 9s184ms 3s61ms 10 11 11s556ms 1s50ms 11 4 3s141ms 785ms 13 7 9s153ms 1s307ms 14 14 9s152ms 653ms 15 10 7s952ms 795ms 16 6 1s643ms 273ms [ User: intelifix - Total duration: 1m7s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 1m7s - Times executed: 69 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136562) LIMIT 1;
Date: 2026-09-14 09:52:39 Duration: 3s693ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136727) LIMIT 1;
Date: 2026-09-14 09:39:13 Duration: 3s684ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0286616) LIMIT 1;
Date: 2026-09-14 07:11:20 Duration: 3s591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 53 1m18s 393ms 18s790ms 1s474ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 14 08 4 7s427ms 1s856ms 09 4 7s618ms 1s904ms 10 4 7s514ms 1s878ms 11 3 2s136ms 712ms 12 4 2s736ms 684ms 13 3 2s425ms 808ms 14 3 1s991ms 663ms 15 4 9s606ms 2s401ms 16 3 2s267ms 755ms 17 3 20s697ms 6s899ms 18 5 3s751ms 750ms 19 3 2s299ms 766ms 20 4 3s235ms 808ms 21 3 2s292ms 764ms 22 3 2s136ms 712ms [ User: intelifix - Total duration: 1m18s - Times executed: 53 ]
[ Application: psql - Total duration: 1m18s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-14 17:40:20 Duration: 18s790ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-14 15:20:08 Duration: 7s569ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-14 08:00:06 Duration: 5s245ms Database: rio User: intelifix Remote: [local] Application: psql
15 52 28s206ms 156ms 4s423ms 542ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 14 07 1 237ms 237ms 09 5 1s470ms 294ms 10 6 4s304ms 717ms 11 5 5s307ms 1s61ms 12 11 7s554ms 686ms 13 2 382ms 191ms 14 13 6s124ms 471ms 15 5 1s696ms 339ms 16 2 397ms 198ms 17 2 730ms 365ms [ User: intelifix - Total duration: 28s206ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 28s206ms - Times executed: 52 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-09-14", "data-ate" : "2026-09-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-09-14 11:38:29 Duration: 4s423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "328", "data-de" : "2026-09-14", "data-ate" : "2026-09-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 397 }');
Date: 2026-09-14 10:42:18 Duration: 1s514ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-09-14", "data-ate" : "2026-09-14", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-09-14 12:31:26 Duration: 1s390ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 50 21s933ms 152ms 1s909ms 438ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 14 08 6 2s758ms 459ms 10 13 5s221ms 401ms 11 12 5s894ms 491ms 13 2 387ms 193ms 14 3 2s604ms 868ms 15 4 1s890ms 472ms 16 10 3s176ms 317ms [ User: intelifix - Total duration: 21s933ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 21s933ms - Times executed: 50 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '647B1EEDF678,20B82B250FAF,CC5830FE3CBA,203543584124,203543187D67,20B82B257EB3,B01FF41B2F81,20354353F83F,20354320B6AE,DC92726FACBB,9C2472338986,2035431E03C9,D8CF6162735E,A42249937442,B01FF41A9E17,5447CCCC650C,8C9A8F5A7C7F', '77;1', 'DEFAULT', 09, 0302, '','', '', 00);
Date: 2026-09-14 14:27:06 Duration: 1s909ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '3CF9F0AB3EF8,D83139968402,14CA56CD1909,14CA56D7280B,843C9920C087,6C11BA67048B,D89A0DAFC939,D89A0DA95F55,5872C994C829,C4EBFF88A9E2,843C9936A847,D831399B46FE,3CF9F0A68652,48D682397186,F4E84F889DF6,48D68238355A,C4EBFF896EBC,C4EBFF8A9210', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-14 10:28:55 Duration: 1s86ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (430, 5, 2, 28, '84011281ED94,9877E7BB76BB,9877E70BF8C3,743AEFDC3487,9877E70958A0,743AEFC5A948,9877E7486D99,84011280475D,1834AF24E91C,9877E74BCB02,9877E701906B,1834AF615CF3,8401125FE9F0,9877E70978DD,9877E77BD995,743AEF5C1991,743AEF5DC19D,840112959590,84011238AB86,9877E77DCC78,743AEF9B4A64,84011295AB9A,9877E7480DBB,840112836DD7,9877E7098D19,1834AF2872E6,8401120703B0,840112946EFD,84011294B3A6,8401127F7B14,743AEFABF92F,743AEFDC6DDE,743AEFAC1330,743AEF75FC5E,8401127FEE1D,1834AF9BCB81,9877E74AE694,9877E7BC47CD,9877E747D3D8,840112824D48', '','DEFAULT',00,0153,'', '','', 00);
Date: 2026-09-14 08:29:09 Duration: 918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 48 1h56m33s 1s378ms 10m14s 2m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 14 07 3 11m4s 3m41s 08 3 5m11s 1m43s 09 3 9m50s 3m16s 10 3 9m40s 3m13s 11 3 8m53s 2m57s 12 3 8m52s 2m57s 13 3 5m40s 1m53s 14 3 8m53s 2m57s 15 3 6m11s 2m3s 16 3 5m32s 1m50s 17 3 7m59s 2m39s 18 3 5m30s 1m50s 19 3 5m12s 1m44s 20 3 5m36s 1m52s 21 3 6m57s 2m19s 22 3 5m26s 1m48s [ User: intelifix - Total duration: 1h56m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 07:15:16 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 10:13:57 Duration: 8m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 09:13:53 Duration: 8m51s Database: rio User: intelifix Remote: [local] Application: psql
18 48 1h17m51s 212ms 4m26s 1m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 14 07 3 5m59s 1m59s 08 3 3m46s 1m15s 09 3 5m54s 1m58s 10 3 6m14s 2m4s 11 3 5m50s 1m56s 12 3 5m57s 1m59s 13 3 4m7s 1m22s 14 3 5m46s 1m55s 15 3 4m8s 1m22s 16 3 4m6s 1m22s 17 3 5m6s 1m42s 18 3 3m57s 1m19s 19 3 3m55s 1m18s 20 3 4m45s 1m35s 21 3 4m7s 1m22s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h17m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h17m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 10:20:47 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 12:19:40 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 09:20:30 Duration: 4m10s Database: brasilia User: intelifix Remote: [local] Application: psql
19 47 21s815ms 151ms 1s691ms 464ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 14 07 2 866ms 433ms 08 2 658ms 329ms 09 4 2s799ms 699ms 10 8 3s463ms 432ms 11 6 2s169ms 361ms 13 9 4s894ms 543ms 14 6 1s544ms 257ms 15 3 1s492ms 497ms 16 3 1s179ms 393ms 17 4 2s746ms 686ms [ User: intelifix - Total duration: 21s815ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 21s815ms - Times executed: 47 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "286923", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "", "data-saida" : "2026-09-14", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-14 13:23:32 Duration: 1s691ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "286719", "oficina" : "6", "cliente" : "5", "usuario" : "417", "nf" : "", "data-saida" : "2026-09-14", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-14 09:30:16 Duration: 1s185ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "286718", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "", "data-saida" : "2026-09-14", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-09-14 10:19:31 Duration: 1s132ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 47 12s842ms 153ms 1s367ms 273ms select * from rs_etiqueta (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 14 07 8 2s746ms 343ms 08 3 486ms 162ms 09 8 1s636ms 204ms 10 3 1s9ms 336ms 11 2 443ms 221ms 12 3 650ms 216ms 13 3 584ms 194ms 14 7 3s272ms 467ms 15 5 941ms 188ms 16 4 668ms 167ms 17 1 402ms 402ms [ User: etiquetas - Total duration: 12s842ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 12s842ms - Times executed: 47 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-14 14:20:04 Duration: 1s367ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('922151038559');
Date: 2026-09-14 07:03:01 Duration: 1s260ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
-
SELECT * FROM RS_ETIQUETA ('A8705D740247');
Date: 2026-09-14 14:31:49 Duration: 855ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m56s 11m27s 7m5s 3 21m16s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 14 05 3 21m16s 7m5s [ User: intelifix - Total duration: 21m16s - Times executed: 3 ]
[ Application: psql - Total duration: 21m16s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-14 05:11:29 Duration: 11m27s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-14 05:18:21 Duration: 6m52s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-14 05:21:18 Duration: 2m56s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s378ms 10m14s 2m25s 48 1h56m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 14 07 3 11m4s 3m41s 08 3 5m11s 1m43s 09 3 9m50s 3m16s 10 3 9m40s 3m13s 11 3 8m53s 2m57s 12 3 8m52s 2m57s 13 3 5m40s 1m53s 14 3 8m53s 2m57s 15 3 6m11s 2m3s 16 3 5m32s 1m50s 17 3 7m59s 2m39s 18 3 5m30s 1m50s 19 3 5m12s 1m44s 20 3 5m36s 1m52s 21 3 6m57s 2m19s 22 3 5m26s 1m48s [ User: intelifix - Total duration: 1h56m33s - Times executed: 48 ]
[ Application: psql - Total duration: 1h56m33s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 07:15:16 Duration: 10m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 10:13:57 Duration: 8m55s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-14 09:13:53 Duration: 8m51s Database: rio User: intelifix Remote: [local] Application: psql
3 212ms 4m26s 1m37s 48 1h17m51s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 14 07 3 5m59s 1m59s 08 3 3m46s 1m15s 09 3 5m54s 1m58s 10 3 6m14s 2m4s 11 3 5m50s 1m56s 12 3 5m57s 1m59s 13 3 4m7s 1m22s 14 3 5m46s 1m55s 15 3 4m8s 1m22s 16 3 4m6s 1m22s 17 3 5m6s 1m42s 18 3 3m57s 1m19s 19 3 3m55s 1m18s 20 3 4m45s 1m35s 21 3 4m7s 1m22s 22 3 4m7s 1m22s [ User: intelifix - Total duration: 1h17m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h17m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 10:20:47 Duration: 4m26s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 12:19:40 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-14 09:20:30 Duration: 4m10s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s731ms 1m6s 34s583ms 4 2m18s 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 14 20 2 1m7s 33s574ms 23 2 1m11s 35s592ms [ User: intelifix - Total duration: 2m18s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m18s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-14 23:17:03 Duration: 1m6s 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-14 20:08:32 Duration: 1m2s 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-14 20:10:32 Duration: 4s878ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 358ms 59s196ms 28s171ms 4 1m52s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 14 20 2 53s130ms 26s565ms 23 2 59s555ms 29s777ms [ User: intelifix - Total duration: 1m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m52s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-14 23:13:59 Duration: 59s196ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-14 20:05:41 Duration: 52s765ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-14 20:09:56 Duration: 365ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 3s82ms 41s210ms 17s954ms 6 1m47s 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 #6
Day Hour Count Duration Avg duration Sep 14 20 3 52s346ms 17s448ms 23 3 55s381ms 18s460ms [ User: intelifix - Total duration: 1m47s - Times executed: 6 ]
[ Application: pg_dump - Total duration: 1m47s - 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-14 23:14:42 Duration: 41s210ms 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-14 20:06:21 Duration: 38s924ms 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-14 23:34:53 Duration: 10s944ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 152ms 7m3s 15s914ms 198 52m31s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 14 07 8 2s797ms 349ms 08 12 8m17s 41s454ms 09 21 7m1s 20s89ms 10 20 6m20s 19s44ms 11 21 6m59s 19s955ms 12 2 27s626ms 13s813ms 13 17 1m57s 6s938ms 14 32 12m16s 23s23ms 15 24 1m29s 3s713ms 16 12 29s65ms 2s422ms 17 22 6m45s 18s409ms 18 7 23s430ms 3s347ms [ User: intelifix - Total duration: 52m31s - Times executed: 198 ]
[ Application: [unknown] - Total duration: 52m31s - Times executed: 198 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029823, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 08:50:07 Duration: 7m3s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029835, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 10:44:31 Duration: 5m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029841, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-14 11:47:36 Duration: 5m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s326ms 1m15s 13s721ms 34 7m46s create table temp0000291315 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 14 09 3 1m37s 32s522ms 10 7 1m44s 14s970ms 11 7 1m19s 11s325ms 14 2 22s660ms 11s330ms 16 1 10s696ms 10s696ms 17 14 2m31s 10s823ms [ User: intelifix - Total duration: 7m46s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 7m46s - Times executed: 34 ]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 09:58:41 Duration: 1m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 10:22:07 Duration: 31s372ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291315 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 10:56:07 Duration: 16s498ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s354ms 1m9s 12s672ms 42 8m52s create table temp0000291267 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 14 08 8 2m27s 18s413ms 09 6 1m6s 11s82ms 10 9 1m48s 12s89ms 11 3 32s779ms 10s926ms 12 2 21s729ms 10s864ms 14 8 1m29s 11s136ms 16 6 1m6s 11s3ms [ User: intelifix - Total duration: 8m52s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8m52s - Times executed: 42 ]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 08:38:33 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:13:34 Duration: 13s805ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 16:16:24 Duration: 12s697ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s208ms 13s616ms 11s117ms 15 2m46s create table temp0000291375 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 14 17 15 2m46s 11s117ms [ User: intelifix - Total duration: 2m46s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m46s - Times executed: 15 ]
-
CREATE TABLE temp0000291375 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 17:14:32 Duration: 13s616ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291375 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 17:21:17 Duration: 11s749ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291375 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 17:30:17 Duration: 11s636ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s358ms 13s592ms 10s870ms 31 5m36s create table temp0000291339 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 14 14 31 5m36s 10s870ms [ User: intelifix - Total duration: 5m36s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m36s - Times executed: 31 ]
-
CREATE TABLE temp0000291339 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:35:35 Duration: 13s592ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291339 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:49:55 Duration: 11s353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291339 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-14 14:42:04 Duration: 11s213ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s39ms 1m13s 9s50ms 72 10m51s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 14 07 2 16s722ms 8s361ms 08 5 1m7s 13s590ms 09 5 21s648ms 4s329ms 10 6 2m5s 20s915ms 11 7 48s820ms 6s974ms 12 1 29s341ms 29s341ms 13 6 46s476ms 7s746ms 14 9 1m32s 10s276ms 15 8 31s504ms 3s938ms 16 11 1m42s 9s353ms 17 12 1m8s 5s690ms [ User: intelifix - Total duration: 10m51s - Times executed: 72 ]
[ Application: [unknown] - Total duration: 10m51s - Times executed: 72 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 10:18:47 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 08:52:45 Duration: 58s811ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-14', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-14 14:27:46 Duration: 30s493ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 220ms 50s802ms 7s673ms 45 5m45s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 14 08 3 55s134ms 18s378ms 09 4 20s97ms 5s24ms 10 8 1m30s 11s327ms 11 6 32s831ms 5s471ms 12 1 13s809ms 13s809ms 14 10 1m13s 7s367ms 15 3 7s386ms 2s462ms 16 2 10s143ms 5s71ms 17 5 36s563ms 7s312ms 18 3 5s49ms 1s683ms [ User: intelifix - Total duration: 5m45s - Times executed: 45 ]
[ Application: psql - Total duration: 5m45s - Times executed: 45 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029823);
Date: 2026-09-14 08:43:21 Duration: 50s802ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029847);
Date: 2026-09-14 14:36:19 Duration: 34s841ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029831);
Date: 2026-09-14 10:31:21 Duration: 30s299ms Database: rio User: intelifix Remote: [local] Application: psql
14 150ms 1m19s 6s679ms 41 4m33s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 14 08 5 17s743ms 3s548ms 09 2 732ms 366ms 10 10 2m40s 16s96ms 11 6 42s82ms 7s13ms 12 1 281ms 281ms 14 5 9s741ms 1s948ms 15 2 5s632ms 2s816ms 16 3 6s562ms 2s187ms 17 7 30s131ms 4s304ms [ User: intelifix - Total duration: 4m33s - Times executed: 41 ]
[ Application: psql - Total duration: 4m33s - Times executed: 41 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029833);
Date: 2026-09-14 10:37:55 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029832);
Date: 2026-09-14 10:32:42 Duration: 43s249ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029836);
Date: 2026-09-14 10:56:10 Duration: 19s249ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s808ms 33s105ms 6s432ms 23 2m27s create table temp0000291267 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 14 08 2 6s193ms 3s96ms 09 4 41s777ms 10s444ms 10 7 44s851ms 6s407ms 11 2 12s449ms 6s224ms 12 2 13s946ms 6s973ms 14 2 10s822ms 5s411ms 16 4 17s899ms 4s474ms [ User: intelifix - Total duration: 2m27s - Times executed: 23 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 23 ]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"09-09-2026", "ate" :"14-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-14 09:27:20 Duration: 33s105ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"09-09-2026", "ate" :"14-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-14 10:31:45 Duration: 24s984ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291267 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"09-09-2026", "ate" :"14-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-14 12:29:44 Duration: 10s349ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 152ms 14s859ms 4s725ms 132 10m23s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 14 00 1 352ms 352ms 07 10 39s831ms 3s983ms 08 12 53s415ms 4s451ms 09 12 1m6s 5s556ms 10 11 1m8s 6s269ms 11 12 1m22s 6s874ms 12 12 1m5s 5s489ms 13 11 19s339ms 1s758ms 14 12 1m4s 5s403ms 15 12 1m2s 5s167ms 16 11 41s561ms 3s778ms 17 4 5s372ms 1s343ms 20 1 190ms 190ms 21 5 22s494ms 4s498ms 22 6 30s386ms 5s64ms [ User: intelifix - Total duration: 10m23s - Times executed: 132 ]
[ Application: psql - Total duration: 10m23s - Times executed: 132 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:35:16 Duration: 14s859ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:55:15 Duration: 13s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-14 11:25:13 Duration: 11s376ms Database: rio User: intelifix Remote: [local] Application: psql
17 705ms 10s426ms 3s736ms 37 2m18s 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 #17
Day Hour Count Duration Avg duration Sep 14 08 2 11s336ms 5s668ms 09 2 8s428ms 4s214ms 10 2 16s139ms 8s69ms 11 3 12s336ms 4s112ms 12 3 3s867ms 1s289ms 13 3 17s137ms 5s712ms 14 3 18s437ms 6s145ms 15 2 13s4ms 6s502ms 16 3 11s834ms 3s944ms 17 2 15s5ms 7s502ms 18 1 762ms 762ms 19 3 2s498ms 832ms 20 2 2s543ms 1s271ms 21 3 2s456ms 818ms 22 3 2s452ms 817ms [ User: intelifix - Total duration: 2m18s - Times executed: 37 ]
[ Application: psql - Total duration: 2m18s - Times executed: 37 ]
-
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-14 13:40:11 Duration: 10s426ms 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-14 10:20:09 Duration: 8s783ms 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-14 15:00:10 Duration: 8s649ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 2m27s 2s920ms 211 10m16s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 14 00 12 35s212ms 2s934ms 01 9 12s187ms 1s354ms 02 9 12s297ms 1s366ms 03 10 10s943ms 1s94ms 04 8 11s824ms 1s478ms 05 7 11s361ms 1s623ms 06 8 11s989ms 1s498ms 07 7 11s227ms 1s603ms 08 8 19s182ms 2s397ms 09 10 2m22s 14s243ms 10 10 14s309ms 1s430ms 11 10 2m41s 16s160ms 12 8 12s900ms 1s612ms 13 9 13s134ms 1s459ms 14 11 18s636ms 1s694ms 15 9 15s643ms 1s738ms 16 10 14s407ms 1s440ms 17 11 14s232ms 1s293ms 18 9 13s362ms 1s484ms 19 8 12s784ms 1s598ms 20 8 18s491ms 2s311ms 21 10 13s816ms 1s381ms 22 10 14s273ms 1s427ms [ User: intelifix - Total duration: 10m16s - Times executed: 211 ]
[ Application: psql - Total duration: 10m16s - Times executed: 211 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 11:47:36 Duration: 2m27s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 09:17:19 Duration: 2m11s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-14 00:05:21 Duration: 19s814ms Database: rio User: intelifix Remote: [local] Application: psql
19 393ms 18s790ms 1s474ms 53 1m18s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 14 08 4 7s427ms 1s856ms 09 4 7s618ms 1s904ms 10 4 7s514ms 1s878ms 11 3 2s136ms 712ms 12 4 2s736ms 684ms 13 3 2s425ms 808ms 14 3 1s991ms 663ms 15 4 9s606ms 2s401ms 16 3 2s267ms 755ms 17 3 20s697ms 6s899ms 18 5 3s751ms 750ms 19 3 2s299ms 766ms 20 4 3s235ms 808ms 21 3 2s292ms 764ms 22 3 2s136ms 712ms [ User: intelifix - Total duration: 1m18s - Times executed: 53 ]
[ Application: psql - Total duration: 1m18s - Times executed: 53 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-14 17:40:20 Duration: 18s790ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-14 15:20:08 Duration: 7s569ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-14 08:00:06 Duration: 5s245ms Database: rio User: intelifix Remote: [local] Application: psql
20 152ms 3s693ms 982ms 69 1m7s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 14 07 12 12s443ms 1s36ms 08 2 3s573ms 1s786ms 09 3 9s184ms 3s61ms 10 11 11s556ms 1s50ms 11 4 3s141ms 785ms 13 7 9s153ms 1s307ms 14 14 9s152ms 653ms 15 10 7s952ms 795ms 16 6 1s643ms 273ms [ User: intelifix - Total duration: 1m7s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 1m7s - Times executed: 69 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136562) LIMIT 1;
Date: 2026-09-14 09:52:39 Duration: 3s693ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136727) LIMIT 1;
Date: 2026-09-14 09:39:13 Duration: 3s684ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0286616) LIMIT 1;
Date: 2026-09-14 07:11:20 Duration: 3s591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 240ms 1 240ms 240ms 240ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 14 08 1 240ms 240ms [ User: etiquetas - Total duration: 208ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 208ms - Times executed: 1 ]
-
select * from rs_caixa_qr ();
Date: 2026-09-14 08:17:58 Duration: 240ms Database: postgres User: contagem 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 14 09 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 28s818ms - Times executed: 3 ]
[ Application: psql - Total duration: 28s455ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 363ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 21,525 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 30 FATAL entries
- 6130 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 6,095 Max number of times the same event was reported
- 6,170 Total events found
Rank Times reported Error 1 6,095 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 14 00 165 01 166 02 167 03 166 04 168 05 168 06 169 07 297 08 426 09 453 10 449 11 531 12 279 13 316 14 442 15 467 16 369 17 201 18 120 19 118 20 120 21 118 22 120 23 100 - ERROR: prepared statement "_PLAN0000000029CAB250" does not exist
- ERROR: prepared statement "_PLAN0000000029D8D090" does not exist
- ERROR: prepared statement "_PLAN00000000569C1990" does not exist
Statement: DEALLOCATE "_PLAN0000000029CAB250"
Date: 2026-09-14 00:00:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029D8D090"
Date: 2026-09-14 00:00:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000569C1990"
Date: 2026-09-14 00:00:41 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 18 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 14 00 1 02 1 03 6 04 2 06 1 09 1 11 1 13 1 17 1 21 1 23 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-14 00:02:23 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-14 02:33:47 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-14 03:58:22 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 15 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 14 09 4 11 4 13 2 14 5 - ERROR: column "d83139992b82" does not exist at character 27
- ERROR: column "d83139992b82" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(D83139992B82)
Date: 2026-09-14 09:21:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(D83139992B82)
Date: 2026-09-14 09:21:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-09-14 09:49:20 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
4 10 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 14 10 2 13 5 14 2 17 1 - ERROR: syntax error at or near "]" at character 33
- ERROR: syntax error at or near "]" at character 33
- ERROR: syntax error at or near "]" at character 34
Statement: select * from rs_caixa_qr(137313])
Date: 2026-09-14 10:00:18 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(137313])
Date: 2026-09-14 10:00:18 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(398712 ])
Date: 2026-09-14 13:05:08 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 14 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-14 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-14 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-14 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 14 09 2 11 3 - LOG: process 1721722 still waiting for ShareLock on transaction 6031150 after 1000.078 ms
- LOG: process 1721722 still waiting for ShareLock on transaction 6031150 after 20446.721 ms
- LOG: process 1836404 still waiting for ShareLock on transaction 6044970 after 1000.159 ms
Detail: Process holding the lock: 1696546. Wait queue: 1721722.
Context: while updating tuple (79702,33) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-14 09:15:11 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1696546. Wait queue: 1721722.
Context: while updating tuple (79702,33) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-14 09:15:31 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1865134. Wait queue: 1836404.
Context: while updating tuple (79784,17) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-09-14 11:45:12 Database: rio Application: psql User: intelifix Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 14 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-14 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-14 05:32:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-14 05:32:02 Database: contagem Application: psql User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 14 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-14 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-14 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-14 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 14 22 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-14 22:03:02 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3
Date: 2026-09-14 22:03:02 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
Date: 2026-09-14 22:03:02 Database: rio Application: pgAdmin 4 - CONN:4051712 User: lenon Remote: 172.20.0.3
10 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 14 09 2 - ERROR: unterminated quoted string at or near "''' )" at character 42
- ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 00, ''' )
Date: 2026-09-14 09:15:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 );
Date: 2026-09-14 09:15:24 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 14 15 2 - ERROR: trailing junk after numeric literal at or near "84011206D0AA398775" at character 27
- ERROR: trailing junk after numeric literal at or near "84011206D0AA398775" at character 27
Statement: select * from rs_caixa_qr(84011206D0AA398775)
Date: 2026-09-14 15:02:59 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(84011206D0AA398775)
Date: 2026-09-14 15:02:59 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
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 14 15 1 - LOG: process 1977407 still waiting for AccessExclusiveLock on relation 4983423 of database 358220 after 1000.140 ms
Detail: Process holding the lock: 2004674. Wait queue: 1977407.
Statement: DROP TABLE IF EXISTS temp0000291369;Date: 2026-09-14 15:14:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 14 15 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000291369"
Date: 2026-09-14 15:14:43
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 14 03 1 - LOG: database system was shut down at 2026-09-14 03:05:02 -03
Date: 2026-09-14 03:05:03
15 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 14 10 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(57473,413,'73003885850075907357,229793844762$73905285850065610682,229695425370$73910285850067214301,229709143039$73017085850082105866,229829551536$73901985850064410198,229645092041$73833085850062207641,216930206785$73907385850066303506,229700291132$73902585850064700959,229646468101$73833085850062201959,216929342728$73833085850062206253,216929990626','246601137594,246608572428,246540414463,246632617692,226354163244,246444509716,246521633539,246522001937,246452644651,246452172024,,,,,,,,,,,,,,,,,,,,',0137,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0229793844762);Date: 2026-09-14 10:31:26 Database: contagem Application: [unknown] User: intelifix Remote: [local]