pgBadger-
Global information
- Generated on Fri Jul 31 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 38,128 log entries in 8s
- Log start from 2026-07-31 00:01:14 to 2026-07-31 23:49:36
-
Overview
Global Stats
- 347 Number of unique normalized queries
- 5,729 Number of queries
- 7h55m20s Total query duration
- 2026-07-31 00:02:47 First query
- 2026-07-31 23:48:38 Last query
- 7 queries/s at 2026-07-31 08:38:03 Query peak
- 7h55m20s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h55m20s Execute total duration
- 3,567 Number of events
- 16 Number of unique normalized events
- 3,426 Max number of times the same event was reported
- 0 Number of cancellation
- 347 Total number of automatic vacuums
- 807 Total number of automatic analyzes
- 10 Number temporary file
- 238.07 MiB Max size of temporary file
- 110.67 MiB Average size of temporary file
- 350 Total number of sessions
- 7 sessions at 2026-07-31 00:54:18 Session peak
- 12d21h4m18s Total duration of sessions
- 52m59s Average duration of sessions
- 16 Average queries per session
- 1m21s Average queries duration per session
- 51m37s Average idle time per session
- 358 Total number of connections
- 9 connections/s at 2026-07-31 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2026-07-31 08:38:03 Date
SELECT Traffic
Key values
- 7 queries/s Query Peak
- 2026-07-31 08:38:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-31 23:48:33 Date
Queries duration
Key values
- 7h55m20s 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 31 00 27 0ms 38s334ms 5s726ms 4s645ms 5s918ms 1m19s 01 34 0ms 3s562ms 997ms 4s450ms 5s53ms 5s525ms 02 17 0ms 3s518ms 1s721ms 3s825ms 5s150ms 6s27ms 03 24 0ms 3s773ms 1s332ms 4s261ms 4s657ms 7s990ms 04 39 0ms 14s792ms 1s414ms 5s276ms 6s187ms 14s792ms 05 40 0ms 9m29s 28s945ms 9s394ms 2m24s 9m29s 06 52 0ms 36s899ms 3s15ms 6s344ms 23s575ms 48s178ms 07 465 150ms 8m39s 5s79ms 56s81ms 6m4s 8m49s 08 586 150ms 8m29s 4s684ms 2m6s 5m48s 8m36s 09 597 150ms 9m19s 3s679ms 56s274ms 4m51s 9m29s 10 681 150ms 9m18s 4s954ms 4m47s 6m13s 9m39s 11 887 150ms 7m21s 2s158ms 41s355ms 4m23s 10m5s 12 126 0ms 6m57s 7s224ms 25s84ms 41s751ms 7m7s 13 384 0ms 5m58s 3s447ms 48s403ms 2m58s 6m 14 610 150ms 7m41s 4s831ms 1m32s 4m15s 7m57s 15 308 0ms 8m44s 4s402ms 40s707ms 1m33s 9m2s 16 216 0ms 5m53s 3s818ms 11s107ms 53s225ms 5m54s 17 81 0ms 6m16s 8s825ms 4s176ms 16s629ms 6m51s 18 25 0ms 5m44s 25s231ms 4s497ms 44s106ms 5m44s 19 21 0ms 6m3s 31s267ms 3s999ms 4s688ms 6m53s 20 118 0ms 7m2s 11s111ms 1m9s 1m30s 7m54s 21 31 0ms 5m59s 21s512ms 6s67ms 8s197ms 6m47s 22 27 0ms 5m54s 24s467ms 5s612ms 50s819ms 5m54s 23 333 0ms 1m27s 6s924ms 1m9s 1m11s 1m27s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 31 00 4 0 12s480ms 0ms 0ms 180ms 01 16 0 262ms 151ms 207ms 1s71ms 02 0 0 0ms 0ms 0ms 0ms 03 6 0 360ms 0ms 0ms 1s41ms 04 19 0 335ms 262ms 373ms 974ms 05 17 0 281ms 0ms 306ms 872ms 06 9 0 5s687ms 0ms 0ms 1s125ms 07 349 0 5s623ms 10s273ms 44s872ms 7m8s 08 440 0 4s888ms 8s446ms 1m6s 6m33s 09 463 0 3s889ms 17s715ms 48s821ms 5m40s 10 528 0 5s407ms 17s899ms 4m38s 8m12s 11 738 0 2s235ms 13s834ms 23s975ms 4m59s 12 72 0 10s532ms 1s911ms 4s837ms 3m47s 13 306 0 3s944ms 11s428ms 48s403ms 3m40s 14 355 0 6s893ms 50s122ms 1m14s 5m54s 15 218 0 5s930ms 11s632ms 40s707ms 3m54s 16 124 0 5s914ms 3s167ms 6s824ms 3m47s 17 50 0 13s676ms 2s38ms 3s134ms 3m36s 18 10 0 1m 0ms 162ms 3m23s 19 6 0 1m44s 0ms 0ms 3m34s 20 15 86 12s584ms 15s576ms 57s905ms 3m50s 21 12 0 52s462ms 0ms 0ms 3m40s 22 6 0 1m44s 0ms 0ms 3m39s 23 10 323 6s924ms 1m4s 1m9s 1m27s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 31 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 31 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 13 13.00 0.00% 08 0 14 14.00 0.00% 09 0 16 16.00 0.00% 10 0 15 15.00 0.00% 11 0 10 10.00 0.00% 12 0 6 6.00 0.00% 13 0 9 9.00 0.00% 14 0 18 18.00 0.00% 15 0 7 7.00 0.00% 16 0 6 6.00 0.00% 17 0 1 1.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second Jul 31 00 17 0.00/s 01 11 0.00/s 02 10 0.00/s 03 19 0.01/s 04 10 0.00/s 05 9 0.00/s 06 14 0.00/s 07 19 0.01/s 08 20 0.01/s 09 22 0.01/s 10 25 0.01/s 11 23 0.01/s 12 10 0.00/s 13 21 0.01/s 14 25 0.01/s 15 18 0.01/s 16 16 0.00/s 17 10 0.00/s 18 7 0.00/s 19 8 0.00/s 20 14 0.00/s 21 8 0.00/s 22 9 0.00/s 23 13 0.00/s Day Hour Count Average Duration Average idle time Jul 31 00 7 1h26s 1h3s 01 15 1h59s 1h56s 02 11 1h16s 1h14s 03 20 22m53s 22m51s 04 9 1h2m39s 1h2m33s 05 10 55m36s 53m40s 06 8 56m41s 56m21s 07 16 52m24s 49m56s 08 20 52m5s 49m47s 09 18 54m43s 52m41s 10 26 48m59s 46m50s 11 23 50m54s 49m30s 12 19 1h41s 59m53s 13 12 54m2s 52m12s 14 24 54m52s 52m49s 15 22 55m29s 54m27s 16 15 58m 57m5s 17 16 1h31s 59m46s 18 9 1h 58m50s 19 7 1h52s 59m18s 20 12 42m14s 40m25s 21 9 1h40s 59m26s 22 9 1h23s 59m10s 23 13 35m30s 32m33s -
Connections
Established Connections
Key values
- 9 connections Connection Peak
- 2026-07-31 03:05:17 Date
Connections per database
Key values
- brasilia Main Database
- 358 connections Total
Connections per user
Key values
- intelifix Main User
- 358 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-07-31 00:54:18 Date
Histogram of session times
Key values
- 282 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 350 sessions Total
Sessions per user
Key values
- intelifix Main User
- 350 sessions Total
Sessions per host
Key values
- [local] Main Host
- 350 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 71,201 buffers Checkpoint Peak
- 2026-07-31 00:09:45 Date
- 270.016 seconds Highest write time
- 0.100 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-07-31 08:44:38 Date
Checkpoints distance
Key values
- 469.34 Mo Distance Peak
- 2026-07-31 08:44:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 31 00 86,275 632.287s 0.031s 632.372s 01 2,844 285.843s 0.049s 285.957s 02 1,465 147.348s 0.03s 147.416s 03 1,625 163.523s 0.029s 163.604s 04 3,646 366.61s 0.048s 366.723s 05 11,655 1,032.658s 0.107s 1,032.88s 06 6,852 397.898s 0.029s 397.944s 07 54,536 2,762.806s 0.454s 2,763.433s 08 46,328 3,167.77s 0.54s 3,168.542s 09 71,602 3,238.838s 0.662s 3,239.72s 10 80,378 3,238.762s 0.737s 3,239.751s 11 55,142 3,238.923s 0.559s 3,239.669s 12 27,582 1,997.857s 0.211s 1,998.195s 13 19,799 2,044.933s 0.325s 2,045.376s 14 45,555 2,936.69s 0.609s 2,937.508s 15 30,569 2,216.99s 0.318s 2,217.433s 16 19,321 1,820.367s 0.257s 1,820.738s 17 8,331 836.636s 0.154s 836.877s 18 1,496 150.043s 0.017s 150.087s 19 27 2.753s 0.006s 2.771s 20 585 101.98s 0.044s 102.047s 21 2,220 223.028s 0.058s 223.194s 22 2,016 202.751s 0.052s 202.844s 23 397 39.949s 0.013s 39.999s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 31 00 0 0 11 470 0.003s 0.006s 01 0 0 1 617 0.004s 0.009s 02 0 0 1 367 0.003s 0.005s 03 0 0 0 419 0.003s 0.007s 04 0 0 1 672 0.002s 0.009s 05 0 0 5 917 0.010s 0.009s 06 0 0 1 176 0.002s 0.002s 07 0 0 31 4,393 0.012s 0.012s 08 0 0 42 5,170 0.006s 0.012s 09 0 0 38 6,831 0.010s 0.012s 10 0 0 53 7,419 0.009s 0.012s 11 0 0 27 7,122 0.007s 0.012s 12 0 0 18 3,098 0.007s 0.012s 13 0 0 11 4,341 0.011s 0.012s 14 0 0 38 6,371 0.008s 0.012s 15 0 0 10 3,949 0.019s 0.012s 16 0 0 6 3,487 0.007s 0.012s 17 0 0 3 1,578 0.007s 0.012s 18 0 0 0 168 0.006s 0.004s 19 0 0 0 7 0.002s 0.003s 20 0 0 1 79 0.020s 0.003s 21 0 0 1 378 0.013s 0.006s 22 0 0 0 496 0.006s 0.008s 23 0 0 0 96 0.002s 0.006s Day Hour Count Avg time (sec) Jul 31 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 31 00 31,264.67 kB 93,428.33 kB 01 1,552.67 kB 44,646.44 kB 02 1,464.80 kB 21,625.00 kB 03 1,090.12 kB 3,351.75 kB 04 2,094.33 kB 2,610.11 kB 05 7,769.11 kB 16,374.78 kB 06 9,316.50 kB 13,306.00 kB 07 42,699.67 kB 71,583.33 kB 08 56,784.58 kB 117,434.00 kB 09 52,174.83 kB 134,794.08 kB 10 72,054.75 kB 113,051.42 kB 11 36,939.58 kB 76,049.08 kB 12 25,278.50 kB 76,130.25 kB 13 14,631.58 kB 32,391.50 kB 14 52,565.33 kB 132,065.33 kB 15 13,047.33 kB 73,752.17 kB 16 8,953.17 kB 27,711.75 kB 17 3,686.36 kB 12,734.73 kB 18 1,688.75 kB 6,988.75 kB 19 97.00 kB 5,330.50 kB 20 3,689.67 kB 6,827.67 kB 21 1,741.33 kB 4,864.17 kB 22 1,524.57 kB 3,314.57 kB 23 204.00 kB 2,026.50 kB -
Temporary Files
Size of temporary files
Key values
- 476.14 MiB Temp Files size Peak
- 2026-07-31 05:32:05 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-31 05:30:39 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 31 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.67 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 924.74 MiB 71.01 MiB 238.07 MiB 115.59 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-31 05:32:13 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-31 05:32:05 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 181.94 MiB 90.97 MiB 90.97 MiB 90.97 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-31 05:30:43 Duration: 40s543ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-31 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 238.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 238.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-31 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.97 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-31 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.55 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 71.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.01 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.01 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-31 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 1.33 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-07-31 10:15:45 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 1.33 sec Highest CPU-cost vacuum
Table public.logs
Database rio - 2026-07-31 10:15:45 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (72) Main table analyzed (database rio)
- 807 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 72 brasilia.pg_catalog.pg_attribute 55 rio.pg_catalog.pg_class 40 contagem.public.temp0000226724 39 rio.public.usuarios 38 contagem.public.temp0000226734 36 rio.pg_catalog.pg_type 32 rio.public.temp0000287112 28 rio.public.temp0000287108 28 contagem.pg_catalog.pg_attribute 28 contagem.public.usuarios 27 brasilia.pg_catalog.pg_class 24 rio.pg_catalog.pg_index 23 brasilia.pg_catalog.pg_type 22 contagem.public.temp0000226736 17 rio.pg_catalog.pg_depend 17 rio.public.temp0000287176 15 brasilia.pg_catalog.pg_index 14 contagem.pg_catalog.pg_class 12 brasilia.public.temp0000237252 11 rio.public.temp0000287094 11 rio.public.temp0000287092 11 brasilia.pg_catalog.pg_depend 10 rio.public.temp0000287170 10 contagem.pg_catalog.pg_type 10 brasilia.public.usuarios 10 contagem.public.temp0000226710 9 rio.public.temp0000287080 8 rio.public.temp0000287078 8 brasilia.public.temp0000237246 7 rio.public.temp0000287188 6 rio.public.temp0000287152 6 contagem.pg_catalog.pg_index 6 rio.public.temp0000287088 6 rio.public.temp0000287118 6 rio.public.temp0000287102 5 rio.public.temp0000287084 4 contagem.pg_catalog.pg_depend 4 rio.public.tmp_drill_0302 4 rio.public.temp0000287126 4 rio.public.temp0000287132 4 rio.public.temp0000287120 4 rio.public.temp0000287160 4 postgres.pg_catalog.pg_shdepend 4 rio.public.temp0000287134 4 rio.public.temp0000287100 3 rio.public.temp0000287168 3 brasilia.public.temp0000237244 3 rio.public.temp0000287142 3 rio.public.temp0000287202 3 rio.public.temp0000287072 3 brasilia.public.nf_entrada 3 template1.pg_catalog.pg_shdepend 3 brasilia.pg_catalog.pg_shdepend 2 rio.public.tmp_drill_0175 2 rio.public.temp0000287148 2 rio.public.temp0000287162 2 rio.public.temp0000287128 2 brasilia.public.temp0000237254 2 rio.public.temp0000287096 2 rio.public.temp0000287154 2 rio.public.temp0000287076 2 brasilia.public.temp0000237300 2 brasilia.public.temp0000237260 2 brasilia.public.temp0000237286 1 rio.public.temp0000287194 1 brasilia.public.temp0000237270 1 rio.public.temp0000287178 1 contagem.public.temp0000226740 1 brasilia.public.temp0000237262 1 contagem.pg_catalog.pg_shdepend 1 rio.public.temp0000287116 1 brasilia.public.temp0000237242 1 rio.public.temp0000287198 1 brasilia.public.temp0000237278 1 brasilia.public.temp0000237308 1 brasilia.public.temp0000237264 1 rio.public.temp0000287114 1 brasilia.public.temp0000237294 1 rio.public.temp0000287098 1 rio.public.temp0000287122 1 brasilia.public.temp0000237276 1 Total 807 Vacuums per table
Key values
- pg_catalog.pg_attribute (29) Main table vacuumed on database rio
- 347 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 29 25 0 0 0 0 0 13,792 4,001 5,896,977 241 6,017 rio.public.temp0000287108 29 0 0 0 0 0 0 24,788 225 1,672,935 0 0 contagem.public.usuarios 28 0 0 0 0 0 0 132 104 55,048 0 0 rio.pg_catalog.pg_class 24 17 0 0 0 0 0 3,107 1,014 1,502,158 49 297 rio.pg_catalog.pg_type 18 15 0 0 0 0 0 1,329 393 528,292 45 139 brasilia.pg_catalog.pg_attribute 17 17 0 0 0 0 0 8,346 2,049 3,448,862 68 1,774 rio.public.temp0000287112 11 0 0 0 0 0 0 2,341 119 250,658 0 0 rio.public.temp0000287094 10 0 0 0 0 0 0 426 54 33,183 0 0 contagem.pg_catalog.pg_attribute 10 10 0 0 0 0 0 5,056 1,475 2,587,961 15 370 rio.public.temp0000287170 10 0 0 0 0 0 0 11,891 37 707,404 0 0 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 635 188 165,695 32 76 rio.public.usuarios 9 7 0 0 0 0 0 217 89 179,143 22 45 rio.public.temp0000287176 9 0 0 0 0 0 0 5,429 41 326,864 0 0 brasilia.pg_catalog.pg_class 9 9 0 0 0 0 0 1,725 431 735,909 25 108 rio.public.temp0000287078 8 0 0 0 0 0 0 435 45 32,181 0 0 brasilia.pg_catalog.pg_type 8 8 0 0 0 0 0 821 191 291,593 14 46 rio.public.tmp_drill_0302 7 4 0 0 0 0 0 2,357 382 964,369 1 62 rio.pg_catalog.pg_depend 6 6 0 0 0 0 0 2,024 778 1,055,197 38 402 rio.public.temp0000287188 6 0 0 0 0 0 0 8,492 23 504,574 0 0 rio.public.tmp_drill_0175 6 2 0 0 0 0 0 74 27 39,793 1 62 template1.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 713 236 388,802 66 165 rio.public.temp0000287152 5 0 0 0 0 0 0 1,712 16 103,763 0 0 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 282 76 57,121 15 28 rio.pg_catalog.pg_statistic 5 5 0 0 0 0 0 7,474 1,475 6,954,721 748 3,816 rio.public.temp0000287160 4 0 0 0 0 0 0 16 12 3,096 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,120 268 453,128 14 108 rio.public.temp0000287102 4 0 0 0 0 0 0 203 23 15,325 0 0 contagem.pg_catalog.pg_type 3 3 0 0 0 0 0 276 115 149,903 1 2 rio.public.temp0000287126 3 0 0 0 0 0 0 152 72 104,630 0 0 rio.public.temp0000287134 3 0 0 0 0 0 0 1,803 106 292,025 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,394 390 1,658,144 225 1,642 rio.public.temp0000287100 3 0 0 0 0 0 0 144 102 161,636 0 0 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,573 300 1,587,099 122 330 rio.public.temp0000287142 3 0 0 0 0 0 0 5,088 12 302,001 0 0 contagem.pg_catalog.pg_class 3 3 0 0 0 0 0 447 162 209,564 6 17 rio.public.temp0000287128 2 0 0 0 0 0 0 108 11 8,171 0 0 rio.public.temp0000287154 2 0 0 0 0 0 0 204 12 13,924 0 0 rio.public.temp0000287096 2 0 0 0 0 0 0 198 103 197,588 0 0 brasilia.public.temp0000237300 2 0 0 0 0 0 0 490 250 403,395 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 314 58 257,078 17 49 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 194 74 50,649 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 602 227 425,094 3 19 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,092 227 1,023,006 154 1,305 brasilia.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 192 168 532,065 0 0 rio.public.acessos 1 0 0 0 0 0 0 37 35 76,203 3 358 rio.public.temp0000287122 1 0 0 0 0 0 0 8 5 1,333 0 0 rio.public.temp0000287118 1 0 0 0 0 0 0 99 6 6,782 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 158 26 79,285 3 6 rio.public.temp0000287194 1 0 0 0 0 0 0 108 6 7,329 0 0 rio.public.temp0000287178 1 0 0 0 0 0 0 104 6 7,062 0 0 rio.public.temp0000287116 1 0 0 0 0 0 0 8 5 1,329 0 0 rio.public.logs 1 0 0 0 0 0 0 3,643 3,488 4,218,160 78 1,915 brasilia.public.temp0000237278 1 0 0 0 0 0 0 245 6 15,594 0 0 rio.public.temp0000287198 1 0 0 0 0 0 0 1,698 4 100,785 0 0 Total 347 170 0 0 0 0 0 129,316 19,748 40,844,586 2,006 19,158 Vacuum throughput per table
Key values
- pg_catalog.pg_attribute (2.19) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.19 rio.public.temp0000287108 0 0 1.15 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.84 rio.pg_catalog.pg_type 0 0 0.17 brasilia.pg_catalog.pg_attribute 0 0 1.22 rio.public.temp0000287112 0 0 0.21 rio.public.temp0000287094 0 0 0.15 contagem.pg_catalog.pg_attribute 0 0 0.88 rio.public.temp0000287170 0 0 0.5 rio.pg_catalog.pg_index 0 0 0.19 rio.public.usuarios 0 0 0.02 rio.public.temp0000287176 0 0 0.34 brasilia.pg_catalog.pg_class 0 0 0.31 rio.public.temp0000287078 0 0 0.13 brasilia.pg_catalog.pg_type 0 0 0.21 rio.public.tmp_drill_0302 0 0 0.15 rio.pg_catalog.pg_depend 0 0 0.61 rio.public.temp0000287188 0 0 0.31 rio.public.tmp_drill_0175 0 0 0 template1.pg_catalog.pg_shdepend 0 0 0.35 rio.public.temp0000287152 0 0 0.26 brasilia.pg_catalog.pg_index 0 0 0.05 rio.pg_catalog.pg_statistic 0 0 0.97 rio.public.temp0000287160 0 0 0.2 brasilia.pg_catalog.pg_depend 0 0 0.26 rio.public.temp0000287102 0 0 0.06 contagem.pg_catalog.pg_type 0 0 0.17 rio.public.temp0000287126 0 0 0.05 rio.public.temp0000287134 0 0 0.1 contagem.pg_catalog.pg_statistic 0 0 0.28 rio.public.temp0000287100 0 0 0.03 rio.pg_toast.pg_toast_2619 0 0 0.17 rio.public.temp0000287142 0 0 0.17 contagem.pg_catalog.pg_class 0 0 0.28 rio.public.temp0000287128 0 0 0.03 rio.public.temp0000287154 0 0 0.03 rio.public.temp0000287096 0 0 0.03 brasilia.public.temp0000237300 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.04 contagem.pg_catalog.pg_index 0 0 0.13 contagem.pg_catalog.pg_depend 0 0 0.17 brasilia.pg_catalog.pg_statistic 0 0 0.19 brasilia.public.nf_entrada_arquivo_erros 0 0 0.15 rio.public.acessos 0 0 0.03 rio.public.temp0000287122 0 0 0.02 rio.public.temp0000287118 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000287194 0 0 0.02 rio.public.temp0000287178 0 0 0.02 rio.public.temp0000287116 0 0 0.01 rio.public.logs 0 0 1.33 brasilia.public.temp0000237278 0 0 0.02 rio.public.temp0000287198 0 0 0.05 Total 0 0 15.32 Tuples removed per table
Key values
- pg_catalog.pg_attribute (105222) Main table with removed tuples on database rio
- 280220 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 29 25 105,222 712,652 55,443 159 17,054 brasilia.pg_catalog.pg_attribute 17 17 66,370 378,018 2,415 0 10,172 contagem.pg_catalog.pg_attribute 10 10 26,079 237,500 0 473 5,309 rio.public.tmp_drill_0302 7 4 22,821 93,135 28,506 0 1,695 rio.pg_catalog.pg_statistic 5 5 10,045 40,857 24 0 6,430 contagem.pg_catalog.pg_statistic 3 3 6,494 22,804 0 0 3,033 rio.pg_catalog.pg_depend 6 6 5,588 109,070 127 0 1,110 brasilia.pg_catalog.pg_depend 4 4 5,333 72,153 0 25 688 brasilia.pg_catalog.pg_statistic 2 2 4,966 15,400 0 0 2,144 rio.pg_catalog.pg_type 18 15 4,842 45,340 4,368 6 1,275 template1.pg_catalog.pg_shdepend 5 5 4,368 66,644 152 0 595 brasilia.pg_catalog.pg_type 8 8 3,215 17,656 32 30 566 rio.pg_catalog.pg_class 24 17 3,158 97,730 15,352 38 2,974 rio.pg_catalog.pg_index 10 10 2,596 19,629 446 0 570 contagem.public.usuarios 28 0 1,698 753 16 0 56 brasilia.pg_catalog.pg_index 5 5 1,288 9,372 2 8 284 contagem.pg_catalog.pg_depend 2 2 1,256 41,411 0 56 338 brasilia.pg_catalog.pg_class 9 9 1,085 33,569 572 0 1,183 rio.pg_toast.pg_toast_2619 3 3 1,024 1,786 1 2 869 rio.public.usuarios 9 7 750 5,400 819 0 162 contagem.pg_catalog.pg_class 3 3 526 11,471 0 128 399 rio.public.tmp_drill_0175 6 2 476 4,716 1,904 0 77 contagem.pg_catalog.pg_index 2 2 336 3,789 0 32 106 contagem.pg_catalog.pg_type 3 3 325 7,853 0 67 180 brasilia.pg_toast.pg_toast_2619 2 2 203 271 0 12 112 contagem.pg_toast.pg_toast_2619 1 1 145 111 0 0 61 brasilia.public.nf_entrada_arquivo_erros 1 0 9 1,677,685 0 0 30,272 rio.public.acessos 1 0 2 105,401 0 0 899 rio.public.temp0000287094 10 0 0 26,714 0 362 598 rio.public.temp0000287126 3 0 0 7,331 0 92 164 rio.public.temp0000287128 2 0 0 3,153 0 73 183 rio.public.temp0000287134 3 0 0 27,054 0 74 1,910 rio.public.temp0000287154 2 0 0 3,239 0 68 188 rio.public.temp0000287096 2 0 0 3,153 0 74 182 rio.public.temp0000287160 4 0 0 95,626 0 0 6,912 rio.public.temp0000287122 1 0 0 1,616 0 34 94 rio.public.temp0000287176 9 0 0 134,481 0 119 9,033 rio.public.temp0000287118 1 0 0 1,575 0 37 91 brasilia.public.temp0000237300 2 0 0 6,330 0 38 474 rio.public.temp0000287078 8 0 0 21,867 0 292 476 rio.public.temp0000287188 6 0 0 143,546 0 0 10,368 rio.public.temp0000287152 5 0 0 119,518 0 0 8,640 rio.public.temp0000287100 3 0 0 6,967 0 68 156 rio.public.temp0000287194 1 0 0 1,764 0 28 100 rio.public.temp0000287178 1 0 0 4,297 0 32 96 rio.public.temp0000287112 11 0 0 65,375 0 212 4,076 rio.public.temp0000287108 29 0 0 470,566 0 338 33,774 rio.public.temp0000287170 10 0 0 239,145 0 0 17,280 rio.public.temp0000287116 1 0 0 1,575 0 37 91 rio.public.temp0000287102 4 0 0 10,803 0 144 240 rio.public.temp0000287142 3 0 0 71,699 0 0 5,184 rio.public.logs 1 0 0 16,240,818 0 0 648,866 brasilia.public.temp0000237278 1 0 0 3,165 0 19 237 rio.public.temp0000287198 1 0 0 23,930 0 0 1,728 Total 347 170 280,220 21,567,483 110,179 3,177 839,754 Pages removed per table
Key values
- pg_catalog.pg_attribute (473) Main table with removed pages on database contagem
- 3177 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.pg_catalog.pg_attribute 10 10 26079 473 rio.public.temp0000287094 10 0 0 362 rio.public.temp0000287108 29 0 0 338 rio.public.temp0000287078 8 0 0 292 rio.public.temp0000287112 11 0 0 212 rio.pg_catalog.pg_attribute 29 25 105222 159 rio.public.temp0000287102 4 0 0 144 contagem.pg_catalog.pg_class 3 3 526 128 rio.public.temp0000287176 9 0 0 119 rio.public.temp0000287126 3 0 0 92 rio.public.temp0000287134 3 0 0 74 rio.public.temp0000287096 2 0 0 74 rio.public.temp0000287128 2 0 0 73 rio.public.temp0000287154 2 0 0 68 rio.public.temp0000287100 3 0 0 68 contagem.pg_catalog.pg_type 3 3 325 67 contagem.pg_catalog.pg_depend 2 2 1256 56 rio.pg_catalog.pg_class 24 17 3158 38 brasilia.public.temp0000237300 2 0 0 38 rio.public.temp0000287118 1 0 0 37 rio.public.temp0000287116 1 0 0 37 rio.public.temp0000287122 1 0 0 34 rio.public.temp0000287178 1 0 0 32 contagem.pg_catalog.pg_index 2 2 336 32 brasilia.pg_catalog.pg_type 8 8 3215 30 rio.public.temp0000287194 1 0 0 28 brasilia.pg_catalog.pg_depend 4 4 5333 25 brasilia.public.temp0000237278 1 0 0 19 brasilia.pg_toast.pg_toast_2619 2 2 203 12 brasilia.pg_catalog.pg_index 5 5 1288 8 rio.pg_catalog.pg_type 18 15 4842 6 rio.pg_toast.pg_toast_2619 3 3 1024 2 brasilia.public.nf_entrada_arquivo_erros 1 0 9 0 rio.public.usuarios 9 7 750 0 rio.public.acessos 1 0 2 0 contagem.pg_catalog.pg_statistic 3 3 6494 0 rio.public.temp0000287160 4 0 0 0 template1.pg_catalog.pg_shdepend 5 5 4368 0 brasilia.pg_catalog.pg_class 9 9 1085 0 rio.pg_catalog.pg_depend 6 6 5588 0 rio.public.temp0000287188 6 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 145 0 rio.public.temp0000287152 5 0 0 0 brasilia.pg_catalog.pg_attribute 17 17 66370 0 rio.public.temp0000287170 10 0 0 0 rio.public.tmp_drill_0302 7 4 22821 0 rio.pg_catalog.pg_index 10 10 2596 0 brasilia.pg_catalog.pg_statistic 2 2 4966 0 rio.public.temp0000287142 3 0 0 0 contagem.public.usuarios 28 0 1698 0 rio.public.tmp_drill_0175 6 2 476 0 rio.public.logs 1 0 0 0 rio.pg_catalog.pg_statistic 5 5 10045 0 rio.public.temp0000287198 1 0 0 0 Total 347 170 280,220 3,177 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 31 00 0 0 01 0 4 02 0 0 03 0 1 04 1 5 05 6 5 06 0 7 07 36 73 08 36 81 09 60 112 10 57 107 11 44 120 12 17 26 13 13 50 14 47 119 15 8 40 16 13 36 17 6 17 18 0 0 19 0 0 20 0 0 21 3 3 22 0 0 23 0 1 - 1.33 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000287108;-
DROP TABLE IF EXISTS temp0000287108;
Date: 2026-07-31 08:41:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000287108;
Date: 2026-07-31 08:41:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1s1ms DROP TABLE IF EXISTS temp0000287108;[ Date: 2026-07-31 08:41:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,773 Total read queries
- 1,483 Total write queries
Queries by database
Key values
- rio Main database
- 2,806 Requests
- 5h48m15s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,594 Requests
User Request type Count Duration etiquetas Total 30 6s185ms select 30 6s185ms intelifix Total 5,594 7h52m50s copy to 409 47m22s ddl 1,074 41m43s others 473 38m15s select 3,638 5h45m28s lenon Total 105 2m23s select 105 2m23s Duration by user
Key values
- 7h52m50s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 30 6s185ms select 30 6s185ms intelifix Total 5,594 7h52m50s copy to 409 47m22s ddl 1,074 41m43s others 473 38m15s select 3,638 5h45m28s lenon Total 105 2m23s select 105 2m23s Queries by host
Key values
- [local] Main host
- 5,729 Requests
- 7h55m20s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,639 Requests
- 4h37s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-31 13:31:24 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,041 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m29s analyze verbose;[ Date: 2026-07-31 05:09:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 09:14:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 10:14:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 15:13:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 07:13:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 08:13:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 14:12:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 11:12:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 20:12:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 12:11:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-07-31 08:19:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 17:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-30'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-07-31 10:48:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 19:11:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 21:11:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 13:10:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m55s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027860, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-31 07:24:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 22:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 16:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-31 18:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h2m51s 48 1s259ms 9m19s 2m33s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 31 07 3 9m21s 3m7s 08 3 9m10s 3m3s 09 3 9m57s 3m19s 10 3 9m55s 3m18s 11 3 8m1s 2m40s 12 3 7m22s 2m27s 13 3 6m15s 2m5s 14 3 8m15s 2m45s 15 3 9m17s 3m5s 16 3 6m14s 2m4s 17 3 6m34s 2m11s 18 3 6m6s 2m2s 19 3 6m20s 2m6s 20 3 7m28s 2m29s 21 3 6m16s 2m5s 22 3 6m12s 2m4s [ User: intelifix - Total duration: 2h2m51s - Times executed: 48 ]
[ Application: psql - Total duration: 2h2m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-31 09:14:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-31 10:14:20 Duration: 9m18s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-31 15:13:45 Duration: 8m44s Database: rio User: intelifix Remote: [local] Application: psql
2 1h40m30s 253 151ms 6m26s 23s835ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 31 07 18 13m26s 44s778ms 08 21 17m23s 49s712ms 09 22 6m44s 18s379ms 10 35 24m3s 41s238ms 11 25 8m6s 19s468ms 12 6 9s86ms 1s514ms 13 22 5m4s 13s832ms 14 73 21m52s 17s976ms 15 23 3m28s 9s69ms 16 5 7s603ms 1s520ms 17 3 4s140ms 1s380ms [ User: intelifix - Total duration: 1h40m30s - Times executed: 253 ]
[ Application: [unknown] - Total duration: 1h40m30s - Times executed: 253 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-31 08:19:54 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-30'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-31 10:48:20 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027860, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-31 07:24:19 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h13m29s 48 197ms 4m29s 1m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 31 07 3 5m22s 1m47s 08 3 4m52s 1m37s 09 3 5m36s 1m52s 10 3 5m24s 1m48s 11 3 5m2s 1m40s 12 3 4m21s 1m27s 13 3 4m6s 1m22s 14 3 4m49s 1m36s 15 3 4m29s 1m29s 16 3 4m13s 1m24s 17 3 4m7s 1m22s 18 3 3m53s 1m17s 19 3 4m7s 1m22s 20 3 4m40s 1m33s 21 3 4m10s 1m23s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h13m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-31 09:20:30 Duration: 4m29s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-31 10:20:17 Duration: 4m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-31 07:19:39 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
4 16m26s 3 2m24s 9m29s 5m28s analyze verbose;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 31 05 3 16m26s 5m28s [ User: intelifix - Total duration: 16m26s - Times executed: 3 ]
[ Application: psql - Total duration: 16m26s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-31 05:09:30 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-31 05:14:03 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-31 05:16:28 Duration: 2m24s Database: contagem User: intelifix Remote: [local] Application: psql
5 14m56s 71 9s831ms 19s731ms 12s626ms create table temp0000287108 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 31 07 14 2m42s 11s594ms 08 17 3m42s 13s68ms 09 9 2m1s 13s513ms 10 23 4m54s 12s797ms 14 8 1m36s 12s9ms [ User: intelifix - Total duration: 14m56s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 14m56s - Times executed: 71 ]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 10:08:27 Duration: 19s731ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 09:32:18 Duration: 15s308ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:54:11 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 13m29s 1,002 150ms 5s670ms 808ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 31 07 87 1m6s 759ms 08 143 1m50s 769ms 09 173 2m3s 715ms 10 155 2m3s 794ms 11 96 1m16s 801ms 12 25 22s143ms 885ms 13 55 46s370ms 843ms 14 91 1m15s 828ms 15 84 1m13s 877ms 16 57 56s612ms 993ms 17 36 35s537ms 987ms [ User: intelifix - Total duration: 13m29s - Times executed: 1002 ]
[ Application: [unknown] - Total duration: 13m29s - Times executed: 1002 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (49846, 417, '215495051515', '',077,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-31 14:02:34 Duration: 5s670ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48688, 406, '835211931002790,241700844449,241645588911,241622485668,241649596069,241783849597,241676729604,241664693334,241622543755,241659738900,241676729402,241604358602,241704302834,241593391617,241689182234,241668200815,241608699104,241663085152,241672187993,230043599810,241620729111,241659762438,241708809312,241689154150,241708971730,241599325473,241704739396,241636060518,241728702533,241689401223,241695487798,241711220008,241704368395,241630744757,241637722745,241673388908,241673367794,241618286167,241701369304,241730907293,241614545656,241704222546,241728544661,241676730514,241620802631,241678301116,241704286165,241666367784,241689377583,241728682430,241620735475', '',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-31 16:15:02 Duration: 5s221ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272347, 503, '836023904001391,241727925476,241731804261,241677515674,241666171829,241604210002,241637897991,241676248995,230047933039,241673843554,241727932323,241651018093,241668710416,241662204449,241674290927,241694661523,241682726676,241656980820,241696457376,241677496783,241655459010,241699326983,241653961221,241708519912,241714720215,241657197383,241649813139,241727938181,241731924856,241661883150,241651710317,241730311725,241727960407,241699254148,241712023958,241727973135,241675852235,241730417391,241608185563,241730425877,241715226683', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"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-31 08:55:11 Duration: 4s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 12m19s 69 1s596ms 55s808ms 10s721ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 31 07 5 55s476ms 11s95ms 08 1 10s341ms 10s341ms 09 11 1m56s 10s580ms 10 7 2m50s 24s321ms 11 6 48s156ms 8s26ms 13 9 1m 6s763ms 14 8 2m34s 19s349ms 15 17 1m44s 6s139ms 16 5 19s101ms 3s820ms [ User: intelifix - Total duration: 12m19s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m19s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 14:20:11 Duration: 55s808ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 09:46:28 Duration: 53s841ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 10:39:37 Duration: 52s889ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10m24s 276 176ms 12s308ms 2s260ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 31 00 12 31s989ms 2s665ms 01 12 21s347ms 1s778ms 02 12 21s855ms 1s821ms 03 12 22s323ms 1s860ms 04 12 22s565ms 1s880ms 05 12 23s200ms 1s933ms 06 12 22s293ms 1s857ms 07 12 24s126ms 2s10ms 08 12 33s151ms 2s762ms 09 12 34s572ms 2s881ms 10 12 35s260ms 2s938ms 11 12 27s818ms 2s318ms 12 12 26s18ms 2s168ms 13 12 26s855ms 2s237ms 14 12 33s453ms 2s787ms 15 12 28s942ms 2s411ms 16 12 26s175ms 2s181ms 17 12 24s721ms 2s60ms 18 12 25s719ms 2s143ms 19 12 25s106ms 2s92ms 20 12 36s165ms 3s13ms 21 12 26s988ms 2s249ms 22 12 23s351ms 1s945ms [ User: intelifix - Total duration: 10m24s - Times executed: 276 ]
[ Application: psql - Total duration: 10m24s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 00:05:26 Duration: 12s308ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 20:05:11 Duration: 10s256ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 10:15:12 Duration: 9s536ms Database: rio User: intelifix Remote: [local] Application: psql
9 7m20s 815 150ms 2s877ms 540ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 31 06 2 1s125ms 562ms 07 134 1m33s 697ms 08 151 1m11s 471ms 09 116 1m9s 596ms 10 123 1m7s 546ms 11 155 1m11s 462ms 12 11 6s278ms 570ms 13 46 24s306ms 528ms 14 23 11s386ms 495ms 15 32 15s423ms 481ms 16 22 9s516ms 432ms [ User: intelifix - Total duration: 7m20s - Times executed: 815 ]
[ Application: [unknown] - Total duration: 7m20s - Times executed: 815 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243832", "modelo" : "159", "itens" : "229683213348,229653333249,229653418890,229653176162,229653178283,229653201317,229653239906,229653328298,229653334562,229653407273,229653168585,229653239704,229653321531,229653322036,229653330017,229653441116,229653559410,229653176768,229653548702,229653538701,229653629393,229653764862,229760643441,229651289918,229680869808,229684241114,229759746574,229757810101,229762126077,229653133353,229683959010,229757460920", "usuario" : "414", "caixa" : "2925660", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-31 07:24:15 Duration: 2s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273101", "modelo" : "159", "itens" : "229654577982,229680698400,229683203044,229682375858,229757446473,229683282749,229757202937,229652349303,229680868393,229683496787,229680209912,229652235779,229651731533,229682042841,229680794952,229681884060,229654434153,229756354762,229757504156,229654749717,229653838001,229653794158,229653076276,229679953445,229762518191,229680939815,229654539315,229652352536,229757593435,229757386770,229681013941,229683370210,229651432435,216917581334,229682018090,229759481218,229682246272,229652463658,229683214156,229654337678,229761149203,229761006484,229654232843,229652293641,229651370510,229758433046,229653634950,229761017798", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-31 07:13:13 Duration: 2s417ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273099", "modelo" : "159", "itens" : "229680231430,229680896376,229654199203,229758152536,229682401316,229682306480,229761638296,229651847682,229682149999,229683892943,229652602033,229683003653,229762816481,229654052040,229653197780,229684056875,229681489396,229680445367,229683401223,229683421023,229652644764,216917122344,229762908790,229679484858,229679530015,229679905864,229757479608,229762664446,229760143033,229651533859,229680751840,229682172528,216917290419,229681765967,229651846268,229761126372,229762573551,229759207980,229761138898,229681040005,229682349515,229682272841,229654306486,229680278202,229653201620,229683207185,229683014462,229758415872", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-31 07:04:23 Duration: 2s344ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 5m34s 137 167ms 12s822ms 2s441ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 31 00 6 19s827ms 3s304ms 01 6 8s362ms 1s393ms 02 5 7s418ms 1s483ms 03 5 7s273ms 1s454ms 04 6 11s62ms 1s843ms 05 5 11s449ms 2s289ms 06 1 1s8ms 1s8ms 07 9 32s102ms 3s566ms 08 11 39s377ms 3s579ms 09 12 48s93ms 4s7ms 10 11 44s544ms 4s49ms 11 12 31s48ms 2s587ms 12 9 16s568ms 1s840ms 13 4 2s27ms 506ms 14 11 16s348ms 1s486ms 15 7 10s547ms 1s506ms 16 6 9s435ms 1s572ms 20 1 240ms 240ms 21 4 7s462ms 1s865ms 22 6 10s290ms 1s715ms [ User: intelifix - Total duration: 5m34s - Times executed: 137 ]
[ Application: psql - Total duration: 5m34s - Times executed: 137 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 00:05:13 Duration: 12s822ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 10:25:10 Duration: 8s617ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 10:45:08 Duration: 7s355ms Database: rio User: intelifix Remote: [local] Application: psql
11 3m16s 16 10s112ms 26s509ms 12s282ms create table temp0000287170 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 31 11 9 1m59s 13s314ms 12 7 1m16s 10s956ms [ User: intelifix - Total duration: 3m16s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m16s - Times executed: 16 ]
-
CREATE TABLE temp0000287170 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 11:32:03 Duration: 26s509ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287170 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 11:55:40 Duration: 13s315ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287170 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 11:38:12 Duration: 12s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 3m13s 509 151ms 1s821ms 379ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 31 10 47 31s728ms 675ms 11 340 1m49s 321ms 13 114 50s129ms 439ms 14 6 1s766ms 294ms 15 2 473ms 236ms [ User: intelifix - Total duration: 3m13s - Times executed: 509 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 509 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"229968767680,230029312434,230026383753,230030722336,230050967083,229978299711,229987863439,230031642235,230047569109,230026268993,230014736162,230032692730,230006971017,229981451321,230043993137,230043984954,229981793958,230009825874,230052527785,230000926565,229991394760,230014387385,230055416283,229975060417,230019620209,230030715769,230014485880,230025290527,230009807387,230031745353,229977569909,230034398800,230028271637,229991580312,230020866884,230030457786","usuario":"419","observacao":""}');
Date: 2026-07-31 10:52:30 Duration: 1s821ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"241673372139,241711111333,241622613537,241663852534,241659752235,241678332735,241618262630,241610024149,230048002541,241672196883,241659740517,241680350104,241700953854,241692663853,241620794953,241692689613,241704219212,241622621619,241695505151,241635757782,241647236770,241629137787,241656766578,241620860011,241673332741,241664810922,241711214956,241731249100,241645800223,241695570310,241676719502,241732062446,241713726772,241676716370,241731202429,241646239614,241703551010,241713701821,241656767790,241692661833,241692665166,241659661620,241673333650,241617429204,241732063860,241637745676,241700930014,241680407684,241614550506,241636120524,241728733647,241608644957,241692676884,241604972433,241703899203,241732061133,230043584859,241732088687,241708911926,241728730819,241678345564,241729501332","usuario":"419","observacao":""}');
Date: 2026-07-31 10:54:14 Duration: 1s744ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"229787774753,229661271925,229743101819,229813876885,229747692525,229809469205,229755127683,229808990517,229808539507,229746116366,229742237783,229691431726,229742445559,229807210725,229745417375,229860161919,229809307494,229817078095,229755717191,229689923352,229865565667,229684432345,229669949921,229786224759,229686648699,229749238905,229691533150,229748428791,229859992733,229663790409,229690805267,229813330211,229663024666,229812976483,216935954462,229786927992,229812698195,229933312021,229690061121,229737512239,216940443239,229690348702,216944823543,229813528893,229837171011,229688601416,229726564245,229836869208,229735815765,229663788286","usuario":"409","observacao":""}');
Date: 2026-07-31 11:48:16 Duration: 1s522ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 3m6s 4 4s954ms 1m29s 46s742ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 31 20 2 1m34s 47s32ms 23 2 1m32s 46s452ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-31 20:08:39 Duration: 1m29s 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-31 23:16:59 Duration: 1m27s 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-31 23:38:02 Duration: 4s982ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 2m12s 82 157ms 15s723ms 1s617ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 31 07 5 2s599ms 519ms 09 7 6s219ms 888ms 10 16 8s585ms 536ms 11 12 6s801ms 566ms 13 7 47s140ms 6s734ms 14 27 17s108ms 633ms 15 7 42s814ms 6s116ms 16 1 1s351ms 1s351ms [ User: intelifix - Total duration: 2m12s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 2m12s - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-07-31 13:44:35 Duration: 15s723ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-07-31 15:42:51 Duration: 12s176ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-07-31 15:42:04 Duration: 12s14ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
15 1m58s 4 458ms 1m 29s613ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 31 20 2 57s226ms 28s613ms 23 2 1m1s 30s614ms [ User: intelifix - Total duration: 1m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m58s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-31 23:13:40 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-31 20:05:29 Duration: 56s665ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-31 20:09:58 Duration: 560ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 1m54s 10 9s819ms 12s657ms 11s463ms create table temp0000287176 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 31 13 4 46s177ms 11s544ms 14 6 1m8s 11s409ms [ User: intelifix - Total duration: 1m54s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 10 ]
-
CREATE TABLE temp0000287176 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 13:53:10 Duration: 12s657ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287176 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 13:51:44 Duration: 12s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287176 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 14:16:31 Duration: 12s223ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 1m51s 8 11s41ms 23s865ms 13s943ms create table temp0000287112 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 31 08 7 1m39s 14s145ms 09 1 12s533ms 12s533ms [ User: intelifix - Total duration: 1m51s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1m51s - Times executed: 8 ]
-
CREATE TABLE temp0000287112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:34:40 Duration: 23s865ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:40:38 Duration: 13s809ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:35:32 Duration: 13s661ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 1m49s 7 10s648ms 37s592ms 15s606ms create table temp0000287188 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 31 14 6 1m11s 11s942ms 16 1 37s592ms 37s592ms [ User: intelifix - Total duration: 1m49s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m49s - Times executed: 7 ]
-
CREATE TABLE temp0000287188 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 16:27:39 Duration: 37s592ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287188 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 14:02:03 Duration: 13s284ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287188 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 14:27:53 Duration: 12s713ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m40s 29 209ms 11s762ms 3s469ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 31 07 3 17s882ms 5s960ms 08 4 15s632ms 3s908ms 09 5 12s109ms 2s421ms 10 5 21s928ms 4s385ms 11 1 1s768ms 1s768ms 12 3 1s347ms 449ms 13 1 6s410ms 6s410ms 14 7 23s524ms 3s360ms [ User: intelifix - Total duration: 1m40s - Times executed: 29 ]
[ Application: psql - Total duration: 1m40s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027860);
Date: 2026-07-31 07:18:06 Duration: 11s762ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027882);
Date: 2026-07-31 10:09:38 Duration: 8s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027879);
Date: 2026-07-31 09:32:10 Duration: 7s567ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m37s 6 3s935ms 38s334ms 16s319ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 31 00 3 49s739ms 16s579ms 06 3 48s178ms 16s59ms [ User: lenon - Total duration: 1m37s - Times executed: 6 ]
[ Application: psql - Total duration: 1m37s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-31 00:02:47 Duration: 38s334ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-31 06:02:39 Duration: 36s899ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-31 00:02:55 Duration: 7s470ms Database: brasilia User: lenon Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,002 13m29s 150ms 5s670ms 808ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 31 07 87 1m6s 759ms 08 143 1m50s 769ms 09 173 2m3s 715ms 10 155 2m3s 794ms 11 96 1m16s 801ms 12 25 22s143ms 885ms 13 55 46s370ms 843ms 14 91 1m15s 828ms 15 84 1m13s 877ms 16 57 56s612ms 993ms 17 36 35s537ms 987ms [ User: intelifix - Total duration: 13m29s - Times executed: 1002 ]
[ Application: [unknown] - Total duration: 13m29s - Times executed: 1002 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (49846, 417, '215495051515', '',077,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-31 14:02:34 Duration: 5s670ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48688, 406, '835211931002790,241700844449,241645588911,241622485668,241649596069,241783849597,241676729604,241664693334,241622543755,241659738900,241676729402,241604358602,241704302834,241593391617,241689182234,241668200815,241608699104,241663085152,241672187993,230043599810,241620729111,241659762438,241708809312,241689154150,241708971730,241599325473,241704739396,241636060518,241728702533,241689401223,241695487798,241711220008,241704368395,241630744757,241637722745,241673388908,241673367794,241618286167,241701369304,241730907293,241614545656,241704222546,241728544661,241676730514,241620802631,241678301116,241704286165,241666367784,241689377583,241728682430,241620735475', '',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-31 16:15:02 Duration: 5s221ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272347, 503, '836023904001391,241727925476,241731804261,241677515674,241666171829,241604210002,241637897991,241676248995,230047933039,241673843554,241727932323,241651018093,241668710416,241662204449,241674290927,241694661523,241682726676,241656980820,241696457376,241677496783,241655459010,241699326983,241653961221,241708519912,241714720215,241657197383,241649813139,241727938181,241731924856,241661883150,241651710317,241730311725,241727960407,241699254148,241712023958,241727973135,241675852235,241730417391,241608185563,241730425877,241715226683', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"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-31 08:55:11 Duration: 4s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 815 7m20s 150ms 2s877ms 540ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 31 06 2 1s125ms 562ms 07 134 1m33s 697ms 08 151 1m11s 471ms 09 116 1m9s 596ms 10 123 1m7s 546ms 11 155 1m11s 462ms 12 11 6s278ms 570ms 13 46 24s306ms 528ms 14 23 11s386ms 495ms 15 32 15s423ms 481ms 16 22 9s516ms 432ms [ User: intelifix - Total duration: 7m20s - Times executed: 815 ]
[ Application: [unknown] - Total duration: 7m20s - Times executed: 815 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243832", "modelo" : "159", "itens" : "229683213348,229653333249,229653418890,229653176162,229653178283,229653201317,229653239906,229653328298,229653334562,229653407273,229653168585,229653239704,229653321531,229653322036,229653330017,229653441116,229653559410,229653176768,229653548702,229653538701,229653629393,229653764862,229760643441,229651289918,229680869808,229684241114,229759746574,229757810101,229762126077,229653133353,229683959010,229757460920", "usuario" : "414", "caixa" : "2925660", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-31 07:24:15 Duration: 2s877ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273101", "modelo" : "159", "itens" : "229654577982,229680698400,229683203044,229682375858,229757446473,229683282749,229757202937,229652349303,229680868393,229683496787,229680209912,229652235779,229651731533,229682042841,229680794952,229681884060,229654434153,229756354762,229757504156,229654749717,229653838001,229653794158,229653076276,229679953445,229762518191,229680939815,229654539315,229652352536,229757593435,229757386770,229681013941,229683370210,229651432435,216917581334,229682018090,229759481218,229682246272,229652463658,229683214156,229654337678,229761149203,229761006484,229654232843,229652293641,229651370510,229758433046,229653634950,229761017798", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-31 07:13:13 Duration: 2s417ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273099", "modelo" : "159", "itens" : "229680231430,229680896376,229654199203,229758152536,229682401316,229682306480,229761638296,229651847682,229682149999,229683892943,229652602033,229683003653,229762816481,229654052040,229653197780,229684056875,229681489396,229680445367,229683401223,229683421023,229652644764,216917122344,229762908790,229679484858,229679530015,229679905864,229757479608,229762664446,229760143033,229651533859,229680751840,229682172528,216917290419,229681765967,229651846268,229761126372,229762573551,229759207980,229761138898,229681040005,229682349515,229682272841,229654306486,229680278202,229653201620,229683207185,229683014462,229758415872", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-31 07:04:23 Duration: 2s344ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 509 3m13s 151ms 1s821ms 379ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 31 10 47 31s728ms 675ms 11 340 1m49s 321ms 13 114 50s129ms 439ms 14 6 1s766ms 294ms 15 2 473ms 236ms [ User: intelifix - Total duration: 3m13s - Times executed: 509 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 509 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"229968767680,230029312434,230026383753,230030722336,230050967083,229978299711,229987863439,230031642235,230047569109,230026268993,230014736162,230032692730,230006971017,229981451321,230043993137,230043984954,229981793958,230009825874,230052527785,230000926565,229991394760,230014387385,230055416283,229975060417,230019620209,230030715769,230014485880,230025290527,230009807387,230031745353,229977569909,230034398800,230028271637,229991580312,230020866884,230030457786","usuario":"419","observacao":""}');
Date: 2026-07-31 10:52:30 Duration: 1s821ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"241673372139,241711111333,241622613537,241663852534,241659752235,241678332735,241618262630,241610024149,230048002541,241672196883,241659740517,241680350104,241700953854,241692663853,241620794953,241692689613,241704219212,241622621619,241695505151,241635757782,241647236770,241629137787,241656766578,241620860011,241673332741,241664810922,241711214956,241731249100,241645800223,241695570310,241676719502,241732062446,241713726772,241676716370,241731202429,241646239614,241703551010,241713701821,241656767790,241692661833,241692665166,241659661620,241673333650,241617429204,241732063860,241637745676,241700930014,241680407684,241614550506,241636120524,241728733647,241608644957,241692676884,241604972433,241703899203,241732061133,230043584859,241732088687,241708911926,241728730819,241678345564,241729501332","usuario":"419","observacao":""}');
Date: 2026-07-31 10:54:14 Duration: 1s744ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"229787774753,229661271925,229743101819,229813876885,229747692525,229809469205,229755127683,229808990517,229808539507,229746116366,229742237783,229691431726,229742445559,229807210725,229745417375,229860161919,229809307494,229817078095,229755717191,229689923352,229865565667,229684432345,229669949921,229786224759,229686648699,229749238905,229691533150,229748428791,229859992733,229663790409,229690805267,229813330211,229663024666,229812976483,216935954462,229786927992,229812698195,229933312021,229690061121,229737512239,216940443239,229690348702,216944823543,229813528893,229837171011,229688601416,229726564245,229836869208,229735815765,229663788286","usuario":"409","observacao":""}');
Date: 2026-07-31 11:48:16 Duration: 1s522ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 276 10m24s 176ms 12s308ms 2s260ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 31 00 12 31s989ms 2s665ms 01 12 21s347ms 1s778ms 02 12 21s855ms 1s821ms 03 12 22s323ms 1s860ms 04 12 22s565ms 1s880ms 05 12 23s200ms 1s933ms 06 12 22s293ms 1s857ms 07 12 24s126ms 2s10ms 08 12 33s151ms 2s762ms 09 12 34s572ms 2s881ms 10 12 35s260ms 2s938ms 11 12 27s818ms 2s318ms 12 12 26s18ms 2s168ms 13 12 26s855ms 2s237ms 14 12 33s453ms 2s787ms 15 12 28s942ms 2s411ms 16 12 26s175ms 2s181ms 17 12 24s721ms 2s60ms 18 12 25s719ms 2s143ms 19 12 25s106ms 2s92ms 20 12 36s165ms 3s13ms 21 12 26s988ms 2s249ms 22 12 23s351ms 1s945ms [ User: intelifix - Total duration: 10m24s - Times executed: 276 ]
[ Application: psql - Total duration: 10m24s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 00:05:26 Duration: 12s308ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 20:05:11 Duration: 10s256ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 10:15:12 Duration: 9s536ms Database: rio User: intelifix Remote: [local] Application: psql
5 253 1h40m30s 151ms 6m26s 23s835ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 31 07 18 13m26s 44s778ms 08 21 17m23s 49s712ms 09 22 6m44s 18s379ms 10 35 24m3s 41s238ms 11 25 8m6s 19s468ms 12 6 9s86ms 1s514ms 13 22 5m4s 13s832ms 14 73 21m52s 17s976ms 15 23 3m28s 9s69ms 16 5 7s603ms 1s520ms 17 3 4s140ms 1s380ms [ User: intelifix - Total duration: 1h40m30s - Times executed: 253 ]
[ Application: [unknown] - Total duration: 1h40m30s - Times executed: 253 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-31 08:19:54 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-30'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-31 10:48:20 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027860, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-31 07:24:19 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
6 137 5m34s 167ms 12s822ms 2s441ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 31 00 6 19s827ms 3s304ms 01 6 8s362ms 1s393ms 02 5 7s418ms 1s483ms 03 5 7s273ms 1s454ms 04 6 11s62ms 1s843ms 05 5 11s449ms 2s289ms 06 1 1s8ms 1s8ms 07 9 32s102ms 3s566ms 08 11 39s377ms 3s579ms 09 12 48s93ms 4s7ms 10 11 44s544ms 4s49ms 11 12 31s48ms 2s587ms 12 9 16s568ms 1s840ms 13 4 2s27ms 506ms 14 11 16s348ms 1s486ms 15 7 10s547ms 1s506ms 16 6 9s435ms 1s572ms 20 1 240ms 240ms 21 4 7s462ms 1s865ms 22 6 10s290ms 1s715ms [ User: intelifix - Total duration: 5m34s - Times executed: 137 ]
[ Application: psql - Total duration: 5m34s - Times executed: 137 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 00:05:13 Duration: 12s822ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 10:25:10 Duration: 8s617ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 10:45:08 Duration: 7s355ms Database: rio User: intelifix Remote: [local] Application: psql
7 100 22s528ms 150ms 2s778ms 225ms create table temp0000226724 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 31 09 19 6s313ms 332ms 10 8 1s418ms 177ms 11 19 3s629ms 191ms 13 13 2s681ms 206ms 14 12 2s715ms 226ms 15 7 1s269ms 181ms 16 14 2s860ms 204ms 17 8 1s639ms 204ms [ User: intelifix - Total duration: 22s528ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 22s528ms - Times executed: 100 ]
-
CREATE TABLE temp0000226724 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 09:03:14 Duration: 2s778ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226724 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"10999", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 09:02:55 Duration: 353ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226724 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"150", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 09:54:19 Duration: 326ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 99 45s428ms 272ms 768ms 458ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 31 01 2 808ms 404ms 03 2 785ms 392ms 04 2 731ms 365ms 05 2 847ms 423ms 06 2 826ms 413ms 07 9 4s319ms 479ms 08 11 5s130ms 466ms 09 10 4s761ms 476ms 10 13 6s68ms 466ms 11 8 3s780ms 472ms 12 3 1s274ms 424ms 13 9 4s70ms 452ms 14 12 5s668ms 472ms 15 5 1s995ms 399ms 16 6 2s972ms 495ms 17 1 500ms 500ms 20 1 474ms 474ms 21 1 415ms 415ms [ User: lenon - Total duration: 45s428ms - Times executed: 99 ]
[ Application: [unknown] - Total duration: 45s428ms - Times executed: 99 ]
-
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-31 09:02:54 Duration: 768ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-31 14:13:27 Duration: 698ms 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-31 10:18:33 Duration: 682ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 99 23s83ms 151ms 413ms 233ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 31 01 11 2s24ms 184ms 04 15 4s607ms 307ms 05 9 2s107ms 234ms 07 8 1s673ms 209ms 08 8 1s782ms 222ms 09 11 2s566ms 233ms 10 11 2s631ms 239ms 11 10 1s972ms 197ms 14 16 3s718ms 232ms [ User: intelifix - Total duration: 23s83ms - Times executed: 99 ]
[ Application: [unknown] - Total duration: 23s83ms - Times executed: 99 ]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229820412731,229772623544,229795553537,229789720118,229788743142,229821385766,229858615157,229797281933', NULL, NULL, 0145, 00);
Date: 2026-07-31 14:15:10 Duration: 413ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241632314652,241732082021,241605033954,241713350317,241622585173,241695039214,241637521738,241713725055,241650447375,241637712138,241697027791,241665712132,241732679105,241609916282,241711214350,241617912136,241710303543,241595010810,241675283941,241649316266', NULL, NULL, 0320, 00);
Date: 2026-07-31 04:43:58 Duration: 395ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229825025055,229830748385,229832637683,229716029704,216931101430,229825836986,229706713958,229641564659,229704689595,229712213249', NULL, NULL, 0137, 00);
Date: 2026-07-31 14:20:02 Duration: 389ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 94 19s320ms 150ms 1s581ms 205ms create table temp0000226710 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 31 10 4 2s293ms 573ms 11 6 918ms 153ms 13 6 931ms 155ms 14 61 11s797ms 193ms 15 3 575ms 191ms 16 6 1s136ms 189ms 17 8 1s668ms 208ms [ User: intelifix - Total duration: 19s320ms - Times executed: 94 ]
[ Application: [unknown] - Total duration: 19s320ms - Times executed: 94 ]
-
CREATE TABLE temp0000226710 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 10:16:33 Duration: 1s581ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226710 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"152", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 10:53:23 Duration: 280ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226710 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"10999", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 10:15:17 Duration: 279ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 91 52s98ms 369ms 1s71ms 572ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 31 01 2 1s201ms 600ms 03 1 486ms 486ms 04 2 1s40ms 520ms 05 2 1s61ms 530ms 06 1 499ms 499ms 07 7 3s886ms 555ms 08 11 6s309ms 573ms 09 10 6s146ms 614ms 10 13 7s573ms 582ms 11 8 4s650ms 581ms 12 3 1s573ms 524ms 13 8 4s221ms 527ms 14 12 7s190ms 599ms 15 5 2s615ms 523ms 16 5 2s967ms 593ms 17 1 674ms 674ms [ User: intelifix - Total duration: 52s98ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 52s98ms - Times executed: 91 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-31 09:02:54 Duration: 1s71ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (507, 53, 1);
Date: 2026-07-31 14:13:27 Duration: 857ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 81, 1);
Date: 2026-07-31 08:06:56 Duration: 786ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 90 18s186ms 152ms 756ms 202ms create table temp0000237252 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 31 07 1 756ms 756ms 08 1 181ms 181ms 09 2 375ms 187ms 10 7 1s312ms 187ms 11 4 685ms 171ms 12 3 554ms 184ms 13 9 1s662ms 184ms 14 17 3s289ms 193ms 15 13 2s963ms 227ms 16 33 6s404ms 194ms [ User: intelifix - Total duration: 18s186ms - Times executed: 90 ]
[ Application: [unknown] - Total duration: 18s186ms - Times executed: 90 ]
-
CREATE TABLE temp0000237252 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "26-07-2026", "data-ate" : "31-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-31 07:55:51 Duration: 756ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237252 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "31-07-2026", "data-ate" : "31-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-31 15:22:21 Duration: 340ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237252 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "31-07-2026", "data-ate" : "31-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-31 14:14:31 Duration: 310ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 89 36s435ms 305ms 754ms 409ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 31 07 7 3s15ms 430ms 08 11 4s319ms 392ms 09 11 4s211ms 382ms 10 11 4s571ms 415ms 11 8 3s347ms 418ms 12 5 1s738ms 347ms 13 6 2s599ms 433ms 14 17 7s511ms 441ms 15 8 3s239ms 404ms 16 4 1s519ms 379ms 17 1 361ms 361ms [ User: intelifix - Total duration: 36s435ms - Times executed: 89 ]
[ Application: [unknown] - Total duration: 36s435ms - Times executed: 89 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-31 14:53:04 Duration: 754ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-07-31 13:43:55 Duration: 618ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-31 14:39:24 Duration: 604ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 82 2m12s 157ms 15s723ms 1s617ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 31 07 5 2s599ms 519ms 09 7 6s219ms 888ms 10 16 8s585ms 536ms 11 12 6s801ms 566ms 13 7 47s140ms 6s734ms 14 27 17s108ms 633ms 15 7 42s814ms 6s116ms 16 1 1s351ms 1s351ms [ User: intelifix - Total duration: 2m12s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 2m12s - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-07-31 13:44:35 Duration: 15s723ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-07-31 15:42:51 Duration: 12s176ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-07-31 15:42:04 Duration: 12s14ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
15 71 14m56s 9s831ms 19s731ms 12s626ms create table temp0000287108 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 31 07 14 2m42s 11s594ms 08 17 3m42s 13s68ms 09 9 2m1s 13s513ms 10 23 4m54s 12s797ms 14 8 1m36s 12s9ms [ User: intelifix - Total duration: 14m56s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 14m56s - Times executed: 71 ]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 10:08:27 Duration: 19s731ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 09:32:18 Duration: 15s308ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:54:11 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 69 12m19s 1s596ms 55s808ms 10s721ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 31 07 5 55s476ms 11s95ms 08 1 10s341ms 10s341ms 09 11 1m56s 10s580ms 10 7 2m50s 24s321ms 11 6 48s156ms 8s26ms 13 9 1m 6s763ms 14 8 2m34s 19s349ms 15 17 1m44s 6s139ms 16 5 19s101ms 3s820ms [ User: intelifix - Total duration: 12m19s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m19s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 14:20:11 Duration: 55s808ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 09:46:28 Duration: 53s841ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 10:39:37 Duration: 52s889ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 55 28s129ms 160ms 1s236ms 511ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 31 07 3 2s836ms 945ms 08 3 2s41ms 680ms 09 17 8s124ms 477ms 10 16 6s807ms 425ms 11 10 5s834ms 583ms 14 4 1s172ms 293ms 15 2 1s312ms 656ms [ User: intelifix - Total duration: 28s129ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 28s129ms - Times executed: 55 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '319092860216,10C25A3D6E46,BC9B68959223,54A65C8C4B65,90585144D7E2,1062D0C7F041,1062D0123D28,5C769593F31B,480033058378,A456CCE45348,5C769591F89E,1062D01213E5,A456CCE30E4D,54A65C10D2BB,905851416016,14B7F8DFF156', '138;1', 'DEFAULT', 09, 046, '','', '', 00);
Date: 2026-07-31 09:39:28 Duration: 1s236ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D89A0DA8FCA9,4896D958B776,D831398F7AFA,5872C98F889B,48D682333D3C,D89A0DAD02FF,3CF9F0A43E06,843C9935CE6D,843C9922BAD9,48D682399E38,843C9933A8B9,5872C98B108D,F4E84F899846,D831392216C4,5872C994A3AB,D89A0DACCD89,C4EBFF898D52,843C992DDEFB,D8313993B072,3CF9F0A54306', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-31 10:08:13 Duration: 1s209ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '843C99215B55,5872C98F6687,843C99227AD1,3CF9F0AB2E66,F4E84F86831C,843C993568C1,4896D956946E,843C992D3B5D,F4E84F89A434,4896D9546302,843C992167F1,D83139218E68,3891485389E7,5872C994C805,389148538D6B,48D6823020D4,14CA56CE599D,C4EBFF8D3606,48D68238873E,F4E84F81EA0E', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-07-31 07:39:04 Duration: 1s119ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
18 53 22s829ms 150ms 4s296ms 430ms create table temp0000287118 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 31 07 1 4s296ms 4s296ms 08 9 1s478ms 164ms 09 8 3s473ms 434ms 10 16 5s858ms 366ms 11 18 7s337ms 407ms 13 1 386ms 386ms [ User: intelifix - Total duration: 22s829ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 22s829ms - Times executed: 53 ]
-
CREATE TABLE temp0000287118 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 07:25:52 Duration: 4s296ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287118 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"82501", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 11:26:29 Duration: 640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287118 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"26-07-2026", "ate" :"31-07-2026", "nota-fiscal":"82501", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-31 10:25:08 Duration: 586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 52 10s437ms 150ms 1s245ms 200ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 31 01 1 166ms 166ms 08 2 1s410ms 705ms 09 3 544ms 181ms 10 4 778ms 194ms 11 8 1s330ms 166ms 12 3 480ms 160ms 13 1 157ms 157ms 14 4 938ms 234ms 15 17 2s933ms 172ms 16 8 1s486ms 185ms 17 1 209ms 209ms [ User: intelifix - Total duration: 10s437ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 10s437ms - Times executed: 52 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-31", "data-ate" : "2026-07-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-07-31 08:49:53 Duration: 1s245ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-07-31", "data-ate" : "2026-07-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 304 }');
Date: 2026-07-31 14:30:53 Duration: 288ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-07-31", "data-ate" : "2026-07-31", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 401 }');
Date: 2026-07-31 14:32:57 Duration: 240ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 51 1m37s 175ms 31s814ms 1s904ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 31 07 5 2s968ms 593ms 08 12 5s633ms 469ms 09 4 32s884ms 8s221ms 10 10 7s976ms 797ms 11 3 18s517ms 6s172ms 12 3 9s918ms 3s306ms 13 3 787ms 262ms 14 11 18s457ms 1s677ms [ User: intelifix - Total duration: 1m37s - Times executed: 51 ]
[ Application: psql - Total duration: 1m37s - Times executed: 51 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027880);
Date: 2026-07-31 09:37:16 Duration: 31s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027893);
Date: 2026-07-31 11:57:53 Duration: 16s527ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027901);
Date: 2026-07-31 14:16:01 Duration: 8s313ms 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 2m24s 9m29s 5m28s 3 16m26s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 31 05 3 16m26s 5m28s [ User: intelifix - Total duration: 16m26s - Times executed: 3 ]
[ Application: psql - Total duration: 16m26s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-31 05:09:30 Duration: 9m29s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-31 05:14:03 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-31 05:16:28 Duration: 2m24s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s259ms 9m19s 2m33s 48 2h2m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 31 07 3 9m21s 3m7s 08 3 9m10s 3m3s 09 3 9m57s 3m19s 10 3 9m55s 3m18s 11 3 8m1s 2m40s 12 3 7m22s 2m27s 13 3 6m15s 2m5s 14 3 8m15s 2m45s 15 3 9m17s 3m5s 16 3 6m14s 2m4s 17 3 6m34s 2m11s 18 3 6m6s 2m2s 19 3 6m20s 2m6s 20 3 7m28s 2m29s 21 3 6m16s 2m5s 22 3 6m12s 2m4s [ User: intelifix - Total duration: 2h2m51s - Times executed: 48 ]
[ Application: psql - Total duration: 2h2m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-31 09:14:20 Duration: 9m19s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-31 10:14:20 Duration: 9m18s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-31 15:13:45 Duration: 8m44s Database: rio User: intelifix Remote: [local] Application: psql
3 197ms 4m29s 1m31s 48 1h13m29s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 31 07 3 5m22s 1m47s 08 3 4m52s 1m37s 09 3 5m36s 1m52s 10 3 5m24s 1m48s 11 3 5m2s 1m40s 12 3 4m21s 1m27s 13 3 4m6s 1m22s 14 3 4m49s 1m36s 15 3 4m29s 1m29s 16 3 4m13s 1m24s 17 3 4m7s 1m22s 18 3 3m53s 1m17s 19 3 4m7s 1m22s 20 3 4m40s 1m33s 21 3 4m10s 1m23s 22 3 4m11s 1m23s [ User: intelifix - Total duration: 1h13m29s - Times executed: 48 ]
[ Application: psql - Total duration: 1h13m29s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-31 09:20:30 Duration: 4m29s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-31 10:20:17 Duration: 4m25s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-31 07:19:39 Duration: 4m14s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s954ms 1m29s 46s742ms 4 3m6s 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 31 20 2 1m34s 47s32ms 23 2 1m32s 46s452ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-31 20:08:39 Duration: 1m29s 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-31 23:16:59 Duration: 1m27s 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-31 23:38:02 Duration: 4s982ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 458ms 1m 29s613ms 4 1m58s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 31 20 2 57s226ms 28s613ms 23 2 1m1s 30s614ms [ User: intelifix - Total duration: 1m58s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m58s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-31 23:13:40 Duration: 1m Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-31 20:05:29 Duration: 56s665ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-31 20:09:58 Duration: 560ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 151ms 6m26s 23s835ms 253 1h40m30s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 31 07 18 13m26s 44s778ms 08 21 17m23s 49s712ms 09 22 6m44s 18s379ms 10 35 24m3s 41s238ms 11 25 8m6s 19s468ms 12 6 9s86ms 1s514ms 13 22 5m4s 13s832ms 14 73 21m52s 17s976ms 15 23 3m28s 9s69ms 16 5 7s603ms 1s520ms 17 3 4s140ms 1s380ms [ User: intelifix - Total duration: 1h40m30s - Times executed: 253 ]
[ Application: [unknown] - Total duration: 1h40m30s - Times executed: 253 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-31 08:19:54 Duration: 6m26s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-30'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-31 10:48:20 Duration: 6m6s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027860, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-31 07:24:19 Duration: 5m55s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 3s935ms 38s334ms 16s319ms 6 1m37s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 31 00 3 49s739ms 16s579ms 06 3 48s178ms 16s59ms [ User: lenon - Total duration: 1m37s - Times executed: 6 ]
[ Application: psql - Total duration: 1m37s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-31 00:02:47 Duration: 38s334ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-31 06:02:39 Duration: 36s899ms Database: rio User: lenon Remote: [local] Application: psql
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-07-31 00:02:55 Duration: 7s470ms Database: brasilia User: lenon Remote: [local] Application: psql
8 10s648ms 37s592ms 15s606ms 7 1m49s create table temp0000287188 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 31 14 6 1m11s 11s942ms 16 1 37s592ms 37s592ms [ User: intelifix - Total duration: 1m49s - Times executed: 7 ]
[ Application: [unknown] - Total duration: 1m49s - Times executed: 7 ]
-
CREATE TABLE temp0000287188 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 16:27:39 Duration: 37s592ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287188 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 14:02:03 Duration: 13s284ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287188 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 14:27:53 Duration: 12s713ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11s41ms 23s865ms 13s943ms 8 1m51s create table temp0000287112 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 31 08 7 1m39s 14s145ms 09 1 12s533ms 12s533ms [ User: intelifix - Total duration: 1m51s - Times executed: 8 ]
[ Application: [unknown] - Total duration: 1m51s - Times executed: 8 ]
-
CREATE TABLE temp0000287112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:34:40 Duration: 23s865ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:40:38 Duration: 13s809ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287112 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:35:32 Duration: 13s661ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s831ms 19s731ms 12s626ms 71 14m56s create table temp0000287108 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 31 07 14 2m42s 11s594ms 08 17 3m42s 13s68ms 09 9 2m1s 13s513ms 10 23 4m54s 12s797ms 14 8 1m36s 12s9ms [ User: intelifix - Total duration: 14m56s - Times executed: 71 ]
[ Application: [unknown] - Total duration: 14m56s - Times executed: 71 ]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 10:08:27 Duration: 19s731ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 09:32:18 Duration: 15s308ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287108 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 08:54:11 Duration: 15s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s112ms 26s509ms 12s282ms 16 3m16s create table temp0000287170 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 31 11 9 1m59s 13s314ms 12 7 1m16s 10s956ms [ User: intelifix - Total duration: 3m16s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m16s - Times executed: 16 ]
-
CREATE TABLE temp0000287170 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 11:32:03 Duration: 26s509ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287170 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 11:55:40 Duration: 13s315ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287170 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 11:38:12 Duration: 12s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s819ms 12s657ms 11s463ms 10 1m54s create table temp0000287176 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 31 13 4 46s177ms 11s544ms 14 6 1m8s 11s409ms [ User: intelifix - Total duration: 1m54s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m54s - Times executed: 10 ]
-
CREATE TABLE temp0000287176 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 13:53:10 Duration: 12s657ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287176 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 13:51:44 Duration: 12s512ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000287176 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-31 14:16:31 Duration: 12s223ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s596ms 55s808ms 10s721ms 69 12m19s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 31 07 5 55s476ms 11s95ms 08 1 10s341ms 10s341ms 09 11 1m56s 10s580ms 10 7 2m50s 24s321ms 11 6 48s156ms 8s26ms 13 9 1m 6s763ms 14 8 2m34s 19s349ms 15 17 1m44s 6s139ms 16 5 19s101ms 3s820ms [ User: intelifix - Total duration: 12m19s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 12m19s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 14:20:11 Duration: 55s808ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 09:46:28 Duration: 53s841ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-31 10:39:37 Duration: 52s889ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 209ms 11s762ms 3s469ms 29 1m40s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 31 07 3 17s882ms 5s960ms 08 4 15s632ms 3s908ms 09 5 12s109ms 2s421ms 10 5 21s928ms 4s385ms 11 1 1s768ms 1s768ms 12 3 1s347ms 449ms 13 1 6s410ms 6s410ms 14 7 23s524ms 3s360ms [ User: intelifix - Total duration: 1m40s - Times executed: 29 ]
[ Application: psql - Total duration: 1m40s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027860);
Date: 2026-07-31 07:18:06 Duration: 11s762ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027882);
Date: 2026-07-31 10:09:38 Duration: 8s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027879);
Date: 2026-07-31 09:32:10 Duration: 7s567ms Database: rio User: intelifix Remote: [local] Application: psql
15 167ms 12s822ms 2s441ms 137 5m34s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 31 00 6 19s827ms 3s304ms 01 6 8s362ms 1s393ms 02 5 7s418ms 1s483ms 03 5 7s273ms 1s454ms 04 6 11s62ms 1s843ms 05 5 11s449ms 2s289ms 06 1 1s8ms 1s8ms 07 9 32s102ms 3s566ms 08 11 39s377ms 3s579ms 09 12 48s93ms 4s7ms 10 11 44s544ms 4s49ms 11 12 31s48ms 2s587ms 12 9 16s568ms 1s840ms 13 4 2s27ms 506ms 14 11 16s348ms 1s486ms 15 7 10s547ms 1s506ms 16 6 9s435ms 1s572ms 20 1 240ms 240ms 21 4 7s462ms 1s865ms 22 6 10s290ms 1s715ms [ User: intelifix - Total duration: 5m34s - Times executed: 137 ]
[ Application: psql - Total duration: 5m34s - Times executed: 137 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 00:05:13 Duration: 12s822ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 10:25:10 Duration: 8s617ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-31 10:45:08 Duration: 7s355ms Database: rio User: intelifix Remote: [local] Application: psql
16 176ms 12s308ms 2s260ms 276 10m24s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 31 00 12 31s989ms 2s665ms 01 12 21s347ms 1s778ms 02 12 21s855ms 1s821ms 03 12 22s323ms 1s860ms 04 12 22s565ms 1s880ms 05 12 23s200ms 1s933ms 06 12 22s293ms 1s857ms 07 12 24s126ms 2s10ms 08 12 33s151ms 2s762ms 09 12 34s572ms 2s881ms 10 12 35s260ms 2s938ms 11 12 27s818ms 2s318ms 12 12 26s18ms 2s168ms 13 12 26s855ms 2s237ms 14 12 33s453ms 2s787ms 15 12 28s942ms 2s411ms 16 12 26s175ms 2s181ms 17 12 24s721ms 2s60ms 18 12 25s719ms 2s143ms 19 12 25s106ms 2s92ms 20 12 36s165ms 3s13ms 21 12 26s988ms 2s249ms 22 12 23s351ms 1s945ms [ User: intelifix - Total duration: 10m24s - Times executed: 276 ]
[ Application: psql - Total duration: 10m24s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 00:05:26 Duration: 12s308ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 20:05:11 Duration: 10s256ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-31 10:15:12 Duration: 9s536ms Database: rio User: intelifix Remote: [local] Application: psql
17 175ms 31s814ms 1s904ms 51 1m37s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 31 07 5 2s968ms 593ms 08 12 5s633ms 469ms 09 4 32s884ms 8s221ms 10 10 7s976ms 797ms 11 3 18s517ms 6s172ms 12 3 9s918ms 3s306ms 13 3 787ms 262ms 14 11 18s457ms 1s677ms [ User: intelifix - Total duration: 1m37s - Times executed: 51 ]
[ Application: psql - Total duration: 1m37s - Times executed: 51 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 452); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027880);
Date: 2026-07-31 09:37:16 Duration: 31s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027893);
Date: 2026-07-31 11:57:53 Duration: 16s527ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027901);
Date: 2026-07-31 14:16:01 Duration: 8s313ms Database: rio User: intelifix Remote: [local] Application: psql
18 157ms 15s723ms 1s617ms 82 2m12s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 31 07 5 2s599ms 519ms 09 7 6s219ms 888ms 10 16 8s585ms 536ms 11 12 6s801ms 566ms 13 7 47s140ms 6s734ms 14 27 17s108ms 633ms 15 7 42s814ms 6s116ms 16 1 1s351ms 1s351ms [ User: intelifix - Total duration: 2m12s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 2m12s - Times executed: 82 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-07-31 13:44:35 Duration: 15s723ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-07-31 15:42:51 Duration: 12s176ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-07-31 15:42:04 Duration: 12s14ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 150ms 5s670ms 808ms 1,002 13m29s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 31 07 87 1m6s 759ms 08 143 1m50s 769ms 09 173 2m3s 715ms 10 155 2m3s 794ms 11 96 1m16s 801ms 12 25 22s143ms 885ms 13 55 46s370ms 843ms 14 91 1m15s 828ms 15 84 1m13s 877ms 16 57 56s612ms 993ms 17 36 35s537ms 987ms [ User: intelifix - Total duration: 13m29s - Times executed: 1002 ]
[ Application: [unknown] - Total duration: 13m29s - Times executed: 1002 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (49846, 417, '215495051515', '',077,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-31 14:02:34 Duration: 5s670ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48688, 406, '835211931002790,241700844449,241645588911,241622485668,241649596069,241783849597,241676729604,241664693334,241622543755,241659738900,241676729402,241604358602,241704302834,241593391617,241689182234,241668200815,241608699104,241663085152,241672187993,230043599810,241620729111,241659762438,241708809312,241689154150,241708971730,241599325473,241704739396,241636060518,241728702533,241689401223,241695487798,241711220008,241704368395,241630744757,241637722745,241673388908,241673367794,241618286167,241701369304,241730907293,241614545656,241704222546,241728544661,241676730514,241620802631,241678301116,241704286165,241666367784,241689377583,241728682430,241620735475', '',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-31 16:15:02 Duration: 5s221ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272347, 503, '836023904001391,241727925476,241731804261,241677515674,241666171829,241604210002,241637897991,241676248995,230047933039,241673843554,241727932323,241651018093,241668710416,241662204449,241674290927,241694661523,241682726676,241656980820,241696457376,241677496783,241655459010,241699326983,241653961221,241708519912,241714720215,241657197383,241649813139,241727938181,241731924856,241661883150,241651710317,241730311725,241727960407,241699254148,241712023958,241727973135,241675852235,241730417391,241608185563,241730425877,241715226683', '',0320,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"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-31 08:55:11 Duration: 4s234ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 369ms 1s71ms 572ms 91 52s98ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 31 01 2 1s201ms 600ms 03 1 486ms 486ms 04 2 1s40ms 520ms 05 2 1s61ms 530ms 06 1 499ms 499ms 07 7 3s886ms 555ms 08 11 6s309ms 573ms 09 10 6s146ms 614ms 10 13 7s573ms 582ms 11 8 4s650ms 581ms 12 3 1s573ms 524ms 13 8 4s221ms 527ms 14 12 7s190ms 599ms 15 5 2s615ms 523ms 16 5 2s967ms 593ms 17 1 674ms 674ms [ User: intelifix - Total duration: 52s98ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 52s98ms - Times executed: 91 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-07-31 09:02:54 Duration: 1s71ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (507, 53, 1);
Date: 2026-07-31 14:13:27 Duration: 857ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 81, 1);
Date: 2026-07-31 08:06:56 Duration: 786ms 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 7 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 31 13 1 0ms 0ms 14 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 6m4s - Times executed: 6 ]
[ User: lenon - Total duration: 472ms - Times executed: 1 ]
[ Application: psql - Total duration: 6m3s - Times executed: 5 ]
[ Application: [unknown] - Total duration: 766ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 16,122 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 22 FATAL entries
- 3543 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,426 Max number of times the same event was reported
- 3,567 Total events found
Rank Times reported Error 1 3,426 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 31 00 57 01 55 02 53 03 54 04 54 05 58 06 57 07 257 08 325 09 374 10 349 11 328 12 158 13 140 14 290 15 250 16 146 17 93 18 56 19 57 20 55 21 57 22 58 23 45 - ERROR: prepared statement "_PLAN000000003A6FA5A0" does not exist
- ERROR: prepared statement "_PLAN00000000411654C0" does not exist
- ERROR: prepared statement "_PLAN000000003A700570" does not exist
Statement: DEALLOCATE "_PLAN000000003A6FA5A0"
Date: 2026-07-31 00:01:14 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000411654C0"
Date: 2026-07-31 00:02:16 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003A700570"
Date: 2026-07-31 00:03:18 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 31 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 1 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-31 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-31 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-31 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 31 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-31 08:00:22 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-31 08:20:07 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-31 08:40:09 Database: brasilia Application: psql User: intelifix Remote: [local]
4 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 31 03 10 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-31 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-31 03:05:01 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-31 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
5 8 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 31 07 2 09 2 11 3 15 1 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(v)
Date: 2026-07-31 07:41:14 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-07-31 07:41:15 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(v)
Date: 2026-07-31 09:25:34 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
6 8 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 31 00 2 04 1 06 1 15 1 17 1 22 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-31 00:02:59 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-31 00:55:00 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-31 04:00:30 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
7 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 31 05 1 09 1 10 2 14 2 - ERROR: syntax error at or near "241764832939" at character 79
- ERROR: syntax error at or near "241683160311" at character 41
- ERROR: syntax error at or near ")" at character 34
Statement: SELECT RS_SERIAL_TEMPORARIO( '241764832939'' ) OR RS_SERIAL_TEMPORARIO_VIVO( '241764832939'' )
Date: 2026-07-31 05:05:31 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241683160311');
Date: 2026-07-31 09:35:14 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(385688,)
Date: 2026-07-31 10:20:04 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
8 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 31 03 4 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-31 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-31 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-31 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 31 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-31 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-31 05:32:13 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-31 05:32:13 Database: contagem Application: psql User: intelifix Remote: [local]
10 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 31 10 4 - ERROR: trailing junk after numeric literal at or near "840112E0B997" at character 32
- ERROR: trailing junk after numeric literal at or near "9c73709db1a3" at character 27
- ERROR: trailing junk after numeric literal at or near "9c73709db1a3" at character 27
Statement: SELECT RS_SERIAL_TEMPORARIO( ''840112E0B997' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''840112E0B997' )
Date: 2026-07-31 10:19:51 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(9c73709db1a3)
Date: 2026-07-31 10:43:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(9c73709db1a3)
Date: 2026-07-31 10:43:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
11 2 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 31 14 2 - ERROR: invalid input syntax for type integer: ""
- ERROR: invalid input syntax for type integer: ""
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"4857544374DCF2B6","barra2":"905E44C77192","barra3":"WIFITWPASCLARO_C77192PPYF8CHV","lote":""}');Date: 2026-07-31 14:53:37 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"4857544374DCF2B6","barra2":"905E44C77192","barra3":"WIFITWPASCLARO_C77192PPYF8CHV","lote":""}');Date: 2026-07-31 14:53:54 Database: contagem Application: [unknown] User: intelifix Remote: [local]
12 1 ERROR: spiexceptions.StringDataRightTruncation: value too long for type character(...)
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 31 09 1 - ERROR: spiexceptions.StringDataRightTruncation: value too long for type character(1)
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"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/Cópia de QR CODE ATUALIZADA (LINK NOVO).xlsm'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-07-31 09:23:58 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 31 08 1 - LOG: process 1862943 still waiting for AccessExclusiveLock on relation 3232052 of database 358220 after 1000.161 ms
Detail: Process holding the lock: 1888461. Wait queue: 1862943.
Statement: DROP TABLE IF EXISTS temp0000287108;Date: 2026-07-31 08:41:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 31 08 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000287108"
Date: 2026-07-31 08:41:44
15 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 31 18 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' 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
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-31 18:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 31 03 1 - LOG: database system was shut down at 2026-07-31 03:05:02 -03
Date: 2026-07-31 03:05:03