pgBadger-
Global information
- Generated on Thu Sep 10 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 36,393 log entries in 11s
- Log start from 2026-09-10 00:02:02 to 2026-09-10 23:49:26
-
Overview
Global Stats
- 402 Number of unique normalized queries
- 5,006 Number of queries
- 7h14m56s Total query duration
- 2026-09-10 00:02:08 First query
- 2026-09-10 23:43:18 Last query
- 6 queries/s at 2026-09-10 14:05:02 Query peak
- 7h14m56s Total query duration
- 150ms Prepare/parse total duration
- 0ms Bind total duration
- 7h14m55s Execute total duration
- 2,992 Number of events
- 17 Number of unique normalized events
- 2,879 Max number of times the same event was reported
- 0 Number of cancellation
- 347 Total number of automatic vacuums
- 903 Total number of automatic analyzes
- 20 Number temporary file
- 245.16 MiB Max size of temporary file
- 66.72 MiB Average size of temporary file
- 558 Total number of sessions
- 11 sessions at 2026-09-10 13:46:06 Session peak
- 12d15h1m12s Total duration of sessions
- 32m34s Average duration of sessions
- 8 Average queries per session
- 46s767ms Average queries duration per session
- 31m48s Average idle time per session
- 564 Total number of connections
- 4 connections/s at 2026-09-10 14:05:01 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-10 14:05:02 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-10 14:05:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-10 23:42:10 Date
Queries duration
Key values
- 7h14m56s 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 10 00 31 0ms 27s648ms 3s841ms 10s504ms 1m10s 1m10s 01 16 0ms 6s431ms 2s269ms 7s473ms 9s188ms 9s188ms 02 14 0ms 5s185ms 2s531ms 7s884ms 8s176ms 8s176ms 03 14 0ms 4s674ms 2s652ms 7s380ms 7s380ms 7s380ms 04 17 0ms 4s740ms 2s262ms 7s744ms 7s744ms 7s744ms 05 18 0ms 9m40s 1m8s 5m52s 9m40s 9m40s 06 19 0ms 7s317ms 2s566ms 9s165ms 23s123ms 23s123ms 07 176 0ms 7m34s 12s323ms 1m4s 5m19s 7m34s 08 422 0ms 5m56s 6s596ms 56s817ms 6m51s 9m58s 09 516 0ms 6m34s 5s229ms 1m7s 6m36s 7m1s 10 525 151ms 5m21s 2s728ms 32s462ms 1m1s 9m22s 11 496 0ms 5m24s 4s239ms 49s88ms 4m53s 5m28s 12 135 0ms 4m53s 6s740ms 11s404ms 3m28s 4m54s 13 342 0ms 4m51s 2s948ms 26s803ms 1m50s 5m5s 14 647 150ms 5m35s 3s289ms 55s20ms 5m23s 6m1s 15 465 150ms 5m24s 4s135ms 45s232ms 5m33s 6m12s 16 354 0ms 5m12s 2s979ms 26s750ms 36s809ms 5m50s 17 252 0ms 4m59s 3s935ms 31s808ms 50s816ms 6m20s 18 22 0ms 4m50s 26s367ms 2s541ms 41s964ms 4m50s 19 20 0ms 4m48s 27s624ms 2s450ms 41s306ms 4m48s 20 115 0ms 4m59s 9s661ms 1m2s 1m18s 6m41s 21 26 0ms 4m54s 21s989ms 4s312ms 43s472ms 4m54s 22 26 0ms 4m41s 22s309ms 5s619ms 41s612ms 4m41s 23 338 0ms 1m1s 5s744ms 1m7s 1m12s 1m24s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 10 00 10 0 1s389ms 1s351ms 1s779ms 10s504ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 8 0 1s470ms 0ms 2s598ms 9s165ms 07 113 0 16s892ms 5s209ms 1m4s 6m6s 08 276 0 6s740ms 7s980ms 31s142ms 5m59s 09 379 0 5s435ms 11s804ms 38s528ms 6m36s 10 422 0 2s860ms 7s616ms 23s703ms 4m59s 11 346 0 4s246ms 9s968ms 21s150ms 5m21s 12 83 0 7s104ms 1s776ms 3s804ms 3m28s 13 262 0 3s351ms 9s861ms 20s736ms 3m27s 14 525 0 3s279ms 13s695ms 42s420ms 5m39s 15 353 0 4s603ms 12s459ms 17s300ms 5m28s 16 259 0 3s539ms 12s605ms 21s182ms 3m41s 17 164 0 4s296ms 4s437ms 8s507ms 3m45s 18 8 0 1m7s 0ms 0ms 3m19s 19 6 0 1m28s 0ms 0ms 3m22s 20 16 80 11s288ms 10s250ms 1m 3m22s 21 8 0 1m7s 0ms 0ms 3m23s 22 6 0 1m30s 0ms 0ms 3m42s 23 18 320 5s744ms 1m4s 1m7s 1m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 10 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 2 0 377ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 2 0 0 180ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 1 0 0 150ms 0ms 0ms 0ms 17 0 0 2 0 161ms 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 10 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 1 1.00 0.00% 07 0 11 11.00 0.00% 08 0 13 13.00 0.00% 09 0 11 11.00 0.00% 10 0 10 10.00 0.00% 11 0 12 12.00 0.00% 12 0 4 4.00 0.00% 13 0 42 42.00 0.00% 14 0 12 12.00 0.00% 15 0 10 10.00 0.00% 16 0 7 7.00 0.00% 17 0 8 8.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 1 4 4.00 0.30% Day Hour Count Average / Second Sep 10 00 14 0.00/s 01 7 0.00/s 02 7 0.00/s 03 13 0.00/s 04 5 0.00/s 05 6 0.00/s 06 12 0.00/s 07 17 0.00/s 08 28 0.01/s 09 35 0.01/s 10 29 0.01/s 11 35 0.01/s 12 48 0.01/s 13 75 0.02/s 14 32 0.01/s 15 37 0.01/s 16 37 0.01/s 17 27 0.01/s 18 17 0.00/s 19 15 0.00/s 20 21 0.01/s 21 19 0.01/s 22 15 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Sep 10 00 4 49m14s 48m44s 01 13 1h1m9s 1h1m6s 02 7 1h26s 1h21s 03 14 27m19s 27m17s 04 6 1h1m 1h53s 05 5 1h 55m52s 06 6 55m49s 55m41s 07 12 59m42s 56m41s 08 23 46m 43m59s 09 36 35m44s 34m29s 10 33 37m43s 37m 11 33 34m7s 33m3s 12 54 23m40s 23m23s 13 60 9m10s 8m53s 14 33 34m53s 33m48s 15 40 42m4s 41m16s 16 38 29m51s 29m23s 17 33 32m50s 32m20s 18 23 35m5s 34m40s 19 14 30m15s 29m36s 20 17 22m33s 21m27s 21 21 28m34s 28m7s 22 16 29m11s 28m34s 23 17 22m48s 20m54s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-10 14:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 564 connections Total
Connections per user
Key values
- etiquetas Main User
- 564 connections Total
-
Sessions
Simultaneous sessions
Key values
- 11 sessions Session Peak
- 2026-09-10 13:46:06 Date
Histogram of session times
Key values
- 246 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 558 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 558 sessions Total
Sessions per host
Key values
- [local] Main Host
- 558 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 558 sessions Total
Application Count Total Duration Average Duration [unknown] 495 11d13h53m48s 33m41s pgAdmin 4 - CONN:1903860 4 48s606ms 12s151ms pgAdmin 4 - CONN:2332371 2 2h28m6s 1h14m3s pgAdmin 4 - CONN:3431230 1 1m33s 1m33s pgAdmin 4 - CONN:3959432 2 2m51s 1m25s pgAdmin 4 - CONN:4608203 1 55s444ms 55s444ms pgAdmin 4 - CONN:6647692 1 49s488ms 49s488ms pgAdmin 4 - CONN:6805253 2 11m49s 5m54s pgAdmin 4 - CONN:6891170 4 41s238ms 10s309ms pgAdmin 4 - CONN:8250977 2 26m3s 13m1s pgAdmin 4 - CONN:8316082 2 8m42s 4m21s pgAdmin 4 - CONN:8573629 2 4m27s 2m13s pgAdmin 4 - DB:brasilia 3 6m43s 2m14s pgAdmin 4 - DB:contagem 6 1h1m2s 10m10s pgAdmin 4 - DB:postgres 5 3h33m34s 42m42s pgAdmin 4 - DB:rio 3 2h29m48s 49m56s pg_dump 9 41m36s 4m37s postgres_fdw 1 34m58s 34m58s psql 13 13h12m51s 1h59s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 35,454 buffers Checkpoint Peak
- 2026-09-10 00:09:40 Date
- 270.056 seconds Highest write time
- 0.282 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-09-10 14:49:37 Date
Checkpoints distance
Key values
- 434.21 Mo Distance Peak
- 2026-09-10 14:49:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 10 00 53,667 754.548s 0.076s 754.718s 01 2,959 296.004s 0.022s 296.05s 02 2,506 250.818s 0.03s 250.989s 03 2,065 207.049s 0.089s 207.166s 04 3,127 313.082s 0.015s 313.182s 05 9,061 906.63s 0.173s 906.842s 06 6,195 377.737s 0.064s 377.809s 07 46,415 2,434.95s 0.178s 2,435.184s 08 44,877 2,915.148s 0.293s 2,915.635s 09 65,584 3,239.396s 0.284s 3,239.779s 10 57,703 3,239.254s 0.268s 3,239.727s 11 52,059 3,214.98s 0.625s 3,215.696s 12 22,981 2,471.932s 0.155s 2,472.206s 13 19,286 1,826.791s 0.259s 1,827.181s 14 81,492 3,239.039s 0.528s 3,239.675s 15 64,675 3,239.268s 0.349s 3,239.717s 16 58,880 3,085.286s 0.283s 3,085.638s 17 19,952 2,243.705s 0.24s 2,244.013s 18 2,991 299.335s 0.023s 299.439s 19 33 3.321s 0.004s 3.33s 20 1,723 219.325s 0.012s 219.346s 21 2,486 249.587s 0.085s 249.7s 22 2,542 254.613s 0.034s 254.67s 23 392 39.306s 0.013s 39.333s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 10 00 0 0 10 620 0.062s 0.006s 01 0 0 1 466 0.006s 0.006s 02 0 0 1 443 0.012s 0.006s 03 0 0 0 340 0.062s 0.006s 04 0 0 1 434 0.003s 0.006s 05 0 0 5 656 0.063s 0.009s 06 0 0 1 38 0.062s 0.004s 07 0 0 27 3,063 0.062s 0.012s 08 0 0 58 5,311 0.062s 0.011s 09 0 0 58 5,715 0.062s 0.012s 10 0 0 37 6,715 0.006s 0.012s 11 0 0 61 6,702 0.063s 0.012s 12 0 0 8 3,495 0.055s 0.012s 13 0 0 10 4,227 0.062s 0.012s 14 0 0 59 7,629 0.062s 0.012s 15 0 0 47 6,780 0.062s 0.012s 16 0 0 31 6,028 0.059s 0.012s 17 0 0 31 4,678 0.063s 0.012s 18 0 0 0 412 0.003s 0.006s 19 0 0 0 12 0.002s 0.002s 20 0 0 2 94 0.002s 0.003s 21 0 0 0 361 0.062s 0.009s 22 0 0 1 405 0.009s 0.007s 23 0 0 0 27 0.004s 0.005s Day Hour Count Avg time (sec) Sep 10 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 10 00 27,652.83 kB 72,141.83 kB 01 2,648.50 kB 42,522.83 kB 02 2,255.33 kB 23,722.50 kB 03 1,628.00 kB 4,117.43 kB 04 2,877.83 kB 3,191.50 kB 05 7,940.11 kB 16,063.78 kB 06 7,520.50 kB 12,975.00 kB 07 36,635.67 kB 58,266.00 kB 08 87,411.09 kB 107,562.73 kB 09 78,877.00 kB 130,994.83 kB 10 49,800.00 kB 111,177.92 kB 11 83,473.42 kB 107,427.75 kB 12 11,790.25 kB 88,694.33 kB 13 13,495.58 kB 39,546.92 kB 14 80,328.58 kB 115,500.75 kB 15 63,645.17 kB 136,508.75 kB 16 42,817.75 kB 113,044.25 kB 17 41,696.33 kB 96,945.42 kB 18 2,237.83 kB 47,293.33 kB 19 110.50 kB 30,887.00 kB 20 6,146.67 kB 25,344.33 kB 21 1,711.57 kB 15,811.29 kB 22 1,896.00 kB 8,574.29 kB 23 248.80 kB 5,018.40 kB -
Temporary Files
Size of temporary files
Key values
- 490.31 MiB Temp Files size Peak
- 2026-09-10 05:31:54 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-10 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.72 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.56 MiB 245.16 MiB 64.33 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-10 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-10 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 305.07 MiB 56.71 MiB 93.32 MiB 76.27 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-10 05:30:40 Duration: 38s481ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-10 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 245.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 245.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 93.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-10 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 93.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-10 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 61.72 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-10 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 56.71 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-10 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 40.49 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 40.43 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 40.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 40.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 40.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 40.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 40.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 36.63 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 36.58 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 36.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 36.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 36.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 36.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 36.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-10 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 13.10 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-10 15:47:54 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 13.10 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-10 15:47:54 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (117) Main table analyzed (database rio)
- 903 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 117 rio.public.temp0000291029 68 rio.pg_catalog.pg_class 63 rio.pg_catalog.pg_type 51 rio.public.temp0000291095 48 rio.public.usuarios 45 brasilia.pg_catalog.pg_attribute 36 rio.pg_catalog.pg_index 33 rio.public.temp0000291011 32 rio.pg_catalog.pg_depend 24 contagem.pg_catalog.pg_attribute 23 contagem.public.usuarios 18 contagem.public.temp0000227117 15 brasilia.pg_catalog.pg_class 15 contagem.public.temp0000227115 14 rio.public.temp0000291121 14 rio.public.temp0000290230 12 brasilia.pg_catalog.pg_type 12 contagem.pg_catalog.pg_class 11 brasilia.public.temp0000239900 11 contagem.public.temp0000227093 10 brasilia.public.temp0000239924 9 contagem.pg_catalog.pg_type 9 rio.public.temp0000291115 9 rio.public.temp0000291083 9 rio.public.temp0000291023 8 rio.public.temp0000291013 8 brasilia.public.usuarios 8 brasilia.pg_catalog.pg_index 7 rio.public.temp0000291035 7 rio.public.temp0000290226 7 rio.public.temp0000291101 7 rio.public.temp0000291089 6 contagem.pg_catalog.pg_index 5 rio.public.temp0000290787 5 brasilia.pg_catalog.pg_depend 5 rio.public.temp0000290232 5 brasilia.public.temp0000239926 5 rio.public.temp0000290883 4 rio.public.tmp_drill_0175 4 brasilia.public.temp0000239928 4 contagem.pg_catalog.pg_depend 4 brasilia.public.temp0000239864 4 rio.public.temp0000291075 3 rio.public.temp0000291009 3 rio.public.temp0000291099 3 brasilia.public.temp0000239922 3 brasilia.public.temp0000239858 3 brasilia.public.temp0000239910 3 rio.public.temp0000290026 3 contagem.public.temp0000227103 3 rio.public.temp0000291021 3 rio.public.temp0000290769 3 rio.public.tmp_drill_0302 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000291123 2 contagem.pg_catalog.pg_shdepend 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000239896 2 rio.public.temp0000291133 2 brasilia.public.temp0000239874 2 rio.public.temp0000291055 2 rio.public.temp0000291081 2 brasilia.public.temp0000239868 2 brasilia.public.temp0000239902 2 rio.public.temp0000291093 2 contagem.public.nf_entrada 2 brasilia.public.temp0000239918 2 brasilia.pg_catalog.pg_shdepend 2 brasilia.public.temp0000239952 2 rio.public.temp0000291107 2 rio.public.temp0000291041 2 rio.public.temp0000291097 2 rio.public.temp0000291057 1 brasilia.public.temp0000239888 1 brasilia.public.temp0000239862 1 rio.public.temp0000291017 1 brasilia.public.temp0000239886 1 rio.public.tmp_drill_0320 1 brasilia.public.temp0000239880 1 rio.public.temp0000291001 1 contagem.public.temp0000227113 1 rio.public.temp0000290893 1 rio.auditor.auditor_2026_09 1 rio.public.temp0000291135 1 brasilia.public.temp0000239894 1 brasilia.public.temp0000239920 1 brasilia.public.temp0000239892 1 brasilia.public.temp0000239950 1 contagem.public.temp0000227089 1 rio.public.temp0000291145 1 brasilia.auditor.auditor_2026_09 1 brasilia.public.temp0000239908 1 Total 903 Vacuums per table
Key values
- pg_catalog.pg_attribute (39) Main table vacuumed on database rio
- 347 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 39 39 0 0 0 0 0 21,092 5,924 8,724,159 391 10,496 rio.public.temp0000291029 30 0 0 0 0 0 0 23,935 137 1,432,726 0 0 rio.public.temp0000291095 19 0 0 0 0 0 0 6,314 206 612,252 0 0 rio.pg_catalog.pg_type 18 18 0 0 0 0 0 1,824 583 791,123 61 225 rio.pg_catalog.pg_class 18 18 0 0 0 0 0 3,659 1,329 2,124,024 84 313 contagem.public.usuarios 17 0 0 0 0 0 0 78 59 36,053 0 0 rio.public.temp0000291011 15 0 0 0 0 0 0 16,197 119 1,076,307 0 0 rio.public.temp0000291121 14 0 0 0 0 0 0 17,948 52 1,067,114 0 0 rio.pg_catalog.pg_index 11 11 0 0 0 0 0 598 195 206,559 28 56 rio.public.temp0000290230 10 0 0 0 0 0 0 409 47 31,197 0 0 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 9,880 3,202 12,214,894 1,969 8,994 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,998 1,004 1,568,517 62 678 rio.public.temp0000291083 9 0 0 0 0 0 0 682 51 48,450 0 0 brasilia.pg_catalog.pg_attribute 9 9 0 0 0 0 0 4,325 1,360 2,034,053 61 1,447 brasilia.public.temp0000239924 9 0 0 0 0 0 0 2,269 783 1,302,168 0 0 contagem.pg_catalog.pg_attribute 8 8 0 0 0 0 0 4,685 1,316 2,271,636 34 948 rio.public.temp0000291115 7 0 0 0 0 0 0 12,551 28 744,730 0 0 rio.public.usuarios 6 2 0 0 0 0 0 77 34 71,672 6 10 rio.public.tmp_drill_0175 6 4 0 0 0 0 0 1,568 786 1,172,548 1 74 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 757 325 477,601 19 67 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 754 143 232,562 12 42 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,935 560 2,713,496 176 501 brasilia.public.temp0000239928 4 0 0 0 0 0 0 1,009 265 449,694 0 0 contagem.pg_catalog.pg_type 3 3 0 0 0 0 0 360 83 138,969 5 12 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 2,216 9 357,840 0 0 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 545 187 308,064 28 64 brasilia.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 464 139 590,486 41 88 contagem.public.temp0000227103 3 0 0 0 0 0 0 343 126 206,606 0 0 brasilia.pg_catalog.pg_type 3 3 0 0 0 0 0 221 101 138,379 10 46 rio.public.temp0000290787 3 0 0 0 0 0 0 266 18 18,411 0 0 brasilia.public.temp0000239910 3 0 0 0 0 0 0 511 11 32,064 0 0 rio.public.temp0000290026 3 0 0 0 0 0 0 174 17 12,919 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,299 1,590 5,778,181 1,241 7,541 rio.public.temp0000291081 2 0 0 0 0 0 0 3,584 1,796 2,523,010 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,861 182 769,971 144 1,311 brasilia.public.temp0000239874 2 0 0 0 0 0 0 504 257 419,237 0 0 rio.public.temp0000291055 2 0 0 0 0 0 0 3,581 8 212,528 0 0 rio.public.temp0000290769 2 0 0 0 0 0 0 151 12 10,666 0 0 brasilia.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 327 106 156,778 25 39 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 640 151 350,343 3 24 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 107 19 31,706 1 2 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 107 44 32,241 4 9 rio.auditor.auditor_2026_09 2 0 0 0 0 0 0 155,945 69,251 89,058,487 42,995 817,076 brasilia.public.temp0000239952 2 0 0 0 0 0 0 504 257 418,650 0 0 brasilia.public.temp0000239896 2 0 0 0 0 0 0 504 8 30,942 0 0 rio.public.temp0000291075 2 0 0 0 0 0 0 1,796 7 107,105 0 0 rio.public.temp0000291145 1 0 0 0 0 0 0 68 6 4,885 0 0 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 383 151 172,240 6 84 rio.public.temp0000291099 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000239868 1 0 0 0 0 0 0 252 4 15,471 0 0 contagem.public.temp0000227113 1 0 0 0 0 0 0 114 6 7,696 0 0 brasilia.auditor.auditor_2026_09 1 0 0 0 0 0 0 16,052 9,381 12,406,078 3,345 64,736 brasilia.public.temp0000239886 1 0 0 0 0 0 0 252 253 403,769 0 0 brasilia.public.temp0000239888 1 0 0 0 0 0 0 252 4 15,471 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 156 5 26,430 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 10,464 9,678 11,179,800 20 136 brasilia.public.temp0000239920 1 0 0 0 0 0 0 252 4 15,471 0 0 brasilia.public.temp0000239950 1 0 0 0 0 0 0 253 4 15,571 0 0 Total 347 169 0 0 0 0 0 344,056 112,386 167,370,774 50,772 915,019 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (23.51) 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 2.83 rio.public.temp0000291029 0 0 0.76 rio.public.temp0000291095 0 0 0.25 rio.pg_catalog.pg_type 0 0 0.29 rio.pg_catalog.pg_class 0 0 0.69 contagem.public.usuarios 0 0 0 rio.public.temp0000291011 0 0 0.59 rio.public.temp0000291121 0 0 0.58 rio.pg_catalog.pg_index 0 0 0.13 rio.public.temp0000290230 0 0 0.01 rio.pg_catalog.pg_statistic 0 0 1.17 rio.pg_catalog.pg_depend 0 0 0.7 rio.public.temp0000291083 0 0 0.03 brasilia.pg_catalog.pg_attribute 0 0 1.15 brasilia.public.temp0000239924 0 0 0.03 contagem.pg_catalog.pg_attribute 0 0 0.81 rio.public.temp0000291115 0 0 0.3 rio.public.usuarios 0 0 0 rio.public.tmp_drill_0175 0 0 0.08 brasilia.pg_catalog.pg_class 0 0 0.6 contagem.pg_catalog.pg_class 0 0 0.54 rio.pg_toast.pg_toast_2619 0 0 0.25 brasilia.public.temp0000239928 0 0 0 contagem.pg_catalog.pg_type 0 0 0.25 rio.public.tmp_drill_0302 0 0 0.06 postgres.pg_catalog.pg_shdepend 0 0 0.52 brasilia.pg_toast.pg_toast_2619 0 0 0.02 contagem.public.temp0000227103 0 0 0.01 brasilia.pg_catalog.pg_type 0 0 0.19 rio.public.temp0000290787 0 0 0.01 brasilia.public.temp0000239910 0 0 0 rio.public.temp0000290026 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.33 rio.public.temp0000291081 0 0 0.1 contagem.pg_catalog.pg_statistic 0 0 0.17 brasilia.public.temp0000239874 0 0 0.01 rio.public.temp0000291055 0 0 0.09 rio.public.temp0000290769 0 0 0 brasilia.pg_catalog.pg_shdepend 0 0 0.14 contagem.pg_catalog.pg_depend 0 0 0.4 contagem.pg_catalog.pg_index 0 0 0.18 brasilia.pg_catalog.pg_index 0 0 0.15 rio.auditor.auditor_2026_09 0 0 23.51 brasilia.public.temp0000239952 0 0 0 brasilia.public.temp0000239896 0 0 0 rio.public.temp0000291075 0 0 0.08 rio.public.temp0000291145 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.2 rio.public.temp0000291099 0 0 0.04 brasilia.public.temp0000239868 0 0 0 contagem.public.temp0000227113 0 0 0 brasilia.auditor.auditor_2026_09 0 0 3.31 brasilia.public.temp0000239886 0 0 0 brasilia.public.temp0000239888 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.auditor.auditor_2026_09 0 0 1.25 brasilia.public.temp0000239920 0 0 0 brasilia.public.temp0000239950 0 0 0.01 Total 0 0 42.82 Tuples removed per table
Key values
- pg_catalog.pg_attribute (157329) Main table with removed tuples on database rio
- 339946 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 39 39 157,329 993,007 10,924 39 24,914 rio.public.tmp_drill_0302 3 3 33,195 33,995 0 0 853 contagem.pg_catalog.pg_attribute 8 8 32,593 197,786 0 219 4,439 brasilia.pg_catalog.pg_attribute 9 9 32,055 199,711 0 49 4,892 rio.public.tmp_drill_0175 6 4 22,846 115,107 45,692 0 1,743 rio.pg_catalog.pg_statistic 9 9 14,480 73,537 47 0 11,574 rio.pg_catalog.pg_depend 9 9 8,075 171,416 18 0 1,683 brasilia.pg_catalog.pg_statistic 3 3 5,757 23,784 0 0 3,216 rio.pg_catalog.pg_type 18 18 5,366 41,282 204 0 1,314 contagem.pg_catalog.pg_statistic 2 2 5,338 14,897 0 0 2,022 rio.auditor.auditor_2026_09 2 0 3,308 14,035,079 0 0 641,714 rio.pg_catalog.pg_class 18 18 3,138 63,252 552 0 2,245 rio.pg_catalog.pg_index 11 11 2,360 21,227 107 9 579 contagem.auditor.auditor_2026_09 1 0 2,180 1,243,690 0 0 58,400 postgres.pg_catalog.pg_shdepend 3 3 2,137 40,723 1 0 375 contagem.pg_catalog.pg_type 3 3 1,528 6,775 0 11 209 brasilia.pg_catalog.pg_shdepend 2 2 1,460 27,250 1 0 250 rio.pg_toast.pg_toast_2619 4 4 1,176 2,465 0 0 1,124 contagem.public.usuarios 17 0 1,082 408 0 0 34 brasilia.pg_catalog.pg_class 4 4 892 13,511 0 9 476 contagem.pg_catalog.pg_index 2 2 664 3,793 0 0 105 brasilia.auditor.auditor_2026_09 1 0 644 1,573,678 0 0 69,056 contagem.pg_catalog.pg_class 4 4 514 14,711 0 36 514 brasilia.pg_catalog.pg_depend 1 1 402 17,334 0 20 172 contagem.pg_catalog.pg_depend 2 2 365 38,209 0 0 347 rio.public.usuarios 6 2 345 3,732 678 0 114 brasilia.pg_toast.pg_toast_2619 3 3 285 407 0 0 204 brasilia.pg_catalog.pg_type 3 3 164 6,681 10 15 171 contagem.pg_toast.pg_toast_2619 1 1 145 117 0 0 62 brasilia.pg_catalog.pg_index 2 2 123 3,764 0 11 108 rio.public.temp0000291081 2 0 0 50,680 0 0 3,584 rio.public.temp0000291145 1 0 0 1,071 0 4 60 brasilia.public.temp0000239874 2 0 0 6,602 0 0 512 rio.public.temp0000291055 2 0 0 50,635 0 0 3,584 rio.public.temp0000290769 2 0 0 6,056 0 57 135 rio.public.temp0000291099 1 0 0 25,359 0 0 1,792 rio.public.temp0000291011 15 0 0 357,239 0 0 25,152 rio.public.temp0000291095 19 0 0 204,067 0 90 12,070 brasilia.public.temp0000239868 1 0 0 3,301 0 0 256 contagem.public.temp0000227113 1 0 0 1,368 0 22 106 rio.public.temp0000291115 7 0 0 177,557 0 0 12,544 contagem.public.temp0000227103 3 0 0 4,103 0 66 318 rio.public.temp0000291121 14 0 0 355,139 0 0 25,088 brasilia.public.temp0000239886 1 0 0 3,301 0 0 256 rio.public.temp0000290787 3 0 0 10,872 0 78 242 rio.public.temp0000290230 10 0 0 21,862 0 157 483 brasilia.public.temp0000239910 3 0 0 9,903 0 0 768 rio.public.temp0000291029 30 0 0 484,040 0 334 32,882 rio.public.temp0000291083 9 0 0 40,585 0 249 903 brasilia.public.temp0000239952 2 0 0 6,602 0 0 512 brasilia.public.temp0000239888 1 0 0 3,301 0 0 256 rio.public.temp0000290026 3 0 0 11,825 0 56 264 brasilia.public.temp0000239896 2 0 0 6,602 0 0 512 brasilia.public.temp0000239928 4 0 0 13,204 0 0 1,024 rio.public.temp0000291075 2 0 0 50,682 0 0 3,584 brasilia.public.temp0000239920 1 0 0 3,301 0 0 256 brasilia.public.temp0000239924 9 0 0 29,709 0 0 2,304 brasilia.public.temp0000239950 1 0 0 3,301 0 0 256 Total 347 169 339,946 20,923,595 58,234 1,531 962,612 Pages removed per table
Key values
- public.temp0000291029 (334) Main table with removed pages on database rio
- 1531 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000291029 30 0 0 334 rio.public.temp0000291083 9 0 0 249 contagem.pg_catalog.pg_attribute 8 8 32593 219 rio.public.temp0000290230 10 0 0 157 rio.public.temp0000291095 19 0 0 90 rio.public.temp0000290787 3 0 0 78 contagem.public.temp0000227103 3 0 0 66 rio.public.temp0000290769 2 0 0 57 rio.public.temp0000290026 3 0 0 56 brasilia.pg_catalog.pg_attribute 9 9 32055 49 rio.pg_catalog.pg_attribute 39 39 157329 39 contagem.pg_catalog.pg_class 4 4 514 36 contagem.public.temp0000227113 1 0 0 22 brasilia.pg_catalog.pg_depend 1 1 402 20 brasilia.pg_catalog.pg_type 3 3 164 15 contagem.pg_catalog.pg_type 3 3 1528 11 brasilia.pg_catalog.pg_index 2 2 123 11 brasilia.pg_catalog.pg_class 4 4 892 9 rio.pg_catalog.pg_index 11 11 2360 9 rio.public.temp0000291145 1 0 0 4 rio.pg_catalog.pg_statistic 9 9 14480 0 rio.public.temp0000291081 2 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5338 0 brasilia.public.temp0000239874 2 0 0 0 rio.public.temp0000291055 2 0 0 0 rio.pg_catalog.pg_type 18 18 5366 0 rio.public.temp0000291099 1 0 0 0 rio.public.temp0000291011 15 0 0 0 brasilia.pg_catalog.pg_shdepend 2 2 1460 0 contagem.pg_catalog.pg_depend 2 2 365 0 brasilia.public.temp0000239868 1 0 0 0 rio.public.tmp_drill_0302 3 3 33195 0 postgres.pg_catalog.pg_shdepend 3 3 2137 0 rio.public.temp0000291115 7 0 0 0 brasilia.auditor.auditor_2026_09 1 0 644 0 brasilia.pg_toast.pg_toast_2619 3 3 285 0 contagem.pg_catalog.pg_index 2 2 664 0 rio.public.temp0000291121 14 0 0 0 brasilia.public.temp0000239886 1 0 0 0 rio.public.usuarios 6 2 345 0 rio.auditor.auditor_2026_09 2 0 3308 0 brasilia.public.temp0000239910 3 0 0 0 contagem.public.usuarios 17 0 1082 0 rio.pg_catalog.pg_depend 9 9 8075 0 brasilia.public.temp0000239952 2 0 0 0 brasilia.public.temp0000239888 1 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 145 0 brasilia.public.temp0000239896 2 0 0 0 contagem.auditor.auditor_2026_09 1 0 2180 0 rio.pg_toast.pg_toast_2619 4 4 1176 0 brasilia.public.temp0000239928 4 0 0 0 rio.public.temp0000291075 2 0 0 0 brasilia.public.temp0000239920 1 0 0 0 brasilia.public.temp0000239924 9 0 0 0 rio.public.tmp_drill_0175 6 4 22846 0 brasilia.pg_catalog.pg_statistic 3 3 5757 0 rio.pg_catalog.pg_class 18 18 3138 0 brasilia.public.temp0000239950 1 0 0 0 Total 347 169 339,946 1,531 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 10 00 1 1 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 11 34 08 37 88 09 39 90 10 18 81 11 50 115 12 7 31 13 18 63 14 62 137 15 41 119 16 26 81 17 27 59 18 0 0 19 0 0 20 0 0 21 4 4 22 0 0 23 0 0 - 13.10 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 4m20s 40s527ms 2m9s 1m26s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:57:23 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 09:36:39 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:45:50 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s 1s 1s 1s drop table if exists temp0000291029;-
DROP TABLE IF EXISTS temp0000291029;
Date: 2026-09-10 08:43:37 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291029;
Date: 2026-09-10 08:37:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000291029;
Date: 2026-09-10 09:55:39 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m9s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-10 08:57:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m30s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-10 09:36:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 40s527ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-09-10 08:45:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 1s DROP TABLE IF EXISTS temp0000291029;[ Date: 2026-09-10 08:43:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,262 Total read queries
- 1,271 Total write queries
Queries by database
Key values
- rio Main database
- 3,212 Requests
- 5h32m27s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,231 1h32m35s copy to 140 10m45s ddl 137 1m41s others 179 8m35s select 775 1h11m32s contagem Total 562 9m52s copy to 114 1m20s ddl 61 46s239ms delete 4 1s78ms others 5 2m59s select 375 4m44s update 3 510ms postgres Total 1 191ms others 1 191ms rio Total 3,212 5h32m27s copy to 146 29m2s ddl 666 53m12s others 288 31m42s select 2,112 3h38m30s Queries by user
Key values
- intelifix Main user
- 4,834 Requests
User Request type Count Duration etiquetas Total 17 7s393ms select 17 7s393ms intelifix Total 4,834 7h9m47s copy to 400 41m8s ddl 859 51m43s others 472 43m18s select 3,103 4h53m37s lenon Total 155 5m1s ddl 5 3m56s delete 4 1s78ms others 1 191ms select 142 1m2s update 3 510ms Duration by user
Key values
- 7h9m47s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 17 7s393ms select 17 7s393ms intelifix Total 4,834 7h9m47s copy to 400 41m8s ddl 859 51m43s others 472 43m18s select 3,103 4h53m37s lenon Total 155 5m1s ddl 5 3m56s delete 4 1s78ms others 1 191ms select 142 1m2s update 3 510ms Queries by host
Key values
- [local] Main host
- 4,991 Requests
- 7h10m56s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,902 Requests
- 3h24m39s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 3,902 3h5m4s ddl 859 51m43s select 3,043 2h13m21s pgAdmin 4 - CONN:2332371 Total 1 3m51s ddl 1 3m51s pgAdmin 4 - CONN:6805253 Total 2 360ms update 2 360ms pgAdmin 4 - CONN:8250977 Total 3 473ms delete 2 323ms update 1 150ms pgAdmin 4 - CONN:8316082 Total 3 989ms delete 2 755ms select 1 234ms pgAdmin 4 - CONN:8573629 Total 5 5s766ms ddl 4 5s526ms select 1 239ms pgAdmin 4 - DB:postgres Total 1 191ms others 1 191ms pg_dump Total 417 41m12s copy to 400 41m8s select 17 4s66ms psql Total 672 3h24m39s others 472 43m18s select 200 2h41m21s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-10 12:44:01 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,441 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m40s analyze verbose;[ Date: 2026-09-10 05:09:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-10 07:12:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 6m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-10 09:11:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029681, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 07:25:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 5m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029707, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 08:57:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 5m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029696, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 08:45:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 5m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029719, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 09:12:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 5m48s analyze verbose;[ Date: 2026-09-10 05:15:30 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
9 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029685, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 08:14:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029762, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 14:33:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 5m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029744, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 11:38:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029770, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 15:07:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m22s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029774, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 15:47:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029734, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 10:14:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 5m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029723, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 09:48:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m18s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029684, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 07:53:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m18s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029739, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 11:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029722, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 09:36:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029682, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 07:39:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029765, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-10 14:46:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h36m56s 203 151ms 6m5s 28s652ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 10 07 11 17m12s 1m33s 08 28 18m17s 39s179ms 09 19 17m36s 55s625ms 10 14 5m37s 24s104ms 11 18 11m18s 37s675ms 12 4 1s671ms 417ms 13 20 2m37s 7s862ms 14 23 11m22s 29s667ms 15 24 11m34s 28s949ms 16 25 45s422ms 1s816ms 17 17 32s814ms 1s930ms [ User: intelifix - Total duration: 1h36m56s - Times executed: 203 ]
[ Application: [unknown] - Total duration: 1h36m56s - Times executed: 203 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029681, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 07:25:21 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029707, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 08:57:22 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029696, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 08:45:48 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h28m26s 48 1s364ms 7m34s 1m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 10 07 3 8m9s 2m43s 08 3 5m8s 1m42s 09 3 7m9s 2m23s 10 3 5m8s 1m42s 11 3 5m10s 1m43s 12 3 5m10s 1m43s 13 3 5m7s 1m42s 14 3 5m28s 1m49s 15 3 5m26s 1m48s 16 3 5m29s 1m49s 17 3 5m17s 1m45s 18 3 5m12s 1m44s 19 3 5m4s 1m41s 20 3 5m15s 1m45s 21 3 5m10s 1m43s 22 3 4m57s 1m39s [ User: intelifix - Total duration: 1h28m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h28m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 07:12:35 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 09:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 16:10:13 Duration: 5m12s Database: rio User: intelifix Remote: [local] Application: psql
3 1h5m55s 48 219ms 4m2s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 10 07 3 4m51s 1m37s 08 3 4m34s 1m31s 09 3 4m54s 1m38s 10 3 3m58s 1m19s 11 3 3m58s 1m19s 12 3 3m53s 1m17s 13 3 3m53s 1m17s 14 3 3m57s 1m19s 15 3 4m7s 1m22s 16 3 4m9s 1m23s 17 3 4m10s 1m23s 18 3 3m47s 1m15s 19 3 3m48s 1m16s 20 3 3m50s 1m16s 21 3 3m51s 1m17s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h5m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 08:14:38 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 09:17:04 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 07:17:54 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
4 18m12s 3 2m43s 9m40s 6m4s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 10 05 3 18m12s 6m4s [ User: intelifix - Total duration: 18m12s - Times executed: 3 ]
[ Application: psql - Total duration: 18m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-10 05:09:41 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-10 05:15:30 Duration: 5m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-10 05:18:13 Duration: 2m43s Database: contagem User: intelifix Remote: [local] Application: psql
5 15m3s 81 8s915ms 16s533ms 11s159ms create table temp0000291029 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 10 08 36 6m50s 11s400ms 09 17 3m6s 10s970ms 10 4 45s732ms 11s433ms 11 24 4m21s 10s885ms [ User: intelifix - Total duration: 15m3s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 15m3s - Times executed: 81 ]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 11:19:09 Duration: 16s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 10:14:26 Duration: 14s332ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 08:56:04 Duration: 12s801ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 13m44s 1,060 150ms 4s905ms 777ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 10 07 18 19s634ms 1s90ms 08 67 52s986ms 790ms 09 151 1m47s 712ms 10 176 2m7s 725ms 11 88 1m4s 737ms 12 34 23s504ms 691ms 13 37 30s736ms 830ms 14 145 1m58s 816ms 15 146 2m5s 857ms 16 131 1m52s 861ms 17 67 41s164ms 614ms [ User: intelifix - Total duration: 13m44s - Times executed: 1060 ]
[ Application: [unknown] - Total duration: 13m44s - Times executed: 1060 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285718, 504, 'F200011054B2402,9877E74CD9A1$F200012014BA3FE,840112980221$F200011326B93FA,84011282E224$F200011328B2F4B,840112836763$F200012015B9875,840112984795$F200011291B24B0,8401125FFB70$F200011246B0537,8401122B4264$F200012075B29B7,840112DD706A$F200011075B7598,9877E74A39D2$F200011086B3F62,9877E77B1FD6$F200011327B5F48,840112831AEF$F200010280BB52B,743AEFAC594C$F200011009E18CB,9877E707C715$F200011132B0924,9877E7B9D419$F200012004B2CB0,84011295B897$F200010048127F9,743AEF1420B5', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 07:41:24 Duration: 4s905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286240, 317, '835074911001212,241660458397,241730205373,241608838387,241660457084,241646707998,241597400314,241637384249,241732471633,241672742930,241603895369,241646635971,241596701121,241667799002,241619533147,241706981334,241667671818,241712113237,241664729599,241645955871', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 15:51:09 Duration: 4s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285744, 452, '71521085850016807886,216609044050,216836394970,216514813653,216551183252,216861139506,216799350323,216870366377,216505363752,216351573535,216867624359,216858134050H010987116,216634486364', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 10:48:20 Duration: 4s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 11m12s 204 150ms 2m13s 3s295ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 10 00 9 25s835ms 2s870ms 01 10 16s490ms 1s649ms 02 8 16s796ms 2s99ms 03 9 17s66ms 1s896ms 04 11 18s163ms 1s651ms 05 8 16s571ms 2s71ms 06 8 16s564ms 2s70ms 07 9 21s131ms 2s347ms 08 11 3m15s 17s802ms 09 8 1m49s 13s717ms 10 6 17s744ms 2s957ms 11 8 19s955ms 2s494ms 12 9 17s397ms 1s933ms 13 10 18s822ms 1s882ms 14 10 17s188ms 1s718ms 15 9 16s585ms 1s842ms 16 9 15s680ms 1s742ms 17 10 15s970ms 1s597ms 18 8 14s58ms 1s757ms 19 8 14s797ms 1s849ms 20 10 21s163ms 2s116ms 21 8 14s456ms 1s807ms 22 8 14s251ms 1s781ms [ User: intelifix - Total duration: 11m12s - Times executed: 204 ]
[ Application: psql - Total duration: 11m12s - Times executed: 204 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:57:23 Duration: 2m13s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 09:36:39 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:45:50 Duration: 45s234ms Database: rio User: intelifix Remote: [local] Application: psql
8 9m16s 75 1s136ms 25s957ms 7s424ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 10 07 2 10s43ms 5s21ms 08 4 21s406ms 5s351ms 09 2 35s125ms 17s562ms 10 9 1m31s 10s163ms 11 6 49s835ms 8s305ms 12 2 5s206ms 2s603ms 13 7 1m6s 9s490ms 14 9 1m14s 8s230ms 15 11 1m10s 6s385ms 16 17 1m56s 6s861ms 17 6 16s353ms 2s725ms [ User: intelifix - Total duration: 9m16s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 9m16s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 0320, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 09:38:43 Duration: 25s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 10:52:31 Duration: 25s532ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 10:12:33 Duration: 24s222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m47s 47 8s249ms 38s71ms 11s229ms create table temp0000291011 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 10 07 11 1m34s 8s593ms 08 9 1m41s 11s229ms 09 13 2m29s 11s477ms 10 3 59s708ms 19s902ms 11 11 2m3s 11s208ms [ User: intelifix - Total duration: 8m47s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m47s - Times executed: 47 ]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 10:08:59 Duration: 38s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 11:03:16 Duration: 17s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 09:06:55 Duration: 12s982ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m37s 160 191ms 27s648ms 2s858ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 10 00 6 48s726ms 8s121ms 01 6 19s821ms 3s303ms 02 6 18s641ms 3s106ms 03 5 20s68ms 4s13ms 04 6 20s304ms 3s384ms 05 5 10s820ms 2s164ms 07 9 30s96ms 3s344ms 08 12 39s968ms 3s330ms 09 12 33s279ms 2s773ms 10 12 29s294ms 2s441ms 11 12 42s486ms 3s540ms 12 12 33s669ms 2s805ms 13 8 9s249ms 1s156ms 14 12 27s210ms 2s267ms 15 12 29s844ms 2s487ms 16 10 17s301ms 1s730ms 17 4 1s610ms 402ms 20 1 388ms 388ms 21 4 9s436ms 2s359ms 22 6 15s208ms 2s534ms [ User: intelifix - Total duration: 7m37s - Times executed: 160 ]
[ Application: psql - Total duration: 7m37s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 00:05:28 Duration: 27s648ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 08:55:10 Duration: 8s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 07:55:09 Duration: 8s26ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m55s 732 150ms 7s520ms 485ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 10 07 27 10s526ms 389ms 08 80 40s744ms 509ms 09 126 1m8s 545ms 10 113 48s894ms 432ms 11 92 47s382ms 515ms 12 9 4s160ms 462ms 13 68 35s892ms 527ms 14 92 45s993ms 499ms 15 82 32s571ms 397ms 16 22 11s669ms 530ms 17 21 8s829ms 420ms [ User: intelifix - Total duration: 5m55s - Times executed: 732 ]
[ Application: [unknown] - Total duration: 5m55s - Times executed: 732 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "155", "itens" : "186A81D48559,5447CC4A89B9,E8D2FFA71954,841EA38E4A7D,D833B7C9F34E,506F0C3C56CC,186A81D65CF9", "usuario" : "414", "caixa" : "1227053", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-10 11:24:27 Duration: 7s520ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "151", "itens" : "C85D38AA0708,C85D38A8D205,C85D380E094B,D86C5A059DD3", "usuario" : "414", "caixa" : "1227739", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-10 09:27:35 Duration: 7s441ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286212", "modelo" : "463", "itens" : "241720711630,241724256464,241794541630,241784108186,241779495458,241748966878,241750496971,241706267492,241787254869,241754205156,241720961733,241720332850,241755895467,241721562330,241754577291,241751822949,241721680423,241722452428,241704953335,241721016586,241781519113,241721619608,241724270608,241781511537,241721372738,241748218286,241782627997,241782110316,241736714751,241754641417,241787513536,241722529809,241719458790,241720062038,241721764145,241721083843,241725623456,241719902931,241749060222,241782639918,241725004046,241781507495,241755559799,241721078589,241721666279,241748563046,241748525668,241723242539,241758600816,241736032429,241723075070,241781536465,241721352938,241720088404,241735381928,241758234966,241720706275,241754770925,241725640506,241750189310", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-10 14:19:11 Duration: 3s688ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m43s 32 10s152ms 12s554ms 10s729ms create table temp0000291095 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 10 13 3 33s666ms 11s222ms 14 7 1m14s 10s688ms 15 3 32s352ms 10s784ms 17 19 3m22s 10s657ms [ User: intelifix - Total duration: 5m43s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 5m43s - Times executed: 32 ]
-
CREATE TABLE temp0000291095 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 13:26:40 Duration: 12s554ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291095 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 14:40:41 Duration: 11s192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291095 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 17:15:09 Duration: 11s177ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m51s 1 3m51s 3m51s 3m51s drop table if exists x; create temp table x as select * from lote_itens aa where li_status = ? and exists ( select ? from lote_itens a inner join fluxos b on b.flu_id = a.flu_id and b.flu_status not in (...) where a.eq_id = aa.eq_id) and not exists ( select ? from nf_entrada_itens c where c.li_id = aa.li_id);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 10 12 1 3m51s 3m51s [ User: lenon - Total duration: 3m51s - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:2332371 - Total duration: 3m51s - Times executed: 1 ]
-
drop table IF EXISTS x; CREATE TEMP TABLE X AS SELECT * FROM LOTE_ITENS AA WHERE LI_STATUS = 0 AND EXISTS ( SELECT 1 FROM LOTE_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID AND B.FLU_STATUS NOT IN ('L', 'E') WHERE A.EQ_ID = AA.EQ_ID) AND NOT EXISTS ( SELECT 1 FROM NF_ENTRADA_ITENS C WHERE C.LI_ID = AA.LI_ID);
Date: 2026-09-10 12:48:32 Duration: 3m51s Database: rio User: lenon Remote: 172.20.0.3 Application: pgAdmin 4 - CONN:2332371
14 3m18s 55 163ms 27s640ms 3s614ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 10 07 5 34s705ms 6s941ms 08 12 34s849ms 2s904ms 09 8 32s511ms 4s63ms 10 1 5s191ms 5s191ms 11 10 23s390ms 2s339ms 13 1 4s600ms 4s600ms 14 5 26s423ms 5s284ms 15 6 27s842ms 4s640ms 16 2 5s327ms 2s663ms 17 5 3s930ms 786ms [ User: intelifix - Total duration: 3m18s - Times executed: 55 ]
[ Application: psql - Total duration: 3m18s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029681);
Date: 2026-09-10 07:19:15 Duration: 27s640ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029722);
Date: 2026-09-10 09:31:08 Duration: 14s50ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029686);
Date: 2026-09-10 08:12:28 Duration: 11s77ms Database: rio User: intelifix Remote: [local] Application: psql
15 3m6s 17 10s516ms 12s850ms 10s982ms create table temp0000291115 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 10 14 9 1m37s 10s800ms 15 8 1m29s 11s187ms [ User: intelifix - Total duration: 3m6s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 17 ]
-
CREATE TABLE temp0000291115 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 15:15:24 Duration: 12s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291115 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 15:00:39 Duration: 11s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291115 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 15:01:08 Duration: 11s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m5s 37 154ms 1m8s 5s6ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 10 07 4 1s185ms 296ms 08 6 1s480ms 246ms 09 5 14s510ms 2s902ms 10 1 539ms 539ms 11 8 6s180ms 772ms 13 1 160ms 160ms 14 5 1m4s 12s834ms 15 5 1m10s 14s80ms 16 2 26s597ms 13s298ms [ User: intelifix - Total duration: 3m5s - Times executed: 37 ]
[ Application: psql - Total duration: 3m5s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029775);
Date: 2026-09-10 15:59:15 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029763);
Date: 2026-09-10 14:38:30 Duration: 42s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029768);
Date: 2026-09-10 14:54:23 Duration: 20s992ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m59s 16 10s292ms 15s902ms 11s233ms create table temp0000291121 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 10 14 7 1m18s 11s250ms 15 4 42s11ms 10s502ms 16 5 58s975ms 11s795ms [ User: intelifix - Total duration: 2m59s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 2m59s - Times executed: 16 ]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 16:17:13 Duration: 15s902ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 14:55:13 Duration: 12s857ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 14:54:14 Duration: 11s741ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m12s 4 4s27ms 1m3s 33s123ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 10 20 2 1m7s 33s568ms 23 2 1m5s 32s679ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-10 20:08:33 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-10 23:16:31 Duration: 1m1s 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-10 23:33:35 Duration: 4s88ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
19 1m46s 47 1s959ms 5s832ms 2s267ms create table temp0000291029 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 10 08 23 48s807ms 2s122ms 09 9 19s403ms 2s155ms 10 2 4s634ms 2s317ms 11 13 33s737ms 2s595ms [ User: intelifix - Total duration: 1m46s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 1m46s - Times executed: 47 ]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 11:21:41 Duration: 5s832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 11:37:04 Duration: 2s926ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 10:15:40 Duration: 2s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 1m45s 4 328ms 52s466ms 26s345ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 10 20 2 52s586ms 26s293ms 23 2 52s795ms 26s397ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-10 23:13:39 Duration: 52s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-10 20:05:40 Duration: 52s246ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-10 20:09:54 Duration: 339ms 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,060 13m44s 150ms 4s905ms 777ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 10 07 18 19s634ms 1s90ms 08 67 52s986ms 790ms 09 151 1m47s 712ms 10 176 2m7s 725ms 11 88 1m4s 737ms 12 34 23s504ms 691ms 13 37 30s736ms 830ms 14 145 1m58s 816ms 15 146 2m5s 857ms 16 131 1m52s 861ms 17 67 41s164ms 614ms [ User: intelifix - Total duration: 13m44s - Times executed: 1060 ]
[ Application: [unknown] - Total duration: 13m44s - Times executed: 1060 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285718, 504, 'F200011054B2402,9877E74CD9A1$F200012014BA3FE,840112980221$F200011326B93FA,84011282E224$F200011328B2F4B,840112836763$F200012015B9875,840112984795$F200011291B24B0,8401125FFB70$F200011246B0537,8401122B4264$F200012075B29B7,840112DD706A$F200011075B7598,9877E74A39D2$F200011086B3F62,9877E77B1FD6$F200011327B5F48,840112831AEF$F200010280BB52B,743AEFAC594C$F200011009E18CB,9877E707C715$F200011132B0924,9877E7B9D419$F200012004B2CB0,84011295B897$F200010048127F9,743AEF1420B5', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 07:41:24 Duration: 4s905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286240, 317, '835074911001212,241660458397,241730205373,241608838387,241660457084,241646707998,241597400314,241637384249,241732471633,241672742930,241603895369,241646635971,241596701121,241667799002,241619533147,241706981334,241667671818,241712113237,241664729599,241645955871', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 15:51:09 Duration: 4s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285744, 452, '71521085850016807886,216609044050,216836394970,216514813653,216551183252,216861139506,216799350323,216870366377,216505363752,216351573535,216867624359,216858134050H010987116,216634486364', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 10:48:20 Duration: 4s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 732 5m55s 150ms 7s520ms 485ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 10 07 27 10s526ms 389ms 08 80 40s744ms 509ms 09 126 1m8s 545ms 10 113 48s894ms 432ms 11 92 47s382ms 515ms 12 9 4s160ms 462ms 13 68 35s892ms 527ms 14 92 45s993ms 499ms 15 82 32s571ms 397ms 16 22 11s669ms 530ms 17 21 8s829ms 420ms [ User: intelifix - Total duration: 5m55s - Times executed: 732 ]
[ Application: [unknown] - Total duration: 5m55s - Times executed: 732 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "155", "itens" : "186A81D48559,5447CC4A89B9,E8D2FFA71954,841EA38E4A7D,D833B7C9F34E,506F0C3C56CC,186A81D65CF9", "usuario" : "414", "caixa" : "1227053", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-10 11:24:27 Duration: 7s520ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "151", "itens" : "C85D38AA0708,C85D38A8D205,C85D380E094B,D86C5A059DD3", "usuario" : "414", "caixa" : "1227739", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-10 09:27:35 Duration: 7s441ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "286212", "modelo" : "463", "itens" : "241720711630,241724256464,241794541630,241784108186,241779495458,241748966878,241750496971,241706267492,241787254869,241754205156,241720961733,241720332850,241755895467,241721562330,241754577291,241751822949,241721680423,241722452428,241704953335,241721016586,241781519113,241721619608,241724270608,241781511537,241721372738,241748218286,241782627997,241782110316,241736714751,241754641417,241787513536,241722529809,241719458790,241720062038,241721764145,241721083843,241725623456,241719902931,241749060222,241782639918,241725004046,241781507495,241755559799,241721078589,241721666279,241748563046,241748525668,241723242539,241758600816,241736032429,241723075070,241781536465,241721352938,241720088404,241735381928,241758234966,241720706275,241754770925,241725640506,241750189310", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-10 14:19:11 Duration: 3s688ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 240 1m38s 150ms 1s977ms 410ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 10 10 49 18s690ms 381ms 11 42 12s796ms 304ms 14 149 1m7s 449ms [ User: intelifix - Total duration: 1m38s - Times executed: 240 ]
[ Application: [unknown] - Total duration: 1m38s - Times executed: 240 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"136735","seriais":"241783257890,241780604444,241724348392,241780580021,241737071330,241734617475,241751233643,241758325558,241737944052,241722307183,241719309506,241722988798,241758265979,241720332749,241789136668,241750409208,241705062336,241791434850,241791624566,241737058904,241782081727,241758053860,241749030623,241783283045,241788887777,241784631729,241791435355,241725453035,241725529406,241721360616,241755690521,241754199701,241705011523,241750330817,241750395671,241737862630,241784602837,241758203751,241724966264,241737927484","usuario":"399","observacao":""}');
Date: 2026-09-10 14:31:36 Duration: 1s977ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"136735","seriais":"241763998705,3C7625012B93,241759675454,241764603242,241759675050,241763527794,241814378502,241778097375,241745707379,241765633556,241762600219,241747366071,241740755774,241778235773,241764140313,241759701013,241759693840,241778019411,241762584661,241738818087,241763985471,241742671921,241764594453,241763982946,241767940123,241746420009,3C762502203P,241764570512,241762559810,241763308806,241759692325,241745691924","usuario":"399","observacao":""}');
Date: 2026-09-10 14:44:28 Duration: 1s567ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"136735","seriais":"241734581839,241758300607,241783277690,241720463749,241791583653,241719299303,241725595271,241749058201,241786628791,241783272640,241789403541,241721789602,241750429311,241758301617,241753869512,241737069208,241749058908,241783264053,241750389711,241791372342,241784655064,241725462733,241734645660,241720392934,241755669508,241791004247,241791403961,241720278400,241758297373","usuario":"399","observacao":""}');
Date: 2026-09-10 14:46:05 Duration: 1s436ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 204 11m12s 150ms 2m13s 3s295ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 10 00 9 25s835ms 2s870ms 01 10 16s490ms 1s649ms 02 8 16s796ms 2s99ms 03 9 17s66ms 1s896ms 04 11 18s163ms 1s651ms 05 8 16s571ms 2s71ms 06 8 16s564ms 2s70ms 07 9 21s131ms 2s347ms 08 11 3m15s 17s802ms 09 8 1m49s 13s717ms 10 6 17s744ms 2s957ms 11 8 19s955ms 2s494ms 12 9 17s397ms 1s933ms 13 10 18s822ms 1s882ms 14 10 17s188ms 1s718ms 15 9 16s585ms 1s842ms 16 9 15s680ms 1s742ms 17 10 15s970ms 1s597ms 18 8 14s58ms 1s757ms 19 8 14s797ms 1s849ms 20 10 21s163ms 2s116ms 21 8 14s456ms 1s807ms 22 8 14s251ms 1s781ms [ User: intelifix - Total duration: 11m12s - Times executed: 204 ]
[ Application: psql - Total duration: 11m12s - Times executed: 204 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:57:23 Duration: 2m13s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 09:36:39 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:45:50 Duration: 45s234ms Database: rio User: intelifix Remote: [local] Application: psql
5 203 1h36m56s 151ms 6m5s 28s652ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 10 07 11 17m12s 1m33s 08 28 18m17s 39s179ms 09 19 17m36s 55s625ms 10 14 5m37s 24s104ms 11 18 11m18s 37s675ms 12 4 1s671ms 417ms 13 20 2m37s 7s862ms 14 23 11m22s 29s667ms 15 24 11m34s 28s949ms 16 25 45s422ms 1s816ms 17 17 32s814ms 1s930ms [ User: intelifix - Total duration: 1h36m56s - Times executed: 203 ]
[ Application: [unknown] - Total duration: 1h36m56s - Times executed: 203 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029681, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 07:25:21 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029707, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 08:57:22 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029696, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 08:45:48 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 160 7m37s 191ms 27s648ms 2s858ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 10 00 6 48s726ms 8s121ms 01 6 19s821ms 3s303ms 02 6 18s641ms 3s106ms 03 5 20s68ms 4s13ms 04 6 20s304ms 3s384ms 05 5 10s820ms 2s164ms 07 9 30s96ms 3s344ms 08 12 39s968ms 3s330ms 09 12 33s279ms 2s773ms 10 12 29s294ms 2s441ms 11 12 42s486ms 3s540ms 12 12 33s669ms 2s805ms 13 8 9s249ms 1s156ms 14 12 27s210ms 2s267ms 15 12 29s844ms 2s487ms 16 10 17s301ms 1s730ms 17 4 1s610ms 402ms 20 1 388ms 388ms 21 4 9s436ms 2s359ms 22 6 15s208ms 2s534ms [ User: intelifix - Total duration: 7m37s - Times executed: 160 ]
[ Application: psql - Total duration: 7m37s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 00:05:28 Duration: 27s648ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 08:55:10 Duration: 8s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 07:55:09 Duration: 8s26ms Database: rio User: intelifix Remote: [local] Application: psql
7 134 42s323ms 297ms 546ms 315ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 10 00 1 303ms 303ms 06 1 298ms 298ms 07 9 2s746ms 305ms 08 12 4s156ms 346ms 09 8 2s754ms 344ms 10 10 3s107ms 310ms 11 10 3s184ms 318ms 12 4 1s220ms 305ms 13 42 12s982ms 309ms 14 11 3s420ms 310ms 15 10 3s89ms 308ms 16 7 2s202ms 314ms 17 8 2s552ms 319ms 20 1 304ms 304ms [ User: lenon - Total duration: 42s323ms - Times executed: 134 ]
[ Application: [unknown] - Total duration: 42s323ms - Times executed: 134 ]
-
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-10 08:38:51 Duration: 546ms 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-10 09:13:16 Duration: 412ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-10 09:13:26 Duration: 394ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
8 114 42s167ms 328ms 594ms 369ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 10 07 6 2s246ms 374ms 08 11 4s538ms 412ms 09 5 2s88ms 417ms 10 10 3s685ms 368ms 11 9 3s384ms 376ms 12 4 1s403ms 350ms 13 34 11s830ms 347ms 14 11 4s198ms 381ms 15 9 3s241ms 360ms 16 7 2s582ms 368ms 17 8 2s966ms 370ms [ User: intelifix - Total duration: 42s167ms - Times executed: 114 ]
[ Application: [unknown] - Total duration: 42s167ms - Times executed: 114 ]
-
select * from rs_menu_grants (401, 53, 1);
Date: 2026-09-10 14:22:57 Duration: 594ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (415, 21, 1);
Date: 2026-09-10 08:38:51 Duration: 593ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (416, 53, 1);
Date: 2026-09-10 07:53:39 Duration: 472ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 87 42s202ms 156ms 2s394ms 485ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 10 07 5 4s204ms 840ms 08 8 3s434ms 429ms 09 5 1s813ms 362ms 10 6 1s988ms 331ms 11 8 3s910ms 488ms 12 1 2s394ms 2s394ms 13 16 7s743ms 483ms 14 14 6s727ms 480ms 15 5 1s158ms 231ms 16 17 6s631ms 390ms 17 2 2s198ms 1s99ms [ User: intelifix - Total duration: 42s202ms - Times executed: 87 ]
[ Application: [unknown] - Total duration: 42s202ms - Times executed: 87 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133692) LIMIT 1;
Date: 2026-09-10 12:56:54 Duration: 2s394ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0136462) LIMIT 1;
Date: 2026-09-10 07:07:02 Duration: 2s218ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0129996) LIMIT 1;
Date: 2026-09-10 17:39:49 Duration: 1s400ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
10 85 23s579ms 245ms 354ms 277ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 10 07 4 1s74ms 268ms 08 13 3s822ms 294ms 09 11 3s144ms 285ms 10 4 1s65ms 266ms 11 10 2s757ms 275ms 12 4 1s85ms 271ms 13 8 2s202ms 275ms 14 6 1s632ms 272ms 15 12 3s256ms 271ms 16 5 1s373ms 274ms 17 8 2s164ms 270ms [ User: intelifix - Total duration: 23s579ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 23s579ms - Times executed: 85 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-10 11:33:51 Duration: 354ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-10 17:21:17 Duration: 354ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-10 13:48:02 Duration: 336ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
11 81 15m3s 8s915ms 16s533ms 11s159ms create table temp0000291029 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 10 08 36 6m50s 11s400ms 09 17 3m6s 10s970ms 10 4 45s732ms 11s433ms 11 24 4m21s 10s885ms [ User: intelifix - Total duration: 15m3s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 15m3s - Times executed: 81 ]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 11:19:09 Duration: 16s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 10:14:26 Duration: 14s332ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 08:56:04 Duration: 12s801ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 75 9m16s 1s136ms 25s957ms 7s424ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 10 07 2 10s43ms 5s21ms 08 4 21s406ms 5s351ms 09 2 35s125ms 17s562ms 10 9 1m31s 10s163ms 11 6 49s835ms 8s305ms 12 2 5s206ms 2s603ms 13 7 1m6s 9s490ms 14 9 1m14s 8s230ms 15 11 1m10s 6s385ms 16 17 1m56s 6s861ms 17 6 16s353ms 2s725ms [ User: intelifix - Total duration: 9m16s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 9m16s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 0320, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 09:38:43 Duration: 25s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 10:52:31 Duration: 25s532ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 10:12:33 Duration: 24s222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 57 1m42s 570ms 19s573ms 1s792ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 10 08 4 6s398ms 1s599ms 09 3 2s207ms 735ms 10 3 5s262ms 1s754ms 11 4 5s646ms 1s411ms 12 4 15s930ms 3s982ms 13 6 11s507ms 1s917ms 14 4 7s528ms 1s882ms 15 4 8s309ms 2s77ms 16 3 2s205ms 735ms 17 3 3s306ms 1s102ms 18 4 22s353ms 5s588ms 19 4 3s112ms 778ms 20 4 3s22ms 755ms 21 4 3s162ms 790ms 22 3 2s228ms 742ms [ User: intelifix - Total duration: 1m42s - Times executed: 57 ]
[ Application: psql - Total duration: 1m42s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-10 18:00:21 Duration: 19s573ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-10 12:40:10 Duration: 9s48ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-10 15:00:07 Duration: 6s8ms Database: rio User: intelifix Remote: [local] Application: psql
14 55 3m18s 163ms 27s640ms 3s614ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 10 07 5 34s705ms 6s941ms 08 12 34s849ms 2s904ms 09 8 32s511ms 4s63ms 10 1 5s191ms 5s191ms 11 10 23s390ms 2s339ms 13 1 4s600ms 4s600ms 14 5 26s423ms 5s284ms 15 6 27s842ms 4s640ms 16 2 5s327ms 2s663ms 17 5 3s930ms 786ms [ User: intelifix - Total duration: 3m18s - Times executed: 55 ]
[ Application: psql - Total duration: 3m18s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029681);
Date: 2026-09-10 07:19:15 Duration: 27s640ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029722);
Date: 2026-09-10 09:31:08 Duration: 14s50ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029686);
Date: 2026-09-10 08:12:28 Duration: 11s77ms Database: rio User: intelifix Remote: [local] Application: psql
15 48 1h28m26s 1s364ms 7m34s 1m50s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 10 07 3 8m9s 2m43s 08 3 5m8s 1m42s 09 3 7m9s 2m23s 10 3 5m8s 1m42s 11 3 5m10s 1m43s 12 3 5m10s 1m43s 13 3 5m7s 1m42s 14 3 5m28s 1m49s 15 3 5m26s 1m48s 16 3 5m29s 1m49s 17 3 5m17s 1m45s 18 3 5m12s 1m44s 19 3 5m4s 1m41s 20 3 5m15s 1m45s 21 3 5m10s 1m43s 22 3 4m57s 1m39s [ User: intelifix - Total duration: 1h28m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h28m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 07:12:35 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 09:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 16:10:13 Duration: 5m12s Database: rio User: intelifix Remote: [local] Application: psql
16 48 1h5m55s 219ms 4m2s 1m22s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 10 07 3 4m51s 1m37s 08 3 4m34s 1m31s 09 3 4m54s 1m38s 10 3 3m58s 1m19s 11 3 3m58s 1m19s 12 3 3m53s 1m17s 13 3 3m53s 1m17s 14 3 3m57s 1m19s 15 3 4m7s 1m22s 16 3 4m9s 1m23s 17 3 4m10s 1m23s 18 3 3m47s 1m15s 19 3 3m48s 1m16s 20 3 3m50s 1m16s 21 3 3m51s 1m17s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h5m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 08:14:38 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 09:17:04 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 07:17:54 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
17 47 8m47s 8s249ms 38s71ms 11s229ms create table temp0000291011 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 10 07 11 1m34s 8s593ms 08 9 1m41s 11s229ms 09 13 2m29s 11s477ms 10 3 59s708ms 19s902ms 11 11 2m3s 11s208ms [ User: intelifix - Total duration: 8m47s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m47s - Times executed: 47 ]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 10:08:59 Duration: 38s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 11:03:16 Duration: 17s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 09:06:55 Duration: 12s982ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 47 1m46s 1s959ms 5s832ms 2s267ms create table temp0000291029 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 10 08 23 48s807ms 2s122ms 09 9 19s403ms 2s155ms 10 2 4s634ms 2s317ms 11 13 33s737ms 2s595ms [ User: intelifix - Total duration: 1m46s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 1m46s - Times executed: 47 ]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 11:21:41 Duration: 5s832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 11:37:04 Duration: 2s926ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 10:15:40 Duration: 2s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 41 11s3ms 150ms 633ms 268ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 10 09 1 234ms 234ms 10 5 1s548ms 309ms 11 4 867ms 216ms 14 10 2s525ms 252ms 15 20 5s610ms 280ms 16 1 215ms 215ms [ User: intelifix - Total duration: 11s3ms - Times executed: 41 ]
[ Application: [unknown] - Total duration: 11s3ms - Times executed: 41 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '14200454A5DE,7C7D21F0CC8B,DC5193DA938A,38165A47A0B0,DC5193D9EACA,7C7D21F20F4F,DC5193DA69B2,DC5193DC039E,142004557B9E,38165A488498,14200452EFBE,7C7D21EBF02B,7C7D21F1EADF,DC5193D9E206,DC5193DAAA22,14200452EBB6,E44E12939C7F,14200452EB0E,14200454DCDE,DC5193DAC406', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-09-10 15:50:06 Duration: 633ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '317004120103,318322066779,318268066869,318170671821,383FB3A7121F,319012385360,310007191426,319037522934,318330522735,317158451531,905851A9C372,317002177081,1062D09958DB,310007479602,319287067881,318184400521', '138;1', 'DEFAULT', 09, 046, '','', '', 00);
Date: 2026-09-10 15:10:28 Duration: 524ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D89A0D867C03,689E29BE9FB9,6C11BA66D137,14CA56CD9307,14CA56D731E3,F4E84F83B916,843C992E95B3,3CF9F0A8E1EE,3891485162B9,48D682330DEA,C4EBFF89E974,5872C98F57BD,5872C98F6081,6C11BA632979,6C11BA689EFB,C4EBFF8AED0C,5872C98B291D,F4E84F86458A,D89A0DB0BC21,D89A0DA8FEC5', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-10 14:43:55 Duration: 442ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 37 3m5s 154ms 1m8s 5s6ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 10 07 4 1s185ms 296ms 08 6 1s480ms 246ms 09 5 14s510ms 2s902ms 10 1 539ms 539ms 11 8 6s180ms 772ms 13 1 160ms 160ms 14 5 1m4s 12s834ms 15 5 1m10s 14s80ms 16 2 26s597ms 13s298ms [ User: intelifix - Total duration: 3m5s - Times executed: 37 ]
[ Application: psql - Total duration: 3m5s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029775);
Date: 2026-09-10 15:59:15 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029763);
Date: 2026-09-10 14:38:30 Duration: 42s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029768);
Date: 2026-09-10 14:54:23 Duration: 20s992ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m43s 9m40s 6m4s 3 18m12s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 10 05 3 18m12s 6m4s [ User: intelifix - Total duration: 18m12s - Times executed: 3 ]
[ Application: psql - Total duration: 18m12s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-10 05:09:41 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-10 05:15:30 Duration: 5m48s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-10 05:18:13 Duration: 2m43s Database: contagem User: intelifix Remote: [local] Application: psql
2 3m51s 3m51s 3m51s 1 3m51s drop table if exists x; create temp table x as select * from lote_itens aa where li_status = ? and exists ( select ? from lote_itens a inner join fluxos b on b.flu_id = a.flu_id and b.flu_status not in (...) where a.eq_id = aa.eq_id) and not exists ( select ? from nf_entrada_itens c where c.li_id = aa.li_id);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 10 12 1 3m51s 3m51s [ User: lenon - Total duration: 3m51s - Times executed: 1 ]
[ Application: pgAdmin 4 - CONN:2332371 - Total duration: 3m51s - Times executed: 1 ]
-
drop table IF EXISTS x; CREATE TEMP TABLE X AS SELECT * FROM LOTE_ITENS AA WHERE LI_STATUS = 0 AND EXISTS ( SELECT 1 FROM LOTE_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID AND B.FLU_STATUS NOT IN ('L', 'E') WHERE A.EQ_ID = AA.EQ_ID) AND NOT EXISTS ( SELECT 1 FROM NF_ENTRADA_ITENS C WHERE C.LI_ID = AA.LI_ID);
Date: 2026-09-10 12:48:32 Duration: 3m51s Database: rio User: lenon Remote: 172.20.0.3 Application: pgAdmin 4 - CONN:2332371
3 1s364ms 7m34s 1m50s 48 1h28m26s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 10 07 3 8m9s 2m43s 08 3 5m8s 1m42s 09 3 7m9s 2m23s 10 3 5m8s 1m42s 11 3 5m10s 1m43s 12 3 5m10s 1m43s 13 3 5m7s 1m42s 14 3 5m28s 1m49s 15 3 5m26s 1m48s 16 3 5m29s 1m49s 17 3 5m17s 1m45s 18 3 5m12s 1m44s 19 3 5m4s 1m41s 20 3 5m15s 1m45s 21 3 5m10s 1m43s 22 3 4m57s 1m39s [ User: intelifix - Total duration: 1h28m26s - Times executed: 48 ]
[ Application: psql - Total duration: 1h28m26s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 07:12:35 Duration: 7m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 09:11:36 Duration: 6m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-10 16:10:13 Duration: 5m12s Database: rio User: intelifix Remote: [local] Application: psql
4 219ms 4m2s 1m22s 48 1h5m55s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 10 07 3 4m51s 1m37s 08 3 4m34s 1m31s 09 3 4m54s 1m38s 10 3 3m58s 1m19s 11 3 3m58s 1m19s 12 3 3m53s 1m17s 13 3 3m53s 1m17s 14 3 3m57s 1m19s 15 3 4m7s 1m22s 16 3 4m9s 1m23s 17 3 4m10s 1m23s 18 3 3m47s 1m15s 19 3 3m48s 1m16s 20 3 3m50s 1m16s 21 3 3m51s 1m17s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h5m55s - Times executed: 48 ]
[ Application: psql - Total duration: 1h5m55s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 08:14:38 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 09:17:04 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-10 07:17:54 Duration: 3m44s Database: brasilia User: intelifix Remote: [local] Application: psql
5 4s27ms 1m3s 33s123ms 4 2m12s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 10 20 2 1m7s 33s568ms 23 2 1m5s 32s679ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-10 20:08:33 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-10 23:16:31 Duration: 1m1s 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-10 23:33:35 Duration: 4s88ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 151ms 6m5s 28s652ms 203 1h36m56s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 10 07 11 17m12s 1m33s 08 28 18m17s 39s179ms 09 19 17m36s 55s625ms 10 14 5m37s 24s104ms 11 18 11m18s 37s675ms 12 4 1s671ms 417ms 13 20 2m37s 7s862ms 14 23 11m22s 29s667ms 15 24 11m34s 28s949ms 16 25 45s422ms 1s816ms 17 17 32s814ms 1s930ms [ User: intelifix - Total duration: 1h36m56s - Times executed: 203 ]
[ Application: [unknown] - Total duration: 1h36m56s - Times executed: 203 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029681, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 07:25:21 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029707, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 08:57:22 Duration: 5m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029696, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-10 08:45:48 Duration: 5m53s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 328ms 52s466ms 26s345ms 4 1m45s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 10 20 2 52s586ms 26s293ms 23 2 52s795ms 26s397ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-10 23:13:39 Duration: 52s466ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-10 20:05:40 Duration: 52s246ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-10 20:09:54 Duration: 339ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
8 10s292ms 15s902ms 11s233ms 16 2m59s create table temp0000291121 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 10 14 7 1m18s 11s250ms 15 4 42s11ms 10s502ms 16 5 58s975ms 11s795ms [ User: intelifix - Total duration: 2m59s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 2m59s - Times executed: 16 ]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 16:17:13 Duration: 15s902ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 14:55:13 Duration: 12s857ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291121 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 14:54:14 Duration: 11s741ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8s249ms 38s71ms 11s229ms 47 8m47s create table temp0000291011 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 10 07 11 1m34s 8s593ms 08 9 1m41s 11s229ms 09 13 2m29s 11s477ms 10 3 59s708ms 19s902ms 11 11 2m3s 11s208ms [ User: intelifix - Total duration: 8m47s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m47s - Times executed: 47 ]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 10:08:59 Duration: 38s71ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 11:03:16 Duration: 17s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291011 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 09:06:55 Duration: 12s982ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8s915ms 16s533ms 11s159ms 81 15m3s create table temp0000291029 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 10 08 36 6m50s 11s400ms 09 17 3m6s 10s970ms 10 4 45s732ms 11s433ms 11 24 4m21s 10s885ms [ User: intelifix - Total duration: 15m3s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 15m3s - Times executed: 81 ]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 11:19:09 Duration: 16s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 10:14:26 Duration: 14s332ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 08:56:04 Duration: 12s801ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s516ms 12s850ms 10s982ms 17 3m6s create table temp0000291115 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 10 14 9 1m37s 10s800ms 15 8 1m29s 11s187ms [ User: intelifix - Total duration: 3m6s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m6s - Times executed: 17 ]
-
CREATE TABLE temp0000291115 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 15:15:24 Duration: 12s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291115 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 15:00:39 Duration: 11s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291115 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 15:01:08 Duration: 11s231ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s152ms 12s554ms 10s729ms 32 5m43s create table temp0000291095 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 10 13 3 33s666ms 11s222ms 14 7 1m14s 10s688ms 15 3 32s352ms 10s784ms 17 19 3m22s 10s657ms [ User: intelifix - Total duration: 5m43s - Times executed: 32 ]
[ Application: [unknown] - Total duration: 5m43s - Times executed: 32 ]
-
CREATE TABLE temp0000291095 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 13:26:40 Duration: 12s554ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291095 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 14:40:41 Duration: 11s192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291095 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-10 17:15:09 Duration: 11s177ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s136ms 25s957ms 7s424ms 75 9m16s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 10 07 2 10s43ms 5s21ms 08 4 21s406ms 5s351ms 09 2 35s125ms 17s562ms 10 9 1m31s 10s163ms 11 6 49s835ms 8s305ms 12 2 5s206ms 2s603ms 13 7 1m6s 9s490ms 14 9 1m14s 8s230ms 15 11 1m10s 6s385ms 16 17 1m56s 6s861ms 17 6 16s353ms 2s725ms [ User: intelifix - Total duration: 9m16s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 9m16s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 0320, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 09:38:43 Duration: 25s957ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 0302, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 10:52:31 Duration: 25s532ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-10', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-10 10:12:33 Duration: 24s222ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 154ms 1m8s 5s6ms 37 3m5s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 10 07 4 1s185ms 296ms 08 6 1s480ms 246ms 09 5 14s510ms 2s902ms 10 1 539ms 539ms 11 8 6s180ms 772ms 13 1 160ms 160ms 14 5 1m4s 12s834ms 15 5 1m10s 14s80ms 16 2 26s597ms 13s298ms [ User: intelifix - Total duration: 3m5s - Times executed: 37 ]
[ Application: psql - Total duration: 3m5s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029775);
Date: 2026-09-10 15:59:15 Duration: 1m8s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029763);
Date: 2026-09-10 14:38:30 Duration: 42s237ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029768);
Date: 2026-09-10 14:54:23 Duration: 20s992ms Database: rio User: intelifix Remote: [local] Application: psql
15 163ms 27s640ms 3s614ms 55 3m18s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 10 07 5 34s705ms 6s941ms 08 12 34s849ms 2s904ms 09 8 32s511ms 4s63ms 10 1 5s191ms 5s191ms 11 10 23s390ms 2s339ms 13 1 4s600ms 4s600ms 14 5 26s423ms 5s284ms 15 6 27s842ms 4s640ms 16 2 5s327ms 2s663ms 17 5 3s930ms 786ms [ User: intelifix - Total duration: 3m18s - Times executed: 55 ]
[ Application: psql - Total duration: 3m18s - Times executed: 55 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029681);
Date: 2026-09-10 07:19:15 Duration: 27s640ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029722);
Date: 2026-09-10 09:31:08 Duration: 14s50ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029686);
Date: 2026-09-10 08:12:28 Duration: 11s77ms Database: rio User: intelifix Remote: [local] Application: psql
16 150ms 2m13s 3s295ms 204 11m12s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 10 00 9 25s835ms 2s870ms 01 10 16s490ms 1s649ms 02 8 16s796ms 2s99ms 03 9 17s66ms 1s896ms 04 11 18s163ms 1s651ms 05 8 16s571ms 2s71ms 06 8 16s564ms 2s70ms 07 9 21s131ms 2s347ms 08 11 3m15s 17s802ms 09 8 1m49s 13s717ms 10 6 17s744ms 2s957ms 11 8 19s955ms 2s494ms 12 9 17s397ms 1s933ms 13 10 18s822ms 1s882ms 14 10 17s188ms 1s718ms 15 9 16s585ms 1s842ms 16 9 15s680ms 1s742ms 17 10 15s970ms 1s597ms 18 8 14s58ms 1s757ms 19 8 14s797ms 1s849ms 20 10 21s163ms 2s116ms 21 8 14s456ms 1s807ms 22 8 14s251ms 1s781ms [ User: intelifix - Total duration: 11m12s - Times executed: 204 ]
[ Application: psql - Total duration: 11m12s - Times executed: 204 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:57:23 Duration: 2m13s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 09:36:39 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-10 08:45:50 Duration: 45s234ms Database: rio User: intelifix Remote: [local] Application: psql
17 191ms 27s648ms 2s858ms 160 7m37s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 10 00 6 48s726ms 8s121ms 01 6 19s821ms 3s303ms 02 6 18s641ms 3s106ms 03 5 20s68ms 4s13ms 04 6 20s304ms 3s384ms 05 5 10s820ms 2s164ms 07 9 30s96ms 3s344ms 08 12 39s968ms 3s330ms 09 12 33s279ms 2s773ms 10 12 29s294ms 2s441ms 11 12 42s486ms 3s540ms 12 12 33s669ms 2s805ms 13 8 9s249ms 1s156ms 14 12 27s210ms 2s267ms 15 12 29s844ms 2s487ms 16 10 17s301ms 1s730ms 17 4 1s610ms 402ms 20 1 388ms 388ms 21 4 9s436ms 2s359ms 22 6 15s208ms 2s534ms [ User: intelifix - Total duration: 7m37s - Times executed: 160 ]
[ Application: psql - Total duration: 7m37s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 00:05:28 Duration: 27s648ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 08:55:10 Duration: 8s98ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-10 07:55:09 Duration: 8s26ms Database: rio User: intelifix Remote: [local] Application: psql
18 1s959ms 5s832ms 2s267ms 47 1m46s create table temp0000291029 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 10 08 23 48s807ms 2s122ms 09 9 19s403ms 2s155ms 10 2 4s634ms 2s317ms 11 13 33s737ms 2s595ms [ User: intelifix - Total duration: 1m46s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 1m46s - Times executed: 47 ]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 11:21:41 Duration: 5s832ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 11:37:04 Duration: 2s926ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000291029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"05-09-2026", "ate" :"10-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-10 10:15:40 Duration: 2s513ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 570ms 19s573ms 1s792ms 57 1m42s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 10 08 4 6s398ms 1s599ms 09 3 2s207ms 735ms 10 3 5s262ms 1s754ms 11 4 5s646ms 1s411ms 12 4 15s930ms 3s982ms 13 6 11s507ms 1s917ms 14 4 7s528ms 1s882ms 15 4 8s309ms 2s77ms 16 3 2s205ms 735ms 17 3 3s306ms 1s102ms 18 4 22s353ms 5s588ms 19 4 3s112ms 778ms 20 4 3s22ms 755ms 21 4 3s162ms 790ms 22 3 2s228ms 742ms [ User: intelifix - Total duration: 1m42s - Times executed: 57 ]
[ Application: psql - Total duration: 1m42s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-10 18:00:21 Duration: 19s573ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-10 12:40:10 Duration: 9s48ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-10 15:00:07 Duration: 6s8ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 4s905ms 777ms 1,060 13m44s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 10 07 18 19s634ms 1s90ms 08 67 52s986ms 790ms 09 151 1m47s 712ms 10 176 2m7s 725ms 11 88 1m4s 737ms 12 34 23s504ms 691ms 13 37 30s736ms 830ms 14 145 1m58s 816ms 15 146 2m5s 857ms 16 131 1m52s 861ms 17 67 41s164ms 614ms [ User: intelifix - Total duration: 13m44s - Times executed: 1060 ]
[ Application: [unknown] - Total duration: 13m44s - Times executed: 1060 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285718, 504, 'F200011054B2402,9877E74CD9A1$F200012014BA3FE,840112980221$F200011326B93FA,84011282E224$F200011328B2F4B,840112836763$F200012015B9875,840112984795$F200011291B24B0,8401125FFB70$F200011246B0537,8401122B4264$F200012075B29B7,840112DD706A$F200011075B7598,9877E74A39D2$F200011086B3F62,9877E77B1FD6$F200011327B5F48,840112831AEF$F200010280BB52B,743AEFAC594C$F200011009E18CB,9877E707C715$F200011132B0924,9877E7B9D419$F200012004B2CB0,84011295B897$F200010048127F9,743AEF1420B5', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 07:41:24 Duration: 4s905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (286240, 317, '835074911001212,241660458397,241730205373,241608838387,241660457084,241646707998,241597400314,241637384249,241732471633,241672742930,241603895369,241646635971,241596701121,241667799002,241619533147,241706981334,241667671818,241712113237,241664729599,241645955871', '',0320,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 15:51:09 Duration: 4s850ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (285744, 452, '71521085850016807886,216609044050,216836394970,216514813653,216551183252,216861139506,216799350323,216870366377,216505363752,216351573535,216867624359,216858134050H010987116,216634486364', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-10 10:48:20 Duration: 4s786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 150ms 1 150ms 150ms 150ms SELECT * FROM RS_ETIQUETA ('');Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Sep 10 23 1 150ms 150ms [ User: etiquetas - Total duration: 175ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 175ms - Times executed: 1 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-09-10 23:43:16 Duration: 150ms Database: postgres User: brasilia Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 10 11 1 0ms 0ms 12 1 0ms 0ms 13 3 0ms 0ms 20 3 0ms 0ms 21 1 0ms 0ms [ User: intelifix - Total duration: 7s57ms - Times executed: 8 ]
[ User: lenon - Total duration: 1s325ms - Times executed: 1 ]
[ Application: psql - Total duration: 5s32ms - Times executed: 5 ]
[ Application: [unknown] - Total duration: 2s24ms - Times executed: 3 ]
[ Application: pgAdmin 4 - CONN:8573629 - Total duration: 1s325ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 15,202 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 17 FATAL entries
- 2963 ERROR entries
- 0 WARNING entries
- 12 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,879 Max number of times the same event was reported
- 2,992 Total events found
Rank Times reported Error 1 2,879 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 10 07 139 08 253 09 313 10 316 11 286 12 84 13 130 14 311 15 407 16 196 17 165 18 48 19 49 20 50 21 46 22 47 23 39 - ERROR: prepared statement "_PLAN0000000034E14BD0" does not exist
- ERROR: prepared statement "_PLAN0000000034E16730" does not exist
- ERROR: prepared statement "_PLAN0000000034E15E10" does not exist
Statement: DEALLOCATE "_PLAN0000000034E14BD0"
Date: 2026-09-10 07:01:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000034E16730"
Date: 2026-09-10 07:01:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000034E15E10"
Date: 2026-09-10 07:02:10 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 40 ERROR: function rs_equipamento_garantia(...) does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 10 12 4 13 36 - ERROR: function rs_equipamento_garantia(character varying, integer) does not exist at character 14 2026-09-10 12:53:27 -03 [2755656]: [46-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: bGarantia := RS_EQUIPAMENTO_GARANTIA( aCodigos[ nI ] , nModelo )
- ERROR: function rs_equipamento_garantia(character varying, integer) does not exist at character 14 2026-09-10 12:55:50 -03 [2761559]: [14-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: bGarantia := RS_EQUIPAMENTO_GARANTIA( aCodigos[ nI ] , nModelo )
- ERROR: function rs_equipamento_garantia(character varying, integer) does not exist at character 14 2026-09-10 12:58:37 -03 [2776165]: [9-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: bGarantia := RS_EQUIPAMENTO_GARANTIA( aCodigos[ nI ] , nModelo )
Context: PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 731 at assignment
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(136432,397,'257298115182131,216821719597$258114115537990,216853190123$258179115303640,216885837999$256028114289495,216664067994$258246115327070,216901266890$258184115100822,216886021430$256053114156264,216667802243$258087115132639,216850259903$255272117196470,216622130008$257137111521115,216794266885$257016114055158,216757946180$258272115006772,216919703639$258086115632228,216850405978$255050118794552,216529399295','',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-09-10 12:53:27 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 731 at assignment
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(136432,397,'258179115303640,216885837999$258184115100822,216886021430$258272115006772,216919703639$258246115327070,216901266890$256028114289495,216664067994$255272117196470,216622130008$257137111521115,216794266885$258086115632228,216850405978$256053114156264,216667802243$258087115132639,216850259903$257016114055158,216757946180$255050118794552,216529399295$258114115537990,216853190123$257298115182131,216821719597','',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-09-10 12:55:50 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 731 at assignment
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(136432,397,'257298115182131,216821719597$258114115537990,216853190123$255050118794552,216529399295$257016114055158,216757946180$258087115132639,216850259903$256053114156264,216667802243$258086115632228,216850405978$257137111521115,216794266885$255272117196470,216622130008$256028114289495,216664067994$258246115327070,216901266890$258272115006772,216919703639$258184115100822,216886021430$258179115303640,216885837999','',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-09-10 12:58:37 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 14 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 10 08 2 09 3 10 1 12 2 16 1 17 5 - ERROR: syntax error at or near "135801" at character 37
- ERROR: syntax error at or near "135801" at character 37
- ERROR: syntax error at or near "]" at character 35
Statement: select * from rs_caixa_qr(->> Caixa 135801)
Date: 2026-09-10 08:25:31 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(->> Caixa 135801)
Date: 2026-09-10 08:25:31 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3631219 ])
Date: 2026-09-10 09:03:52 Database: rio Application: [unknown] User: etiquetas Remote: [local]
4 12 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 10 08 3 10 4 15 3 16 2 - ERROR: trailing junk after numeric literal at or near "88ç0fça2çafç77ç53" at character 27
- ERROR: trailing junk after numeric literal at or near "88ç0fça2çafç77ç53" at character 27
- ERROR: trailing junk after numeric literal at or near "88ç0fça2çafç77ç53" at character 27
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2çafç77ç53)
Date: 2026-09-10 08:01:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2çafç77ç53)
Date: 2026-09-10 08:01:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(88ç0fça2çafç77ç53)
Date: 2026-09-10 08:01:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 7 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 10 08 5 09 2 - LOG: process 2563261 still waiting for ShareLock on transaction 5858811 after 1000.075 ms
- LOG: process 2563261 still waiting for ShareLock on transaction 5858811 after 6736.705 ms
- LOG: process 2555032 still waiting for ShareLock on transaction 5859998 after 1000.137 ms
Detail: Process holding the lock: 2547014. Wait queue: 2563261.
Context: while updating tuple (79415,110) 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-10 08:45:09 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2547014. Wait queue: 2563261.
Context: while updating tuple (79415,110) 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-10 08:45:15 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 2563261. Wait queue: 2555032.
Context: while updating tuple (79417,41) 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-10 08:55:13 Database: rio Application: psql User: intelifix Remote: [local]
6 7 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 10 07 1 14 2 15 2 16 2 - ERROR: column "pas_id" does not exist at character 66 2026-09-10 07:17:55 -03 [2528682]: [26-1] user=intelifix,db=brasilia,app=[unknown],client=[local] QUERY: SELECT * FROM PARTE_MOVIMENTOS WHERE PM_ID = ANY( aPMs ) AND PAS_ID = nPasso
- ERROR: column "controle" does not exist at character 36
- ERROR: column "controle" does not exist at character 36
Context: PL/pgSQL function rs_caixa_kits_exclui(integer,integer) line 46 at FOR over SELECT rows PL/pgSQL function rs_lote_saida_exclui(integer) line 87 at assignment
Hint: Perhaps you meant to reference the column "parte_movimentos.ps_id".
Statement: SELECT * FROM RS_LOTE_SAIDA_EXCLUI(0136556);Date: 2026-09-10 07:17:55 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: Perhaps you meant to reference the column "temp0000239926.con_nome".
Statement: SELECT * FROM temp0000239926 WHERE CONTROLE='L'Date: 2026-09-10 14:50:34 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Hint: Perhaps you meant to reference the column "temp0000239926.con_nome".
Statement: SELECT * FROM temp0000239926 WHERE CONTROLE='L'Date: 2026-09-10 14:50:34 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 10 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-10 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-10 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-10 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 7 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 10 00 1 06 1 12 1 15 2 19 2 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-10 00:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-10 06:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-10 12:16:16 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
9 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 10 05 4 16 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-10 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-10 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-10 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
10 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 10 15 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-10 15:11:43 Database: rio Application: pgAdmin 4 - CONN:2332371 User: lenon Remote: 172.20.0.3
Date: 2026-09-10 15:11:43 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
Date: 2026-09-10 15:12:16 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3
11 3 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 10 12 2 16 1 - ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
- ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
- ERROR: update or delete on table "equipamentos" violates foreign key constraint "fluxos_eq_id_fkey" on table "fluxos"
Detail: Key (li_id)=(1194791) is still referenced from table "nf_entrada_itens".
Statement: DELETE FROM LOTE_itens where li_id in (select li_id from x );Date: 2026-09-10 12:42:16 Database: brasilia Application: pgAdmin 4 - CONN:8573629 User: lenon Remote: 172.20.0.3
Detail: Key (li_id)=(1630096) is still referenced from table "nf_entrada_itens".
Statement: DELETE FROM LOTE_itens where li_id in (select li_id from x );Date: 2026-09-10 12:43:06 Database: brasilia Application: pgAdmin 4 - CONN:8573629 User: lenon Remote: 172.20.0.3
Detail: Key (eq_id)=(962846) is still referenced from table "fluxos".
Statement: DELETE FROM EQUIPAMENTOS WHERE EQ_ID IN (SELECT EQ_ID FROM Y)Date: 2026-09-10 16:58:49 Database: contagem Application: pgAdmin 4 - CONN:8250977 User: lenon Remote: 172.20.0.3
12 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 10 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-10 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-10 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-10 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 10 08 1 - LOG: process 2563261 still waiting for AccessExclusiveLock on relation 4863238 of database 358220 after 1000.129 ms
Detail: Process holding the lock: 2570423. Wait queue: 2563261.
Statement: DROP TABLE IF EXISTS temp0000291029;Date: 2026-09-10 08:43:37 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 10 15 1 - ERROR: malformed array literal: "{0,95,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,95,0,0,}', 463 ));Date: 2026-09-10 15:57:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 10 16 1 - ERROR: canceling statement due to user request
Statement: select * from LOTE_ITENS A INNER JOIN CODIGOS_BARRA B ON B.EQ_CODIGO = A.LI_SERIE
Date: 2026-09-10 16:55:04 Database: contagem Application: pgAdmin 4 - CONN:8250977 User: lenon Remote: 172.20.0.3
16 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 10 08 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000291029"
Date: 2026-09-10 08:43:37
17 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 10 03 1 - LOG: database system was shut down at 2026-09-10 03:05:01 -03
Date: 2026-09-10 03:05:02