pgBadger-
Global information
- Generated on Tue Jul 21 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 44,359 log entries in 8s
- Log start from 2026-07-21 00:00:40 to 2026-07-21 23:50:06
-
Overview
Global Stats
- 378 Number of unique normalized queries
- 6,986 Number of queries
- 8h13m14s Total query duration
- 2026-07-21 00:02:18 First query
- 2026-07-21 23:48:54 Last query
- 6 queries/s at 2026-07-21 11:05:13 Query peak
- 8h13m14s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h13m14s Execute total duration
- 3,838 Number of events
- 15 Number of unique normalized events
- 3,668 Max number of times the same event was reported
- 0 Number of cancellation
- 493 Total number of automatic vacuums
- 1,057 Total number of automatic analyzes
- 10 Number temporary file
- 236.30 MiB Max size of temporary file
- 109.87 MiB Average size of temporary file
- 359 Total number of sessions
- 9 sessions at 2026-07-21 08:15:56 Session peak
- 13d2h35m54s Total duration of sessions
- 52m34s Average duration of sessions
- 19 Average queries per session
- 1m22s Average queries duration per session
- 51m12s Average idle time per session
- 365 Total number of connections
- 5 connections/s at 2026-07-21 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-21 11:05:13 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-21 11:05:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-07-21 23:48:26 Date
Queries duration
Key values
- 8h13m14s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 21 00 28 0ms 18s109ms 4s523ms 5s67ms 6s30ms 1m15s 01 31 0ms 5s199ms 1s232ms 5s190ms 6s323ms 6s605ms 02 20 0ms 4s950ms 1s700ms 4s323ms 5s786ms 6s405ms 03 21 0ms 10s682ms 2s197ms 5s229ms 7s58ms 12s289ms 04 23 0ms 4s223ms 1s474ms 4s741ms 5s375ms 6s585ms 05 39 0ms 8m10s 26s670ms 9s357ms 2m22s 8m10s 06 21 0ms 13s549ms 3s381ms 4s62ms 5s190ms 29s569ms 07 192 0ms 7m59s 11s491ms 33s785ms 6m 9m6s 08 676 150ms 7m49s 2s868ms 56s273ms 4m6s 8m 09 871 150ms 9m40s 3s589ms 1m15s 6m6s 10m21s 10 716 150ms 8m39s 4s166ms 4m27s 5m28s 8m42s 11 601 150ms 8m6s 2s427ms 32s536ms 1m20s 8m9s 12 162 0ms 7m19s 5s947ms 11s523ms 1m15s 7m19s 13 485 0ms 6m51s 3s603ms 54s599ms 4m25s 6m59s 14 755 150ms 8m26s 2s744ms 45s178ms 4m54s 8m32s 15 917 150ms 8m49s 2s991ms 1m16s 5m41s 8m58s 16 606 150ms 7m49s 2s989ms 50s468ms 3m58s 7m53s 17 277 0ms 7m24s 3s683ms 15s487ms 1m12s 7m26s 18 22 0ms 5m48s 27s844ms 3s898ms 44s610ms 5m48s 19 21 0ms 5m44s 29s824ms 3s865ms 46s590ms 5m44s 20 114 0ms 7m11s 11s662ms 1m7s 2m23s 7m11s 21 33 0ms 5m50s 19s217ms 5s848ms 45s976ms 5m50s 22 27 0ms 5m25s 22s610ms 5s965ms 14s249ms 5m53s 23 328 0ms 1m34s 7s70ms 1m6s 1m10s 1m34s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 21 00 6 0 3s977ms 0ms 0ms 1s878ms 01 13 0 257ms 0ms 159ms 1s3ms 02 2 0 443ms 0ms 0ms 0ms 03 3 0 496ms 0ms 0ms 333ms 04 5 0 259ms 0ms 0ms 186ms 05 16 0 314ms 0ms 364ms 1s67ms 06 6 0 3s133ms 0ms 0ms 847ms 07 103 0 16s664ms 2s967ms 16s163ms 8m55s 08 516 0 2s847ms 8s338ms 20s743ms 5m50s 09 655 0 3s476ms 13s887ms 57s710ms 6m43s 10 544 0 4s675ms 13s231ms 4m27s 6m14s 11 456 0 2s625ms 9s665ms 20s712ms 4m35s 12 105 0 8s318ms 3s14ms 8s178ms 4m26s 13 352 0 3s752ms 10s876ms 18s211ms 4m45s 14 536 0 3s23ms 10s637ms 23s92ms 6m 15 704 0 3s210ms 20s522ms 1m1s 6m39s 16 473 0 3s99ms 12s774ms 34s524ms 5m19s 17 199 0 4s745ms 5s602ms 14s18ms 3m49s 18 7 0 1m23s 0ms 0ms 3m13s 19 6 0 1m40s 0ms 0ms 3m29s 20 12 87 13s83ms 30s75ms 1m6s 3m50s 21 13 0 46s67ms 0ms 576ms 3m20s 22 6 0 1m35s 0ms 0ms 3m26s 23 4 324 7s70ms 1m2s 1m6s 1m24s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 21 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 21 00 0 1 1.00 0.00% 01 0 2 2.00 0.00% 02 0 1 1.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 2 2.00 0.00% 06 0 2 2.00 0.00% 07 0 8 8.00 0.00% 08 0 17 17.00 0.00% 09 0 18 18.00 0.00% 10 0 13 13.00 0.00% 11 0 12 12.00 0.00% 12 0 7 7.00 0.00% 13 0 11 11.00 0.00% 14 0 17 17.00 0.00% 15 0 17 17.00 0.00% 16 0 11 11.00 0.00% 17 0 8 8.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jul 21 00 15 0.00/s 01 9 0.00/s 02 7 0.00/s 03 17 0.00/s 04 10 0.00/s 05 9 0.00/s 06 17 0.00/s 07 17 0.00/s 08 23 0.01/s 09 24 0.01/s 10 22 0.01/s 11 23 0.01/s 12 13 0.00/s 13 22 0.01/s 14 23 0.01/s 15 23 0.01/s 16 24 0.01/s 17 16 0.00/s 18 7 0.00/s 19 7 0.00/s 20 14 0.00/s 21 8 0.00/s 22 8 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jul 21 00 4 1h45s 1h13s 01 14 1h1m15s 1h1m13s 02 9 1h22s 1h18s 03 15 20m5s 20m2s 04 9 1h2m40s 1h2m36s 05 10 55m36s 53m52s 06 9 58m40s 58m32s 07 17 54m14s 52m4s 08 17 50m9s 48m15s 09 24 53m32s 51m22s 10 22 56m54s 54m39s 11 21 55m53s 54m44s 12 22 57m8s 56m24s 13 16 46m27s 44m38s 14 20 54m4s 52m21s 15 23 57m37s 55m38s 16 27 46m23s 45m16s 17 18 56m6s 55m9s 18 14 58m47s 58m3s 19 7 1h49s 59m20s 20 11 39m57s 37m56s 21 9 1h45s 59m35s 22 10 55m18s 54m17s 23 11 30m48s 27m17s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-07-21 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
- 9 sessions Session Peak
- 2026-07-21 08:15:56 Date
Histogram of session times
Key values
- 287 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 359 sessions Total
Sessions per user
Key values
- intelifix Main User
- 359 sessions Total
Sessions per host
Key values
- [local] Main Host
- 359 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 60,831 buffers Checkpoint Peak
- 2026-07-21 00:09:50 Date
- 270.031 seconds Highest write time
- 0.134 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-07-21 10:44:37 Date
Checkpoints distance
Key values
- 390.41 Mo Distance Peak
- 2026-07-21 10:44:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 21 00 89,190 667.172s 0.038s 667.288s 01 3,392 341.042s 0.055s 341.175s 02 1,436 144.441s 0.028s 144.512s 03 1,892 189.665s 0.032s 189.763s 04 1,710 171.993s 0.028s 172.078s 05 11,919 1,095.155s 0.101s 1,095.322s 06 6,510 389.324s 0.008s 389.347s 07 38,481 2,412.737s 0.213s 2,413.077s 08 57,553 3,205.605s 0.735s 3,206.56s 09 73,150 3,238.54s 0.879s 3,239.688s 10 96,147 3,238.569s 0.858s 3,239.668s 11 51,823 3,238.825s 0.655s 3,239.685s 12 21,089 1,924.138s 0.181s 1,924.435s 13 26,927 2,568.636s 0.454s 2,569.271s 14 70,725 3,238.794s 0.703s 3,239.735s 15 83,246 3,238.668s 0.768s 3,239.675s 16 46,570 3,139.824s 0.53s 3,140.561s 17 15,621 1,615.03s 0.206s 1,615.358s 18 817 82.051s 0.018s 82.096s 19 22 2.234s 0.004s 2.248s 20 1,122 298.235s 0.018s 298.275s 21 2,911 292.235s 0.038s 292.366s 22 2,242 225.139s 0.033s 225.224s 23 242 28.374s 0.017s 28.415s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 21 00 0 0 12 470 0.003s 0.009s 01 0 0 1 731 0.002s 0.01s 02 0 0 1 411 0.003s 0.006s 03 0 0 0 395 0.004s 0.01s 04 0 0 1 416 0.002s 0.009s 05 0 0 4 966 0.010s 0.009s 06 0 0 1 62 0.002s 0.002s 07 0 0 26 2,443 0.009s 0.012s 08 0 0 27 7,087 0.010s 0.012s 09 0 0 59 7,836 0.012s 0.012s 10 0 0 46 7,775 0.014s 0.012s 11 0 0 23 6,687 0.013s 0.012s 12 0 0 7 2,463 0.004s 0.012s 13 0 0 27 5,630 0.014s 0.012s 14 0 0 36 7,433 0.015s 0.012s 15 0 0 51 7,827 0.011s 0.012s 16 0 0 29 5,668 0.007s 0.012s 17 0 0 5 2,964 0.004s 0.013s 18 0 0 1 142 0.004s 0.004s 19 0 0 0 3 0.002s 0.002s 20 0 0 1 79 0.002s 0.003s 21 0 0 0 449 0.003s 0.011s 22 0 0 1 415 0.003s 0.009s 23 0 0 0 24 0.003s 0.006s Day Hour Count Avg time (sec) Jul 21 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 21 00 24,748.00 kB 79,690.50 kB 01 1,705.10 kB 32,771.50 kB 02 1,224.83 kB 14,559.83 kB 03 1,011.00 kB 2,627.00 kB 04 996.89 kB 1,692.56 kB 05 8,450.33 kB 17,093.33 kB 06 7,843.00 kB 14,102.00 kB 07 34,675.50 kB 66,358.33 kB 08 37,486.17 kB 77,317.83 kB 09 79,530.17 kB 108,887.42 kB 10 63,552.67 kB 122,187.75 kB 11 31,668.17 kB 99,657.25 kB 12 9,289.50 kB 41,114.33 kB 13 36,421.50 kB 52,234.17 kB 14 48,811.42 kB 94,604.92 kB 15 70,659.75 kB 132,534.25 kB 16 39,218.00 kB 78,216.83 kB 17 7,387.00 kB 36,478.50 kB 18 786.75 kB 16,621.00 kB 19 171.00 kB 12,723.00 kB 20 5,323.67 kB 11,617.67 kB 21 1,352.36 kB 6,471.00 kB 22 1,516.12 kB 3,343.12 kB 23 154.25 kB 2,159.25 kB -
Temporary Files
Size of temporary files
Key values
- 472.59 MiB Temp Files size Peak
- 2026-07-21 05:31:59 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-21 05:32:05 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 21 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.87 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 917.88 MiB 70.48 MiB 236.30 MiB 114.73 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-21 05:32:06 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-21 05:31:59 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 180.78 MiB 90.39 MiB 90.39 MiB 90.39 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-21 05:30:42 Duration: 40s276ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-21 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 236.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 236.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-21 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.39 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-21 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 77.98 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 77.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 77.89 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:32:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.48 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-21 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 4.70 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database brasilia - 2026-07-21 00:06:08 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 4.70 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database brasilia - 2026-07-21 00:06:08 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (131) Main table analyzed (database rio)
- 1,057 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 131 rio.pg_catalog.pg_class 67 rio.pg_catalog.pg_type 57 rio.public.temp0000286034 47 rio.public.temp0000284750 45 rio.public.temp0000285940 45 rio.public.usuarios 45 brasilia.pg_catalog.pg_attribute 43 rio.pg_catalog.pg_index 37 contagem.pg_catalog.pg_attribute 32 rio.pg_catalog.pg_depend 28 rio.public.temp0000285938 27 rio.public.temp0000285984 24 brasilia.pg_catalog.pg_class 23 brasilia.pg_catalog.pg_type 21 rio.public.temp0000285920 21 contagem.public.usuarios 20 contagem.pg_catalog.pg_class 17 rio.public.temp0000285808 15 brasilia.pg_catalog.pg_index 14 rio.public.temp0000285978 14 rio.public.temp0000286014 14 contagem.pg_catalog.pg_type 13 rio.public.temp0000286018 12 rio.public.temp0000285404 11 brasilia.public.usuarios 11 brasilia.pg_catalog.pg_depend 11 rio.public.temp0000286004 11 rio.public.temp0000286008 10 contagem.public.temp0000226658 9 contagem.pg_catalog.pg_index 8 brasilia.public.temp0000236586 7 brasilia.public.temp0000236588 7 contagem.public.temp0000226612 7 rio.public.temp0000285936 6 rio.public.temp0000285998 6 rio.public.temp0000285928 6 rio.public.temp0000285960 6 rio.public.temp0000286026 5 rio.public.temp0000286020 5 contagem.pg_catalog.pg_depend 5 rio.public.temp0000285950 5 postgres.pg_catalog.pg_shdepend 5 rio.public.temp0000285942 4 rio.public.temp0000285946 4 brasilia.public.nf_entrada 4 rio.public.temp0000286050 4 rio.public.temp0000286012 4 rio.public.temp0000285956 3 rio.public.tmp_drill_0302 3 brasilia.public.temp0000236596 3 rio.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0175 3 rio.public.temp0000286054 3 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000236532 3 rio.public.temp0000286058 3 rio.public.temp0000285962 3 brasilia.public.temp0000236592 3 rio.public.temp0000285970 2 brasilia.public.temp0000236614 2 brasilia.public.temp0000236540 2 rio.public.temp0000285924 2 brasilia.public.temp0000236558 2 brasilia.public.temp0000236544 2 brasilia.public.temp0000236584 2 rio.public.temp0000285986 2 brasilia.public.temp0000236534 2 brasilia.public.temp0000236612 1 brasilia.public.temp0000236536 1 rio.public.temp0000286000 1 rio.public.temp0000286074 1 rio.public.temp0000285972 1 rio.public.temp0000286056 1 rio.public.temp0000286052 1 contagem.public.temp0000226668 1 brasilia.public.temp0000236570 1 rio.public.temp0000285990 1 rio.public.temp0000285980 1 rio.public.temp0000285996 1 rio.public.temp0000285994 1 rio.public.temp0000286038 1 brasilia.public.temp0000236530 1 rio.public.temp0000285954 1 rio.public.temp0000285932 1 rio.public.temp0000285870 1 rio.public.temp0000285824 1 brasilia.public.temp0000236548 1 brasilia.public.temp0000236590 1 template1.pg_catalog.pg_shdepend 1 rio.public.temp0000286066 1 rio.public.temp0000286042 1 brasilia.public.temp0000236606 1 rio.public.temp0000286006 1 rio.public.temp0000285964 1 brasilia.public.temp0000236598 1 brasilia.public.temp0000236538 1 rio.public.temp0000286024 1 rio.public.temp0000286048 1 rio.public.temp0000286070 1 rio.public.temp0000285944 1 Total 1,057 Vacuums per table
Key values
- pg_catalog.pg_attribute (52) Main table vacuumed on database rio
- 493 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 52 45 0 0 0 0 0 26,661 7,361 10,567,416 394 9,854 rio.public.temp0000285940 46 0 0 0 0 0 0 34,628 453 2,548,582 0 0 rio.public.temp0000284750 36 0 0 0 0 0 0 2,547 191 179,829 0 0 rio.pg_catalog.pg_class 34 25 0 0 0 0 0 5,290 1,805 2,537,322 98 370 rio.public.temp0000285938 27 0 0 0 0 0 0 31,805 1,767 4,030,338 0 0 rio.pg_catalog.pg_type 25 21 0 0 0 0 0 2,158 730 966,321 95 302 rio.public.temp0000286034 22 0 0 0 0 0 0 11,309 114 685,217 0 0 contagem.public.usuarios 20 0 0 0 0 0 0 89 66 37,761 1 1 brasilia.pg_catalog.pg_attribute 15 14 0 0 0 0 0 7,272 1,676 2,866,216 55 1,391 rio.public.temp0000285808 14 0 0 0 0 0 0 1,048 167 226,910 0 0 rio.public.temp0000285984 13 0 0 0 0 0 0 7,174 64 432,835 0 0 rio.pg_catalog.pg_index 13 13 0 0 0 0 0 1,084 320 255,038 57 138 rio.public.usuarios 12 6 0 0 0 0 0 178 72 173,241 8 13 rio.public.temp0000285404 11 0 0 0 0 0 0 732 58 52,198 0 0 brasilia.pg_catalog.pg_class 11 10 0 0 0 0 0 2,174 401 725,503 22 112 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,664 1,852 3,176,040 13 441 brasilia.pg_catalog.pg_type 11 10 0 0 0 0 0 973 237 322,905 8 50 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,661 1,367 1,770,189 84 721 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 10,725 2,445 10,538,968 1,006 4,290 rio.public.temp0000285978 9 0 0 0 0 0 0 3,492 45 212,959 0 0 brasilia.pg_catalog.pg_index 7 6 0 0 0 0 0 284 58 57,547 13 26 rio.public.temp0000285960 6 0 0 0 0 0 0 426 34 30,621 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,954 377 1,974,359 125 348 rio.public.tmp_drill_0175 4 3 0 0 0 0 0 1,339 9 234,484 0 0 brasilia.public.nf_entrada 4 4 0 0 0 0 0 439 70 202,409 8 12 template1.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 481 173 324,102 43 137 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,187 281 502,916 12 120 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 496 175 258,132 5 13 rio.public.temp0000286054 3 0 0 0 0 0 0 203 17 14,697 0 0 rio.public.temp0000285956 3 0 0 0 0 0 0 92 12 7,411 0 0 rio.public.tmp_drill_0302 3 3 0 0 0 0 0 92 22 34,795 0 0 contagem.pg_catalog.pg_type 3 3 0 0 0 0 0 249 105 144,723 3 6 brasilia.public.temp0000236596 3 0 0 0 0 0 0 726 18 46,237 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 106 42 31,276 2 3 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 575 219 413,913 2 18 rio.public.temp0000286050 2 0 0 0 0 0 0 141 9 9,845 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 335 78 297,127 25 56 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,065 344 1,442,568 188 1,557 brasilia.public.temp0000236584 1 0 0 0 0 0 0 81 6 5,679 0 0 rio.public.temp0000285964 1 0 0 0 0 0 0 8 5 1,300 0 0 rio.public.temp0000286052 1 0 0 0 0 0 0 96 6 6,594 0 0 contagem.public.temp0000226668 1 0 0 0 0 0 0 106 6 7,207 0 0 brasilia.public.temp0000236570 1 0 0 0 0 0 0 242 6 15,403 0 0 brasilia.public.temp0000236538 1 0 0 0 0 0 0 242 6 15,411 0 0 rio.public.temp0000285994 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000285996 1 0 0 0 0 0 0 85 6 5,924 0 0 rio.public.temp0000286024 1 0 0 0 0 0 0 94 6 6,475 0 0 rio.public.temp0000286048 1 0 0 0 0 0 0 1,669 4 99,074 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,419 6 167,176 0 0 rio.public.temp0000285990 1 0 0 0 0 0 0 85 6 5,924 0 0 rio.public.temp0000286038 1 0 0 0 0 0 0 8 5 1,320 0 0 rio.public.temp0000285944 1 0 0 0 0 0 0 85 6 5,924 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 130 47 95,753 8 30 rio.public.temp0000285954 1 0 0 0 0 0 0 84 6 5,863 0 0 contagem.public.temp0000226658 1 0 0 0 0 0 0 106 6 7,207 0 0 postgres.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 171 60 76,774 10 12 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 159 4 23,753 0 0 contagem.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 122 32 70,003 5 10 rio.public.temp0000286000 1 0 0 0 0 0 0 8 5 1,305 0 0 rio.public.temp0000286026 1 0 0 0 0 0 0 103 6 7,002 0 0 contagem.pg_toast.pg_toast_371973 1 0 0 0 0 0 0 533 180 78,044 176 995 rio.public.temp0000285824 1 0 0 0 0 0 0 1,667 4 98,956 0 0 rio.public.temp0000285970 1 0 0 0 0 0 0 84 6 5,864 0 0 rio.public.temp0000286042 1 0 0 0 0 0 0 8 5 1,320 0 0 rio.public.temp0000285972 1 0 0 0 0 0 0 84 6 5,864 0 0 rio.public.temp0000286066 1 0 0 0 0 0 0 8 5 1,328 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 22,732 22,084 27,354,069 155 789 Total 493 223 0 0 0 0 0 202,077 45,767 76,510,240 2,621 21,815 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (4.7) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.11 rio.public.temp0000285940 0 0 1.6 rio.public.temp0000284750 0 0 0.49 rio.pg_catalog.pg_class 0 0 1.06 rio.public.temp0000285938 0 0 1.35 rio.pg_catalog.pg_type 0 0 0.35 rio.public.temp0000286034 0 0 0.63 contagem.public.usuarios 0 0 0 brasilia.pg_catalog.pg_attribute 0 0 0.98 rio.public.temp0000285808 0 0 0.22 rio.public.temp0000285984 0 0 0.34 rio.pg_catalog.pg_index 0 0 0.37 rio.public.usuarios 0 0 0 rio.public.temp0000285404 0 0 0.17 brasilia.pg_catalog.pg_class 0 0 0.27 contagem.pg_catalog.pg_attribute 0 0 1.14 brasilia.pg_catalog.pg_type 0 0 0.15 rio.pg_catalog.pg_depend 0 0 0.72 rio.pg_catalog.pg_statistic 0 0 1.42 rio.public.temp0000285978 0 0 0.2 brasilia.pg_catalog.pg_index 0 0 0.05 rio.public.temp0000285960 0 0 0.12 rio.pg_toast.pg_toast_2619 0 0 0.2 rio.public.tmp_drill_0175 0 0 0.07 brasilia.public.nf_entrada 0 0 0.07 template1.pg_catalog.pg_shdepend 0 0 0.14 brasilia.pg_catalog.pg_depend 0 0 0.25 contagem.pg_catalog.pg_class 0 0 0.31 rio.public.temp0000286054 0 0 0.05 rio.public.temp0000285956 0 0 0.11 rio.public.tmp_drill_0302 0 0 0 contagem.pg_catalog.pg_type 0 0 0.11 brasilia.public.temp0000236596 0 0 0.06 contagem.pg_catalog.pg_index 0 0 0.09 contagem.pg_catalog.pg_depend 0 0 0.15 rio.public.temp0000286050 0 0 0.02 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.pg_catalog.pg_statistic 0 0 0.25 brasilia.public.temp0000236584 0 0 0.02 rio.public.temp0000285964 0 0 0.01 rio.public.temp0000286052 0 0 0.02 contagem.public.temp0000226668 0 0 0.02 brasilia.public.temp0000236570 0 0 0.03 brasilia.public.temp0000236538 0 0 0.02 rio.public.temp0000285994 0 0 0.04 rio.public.temp0000285996 0 0 0.02 rio.public.temp0000286024 0 0 0.02 rio.public.temp0000286048 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.05 rio.public.temp0000285990 0 0 0.02 rio.public.temp0000286038 0 0 0.02 rio.public.temp0000285944 0 0 0.01 rio.pg_catalog.pg_shdepend 0 0 0.08 rio.public.temp0000285954 0 0 0.01 contagem.public.temp0000226658 0 0 0.02 postgres.pg_catalog.pg_shdepend 0 0 0.13 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000286000 0 0 0.01 rio.public.temp0000286026 0 0 0.02 contagem.pg_toast.pg_toast_371973 0 0 0.06 rio.public.temp0000285824 0 0 0.05 rio.public.temp0000285970 0 0 0.02 rio.public.temp0000286042 0 0 0.01 rio.public.temp0000285972 0 0 0.01 rio.public.temp0000286066 0 0 0.02 brasilia.auditor.auditor_2026_07 0 0 4.7 Total 0 0 23.15 Tuples removed per table
Key values
- pg_catalog.pg_attribute (179084) Main table with removed tuples on database rio
- 398541 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 52 45 179,084 1,337,337 80,851 657 31,035 brasilia.pg_catalog.pg_attribute 15 14 71,800 341,962 17,555 76 8,800 contagem.pg_catalog.pg_attribute 11 11 31,951 256,239 0 0 5,780 rio.public.tmp_drill_0175 4 3 19,322 58,810 19,322 0 993 rio.pg_catalog.pg_statistic 9 9 15,623 76,743 750 0 11,574 rio.pg_catalog.pg_depend 11 11 12,477 202,633 2,371 0 2,057 brasilia.pg_catalog.pg_depend 4 4 10,129 71,525 0 0 724 brasilia.pg_catalog.pg_class 11 10 7,727 41,392 4,216 30 1,413 rio.pg_catalog.pg_type 25 21 7,396 60,905 3,162 37 1,803 brasilia.pg_catalog.pg_statistic 2 2 4,986 15,596 188 0 2,144 rio.pg_catalog.pg_class 34 25 4,410 137,535 12,911 59 4,683 contagem.pg_catalog.pg_statistic 1 1 4,274 7,274 0 0 1,011 brasilia.pg_catalog.pg_type 11 10 4,225 26,017 1,648 19 766 rio.pg_catalog.pg_index 13 13 3,951 25,202 64 0 819 template1.pg_catalog.pg_shdepend 4 4 3,406 54,806 352 0 460 brasilia.public.nf_entrada 4 4 3,289 20,599 665 0 608 brasilia.auditor.auditor_2026_07 1 0 2,626 3,354,914 0 0 148,566 brasilia.pg_catalog.pg_index 7 6 2,085 13,971 828 3 372 contagem.pg_catalog.pg_depend 2 2 2,036 37,708 0 0 352 contagem.public.usuarios 20 0 1,195 460 0 0 40 rio.pg_toast.pg_toast_2619 4 4 1,190 2,329 0 0 1,160 contagem.pg_catalog.pg_shdepend 1 1 1,140 13,572 0 0 115 rio.pg_catalog.pg_shdepend 1 1 979 13,597 0 0 115 contagem.pg_catalog.pg_class 4 4 657 14,450 0 0 528 postgres.pg_catalog.pg_shdepend 1 1 655 13,594 36 0 115 rio.public.usuarios 12 6 568 7,622 1,514 0 192 rio.public.tmp_drill_0302 3 3 367 887 0 0 25 contagem.pg_catalog.pg_index 2 2 349 3,793 0 5 100 contagem.pg_catalog.pg_type 3 3 283 6,749 0 6 183 brasilia.pg_toast.pg_toast_2619 2 2 206 286 6 0 132 contagem.pg_toast.pg_toast_2619 1 1 155 111 0 0 64 brasilia.public.temp0000236584 1 0 0 1,693 0 55 73 rio.public.temp0000285404 11 0 0 44,952 0 327 1,017 rio.public.temp0000285964 1 0 0 1,481 0 52 76 rio.public.temp0000286052 1 0 0 1,638 0 40 88 rio.public.temp0000285984 13 0 0 135,630 0 141 8,819 contagem.public.temp0000226668 1 0 0 1,276 0 30 98 brasilia.public.temp0000236570 1 0 0 3,119 0 22 234 brasilia.public.temp0000236538 1 0 0 3,118 0 22 234 rio.public.temp0000285994 1 0 0 23,473 0 0 1,664 rio.public.temp0000285996 1 0 0 1,502 0 51 77 rio.public.temp0000286024 1 0 0 1,635 0 42 86 rio.public.temp0000286048 1 0 0 23,500 0 0 1,728 rio.public.temp0000285978 9 0 0 60,605 0 206 3,762 rio.public.temp0000285808 14 0 0 57,424 0 437 1,291 rio.public.temp0000285990 1 0 0 1,488 0 51 77 rio.public.temp0000286038 1 0 0 1,637 0 41 87 rio.public.temp0000285944 1 0 0 1,487 0 51 77 rio.public.temp0000285960 6 0 0 27,486 0 88 616 rio.public.temp0000285954 1 0 0 1,477 0 52 76 contagem.public.temp0000226658 1 0 0 1,276 0 30 98 rio.public.temp0000286054 3 0 0 5,005 0 117 267 rio.public.temp0000286050 2 0 0 11,188 0 63 257 rio.public.temp0000286000 1 0 0 1,505 0 49 79 rio.public.temp0000286026 1 0 0 4,226 0 33 95 contagem.pg_toast.pg_toast_371973 1 0 0 1,001 0 0 177 rio.public.temp0000285956 3 0 0 48,381 0 52 3,404 rio.public.temp0000285824 1 0 0 23,474 0 0 1,664 rio.public.temp0000285970 1 0 0 1,481 0 52 76 rio.public.temp0000286034 22 0 0 205,464 0 475 13,221 rio.public.temp0000286042 1 0 0 1,637 0 41 87 rio.public.temp0000285972 1 0 0 1,481 0 52 76 rio.public.temp0000286066 1 0 0 1,728 0 37 91 brasilia.public.temp0000236596 3 0 0 9,368 0 66 702 rio.public.temp0000285938 27 0 0 612,092 0 53 43,851 rio.public.temp0000285940 46 0 0 620,308 0 1,031 43,705 rio.public.temp0000284750 36 0 0 138,207 0 1,006 3,122 Total 493 223 398,541 8,301,061 146,439 5,757 357,881 Pages removed per table
Key values
- public.temp0000285940 (1031) Main table with removed pages on database rio
- 5757 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000285940 46 0 0 1031 rio.public.temp0000284750 36 0 0 1006 rio.pg_catalog.pg_attribute 52 45 179084 657 rio.public.temp0000286034 22 0 0 475 rio.public.temp0000285808 14 0 0 437 rio.public.temp0000285404 11 0 0 327 rio.public.temp0000285978 9 0 0 206 rio.public.temp0000285984 13 0 0 141 rio.public.temp0000286054 3 0 0 117 rio.public.temp0000285960 6 0 0 88 brasilia.pg_catalog.pg_attribute 15 14 71800 76 brasilia.public.temp0000236596 3 0 0 66 rio.public.temp0000286050 2 0 0 63 rio.pg_catalog.pg_class 34 25 4410 59 brasilia.public.temp0000236584 1 0 0 55 rio.public.temp0000285938 27 0 0 53 rio.public.temp0000285964 1 0 0 52 rio.public.temp0000285954 1 0 0 52 rio.public.temp0000285956 3 0 0 52 rio.public.temp0000285970 1 0 0 52 rio.public.temp0000285972 1 0 0 52 rio.public.temp0000285996 1 0 0 51 rio.public.temp0000285990 1 0 0 51 rio.public.temp0000285944 1 0 0 51 rio.public.temp0000286000 1 0 0 49 rio.public.temp0000286024 1 0 0 42 rio.public.temp0000286038 1 0 0 41 rio.public.temp0000286042 1 0 0 41 rio.public.temp0000286052 1 0 0 40 rio.pg_catalog.pg_type 25 21 7396 37 rio.public.temp0000286066 1 0 0 37 rio.public.temp0000286026 1 0 0 33 brasilia.pg_catalog.pg_class 11 10 7727 30 contagem.public.temp0000226668 1 0 0 30 contagem.public.temp0000226658 1 0 0 30 brasilia.public.temp0000236570 1 0 0 22 brasilia.public.temp0000236538 1 0 0 22 brasilia.pg_catalog.pg_type 11 10 4225 19 contagem.pg_catalog.pg_type 3 3 283 6 contagem.pg_catalog.pg_index 2 2 349 5 brasilia.pg_catalog.pg_index 7 6 2085 3 rio.pg_catalog.pg_statistic 9 9 15623 0 rio.pg_toast.pg_toast_2619 4 4 1190 0 rio.public.temp0000285994 1 0 0 0 rio.public.temp0000286048 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4274 0 contagem.pg_catalog.pg_depend 2 2 2036 0 rio.pg_catalog.pg_shdepend 1 1 979 0 rio.public.tmp_drill_0175 4 3 19322 0 brasilia.public.nf_entrada 4 4 3289 0 contagem.pg_catalog.pg_attribute 11 11 31951 0 rio.public.usuarios 12 6 568 0 postgres.pg_catalog.pg_shdepend 1 1 655 0 contagem.pg_toast.pg_toast_2619 1 1 155 0 contagem.pg_catalog.pg_shdepend 1 1 1140 0 rio.pg_catalog.pg_index 13 13 3951 0 contagem.pg_toast.pg_toast_371973 1 0 0 0 rio.public.temp0000285824 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 206 0 brasilia.pg_catalog.pg_statistic 2 2 4986 0 contagem.public.usuarios 20 0 1195 0 template1.pg_catalog.pg_shdepend 4 4 3406 0 rio.public.tmp_drill_0302 3 3 367 0 rio.pg_catalog.pg_depend 11 11 12477 0 brasilia.pg_catalog.pg_depend 4 4 10129 0 contagem.pg_catalog.pg_class 4 4 657 0 brasilia.auditor.auditor_2026_07 1 0 2626 0 Total 493 223 398,541 5,757 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 21 00 1 0 01 0 8 02 0 0 03 0 0 04 0 3 05 7 14 06 0 0 07 17 26 08 47 114 09 77 138 10 44 114 11 43 112 12 1 13 13 44 87 14 57 122 15 106 173 16 40 99 17 7 30 18 0 0 19 0 0 20 0 0 21 2 4 22 0 0 23 0 0 - 4.70 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 3m 1m27s 1m33s 1m30s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 08:36:46 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 07:26:36 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 03:05:27 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s 1s 1s 1s drop table if exists temp0000285940;-
DROP TABLE IF EXISTS temp0000285940;
Date: 2026-07-21 07:11:42 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285940;
Date: 2026-07-21 07:11:42 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m33s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-21 08:36:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m27s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-21 07:26:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s DROP TABLE IF EXISTS temp0000285940;[ Date: 2026-07-21 07:11:42 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,742 Total read queries
- 1,749 Total write queries
Queries by database
Key values
- rio Main database
- 4,972 Requests
- 6h15m59s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,827 Requests
User Request type Count Duration etiquetas Total 42 8s304ms select 42 8s304ms intelifix Total 6,827 8h11m34s copy to 411 47m56s ddl 1,338 55m23s others 494 42m30s select 4,583 5h45m43s lenon Total 117 1m31s select 117 1m31s Duration by user
Key values
- 8h11m34s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 42 8s304ms select 42 8s304ms intelifix Total 6,827 8h11m34s copy to 411 47m56s ddl 1,338 55m23s others 494 42m30s select 4,583 5h45m43s lenon Total 117 1m31s select 117 1m31s Queries by host
Key values
- [local] Main host
- 6,986 Requests
- 8h13m14s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,863 Requests
- 4h11m1s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-21 13:10:20 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,895 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 09:14:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 15:13:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 10:13:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 14:13:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m10s analyze verbose;[ Date: 2026-07-21 05:08:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m6s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 11:13:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 07:13:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 16:12:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 08:12:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 17:12:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 12:12:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 20:12:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 13:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027327, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-21 09:25:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-21 15:25:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m4s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027339, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-21 09:54:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027359, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-21 14:47:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 21:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 18:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-21 19:10:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h5m27s 48 1s263ms 9m40s 2m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 21 07 3 8m34s 2m51s 08 3 8m6s 2m42s 09 3 10m26s 3m28s 10 3 9m8s 3m2s 11 3 8m36s 2m52s 12 3 7m47s 2m35s 13 3 7m10s 2m23s 14 3 8m52s 2m57s 15 3 9m20s 3m6s 16 3 8m10s 2m43s 17 3 7m46s 2m35s 18 3 6m4s 2m1s 19 3 6m 2m 20 3 7m32s 2m30s 21 3 6m6s 2m2s 22 3 5m41s 1m53s [ User: intelifix - Total duration: 2h5m27s - Times executed: 48 ]
[ Application: psql - Total duration: 2h5m27s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-21 09:14:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-21 15:13:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-21 10:13:41 Duration: 8m39s Database: rio User: intelifix Remote: [local] Application: psql
2 1h33m10s 361 150ms 6m37s 15s484ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 21 07 11 14m11s 1m17s 08 53 6m41s 7s582ms 09 44 14m22s 19s596ms 10 40 22m13s 33s338ms 11 38 52s411ms 1s379ms 12 10 19s301ms 1s930ms 13 12 5m28s 27s358ms 14 28 6m46s 14s521ms 15 68 14m32s 12s827ms 16 46 7m17s 9s503ms 17 11 24s758ms 2s250ms [ User: intelifix - Total duration: 1h33m10s - Times executed: 361 ]
[ Application: [unknown] - Total duration: 1h33m10s - Times executed: 361 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027327, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 09:25:07 Duration: 6m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 15:25:00 Duration: 6m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027339, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 09:54:51 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h17m40s 48 176ms 5m9s 1m37s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 21 07 3 4m53s 1m37s 08 3 4m36s 1m32s 09 3 6m1s 2m 10 3 5m39s 1m53s 11 3 5m23s 1m47s 12 3 5m11s 1m43s 13 3 4m53s 1m37s 14 3 5m45s 1m55s 15 3 6m6s 2m2s 16 3 4m37s 1m32s 17 3 4m26s 1m28s 18 3 3m41s 1m13s 19 3 3m59s 1m19s 20 3 4m42s 1m34s 21 3 3m50s 1m16s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h17m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h17m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-21 15:20:21 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-21 09:21:20 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-21 14:19:33 Duration: 4m44s Database: brasilia User: intelifix Remote: [local] Application: psql
4 17m31s 1,312 151ms 4s763ms 801ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 21 07 33 10s604ms 321ms 08 127 1m41s 802ms 09 128 2m24s 1s127ms 10 202 2m29s 741ms 11 113 1m41s 894ms 12 36 37s517ms 1s42ms 13 103 1m30s 879ms 14 207 2m48s 814ms 15 185 2m15s 731ms 16 117 1m13s 624ms 17 61 38s918ms 638ms [ User: intelifix - Total duration: 17m31s - Times executed: 1312 ]
[ Application: [unknown] - Total duration: 17m31s - Times executed: 1312 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46934, 409, '246144516880', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 13:57:44 Duration: 4s763ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267745, 504, 'CP234232LT9,D4925EF89520,544D4242007239DD,D4925EF89523$CP2317320ZA,D4925E9483DA,544D424200681CEC,D4925E9483DD$CP234232M4A,D4925EF8A0C3,544D424200723B28,D4925EF8A0C6$CP2305324NG,D4925E193D84,544D424200638B3F,D4925E193D87$CP240932JFU,08C7F52E0212,544D424200784DEF,08C7F52E0215$CP2317320Y4,D4925E94827B,544D424200681CC5,D4925E94827E$CP2327324CD,D4925ED54391,544D4242006DB076,D4925ED54394$CP234532FGG,08C7F504242F,544D4242007373EC,08C7F5042432$CP240932N8H,08C7F52E92B4,544D424200785E01,08C7F52E92B7$CP233532236,D4925EE9ABBC,544D4242006F53B5,D4925EE9ABBF$CP24093207G,08C7F52B473C,544D424200780049,08C7F52B473F$CP2310327D3,D4925E34880B,544D42420065CF4D,D4925E34880E$CP240332N71,08C7F52420A3,544D42420076FFD0,08C7F52420A6$CP230132RVB,D4925E054287,544D424200617E0E,D4925E05428A$CP234532946,08C7F5033033,544D4242007358D0,08C7F5033036$CP232532K2A,D4925ECE6C8E,544D4242006D6474,D4925ECE6C91$CP232032F3G,D4925EA5C588,544D42420069F06E,D4925EA5C58B$CP2250321M5,A0B53CF963F2,544D42420060AEE8,A0B53CF963F5$CP232032F27,D4925EA5C40E,544D42420069F044,D4925EA5C411$CP232232A34,D4925EBCF114,544D4242006BB6AF,D4925EBCF117$CP2305323GQ,D4925E1910A8,544D424200638643,D4925E1910AB$CP234232YVT,D4925EFA3D37,544D4242007268FC,D4925EFA3D3A$CP230232G0Y,D4925E088694,544D42420061DA39,D4925E088697$CP230232PLH,D4925E09A925,544D42420061FA82,D4925E09A928$CP22413213P,A0B53CC264FC,544D4242005E94D3,A0B53CC264FF$CP2411322SU,08C7F52FEC1D,544D424200788462,08C7F52FEC20$CP2342323V3,D4925EF60C63,544D42420071F1C8,D4925EF60C66$CP2325320NK,D4925EC92C08,544D4242006CFCDA,D4925EC92C0B$CP232532MCA,D4925ECEC4BA,544D4242006D6E40,D4925ECEC4BD$CP232032MB6,D4925EA6B459,544D4242006A0AF7,D4925EA6B45C$CP240932C56,08C7F52D0FFC,544D424200783309,08C7F52D0FFF$CP2411320H6,08C7F52F9454,544D424200787AA1,08C7F52F9457$CP2305323D2,D4925E190C67,544D4242006385CA,D4925E190C6A$CP23033299M,D4925E14F8D6,544D42420062DAB7,D4925E14F8D9$CP232032BAR,D4925EA534CB,544D42420069E059,D4925EA534CE$CP2323326U9,D4925EBB5BD4,544D4242006C8A7C,D4925EBB5BD7$CP2322323EM,D4925EB35964,544D4242006B9A64,D4925EB35967$CP2327321EW,D4925ED4D3A1,544D4242006DA406,D4925ED4D3A4$CP232532QKQ,D4925ECF4032,544D4242006D7BF8,D4925ECF4035$CP2305322ZG,D4925E18FC9E,544D424200638409,D4925E18FCA1', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 08:22:25 Duration: 4s441ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127696, 397, '854271000000172,241627531829,241613900207,241642271427,230056962742,241640779899,241625666876,241632960709,230056755976,241633636262,241633720615,241624015357,241633759305,241640019411,241612018686,241642255970,241613418991,241640049212,241633591332,241632559603,241640091921,241613125978,241623962749,241613695259,241640108992,241611512746,241611637280,241613510820,241626701232,241625497185,241640536363,241611263350,241643776466,241640025977,241640735272,241622935364,241627230509,241613677176,241640079292,241612579909,241642265870', '',0324,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 15:43:26 Duration: 4s329ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
5 14m29s 3 2m21s 8m10s 4m49s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 21 05 3 14m29s 4m49s [ User: intelifix - Total duration: 14m29s - Times executed: 3 ]
[ Application: psql - Total duration: 14m29s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-21 05:08:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-21 05:12:10 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-21 05:14:31 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql
6 14m28s 276 153ms 1m39s 3s147ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 21 00 12 31s679ms 2s639ms 01 12 27s581ms 2s298ms 02 12 27s27ms 2s252ms 03 12 35s590ms 2s965ms 04 12 24s569ms 2s47ms 05 12 27s746ms 2s312ms 06 12 27s285ms 2s273ms 07 12 1m58s 9s911ms 08 12 2m8s 10s701ms 09 12 39s653ms 3s304ms 10 12 39s61ms 3s255ms 11 12 36s904ms 3s75ms 12 12 31s960ms 2s663ms 13 12 32s408ms 2s700ms 14 12 32s39ms 2s669ms 15 12 31s298ms 2s608ms 16 12 27s676ms 2s306ms 17 12 25s742ms 2s145ms 18 12 23s292ms 1s941ms 19 12 23s44ms 1s920ms 20 12 30s918ms 2s576ms 21 12 22s891ms 1s907ms 22 12 22s846ms 1s903ms [ User: intelifix - Total duration: 14m28s - Times executed: 276 ]
[ Application: psql - Total duration: 14m28s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 08:36:46 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 07:26:36 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 03:05:27 Duration: 10s682ms Database: rio User: intelifix Remote: [local] Application: psql
7 13m53s 65 9s418ms 33s464ms 12s825ms create table temp0000285940 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 21 07 15 2m55s 11s688ms 08 6 1m16s 12s808ms 09 9 1m58s 13s116ms 10 11 2m14s 12s206ms 14 9 2m5s 13s918ms 15 12 2m48s 14s45ms 16 3 35s311ms 11s770ms [ User: intelifix - Total duration: 13m53s - Times executed: 65 ]
[ Application: [unknown] - Total duration: 13m53s - Times executed: 65 ]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 07:11:28 Duration: 33s464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:48:19 Duration: 16s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 15:34:53 Duration: 16s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9m42s 1,113 151ms 6s451ms 523ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 21 07 5 4s488ms 897ms 08 127 1m36s 756ms 09 166 1m42s 615ms 10 132 1m1s 464ms 11 130 1m2s 478ms 12 10 6s312ms 631ms 13 120 1m1s 511ms 14 116 58s485ms 504ms 15 158 1m6s 422ms 16 118 48s538ms 411ms 17 31 14s844ms 478ms [ User: intelifix - Total duration: 9m42s - Times executed: 1113 ]
[ Application: [unknown] - Total duration: 9m42s - Times executed: 1113 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "454", "itens" : "241627163252,241624798093,241624943540,241626531619,241613198790,241625013143,241613539004,241624902627,241611266481,241611556464,241613681824,241624944651,241627273846,241611517392,241626531518,241611565859,241611510019,241632701537,241627123652,241613238693,241613687177,241627278290,241627155372,241611564344,241613318095,241613349715,241624955157,241624936670,241613536781,241611498097,241613680006,241612577989,241624905556,241611507189,241614004762,241611232034,241624916769,241613493646,241625608385", "usuario" : "414", "caixa" : "1226886", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-21 08:11:27 Duration: 6s451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "295", "itens" : "230010175459,229973587073,230031658296,230009998292,229970665969,230027577595,230019549618,230011377484,229986463942,229982221733,230023205979,229975683036,229971959192,229974838801,229982813642,230023337383,229968263737,229966220508,230021088904,230001080016", "usuario" : "414", "caixa" : "2911516", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-21 09:13:16 Duration: 6s403ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "103107", "modelo" : "295", "itens" : "230023156479,230034654156,230030071229,230011353442,230034653449,230011045555,230022974969,230054173850,229968266767,229972447882,230007986177,229976923247,229991055557,229980866078,230014872843,230029415171,229964560223", "usuario" : "414", "caixa" : "1195700", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-21 09:10:03 Duration: 3s218ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9m30s 43 10s389ms 34s838ms 13s263ms create table temp0000285938 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 21 07 1 10s641ms 10s641ms 09 6 1m19s 13s170ms 10 6 1m14s 12s439ms 11 5 1m8s 13s628ms 13 1 12s29ms 12s29ms 14 10 2m8s 12s894ms 15 8 1m39s 12s492ms 16 6 1m36s 16s160ms [ User: intelifix - Total duration: 9m30s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 9m30s - Times executed: 43 ]
-
CREATE TABLE temp0000285938 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 16:25:14 Duration: 34s838ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285938 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 14:36:56 Duration: 16s777ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285938 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 15:10:58 Duration: 15s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m44s 64 1s264ms 34s355ms 8s200ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 21 07 2 11s135ms 5s567ms 08 5 30s622ms 6s124ms 09 5 37s14ms 7s402ms 10 3 22s743ms 7s581ms 11 5 56s999ms 11s399ms 12 4 17s257ms 4s314ms 13 7 56s865ms 8s123ms 14 6 24s742ms 4s123ms 15 6 1m36s 16s99ms 16 8 1m2s 7s798ms 17 13 1m48s 8s343ms [ User: intelifix - Total duration: 8m44s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 8m44s - Times executed: 64 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 15:37:34 Duration: 34s355ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 17:24:26 Duration: 34s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 11:59:37 Duration: 33s131ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7m13s 159 185ms 12s90ms 2s728ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 21 00 6 18s448ms 3s74ms 01 6 7s292ms 1s215ms 02 6 6s93ms 1s15ms 03 5 8s874ms 1s774ms 04 6 8s49ms 1s341ms 05 5 12s412ms 2s482ms 07 12 37s250ms 3s104ms 08 12 42s159ms 3s513ms 09 12 46s636ms 3s886ms 10 12 44s170ms 3s680ms 11 12 50s203ms 4s183ms 12 11 35s14ms 3s183ms 13 10 7s326ms 732ms 14 10 34s312ms 3s431ms 15 12 38s180ms 3s181ms 16 8 15s211ms 1s901ms 17 3 2s482ms 827ms 21 5 9s415ms 1s883ms 22 6 10s309ms 1s718ms [ User: intelifix - Total duration: 7m13s - Times executed: 159 ]
[ Application: psql - Total duration: 7m13s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 00:05:13 Duration: 12s90ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 07:35:10 Duration: 8s680ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 14:25:09 Duration: 8s674ms Database: rio User: intelifix Remote: [local] Application: psql
12 4m18s 19 10s613ms 37s968ms 13s581ms create table temp0000286034 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 21 13 16 3m41s 13s848ms 16 3 36s469ms 12s156ms [ User: intelifix - Total duration: 4m18s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 19 ]
-
CREATE TABLE temp0000286034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 13:27:47 Duration: 37s968ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 13:38:17 Duration: 14s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 13:37:27 Duration: 13s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m14s 4 4s730ms 1m34s 48s613ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 21 20 2 1m35s 47s551ms 23 2 1m39s 49s676ms [ User: intelifix - Total duration: 3m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-21 23:16:55 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-21 20:09:03 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-21 20:10:53 Duration: 4s875ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
14 3m8s 61 271ms 8s584ms 3s83ms create table temp0000284750 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 21 07 2 5s157ms 2s578ms 08 17 45s445ms 2s673ms 09 10 25s179ms 2s517ms 10 2 7s980ms 3s990ms 11 4 19s138ms 4s784ms 13 15 44s203ms 2s946ms 14 4 13s433ms 3s358ms 15 2 8s887ms 4s443ms 16 4 14s876ms 3s719ms 17 1 3s796ms 3s796ms [ User: intelifix - Total duration: 3m8s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 61 ]
-
CREATE TABLE temp0000284750 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "103107", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "21-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-21 09:09:19 Duration: 8s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284750 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "21-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-21 11:54:09 Duration: 6s419ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284750 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "21-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-21 10:48:42 Duration: 5s971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m32s 37 2s839ms 5s544ms 4s122ms create table temp0000285940 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 21 07 7 21s846ms 3s120ms 08 10 41s713ms 4s171ms 09 4 15s686ms 3s921ms 10 5 21s303ms 4s260ms 11 7 30s359ms 4s337ms 14 2 10s750ms 5s375ms 15 2 10s856ms 5s428ms [ User: intelifix - Total duration: 2m32s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 37 ]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 15:09:12 Duration: 5s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 14:23:19 Duration: 5s455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 15:09:26 Duration: 5s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 2m30s 11 10s750ms 15s537ms 13s662ms create table temp0000285984 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 21 09 11 2m30s 13s662ms [ User: intelifix - Total duration: 2m30s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 11 ]
-
CREATE TABLE temp0000285984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:42:22 Duration: 15s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:42:46 Duration: 15s340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:27:02 Duration: 15s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m27s 12 10s521ms 14s488ms 12s316ms create table temp0000285978 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 21 09 12 2m27s 12s316ms [ User: intelifix - Total duration: 2m27s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 12 ]
-
CREATE TABLE temp0000285978 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:14:35 Duration: 14s488ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285978 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:15:33 Duration: 13s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285978 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:08:29 Duration: 13s244ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m23s 36 662ms 11s540ms 3s986ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 21 08 2 15s599ms 7s799ms 09 3 21s868ms 7s289ms 10 3 19s854ms 6s618ms 11 2 15s568ms 7s784ms 12 1 3s972ms 3s972ms 13 3 6s625ms 2s208ms 14 2 16s104ms 8s52ms 15 1 3s242ms 3s242ms 16 3 18s447ms 6s149ms 17 2 8s696ms 4s348ms 18 2 1s589ms 794ms 19 3 2s886ms 962ms 20 3 3s397ms 1s132ms 21 3 2s993ms 997ms 22 3 2s682ms 894ms [ User: intelifix - Total duration: 2m23s - Times executed: 36 ]
[ Application: psql - Total duration: 2m23s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-21 14:20:12 Duration: 11s540ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-21 09:20:12 Duration: 10s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-21 11:20:10 Duration: 9s64ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m8s 4 411ms 1m5s 32s35ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 21 20 2 1m2s 31s248ms 23 2 1m5s 32s821ms [ User: intelifix - Total duration: 2m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-21 23:13:31 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-21 20:05:46 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-21 20:10:18 Duration: 610ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2m 36 195ms 10s849ms 3s342ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 21 07 3 14s113ms 4s704ms 08 1 10s849ms 10s849ms 09 10 29s974ms 2s997ms 10 3 7s25ms 2s341ms 11 2 2s890ms 1s445ms 13 4 19s677ms 4s919ms 14 3 10s160ms 3s386ms 15 7 14s572ms 2s81ms 16 3 11s75ms 3s691ms [ User: intelifix - Total duration: 2m - Times executed: 36 ]
[ Application: psql - Total duration: 2m - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027319);
Date: 2026-07-21 08:30:42 Duration: 10s849ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027313);
Date: 2026-07-21 07:12:53 Duration: 10s360ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027367);
Date: 2026-07-21 15:17:59 Duration: 10s32ms Database: rio User: intelifix Remote: [local] Application: psql
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,312 17m31s 151ms 4s763ms 801ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 21 07 33 10s604ms 321ms 08 127 1m41s 802ms 09 128 2m24s 1s127ms 10 202 2m29s 741ms 11 113 1m41s 894ms 12 36 37s517ms 1s42ms 13 103 1m30s 879ms 14 207 2m48s 814ms 15 185 2m15s 731ms 16 117 1m13s 624ms 17 61 38s918ms 638ms [ User: intelifix - Total duration: 17m31s - Times executed: 1312 ]
[ Application: [unknown] - Total duration: 17m31s - Times executed: 1312 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46934, 409, '246144516880', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 13:57:44 Duration: 4s763ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267745, 504, 'CP234232LT9,D4925EF89520,544D4242007239DD,D4925EF89523$CP2317320ZA,D4925E9483DA,544D424200681CEC,D4925E9483DD$CP234232M4A,D4925EF8A0C3,544D424200723B28,D4925EF8A0C6$CP2305324NG,D4925E193D84,544D424200638B3F,D4925E193D87$CP240932JFU,08C7F52E0212,544D424200784DEF,08C7F52E0215$CP2317320Y4,D4925E94827B,544D424200681CC5,D4925E94827E$CP2327324CD,D4925ED54391,544D4242006DB076,D4925ED54394$CP234532FGG,08C7F504242F,544D4242007373EC,08C7F5042432$CP240932N8H,08C7F52E92B4,544D424200785E01,08C7F52E92B7$CP233532236,D4925EE9ABBC,544D4242006F53B5,D4925EE9ABBF$CP24093207G,08C7F52B473C,544D424200780049,08C7F52B473F$CP2310327D3,D4925E34880B,544D42420065CF4D,D4925E34880E$CP240332N71,08C7F52420A3,544D42420076FFD0,08C7F52420A6$CP230132RVB,D4925E054287,544D424200617E0E,D4925E05428A$CP234532946,08C7F5033033,544D4242007358D0,08C7F5033036$CP232532K2A,D4925ECE6C8E,544D4242006D6474,D4925ECE6C91$CP232032F3G,D4925EA5C588,544D42420069F06E,D4925EA5C58B$CP2250321M5,A0B53CF963F2,544D42420060AEE8,A0B53CF963F5$CP232032F27,D4925EA5C40E,544D42420069F044,D4925EA5C411$CP232232A34,D4925EBCF114,544D4242006BB6AF,D4925EBCF117$CP2305323GQ,D4925E1910A8,544D424200638643,D4925E1910AB$CP234232YVT,D4925EFA3D37,544D4242007268FC,D4925EFA3D3A$CP230232G0Y,D4925E088694,544D42420061DA39,D4925E088697$CP230232PLH,D4925E09A925,544D42420061FA82,D4925E09A928$CP22413213P,A0B53CC264FC,544D4242005E94D3,A0B53CC264FF$CP2411322SU,08C7F52FEC1D,544D424200788462,08C7F52FEC20$CP2342323V3,D4925EF60C63,544D42420071F1C8,D4925EF60C66$CP2325320NK,D4925EC92C08,544D4242006CFCDA,D4925EC92C0B$CP232532MCA,D4925ECEC4BA,544D4242006D6E40,D4925ECEC4BD$CP232032MB6,D4925EA6B459,544D4242006A0AF7,D4925EA6B45C$CP240932C56,08C7F52D0FFC,544D424200783309,08C7F52D0FFF$CP2411320H6,08C7F52F9454,544D424200787AA1,08C7F52F9457$CP2305323D2,D4925E190C67,544D4242006385CA,D4925E190C6A$CP23033299M,D4925E14F8D6,544D42420062DAB7,D4925E14F8D9$CP232032BAR,D4925EA534CB,544D42420069E059,D4925EA534CE$CP2323326U9,D4925EBB5BD4,544D4242006C8A7C,D4925EBB5BD7$CP2322323EM,D4925EB35964,544D4242006B9A64,D4925EB35967$CP2327321EW,D4925ED4D3A1,544D4242006DA406,D4925ED4D3A4$CP232532QKQ,D4925ECF4032,544D4242006D7BF8,D4925ECF4035$CP2305322ZG,D4925E18FC9E,544D424200638409,D4925E18FCA1', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 08:22:25 Duration: 4s441ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127696, 397, '854271000000172,241627531829,241613900207,241642271427,230056962742,241640779899,241625666876,241632960709,230056755976,241633636262,241633720615,241624015357,241633759305,241640019411,241612018686,241642255970,241613418991,241640049212,241633591332,241632559603,241640091921,241613125978,241623962749,241613695259,241640108992,241611512746,241611637280,241613510820,241626701232,241625497185,241640536363,241611263350,241643776466,241640025977,241640735272,241622935364,241627230509,241613677176,241640079292,241612579909,241642265870', '',0324,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 15:43:26 Duration: 4s329ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
2 1,113 9m42s 151ms 6s451ms 523ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 21 07 5 4s488ms 897ms 08 127 1m36s 756ms 09 166 1m42s 615ms 10 132 1m1s 464ms 11 130 1m2s 478ms 12 10 6s312ms 631ms 13 120 1m1s 511ms 14 116 58s485ms 504ms 15 158 1m6s 422ms 16 118 48s538ms 411ms 17 31 14s844ms 478ms [ User: intelifix - Total duration: 9m42s - Times executed: 1113 ]
[ Application: [unknown] - Total duration: 9m42s - Times executed: 1113 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104675", "modelo" : "454", "itens" : "241627163252,241624798093,241624943540,241626531619,241613198790,241625013143,241613539004,241624902627,241611266481,241611556464,241613681824,241624944651,241627273846,241611517392,241626531518,241611565859,241611510019,241632701537,241627123652,241613238693,241613687177,241627278290,241627155372,241611564344,241613318095,241613349715,241624955157,241624936670,241613536781,241611498097,241613680006,241612577989,241624905556,241611507189,241614004762,241611232034,241624916769,241613493646,241625608385", "usuario" : "414", "caixa" : "1226886", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-21 08:11:27 Duration: 6s451ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "295", "itens" : "230010175459,229973587073,230031658296,230009998292,229970665969,230027577595,230019549618,230011377484,229986463942,229982221733,230023205979,229975683036,229971959192,229974838801,229982813642,230023337383,229968263737,229966220508,230021088904,230001080016", "usuario" : "414", "caixa" : "2911516", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-21 09:13:16 Duration: 6s403ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "103107", "modelo" : "295", "itens" : "230023156479,230034654156,230030071229,230011353442,230034653449,230011045555,230022974969,230054173850,229968266767,229972447882,230007986177,229976923247,229991055557,229980866078,230014872843,230029415171,229964560223", "usuario" : "414", "caixa" : "1195700", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-21 09:10:03 Duration: 3s218ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 361 1h33m10s 150ms 6m37s 15s484ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 21 07 11 14m11s 1m17s 08 53 6m41s 7s582ms 09 44 14m22s 19s596ms 10 40 22m13s 33s338ms 11 38 52s411ms 1s379ms 12 10 19s301ms 1s930ms 13 12 5m28s 27s358ms 14 28 6m46s 14s521ms 15 68 14m32s 12s827ms 16 46 7m17s 9s503ms 17 11 24s758ms 2s250ms [ User: intelifix - Total duration: 1h33m10s - Times executed: 361 ]
[ Application: [unknown] - Total duration: 1h33m10s - Times executed: 361 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027327, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 09:25:07 Duration: 6m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 15:25:00 Duration: 6m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027339, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 09:54:51 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 276 14m28s 153ms 1m39s 3s147ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 21 00 12 31s679ms 2s639ms 01 12 27s581ms 2s298ms 02 12 27s27ms 2s252ms 03 12 35s590ms 2s965ms 04 12 24s569ms 2s47ms 05 12 27s746ms 2s312ms 06 12 27s285ms 2s273ms 07 12 1m58s 9s911ms 08 12 2m8s 10s701ms 09 12 39s653ms 3s304ms 10 12 39s61ms 3s255ms 11 12 36s904ms 3s75ms 12 12 31s960ms 2s663ms 13 12 32s408ms 2s700ms 14 12 32s39ms 2s669ms 15 12 31s298ms 2s608ms 16 12 27s676ms 2s306ms 17 12 25s742ms 2s145ms 18 12 23s292ms 1s941ms 19 12 23s44ms 1s920ms 20 12 30s918ms 2s576ms 21 12 22s891ms 1s907ms 22 12 22s846ms 1s903ms [ User: intelifix - Total duration: 14m28s - Times executed: 276 ]
[ Application: psql - Total duration: 14m28s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 08:36:46 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 07:26:36 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 03:05:27 Duration: 10s682ms Database: rio User: intelifix Remote: [local] Application: psql
5 240 39s576ms 150ms 224ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 21 01 2 318ms 159ms 04 1 159ms 159ms 08 20 3s313ms 165ms 09 34 5s600ms 164ms 10 25 4s145ms 165ms 11 38 6s215ms 163ms 12 4 660ms 165ms 13 14 2s283ms 163ms 14 28 4s563ms 162ms 15 48 7s989ms 166ms 16 24 4s13ms 167ms 17 2 312ms 156ms [ User: intelifix - Total duration: 39s576ms - Times executed: 240 ]
[ Application: [unknown] - Total duration: 39s576ms - Times executed: 240 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0303;
Date: 2026-07-21 16:31:17 Duration: 224ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0156;
Date: 2026-07-21 08:10:29 Duration: 206ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0271;
Date: 2026-07-21 15:47:23 Duration: 203ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 159 7m13s 185ms 12s90ms 2s728ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 21 00 6 18s448ms 3s74ms 01 6 7s292ms 1s215ms 02 6 6s93ms 1s15ms 03 5 8s874ms 1s774ms 04 6 8s49ms 1s341ms 05 5 12s412ms 2s482ms 07 12 37s250ms 3s104ms 08 12 42s159ms 3s513ms 09 12 46s636ms 3s886ms 10 12 44s170ms 3s680ms 11 12 50s203ms 4s183ms 12 11 35s14ms 3s183ms 13 10 7s326ms 732ms 14 10 34s312ms 3s431ms 15 12 38s180ms 3s181ms 16 8 15s211ms 1s901ms 17 3 2s482ms 827ms 21 5 9s415ms 1s883ms 22 6 10s309ms 1s718ms [ User: intelifix - Total duration: 7m13s - Times executed: 159 ]
[ Application: psql - Total duration: 7m13s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 00:05:13 Duration: 12s90ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 07:35:10 Duration: 8s680ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 14:25:09 Duration: 8s674ms Database: rio User: intelifix Remote: [local] Application: psql
7 145 30s642ms 150ms 4s295ms 211ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 21 08 1 174ms 174ms 09 6 1s58ms 176ms 11 13 2s212ms 170ms 12 3 590ms 196ms 13 8 1s399ms 174ms 14 19 7s515ms 395ms 15 33 5s876ms 178ms 16 34 6s295ms 185ms 17 28 5s519ms 197ms [ User: intelifix - Total duration: 30s642ms - Times executed: 145 ]
[ Application: [unknown] - Total duration: 30s642ms - Times executed: 145 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-21", "data-ate" : "2026-07-21", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 509 }');
Date: 2026-07-21 14:16:40 Duration: 4s295ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-07-21", "data-ate" : "2026-07-21", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 415 }');
Date: 2026-07-21 16:12:06 Duration: 349ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-21", "data-ate" : "2026-07-21", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-21 11:05:20 Duration: 297ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 134 1m2s 150ms 2s593ms 464ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 21 08 24 8s256ms 344ms 09 12 6s476ms 539ms 10 12 5s381ms 448ms 11 26 13s459ms 517ms 12 3 1s461ms 487ms 14 6 2s919ms 486ms 15 32 18s425ms 575ms 16 16 4s982ms 311ms 17 3 900ms 300ms [ User: intelifix - Total duration: 1m2s - Times executed: 134 ]
[ Application: [unknown] - Total duration: 1m2s - Times executed: 134 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0268865) LIMIT 1;
Date: 2026-07-21 15:53:06 Duration: 2s593ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0268543) LIMIT 1;
Date: 2026-07-21 09:05:08 Duration: 1s560ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0268738) LIMIT 1;
Date: 2026-07-21 11:37:13 Duration: 1s524ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 131 42s819ms 158ms 721ms 326ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 21 08 64 18s374ms 287ms 09 66 24s271ms 367ms 10 1 173ms 173ms [ User: intelifix - Total duration: 42s819ms - Times executed: 131 ]
[ Application: [unknown] - Total duration: 42s819ms - Times executed: 131 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0103107);
Date: 2026-07-21 09:10:04 Duration: 721ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0103107);
Date: 2026-07-21 09:09:51 Duration: 645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-07-21 09:09:41 Duration: 587ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 111 51s859ms 280ms 781ms 467ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 21 00 1 653ms 653ms 01 2 747ms 373ms 02 1 408ms 408ms 03 1 465ms 465ms 04 1 318ms 318ms 05 2 760ms 380ms 06 1 355ms 355ms 07 7 2s991ms 427ms 08 13 6s322ms 486ms 09 12 5s686ms 473ms 10 9 4s639ms 515ms 11 9 4s29ms 447ms 12 4 1s862ms 465ms 13 10 4s223ms 422ms 14 9 4s671ms 519ms 15 11 5s770ms 524ms 16 9 4s225ms 469ms 17 6 2s546ms 424ms 20 1 409ms 409ms 21 2 769ms 384ms [ User: lenon - Total duration: 51s859ms - Times executed: 111 ]
[ Application: [unknown] - Total duration: 51s859ms - Times executed: 111 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-21 15:00:03 Duration: 781ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-21 10:09:19 Duration: 774ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-21 15:02:10 Duration: 748ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
11 104 22s103ms 150ms 421ms 212ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 21 01 7 1s221ms 174ms 04 1 179ms 179ms 05 12 3s288ms 274ms 07 11 2s142ms 194ms 08 9 1s630ms 181ms 09 6 1s286ms 214ms 10 8 1s557ms 194ms 11 16 3s472ms 217ms 12 9 1s866ms 207ms 13 1 151ms 151ms 14 7 1s666ms 238ms 15 15 3s210ms 214ms 16 2 430ms 215ms [ User: intelifix - Total duration: 22s103ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 22s103ms - Times executed: 104 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229873571421,229862447596,229862715759,229907768002,229875903343,229875762847,229875626570,229874950916,229875740421,229905653553,229869665865,229872354646,229907840209,229875432635,229876937091,229868906363,229873348996,229870014665', NULL, NULL, 0190, 00);
Date: 2026-07-21 05:10:43 Duration: 421ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229838556566,229838983354,229842399209,229839028587,229862069298,229842068895,229842057783,229852948903,229842373045,229856905271,229845878202,229854504352', NULL, NULL, 0160, 00);
Date: 2026-07-21 05:03:53 Duration: 364ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229914688990,229872382023,229872483952,229874875678,229870567176,229913348590,229872568102,229894981120,229870449208,229885258991,229885519095,229905515054,229869987894', NULL, NULL, 0190, 00);
Date: 2026-07-21 05:15:41 Duration: 348ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 100 58s314ms 359ms 920ms 583ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 21 00 1 851ms 851ms 01 2 1s54ms 527ms 02 1 478ms 478ms 03 1 690ms 690ms 04 1 451ms 451ms 05 2 985ms 492ms 07 4 2s200ms 550ms 08 13 7s615ms 585ms 09 10 5s780ms 578ms 10 9 5s662ms 629ms 11 7 3s942ms 563ms 12 3 1s693ms 564ms 13 10 5s413ms 541ms 14 9 5s800ms 644ms 15 10 6s214ms 621ms 16 9 5s211ms 579ms 17 6 3s353ms 558ms 21 2 914ms 457ms [ User: intelifix - Total duration: 58s314ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 58s314ms - Times executed: 100 ]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-07-21 15:02:10 Duration: 920ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-07-21 08:15:57 Duration: 866ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (427, 18, 1);
Date: 2026-07-21 10:17:20 Duration: 851ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
13 96 40s87ms 169ms 718ms 417ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 21 07 5 2s125ms 425ms 08 8 3s180ms 397ms 09 19 8s458ms 445ms 10 8 3s632ms 454ms 11 7 2s803ms 400ms 12 1 311ms 311ms 13 7 2s621ms 374ms 14 7 2s900ms 414ms 15 16 6s638ms 414ms 16 13 5s705ms 438ms 17 5 1s707ms 341ms [ User: intelifix - Total duration: 40s87ms - Times executed: 96 ]
[ Application: [unknown] - Total duration: 40s87ms - Times executed: 96 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-21 15:21:23 Duration: 718ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-21 14:36:17 Duration: 629ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-21 15:00:18 Duration: 617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 88 36s505ms 150ms 1s375ms 414ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 21 09 10 2s695ms 269ms 10 8 2s465ms 308ms 11 6 1s764ms 294ms 13 8 1s947ms 243ms 14 14 7s838ms 559ms 15 22 9s532ms 433ms 16 14 6s103ms 435ms 17 6 4s156ms 692ms [ User: intelifix - Total duration: 36s505ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 36s505ms - Times executed: 88 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '229977221032,229978006068,230032968390,230035456972,230027459199,230035772941,230034594150,230011780712,230027589011,230026022932,230027683947,230053408084,230053015162,230053313452,229976952947,229977038487,230027752540,229977431030,230019909204,230014007797,230028460017,230044269606,230032968592,229975196366,230043119101,230005419608,229977110112,230008151828,230052581226,230027046376,229985182437,230035795670,229976120307,230035820825,230007532643,230011640923,230010935668,230019633139,229975497686,229975213944,229971275658,229976978808,229975496575,230020973438,229977517378,230052199213,229971049799,230029385471,230024163334,229987188591,229962902541,230034481031,230028389908,229981584869,229989540214,230009722228,229982691128,229976652637,229981611516,230028879406,230044138404,229977072532,229983230002,229985181427,229976839602,229977164157,230044519709,230045982142,230020768591,230021767387,230029271824,230014218806,230027722133,230027631619,229968216381,229978228289,229977483941,230042119092,229986010307,229975888891,230009916870,230035442628,230014033131,230007964761,229979838289,230054232442,230035622343,229977075764,229989210406', '113;1', 'DEFAULT', 00, 0295, '','', '', 00);
Date: 2026-07-21 17:15:12 Duration: 1s375ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '840112295848,1834AF9A3947,8401122A137A,9877E709AA1C,9877E7BDFAA6,9877E702F3AB,743AEF5BB687,1834AF996C17,1834AF9B5403,9877E7BDD912,840112BD15ED,9877E7483CF4,9877E707DFE9,1834AF2879FB,743AEFAD7C4A,1834AF9A10AC,743AEF5B8F89,9877E74AE234,9877E74A5F80,1834AF2882C2,743AEFAD09BF,9877E748B686,84011227CDD2,9877E7BA0B0F,840112805851,743AEF30DB71', '87;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-07-21 14:11:54 Duration: 1s291ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, 'ZTEGD6409448,ZTEGD9710C33,ZTEGD70A7B05,ZTEGD7BA8856,ZTEGDC622560,ZTEGD97C1515,ZTEGDC6209D5,ZTEGD7BC5E57,ZTEGDC60D92E,ZTEGDB009FE8,ZTEGD980055E,ZTEGD9718C2B,ZTEGDB017E08,ZTEGDB1685B3,ZTEGD97B9A59,ZTEGD6405263,ZTEGDC703BD8,ZTEGD64137A7,ZTEGD970F8CC,ZTEGDB007201,ZTEGD64158CE,ZTEGDB14B23F,ZTEGD7BAF4F2,ZTEGD97111A8,ZTEGDB158CB2,ZTEGDB172D68,ZTEGD970C991,ZTEGD64121F6,ZTEGDE3418CA,ZTEGD97F8B39,ZTEGDD304DA7,ZTEGDC6EF15F,ZTEGDD331526,ZTEGD7BB54E5,ZTEGDB177220,ZTEGDB085CB9,ZTEGD7BA2632,ZTEGD97E9252,ZTEGD7BB45A2,ZTEGD64096CA,ZTEGDE341CCE,ZTEGDC6F0B8A,ZTEGD7BB151A,ZTEGD6410DC9,ZTEGDC60E14F,ZTEGD97FA9C5,ZTEGD7BB2EB7,ZTEGD7BB784F,ZTEGDE341A5B,ZTEGDD3080D1,ZTEGDD31EA96,ZTEGD6410B95,ZTEGD640A7F5,ZTEGD9714D85,ZTEGDB007770,ZTEGD7BA2A96,ZTEGD641F732,ZTEGD640076E,ZTEGDC6F727C,ZTEGDB152104,ZTEGD641D2AF', '113;1', 'DEFAULT', 00, 0318, '','', '', 00);
Date: 2026-07-21 15:58:06 Duration: 1s81ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 84 18s815ms 151ms 2s861ms 223ms create table temp0000285824 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 21 07 1 2s861ms 2s861ms 08 9 1s831ms 203ms 09 10 1s812ms 181ms 10 23 4s168ms 181ms 11 11 1s898ms 172ms 12 5 899ms 179ms 13 1 194ms 194ms 14 14 2s915ms 208ms 15 7 1s679ms 239ms 17 3 554ms 184ms [ User: intelifix - Total duration: 18s815ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 18s815ms - Times executed: 84 ]
-
CREATE TABLE temp0000285824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 07:59:51 Duration: 2s861ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"1065362", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 15:25:04 Duration: 300ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"1065362", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 15:48:29 Duration: 279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 71 14s804ms 150ms 1s184ms 208ms create table temp0000226612 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 21 10 5 1s698ms 339ms 13 4 1s801ms 450ms 14 32 5s651ms 176ms 15 24 4s384ms 182ms 16 6 1s267ms 211ms [ User: intelifix - Total duration: 14s804ms - Times executed: 71 ]
[ Application: [unknown] - Total duration: 14s804ms - Times executed: 71 ]
-
CREATE TABLE temp0000226612 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 13:05:40 Duration: 1s184ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226612 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 10:11:33 Duration: 899ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226612 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"229760", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 16:16:55 Duration: 287ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
17 65 13m53s 9s418ms 33s464ms 12s825ms create table temp0000285940 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 21 07 15 2m55s 11s688ms 08 6 1m16s 12s808ms 09 9 1m58s 13s116ms 10 11 2m14s 12s206ms 14 9 2m5s 13s918ms 15 12 2m48s 14s45ms 16 3 35s311ms 11s770ms [ User: intelifix - Total duration: 13m53s - Times executed: 65 ]
[ Application: [unknown] - Total duration: 13m53s - Times executed: 65 ]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 07:11:28 Duration: 33s464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:48:19 Duration: 16s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 15:34:53 Duration: 16s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 64 8m44s 1s264ms 34s355ms 8s200ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 21 07 2 11s135ms 5s567ms 08 5 30s622ms 6s124ms 09 5 37s14ms 7s402ms 10 3 22s743ms 7s581ms 11 5 56s999ms 11s399ms 12 4 17s257ms 4s314ms 13 7 56s865ms 8s123ms 14 6 24s742ms 4s123ms 15 6 1m36s 16s99ms 16 8 1m2s 7s798ms 17 13 1m48s 8s343ms [ User: intelifix - Total duration: 8m44s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 8m44s - Times executed: 64 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 15:37:34 Duration: 34s355ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 17:24:26 Duration: 34s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 11:59:37 Duration: 33s131ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 64 15s389ms 157ms 331ms 240ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 21 07 3 760ms 253ms 08 6 1s589ms 264ms 09 11 2s921ms 265ms 10 5 1s316ms 263ms 11 4 1s46ms 261ms 13 4 1s138ms 284ms 14 12 2s408ms 200ms 15 14 2s995ms 213ms 16 3 798ms 266ms 17 2 414ms 207ms [ User: intelifix - Total duration: 15s389ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 15s389ms - Times executed: 64 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"271", "usuario" :"507", "tipo" :"N", "itens" :"005", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-21 08:09:29 Duration: 331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"189", "usuario" :"507", "tipo" :"N", "itens" :"0010", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-21 09:02:28 Duration: 322ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"42", "usuario" :"418", "tipo" :"N", "itens" :"003", "nota-fiscal" :"10657", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-21 15:20:23 Duration: 320ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 63 1m45s 194ms 26s368ms 1s671ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 21 07 6 2s852ms 475ms 08 2 1s113ms 556ms 09 21 9s162ms 436ms 10 6 19s168ms 3s194ms 11 2 33s967ms 16s983ms 13 7 2s458ms 351ms 14 6 19s43ms 3s173ms 15 8 11s188ms 1s398ms 16 5 6s375ms 1s275ms [ User: intelifix - Total duration: 1m45s - Times executed: 63 ]
[ Application: psql - Total duration: 1m45s - Times executed: 63 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027347);
Date: 2026-07-21 11:23:00 Duration: 26s368ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027360);
Date: 2026-07-21 14:43:42 Duration: 13s184ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027343);
Date: 2026-07-21 10:35:42 Duration: 9s772ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m21s 8m10s 4m49s 3 14m29s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 21 05 3 14m29s 4m49s [ User: intelifix - Total duration: 14m29s - Times executed: 3 ]
[ Application: psql - Total duration: 14m29s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-21 05:08:12 Duration: 8m10s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-21 05:12:10 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-21 05:14:31 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s263ms 9m40s 2m36s 48 2h5m27s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 21 07 3 8m34s 2m51s 08 3 8m6s 2m42s 09 3 10m26s 3m28s 10 3 9m8s 3m2s 11 3 8m36s 2m52s 12 3 7m47s 2m35s 13 3 7m10s 2m23s 14 3 8m52s 2m57s 15 3 9m20s 3m6s 16 3 8m10s 2m43s 17 3 7m46s 2m35s 18 3 6m4s 2m1s 19 3 6m 2m 20 3 7m32s 2m30s 21 3 6m6s 2m2s 22 3 5m41s 1m53s [ User: intelifix - Total duration: 2h5m27s - Times executed: 48 ]
[ Application: psql - Total duration: 2h5m27s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-21 09:14:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-21 15:13:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-21 10:13:41 Duration: 8m39s Database: rio User: intelifix Remote: [local] Application: psql
3 176ms 5m9s 1m37s 48 1h17m40s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 21 07 3 4m53s 1m37s 08 3 4m36s 1m32s 09 3 6m1s 2m 10 3 5m39s 1m53s 11 3 5m23s 1m47s 12 3 5m11s 1m43s 13 3 4m53s 1m37s 14 3 5m45s 1m55s 15 3 6m6s 2m2s 16 3 4m37s 1m32s 17 3 4m26s 1m28s 18 3 3m41s 1m13s 19 3 3m59s 1m19s 20 3 4m42s 1m34s 21 3 3m50s 1m16s 22 3 3m52s 1m17s [ User: intelifix - Total duration: 1h17m40s - Times executed: 48 ]
[ Application: psql - Total duration: 1h17m40s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-21 15:20:21 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-21 09:21:20 Duration: 4m53s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-21 14:19:33 Duration: 4m44s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s730ms 1m34s 48s613ms 4 3m14s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 21 20 2 1m35s 47s551ms 23 2 1m39s 49s676ms [ User: intelifix - Total duration: 3m14s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m14s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-21 23:16:55 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-21 20:09:03 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-21 20:10:53 Duration: 4s875ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 411ms 1m5s 32s35ms 4 2m8s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 21 20 2 1m2s 31s248ms 23 2 1m5s 32s821ms [ User: intelifix - Total duration: 2m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m8s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-21 23:13:31 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-21 20:05:46 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-21 20:10:18 Duration: 610ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 150ms 6m37s 15s484ms 361 1h33m10s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 21 07 11 14m11s 1m17s 08 53 6m41s 7s582ms 09 44 14m22s 19s596ms 10 40 22m13s 33s338ms 11 38 52s411ms 1s379ms 12 10 19s301ms 1s930ms 13 12 5m28s 27s358ms 14 28 6m46s 14s521ms 15 68 14m32s 12s827ms 16 46 7m17s 9s503ms 17 11 24s758ms 2s250ms [ User: intelifix - Total duration: 1h33m10s - Times executed: 361 ]
[ Application: [unknown] - Total duration: 1h33m10s - Times executed: 361 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027327, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 09:25:07 Duration: 6m37s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027367, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 15:25:00 Duration: 6m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027339, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-21 09:54:51 Duration: 6m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s750ms 15s537ms 13s662ms 11 2m30s create table temp0000285984 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 21 09 11 2m30s 13s662ms [ User: intelifix - Total duration: 2m30s - Times executed: 11 ]
[ Application: [unknown] - Total duration: 2m30s - Times executed: 11 ]
-
CREATE TABLE temp0000285984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:42:22 Duration: 15s537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:42:46 Duration: 15s340ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285984 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:27:02 Duration: 15s108ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s613ms 37s968ms 13s581ms 19 4m18s create table temp0000286034 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 21 13 16 3m41s 13s848ms 16 3 36s469ms 12s156ms [ User: intelifix - Total duration: 4m18s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m18s - Times executed: 19 ]
-
CREATE TABLE temp0000286034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 13:27:47 Duration: 37s968ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 13:38:17 Duration: 14s184ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286034 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 13:37:27 Duration: 13s607ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s389ms 34s838ms 13s263ms 43 9m30s create table temp0000285938 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 21 07 1 10s641ms 10s641ms 09 6 1m19s 13s170ms 10 6 1m14s 12s439ms 11 5 1m8s 13s628ms 13 1 12s29ms 12s29ms 14 10 2m8s 12s894ms 15 8 1m39s 12s492ms 16 6 1m36s 16s160ms [ User: intelifix - Total duration: 9m30s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 9m30s - Times executed: 43 ]
-
CREATE TABLE temp0000285938 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 16:25:14 Duration: 34s838ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285938 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 14:36:56 Duration: 16s777ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285938 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 15:10:58 Duration: 15s600ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s418ms 33s464ms 12s825ms 65 13m53s create table temp0000285940 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 21 07 15 2m55s 11s688ms 08 6 1m16s 12s808ms 09 9 1m58s 13s116ms 10 11 2m14s 12s206ms 14 9 2m5s 13s918ms 15 12 2m48s 14s45ms 16 3 35s311ms 11s770ms [ User: intelifix - Total duration: 13m53s - Times executed: 65 ]
[ Application: [unknown] - Total duration: 13m53s - Times executed: 65 ]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 07:11:28 Duration: 33s464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:48:19 Duration: 16s480ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 15:34:53 Duration: 16s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s521ms 14s488ms 12s316ms 12 2m27s create table temp0000285978 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 21 09 12 2m27s 12s316ms [ User: intelifix - Total duration: 2m27s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m27s - Times executed: 12 ]
-
CREATE TABLE temp0000285978 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:14:35 Duration: 14s488ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285978 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:15:33 Duration: 13s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285978 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-21 09:08:29 Duration: 13s244ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s264ms 34s355ms 8s200ms 64 8m44s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 21 07 2 11s135ms 5s567ms 08 5 30s622ms 6s124ms 09 5 37s14ms 7s402ms 10 3 22s743ms 7s581ms 11 5 56s999ms 11s399ms 12 4 17s257ms 4s314ms 13 7 56s865ms 8s123ms 14 6 24s742ms 4s123ms 15 6 1m36s 16s99ms 16 8 1m2s 7s798ms 17 13 1m48s 8s343ms [ User: intelifix - Total duration: 8m44s - Times executed: 64 ]
[ Application: [unknown] - Total duration: 8m44s - Times executed: 64 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 15:37:34 Duration: 34s355ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 17:24:26 Duration: 34s188ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-21', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-21 11:59:37 Duration: 33s131ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 2s839ms 5s544ms 4s122ms 37 2m32s create table temp0000285940 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 21 07 7 21s846ms 3s120ms 08 10 41s713ms 4s171ms 09 4 15s686ms 3s921ms 10 5 21s303ms 4s260ms 11 7 30s359ms 4s337ms 14 2 10s750ms 5s375ms 15 2 10s856ms 5s428ms [ User: intelifix - Total duration: 2m32s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 2m32s - Times executed: 37 ]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 15:09:12 Duration: 5s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 14:23:19 Duration: 5s455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285940 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-21 15:09:26 Duration: 5s311ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 662ms 11s540ms 3s986ms 36 2m23s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 21 08 2 15s599ms 7s799ms 09 3 21s868ms 7s289ms 10 3 19s854ms 6s618ms 11 2 15s568ms 7s784ms 12 1 3s972ms 3s972ms 13 3 6s625ms 2s208ms 14 2 16s104ms 8s52ms 15 1 3s242ms 3s242ms 16 3 18s447ms 6s149ms 17 2 8s696ms 4s348ms 18 2 1s589ms 794ms 19 3 2s886ms 962ms 20 3 3s397ms 1s132ms 21 3 2s993ms 997ms 22 3 2s682ms 894ms [ User: intelifix - Total duration: 2m23s - Times executed: 36 ]
[ Application: psql - Total duration: 2m23s - Times executed: 36 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-21 14:20:12 Duration: 11s540ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-21 09:20:12 Duration: 10s585ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-21 11:20:10 Duration: 9s64ms Database: rio User: intelifix Remote: [local] Application: psql
15 195ms 10s849ms 3s342ms 36 2m select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 21 07 3 14s113ms 4s704ms 08 1 10s849ms 10s849ms 09 10 29s974ms 2s997ms 10 3 7s25ms 2s341ms 11 2 2s890ms 1s445ms 13 4 19s677ms 4s919ms 14 3 10s160ms 3s386ms 15 7 14s572ms 2s81ms 16 3 11s75ms 3s691ms [ User: intelifix - Total duration: 2m - Times executed: 36 ]
[ Application: psql - Total duration: 2m - Times executed: 36 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027319);
Date: 2026-07-21 08:30:42 Duration: 10s849ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027313);
Date: 2026-07-21 07:12:53 Duration: 10s360ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027367);
Date: 2026-07-21 15:17:59 Duration: 10s32ms Database: rio User: intelifix Remote: [local] Application: psql
16 153ms 1m39s 3s147ms 276 14m28s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 21 00 12 31s679ms 2s639ms 01 12 27s581ms 2s298ms 02 12 27s27ms 2s252ms 03 12 35s590ms 2s965ms 04 12 24s569ms 2s47ms 05 12 27s746ms 2s312ms 06 12 27s285ms 2s273ms 07 12 1m58s 9s911ms 08 12 2m8s 10s701ms 09 12 39s653ms 3s304ms 10 12 39s61ms 3s255ms 11 12 36s904ms 3s75ms 12 12 31s960ms 2s663ms 13 12 32s408ms 2s700ms 14 12 32s39ms 2s669ms 15 12 31s298ms 2s608ms 16 12 27s676ms 2s306ms 17 12 25s742ms 2s145ms 18 12 23s292ms 1s941ms 19 12 23s44ms 1s920ms 20 12 30s918ms 2s576ms 21 12 22s891ms 1s907ms 22 12 22s846ms 1s903ms [ User: intelifix - Total duration: 14m28s - Times executed: 276 ]
[ Application: psql - Total duration: 14m28s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 08:36:46 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 07:26:36 Duration: 1m31s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-21 03:05:27 Duration: 10s682ms Database: rio User: intelifix Remote: [local] Application: psql
17 271ms 8s584ms 3s83ms 61 3m8s create table temp0000284750 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 21 07 2 5s157ms 2s578ms 08 17 45s445ms 2s673ms 09 10 25s179ms 2s517ms 10 2 7s980ms 3s990ms 11 4 19s138ms 4s784ms 13 15 44s203ms 2s946ms 14 4 13s433ms 3s358ms 15 2 8s887ms 4s443ms 16 4 14s876ms 3s719ms 17 1 3s796ms 3s796ms [ User: intelifix - Total duration: 3m8s - Times executed: 61 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 61 ]
-
CREATE TABLE temp0000284750 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "103107", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "21-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-21 09:09:19 Duration: 8s584ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284750 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "21-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-21 11:54:09 Duration: 6s419ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284750 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "21-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-21 10:48:42 Duration: 5s971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 185ms 12s90ms 2s728ms 159 7m13s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 21 00 6 18s448ms 3s74ms 01 6 7s292ms 1s215ms 02 6 6s93ms 1s15ms 03 5 8s874ms 1s774ms 04 6 8s49ms 1s341ms 05 5 12s412ms 2s482ms 07 12 37s250ms 3s104ms 08 12 42s159ms 3s513ms 09 12 46s636ms 3s886ms 10 12 44s170ms 3s680ms 11 12 50s203ms 4s183ms 12 11 35s14ms 3s183ms 13 10 7s326ms 732ms 14 10 34s312ms 3s431ms 15 12 38s180ms 3s181ms 16 8 15s211ms 1s901ms 17 3 2s482ms 827ms 21 5 9s415ms 1s883ms 22 6 10s309ms 1s718ms [ User: intelifix - Total duration: 7m13s - Times executed: 159 ]
[ Application: psql - Total duration: 7m13s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 00:05:13 Duration: 12s90ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 07:35:10 Duration: 8s680ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-21 14:25:09 Duration: 8s674ms Database: rio User: intelifix Remote: [local] Application: psql
19 194ms 26s368ms 1s671ms 63 1m45s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 21 07 6 2s852ms 475ms 08 2 1s113ms 556ms 09 21 9s162ms 436ms 10 6 19s168ms 3s194ms 11 2 33s967ms 16s983ms 13 7 2s458ms 351ms 14 6 19s43ms 3s173ms 15 8 11s188ms 1s398ms 16 5 6s375ms 1s275ms [ User: intelifix - Total duration: 1m45s - Times executed: 63 ]
[ Application: psql - Total duration: 1m45s - Times executed: 63 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027347);
Date: 2026-07-21 11:23:00 Duration: 26s368ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027360);
Date: 2026-07-21 14:43:42 Duration: 13s184ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027343);
Date: 2026-07-21 10:35:42 Duration: 9s772ms Database: rio User: intelifix Remote: [local] Application: psql
20 151ms 4s763ms 801ms 1,312 17m31s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 21 07 33 10s604ms 321ms 08 127 1m41s 802ms 09 128 2m24s 1s127ms 10 202 2m29s 741ms 11 113 1m41s 894ms 12 36 37s517ms 1s42ms 13 103 1m30s 879ms 14 207 2m48s 814ms 15 185 2m15s 731ms 16 117 1m13s 624ms 17 61 38s918ms 638ms [ User: intelifix - Total duration: 17m31s - Times executed: 1312 ]
[ Application: [unknown] - Total duration: 17m31s - Times executed: 1312 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46934, 409, '246144516880', '',077,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 13:57:44 Duration: 4s763ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (267745, 504, 'CP234232LT9,D4925EF89520,544D4242007239DD,D4925EF89523$CP2317320ZA,D4925E9483DA,544D424200681CEC,D4925E9483DD$CP234232M4A,D4925EF8A0C3,544D424200723B28,D4925EF8A0C6$CP2305324NG,D4925E193D84,544D424200638B3F,D4925E193D87$CP240932JFU,08C7F52E0212,544D424200784DEF,08C7F52E0215$CP2317320Y4,D4925E94827B,544D424200681CC5,D4925E94827E$CP2327324CD,D4925ED54391,544D4242006DB076,D4925ED54394$CP234532FGG,08C7F504242F,544D4242007373EC,08C7F5042432$CP240932N8H,08C7F52E92B4,544D424200785E01,08C7F52E92B7$CP233532236,D4925EE9ABBC,544D4242006F53B5,D4925EE9ABBF$CP24093207G,08C7F52B473C,544D424200780049,08C7F52B473F$CP2310327D3,D4925E34880B,544D42420065CF4D,D4925E34880E$CP240332N71,08C7F52420A3,544D42420076FFD0,08C7F52420A6$CP230132RVB,D4925E054287,544D424200617E0E,D4925E05428A$CP234532946,08C7F5033033,544D4242007358D0,08C7F5033036$CP232532K2A,D4925ECE6C8E,544D4242006D6474,D4925ECE6C91$CP232032F3G,D4925EA5C588,544D42420069F06E,D4925EA5C58B$CP2250321M5,A0B53CF963F2,544D42420060AEE8,A0B53CF963F5$CP232032F27,D4925EA5C40E,544D42420069F044,D4925EA5C411$CP232232A34,D4925EBCF114,544D4242006BB6AF,D4925EBCF117$CP2305323GQ,D4925E1910A8,544D424200638643,D4925E1910AB$CP234232YVT,D4925EFA3D37,544D4242007268FC,D4925EFA3D3A$CP230232G0Y,D4925E088694,544D42420061DA39,D4925E088697$CP230232PLH,D4925E09A925,544D42420061FA82,D4925E09A928$CP22413213P,A0B53CC264FC,544D4242005E94D3,A0B53CC264FF$CP2411322SU,08C7F52FEC1D,544D424200788462,08C7F52FEC20$CP2342323V3,D4925EF60C63,544D42420071F1C8,D4925EF60C66$CP2325320NK,D4925EC92C08,544D4242006CFCDA,D4925EC92C0B$CP232532MCA,D4925ECEC4BA,544D4242006D6E40,D4925ECEC4BD$CP232032MB6,D4925EA6B459,544D4242006A0AF7,D4925EA6B45C$CP240932C56,08C7F52D0FFC,544D424200783309,08C7F52D0FFF$CP2411320H6,08C7F52F9454,544D424200787AA1,08C7F52F9457$CP2305323D2,D4925E190C67,544D4242006385CA,D4925E190C6A$CP23033299M,D4925E14F8D6,544D42420062DAB7,D4925E14F8D9$CP232032BAR,D4925EA534CB,544D42420069E059,D4925EA534CE$CP2323326U9,D4925EBB5BD4,544D4242006C8A7C,D4925EBB5BD7$CP2322323EM,D4925EB35964,544D4242006B9A64,D4925EB35967$CP2327321EW,D4925ED4D3A1,544D4242006DA406,D4925ED4D3A4$CP232532QKQ,D4925ECF4032,544D4242006D7BF8,D4925ECF4035$CP2305322ZG,D4925E18FC9E,544D424200638409,D4925E18FCA1', '',0298,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 08:22:25 Duration: 4s441ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (127696, 397, '854271000000172,241627531829,241613900207,241642271427,230056962742,241640779899,241625666876,241632960709,230056755976,241633636262,241633720615,241624015357,241633759305,241640019411,241612018686,241642255970,241613418991,241640049212,241633591332,241632559603,241640091921,241613125978,241623962749,241613695259,241640108992,241611512746,241611637280,241613510820,241626701232,241625497185,241640536363,241611263350,241643776466,241640025977,241640735272,241622935364,241627230509,241613677176,241640079292,241612579909,241642265870', '',0324,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-21 15:43:26 Duration: 4s329ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 21 10 1 0ms 0ms 12 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms [ User: intelifix - Total duration: 2s65ms - Times executed: 3 ]
[ User: etiquetas - Total duration: 186ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1s677ms - Times executed: 3 ]
[ Application: psql - Total duration: 574ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,391 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 16 FATAL entries
- 3816 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,668 Max number of times the same event was reported
- 3,838 Total events found
Rank Times reported Error 1 3,668 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 21 00 59 01 60 02 59 03 59 04 58 05 60 06 64 07 183 08 335 09 355 10 358 11 256 12 126 13 198 14 323 15 360 16 243 17 164 18 60 19 59 20 59 21 60 22 60 23 50 - ERROR: prepared statement "_PLAN0000000029640290" does not exist
- ERROR: prepared statement "_PLAN000000002961EB70" does not exist
- ERROR: prepared statement "_PLAN0000000029641960" does not exist
Statement: DEALLOCATE "_PLAN0000000029640290"
Date: 2026-07-21 00:00:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000002961EB70"
Date: 2026-07-21 00:01:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029641960"
Date: 2026-07-21 00:02:41 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 21 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-21 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-21 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-21 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 21 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-21 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-21 08:20:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-21 08:40:11 Database: brasilia Application: psql User: intelifix Remote: [local]
4 31 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 21 09 2 10 17 13 1 14 11 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "1942" at character 219
Statement: select * from rs_caixa_qr(3304027 ])
Date: 2026-07-21 09:04:04 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3304027 ])
Date: 2026-07-21 09:04:04 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: CREATE TABLE temp0000285974 AS SELECT * FROM RS_LOTES_LISTA('{ "oficina" :"6", "cliente" :"0", "desde" :"16-07-2026", "ate" :"21-07-2026", "nota-fiscal":"'1942", "modelo" :"189", "lotes" :"", "lote-stone" :"" }')
Date: 2026-07-21 10:11:40 Database: rio Application: [unknown] User: intelifix Remote: [local]
5 21 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 21 05 4 10 17 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-21 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-21 05:32:06 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-21 05:32:07 Database: contagem Application: psql User: intelifix Remote: [local]
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 21 03 7 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-21 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-21 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-21 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
7 6 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 21 00 1 06 3 10 1 12 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-21 00:02:24 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-21 06:02:19 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-21 06:34:29 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
8 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 21 07 1 08 3 - LOG: process 187232 still waiting for ShareLock on transaction 3015805 after 1000.184 ms
- LOG: process 199603 still waiting for ShareLock on transaction 3020701 after 1000.187 ms
- LOG: process 199603 still waiting for ShareLock on transaction 3020701 after 5011.038 ms
Detail: Process holding the lock: 191182. Wait queue: 187232.
Context: while updating tuple (74196,19) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-21 07:25:10 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 206164. Wait queue: 199603.
Context: while updating tuple (74197,17) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-21 08:35:13 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 206164. Wait queue: 199603.
Context: while updating tuple (74197,17) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-21 08:35:17 Database: rio Application: psql User: intelifix Remote: [local]
9 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 21 13 2 - ERROR: column "d4925e1641cf" does not exist at character 27
- ERROR: column "d4925e1641cf" does not exist at character 27
Statement: select * from rs_caixa_qr(D4925E1641CF)
Date: 2026-07-21 13:24:04 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(D4925E1641CF)
Date: 2026-07-21 13:24:04 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 21 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-21 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-21 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 21 14 2 - ERROR: trailing junk after numeric literal at or near "582FF79B57B6" at character 27
- ERROR: trailing junk after numeric literal at or near "582FF79B57B6" at character 27
Statement: select * from rs_caixa_qr(582FF79B57B6)
Date: 2026-07-21 14:40:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(582FF79B57B6)
Date: 2026-07-21 14:40:02 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 21 07 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000285940"
Date: 2026-07-21 07:11:42
13 1 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 21 17 1 - FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-07-21 17:59:34 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
14 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 21 07 1 - LOG: process 191182 still waiting for AccessExclusiveLock on relation 2696713 of database 358220 after 1000.108 ms
Detail: Process holding the lock: 191498. Wait queue: 191182.
Statement: DROP TABLE IF EXISTS temp0000285940;Date: 2026-07-21 07:11:42 Database: rio Application: [unknown] User: intelifix Remote: [local]
15 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 21 03 1 - LOG: database system was shut down at 2026-07-21 03:05:01 -03
Date: 2026-07-21 03:05:03