pgBadger-
Global information
- Generated on Mon Aug 3 23:50:15 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 35,529 log entries in 13s
- Log start from 2026-08-03 00:00:19 to 2026-08-03 23:50:05
-
Overview
Global Stats
- 360 Number of unique normalized queries
- 5,446 Number of queries
- 9h55m27s Total query duration
- 2026-08-03 00:02:04 First query
- 2026-08-03 23:43:25 Last query
- 5 queries/s at 2026-08-03 14:07:58 Query peak
- 9h55m27s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h55m27s Execute total duration
- 3,042 Number of events
- 16 Number of unique normalized events
- 2,904 Max number of times the same event was reported
- 0 Number of cancellation
- 459 Total number of automatic vacuums
- 831 Total number of automatic analyzes
- 11 Number temporary file
- 238.45 MiB Max size of temporary file
- 110.25 MiB Average size of temporary file
- 347 Total number of sessions
- 8 sessions at 2026-08-03 09:20:55 Session peak
- 12d16h12m15s Total duration of sessions
- 52m36s Average duration of sessions
- 15 Average queries per session
- 1m42s Average queries duration per session
- 50m53s Average idle time per session
- 358 Total number of connections
- 6 connections/s at 2026-08-03 06:02:02 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-03 14:07:58 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-03 16:07:26 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-03 23:43:21 Date
Queries duration
Key values
- 9h55m27s 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) Aug 03 00 22 0ms 25s29ms 5s293ms 4s182ms 4s893ms 1m11s 01 12 0ms 4s229ms 2s66ms 3s799ms 4s159ms 4s606ms 02 12 0ms 4s367ms 2s97ms 3s878ms 4s127ms 4s626ms 03 13 0ms 4s438ms 1s740ms 1s134ms 4s415ms 5s22ms 04 12 0ms 4s80ms 2s60ms 3s799ms 4s167ms 4s477ms 05 17 0ms 9m44s 1m7s 4s592ms 2m31s 9m44s 06 17 0ms 11s455ms 3s245ms 3s744ms 4s90ms 34s674ms 07 172 0ms 14m49s 14s914ms 1m6s 4m50s 14m49s 08 469 150ms 6m32s 3s762ms 42s9ms 3m51s 6m32s 09 649 152ms 16m19s 7s483ms 3m21s 10m36s 18m16s 10 672 150ms 13m9s 5s241ms 1m59s 6m36s 13m20s 11 568 150ms 23m52s 9s811ms 5m30s 9m8s 33m11s 12 181 0ms 10m54s 7s139ms 12s475ms 1m34s 11m1s 13 135 0ms 5m28s 5s606ms 10s869ms 41s952ms 5m57s 14 449 150ms 7m2s 4s575ms 49s902ms 5m10s 7m13s 15 556 151ms 7m22s 3s671ms 41s501ms 4m24s 9m33s 16 560 150ms 7m37s 3s881ms 1m19s 3m58s 7m56s 17 357 0ms 10m44s 4s384ms 45s940ms 2m12s 10m52s 18 26 0ms 5m36s 23s703ms 4s555ms 47s49ms 5m36s 19 21 0ms 5m32s 28s891ms 4s19ms 45s15ms 5m32s 20 128 0ms 11m39s 12s829ms 1m2s 2m8s 11m39s 21 31 0ms 5m47s 20s807ms 7s973ms 47s902ms 5m47s 22 27 0ms 5m37s 23s991ms 8s100ms 48s949ms 5m37s 23 340 0ms 1m28s 5s855ms 1m6s 1m10s 1m53s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 00 4 0 568ms 0ms 0ms 192ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 286ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 2 0 226ms 0ms 0ms 0ms 07 119 0 18s748ms 4s883ms 48s147ms 7m53s 08 324 0 4s122ms 9s473ms 16s418ms 5m17s 09 471 0 8s65ms 32s603ms 2m27s 10m37s 10 509 0 6s268ms 28s471ms 1m54s 6m57s 11 410 0 11s588ms 11s337ms 5m13s 11m44s 12 112 0 10s958ms 5s220ms 12s311ms 3m37s 13 86 0 7s480ms 1s931ms 5s35ms 3m17s 14 340 0 5s442ms 14s114ms 27s950ms 6m55s 15 421 0 3s912ms 11s435ms 30s476ms 5m57s 16 428 0 4s140ms 15s20ms 41s584ms 6m56s 17 242 0 5s917ms 8s466ms 40s162ms 4m23s 18 10 0 58s636ms 0ms 0ms 3m16s 19 6 0 1m36s 0ms 0ms 3m22s 20 22 89 14s244ms 9s494ms 1m2s 3m56s 21 11 0 54s507ms 0ms 219ms 3m22s 22 6 0 1m39s 0ms 0ms 3m30s 23 20 320 5s855ms 1m 1m6s 1m53s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 03 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 Aug 03 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 15 15.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 17 17.00 0.00% 12 0 4 4.00 0.00% 13 0 8 8.00 0.00% 14 0 19 19.00 0.00% 15 0 10 10.00 0.00% 16 0 19 19.00 0.00% 17 0 7 7.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 5 5.00 0.00% Day Hour Count Average / Second Aug 03 00 16 0.00/s 01 7 0.00/s 02 14 0.00/s 03 13 0.00/s 04 8 0.00/s 05 9 0.00/s 06 13 0.00/s 07 18 0.01/s 08 21 0.01/s 09 25 0.01/s 10 21 0.01/s 11 20 0.01/s 12 15 0.00/s 13 17 0.00/s 14 26 0.01/s 15 20 0.01/s 16 23 0.01/s 17 18 0.01/s 18 7 0.00/s 19 8 0.00/s 20 13 0.00/s 21 8 0.00/s 22 8 0.00/s 23 10 0.00/s Day Hour Count Average Duration Average idle time Aug 03 00 4 47m30s 47m1s 01 14 1h1m4s 1h1m2s 02 7 1h1s 59m57s 03 12 27m32s 27m30s 04 8 1h3m 1h2m57s 05 8 54m7s 51m44s 06 8 58m11s 58m4s 07 14 53m19s 50m16s 08 17 56m5s 54m21s 09 25 52m48s 49m34s 10 22 56m8s 53m28s 11 20 58m44s 54m6s 12 20 54m1s 52m56s 13 14 1h22s 59m28s 14 25 45m17s 43m54s 15 21 53m26s 51m49s 16 24 48m47s 47m16s 17 20 50m13s 48m55s 18 14 1h8s 59m24s 19 8 54m6s 52m50s 20 10 43m9s 40m25s 21 10 1h1m9s 1h5s 22 9 54m46s 53m35s 23 13 35m6s 32m33s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-08-03 06:02:02 Date
Connections per database
Key values
- rio Main Database
- 358 connections Total
Connections per user
Key values
- intelifix Main User
- 358 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-03 09:20:55 Date
Histogram of session times
Key values
- 276 3600000-28800000ms duration
Sessions per database
Key values
- brasilia Main Database
- 347 sessions Total
Sessions per user
Key values
- intelifix Main User
- 347 sessions Total
Sessions per host
Key values
- [local] Main Host
- 347 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 28,142 buffers Checkpoint Peak
- 2026-08-03 16:34:39 Date
- 270.039 seconds Highest write time
- 0.340 seconds Sync time
Checkpoints Wal files
Key values
- 16 files Wal files usage Peak
- 2026-08-03 16:34:39 Date
Checkpoints distance
Key values
- 529.86 Mo Distance Peak
- 2026-08-03 16:34:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 03 00 14,186 269.923s 0.004s 269.984s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 14 0.054s 0.061s 0.163s 04 0 0s 0s 0s 05 6,085 609.343s 0.173s 609.606s 06 1,024 102.78s 0.003s 102.81s 07 32,365 2,042.762s 0.647s 2,043.551s 08 45,994 3,061.353s 0.932s 3,062.495s 09 86,482 3,225.866s 1.459s 3,227.687s 10 89,667 3,238.318s 1.138s 3,239.708s 11 131,850 3,238.121s 1.341s 3,239.757s 12 23,194 1,809.207s 0.463s 1,809.888s 13 11,805 1,167.847s 0.583s 1,168.55s 14 53,850 3,073.438s 0.88s 3,074.501s 15 64,823 3,219.232s 1.09s 3,220.488s 16 74,879 3,052.114s 0.988s 3,053.346s 17 35,139 2,403.533s 0.531s 2,404.258s 18 3,070 307.357s 0.183s 307.606s 19 23 2.329s 0.015s 2.354s 20 755 320.456s 0.056s 320.589s 21 2,329 233.963s 0.098s 234.135s 22 2,017 202.459s 0.165s 202.677s 23 409 41.11s 0.024s 41.169s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 03 00 0 0 5 46 0.002s 0.001s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 10 0.038s 0.02s 04 0 0 0 0 0s 0s 05 0 0 3 132 0.089s 0.013s 06 0 0 0 7 0.001s 0.001s 07 0 0 16 1,944 0.061s 0.011s 08 0 0 24 4,995 0.048s 0.012s 09 0 0 51 7,134 0.052s 0.012s 10 0 0 38 6,041 0.042s 0.012s 11 0 0 74 6,471 0.065s 0.012s 12 0 0 6 3,258 0.063s 0.012s 13 0 0 4 3,119 0.071s 0.012s 14 0 0 24 5,690 0.040s 0.012s 15 0 0 27 6,108 0.028s 0.012s 16 0 0 37 5,928 0.055s 0.012s 17 0 0 16 4,735 0.046s 0.011s 18 0 0 1 200 0.083s 0.019s 19 0 0 0 3 0.009s 0.005s 20 0 0 1 81 0.017s 0.004s 21 0 0 1 413 0.012s 0.01s 22 0 0 1 407 0.064s 0.016s 23 0 0 0 34 0.009s 0.006s Day Hour Count Avg time (sec) Aug 03 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 Aug 03 00 77,324.00 kB 77,324.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 547.00 kB 34,850.50 kB 04 0.00 kB 0.00 kB 05 7,660.17 kB 12,334.83 kB 06 3,640.00 kB 15,229.00 kB 07 23,820.73 kB 40,893.27 kB 08 33,006.67 kB 70,374.17 kB 09 68,662.67 kB 149,935.08 kB 10 51,904.42 kB 129,471.83 kB 11 101,847.17 kB 156,912.33 kB 12 8,267.58 kB 79,080.50 kB 13 4,701.92 kB 25,381.83 kB 14 33,294.08 kB 68,628.00 kB 15 37,384.17 kB 85,108.92 kB 16 49,969.33 kB 138,374.00 kB 17 24,547.91 kB 106,145.55 kB 18 1,332.83 kB 49,914.83 kB 19 179.00 kB 34,036.00 kB 20 6,686.67 kB 29,328.33 kB 21 1,658.57 kB 18,278.57 kB 22 1,532.57 kB 9,582.00 kB 23 177.00 kB 5,435.80 kB -
Temporary Files
Size of temporary files
Key values
- 476.91 MiB Temp Files size Peak
- 2026-08-03 05:32:01 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-03 05:30:39 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.87 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 1 104.00 MiB 104.00 MiB 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 926.53 MiB 71.12 MiB 238.45 MiB 115.82 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-03 05:32:09 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-03 05:32:01 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 182.17 MiB 91.09 MiB 91.09 MiB 91.09 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-03 05:30:42 Duration: 40s418ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-03 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-03 11:21:00 Duration: 23m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-03 09:37:58 Duration: 16m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-03 09:42:47 Duration: 10m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Queries generating the largest temporary files
Rank Size Query 1 238.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 238.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-03 10:53:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 91.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-03 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 91.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-03 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.78 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.70 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 78.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 71.12 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-03 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 3.19 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-03 11:21:47 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 3.19 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-03 11:21:47 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (82) Main table analyzed (database rio)
- 831 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 82 brasilia.pg_catalog.pg_attribute 46 rio.public.usuarios 45 rio.pg_catalog.pg_class 40 rio.public.temp0000287226 34 rio.pg_catalog.pg_type 34 rio.public.temp0000287316 32 rio.public.temp0000287300 28 brasilia.pg_catalog.pg_class 21 rio.pg_catalog.pg_index 21 brasilia.pg_catalog.pg_type 19 rio.auditor.auditor_2026_08 18 contagem.pg_catalog.pg_attribute 18 rio.public.temp0000287264 17 contagem.public.usuarios 16 rio.pg_catalog.pg_depend 16 brasilia.auditor.auditor_2026_08 15 contagem.public.temp0000226740 14 rio.public.temp0000287222 12 brasilia.public.temp0000237382 12 brasilia.public.temp0000237340 12 brasilia.public.temp0000237372 12 brasilia.pg_catalog.pg_index 11 brasilia.public.temp0000237378 10 contagem.auditor.auditor_2026_08 10 brasilia.public.temp0000237386 10 rio.public.temp0000287260 9 brasilia.public.usuarios 9 brasilia.pg_catalog.pg_depend 9 contagem.public.temp0000226710 8 contagem.pg_catalog.pg_class 7 brasilia.public.temp0000237404 6 rio.public.temp0000287244 6 rio.public.temp0000287360 6 brasilia.public.temp0000237398 6 brasilia.public.temp0000237356 6 rio.public.temp0000287356 5 rio.public.temp0000287254 5 rio.public.temp0000287304 5 contagem.pg_catalog.pg_type 5 rio.public.temp0000287312 5 rio.public.temp0000287292 5 brasilia.public.temp0000237380 5 brasilia.public.temp0000237362 4 rio.public.temp0000287266 4 contagem.public.temp0000226724 4 contagem.public.temp0000226742 4 rio.public.temp0000287278 4 rio.public.temp0000287078 4 rio.public.temp0000287256 3 contagem.pg_catalog.pg_index 3 rio.public.temp0000287218 3 contagem.pg_catalog.pg_shdepend 3 brasilia.public.temp0000237326 3 rio.public.temp0000287302 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000287228 3 rio.public.temp0000287276 3 brasilia.public.nf_entrada 2 brasilia.public.temp0000237332 2 contagem.pg_catalog.pg_depend 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000287306 2 rio.public.temp0000287242 2 rio.public.temp0000287324 2 rio.public.temp0000287248 2 rio.public.temp0000287344 2 rio.public.temp0000287320 2 rio.public.temp0000287346 2 rio.public.temp0000287290 2 brasilia.public.temp0000237388 2 rio.public.temp0000287234 2 brasilia.public.temp0000237336 2 rio.public.tmp_drill_0175 2 rio.public.temp0000287262 2 brasilia.public.temp0000237322 2 rio.public.temp0000287342 2 rio.public.temp0000287280 2 brasilia.public.temp0000237344 1 rio.public.temp0000287308 1 brasilia.public.temp0000237334 1 brasilia.public.temp0000237376 1 rio.public.temp0000287352 1 rio.public.temp0000287288 1 brasilia.public.temp0000237338 1 brasilia.public.temp0000237348 1 rio.public.temp0000287096 1 brasilia.public.temp0000237384 1 brasilia.public.temp0000237328 1 brasilia.public.temp0000237358 1 brasilia.public.temp0000237366 1 brasilia.public.temp0000237324 1 rio.public.temp0000287298 1 rio.public.temp0000287270 1 brasilia.public.temp0000237396 1 rio.public.temp0000287268 1 brasilia.public.temp0000237374 1 rio.public.temp0000287294 1 brasilia.public.temp0000237346 1 rio.public.temp0000287214 1 rio.public.temp0000287246 1 brasilia.public.temp0000237410 1 brasilia.public.temp0000237368 1 rio.public.temp0000287340 1 rio.public.temp0000287296 1 brasilia.public.temp0000237352 1 Total 831 Vacuums per table
Key values
- pg_catalog.pg_attribute (62) Main table vacuumed on database rio
- 459 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 62 26 0 0 0 0 0 13,288 3,803 5,596,165 213 5,027 rio.pg_catalog.pg_class 52 17 0 0 0 0 0 3,057 1,071 1,522,450 71 284 rio.public.usuarios 40 6 0 0 0 0 0 219 77 124,355 6 7 rio.public.temp0000287226 34 0 0 0 0 0 0 24,482 253 1,707,303 0 0 rio.pg_catalog.pg_type 33 14 0 0 0 0 0 1,324 435 565,624 42 146 rio.public.temp0000287316 32 0 0 0 0 0 0 7,147 420 869,934 0 0 contagem.public.usuarios 15 0 0 0 0 0 0 61 43 26,504 0 0 brasilia.pg_catalog.pg_attribute 14 13 0 0 0 0 0 7,586 2,017 3,262,694 77 2,155 rio.auditor.auditor_2026_08 12 0 0 0 0 0 0 80,767 40,944 53,833,022 18,101 343,558 rio.public.temp0000287300 11 0 0 0 0 0 0 763 63 54,732 0 0 brasilia.pg_catalog.pg_class 8 8 0 0 0 0 0 1,778 498 802,840 22 79 brasilia.auditor.auditor_2026_08 7 0 0 0 0 0 0 11,356 7,436 8,973,984 1,389 25,887 brasilia.pg_catalog.pg_type 7 6 0 0 0 0 0 592 188 288,964 18 66 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,812 3,154 12,685,279 1,822 8,584 rio.pg_catalog.pg_index 7 7 0 0 0 0 0 344 96 126,439 20 52 rio.pg_catalog.pg_depend 7 7 0 0 0 0 0 2,124 794 1,068,793 66 586 rio.public.temp0000287360 6 0 0 0 0 0 0 8,504 1,719 2,688,963 0 0 contagem.auditor.auditor_2026_08 5 0 0 0 0 0 0 8,765 5,710 6,948,049 1,019 17,813 contagem.pg_catalog.pg_attribute 5 5 0 0 0 0 0 2,518 873 1,455,592 8 186 postgres.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 695 252 405,743 52 101 rio.public.temp0000287292 5 0 0 0 0 0 0 3,410 17 204,010 0 0 brasilia.public.temp0000237404 5 0 0 0 0 0 0 992 29 64,131 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,067 320 526,807 17 166 rio.public.temp0000287254 4 0 0 0 0 0 0 98 20 8,739 0 0 rio.public.tmp_drill_0175 4 2 0 0 0 0 0 55 6 12,205 0 0 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 4,834 681 3,003,714 392 2,994 rio.public.temp0000287278 4 0 0 0 0 0 0 16 12 3,096 0 0 rio.public.temp0000287312 4 0 0 0 0 0 0 354 24 24,467 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 231 61 65,339 7 23 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,762 518 2,605,227 188 588 rio.public.temp0000287078 3 0 0 0 0 0 0 75 16 6,763 0 0 rio.public.temp0000287276 3 0 0 0 0 0 0 12 9 2,322 0 0 brasilia.public.nf_entrada 3 2 0 0 0 0 0 365 154 300,873 17 30 rio.public.temp0000287280 2 0 0 0 0 0 0 134 8 9,112 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 310 62 270,958 26 60 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,771 231 989,236 170 1,491 rio.public.temp0000287324 2 0 0 0 0 0 0 85 81 149,190 0 0 rio.public.temp0000287290 2 0 0 0 0 0 0 1,703 7 101,618 0 0 rio.public.temp0000287346 2 0 0 0 0 0 0 86 11 6,789 0 0 rio.public.temp0000287244 2 0 0 0 0 0 0 41 11 3,955 0 0 rio.public.temp0000287262 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000287296 1 0 0 0 0 0 0 1,699 4 100,844 0 0 rio.public.temp0000287260 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.caixa_itens_exclusao 1 0 0 0 0 0 0 386 363 1,465,439 16 1,566 brasilia.public.temp0000237396 1 0 0 0 0 0 0 247 6 15,810 0 0 rio.public.temp0000287270 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000287246 1 0 0 0 0 0 0 65 4 4,438 0 0 contagem.pg_catalog.pg_class 1 1 0 0 0 0 0 85 35 49,981 1 3 brasilia.public.temp0000237384 1 0 0 0 0 0 0 245 6 15,594 0 0 rio.public.temp0000287096 1 0 0 0 0 0 0 76 6 5,378 0 0 brasilia.public.temp0000237358 1 0 0 0 0 0 0 245 6 15,592 0 0 brasilia.public.temp0000237368 1 0 0 0 0 0 0 245 6 15,594 0 0 rio.public.temp0000287256 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.temp0000287288 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000287234 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000287352 1 0 0 0 0 0 0 78 76 149,181 0 0 brasilia.public.temp0000237388 1 0 0 0 0 0 0 245 244 386,439 0 0 rio.public.temp0000287242 1 0 0 0 0 0 0 65 4 4,438 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 124 25 80,311 6 10 contagem.pg_catalog.pg_type 1 1 0 0 0 0 0 80 33 49,966 2 4 rio.public.temp0000287306 1 0 0 0 0 0 0 8 5 1,282 0 0 rio.public.temp0000287266 1 0 0 0 0 0 0 65 4 4,438 0 0 rio.public.temp0000287320 1 0 0 0 0 0 0 77 6 5,438 0 0 rio.public.temp0000287302 1 0 0 0 0 0 0 8 5 1,297 0 0 brasilia.public.temp0000237334 1 0 0 0 0 0 0 245 6 15,594 0 0 brasilia.public.temp0000237374 1 0 0 0 0 0 0 245 243 385,516 0 0 Total 459 147 0 0 0 0 0 207,262 73,231 114,150,522 23,768 411,466 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (13.68) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.11 rio.pg_catalog.pg_class 0 0 0.97 rio.public.usuarios 0 0 0.04 rio.public.temp0000287226 0 0 0.92 rio.pg_catalog.pg_type 0 0 0.35 rio.public.temp0000287316 0 0 0.74 contagem.public.usuarios 0 0 0.02 brasilia.pg_catalog.pg_attribute 0 0 1.35 rio.auditor.auditor_2026_08 0 0 13.68 rio.public.temp0000287300 0 0 0.17 brasilia.pg_catalog.pg_class 0 0 0.44 brasilia.auditor.auditor_2026_08 0 0 2.4 brasilia.pg_catalog.pg_type 0 0 0.19 rio.pg_catalog.pg_statistic 0 0 1.41 rio.pg_catalog.pg_index 0 0 0.8 rio.pg_catalog.pg_depend 0 0 0.96 rio.public.temp0000287360 0 0 0.34 contagem.auditor.auditor_2026_08 0 0 1.49 contagem.pg_catalog.pg_attribute 0 0 0.78 postgres.pg_catalog.pg_shdepend 0 0 0.56 rio.public.temp0000287292 0 0 0.23 brasilia.public.temp0000237404 0 0 0.1 brasilia.pg_catalog.pg_depend 0 0 0.31 rio.public.temp0000287254 0 0 0.05 rio.public.tmp_drill_0175 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.49 rio.public.temp0000287278 0 0 0.2 rio.public.temp0000287312 0 0 0.07 brasilia.pg_catalog.pg_index 0 0 0.12 rio.pg_toast.pg_toast_2619 0 0 0.22 rio.public.temp0000287078 0 0 0.04 rio.public.temp0000287276 0 0 0.16 brasilia.public.nf_entrada 0 0 0.1 rio.public.temp0000287280 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.19 rio.public.temp0000287324 0 0 0.04 rio.public.temp0000287290 0 0 0.09 rio.public.temp0000287346 0 0 0.03 rio.public.temp0000287244 0 0 0.03 rio.public.temp0000287262 0 0 0 rio.public.temp0000287296 0 0 0.06 rio.public.temp0000287260 0 0 0 rio.public.caixa_itens_exclusao 0 0 0.32 brasilia.public.temp0000237396 0 0 0.01 rio.public.temp0000287270 0 0 0.05 rio.public.temp0000287246 0 0 0 contagem.pg_catalog.pg_class 0 0 0.12 brasilia.public.temp0000237384 0 0 0.02 rio.public.temp0000287096 0 0 0.01 brasilia.public.temp0000237358 0 0 0.02 brasilia.public.temp0000237368 0 0 0.02 rio.public.temp0000287256 0 0 0 rio.public.temp0000287288 0 0 0.04 rio.public.temp0000287234 0 0 0.04 rio.public.temp0000287352 0 0 0.02 brasilia.public.temp0000237388 0 0 0.02 rio.public.temp0000287242 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 contagem.pg_catalog.pg_type 0 0 0.08 rio.public.temp0000287306 0 0 0.01 rio.public.temp0000287266 0 0 0 rio.public.temp0000287320 0 0 0.02 rio.public.temp0000287302 0 0 0.01 brasilia.public.temp0000237334 0 0 0.02 brasilia.public.temp0000237374 0 0 0.03 Total 0 0 34.13 Tuples removed per table
Key values
- pg_catalog.pg_attribute (109373) Main table with removed tuples on database rio
- 260305 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 62 26 109,373 1,693,177 356,115 35 40,117 brasilia.pg_catalog.pg_attribute 14 13 67,044 323,818 10,460 79 8,665 contagem.pg_catalog.pg_attribute 5 5 13,563 116,076 0 0 2,720 rio.pg_catalog.pg_statistic 7 7 11,030 59,207 1,086 0 9,002 brasilia.pg_catalog.pg_depend 4 4 8,543 77,544 4,787 0 722 brasilia.pg_catalog.pg_statistic 4 4 7,706 33,513 0 0 4,288 rio.pg_catalog.pg_depend 7 7 7,343 133,255 1,991 0 1,295 brasilia.pg_catalog.pg_class 8 8 5,714 32,307 2,075 1 1,124 contagem.pg_catalog.pg_statistic 2 2 5,053 14,943 0 0 2,022 postgres.pg_catalog.pg_shdepend 5 5 4,281 68,685 761 0 595 rio.pg_catalog.pg_type 33 14 3,674 88,915 14,102 4 2,375 brasilia.pg_catalog.pg_type 7 6 3,081 16,707 1,072 0 510 rio.pg_catalog.pg_class 52 17 2,546 227,043 49,926 7 6,271 rio.auditor.auditor_2026_08 12 0 2,250 5,520,928 0 0 250,093 brasilia.public.nf_entrada 3 2 2,080 15,527 1,081 0 456 rio.pg_catalog.pg_index 7 7 1,576 13,547 87 0 370 brasilia.pg_catalog.pg_index 4 4 1,494 8,299 741 8 228 rio.pg_toast.pg_toast_2619 3 3 1,005 2,254 9 0 792 contagem.public.usuarios 15 0 910 360 0 0 30 rio.public.caixa_itens_exclusao 1 0 546 1,315,827 0 0 10,998 rio.public.tmp_drill_0175 4 2 490 1,050 280 0 22 rio.public.usuarios 40 6 282 30,798 10,438 2 718 brasilia.auditor.auditor_2026_08 7 0 264 941,281 0 0 40,219 brasilia.pg_toast.pg_toast_2619 2 2 174 280 0 0 120 contagem.pg_catalog.pg_class 1 1 115 3,630 0 0 133 contagem.pg_toast.pg_toast_2619 1 1 102 112 0 0 52 contagem.pg_catalog.pg_type 1 1 66 2,247 0 0 59 contagem.auditor.auditor_2026_08 5 0 0 611,408 0 0 24,597 rio.public.temp0000287262 1 0 0 1,136 0 0 64 rio.public.temp0000287296 1 0 0 23,949 0 0 1,728 rio.public.temp0000287260 1 0 0 1,130 0 0 64 rio.public.temp0000287280 2 0 0 2,310 0 0 128 brasilia.public.temp0000237396 1 0 0 3,168 0 18 238 rio.public.temp0000287300 11 0 0 42,540 0 460 948 rio.public.temp0000287270 1 0 0 23,940 0 0 1,728 rio.public.temp0000287246 1 0 0 1,130 0 0 64 rio.public.temp0000287292 5 0 0 119,732 0 0 8,640 rio.public.temp0000287226 34 0 0 471,927 0 62 33,794 rio.public.temp0000287254 4 0 0 7,985 0 46 178 brasilia.public.temp0000237384 1 0 0 3,165 0 19 237 rio.public.temp0000287096 1 0 0 1,190 0 60 68 brasilia.public.temp0000237358 1 0 0 3,165 0 19 237 rio.public.temp0000287078 3 0 0 6,013 0 27 133 rio.public.temp0000287276 3 0 0 71,814 0 0 5,184 rio.public.temp0000287278 4 0 0 95,765 0 0 6,912 brasilia.public.temp0000237368 1 0 0 3,165 0 19 237 rio.public.temp0000287256 1 0 0 1,130 0 0 64 rio.public.temp0000287288 1 0 0 23,944 0 0 1,728 rio.public.temp0000287234 1 0 0 23,943 0 0 1,728 rio.public.temp0000287352 1 0 0 1,198 0 58 70 brasilia.public.temp0000237388 1 0 0 3,165 0 19 237 rio.public.temp0000287242 1 0 0 1,130 0 0 64 rio.public.temp0000287324 2 0 0 2,394 0 118 138 rio.public.temp0000287312 4 0 0 14,445 0 190 322 rio.public.temp0000287306 1 0 0 3,354 0 53 75 rio.public.temp0000287316 32 0 0 237,904 0 1,180 12,516 brasilia.public.temp0000237404 5 0 0 15,850 0 90 1,190 rio.public.temp0000287266 1 0 0 1,130 0 0 64 rio.public.temp0000287320 1 0 0 1,197 0 59 69 rio.public.temp0000287360 6 0 0 143,729 0 0 10,368 rio.public.temp0000287302 1 0 0 3,858 0 42 86 brasilia.public.temp0000237334 1 0 0 3,165 0 19 237 brasilia.public.temp0000237374 1 0 0 3,165 0 19 237 rio.public.temp0000287290 2 0 0 47,890 0 0 3,456 rio.public.temp0000287346 2 0 0 2,396 0 116 140 rio.public.temp0000287244 2 0 0 2,737 0 35 61 Total 459 147 260,305 12,773,686 455,011 2,864 502,025 Pages removed per table
Key values
- public.temp0000287316 (1180) Main table with removed pages on database rio
- 2864 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000287316 32 0 0 1180 rio.public.temp0000287300 11 0 0 460 rio.public.temp0000287312 4 0 0 190 rio.public.temp0000287324 2 0 0 118 rio.public.temp0000287346 2 0 0 116 brasilia.public.temp0000237404 5 0 0 90 brasilia.pg_catalog.pg_attribute 14 13 67044 79 rio.public.temp0000287226 34 0 0 62 rio.public.temp0000287096 1 0 0 60 rio.public.temp0000287320 1 0 0 59 rio.public.temp0000287352 1 0 0 58 rio.public.temp0000287306 1 0 0 53 rio.public.temp0000287254 4 0 0 46 rio.public.temp0000287302 1 0 0 42 rio.pg_catalog.pg_attribute 62 26 109373 35 rio.public.temp0000287244 2 0 0 35 rio.public.temp0000287078 3 0 0 27 brasilia.public.temp0000237384 1 0 0 19 brasilia.public.temp0000237358 1 0 0 19 brasilia.public.temp0000237368 1 0 0 19 brasilia.public.temp0000237388 1 0 0 19 brasilia.public.temp0000237334 1 0 0 19 brasilia.public.temp0000237374 1 0 0 19 brasilia.public.temp0000237396 1 0 0 18 brasilia.pg_catalog.pg_index 4 4 1494 8 rio.pg_catalog.pg_class 52 17 2546 7 rio.pg_catalog.pg_type 33 14 3674 4 rio.public.usuarios 40 6 282 2 brasilia.pg_catalog.pg_class 8 8 5714 1 contagem.auditor.auditor_2026_08 5 0 0 0 rio.public.temp0000287262 1 0 0 0 brasilia.pg_catalog.pg_depend 4 4 8543 0 contagem.pg_catalog.pg_attribute 5 5 13563 0 rio.public.temp0000287296 1 0 0 0 rio.public.temp0000287260 1 0 0 0 rio.public.temp0000287280 2 0 0 0 rio.public.caixa_itens_exclusao 1 0 546 0 postgres.pg_catalog.pg_shdepend 5 5 4281 0 rio.public.temp0000287270 1 0 0 0 brasilia.auditor.auditor_2026_08 7 0 264 0 rio.public.temp0000287246 1 0 0 0 rio.public.temp0000287292 5 0 0 0 contagem.pg_catalog.pg_class 1 1 115 0 rio.pg_toast.pg_toast_2619 3 3 1005 0 rio.public.tmp_drill_0175 4 2 490 0 rio.public.temp0000287276 3 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 7706 0 rio.public.temp0000287278 4 0 0 0 brasilia.pg_catalog.pg_type 7 6 3081 0 rio.public.temp0000287256 1 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 174 0 contagem.pg_catalog.pg_statistic 2 2 5053 0 rio.public.temp0000287288 1 0 0 0 contagem.public.usuarios 15 0 910 0 rio.auditor.auditor_2026_08 12 0 2250 0 rio.public.temp0000287234 1 0 0 0 rio.public.temp0000287242 1 0 0 0 rio.pg_catalog.pg_statistic 7 7 11030 0 contagem.pg_toast.pg_toast_2619 1 1 102 0 contagem.pg_catalog.pg_type 1 1 66 0 rio.public.temp0000287266 1 0 0 0 brasilia.public.nf_entrada 3 2 2080 0 rio.public.temp0000287360 6 0 0 0 rio.pg_catalog.pg_index 7 7 1576 0 rio.public.temp0000287290 2 0 0 0 rio.pg_catalog.pg_depend 7 7 7343 0 Total 459 147 260,305 2,864 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 03 00 3 3 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 0 07 10 19 08 28 78 09 69 119 10 61 97 11 119 104 12 5 31 13 11 30 14 25 65 15 39 100 16 58 113 17 24 70 18 0 0 19 0 0 20 0 0 21 1 2 22 0 0 23 0 0 - 3.19 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 13m16s 2m22s 7m25s 4m25s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 09:42:50 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 15:08:34 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 11:37:40 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
2 1 8m19s 8m19s 8m19s 8m19s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-03 11:21:00 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-03 09:37:58 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-03 09:42:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Queries that waited the most
Rank Wait time Query 1 8m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0305 )', '/var/www/html/tmp/nf_carga_lotes_0305.xlsx');[ Date: 2026-08-03 11:21:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 7m25s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-03 09:42:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 3m28s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-03 15:08:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 2m22s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-03 11:37:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 3,544 Total read queries
- 1,453 Total write queries
Queries by database
Key values
- rio Main database
- 3,235 Requests
- 7h54m21s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,156 Requests
User Request type Count Duration etiquetas Total 63 17s306ms select 63 17s306ms intelifix Total 6,156 14h25m copy to 818 1h24m59s ddl 1,044 40m42s others 790 1h31m17s select 3,504 10h48m lenon Total 112 51s312ms select 112 51s312ms Duration by user
Key values
- 14h25m (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 63 17s306ms select 63 17s306ms intelifix Total 6,156 14h25m copy to 818 1h24m59s ddl 1,044 40m42s others 790 1h31m17s select 3,504 10h48m lenon Total 112 51s312ms select 112 51s312ms Queries by host
Key values
- [local] Main host
- 6,331 Requests
- 14h26m8s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,393 Requests
- 4h53m21s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-03 15:37:23 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,343 100-500ms duration
Slowest individual queries
Rank Duration Query 1 23m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-08-03 11:21:00 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 16m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-08-03 09:37:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 14m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 07:19:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 13m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 10:18:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 11m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 11:16:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 11m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 20:16:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 10m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 12:15:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 10m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 17:15:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 10m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-03 09:42:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 9m44s analyze verbose;[ Date: 2026-08-03 05:09:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 9m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 09:14:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 8m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0305 )', '/var/www/html/tmp/nf_carga_lotes_0305.xlsx');[ Date: 2026-08-03 11:21:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 7m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027911, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-03 07:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 7m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 16:12:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m32s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-03 09:42:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 7m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-03 15:12:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 7m2s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027937, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-03 14:14:51 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027943, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-03 16:33:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027927, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-03 10:58:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027931, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-03 11:28:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h47m35s 272 153ms 23m52s 36s967ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 07 6 13m16s 2m12s 08 13 6m42s 30s990ms 09 28 34m25s 1m13s 10 34 22m57s 40s505ms 11 24 53m57s 2m14s 12 9 2m24s 16s59ms 13 3 4s960ms 1s653ms 14 40 12m46s 19s169ms 15 35 6m28s 11s101ms 16 41 10m31s 15s399ms 17 39 3m59s 6s142ms [ User: intelifix - Total duration: 2h47m35s - Times executed: 272 ]
[ Application: [unknown] - Total duration: 2h47m35s - Times executed: 272 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-03 11:21:00 Duration: 23m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-03 09:37:58 Duration: 16m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-03 09:42:47 Duration: 10m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
2 2h26m25s 48 1s224ms 14m49s 3m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 07 3 15m33s 5m11s 08 3 6m50s 2m16s 09 3 10m21s 3m27s 10 3 14m 4m40s 11 3 12m27s 4m9s 12 3 11m22s 3m47s 13 3 5m45s 1m55s 14 3 6m40s 2m13s 15 3 8m4s 2m41s 16 3 7m59s 2m39s 17 3 11m28s 3m49s 18 3 5m54s 1m58s 19 3 5m48s 1m56s 20 3 12m9s 4m3s 21 3 6m3s 2m1s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 2h26m25s - Times executed: 48 ]
[ Application: psql - Total duration: 2h26m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 07:19:51 Duration: 14m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 10:18:11 Duration: 13m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 11:16:44 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
3 1h18m21s 47 203ms 4m50s 1m40s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 03 07 3 6m26s 2m8s 08 3 4m8s 1m22s 09 3 6m30s 2m10s 10 2 4m44s 2m22s 11 3 6m40s 2m13s 12 3 4m43s 1m34s 13 3 3m43s 1m14s 14 3 4m16s 1m25s 15 3 5m44s 1m54s 16 3 4m29s 1m29s 17 3 5m44s 1m54s 18 3 3m45s 1m15s 19 3 3m51s 1m17s 20 3 5m34s 1m51s 21 3 3m53s 1m17s 22 3 4m4s 1m21s [ User: intelifix - Total duration: 1h18m21s - Times executed: 47 ]
[ Application: psql - Total duration: 1h18m21s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 11:24:01 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 10:25:23 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 09:21:37 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
4 26m56s 1,090 150ms 10s284ms 1s482ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 07 11 7s699ms 699ms 08 78 1m57s 1s504ms 09 137 3m29s 1s532ms 10 179 4m5s 1s370ms 11 121 2m56s 1s458ms 12 63 1m36s 1s525ms 13 47 51s178ms 1s88ms 14 125 3m45s 1s804ms 15 139 4m14s 1s828ms 16 108 2m36s 1s446ms 17 82 1m16s 930ms [ User: intelifix - Total duration: 26m56s - Times executed: 1090 ]
[ Application: [unknown] - Total duration: 26m56s - Times executed: 1090 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273477, 508, '923181029036,94988F959AB3,B0BBE54D30A3,D0CF0EFD89FA,44D454604026,44D45469DB5E,94988F308741,94988F3070FF,C4EB42A06EC7,38A659237C95,94988F2FCDD6,8CFDDE98234C,C4EB42A09CF6,ACD75BB8462F,6CBAB8F16866,943C96AC2FB5,E4C0E290149E,94988F307B6A,3453D2A7E83F,5CFA259BE8DE,943C96AB1EC3,ACD75BB7FC07', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-03 16:36:32 Duration: 10s284ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48644, 417, '270911021423100261,229884361520,229780684353,229747607488,229786779112,229808501019,229741562230,229781486990,229933963555,229691528907,229813794453,229743724158,229813498991,229879770410,229667789306,229671447384,229748409294,229742677377,229837220814,229737746481,229747730913,229669058082,229816889110,216940447986,216940057286,216939931416,229813113141,229691122627,229743537697,229663016584,229750533947,229740474256,229860075468,229859809202,216939703133,229748549107,229747057681,229866003948,229691464456,229739005762,229810947272,229816868906,229747105464,229810163650,229808268391,229751897278,229742673842,229933953049', '246652245253,246584779208,246571527981,246598208789,246618509200,246527361113,246584776985,246310382440,246506994557,246628929409,226066362530,246629875775,246652909314,246498421824,246514394258,246548477090,246549386685,246640725880,246569591329,246548574350,246515925967,246628230924,246475641924,246463377898,246465034951,246627479098,246514070714,246547268397,246487250824,246562957998,246574934869,246651759617,246648477489,246463533649,246551076064,246555645657,246653654448,246516341721,246527955166,246640372232,246628910519,246558987588,246626926789,246619287491,246529779912,246550870512,246338571824,,,', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-03 09:13:15 Duration: 9s98ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273478, 304, 'CP2207LV5VU,3C82C0CA2CBC$CP2435LV5BF,C4509CF0BDA4$CP2046LV076,484BD4A0157C$CP2528LV5ZW,F8D2AC963B04$CP2301LV5F2,B85E71E70374$CP2145LV21U,D4E2CB1FC734$CP2429LV6AQ,C4509CBD2A0C$CP2429LV0CY,C4509CBCD144$CP2247LV4ST,F8D2AC142494$CP2233LVD23,4075C3B364C8$CP2530LV1DA,3C82C08DEE8C$CP2238LVC4H,4075C3C157E0$CP2139LV1YE,ECA81F6D9694$CP2238LV6EA,4075C3C14110$CP2111LV2R8,08A7C04C9164$CP2139LV4RB,ECA81FF470AC$CP2206LV1JU,3C82C0693408$CP2534LV33C,3C82C0906AA4$CP2248LV65F,B85E71D92E34$CP2529LVA8N,3C82C08D9270$CP2205LV2NL,1C9D7282C134$CP2120LV347,08A7C06C4F04$CP2240LV5MS,B85E71C311E4$CP2302LVBDY,B85E71E939B4$CP2142LV8T1,ECA81FF97F5C$CP2145LV4GG,D4E2CB1FB1A4$CP2147LV7VS,D4E2CB9288A4$CP2532LV03W,3C82C08FF7B8$CP2233LV75K,4075C3B2CD88$CP2531LV5WA,3C82C08F126C$CP2301LV3ZH,B85E71E6DB24$CP2431LV56E,C4509CBD3DD4$CP2531LV5H5,3C82C0903EE4$CP2249LVAT2,B85E71DC7C9C$CP2248LVGS4,B85E71DC5050$CP2139LV8QH,ECA81FF593DC$CP2233LVBF9,4075C3B550E4$CP2534LV05V,3C82C0905FF0$CP2429LV5GY,C4509CBD67D4', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-03 16:08:29 Duration: 8s417ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
5 24m6s 274 166ms 7m32s 5s278ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 03 00 12 48s635ms 4s52ms 01 12 24s797ms 2s66ms 02 12 25s175ms 2s97ms 03 10 21s498ms 2s149ms 04 12 24s721ms 2s60ms 05 12 24s753ms 2s62ms 06 12 24s145ms 2s12ms 07 12 28s326ms 2s360ms 08 12 27s552ms 2s296ms 09 12 8m6s 40s512ms 10 12 26s482ms 2s206ms 11 12 2m50s 14s224ms 12 12 22s629ms 1s885ms 13 12 26s262ms 2s188ms 14 12 25s747ms 2s145ms 15 12 3m56s 19s690ms 16 12 25s564ms 2s130ms 17 12 26s719ms 2s226ms 18 12 24s643ms 2s53ms 19 12 23s505ms 1s958ms 20 12 52s930ms 4s410ms 21 12 25s75ms 2s89ms 22 12 24s55ms 2s4ms [ User: intelifix - Total duration: 24m6s - Times executed: 274 ]
[ Application: psql - Total duration: 24m6s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 09:42:50 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 15:08:34 Duration: 3m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 11:37:40 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
6 16m31s 3 2m31s 9m44s 5m30s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 03 05 3 16m31s 5m30s [ User: intelifix - Total duration: 16m31s - Times executed: 3 ]
[ Application: psql - Total duration: 16m31s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-03 05:09:46 Duration: 9m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
analyze verbose;
Date: 2026-08-03 05:14:01 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
analyze verbose;
Date: 2026-08-03 05:16:32 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
7 13m24s 59 9s443ms 1m4s 13s638ms create table temp0000287226 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 03 07 12 2m57s 14s811ms 08 14 2m37s 11s234ms 09 15 4m16s 17s108ms 10 6 1m5s 10s863ms 11 12 2m27s 12s318ms [ User: intelifix - Total duration: 13m24s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 13m24s - Times executed: 59 ]
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:30:06 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 07:23:20 Duration: 53s142ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:32:13 Duration: 15s338ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
8 12m27s 778 151ms 3s360ms 960ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 03 08 95 1m40s 1s53ms 09 130 2m19s 1s71ms 10 162 2m44s 1s18ms 11 116 1m46s 918ms 12 13 9s656ms 742ms 13 8 10s658ms 1s332ms 14 60 1m1s 1s22ms 15 91 1m19s 877ms 16 70 54s728ms 781ms 17 33 20s88ms 608ms [ User: intelifix - Total duration: 12m27s - Times executed: 778 ]
[ Application: [unknown] - Total duration: 12m27s - Times executed: 778 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273453", "modelo" : "318", "itens" : "D83139A0E2A2,4896D95472F8,D89A0DB0D673,D89A0DA67A97,3CF9F0AF7500,3CF9F0AB3D2A,C4EBFF8D3264,3CF9F0A8D45C,3891484D6671,F4E84F839090,C4EBFF8D5CD0,48D68239A5E2,F00C514C946A,3891484A792B,14CA56D284E3,F4E84F822E60,843C99360A19,689E29BD1605,3CF9F0AE06F4,4896D956EF2E", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 08:49:09 Duration: 3s360ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273465", "modelo" : "318", "itens" : "D89A0DA515FD,5872C991EC65,843C992F4A85,D89A0DA53847,843C99215735,C4EBFF8E60A4,5872C989BA21,6C11BA630603,D89A0D83E4FD,D89A0DA6F86D,D83139A1838E,4896D94FF2EC,D89A0DAC3933,3CF9F06FAB03,3CF9F0A30ADA,F4E84F861554,4896D9534122,48D6823061DE,14CA56D45E71,3891484F8C31", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 09:20:13 Duration: 3s336ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273491", "modelo" : "464", "itens" : "241747932446,241762294150,241767097379,241747983539,241738953051,241766809090,241748064355,241767008909,241767009717,241740065976,241741064547,241744446482,241766684859,241766275268,241766177177,241741133443,241766446070,241747051619,241741186276,241743742340,241741247595,241773562130,241747013052,241747052528,241763107596,241767066669,241762308898,241747047274,241763794970,241739791730,241759868605,241742078495,241766301332,241766282037,241767101825,241747047577,241740851418,241763792546,241763769917,241763116890,241770876783,241763791435,241769672233,241745422627,241769686476,241741142434,241762119105,241760929202,241766582425,241766198189,241743833134,241766430817,241762137591,241766365860,241766119292,241762082132,241769559113,241763637378,241762198608,241762053745", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 09:45:26 Duration: 3s255ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
9 10m42s 114 156ms 1m24s 5s639ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 03 00 1 637ms 637ms 03 1 406ms 406ms 07 11 1m13s 6s711ms 08 12 1m34s 7s884ms 09 12 1m22s 6s856ms 10 12 1m21s 6s752ms 11 12 1m32s 7s747ms 12 6 13s446ms 2s241ms 13 5 6s856ms 1s371ms 14 6 9s480ms 1s580ms 15 6 18s74ms 3s12ms 16 10 2m 12s7ms 17 6 8s864ms 1s477ms 18 1 626ms 626ms 20 2 906ms 453ms 21 5 17s770ms 3s554ms 22 6 21s42ms 3s507ms [ User: intelifix - Total duration: 10m42s - Times executed: 114 ]
[ Application: psql - Total duration: 10m42s - Times executed: 114 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 16:26:26 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 07:15:24 Duration: 22s724ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 11:25:20 Duration: 19s83ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
10 4m12s 25 154ms 48s147ms 10s111ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 03 07 3 56s133ms 18s711ms 08 2 4s449ms 2s224ms 09 4 1m22s 20s512ms 10 3 25s71ms 8s357ms 11 5 12s579ms 2s515ms 14 2 43s955ms 21s977ms 15 1 7s370ms 7s370ms 16 4 20s932ms 5s233ms 17 1 237ms 237ms [ User: intelifix - Total duration: 4m12s - Times executed: 25 ]
[ Application: psql - Total duration: 4m12s - Times executed: 25 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027911);
Date: 2026-08-03 07:24:22 Duration: 48s147ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027921);
Date: 2026-08-03 09:32:22 Duration: 40s335ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027937);
Date: 2026-08-03 14:07:57 Duration: 37s571ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
11 4m 35 246ms 1m57s 6s865ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 03 07 4 3s367ms 841ms 08 5 3s680ms 736ms 09 6 2m3s 20s554ms 10 3 1m6s 22s90ms 11 7 14s99ms 2s14ms 14 3 3s768ms 1s256ms 15 2 1s10ms 505ms 16 3 12s572ms 4s190ms 17 2 12s211ms 6s105ms [ User: intelifix - Total duration: 4m - Times executed: 35 ]
[ Application: psql - Total duration: 4m - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027922);
Date: 2026-08-03 09:35:02 Duration: 1m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027928);
Date: 2026-08-03 10:56:13 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027941);
Date: 2026-08-03 16:24:28 Duration: 11s608ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
12 3m56s 21 10s129ms 13s160ms 11s275ms create table temp0000287316 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 03 14 9 1m41s 11s238ms 15 6 1m9s 11s568ms 16 6 1m6s 11s39ms [ User: intelifix - Total duration: 3m56s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 21 ]
-
CREATE TABLE temp0000287316 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 14:06:20 Duration: 13s160ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287316 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 15:02:20 Duration: 12s276ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287316 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 16:26:59 Duration: 12s31ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
13 3m42s 115 185ms 26s660ms 1s934ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 03 09 4 1m19s 19s815ms 10 9 26s439ms 2s937ms 14 27 44s124ms 1s634ms 15 28 27s81ms 967ms 16 22 27s243ms 1s238ms 17 25 18s368ms 734ms [ User: intelifix - Total duration: 3m42s - Times executed: 115 ]
[ Application: [unknown] - Total duration: 3m42s - Times executed: 115 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-08-03 09:31:20 Duration: 26s660ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048104) LIMIT 1;
Date: 2026-08-03 09:32:58 Duration: 24s745ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-08-03 09:15:46 Duration: 20s633ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
14 3m7s 17 9s887ms 12s581ms 11s54ms create table temp0000287292 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 03 11 17 3m7s 11s54ms [ User: intelifix - Total duration: 3m7s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 17 ]
-
CREATE TABLE temp0000287292 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 11:28:50 Duration: 12s581ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287292 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 11:24:25 Duration: 12s141ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287292 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 11:28:27 Duration: 11s869ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
15 3m 4 4s150ms 1m28s 45s3ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 03 20 2 1m27s 43s732ms 23 2 1m32s 46s274ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-03 23:16:23 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-03 20:08:24 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-03 23:34:14 Duration: 4s356ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-03.log
16 2m3s 33 748ms 11s249ms 3s730ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 03 08 3 8s386ms 2s795ms 09 2 18s954ms 9s477ms 10 3 22s471ms 7s490ms 11 2 19s131ms 9s565ms 12 2 5s675ms 2s837ms 13 2 1s622ms 811ms 14 2 5s174ms 2s587ms 15 2 11s221ms 5s610ms 16 2 12s565ms 6s282ms 17 3 2s568ms 856ms 18 2 3s513ms 1s756ms 19 2 1s978ms 989ms 20 3 7s280ms 2s426ms 21 2 1s510ms 755ms 22 1 1s50ms 1s50ms [ User: intelifix - Total duration: 2m3s - Times executed: 33 ]
[ Application: psql - Total duration: 2m3s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 09:40:13 Duration: 11s249ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 11:00:12 Duration: 10s801ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 10:20:11 Duration: 10s333ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
17 1m53s 9 11s572ms 14s390ms 12s624ms create table temp0000287276 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 03 09 9 1m53s 12s624ms [ User: intelifix - Total duration: 1m53s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 9 ]
-
CREATE TABLE temp0000287276 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:34:23 Duration: 14s390ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287276 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:33:41 Duration: 14s105ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287276 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:35:59 Duration: 13s151ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
18 1m48s 40 1s137ms 10s251ms 2s721ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 03 07 3 16s677ms 5s559ms 09 3 15s512ms 5s170ms 10 2 8s30ms 4s15ms 11 2 3s521ms 1s760ms 12 2 2s703ms 1s351ms 14 7 17s630ms 2s518ms 15 5 11s29ms 2s205ms 16 4 14s373ms 3s593ms 17 11 17s387ms 1s580ms 18 1 1s991ms 1s991ms [ User: intelifix - Total duration: 1m48s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 40 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0404, '', '', 0, 7, '2026-07-01');
Date: 2026-08-03 07:10:15 Duration: 10s251ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-03 16:57:27 Duration: 9s374ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-03', 0395, '', '', 0, 6, '2026-08-01');
Date: 2026-08-03 14:59:44 Duration: 8s861ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
19 1m48s 10 9s545ms 11s887ms 10s878ms create table temp0000287360 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 03 16 4 44s665ms 11s166ms 17 6 1m4s 10s685ms [ User: intelifix - Total duration: 1m48s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 10 ]
-
CREATE TABLE temp0000287360 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 16:23:56 Duration: 11s887ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287360 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 17:25:56 Duration: 11s469ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287360 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 16:24:38 Duration: 11s403ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
20 1m46s 1 1m46s 1m46s 1m46s select * from rs_smart_fiscal_saida () / 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 (/ 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 #20
Day Hour Count Duration Avg duration Aug 03 10 1 1m46s 1m46s [ User: intelifix - Total duration: 1m46s - Times executed: 1 ]
[ Application: psql - Total duration: 1m46s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 10:19:57 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,090 26m56s 150ms 10s284ms 1s482ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 07 11 7s699ms 699ms 08 78 1m57s 1s504ms 09 137 3m29s 1s532ms 10 179 4m5s 1s370ms 11 121 2m56s 1s458ms 12 63 1m36s 1s525ms 13 47 51s178ms 1s88ms 14 125 3m45s 1s804ms 15 139 4m14s 1s828ms 16 108 2m36s 1s446ms 17 82 1m16s 930ms [ User: intelifix - Total duration: 26m56s - Times executed: 1090 ]
[ Application: [unknown] - Total duration: 26m56s - Times executed: 1090 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273477, 508, '923181029036,94988F959AB3,B0BBE54D30A3,D0CF0EFD89FA,44D454604026,44D45469DB5E,94988F308741,94988F3070FF,C4EB42A06EC7,38A659237C95,94988F2FCDD6,8CFDDE98234C,C4EB42A09CF6,ACD75BB8462F,6CBAB8F16866,943C96AC2FB5,E4C0E290149E,94988F307B6A,3453D2A7E83F,5CFA259BE8DE,943C96AB1EC3,ACD75BB7FC07', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-03 16:36:32 Duration: 10s284ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48644, 417, '270911021423100261,229884361520,229780684353,229747607488,229786779112,229808501019,229741562230,229781486990,229933963555,229691528907,229813794453,229743724158,229813498991,229879770410,229667789306,229671447384,229748409294,229742677377,229837220814,229737746481,229747730913,229669058082,229816889110,216940447986,216940057286,216939931416,229813113141,229691122627,229743537697,229663016584,229750533947,229740474256,229860075468,229859809202,216939703133,229748549107,229747057681,229866003948,229691464456,229739005762,229810947272,229816868906,229747105464,229810163650,229808268391,229751897278,229742673842,229933953049', '246652245253,246584779208,246571527981,246598208789,246618509200,246527361113,246584776985,246310382440,246506994557,246628929409,226066362530,246629875775,246652909314,246498421824,246514394258,246548477090,246549386685,246640725880,246569591329,246548574350,246515925967,246628230924,246475641924,246463377898,246465034951,246627479098,246514070714,246547268397,246487250824,246562957998,246574934869,246651759617,246648477489,246463533649,246551076064,246555645657,246653654448,246516341721,246527955166,246640372232,246628910519,246558987588,246626926789,246619287491,246529779912,246550870512,246338571824,,,', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-03 09:13:15 Duration: 9s98ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273478, 304, 'CP2207LV5VU,3C82C0CA2CBC$CP2435LV5BF,C4509CF0BDA4$CP2046LV076,484BD4A0157C$CP2528LV5ZW,F8D2AC963B04$CP2301LV5F2,B85E71E70374$CP2145LV21U,D4E2CB1FC734$CP2429LV6AQ,C4509CBD2A0C$CP2429LV0CY,C4509CBCD144$CP2247LV4ST,F8D2AC142494$CP2233LVD23,4075C3B364C8$CP2530LV1DA,3C82C08DEE8C$CP2238LVC4H,4075C3C157E0$CP2139LV1YE,ECA81F6D9694$CP2238LV6EA,4075C3C14110$CP2111LV2R8,08A7C04C9164$CP2139LV4RB,ECA81FF470AC$CP2206LV1JU,3C82C0693408$CP2534LV33C,3C82C0906AA4$CP2248LV65F,B85E71D92E34$CP2529LVA8N,3C82C08D9270$CP2205LV2NL,1C9D7282C134$CP2120LV347,08A7C06C4F04$CP2240LV5MS,B85E71C311E4$CP2302LVBDY,B85E71E939B4$CP2142LV8T1,ECA81FF97F5C$CP2145LV4GG,D4E2CB1FB1A4$CP2147LV7VS,D4E2CB9288A4$CP2532LV03W,3C82C08FF7B8$CP2233LV75K,4075C3B2CD88$CP2531LV5WA,3C82C08F126C$CP2301LV3ZH,B85E71E6DB24$CP2431LV56E,C4509CBD3DD4$CP2531LV5H5,3C82C0903EE4$CP2249LVAT2,B85E71DC7C9C$CP2248LVGS4,B85E71DC5050$CP2139LV8QH,ECA81FF593DC$CP2233LVBF9,4075C3B550E4$CP2534LV05V,3C82C0905FF0$CP2429LV5GY,C4509CBD67D4', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-03 16:08:29 Duration: 8s417ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
2 778 12m27s 151ms 3s360ms 960ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 08 95 1m40s 1s53ms 09 130 2m19s 1s71ms 10 162 2m44s 1s18ms 11 116 1m46s 918ms 12 13 9s656ms 742ms 13 8 10s658ms 1s332ms 14 60 1m1s 1s22ms 15 91 1m19s 877ms 16 70 54s728ms 781ms 17 33 20s88ms 608ms [ User: intelifix - Total duration: 12m27s - Times executed: 778 ]
[ Application: [unknown] - Total duration: 12m27s - Times executed: 778 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273453", "modelo" : "318", "itens" : "D83139A0E2A2,4896D95472F8,D89A0DB0D673,D89A0DA67A97,3CF9F0AF7500,3CF9F0AB3D2A,C4EBFF8D3264,3CF9F0A8D45C,3891484D6671,F4E84F839090,C4EBFF8D5CD0,48D68239A5E2,F00C514C946A,3891484A792B,14CA56D284E3,F4E84F822E60,843C99360A19,689E29BD1605,3CF9F0AE06F4,4896D956EF2E", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 08:49:09 Duration: 3s360ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273465", "modelo" : "318", "itens" : "D89A0DA515FD,5872C991EC65,843C992F4A85,D89A0DA53847,843C99215735,C4EBFF8E60A4,5872C989BA21,6C11BA630603,D89A0D83E4FD,D89A0DA6F86D,D83139A1838E,4896D94FF2EC,D89A0DAC3933,3CF9F06FAB03,3CF9F0A30ADA,F4E84F861554,4896D9534122,48D6823061DE,14CA56D45E71,3891484F8C31", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 09:20:13 Duration: 3s336ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273491", "modelo" : "464", "itens" : "241747932446,241762294150,241767097379,241747983539,241738953051,241766809090,241748064355,241767008909,241767009717,241740065976,241741064547,241744446482,241766684859,241766275268,241766177177,241741133443,241766446070,241747051619,241741186276,241743742340,241741247595,241773562130,241747013052,241747052528,241763107596,241767066669,241762308898,241747047274,241763794970,241739791730,241759868605,241742078495,241766301332,241766282037,241767101825,241747047577,241740851418,241763792546,241763769917,241763116890,241770876783,241763791435,241769672233,241745422627,241769686476,241741142434,241762119105,241760929202,241766582425,241766198189,241743833134,241766430817,241762137591,241766365860,241766119292,241762082132,241769559113,241763637378,241762198608,241762053745", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 09:45:26 Duration: 3s255ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
3 274 24m6s 166ms 7m32s 5s278ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 03 00 12 48s635ms 4s52ms 01 12 24s797ms 2s66ms 02 12 25s175ms 2s97ms 03 10 21s498ms 2s149ms 04 12 24s721ms 2s60ms 05 12 24s753ms 2s62ms 06 12 24s145ms 2s12ms 07 12 28s326ms 2s360ms 08 12 27s552ms 2s296ms 09 12 8m6s 40s512ms 10 12 26s482ms 2s206ms 11 12 2m50s 14s224ms 12 12 22s629ms 1s885ms 13 12 26s262ms 2s188ms 14 12 25s747ms 2s145ms 15 12 3m56s 19s690ms 16 12 25s564ms 2s130ms 17 12 26s719ms 2s226ms 18 12 24s643ms 2s53ms 19 12 23s505ms 1s958ms 20 12 52s930ms 4s410ms 21 12 25s75ms 2s89ms 22 12 24s55ms 2s4ms [ User: intelifix - Total duration: 24m6s - Times executed: 274 ]
[ Application: psql - Total duration: 24m6s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 09:42:50 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 15:08:34 Duration: 3m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 11:37:40 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
4 272 2h47m35s 153ms 23m52s 36s967ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 07 6 13m16s 2m12s 08 13 6m42s 30s990ms 09 28 34m25s 1m13s 10 34 22m57s 40s505ms 11 24 53m57s 2m14s 12 9 2m24s 16s59ms 13 3 4s960ms 1s653ms 14 40 12m46s 19s169ms 15 35 6m28s 11s101ms 16 41 10m31s 15s399ms 17 39 3m59s 6s142ms [ User: intelifix - Total duration: 2h47m35s - Times executed: 272 ]
[ Application: [unknown] - Total duration: 2h47m35s - Times executed: 272 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-03 11:21:00 Duration: 23m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-03 09:37:58 Duration: 16m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-03 09:42:47 Duration: 10m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
5 202 1m10s 151ms 1s295ms 350ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 03 07 19 8s37ms 423ms 08 22 5s791ms 263ms 09 27 9s854ms 364ms 10 21 6s849ms 326ms 11 24 8s180ms 340ms 14 3 500ms 166ms 15 36 13s265ms 368ms 16 50 18s421ms 368ms [ User: intelifix - Total duration: 1m10s - Times executed: 202 ]
[ Application: [unknown] - Total duration: 1m10s - Times executed: 202 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '121', 2, '229713907375,229765252331,229732181831,216950341422,229828274654,229777684655,229678375670,229798287799,229828796175', NULL, NULL, 0137, 00);
Date: 2026-08-03 16:10:11 Duration: 1s295ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '108', 2, '230045134853,229972386586,229973888595,230011337884,229977472021,229991456079,230026256669,229981989106,230049746672,230011052324,229987586868,229990444151', NULL, NULL, 0295, 00);
Date: 2026-08-03 16:29:16 Duration: 1s193ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '230014808593,229966261118,229971966567,230026326777,230030290824,229965118996,229972390527,230010973450,229971521923,230041643031', NULL, NULL, 0295, 00);
Date: 2026-08-03 07:41:17 Duration: 1s2ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
6 124 27s863ms 150ms 1s321ms 224ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 03 07 22 5s120ms 232ms 08 28 5s623ms 200ms 09 15 3s330ms 222ms 10 14 4s206ms 300ms 11 14 3s25ms 216ms 12 3 728ms 242ms 13 2 324ms 162ms 14 4 762ms 190ms 15 4 722ms 180ms 16 13 2s342ms 180ms 17 2 390ms 195ms 21 2 890ms 445ms 23 1 395ms 395ms [ User: intelifix - Total duration: 27s863ms - Times executed: 124 ]
[ Application: [unknown] - Total duration: 27s863ms - Times executed: 124 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('820091914000277');
Date: 2026-08-03 10:37:12 Duration: 1s321ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('229652978488');
Date: 2026-08-03 07:02:45 Duration: 938ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('230054785862');
Date: 2026-08-03 21:01:26 Duration: 671ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
7 115 3m42s 185ms 26s660ms 1s934ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 03 09 4 1m19s 19s815ms 10 9 26s439ms 2s937ms 14 27 44s124ms 1s634ms 15 28 27s81ms 967ms 16 22 27s243ms 1s238ms 17 25 18s368ms 734ms [ User: intelifix - Total duration: 3m42s - Times executed: 115 ]
[ Application: [unknown] - Total duration: 3m42s - Times executed: 115 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-08-03 09:31:20 Duration: 26s660ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048104) LIMIT 1;
Date: 2026-08-03 09:32:58 Duration: 24s745ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-08-03 09:15:46 Duration: 20s633ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
8 114 10m42s 156ms 1m24s 5s639ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 03 00 1 637ms 637ms 03 1 406ms 406ms 07 11 1m13s 6s711ms 08 12 1m34s 7s884ms 09 12 1m22s 6s856ms 10 12 1m21s 6s752ms 11 12 1m32s 7s747ms 12 6 13s446ms 2s241ms 13 5 6s856ms 1s371ms 14 6 9s480ms 1s580ms 15 6 18s74ms 3s12ms 16 10 2m 12s7ms 17 6 8s864ms 1s477ms 18 1 626ms 626ms 20 2 906ms 453ms 21 5 17s770ms 3s554ms 22 6 21s42ms 3s507ms [ User: intelifix - Total duration: 10m42s - Times executed: 114 ]
[ Application: psql - Total duration: 10m42s - Times executed: 114 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 16:26:26 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 07:15:24 Duration: 22s724ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 11:25:20 Duration: 19s83ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
9 100 46s43ms 264ms 798ms 460ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 03 07 9 3s879ms 431ms 08 11 5s262ms 478ms 09 9 4s552ms 505ms 10 7 3s368ms 481ms 11 10 4s686ms 468ms 12 4 1s921ms 480ms 13 6 2s504ms 417ms 14 16 6s966ms 435ms 15 9 4s113ms 457ms 16 12 5s786ms 482ms 17 5 2s265ms 453ms 18 1 315ms 315ms 20 1 421ms 421ms [ User: lenon - Total duration: 46s43ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 46s43ms - Times executed: 100 ]
-
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-08-03 15:02:29 Duration: 798ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
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-08-03 11:02:54 Duration: 790ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
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-08-03 09:36:17 Duration: 729ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-03.log
10 97 1m 151ms 1s681ms 620ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 03 08 18 13s117ms 728ms 09 15 8s893ms 592ms 10 18 9s807ms 544ms 11 6 4s2ms 667ms 13 1 199ms 199ms 14 5 3s532ms 706ms 15 16 9s403ms 587ms 16 17 11s10ms 647ms 17 1 241ms 241ms [ User: intelifix - Total duration: 1m - Times executed: 97 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 97 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '230035589107,230042017994,230044530115,229989584460,230035587894,229982704462,230052199415,230017303540,230047034657,229978495465,230041750416,230042023147,230027444451,230021525366,229977060208,230050270518,230027590325,229987715871,230006648707,230044221319,229976907184,229977316674,229987592526,230052226667,229977091221,230042144247,229981490719,229975499505,229981489405,229977290915,230035557689,230007640914,229987722640,229972052132,230017226383,230019974867,229977049397,230017305257,230041892629,230035465357,229987615154,229967639905,229983142238,230033032135,229987970521,230047422731,230051339498,230014165669,230029388300,229976874858,229987621418,230010886269,229989868809,230053346081,229979300707,230044220511,230052247174,229979659204,230034570815,229987764967,229967993352,230052630423,230027763349,230012374765,230014058284,230042212234,229986202626,230035279199,229975137393,230042221326,230044535973,230044150729,229987772342,229987856266,230027515468,229977456486,230010908998,229968197490,229989584258,230017342029,229975586281,230044223945,230026645473,229981490820,230050273750,229991071418,230012154665,229988481233,230019971029,230035448082,230047236371,230034573340,230017229010,229976852432,229982703351,230050344363,229977074249,229981638083,230027505063,229989535768', '113;1', 'DEFAULT', 00, 0295, '','', '', 00);
Date: 2026-08-03 16:55:42 Duration: 1s681ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'E466AB5AF652,3CF9F069529B,E466AB5ABC4A,E466AB5AF046,9C635B856D02,8493B2DFF333,3CF9F06A6335,9C635B851B12,9C635B857320,E466AB57F5FE', '138;1', 'DEFAULT', 09, 0303, '','', '', 00);
Date: 2026-08-03 10:23:59 Duration: 1s329ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'D83139246162,C4EBFF8D9810,4896D957F5FC,14CA56D4D851,F4E84F88C60A,3891484AA5D7,843C99339797,D89A0DA451AD,843C992E70E1,843C9920B63D,48D6823ACF96,843C992C3C4B,3891484A9701,5872C98ED29D,14CA56CDF901,D89A0DAFF63F,48D682313EC4', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-03 14:53:47 Duration: 1s328ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
11 88 51s145ms 318ms 1s33ms 581ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 03 07 4 2s188ms 547ms 08 9 5s297ms 588ms 09 9 5s736ms 637ms 10 7 4s158ms 594ms 11 10 6s142ms 614ms 12 3 2s74ms 691ms 13 5 2s656ms 531ms 14 14 7s496ms 535ms 15 9 5s222ms 580ms 16 12 6s871ms 572ms 17 5 2s851ms 570ms 18 1 447ms 447ms [ User: intelifix - Total duration: 51s145ms - Times executed: 88 ]
[ Application: [unknown] - Total duration: 51s145ms - Times executed: 88 ]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-03 11:17:28 Duration: 1s33ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
select * from rs_menu_grants (80, 82, 1);
Date: 2026-08-03 12:54:37 Duration: 956ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
select * from rs_menu_grants (184, 20, 1);
Date: 2026-08-03 11:02:54 Duration: 899ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
12 73 30s230ms 260ms 662ms 414ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 03 07 3 1s38ms 346ms 08 7 2s717ms 388ms 09 11 5s295ms 481ms 10 8 3s186ms 398ms 11 14 5s565ms 397ms 12 2 817ms 408ms 13 2 671ms 335ms 14 7 2s979ms 425ms 15 2 794ms 397ms 16 10 4s263ms 426ms 17 7 2s900ms 414ms [ User: intelifix - Total duration: 30s230ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 30s230ms - Times executed: 73 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-08-03 14:32:41 Duration: 662ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-03 17:24:12 Duration: 597ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-03 09:32:20 Duration: 593ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
13 63 23s25ms 154ms 1s905ms 365ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 03 07 2 547ms 273ms 08 5 1s242ms 248ms 09 13 4s700ms 361ms 10 12 4s798ms 399ms 11 6 2s425ms 404ms 14 6 2s625ms 437ms 15 6 1s791ms 298ms 16 9 3s360ms 373ms 17 4 1s532ms 383ms [ User: intelifix - Total duration: 23s25ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 23s25ms - Times executed: 63 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "273449", "oficina" : "6", "cliente" : "5", "usuario" : "417", "nf" : "", "data-saida" : "2026-08-03", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "S", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-03 10:44:30 Duration: 1s905ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "273489", "oficina" : "6", "cliente" : "5", "usuario" : "416", "nf" : "", "data-saida" : "2026-08-03", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-03 14:16:29 Duration: 1s641ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "273449", "oficina" : "6", "cliente" : "5", "usuario" : "417", "nf" : "", "data-saida" : "", "sucata" : "N", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-03 09:53:47 Duration: 1s251ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
14 60 15s226ms 150ms 4s980ms 253ms create table temp0000287096 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 03 07 3 537ms 179ms 08 14 2s213ms 158ms 09 20 3s511ms 175ms 10 20 3s661ms 183ms 11 1 4s980ms 4s980ms 12 2 322ms 161ms [ User: intelifix - Total duration: 15s226ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 15s226ms - Times executed: 60 ]
-
CREATE TABLE temp0000287096 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-07-2026", "ate" :"03-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-03 11:39:33 Duration: 4s980ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287096 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-07-2026", "ate" :"03-08-2026", "nota-fiscal":"70562", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-03 07:58:10 Duration: 212ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287096 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-07-2026", "ate" :"03-08-2026", "nota-fiscal":"122", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-03 10:02:47 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
15 59 13m24s 9s443ms 1m4s 13s638ms create table temp0000287226 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 03 07 12 2m57s 14s811ms 08 14 2m37s 11s234ms 09 15 4m16s 17s108ms 10 6 1m5s 10s863ms 11 12 2m27s 12s318ms [ User: intelifix - Total duration: 13m24s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 13m24s - Times executed: 59 ]
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:30:06 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 07:23:20 Duration: 53s142ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:32:13 Duration: 15s338ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
16 56 29s792ms 329ms 2s737ms 532ms create table temp0000287260 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 03 08 9 6s707ms 745ms 09 16 7s303ms 456ms 10 15 7s948ms 529ms 11 9 4s540ms 504ms 12 7 3s291ms 470ms [ User: intelifix - Total duration: 29s792ms - Times executed: 56 ]
[ Application: [unknown] - Total duration: 29s792ms - Times executed: 56 ]
-
CREATE TABLE temp0000287260 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-07-2026", "ate" :"03-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-03 08:22:56 Duration: 2s737ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287260 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-07-2026", "ate" :"03-08-2026", "nota-fiscal":"82501", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-03 11:32:29 Duration: 764ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287260 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"29-07-2026", "ate" :"03-08-2026", "nota-fiscal":"82501", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-03 10:35:41 Duration: 753ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
17 54 12s714ms 152ms 1s717ms 235ms create table temp0000237386 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 03 15 5 2s868ms 573ms 16 6 1s205ms 200ms 17 43 8s641ms 200ms [ User: intelifix - Total duration: 12s714ms - Times executed: 54 ]
[ Application: [unknown] - Total duration: 12s714ms - Times executed: 54 ]
-
CREATE TABLE temp0000237386 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "29-07-2026", "data-ate" : "03-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-03 15:23:18 Duration: 1s717ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000237386 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "29-07-2026", "data-ate" : "03-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-03 15:28:05 Duration: 591ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000237386 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "03-08-2026", "data-ate" : "03-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-03 17:17:29 Duration: 274ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
18 48 2h26m25s 1s224ms 14m49s 3m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 03 07 3 15m33s 5m11s 08 3 6m50s 2m16s 09 3 10m21s 3m27s 10 3 14m 4m40s 11 3 12m27s 4m9s 12 3 11m22s 3m47s 13 3 5m45s 1m55s 14 3 6m40s 2m13s 15 3 8m4s 2m41s 16 3 7m59s 2m39s 17 3 11m28s 3m49s 18 3 5m54s 1m58s 19 3 5m48s 1m56s 20 3 12m9s 4m3s 21 3 6m3s 2m1s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 2h26m25s - Times executed: 48 ]
[ Application: psql - Total duration: 2h26m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 07:19:51 Duration: 14m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 10:18:11 Duration: 13m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 11:16:44 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
19 47 1h18m21s 203ms 4m50s 1m40s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 03 07 3 6m26s 2m8s 08 3 4m8s 1m22s 09 3 6m30s 2m10s 10 2 4m44s 2m22s 11 3 6m40s 2m13s 12 3 4m43s 1m34s 13 3 3m43s 1m14s 14 3 4m16s 1m25s 15 3 5m44s 1m54s 16 3 4m29s 1m29s 17 3 5m44s 1m54s 18 3 3m45s 1m15s 19 3 3m51s 1m17s 20 3 5m34s 1m51s 21 3 3m53s 1m17s 22 3 4m4s 1m21s [ User: intelifix - Total duration: 1h18m21s - Times executed: 47 ]
[ Application: psql - Total duration: 1h18m21s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 11:24:01 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 10:25:23 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 09:21:37 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
20 47 11s693ms 152ms 900ms 248ms select * from rs_etiqueta (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 03 00 1 192ms 192ms 03 1 286ms 286ms 07 6 1s445ms 240ms 08 6 1s163ms 193ms 09 6 1s355ms 225ms 10 5 1s124ms 224ms 11 7 1s628ms 232ms 13 1 191ms 191ms 14 1 206ms 206ms 16 6 1s337ms 222ms 17 1 194ms 194ms 20 1 162ms 162ms 23 5 2s404ms 480ms [ User: etiquetas - Total duration: 11s693ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 11s693ms - Times executed: 47 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-03 23:24:49 Duration: 900ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-08-03 23:39:43 Duration: 811ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_ETIQUETA ('229652978488');
Date: 2026-08-03 07:09:18 Duration: 485ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-03.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m31s 9m44s 5m30s 3 16m31s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 03 05 3 16m31s 5m30s [ User: intelifix - Total duration: 16m31s - Times executed: 3 ]
[ Application: psql - Total duration: 16m31s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-03 05:09:46 Duration: 9m44s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
analyze verbose;
Date: 2026-08-03 05:14:01 Duration: 4m15s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
analyze verbose;
Date: 2026-08-03 05:16:32 Duration: 2m31s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
2 1s224ms 14m49s 3m3s 48 2h26m25s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 03 07 3 15m33s 5m11s 08 3 6m50s 2m16s 09 3 10m21s 3m27s 10 3 14m 4m40s 11 3 12m27s 4m9s 12 3 11m22s 3m47s 13 3 5m45s 1m55s 14 3 6m40s 2m13s 15 3 8m4s 2m41s 16 3 7m59s 2m39s 17 3 11m28s 3m49s 18 3 5m54s 1m58s 19 3 5m48s 1m56s 20 3 12m9s 4m3s 21 3 6m3s 2m1s 22 3 5m55s 1m58s [ User: intelifix - Total duration: 2h26m25s - Times executed: 48 ]
[ Application: psql - Total duration: 2h26m25s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 07:19:51 Duration: 14m49s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 10:18:11 Duration: 13m9s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-03 11:16:44 Duration: 11m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
3 1m46s 1m46s 1m46s 1 1m46s select * from rs_smart_fiscal_saida () / 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 (/ 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 #3
Day Hour Count Duration Avg duration Aug 03 10 1 1m46s 1m46s [ User: intelifix - Total duration: 1m46s - Times executed: 1 ]
[ Application: psql - Total duration: 1m46s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (/ usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 10:19:57 Duration: 1m46s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
4 203ms 4m50s 1m40s 47 1h18m21s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 03 07 3 6m26s 2m8s 08 3 4m8s 1m22s 09 3 6m30s 2m10s 10 2 4m44s 2m22s 11 3 6m40s 2m13s 12 3 4m43s 1m34s 13 3 3m43s 1m14s 14 3 4m16s 1m25s 15 3 5m44s 1m54s 16 3 4m29s 1m29s 17 3 5m44s 1m54s 18 3 3m45s 1m15s 19 3 3m51s 1m17s 20 3 5m34s 1m51s 21 3 3m53s 1m17s 22 3 4m4s 1m21s [ User: intelifix - Total duration: 1h18m21s - Times executed: 47 ]
[ Application: psql - Total duration: 1h18m21s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 11:24:01 Duration: 4m50s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 10:25:23 Duration: 4m42s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-03 09:21:37 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
5 4s150ms 1m28s 45s3ms 4 3m copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 03 20 2 1m27s 43s732ms 23 2 1m32s 46s274ms [ User: intelifix - Total duration: 3m - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-03 23:16:23 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-03 20:08:24 Duration: 1m23s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-03 23:34:14 Duration: 4s356ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-03.log
6 153ms 23m52s 36s967ms 272 2h47m35s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 03 07 6 13m16s 2m12s 08 13 6m42s 30s990ms 09 28 34m25s 1m13s 10 34 22m57s 40s505ms 11 24 53m57s 2m14s 12 9 2m24s 16s59ms 13 3 4s960ms 1s653ms 14 40 12m46s 19s169ms 15 35 6m28s 11s101ms 16 41 10m31s 15s399ms 17 39 3m59s 6s142ms [ User: intelifix - Total duration: 2h47m35s - Times executed: 272 ]
[ Application: [unknown] - Total duration: 2h47m35s - Times executed: 272 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-08-03 11:21:00 Duration: 23m52s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-31'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-03 09:37:58 Duration: 16m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027921, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-03 09:42:47 Duration: 10m26s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
7 9s443ms 1m4s 13s638ms 59 13m24s create table temp0000287226 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 03 07 12 2m57s 14s811ms 08 14 2m37s 11s234ms 09 15 4m16s 17s108ms 10 6 1m5s 10s863ms 11 12 2m27s 12s318ms [ User: intelifix - Total duration: 13m24s - Times executed: 59 ]
[ Application: [unknown] - Total duration: 13m24s - Times executed: 59 ]
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:30:06 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 07:23:20 Duration: 53s142ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287226 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:32:13 Duration: 15s338ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
8 11s572ms 14s390ms 12s624ms 9 1m53s create table temp0000287276 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 03 09 9 1m53s 12s624ms [ User: intelifix - Total duration: 1m53s - Times executed: 9 ]
[ Application: [unknown] - Total duration: 1m53s - Times executed: 9 ]
-
CREATE TABLE temp0000287276 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:34:23 Duration: 14s390ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287276 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:33:41 Duration: 14s105ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287276 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 09:35:59 Duration: 13s151ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
9 10s129ms 13s160ms 11s275ms 21 3m56s create table temp0000287316 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 03 14 9 1m41s 11s238ms 15 6 1m9s 11s568ms 16 6 1m6s 11s39ms [ User: intelifix - Total duration: 3m56s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 3m56s - Times executed: 21 ]
-
CREATE TABLE temp0000287316 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 14:06:20 Duration: 13s160ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287316 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 15:02:20 Duration: 12s276ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287316 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 16:26:59 Duration: 12s31ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
10 9s887ms 12s581ms 11s54ms 17 3m7s create table temp0000287292 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 03 11 17 3m7s 11s54ms [ User: intelifix - Total duration: 3m7s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m7s - Times executed: 17 ]
-
CREATE TABLE temp0000287292 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 11:28:50 Duration: 12s581ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287292 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 11:24:25 Duration: 12s141ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287292 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 11:28:27 Duration: 11s869ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
11 9s545ms 11s887ms 10s878ms 10 1m48s create table temp0000287360 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 03 16 4 44s665ms 11s166ms 17 6 1m4s 10s685ms [ User: intelifix - Total duration: 1m48s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 10 ]
-
CREATE TABLE temp0000287360 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 16:23:56 Duration: 11s887ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287360 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 17:25:56 Duration: 11s469ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CREATE TABLE temp0000287360 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-03 16:24:38 Duration: 11s403ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
12 154ms 48s147ms 10s111ms 25 4m12s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 03 07 3 56s133ms 18s711ms 08 2 4s449ms 2s224ms 09 4 1m22s 20s512ms 10 3 25s71ms 8s357ms 11 5 12s579ms 2s515ms 14 2 43s955ms 21s977ms 15 1 7s370ms 7s370ms 16 4 20s932ms 5s233ms 17 1 237ms 237ms [ User: intelifix - Total duration: 4m12s - Times executed: 25 ]
[ Application: psql - Total duration: 4m12s - Times executed: 25 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027911);
Date: 2026-08-03 07:24:22 Duration: 48s147ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027921);
Date: 2026-08-03 09:32:22 Duration: 40s335ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027937);
Date: 2026-08-03 14:07:57 Duration: 37s571ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
13 246ms 1m57s 6s865ms 35 4m select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 03 07 4 3s367ms 841ms 08 5 3s680ms 736ms 09 6 2m3s 20s554ms 10 3 1m6s 22s90ms 11 7 14s99ms 2s14ms 14 3 3s768ms 1s256ms 15 2 1s10ms 505ms 16 3 12s572ms 4s190ms 17 2 12s211ms 6s105ms [ User: intelifix - Total duration: 4m - Times executed: 35 ]
[ Application: psql - Total duration: 4m - Times executed: 35 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027922);
Date: 2026-08-03 09:35:02 Duration: 1m57s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027928);
Date: 2026-08-03 10:56:13 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027941);
Date: 2026-08-03 16:24:28 Duration: 11s608ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
14 156ms 1m24s 5s639ms 114 10m42s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 03 00 1 637ms 637ms 03 1 406ms 406ms 07 11 1m13s 6s711ms 08 12 1m34s 7s884ms 09 12 1m22s 6s856ms 10 12 1m21s 6s752ms 11 12 1m32s 7s747ms 12 6 13s446ms 2s241ms 13 5 6s856ms 1s371ms 14 6 9s480ms 1s580ms 15 6 18s74ms 3s12ms 16 10 2m 12s7ms 17 6 8s864ms 1s477ms 18 1 626ms 626ms 20 2 906ms 453ms 21 5 17s770ms 3s554ms 22 6 21s42ms 3s507ms [ User: intelifix - Total duration: 10m42s - Times executed: 114 ]
[ Application: psql - Total duration: 10m42s - Times executed: 114 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 16:26:26 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 07:15:24 Duration: 22s724ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-03 11:25:20 Duration: 19s83ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
15 166ms 7m32s 5s278ms 274 24m6s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 03 00 12 48s635ms 4s52ms 01 12 24s797ms 2s66ms 02 12 25s175ms 2s97ms 03 10 21s498ms 2s149ms 04 12 24s721ms 2s60ms 05 12 24s753ms 2s62ms 06 12 24s145ms 2s12ms 07 12 28s326ms 2s360ms 08 12 27s552ms 2s296ms 09 12 8m6s 40s512ms 10 12 26s482ms 2s206ms 11 12 2m50s 14s224ms 12 12 22s629ms 1s885ms 13 12 26s262ms 2s188ms 14 12 25s747ms 2s145ms 15 12 3m56s 19s690ms 16 12 25s564ms 2s130ms 17 12 26s719ms 2s226ms 18 12 24s643ms 2s53ms 19 12 23s505ms 1s958ms 20 12 52s930ms 4s410ms 21 12 25s75ms 2s89ms 22 12 24s55ms 2s4ms [ User: intelifix - Total duration: 24m6s - Times executed: 274 ]
[ Application: psql - Total duration: 24m6s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 09:42:50 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 15:08:34 Duration: 3m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-03 11:37:40 Duration: 2m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
16 748ms 11s249ms 3s730ms 33 2m3s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 03 08 3 8s386ms 2s795ms 09 2 18s954ms 9s477ms 10 3 22s471ms 7s490ms 11 2 19s131ms 9s565ms 12 2 5s675ms 2s837ms 13 2 1s622ms 811ms 14 2 5s174ms 2s587ms 15 2 11s221ms 5s610ms 16 2 12s565ms 6s282ms 17 3 2s568ms 856ms 18 2 3s513ms 1s756ms 19 2 1s978ms 989ms 20 3 7s280ms 2s426ms 21 2 1s510ms 755ms 22 1 1s50ms 1s50ms [ User: intelifix - Total duration: 2m3s - Times executed: 33 ]
[ Application: psql - Total duration: 2m3s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 09:40:13 Duration: 11s249ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 11:00:12 Duration: 10s801ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-03 10:20:11 Duration: 10s333ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-03.log
17 1s137ms 10s251ms 2s721ms 40 1m48s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 03 07 3 16s677ms 5s559ms 09 3 15s512ms 5s170ms 10 2 8s30ms 4s15ms 11 2 3s521ms 1s760ms 12 2 2s703ms 1s351ms 14 7 17s630ms 2s518ms 15 5 11s29ms 2s205ms 16 4 14s373ms 3s593ms 17 11 17s387ms 1s580ms 18 1 1s991ms 1s991ms [ User: intelifix - Total duration: 1m48s - Times executed: 40 ]
[ Application: [unknown] - Total duration: 1m48s - Times executed: 40 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-31', 0404, '', '', 0, 7, '2026-07-01');
Date: 2026-08-03 07:10:15 Duration: 10s251ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-03 16:57:27 Duration: 9s374ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-03', 0395, '', '', 0, 6, '2026-08-01');
Date: 2026-08-03 14:59:44 Duration: 8s861ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
18 185ms 26s660ms 1s934ms 115 3m42s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 03 09 4 1m19s 19s815ms 10 9 26s439ms 2s937ms 14 27 44s124ms 1s634ms 15 28 27s81ms 967ms 16 22 27s243ms 1s238ms 17 25 18s368ms 734ms [ User: intelifix - Total duration: 3m42s - Times executed: 115 ]
[ Application: [unknown] - Total duration: 3m42s - Times executed: 115 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048105) LIMIT 1;
Date: 2026-08-03 09:31:20 Duration: 26s660ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048104) LIMIT 1;
Date: 2026-08-03 09:32:58 Duration: 24s745ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-08-03 09:15:46 Duration: 20s633ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
19 150ms 10s284ms 1s482ms 1,090 26m56s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 03 07 11 7s699ms 699ms 08 78 1m57s 1s504ms 09 137 3m29s 1s532ms 10 179 4m5s 1s370ms 11 121 2m56s 1s458ms 12 63 1m36s 1s525ms 13 47 51s178ms 1s88ms 14 125 3m45s 1s804ms 15 139 4m14s 1s828ms 16 108 2m36s 1s446ms 17 82 1m16s 930ms [ User: intelifix - Total duration: 26m56s - Times executed: 1090 ]
[ Application: [unknown] - Total duration: 26m56s - Times executed: 1090 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273477, 508, '923181029036,94988F959AB3,B0BBE54D30A3,D0CF0EFD89FA,44D454604026,44D45469DB5E,94988F308741,94988F3070FF,C4EB42A06EC7,38A659237C95,94988F2FCDD6,8CFDDE98234C,C4EB42A09CF6,ACD75BB8462F,6CBAB8F16866,943C96AC2FB5,E4C0E290149E,94988F307B6A,3453D2A7E83F,5CFA259BE8DE,943C96AB1EC3,ACD75BB7FC07', '',0155,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-03 16:36:32 Duration: 10s284ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48644, 417, '270911021423100261,229884361520,229780684353,229747607488,229786779112,229808501019,229741562230,229781486990,229933963555,229691528907,229813794453,229743724158,229813498991,229879770410,229667789306,229671447384,229748409294,229742677377,229837220814,229737746481,229747730913,229669058082,229816889110,216940447986,216940057286,216939931416,229813113141,229691122627,229743537697,229663016584,229750533947,229740474256,229860075468,229859809202,216939703133,229748549107,229747057681,229866003948,229691464456,229739005762,229810947272,229816868906,229747105464,229810163650,229808268391,229751897278,229742673842,229933953049', '246652245253,246584779208,246571527981,246598208789,246618509200,246527361113,246584776985,246310382440,246506994557,246628929409,226066362530,246629875775,246652909314,246498421824,246514394258,246548477090,246549386685,246640725880,246569591329,246548574350,246515925967,246628230924,246475641924,246463377898,246465034951,246627479098,246514070714,246547268397,246487250824,246562957998,246574934869,246651759617,246648477489,246463533649,246551076064,246555645657,246653654448,246516341721,246527955166,246640372232,246628910519,246558987588,246626926789,246619287491,246529779912,246550870512,246338571824,,,', 0141, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-08-03 09:13:15 Duration: 9s98ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (273478, 304, 'CP2207LV5VU,3C82C0CA2CBC$CP2435LV5BF,C4509CF0BDA4$CP2046LV076,484BD4A0157C$CP2528LV5ZW,F8D2AC963B04$CP2301LV5F2,B85E71E70374$CP2145LV21U,D4E2CB1FC734$CP2429LV6AQ,C4509CBD2A0C$CP2429LV0CY,C4509CBCD144$CP2247LV4ST,F8D2AC142494$CP2233LVD23,4075C3B364C8$CP2530LV1DA,3C82C08DEE8C$CP2238LVC4H,4075C3C157E0$CP2139LV1YE,ECA81F6D9694$CP2238LV6EA,4075C3C14110$CP2111LV2R8,08A7C04C9164$CP2139LV4RB,ECA81FF470AC$CP2206LV1JU,3C82C0693408$CP2534LV33C,3C82C0906AA4$CP2248LV65F,B85E71D92E34$CP2529LVA8N,3C82C08D9270$CP2205LV2NL,1C9D7282C134$CP2120LV347,08A7C06C4F04$CP2240LV5MS,B85E71C311E4$CP2302LVBDY,B85E71E939B4$CP2142LV8T1,ECA81FF97F5C$CP2145LV4GG,D4E2CB1FB1A4$CP2147LV7VS,D4E2CB9288A4$CP2532LV03W,3C82C08FF7B8$CP2233LV75K,4075C3B2CD88$CP2531LV5WA,3C82C08F126C$CP2301LV3ZH,B85E71E6DB24$CP2431LV56E,C4509CBD3DD4$CP2531LV5H5,3C82C0903EE4$CP2249LVAT2,B85E71DC7C9C$CP2248LVGS4,B85E71DC5050$CP2139LV8QH,ECA81FF593DC$CP2233LVBF9,4075C3B550E4$CP2534LV05V,3C82C0905FF0$CP2429LV5GY,C4509CBD67D4', '',0185,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-03 16:08:29 Duration: 8s417ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
20 151ms 3s360ms 960ms 778 12m27s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 03 08 95 1m40s 1s53ms 09 130 2m19s 1s71ms 10 162 2m44s 1s18ms 11 116 1m46s 918ms 12 13 9s656ms 742ms 13 8 10s658ms 1s332ms 14 60 1m1s 1s22ms 15 91 1m19s 877ms 16 70 54s728ms 781ms 17 33 20s88ms 608ms [ User: intelifix - Total duration: 12m27s - Times executed: 778 ]
[ Application: [unknown] - Total duration: 12m27s - Times executed: 778 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273453", "modelo" : "318", "itens" : "D83139A0E2A2,4896D95472F8,D89A0DB0D673,D89A0DA67A97,3CF9F0AF7500,3CF9F0AB3D2A,C4EBFF8D3264,3CF9F0A8D45C,3891484D6671,F4E84F839090,C4EBFF8D5CD0,48D68239A5E2,F00C514C946A,3891484A792B,14CA56D284E3,F4E84F822E60,843C99360A19,689E29BD1605,3CF9F0AE06F4,4896D956EF2E", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 08:49:09 Duration: 3s360ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273465", "modelo" : "318", "itens" : "D89A0DA515FD,5872C991EC65,843C992F4A85,D89A0DA53847,843C99215735,C4EBFF8E60A4,5872C989BA21,6C11BA630603,D89A0D83E4FD,D89A0DA6F86D,D83139A1838E,4896D94FF2EC,D89A0DAC3933,3CF9F06FAB03,3CF9F0A30ADA,F4E84F861554,4896D9534122,48D6823061DE,14CA56D45E71,3891484F8C31", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 09:20:13 Duration: 3s336ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "273491", "modelo" : "464", "itens" : "241747932446,241762294150,241767097379,241747983539,241738953051,241766809090,241748064355,241767008909,241767009717,241740065976,241741064547,241744446482,241766684859,241766275268,241766177177,241741133443,241766446070,241747051619,241741186276,241743742340,241741247595,241773562130,241747013052,241747052528,241763107596,241767066669,241762308898,241747047274,241763794970,241739791730,241759868605,241742078495,241766301332,241766282037,241767101825,241747047577,241740851418,241763792546,241763769917,241763116890,241770876783,241763791435,241769672233,241745422627,241769686476,241741142434,241762119105,241760929202,241766582425,241766198189,241743833134,241766430817,241762137591,241766365860,241766119292,241762082132,241769559113,241763637378,241762198608,241762053745", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-03 09:45:26 Duration: 3s255ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-03.log
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 17 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 02 09 2 0ms 0ms 10 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 19 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms Aug 03 13 1 0ms 0ms 18 1 0ms 0ms 19 2 0ms 0ms 20 2 0ms 0ms 21 2 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 12m14s - Times executed: 17 ]
[ Application: psql - Total duration: 12m14s - Times executed: 17 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 14,878 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 20 FATAL entries
- 3011 ERROR entries
- 0 WARNING entries
- 11 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,904 Max number of times the same event was reported
- 3,042 Total events found
Rank Times reported Error 1 2,904 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 03 00 58 01 56 02 57 03 53 04 55 05 56 06 54 07 135 08 256 09 301 10 273 11 235 12 121 13 131 14 203 15 196 16 176 17 160 18 57 19 57 20 54 21 56 22 56 23 48 - ERROR: prepared statement "_PLAN0000000041167DD0" does not exist
- ERROR: prepared statement "_PLAN0000000041162720" does not exist
- ERROR: prepared statement "_PLAN0000000041160730" does not exist
Statement: DEALLOCATE "_PLAN0000000041167DD0"
Date: 2026-08-03 00:00:19 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Statement: DEALLOCATE "_PLAN0000000041162720"
Date: 2026-08-03 00:01:20 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Statement: DEALLOCATE "_PLAN0000000041160730"
Date: 2026-08-03 00:02:23 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
2 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 03 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-08-03 08:00:08 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
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-08-03 08:20:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
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-08-03 08:40:04 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
3 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 03 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 1 - 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-08-03 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
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-08-03 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
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-08-03 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
4 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 03 00 1 02 7 04 1 06 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-03 00:02:04 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Date: 2026-08-03 02:19:14 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Date: 2026-08-03 02:19:29 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
5 10 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 03 09 2 11 6 15 2 - LOG: process 721497 still waiting for ShareLock on transaction 3736446 after 1000.306 ms
- LOG: process 721497 still waiting for ShareLock on transaction 3736446 after 55636.977 ms
- LOG: process 801454 still waiting for ShareLock on transaction 3745566 after 1000.123 ms
Detail: Process holding the lock: 697471. Wait queue: 721497.
Context: while updating tuple (75586,80) 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-08-03 09:35:23 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Detail: Process holding the lock: 697471. Wait queue: 721497.
Context: while updating tuple (75586,80) 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-08-03 09:36:18 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Detail: Process holding the lock: 798620. Wait queue: 801454.
Context: while updating tuple (75676,83) 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,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027928, 0305 )' , '/var/www/html/tmp/nf_carga_lotes_0305.xlsx' )Date: 2026-08-03 11:12:41 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
6 7 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 03 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-08-03 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Date: 2026-08-03 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Date: 2026-08-03 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 03 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-03 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-03 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-03 05:32:09 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
8 4 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 03 14 4 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
- ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(50126,417,'246233306982$226292871718$226411960221$226344251828$226209796180$226150993539$246029541833$246094402843$246094406075$246272704464$246035002029$246329262644$226267069716$246264730510$226343099504$226237325466$226109478500$246221024852$226408429101$246337483951$246280215668$246081479000$246081540623$246148686176$246087710518$226390079914$246342380322$226273284969$226071929908$246101390001$246156162933$246239808605$246206970810$226186113555$226004205274$246314688392$226065132747$246040783446$226310038196$226330159699$226387286375$246219740014$246180874357$226006275375$246336663557$226157189092$246284681133$246110982643$246344528689$246273184163','',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0246094406075);Date: 2026-08-03 14:42:51 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(50126,417,'246233306982$226292871718$226411960221$226344251828$226209796180$226150993539$246029541833$246094402843$246094406075$246272704464$246035002029$246329262644$226267069716$246264730510$226343099504$226237325466$226109478500$246221024852$226408429101$246337483951$246280215668$246081479000$246081540623$246148686176$246087710518$226390079914$246342380322$226273284969$226071929908$246101390001$246156162933$246239808605$246206970810$226186113555$226004205274$246314688392$226065132747$246040783446$226310038196$226330159699$226387286375$246219740014$246180874357$226006275375$246336663557$226157189092$246284681133$246110982643$246344528689$246273184163','',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0246094406075);Date: 2026-08-03 14:43:37 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(50126,417,'246273184163$246344528689$246110982643$246284681133$226157189092$246336663557$226006275375$246180874357$246219740014$226387286375$226330159699$226310038196$246040783446$226065132747$246314688392$226004205274$226186113555$246206970810$246239808605$246156162933$246101390001$226071929908$226273284969$246342380322$226390079914$246087710518$246081479000$246148686176$246081540623$246280215668$246337483951$226408429101$246221024852$226109478500$226237325466$226343099504$246264730510$226267069716$246329262644$246035002029$246272704464$246094406075$246094402843$246029541833$226150993539$226209796180$226411960221$226344251828$226292871718$246233306982','',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0246094406075);Date: 2026-08-03 14:45:45 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
9 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 03 08 2 14 1 - ERROR: column "c85d38fe0417" does not exist at character 27
- ERROR: column "c85d38fe0417" does not exist at character 27
- ERROR: column "controle" does not exist at character 36
Statement: select * from rs_caixa_qr(C85D38FE0417)
Date: 2026-08-03 08:04:24 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Statement: select * from rs_caixa_qr(C85D38FE0417)
Date: 2026-08-03 08:04:25 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Statement: SELECT * FROM temp0000237324 WHERE CONTROLE='L'
Date: 2026-08-03 14:06:18 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
10 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 03 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Date: 2026-08-03 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Date: 2026-08-03 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
11 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 03 08 2 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
Statement: select * from rs_caixa_qr(3378966 ])
Date: 2026-08-03 08:31:29 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
Statement: select * from rs_caixa_qr(3378966 ])
Date: 2026-08-03 08:31:29 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
12 1 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 03 07 1 - ERROR: trailing junk after numeric literal at or near "843C9936637D" at character 41
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''843C9936637D');
Date: 2026-08-03 07:50:57 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
13 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 03 07 1 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 85
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( '2026-07-31', 0404 ,'', '',0,7,'N-Na--N-Na');
Date: 2026-08-03 07:10:00 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
14 1 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 03 11 1 - ERROR: invalid input syntax for type integer: ""
Context: PL/pgSQL function rs_pre_alerta_tela(text) line 30 at assignment
Statement: SELECT * FROM RS_PRE_ALERTA_TELA('{"barra1":"ZTE3A8TR8U04589","barra2":"CLARO_07F856","barra3":"","lote":""}');Date: 2026-08-03 11:26:59 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
15 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 03 22 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-03 22:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-03.log
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 03 03 1 - LOG: database system was shut down at 2026-08-03 03:05:01 -03
Date: 2026-08-03 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-03.log