pgBadger-
Global information
- Generated on Wed Sep 2 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 44,053 log entries in 12s
- Log start from 2026-09-02 00:00:24 to 2026-09-02 23:49:34
-
Overview
Global Stats
- 371 Number of unique normalized queries
- 6,000 Number of queries
- 8h24m Total query duration
- 2026-09-02 00:02:04 First query
- 2026-09-02 23:43:00 Last query
- 5 queries/s at 2026-09-02 20:08:39 Query peak
- 8h24m Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h24m Execute total duration
- 4,685 Number of events
- 14 Number of unique normalized events
- 4,609 Max number of times the same event was reported
- 0 Number of cancellation
- 434 Total number of automatic vacuums
- 997 Total number of automatic analyzes
- 12 Number temporary file
- 243.76 MiB Max size of temporary file
- 104.21 MiB Average size of temporary file
- 344 Total number of sessions
- 7 sessions at 2026-09-02 02:20:15 Session peak
- 12d21h37m17s Total duration of sessions
- 54m Average duration of sessions
- 17 Average queries per session
- 1m27s Average queries duration per session
- 52m32s Average idle time per session
- 365 Total number of connections
- 6 connections/s at 2026-09-02 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-02 20:08:39 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-02 15:20:58 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-02 20:08:39 Date
Queries duration
Key values
- 8h24m Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 02 00 27 0ms 29s814ms 5s972ms 6s423ms 10s447ms 1m53s 01 38 0ms 5s960ms 1s552ms 6s459ms 9s733ms 11s860ms 02 17 0ms 8s449ms 3s500ms 6s202ms 10s316ms 13s793ms 03 18 0ms 10s753ms 3s645ms 6s612ms 11s803ms 15s963ms 04 18 0ms 11s459ms 4s43ms 9s491ms 11s742ms 16s646ms 05 73 0ms 10m25s 19s495ms 15s872ms 2m58s 10m26s 06 36 0ms 12s250ms 2s329ms 5s368ms 5s908ms 38s712ms 07 236 0ms 14m14s 13s136ms 2m19s 5m34s 14m16s 08 620 150ms 6m39s 3s610ms 1m14s 4m7s 7m3s 09 794 150ms 10m6s 5s162ms 6m20s 8m10s 10m39s 10 670 0ms 8m4s 3s10ms 45s976ms 4m13s 8m8s 11 658 150ms 7m18s 3s336ms 1m12s 4m12s 7m28s 12 204 0ms 5m21s 7s750ms 36s136ms 5m15s 6m 13 332 0ms 5m14s 2s998ms 21s190ms 47s861ms 5m48s 14 548 150ms 6m11s 3s124ms 47s303ms 4m22s 6m21s 15 505 0ms 5m33s 4s37ms 55s27ms 5m37s 6m16s 16 392 0ms 5m32s 3s695ms 38s140ms 4m9s 5m37s 17 239 0ms 5m15s 5s926ms 46s55ms 2m36s 6m4s 18 26 0ms 4m56s 22s471ms 3s388ms 43s545ms 4m56s 19 24 0ms 4m57s 24s263ms 3s414ms 42s742ms 4m57s 20 117 0ms 5m6s 9s737ms 1m2s 1m14s 6m54s 21 38 0ms 5m6s 15s797ms 5s802ms 6s449ms 5m50s 22 30 0ms 4m56s 19s901ms 5s589ms 43s561ms 4m56s 23 340 0ms 1m2s 5s792ms 1m5s 1m8s 1m14s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 02 00 3 0 1s194ms 0ms 0ms 0ms 01 18 0 321ms 175ms 326ms 1s250ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 48 0 347ms 508ms 1s126ms 1s662ms 06 16 0 933ms 0ms 578ms 2s895ms 07 155 0 17s378ms 7s221ms 2m19s 8m32s 08 425 0 3s951ms 21s936ms 51s607ms 6m5s 09 585 0 6s49ms 20s385ms 6m19s 8m31s 10 511 0 3s284ms 13s228ms 29s316ms 6m19s 11 484 0 3s693ms 15s99ms 45s329ms 6m14s 12 140 0 9s983ms 8s613ms 20s276ms 5m21s 13 273 0 3s201ms 7s82ms 14s335ms 3m36s 14 455 0 3s164ms 11s829ms 30s171ms 5m31s 15 396 0 4s185ms 9s559ms 31s368ms 5m43s 16 328 0 3s715ms 8s465ms 13s247ms 5m29s 17 172 0 6s681ms 15s184ms 29s845ms 3m49s 18 8 0 1m9s 0ms 0ms 3m37s 19 6 0 1m32s 0ms 0ms 3m36s 20 15 83 11s338ms 16s163ms 1m2s 3m31s 21 14 0 40s276ms 0ms 0ms 3m31s 22 6 0 1m33s 0ms 0ms 3m40s 23 21 319 5s792ms 1m2s 1m5s 1m14s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 02 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 02 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 5 5.00 0.00% 06 0 1 1.00 0.00% 07 0 12 12.00 0.00% 08 0 22 22.00 0.00% 09 0 27 27.00 0.00% 10 0 16 16.00 0.00% 11 0 18 18.00 0.00% 12 0 9 9.00 0.00% 13 0 10 10.00 0.00% 14 0 13 13.00 0.00% 15 0 10 10.00 0.00% 16 0 7 7.00 0.00% 17 0 7 7.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 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 7 7.00 0.00% Day Hour Count Average / Second Sep 02 00 18 0.01/s 01 16 0.00/s 02 11 0.00/s 03 17 0.00/s 04 7 0.00/s 05 13 0.00/s 06 15 0.00/s 07 13 0.00/s 08 30 0.01/s 09 26 0.01/s 10 15 0.00/s 11 21 0.01/s 12 12 0.00/s 13 20 0.01/s 14 24 0.01/s 15 17 0.00/s 16 21 0.01/s 17 12 0.00/s 18 7 0.00/s 19 11 0.00/s 20 12 0.00/s 21 11 0.00/s 22 8 0.00/s 23 8 0.00/s Day Hour Count Average Duration Average idle time Sep 02 00 8 1h 59m40s 01 15 1h36s 1h32s 02 11 1h17s 1h11s 03 20 20m22s 20m18s 04 7 1h2m41s 1h2m31s 05 8 55m 52m2s 06 11 58m4s 57m56s 07 13 1h2m16s 58m17s 08 15 56m4s 53m35s 09 25 53m38s 50m54s 10 22 59m8s 57m36s 11 17 52m7s 49m57s 12 21 56m40s 55m25s 13 11 59m9s 57m39s 14 23 55m11s 53m56s 15 22 53m31s 51m59s 16 15 58m55s 57m18s 17 18 58m31s 57m12s 18 11 1h7s 59m14s 19 7 1h32s 59m9s 20 12 41m53s 40m18s 21 8 1h6s 58m51s 22 10 1h1m5s 1h5s 23 14 36m53s 34m32s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-09-02 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 365 connections Total
Connections per user
Key values
- intelifix Main User
- 365 connections Total
-
Sessions
Simultaneous sessions
Key values
- 7 sessions Session Peak
- 2026-09-02 02:20:15 Date
Histogram of session times
Key values
- 285 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 344 sessions Total
Sessions per user
Key values
- intelifix Main User
- 344 sessions Total
Sessions per host
Key values
- [local] Main Host
- 344 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,022 buffers Checkpoint Peak
- 2026-09-02 09:04:35 Date
- 270.079 seconds Highest write time
- 0.143 seconds Sync time
Checkpoints Wal files
Key values
- 16 files Wal files usage Peak
- 2026-09-02 09:14:35 Date
Checkpoints distance
Key values
- 528.67 Mo Distance Peak
- 2026-09-02 09:14:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 02 00 21,297 634.926s 0.037s 635.027s 01 2,621 262.916s 0.23s 263.184s 02 3,293 329.974s 0.081s 330.146s 03 1,857 185.229s 0.139s 185.418s 04 2,176 218.237s 0.083s 218.359s 05 12,156 1,216.377s 0.281s 1,216.737s 06 3,411 341.702s 0.068s 341.787s 07 25,824 1,906.049s 0.243s 1,906.377s 08 54,083 3,177.966s 0.517s 3,178.626s 09 84,126 3,238.859s 0.571s 3,239.686s 10 64,191 3,195.83s 0.316s 3,196.383s 11 56,582 3,238.314s 0.586s 3,239.036s 12 42,133 2,358.884s 0.333s 2,359.324s 13 43,403 2,545.889s 0.346s 2,546.301s 14 62,258 3,239.06s 0.496s 3,239.684s 15 73,863 3,239.207s 0.37s 3,239.675s 16 48,432 3,224.635s 0.248s 3,225.021s 17 53,875 2,898.81s 0.251s 2,899.126s 18 2,134 213.816s 0.084s 213.926s 19 35 3.523s 0.019s 3.556s 20 667 287.69s 0.019s 287.718s 21 3,144 314.762s 0.108s 314.904s 22 2,047 205.118s 0.061s 205.285s 23 265 26.589s 0.019s 26.635s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 02 00 0 0 6 491 0.010s 0.006s 01 0 0 1 535 0.064s 0.012s 02 0 0 1 373 0.063s 0.005s 03 0 0 1 343 0.032s 0.008s 04 0 0 0 412 0.046s 0.006s 05 0 0 6 914 0.089s 0.011s 06 0 0 1 80 0.042s 0.007s 07 0 0 18 2,225 0.061s 0.013s 08 0 0 34 6,411 0.061s 0.012s 09 0 0 56 8,328 0.043s 0.012s 10 0 0 29 6,226 0.018s 0.012s 11 0 0 33 6,044 0.063s 0.012s 12 0 0 22 3,956 0.066s 0.012s 13 0 0 15 5,553 0.035s 0.012s 14 0 0 33 7,674 0.061s 0.012s 15 0 0 44 6,065 0.062s 0.012s 16 0 0 29 5,201 0.021s 0.012s 17 0 0 41 4,566 0.030s 0.011s 18 0 0 1 270 0.054s 0.008s 19 0 0 0 11 0.015s 0.004s 20 0 0 1 80 0.007s 0.003s 21 0 0 1 512 0.062s 0.011s 22 0 0 1 408 0.026s 0.013s 23 0 0 0 33 0.005s 0.005s Day Hour Count Avg time (sec) Sep 02 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Sep 02 00 17,722.17 kB 55,166.83 kB 01 1,636.00 kB 31,833.38 kB 02 2,296.60 kB 16,824.40 kB 03 1,480.00 kB 4,022.71 kB 04 2,076.33 kB 3,101.67 kB 05 8,920.00 kB 15,456.10 kB 06 7,352.00 kB 11,874.50 kB 07 27,947.36 kB 44,472.27 kB 08 45,335.08 kB 79,320.42 kB 09 76,855.25 kB 188,827.42 kB 10 40,351.75 kB 102,366.75 kB 11 44,731.83 kB 88,239.00 kB 12 30,196.67 kB 77,484.50 kB 13 20,618.00 kB 46,061.92 kB 14 44,393.33 kB 70,796.42 kB 15 59,652.67 kB 114,300.92 kB 16 40,081.25 kB 83,951.50 kB 17 61,236.64 kB 103,189.09 kB 18 1,547.20 kB 72,220.60 kB 19 108.50 kB 49,608.50 kB 20 8,355.67 kB 40,368.67 kB 21 2,201.57 kB 25,015.57 kB 22 1,393.62 kB 12,370.00 kB 23 184.40 kB 6,561.20 kB -
Temporary Files
Size of temporary files
Key values
- 487.52 MiB Temp Files size Peak
- 2026-09-02 05:32:12 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-09-02 05:32:21 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 02 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 104.21 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 946.95 MiB 72.70 MiB 243.76 MiB 118.37 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-02 05:32:22 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-02 05:32:12 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 303.57 MiB 56.43 MiB 92.86 MiB 75.89 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-02 05:30:47 Duration: 44s999ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-02 05:30:43 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 243.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 243.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 92.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-02 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 92.86 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-02 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 80.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.38 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 72.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-02 05:32:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 61.42 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-02 05:30:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 56.43 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-02 05:30:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.50 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-02 09:07:13 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 4.50 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-02 09:07:13 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (109) Main table analyzed (database rio)
- 997 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 109 rio.pg_catalog.pg_class 55 rio.public.temp0000290354 50 rio.pg_catalog.pg_type 48 rio.public.usuarios 47 contagem.pg_catalog.pg_attribute 42 brasilia.pg_catalog.pg_attribute 35 rio.public.temp0000290346 34 rio.public.temp0000290438 33 rio.pg_catalog.pg_index 33 contagem.public.usuarios 29 rio.pg_catalog.pg_depend 26 rio.public.temp0000290372 24 contagem.pg_catalog.pg_class 20 contagem.public.temp0000227041 17 contagem.pg_catalog.pg_type 17 rio.public.temp0000290464 17 contagem.public.temp0000227013 16 rio.public.temp0000290432 16 rio.public.temp0000290208 14 rio.public.temp0000290352 14 brasilia.pg_catalog.pg_class 14 brasilia.pg_catalog.pg_type 12 rio.public.temp0000290234 12 rio.public.temp0000290232 12 rio.public.temp0000290468 11 contagem.pg_catalog.pg_index 10 brasilia.public.temp0000239398 10 rio.auditor.auditor_2026_09 9 rio.public.temp0000290230 9 rio.public.temp0000290350 9 rio.public.temp0000290026 9 rio.public.temp0000290482 8 rio.public.temp0000290344 8 rio.public.temp0000290228 8 rio.public.temp0000290226 8 contagem.pg_catalog.pg_depend 8 brasilia.public.usuarios 7 rio.public.temp0000290206 7 brasilia.pg_catalog.pg_index 7 brasilia.auditor.auditor_2026_09 6 brasilia.public.temp0000239452 6 rio.public.temp0000290336 5 rio.public.temp0000290480 5 rio.public.temp0000290376 5 brasilia.pg_catalog.pg_depend 5 brasilia.public.temp0000239424 4 rio.public.temp0000290454 4 rio.public.temp0000290362 4 rio.public.tmp_drill_0302 4 rio.public.temp0000290412 4 contagem.auditor.auditor_2026_09 4 rio.public.temp0000290434 3 contagem.public.temp0000227045 3 postgres.pg_catalog.pg_shdepend 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000239394 3 rio.public.temp0000290388 3 rio.public.temp0000290436 3 contagem.pg_catalog.pg_shdepend 3 rio.public.temp0000290396 2 brasilia.public.temp0000239460 2 brasilia.public.temp0000239412 2 rio.public.temp0000290338 2 contagem.public.temp0000227049 2 rio.public.temp0000290404 2 brasilia.public.temp0000239434 2 brasilia.public.temp0000239388 2 rio.pg_catalog.pg_shdepend 2 rio.public.temp0000290448 1 brasilia.public.temp0000239438 1 rio.public.temp0000290444 1 rio.public.temp0000290456 1 rio.public.temp0000290486 1 brasilia.public.temp0000239446 1 rio.public.temp0000290466 1 brasilia.public.temp0000239386 1 contagem.public.nf_entrada 1 brasilia.public.temp0000239390 1 rio.public.temp0000290476 1 rio.public.temp0000290158 1 rio.public.temp0000290374 1 brasilia.public.temp0000239396 1 contagem.public.temp0000227051 1 brasilia.public.temp0000239450 1 brasilia.public.temp0000239420 1 rio.public.temp0000290386 1 brasilia.public.temp0000239428 1 contagem.public.temp0000227037 1 rio.public.temp0000290366 1 rio.public.temp0000290450 1 brasilia.public.temp0000239406 1 rio.public.temp0000290370 1 brasilia.public.temp0000239384 1 Total 997 Vacuums per table
Key values
- pg_catalog.pg_attribute (44) Main table vacuumed on database rio
- 434 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 44 36 0 0 0 0 0 21,905 5,526 8,204,041 341 8,370 rio.public.temp0000290346 33 0 0 0 0 0 0 2,465 466 640,681 0 0 contagem.public.usuarios 29 0 0 0 0 0 0 130 94 50,186 1 1 rio.pg_catalog.pg_class 28 23 0 0 0 0 0 4,832 1,344 2,165,071 79 332 rio.public.temp0000290354 26 0 0 0 0 0 0 23,266 3,640 5,960,821 0 0 rio.pg_catalog.pg_type 19 19 0 0 0 0 0 2,091 582 809,033 74 260 rio.public.temp0000290432 16 0 0 0 0 0 0 23,107 1,830 3,656,678 0 0 contagem.pg_catalog.pg_attribute 14 14 0 0 0 0 0 8,704 2,595 4,845,726 21 427 rio.pg_catalog.pg_index 13 13 0 0 0 0 0 786 181 231,725 27 71 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 3,937 1,207 1,862,632 77 637 rio.public.temp0000290438 12 0 0 0 0 0 0 3,301 128 331,258 0 0 rio.public.temp0000290468 11 0 0 0 0 0 0 5,678 46 343,546 0 0 rio.public.temp0000290234 11 0 0 0 0 0 0 1,041 63 73,504 0 0 rio.public.temp0000290026 9 0 0 0 0 0 0 648 367 594,001 0 0 brasilia.pg_catalog.pg_attribute 9 9 0 0 0 0 0 4,155 1,232 1,901,694 44 1,145 rio.public.usuarios 8 4 0 0 0 0 0 136 48 109,189 7 13 rio.public.temp0000290230 8 0 0 0 0 0 0 587 46 41,499 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,484 2,777 10,931,942 1,664 7,667 rio.public.temp0000290482 8 0 0 0 0 0 0 14,176 32 841,208 0 0 rio.public.temp0000290228 8 0 0 0 0 0 0 7,096 29 425,066 0 0 rio.public.temp0000290206 7 0 0 0 0 0 0 691 39 48,480 0 0 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 678 233 382,082 5 10 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 1,118 317 466,187 14 36 rio.public.temp0000290372 6 0 0 0 0 0 0 365 34 26,684 0 0 rio.auditor.auditor_2026_09 6 1 0 0 0 0 0 126,296 56,405 75,919,718 32,927 675,510 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,955 532 2,652,635 151 410 brasilia.auditor.auditor_2026_09 4 0 0 0 0 0 0 14,398 8,104 9,996,466 2,719 49,755 rio.public.temp0000290412 4 0 0 0 0 0 0 442 22 29,544 0 0 rio.public.tmp_drill_0302 4 4 0 0 0 0 0 2,412 12 399,793 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 270 92 90,123 3 4 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,115 409 725,563 4 24 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 497 112 192,749 10 19 brasilia.pg_catalog.pg_class 3 3 0 0 0 0 0 521 209 321,435 8 36 contagem.public.temp0000227045 3 0 0 0 0 0 0 339 18 22,905 0 0 contagem.auditor.auditor_2026_09 3 0 0 0 0 0 0 17,841 10,284 12,245,666 3,163 54,364 brasilia.pg_catalog.pg_type 3 3 0 0 0 0 0 169 76 117,062 5 22 brasilia.public.temp0000239394 3 0 0 0 0 0 0 504 11 31,480 0 0 rio.public.temp0000290388 3 0 0 0 0 0 0 222 81 123,502 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 92 33 28,281 7 15 contagem.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 316 103 180,097 20 38 rio.public.temp0000290226 2 0 0 0 0 0 0 3,544 1,776 2,494,470 0 0 brasilia.public.temp0000239460 2 0 0 0 0 0 0 500 254 414,528 0 0 brasilia.pg_catalog.pg_depend 2 2 0 0 0 0 0 555 227 294,945 12 96 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,042 1,196 3,705,071 1,083 7,311 rio.public.temp0000290436 2 0 0 0 0 0 0 217 113 187,244 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 283 72 249,525 21 44 rio.public.temp0000290404 2 0 0 0 0 0 0 128 12 9,252 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,465 772 3,127,653 630 4,231 rio.public.temp0000290396 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.public.temp0000290480 1 0 0 0 0 0 0 73 6 5,197 0 0 rio.public.temp0000290454 1 0 0 0 0 0 0 66 4 4,497 0 0 rio.public.temp0000290158 1 0 0 0 0 0 0 64 6 4,624 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 145 63 176,324 12 34 rio.public.temp0000290466 1 0 0 0 0 0 0 66 4 4,497 0 0 brasilia.public.temp0000239446 1 0 0 0 0 0 0 250 4 15,353 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 151 72 128,219 6 6 brasilia.public.temp0000239386 1 0 0 0 0 0 0 251 4 15,521 0 0 brasilia.public.temp0000239428 1 0 0 0 0 0 0 250 4 15,353 0 0 rio.public.temp0000290448 1 0 0 0 0 0 0 1,772 4 105,151 0 0 Total 434 190 0 0 0 0 0 322,596 103,958 158,978,925 43,135 810,888 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (21.23) 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.9 rio.public.temp0000290346 0 0 0.24 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 0.78 rio.public.temp0000290354 0 0 1.09 rio.pg_catalog.pg_type 0 0 0.4 rio.public.temp0000290432 0 0 0.65 contagem.pg_catalog.pg_attribute 0 0 1.74 rio.pg_catalog.pg_index 0 0 0.17 rio.pg_catalog.pg_depend 0 0 0.83 rio.public.temp0000290438 0 0 0.12 rio.public.temp0000290468 0 0 0.29 rio.public.temp0000290234 0 0 0.06 rio.public.temp0000290026 0 0 0.05 brasilia.pg_catalog.pg_attribute 0 0 1 rio.public.usuarios 0 0 0 rio.public.temp0000290230 0 0 0.05 rio.pg_catalog.pg_statistic 0 0 1.59 rio.public.temp0000290482 0 0 0.33 rio.public.temp0000290228 0 0 0.38 rio.public.temp0000290206 0 0 0.06 contagem.pg_catalog.pg_type 0 0 0.32 contagem.pg_catalog.pg_class 0 0 1.03 rio.public.temp0000290372 0 0 0.05 rio.auditor.auditor_2026_09 0 0 21.23 rio.pg_toast.pg_toast_2619 0 0 0.26 brasilia.auditor.auditor_2026_09 0 0 2.66 rio.public.temp0000290412 0 0 0.02 rio.public.tmp_drill_0302 0 0 0.06 contagem.pg_catalog.pg_index 0 0 0.27 contagem.pg_catalog.pg_depend 0 0 0.54 postgres.pg_catalog.pg_shdepend 0 0 0.51 brasilia.pg_catalog.pg_class 0 0 0.52 contagem.public.temp0000227045 0 0 0.03 contagem.auditor.auditor_2026_09 0 0 3.87 brasilia.pg_catalog.pg_type 0 0 0.31 brasilia.public.temp0000239394 0 0 0 rio.public.temp0000290388 0 0 0.02 brasilia.pg_catalog.pg_index 0 0 0.09 contagem.pg_catalog.pg_shdepend 0 0 0.19 rio.public.temp0000290226 0 0 0.11 brasilia.public.temp0000239460 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.34 contagem.pg_catalog.pg_statistic 0 0 0.22 rio.public.temp0000290436 0 0 0.07 brasilia.pg_toast.pg_toast_2619 0 0 0.02 rio.public.temp0000290404 0 0 0.02 brasilia.pg_catalog.pg_statistic 0 0 0.38 rio.public.temp0000290396 0 0 0.1 rio.public.temp0000290480 0 0 0.01 rio.public.temp0000290454 0 0 0 rio.public.temp0000290158 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000290466 0 0 0 brasilia.public.temp0000239446 0 0 0 contagem.public.nf_entrada 0 0 0.14 brasilia.public.temp0000239386 0 0 0.01 brasilia.public.temp0000239428 0 0 0 rio.public.temp0000290448 0 0 0.04 Total 0 0 46.19 Tuples removed per table
Key values
- pg_catalog.pg_attribute (168038) Main table with removed tuples on database rio
- 383507 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 44 36 168,038 1,148,454 69,730 302 28,608 contagem.pg_catalog.pg_attribute 14 14 56,655 335,593 0 211 7,639 rio.public.tmp_drill_0302 4 4 34,928 36,987 0 0 930 brasilia.pg_catalog.pg_attribute 9 9 29,349 199,631 575 43 4,850 rio.auditor.auditor_2026_09 6 1 25,329 7,874,645 0 0 371,113 rio.pg_catalog.pg_statistic 8 8 14,399 66,599 157 0 10,288 rio.pg_catalog.pg_depend 13 13 9,351 248,605 156 0 2,379 rio.pg_catalog.pg_type 19 19 8,792 43,621 168 30 1,381 contagem.pg_catalog.pg_statistic 2 2 5,126 14,785 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 4,912 15,364 0 0 2,144 rio.pg_catalog.pg_class 28 23 4,761 122,498 7,273 58 3,988 rio.pg_catalog.pg_index 13 13 3,512 25,009 39 4 725 postgres.pg_catalog.pg_shdepend 3 3 2,981 40,735 23 0 375 contagem.pg_catalog.pg_shdepend 2 2 2,468 27,638 423 0 250 contagem.pg_catalog.pg_type 6 6 2,299 13,502 0 28 396 contagem.public.usuarios 29 0 1,768 696 0 0 58 contagem.pg_catalog.pg_depend 3 3 1,724 55,116 0 44 541 brasilia.pg_catalog.pg_depend 2 2 1,529 36,387 0 0 344 rio.pg_toast.pg_toast_2619 4 4 1,183 2,547 0 0 1,116 contagem.pg_catalog.pg_index 4 4 1,170 7,592 0 28 209 contagem.pg_catalog.pg_class 6 6 726 21,603 0 48 772 brasilia.pg_catalog.pg_class 3 3 594 12,806 0 0 390 rio.public.usuarios 8 4 474 4,922 850 0 168 brasilia.auditor.auditor_2026_09 4 0 346 973,606 0 0 46,317 brasilia.pg_catalog.pg_index 2 2 261 3,765 0 5 103 contagem.public.nf_entrada 1 1 252 1,049 0 0 79 brasilia.pg_catalog.pg_type 3 3 236 6,667 36 0 171 brasilia.pg_toast.pg_toast_2619 2 2 230 276 0 0 140 contagem.pg_toast.pg_toast_2619 1 1 114 116 0 32 31 rio.public.temp0000290480 1 0 0 1,091 0 63 65 rio.public.temp0000290230 8 0 0 31,885 0 268 692 rio.public.temp0000290454 1 0 0 1,040 0 0 64 rio.public.temp0000290432 16 0 0 376,332 0 0 26,944 rio.public.temp0000290158 1 0 0 2,517 0 8 56 rio.public.temp0000290026 9 0 0 43,179 0 254 962 rio.public.temp0000290466 1 0 0 1,032 0 0 64 brasilia.public.temp0000239446 1 0 0 3,278 0 0 256 rio.public.temp0000290354 26 0 0 541,800 0 268 38,004 brasilia.public.temp0000239386 1 0 0 3,278 0 0 256 contagem.public.temp0000227045 3 0 0 4,070 0 69 315 rio.public.temp0000290226 2 0 0 50,049 0 0 3,584 rio.public.temp0000290468 11 0 0 155,552 0 126 11,074 brasilia.public.temp0000239428 1 0 0 3,278 0 0 256 brasilia.public.temp0000239460 2 0 0 6,556 0 0 512 rio.public.temp0000290206 7 0 0 36,192 0 279 809 contagem.auditor.auditor_2026_09 3 0 0 1,082,198 0 0 53,705 rio.public.temp0000290436 2 0 0 9,049 0 55 201 rio.public.temp0000290438 12 0 0 88,394 0 272 3,248 rio.public.temp0000290482 8 0 0 200,203 0 0 14,336 rio.public.temp0000290448 1 0 0 25,023 0 0 1,792 rio.public.temp0000290412 4 0 0 18,678 0 98 414 rio.public.temp0000290372 6 0 0 20,746 0 307 461 brasilia.public.temp0000239394 3 0 0 9,834 0 0 768 rio.public.temp0000290388 3 0 0 9,143 0 54 202 rio.public.temp0000290404 2 0 0 5,036 0 16 112 rio.public.temp0000290346 33 0 0 128,134 0 769 2,847 rio.public.temp0000290228 8 0 0 200,003 0 0 14,336 rio.public.temp0000290396 2 0 0 50,006 0 0 3,584 rio.public.temp0000290234 11 0 0 50,430 0 285 1,123 Total 434 190 383,507 14,498,820 79,430 4,024 668,569 Pages removed per table
Key values
- public.temp0000290346 (769) Main table with removed pages on database rio
- 4024 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000290346 33 0 0 769 rio.public.temp0000290372 6 0 0 307 rio.pg_catalog.pg_attribute 44 36 168038 302 rio.public.temp0000290234 11 0 0 285 rio.public.temp0000290206 7 0 0 279 rio.public.temp0000290438 12 0 0 272 rio.public.temp0000290230 8 0 0 268 rio.public.temp0000290354 26 0 0 268 rio.public.temp0000290026 9 0 0 254 contagem.pg_catalog.pg_attribute 14 14 56655 211 rio.public.temp0000290468 11 0 0 126 rio.public.temp0000290412 4 0 0 98 contagem.public.temp0000227045 3 0 0 69 rio.public.temp0000290480 1 0 0 63 rio.pg_catalog.pg_class 28 23 4761 58 rio.public.temp0000290436 2 0 0 55 rio.public.temp0000290388 3 0 0 54 contagem.pg_catalog.pg_class 6 6 726 48 contagem.pg_catalog.pg_depend 3 3 1724 44 brasilia.pg_catalog.pg_attribute 9 9 29349 43 contagem.pg_toast.pg_toast_2619 1 1 114 32 rio.pg_catalog.pg_type 19 19 8792 30 contagem.pg_catalog.pg_type 6 6 2299 28 contagem.pg_catalog.pg_index 4 4 1170 28 rio.public.temp0000290404 2 0 0 16 rio.public.temp0000290158 1 0 0 8 brasilia.pg_catalog.pg_index 2 2 261 5 rio.pg_catalog.pg_index 13 13 3512 4 rio.public.usuarios 8 4 474 0 rio.public.temp0000290454 1 0 0 0 postgres.pg_catalog.pg_shdepend 3 3 2981 0 rio.public.temp0000290432 16 0 0 0 brasilia.pg_catalog.pg_class 3 3 594 0 rio.pg_catalog.pg_statistic 8 8 14399 0 rio.public.temp0000290466 1 0 0 0 brasilia.public.temp0000239446 1 0 0 0 contagem.public.nf_entrada 1 1 252 0 rio.pg_catalog.pg_depend 13 13 9351 0 contagem.public.usuarios 29 0 1768 0 brasilia.public.temp0000239386 1 0 0 0 contagem.pg_catalog.pg_shdepend 2 2 2468 0 rio.public.temp0000290226 2 0 0 0 brasilia.public.temp0000239428 1 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1183 0 brasilia.public.temp0000239460 2 0 0 0 brasilia.pg_catalog.pg_depend 2 2 1529 0 contagem.auditor.auditor_2026_09 3 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5126 0 brasilia.auditor.auditor_2026_09 4 0 346 0 brasilia.pg_toast.pg_toast_2619 2 2 230 0 rio.public.temp0000290482 8 0 0 0 rio.public.temp0000290448 1 0 0 0 brasilia.pg_catalog.pg_type 3 3 236 0 rio.public.tmp_drill_0302 4 4 34928 0 brasilia.public.temp0000239394 3 0 0 0 rio.auditor.auditor_2026_09 6 1 25329 0 rio.public.temp0000290228 8 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 4912 0 rio.public.temp0000290396 2 0 0 0 Total 434 190 383,507 4,024 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 02 00 2 2 01 0 3 02 0 0 03 0 0 04 0 0 05 7 5 06 0 0 07 11 25 08 46 115 09 77 141 10 38 100 11 42 100 12 17 43 13 19 69 14 38 117 15 46 101 16 37 93 17 53 77 18 0 0 19 0 0 20 0 0 21 1 6 22 0 0 23 0 0 - 4.50 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 1 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 7s626ms 7s626ms 7s626ms 7s626ms select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029322, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 07:25:06 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029332, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:06:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029337, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:59:38 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 7s626ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/Exclusão ATOP 1.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-09-02 08:56:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,079 Total read queries
- 1,376 Total write queries
Queries by database
Key values
- rio Main database
- 4,158 Requests
- 6h27m24s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,824 Requests
User Request type Count Duration etiquetas Total 67 19s875ms select 67 19s875ms intelifix Total 5,824 8h22m51s copy to 402 41m43s ddl 974 43m11s others 545 52m51s select 3,903 6h5m4s lenon Total 109 49s365ms select 109 49s365ms Duration by user
Key values
- 8h22m51s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 67 19s875ms select 67 19s875ms intelifix Total 5,824 8h22m51s copy to 402 41m43s ddl 974 43m11s others 545 52m51s select 3,903 6h5m4s lenon Total 109 49s365ms select 109 49s365ms Queries by host
Key values
- [local] Main host
- 6,000 Requests
- 8h24m ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,854 Requests
- 4h10m9s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-02 04:25:13 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,862 100-500ms duration
Slowest individual queries
Rank Duration Query 1 14m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-02 07:19:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m25s analyze verbose;[ Date: 2026-09-02 05:10:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-02 09:15:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029322, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 07:25:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 8m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029332, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 09:06:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 8m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-02 10:13:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-02 11:12:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029337, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 09:59:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 6m40s analyze verbose;[ Date: 2026-09-02 05:17:08 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
10 6m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-02 08:11:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 6m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029339, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 10:29:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 6m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029336, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 09:16:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 6m11s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029350, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 14:42:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029333, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');[ Date: 2026-09-02 09:07:05 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029326, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 08:15:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029341, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 11:08:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m42s SELECT * FROM RS_SMART_FISCAL_SAIDA ();[ Date: 2026-09-02 09:24:24 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
18 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029352, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 15:16:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029355, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 15:35:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029324, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-02 07:58:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h59m3s 284 150ms 8m28s 25s153ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 02 06 4 1s649ms 412ms 07 32 19m38s 36s820ms 08 32 8m27s 15s862ms 09 27 28m27s 1m3s 10 24 7m7s 17s818ms 11 28 10m9s 21s757ms 12 10 11m30s 1m9s 13 14 25s845ms 1s846ms 14 36 7m41s 12s814ms 15 22 12m8s 33s122ms 16 25 6m17s 15s114ms 17 30 7m7s 14s236ms [ User: intelifix - Total duration: 1h59m3s - Times executed: 284 ]
[ Application: [unknown] - Total duration: 1h59m3s - Times executed: 284 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029322, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 07:25:06 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029332, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:06:38 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029337, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:59:38 Duration: 7m Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h50m32s 48 1s331ms 14m14s 2m18s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 02 07 3 15m21s 5m7s 08 3 7m8s 2m22s 09 3 11m22s 3m47s 10 3 8m34s 2m51s 11 3 7m42s 2m34s 12 3 5m33s 1m51s 13 3 5m30s 1m50s 14 3 5m45s 1m55s 15 3 5m46s 1m55s 16 3 5m49s 1m56s 17 3 5m33s 1m51s 18 3 5m12s 1m44s 19 3 5m12s 1m44s 20 3 5m23s 1m47s 21 3 5m22s 1m47s 22 3 5m11s 1m43s [ User: intelifix - Total duration: 1h50m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h50m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-02 07:19:15 Duration: 14m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-02 09:15:07 Duration: 10m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-02 10:13:05 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
3 1h15m56s 48 295ms 5m42s 1m34s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 02 07 3 7m12s 2m24s 08 3 4m39s 1m33s 09 3 8m15s 2m45s 10 3 4m55s 1m38s 11 3 4m42s 1m34s 12 3 4m11s 1m23s 13 3 4m6s 1m22s 14 3 4m33s 1m31s 15 3 4m20s 1m26s 16 3 4m23s 1m27s 17 3 4m13s 1m24s 18 3 4m4s 1m21s 19 3 4m4s 1m21s 20 3 4m3s 1m21s 21 3 3m59s 1m19s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h15m56s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m56s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-02 09:24:24 Duration: 5m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-02 07:27:18 Duration: 4m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-02 08:16:47 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
4 25m32s 1,467 150ms 10s822ms 1s44ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 02 07 5 2s603ms 520ms 08 119 2m43s 1s375ms 09 199 4m20s 1s309ms 10 190 3m38s 1s151ms 11 152 3m16s 1s293ms 12 63 57s825ms 917ms 13 101 1m25s 841ms 14 230 3m20s 871ms 15 170 2m16s 803ms 16 163 2m27s 901ms 17 75 1m2s 839ms [ User: intelifix - Total duration: 25m32s - Times executed: 1467 ]
[ Application: [unknown] - Total duration: 25m32s - Times executed: 1467 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (283560, 450, '11824385850058501215,E820E2B2B236,942CB3EF63FE,8C444FA3F248,942CB374E6CF,E820E206A4A7,942CB3EBCA74,8C444FEF40A6,E820E20516B8,942CB3AB98DB,90F3055CBE80,8C444FC92715,8C444F75940E,E820E29295BB,E820E29016CA,E820E25BF56C,8C444FA2FBF1,90F3055C5541,E820E24E55C8,E820E2B33B34,942CB3D4C194,8C444F596163,942CB3CA2364,E820E25D4C8F,942CB3998356,8C444FCA5702,8C444FCB8218,942CB3B36444,942CB3E3331D,E820E2F1702F,E820E2EF5456,8C444F6757D1', '',039,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-02 15:21:06 Duration: 10s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55197, 406, '215768785861', '',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-09-02 08:35:15 Duration: 7s600ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (283685, 404, 'F200012013BBD5A,84011297B57C$F200012301B55F8,1834AF60DCFB$F200010323B8B7C,743AEFDB4C61$F200011244B2E7A,8401122AE6CA$F200011168B4C20,9877E7BDB1C7$F200011116BBFE5,9877E77ED8FC$F200012063B7FD1,840112DAC557$F200011057E7C90,9877E74E0ED5$F200012353B4A95,1834AF63E2CF$F200011119B4D2A,9877E7B840A4$F200011242B1281,8401122A91F8$F200012300B3175,1834AF60A9A8$F200012186B7397,1834AF244A3E$F200010281B00BA,743AEFAC6C85$F200012126B491E,840112E9D9A3$F200010288BEB3A,743AEFAE68EC$F200011174B762A,9877E7BF2BF1$F200011116B1140,9877E77E8C96$F200011131B1313,9877E7B99956$F200013248B399F,1834AF9BCA31$F200011355B6457,8401129508CC$F200012060B1D63,840112C24371$F200011102B1A01,9877E77B5854$F200011067B72C1,9877E7485DAF$F200011329BBB22,84011283F420$F200011053B4CCF,9877E74CB042$F2000101541C23B,743AEF34BD01$F2000101791036E,743AEF600611$F200010284B79D6,743AEFAD882F$F200010248B97CF,743AEF965648$F20001016211E80,743AEF5CDF12$F200010232B0D03,743AEF72B871$F200010349B1EFF,9877E7031967$F200011251B3EA4,84011237659D$F200012189B11B2,1834AF24C7FF$F200010304B0594,743AEFC5E7CA$F20001020517098,743AEF772330$F200012185B30AD,840112ED6733$F200011057EDC70,9877E74E38C7', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-02 09:19:31 Duration: 6s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 20m4s 3 2m58s 10m25s 6m41s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 02 05 3 20m4s 6m41s [ User: intelifix - Total duration: 20m4s - Times executed: 3 ]
[ Application: psql - Total duration: 20m4s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-02 05:10:27 Duration: 10m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-02 05:17:08 Duration: 6m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-02 05:20:06 Duration: 2m58s Database: contagem User: intelifix Remote: [local] Application: psql
6 12m42s 58 9s908ms 34s861ms 13s141ms create table temp0000290354 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 02 07 10 1m47s 10s767ms 08 12 2m43s 13s645ms 09 9 2m23s 15s966ms 10 6 1m24s 14s94ms 11 9 2m3s 13s775ms 12 6 1m6s 11s94ms 14 6 1m11s 11s993ms [ User: intelifix - Total duration: 12m42s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 12m42s - Times executed: 58 ]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 09:51:50 Duration: 34s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 08:19:01 Duration: 31s168ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 11:20:34 Duration: 23s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 12m41s 160 175ms 29s814ms 4s762ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 02 00 6 45s519ms 7s586ms 01 6 19s436ms 3s239ms 02 5 25s197ms 5s39ms 03 5 31s450ms 6s290ms 04 6 39s635ms 6s605ms 05 5 26s402ms 5s280ms 07 9 58s324ms 6s480ms 08 12 1m4s 5s333ms 09 12 1m21s 6s781ms 10 12 1m28s 7s402ms 11 12 1m22s 6s888ms 12 12 41s149ms 3s429ms 13 8 15s566ms 1s945ms 14 12 47s115ms 3s926ms 15 11 41s830ms 3s802ms 16 10 26s41ms 2s604ms 17 6 3s898ms 649ms 21 5 11s963ms 2s392ms 22 6 11s580ms 1s930ms [ User: intelifix - Total duration: 12m41s - Times executed: 160 ]
[ Application: psql - Total duration: 12m41s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 00:05:31 Duration: 29s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 11:35:19 Duration: 18s508ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 09:55:20 Duration: 18s280ms Database: rio User: intelifix Remote: [local] Application: psql
8 11m47s 276 188ms 21s794ms 2s564ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 02 00 12 54s753ms 4s562ms 01 12 31s917ms 2s659ms 02 12 34s318ms 2s859ms 03 12 33s375ms 2s781ms 04 12 33s139ms 2s761ms 05 12 35s490ms 2s957ms 06 12 33s863ms 2s821ms 07 12 47s869ms 3s989ms 08 12 36s127ms 3s10ms 09 12 48s315ms 4s26ms 10 12 38s255ms 3s187ms 11 12 35s461ms 2s955ms 12 12 26s649ms 2s220ms 13 12 26s362ms 2s196ms 14 12 27s906ms 2s325ms 15 12 20s636ms 1s719ms 16 12 20s427ms 1s702ms 17 12 20s545ms 1s712ms 18 12 20s317ms 1s693ms 19 12 20s223ms 1s685ms 20 12 22s638ms 1s886ms 21 12 19s635ms 1s636ms 22 12 19s698ms 1s641ms [ User: intelifix - Total duration: 11m47s - Times executed: 276 ]
[ Application: psql - Total duration: 11m47s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 00:05:53 Duration: 21s794ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 07:25:34 Duration: 16s721ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 09:15:24 Duration: 13s14ms Database: rio User: intelifix Remote: [local] Application: psql
9 10m21s 828 150ms 12s238ms 750ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 02 07 5 6s408ms 1s281ms 08 100 1m23s 839ms 09 129 2m11s 1s17ms 10 132 1m51s 843ms 11 120 1m47s 897ms 12 16 10s956ms 684ms 13 75 44s487ms 593ms 14 96 49s691ms 517ms 15 106 49s667ms 468ms 16 47 24s848ms 528ms 17 2 1s22ms 511ms [ User: intelifix - Total duration: 10m21s - Times executed: 828 ]
[ Application: [unknown] - Total duration: 10m21s - Times executed: 828 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "145", "itens" : "229804555762,229802868808,229817853839,229725287992,229819926566,229804439612,229789694155,229844685268,229850027192,229820238089,229805168909,229770678607,229819980815,229772758103,229903896871", "usuario" : "414", "caixa" : "2726298", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 08:19:42 Duration: 12s238ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "320", "itens" : "230048863545,241617506484,230047878790,241601002629,241596684654,230048041737,241635512832,241602560223,241619855759,241635998591,241607024350,241615892242,241609971013,241602562041,241602542443,230049244345,230047919704,241615868906,241610107187,241616058497,241629863145,241604996677,241596105271,241607921722,241607798803,241607787791,241599262942,230049152440,241602893240,241608844146,241598105163,241630944855,241628272238", "usuario" : "414", "caixa" : "1298444", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 09:46:30 Duration: 10s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "305", "itens" : "229951758691,230013121011,230043201332,229998710009,229952200105,230015633961,229951895473,230015660608,229951701313,229951551422,230030813860", "usuario" : "414", "caixa" : "1297801", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 15:33:40 Duration: 8s649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 5m21s 44 156ms 1m39s 7s311ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 02 07 4 3s551ms 887ms 08 8 1m14s 9s332ms 09 5 1m51s 22s280ms 10 2 1s425ms 712ms 11 4 13s873ms 3s468ms 12 2 1s154ms 577ms 13 1 28s229ms 28s229ms 14 3 10s189ms 3s396ms 15 6 59s242ms 9s873ms 16 3 2s102ms 700ms 17 6 15s869ms 2s644ms [ User: intelifix - Total duration: 5m21s - Times executed: 44 ]
[ Application: psql - Total duration: 5m21s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029334);
Date: 2026-09-02 09:07:15 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029354);
Date: 2026-09-02 15:30:23 Duration: 57s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029330);
Date: 2026-09-02 08:48:49 Duration: 46s420ms Database: rio User: intelifix Remote: [local] Application: psql
11 5m13s 66 1s287ms 19s886ms 4s747ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 02 07 2 24s442ms 12s221ms 08 3 13s148ms 4s382ms 09 3 18s16ms 6s5ms 10 9 38s671ms 4s296ms 11 8 41s259ms 5s157ms 12 5 17s43ms 3s408ms 13 17 1m12s 4s282ms 14 8 29s30ms 3s628ms 15 5 18s823ms 3s764ms 16 2 13s315ms 6s657ms 17 4 26s811ms 6s702ms [ User: intelifix - Total duration: 5m13s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 5m13s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0476, '', '', 0, 6, '2026-09-01');
Date: 2026-09-02 07:26:16 Duration: 19s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0302, '', '', 0, 6, '2026-09-02');
Date: 2026-09-02 09:35:30 Duration: 10s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-02 12:33:34 Duration: 10s340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m12s 27 753ms 58s528ms 11s573ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 02 07 3 1m7s 22s567ms 08 5 1m4s 12s980ms 09 4 43s194ms 10s798ms 10 1 13s707ms 13s707ms 11 1 6s942ms 6s942ms 12 2 16s850ms 8s425ms 13 1 13s629ms 13s629ms 14 3 40s160ms 13s386ms 15 3 33s692ms 11s230ms 16 2 9s544ms 4s772ms 17 2 2s153ms 1s76ms [ User: intelifix - Total duration: 5m12s - Times executed: 27 ]
[ Application: psql - Total duration: 5m12s - Times executed: 27 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029322);
Date: 2026-09-02 07:16:59 Duration: 58s528ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029332);
Date: 2026-09-02 08:58:16 Duration: 30s39ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029354);
Date: 2026-09-02 15:30:48 Duration: 25s539ms Database: rio User: intelifix Remote: [local] Application: psql
13 3m46s 20 10s205ms 15s148ms 11s318ms create table temp0000290432 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 02 11 3 34s227ms 11s409ms 12 1 10s466ms 10s466ms 13 2 25s697ms 12s848ms 14 2 23s337ms 11s668ms 15 5 56s301ms 11s260ms 16 2 21s17ms 10s508ms 17 5 55s312ms 11s62ms [ User: intelifix - Total duration: 3m46s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m46s - Times executed: 20 ]
-
CREATE TABLE temp0000290432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 13:41:53 Duration: 15s148ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:12:06 Duration: 12s915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 11:52:19 Duration: 12s185ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m41s 20 10s402ms 12s192ms 11s65ms create table temp0000290468 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 02 15 15 2m44s 10s966ms 16 5 56s823ms 11s364ms [ User: intelifix - Total duration: 3m41s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m41s - Times executed: 20 ]
-
CREATE TABLE temp0000290468 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 16:01:17 Duration: 12s192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290468 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 15:30:02 Duration: 11s680ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290468 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 16:01:01 Duration: 11s621ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m7s 41 1s817ms 38s379ms 4s580ms create table temp0000290354 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 02 07 2 40s628ms 20s314ms 08 16 37s44ms 2s315ms 09 5 46s279ms 9s255ms 10 4 21s896ms 5s474ms 11 14 41s939ms 2s995ms [ User: intelifix - Total duration: 3m7s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 41 ]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 07:26:29 Duration: 38s379ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 09:32:06 Duration: 35s261ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 10:31:15 Duration: 13s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m16s 33 593ms 17s746ms 4s144ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 02 08 1 4s564ms 4s564ms 09 1 13s742ms 13s742ms 10 2 27s919ms 13s959ms 11 2 21s213ms 10s606ms 12 3 9s36ms 3s12ms 13 1 849ms 849ms 14 3 17s5ms 5s668ms 15 2 16s699ms 8s349ms 16 2 6s770ms 3s385ms 17 3 7s769ms 2s589ms 18 2 1s738ms 869ms 19 3 2s548ms 849ms 20 3 2s883ms 961ms 21 3 2s498ms 832ms 22 2 1s520ms 760ms [ User: intelifix - Total duration: 2m16s - Times executed: 33 ]
[ Application: psql - Total duration: 2m16s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-02 10:20:19 Duration: 17s746ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-02 11:40:15 Duration: 14s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-02 09:20:15 Duration: 13s742ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m15s 4 3s872ms 1m4s 33s768ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 02 20 2 1m8s 34s155ms 23 2 1m6s 33s381ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-02 20:08:38 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-02 23:16:38 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-02 20:10:36 Duration: 4s155ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2m9s 12 10s196ms 11s179ms 10s754ms create table temp0000290482 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 02 17 12 2m9s 10s754ms [ User: intelifix - Total duration: 2m9s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 12 ]
-
CREATE TABLE temp0000290482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:42:29 Duration: 11s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:37:59 Duration: 11s121ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:45:23 Duration: 11s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m8s 57 560ms 18s21ms 2s259ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 02 08 5 11s422ms 2s284ms 09 5 32s92ms 6s418ms 10 4 20s792ms 5s198ms 11 4 9s139ms 2s284ms 12 3 2s580ms 860ms 13 5 16s856ms 3s371ms 14 3 2s339ms 779ms 15 4 6s161ms 1s540ms 16 4 10s856ms 2s714ms 17 3 2s662ms 887ms 18 4 2s926ms 731ms 19 3 2s371ms 790ms 20 3 2s291ms 763ms 21 3 2s172ms 724ms 22 4 4s143ms 1s35ms [ User: intelifix - Total duration: 2m8s - Times executed: 57 ]
[ Application: psql - Total duration: 2m8s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 09:40:19 Duration: 18s21ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 10:00:18 Duration: 17s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 09:00:13 Duration: 11s570ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m48s 112 150ms 5s748ms 971ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 02 06 7 9s494ms 1s356ms 07 34 33s334ms 980ms 08 10 11s802ms 1s180ms 09 11 9s531ms 866ms 10 15 12s278ms 818ms 11 8 10s789ms 1s348ms 13 8 10s378ms 1s297ms 14 11 7s512ms 682ms 15 1 391ms 391ms 16 7 3s238ms 462ms [ User: intelifix - Total duration: 1m48s - Times executed: 112 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 112 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283073) LIMIT 1;
Date: 2026-09-02 07:36:40 Duration: 5s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283370) LIMIT 1;
Date: 2026-09-02 06:54:25 Duration: 3s999ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283074) LIMIT 1;
Date: 2026-09-02 07:35:14 Duration: 3s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,467 25m32s 150ms 10s822ms 1s44ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 02 07 5 2s603ms 520ms 08 119 2m43s 1s375ms 09 199 4m20s 1s309ms 10 190 3m38s 1s151ms 11 152 3m16s 1s293ms 12 63 57s825ms 917ms 13 101 1m25s 841ms 14 230 3m20s 871ms 15 170 2m16s 803ms 16 163 2m27s 901ms 17 75 1m2s 839ms [ User: intelifix - Total duration: 25m32s - Times executed: 1467 ]
[ Application: [unknown] - Total duration: 25m32s - Times executed: 1467 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (283560, 450, '11824385850058501215,E820E2B2B236,942CB3EF63FE,8C444FA3F248,942CB374E6CF,E820E206A4A7,942CB3EBCA74,8C444FEF40A6,E820E20516B8,942CB3AB98DB,90F3055CBE80,8C444FC92715,8C444F75940E,E820E29295BB,E820E29016CA,E820E25BF56C,8C444FA2FBF1,90F3055C5541,E820E24E55C8,E820E2B33B34,942CB3D4C194,8C444F596163,942CB3CA2364,E820E25D4C8F,942CB3998356,8C444FCA5702,8C444FCB8218,942CB3B36444,942CB3E3331D,E820E2F1702F,E820E2EF5456,8C444F6757D1', '',039,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-02 15:21:06 Duration: 10s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55197, 406, '215768785861', '',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-09-02 08:35:15 Duration: 7s600ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (283685, 404, 'F200012013BBD5A,84011297B57C$F200012301B55F8,1834AF60DCFB$F200010323B8B7C,743AEFDB4C61$F200011244B2E7A,8401122AE6CA$F200011168B4C20,9877E7BDB1C7$F200011116BBFE5,9877E77ED8FC$F200012063B7FD1,840112DAC557$F200011057E7C90,9877E74E0ED5$F200012353B4A95,1834AF63E2CF$F200011119B4D2A,9877E7B840A4$F200011242B1281,8401122A91F8$F200012300B3175,1834AF60A9A8$F200012186B7397,1834AF244A3E$F200010281B00BA,743AEFAC6C85$F200012126B491E,840112E9D9A3$F200010288BEB3A,743AEFAE68EC$F200011174B762A,9877E7BF2BF1$F200011116B1140,9877E77E8C96$F200011131B1313,9877E7B99956$F200013248B399F,1834AF9BCA31$F200011355B6457,8401129508CC$F200012060B1D63,840112C24371$F200011102B1A01,9877E77B5854$F200011067B72C1,9877E7485DAF$F200011329BBB22,84011283F420$F200011053B4CCF,9877E74CB042$F2000101541C23B,743AEF34BD01$F2000101791036E,743AEF600611$F200010284B79D6,743AEFAD882F$F200010248B97CF,743AEF965648$F20001016211E80,743AEF5CDF12$F200010232B0D03,743AEF72B871$F200010349B1EFF,9877E7031967$F200011251B3EA4,84011237659D$F200012189B11B2,1834AF24C7FF$F200010304B0594,743AEFC5E7CA$F20001020517098,743AEF772330$F200012185B30AD,840112ED6733$F200011057EDC70,9877E74E38C7', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-02 09:19:31 Duration: 6s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 828 10m21s 150ms 12s238ms 750ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 02 07 5 6s408ms 1s281ms 08 100 1m23s 839ms 09 129 2m11s 1s17ms 10 132 1m51s 843ms 11 120 1m47s 897ms 12 16 10s956ms 684ms 13 75 44s487ms 593ms 14 96 49s691ms 517ms 15 106 49s667ms 468ms 16 47 24s848ms 528ms 17 2 1s22ms 511ms [ User: intelifix - Total duration: 10m21s - Times executed: 828 ]
[ Application: [unknown] - Total duration: 10m21s - Times executed: 828 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "145", "itens" : "229804555762,229802868808,229817853839,229725287992,229819926566,229804439612,229789694155,229844685268,229850027192,229820238089,229805168909,229770678607,229819980815,229772758103,229903896871", "usuario" : "414", "caixa" : "2726298", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 08:19:42 Duration: 12s238ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "320", "itens" : "230048863545,241617506484,230047878790,241601002629,241596684654,230048041737,241635512832,241602560223,241619855759,241635998591,241607024350,241615892242,241609971013,241602562041,241602542443,230049244345,230047919704,241615868906,241610107187,241616058497,241629863145,241604996677,241596105271,241607921722,241607798803,241607787791,241599262942,230049152440,241602893240,241608844146,241598105163,241630944855,241628272238", "usuario" : "414", "caixa" : "1298444", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 09:46:30 Duration: 10s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "305", "itens" : "229951758691,230013121011,230043201332,229998710009,229952200105,230015633961,229951895473,230015660608,229951701313,229951551422,230030813860", "usuario" : "414", "caixa" : "1297801", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 15:33:40 Duration: 8s649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 284 1h59m3s 150ms 8m28s 25s153ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 02 06 4 1s649ms 412ms 07 32 19m38s 36s820ms 08 32 8m27s 15s862ms 09 27 28m27s 1m3s 10 24 7m7s 17s818ms 11 28 10m9s 21s757ms 12 10 11m30s 1m9s 13 14 25s845ms 1s846ms 14 36 7m41s 12s814ms 15 22 12m8s 33s122ms 16 25 6m17s 15s114ms 17 30 7m7s 14s236ms [ User: intelifix - Total duration: 1h59m3s - Times executed: 284 ]
[ Application: [unknown] - Total duration: 1h59m3s - Times executed: 284 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029322, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 07:25:06 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029332, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:06:38 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029337, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:59:38 Duration: 7m Database: rio User: intelifix Remote: [local] Application: [unknown]
4 276 11m47s 188ms 21s794ms 2s564ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 02 00 12 54s753ms 4s562ms 01 12 31s917ms 2s659ms 02 12 34s318ms 2s859ms 03 12 33s375ms 2s781ms 04 12 33s139ms 2s761ms 05 12 35s490ms 2s957ms 06 12 33s863ms 2s821ms 07 12 47s869ms 3s989ms 08 12 36s127ms 3s10ms 09 12 48s315ms 4s26ms 10 12 38s255ms 3s187ms 11 12 35s461ms 2s955ms 12 12 26s649ms 2s220ms 13 12 26s362ms 2s196ms 14 12 27s906ms 2s325ms 15 12 20s636ms 1s719ms 16 12 20s427ms 1s702ms 17 12 20s545ms 1s712ms 18 12 20s317ms 1s693ms 19 12 20s223ms 1s685ms 20 12 22s638ms 1s886ms 21 12 19s635ms 1s636ms 22 12 19s698ms 1s641ms [ User: intelifix - Total duration: 11m47s - Times executed: 276 ]
[ Application: psql - Total duration: 11m47s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 00:05:53 Duration: 21s794ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 07:25:34 Duration: 16s721ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 09:15:24 Duration: 13s14ms Database: rio User: intelifix Remote: [local] Application: psql
5 160 12m41s 175ms 29s814ms 4s762ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 02 00 6 45s519ms 7s586ms 01 6 19s436ms 3s239ms 02 5 25s197ms 5s39ms 03 5 31s450ms 6s290ms 04 6 39s635ms 6s605ms 05 5 26s402ms 5s280ms 07 9 58s324ms 6s480ms 08 12 1m4s 5s333ms 09 12 1m21s 6s781ms 10 12 1m28s 7s402ms 11 12 1m22s 6s888ms 12 12 41s149ms 3s429ms 13 8 15s566ms 1s945ms 14 12 47s115ms 3s926ms 15 11 41s830ms 3s802ms 16 10 26s41ms 2s604ms 17 6 3s898ms 649ms 21 5 11s963ms 2s392ms 22 6 11s580ms 1s930ms [ User: intelifix - Total duration: 12m41s - Times executed: 160 ]
[ Application: psql - Total duration: 12m41s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 00:05:31 Duration: 29s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 11:35:19 Duration: 18s508ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 09:55:20 Duration: 18s280ms Database: rio User: intelifix Remote: [local] Application: psql
6 153 40s65ms 150ms 828ms 261ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 02 01 12 2s848ms 237ms 05 27 6s380ms 236ms 07 9 2s639ms 293ms 08 14 4s317ms 308ms 09 24 6s673ms 278ms 10 24 6s236ms 259ms 11 26 6s792ms 261ms 12 3 959ms 319ms 13 1 349ms 349ms 14 4 912ms 228ms 15 7 1s591ms 227ms 16 2 362ms 181ms [ User: intelifix - Total duration: 40s65ms - Times executed: 153 ]
[ Application: [unknown] - Total duration: 40s65ms - Times executed: 153 ]
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229805050918,229796105061,229821189103,229857605171,229819733742,229805200405,229803717790,229819747480', NULL, NULL, 0145, 00);
Date: 2026-09-02 11:43:41 Duration: 828ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '229910467490,229899638296,229893544144,229895248901,229908422342,229913843443,229915612022,229899095763,229915761532,229903138807,229913608492', NULL, NULL, 0263, 00);
Date: 2026-09-02 10:20:42 Duration: 707ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '229838578386,229851983646,229841253654,229846050015,229840493849,229852522139,229843412832,229841595157,229842314251,229841354651', NULL, NULL, 0160, 00);
Date: 2026-09-02 10:31:33 Duration: 693ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 131 27s994ms 150ms 529ms 213ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 02 05 4 1s385ms 346ms 07 23 4s972ms 216ms 08 14 3s88ms 220ms 09 30 6s337ms 211ms 10 16 3s224ms 201ms 11 13 2s876ms 221ms 12 2 370ms 185ms 13 3 639ms 213ms 14 6 1s169ms 194ms 15 6 1s202ms 200ms 16 12 2s367ms 197ms 17 1 161ms 161ms 21 1 198ms 198ms [ User: intelifix - Total duration: 27s994ms - Times executed: 131 ]
[ Application: [unknown] - Total duration: 27s994ms - Times executed: 131 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230043671737');
Date: 2026-09-02 05:17:59 Duration: 529ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('B4F26750930F');
Date: 2026-09-02 08:40:20 Duration: 426ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241784436176');
Date: 2026-09-02 05:15:25 Duration: 410ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 112 1m48s 150ms 5s748ms 971ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 02 06 7 9s494ms 1s356ms 07 34 33s334ms 980ms 08 10 11s802ms 1s180ms 09 11 9s531ms 866ms 10 15 12s278ms 818ms 11 8 10s789ms 1s348ms 13 8 10s378ms 1s297ms 14 11 7s512ms 682ms 15 1 391ms 391ms 16 7 3s238ms 462ms [ User: intelifix - Total duration: 1m48s - Times executed: 112 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 112 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283073) LIMIT 1;
Date: 2026-09-02 07:36:40 Duration: 5s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283370) LIMIT 1;
Date: 2026-09-02 06:54:25 Duration: 3s999ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283074) LIMIT 1;
Date: 2026-09-02 07:35:14 Duration: 3s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 103 42s885ms 301ms 827ms 416ms 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 #9
Day Hour Count Duration Avg duration Sep 02 01 2 869ms 434ms 05 5 2s943ms 588ms 06 1 384ms 384ms 07 5 2s200ms 440ms 08 14 6s900ms 492ms 09 13 6s235ms 479ms 10 5 2s367ms 473ms 11 10 4s908ms 490ms 12 5 1s613ms 322ms 13 10 3s298ms 329ms 14 10 3s463ms 346ms 15 7 2s296ms 328ms 16 7 2s536ms 362ms 17 7 2s235ms 319ms 21 2 631ms 315ms [ User: lenon - Total duration: 42s885ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 42s885ms - Times executed: 103 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-02 08:35:17 Duration: 827ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-02 05:07:36 Duration: 735ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-02 10:12:34 Duration: 704ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
10 93 47s684ms 232ms 1s45ms 512ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 02 01 2 1s502ms 751ms 05 5 3s708ms 741ms 07 3 1s765ms 588ms 08 12 7s115ms 592ms 09 13 7s432ms 571ms 10 5 2s836ms 567ms 11 10 6s170ms 617ms 12 5 1s893ms 378ms 13 9 3s707ms 411ms 14 10 4s146ms 414ms 15 7 2s613ms 373ms 16 6 2s617ms 436ms 17 6 2s174ms 362ms [ User: intelifix - Total duration: 47s684ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 47s684ms - Times executed: 93 ]
-
select * from rs_menu_grants (500, 19, 1);
Date: 2026-09-02 05:07:36 Duration: 1s45ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-09-02 01:30:13 Duration: 997ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-09-02 11:34:34 Duration: 978ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
11 91 34s387ms 181ms 1s811ms 377ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 02 07 3 1s287ms 429ms 08 14 5s875ms 419ms 09 6 4s617ms 769ms 10 6 2s269ms 378ms 11 10 5s35ms 503ms 12 5 1s958ms 391ms 13 5 1s415ms 283ms 14 8 2s399ms 299ms 15 9 2s627ms 291ms 16 5 1s375ms 275ms 17 20 5s525ms 276ms [ User: intelifix - Total duration: 34s387ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 34s387ms - Times executed: 91 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-02 09:42:08 Duration: 1s811ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-09-02 09:25:19 Duration: 917ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-02 12:21:16 Duration: 860ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 84 21s301ms 155ms 1s44ms 253ms create table temp0000290372 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 02 08 9 2s113ms 234ms 09 42 11s587ms 275ms 10 11 2s392ms 217ms 11 22 5s208ms 236ms [ User: intelifix - Total duration: 21s301ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 21s301ms - Times executed: 84 ]
-
CREATE TABLE temp0000290372 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-31', '2026-09-02');
Date: 2026-09-02 09:31:14 Duration: 1s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290372 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '2102313BFARYN2929429', '2026-08-31', '2026-09-02');
Date: 2026-09-02 09:50:07 Duration: 788ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290372 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '216569956778', '2026-08-31', '2026-09-02');
Date: 2026-09-02 11:52:26 Duration: 667ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 74 25s191ms 161ms 1s433ms 340ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 02 08 20 6s773ms 338ms 09 15 4s77ms 271ms 15 11 2s94ms 190ms 16 28 12s246ms 437ms [ User: intelifix - Total duration: 25s191ms - Times executed: 74 ]
[ Application: [unknown] - Total duration: 25s191ms - Times executed: 74 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0109871);
Date: 2026-09-02 08:49:42 Duration: 1s433ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-09-02 16:13:14 Duration: 583ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-09-02 16:13:53 Duration: 553ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 68 38s902ms 150ms 2s265ms 572ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 02 08 9 4s725ms 525ms 09 17 11s393ms 670ms 10 13 5s922ms 455ms 11 14 9s63ms 647ms 13 3 689ms 229ms 14 4 2s924ms 731ms 15 1 267ms 267ms 16 5 3s99ms 619ms 17 2 817ms 408ms [ User: intelifix - Total duration: 38s902ms - Times executed: 68 ]
[ Application: [unknown] - Total duration: 38s902ms - Times executed: 68 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D8313922177E,5872C98F9A41,D831399AE5E4,4896D9566DB6,843C9936014F,3CF9F0A5F83E,4896D95866D6,843C99228D2B,48D682385BCA,48D68233B7D6,3891484A95E7,48D682330CF4,C4EBFF8AED54,F4E84F894644,3891484F25A7,3CF9F0AC0066,C4EBFF89D126,3CF9F0A90ECA,C4EBFF8ABA66,843C99353879,843C992E9B89,3CF9F0AC4452,48D68234B358,843C99368BCD,48D682335422,6C11BA6FFDA1,D89A0DA4EA11,5872C98CE0FD,D831391DFB68,D83139249066,6C11BA6D4133,3891484F09A5,4896D9503A68,D831391E0BEE,843C992F7A37,3891484A8543,4896D958C220,4896D956CB7C,4896D9527EE2,D89A0DAC6687', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-09-02 11:28:57 Duration: 2s265ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '230035557992,230047569109,230028272243,229974591325,230028682036,230014878702,229972373858,230055441819,229967167984,229975121736,230010433442,229980209415,230029247881,230054211632,230053401822,230025954059,229960960511,230054166071,229973981333,230052389714,229971845669,230020884260,230035114257,229972508999,229982748002,229981812647,230014045657,230051796064,230032619614,230053810830,230050202228,230030355981,230028962546,230014127887,230019470924,230037921636,230019620209,230047021828,230028488605,230006114558,230030299410,230005148492,229976664759,230037986265,229966429696,229982260020,229963473034,230024647982', '','DEFAULT',051,0295,'', '','', 00);
Date: 2026-09-02 09:51:10 Duration: 1s734ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '186A81D40FFD,922321110206,922291067496,923081022924,922271004568,C03C04801898,920411010395,923091160562,921451019106', '138;1', 'DEFAULT', 09, 0155, '','', '', 00);
Date: 2026-09-02 09:17:43 Duration: 1s596ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
15 67 25s425ms 150ms 1s302ms 379ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 02 01 1 401ms 401ms 05 2 1s230ms 615ms 07 2 1s560ms 780ms 08 2 867ms 433ms 09 6 1s721ms 286ms 10 9 4s358ms 484ms 11 21 6s698ms 318ms 12 8 2s643ms 330ms 13 3 849ms 283ms 14 3 1s101ms 367ms 15 7 3s473ms 496ms 16 2 310ms 155ms 17 1 209ms 209ms [ User: intelifix - Total duration: 25s425ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 25s425ms - Times executed: 67 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "366", "data-de" : "2026-09-01", "data-ate" : "2026-09-01", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 418 }');
Date: 2026-09-02 07:14:02 Duration: 1s302ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-09-01", "data-ate" : "2026-09-01", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 441 }');
Date: 2026-09-02 11:10:20 Duration: 987ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "328", "data-de" : "2026-09-02", "data-ate" : "2026-09-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 397 }');
Date: 2026-09-02 15:05:55 Duration: 938ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 66 5m13s 1s287ms 19s886ms 4s747ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 02 07 2 24s442ms 12s221ms 08 3 13s148ms 4s382ms 09 3 18s16ms 6s5ms 10 9 38s671ms 4s296ms 11 8 41s259ms 5s157ms 12 5 17s43ms 3s408ms 13 17 1m12s 4s282ms 14 8 29s30ms 3s628ms 15 5 18s823ms 3s764ms 16 2 13s315ms 6s657ms 17 4 26s811ms 6s702ms [ User: intelifix - Total duration: 5m13s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 5m13s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0476, '', '', 0, 6, '2026-09-01');
Date: 2026-09-02 07:26:16 Duration: 19s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0302, '', '', 0, 6, '2026-09-02');
Date: 2026-09-02 09:35:30 Duration: 10s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-02 12:33:34 Duration: 10s340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 58 12m42s 9s908ms 34s861ms 13s141ms create table temp0000290354 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 02 07 10 1m47s 10s767ms 08 12 2m43s 13s645ms 09 9 2m23s 15s966ms 10 6 1m24s 14s94ms 11 9 2m3s 13s775ms 12 6 1m6s 11s94ms 14 6 1m11s 11s993ms [ User: intelifix - Total duration: 12m42s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 12m42s - Times executed: 58 ]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 09:51:50 Duration: 34s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 08:19:01 Duration: 31s168ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 11:20:34 Duration: 23s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 57 2m8s 560ms 18s21ms 2s259ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 02 08 5 11s422ms 2s284ms 09 5 32s92ms 6s418ms 10 4 20s792ms 5s198ms 11 4 9s139ms 2s284ms 12 3 2s580ms 860ms 13 5 16s856ms 3s371ms 14 3 2s339ms 779ms 15 4 6s161ms 1s540ms 16 4 10s856ms 2s714ms 17 3 2s662ms 887ms 18 4 2s926ms 731ms 19 3 2s371ms 790ms 20 3 2s291ms 763ms 21 3 2s172ms 724ms 22 4 4s143ms 1s35ms [ User: intelifix - Total duration: 2m8s - Times executed: 57 ]
[ Application: psql - Total duration: 2m8s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 09:40:19 Duration: 18s21ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 10:00:18 Duration: 17s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 09:00:13 Duration: 11s570ms Database: rio User: intelifix Remote: [local] Application: psql
19 52 8s257ms 150ms 186ms 158ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 02 01 1 157ms 157ms 05 1 160ms 160ms 07 1 152ms 152ms 08 8 1s280ms 160ms 09 15 2s401ms 160ms 10 11 1s744ms 158ms 11 15 2s361ms 157ms [ User: intelifix - Total duration: 8s257ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 8s257ms - Times executed: 52 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-09-02 09:54:53 Duration: 186ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0185;
Date: 2026-09-02 08:28:09 Duration: 178ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0303;
Date: 2026-09-02 11:03:16 Duration: 176ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 50 11s492ms 150ms 1s867ms 229ms create table temp0000290370 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 02 08 17 4s504ms 264ms 09 7 1s240ms 177ms 10 21 4s38ms 192ms 11 3 686ms 228ms 16 1 535ms 535ms 17 1 487ms 487ms [ User: intelifix - Total duration: 11s492ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 11s492ms - Times executed: 50 ]
-
CREATE TABLE temp0000290370 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 08:03:34 Duration: 1s867ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290370 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"67797", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 16:12:12 Duration: 535ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290370 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"67797", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 17:10:52 Duration: 487ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m58s 10m25s 6m41s 3 20m4s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 02 05 3 20m4s 6m41s [ User: intelifix - Total duration: 20m4s - Times executed: 3 ]
[ Application: psql - Total duration: 20m4s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-02 05:10:27 Duration: 10m25s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-02 05:17:08 Duration: 6m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-02 05:20:06 Duration: 2m58s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s331ms 14m14s 2m18s 48 1h50m32s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 02 07 3 15m21s 5m7s 08 3 7m8s 2m22s 09 3 11m22s 3m47s 10 3 8m34s 2m51s 11 3 7m42s 2m34s 12 3 5m33s 1m51s 13 3 5m30s 1m50s 14 3 5m45s 1m55s 15 3 5m46s 1m55s 16 3 5m49s 1m56s 17 3 5m33s 1m51s 18 3 5m12s 1m44s 19 3 5m12s 1m44s 20 3 5m23s 1m47s 21 3 5m22s 1m47s 22 3 5m11s 1m43s [ User: intelifix - Total duration: 1h50m32s - Times executed: 48 ]
[ Application: psql - Total duration: 1h50m32s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-02 07:19:15 Duration: 14m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-02 09:15:07 Duration: 10m6s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-02 10:13:05 Duration: 8m4s Database: rio User: intelifix Remote: [local] Application: psql
3 295ms 5m42s 1m34s 48 1h15m56s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 02 07 3 7m12s 2m24s 08 3 4m39s 1m33s 09 3 8m15s 2m45s 10 3 4m55s 1m38s 11 3 4m42s 1m34s 12 3 4m11s 1m23s 13 3 4m6s 1m22s 14 3 4m33s 1m31s 15 3 4m20s 1m26s 16 3 4m23s 1m27s 17 3 4m13s 1m24s 18 3 4m4s 1m21s 19 3 4m4s 1m21s 20 3 4m3s 1m21s 21 3 3m59s 1m19s 22 3 4m8s 1m22s [ User: intelifix - Total duration: 1h15m56s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m56s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-02 09:24:24 Duration: 5m42s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-02 07:27:18 Duration: 4m49s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-02 08:16:47 Duration: 4m2s Database: brasilia User: intelifix Remote: [local] Application: psql
4 3s872ms 1m4s 33s768ms 4 2m15s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 02 20 2 1m8s 34s155ms 23 2 1m6s 33s381ms [ User: intelifix - Total duration: 2m15s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m15s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-02 20:08:38 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-02 23:16:38 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-02 20:10:36 Duration: 4s155ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 150ms 8m28s 25s153ms 284 1h59m3s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 02 06 4 1s649ms 412ms 07 32 19m38s 36s820ms 08 32 8m27s 15s862ms 09 27 28m27s 1m3s 10 24 7m7s 17s818ms 11 28 10m9s 21s757ms 12 10 11m30s 1m9s 13 14 25s845ms 1s846ms 14 36 7m41s 12s814ms 15 22 12m8s 33s122ms 16 25 6m17s 15s114ms 17 30 7m7s 14s236ms [ User: intelifix - Total duration: 1h59m3s - Times executed: 284 ]
[ Application: [unknown] - Total duration: 1h59m3s - Times executed: 284 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029322, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 07:25:06 Duration: 8m28s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029332, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:06:38 Duration: 8m19s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029337, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-02 09:59:38 Duration: 7m Database: rio User: intelifix Remote: [local] Application: [unknown]
6 9s908ms 34s861ms 13s141ms 58 12m42s create table temp0000290354 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 02 07 10 1m47s 10s767ms 08 12 2m43s 13s645ms 09 9 2m23s 15s966ms 10 6 1m24s 14s94ms 11 9 2m3s 13s775ms 12 6 1m6s 11s94ms 14 6 1m11s 11s993ms [ User: intelifix - Total duration: 12m42s - Times executed: 58 ]
[ Application: [unknown] - Total duration: 12m42s - Times executed: 58 ]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 09:51:50 Duration: 34s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 08:19:01 Duration: 31s168ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 11:20:34 Duration: 23s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 753ms 58s528ms 11s573ms 27 5m12s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 02 07 3 1m7s 22s567ms 08 5 1m4s 12s980ms 09 4 43s194ms 10s798ms 10 1 13s707ms 13s707ms 11 1 6s942ms 6s942ms 12 2 16s850ms 8s425ms 13 1 13s629ms 13s629ms 14 3 40s160ms 13s386ms 15 3 33s692ms 11s230ms 16 2 9s544ms 4s772ms 17 2 2s153ms 1s76ms [ User: intelifix - Total duration: 5m12s - Times executed: 27 ]
[ Application: psql - Total duration: 5m12s - Times executed: 27 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029322);
Date: 2026-09-02 07:16:59 Duration: 58s528ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029332);
Date: 2026-09-02 08:58:16 Duration: 30s39ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029354);
Date: 2026-09-02 15:30:48 Duration: 25s539ms Database: rio User: intelifix Remote: [local] Application: psql
8 10s205ms 15s148ms 11s318ms 20 3m46s create table temp0000290432 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 02 11 3 34s227ms 11s409ms 12 1 10s466ms 10s466ms 13 2 25s697ms 12s848ms 14 2 23s337ms 11s668ms 15 5 56s301ms 11s260ms 16 2 21s17ms 10s508ms 17 5 55s312ms 11s62ms [ User: intelifix - Total duration: 3m46s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m46s - Times executed: 20 ]
-
CREATE TABLE temp0000290432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 13:41:53 Duration: 15s148ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:12:06 Duration: 12s915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290432 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 11:52:19 Duration: 12s185ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s402ms 12s192ms 11s65ms 20 3m41s create table temp0000290468 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 02 15 15 2m44s 10s966ms 16 5 56s823ms 11s364ms [ User: intelifix - Total duration: 3m41s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m41s - Times executed: 20 ]
-
CREATE TABLE temp0000290468 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 16:01:17 Duration: 12s192ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290468 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 15:30:02 Duration: 11s680ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290468 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 16:01:01 Duration: 11s621ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s196ms 11s179ms 10s754ms 12 2m9s create table temp0000290482 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 02 17 12 2m9s 10s754ms [ User: intelifix - Total duration: 2m9s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m9s - Times executed: 12 ]
-
CREATE TABLE temp0000290482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:42:29 Duration: 11s179ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:37:59 Duration: 11s121ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-02 17:45:23 Duration: 11s119ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 156ms 1m39s 7s311ms 44 5m21s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 02 07 4 3s551ms 887ms 08 8 1m14s 9s332ms 09 5 1m51s 22s280ms 10 2 1s425ms 712ms 11 4 13s873ms 3s468ms 12 2 1s154ms 577ms 13 1 28s229ms 28s229ms 14 3 10s189ms 3s396ms 15 6 59s242ms 9s873ms 16 3 2s102ms 700ms 17 6 15s869ms 2s644ms [ User: intelifix - Total duration: 5m21s - Times executed: 44 ]
[ Application: psql - Total duration: 5m21s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029334);
Date: 2026-09-02 09:07:15 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 503); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029354);
Date: 2026-09-02 15:30:23 Duration: 57s609ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029330);
Date: 2026-09-02 08:48:49 Duration: 46s420ms Database: rio User: intelifix Remote: [local] Application: psql
12 175ms 29s814ms 4s762ms 160 12m41s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 02 00 6 45s519ms 7s586ms 01 6 19s436ms 3s239ms 02 5 25s197ms 5s39ms 03 5 31s450ms 6s290ms 04 6 39s635ms 6s605ms 05 5 26s402ms 5s280ms 07 9 58s324ms 6s480ms 08 12 1m4s 5s333ms 09 12 1m21s 6s781ms 10 12 1m28s 7s402ms 11 12 1m22s 6s888ms 12 12 41s149ms 3s429ms 13 8 15s566ms 1s945ms 14 12 47s115ms 3s926ms 15 11 41s830ms 3s802ms 16 10 26s41ms 2s604ms 17 6 3s898ms 649ms 21 5 11s963ms 2s392ms 22 6 11s580ms 1s930ms [ User: intelifix - Total duration: 12m41s - Times executed: 160 ]
[ Application: psql - Total duration: 12m41s - Times executed: 160 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 00:05:31 Duration: 29s814ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 11:35:19 Duration: 18s508ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-02 09:55:20 Duration: 18s280ms Database: rio User: intelifix Remote: [local] Application: psql
13 1s287ms 19s886ms 4s747ms 66 5m13s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 02 07 2 24s442ms 12s221ms 08 3 13s148ms 4s382ms 09 3 18s16ms 6s5ms 10 9 38s671ms 4s296ms 11 8 41s259ms 5s157ms 12 5 17s43ms 3s408ms 13 17 1m12s 4s282ms 14 8 29s30ms 3s628ms 15 5 18s823ms 3s764ms 16 2 13s315ms 6s657ms 17 4 26s811ms 6s702ms [ User: intelifix - Total duration: 5m13s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 5m13s - Times executed: 66 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0476, '', '', 0, 6, '2026-09-01');
Date: 2026-09-02 07:26:16 Duration: 19s886ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0302, '', '', 0, 6, '2026-09-02');
Date: 2026-09-02 09:35:30 Duration: 10s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-02', 0175, '', '', 0, 6, '2026-09-01');
Date: 2026-09-02 12:33:34 Duration: 10s340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 1s817ms 38s379ms 4s580ms 41 3m7s create table temp0000290354 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 02 07 2 40s628ms 20s314ms 08 16 37s44ms 2s315ms 09 5 46s279ms 9s255ms 10 4 21s896ms 5s474ms 11 14 41s939ms 2s995ms [ User: intelifix - Total duration: 3m7s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 41 ]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 07:26:29 Duration: 38s379ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 09:32:06 Duration: 35s261ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290354 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-08-2026", "ate" :"02-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-02 10:31:15 Duration: 13s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 593ms 17s746ms 4s144ms 33 2m16s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 02 08 1 4s564ms 4s564ms 09 1 13s742ms 13s742ms 10 2 27s919ms 13s959ms 11 2 21s213ms 10s606ms 12 3 9s36ms 3s12ms 13 1 849ms 849ms 14 3 17s5ms 5s668ms 15 2 16s699ms 8s349ms 16 2 6s770ms 3s385ms 17 3 7s769ms 2s589ms 18 2 1s738ms 869ms 19 3 2s548ms 849ms 20 3 2s883ms 961ms 21 3 2s498ms 832ms 22 2 1s520ms 760ms [ User: intelifix - Total duration: 2m16s - Times executed: 33 ]
[ Application: psql - Total duration: 2m16s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-02 10:20:19 Duration: 17s746ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-02 11:40:15 Duration: 14s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-09-02 09:20:15 Duration: 13s742ms Database: rio User: intelifix Remote: [local] Application: psql
16 188ms 21s794ms 2s564ms 276 11m47s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 02 00 12 54s753ms 4s562ms 01 12 31s917ms 2s659ms 02 12 34s318ms 2s859ms 03 12 33s375ms 2s781ms 04 12 33s139ms 2s761ms 05 12 35s490ms 2s957ms 06 12 33s863ms 2s821ms 07 12 47s869ms 3s989ms 08 12 36s127ms 3s10ms 09 12 48s315ms 4s26ms 10 12 38s255ms 3s187ms 11 12 35s461ms 2s955ms 12 12 26s649ms 2s220ms 13 12 26s362ms 2s196ms 14 12 27s906ms 2s325ms 15 12 20s636ms 1s719ms 16 12 20s427ms 1s702ms 17 12 20s545ms 1s712ms 18 12 20s317ms 1s693ms 19 12 20s223ms 1s685ms 20 12 22s638ms 1s886ms 21 12 19s635ms 1s636ms 22 12 19s698ms 1s641ms [ User: intelifix - Total duration: 11m47s - Times executed: 276 ]
[ Application: psql - Total duration: 11m47s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 00:05:53 Duration: 21s794ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 07:25:34 Duration: 16s721ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-02 09:15:24 Duration: 13s14ms Database: rio User: intelifix Remote: [local] Application: psql
17 560ms 18s21ms 2s259ms 57 2m8s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 02 08 5 11s422ms 2s284ms 09 5 32s92ms 6s418ms 10 4 20s792ms 5s198ms 11 4 9s139ms 2s284ms 12 3 2s580ms 860ms 13 5 16s856ms 3s371ms 14 3 2s339ms 779ms 15 4 6s161ms 1s540ms 16 4 10s856ms 2s714ms 17 3 2s662ms 887ms 18 4 2s926ms 731ms 19 3 2s371ms 790ms 20 3 2s291ms 763ms 21 3 2s172ms 724ms 22 4 4s143ms 1s35ms [ User: intelifix - Total duration: 2m8s - Times executed: 57 ]
[ Application: psql - Total duration: 2m8s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 09:40:19 Duration: 18s21ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 10:00:18 Duration: 17s44ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-02 09:00:13 Duration: 11s570ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 10s822ms 1s44ms 1,467 25m32s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 02 07 5 2s603ms 520ms 08 119 2m43s 1s375ms 09 199 4m20s 1s309ms 10 190 3m38s 1s151ms 11 152 3m16s 1s293ms 12 63 57s825ms 917ms 13 101 1m25s 841ms 14 230 3m20s 871ms 15 170 2m16s 803ms 16 163 2m27s 901ms 17 75 1m2s 839ms [ User: intelifix - Total duration: 25m32s - Times executed: 1467 ]
[ Application: [unknown] - Total duration: 25m32s - Times executed: 1467 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (283560, 450, '11824385850058501215,E820E2B2B236,942CB3EF63FE,8C444FA3F248,942CB374E6CF,E820E206A4A7,942CB3EBCA74,8C444FEF40A6,E820E20516B8,942CB3AB98DB,90F3055CBE80,8C444FC92715,8C444F75940E,E820E29295BB,E820E29016CA,E820E25BF56C,8C444FA2FBF1,90F3055C5541,E820E24E55C8,E820E2B33B34,942CB3D4C194,8C444F596163,942CB3CA2364,E820E25D4C8F,942CB3998356,8C444FCA5702,8C444FCB8218,942CB3B36444,942CB3E3331D,E820E2F1702F,E820E2EF5456,8C444F6757D1', '',039,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-02 15:21:06 Duration: 10s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55197, 406, '215768785861', '',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-09-02 08:35:15 Duration: 7s600ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (283685, 404, 'F200012013BBD5A,84011297B57C$F200012301B55F8,1834AF60DCFB$F200010323B8B7C,743AEFDB4C61$F200011244B2E7A,8401122AE6CA$F200011168B4C20,9877E7BDB1C7$F200011116BBFE5,9877E77ED8FC$F200012063B7FD1,840112DAC557$F200011057E7C90,9877E74E0ED5$F200012353B4A95,1834AF63E2CF$F200011119B4D2A,9877E7B840A4$F200011242B1281,8401122A91F8$F200012300B3175,1834AF60A9A8$F200012186B7397,1834AF244A3E$F200010281B00BA,743AEFAC6C85$F200012126B491E,840112E9D9A3$F200010288BEB3A,743AEFAE68EC$F200011174B762A,9877E7BF2BF1$F200011116B1140,9877E77E8C96$F200011131B1313,9877E7B99956$F200013248B399F,1834AF9BCA31$F200011355B6457,8401129508CC$F200012060B1D63,840112C24371$F200011102B1A01,9877E77B5854$F200011067B72C1,9877E7485DAF$F200011329BBB22,84011283F420$F200011053B4CCF,9877E74CB042$F2000101541C23B,743AEF34BD01$F2000101791036E,743AEF600611$F200010284B79D6,743AEFAD882F$F200010248B97CF,743AEF965648$F20001016211E80,743AEF5CDF12$F200010232B0D03,743AEF72B871$F200010349B1EFF,9877E7031967$F200011251B3EA4,84011237659D$F200012189B11B2,1834AF24C7FF$F200010304B0594,743AEFC5E7CA$F20001020517098,743AEF772330$F200012185B30AD,840112ED6733$F200011057EDC70,9877E74E38C7', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-02 09:19:31 Duration: 6s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 150ms 5s748ms 971ms 112 1m48s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 02 06 7 9s494ms 1s356ms 07 34 33s334ms 980ms 08 10 11s802ms 1s180ms 09 11 9s531ms 866ms 10 15 12s278ms 818ms 11 8 10s789ms 1s348ms 13 8 10s378ms 1s297ms 14 11 7s512ms 682ms 15 1 391ms 391ms 16 7 3s238ms 462ms [ User: intelifix - Total duration: 1m48s - Times executed: 112 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 112 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283073) LIMIT 1;
Date: 2026-09-02 07:36:40 Duration: 5s748ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283370) LIMIT 1;
Date: 2026-09-02 06:54:25 Duration: 3s999ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0283074) LIMIT 1;
Date: 2026-09-02 07:35:14 Duration: 3s836ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 150ms 12s238ms 750ms 828 10m21s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 02 07 5 6s408ms 1s281ms 08 100 1m23s 839ms 09 129 2m11s 1s17ms 10 132 1m51s 843ms 11 120 1m47s 897ms 12 16 10s956ms 684ms 13 75 44s487ms 593ms 14 96 49s691ms 517ms 15 106 49s667ms 468ms 16 47 24s848ms 528ms 17 2 1s22ms 511ms [ User: intelifix - Total duration: 10m21s - Times executed: 828 ]
[ Application: [unknown] - Total duration: 10m21s - Times executed: 828 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "145", "itens" : "229804555762,229802868808,229817853839,229725287992,229819926566,229804439612,229789694155,229844685268,229850027192,229820238089,229805168909,229770678607,229819980815,229772758103,229903896871", "usuario" : "414", "caixa" : "2726298", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 08:19:42 Duration: 12s238ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "320", "itens" : "230048863545,241617506484,230047878790,241601002629,241596684654,230048041737,241635512832,241602560223,241619855759,241635998591,241607024350,241615892242,241609971013,241602562041,241602542443,230049244345,230047919704,241615868906,241610107187,241616058497,241629863145,241604996677,241596105271,241607921722,241607798803,241607787791,241599262942,230049152440,241602893240,241608844146,241598105163,241630944855,241628272238", "usuario" : "414", "caixa" : "1298444", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 09:46:30 Duration: 10s407ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "305", "itens" : "229951758691,230013121011,230043201332,229998710009,229952200105,230015633961,229951895473,230015660608,229951701313,229951551422,230030813860", "usuario" : "414", "caixa" : "1297801", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-02 15:33:40 Duration: 8s649ms 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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 02 09 1 0ms 0ms 11 1 0ms 0ms 16 1 0ms 0ms 19 1 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 5m5s - Times executed: 5 ]
[ Application: psql - Total duration: 5m4s - Times executed: 3 ]
[ Application: [unknown] - Total duration: 1s535ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,778 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 40 FATAL entries
- 4642 ERROR entries
- 0 WARNING entries
- 3 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,609 Max number of times the same event was reported
- 4,685 Total events found
Rank Times reported Error 1 4,609 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 02 00 59 01 60 02 58 03 53 04 57 05 58 06 57 07 204 08 365 09 414 10 355 11 369 12 258 13 307 14 430 15 384 16 261 17 166 18 120 19 119 20 118 21 119 22 119 23 99 - ERROR: prepared statement "_PLAN00000000352B66F0" does not exist
- ERROR: prepared statement "_PLAN00000000352BA6D0" does not exist
- ERROR: prepared statement "_PLAN00000000352B5020" does not exist
Statement: DEALLOCATE "_PLAN00000000352B66F0"
Date: 2026-09-02 00:00:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000352BA6D0"
Date: 2026-09-02 00:01:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000352B5020"
Date: 2026-09-02 00:02:26 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 27 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 02 00 3 01 5 02 1 05 1 06 2 08 7 14 1 16 3 19 3 21 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-02 00:02:06 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-02 00:02:45 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-02 00:29:17 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 14 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 02 09 10 14 2 16 2 - ERROR: syntax error at or near "1" at character 95
- ERROR: syntax error at or near "15" at character 95
- ERROR: syntax error at or near "1" at character 95
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'1","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-09-02 09:04:34 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'15","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-09-02 09:04:35 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT MOD_ID AS ID, MOD_LEGADO || ' | ' || TCN_NOME AS NOME FROM RS_MODELOS_LISTA('{"nome":"'1","cliente":"0","status":"S","grupo":0,"tipo":0}')
Date: 2026-09-02 09:04:46 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 10 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 02 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-09-02 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-02 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-02 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 7 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 02 13 6 16 1 - ERROR: trailing junk after numeric literal at or near "942CB399DA9E" at character 27
- ERROR: trailing junk after numeric literal at or near "942CB399DA9E" at character 27
- ERROR: trailing junk after numeric literal at or near "942CB399DA9E" at character 27
Statement: select * from rs_caixa_qr(942CB399DA9E)
Date: 2026-09-02 13:00:56 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(942CB399DA9E)
Date: 2026-09-02 13:00:57 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(942CB399DA9E)
Date: 2026-09-02 13:01:07 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
6 4 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 02 10 4 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73901285850064203315)Date: 2026-09-02 10:29:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73901285850064203315)Date: 2026-09-02 10:29:16 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73901285850064203315)Date: 2026-09-02 10:29:24 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 02 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-02 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-02 05:32:22 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-02 05:32:22 Database: contagem Application: psql User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 02 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-02 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-02 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-02 03:05:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 02 08 1 10 1 - ERROR: unterminated quoted string at or near "'C4447D26CFC7'');" at character 39
- ERROR: unterminated quoted string at or near "'40EEDD512449'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('C4447D26CFC7'');
Date: 2026-09-02 08:51:25 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('40EEDD512449'');
Date: 2026-09-02 10:45:48 Database: rio Application: [unknown] User: intelifix Remote: [local]
10 1 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 02 08 1 - LOG: process 3479364 still waiting for ShareLock on transaction 5442623 after 1000.150 ms
Detail: Process holding the lock: 3445919. Wait queue: 3479364.
Context: while deleting tuple (37721,98) in relation "caixa_itens" SQL statement "DELETE FROM CAIXA_ITENS WHERE FLU_ID IN (SELECT FLU_ID FROM FLUXOS WHERE EQ_ID = cRet.ID )" PL/pgSQL function rs_exclui_seriais(character varying) line 50 at SQL statement PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/Exclusão ATOP 1.xlsx'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-09-02 08:56:16 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 1 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 02 16 1 - ERROR: malformed array literal: "{63,0,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{63,0,0,0,}', 263 ));Date: 2026-09-02 16:31:31 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 02 08 1 - ERROR: process 3445919 detected deadlock while waiting for ShareLock on transaction 5442679 after 1000.114 ms
Detail: Process holding the lock: 3479364. Wait queue: .
Context: while deleting tuple (8142,35) in relation "caixa_itens" SQL statement "DELETE FROM CAIXA_ITENS WHERE FLU_ID IN (SELECT FLU_ID FROM FLUXOS WHERE EQ_ID = cRet.ID )" PL/pgSQL function rs_exclui_seriais(character varying) line 50 at SQL statement PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO ATOP.xlsx'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-09-02 08:56:23 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 02 03 1 - LOG: database system was shut down at 2026-09-02 03:05:02 -03
Date: 2026-09-02 03:05:03
14 1 ERROR: spiexceptions.DeadlockDetected: deadlock detected
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 02 08 1 - ERROR: spiexceptions.DeadlockDetected: deadlock detected
Detail: Process 3445919 waits for ShareLock on transaction 5442679; blocked by process 3479364. Process 3479364 waits for ShareLock on transaction 5442623; blocked by process 3445919.
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 137, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: See server log for query details.
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO ATOP.xlsx'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-09-02 08:56:23 Database: rio Application: [unknown] User: intelifix Remote: [local]