pgBadger-
Global information
- Generated on Thu Jul 30 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 47,286 log entries in 10s
- Log start from 2026-07-30 00:00:29 to 2026-07-30 23:49:13
-
Overview
Global Stats
- 383 Number of unique normalized queries
- 6,586 Number of queries
- 8h13m39s Total query duration
- 2026-07-30 00:02:33 First query
- 2026-07-30 23:46:54 Last query
- 5 queries/s at 2026-07-30 15:45:12 Query peak
- 8h13m39s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h13m39s Execute total duration
- 5,003 Number of events
- 18 Number of unique normalized events
- 4,659 Max number of times the same event was reported
- 0 Number of cancellation
- 495 Total number of automatic vacuums
- 996 Total number of automatic analyzes
- 10 Number temporary file
- 237.76 MiB Max size of temporary file
- 110.53 MiB Average size of temporary file
- 380 Total number of sessions
- 8 sessions at 2026-07-30 00:56:23 Session peak
- 13d17h57m28s Total duration of sessions
- 52m5s Average duration of sessions
- 17 Average queries per session
- 1m17s Average queries duration per session
- 50m47s Average idle time per session
- 392 Total number of connections
- 7 connections/s at 2026-07-30 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-30 15:45:12 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-30 15:45:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-30 23:46:24 Date
Queries duration
Key values
- 8h13m39s 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 30 00 33 0ms 31s114ms 4s721ms 5s372ms 6s694ms 1m23s 01 37 0ms 3s847ms 1s78ms 5s128ms 5s695ms 7s799ms 02 18 0ms 4s61ms 1s776ms 4s289ms 5s336ms 6s180ms 03 19 0ms 4s467ms 1s824ms 5s26ms 5s513ms 7s661ms 04 41 0ms 3s899ms 1s46ms 5s59ms 5s999ms 8s400ms 05 34 0ms 9m11s 33s302ms 7s239ms 2m29s 9m11s 06 32 0ms 27s705ms 3s90ms 5s331ms 6s597ms 37s835ms 07 266 0ms 8m51s 4s385ms 24s178ms 1m9s 9m 08 520 0ms 6m42s 6s12ms 4m24s 5m19s 7m46s 09 585 150ms 9m25s 4s698ms 1m16s 6m14s 9m53s 10 558 150ms 8m33s 2s992ms 49s503ms 1m11s 8m41s 11 576 150ms 8m58s 3s969ms 1m4s 5m12s 9m1s 12 157 0ms 8m44s 6s816ms 15s601ms 1m5s 8m55s 13 467 0ms 6m4s 2s716ms 35s531ms 42s282ms 6m55s 14 1,159 150ms 9m8s 2s866ms 2m31s 6m15s 9m38s 15 799 150ms 9m23s 3s379ms 52s532ms 6m59s 9m28s 16 532 150ms 8m9s 3s68ms 55s285ms 1m59s 8m30s 17 205 0ms 7m41s 5s506ms 30s95ms 1m18s 8m8s 18 25 0ms 5m33s 24s347ms 4s185ms 43s543ms 5m33s 19 21 0ms 5m15s 27s737ms 3s804ms 14s802ms 5m45s 20 113 0ms 7m9s 11s587ms 58s950ms 1m54s 7m9s 21 27 0ms 5m59s 24s103ms 3s494ms 4s990ms 6m48s 22 26 0ms 5m22s 23s488ms 5s919ms 18s275ms 5m50s 23 336 0ms 1m25s 6s552ms 1m5s 1m11s 1m51s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 30 00 10 0 4s514ms 0ms 0ms 1s250ms 01 19 0 300ms 190ms 327ms 1s245ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 186ms 0ms 0ms 0ms 04 23 0 348ms 288ms 579ms 960ms 05 11 0 332ms 0ms 228ms 827ms 06 10 0 4s120ms 0ms 0ms 1s249ms 07 221 0 4s834ms 4s651ms 13s914ms 4m8s 08 374 0 6s370ms 30s606ms 3m47s 5m19s 09 415 0 5s530ms 15s805ms 1m7s 6m51s 10 421 0 3s254ms 14s166ms 45s437ms 4m12s 11 426 0 4s239ms 13s805ms 44s72ms 6m28s 12 103 0 9s591ms 4s655ms 8s383ms 4m20s 13 349 0 3s24ms 16s896ms 26s222ms 3m30s 14 942 0 2s797ms 28s402ms 2m2s 6m14s 15 656 0 3s470ms 14s774ms 47s853ms 7m35s 16 360 0 3s730ms 12s740ms 47s533ms 4m16s 17 128 0 8s310ms 8s599ms 26s913ms 4m3s 18 10 0 58s134ms 0ms 0ms 3m22s 19 6 0 1m32s 0ms 0ms 3m17s 20 10 88 13s4ms 10s21ms 58s558ms 3m51s 21 12 0 52s134ms 0ms 0ms 3m34s 22 6 0 1m33s 0ms 0ms 3m18s 23 9 327 6s552ms 1m1s 1m5s 1m51s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 30 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 30 00 0 2 2.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 3 3.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 10 10.00 0.00% 08 0 17 17.00 0.00% 09 0 15 15.00 0.00% 10 0 13 13.00 0.00% 11 0 10 10.00 0.00% 12 0 7 7.00 0.00% 13 0 11 11.00 0.00% 14 0 14 14.00 0.00% 15 0 14 14.00 0.00% 16 0 9 9.00 0.00% 17 0 4 4.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 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 30 00 20 0.01/s 01 10 0.00/s 02 9 0.00/s 03 20 0.01/s 04 11 0.00/s 05 11 0.00/s 06 15 0.00/s 07 17 0.00/s 08 22 0.01/s 09 24 0.01/s 10 22 0.01/s 11 21 0.01/s 12 13 0.00/s 13 25 0.01/s 14 24 0.01/s 15 21 0.01/s 16 21 0.01/s 17 17 0.00/s 18 10 0.00/s 19 11 0.00/s 20 13 0.00/s 21 10 0.00/s 22 11 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Jul 30 00 11 46m55s 46m40s 01 16 1h35s 1h32s 02 10 1h18s 1h15s 03 20 22m28s 22m26s 04 10 56m43s 56m39s 05 10 56m36s 54m43s 06 10 58m48s 58m38s 07 15 55m31s 54m13s 08 18 51m6s 48m13s 09 22 56m7s 54m2s 10 22 52m13s 50m57s 11 21 48m43s 46m54s 12 18 56m12s 55m13s 13 16 45m58s 44m38s 14 22 56m44s 54m13s 15 25 55m48s 54m 16 21 49m24s 48m7s 17 19 55m36s 54m36s 18 15 58m8s 57m27s 19 10 1h32s 59m33s 20 13 47m42s 46m1s 21 10 1h36s 59m31s 22 11 55m43s 54m48s 23 15 38m27s 36m -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-30 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 392 connections Total
Connections per user
Key values
- intelifix Main User
- 392 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-30 00:56:23 Date
Histogram of session times
Key values
- 297 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 380 sessions Total
Sessions per user
Key values
- intelifix Main User
- 380 sessions Total
Sessions per host
Key values
- [local] Main Host
- 380 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 72,250 buffers Checkpoint Peak
- 2026-07-30 00:09:43 Date
- 270.015 seconds Highest write time
- 0.122 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-07-30 08:59:37 Date
Checkpoints distance
Key values
- 366.93 Mo Distance Peak
- 2026-07-30 08:59:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 30 00 89,052 680.57s 0.046s 680.684s 01 3,714 372.796s 0.048s 372.905s 02 1,914 192.552s 0.042s 192.653s 03 1,929 193.084s 0.036s 193.174s 04 3,909 393.009s 0.031s 393.091s 05 10,530 1,049.886s 0.092s 1,050.07s 06 9,269 618.805s 0.055s 618.919s 07 22,778 2,235.078s 0.305s 2,235.518s 08 81,723 3,076.861s 0.547s 3,077.638s 09 76,443 3,238.782s 0.626s 3,239.635s 10 59,573 3,238.07s 0.456s 3,238.703s 11 55,809 3,238.885s 0.514s 3,239.62s 12 22,260 1,978.133s 0.153s 1,978.404s 13 43,840 2,212.68s 0.465s 2,213.299s 14 111,674 3,238.371s 1.039s 3,239.683s 15 65,058 3,238.775s 0.716s 3,239.709s 16 50,976 3,084.874s 0.537s 3,085.599s 17 19,619 1,707.149s 0.222s 1,707.481s 18 1,204 120.821s 0.014s 120.859s 19 22 2.23s 0.004s 2.239s 20 740 269.653s 0.025s 269.697s 21 1,527 153.142s 0.018s 153.21s 22 3,096 310.521s 0.021s 310.583s 23 298 30.034s 0.018s 30.084s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 30 00 0 0 12 568 0.006s 0.006s 01 0 0 1 714 0.003s 0.009s 02 0 0 1 478 0.003s 0.009s 03 0 0 0 376 0.005s 0.007s 04 0 0 1 576 0.002s 0.007s 05 0 0 5 846 0.009s 0.01s 06 0 0 1 606 0.003s 0.007s 07 0 0 8 3,104 0.013s 0.012s 08 0 0 59 5,930 0.017s 0.012s 09 0 0 47 6,549 0.015s 0.012s 10 0 0 39 5,989 0.029s 0.012s 11 0 0 41 5,280 0.018s 0.012s 12 0 0 7 2,978 0.003s 0.012s 13 0 0 22 5,053 0.015s 0.012s 14 0 0 70 8,794 0.031s 0.012s 15 0 0 38 7,417 0.013s 0.012s 16 0 0 29 6,400 0.008s 0.012s 17 0 0 11 2,814 0.009s 0.011s 18 0 0 0 121 0.003s 0.004s 19 0 0 0 3 0.002s 0.002s 20 0 0 1 90 0.004s 0.003s 21 0 0 1 106 0.003s 0.006s 22 0 0 1 319 0.002s 0.007s 23 0 0 0 92 0.003s 0.007s Day Hour Count Avg time (sec) Jul 30 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 30 00 32,611.33 kB 91,909.33 kB 01 2,052.67 kB 44,249.33 kB 02 1,186.12 kB 18,810.50 kB 03 1,464.29 kB 3,802.86 kB 04 2,699.00 kB 3,717.29 kB 05 6,898.80 kB 15,627.50 kB 06 3,810.57 kB 9,873.86 kB 07 10,549.75 kB 13,816.42 kB 08 80,306.00 kB 120,250.17 kB 09 64,346.25 kB 134,642.33 kB 10 53,751.58 kB 98,404.00 kB 11 55,480.92 kB 103,297.83 kB 12 10,246.58 kB 53,556.25 kB 13 29,405.58 kB 57,775.92 kB 14 95,783.50 kB 127,352.33 kB 15 51,836.50 kB 102,825.00 kB 16 39,921.92 kB 90,238.92 kB 17 15,500.00 kB 46,303.27 kB 18 1,167.75 kB 23,428.00 kB 19 177.00 kB 17,920.00 kB 20 6,458.00 kB 16,119.33 kB 21 1,275.20 kB 11,142.00 kB 22 3,136.33 kB 8,777.17 kB 23 158.67 kB 8,050.17 kB -
Temporary Files
Size of temporary files
Key values
- 475.52 MiB Temp Files size Peak
- 2026-07-30 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-30 05:30:37 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 30 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.53 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 923.54 MiB 70.92 MiB 237.76 MiB 115.44 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-30 05:32:08 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-30 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 181.72 MiB 90.86 MiB 90.86 MiB 90.86 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-30 05:30:40 Duration: 38s104ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-30 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 237.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 237.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-30 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-30 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.37 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.99 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.92 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-30 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 10.21 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database contagem - 2026-07-30 13:59:00 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 10.21 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database contagem - 2026-07-30 13:59:00 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (96) Main table analyzed (database rio)
- 996 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 96 rio.public.usuarios 50 rio.pg_catalog.pg_class 50 brasilia.pg_catalog.pg_attribute 44 contagem.pg_catalog.pg_attribute 43 rio.pg_catalog.pg_type 43 rio.public.temp0000286974 39 contagem.pg_catalog.pg_class 32 contagem.public.temp0000226722 31 rio.pg_catalog.pg_index 27 contagem.pg_catalog.pg_type 27 rio.pg_catalog.pg_depend 23 contagem.public.temp0000226730 23 contagem.public.temp0000226710 22 brasilia.pg_catalog.pg_class 21 contagem.pg_catalog.pg_index 20 rio.public.temp0000286954 18 rio.public.temp0000287030 17 brasilia.pg_catalog.pg_type 17 rio.public.temp0000286684 17 contagem.pg_catalog.pg_depend 16 rio.public.temp0000287016 16 contagem.public.usuarios 15 rio.public.temp0000286972 13 brasilia.public.temp0000237200 13 contagem.public.temp0000226724 13 contagem.public.nf_entrada 13 rio.public.temp0000286946 12 brasilia.public.usuarios 12 rio.public.temp0000286934 12 rio.public.temp0000285404 12 brasilia.pg_catalog.pg_index 11 brasilia.pg_catalog.pg_depend 9 rio.public.temp0000286930 9 rio.public.temp0000286968 8 rio.public.temp0000287012 8 rio.public.temp0000286112 8 contagem.public.temp0000226698 7 rio.public.temp0000286924 7 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000287034 5 template1.pg_catalog.pg_shdepend 5 rio.public.temp0000287038 5 rio.public.temp0000287060 5 contagem.public.temp0000226720 4 brasilia.public.temp0000237192 4 rio.public.temp0000286988 4 rio.public.temp0000286682 4 rio.public.temp0000287020 4 rio.public.tmp_drill_0175 4 brasilia.public.nf_entrada 3 contagem.public.temp0000226732 3 rio.public.temp0000287026 3 rio.public.temp0000286948 3 contagem.public.temp0000226706 3 rio.public.temp0000286964 3 contagem.public.temp0000226682 3 rio.public.temp0000287024 3 rio.public.temp0000286572 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000287056 2 rio.public.temp0000286966 2 rio.public.temp0000286922 2 contagem.public.temp0000226728 2 brasilia.public.temp0000237188 2 rio.public.temp0000286950 2 rio.public.temp0000286970 2 rio.public.temp0000287046 2 rio.public.temp0000286958 2 rio.public.tmp_drill_0302 2 brasilia.public.temp0000237206 2 rio.public.temp0000287032 2 postgres.pg_catalog.pg_shdepend 2 contagem.public.parametros 1 rio.public.temp0000287008 1 rio.public.temp0000287058 1 rio.public.temp0000287064 1 rio.public.temp0000287052 1 brasilia.public.temp0000237150 1 brasilia.public.temp0000237216 1 contagem.public.temp0000226726 1 brasilia.public.temp0000237154 1 rio.public.temp0000286982 1 contagem.public.temp0000226718 1 brasilia.public.temp0000237164 1 contagem.pg_catalog.pg_shdepend 1 rio.public.temp0000287014 1 brasilia.public.temp0000237142 1 rio.public.temp0000287004 1 rio.public.temp0000287066 1 rio.public.temp0000286984 1 brasilia.public.temp0000237146 1 Total 996 Vacuums per table
Key values
- pg_catalog.pg_attribute (35) Main table vacuumed on database rio
- 495 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 35 35 0 0 0 0 0 20,925 5,218 8,073,461 298 7,861 contagem.public.temp0000226722 29 0 0 0 0 0 0 3,005 372 538,976 0 0 contagem.pg_catalog.pg_attribute 28 28 0 0 0 0 0 25,872 1,916 6,484,997 40 836 rio.pg_catalog.pg_class 27 23 0 0 0 0 0 4,629 1,215 1,981,811 62 238 rio.public.temp0000286974 23 0 0 0 0 0 0 11,506 215 856,859 0 0 rio.pg_catalog.pg_type 19 19 0 0 0 0 0 1,949 469 689,787 56 186 contagem.pg_catalog.pg_class 19 19 0 0 0 0 0 6,524 371 1,121,751 8 25 contagem.pg_catalog.pg_type 18 18 0 0 0 0 0 3,068 235 599,503 10 23 rio.public.temp0000287030 17 0 0 0 0 0 0 20,358 1,755 3,390,152 0 0 rio.public.temp0000286954 17 0 0 0 0 0 0 13,741 69 821,682 0 0 contagem.pg_catalog.pg_depend 15 15 0 0 0 0 0 6,416 506 1,707,924 14 81 contagem.pg_catalog.pg_index 14 14 0 0 0 0 0 1,394 171 259,616 11 14 contagem.public.usuarios 14 0 0 0 0 0 0 66 50 25,347 1 1 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 7,272 1,666 2,990,467 53 1,390 rio.pg_catalog.pg_index 12 12 0 0 0 0 0 758 185 199,414 35 59 rio.public.temp0000286684 12 0 0 0 0 0 0 647 155 207,557 0 0 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,303 956 1,545,874 55 424 rio.public.temp0000285404 9 0 0 0 0 0 0 385 90 93,599 0 0 rio.public.temp0000286968 8 0 0 0 0 0 0 8,477 29 504,769 0 0 brasilia.pg_catalog.pg_class 8 8 0 0 0 0 0 1,581 383 638,843 22 71 brasilia.pg_catalog.pg_type 8 8 0 0 0 0 0 683 178 258,262 15 40 rio.public.temp0000286112 8 0 0 0 0 0 0 476 139 196,964 0 0 template1.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 957 162 342,444 75 150 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,739 1,779 7,507,411 879 3,579 rio.public.temp0000287012 7 0 0 0 0 0 0 675 36 45,752 0 0 rio.public.temp0000287016 7 0 0 0 0 0 0 2,399 34 146,789 0 0 rio.public.usuarios 6 4 0 0 0 0 0 134 46 76,544 8 13 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 275 66 63,885 17 29 rio.public.temp0000287034 5 0 0 0 0 0 0 5,182 1,712 2,485,705 0 0 rio.public.temp0000287038 5 0 0 0 0 0 0 5,187 21 309,314 0 0 rio.public.temp0000286682 4 0 0 0 0 0 0 329 23 22,951 0 0 rio.public.tmp_drill_0302 4 1 0 0 0 0 0 39 5 9,484 0 0 contagem.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 593 173 299,772 25 55 contagem.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,816 910 3,587,942 488 2,824 rio.public.tmp_drill_0175 4 4 0 0 0 0 0 2,035 12 350,608 0 0 contagem.public.nf_entrada 4 4 0 0 0 0 0 689 156 246,767 41 456 contagem.public.temp0000226720 3 0 0 0 0 0 0 321 18 21,805 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 947 260 445,826 4 30 rio.public.temp0000286988 3 0 0 0 0 0 0 3,390 1,701 2,375,697 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,852 333 1,961,448 157 486 rio.public.temp0000287026 3 0 0 0 0 0 0 5,082 12 301,647 0 0 rio.public.temp0000286958 2 0 0 0 0 0 0 12 9 3,977 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 269 24 74,063 3 5 brasilia.public.nf_entrada 2 2 0 0 0 0 0 439 150 225,143 7 8 rio.public.temp0000286572 2 0 0 0 0 0 0 130 11 9,559 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,106 253 1,131,220 178 1,442 rio.public.temp0000286966 2 0 0 0 0 0 0 1,699 7 101,382 0 0 rio.public.temp0000287020 2 0 0 0 0 0 0 188 99 186,549 0 0 rio.public.temp0000287056 2 0 0 0 0 0 0 3,390 1,699 2,378,113 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 298 68 266,922 23 59 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 357 68 257,313 24 58 rio.public.temp0000286950 2 0 0 0 0 0 0 1,759 8 104,987 0 0 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 301 62 148,492 4 6 rio.public.temp0000286970 2 0 0 0 0 0 0 71 7 5,330 0 0 brasilia.public.temp0000237188 2 0 0 0 0 0 0 490 12 31,191 0 0 contagem.public.temp0000226728 2 0 0 0 0 0 0 115 11 8,612 0 0 rio.public.temp0000287032 2 0 0 0 0 0 0 8 6 1,548 0 0 brasilia.public.temp0000237154 1 0 0 0 0 0 0 245 6 15,605 0 0 rio.public.temp0000286964 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000287064 1 0 0 0 0 0 0 148 6 9,741 0 0 rio.public.temp0000287014 1 0 0 0 0 0 0 128 4 8,155 0 0 brasilia.public.lote_caixas 1 1 0 0 0 0 0 178 120 446,833 15 1,078 brasilia.public.giga_testes 1 1 0 0 0 0 0 4,989 3,995 13,003,020 29 452 contagem.public.notas_fiscais 1 1 0 0 0 0 0 210 138 489,472 15 1,945 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 41,116 28,584 35,523,974 5,764 133,168 contagem.public.temp0000226726 1 0 0 0 0 0 0 107 6 7,268 0 0 rio.public.temp0000286972 1 0 0 0 0 0 0 67 4 4,556 0 0 rio.public.temp0000287004 1 0 0 0 0 0 0 8 5 1,299 0 0 Total 495 284 0 0 0 0 0 246,508 59,167 108,234,504 8,436 157,092 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (10.21) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.17 contagem.public.temp0000226722 0 0 0.52 contagem.pg_catalog.pg_attribute 0 0 2.16 rio.pg_catalog.pg_class 0 0 0.82 rio.public.temp0000286974 0 0 0.56 rio.pg_catalog.pg_type 0 0 0.27 contagem.pg_catalog.pg_class 0 0 0.58 contagem.pg_catalog.pg_type 0 0 0.42 rio.public.temp0000287030 0 0 0.9 rio.public.temp0000286954 0 0 0.7 contagem.pg_catalog.pg_depend 0 0 0.66 contagem.pg_catalog.pg_index 0 0 0.28 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 1.4 rio.pg_catalog.pg_index 0 0 0.33 rio.public.temp0000286684 0 0 0.18 rio.pg_catalog.pg_depend 0 0 1.04 rio.public.temp0000285404 0 0 0.14 rio.public.temp0000286968 0 0 0.45 brasilia.pg_catalog.pg_class 0 0 0.26 brasilia.pg_catalog.pg_type 0 0 0.18 rio.public.temp0000286112 0 0 0.14 template1.pg_catalog.pg_shdepend 0 0 0.32 rio.pg_catalog.pg_statistic 0 0 1.24 rio.public.temp0000287012 0 0 0.09 rio.public.temp0000287016 0 0 0.11 rio.public.usuarios 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.06 rio.public.temp0000287034 0 0 0.26 rio.public.temp0000287038 0 0 0.21 rio.public.temp0000286682 0 0 0.05 rio.public.tmp_drill_0302 0 0 0.03 contagem.pg_catalog.pg_shdepend 0 0 0.29 contagem.pg_catalog.pg_statistic 0 0 0.45 rio.public.tmp_drill_0175 0 0 0.08 contagem.public.nf_entrada 0 0 0.07 contagem.public.temp0000226720 0 0 0.04 brasilia.pg_catalog.pg_depend 0 0 0.16 rio.public.temp0000286988 0 0 0.17 rio.pg_toast.pg_toast_2619 0 0 0.23 rio.public.temp0000287026 0 0 0.15 rio.public.temp0000286958 0 0 0.01 rio.pg_catalog.pg_shdepend 0 0 0.08 brasilia.public.nf_entrada 0 0 0.08 rio.public.temp0000286572 0 0 0.04 brasilia.pg_catalog.pg_statistic 0 0 0.26 rio.public.temp0000286966 0 0 0.05 rio.public.temp0000287020 0 0 0.02 rio.public.temp0000287056 0 0 0.15 contagem.pg_toast.pg_toast_2619 0 0 0.02 brasilia.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000286950 0 0 0.05 postgres.pg_catalog.pg_shdepend 0 0 0.15 rio.public.temp0000286970 0 0 0.04 brasilia.public.temp0000237188 0 0 0.03 contagem.public.temp0000226728 0 0 0.04 rio.public.temp0000287032 0 0 0.1 brasilia.public.temp0000237154 0 0 0.02 rio.public.temp0000286964 0 0 0 rio.public.temp0000287064 0 0 0.02 rio.public.temp0000287014 0 0 0 brasilia.public.lote_caixas 0 0 0.15 brasilia.public.giga_testes 0 0 2.65 contagem.public.notas_fiscais 0 0 0.11 contagem.auditor.auditor_2026_07 0 0 10.21 contagem.public.temp0000226726 0 0 0.02 rio.public.temp0000286972 0 0 0 rio.public.temp0000287004 0 0 0.02 Total 0 0 33.5 Tuples removed per table
Key values
- pg_catalog.pg_attribute (270156) Main table with removed tuples on database contagem
- 703581 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain contagem.pg_catalog.pg_attribute 28 28 270,156 732,822 68 1,280 26,660 rio.pg_catalog.pg_attribute 35 35 157,419 880,231 23,403 283 22,380 brasilia.pg_catalog.pg_attribute 14 14 61,813 316,029 775 127 7,996 contagem.pg_catalog.pg_depend 15 15 41,067 293,403 12 106 3,292 rio.public.tmp_drill_0175 4 4 29,728 30,731 0 0 775 contagem.pg_catalog.pg_type 18 18 22,671 51,753 4 110 2,171 contagem.auditor.auditor_2026_07 1 0 18,880 3,467,628 0 0 154,422 rio.pg_catalog.pg_statistic 7 7 12,870 56,567 0 0 9,002 contagem.pg_catalog.pg_index 14 14 12,160 26,593 0 47 1,053 contagem.public.nf_entrada 4 4 9,706 4,360 235 0 316 rio.pg_catalog.pg_type 19 19 8,325 44,163 880 7 1,409 template1.pg_catalog.pg_shdepend 7 7 7,591 94,982 0 0 833 contagem.pg_catalog.pg_statistic 4 4 7,504 30,984 0 0 4,044 rio.pg_catalog.pg_depend 10 10 7,102 185,364 2,852 0 1,826 brasilia.pg_catalog.pg_statistic 2 2 5,197 15,430 0 0 2,144 contagem.pg_catalog.pg_class 19 19 3,906 83,825 8 233 4,760 contagem.pg_catalog.pg_shdepend 4 4 3,878 54,388 34 0 476 postgres.pg_catalog.pg_shdepend 2 2 3,652 27,137 3 0 238 rio.pg_catalog.pg_index 12 12 3,522 23,577 613 0 684 rio.pg_catalog.pg_shdepend 2 2 3,084 27,108 3 0 238 rio.pg_catalog.pg_class 27 23 2,573 101,431 7,384 45 3,536 brasilia.pg_catalog.pg_depend 3 3 1,988 52,848 0 0 552 brasilia.pg_catalog.pg_type 8 8 1,577 17,682 4 12 526 brasilia.pg_catalog.pg_index 5 5 1,468 9,375 0 5 266 rio.pg_toast.pg_toast_2619 3 3 1,092 2,271 1 0 873 brasilia.pg_catalog.pg_class 8 8 964 26,988 0 22 931 contagem.public.usuarios 14 0 892 336 0 0 28 contagem.public.notas_fiscais 1 1 842 42,711 0 0 248 brasilia.public.nf_entrada 2 2 609 8,315 0 0 304 rio.public.tmp_drill_0302 4 1 430 62,280 30,925 0 791 brasilia.pg_toast.pg_toast_2619 2 2 216 281 0 0 136 rio.public.usuarios 6 4 210 3,761 707 0 108 brasilia.public.giga_testes 1 1 197 700,215 0 0 18,498 contagem.pg_toast.pg_toast_2619 2 2 181 236 0 0 108 brasilia.public.lote_caixas 1 1 111 129,537 0 0 1,024 contagem.public.temp0000226720 3 0 0 3,854 0 87 297 rio.public.temp0000287030 17 0 0 406,025 0 0 29,376 rio.public.temp0000286958 2 0 0 2,402 0 53 139 contagem.public.temp0000226722 29 0 0 37,417 0 841 2,871 rio.public.temp0000286682 4 0 0 15,425 0 104 344 brasilia.public.temp0000237154 1 0 0 3,154 0 19 237 rio.public.temp0000286988 3 0 0 71,565 0 0 5,184 rio.public.temp0000286572 2 0 0 11,526 0 62 258 rio.public.temp0000286968 8 0 0 190,795 0 0 13,824 rio.public.temp0000286964 1 0 0 1,078 0 0 64 rio.public.temp0000287064 1 0 0 6,241 0 52 140 rio.public.temp0000286966 2 0 0 24,967 0 0 1,792 rio.public.temp0000287034 5 0 0 97,045 0 42 6,998 rio.public.temp0000287012 7 0 0 39,579 0 202 886 rio.public.temp0000287020 2 0 0 3,032 0 84 172 rio.public.temp0000287014 1 0 0 5,531 0 0 128 rio.public.temp0000287038 5 0 0 97,095 0 39 7,001 rio.public.temp0000287056 2 0 0 47,774 0 0 3,456 rio.public.temp0000287026 3 0 0 71,616 0 0 5,184 rio.public.temp0000286954 17 0 0 315,165 0 221 22,755 rio.public.temp0000286950 2 0 0 24,939 0 0 1,792 contagem.public.temp0000226726 1 0 0 1,286 0 29 99 rio.public.temp0000286970 2 0 0 24,966 0 0 1,792 brasilia.public.temp0000237188 2 0 0 6,312 0 38 474 contagem.public.temp0000226728 2 0 0 2,582 0 58 198 rio.public.temp0000287016 7 0 0 49,194 0 147 2,413 rio.public.temp0000286684 12 0 0 40,204 0 250 902 rio.public.temp0000286112 8 0 0 32,042 0 311 713 rio.public.temp0000286972 1 0 0 1,078 0 0 64 rio.public.temp0000287032 2 0 0 47,749 0 0 3,456 rio.public.temp0000287004 1 0 0 1,333 0 52 76 rio.public.temp0000286974 23 0 0 191,121 0 721 11,759 rio.public.temp0000285404 9 0 0 23,590 0 309 523 Total 495 284 703,581 9,503,024 67,911 5,998 398,015 Pages removed per table
Key values
- pg_catalog.pg_attribute (1280) Main table with removed pages on database contagem
- 5998 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_attribute 28 28 270156 1280 contagem.public.temp0000226722 29 0 0 841 rio.public.temp0000286974 23 0 0 721 rio.public.temp0000286112 8 0 0 311 rio.public.temp0000285404 9 0 0 309 rio.pg_catalog.pg_attribute 35 35 157419 283 rio.public.temp0000286684 12 0 0 250 contagem.pg_catalog.pg_class 19 19 3906 233 rio.public.temp0000286954 17 0 0 221 rio.public.temp0000287012 7 0 0 202 rio.public.temp0000287016 7 0 0 147 brasilia.pg_catalog.pg_attribute 14 14 61813 127 contagem.pg_catalog.pg_type 18 18 22671 110 contagem.pg_catalog.pg_depend 15 15 41067 106 rio.public.temp0000286682 4 0 0 104 contagem.public.temp0000226720 3 0 0 87 rio.public.temp0000287020 2 0 0 84 rio.public.temp0000286572 2 0 0 62 contagem.public.temp0000226728 2 0 0 58 rio.public.temp0000286958 2 0 0 53 rio.public.temp0000287064 1 0 0 52 rio.public.temp0000287004 1 0 0 52 contagem.pg_catalog.pg_index 14 14 12160 47 rio.pg_catalog.pg_class 27 23 2573 45 rio.public.temp0000287034 5 0 0 42 rio.public.temp0000287038 5 0 0 39 brasilia.public.temp0000237188 2 0 0 38 contagem.public.temp0000226726 1 0 0 29 brasilia.pg_catalog.pg_class 8 8 964 22 brasilia.public.temp0000237154 1 0 0 19 brasilia.pg_catalog.pg_type 8 8 1577 12 rio.pg_catalog.pg_type 19 19 8325 7 brasilia.pg_catalog.pg_index 5 5 1468 5 rio.public.temp0000287030 17 0 0 0 template1.pg_catalog.pg_shdepend 7 7 7591 0 brasilia.pg_catalog.pg_depend 3 3 1988 0 rio.pg_catalog.pg_statistic 7 7 12870 0 rio.pg_catalog.pg_shdepend 2 2 3084 0 brasilia.public.nf_entrada 2 2 609 0 rio.public.temp0000286988 3 0 0 0 rio.public.temp0000286968 8 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 5197 0 rio.public.temp0000286964 1 0 0 0 rio.public.temp0000286966 2 0 0 0 rio.public.tmp_drill_0302 4 1 430 0 rio.pg_catalog.pg_depend 10 10 7102 0 rio.pg_catalog.pg_index 12 12 3522 0 contagem.pg_catalog.pg_shdepend 4 4 3878 0 rio.public.temp0000287014 1 0 0 0 contagem.public.usuarios 14 0 892 0 brasilia.public.lote_caixas 1 1 111 0 rio.public.temp0000287056 2 0 0 0 brasilia.public.giga_testes 1 1 197 0 rio.pg_toast.pg_toast_2619 3 3 1092 0 rio.public.temp0000287026 3 0 0 0 contagem.public.notas_fiscais 1 1 842 0 contagem.pg_toast.pg_toast_2619 2 2 181 0 contagem.pg_catalog.pg_statistic 4 4 7504 0 brasilia.pg_toast.pg_toast_2619 2 2 216 0 rio.public.tmp_drill_0175 4 4 29728 0 contagem.auditor.auditor_2026_07 1 0 18880 0 rio.public.temp0000286950 2 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 3652 0 rio.public.temp0000286970 2 0 0 0 rio.public.temp0000286972 1 0 0 0 rio.public.temp0000287032 2 0 0 0 rio.public.usuarios 6 4 210 0 contagem.public.nf_entrada 4 4 9706 0 Total 495 284 703,581 5,998 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 30 00 0 0 01 0 5 02 0 0 03 0 0 04 0 2 05 6 3 06 0 3 07 17 37 08 67 88 09 33 89 10 78 120 11 43 86 12 6 14 13 62 118 14 74 147 15 40 112 16 48 135 17 17 31 18 0 0 19 0 0 20 0 0 21 4 6 22 0 0 23 0 0 - 10.21 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 2m16s 2m16s 2m16s 2m16s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 08:37:30 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 00:05:30 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 20:15:10 Database: rio User: intelifix Remote: [local] Application: psql
2 1 42s466ms 42s466ms 42s466ms 42s466ms call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 15:35:51 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 00:05:19 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 22:45:16 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 2m16s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-30 08:37:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 42s466ms CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-07-30 15:35:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,522 Total read queries
- 1,568 Total write queries
Queries by database
Key values
- rio Main database
- 3,819 Requests
- 5h59m25s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,440 Requests
User Request type Count Duration etiquetas Total 34 6s872ms select 34 6s872ms intelifix Total 6,440 8h11m24s copy to 415 45m22s ddl 1,153 47m10s others 495 43m16s select 4,376 5h55m34s lenon Total 112 2m8s select 112 2m8s Duration by user
Key values
- 8h11m24s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 34 6s872ms select 34 6s872ms intelifix Total 6,440 8h11m24s copy to 415 45m22s ddl 1,153 47m10s others 495 43m16s select 4,376 5h55m34s lenon Total 112 2m8s select 112 2m8s Queries by host
Key values
- [local] Main host
- 6,586 Requests
- 8h13m39s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,437 Requests
- 4h19m27s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-30 10:58:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,346 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 09:14:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 15:14:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m11s analyze verbose;[ Date: 2026-07-30 05:09:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 14:14:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 11:14:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 07:13:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 12:13:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 10:13:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 16:13:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 17:12:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-29'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-07-30 15:28:48 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 7m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 20:12:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 08:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m29s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027817, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-30 09:53:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027843, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-30 14:36:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 13:11:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 6m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027826, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-30 11:11:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-30 21:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027854, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-30 15:35:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027814, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-30 09:09:54 - 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 2h9m39s 48 1s529ms 9m25s 2m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 30 07 3 9m29s 3m9s 08 3 7m18s 2m26s 09 3 10m10s 3m23s 10 3 9m11s 3m3s 11 3 9m58s 3m19s 12 3 9m23s 3m7s 13 3 6m24s 2m8s 14 3 9m46s 3m15s 15 3 10m2s 3m20s 16 3 8m43s 2m54s 17 3 8m16s 2m45s 18 3 5m49s 1m56s 19 3 5m32s 1m50s 20 3 7m36s 2m32s 21 3 6m17s 2m5s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 2h9m39s - Times executed: 48 ]
[ Application: psql - Total duration: 2h9m39s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 09:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 15:14:24 Duration: 9m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 14:14:09 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql
2 1h22m11s 354 153ms 7m29s 13s932ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 30 07 16 5s859ms 366ms 08 38 22m12s 35s56ms 09 32 14m25s 27s42ms 10 49 1m52s 2s287ms 11 27 7m1s 15s605ms 12 4 1s554ms 388ms 13 53 1m18s 1s473ms 14 44 16m36s 22s652ms 15 26 13m48s 31s855ms 16 44 3m9s 4s310ms 17 21 1m40s 4s807ms [ User: intelifix - Total duration: 1h22m11s - Times executed: 354 ]
[ Application: [unknown] - Total duration: 1h22m11s - Times executed: 354 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-29'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-30 15:28:48 Duration: 7m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027817, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-30 09:53:37 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027843, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-30 14:36:35 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h18m15s 48 249ms 5m 1m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 30 07 3 5m4s 1m41s 08 3 4m59s 1m39s 09 3 6m5s 2m1s 10 3 5m7s 1m42s 11 3 6m10s 2m3s 12 3 5m13s 1m44s 13 3 3m55s 1m18s 14 3 5m42s 1m54s 15 3 5m36s 1m52s 16 3 5m9s 1m43s 17 3 4m52s 1m37s 18 3 3m50s 1m16s 19 3 3m45s 1m15s 20 3 4m52s 1m37s 21 3 4m5s 1m21s 22 3 3m45s 1m15s [ User: intelifix - Total duration: 1h18m15s - Times executed: 48 ]
[ Application: psql - Total duration: 1h18m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-30 11:21:04 Duration: 5m Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-30 09:21:05 Duration: 4m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-30 14:20:24 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
4 19m57s 106 1s786ms 49s622ms 11s295ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 30 07 7 1m28s 12s572ms 08 12 1m44s 8s739ms 09 7 1m48s 15s526ms 10 6 1m16s 12s729ms 11 8 2m4s 15s592ms 12 11 58s817ms 5s347ms 13 6 1m10s 11s751ms 14 8 2m 15s72ms 15 16 3m10s 11s890ms 16 16 2m27s 9s235ms 17 9 1m46s 11s862ms [ User: intelifix - Total duration: 19m57s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 19m57s - Times executed: 106 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 07:37:47 Duration: 49s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 09:22:01 Duration: 48s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 14:31:38 Duration: 46s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 19m39s 1,238 150ms 6s27ms 953ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 30 08 107 1m23s 783ms 09 153 3m25s 1s340ms 10 147 2m39s 1s83ms 11 143 2m41s 1s130ms 12 29 30s117ms 1s38ms 13 67 1m24s 1s259ms 14 217 3m10s 876ms 15 203 2m35s 767ms 16 136 1m30s 667ms 17 36 18s574ms 515ms [ User: intelifix - Total duration: 19m39s - Times executed: 1238 ]
[ Application: [unknown] - Total duration: 19m39s - Times executed: 1238 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272349, 503, '863400606402813,241766280017,241767039292,241767012748,241762300313,241770871228,241773714041$Z87325051028843,241740004960,241745192930,241768407901,241761112329,241766906979,241762192042,241745268593,241760970116,241747934769,241744080611$Z87325051026506,241739771223,241743625257,241766914152,241748145676$Z87325051008803,241687987077,241769686476,241766147578,241769548506,241748000511$Z87325051029465,241740067188,241766591416,241773710809,241770841629,241770857084,241743123334$Z87325051018476,241738968204,241768296172,241748088600,241748065769$Z87325051027422,241739862848,241767056365,241767002848,241763658491$Z87325051008516,241738024060', '',0464,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-30 10:39:42 Duration: 6s27ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50253, 417, '835072911000854,241659859797,241604720815,241711201117,241659640204,241597401627,241727009012,241727510711,241728703543,241698688504,241636066275,241604800015,241654478599,241713741926,230043629510,241671557090,241617427789,241647992030,241676709703,241592186987,230043581324,241711187478,241646283838,241664755259,241671556080,241783849901,241628182734,241664841329,241732105255,241595004041,241645524359,241695561319,241669220219,241593454754,241678322936,241607827694,241668279509,241671567900,241659680915,241614498705,241602690314,241599310523,241659770520,241713704952,241713707275,241663120308,241702249906,241673329104,241646413447,241678301924,241592091322', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"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-30 15:16:04 Duration: 5s374ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48450, 407, '226327303047', '',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-30 09:07:02 Duration: 5s368ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 16m9s 3 2m29s 9m11s 5m23s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 30 05 3 16m9s 5m23s [ User: intelifix - Total duration: 16m9s - Times executed: 3 ]
[ Application: psql - Total duration: 16m9s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-30 05:09:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-30 05:13:42 Duration: 4m29s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-30 05:16:11 Duration: 2m29s Database: contagem User: intelifix Remote: [local] Application: psql
7 12m36s 276 202ms 2m22s 2s739ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 30 00 12 32s716ms 2s726ms 01 12 23s328ms 1s944ms 02 12 23s282ms 1s940ms 03 12 24s622ms 2s51ms 04 12 23s517ms 1s959ms 05 12 25s561ms 2s130ms 06 12 22s316ms 1s859ms 07 12 24s17ms 2s1ms 08 12 2m47s 13s989ms 09 12 35s43ms 2s920ms 10 12 29s500ms 2s458ms 11 12 29s366ms 2s447ms 12 12 23s799ms 1s983ms 13 12 26s310ms 2s192ms 14 12 31s885ms 2s657ms 15 12 35s474ms 2s956ms 16 12 29s772ms 2s481ms 17 12 23s257ms 1s938ms 18 12 24s54ms 2s4ms 19 12 22s343ms 1s861ms 20 12 31s245ms 2s603ms 21 12 22s639ms 1s886ms 22 12 24s77ms 2s6ms [ User: intelifix - Total duration: 12m36s - Times executed: 276 ]
[ Application: psql - Total duration: 12m36s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 08:37:30 Duration: 2m22s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 00:05:30 Duration: 10s720ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 20:15:10 Duration: 8s685ms Database: rio User: intelifix Remote: [local] Application: psql
8 8m54s 43 10s84ms 34s495ms 12s422ms create table temp0000286954 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 30 08 23 4m49s 12s579ms 09 14 2m51s 12s259ms 11 6 1m13s 12s197ms [ User: intelifix - Total duration: 8m54s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 43 ]
-
CREATE TABLE temp0000286954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:05:19 Duration: 34s495ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 09:02:59 Duration: 14s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:31:40 Duration: 14s112ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m30s 159 297ms 49s262ms 3s210ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 30 00 6 25s965ms 4s327ms 01 6 10s872ms 1s812ms 02 6 8s693ms 1s448ms 03 5 9s611ms 1s922ms 04 6 11s394ms 1s899ms 05 5 7s366ms 1s473ms 06 6 9s280ms 1s546ms 07 11 37s259ms 3s387ms 08 12 43s460ms 3s621ms 09 12 48s101ms 4s8ms 10 12 40s80ms 3s340ms 11 12 47s979ms 3s998ms 12 12 33s177ms 2s764ms 13 6 7s152ms 1s192ms 14 12 40s739ms 3s394ms 15 12 1m21s 6s771ms 16 9 24s629ms 2s736ms 17 5 3s627ms 725ms 22 4 19s868ms 4s967ms [ User: intelifix - Total duration: 8m30s - Times executed: 159 ]
[ Application: psql - Total duration: 8m30s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 15:35:51 Duration: 49s262ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 00:05:19 Duration: 18s599ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 22:45:16 Duration: 14s710ms Database: rio User: intelifix Remote: [local] Application: psql
10 8m13s 896 152ms 2s605ms 550ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 30 06 2 1s240ms 620ms 07 137 1m21s 595ms 08 87 46s33ms 529ms 09 101 57s388ms 568ms 10 108 50s737ms 469ms 11 135 1m12s 540ms 12 23 10s826ms 470ms 13 71 38s655ms 544ms 14 92 50s760ms 551ms 15 81 51s369ms 634ms 16 52 28s559ms 549ms 17 7 3s459ms 494ms [ User: intelifix - Total duration: 8m13s - Times executed: 896 ]
[ Application: [unknown] - Total duration: 8m13s - Times executed: 896 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272806", "modelo" : "320", "itens" : "241672183650,241595647594,241673089608,241622441624,241672317579,241703539617,241732100710,241717172833,241645732640,241712682642,241595224747,241697058603,241654488601,241727046871,241646337984,241728679297,241712508708,241729513353,241604746978,241729499412,241654357274,241592970207,241599299309,241660140612,241712528585,241604665051,241666919309,241614465368,241594984668,241708741326,241708868587,241731233543,241727039799,241654359799,241676719704,241622639296,241654470721,241731013645,241676733948,241713698486,241700944762,241619592648,241708817393,241620809095,241704298792,241710956973,241663012542,241636056173", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-30 11:57:25 Duration: 2s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272805", "modelo" : "320", "itens" : "241655362334,241703713652,230049074856,241677320527,241689021938,241734177982,241710295764,241654339696,241672348996,241697122728,241665935666,241659697279,241618222323,241704737780,241728548601,241688998096,241664123245,241689403546,230049073038,241673331933,241657979413,241620724161,241620832331,241732058910,241689885467,241712511234,241599424046,241673362643,241599251729,241727013838,241653151737,241728677681,241704235476,241692606473,241622591919,241676825270,241614463146,241714952639,241668194046,241704267981,241701037778,241593463745,241607301931,241728678691,241654498298,241617923955,241694292845,241704166984", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-30 11:48:28 Duration: 2s460ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272807", "modelo" : "320", "itens" : "241607637294,241609882744,241730910729,230048471734,241646162435,241727039496,241677698295,241692679915,241597466683,241729515070,241671921122,241669282020,241727276770,241671569314,241692626172,230048492443,241635567887,241695003655,241670430101,241635166580,241667077483,241603744344,241619382324,241726883141,241701154962,241617554143,241646237795,241598102941,241596597698,241663296688,241616287083,241726884959,241619476373,241680321616,241650819915,241637704965,241712536566,241700844045,241604318294,241678324148,241654587476,241654495773,241622487183,241708938998,241689452642,241714875257,241694145557,241660320102", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-30 13:18:03 Duration: 2s32ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 4m21s 22 9s708ms 14s58ms 11s892ms create table temp0000286974 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 30 10 7 1m19s 11s371ms 11 15 3m2s 12s134ms [ User: intelifix - Total duration: 4m21s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m21s - Times executed: 22 ]
-
CREATE TABLE temp0000286974 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 11:33:05 Duration: 14s58ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286974 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 11:17:05 Duration: 13s522ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286974 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 11:28:44 Duration: 13s301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m17s 18 10s658ms 32s344ms 14s320ms create table temp0000287034 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 30 14 9 1m58s 13s208ms 15 9 2m18s 15s433ms [ User: intelifix - Total duration: 4m17s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 4m17s - Times executed: 18 ]
-
CREATE TABLE temp0000287034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 15:27:56 Duration: 32s344ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 14:30:06 Duration: 15s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 15:51:16 Duration: 15s42ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m3s 561 150ms 2s637ms 434ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 30 13 6 2s379ms 396ms 14 382 3m13s 506ms 15 173 47s792ms 276ms [ User: intelifix - Total duration: 4m3s - Times executed: 561 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 561 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"130949","seriais":"241660462944,241671943548,241604373755,241667594661,241604380827,241671975167,241658690022,241620569498,241646699008,241652248304,241672635568,241650485359,241689793034,241691599999,241710946265,230040178398,241663007086,241676184949,241662986579,241649394355,241665055569,241662656872,241679358705,230040165771,241655165165,241620578590,241628064664,241638316472,241664938385,241646827482,241646393445,241667612946,241609728485,241675287173,241616247180,241609267879","usuario":"399","observacao":""}');
Date: 2026-07-30 14:01:23 Duration: 2s637ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"130949","seriais":"230049196585,241691703344,241710857087,241675287072,241655134051,241665213441,241710863048,241607630224,241614628997,241615117990,241658640118,241667659718,241651311737,241618458181,241652111321,241630820624,241680700823,241708998904,241716413758,241665012434,241728792340,241628059714,241694443140,241621476265,241606475980,241710901234,241652379910,241637383340,241726136569,241669644255,241658672040,241679317589,241594129500,241665232635,241671924556,241652147687,241620628090,241677394450,241711067489,241635723840","usuario":"399","observacao":""}');
Date: 2026-07-30 14:28:24 Duration: 2s239ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"130949","seriais":"241628058906,241628057491,241710870524,241628066785,241620624353,241672760104,241712645062,241716505764,241712640012,241656887577,241700819294,241667944852,241595410221,241616761833,241595447395,241712759393,241618297178,241630925762,241728795471,241614574649,241603461635,241672688907,241665126687,241667929496,241694440211,241607630123,241616746881,241620625060,241609280811,241667245861,241593835779,241599443442,241628057794,230039853036,241664998189,241665003746,241622364242,241660567678,241665345272,241664989300","usuario":"399","observacao":""}');
Date: 2026-07-30 14:32:10 Duration: 2s183ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 3m58s 20 10s216ms 14s856ms 11s925ms create table temp0000287030 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 30 14 9 1m50s 12s289ms 15 3 39s53ms 13s17ms 16 8 1m28s 11s105ms [ User: intelifix - Total duration: 3m58s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m58s - Times executed: 20 ]
-
CREATE TABLE temp0000287030 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 15:40:36 Duration: 14s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287030 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 14:30:39 Duration: 14s357ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287030 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 14:07:34 Duration: 13s301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m4s 24 979ms 41s758ms 7s670ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 30 10 4 1m3s 15s817ms 13 13 1m28s 6s795ms 14 4 11s492ms 2s873ms 17 3 20s974ms 6s991ms [ User: intelifix - Total duration: 3m4s - Times executed: 24 ]
[ Application: psql - Total duration: 3m4s - Times executed: 24 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01586);
Date: 2026-07-30 10:41:11 Duration: 41s758ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01593);
Date: 2026-07-30 13:58:01 Duration: 24s80ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01587);
Date: 2026-07-30 10:45:14 Duration: 15s619ms Database: contagem User: intelifix Remote: [local] Application: psql
16 3m 4 4s705ms 1m25s 45s39ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 30 20 2 1m30s 45s196ms 23 2 1m29s 44s883ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-30 20:08:30 Duration: 1m25s 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-30 23:16:25 Duration: 1m25s 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-30 20:10:20 Duration: 4s895ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m30s 12 10s870ms 14s748ms 12s531ms create table temp0000286968 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 30 08 9 1m52s 12s484ms 09 3 38s19ms 12s673ms [ User: intelifix - Total duration: 2m30s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 12 ]
-
CREATE TABLE temp0000286968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:52:59 Duration: 14s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 09:11:46 Duration: 14s48ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:42:04 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m21s 39 671ms 20s447ms 3s620ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 30 08 2 23s300ms 11s650ms 09 2 6s719ms 3s359ms 10 2 10s293ms 5s146ms 11 3 20s809ms 6s936ms 12 3 11s906ms 3s968ms 13 3 8s710ms 2s903ms 14 3 14s144ms 4s714ms 15 3 12s519ms 4s173ms 16 3 12s998ms 4s332ms 17 3 7s292ms 2s430ms 18 2 2s476ms 1s238ms 19 3 2s786ms 928ms 20 2 2s573ms 1s286ms 21 3 2s547ms 849ms 22 2 2s101ms 1s50ms [ User: intelifix - Total duration: 2m21s - Times executed: 39 ]
[ Application: psql - Total duration: 2m21s - Times executed: 39 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-30 08:00:22 Duration: 20s447ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-30 11:40:12 Duration: 10s444ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-30 12:00:11 Duration: 9s729ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m 40 168ms 15s32ms 3s22ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 30 08 3 17s600ms 5s866ms 09 3 25s115ms 8s371ms 10 4 7s582ms 1s895ms 11 4 19s338ms 4s834ms 13 15 6s157ms 410ms 14 6 27s506ms 4s584ms 15 2 16s31ms 8s15ms 17 3 1s549ms 516ms [ User: intelifix - Total duration: 2m - Times executed: 40 ]
[ Application: psql - Total duration: 2m - Times executed: 40 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027817);
Date: 2026-07-30 09:46:51 Duration: 15s32ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027843);
Date: 2026-07-30 14:30:04 Duration: 12s469ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027803);
Date: 2026-07-30 08:08:29 Duration: 12s108ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m57s 4 406ms 58s647ms 29s363ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 30 20 2 59s145ms 29s572ms 23 2 58s307ms 29s153ms [ User: intelifix - Total duration: 1m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-30 20:05:27 Duration: 58s647ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-30 23:13:20 Duration: 57s900ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-30 20:09:46 Duration: 497ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,238 19m39s 150ms 6s27ms 953ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 30 08 107 1m23s 783ms 09 153 3m25s 1s340ms 10 147 2m39s 1s83ms 11 143 2m41s 1s130ms 12 29 30s117ms 1s38ms 13 67 1m24s 1s259ms 14 217 3m10s 876ms 15 203 2m35s 767ms 16 136 1m30s 667ms 17 36 18s574ms 515ms [ User: intelifix - Total duration: 19m39s - Times executed: 1238 ]
[ Application: [unknown] - Total duration: 19m39s - Times executed: 1238 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272349, 503, '863400606402813,241766280017,241767039292,241767012748,241762300313,241770871228,241773714041$Z87325051028843,241740004960,241745192930,241768407901,241761112329,241766906979,241762192042,241745268593,241760970116,241747934769,241744080611$Z87325051026506,241739771223,241743625257,241766914152,241748145676$Z87325051008803,241687987077,241769686476,241766147578,241769548506,241748000511$Z87325051029465,241740067188,241766591416,241773710809,241770841629,241770857084,241743123334$Z87325051018476,241738968204,241768296172,241748088600,241748065769$Z87325051027422,241739862848,241767056365,241767002848,241763658491$Z87325051008516,241738024060', '',0464,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-30 10:39:42 Duration: 6s27ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50253, 417, '835072911000854,241659859797,241604720815,241711201117,241659640204,241597401627,241727009012,241727510711,241728703543,241698688504,241636066275,241604800015,241654478599,241713741926,230043629510,241671557090,241617427789,241647992030,241676709703,241592186987,230043581324,241711187478,241646283838,241664755259,241671556080,241783849901,241628182734,241664841329,241732105255,241595004041,241645524359,241695561319,241669220219,241593454754,241678322936,241607827694,241668279509,241671567900,241659680915,241614498705,241602690314,241599310523,241659770520,241713704952,241713707275,241663120308,241702249906,241673329104,241646413447,241678301924,241592091322', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"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-30 15:16:04 Duration: 5s374ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48450, 407, '226327303047', '',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-30 09:07:02 Duration: 5s368ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 896 8m13s 152ms 2s605ms 550ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 30 06 2 1s240ms 620ms 07 137 1m21s 595ms 08 87 46s33ms 529ms 09 101 57s388ms 568ms 10 108 50s737ms 469ms 11 135 1m12s 540ms 12 23 10s826ms 470ms 13 71 38s655ms 544ms 14 92 50s760ms 551ms 15 81 51s369ms 634ms 16 52 28s559ms 549ms 17 7 3s459ms 494ms [ User: intelifix - Total duration: 8m13s - Times executed: 896 ]
[ Application: [unknown] - Total duration: 8m13s - Times executed: 896 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272806", "modelo" : "320", "itens" : "241672183650,241595647594,241673089608,241622441624,241672317579,241703539617,241732100710,241717172833,241645732640,241712682642,241595224747,241697058603,241654488601,241727046871,241646337984,241728679297,241712508708,241729513353,241604746978,241729499412,241654357274,241592970207,241599299309,241660140612,241712528585,241604665051,241666919309,241614465368,241594984668,241708741326,241708868587,241731233543,241727039799,241654359799,241676719704,241622639296,241654470721,241731013645,241676733948,241713698486,241700944762,241619592648,241708817393,241620809095,241704298792,241710956973,241663012542,241636056173", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-30 11:57:25 Duration: 2s605ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272805", "modelo" : "320", "itens" : "241655362334,241703713652,230049074856,241677320527,241689021938,241734177982,241710295764,241654339696,241672348996,241697122728,241665935666,241659697279,241618222323,241704737780,241728548601,241688998096,241664123245,241689403546,230049073038,241673331933,241657979413,241620724161,241620832331,241732058910,241689885467,241712511234,241599424046,241673362643,241599251729,241727013838,241653151737,241728677681,241704235476,241692606473,241622591919,241676825270,241614463146,241714952639,241668194046,241704267981,241701037778,241593463745,241607301931,241728678691,241654498298,241617923955,241694292845,241704166984", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-30 11:48:28 Duration: 2s460ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272807", "modelo" : "320", "itens" : "241607637294,241609882744,241730910729,230048471734,241646162435,241727039496,241677698295,241692679915,241597466683,241729515070,241671921122,241669282020,241727276770,241671569314,241692626172,230048492443,241635567887,241695003655,241670430101,241635166580,241667077483,241603744344,241619382324,241726883141,241701154962,241617554143,241646237795,241598102941,241596597698,241663296688,241616287083,241726884959,241619476373,241680321616,241650819915,241637704965,241712536566,241700844045,241604318294,241678324148,241654587476,241654495773,241622487183,241708938998,241689452642,241714875257,241694145557,241660320102", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-30 13:18:03 Duration: 2s32ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 561 4m3s 150ms 2s637ms 434ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 30 13 6 2s379ms 396ms 14 382 3m13s 506ms 15 173 47s792ms 276ms [ User: intelifix - Total duration: 4m3s - Times executed: 561 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 561 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"130949","seriais":"241660462944,241671943548,241604373755,241667594661,241604380827,241671975167,241658690022,241620569498,241646699008,241652248304,241672635568,241650485359,241689793034,241691599999,241710946265,230040178398,241663007086,241676184949,241662986579,241649394355,241665055569,241662656872,241679358705,230040165771,241655165165,241620578590,241628064664,241638316472,241664938385,241646827482,241646393445,241667612946,241609728485,241675287173,241616247180,241609267879","usuario":"399","observacao":""}');
Date: 2026-07-30 14:01:23 Duration: 2s637ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"130949","seriais":"230049196585,241691703344,241710857087,241675287072,241655134051,241665213441,241710863048,241607630224,241614628997,241615117990,241658640118,241667659718,241651311737,241618458181,241652111321,241630820624,241680700823,241708998904,241716413758,241665012434,241728792340,241628059714,241694443140,241621476265,241606475980,241710901234,241652379910,241637383340,241726136569,241669644255,241658672040,241679317589,241594129500,241665232635,241671924556,241652147687,241620628090,241677394450,241711067489,241635723840","usuario":"399","observacao":""}');
Date: 2026-07-30 14:28:24 Duration: 2s239ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"130949","seriais":"241628058906,241628057491,241710870524,241628066785,241620624353,241672760104,241712645062,241716505764,241712640012,241656887577,241700819294,241667944852,241595410221,241616761833,241595447395,241712759393,241618297178,241630925762,241728795471,241614574649,241603461635,241672688907,241665126687,241667929496,241694440211,241607630123,241616746881,241620625060,241609280811,241667245861,241593835779,241599443442,241628057794,230039853036,241664998189,241665003746,241622364242,241660567678,241665345272,241664989300","usuario":"399","observacao":""}');
Date: 2026-07-30 14:32:10 Duration: 2s183ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
4 354 1h22m11s 153ms 7m29s 13s932ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 30 07 16 5s859ms 366ms 08 38 22m12s 35s56ms 09 32 14m25s 27s42ms 10 49 1m52s 2s287ms 11 27 7m1s 15s605ms 12 4 1s554ms 388ms 13 53 1m18s 1s473ms 14 44 16m36s 22s652ms 15 26 13m48s 31s855ms 16 44 3m9s 4s310ms 17 21 1m40s 4s807ms [ User: intelifix - Total duration: 1h22m11s - Times executed: 354 ]
[ Application: [unknown] - Total duration: 1h22m11s - Times executed: 354 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-29'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-30 15:28:48 Duration: 7m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027817, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-30 09:53:37 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027843, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-30 14:36:35 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 276 12m36s 202ms 2m22s 2s739ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 30 00 12 32s716ms 2s726ms 01 12 23s328ms 1s944ms 02 12 23s282ms 1s940ms 03 12 24s622ms 2s51ms 04 12 23s517ms 1s959ms 05 12 25s561ms 2s130ms 06 12 22s316ms 1s859ms 07 12 24s17ms 2s1ms 08 12 2m47s 13s989ms 09 12 35s43ms 2s920ms 10 12 29s500ms 2s458ms 11 12 29s366ms 2s447ms 12 12 23s799ms 1s983ms 13 12 26s310ms 2s192ms 14 12 31s885ms 2s657ms 15 12 35s474ms 2s956ms 16 12 29s772ms 2s481ms 17 12 23s257ms 1s938ms 18 12 24s54ms 2s4ms 19 12 22s343ms 1s861ms 20 12 31s245ms 2s603ms 21 12 22s639ms 1s886ms 22 12 24s77ms 2s6ms [ User: intelifix - Total duration: 12m36s - Times executed: 276 ]
[ Application: psql - Total duration: 12m36s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 08:37:30 Duration: 2m22s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 00:05:30 Duration: 10s720ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 20:15:10 Duration: 8s685ms Database: rio User: intelifix Remote: [local] Application: psql
6 159 8m30s 297ms 49s262ms 3s210ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 30 00 6 25s965ms 4s327ms 01 6 10s872ms 1s812ms 02 6 8s693ms 1s448ms 03 5 9s611ms 1s922ms 04 6 11s394ms 1s899ms 05 5 7s366ms 1s473ms 06 6 9s280ms 1s546ms 07 11 37s259ms 3s387ms 08 12 43s460ms 3s621ms 09 12 48s101ms 4s8ms 10 12 40s80ms 3s340ms 11 12 47s979ms 3s998ms 12 12 33s177ms 2s764ms 13 6 7s152ms 1s192ms 14 12 40s739ms 3s394ms 15 12 1m21s 6s771ms 16 9 24s629ms 2s736ms 17 5 3s627ms 725ms 22 4 19s868ms 4s967ms [ User: intelifix - Total duration: 8m30s - Times executed: 159 ]
[ Application: psql - Total duration: 8m30s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 15:35:51 Duration: 49s262ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 00:05:19 Duration: 18s599ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 22:45:16 Duration: 14s710ms Database: rio User: intelifix Remote: [local] Application: psql
7 137 30s600ms 151ms 575ms 223ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 30 00 2 406ms 203ms 01 12 2s754ms 229ms 04 16 5s140ms 321ms 05 7 1s965ms 280ms 07 9 1s672ms 185ms 08 14 2s956ms 211ms 09 12 2s352ms 196ms 10 9 1s633ms 181ms 11 11 2s202ms 200ms 12 7 1s410ms 201ms 14 13 2s851ms 219ms 15 20 3s930ms 196ms 16 3 680ms 226ms 17 2 640ms 320ms [ User: intelifix - Total duration: 30s600ms - Times executed: 137 ]
[ Application: [unknown] - Total duration: 30s600ms - Times executed: 137 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241699252633,241617936178,241634351720,241669544548,241650504452,230049171533,241663012542,241710956973,241704298792,241620809095,241708817393,241727013838,241599251729,241673362643,241599424046,241712511234,241689885467,241732058910,241620832331,241620724161,241715408901,241598881031,241659787894,241634737290', NULL, NULL, 0320, 00);
Date: 2026-07-30 04:47:01 Duration: 575ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241619592648,241700944762,241713698486,241676733948,241731013645,241654470721,241622639296,241676719704,241654359799,241729493048,241636056173,241673331933,230049073038,241689403546,241664123245,241688998096,241728548601,241704737780,241618222323,241659697279', NULL, NULL, 0320, 00);
Date: 2026-07-30 04:45:03 Duration: 475ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, 'ZTEGD6407506,ZTEGDD30B884,ZTEGDB156F06,ZTEGDB009511,ZTEGDD3132DB,ZTEGDC6233F3,ZTEGDD3132DA,ZTEGD640A6D4,ZTEGDC610700,ZTEGD7BB5FE8,ZTEGDC625029,ZTEGD64191B0,ZTEGDC6EE633,ZTEGDB16C92C,ZTEGDC6F26AC,ZTEGDC61136D,ZTEGDC6E31B0,ZTEGDD31CA8A,ZTEGDC60E9F0,ZTEGD70A19CC,ZTEGD641ED07,ZTEGD70A21E1,ZTEGDB165CF5,ZTEGD971E492', NULL, NULL, 0318, 00);
Date: 2026-07-30 17:05:58 Duration: 393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 115 49s61ms 214ms 689ms 426ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 30 08 18 7s404ms 411ms 09 10 5s40ms 504ms 10 19 7s684ms 404ms 11 10 4s573ms 457ms 12 5 1s838ms 367ms 13 13 5s561ms 427ms 14 16 7s268ms 454ms 15 8 3s389ms 423ms 16 12 4s796ms 399ms 17 4 1s502ms 375ms [ User: intelifix - Total duration: 49s61ms - Times executed: 115 ]
[ Application: [unknown] - Total duration: 49s61ms - Times executed: 115 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-30 14:11:27 Duration: 689ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-30 09:47:45 Duration: 686ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-30 11:45:22 Duration: 655ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
9 106 19m57s 1s786ms 49s622ms 11s295ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 30 07 7 1m28s 12s572ms 08 12 1m44s 8s739ms 09 7 1m48s 15s526ms 10 6 1m16s 12s729ms 11 8 2m4s 15s592ms 12 11 58s817ms 5s347ms 13 6 1m10s 11s751ms 14 8 2m 15s72ms 15 16 3m10s 11s890ms 16 16 2m27s 9s235ms 17 9 1m46s 11s862ms [ User: intelifix - Total duration: 19m57s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 19m57s - Times executed: 106 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 07:37:47 Duration: 49s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 09:22:01 Duration: 48s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 14:31:38 Duration: 46s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 106 1m18s 158ms 13s986ms 741ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 30 07 14 7s411ms 529ms 08 15 6s126ms 408ms 09 2 2s19ms 1s9ms 10 6 3s646ms 607ms 13 29 21s373ms 737ms 14 6 16s721ms 2s786ms 15 10 7s577ms 757ms 16 13 9s541ms 733ms 17 11 4s212ms 382ms [ User: intelifix - Total duration: 1m18s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 106 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0130949) LIMIT 1;
Date: 2026-07-30 14:58:36 Duration: 13s986ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0272477) LIMIT 1;
Date: 2026-07-30 13:22:44 Duration: 2s255ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0272505) LIMIT 1;
Date: 2026-07-30 15:07:34 Duration: 2s228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 106 48s510ms 275ms 764ms 457ms 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 #11
Day Hour Count Duration Avg duration Jul 30 00 2 953ms 476ms 01 2 1s123ms 561ms 04 3 1s157ms 385ms 05 2 695ms 347ms 06 2 819ms 409ms 07 8 3s290ms 411ms 08 10 4s592ms 459ms 09 12 5s520ms 460ms 10 8 4s391ms 548ms 11 9 4s571ms 507ms 12 5 2s232ms 446ms 13 11 4s482ms 407ms 14 11 4s995ms 454ms 15 10 4s752ms 475ms 16 6 2s778ms 463ms 17 4 1s667ms 416ms 21 1 486ms 486ms [ User: lenon - Total duration: 48s510ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 48s510ms - Times executed: 106 ]
-
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-30 10:30:57 Duration: 764ms 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-30 10:19:25 Duration: 762ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-30 15:25:02 Duration: 740ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
12 101 22s167ms 162ms 427ms 219ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 30 08 2 701ms 350ms 09 4 1s90ms 272ms 10 3 782ms 260ms 11 5 1s352ms 270ms 12 1 354ms 354ms 13 12 2s396ms 199ms 14 24 5s422ms 225ms 15 25 5s145ms 205ms 16 25 4s921ms 196ms [ User: intelifix - Total duration: 22s167ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 22s167ms - Times executed: 101 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"001", "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-30 08:52:09 Duration: 427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"151", "usuario" :"428", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "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-30 12:12:06 Duration: 354ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"153", "usuario" :"184", "tipo" :"N", "itens" :"01", "nota-fiscal" :"6969", "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-30 11:17:51 Duration: 339ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 98 56s581ms 349ms 902ms 577ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 30 00 2 1s251ms 625ms 01 2 1s334ms 667ms 04 2 1s5ms 502ms 05 2 999ms 499ms 06 2 1s110ms 555ms 07 7 3s488ms 498ms 08 10 5s665ms 566ms 09 11 6s253ms 568ms 10 8 5s309ms 663ms 11 9 5s683ms 631ms 12 5 2s762ms 552ms 13 8 4s216ms 527ms 14 11 6s131ms 557ms 15 10 5s904ms 590ms 16 6 3s681ms 613ms 17 3 1s784ms 594ms [ User: intelifix - Total duration: 56s581ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 56s581ms - Times executed: 98 ]
-
select * from rs_menu_grants (452, 81, 1);
Date: 2026-07-30 10:30:57 Duration: 902ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (401, 53, 1);
Date: 2026-07-30 10:19:25 Duration: 896ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-07-30 08:18:32 Duration: 878ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
14 98 18s159ms 150ms 280ms 185ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 30 00 1 202ms 202ms 08 3 609ms 203ms 09 2 370ms 185ms 10 7 1s186ms 169ms 11 9 1s485ms 165ms 12 4 750ms 187ms 13 4 857ms 214ms 14 19 3s577ms 188ms 15 27 5s139ms 190ms 16 19 3s457ms 181ms 17 3 522ms 174ms [ User: intelifix - Total duration: 18s159ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 18s159ms - Times executed: 98 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "396", "data-de" : "2026-07-30", "data-ate" : "2026-07-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 450 }');
Date: 2026-07-30 15:26:24 Duration: 280ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "382", "data-de" : "2026-07-30", "data-ate" : "2026-07-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 433 }');
Date: 2026-07-30 16:12:53 Duration: 275ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "328", "data-de" : "2026-07-30", "data-ate" : "2026-07-30", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 397 }');
Date: 2026-07-30 13:34:50 Duration: 269ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 72 14s338ms 151ms 566ms 199ms create table temp0000237200 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 30 14 11 2s326ms 211ms 15 17 3s392ms 199ms 16 16 3s199ms 199ms 17 28 5s420ms 193ms [ User: intelifix - Total duration: 14s338ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 14s338ms - Times executed: 72 ]
-
CREATE TABLE temp0000237200 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "25-07-2026", "data-ate" : "30-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-30 14:14:00 Duration: 566ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237200 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "30-07-2026", "data-ate" : "30-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-30 15:19:46 Duration: 339ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237200 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "30-07-2026", "data-ate" : "30-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-30 15:41:04 Duration: 300ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 66 10s671ms 150ms 214ms 161ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 30 01 2 327ms 163ms 04 1 154ms 154ms 07 5 773ms 154ms 08 2 303ms 151ms 09 17 2s790ms 164ms 10 5 819ms 163ms 11 10 1s616ms 161ms 13 6 939ms 156ms 14 16 2s627ms 164ms 15 1 166ms 166ms 16 1 152ms 152ms [ User: intelifix - Total duration: 10s671ms - Times executed: 66 ]
[ Application: [unknown] - Total duration: 10s671ms - Times executed: 66 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0185;
Date: 2026-07-30 14:41:50 Duration: 214ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-30 09:29:30 Duration: 205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-30 11:23:03 Duration: 191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 59 27s309ms 150ms 6s843ms 462ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 30 07 5 1s122ms 224ms 08 4 1s213ms 303ms 09 4 1s76ms 269ms 10 4 701ms 175ms 11 6 1s727ms 287ms 13 2 403ms 201ms 14 12 15s552ms 1s296ms 15 9 2s26ms 225ms 16 6 1s279ms 213ms 17 7 2s205ms 315ms [ User: intelifix - Total duration: 27s309ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 27s309ms - Times executed: 59 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "46986", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000082501", "data-saida" : "2026-07-28", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE PAPEL LOTE -24", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-30 14:16:29 Duration: 6s843ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "46984", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000082502", "data-saida" : "2026-07-28", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE RIO -LOTE 24", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-30 14:16:44 Duration: 2s93ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "46989", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000082516", "data-saida" : "2026-07-28", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "CARDS - LOTE 24", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-07-30 14:15:46 Duration: 1s901ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 57 1m47s 173ms 22s562ms 1s883ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 30 08 11 19s950ms 1s813ms 09 7 18s409ms 2s629ms 10 6 7s558ms 1s259ms 11 10 3s558ms 355ms 13 3 10s489ms 3s496ms 14 14 38s22ms 2s715ms 15 3 1s752ms 584ms 16 3 7s602ms 2s534ms [ User: intelifix - Total duration: 1m47s - Times executed: 57 ]
[ Application: psql - Total duration: 1m47s - Times executed: 57 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027852);
Date: 2026-07-30 14:58:35 Duration: 22s562ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027818);
Date: 2026-07-30 09:53:22 Duration: 15s132ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027804);
Date: 2026-07-30 08:26:40 Duration: 10s146ms Database: rio User: intelifix Remote: [local] Application: psql
19 52 19s31ms 151ms 4s317ms 365ms create table temp0000286958 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 30 08 1 2s891ms 2s891ms 09 3 519ms 173ms 10 2 4s565ms 2s282ms 11 2 614ms 307ms 12 1 256ms 256ms 13 2 612ms 306ms 14 19 4s824ms 253ms 15 6 1s154ms 192ms 16 15 3s400ms 226ms 17 1 191ms 191ms [ User: intelifix - Total duration: 19s31ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 19s31ms - Times executed: 52 ]
-
CREATE TABLE temp0000286958 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-07-2026", "ate" :"30-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-30 10:12:00 Duration: 4s317ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286958 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-07-2026", "ate" :"30-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-30 08:05:00 Duration: 2s891ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286958 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"25-07-2026", "ate" :"30-07-2026", "nota-fiscal":"66673", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-30 11:08:03 Duration: 387ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 48 2h9m39s 1s529ms 9m25s 2m42s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 30 07 3 9m29s 3m9s 08 3 7m18s 2m26s 09 3 10m10s 3m23s 10 3 9m11s 3m3s 11 3 9m58s 3m19s 12 3 9m23s 3m7s 13 3 6m24s 2m8s 14 3 9m46s 3m15s 15 3 10m2s 3m20s 16 3 8m43s 2m54s 17 3 8m16s 2m45s 18 3 5m49s 1m56s 19 3 5m32s 1m50s 20 3 7m36s 2m32s 21 3 6m17s 2m5s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 2h9m39s - Times executed: 48 ]
[ Application: psql - Total duration: 2h9m39s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 09:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 15:14:24 Duration: 9m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 14:14:09 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m29s 9m11s 5m23s 3 16m9s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 30 05 3 16m9s 5m23s [ User: intelifix - Total duration: 16m9s - Times executed: 3 ]
[ Application: psql - Total duration: 16m9s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-30 05:09:12 Duration: 9m11s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-30 05:13:42 Duration: 4m29s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-30 05:16:11 Duration: 2m29s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s529ms 9m25s 2m42s 48 2h9m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 30 07 3 9m29s 3m9s 08 3 7m18s 2m26s 09 3 10m10s 3m23s 10 3 9m11s 3m3s 11 3 9m58s 3m19s 12 3 9m23s 3m7s 13 3 6m24s 2m8s 14 3 9m46s 3m15s 15 3 10m2s 3m20s 16 3 8m43s 2m54s 17 3 8m16s 2m45s 18 3 5m49s 1m56s 19 3 5m32s 1m50s 20 3 7m36s 2m32s 21 3 6m17s 2m5s 22 3 5m38s 1m52s [ User: intelifix - Total duration: 2h9m39s - Times executed: 48 ]
[ Application: psql - Total duration: 2h9m39s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 09:14:26 Duration: 9m25s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 15:14:24 Duration: 9m23s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-30 14:14:09 Duration: 9m8s Database: rio User: intelifix Remote: [local] Application: psql
3 249ms 5m 1m37s 48 1h18m15s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 30 07 3 5m4s 1m41s 08 3 4m59s 1m39s 09 3 6m5s 2m1s 10 3 5m7s 1m42s 11 3 6m10s 2m3s 12 3 5m13s 1m44s 13 3 3m55s 1m18s 14 3 5m42s 1m54s 15 3 5m36s 1m52s 16 3 5m9s 1m43s 17 3 4m52s 1m37s 18 3 3m50s 1m16s 19 3 3m45s 1m15s 20 3 4m52s 1m37s 21 3 4m5s 1m21s 22 3 3m45s 1m15s [ User: intelifix - Total duration: 1h18m15s - Times executed: 48 ]
[ Application: psql - Total duration: 1h18m15s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-30 11:21:04 Duration: 5m Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-30 09:21:05 Duration: 4m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-30 14:20:24 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s705ms 1m25s 45s39ms 4 3m copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 30 20 2 1m30s 45s196ms 23 2 1m29s 44s883ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-30 20:08:30 Duration: 1m25s 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-30 23:16:25 Duration: 1m25s 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-30 20:10:20 Duration: 4s895ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 406ms 58s647ms 29s363ms 4 1m57s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 30 20 2 59s145ms 29s572ms 23 2 58s307ms 29s153ms [ User: intelifix - Total duration: 1m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m57s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-30 20:05:27 Duration: 58s647ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-30 23:13:20 Duration: 57s900ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-30 20:09:46 Duration: 497ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 10s658ms 32s344ms 14s320ms 18 4m17s create table temp0000287034 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 30 14 9 1m58s 13s208ms 15 9 2m18s 15s433ms [ User: intelifix - Total duration: 4m17s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 4m17s - Times executed: 18 ]
-
CREATE TABLE temp0000287034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 15:27:56 Duration: 32s344ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 14:30:06 Duration: 15s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 15:51:16 Duration: 15s42ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 153ms 7m29s 13s932ms 354 1h22m11s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 30 07 16 5s859ms 366ms 08 38 22m12s 35s56ms 09 32 14m25s 27s42ms 10 49 1m52s 2s287ms 11 27 7m1s 15s605ms 12 4 1s554ms 388ms 13 53 1m18s 1s473ms 14 44 16m36s 22s652ms 15 26 13m48s 31s855ms 16 44 3m9s 4s310ms 17 21 1m40s 4s807ms [ User: intelifix - Total duration: 1h22m11s - Times executed: 354 ]
[ Application: [unknown] - Total duration: 1h22m11s - Times executed: 354 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-29'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-30 15:28:48 Duration: 7m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027817, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-30 09:53:37 Duration: 6m29s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027843, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-30 14:36:35 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s870ms 14s748ms 12s531ms 12 2m30s create table temp0000286968 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 30 08 9 1m52s 12s484ms 09 3 38s19ms 12s673ms [ User: intelifix - Total duration: 2m30s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 12 ]
-
CREATE TABLE temp0000286968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:52:59 Duration: 14s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 09:11:46 Duration: 14s48ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286968 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:42:04 Duration: 13s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s84ms 34s495ms 12s422ms 43 8m54s create table temp0000286954 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 30 08 23 4m49s 12s579ms 09 14 2m51s 12s259ms 11 6 1m13s 12s197ms [ User: intelifix - Total duration: 8m54s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m54s - Times executed: 43 ]
-
CREATE TABLE temp0000286954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:05:19 Duration: 34s495ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 09:02:59 Duration: 14s994ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286954 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 08:31:40 Duration: 14s112ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s216ms 14s856ms 11s925ms 20 3m58s create table temp0000287030 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 30 14 9 1m50s 12s289ms 15 3 39s53ms 13s17ms 16 8 1m28s 11s105ms [ User: intelifix - Total duration: 3m58s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m58s - Times executed: 20 ]
-
CREATE TABLE temp0000287030 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 15:40:36 Duration: 14s856ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287030 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 14:30:39 Duration: 14s357ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287030 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 14:07:34 Duration: 13s301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s708ms 14s58ms 11s892ms 22 4m21s create table temp0000286974 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 30 10 7 1m19s 11s371ms 11 15 3m2s 12s134ms [ User: intelifix - Total duration: 4m21s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m21s - Times executed: 22 ]
-
CREATE TABLE temp0000286974 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 11:33:05 Duration: 14s58ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286974 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 11:17:05 Duration: 13s522ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286974 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-30 11:28:44 Duration: 13s301ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s786ms 49s622ms 11s295ms 106 19m57s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 30 07 7 1m28s 12s572ms 08 12 1m44s 8s739ms 09 7 1m48s 15s526ms 10 6 1m16s 12s729ms 11 8 2m4s 15s592ms 12 11 58s817ms 5s347ms 13 6 1m10s 11s751ms 14 8 2m 15s72ms 15 16 3m10s 11s890ms 16 16 2m27s 9s235ms 17 9 1m46s 11s862ms [ User: intelifix - Total duration: 19m57s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 19m57s - Times executed: 106 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 07:37:47 Duration: 49s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 09:22:01 Duration: 48s615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-30', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-30 14:31:38 Duration: 46s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 979ms 41s758ms 7s670ms 24 3m4s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 30 10 4 1m3s 15s817ms 13 13 1m28s 6s795ms 14 4 11s492ms 2s873ms 17 3 20s974ms 6s991ms [ User: intelifix - Total duration: 3m4s - Times executed: 24 ]
[ Application: psql - Total duration: 3m4s - Times executed: 24 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01586);
Date: 2026-07-30 10:41:11 Duration: 41s758ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01593);
Date: 2026-07-30 13:58:01 Duration: 24s80ms Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 420); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01587);
Date: 2026-07-30 10:45:14 Duration: 15s619ms Database: contagem User: intelifix Remote: [local] Application: psql
14 671ms 20s447ms 3s620ms 39 2m21s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 30 08 2 23s300ms 11s650ms 09 2 6s719ms 3s359ms 10 2 10s293ms 5s146ms 11 3 20s809ms 6s936ms 12 3 11s906ms 3s968ms 13 3 8s710ms 2s903ms 14 3 14s144ms 4s714ms 15 3 12s519ms 4s173ms 16 3 12s998ms 4s332ms 17 3 7s292ms 2s430ms 18 2 2s476ms 1s238ms 19 3 2s786ms 928ms 20 2 2s573ms 1s286ms 21 3 2s547ms 849ms 22 2 2s101ms 1s50ms [ User: intelifix - Total duration: 2m21s - Times executed: 39 ]
[ Application: psql - Total duration: 2m21s - Times executed: 39 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-30 08:00:22 Duration: 20s447ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-30 11:40:12 Duration: 10s444ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-30 12:00:11 Duration: 9s729ms Database: rio User: intelifix Remote: [local] Application: psql
15 297ms 49s262ms 3s210ms 159 8m30s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 30 00 6 25s965ms 4s327ms 01 6 10s872ms 1s812ms 02 6 8s693ms 1s448ms 03 5 9s611ms 1s922ms 04 6 11s394ms 1s899ms 05 5 7s366ms 1s473ms 06 6 9s280ms 1s546ms 07 11 37s259ms 3s387ms 08 12 43s460ms 3s621ms 09 12 48s101ms 4s8ms 10 12 40s80ms 3s340ms 11 12 47s979ms 3s998ms 12 12 33s177ms 2s764ms 13 6 7s152ms 1s192ms 14 12 40s739ms 3s394ms 15 12 1m21s 6s771ms 16 9 24s629ms 2s736ms 17 5 3s627ms 725ms 22 4 19s868ms 4s967ms [ User: intelifix - Total duration: 8m30s - Times executed: 159 ]
[ Application: psql - Total duration: 8m30s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 15:35:51 Duration: 49s262ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 00:05:19 Duration: 18s599ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-30 22:45:16 Duration: 14s710ms Database: rio User: intelifix Remote: [local] Application: psql
16 168ms 15s32ms 3s22ms 40 2m select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 30 08 3 17s600ms 5s866ms 09 3 25s115ms 8s371ms 10 4 7s582ms 1s895ms 11 4 19s338ms 4s834ms 13 15 6s157ms 410ms 14 6 27s506ms 4s584ms 15 2 16s31ms 8s15ms 17 3 1s549ms 516ms [ User: intelifix - Total duration: 2m - Times executed: 40 ]
[ Application: psql - Total duration: 2m - Times executed: 40 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027817);
Date: 2026-07-30 09:46:51 Duration: 15s32ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027843);
Date: 2026-07-30 14:30:04 Duration: 12s469ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027803);
Date: 2026-07-30 08:08:29 Duration: 12s108ms Database: rio User: intelifix Remote: [local] Application: psql
17 202ms 2m22s 2s739ms 276 12m36s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 30 00 12 32s716ms 2s726ms 01 12 23s328ms 1s944ms 02 12 23s282ms 1s940ms 03 12 24s622ms 2s51ms 04 12 23s517ms 1s959ms 05 12 25s561ms 2s130ms 06 12 22s316ms 1s859ms 07 12 24s17ms 2s1ms 08 12 2m47s 13s989ms 09 12 35s43ms 2s920ms 10 12 29s500ms 2s458ms 11 12 29s366ms 2s447ms 12 12 23s799ms 1s983ms 13 12 26s310ms 2s192ms 14 12 31s885ms 2s657ms 15 12 35s474ms 2s956ms 16 12 29s772ms 2s481ms 17 12 23s257ms 1s938ms 18 12 24s54ms 2s4ms 19 12 22s343ms 1s861ms 20 12 31s245ms 2s603ms 21 12 22s639ms 1s886ms 22 12 24s77ms 2s6ms [ User: intelifix - Total duration: 12m36s - Times executed: 276 ]
[ Application: psql - Total duration: 12m36s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 08:37:30 Duration: 2m22s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 00:05:30 Duration: 10s720ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-30 20:15:10 Duration: 8s685ms Database: rio User: intelifix Remote: [local] Application: psql
18 173ms 22s562ms 1s883ms 57 1m47s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 30 08 11 19s950ms 1s813ms 09 7 18s409ms 2s629ms 10 6 7s558ms 1s259ms 11 10 3s558ms 355ms 13 3 10s489ms 3s496ms 14 14 38s22ms 2s715ms 15 3 1s752ms 584ms 16 3 7s602ms 2s534ms [ User: intelifix - Total duration: 1m47s - Times executed: 57 ]
[ Application: psql - Total duration: 1m47s - Times executed: 57 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027852);
Date: 2026-07-30 14:58:35 Duration: 22s562ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027818);
Date: 2026-07-30 09:53:22 Duration: 15s132ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027804);
Date: 2026-07-30 08:26:40 Duration: 10s146ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 6s27ms 953ms 1,238 19m39s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 30 08 107 1m23s 783ms 09 153 3m25s 1s340ms 10 147 2m39s 1s83ms 11 143 2m41s 1s130ms 12 29 30s117ms 1s38ms 13 67 1m24s 1s259ms 14 217 3m10s 876ms 15 203 2m35s 767ms 16 136 1m30s 667ms 17 36 18s574ms 515ms [ User: intelifix - Total duration: 19m39s - Times executed: 1238 ]
[ Application: [unknown] - Total duration: 19m39s - Times executed: 1238 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272349, 503, '863400606402813,241766280017,241767039292,241767012748,241762300313,241770871228,241773714041$Z87325051028843,241740004960,241745192930,241768407901,241761112329,241766906979,241762192042,241745268593,241760970116,241747934769,241744080611$Z87325051026506,241739771223,241743625257,241766914152,241748145676$Z87325051008803,241687987077,241769686476,241766147578,241769548506,241748000511$Z87325051029465,241740067188,241766591416,241773710809,241770841629,241770857084,241743123334$Z87325051018476,241738968204,241768296172,241748088600,241748065769$Z87325051027422,241739862848,241767056365,241767002848,241763658491$Z87325051008516,241738024060', '',0464,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-30 10:39:42 Duration: 6s27ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (50253, 417, '835072911000854,241659859797,241604720815,241711201117,241659640204,241597401627,241727009012,241727510711,241728703543,241698688504,241636066275,241604800015,241654478599,241713741926,230043629510,241671557090,241617427789,241647992030,241676709703,241592186987,230043581324,241711187478,241646283838,241664755259,241671556080,241783849901,241628182734,241664841329,241732105255,241595004041,241645524359,241695561319,241669220219,241593454754,241678322936,241607827694,241668279509,241671567900,241659680915,241614498705,241602690314,241599310523,241659770520,241713704952,241713707275,241663120308,241702249906,241673329104,241646413447,241678301924,241592091322', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"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-30 15:16:04 Duration: 5s374ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48450, 407, '226327303047', '',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-30 09:07:02 Duration: 5s368ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 158ms 13s986ms 741ms 106 1m18s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 30 07 14 7s411ms 529ms 08 15 6s126ms 408ms 09 2 2s19ms 1s9ms 10 6 3s646ms 607ms 13 29 21s373ms 737ms 14 6 16s721ms 2s786ms 15 10 7s577ms 757ms 16 13 9s541ms 733ms 17 11 4s212ms 382ms [ User: intelifix - Total duration: 1m18s - Times executed: 106 ]
[ Application: [unknown] - Total duration: 1m18s - Times executed: 106 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0130949) LIMIT 1;
Date: 2026-07-30 14:58:36 Duration: 13s986ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0272477) LIMIT 1;
Date: 2026-07-30 13:22:44 Duration: 2s255ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0272505) LIMIT 1;
Date: 2026-07-30 15:07:34 Duration: 2s228ms 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 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 30 08 1 0ms 0ms 09 1 0ms 0ms 20 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 3s297ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 2s216ms - Times executed: 2 ]
[ Application: psql - Total duration: 1s80ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,669 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 23 FATAL entries
- 4974 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,659 Max number of times the same event was reported
- 5,003 Total events found
Rank Times reported Error 1 4,659 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 30 00 173 01 174 02 174 03 159 04 174 05 177 06 180 07 368 08 455 09 384 10 407 11 331 12 113 13 130 14 348 15 280 16 227 17 78 18 56 19 55 20 55 21 58 22 57 23 46 - ERROR: prepared statement "_PLAN000000002A5DA620" does not exist
- ERROR: prepared statement "_PLAN000000002AB4C090" does not exist
- ERROR: prepared statement "_PLAN000000002A099DF0" does not exist
Statement: DEALLOCATE "_PLAN000000002A5DA620"
Date: 2026-07-30 00:00:29 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002AB4C090"
Date: 2026-07-30 00:00:31 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002A099DF0"
Date: 2026-07-30 00:00:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 195 ERROR: out of shared memory
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 30 08 151 10 44 - ERROR: out of shared memory
- ERROR: out of shared memory
- ERROR: out of shared memory
Context: SQL statement "SELECT A.EQ_ID FROM CODIGOS_BARRA A INNER JOIN EQUIPAMENTOS B ON B.EQ_ID = A.EQ_ID AND B.MOD_ID = ANY( aModelos ) WHERE A.EQ_CODIGO = cSerial AND EQ_EXTRA = 'N'" PL/pgSQL function rs_lote_consiste_serial(text) line 60 at SQL statement
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"272229","seriais":[{"serial":"SEIG60705056"},{"serial":""},{"serial":""},{"serial":""}]}')Date: 2026-07-30 08:50:32 Database: rio Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT A.EQ_ID FROM CODIGOS_BARRA A INNER JOIN EQUIPAMENTOS B ON B.EQ_ID = A.EQ_ID AND B.MOD_ID = ANY( aModelos ) WHERE A.EQ_CODIGO = cSerial AND EQ_EXTRA = 'N'" PL/pgSQL function rs_lote_consiste_serial(text) line 60 at SQL statement
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"48485","seriais":[{"serial":"835261938002273"},{"serial":""}]}')Date: 2026-07-30 08:50:33 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: SQL statement "SELECT PAR_VALOR FROM PARAMETROS WHERE PAR_NOME = cParam" PL/pgSQL function rs_parametro(character varying) line 20 at SQL statement PL/pgSQL function rs_programas(boolean) line 35 at assignment PL/pgSQL function rs_menu(integer,integer) line 83 at FOR over EXECUTE statement SQL statement "SELECT PRO_DESCRICAO, PRO_GRANTS FROM RS_MENU( nUser , nSistema ) WHERE MEN_ID <> -1 AND PRO_ID = nProg" PL/pgSQL function rs_menu_grants(integer,integer,integer) line 20 at SQL statement
Hint: You might need to increase "max_locks_per_transaction".
Statement: select * from rs_menu_grants(508,53,1);Date: 2026-07-30 08:50:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 30 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-30 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-30 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-30 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
4 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 30 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 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-30 08:00:23 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-30 08:20:06 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-30 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
5 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 30 00 1 05 1 06 2 09 1 10 4 17 1 19 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-30 00:02:45 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-30 05:58:16 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-30 06:02:39 Database: testes Application: [unknown] User: lenon Remote: [local]
6 8 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 30 03 8 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-30 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 6 ERROR: spiexceptions.OutOfMemory: out of shared memory
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 30 08 4 10 2 - ERROR: spiexceptions.OutOfMemory: out of shared memory
- ERROR: spiexceptions.OutOfMemory: out of shared memory
- ERROR: spiexceptions.OutOfMemory: out of shared memory
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,420,''/var/www/html/uploads/29-07 - Query 29 - Copia.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-07-30 08:50:37 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,420,''/var/www/html/uploads/29-07 - Query 29 - Copia.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-07-30 08:51:19 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: You might need to increase "max_locks_per_transaction".
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(2,420,''/var/www/html/uploads/29-07 - Query 29 - Copia.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-07-30 08:52:44 Database: contagem Application: [unknown] User: intelifix Remote: [local]
8 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 30 08 2 09 2 14 2 - ERROR: syntax error at or near "D8CF6165FCE2" at character 32
- ERROR: syntax error at or near "D8CF6165FCE2" at character 44
- ERROR: syntax error at or near "[" at character 33
Statement: SELECT RS_SERIAL_TEMPORARIO( ''D8CF6165FCE2' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''D8CF6165FCE2' )
Date: 2026-07-30 08:44:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 00, ''D8CF6165FCE2' )
Date: 2026-07-30 08:44:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(384861[)
Date: 2026-07-30 09:50:17 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 5 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 30 05 4 08 1 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-30 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-30 05:32:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-30 05:32:08 Database: contagem Application: psql User: intelifix Remote: [local]
10 5 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 30 08 3 15 2 - LOG: process 738263 still waiting for ShareLock on transaction 3557080 after 1000.166 ms
- LOG: process 738263 still waiting for ShareLock on transaction 3557080 after 5913.430 ms
- LOG: process 738263 still waiting for ShareLock on transaction 3557080 after 31265.672 ms
Detail: Process holding the lock: 749009. Wait queue: 738263.
Context: while updating tuple (75427,6) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-30 08:35:12 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 749009. Wait queue: 738263.
Context: while updating tuple (75427,6) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-30 08:35:17 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 749009. Wait queue: 738263.
Context: while updating tuple (75427,6) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-30 08:35:42 Database: rio Application: psql User: intelifix Remote: [local]
11 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 30 07 1 08 2 12 1 - ERROR: column "controle" does not exist at character 36
- ERROR: column "undefined" does not exist at character 36
- ERROR: column "undefined" does not exist at character 37
Statement: SELECT * FROM temp0000237138 WHERE CONTROLE='L'
Date: 2026-07-30 07:05:53 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_MODELO_COMPATIVEL(undefined,00);
Date: 2026-07-30 08:52:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_MODELO_PRINT_SAIDA(undefined);
Date: 2026-07-30 08:52:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 30 08 1 11 3 - ERROR: trailing junk after numeric literal at or near "0undefined" at character 58
- ERROR: trailing junk after numeric literal at or near "84Ç1EÇA3Ç7FÇ31Ç25" at character 27
- ERROR: trailing junk after numeric literal at or near "84Ç1EÇA3Ç7FÇ31Ç25" at character 27
Statement: SELECT * FROM RS_MODELOS_LISTA(NULL,NULL) WHERE MOD_ID = 0undefined
Date: 2026-07-30 08:52:41 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(84Ç1EÇA3Ç7FÇ31Ç25)
Date: 2026-07-30 11:04:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(84Ç1EÇA3Ç7FÇ31Ç25)
Date: 2026-07-30 11:04:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
13 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 30 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-30 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-30 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-30 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
14 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 30 07 1 - ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-07-30 07:14:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 30 14 1 - ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint
Detail: Failing row contains (6462655, null, 1, null, A, 27851, 90, null, null, null).
Context: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statement
Statement: SELECT RS_SETGLOBAL('USUARIO',449);SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO( 027851 ); ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint DETAIL: Failing row contains (6462655, null, 1, null, A, 27851, 90, null, null, null). CONTEXT: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statementDate: 2026-07-30 14:56:07 Database: rio Application: psql User: intelifix Remote: [local]
16 1 ERROR: UnicodeDecodeError: 'utf-8' codec can't decode byte 0x8e in position 17: invalid start byte
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 30 14 1 - ERROR: UnicodeDecodeError: 'utf-8' codec can't decode byte 0x8e in position 17: invalid start byte
Context: Traceback (most recent call last): PL/Python function "rs_read_file", line 15, in <module> dados = nfile.readlines() PL/Python function "rs_read_file", line 321, in decode PL/Python function "rs_read_file" PL/pgSQL function rs_read_file(text,integer) line 16 at FOR over SELECT rows PL/pgSQL assignment "cDados := RS_READ_FILE( cFile , 2 )" PL/pgSQL function rs_nf_entrada_xml_grava(character varying,integer,integer,character varying,integer,character varying) line 81 at assignment
Statement: SELECT * FROM RS_NF_ENTRADA_XML_GRAVA( '/var/www/html/uploads/Novo Modelo Padrão Pre-Alerta 1.xlsx', 0184 , 00, 'N', 06,'0');Date: 2026-07-30 14:47:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
17 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 30 03 1 - LOG: database system was shut down at 2026-07-30 03:05:01 -03
Date: 2026-07-30 03:05:02
18 1 ERROR: record "..." has no field "..."
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 30 15 1 - ERROR: record "cret" has no field "li_id"
Context: PL/pgSQL function rs_triagem_checa_equipamento(integer,character varying,integer) line 64 at SQL statement
Statement: SELECT * FROM RS_TRIAGEM_CHECA_EQUIPAMENTO(0359,'CP2413323LJ',0298);Date: 2026-07-30 15:11:37 Database: brasilia Application: [unknown] User: intelifix Remote: [local]