pgBadger-
Global information
- Generated on Fri Jul 17 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 42,581 log entries in 8s
- Log start from 2026-07-17 00:00:05 to 2026-07-17 23:49:20
-
Overview
Global Stats
- 378 Number of unique normalized queries
- 6,189 Number of queries
- 7h52m30s Total query duration
- 2026-07-17 00:02:12 First query
- 2026-07-17 23:48:21 Last query
- 5 queries/s at 2026-07-17 08:00:12 Query peak
- 7h52m30s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h52m30s Execute total duration
- 3,846 Number of events
- 25 Number of unique normalized events
- 3,669 Max number of times the same event was reported
- 0 Number of cancellation
- 508 Total number of automatic vacuums
- 1,026 Total number of automatic analyzes
- 17 Number temporary file
- 235.83 MiB Max size of temporary file
- 124.16 MiB Average size of temporary file
- 411 Total number of sessions
- 20 sessions at 2026-07-17 15:01:25 Session peak
- 14d4h25m3s Total duration of sessions
- 49m41s Average duration of sessions
- 15 Average queries per session
- 1m8s Average queries duration per session
- 48m32s Average idle time per session
- 412 Total number of connections
- 6 connections/s at 2026-07-17 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-17 08:00:12 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-17 08:00:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-17 23:48:18 Date
Queries duration
Key values
- 7h52m30s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 17 00 25 0ms 17s815ms 4s475ms 5s175ms 5s561ms 1m12s 01 28 0ms 5s172ms 1s342ms 4s63ms 6s276ms 7s173ms 02 17 0ms 4s917ms 2s118ms 4s910ms 6s236ms 6s527ms 03 17 0ms 5s207ms 2s132ms 3s968ms 6s377ms 8s88ms 04 20 0ms 5s619ms 1s901ms 4s337ms 6s531ms 8s255ms 05 42 0ms 8m4s 23s877ms 10s482ms 2m12s 8m4s 06 30 0ms 13s451ms 2s822ms 4s931ms 13s494ms 30s221ms 07 583 0ms 8m34s 4s184ms 1m14s 4m48s 9m9s 08 744 150ms 9m3s 4s662ms 4m30s 5m26s 9m26s 09 858 150ms 8m12s 2s398ms 1m9s 2m19s 8m57s 10 685 150ms 9m11s 3s644ms 54s443ms 5m18s 9m15s 11 548 150ms 7m2s 3s173ms 31s316ms 4m52s 7m24s 12 112 0ms 6m55s 7s88ms 7s880ms 59s712ms 6m56s 13 365 0ms 6m18s 3s420ms 34s469ms 1m45s 6m54s 14 668 0ms 7m55s 3s346ms 1m6s 4m20s 8m 15 578 150ms 9m1s 3s540ms 37s980ms 4m6s 10m12s 16 215 0ms 8m38s 6s586ms 59s989ms 1m13s 8m41s 17 106 0ms 5m51s 6s468ms 6s72ms 42s628ms 5m52s 18 25 0ms 5m36s 24s893ms 4s764ms 49s935ms 5m36s 19 19 0ms 5m38s 31s800ms 4s258ms 44s989ms 5m38s 20 115 0ms 7m13s 11s485ms 1m7s 2m13s 7m13s 21 33 0ms 5m39s 18s954ms 6s815ms 44s523ms 5m39s 22 24 0ms 8m58s 38s88ms 5s536ms 44s570ms 9m57s 23 332 0ms 1m41s 6s888ms 1m4s 1m10s 2m Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 17 00 3 0 4s255ms 0ms 0ms 0ms 01 11 0 288ms 0ms 157ms 1s63ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 3 0 380ms 0ms 0ms 0ms 05 21 0 291ms 167ms 232ms 1s47ms 06 9 0 1s807ms 0ms 0ms 1s33ms 07 417 0 4s382ms 11s163ms 41s592ms 5m19s 08 530 0 4s861ms 23s269ms 4m19s 5m24s 09 707 0 2s368ms 13s720ms 47s776ms 5m14s 10 522 26 3s883ms 19s897ms 53s625ms 8m 11 440 0 3s534ms 10s15ms 14s889ms 7m5s 12 70 0 10s355ms 2s368ms 3s599ms 3m28s 13 276 0 3s612ms 10s468ms 20s144ms 3m38s 14 537 0 3s218ms 16s841ms 49s421ms 5m57s 15 432 0 3s888ms 12s425ms 20s745ms 5m26s 16 148 0 8s47ms 6s460ms 44s479ms 4m24s 17 48 0 13s308ms 1s531ms 3s799ms 3m32s 18 11 0 53s888ms 0ms 0ms 3m19s 19 6 0 1m35s 0ms 0ms 3m11s 20 10 87 13s144ms 22s737ms 1m7s 3m42s 21 12 0 48s340ms 0ms 0ms 3m14s 22 6 0 2m25s 0ms 0ms 3m59s 23 8 324 6s888ms 1m2s 1m4s 2m Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 17 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 1 0 0 1s156ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 17 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 2 2.00 0.00% 07 0 14 14.00 0.00% 08 0 13 13.00 0.00% 09 0 13 13.00 0.00% 10 0 17 17.00 0.00% 11 0 14 14.00 0.00% 12 0 4 4.00 0.00% 13 0 16 16.00 0.00% 14 0 10 10.00 0.00% 15 0 14 14.00 0.00% 16 0 6 6.00 0.00% 17 0 3 3.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 17 00 15 0.00/s 01 9 0.00/s 02 9 0.00/s 03 20 0.01/s 04 9 0.00/s 05 8 0.00/s 06 14 0.00/s 07 22 0.01/s 08 27 0.01/s 09 24 0.01/s 10 36 0.01/s 11 21 0.01/s 12 14 0.00/s 13 22 0.01/s 14 35 0.01/s 15 32 0.01/s 16 15 0.00/s 17 14 0.00/s 18 10 0.00/s 19 8 0.00/s 20 16 0.00/s 21 10 0.00/s 22 10 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Jul 17 00 8 1h22s 1h8s 01 14 1h36s 1h33s 02 8 1h22s 1h18s 03 21 25m51s 25m50s 04 8 1h3m 1h2m55s 05 9 1h40s 58m49s 06 8 56m53s 56m42s 07 15 56m48s 54m5s 08 26 46m41s 44m28s 09 25 53m41s 52m18s 10 34 34m39s 33m26s 11 24 49m55s 48m43s 12 18 1h4m18s 1h3m34s 13 16 1h15m31s 1h14m13s 14 34 39m1s 37m55s 15 34 37m39s 36m39s 16 21 56m16s 55m8s 17 14 57m8s 56m19s 18 15 56m52s 56m10s 19 9 1h38s 59m31s 20 12 41m36s 39m46s 21 11 1h16s 59m19s 22 12 56m20s 55m4s 23 15 38m57s 36m25s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-07-17 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 412 connections Total
Connections per user
Key values
- intelifix Main User
- 412 connections Total
-
Sessions
Simultaneous sessions
Key values
- 20 sessions Session Peak
- 2026-07-17 15:01:25 Date
Histogram of session times
Key values
- 306 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 411 sessions Total
Sessions per user
Key values
- intelifix Main User
- 411 sessions Total
Sessions per host
Key values
- [local] Main Host
- 411 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 411 sessions Total
Application Count Total Duration Average Duration [unknown] 341 12d20h40m16s 54m18s pgAdmin 4 - CONN:4065845 1 20m28s 20m28s pgAdmin 4 - CONN:511991 1 3h9m23s 3h9m23s pgAdmin 4 - CONN:5717440 2 6s9ms 3s4ms pgAdmin 4 - CONN:6741279 2 1m30s 45s386ms pgAdmin 4 - CONN:7258825 3 4s849ms 1s616ms pgAdmin 4 - CONN:7510069 5 12s829ms 2s565ms pgAdmin 4 - CONN:7701669 1 45s417ms 45s417ms pgAdmin 4 - CONN:8852883 1 28s171ms 28s171ms pgAdmin 4 - CONN:9879588 1 34s985ms 34s985ms pgAdmin 4 - DB:brasilia 2 37s314ms 18s657ms pgAdmin 4 - DB:contagem 2 47s845ms 23s922ms pgAdmin 4 - DB:postgres 4 2h35m51s 38m57s pgAdmin 4 - DB:rio 5 3h36m13s 43m14s pg_dump 19 48m56s 2m34s postgres_fdw 1 34m59s 34m59s psql 20 20h33m45s 1h1m41s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 14,493 buffers Checkpoint Peak
- 2026-07-17 08:04:37 Date
- 270.003 seconds Highest write time
- 0.204 seconds Sync time
Checkpoints Wal files
Key values
- 17 files Wal files usage Peak
- 2026-07-17 08:34:37 Date
Checkpoints distance
Key values
- 529.02 Mo Distance Peak
- 2026-07-17 08:34:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 17 00 19,442 638.294s 0.074s 638.42s 01 2,345 235.742s 0.083s 235.891s 02 1,791 180.072s 0.06s 180.171s 03 1,743 174.276s 0.069s 174.392s 04 1,868 187.599s 0.058s 187.698s 05 10,264 961.389s 0.1s 961.564s 06 8,084 475.053s 0.047s 475.141s 07 48,897 2,812.945s 0.544s 2,813.698s 08 110,678 3,220.654s 0.706s 3,221.681s 09 64,527 3,238.457s 0.855s 3,239.57s 10 67,734 3,238.509s 0.974s 3,239.743s 11 50,674 3,177.768s 0.61s 3,178.583s 12 15,612 1,492.283s 0.145s 1,492.534s 13 21,651 2,026.026s 0.528s 2,026.702s 14 68,863 3,238.771s 0.717s 3,239.716s 15 80,237 3,217.837s 0.536s 3,218.605s 16 42,157 2,307.556s 0.259s 2,307.951s 17 7,474 751.574s 0.148s 751.814s 18 1,024 102.975s 0.015s 103.026s 19 22 2.234s 0.006s 2.248s 20 1,719 332.63s 0.03s 332.683s 21 2,831 284.185s 0.083s 284.352s 22 2,041 205.101s 0.063s 205.379s 23 376 38.296s 0.012s 38.334s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 17 00 0 0 7 481 0.008s 0.006s 01 0 0 1 620 0.007s 0.012s 02 0 0 0 476 0.008s 0.006s 03 0 0 1 351 0.007s 0.007s 04 0 0 0 435 0.008s 0.006s 05 0 0 5 939 0.006s 0.009s 06 0 0 1 325 0.006s 0.006s 07 0 0 35 5,178 0.004s 0.012s 08 0 0 88 7,160 0.017s 0.012s 09 0 0 30 8,034 0.006s 0.012s 10 0 0 40 7,680 0.010s 0.012s 11 0 0 23 6,206 0.009s 0.012s 12 0 0 4 2,434 0.009s 0.012s 13 0 0 14 5,363 0.007s 0.012s 14 0 0 46 7,490 0.011s 0.012s 15 0 0 42 7,023 0.011s 0.012s 16 0 0 28 3,347 0.009s 0.011s 17 0 0 2 1,828 0.008s 0.011s 18 0 0 0 110 0.003s 0.008s 19 0 0 0 4 0.004s 0.002s 20 0 0 2 92 0.009s 0.003s 21 0 0 1 467 0.019s 0.013s 22 0 0 0 410 0.008s 0.007s 23 0 0 0 30 0.003s 0.004s Day Hour Count Avg time (sec) Jul 17 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 17 00 17,546.33 kB 52,566.67 kB 01 1,087.45 kB 26,179.73 kB 02 1,560.50 kB 11,093.00 kB 03 1,390.71 kB 2,722.86 kB 04 1,629.33 kB 2,383.50 kB 05 7,863.89 kB 17,294.89 kB 06 3,559.00 kB 12,026.00 kB 07 47,358.50 kB 79,438.00 kB 08 121,158.33 kB 225,759.00 kB 09 40,226.42 kB 119,562.17 kB 10 55,413.33 kB 134,336.83 kB 11 30,245.08 kB 77,305.50 kB 12 6,584.58 kB 32,433.17 kB 13 18,934.00 kB 29,132.08 kB 14 61,786.17 kB 86,063.17 kB 15 57,712.50 kB 98,987.33 kB 16 41,511.09 kB 89,881.64 kB 17 3,442.73 kB 44,582.18 kB 18 662.17 kB 18,714.67 kB 19 173.00 kB 12,771.00 kB 20 8,003.00 kB 17,433.33 kB 21 1,258.18 kB 9,317.82 kB 22 1,620.14 kB 4,479.29 kB 23 203.50 kB 2,962.00 kB -
Temporary Files
Size of temporary files
Key values
- 471.66 MiB Temp Files size Peak
- 2026-07-17 05:31:55 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-17 05:32:01 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 17 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.66 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 2 338.06 MiB 169.03 MiB 10 2 208.00 MiB 104.00 MiB 11 1 156.01 MiB 156.01 MiB 12 0 0 0 13 1 156.00 MiB 156.00 MiB 14 0 0 0 15 1 156.01 MiB 156.01 MiB 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 916.10 MiB 70.34 MiB 235.83 MiB 114.51 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-17 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-17 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 5 806.08 MiB 156.00 MiB 182.01 MiB 161.22 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01562);
Date: 2026-07-17 09:28:14 Duration: 2m2s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01563);
Date: 2026-07-17 09:55:08 Duration: 1m47s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01566);
Date: 2026-07-17 15:15:34 Duration: 1m38s Database: contagem User: intelifix Remote: [local] Application: psql
3 2 208.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027223, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 10:11:58 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027233, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 14:21:48 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027226, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 11:13:51 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 2 180.47 MiB 90.23 MiB 90.23 MiB 90.23 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-17 05:30:41 Duration: 38s428ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-17 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 235.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 235.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01562);[ Date: 2026-07-17 09:28:12 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 156.05 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01563);[ Date: 2026-07-17 09:55:01 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01564);[ Date: 2026-07-17 11:38:30 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01566);[ Date: 2026-07-17 15:15:32 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 156.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01565);[ Date: 2026-07-17 13:48:32 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
8 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-17 10:15:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-17 10:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 90.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-17 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 90.23 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-17 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 77.84 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 77.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 77.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 70.41 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 70.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 70.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-17 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0.63 sec Highest CPU-cost vacuum
Table public.nf_entrada_arquivo_erros
Database rio - 2026-07-17 10:18:10 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 0.63 sec Highest CPU-cost vacuum
Table public.nf_entrada_arquivo_erros
Database rio - 2026-07-17 10:18:10 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (109) Main table analyzed (database rio)
- 1,026 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 109 rio.pg_catalog.pg_class 61 rio.pg_catalog.pg_type 53 rio.public.usuarios 47 brasilia.pg_catalog.pg_attribute 44 contagem.pg_catalog.pg_attribute 43 rio.public.temp0000285654 41 rio.public.temp0000285672 39 rio.pg_catalog.pg_index 38 rio.pg_catalog.pg_depend 29 contagem.public.usuarios 29 brasilia.pg_catalog.pg_class 25 contagem.public.temp0000226658 24 contagem.pg_catalog.pg_class 22 brasilia.pg_catalog.pg_type 20 rio.public.temp0000285744 20 contagem.pg_catalog.pg_type 19 rio.public.temp0000285728 19 rio.public.temp0000284750 17 contagem.public.temp0000226620 17 rio.public.temp0000285644 16 brasilia.public.temp0000236396 14 contagem.pg_catalog.pg_index 13 rio.public.temp0000285664 13 brasilia.pg_catalog.pg_index 13 rio.public.temp0000285658 12 rio.public.temp0000285648 11 rio.public.temp0000285748 11 rio.public.temp0000285726 11 rio.public.temp0000285576 11 rio.public.temp0000285722 11 rio.public.temp0000285638 9 contagem.pg_catalog.pg_depend 9 brasilia.public.usuarios 9 brasilia.pg_catalog.pg_depend 8 rio.public.temp0000285650 8 rio.public.temp0000285656 7 rio.public.temp0000285404 7 rio.public.temp0000285762 7 contagem.public.temp0000226612 6 rio.public.temp0000285674 6 brasilia.pg_catalog.pg_shdepend 6 rio.public.temp0000285020 5 rio.public.temp0000285704 5 rio.public.temp0000285642 5 rio.public.temp0000285758 5 brasilia.public.temp0000236392 4 contagem.public.nf_entrada 4 rio.public.tmp_drill_0302 3 rio.public.temp0000285708 3 brasilia.public.temp0000236340 3 brasilia.public.temp0000236336 3 contagem.pg_catalog.pg_shdepend 3 rio.public.temp0000285712 3 rio.public.temp0000285730 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000285732 2 rio.public.temp0000285682 2 rio.public.temp0000285282 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000285772 2 brasilia.public.nf_entrada 2 rio.public.temp0000285696 2 rio.public.temp0000285756 2 rio.public.temp0000285736 1 rio.public.temp0000285686 1 brasilia.public.temp0000236418 1 contagem.public.parametros 1 rio.public.temp0000285738 1 brasilia.public.temp0000236370 1 brasilia.public.temp0000236350 1 rio.public.temp0000285652 1 brasilia.public.temp0000236398 1 rio.public.temp0000285720 1 rio.public.temp0000285678 1 rio.public.temp0000284984 1 brasilia.public.temp0000236344 1 brasilia.public.temp0000236334 1 rio.public.temp0000285692 1 rio.public.temp0000285680 1 rio.public.temp0000285724 1 rio.pg_catalog.pg_shdepend 1 rio.public.temp0000285690 1 rio.public.temp0000285766 1 brasilia.public.temp0000236384 1 rio.public.temp0000285668 1 brasilia.public.temp0000236386 1 rio.public.temp0000285634 1 Total 1,026 Vacuums per table
Key values
- pg_catalog.pg_attribute (52) Main table vacuumed on database rio
- 508 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 52 40 0 0 0 0 0 23,285 6,437 9,429,932 358 8,569 rio.public.temp0000285672 40 0 0 0 0 0 0 22,168 2,140 4,019,446 0 0 rio.pg_catalog.pg_class 40 27 0 0 0 0 0 5,557 1,720 2,586,699 91 375 rio.pg_catalog.pg_type 31 23 0 0 0 0 0 2,322 666 951,584 54 167 contagem.public.usuarios 29 0 0 0 0 0 0 130 93 52,954 1 1 rio.public.temp0000285654 26 0 0 0 0 0 0 5,783 137 361,851 0 0 rio.public.temp0000285744 20 0 0 0 0 0 0 21,629 8,366 11,937,184 0 0 rio.public.temp0000284750 17 0 0 0 0 0 0 1,213 309 456,082 0 0 contagem.pg_catalog.pg_attribute 17 17 0 0 0 0 0 9,996 2,435 4,567,967 28 729 contagem.public.temp0000226658 17 0 0 0 0 0 0 1,256 292 418,272 0 0 rio.pg_catalog.pg_index 15 15 0 0 0 0 0 1,118 318 274,307 62 117 brasilia.pg_catalog.pg_attribute 13 13 0 0 0 0 0 6,488 1,766 2,816,282 53 1,145 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,457 1,663 2,493,592 90 964 rio.public.temp0000285658 12 0 0 0 0 0 0 994 171 253,982 0 0 rio.public.temp0000285748 11 0 0 0 0 0 0 11,651 3,358 4,955,635 0 0 rio.public.temp0000285576 10 0 0 0 0 0 0 5,007 33 300,988 0 0 rio.public.temp0000285728 9 0 0 0 0 0 0 5,641 246 733,826 0 0 rio.public.usuarios 9 4 0 0 0 0 0 129 41 83,111 2 4 contagem.pg_catalog.pg_class 8 8 0 0 0 0 0 1,424 246 403,430 7 14 template1.pg_catalog.pg_shdepend 8 8 0 0 0 0 0 1,350 453 923,468 144 407 rio.public.temp0000285404 7 0 0 0 0 0 0 535 208 331,091 0 0 contagem.pg_catalog.pg_type 7 7 0 0 0 0 0 762 236 364,143 5 24 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,720 2,387 10,908,290 972 4,697 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,370 452 747,723 22 66 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 415 126 201,273 11 40 rio.public.temp0000285758 5 0 0 0 0 0 0 8,307 1,678 2,623,587 0 0 rio.public.temp0000285020 5 0 0 0 0 0 0 330 142 221,892 0 0 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 236 65 59,638 2 2 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,424 373 764,428 4 30 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 241 70 60,226 17 27 rio.public.tmp_drill_0302 4 2 0 0 0 0 0 256 8 50,176 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,855 418 2,182,295 145 419 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 955 309 451,081 18 268 rio.public.temp0000285730 3 0 0 0 0 0 0 4,986 12 295,983 0 0 rio.public.temp0000285722 3 0 0 0 0 0 0 306 18 20,824 0 0 rio.public.temp0000285712 3 0 0 0 0 0 0 1,669 10 100,150 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 324 72 328,640 33 72 rio.public.temp0000285650 2 0 0 0 0 0 0 1,752 10 104,893 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,812 125 563,041 101 891 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 311 46 183,598 17 45 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,021 417 1,669,985 325 2,274 rio.public.temp0000285772 2 0 0 0 0 0 0 3,324 8 197,322 0 0 rio.public.temp0000285704 2 0 0 0 0 0 0 153 151 248,599 0 0 rio.public.temp0000285696 1 0 0 0 0 0 0 77 6 5,431 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 206 76 167,205 1 2 rio.public.temp0000285690 1 0 0 0 0 0 0 76 6 5,364 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 118 47 72,238 9 16 rio.public.temp0000285724 1 0 0 0 0 0 0 106 6 7,209 0 0 rio.public.temp0000285680 1 0 0 0 0 0 0 93 91 176,053 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 1,433 1,100 3,053,318 111 5,124 rio.public.temp0000285668 1 0 0 0 0 0 0 92 6 6,352 0 0 rio.public.temp0000285756 1 0 0 0 0 0 0 8 6 3,716 0 0 rio.public.temp0000285282 1 0 0 0 0 0 0 8 5 1,292 0 0 rio.public.temp0000285682 1 0 0 0 0 0 0 93 6 6,411 0 0 rio.public.temp0000285738 1 0 0 0 0 0 0 107 6 7,265 0 0 contagem.public.parametros 1 1 0 0 0 0 0 115 53 15,655 1 1 rio.public.temp0000285686 1 0 0 0 0 0 0 97 6 6,659 0 0 rio.public.temp0000285736 1 0 0 0 0 0 0 107 6 7,267 0 0 rio.public.temp0000284984 1 0 0 0 0 0 0 145 6 9,553 0 0 rio.public.temp0000285720 1 0 0 0 0 0 0 92 6 6,340 0 0 rio.public.temp0000285678 1 0 0 0 0 0 0 93 6 6,414 0 0 Total 508 230 0 0 0 0 0 179,728 39,675 74,263,212 2,684 26,490 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (3.17) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.17 rio.public.temp0000285672 0 0 1.17 rio.pg_catalog.pg_class 0 0 0.94 rio.pg_catalog.pg_type 0 0 0.37 contagem.public.usuarios 0 0 0 rio.public.temp0000285654 0 0 0.53 rio.public.temp0000285744 0 0 1.18 rio.public.temp0000284750 0 0 0.28 contagem.pg_catalog.pg_attribute 0 0 1.27 contagem.public.temp0000226658 0 0 0.35 rio.pg_catalog.pg_index 0 0 0.27 brasilia.pg_catalog.pg_attribute 0 0 1.14 rio.pg_catalog.pg_depend 0 0 0.92 rio.public.temp0000285658 0 0 0.15 rio.public.temp0000285748 0 0 0.6 rio.public.temp0000285576 0 0 0.49 rio.public.temp0000285728 0 0 0.31 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_class 0 0 0.26 template1.pg_catalog.pg_shdepend 0 0 0.25 rio.public.temp0000285404 0 0 0.12 contagem.pg_catalog.pg_type 0 0 0.14 rio.pg_catalog.pg_statistic 0 0 1.3 brasilia.pg_catalog.pg_class 0 0 0.27 brasilia.pg_catalog.pg_type 0 0 0.08 rio.public.temp0000285758 0 0 0.3 rio.public.temp0000285020 0 0 0.08 contagem.pg_catalog.pg_index 0 0 0.17 contagem.pg_catalog.pg_depend 0 0 0.19 brasilia.pg_catalog.pg_index 0 0 0.05 rio.public.tmp_drill_0302 0 0 0.02 rio.pg_toast.pg_toast_2619 0 0 0.18 brasilia.pg_catalog.pg_depend 0 0 0.2 rio.public.temp0000285730 0 0 0.14 rio.public.temp0000285722 0 0 0.05 rio.public.temp0000285712 0 0 0.16 brasilia.pg_toast.pg_toast_2619 0 0 0.03 rio.public.temp0000285650 0 0 0.06 contagem.pg_catalog.pg_statistic 0 0 0.15 contagem.pg_toast.pg_toast_2619 0 0 0.02 brasilia.pg_catalog.pg_statistic 0 0 0.26 rio.public.temp0000285772 0 0 0.08 rio.public.temp0000285704 0 0 0.04 rio.public.temp0000285696 0 0 0.02 brasilia.public.nf_entrada 0 0 0.05 rio.public.temp0000285690 0 0 0.02 rio.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000285724 0 0 0.02 rio.public.temp0000285680 0 0 0.02 rio.public.nf_entrada_arquivo_erros 0 0 0.63 rio.public.temp0000285668 0 0 0.01 rio.public.temp0000285756 0 0 0.02 rio.public.temp0000285282 0 0 0.02 rio.public.temp0000285682 0 0 0.02 rio.public.temp0000285738 0 0 0.01 contagem.public.parametros 0 0 0.05 rio.public.temp0000285686 0 0 0.02 rio.public.temp0000285736 0 0 0.02 rio.public.temp0000284984 0 0 0.02 rio.public.temp0000285720 0 0 0.02 rio.public.temp0000285678 0 0 0.01 Total 0 0 18.74 Tuples removed per table
Key values
- pg_catalog.pg_attribute (176749) Main table with removed tuples on database rio
- 370248 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 52 40 176,749 1,313,225 109,672 353 31,707 contagem.pg_catalog.pg_attribute 17 17 62,880 405,161 162 211 9,180 brasilia.pg_catalog.pg_attribute 13 13 52,483 284,522 749 88 7,240 rio.pg_catalog.pg_statistic 7 7 12,576 59,356 119 0 9,002 rio.pg_catalog.pg_depend 13 13 10,704 248,274 2,452 0 2,431 rio.pg_catalog.pg_type 31 23 8,519 78,009 6,748 18 2,224 contagem.pg_catalog.pg_statistic 2 2 5,393 14,832 0 0 2,022 template1.pg_catalog.pg_shdepend 8 8 5,158 109,468 777 0 920 brasilia.pg_catalog.pg_statistic 2 2 5,010 15,288 0 0 2,144 rio.pg_catalog.pg_index 15 15 4,408 29,281 391 0 915 rio.pg_catalog.pg_class 40 27 4,189 160,219 21,860 71 4,945 brasilia.pg_catalog.pg_depend 3 3 3,115 54,151 0 0 531 contagem.pg_catalog.pg_type 7 7 2,561 15,753 10 23 450 contagem.pg_catalog.pg_class 8 8 2,119 27,038 0 15 976 rio.public.tmp_drill_0302 4 2 1,887 29,460 13,004 0 421 contagem.pg_catalog.pg_depend 5 5 1,858 93,959 0 0 875 contagem.public.usuarios 29 0 1,768 667 0 0 58 brasilia.pg_catalog.pg_type 6 6 1,493 13,296 0 7 357 brasilia.pg_catalog.pg_index 5 5 1,252 9,428 35 0 265 brasilia.pg_catalog.pg_class 7 7 1,188 23,809 169 11 899 brasilia.public.nf_entrada 1 1 1,125 3,754 0 0 152 rio.pg_toast.pg_toast_2619 4 4 1,122 2,293 17 0 1,124 contagem.pg_catalog.pg_index 5 5 974 9,485 0 8 239 rio.pg_catalog.pg_shdepend 1 1 963 13,850 240 0 115 contagem.pg_toast.pg_toast_2619 2 2 215 230 0 0 124 rio.public.usuarios 9 4 209 6,016 1,435 0 144 brasilia.pg_toast.pg_toast_2619 2 2 202 276 0 16 104 rio.public.nf_entrada_arquivo_erros 1 0 104 8,514,120 0 0 152,739 contagem.public.parametros 1 1 24 384 0 3 49 rio.public.temp0000285728 9 0 0 87,263 0 160 5,600 rio.public.temp0000285672 40 0 0 395,830 0 904 27,256 rio.public.temp0000285696 1 0 0 1,211 0 59 69 rio.public.temp0000285404 7 0 0 25,043 0 241 559 rio.public.temp0000285744 20 0 0 467,822 0 0 33,280 rio.public.temp0000285690 1 0 0 3,068 0 60 68 rio.public.temp0000285724 1 0 0 1,888 0 30 98 rio.public.temp0000285680 1 0 0 1,719 0 43 85 rio.public.temp0000284750 17 0 0 52,177 0 592 1,328 rio.public.temp0000285730 3 0 0 70,202 0 0 4,992 rio.public.temp0000285722 3 0 0 12,607 0 102 282 rio.public.temp0000285576 10 0 0 233,598 0 0 16,640 rio.public.temp0000285712 3 0 0 70,134 0 0 4,992 rio.public.temp0000285650 2 0 0 25,085 0 44 1,748 rio.public.temp0000285668 1 0 0 1,715 0 44 84 rio.public.temp0000285758 5 0 0 116,952 0 0 8,320 rio.public.temp0000285756 1 0 0 4,854 0 19 109 rio.public.temp0000285654 26 0 0 133,492 0 627 7,981 rio.public.temp0000285282 1 0 0 1,311 0 54 74 rio.public.temp0000285682 1 0 0 1,719 0 43 85 rio.public.temp0000285738 1 0 0 1,888 0 29 99 rio.public.temp0000285020 5 0 0 16,251 0 213 363 rio.public.temp0000285686 1 0 0 1,778 0 39 89 rio.public.temp0000285736 1 0 0 1,888 0 29 99 rio.public.temp0000285772 2 0 0 46,802 0 0 3,328 rio.public.temp0000284984 1 0 0 6,093 0 55 137 rio.public.temp0000285720 1 0 0 3,764 0 44 84 rio.public.temp0000285678 1 0 0 1,717 0 43 85 rio.public.temp0000285704 2 0 0 6,135 0 119 137 rio.public.temp0000285748 11 0 0 257,367 0 0 18,304 rio.public.temp0000285658 12 0 0 42,290 0 259 989 contagem.public.temp0000226658 17 0 0 21,852 0 507 1,605 Total 508 230 370,248 13,651,119 157,840 5,183 371,321 Pages removed per table
Key values
- public.temp0000285672 (904) Main table with removed pages on database rio
- 5183 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000285672 40 0 0 904 rio.public.temp0000285654 26 0 0 627 rio.public.temp0000284750 17 0 0 592 contagem.public.temp0000226658 17 0 0 507 rio.pg_catalog.pg_attribute 52 40 176749 353 rio.public.temp0000285658 12 0 0 259 rio.public.temp0000285404 7 0 0 241 rio.public.temp0000285020 5 0 0 213 contagem.pg_catalog.pg_attribute 17 17 62880 211 rio.public.temp0000285728 9 0 0 160 rio.public.temp0000285704 2 0 0 119 rio.public.temp0000285722 3 0 0 102 brasilia.pg_catalog.pg_attribute 13 13 52483 88 rio.pg_catalog.pg_class 40 27 4189 71 rio.public.temp0000285690 1 0 0 60 rio.public.temp0000285696 1 0 0 59 rio.public.temp0000284984 1 0 0 55 rio.public.temp0000285282 1 0 0 54 rio.public.temp0000285650 2 0 0 44 rio.public.temp0000285668 1 0 0 44 rio.public.temp0000285720 1 0 0 44 rio.public.temp0000285680 1 0 0 43 rio.public.temp0000285682 1 0 0 43 rio.public.temp0000285678 1 0 0 43 rio.public.temp0000285686 1 0 0 39 rio.public.temp0000285724 1 0 0 30 rio.public.temp0000285738 1 0 0 29 rio.public.temp0000285736 1 0 0 29 contagem.pg_catalog.pg_type 7 7 2561 23 rio.public.temp0000285756 1 0 0 19 rio.pg_catalog.pg_type 31 23 8519 18 brasilia.pg_toast.pg_toast_2619 2 2 202 16 contagem.pg_catalog.pg_class 8 8 2119 15 brasilia.pg_catalog.pg_class 7 7 1188 11 contagem.pg_catalog.pg_index 5 5 974 8 brasilia.pg_catalog.pg_type 6 6 1493 7 contagem.public.parametros 1 1 24 3 contagem.public.usuarios 29 0 1768 0 rio.public.temp0000285744 20 0 0 0 brasilia.public.nf_entrada 1 1 1125 0 rio.pg_catalog.pg_shdepend 1 1 963 0 brasilia.pg_catalog.pg_depend 3 3 3115 0 rio.public.nf_entrada_arquivo_erros 1 0 104 0 rio.public.temp0000285730 3 0 0 0 rio.pg_catalog.pg_statistic 7 7 12576 0 rio.public.temp0000285576 10 0 0 0 rio.public.temp0000285712 3 0 0 0 rio.public.temp0000285758 5 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5393 0 rio.public.usuarios 9 4 209 0 contagem.pg_toast.pg_toast_2619 2 2 215 0 rio.public.tmp_drill_0302 4 2 1887 0 rio.pg_catalog.pg_depend 13 13 10704 0 brasilia.pg_catalog.pg_statistic 2 2 5010 0 rio.pg_toast.pg_toast_2619 4 4 1122 0 rio.public.temp0000285772 2 0 0 0 contagem.pg_catalog.pg_depend 5 5 1858 0 brasilia.pg_catalog.pg_index 5 5 1252 0 template1.pg_catalog.pg_shdepend 8 8 5158 0 rio.pg_catalog.pg_index 15 15 4408 0 rio.public.temp0000285748 11 0 0 0 Total 508 230 370,248 5,183 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 17 00 0 0 01 0 3 02 0 0 03 0 0 04 0 1 05 6 10 06 1 2 07 60 100 08 69 147 09 70 156 10 45 106 11 42 110 12 2 9 13 36 78 14 77 120 15 65 119 16 32 44 17 3 17 18 0 0 19 0 0 20 0 0 21 0 4 22 0 0 23 0 0 - 0.63 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000285672;-
DROP TABLE IF EXISTS temp0000285672;
Date: 2026-07-17 07:42:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285672;
Date: 2026-07-17 08:48:08 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285672;
Date: 2026-07-17 07:42:43 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1s 1s 1s 1s drop table if exists temp0000285728;-
DROP TABLE IF EXISTS temp0000285728;
Date: 2026-07-17 13:42:11 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285728;
Date: 2026-07-17 13:42:11 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s 1s 1s 1s drop table if exists temp0000285744;-
DROP TABLE IF EXISTS temp0000285744;
Date: 2026-07-17 14:59:12 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285744;
Date: 2026-07-17 14:59:12 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s1ms DROP TABLE IF EXISTS temp0000285672;[ Date: 2026-07-17 07:42:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 1s DROP TABLE IF EXISTS temp0000285728;[ Date: 2026-07-17 13:42:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s DROP TABLE IF EXISTS temp0000285744;[ Date: 2026-07-17 14:59:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,227 Total read queries
- 1,479 Total write queries
Queries by database
Key values
- rio Main database
- 4,101 Requests
- 5h50m (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,237 1h39m33s copy to 140 11m1s ddl 230 2m8s others 190 6m9s select 677 1h20m13s contagem Total 851 22m55s copy to 144 2m6s ddl 102 48s873ms others 6 2m38s select 599 17m21s rio Total 4,101 5h50m copy to 153 34m51s ddl 709 48m54s others 287 29m22s select 2,951 3h56m51s update 1 1s156ms Queries by user
Key values
- intelifix Main user
- 6,035 Requests
User Request type Count Duration etiquetas Total 32 8s603ms select 32 8s603ms intelifix Total 6,035 7h50m13s copy to 437 48m ddl 1,036 51m50s others 483 38m10s select 4,079 5h32m11s lenon Total 122 2m8s ddl 5 1s133ms select 116 2m5s update 1 1s156ms Duration by user
Key values
- 7h50m13s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 32 8s603ms select 32 8s603ms intelifix Total 6,035 7h50m13s copy to 437 48m ddl 1,036 51m50s others 483 38m10s select 4,079 5h32m11s lenon Total 122 2m8s ddl 5 1s133ms select 116 2m5s update 1 1s156ms Queries by host
Key values
- [local] Main host
- 6,177 Requests
- 7h51m35s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,019 Requests
- 4h17m28s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 5,019 2h46m4s ddl 1,036 51m50s select 3,983 1h54m13s pgAdmin 4 - CONN:4065845 Total 1 20s682ms select 1 20s682ms pgAdmin 4 - CONN:511991 Total 8 33s489ms ddl 2 506ms select 5 31s826ms update 1 1s156ms pgAdmin 4 - CONN:7510069 Total 1 182ms ddl 1 182ms pgAdmin 4 - CONN:8852883 Total 1 224ms ddl 1 224ms pgAdmin 4 - CONN:9879588 Total 1 219ms ddl 1 219ms pg_dump Total 447 48m2s copy to 437 48m select 10 2s95ms psql Total 711 4h17m28s others 483 38m10s select 228 3h39m18s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-17 09:01:44 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,296 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 10:14:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 08:14:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 15:14:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 22:14:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 16:13:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 07:13:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m12s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 09:13:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m4s analyze verbose;[ Date: 2026-07-17 05:08:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 14:12:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 20:12:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 11:12:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 12:11:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m49s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027223, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-17 10:11:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 13:11:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 17:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m50s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027233, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-17 14:21:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 21:10:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 19:10:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m36s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-17 18:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027226, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-17 11:13:51 - 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 2h7m30s 48 1s380ms 9m11s 2m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 07 3 9m11s 3m3s 08 3 9m39s 3m13s 09 3 8m51s 2m57s 10 3 9m50s 3m16s 11 3 7m46s 2m35s 12 3 7m13s 2m24s 13 3 6m38s 2m12s 14 3 8m31s 2m50s 15 3 9m31s 3m10s 16 3 9m2s 3m 17 3 6m8s 2m2s 18 3 5m56s 1m58s 19 3 5m55s 1m58s 20 3 7m35s 2m31s 21 3 5m55s 1m58s 22 3 9m41s 3m13s [ User: intelifix - Total duration: 2h7m30s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 10:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 08:14:04 Duration: 9m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 15:14:02 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: psql
2 1h16m16s 47 276ms 5m2s 1m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 07 3 5m13s 1m44s 08 3 5m47s 1m55s 09 3 5m59s 1m59s 10 3 6m11s 2m3s 11 3 5m45s 1m55s 12 3 4m1s 1m20s 13 3 4m9s 1m23s 14 3 5m10s 1m43s 15 3 4m47s 1m35s 16 3 4m39s 1m33s 17 3 3m57s 1m19s 18 3 3m50s 1m16s 19 3 3m40s 1m13s 20 3 4m28s 1m29s 21 3 3m42s 1m14s 22 2 4m52s 2m26s [ User: intelifix - Total duration: 1h16m16s - Times executed: 47 ]
[ Application: psql - Total duration: 1h16m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 10:20:55 Duration: 5m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 09:19:40 Duration: 5m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 11:18:26 Duration: 4m43s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1h9m35s 303 153ms 6m49s 13s779ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 07 36 11m29s 19s158ms 08 41 21m17s 31s164ms 09 32 1m46s 3s330ms 10 39 9m22s 14s410ms 11 27 6m25s 14s261ms 12 4 2s36ms 509ms 13 18 26s511ms 1s472ms 14 52 7m43s 8s916ms 15 27 6m10s 13s719ms 16 22 4m43s 12s908ms 17 5 7s440ms 1s488ms [ User: intelifix - Total duration: 1h9m35s - Times executed: 303 ]
[ Application: [unknown] - Total duration: 1h9m35s - Times executed: 303 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027223, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 10:11:58 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027233, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 14:21:48 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027226, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 11:13:51 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 18m56s 1,309 150ms 4s975ms 868ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 17 06 1 861ms 861ms 07 88 1m5s 743ms 08 166 2m45s 994ms 09 230 2m53s 756ms 10 182 2m52s 948ms 11 113 1m35s 841ms 12 38 31s635ms 832ms 13 111 1m21s 735ms 14 159 2m18s 873ms 15 170 2m51s 1s10ms 16 46 36s183ms 786ms 17 5 3s619ms 723ms [ User: intelifix - Total duration: 18m56s - Times executed: 1309 ]
[ Application: [unknown] - Total duration: 18m56s - Times executed: 1309 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47539, 407, '73900285850063604733,229638345568,229776466466,229709127178,229880697985,216923999311,229799268893,229823272337,216924344249,229822938184,229826053450,229833075560,229830976062,229834065062,229715575159,216930868500,229678440122,229826155154,229764668503,229826595758,229710388503,229646223352,229694796666,216925444648,229822226970,229707435880,229828292838,216927164558,229699877375,229822727075,229731282641,229640558488,229801289090,229639430310,229700636776,229677007388,229830775156,216949473649', '246448904971,246577195673,246540389006,246188641827,246431226971,246617028708,246622255671,246441086890,246625765475,226028425965,246066413052,246638546677,246207080518,246529078901,246446066377,246490710421,246634709917,246561869294,246633911826,246542615059,246466607495,246500450103,246450166777,246613538805,246541931626,246634704361,246451834763,246512092137,246625388389,246563997785,246448584760,246626360517,246446823657,246516782325,246460313447,246435210717,', 0137, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-17 08:42:36 Duration: 4s975ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47578, 418, '835135920002723,241676663234,241671993553,241679910207,241695585260,241676633759,241704374457,241703818184,241704268688,241663849301,241704257778,241654362326,241714931728,241629525356,241597540911,241714926070,241680315577,241713716670,241728730516,241604788700,241649653651,241695594049,241695611223,241646327175,241605360204,241659722939,241622547189,241599300522,241598814761,241656687681,241727021415', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-17 10:19:52 Duration: 4s645ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (125809, 401, '246140110110', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-17 15:05:20 Duration: 4s548ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
5 13m57s 3 2m12s 8m4s 4m39s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 17 05 3 13m57s 4m39s [ User: intelifix - Total duration: 13m57s - Times executed: 3 ]
[ Application: psql - Total duration: 13m57s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-17 05:08:05 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-17 05:11:47 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-17 05:13:59 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
6 11m32s 265 158ms 11s889ms 2s613ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 17 00 12 32s45ms 2s670ms 01 11 29s14ms 2s637ms 02 11 27s8ms 2s455ms 03 11 27s740ms 2s521ms 04 12 28s135ms 2s344ms 05 11 27s466ms 2s496ms 06 12 26s619ms 2s218ms 07 11 32s533ms 2s957ms 08 12 38s284ms 3s190ms 09 12 38s49ms 3s170ms 10 12 39s35ms 3s252ms 11 12 30s177ms 2s514ms 12 12 25s12ms 2s84ms 13 12 26s941ms 2s245ms 14 12 36s897ms 3s74ms 15 12 29s215ms 2s434ms 16 12 27s33ms 2s252ms 17 12 25s5ms 2s83ms 18 11 26s623ms 2s420ms 19 10 25s682ms 2s568ms 20 12 40s583ms 3s381ms 21 12 28s514ms 2s376ms 22 9 25s18ms 2s779ms [ User: intelifix - Total duration: 11m32s - Times executed: 265 ]
[ Application: psql - Total duration: 11m32s - Times executed: 265 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 20:05:13 Duration: 11s889ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 14:45:19 Duration: 10s895ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 10:15:16 Duration: 10s170ms Database: rio User: intelifix Remote: [local] Application: psql
7 9m38s 58 1s619ms 43s788ms 9s978ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 17 07 3 26s160ms 8s720ms 08 3 28s666ms 9s555ms 09 10 1m42s 10s213ms 10 8 2m21s 17s627ms 11 6 46s296ms 7s716ms 12 3 7s953ms 2s651ms 13 7 1m19s 11s328ms 14 7 1m28s 12s605ms 15 3 27s668ms 9s222ms 16 3 16s290ms 5s430ms 17 3 10s63ms 3s354ms 18 2 4s955ms 2s477ms [ User: intelifix - Total duration: 9m38s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 9m38s - Times executed: 58 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 10:10:23 Duration: 43s788ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 09:00:34 Duration: 31s364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 13:57:59 Duration: 30s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m36s 45 9s853ms 34s496ms 12s816ms create table temp0000285672 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 17 07 16 3m 11s304ms 08 14 3m6s 13s321ms 09 6 1m36s 16s147ms 10 6 1m19s 13s220ms 11 3 33s145ms 11s48ms [ User: intelifix - Total duration: 9m36s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 9m36s - Times executed: 45 ]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 09:36:09 Duration: 34s496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:47:41 Duration: 16s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:47:16 Duration: 15s628ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m 8 660ms 2m2s 1m7s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 17 09 2 3m49s 1m54s 11 1 1m34s 1m34s 13 1 1m33s 1m33s 15 4 2m2s 30s687ms [ User: intelifix - Total duration: 9m - Times executed: 8 ]
[ Application: psql - Total duration: 9m - Times executed: 8 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01562);
Date: 2026-07-17 09:28:14 Duration: 2m2s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01563);
Date: 2026-07-17 09:55:08 Duration: 1m47s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01566);
Date: 2026-07-17 15:15:34 Duration: 1m38s Database: contagem User: intelifix Remote: [local] Application: psql
10 8m26s 986 152ms 2s628ms 513ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 17 07 114 1m12s 639ms 08 139 1m1s 439ms 09 163 1m24s 516ms 10 135 1m15s 556ms 11 158 1m11s 449ms 13 42 17s706ms 421ms 14 141 1m8s 485ms 15 73 46s279ms 633ms 16 8 3s962ms 495ms 17 13 6s45ms 465ms [ User: intelifix - Total duration: 8m26s - Times executed: 986 ]
[ Application: [unknown] - Total duration: 8m26s - Times executed: 986 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "320", "itens" : "241598825671,241630945764,241614592429,241630937379,241604591431,241630949097,241604785669,241601115367,241595274247,241614569395,241630947380,241632296266,241599290723,241620827178,241599246980,241599279307,241622486274,241597547981,241630949502,241630940108,241614648292,241607184646,241630940209,241616875861,241617361218,241607098094,241631504966,241614609096,230040227393,241619451826,241630947986,241603755759,241604819208,241630944754,241616212834,241614654253,241616835274,241603881934,241616954657,230040221333", "usuario" : "414", "caixa" : "1298752", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-17 07:27:17 Duration: 2s628ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "267523", "modelo" : "320", "itens" : "241661341930,241595254144,241713355165,241659806280,241654549011,241599254052,241619813556,241695183852,241663827278,241659660509,241698744244,241634773355,241732793033,241660400413,241706885364,241730216283,241650584763,241616179698,241673315668,241618168603,241619414347,241631509512,241713741219,241695637689,230048590006,241599464050,241656756274,241618623552,241709239410,241660417181,241622568606,241597555457,241619723244,241657179199,241732877182,241706590712,241614611320,241671936981,241614517797,241728659194,241695108591,241680480218,241656758597,241706776060,241653959301,241634533960,241629414560,241658157084", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-17 07:03:54 Duration: 2s473ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "268034", "modelo" : "464", "itens" : "241759778292,241767021335,241759805972,241741192843,241768394364,241762108700,241740451828,241743116363,241738950122,241741205369,241759748087,241745307789,241761486787,241761083134,241768395475,241744672038,241766824951,241763749511,241739033036,241741174861,241741139807,241742352238,241761082932,241738529900,241771319610,241766232537,241747044648,241737988804,241761254161,241768340420,241743993049,241760958902,241739703135,241746427180,241748091833,241764638194,241739809105,241738941030,241760945163,241739012630,241761179507,241763832830,241742599512,241688098806,241737994966,241760124971,241763701729,241739013943,241742100822,241746415967,241743114747,241761225774,241769497086,241762238184,241762179515,241771203942,241744652642,241739009396,241739731118,241767759194", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-17 15:26:36 Duration: 2s456ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m25s 158 174ms 10s565ms 2s438ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 17 00 6 16s240ms 2s706ms 01 6 5s397ms 899ms 02 6 9s7ms 1s501ms 03 5 8s285ms 1s657ms 04 5 8s748ms 1s749ms 05 4 9s549ms 2s387ms 06 4 3s575ms 893ms 07 9 26s562ms 2s951ms 08 12 44s36ms 3s669ms 09 12 48s249ms 4s20ms 10 12 36s758ms 3s63ms 11 12 44s985ms 3s748ms 12 10 15s265ms 1s526ms 13 9 9s513ms 1s57ms 14 12 35s679ms 2s973ms 15 12 31s567ms 2s630ms 16 5 4s330ms 866ms 17 4 4s760ms 1s190ms 20 1 297ms 297ms 21 6 11s120ms 1s853ms 22 6 11s378ms 1s896ms [ User: intelifix - Total duration: 6m25s - Times executed: 158 ]
[ Application: psql - Total duration: 6m25s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 00:05:12 Duration: 10s565ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 10:35:09 Duration: 8s76ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 09:55:09 Duration: 8s20ms Database: rio User: intelifix Remote: [local] Application: psql
12 6m11s 31 9s625ms 14s618ms 11s976ms create table temp0000285654 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 17 07 11 2m8s 11s716ms 08 20 4m2s 12s119ms [ User: intelifix - Total duration: 6m11s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m11s - Times executed: 31 ]
-
CREATE TABLE temp0000285654 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:02:53 Duration: 14s618ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285654 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:16:45 Duration: 14s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285654 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:20:15 Duration: 14s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 5m59s 27 10s518ms 35s718ms 13s308ms create table temp0000285744 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 17 13 3 35s893ms 11s964ms 14 17 3m55s 13s859ms 15 7 1m27s 12s547ms [ User: intelifix - Total duration: 5m59s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m59s - Times executed: 27 ]
-
CREATE TABLE temp0000285744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:46:13 Duration: 35s718ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:41:41 Duration: 13s642ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:53:54 Duration: 13s549ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 4m19s 72 199ms 1m9s 3s610ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 17 07 14 44s890ms 3s206ms 08 24 54s227ms 2s259ms 09 2 1s30ms 515ms 10 4 1m11s 17s880ms 11 1 696ms 696ms 13 4 3s141ms 785ms 14 11 49s726ms 4s520ms 15 6 24s548ms 4s91ms 16 6 10s192ms 1s698ms [ User: intelifix - Total duration: 4m19s - Times executed: 72 ]
[ Application: psql - Total duration: 4m19s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027225);
Date: 2026-07-17 10:17:31 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027192);
Date: 2026-07-17 07:57:26 Duration: 39s137ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027195);
Date: 2026-07-17 08:00:57 Duration: 31s453ms Database: rio User: intelifix Remote: [local] Application: psql
15 3m14s 4 4s355ms 1m41s 48s662ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 17 20 2 1m28s 44s192ms 23 2 1m46s 53s133ms [ User: intelifix - Total duration: 3m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-17 23:17:51 Duration: 1m41s 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-07-17 20:09:01 Duration: 1m23s 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-07-17 20:10:46 Duration: 4s866ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 3m14s 41 3s215ms 6s282ms 4s732ms create table temp0000285672 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 17 07 8 33s827ms 4s228ms 08 12 55s487ms 4s623ms 09 21 1m44s 4s987ms [ User: intelifix - Total duration: 3m14s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 41 ]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-07-2026", "ate" :"17-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-17 08:37:34 Duration: 6s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-07-2026", "ate" :"17-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-17 09:31:16 Duration: 6s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-07-2026", "ate" :"17-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-17 09:28:37 Duration: 6s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m55s 14 10s529ms 15s717ms 12s559ms create table temp0000285576 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 17 07 4 45s680ms 11s420ms 08 10 2m10s 13s15ms [ User: intelifix - Total duration: 2m55s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 14 ]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:23:51 Duration: 15s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:24:39 Duration: 13s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:13:19 Duration: 13s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m49s 14 9s832ms 15s607ms 12s136ms create table temp0000285748 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 17 14 3 35s279ms 11s759ms 15 3 38s390ms 12s796ms 16 8 1m36s 12s30ms [ User: intelifix - Total duration: 2m49s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m49s - Times executed: 14 ]
-
CREATE TABLE temp0000285748 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 15:58:12 Duration: 15s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285748 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 16:08:05 Duration: 15s475ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285748 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 16:08:43 Duration: 15s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m26s 4 388ms 1m13s 36s571ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 17 20 2 1m12s 36s112ms 23 2 1m14s 37s29ms [ User: intelifix - Total duration: 2m26s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m26s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-17 23:14:06 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-17 20:05:54 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-17 20:10:12 Duration: 425ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2m25s 12 9s718ms 13s716ms 12s158ms create table temp0000285758 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 17 14 6 1m9s 11s504ms 15 6 1m16s 12s812ms [ User: intelifix - Total duration: 2m25s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m25s - Times executed: 12 ]
-
CREATE TABLE temp0000285758 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 15:31:00 Duration: 13s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285758 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 15:32:32 Duration: 13s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285758 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:13:12 Duration: 12s780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,309 18m56s 150ms 4s975ms 868ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 06 1 861ms 861ms 07 88 1m5s 743ms 08 166 2m45s 994ms 09 230 2m53s 756ms 10 182 2m52s 948ms 11 113 1m35s 841ms 12 38 31s635ms 832ms 13 111 1m21s 735ms 14 159 2m18s 873ms 15 170 2m51s 1s10ms 16 46 36s183ms 786ms 17 5 3s619ms 723ms [ User: intelifix - Total duration: 18m56s - Times executed: 1309 ]
[ Application: [unknown] - Total duration: 18m56s - Times executed: 1309 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47539, 407, '73900285850063604733,229638345568,229776466466,229709127178,229880697985,216923999311,229799268893,229823272337,216924344249,229822938184,229826053450,229833075560,229830976062,229834065062,229715575159,216930868500,229678440122,229826155154,229764668503,229826595758,229710388503,229646223352,229694796666,216925444648,229822226970,229707435880,229828292838,216927164558,229699877375,229822727075,229731282641,229640558488,229801289090,229639430310,229700636776,229677007388,229830775156,216949473649', '246448904971,246577195673,246540389006,246188641827,246431226971,246617028708,246622255671,246441086890,246625765475,226028425965,246066413052,246638546677,246207080518,246529078901,246446066377,246490710421,246634709917,246561869294,246633911826,246542615059,246466607495,246500450103,246450166777,246613538805,246541931626,246634704361,246451834763,246512092137,246625388389,246563997785,246448584760,246626360517,246446823657,246516782325,246460313447,246435210717,', 0137, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-17 08:42:36 Duration: 4s975ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47578, 418, '835135920002723,241676663234,241671993553,241679910207,241695585260,241676633759,241704374457,241703818184,241704268688,241663849301,241704257778,241654362326,241714931728,241629525356,241597540911,241714926070,241680315577,241713716670,241728730516,241604788700,241649653651,241695594049,241695611223,241646327175,241605360204,241659722939,241622547189,241599300522,241598814761,241656687681,241727021415', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-17 10:19:52 Duration: 4s645ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (125809, 401, '246140110110', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-17 15:05:20 Duration: 4s548ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
2 986 8m26s 152ms 2s628ms 513ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 07 114 1m12s 639ms 08 139 1m1s 439ms 09 163 1m24s 516ms 10 135 1m15s 556ms 11 158 1m11s 449ms 13 42 17s706ms 421ms 14 141 1m8s 485ms 15 73 46s279ms 633ms 16 8 3s962ms 495ms 17 13 6s45ms 465ms [ User: intelifix - Total duration: 8m26s - Times executed: 986 ]
[ Application: [unknown] - Total duration: 8m26s - Times executed: 986 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "320", "itens" : "241598825671,241630945764,241614592429,241630937379,241604591431,241630949097,241604785669,241601115367,241595274247,241614569395,241630947380,241632296266,241599290723,241620827178,241599246980,241599279307,241622486274,241597547981,241630949502,241630940108,241614648292,241607184646,241630940209,241616875861,241617361218,241607098094,241631504966,241614609096,230040227393,241619451826,241630947986,241603755759,241604819208,241630944754,241616212834,241614654253,241616835274,241603881934,241616954657,230040221333", "usuario" : "414", "caixa" : "1298752", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-17 07:27:17 Duration: 2s628ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "267523", "modelo" : "320", "itens" : "241661341930,241595254144,241713355165,241659806280,241654549011,241599254052,241619813556,241695183852,241663827278,241659660509,241698744244,241634773355,241732793033,241660400413,241706885364,241730216283,241650584763,241616179698,241673315668,241618168603,241619414347,241631509512,241713741219,241695637689,230048590006,241599464050,241656756274,241618623552,241709239410,241660417181,241622568606,241597555457,241619723244,241657179199,241732877182,241706590712,241614611320,241671936981,241614517797,241728659194,241695108591,241680480218,241656758597,241706776060,241653959301,241634533960,241629414560,241658157084", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-17 07:03:54 Duration: 2s473ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "268034", "modelo" : "464", "itens" : "241759778292,241767021335,241759805972,241741192843,241768394364,241762108700,241740451828,241743116363,241738950122,241741205369,241759748087,241745307789,241761486787,241761083134,241768395475,241744672038,241766824951,241763749511,241739033036,241741174861,241741139807,241742352238,241761082932,241738529900,241771319610,241766232537,241747044648,241737988804,241761254161,241768340420,241743993049,241760958902,241739703135,241746427180,241748091833,241764638194,241739809105,241738941030,241760945163,241739012630,241761179507,241763832830,241742599512,241688098806,241737994966,241760124971,241763701729,241739013943,241742100822,241746415967,241743114747,241761225774,241769497086,241762238184,241762179515,241771203942,241744652642,241739009396,241739731118,241767759194", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-17 15:26:36 Duration: 2s456ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 303 1h9m35s 153ms 6m49s 13s779ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 07 36 11m29s 19s158ms 08 41 21m17s 31s164ms 09 32 1m46s 3s330ms 10 39 9m22s 14s410ms 11 27 6m25s 14s261ms 12 4 2s36ms 509ms 13 18 26s511ms 1s472ms 14 52 7m43s 8s916ms 15 27 6m10s 13s719ms 16 22 4m43s 12s908ms 17 5 7s440ms 1s488ms [ User: intelifix - Total duration: 1h9m35s - Times executed: 303 ]
[ Application: [unknown] - Total duration: 1h9m35s - Times executed: 303 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027223, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 10:11:58 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027233, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 14:21:48 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027226, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 11:13:51 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 265 11m32s 158ms 11s889ms 2s613ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 17 00 12 32s45ms 2s670ms 01 11 29s14ms 2s637ms 02 11 27s8ms 2s455ms 03 11 27s740ms 2s521ms 04 12 28s135ms 2s344ms 05 11 27s466ms 2s496ms 06 12 26s619ms 2s218ms 07 11 32s533ms 2s957ms 08 12 38s284ms 3s190ms 09 12 38s49ms 3s170ms 10 12 39s35ms 3s252ms 11 12 30s177ms 2s514ms 12 12 25s12ms 2s84ms 13 12 26s941ms 2s245ms 14 12 36s897ms 3s74ms 15 12 29s215ms 2s434ms 16 12 27s33ms 2s252ms 17 12 25s5ms 2s83ms 18 11 26s623ms 2s420ms 19 10 25s682ms 2s568ms 20 12 40s583ms 3s381ms 21 12 28s514ms 2s376ms 22 9 25s18ms 2s779ms [ User: intelifix - Total duration: 11m32s - Times executed: 265 ]
[ Application: psql - Total duration: 11m32s - Times executed: 265 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 20:05:13 Duration: 11s889ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 14:45:19 Duration: 10s895ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 10:15:16 Duration: 10s170ms Database: rio User: intelifix Remote: [local] Application: psql
5 158 6m25s 174ms 10s565ms 2s438ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 17 00 6 16s240ms 2s706ms 01 6 5s397ms 899ms 02 6 9s7ms 1s501ms 03 5 8s285ms 1s657ms 04 5 8s748ms 1s749ms 05 4 9s549ms 2s387ms 06 4 3s575ms 893ms 07 9 26s562ms 2s951ms 08 12 44s36ms 3s669ms 09 12 48s249ms 4s20ms 10 12 36s758ms 3s63ms 11 12 44s985ms 3s748ms 12 10 15s265ms 1s526ms 13 9 9s513ms 1s57ms 14 12 35s679ms 2s973ms 15 12 31s567ms 2s630ms 16 5 4s330ms 866ms 17 4 4s760ms 1s190ms 20 1 297ms 297ms 21 6 11s120ms 1s853ms 22 6 11s378ms 1s896ms [ User: intelifix - Total duration: 6m25s - Times executed: 158 ]
[ Application: psql - Total duration: 6m25s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 00:05:12 Duration: 10s565ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 10:35:09 Duration: 8s76ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 09:55:09 Duration: 8s20ms Database: rio User: intelifix Remote: [local] Application: psql
6 128 27s400ms 151ms 956ms 214ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 17 01 6 1s168ms 194ms 05 12 3s68ms 255ms 07 17 3s213ms 189ms 08 12 2s243ms 186ms 09 13 2s518ms 193ms 10 14 3s66ms 219ms 11 14 3s499ms 249ms 12 2 424ms 212ms 13 3 625ms 208ms 14 19 3s758ms 197ms 15 16 3s813ms 238ms [ User: intelifix - Total duration: 27s400ms - Times executed: 128 ]
[ Application: [unknown] - Total duration: 27s400ms - Times executed: 128 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241631066584,241635532430,241661317583,241617874051,241728713948,241727278992,241712828895,241630595068,241604204344,241673946975,241729929409,241732070404,241619332847,241629114856,241700641523,241691041024,241702173131,241622534461,241658535763,241614617481,241695482950,241676838302,241695637891,241709300000,241638290814,241712817682,241667233436,241661331525,241670328395,241704029697,241646422135,241712107175,241650808803,241595787080,241710319099,241645570324,241689971739,241616071833,241653382949,241631298807,241653186464,241607096680,241704299601,241627866384,241607049100,241663093133,241645489507,241664066168,241699120724,241654473347,241692607685,241614606470,241671543958,241715020626,241595700507,241649239312,241654649503,241656754759,241635204362,241649259112,241637878494,241729506483,241728536478', NULL, NULL, 0320, 00);
Date: 2026-07-17 05:02:53 Duration: 956ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, '905851455B92,480033E9A17D,70037E9ABD17,946A77262BC0,10C25A11B519,1062D011EABE,905851469A35,90585145F855,383FB3A3F878,1062D0276177,B42A0ED2030F,BC9B6899927D,54A65C909F2C,B42A0E1BC08B,90585146F6BD,1062D0C892F3,1062D0C75C8B,905851A974EA,D4B92F2BF810,383FB3A9E6AD,5C76959410DB,10C25A3AC333,B42A0E1953BB,70037E9A7CE3,087E64828F98,A456CCE3152A,480033051856,80D04AB7232A,1062D0C7197F,54A65C1214A6,383FB3A7AEE9,383FB3A8CF8D,54A65C8D6E86,80D04A937B3E,1062D0C5AA45,5C7695931B56,70037EA136B9,10C25A16355D', NULL, NULL, 046, 00);
Date: 2026-07-17 11:22:08 Duration: 699ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, 'B85E71E62D50,B85E71D2AC94,4075C39C1C14,4075C3BE0EB4,08A7C07A38C4,E4BFFAF0CE0C,B85E71DAA37C,B85E71DAB358,E4BFFAEFF96C,B85E71EC1648,3C82C0918CCC,4075C39C2254,00CB7AE4E2D0,B85E71E53300,ECA81F200B64,C4509CEC114C,B85E71C5AB20,B85E71C75FC4,B85E71D9D0A0,C4509CAC578C,CCF3C848E204,8C6A8DC2406C', NULL, NULL, 0185, 00);
Date: 2026-07-17 15:16:28 Duration: 478ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 119 19s366ms 150ms 273ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 17 01 1 152ms 152ms 05 1 180ms 180ms 07 8 1s244ms 155ms 08 20 3s217ms 160ms 09 24 3s853ms 160ms 10 24 3s889ms 162ms 11 20 3s329ms 166ms 13 2 311ms 155ms 14 11 1s883ms 171ms 15 8 1s304ms 163ms [ User: intelifix - Total duration: 19s366ms - Times executed: 119 ]
[ Application: [unknown] - Total duration: 19s366ms - Times executed: 119 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0156;
Date: 2026-07-17 14:42:32 Duration: 273ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-17 11:13:24 Duration: 195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0129;
Date: 2026-07-17 11:48:30 Duration: 188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 111 30s879ms 152ms 798ms 278ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 17 09 111 30s879ms 278ms [ User: intelifix - Total duration: 30s879ms - Times executed: 111 ]
[ Application: [unknown] - Total duration: 30s879ms - Times executed: 111 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46986","seriais":"D8313993891E,3891484BDADD,38914851C3A3,D83139244F26,C4EBFF8BAE9E,14CA56D28C2D,3891484BD64B,6C11BA6906C9,14CA56D123C7,3CF9F0ACFC5A,48D682357FB8,14CA56CDD495,F4E84F80D194,D831391FDDF0,6C11BA6D7949,5872C98AD6C1,6C11BA6F3183,3CF9F0AE7B52,D89A0DB0D673,C4EBFF891996,38914851D41D,843C992E838F,843C9935C7B3,D89A0DA90E79","usuario":"416","observacao":""}');
Date: 2026-07-17 09:30:27 Duration: 798ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46986","seriais":"F8F532522F5A,B0DAF9653341,5819F848BF87,A8F5DDED4E62,BC644BCC8EB1,BC644BC0B785,BC644BCB2AB2,F8F532508CBD,CC75E2BA4997,4C1265388872","usuario":"416","observacao":""}');
Date: 2026-07-17 09:29:57 Duration: 692ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"46986","seriais":"241715031233,241727457293,241593263647,241659704957,241731218894,241708889094,241704694163,241650547991,241728484150,241616096986,241732148390,241659714352,241727454768,241677395056,241732139399,241727475151,241717153639,241646256282,241728722232,241659720010,241713313747,241647395069,241728731728","usuario":"416","observacao":""}');
Date: 2026-07-17 09:32:26 Duration: 613ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
9 110 21s521ms 150ms 595ms 195ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 17 05 1 151ms 151ms 07 2 455ms 227ms 08 3 502ms 167ms 09 3 546ms 182ms 10 11 2s349ms 213ms 11 11 1s894ms 172ms 12 3 528ms 176ms 13 3 601ms 200ms 14 20 4s82ms 204ms 15 29 5s349ms 184ms 16 24 5s57ms 210ms [ User: intelifix - Total duration: 21s521ms - Times executed: 110 ]
[ Application: [unknown] - Total duration: 21s521ms - Times executed: 110 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "365", "data-de" : "2026-07-17", "data-ate" : "2026-07-17", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 417 }');
Date: 2026-07-17 14:43:28 Duration: 595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-07-13", "data-ate" : "2026-07-13", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 398 }');
Date: 2026-07-17 16:19:56 Duration: 360ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "364", "data-de" : "2026-07-17", "data-ate" : "2026-07-17", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 366 }');
Date: 2026-07-17 10:06:03 Duration: 352ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 104 47s171ms 263ms 826ms 453ms 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 #10
Day Hour Count Duration Avg duration Jul 17 01 2 798ms 399ms 04 1 374ms 374ms 05 3 1s146ms 382ms 06 2 745ms 372ms 07 11 4s563ms 414ms 08 12 5s987ms 498ms 09 10 4s511ms 451ms 10 10 4s935ms 493ms 11 9 4s391ms 487ms 12 4 1s433ms 358ms 13 12 4s911ms 409ms 14 8 4s95ms 511ms 15 12 5s950ms 495ms 16 4 1s538ms 384ms 17 2 965ms 482ms 20 1 453ms 453ms 21 1 367ms 367ms [ User: lenon - Total duration: 47s171ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 47s171ms - Times executed: 104 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-17 10:03:06 Duration: 826ms 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-07-17 14:13:00 Duration: 675ms 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-07-17 14:19:57 Duration: 674ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 102 58s171ms 157ms 2s34ms 570ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 17 07 12 3s215ms 267ms 08 10 4s26ms 402ms 09 12 6s601ms 550ms 10 21 15s671ms 746ms 11 5 5s547ms 1s109ms 13 3 3s368ms 1s122ms 14 33 16s351ms 495ms 15 6 3s388ms 564ms [ User: intelifix - Total duration: 58s171ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 58s171ms - Times executed: 102 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267504) LIMIT 1;
Date: 2026-07-17 10:43:34 Duration: 2s34ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267020) LIMIT 1;
Date: 2026-07-17 11:06:09 Duration: 1s651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267761) LIMIT 1;
Date: 2026-07-17 13:54:04 Duration: 1s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 97 40s461ms 261ms 685ms 417ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 17 07 14 5s754ms 411ms 08 12 4s892ms 407ms 09 8 3s512ms 439ms 10 5 2s500ms 500ms 11 12 4s956ms 413ms 12 3 1s195ms 398ms 13 8 3s304ms 413ms 14 13 5s921ms 455ms 15 9 3s628ms 403ms 16 10 3s744ms 374ms 17 3 1s50ms 350ms [ User: intelifix - Total duration: 40s461ms - Times executed: 97 ]
[ Application: [unknown] - Total duration: 40s461ms - Times executed: 97 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-17 14:45:23 Duration: 685ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-17 14:34:02 Duration: 641ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-07-17 10:34:52 Duration: 639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 95 53s986ms 322ms 921ms 568ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 17 01 2 1s55ms 527ms 04 1 598ms 598ms 05 1 442ms 442ms 06 1 453ms 453ms 07 9 4s562ms 506ms 08 12 7s212ms 601ms 09 10 5s803ms 580ms 10 10 6s243ms 624ms 11 9 5s344ms 593ms 12 4 1s938ms 484ms 13 11 5s796ms 526ms 14 7 4s54ms 579ms 15 12 7s152ms 596ms 16 4 2s72ms 518ms 17 2 1s255ms 627ms [ User: intelifix - Total duration: 53s986ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 53s986ms - Times executed: 95 ]
-
select * from rs_menu_grants (415, 21, 1);
Date: 2026-07-17 10:06:09 Duration: 921ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 81, 1);
Date: 2026-07-17 10:03:06 Duration: 907ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (507, 18, 1);
Date: 2026-07-17 08:12:43 Duration: 809ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 82 18s605ms 151ms 699ms 226ms create table temp0000236396 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 17 13 12 2s872ms 239ms 14 13 3s321ms 255ms 15 16 3s368ms 210ms 16 9 1s902ms 211ms 17 32 7s140ms 223ms [ User: intelifix - Total duration: 18s605ms - Times executed: 82 ]
[ Application: [unknown] - Total duration: 18s605ms - Times executed: 82 ]
-
CREATE TABLE temp0000236396 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "17-07-2026", "data-ate" : "17-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-17 14:48:20 Duration: 699ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236396 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "12-07-2026", "data-ate" : "17-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-17 13:15:23 Duration: 653ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236396 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "17-07-2026", "data-ate" : "17-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-17 16:50:08 Duration: 317ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 77 21s7ms 174ms 521ms 272ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 17 07 6 1s696ms 282ms 08 14 3s981ms 284ms 09 24 6s500ms 270ms 10 7 2s293ms 327ms 11 14 3s462ms 247ms 13 10 2s456ms 245ms 17 2 617ms 308ms [ User: intelifix - Total duration: 21s7ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 21s7ms - Times executed: 77 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"14", "usuario" :"407", "tipo" :"N", "itens" :"002", "nota-fiscal" :"1557", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-17 10:06:49 Duration: 521ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"189", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-17 08:37:44 Duration: 386ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"46", "usuario" :"397", "tipo" :"N", "itens" :"0400", "nota-fiscal" :"2030", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-17 10:08:01 Duration: 355ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 72 4m19s 199ms 1m9s 3s610ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 17 07 14 44s890ms 3s206ms 08 24 54s227ms 2s259ms 09 2 1s30ms 515ms 10 4 1m11s 17s880ms 11 1 696ms 696ms 13 4 3s141ms 785ms 14 11 49s726ms 4s520ms 15 6 24s548ms 4s91ms 16 6 10s192ms 1s698ms [ User: intelifix - Total duration: 4m19s - Times executed: 72 ]
[ Application: psql - Total duration: 4m19s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027225);
Date: 2026-07-17 10:17:31 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027192);
Date: 2026-07-17 07:57:26 Duration: 39s137ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027195);
Date: 2026-07-17 08:00:57 Duration: 31s453ms Database: rio User: intelifix Remote: [local] Application: psql
17 58 9m38s 1s619ms 43s788ms 9s978ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 17 07 3 26s160ms 8s720ms 08 3 28s666ms 9s555ms 09 10 1m42s 10s213ms 10 8 2m21s 17s627ms 11 6 46s296ms 7s716ms 12 3 7s953ms 2s651ms 13 7 1m19s 11s328ms 14 7 1m28s 12s605ms 15 3 27s668ms 9s222ms 16 3 16s290ms 5s430ms 17 3 10s63ms 3s354ms 18 2 4s955ms 2s477ms [ User: intelifix - Total duration: 9m38s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 9m38s - Times executed: 58 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 10:10:23 Duration: 43s788ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 09:00:34 Duration: 31s364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 13:57:59 Duration: 30s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 50 11s208ms 153ms 840ms 224ms create table temp0000236336 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 17 07 4 1s615ms 403ms 08 12 3s142ms 261ms 09 5 805ms 161ms 10 19 3s545ms 186ms 11 10 2s99ms 209ms [ User: intelifix - Total duration: 11s208ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 11s208ms - Times executed: 50 ]
-
CREATE TABLE temp0000236336 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "12-07-2026", "data-ate" : "17-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-17 07:52:44 Duration: 840ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236336 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "16-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-17 08:18:33 Duration: 349ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236336 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "16-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-17 08:39:01 Duration: 306ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
19 48 2h7m30s 1s380ms 9m11s 2m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 17 07 3 9m11s 3m3s 08 3 9m39s 3m13s 09 3 8m51s 2m57s 10 3 9m50s 3m16s 11 3 7m46s 2m35s 12 3 7m13s 2m24s 13 3 6m38s 2m12s 14 3 8m31s 2m50s 15 3 9m31s 3m10s 16 3 9m2s 3m 17 3 6m8s 2m2s 18 3 5m56s 1m58s 19 3 5m55s 1m58s 20 3 7m35s 2m31s 21 3 5m55s 1m58s 22 3 9m41s 3m13s [ User: intelifix - Total duration: 2h7m30s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 10:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 08:14:04 Duration: 9m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 15:14:02 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: psql
20 47 1h16m16s 276ms 5m2s 1m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 17 07 3 5m13s 1m44s 08 3 5m47s 1m55s 09 3 5m59s 1m59s 10 3 6m11s 2m3s 11 3 5m45s 1m55s 12 3 4m1s 1m20s 13 3 4m9s 1m23s 14 3 5m10s 1m43s 15 3 4m47s 1m35s 16 3 4m39s 1m33s 17 3 3m57s 1m19s 18 3 3m50s 1m16s 19 3 3m40s 1m13s 20 3 4m28s 1m29s 21 3 3m42s 1m14s 22 2 4m52s 2m26s [ User: intelifix - Total duration: 1h16m16s - Times executed: 47 ]
[ Application: psql - Total duration: 1h16m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 10:20:55 Duration: 5m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 09:19:40 Duration: 5m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 11:18:26 Duration: 4m43s Database: brasilia User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m12s 8m4s 4m39s 3 13m57s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 17 05 3 13m57s 4m39s [ User: intelifix - Total duration: 13m57s - Times executed: 3 ]
[ Application: psql - Total duration: 13m57s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-17 05:08:05 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-17 05:11:47 Duration: 3m41s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-17 05:13:59 Duration: 2m12s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s380ms 9m11s 2m39s 48 2h7m30s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 17 07 3 9m11s 3m3s 08 3 9m39s 3m13s 09 3 8m51s 2m57s 10 3 9m50s 3m16s 11 3 7m46s 2m35s 12 3 7m13s 2m24s 13 3 6m38s 2m12s 14 3 8m31s 2m50s 15 3 9m31s 3m10s 16 3 9m2s 3m 17 3 6m8s 2m2s 18 3 5m56s 1m58s 19 3 5m55s 1m58s 20 3 7m35s 2m31s 21 3 5m55s 1m58s 22 3 9m41s 3m13s [ User: intelifix - Total duration: 2h7m30s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m30s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 10:14:13 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 08:14:04 Duration: 9m3s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-17 15:14:02 Duration: 9m1s Database: rio User: intelifix Remote: [local] Application: psql
3 276ms 5m2s 1m37s 47 1h16m16s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 17 07 3 5m13s 1m44s 08 3 5m47s 1m55s 09 3 5m59s 1m59s 10 3 6m11s 2m3s 11 3 5m45s 1m55s 12 3 4m1s 1m20s 13 3 4m9s 1m23s 14 3 5m10s 1m43s 15 3 4m47s 1m35s 16 3 4m39s 1m33s 17 3 3m57s 1m19s 18 3 3m50s 1m16s 19 3 3m40s 1m13s 20 3 4m28s 1m29s 21 3 3m42s 1m14s 22 2 4m52s 2m26s [ User: intelifix - Total duration: 1h16m16s - Times executed: 47 ]
[ Application: psql - Total duration: 1h16m16s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 10:20:55 Duration: 5m2s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 09:19:40 Duration: 5m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-17 11:18:26 Duration: 4m43s Database: brasilia User: intelifix Remote: [local] Application: psql
4 660ms 2m2s 1m7s 8 9m select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 17 09 2 3m49s 1m54s 11 1 1m34s 1m34s 13 1 1m33s 1m33s 15 4 2m2s 30s687ms [ User: intelifix - Total duration: 9m - Times executed: 8 ]
[ Application: psql - Total duration: 9m - Times executed: 8 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01562);
Date: 2026-07-17 09:28:14 Duration: 2m2s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01563);
Date: 2026-07-17 09:55:08 Duration: 1m47s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01566);
Date: 2026-07-17 15:15:34 Duration: 1m38s Database: contagem User: intelifix Remote: [local] Application: psql
5 4s355ms 1m41s 48s662ms 4 3m14s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 17 20 2 1m28s 44s192ms 23 2 1m46s 53s133ms [ User: intelifix - Total duration: 3m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-17 23:17:51 Duration: 1m41s 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-07-17 20:09:01 Duration: 1m23s 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-07-17 20:10:46 Duration: 4s866ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 388ms 1m13s 36s571ms 4 2m26s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 17 20 2 1m12s 36s112ms 23 2 1m14s 37s29ms [ User: intelifix - Total duration: 2m26s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m26s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-17 23:14:06 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-17 20:05:54 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-17 20:10:12 Duration: 425ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 153ms 6m49s 13s779ms 303 1h9m35s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 17 07 36 11m29s 19s158ms 08 41 21m17s 31s164ms 09 32 1m46s 3s330ms 10 39 9m22s 14s410ms 11 27 6m25s 14s261ms 12 4 2s36ms 509ms 13 18 26s511ms 1s472ms 14 52 7m43s 8s916ms 15 27 6m10s 13s719ms 16 22 4m43s 12s908ms 17 5 7s440ms 1s488ms [ User: intelifix - Total duration: 1h9m35s - Times executed: 303 ]
[ Application: [unknown] - Total duration: 1h9m35s - Times executed: 303 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027223, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 10:11:58 Duration: 6m49s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027233, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 14:21:48 Duration: 5m50s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027226, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-17 11:13:51 Duration: 5m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s518ms 35s718ms 13s308ms 27 5m59s create table temp0000285744 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 17 13 3 35s893ms 11s964ms 14 17 3m55s 13s859ms 15 7 1m27s 12s547ms [ User: intelifix - Total duration: 5m59s - Times executed: 27 ]
[ Application: [unknown] - Total duration: 5m59s - Times executed: 27 ]
-
CREATE TABLE temp0000285744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:46:13 Duration: 35s718ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:41:41 Duration: 13s642ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285744 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:53:54 Duration: 13s549ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s853ms 34s496ms 12s816ms 45 9m36s create table temp0000285672 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 17 07 16 3m 11s304ms 08 14 3m6s 13s321ms 09 6 1m36s 16s147ms 10 6 1m19s 13s220ms 11 3 33s145ms 11s48ms [ User: intelifix - Total duration: 9m36s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 9m36s - Times executed: 45 ]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 09:36:09 Duration: 34s496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:47:41 Duration: 16s239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:47:16 Duration: 15s628ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s529ms 15s717ms 12s559ms 14 2m55s create table temp0000285576 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 17 07 4 45s680ms 11s420ms 08 10 2m10s 13s15ms [ User: intelifix - Total duration: 2m55s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m55s - Times executed: 14 ]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:23:51 Duration: 15s717ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:24:39 Duration: 13s932ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:13:19 Duration: 13s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s718ms 13s716ms 12s158ms 12 2m25s create table temp0000285758 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 17 14 6 1m9s 11s504ms 15 6 1m16s 12s812ms [ User: intelifix - Total duration: 2m25s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m25s - Times executed: 12 ]
-
CREATE TABLE temp0000285758 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 15:31:00 Duration: 13s716ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285758 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 15:32:32 Duration: 13s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285758 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 14:13:12 Duration: 12s780ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s832ms 15s607ms 12s136ms 14 2m49s create table temp0000285748 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 17 14 3 35s279ms 11s759ms 15 3 38s390ms 12s796ms 16 8 1m36s 12s30ms [ User: intelifix - Total duration: 2m49s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 2m49s - Times executed: 14 ]
-
CREATE TABLE temp0000285748 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 15:58:12 Duration: 15s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285748 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 16:08:05 Duration: 15s475ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285748 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 16:08:43 Duration: 15s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 9s625ms 14s618ms 11s976ms 31 6m11s create table temp0000285654 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 17 07 11 2m8s 11s716ms 08 20 4m2s 12s119ms [ User: intelifix - Total duration: 6m11s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 6m11s - Times executed: 31 ]
-
CREATE TABLE temp0000285654 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:02:53 Duration: 14s618ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285654 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:16:45 Duration: 14s445ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285654 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-17 08:20:15 Duration: 14s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 1s619ms 43s788ms 9s978ms 58 9m38s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 17 07 3 26s160ms 8s720ms 08 3 28s666ms 9s555ms 09 10 1m42s 10s213ms 10 8 2m21s 17s627ms 11 6 46s296ms 7s716ms 12 3 7s953ms 2s651ms 13 7 1m19s 11s328ms 14 7 1m28s 12s605ms 15 3 27s668ms 9s222ms 16 3 16s290ms 5s430ms 17 3 10s63ms 3s354ms 18 2 4s955ms 2s477ms [ User: intelifix - Total duration: 9m38s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 9m38s - Times executed: 58 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 10:10:23 Duration: 43s788ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 09:00:34 Duration: 31s364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-17', 0173, '', '', 0, 6, '2026-07-01');
Date: 2026-07-17 13:57:59 Duration: 30s399ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3s215ms 6s282ms 4s732ms 41 3m14s create table temp0000285672 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 17 07 8 33s827ms 4s228ms 08 12 55s487ms 4s623ms 09 21 1m44s 4s987ms [ User: intelifix - Total duration: 3m14s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 41 ]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-07-2026", "ate" :"17-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-17 08:37:34 Duration: 6s282ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-07-2026", "ate" :"17-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-17 09:31:16 Duration: 6s207ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285672 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"12-07-2026", "ate" :"17-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-17 09:28:37 Duration: 6s172ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 199ms 1m9s 3s610ms 72 4m19s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 17 07 14 44s890ms 3s206ms 08 24 54s227ms 2s259ms 09 2 1s30ms 515ms 10 4 1m11s 17s880ms 11 1 696ms 696ms 13 4 3s141ms 785ms 14 11 49s726ms 4s520ms 15 6 24s548ms 4s91ms 16 6 10s192ms 1s698ms [ User: intelifix - Total duration: 4m19s - Times executed: 72 ]
[ Application: psql - Total duration: 4m19s - Times executed: 72 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027225);
Date: 2026-07-17 10:17:31 Duration: 1m9s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027192);
Date: 2026-07-17 07:57:26 Duration: 39s137ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027195);
Date: 2026-07-17 08:00:57 Duration: 31s453ms Database: rio User: intelifix Remote: [local] Application: psql
17 158ms 11s889ms 2s613ms 265 11m32s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 17 00 12 32s45ms 2s670ms 01 11 29s14ms 2s637ms 02 11 27s8ms 2s455ms 03 11 27s740ms 2s521ms 04 12 28s135ms 2s344ms 05 11 27s466ms 2s496ms 06 12 26s619ms 2s218ms 07 11 32s533ms 2s957ms 08 12 38s284ms 3s190ms 09 12 38s49ms 3s170ms 10 12 39s35ms 3s252ms 11 12 30s177ms 2s514ms 12 12 25s12ms 2s84ms 13 12 26s941ms 2s245ms 14 12 36s897ms 3s74ms 15 12 29s215ms 2s434ms 16 12 27s33ms 2s252ms 17 12 25s5ms 2s83ms 18 11 26s623ms 2s420ms 19 10 25s682ms 2s568ms 20 12 40s583ms 3s381ms 21 12 28s514ms 2s376ms 22 9 25s18ms 2s779ms [ User: intelifix - Total duration: 11m32s - Times executed: 265 ]
[ Application: psql - Total duration: 11m32s - Times executed: 265 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 20:05:13 Duration: 11s889ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 14:45:19 Duration: 10s895ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-17 10:15:16 Duration: 10s170ms Database: rio User: intelifix Remote: [local] Application: psql
18 174ms 10s565ms 2s438ms 158 6m25s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 17 00 6 16s240ms 2s706ms 01 6 5s397ms 899ms 02 6 9s7ms 1s501ms 03 5 8s285ms 1s657ms 04 5 8s748ms 1s749ms 05 4 9s549ms 2s387ms 06 4 3s575ms 893ms 07 9 26s562ms 2s951ms 08 12 44s36ms 3s669ms 09 12 48s249ms 4s20ms 10 12 36s758ms 3s63ms 11 12 44s985ms 3s748ms 12 10 15s265ms 1s526ms 13 9 9s513ms 1s57ms 14 12 35s679ms 2s973ms 15 12 31s567ms 2s630ms 16 5 4s330ms 866ms 17 4 4s760ms 1s190ms 20 1 297ms 297ms 21 6 11s120ms 1s853ms 22 6 11s378ms 1s896ms [ User: intelifix - Total duration: 6m25s - Times executed: 158 ]
[ Application: psql - Total duration: 6m25s - Times executed: 158 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 00:05:12 Duration: 10s565ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 10:35:09 Duration: 8s76ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-17 09:55:09 Duration: 8s20ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 4s975ms 868ms 1,309 18m56s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 17 06 1 861ms 861ms 07 88 1m5s 743ms 08 166 2m45s 994ms 09 230 2m53s 756ms 10 182 2m52s 948ms 11 113 1m35s 841ms 12 38 31s635ms 832ms 13 111 1m21s 735ms 14 159 2m18s 873ms 15 170 2m51s 1s10ms 16 46 36s183ms 786ms 17 5 3s619ms 723ms [ User: intelifix - Total duration: 18m56s - Times executed: 1309 ]
[ Application: [unknown] - Total duration: 18m56s - Times executed: 1309 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47539, 407, '73900285850063604733,229638345568,229776466466,229709127178,229880697985,216923999311,229799268893,229823272337,216924344249,229822938184,229826053450,229833075560,229830976062,229834065062,229715575159,216930868500,229678440122,229826155154,229764668503,229826595758,229710388503,229646223352,229694796666,216925444648,229822226970,229707435880,229828292838,216927164558,229699877375,229822727075,229731282641,229640558488,229801289090,229639430310,229700636776,229677007388,229830775156,216949473649', '246448904971,246577195673,246540389006,246188641827,246431226971,246617028708,246622255671,246441086890,246625765475,226028425965,246066413052,246638546677,246207080518,246529078901,246446066377,246490710421,246634709917,246561869294,246633911826,246542615059,246466607495,246500450103,246450166777,246613538805,246541931626,246634704361,246451834763,246512092137,246625388389,246563997785,246448584760,246626360517,246446823657,246516782325,246460313447,246435210717,', 0137, 00, '[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-17 08:42:36 Duration: 4s975ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (47578, 418, '835135920002723,241676663234,241671993553,241679910207,241695585260,241676633759,241704374457,241703818184,241704268688,241663849301,241704257778,241654362326,241714931728,241629525356,241597540911,241714926070,241680315577,241713716670,241728730516,241604788700,241649653651,241695594049,241695611223,241646327175,241605360204,241659722939,241622547189,241599300522,241598814761,241656687681,241727021415', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-17 10:19:52 Duration: 4s645ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (125809, 401, '246140110110', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-17 15:05:20 Duration: 4s548ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 157ms 2s34ms 570ms 102 58s171ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 17 07 12 3s215ms 267ms 08 10 4s26ms 402ms 09 12 6s601ms 550ms 10 21 15s671ms 746ms 11 5 5s547ms 1s109ms 13 3 3s368ms 1s122ms 14 33 16s351ms 495ms 15 6 3s388ms 564ms [ User: intelifix - Total duration: 58s171ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 58s171ms - Times executed: 102 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267504) LIMIT 1;
Date: 2026-07-17 10:43:34 Duration: 2s34ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267020) LIMIT 1;
Date: 2026-07-17 11:06:09 Duration: 1s651ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0267761) LIMIT 1;
Date: 2026-07-17 13:54:04 Duration: 1s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 9 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 17 11 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 7m21s - Times executed: 9 ]
[ Application: psql - Total duration: 7m20s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 885ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,797 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 19 FATAL entries
- 3810 ERROR entries
- 0 WARNING entries
- 17 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,669 Max number of times the same event was reported
- 3,846 Total events found
Rank Times reported Error 1 3,669 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 17 00 59 01 59 02 60 03 53 04 59 05 59 06 60 07 269 08 291 09 380 10 415 11 359 12 84 13 222 14 351 15 326 16 118 17 98 18 60 19 59 20 60 21 59 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029A52510" does not exist
- ERROR: prepared statement "_PLAN0000000029A52510" does not exist
- ERROR: prepared statement "_PLAN0000000029A564F0" does not exist
Statement: DEALLOCATE "_PLAN0000000029A52510"
Date: 2026-07-17 00:00:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A52510"
Date: 2026-07-17 00:01:05 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A564F0"
Date: 2026-07-17 00:02:06 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 17 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-17 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-17 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-17 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 43 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 17 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 2 19 2 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-17 08:00:19 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-17 08:20:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-17 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
4 9 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 17 07 2 08 1 10 3 13 2 14 1 - ERROR: syntax error at or near "3287701" at character 35
- ERROR: syntax error at or near "3287701" at character 35
- ERROR: syntax error at or near "E44E1291FB3B" at character 41
Statement: select * from rs_caixa_qr(3287701 3287701 )
Date: 2026-07-17 07:08:02 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3287701 3287701 )
Date: 2026-07-17 07:08:03 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''E44E1291FB3B');
Date: 2026-07-17 08:07:14 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 17 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-17 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-17 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-17 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
6 8 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 17 08 1 09 2 13 1 14 4 - ERROR: trailing junk after numeric literal at or near "9C635BF8A151" at character 41
- ERROR: trailing junk after numeric literal at or near "90F3055D5EB5" at character 32
- ERROR: trailing junk after numeric literal at or near "90F3055D5EB5" at character 114
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''9C635BF8A151');
Date: 2026-07-17 08:41:22 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''90F3055D5EB5' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''90F3055D5EB5' )
Date: 2026-07-17 09:14:22 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"46512","seriais":[{"serial":"11718885850041600075"},{"serial":"'90F3055D5EB5"}]}')
Date: 2026-07-17 09:14:38 Database: contagem Application: [unknown] User: intelifix Remote: [local]
7 8 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 17 10 8 - ERROR: canceling statement due to user request
- ERROR: canceling statement due to user request
- ERROR: canceling statement due to user request
Statement: COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-17 10:34:17 Database: rio Application: pg_dump User: intelifix Remote: [local]
Statement: COPY public.posicao_estoque01 (ofi_id, ofi_nome, gru_id, gru_nome, cli_id, cli_nome, data_hora, serie, box, temporario, end_principal, barra1, barra2, barra3, barra4, extra1, extra2, extra3, extra4, acessorio1, acessorio2, mod_id, modelo, fornecedor, legado, legado_original, nf_entrada, nfgvt, nf_saida, valor, city, state, sap, data_entrada, data_conserto, data_insp, data_cq, data_expedicao, lot_saida, tipo_lote, status, detalhe, status_id, defeitos, triagem_data, triagem_tec, flu_id, eq_id, flu_status, pas_id, pas_nome, res_id, res_nome, mot_id, mot_nome, tcn_id, tcn_nome, garantia_fab, garantia_niv, oow, li_id, is_id, versao_hard, versao_soft, validado, auditoria, ultimo_evento, ultimo_evento_data, dias, sit_id, situacao) TO stdout;
Date: 2026-07-17 10:34:27 Database: rio Application: pg_dump User: intelifix Remote: [local]
Statement: SELECT t.tableoid, t.oid, i.indrelid, t.relname AS indexname, t.relpages, t.reltuples, t.relallvisible, t.relallfrozen, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, i.indkey, i.indisclustered, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, CASE WHEN i.indexprs IS NOT NULL THEN (SELECT pg_catalog.array_agg(attname ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid) ELSE NULL END AS indattnames, (SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions, i.indisreplident, inh.inhparent AS parentidx, i.indnkeyatts AS indnkeyatts, i.indnatts AS indnatts, (SELECT pg_catalog.array_agg(attnum ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatcols, (SELECT pg_catalog.array_agg(attstattarget ORDER BY attnum) FROM pg_catalog.pg_attribute WHERE attrelid = i.indexrelid AND attstattarget >= 0) AS indstatvals, i.indnullsnotdistinct, c.conperiod FROM unnest('{1441884,1441894,1441899,1441904,1441909,1441914,1441919,1441924,1441929,1441934,1441939,1441944,1441949,1441954,1441959,1441964,1441969,1441974,1441979,1441984,1441989,1441994,1441999,1442004,1442009,1442014,1442019,1442024,1442029,1442034,1442039,1442044,1442049,1442054,1442059,1442064,1442069,1442074,1442079,1442084,1442089,1442094,1442099,1442104,1442109,1442114,1442119,1442124,1442129,1442134,1442139,1442144,1442149,1442154,1442159,1442164,1442169,1442174,1442179,1442184,1442189,1442194,1442199,1442204,1442209,1442214,1442219,1442224,1442229,1442234,1442239,1442244,1442249,1442254,1442259,1442264,1442269,1442274,1442279,1442284,1442289}'::pg_catalog.oid[]) AS src(tbloid) JOIN pg_catalog.pg_index i ON (src.tbloid = i.indrelid) JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) JOIN pg_catalog.pg_class t2 ON (t2.oid = i.indrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ('p','u','x')) LEFT JOIN pg_catalog.pg_inherits inh ON (inh.inhrelid = indexrelid) WHERE (i.indisvalid OR t2.relkind = 'p') AND i.indisready ORDER BY i.indrelid, indexname
Date: 2026-07-17 10:34:28 Database: brasilia Application: pg_dump User: intelifix Remote: [local]
8 7 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 17 08 1 10 3 13 3 - ERROR: column "controle" does not exist at character 36
- ERROR: column "cai_criacao" does not exist at character 113
- ERROR: column "cc5830fc5935" does not exist at character 27
Hint: Perhaps you meant to reference the column "temp0000236336.con_nome".
Statement: SELECT * FROM temp0000236336 WHERE CONTROLE='L'Date: 2026-07-17 08:40:47 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: select * from caixa_itens where cai_id in (select cai_id from lote_caixas where lot_id= 266961) order by cai_id,cai_criacao
Date: 2026-07-17 10:04:54 Database: rio Application: pgAdmin 4 - CONN:511991 User: lenon Remote: 172.20.0.3
Statement: select * from rs_caixa_qr(CC5830FC5935)
Date: 2026-07-17 10:57:07 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 5 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 17 10 5 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-07-17 10:34:27 Database: rio Application: pg_dump User: intelifix Remote: [local]
Date: 2026-07-17 10:34:27 Database: brasilia Application: pg_dump User: intelifix Remote: [local]
Date: 2026-07-17 10:34:28 Database: brasilia Application: pg_dump User: intelifix Remote: [local]
10 4 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 17 10 4 - LOG: could not send data to client: Broken pipe
- LOG: could not send data to client: Broken pipe
- LOG: could not send data to client: Broken pipe
Statement: COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-17 10:34:17 Database: rio Application: pg_dump User: intelifix Remote: [local]
Statement: COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-17 10:35:40 Database: contagem Application: pg_dump User: intelifix Remote: [local]
Statement: COPY auditor.auditor_2026_04 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-17 10:35:45 Database: contagem Application: pg_dump User: intelifix Remote: [local]
11 4 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 17 10 4 - FATAL: connection to client lost
- FATAL: connection to client lost
- FATAL: connection to client lost
Date: 2026-07-17 10:34:17 Database: rio Application: pg_dump User: intelifix Remote: [local]
Date: 2026-07-17 10:35:40 Database: contagem Application: pg_dump User: intelifix Remote: [local]
Date: 2026-07-17 10:35:45 Database: contagem Application: pg_dump User: intelifix Remote: [local]
12 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 17 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-17 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-17 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-17 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
13 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 17 07 1 13 1 14 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000285672"
Date: 2026-07-17 07:42:43
Context: automatic vacuum of table "rio.public.temp0000285728"
Date: 2026-07-17 13:42:11
Context: automatic vacuum of table "rio.public.temp0000285744"
Date: 2026-07-17 14:59:12
14 3 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 17 00 1 01 1 06 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-17 00:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-17 01:57:58 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-17 06:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
15 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 17 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-07-17 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-17 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-17 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
16 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 17 07 1 13 1 14 1 - LOG: process 783285 still waiting for AccessExclusiveLock on relation 2589484 of database 358220 after 1000.091 ms
- LOG: process 1171627 still waiting for AccessExclusiveLock on relation 2618113 of database 358220 after 1000.379 ms
- LOG: process 1218566 still waiting for AccessExclusiveLock on relation 2630577 of database 358220 after 1000.205 ms
Detail: Process holding the lock: 789053. Wait queue: 783285.
Statement: DROP TABLE IF EXISTS temp0000285672;Date: 2026-07-17 07:42:43 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1187325. Wait queue: 1171627.
Statement: DROP TABLE IF EXISTS temp0000285728;Date: 2026-07-17 13:42:11 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1356511. Wait queue: 1218566.
Statement: DROP TABLE IF EXISTS temp0000285744;Date: 2026-07-17 14:59:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
17 3 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 17 07 3 - ERROR: unterminated quoted identifier at or near "")" at character 29
- ERROR: unterminated quoted identifier at or near "")" at character 29
- ERROR: unterminated quoted identifier at or near "")" at character 29
Statement: SELECT * FROM RS_ETIQUETA(WT")
Date: 2026-07-17 07:39:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(WT")
Date: 2026-07-17 07:39:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(WT")
Date: 2026-07-17 07:39:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
18 3 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 17 07 3 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(1921182224251925161617202123)Date: 2026-07-17 07:53:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(1921182224251925161617202123)Date: 2026-07-17 07:53:48 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(1921182224251925161617202123)Date: 2026-07-17 07:53:49 Database: rio Application: [unknown] User: etiquetas Remote: [local]
19 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 17 12 1 13 2 - 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-07-17 12:17:06 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
Date: 2026-07-17 13:13:54 Database: rio Application: pgAdmin 4 - CONN:511991 User: lenon Remote: 172.20.0.3
Date: 2026-07-17 13:18:16 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3
20 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #20
Day Hour Count Jul 17 08 2 - ERROR: unterminated quoted string at or near "''');" at character 39
- ERROR: unterminated quoted string at or near "'241770186480'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-17 08:05:06 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('241770186480'');
Date: 2026-07-17 08:23:15 Database: rio Application: [unknown] User: intelifix Remote: [local]
21 2 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #21
Day Hour Count Jul 17 13 2 - ERROR: invalid input syntax for type integer: ""
- ERROR: invalid input syntax for type integer: ""
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"453017111021","barra2":"","barra3":"!*!$@(¨","lote":""}');Date: 2026-07-17 13:53:08 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"453017111021","barra2":"","barra3":"!*!$@(¨","lote":""}');Date: 2026-07-17 13:53:18 Database: contagem Application: [unknown] User: intelifix Remote: [local]
22 2 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #22
Day Hour Count Jul 17 18 1 19 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
- ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-17 18:40:04 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-17 19:20:04 Database: brasilia Application: psql User: intelifix Remote: [local]
23 1 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #23
Day Hour Count Jul 17 10 1 - ERROR: unexpected EOF on client connection with an open transaction
Date: 2026-07-17 10:34:27 Database: brasilia Application: pg_dump User: intelifix Remote: [local]
24 1 ERROR: missing FROM-clause entry for table "..."
Times Reported Most Frequent Error / Event #24
Day Hour Count Jul 17 10 1 - ERROR: missing FROM-clause entry for table "b" at character 45
Statement: UPDATE CAIXA_ITENS A SET CAI_DATA = (SELECT B.DATA FROM X WHERE X.FLU_ID = A.FLU_ID) WHERE FLU_ID IN (SELECT FLU_ID FROM X )
Date: 2026-07-17 10:59:46 Database: rio Application: pgAdmin 4 - CONN:511991 User: lenon Remote: 172.20.0.3
25 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #25
Day Hour Count Jul 17 03 1 - LOG: database system was shut down at 2026-07-17 03:05:01 -03
Date: 2026-07-17 03:05:03