pgBadger-
Global information
- Generated on Fri Aug 28 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 43,071 log entries in 14s
- Log start from 2026-08-27 00:00:25 to 2026-08-27 23:59:56
-
Overview
Global Stats
- 411 Number of unique normalized queries
- 6,248 Number of queries
- 9h11m29s Total query duration
- 2026-08-27 00:02:58 First query
- 2026-08-27 23:52:53 Last query
- 6 queries/s at 2026-08-27 15:16:13 Query peak
- 9h11m29s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h11m29s Execute total duration
- 4,426 Number of events
- 15 Number of unique normalized events
- 4,362 Max number of times the same event was reported
- 0 Number of cancellation
- 383 Total number of automatic vacuums
- 837 Total number of automatic analyzes
- 12 Number temporary file
- 242.91 MiB Max size of temporary file
- 103.85 MiB Average size of temporary file
- 366 Total number of sessions
- 8 sessions at 2026-08-27 19:08:42 Session peak
- 14d33m41s Total duration of sessions
- 55m10s Average duration of sessions
- 17 Average queries per session
- 1m30s Average queries duration per session
- 53m40s Average idle time per session
- 377 Total number of connections
- 3 connections/s at 2026-08-27 03:05:17 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-08-27 15:16:13 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-08-27 15:16:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-08-27 11:29:01 Date
Queries duration
Key values
- 9h11m29s 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 27 00 25 0ms 55s657ms 8s456ms 7s892ms 25s321ms 1m16s 01 39 0ms 6s107ms 1s371ms 5s461ms 8s411ms 9s71ms 02 20 0ms 6s603ms 2s171ms 6s243ms 7s84ms 8s81ms 03 19 0ms 6s267ms 2s290ms 4s850ms 7s178ms 9s301ms 04 38 0ms 5s912ms 1s439ms 5s118ms 8s68ms 9s784ms 05 42 0ms 10m32s 33s456ms 17s69ms 3m 10m32s 06 24 0ms 52s36ms 5s742ms 5s117ms 24s193ms 52s36ms 07 215 0ms 10m7s 10s867ms 1m9s 5m22s 10m37s 08 422 0ms 6m32s 4s716ms 1m6s 3m48s 6m38s 09 620 150ms 8m43s 4s198ms 1m29s 4m41s 8m54s 10 555 150ms 6m55s 3s778ms 1m5s 4m21s 7m16s 11 689 150ms 21m46s 5s25ms 1m24s 6m58s 21m59s 12 223 0ms 7m10s 8s586ms 55s274ms 4m18s 7m58s 13 348 0ms 6m25s 3s820ms 48s492ms 1m23s 6m25s 14 913 150ms 7m45s 2s784ms 1m15s 4m42s 7m51s 15 714 150ms 7m37s 4s472ms 1m22s 7m39s 13m51s 16 519 0ms 7m38s 3s724ms 46s241ms 2m17s 7m47s 17 278 0ms 7m2s 4s944ms 40s823ms 1m41s 7m54s 18 37 0ms 6m9s 18s550ms 6s245ms 17s265ms 6m43s 19 24 0ms 5m56s 27s616ms 5s604ms 56s528ms 5m56s 20 120 0ms 6m18s 10s532ms 1m6s 2m22s 6m57s 21 38 0ms 6m5s 17s760ms 6s873ms 10s252ms 6m52s 22 31 0ms 5m44s 20s860ms 8s663ms 49s5ms 5m44s 23 295 0ms 1m45s 8s229ms 1m7s 1m15s 1m54s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 27 00 3 0 26s993ms 0ms 0ms 25s321ms 01 23 0 367ms 158ms 534ms 2s10ms 02 2 0 387ms 0ms 0ms 0ms 03 1 0 197ms 0ms 0ms 0ms 04 21 0 300ms 163ms 389ms 1s126ms 05 19 0 327ms 181ms 417ms 817ms 06 8 0 9s760ms 0ms 0ms 24s193ms 07 159 0 12s484ms 4s923ms 55s309ms 7m37s 08 293 0 5s238ms 9s72ms 58s374ms 5m28s 09 483 0 4s316ms 33s733ms 1m11s 6m43s 10 448 0 3s930ms 20s19ms 51s781ms 6m31s 11 515 0 6s138ms 22s418ms 1m1s 7m57s 12 147 0 10s773ms 8s356ms 50s985ms 6m37s 13 297 0 4s136ms 18s325ms 42s912ms 3m41s 14 737 0 2s921ms 34s570ms 1m6s 7m4s 15 514 0 4s907ms 13s682ms 23s89ms 7m50s 16 376 0 4s199ms 29s58ms 42s324ms 4m24s 17 174 0 6s983ms 12s625ms 37s220ms 3m56s 18 15 0 42s719ms 0ms 2s117ms 3m24s 19 6 0 1m43s 0ms 0ms 3m29s 20 15 85 12s168ms 38s248ms 1m4s 3m25s 21 14 0 44s207ms 0ms 0ms 3m22s 22 7 0 1m24s 0ms 0ms 3m18s 23 22 273 8s229ms 1m4s 1m6s 1m45s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 27 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 27 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 1 1.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 13 13.00 0.00% 08 0 13 13.00 0.00% 09 0 14 14.00 0.00% 10 0 11 11.00 0.00% 11 0 14 14.00 0.00% 12 0 6 6.00 0.00% 13 0 10 10.00 0.00% 14 0 11 11.00 0.00% 15 0 12 12.00 0.00% 16 0 12 12.00 0.00% 17 0 6 6.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 6 6.00 0.00% Day Hour Count Average / Second Aug 27 00 14 0.00/s 01 10 0.00/s 02 7 0.00/s 03 15 0.00/s 04 11 0.00/s 05 10 0.00/s 06 14 0.00/s 07 20 0.01/s 08 23 0.01/s 09 28 0.01/s 10 17 0.00/s 11 23 0.01/s 12 13 0.00/s 13 20 0.01/s 14 22 0.01/s 15 23 0.01/s 16 21 0.01/s 17 16 0.00/s 18 12 0.00/s 19 11 0.00/s 20 12 0.00/s 21 12 0.00/s 22 9 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Aug 27 00 8 57m 56m33s 01 13 1h41s 1h37s 02 10 1h36s 1h31s 03 14 17m16s 17m13s 04 7 1h3m 1h2m52s 05 9 1h40s 58m4s 06 9 57m19s 57m3s 07 14 57m55s 55m8s 08 22 55m 53m30s 09 25 51m40s 49m56s 10 23 54m33s 53m2s 11 20 52m58s 50m4s 12 17 59m46s 57m53s 13 14 53m32s 51m57s 14 23 1h9m53s 1h8m2s 15 22 55m34s 53m9s 16 20 1h9s 58m33s 17 22 55m43s 54m41s 18 15 57m17s 56m31s 19 12 56m5s 55m10s 20 13 47m23s 45m46s 21 10 55m35s 54m28s 22 11 1h47s 59m49s 23 13 43m58s 40m51s -
Connections
Established Connections
Key values
- 3 connections Connection Peak
- 2026-08-27 03:05:17 Date
Connections per database
Key values
- rio Main Database
- 377 connections Total
Connections per user
Key values
- intelifix Main User
- 377 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-27 19:08:42 Date
Histogram of session times
Key values
- 311 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 366 sessions Total
Sessions per user
Key values
- intelifix Main User
- 366 sessions Total
Sessions per host
Key values
- [local] Main Host
- 366 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 366 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 51,009 buffers Checkpoint Peak
- 2026-08-27 00:09:44 Date
- 270.018 seconds Highest write time
- 0.139 seconds Sync time
Checkpoints Wal files
Key values
- 23 files Wal files usage Peak
- 2026-08-27 16:04:37 Date
Checkpoints distance
Key values
- 749.29 Mo Distance Peak
- 2026-08-27 16:04:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 27 00 66,930 628.9s 0.027s 628.99s 01 2,794 280.389s 0.237s 280.746s 02 1,259 126.414s 0.157s 126.68s 03 1,138 114.262s 0.24s 114.569s 04 2,957 296.585s 0.074s 296.736s 05 10,960 1,086.017s 0.101s 1,086.218s 06 5,239 269.129s 0.004s 269.149s 07 30,981 2,409.164s 0.227s 2,409.507s 08 59,848 2,945.046s 0.33s 2,945.515s 09 54,963 3,195.759s 0.525s 3,196.553s 10 79,006 3,224.161s 0.424s 3,224.754s 11 71,122 3,238.891s 0.537s 3,239.613s 12 47,086 2,206.91s 0.159s 2,207.264s 13 24,468 2,239.786s 0.287s 2,240.177s 14 50,351 3,238.029s 0.567s 3,238.794s 15 56,867 3,239.058s 0.453s 3,239.681s 16 46,468 3,106.503s 0.284s 3,106.919s 17 28,415 2,071.223s 0.254s 2,071.597s 18 2,060 206.471s 0.041s 206.541s 19 27 2.738s 0.037s 2.801s 20 1,815 188.677s 0.014s 188.715s 21 3,243 325.974s 0.14s 326.235s 22 1,850 185.698s 0.061s 185.814s 23 412 41.424s 0.094s 41.566s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 27 00 0 0 13 391 0.008s 0.005s 01 0 0 0 617 0.063s 0.011s 02 0 0 1 413 0.066s 0.008s 03 0 0 0 327 0.065s 0.008s 04 0 0 1 611 0.011s 0.008s 05 0 0 5 773 0.040s 0.008s 06 0 0 1 10 0.003s 0.001s 07 0 0 21 3,934 0.058s 0.012s 08 0 0 39 4,988 0.023s 0.012s 09 0 0 27 6,819 0.025s 0.012s 10 0 0 43 5,898 0.042s 0.012s 11 0 0 35 6,220 0.065s 0.012s 12 0 0 28 3,301 0.029s 0.012s 13 0 0 15 4,013 0.046s 0.012s 14 0 0 35 6,848 0.060s 0.012s 15 0 0 52 6,412 0.063s 0.012s 16 0 0 55 5,619 0.027s 0.012s 17 0 0 18 4,343 0.063s 0.012s 18 0 0 0 315 0.013s 0.006s 19 0 0 0 7 0.034s 0.008s 20 0 0 1 89 0.006s 0.003s 21 0 0 1 507 0.064s 0.01s 22 0 0 1 423 0.015s 0.01s 23 0 0 0 119 0.063s 0.009s Day Hour Count Avg time (sec) Aug 27 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 27 00 39,865.00 kB 97,654.80 kB 01 1,635.00 kB 49,657.22 kB 02 1,064.33 kB 22,819.17 kB 03 866.86 kB 3,432.00 kB 04 2,069.38 kB 3,091.12 kB 05 9,697.88 kB 15,472.62 kB 06 9,592.00 kB 14,458.00 kB 07 28,944.08 kB 55,540.08 kB 08 53,436.17 kB 134,318.50 kB 09 37,518.83 kB 94,057.25 kB 10 58,515.33 kB 92,314.58 kB 11 47,719.67 kB 85,926.08 kB 12 38,318.00 kB 82,552.00 kB 13 20,366.50 kB 51,004.00 kB 14 47,433.58 kB 89,751.17 kB 15 70,964.33 kB 103,175.17 kB 16 75,126.42 kB 248,717.00 kB 17 24,111.92 kB 96,767.00 kB 18 1,724.17 kB 39,458.33 kB 19 99.00 kB 25,790.00 kB 20 5,550.00 kB 21,193.67 kB 21 2,430.33 kB 14,189.67 kB 22 1,183.88 kB 7,671.25 kB 23 167.22 kB 3,498.00 kB -
Temporary Files
Size of temporary files
Key values
- 485.83 MiB Temp Files size Peak
- 2026-08-27 05:32:02 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-27 05:32:10 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.22 GiB 103.85 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 943.55 MiB 72.45 MiB 242.91 MiB 117.94 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-27 05:32:11 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-27 05:32:02 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 4 302.67 MiB 56.27 MiB 92.59 MiB 75.67 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-27 05:30:43 Duration: 40s323ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-27 05:30:39 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 242.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 242.91 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 92.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-27 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 92.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-27 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 80.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 80.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 80.07 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 72.53 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 72.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 72.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-27 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 61.22 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-27 05:30:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 56.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-27 05:30:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 108.68 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-27 15:56:47 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 108.68 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database rio - 2026-08-27 15:56:47 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (91) Main table analyzed (database rio)
- 837 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 91 rio.pg_catalog.pg_class 47 rio.public.usuarios 46 rio.pg_catalog.pg_type 41 rio.public.temp0000289868 39 brasilia.pg_catalog.pg_attribute 33 rio.public.temp0000289792 32 contagem.public.usuarios 30 rio.public.temp0000289796 29 rio.pg_catalog.pg_index 27 contagem.pg_catalog.pg_attribute 24 rio.public.temp0000289798 24 rio.public.temp0000289730 23 rio.pg_catalog.pg_depend 21 brasilia.pg_catalog.pg_class 17 rio.public.temp0000289810 16 contagem.public.temp0000226975 14 rio.public.temp0000289884 14 brasilia.pg_catalog.pg_type 13 rio.public.temp0000289806 13 rio.public.temp0000289370 12 rio.public.temp0000289448 10 contagem.public.temp0000226917 10 contagem.pg_catalog.pg_class 10 brasilia.pg_catalog.pg_index 9 rio.public.temp0000289392 8 contagem.pg_catalog.pg_type 8 contagem.public.temp0000226983 8 contagem.public.temp0000226989 8 contagem.public.temp0000226985 7 rio.public.temp0000289223 7 brasilia.pg_catalog.pg_depend 7 brasilia.public.usuarios 7 rio.public.temp0000289786 6 brasilia.pg_catalog.pg_shdepend 5 rio.public.temp0000289388 5 rio.public.temp0000289876 5 contagem.pg_catalog.pg_index 5 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000289740 4 rio.public.temp0000289872 4 contagem.pg_catalog.pg_depend 4 brasilia.public.temp0000239072 4 rio.public.temp0000289840 4 rio.public.temp0000289271 4 brasilia.public.nf_entrada 3 brasilia.public.temp0000239004 3 brasilia.public.temp0000239030 3 rio.public.temp0000289802 3 brasilia.public.temp0000239002 3 rio.public.temp0000289882 3 brasilia.public.temp0000238980 3 rio.public.tmp_drill_0175 3 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000289776 2 brasilia.public.temp0000239044 2 contagem.public.nf_entrada 2 rio.public.temp0000289870 2 rio.public.tmp_drill_0320 2 rio.public.temp0000289812 2 rio.public.temp0000289790 2 brasilia.public.temp0000239066 2 rio.public.temp0000289894 2 rio.public.temp0000289860 2 brasilia.public.temp0000239050 2 brasilia.public.temp0000239064 2 brasilia.public.temp0000239038 2 rio.public.temp0000289804 1 brasilia.public.temp0000239056 1 brasilia.public.temp0000239054 1 brasilia.public.temp0000239016 1 rio.public.temp0000289874 1 brasilia.public.temp0000239052 1 rio.public.temp0000289902 1 rio.public.temp0000289836 1 rio.public.temp0000289864 1 rio.public.tmp_drill_0302 1 rio.public.temp0000289838 1 brasilia.public.temp0000238988 1 brasilia.public.temp0000239084 1 brasilia.public.temp0000238984 1 rio.public.temp0000289886 1 brasilia.public.temp0000239012 1 brasilia.public.temp0000239020 1 brasilia.public.temp0000238992 1 rio.public.temp0000289820 1 rio.public.temp0000289896 1 brasilia.public.temp0000239042 1 rio.public.temp0000289800 1 brasilia.public.temp0000239008 1 rio.public.temp0000289852 1 brasilia.public.temp0000239048 1 rio.public.temp0000289808 1 Total 837 Vacuums per table
Key values
- pg_catalog.pg_attribute (32) Main table vacuumed on database rio
- 383 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 32 32 0 0 0 0 0 18,062 4,639 6,922,281 282 6,568 contagem.public.usuarios 30 0 0 0 0 0 0 148 120 63,739 2 2 rio.pg_catalog.pg_class 23 20 0 0 0 0 0 4,156 1,358 2,080,213 68 264 rio.public.temp0000289730 23 0 0 0 0 0 0 24,701 3,598 6,007,697 0 0 rio.public.temp0000289868 19 0 0 0 0 0 0 1,661 100 113,816 0 0 rio.public.temp0000289792 19 0 0 0 0 0 0 17,650 1,827 3,322,521 0 0 rio.public.usuarios 19 9 0 0 0 0 0 288 107 232,478 27 60 rio.pg_catalog.pg_type 17 17 0 0 0 0 0 1,843 519 681,957 61 192 rio.public.temp0000289884 14 0 0 0 0 0 0 9,416 147 730,223 0 0 rio.public.temp0000289370 12 0 0 0 0 0 0 913 70 64,443 0 0 brasilia.pg_catalog.pg_attribute 11 11 0 0 0 0 0 5,608 1,312 2,117,259 58 1,474 rio.pg_catalog.pg_index 10 10 0 0 0 0 0 609 165 188,952 36 84 rio.pg_catalog.pg_depend 9 9 0 0 0 0 0 2,813 902 1,394,788 49 573 rio.public.temp0000289806 8 0 0 0 0 0 0 634 248 393,131 0 0 rio.public.temp0000289448 8 0 0 0 0 0 0 408 38 30,100 0 0 contagem.pg_catalog.pg_attribute 8 8 0 0 0 0 0 4,219 1,217 2,094,421 17 361 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 9,101 2,453 9,967,841 1,567 7,372 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,408 305 569,011 16 62 rio.public.temp0000289223 7 0 0 0 0 0 0 564 126 177,773 0 0 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 571 155 244,031 15 42 rio.public.tmp_drill_0175 6 1 0 0 0 0 0 47 7 10,491 0 0 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 259 73 56,479 6 13 contagem.public.temp0000226989 5 0 0 0 0 0 0 315 30 22,906 0 0 rio.public.temp0000289392 4 0 0 0 0 0 0 344 77 111,423 0 0 rio.public.temp0000289740 4 0 0 0 0 0 0 5,287 15 314,280 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 526 114 184,479 2 6 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 309 80 132,976 2 6 rio.public.temp0000289388 4 0 0 0 0 0 0 1,773 13 106,824 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,935 514 2,581,047 151 407 contagem.public.temp0000226983 4 0 0 0 0 0 0 208 24 15,771 0 0 postgres.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 594 184 276,784 42 75 brasilia.public.temp0000239030 3 0 0 0 0 0 0 744 12 45,705 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 844 271 400,331 13 111 rio.public.tmp_drill_0302 2 1 0 0 0 0 0 41 3 10,773 0 0 contagem.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 355 132 193,244 30 59 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 56 6 12,499 0 0 brasilia.public.temp0000239038 2 0 0 0 0 0 0 496 252 411,239 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 294 78 252,586 22 49 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,943 937 2,920,286 803 5,489 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 81 12 16,879 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,554 623 2,615,948 500 3,593 rio.public.temp0000289876 2 0 0 0 0 0 0 1,771 9 105,918 0 0 brasilia.public.temp0000239044 2 0 0 0 0 0 0 496 8 30,470 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 567 210 376,359 5 36 rio.public.temp0000289864 1 0 0 0 0 0 0 110 6 7,419 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 134 27 110,379 8 23 rio.public.temp0000289820 1 0 0 0 0 0 0 61 6 4,439 0 0 rio.auditor.auditor_2026_08 1 0 0 0 0 0 0 375,218 288,955 361,470,000 44,573 963,613 rio.public.temp0000289874 1 0 0 0 0 0 0 8 5 1,298 0 0 brasilia.public.temp0000239016 1 0 0 0 0 0 0 248 4 15,235 0 0 rio.public.temp0000289812 1 0 0 0 0 0 0 1,761 5 105,521 0 0 rio.public.temp0000289810 1 0 0 0 0 0 0 54 6 4,017 0 0 brasilia.public.temp0000239054 1 0 0 0 0 0 0 250 4 15,421 0 0 rio.public.temp0000289870 1 0 0 0 0 0 0 83 6 5,805 0 0 brasilia.public.temp0000239064 1 0 0 0 0 0 0 248 4 15,235 0 0 rio.public.temp0000289882 1 0 0 0 0 0 0 83 6 5,803 0 0 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 70,046 60,246 79,581,858 4,834 106,134 rio.public.temp0000289872 1 0 0 0 0 0 0 8 5 1,298 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 97 37 84,870 4 14 rio.public.temp0000289796 1 0 0 0 0 0 0 83 6 5,805 0 0 brasilia.public.temp0000238988 1 0 0 0 0 0 0 249 249 398,544 0 0 rio.public.temp0000289894 1 0 0 0 0 0 0 87 6 6,048 0 0 Total 383 178 0 0 0 0 0 577,440 372,673 490,441,367 53,193 1,096,682 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (108.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 2.96 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 1.32 rio.public.temp0000289730 0 0 1.25 rio.public.temp0000289868 0 0 0.2 rio.public.temp0000289792 0 0 0.95 rio.public.usuarios 0 0 0.01 rio.pg_catalog.pg_type 0 0 0.3 rio.public.temp0000289884 0 0 0.57 rio.public.temp0000289370 0 0 0.11 brasilia.pg_catalog.pg_attribute 0 0 1.13 rio.pg_catalog.pg_index 0 0 0.39 rio.pg_catalog.pg_depend 0 0 0.77 rio.public.temp0000289806 0 0 0.05 rio.public.temp0000289448 0 0 0.04 contagem.pg_catalog.pg_attribute 0 0 1.2 rio.pg_catalog.pg_statistic 0 0 1.46 brasilia.pg_catalog.pg_class 0 0 0.47 rio.public.temp0000289223 0 0 0.1 brasilia.pg_catalog.pg_type 0 0 0.11 rio.public.tmp_drill_0175 0 0 0 brasilia.pg_catalog.pg_index 0 0 0.14 contagem.public.temp0000226989 0 0 0.04 rio.public.temp0000289392 0 0 0.03 rio.public.temp0000289740 0 0 0.22 contagem.pg_catalog.pg_class 0 0 0.4 contagem.pg_catalog.pg_type 0 0 0.35 rio.public.temp0000289388 0 0 0.19 rio.pg_toast.pg_toast_2619 0 0 0.41 contagem.public.temp0000226983 0 0 0.02 postgres.pg_catalog.pg_shdepend 0 0 0.26 brasilia.public.temp0000239030 0 0 0 brasilia.pg_catalog.pg_depend 0 0 0.55 rio.public.tmp_drill_0302 0 0 0 contagem.pg_catalog.pg_shdepend 0 0 0.25 rio.public.tmp_drill_0320 0 0 0 brasilia.public.temp0000239038 0 0 0.01 brasilia.pg_toast.pg_toast_2619 0 0 0.12 contagem.pg_catalog.pg_statistic 0 0 0.19 contagem.pg_catalog.pg_index 0 0 0.07 brasilia.pg_catalog.pg_statistic 0 0 0.44 rio.public.temp0000289876 0 0 0.07 brasilia.public.temp0000239044 0 0 0 contagem.pg_catalog.pg_depend 0 0 0.35 rio.public.temp0000289864 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.temp0000289820 0 0 0 rio.auditor.auditor_2026_08 0 0 108.68 rio.public.temp0000289874 0 0 0.01 brasilia.public.temp0000239016 0 0 0 rio.public.temp0000289812 0 0 0.05 rio.public.temp0000289810 0 0 0.01 brasilia.public.temp0000239054 0 0 0 rio.public.temp0000289870 0 0 0.01 brasilia.public.temp0000239064 0 0 0 rio.public.temp0000289882 0 0 0.01 brasilia.auditor.auditor_2026_08 0 0 23.11 rio.public.temp0000289872 0 0 0.01 contagem.public.nf_entrada 0 0 0.05 rio.public.temp0000289796 0 0 0.01 brasilia.public.temp0000238988 0 0 0.02 rio.public.temp0000289894 0 0 0.01 Total 0 0 149.5 Tuples removed per table
Key values
- pg_catalog.pg_attribute (134151) Main table with removed tuples on database rio
- 311113 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 32 32 134,151 776,822 9,808 276 18,653 brasilia.pg_catalog.pg_attribute 11 11 46,261 244,183 0 126 6,091 rio.auditor.auditor_2026_08 1 0 33,407 18,621,746 0 0 890,824 contagem.pg_catalog.pg_attribute 8 8 26,990 194,336 9,190 147 4,353 rio.pg_catalog.pg_statistic 7 7 13,117 57,731 0 0 9,002 rio.pg_catalog.pg_depend 9 9 7,613 171,515 62 0 1,647 rio.pg_catalog.pg_type 17 17 6,931 39,065 392 19 1,240 contagem.pg_catalog.pg_statistic 2 2 5,377 14,942 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 5,113 15,399 0 0 2,144 brasilia.auditor.auditor_2026_08 1 0 4,476 4,723,584 0 0 200,712 postgres.pg_catalog.pg_shdepend 4 4 3,636 54,816 393 0 496 brasilia.pg_catalog.pg_class 7 7 3,054 23,803 0 7 774 rio.pg_catalog.pg_index 10 10 2,628 19,169 7 3 550 brasilia.pg_catalog.pg_type 6 6 2,587 13,394 0 0 403 rio.pg_catalog.pg_class 23 20 2,563 87,154 4,718 69 2,817 contagem.pg_catalog.pg_shdepend 2 2 2,232 27,149 15 0 248 contagem.public.usuarios 30 0 1,945 745 25 0 60 brasilia.pg_catalog.pg_depend 3 3 1,578 52,946 0 0 558 brasilia.pg_catalog.pg_index 5 5 1,223 9,410 1 10 265 rio.pg_toast.pg_toast_2619 4 4 1,182 2,435 10 0 1,144 rio.public.usuarios 19 9 1,112 11,947 2,276 0 399 contagem.pg_catalog.pg_type 4 4 1,033 9,896 892 17 253 rio.public.tmp_drill_0302 2 1 535 1,605 535 0 28 contagem.pg_catalog.pg_depend 2 2 512 40,975 2,896 0 352 rio.public.tmp_drill_0175 6 1 506 4,332 1,913 0 68 contagem.pg_catalog.pg_index 2 2 394 3,972 446 8 100 contagem.public.nf_entrada 1 1 383 1,579 0 0 79 contagem.pg_catalog.pg_class 4 4 264 18,162 2,225 44 640 brasilia.pg_toast.pg_toast_2619 2 2 215 277 0 11 134 contagem.pg_toast.pg_toast_2619 1 1 95 119 0 18 45 rio.public.temp0000289864 1 0 0 4,617 0 26 102 rio.public.temp0000289392 4 0 0 19,348 0 84 428 brasilia.public.temp0000239030 3 0 0 9,765 0 0 768 rio.public.temp0000289806 8 0 0 36,829 0 198 826 rio.public.temp0000289820 1 0 0 2,377 0 11 53 rio.public.temp0000289730 23 0 0 572,146 0 0 41,216 rio.public.temp0000289740 4 0 0 99,442 0 0 7,168 rio.public.temp0000289874 1 0 0 1,115 0 53 75 brasilia.public.temp0000239016 1 0 0 3,255 0 0 256 rio.public.temp0000289812 1 0 0 24,866 0 0 1,792 rio.public.temp0000289810 1 0 0 2,087 0 18 46 rio.public.temp0000289868 19 0 0 89,358 0 623 3,665 rio.public.temp0000289792 19 0 0 448,559 0 62 32,322 rio.public.temp0000289448 8 0 0 31,307 0 126 706 brasilia.public.temp0000239054 1 0 0 3,258 0 0 256 rio.public.tmp_drill_0320 2 2 0 557 0 0 16 brasilia.public.temp0000239038 2 0 0 6,510 0 0 512 rio.public.temp0000289870 1 0 0 1,115 0 53 75 contagem.public.temp0000226989 5 0 0 6,036 0 77 275 brasilia.public.temp0000239064 1 0 0 3,258 0 0 256 rio.public.temp0000289882 1 0 0 1,126 0 53 75 rio.public.temp0000289876 2 0 0 26,009 0 53 1,867 rio.public.temp0000289370 12 0 0 45,079 0 344 1,000 rio.public.temp0000289223 7 0 0 28,128 0 180 620 rio.public.temp0000289388 4 0 0 99,456 0 0 7,168 rio.public.temp0000289884 14 0 0 182,033 0 354 13,086 contagem.public.temp0000226983 4 0 0 4,720 0 51 173 brasilia.public.temp0000239044 2 0 0 6,515 0 0 512 rio.public.temp0000289872 1 0 0 1,115 0 53 75 rio.public.temp0000289796 1 0 0 1,115 0 53 75 brasilia.public.temp0000238988 1 0 0 3,255 0 0 256 rio.public.temp0000289894 1 0 0 1,156 0 49 79 Total 383 178 311,113 27,008,720 35,804 3,276 1,261,900 Pages removed per table
Key values
- public.temp0000289868 (623) Main table with removed pages on database rio
- 3276 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000289868 19 0 0 623 rio.public.temp0000289884 14 0 0 354 rio.public.temp0000289370 12 0 0 344 rio.pg_catalog.pg_attribute 32 32 134151 276 rio.public.temp0000289806 8 0 0 198 rio.public.temp0000289223 7 0 0 180 contagem.pg_catalog.pg_attribute 8 8 26990 147 brasilia.pg_catalog.pg_attribute 11 11 46261 126 rio.public.temp0000289448 8 0 0 126 rio.public.temp0000289392 4 0 0 84 contagem.public.temp0000226989 5 0 0 77 rio.pg_catalog.pg_class 23 20 2563 69 rio.public.temp0000289792 19 0 0 62 rio.public.temp0000289874 1 0 0 53 rio.public.temp0000289870 1 0 0 53 rio.public.temp0000289882 1 0 0 53 rio.public.temp0000289876 2 0 0 53 rio.public.temp0000289872 1 0 0 53 rio.public.temp0000289796 1 0 0 53 contagem.public.temp0000226983 4 0 0 51 rio.public.temp0000289894 1 0 0 49 contagem.pg_catalog.pg_class 4 4 264 44 rio.public.temp0000289864 1 0 0 26 rio.pg_catalog.pg_type 17 17 6931 19 contagem.pg_toast.pg_toast_2619 1 1 95 18 rio.public.temp0000289810 1 0 0 18 contagem.pg_catalog.pg_type 4 4 1033 17 rio.public.temp0000289820 1 0 0 11 brasilia.pg_toast.pg_toast_2619 2 2 215 11 brasilia.pg_catalog.pg_index 5 5 1223 10 contagem.pg_catalog.pg_index 2 2 394 8 brasilia.pg_catalog.pg_class 7 7 3054 7 rio.pg_catalog.pg_index 10 10 2628 3 brasilia.pg_catalog.pg_type 6 6 2587 0 rio.pg_catalog.pg_depend 9 9 7613 0 brasilia.public.temp0000239030 3 0 0 0 rio.public.tmp_drill_0302 2 1 535 0 rio.public.temp0000289730 23 0 0 0 rio.public.temp0000289740 4 0 0 0 rio.auditor.auditor_2026_08 1 0 33407 0 rio.pg_catalog.pg_statistic 7 7 13117 0 brasilia.public.temp0000239016 1 0 0 0 rio.public.temp0000289812 1 0 0 0 contagem.pg_catalog.pg_shdepend 2 2 2232 0 brasilia.public.temp0000239054 1 0 0 0 rio.public.tmp_drill_0320 2 2 0 0 brasilia.public.temp0000239038 2 0 0 0 rio.public.tmp_drill_0175 6 1 506 0 contagem.pg_catalog.pg_statistic 2 2 5377 0 brasilia.pg_catalog.pg_statistic 2 2 5113 0 brasilia.public.temp0000239064 1 0 0 0 rio.public.usuarios 19 9 1112 0 brasilia.pg_catalog.pg_depend 3 3 1578 0 brasilia.auditor.auditor_2026_08 1 0 4476 0 contagem.public.usuarios 30 0 1945 0 rio.public.temp0000289388 4 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1182 0 brasilia.public.temp0000239044 2 0 0 0 contagem.public.nf_entrada 1 1 383 0 contagem.pg_catalog.pg_depend 2 2 512 0 brasilia.public.temp0000238988 1 0 0 0 postgres.pg_catalog.pg_shdepend 4 4 3636 0 Total 383 178 311,113 3,276 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 27 00 0 0 01 0 5 02 0 0 03 0 0 04 0 2 05 7 2 06 0 0 07 16 33 08 36 87 09 30 92 10 25 69 11 59 108 12 18 44 13 16 34 14 50 104 15 59 114 16 47 94 17 15 41 18 0 0 19 0 0 20 0 0 21 5 6 22 0 0 23 0 2 - 108.68 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 2 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 2 2m17s 33s709ms 1m43s 1m8s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 09:27:00 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 12:15:57 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 07:15:25 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
Queries that waited the most
Rank Wait time Query 1 1m43s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-27 09:26:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 33s709ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-27 12:15:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Queries
Queries by type
Key values
- 4,299 Total read queries
- 1,426 Total write queries
Queries by database
Key values
- rio Main database
- 3,902 Requests
- 6h52m8s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,097 Requests
User Request type Count Duration etiquetas Total 37 9s731ms select 37 9s731ms intelifix Total 6,097 9h7m38s copy to 358 49m44s ddl 1,068 44m24s others 521 55m15s select 4,148 6h38m13s lenon Total 114 3m41s select 114 3m41s Duration by user
Key values
- 9h7m38s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 37 9s731ms select 37 9s731ms intelifix Total 6,097 9h7m38s copy to 358 49m44s ddl 1,068 44m24s others 521 55m15s select 4,148 6h38m13s lenon Total 114 3m41s select 114 3m41s Queries by host
Key values
- [local] Main host
- 6,243 Requests
- 9h11m12s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,149 Requests
- 4h23m25s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-27 15:35:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,786 100-500ms duration
Slowest individual queries
Rank Duration Query 1 21m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029167, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');[ Date: 2026-08-27 11:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 10m32s analyze verbose;[ Date: 2026-08-27 05:10:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 07:15:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 09:13:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 7m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 14:12:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 7m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 16:12:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 7m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 15:12:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029149, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-27 07:18:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 7m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-26'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-08-27 15:03:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 7m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 11:12:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 12:12:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 17:12:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029177, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-27 14:44:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 10:11:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m53s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029184, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-27 15:54:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m46s analyze verbose;[ Date: 2026-08-27 05:17:19 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
17 6m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029162, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-27 09:26:59 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m33s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029171, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-27 12:15:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 08:11:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 6m25s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-27 13:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h53s 48 1s681ms 10m7s 2m31s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 27 07 3 11m5s 3m41s 08 3 6m53s 2m17s 09 3 9m7s 3m2s 10 3 7m23s 2m27s 11 3 7m42s 2m34s 12 3 7m33s 2m31s 13 3 6m47s 2m15s 14 3 8m14s 2m44s 15 3 8m24s 2m48s 16 3 8m6s 2m42s 17 3 7m43s 2m34s 18 3 6m28s 2m9s 19 3 6m15s 2m5s 20 3 6m40s 2m13s 21 3 6m23s 2m7s 22 3 6m1s 2m [ User: intelifix - Total duration: 2h53s - Times executed: 48 ]
[ Application: psql - Total duration: 2h53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-27 07:15:09 Duration: 10m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-27 09:13:44 Duration: 8m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-27 14:12:46 Duration: 7m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 1h57m59s 308 159ms 21m46s 22s985ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 27 07 5 13m1s 2m36s 08 22 7m48s 21s313ms 09 31 10m35s 20s505ms 10 34 8m41s 15s347ms 11 49 30m54s 37s852ms 12 19 11m57s 37s780ms 13 19 59s870ms 3s151ms 14 44 9m17s 12s670ms 15 25 21m12s 50s907ms 16 35 1m22s 2s348ms 17 22 1m54s 5s189ms 18 3 12s130ms 4s43ms [ User: intelifix - Total duration: 1h57m59s - Times executed: 308 ]
[ Application: [unknown] - Total duration: 1h57m59s - Times executed: 308 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029167, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-08-27 11:10:55 Duration: 21m46s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029149, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-27 07:18:29 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-26'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-27 15:03:02 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 1h12m43s 48 272ms 4m25s 1m30s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 27 07 3 6m2s 2m 08 3 4m19s 1m26s 09 3 5m2s 1m40s 10 3 4m27s 1m29s 11 3 4m14s 1m24s 12 3 4m35s 1m31s 13 3 4m15s 1m25s 14 3 5m17s 1m45s 15 3 5m14s 1m44s 16 3 4m52s 1m37s 17 3 4m29s 1m29s 18 3 3m56s 1m18s 19 3 4m7s 1m22s 20 3 4m8s 1m22s 21 3 3m51s 1m17s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h12m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h12m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-27 14:18:28 Duration: 4m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-27 15:18:22 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-27 07:21:56 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 28m15s 1,237 150ms 9s540ms 1s370ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 27 07 22 36s789ms 1s672ms 08 108 1m39s 922ms 09 196 3m36s 1s106ms 10 158 2m54s 1s103ms 11 115 3m40s 1s913ms 12 36 55s355ms 1s537ms 13 50 1m32s 1s849ms 14 183 4m10s 1s367ms 15 162 3m37s 1s341ms 16 154 3m53s 1s515ms 17 53 1m39s 1s868ms [ User: intelifix - Total duration: 28m15s - Times executed: 1237 ]
[ Application: [unknown] - Total duration: 28m15s - Times executed: 1237 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282085, 452, '921031019393,48295246E648,D833B7C93185,64FD965690E0,D0CF0EFCBDB8,3453D2A70926,E4C0E23FE5FF,B0BBE549FF0D,C03C04863B10,5CFA25AC7A73,5447CC498F41,C03C0480D107,44D454940DBA,D0CF0EFD0126,4829524CA253,C03C047E8C46,44D454602171,C03C047E87F4', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-27 14:09:59 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55022, 406, '246212854055', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-27 11:17:48 Duration: 8s580ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55024, 406, '270911021202100463,229866004453,216937362849,229739408507,229740061433,229755056363,216944583744,229879605971,216936673253,229805511423,229837194447,229785021623,229674046886,229786101818,229865905476,229816964044,229805528999,229674286281,229686306466,229737465971,229788058495,229669639711,229740413644,229743853744,229689909411,229661607692,229689473454,229689037395,229837307690,229674272644,229727123548,216944783539,229747642442,229743617076,229742654951,229752064141,229668583738,229689920524,229810878501,229879712222,229664400929,229666736666,229661529806,216944583542,216944734163,229866042942,229934022427,229738742123', '246651698702,246474657394,246530140711,246526360421,246570836971,246468018081,246652536269,246475649702,246580153953,246642334769,246584712131,246513656576,246596765776,246653418891,246627266979,246596321536,246516322325,246520156683,246527156367,246596996281,246514632037,246532002834,246539191426,246516655870,246489607798,246525171427,246524252740,246641104559,246513532244,246527316989,246456580008,246550639703,246541282034,246530949914,226382029813,246493355661,246516656072,246641458083,246652312331,246470339700,246495675360,246492277991,246456883550,246456883045,246653608002,246519553639,246550105577,,,', 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-27 15:13:38 Duration: 8s401ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 20m19s 3 3m 10m32s 6m46s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 27 05 3 20m19s 6m46s [ User: intelifix - Total duration: 20m19s - Times executed: 3 ]
[ Application: psql - Total duration: 20m19s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-27 05:10:33 Duration: 10m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-08-27 05:17:19 Duration: 6m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-08-27 05:20:20 Duration: 3m Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 17m2s 55 1s156ms 1m20s 18s599ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 27 07 6 37s81ms 6s180ms 08 6 34s102ms 5s683ms 09 1 1m20s 1m20s 10 6 2m18s 23s133ms 11 4 1m54s 28s611ms 12 1 3s913ms 3s913ms 13 4 2m7s 31s805ms 14 8 2m32s 19s67ms 16 10 4m2s 24s243ms 17 9 1m31s 10s171ms [ User: intelifix - Total duration: 17m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 09:24:56 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 13:23:24 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 10:27:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 15m59s 273 179ms 1m51s 3s513ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 27 00 12 38s724ms 3s227ms 01 11 32s489ms 2s953ms 02 12 33s465ms 2s788ms 03 12 30s63ms 2s505ms 04 11 29s707ms 2s700ms 05 12 30s730ms 2s560ms 06 12 30s147ms 2s512ms 07 12 43s499ms 3s624ms 08 12 34s916ms 2s909ms 09 12 2m20s 11s689ms 10 12 41s488ms 3s457ms 11 12 36s162ms 3s13ms 12 12 1m12s 6s35ms 13 12 35s318ms 2s943ms 14 12 41s282ms 3s440ms 15 12 43s201ms 3s600ms 16 11 38s631ms 3s511ms 17 12 35s602ms 2s966ms 18 12 33s362ms 2s780ms 19 12 33s996ms 2s833ms 20 12 39s805ms 3s317ms 21 12 31s568ms 2s630ms 22 12 32s408ms 2s700ms [ User: intelifix - Total duration: 15m59s - Times executed: 273 ]
[ Application: psql - Total duration: 15m59s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 09:27:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 12:15:57 Duration: 42s964ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 07:15:25 Duration: 14s979ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 11m21s 140 159ms 21s110ms 4s865ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 27 00 5 30s613ms 6s122ms 01 5 12s524ms 2s504ms 02 6 9s196ms 1s532ms 03 5 12s958ms 2s591ms 04 6 18s697ms 3s116ms 05 4 19s788ms 4s947ms 07 11 58s151ms 5s286ms 08 10 57s517ms 5s751ms 09 11 1m6s 6s73ms 10 11 1m12s 6s564ms 11 8 46s765ms 5s845ms 12 7 58s649ms 8s378ms 13 6 9s705ms 1s617ms 14 11 1m 5s528ms 15 9 1m4s 7s157ms 16 9 44s129ms 4s903ms 17 4 3s965ms 991ms 20 1 360ms 360ms 21 5 17s212ms 3s442ms 22 6 16s683ms 2s780ms [ User: intelifix - Total duration: 11m21s - Times executed: 140 ]
[ Application: psql - Total duration: 11m21s - Times executed: 140 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 00:05:22 Duration: 21s110ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 09:55:16 Duration: 14s813ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 15:05:15 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 10m29s 885 150ms 9s865ms 711ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 27 07 56 40s326ms 720ms 08 55 36s372ms 661ms 09 120 1m25s 712ms 10 127 1m21s 638ms 11 152 1m33s 614ms 12 14 9s78ms 648ms 13 53 30s328ms 572ms 14 116 1m33s 802ms 15 133 1m39s 744ms 16 41 43s531ms 1s61ms 17 18 18s93ms 1s5ms [ User: intelifix - Total duration: 10m29s - Times executed: 885 ]
[ Application: [unknown] - Total duration: 10m29s - Times executed: 885 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "282324", "modelo" : "431", "itens" : "840BBB942AC0,840BBB957D10,840BBB934128,840BBB950BB8,840BBB957A90,840BBB93411C,840BBB933E54,840BBBD4C1F4,840BBB9597F0,840BBB957920,840BBB942B68,840BBB93FF20,840BBB951294,840BBB95B878,840BBB94E494,840BBB933B48,840BBB953918,840BBB94E3FC,840BBB933F7C,840BBB9599C4,840BBB940178,840BBB944AB4,840BBB94E564,840BBB95369C,840BBB94FC38,840BBB944DD0,840BBB958730,,840BBB952480,840BBB95B6C0,840BBB958564,840BBB959858", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 16:37:35 Duration: 9s865ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241679459601,241604227174,230043556573,241709501434,241654389297,241708269809,241603612536,241639301025,241708303954,241689961637,241706687690,241698315964,241603878903,241666235875,241654423847,241619565069,241629344250,241629356372,241630790217,241690108698,241703460115,230049488790,241656984052,241646635870,241592187189,241619674350,241601495662,241615672849,241708301833,241679625577,241682767387,241634517493,241651670111,241601500007,241646573036,241694573759,241668091130,241706659809,241604251117,241603106369,241658892847,241634757191,241706757192,241602995371", "usuario" : "414", "caixa" : "2879975", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 15:15:46 Duration: 5s845ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "281658", "modelo" : "145", "itens" : "229789688194,229796116072,229768434347,229790691840,229790458001,229768434246,229849946578,229878384348,229877799308,229843867073,229868299705,229878542849,229868103648,229804135463,229849626973,229803666371", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246589777484,246605034765,246573476780,246577442847,246589422243,246573478700,246610515670,226402451728,246611567478,246503253945,246649465476,246483476874,246615922326,246609519400,246642693042,246600992934,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 13:44:03 Duration: 3s262ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 8m37s 37 10s323ms 51s715ms 13s974ms create table temp0000289792 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 27 07 11 2m49s 15s366ms 08 5 54s633ms 10s926ms 09 9 2m11s 14s629ms 10 3 43s490ms 14s496ms 11 3 38s539ms 12s846ms 12 6 1m19s 13s280ms [ User: intelifix - Total duration: 8m37s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 8m37s - Times executed: 37 ]
-
CREATE TABLE temp0000289792 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 07:08:18 Duration: 51s715ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289792 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 09:55:22 Duration: 24s913ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289792 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 10:15:43 Duration: 19s50ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 7m20s 29 11s212ms 46s326ms 15s189ms create table temp0000289730 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 27 08 4 1m25s 21s492ms 10 4 52s391ms 13s97ms 11 2 36s 18s 12 6 1m17s 12s880ms 14 1 27s790ms 27s790ms 15 3 40s365ms 13s455ms 16 5 1m11s 14s286ms 17 4 49s255ms 12s313ms [ User: intelifix - Total duration: 7m20s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 7m20s - Times executed: 29 ]
-
CREATE TABLE temp0000289730 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 08:22:05 Duration: 46s326ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289730 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 14:11:06 Duration: 27s790ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289730 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 11:32:24 Duration: 22s888ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 6m36s 50 170ms 1m51s 7s933ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 27 07 4 2s511ms 627ms 08 9 2m41s 17s889ms 09 4 2s536ms 634ms 10 3 1m5s 21s872ms 11 2 3s375ms 1s687ms 12 5 19s294ms 3s858ms 14 5 19s213ms 3s842ms 15 11 3s460ms 314ms 16 6 1m57s 19s554ms 17 1 2s342ms 2s342ms [ User: intelifix - Total duration: 6m36s - Times executed: 50 ]
[ Application: psql - Total duration: 6m36s - Times executed: 50 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029193);
Date: 2026-08-27 16:10:38 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029155);
Date: 2026-08-27 08:26:15 Duration: 1m38s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029159);
Date: 2026-08-27 08:33:02 Duration: 41s197ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 6m29s 105 153ms 44s785ms 3s705ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 27 08 6 3s147ms 524ms 09 13 2m14s 10s380ms 10 10 5s740ms 574ms 11 8 4s443ms 555ms 13 9 1m14s 8s305ms 14 21 1m23s 3s980ms 15 8 10s630ms 1s328ms 16 19 15s448ms 813ms 17 11 56s377ms 5s125ms [ User: intelifix - Total duration: 6m29s - Times executed: 105 ]
[ Application: [unknown] - Total duration: 6m29s - Times executed: 105 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (053989) LIMIT 1;
Date: 2026-08-27 09:17:22 Duration: 44s785ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-27 09:29:35 Duration: 39s310ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-27 13:59:12 Duration: 36s758ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 4m46s 21 10s948ms 17s855ms 13s665ms create table temp0000289884 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 27 14 12 2m43s 13s645ms 15 9 2m3s 13s692ms [ User: intelifix - Total duration: 4m46s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m46s - Times executed: 21 ]
-
CREATE TABLE temp0000289884 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 14:34:42 Duration: 17s855ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289884 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 14:55:05 Duration: 16s176ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289884 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 15:15:40 Duration: 15s625ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 4m40s 21 10s602ms 15s322ms 13s374ms create table temp0000289868 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 27 15 14 3m3s 13s118ms 16 7 1m37s 13s884ms [ User: intelifix - Total duration: 4m40s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m40s - Times executed: 21 ]
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 16:31:05 Duration: 15s322ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 15:49:01 Duration: 15s100ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 15:47:07 Duration: 14s937ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 4m33s 404 159ms 3s183ms 678ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 27 11 34 11s924ms 350ms 13 122 2m17s 1s125ms 14 244 2m2s 500ms 15 1 515ms 515ms 16 3 2s182ms 727ms [ User: intelifix - Total duration: 4m33s - Times executed: 404 ]
[ Application: [unknown] - Total duration: 4m33s - Times executed: 404 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135052","seriais":"241757365577,241791341228,241722996678,241793281013,241789642431,241734686472,241794797490,241794725564,241725820928,241794793753,241754246978,241754260617,241789971027,241749978807,241725417980,241720456172,241791203234,241787104450,241755689813,241737084058,241791331833,241789643845,241794799612,241705051426,241749978302,241722365674,241720417986,241782097283,241793259797,241737087189,241787256485,241722981526,241794813149,241794926672,241787245575,241722360321,241794912227,241757345373,241734664349","usuario":"399","observacao":""}');
Date: 2026-08-27 13:47:54 Duration: 3s183ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135052","seriais":"241814369210,241744339805,241764301821,241814563247,241738524142,241739533040,241772778507,241771131433,241814542639,241778783234,241739649920,241778675973,241747432846,241778645566,241778722443,241739517785,241814216770,241776762734,241814562237,241778754062,241778761515,241776520915,241772470217,241771238288,241745665759,241743312545,241776508892,241778685873,241744542429,241813274546,241778755476,241764411024,241747433957,241762552032,241739558294,241764567076,241743284764,241814232429,241743373538,241744535155","usuario":"399","observacao":""}');
Date: 2026-08-27 13:47:19 Duration: 3s106ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135052","seriais":"241679319812,241691622124,241680720724,241728821838,241674775373,241706854856,241728516072,241694206977,230039623945,241727325866,241655673756,241615164359,241691192632,241671966681,241694441928,241727311522,241607624970,241656922632,241711055771,241603436884,241663006884,241603739696,241671964661,241658640724,241712790206,241689744365,241621262631,241668230717,241713446565,241628039207,241616110120,241711004958,241619543653,241649373343,241609228606,241619384647,241619229098,241652081015,241663003248,241629981922","usuario":"399","observacao":""}');
Date: 2026-08-27 13:45:11 Duration: 2s908ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 3m33s 4 6s282ms 1m45s 53s259ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 27 20 2 1m41s 50s610ms 23 2 1m51s 55s907ms [ User: intelifix - Total duration: 3m33s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m33s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-27 23:17:52 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-27 20:09:01 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-27 20:10:59 Duration: 7s252ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 3m19s 30 223ms 36s100ms 6s646ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 27 07 2 39s433ms 19s716ms 08 5 30s66ms 6s13ms 09 2 20s267ms 10s133ms 10 1 9s215ms 9s215ms 11 4 16s934ms 4s233ms 12 1 11s800ms 11s800ms 13 1 6s539ms 6s539ms 14 3 19s908ms 6s636ms 15 8 29s206ms 3s650ms 16 3 16s32ms 5s344ms [ User: intelifix - Total duration: 3m19s - Times executed: 30 ]
[ Application: psql - Total duration: 3m19s - Times executed: 30 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029149);
Date: 2026-08-27 07:10:59 Duration: 36s100ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029155);
Date: 2026-08-27 08:26:29 Duration: 13s251ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029177);
Date: 2026-08-27 14:37:12 Duration: 12s579ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 2m37s 6 9s769ms 55s657ms 26s201ms select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 27 00 3 1m20s 26s993ms 06 3 1m16s 25s410ms [ User: lenon - Total duration: 2m37s - Times executed: 6 ]
[ Application: psql - Total duration: 2m37s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-27 00:02:58 Duration: 55s657ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-27 06:02:53 Duration: 52s36ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-27 00:03:13 Duration: 15s136ms Database: brasilia User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 2m13s 4 411ms 1m13s 33s450ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 27 20 2 59s794ms 29s897ms 23 2 1m14s 37s3ms [ User: intelifix - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-27 23:14:05 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-27 20:05:38 Duration: 59s383ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-27 23:40:16 Duration: 440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,237 28m15s 150ms 9s540ms 1s370ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 27 07 22 36s789ms 1s672ms 08 108 1m39s 922ms 09 196 3m36s 1s106ms 10 158 2m54s 1s103ms 11 115 3m40s 1s913ms 12 36 55s355ms 1s537ms 13 50 1m32s 1s849ms 14 183 4m10s 1s367ms 15 162 3m37s 1s341ms 16 154 3m53s 1s515ms 17 53 1m39s 1s868ms [ User: intelifix - Total duration: 28m15s - Times executed: 1237 ]
[ Application: [unknown] - Total duration: 28m15s - Times executed: 1237 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282085, 452, '921031019393,48295246E648,D833B7C93185,64FD965690E0,D0CF0EFCBDB8,3453D2A70926,E4C0E23FE5FF,B0BBE549FF0D,C03C04863B10,5CFA25AC7A73,5447CC498F41,C03C0480D107,44D454940DBA,D0CF0EFD0126,4829524CA253,C03C047E8C46,44D454602171,C03C047E87F4', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-27 14:09:59 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55022, 406, '246212854055', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-27 11:17:48 Duration: 8s580ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55024, 406, '270911021202100463,229866004453,216937362849,229739408507,229740061433,229755056363,216944583744,229879605971,216936673253,229805511423,229837194447,229785021623,229674046886,229786101818,229865905476,229816964044,229805528999,229674286281,229686306466,229737465971,229788058495,229669639711,229740413644,229743853744,229689909411,229661607692,229689473454,229689037395,229837307690,229674272644,229727123548,216944783539,229747642442,229743617076,229742654951,229752064141,229668583738,229689920524,229810878501,229879712222,229664400929,229666736666,229661529806,216944583542,216944734163,229866042942,229934022427,229738742123', '246651698702,246474657394,246530140711,246526360421,246570836971,246468018081,246652536269,246475649702,246580153953,246642334769,246584712131,246513656576,246596765776,246653418891,246627266979,246596321536,246516322325,246520156683,246527156367,246596996281,246514632037,246532002834,246539191426,246516655870,246489607798,246525171427,246524252740,246641104559,246513532244,246527316989,246456580008,246550639703,246541282034,246530949914,226382029813,246493355661,246516656072,246641458083,246652312331,246470339700,246495675360,246492277991,246456883550,246456883045,246653608002,246519553639,246550105577,,,', 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-27 15:13:38 Duration: 8s401ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 885 10m29s 150ms 9s865ms 711ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 27 07 56 40s326ms 720ms 08 55 36s372ms 661ms 09 120 1m25s 712ms 10 127 1m21s 638ms 11 152 1m33s 614ms 12 14 9s78ms 648ms 13 53 30s328ms 572ms 14 116 1m33s 802ms 15 133 1m39s 744ms 16 41 43s531ms 1s61ms 17 18 18s93ms 1s5ms [ User: intelifix - Total duration: 10m29s - Times executed: 885 ]
[ Application: [unknown] - Total duration: 10m29s - Times executed: 885 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "282324", "modelo" : "431", "itens" : "840BBB942AC0,840BBB957D10,840BBB934128,840BBB950BB8,840BBB957A90,840BBB93411C,840BBB933E54,840BBBD4C1F4,840BBB9597F0,840BBB957920,840BBB942B68,840BBB93FF20,840BBB951294,840BBB95B878,840BBB94E494,840BBB933B48,840BBB953918,840BBB94E3FC,840BBB933F7C,840BBB9599C4,840BBB940178,840BBB944AB4,840BBB94E564,840BBB95369C,840BBB94FC38,840BBB944DD0,840BBB958730,,840BBB952480,840BBB95B6C0,840BBB958564,840BBB959858", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 16:37:35 Duration: 9s865ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241679459601,241604227174,230043556573,241709501434,241654389297,241708269809,241603612536,241639301025,241708303954,241689961637,241706687690,241698315964,241603878903,241666235875,241654423847,241619565069,241629344250,241629356372,241630790217,241690108698,241703460115,230049488790,241656984052,241646635870,241592187189,241619674350,241601495662,241615672849,241708301833,241679625577,241682767387,241634517493,241651670111,241601500007,241646573036,241694573759,241668091130,241706659809,241604251117,241603106369,241658892847,241634757191,241706757192,241602995371", "usuario" : "414", "caixa" : "2879975", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 15:15:46 Duration: 5s845ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "281658", "modelo" : "145", "itens" : "229789688194,229796116072,229768434347,229790691840,229790458001,229768434246,229849946578,229878384348,229877799308,229843867073,229868299705,229878542849,229868103648,229804135463,229849626973,229803666371", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246589777484,246605034765,246573476780,246577442847,246589422243,246573478700,246610515670,226402451728,246611567478,246503253945,246649465476,246483476874,246615922326,246609519400,246642693042,246600992934,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 13:44:03 Duration: 3s262ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 404 4m33s 159ms 3s183ms 678ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 27 11 34 11s924ms 350ms 13 122 2m17s 1s125ms 14 244 2m2s 500ms 15 1 515ms 515ms 16 3 2s182ms 727ms [ User: intelifix - Total duration: 4m33s - Times executed: 404 ]
[ Application: [unknown] - Total duration: 4m33s - Times executed: 404 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135052","seriais":"241757365577,241791341228,241722996678,241793281013,241789642431,241734686472,241794797490,241794725564,241725820928,241794793753,241754246978,241754260617,241789971027,241749978807,241725417980,241720456172,241791203234,241787104450,241755689813,241737084058,241791331833,241789643845,241794799612,241705051426,241749978302,241722365674,241720417986,241782097283,241793259797,241737087189,241787256485,241722981526,241794813149,241794926672,241787245575,241722360321,241794912227,241757345373,241734664349","usuario":"399","observacao":""}');
Date: 2026-08-27 13:47:54 Duration: 3s183ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135052","seriais":"241814369210,241744339805,241764301821,241814563247,241738524142,241739533040,241772778507,241771131433,241814542639,241778783234,241739649920,241778675973,241747432846,241778645566,241778722443,241739517785,241814216770,241776762734,241814562237,241778754062,241778761515,241776520915,241772470217,241771238288,241745665759,241743312545,241776508892,241778685873,241744542429,241813274546,241778755476,241764411024,241747433957,241762552032,241739558294,241764567076,241743284764,241814232429,241743373538,241744535155","usuario":"399","observacao":""}');
Date: 2026-08-27 13:47:19 Duration: 3s106ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"135052","seriais":"241679319812,241691622124,241680720724,241728821838,241674775373,241706854856,241728516072,241694206977,230039623945,241727325866,241655673756,241615164359,241691192632,241671966681,241694441928,241727311522,241607624970,241656922632,241711055771,241603436884,241663006884,241603739696,241671964661,241658640724,241712790206,241689744365,241621262631,241668230717,241713446565,241628039207,241616110120,241711004958,241619543653,241649373343,241609228606,241619384647,241619229098,241652081015,241663003248,241629981922","usuario":"399","observacao":""}');
Date: 2026-08-27 13:45:11 Duration: 2s908ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 308 1h57m59s 159ms 21m46s 22s985ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 27 07 5 13m1s 2m36s 08 22 7m48s 21s313ms 09 31 10m35s 20s505ms 10 34 8m41s 15s347ms 11 49 30m54s 37s852ms 12 19 11m57s 37s780ms 13 19 59s870ms 3s151ms 14 44 9m17s 12s670ms 15 25 21m12s 50s907ms 16 35 1m22s 2s348ms 17 22 1m54s 5s189ms 18 3 12s130ms 4s43ms [ User: intelifix - Total duration: 1h57m59s - Times executed: 308 ]
[ Application: [unknown] - Total duration: 1h57m59s - Times executed: 308 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029167, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-08-27 11:10:55 Duration: 21m46s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029149, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-27 07:18:29 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-26'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-27 15:03:02 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 273 15m59s 179ms 1m51s 3s513ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 27 00 12 38s724ms 3s227ms 01 11 32s489ms 2s953ms 02 12 33s465ms 2s788ms 03 12 30s63ms 2s505ms 04 11 29s707ms 2s700ms 05 12 30s730ms 2s560ms 06 12 30s147ms 2s512ms 07 12 43s499ms 3s624ms 08 12 34s916ms 2s909ms 09 12 2m20s 11s689ms 10 12 41s488ms 3s457ms 11 12 36s162ms 3s13ms 12 12 1m12s 6s35ms 13 12 35s318ms 2s943ms 14 12 41s282ms 3s440ms 15 12 43s201ms 3s600ms 16 11 38s631ms 3s511ms 17 12 35s602ms 2s966ms 18 12 33s362ms 2s780ms 19 12 33s996ms 2s833ms 20 12 39s805ms 3s317ms 21 12 31s568ms 2s630ms 22 12 32s408ms 2s700ms [ User: intelifix - Total duration: 15m59s - Times executed: 273 ]
[ Application: psql - Total duration: 15m59s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 09:27:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 12:15:57 Duration: 42s964ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 07:15:25 Duration: 14s979ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 159 45s360ms 150ms 884ms 285ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 27 01 16 4s809ms 300ms 04 16 4s348ms 271ms 05 12 4s237ms 353ms 07 5 1s501ms 300ms 08 13 3s388ms 260ms 09 11 4s926ms 447ms 10 18 4s756ms 264ms 11 11 2s937ms 267ms 12 8 2s162ms 270ms 13 1 396ms 396ms 14 16 4s442ms 277ms 15 18 4s262ms 236ms 16 13 3s9ms 231ms 17 1 178ms 178ms [ User: intelifix - Total duration: 45s360ms - Times executed: 159 ]
[ Application: [unknown] - Total duration: 45s360ms - Times executed: 159 ]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241658690022,241658886078,241601110115,241700693952,241663085152,241632281821,241663060527,241630950412,241614498705,241668249405,241667638302,241649469211', NULL, NULL, 0320, 00);
Date: 2026-08-27 09:17:28 Duration: 884ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_TRIAGEM (310, 5, '77', 2, '841EA38E653B,582FF70A79D1,44D4549461CF,64FD966AE447,5CFA25AC4766,C4EB42EA37B5,44D454938A3B,44D45460A815,3C585D7920A4,D833B7312C74,ACD75BB6DDCB,38A65922DBB8,20B82BF92D36,44D454C42A1E,841EA3698485,C4EB429F87F8,841EA38C7679,44D45460992E', NULL, NULL, 0155, 00);
Date: 2026-08-27 09:22:30 Duration: 752ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_TRIAGEM (407, 5, '70', 2, '241708264455,241615138194,241651258903,241649728507,241675579806,230047980721,241672057273,241656755769,241658879007,241646100712,241603347885,241617751941,241658887189,241658892342', NULL, NULL, 0320, 00);
Date: 2026-08-27 09:17:01 Duration: 670ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 140 11m21s 159ms 21s110ms 4s865ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 27 00 5 30s613ms 6s122ms 01 5 12s524ms 2s504ms 02 6 9s196ms 1s532ms 03 5 12s958ms 2s591ms 04 6 18s697ms 3s116ms 05 4 19s788ms 4s947ms 07 11 58s151ms 5s286ms 08 10 57s517ms 5s751ms 09 11 1m6s 6s73ms 10 11 1m12s 6s564ms 11 8 46s765ms 5s845ms 12 7 58s649ms 8s378ms 13 6 9s705ms 1s617ms 14 11 1m 5s528ms 15 9 1m4s 7s157ms 16 9 44s129ms 4s903ms 17 4 3s965ms 991ms 20 1 360ms 360ms 21 5 17s212ms 3s442ms 22 6 16s683ms 2s780ms [ User: intelifix - Total duration: 11m21s - Times executed: 140 ]
[ Application: psql - Total duration: 11m21s - Times executed: 140 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 00:05:22 Duration: 21s110ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 09:55:16 Duration: 14s813ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 15:05:15 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 137 58s568ms 220ms 1s215ms 427ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 27 07 2 709ms 354ms 08 13 6s530ms 502ms 09 7 2s764ms 394ms 10 10 4s661ms 466ms 11 45 19s232ms 427ms 12 16 6s957ms 434ms 13 3 1s51ms 350ms 14 10 4s565ms 456ms 15 10 3s980ms 398ms 16 9 3s570ms 396ms 17 10 3s864ms 386ms 18 2 681ms 340ms [ User: intelifix - Total duration: 58s568ms - Times executed: 137 ]
[ Application: [unknown] - Total duration: 58s568ms - Times executed: 137 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-27 08:20:46 Duration: 1s215ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-27 12:20:41 Duration: 890ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-27 10:23:07 Duration: 806ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 105 6m29s 153ms 44s785ms 3s705ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 27 08 6 3s147ms 524ms 09 13 2m14s 10s380ms 10 10 5s740ms 574ms 11 8 4s443ms 555ms 13 9 1m14s 8s305ms 14 21 1m23s 3s980ms 15 8 10s630ms 1s328ms 16 19 15s448ms 813ms 17 11 56s377ms 5s125ms [ User: intelifix - Total duration: 6m29s - Times executed: 105 ]
[ Application: [unknown] - Total duration: 6m29s - Times executed: 105 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (053989) LIMIT 1;
Date: 2026-08-27 09:17:22 Duration: 44s785ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-27 09:29:35 Duration: 39s310ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-27 13:59:12 Duration: 36s758ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 103 46s594ms 273ms 841ms 452ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 27 01 2 1s264ms 632ms 02 1 316ms 316ms 04 2 756ms 378ms 05 1 400ms 400ms 06 1 527ms 527ms 07 9 3s388ms 376ms 08 9 3s614ms 401ms 09 12 5s449ms 454ms 10 7 3s447ms 492ms 11 9 4s508ms 500ms 12 5 2s202ms 440ms 13 8 4s124ms 515ms 14 11 4s756ms 432ms 15 10 4s647ms 464ms 16 9 4s306ms 478ms 17 4 1s638ms 409ms 18 1 411ms 411ms 21 2 831ms 415ms [ User: lenon - Total duration: 46s594ms - Times executed: 103 ]
[ Application: [unknown] - Total duration: 46s594ms - Times executed: 103 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-27 16:43:47 Duration: 841ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.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-27 13:08:14 Duration: 731ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.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-27 10:15:15 Duration: 680ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 91 52s458ms 345ms 1s173ms 576ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 27 01 2 1s636ms 818ms 02 1 458ms 458ms 04 2 1s38ms 519ms 05 1 472ms 472ms 07 7 4s186ms 598ms 08 8 4s118ms 514ms 09 12 6s895ms 574ms 10 7 4s202ms 600ms 11 8 4s982ms 622ms 12 5 2s733ms 546ms 13 7 4s363ms 623ms 14 9 4s611ms 512ms 15 10 5s883ms 588ms 16 8 4s843ms 605ms 17 4 2s32ms 508ms [ User: intelifix - Total duration: 52s458ms - Times executed: 91 ]
[ Application: [unknown] - Total duration: 52s458ms - Times executed: 91 ]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-08-27 07:16:44 Duration: 1s173ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-08-27 16:09:06 Duration: 947ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
select * from rs_menu_grants (428, 19, 1);
Date: 2026-08-27 16:43:47 Duration: 937ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 83 27s364ms 150ms 1s135ms 329ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 27 01 1 301ms 301ms 05 1 362ms 362ms 07 2 621ms 310ms 08 2 693ms 346ms 09 6 2s13ms 335ms 10 8 3s132ms 391ms 11 9 3s420ms 380ms 12 10 5s313ms 531ms 13 1 160ms 160ms 14 5 1s86ms 217ms 15 16 4s836ms 302ms 16 14 3s553ms 253ms 17 8 1s868ms 233ms [ User: intelifix - Total duration: 27s364ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 27s364ms - Times executed: 83 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-08-27", "data-ate" : "2026-08-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 404 }');
Date: 2026-08-27 12:15:07 Duration: 1s135ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-08-27", "data-ate" : "2026-08-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-08-27 11:24:38 Duration: 860ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "305", "data-de" : "2026-08-27", "data-ate" : "2026-08-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 317 }');
Date: 2026-08-27 12:21:14 Duration: 794ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 70 37s456ms 150ms 5s930ms 535ms select * from rs_lote_saida_manutencao (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 27 06 1 325ms 325ms 07 2 351ms 175ms 08 1 203ms 203ms 09 15 16s902ms 1s126ms 10 8 5s81ms 635ms 11 9 3s351ms 372ms 12 3 2s551ms 850ms 13 1 334ms 334ms 14 9 3s145ms 349ms 15 8 1s822ms 227ms 16 4 872ms 218ms 17 9 2s514ms 279ms [ User: intelifix - Total duration: 37s456ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 37s456ms - Times executed: 70 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "52752", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000083828", "data-saida" : "2026-08-24", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "PRIORIDADE PAPEL LOTE -27", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-27 09:13:48 Duration: 5s930ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "52715", "oficina" : "2", "cliente" : "1", "usuario" : "409", "nf" : "000083825", "data-saida" : "2026-08-24", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "3.1 LOTE- 27", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-27 09:15:25 Duration: 2s578ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO ('{ "id" : "134712", "oficina" : "7", "cliente" : "11", "usuario" : "427", "nf" : "", "data-saida" : "2026-08-27", "sucata" : "D", "garantia" : "N", "fatura" : "", "data-fatura" : "", "data-inspecao" : "", "fechado" : "N", "valorado" : "", "motivo" : "0", "obs" : "Cosmético Pintura", "def-extras" : "N", "acessorios" : "[]", "nf-vivo" : "0" }');
Date: 2026-08-27 10:44:46 Duration: 2s343ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 61 29s225ms 150ms 1s534ms 479ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 27 08 4 1s859ms 464ms 09 16 12s81ms 755ms 10 12 7s507ms 625ms 11 5 1s 200ms 14 3 644ms 214ms 15 12 3s374ms 281ms 16 8 2s500ms 312ms 17 1 256ms 256ms [ User: intelifix - Total duration: 29s225ms - Times executed: 61 ]
[ Application: [unknown] - Total duration: 29s225ms - Times executed: 61 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '5872C98AEC21,4896D9595EC2,14CA56D53EC3,D89A0D86486D,3CF9F0A5F634,D83139A05A34,3CF9F0A43890,689E29FC2AB7,6C11BA64EF6F,6C11BA6887CD,14CA56D5628D,843C99212DAD,48D68231A46A,C4EBFF89665E,5872C98B2B7B,C4EBFF899C4C,14CA56D56BB1,6C11BA6873B1,5872C98FA149,48D682313054', '138;1', 'DEFAULT', 09, 0323, '','', '', 00);
Date: 2026-08-27 10:24:19 Duration: 1s534ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, '142004583502,DC5193D8FE6A,38165A47D614,DC5193DAF2B6,7C7D21F0AB23,14200457CB0E,7C7D21F20D2B,14200457101A,E44E12B291E1,7C7D21F0C4AB,7C7D21ECEA27,38165A47E600,7C7D21ED63FF,7C7D21F1ECCB,7C7D21F1FFF7,38165A47A0B8,7C7D21F0F5F3,14200457C892,E44E12939857,E44E1293D02B', '','DEFAULT',09,0329,'', '','', 00);
Date: 2026-08-27 09:08:03 Duration: 1s487ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_BAIXA_EXECUTA (358, 11, 2, 6, 'C0B101F887B6,DCF8B9F56CE5,98006A6A3BA2,C0B101FB1A90,C0B101FC12CA,C0B101F8BFC0,C0B101E522B0,C0B101FB4AD8', '138;1', 'DEFAULT', 09, 0271, '','', '', 00);
Date: 2026-08-27 10:35:20 Duration: 1s358ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 55 17m2s 1s156ms 1m20s 18s599ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 27 07 6 37s81ms 6s180ms 08 6 34s102ms 5s683ms 09 1 1m20s 1m20s 10 6 2m18s 23s133ms 11 4 1m54s 28s611ms 12 1 3s913ms 3s913ms 13 4 2m7s 31s805ms 14 8 2m32s 19s67ms 16 10 4m2s 24s243ms 17 9 1m31s 10s171ms [ User: intelifix - Total duration: 17m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 09:24:56 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 13:23:24 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 10:27:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 54 1m56s 642ms 20s853ms 2s156ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 27 08 3 3s106ms 1s35ms 09 3 2s849ms 949ms 10 3 3s103ms 1s34ms 11 6 23s845ms 3s974ms 12 3 8s54ms 2s684ms 13 3 2s579ms 859ms 14 3 3s23ms 1s7ms 15 5 22s75ms 4s415ms 16 3 2s521ms 840ms 17 3 22s642ms 7s547ms 18 4 5s987ms 1s496ms 19 4 4s682ms 1s170ms 20 5 5s192ms 1s38ms 21 3 4s14ms 1s338ms 22 3 2s791ms 930ms [ User: intelifix - Total duration: 1m56s - Times executed: 54 ]
[ Application: psql - Total duration: 1m56s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-27 17:40:23 Duration: 20s853ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-27 11:40:12 Duration: 11s130ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-27 15:00:12 Duration: 10s895ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 54 13s138ms 150ms 3s22ms 243ms create table temp0000289808 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 27 08 7 4s5ms 572ms 09 21 3s959ms 188ms 10 26 5s172ms 198ms [ User: intelifix - Total duration: 13s138ms - Times executed: 54 ]
[ Application: [unknown] - Total duration: 13s138ms - Times executed: 54 ]
-
CREATE TABLE temp0000289808 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-08-2026", "ate" :"27-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-27 08:10:39 Duration: 3s22ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289808 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-08-2026", "ate" :"27-08-2026", "nota-fiscal":"132", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-27 10:12:24 Duration: 710ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289808 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-08-2026", "ate" :"27-08-2026", "nota-fiscal":"132", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-27 09:26:29 Duration: 509ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 53 11s203ms 155ms 1s66ms 211ms create table temp0000289868 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 27 14 18 3s434ms 190ms 15 14 3s619ms 258ms 16 13 2s634ms 202ms 17 8 1s514ms 189ms [ User: intelifix - Total duration: 11s203ms - Times executed: 53 ]
[ Application: [unknown] - Total duration: 11s203ms - Times executed: 53 ]
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-25', '2026-08-27');
Date: 2026-08-27 15:15:55 Duration: 1s66ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '20354318916B', '2026-08-25', '2026-08-27');
Date: 2026-08-27 15:18:21 Duration: 286ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '', '2026-08-25', '2026-08-27');
Date: 2026-08-27 14:35:38 Duration: 266ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 51 12s168ms 151ms 529ms 238ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 27 07 1 156ms 156ms 09 2 320ms 160ms 11 3 567ms 189ms 13 1 276ms 276ms 14 13 2s349ms 180ms 15 31 8s497ms 274ms [ User: intelifix - Total duration: 12s168ms - Times executed: 51 ]
[ Application: [unknown] - Total duration: 12s168ms - Times executed: 51 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (53989);
Date: 2026-08-27 15:14:29 Duration: 529ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (0106328);
Date: 2026-08-27 15:18:27 Duration: 415ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (106328);
Date: 2026-08-27 15:17:59 Duration: 362ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 50 6m36s 170ms 1m51s 7s933ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 27 07 4 2s511ms 627ms 08 9 2m41s 17s889ms 09 4 2s536ms 634ms 10 3 1m5s 21s872ms 11 2 3s375ms 1s687ms 12 5 19s294ms 3s858ms 14 5 19s213ms 3s842ms 15 11 3s460ms 314ms 16 6 1m57s 19s554ms 17 1 2s342ms 2s342ms [ User: intelifix - Total duration: 6m36s - Times executed: 50 ]
[ Application: psql - Total duration: 6m36s - Times executed: 50 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029193);
Date: 2026-08-27 16:10:38 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029155);
Date: 2026-08-27 08:26:15 Duration: 1m38s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029159);
Date: 2026-08-27 08:33:02 Duration: 41s197ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m 10m32s 6m46s 3 20m19s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 27 05 3 20m19s 6m46s [ User: intelifix - Total duration: 20m19s - Times executed: 3 ]
[ Application: psql - Total duration: 20m19s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-27 05:10:33 Duration: 10m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-08-27 05:17:19 Duration: 6m46s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-08-27 05:20:20 Duration: 3m Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 1s681ms 10m7s 2m31s 48 2h53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 27 07 3 11m5s 3m41s 08 3 6m53s 2m17s 09 3 9m7s 3m2s 10 3 7m23s 2m27s 11 3 7m42s 2m34s 12 3 7m33s 2m31s 13 3 6m47s 2m15s 14 3 8m14s 2m44s 15 3 8m24s 2m48s 16 3 8m6s 2m42s 17 3 7m43s 2m34s 18 3 6m28s 2m9s 19 3 6m15s 2m5s 20 3 6m40s 2m13s 21 3 6m23s 2m7s 22 3 6m1s 2m [ User: intelifix - Total duration: 2h53s - Times executed: 48 ]
[ Application: psql - Total duration: 2h53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-27 07:15:09 Duration: 10m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-27 09:13:44 Duration: 8m43s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-27 14:12:46 Duration: 7m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 272ms 4m25s 1m30s 48 1h12m43s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 27 07 3 6m2s 2m 08 3 4m19s 1m26s 09 3 5m2s 1m40s 10 3 4m27s 1m29s 11 3 4m14s 1m24s 12 3 4m35s 1m31s 13 3 4m15s 1m25s 14 3 5m17s 1m45s 15 3 5m14s 1m44s 16 3 4m52s 1m37s 17 3 4m29s 1m29s 18 3 3m56s 1m18s 19 3 4m7s 1m22s 20 3 4m8s 1m22s 21 3 3m51s 1m17s 22 3 3m49s 1m16s [ User: intelifix - Total duration: 1h12m43s - Times executed: 48 ]
[ Application: psql - Total duration: 1h12m43s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-27 14:18:28 Duration: 4m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-27 15:18:22 Duration: 4m23s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-27 07:21:56 Duration: 4m20s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 6s282ms 1m45s 53s259ms 4 3m33s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 27 20 2 1m41s 50s610ms 23 2 1m51s 55s907ms [ User: intelifix - Total duration: 3m33s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m33s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-27 23:17:52 Duration: 1m45s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-27 20:09:01 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-27 20:10:59 Duration: 7s252ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 411ms 1m13s 33s450ms 4 2m13s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 27 20 2 59s794ms 29s897ms 23 2 1m14s 37s3ms [ User: intelifix - Total duration: 2m13s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-27 23:14:05 Duration: 1m13s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-27 20:05:38 Duration: 59s383ms Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-08-27 23:40:16 Duration: 440ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 9s769ms 55s657ms 26s201ms 6 2m37s select * from rs_auditor_novas_tabelas ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 27 00 3 1m20s 26s993ms 06 3 1m16s 25s410ms [ User: lenon - Total duration: 2m37s - Times executed: 6 ]
[ Application: psql - Total duration: 2m37s - Times executed: 6 ]
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-27 00:02:58 Duration: 55s657ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-27 06:02:53 Duration: 52s36ms Database: rio User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_AUDITOR_NOVAS_TABELAS ();
Date: 2026-08-27 00:03:13 Duration: 15s136ms Database: brasilia User: lenon Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 159ms 21m46s 22s985ms 308 1h57m59s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 27 07 5 13m1s 2m36s 08 22 7m48s 21s313ms 09 31 10m35s 20s505ms 10 34 8m41s 15s347ms 11 49 30m54s 37s852ms 12 19 11m57s 37s780ms 13 19 59s870ms 3s151ms 14 44 9m17s 12s670ms 15 25 21m12s 50s907ms 16 35 1m22s 2s348ms 17 22 1m54s 5s189ms 18 3 12s130ms 4s43ms [ User: intelifix - Total duration: 1h57m59s - Times executed: 308 ]
[ Application: [unknown] - Total duration: 1h57m59s - Times executed: 308 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029167, 0437 )', '/var/www/html/tmp/nf_carga_lotes_0437.xlsx');
Date: 2026-08-27 11:10:55 Duration: 21m46s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029149, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-27 07:18:29 Duration: 7m37s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-08-03''),DATE(''2026-08-26'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-08-27 15:03:02 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 1s156ms 1m20s 18s599ms 55 17m2s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 27 07 6 37s81ms 6s180ms 08 6 34s102ms 5s683ms 09 1 1m20s 1m20s 10 6 2m18s 23s133ms 11 4 1m54s 28s611ms 12 1 3s913ms 3s913ms 13 4 2m7s 31s805ms 14 8 2m32s 19s67ms 16 10 4m2s 24s243ms 17 9 1m31s 10s171ms [ User: intelifix - Total duration: 17m2s - Times executed: 55 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 55 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 09:24:56 Duration: 1m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 13:23:24 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-27', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-27 10:27:05 Duration: 1m16s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 11s212ms 46s326ms 15s189ms 29 7m20s create table temp0000289730 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 27 08 4 1m25s 21s492ms 10 4 52s391ms 13s97ms 11 2 36s 18s 12 6 1m17s 12s880ms 14 1 27s790ms 27s790ms 15 3 40s365ms 13s455ms 16 5 1m11s 14s286ms 17 4 49s255ms 12s313ms [ User: intelifix - Total duration: 7m20s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 7m20s - Times executed: 29 ]
-
CREATE TABLE temp0000289730 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 08:22:05 Duration: 46s326ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289730 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 14:11:06 Duration: 27s790ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289730 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 11:32:24 Duration: 22s888ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 10s323ms 51s715ms 13s974ms 37 8m37s create table temp0000289792 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 27 07 11 2m49s 15s366ms 08 5 54s633ms 10s926ms 09 9 2m11s 14s629ms 10 3 43s490ms 14s496ms 11 3 38s539ms 12s846ms 12 6 1m19s 13s280ms [ User: intelifix - Total duration: 8m37s - Times executed: 37 ]
[ Application: [unknown] - Total duration: 8m37s - Times executed: 37 ]
-
CREATE TABLE temp0000289792 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 07:08:18 Duration: 51s715ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289792 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 09:55:22 Duration: 24s913ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289792 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 10:15:43 Duration: 19s50ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 10s948ms 17s855ms 13s665ms 21 4m46s create table temp0000289884 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 27 14 12 2m43s 13s645ms 15 9 2m3s 13s692ms [ User: intelifix - Total duration: 4m46s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m46s - Times executed: 21 ]
-
CREATE TABLE temp0000289884 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 14:34:42 Duration: 17s855ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289884 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 14:55:05 Duration: 16s176ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289884 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 15:15:40 Duration: 15s625ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 10s602ms 15s322ms 13s374ms 21 4m40s create table temp0000289868 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 27 15 14 3m3s 13s118ms 16 7 1m37s 13s884ms [ User: intelifix - Total duration: 4m40s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m40s - Times executed: 21 ]
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 16:31:05 Duration: 15s322ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 15:49:01 Duration: 15s100ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000289868 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-27 15:47:07 Duration: 14s937ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 170ms 1m51s 7s933ms 50 6m36s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 27 07 4 2s511ms 627ms 08 9 2m41s 17s889ms 09 4 2s536ms 634ms 10 3 1m5s 21s872ms 11 2 3s375ms 1s687ms 12 5 19s294ms 3s858ms 14 5 19s213ms 3s842ms 15 11 3s460ms 314ms 16 6 1m57s 19s554ms 17 1 2s342ms 2s342ms [ User: intelifix - Total duration: 6m36s - Times executed: 50 ]
[ Application: psql - Total duration: 6m36s - Times executed: 50 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029193);
Date: 2026-08-27 16:10:38 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029155);
Date: 2026-08-27 08:26:15 Duration: 1m38s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029159);
Date: 2026-08-27 08:33:02 Duration: 41s197ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 223ms 36s100ms 6s646ms 30 3m19s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 27 07 2 39s433ms 19s716ms 08 5 30s66ms 6s13ms 09 2 20s267ms 10s133ms 10 1 9s215ms 9s215ms 11 4 16s934ms 4s233ms 12 1 11s800ms 11s800ms 13 1 6s539ms 6s539ms 14 3 19s908ms 6s636ms 15 8 29s206ms 3s650ms 16 3 16s32ms 5s344ms [ User: intelifix - Total duration: 3m19s - Times executed: 30 ]
[ Application: psql - Total duration: 3m19s - Times executed: 30 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029149);
Date: 2026-08-27 07:10:59 Duration: 36s100ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029155);
Date: 2026-08-27 08:26:29 Duration: 13s251ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029177);
Date: 2026-08-27 14:37:12 Duration: 12s579ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 159ms 21s110ms 4s865ms 140 11m21s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 27 00 5 30s613ms 6s122ms 01 5 12s524ms 2s504ms 02 6 9s196ms 1s532ms 03 5 12s958ms 2s591ms 04 6 18s697ms 3s116ms 05 4 19s788ms 4s947ms 07 11 58s151ms 5s286ms 08 10 57s517ms 5s751ms 09 11 1m6s 6s73ms 10 11 1m12s 6s564ms 11 8 46s765ms 5s845ms 12 7 58s649ms 8s378ms 13 6 9s705ms 1s617ms 14 11 1m 5s528ms 15 9 1m4s 7s157ms 16 9 44s129ms 4s903ms 17 4 3s965ms 991ms 20 1 360ms 360ms 21 5 17s212ms 3s442ms 22 6 16s683ms 2s780ms [ User: intelifix - Total duration: 11m21s - Times executed: 140 ]
[ Application: psql - Total duration: 11m21s - Times executed: 140 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 00:05:22 Duration: 21s110ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 09:55:16 Duration: 14s813ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-27 15:05:15 Duration: 14s169ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 153ms 44s785ms 3s705ms 105 6m29s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 27 08 6 3s147ms 524ms 09 13 2m14s 10s380ms 10 10 5s740ms 574ms 11 8 4s443ms 555ms 13 9 1m14s 8s305ms 14 21 1m23s 3s980ms 15 8 10s630ms 1s328ms 16 19 15s448ms 813ms 17 11 56s377ms 5s125ms [ User: intelifix - Total duration: 6m29s - Times executed: 105 ]
[ Application: [unknown] - Total duration: 6m29s - Times executed: 105 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (053989) LIMIT 1;
Date: 2026-08-27 09:17:22 Duration: 44s785ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-27 09:29:35 Duration: 39s310ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052992) LIMIT 1;
Date: 2026-08-27 13:59:12 Duration: 36s758ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 179ms 1m51s 3s513ms 273 15m59s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 27 00 12 38s724ms 3s227ms 01 11 32s489ms 2s953ms 02 12 33s465ms 2s788ms 03 12 30s63ms 2s505ms 04 11 29s707ms 2s700ms 05 12 30s730ms 2s560ms 06 12 30s147ms 2s512ms 07 12 43s499ms 3s624ms 08 12 34s916ms 2s909ms 09 12 2m20s 11s689ms 10 12 41s488ms 3s457ms 11 12 36s162ms 3s13ms 12 12 1m12s 6s35ms 13 12 35s318ms 2s943ms 14 12 41s282ms 3s440ms 15 12 43s201ms 3s600ms 16 11 38s631ms 3s511ms 17 12 35s602ms 2s966ms 18 12 33s362ms 2s780ms 19 12 33s996ms 2s833ms 20 12 39s805ms 3s317ms 21 12 31s568ms 2s630ms 22 12 32s408ms 2s700ms [ User: intelifix - Total duration: 15m59s - Times executed: 273 ]
[ Application: psql - Total duration: 15m59s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 09:27:00 Duration: 1m51s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 12:15:57 Duration: 42s964ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-27 07:15:25 Duration: 14s979ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 642ms 20s853ms 2s156ms 54 1m56s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 27 08 3 3s106ms 1s35ms 09 3 2s849ms 949ms 10 3 3s103ms 1s34ms 11 6 23s845ms 3s974ms 12 3 8s54ms 2s684ms 13 3 2s579ms 859ms 14 3 3s23ms 1s7ms 15 5 22s75ms 4s415ms 16 3 2s521ms 840ms 17 3 22s642ms 7s547ms 18 4 5s987ms 1s496ms 19 4 4s682ms 1s170ms 20 5 5s192ms 1s38ms 21 3 4s14ms 1s338ms 22 3 2s791ms 930ms [ User: intelifix - Total duration: 1m56s - Times executed: 54 ]
[ Application: psql - Total duration: 1m56s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-27 17:40:23 Duration: 20s853ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-27 11:40:12 Duration: 11s130ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-27 15:00:12 Duration: 10s895ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 150ms 9s540ms 1s370ms 1,237 28m15s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 27 07 22 36s789ms 1s672ms 08 108 1m39s 922ms 09 196 3m36s 1s106ms 10 158 2m54s 1s103ms 11 115 3m40s 1s913ms 12 36 55s355ms 1s537ms 13 50 1m32s 1s849ms 14 183 4m10s 1s367ms 15 162 3m37s 1s341ms 16 154 3m53s 1s515ms 17 53 1m39s 1s868ms [ User: intelifix - Total duration: 28m15s - Times executed: 1237 ]
[ Application: [unknown] - Total duration: 28m15s - Times executed: 1237 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (282085, 452, '921031019393,48295246E648,D833B7C93185,64FD965690E0,D0CF0EFCBDB8,3453D2A70926,E4C0E23FE5FF,B0BBE549FF0D,C03C04863B10,5CFA25AC7A73,5447CC498F41,C03C0480D107,44D454940DBA,D0CF0EFD0126,4829524CA253,C03C047E8C46,44D454602171,C03C047E87F4', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-27 14:09:59 Duration: 9s540ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55022, 406, '246212854055', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-27 11:17:48 Duration: 8s580ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (55024, 406, '270911021202100463,229866004453,216937362849,229739408507,229740061433,229755056363,216944583744,229879605971,216936673253,229805511423,229837194447,229785021623,229674046886,229786101818,229865905476,229816964044,229805528999,229674286281,229686306466,229737465971,229788058495,229669639711,229740413644,229743853744,229689909411,229661607692,229689473454,229689037395,229837307690,229674272644,229727123548,216944783539,229747642442,229743617076,229742654951,229752064141,229668583738,229689920524,229810878501,229879712222,229664400929,229666736666,229661529806,216944583542,216944734163,229866042942,229934022427,229738742123', '246651698702,246474657394,246530140711,246526360421,246570836971,246468018081,246652536269,246475649702,246580153953,246642334769,246584712131,246513656576,246596765776,246653418891,246627266979,246596321536,246516322325,246520156683,246527156367,246596996281,246514632037,246532002834,246539191426,246516655870,246489607798,246525171427,246524252740,246641104559,246513532244,246527316989,246456580008,246550639703,246541282034,246530949914,226382029813,246493355661,246516656072,246641458083,246652312331,246470339700,246495675360,246492277991,246456883550,246456883045,246653608002,246519553639,246550105577,,,', 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-27 15:13:38 Duration: 8s401ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 150ms 9s865ms 711ms 885 10m29s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 27 07 56 40s326ms 720ms 08 55 36s372ms 661ms 09 120 1m25s 712ms 10 127 1m21s 638ms 11 152 1m33s 614ms 12 14 9s78ms 648ms 13 53 30s328ms 572ms 14 116 1m33s 802ms 15 133 1m39s 744ms 16 41 43s531ms 1s61ms 17 18 18s93ms 1s5ms [ User: intelifix - Total duration: 10m29s - Times executed: 885 ]
[ Application: [unknown] - Total duration: 10m29s - Times executed: 885 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "282324", "modelo" : "431", "itens" : "840BBB942AC0,840BBB957D10,840BBB934128,840BBB950BB8,840BBB957A90,840BBB93411C,840BBB933E54,840BBBD4C1F4,840BBB9597F0,840BBB957920,840BBB942B68,840BBB93FF20,840BBB951294,840BBB95B878,840BBB94E494,840BBB933B48,840BBB953918,840BBB94E3FC,840BBB933F7C,840BBB9599C4,840BBB940178,840BBB944AB4,840BBB94E564,840BBB95369C,840BBB94FC38,840BBB944DD0,840BBB958730,,840BBB952480,840BBB95B6C0,840BBB958564,840BBB959858", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 16:37:35 Duration: 9s865ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241543", "modelo" : "320", "itens" : "241679459601,241604227174,230043556573,241709501434,241654389297,241708269809,241603612536,241639301025,241708303954,241689961637,241706687690,241698315964,241603878903,241666235875,241654423847,241619565069,241629344250,241629356372,241630790217,241690108698,241703460115,230049488790,241656984052,241646635870,241592187189,241619674350,241601495662,241615672849,241708301833,241679625577,241682767387,241634517493,241651670111,241601500007,241646573036,241694573759,241668091130,241706659809,241604251117,241603106369,241658892847,241634757191,241706757192,241602995371", "usuario" : "414", "caixa" : "2879975", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 15:15:46 Duration: 5s845ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "281658", "modelo" : "145", "itens" : "229789688194,229796116072,229768434347,229790691840,229790458001,229768434246,229849946578,229878384348,229877799308,229843867073,229868299705,229878542849,229868103648,229804135463,229849626973,229803666371", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246589777484,246605034765,246573476780,246577442847,246589422243,246573478700,246610515670,226402451728,246611567478,246503253945,246649465476,246483476874,246615922326,246609519400,246642693042,246600992934,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-27 13:44:03 Duration: 3s262ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.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 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 27 14 1 0ms 0ms 16 1 0ms 0ms 18 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms [ User: intelifix - Total duration: 9s221ms - Times executed: 6 ]
[ Application: psql - Total duration: 7s732ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 1s489ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 18,387 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 18 FATAL entries
- 4401 ERROR entries
- 0 WARNING entries
- 7 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,362 Max number of times the same event was reported
- 4,426 Total events found
Rank Times reported Error 1 4,362 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 27 00 60 01 59 02 60 03 60 04 59 05 60 06 59 07 243 08 264 09 483 10 337 11 515 12 312 13 202 14 371 15 485 16 196 17 176 18 65 19 59 20 60 21 60 22 59 23 58 - ERROR: prepared statement "_PLAN00000000299C92C0" does not exist
- ERROR: prepared statement "_PLAN0000000029A0B350" does not exist
- ERROR: prepared statement "_PLAN0000000029A0F330" does not exist
Statement: DEALLOCATE "_PLAN00000000299C92C0"
Date: 2026-08-27 00:00:25 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: DEALLOCATE "_PLAN0000000029A0B350"
Date: 2026-08-27 00:01:26 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: DEALLOCATE "_PLAN0000000029A0F330"
Date: 2026-08-27 00:02:26 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 17 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 27 10 1 11 15 15 1 - ERROR: column "controle" does not exist at character 36
- ERROR: column "d833b7cb39a0" does not exist at character 27
- ERROR: column "d833b7cb39a0" does not exist at character 27
Statement: SELECT * FROM temp0000238980 WHERE CONTROLE='L'
Date: 2026-08-27 10:25:04 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT * FROM RS_ETIQUETA(D833B7CB39A0)
Date: 2026-08-27 11:24:43 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT * FROM RS_ETIQUETA(D833B7CB39A0)
Date: 2026-08-27 11:24:44 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 27 00 1 02 1 04 2 05 1 06 1 09 1 15 1 17 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-27 00:03:23 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-08-27 02:20:44 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-08-27 04:46:14 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 8 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 27 09 2 10 2 12 2 15 2 - ERROR: syntax error at or near "/" at character 27
- ERROR: syntax error at or near "/" at character 27
- ERROR: syntax error at or near "\" at character 35
Statement: select * from rs_caixa_qr(/)
Date: 2026-08-27 09:56:16 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: select * from rs_caixa_qr(/)
Date: 2026-08-27 09:56:17 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: select * from rs_caixa_qr(3547187 \)
Date: 2026-08-27 10:36:21 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 27 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-27 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-08-27 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-08-27 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 27 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-27 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-27 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-27 05:32:11 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 3 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 27 09 1 12 2 - LOG: process 1908997 still waiting for ShareLock on transaction 5145797 after 1000.146 ms
- LOG: process 2074176 still waiting for ShareLock on transaction 5161800 after 1000.177 ms
- LOG: process 2074176 still waiting for ShareLock on transaction 5161800 after 2268.090 ms
Detail: Process holding the lock: 1876613. Wait queue: 1908997.
Context: while updating tuple (77947,52) 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-27 09:25:16 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 2074375. Wait queue: 2074176.
Context: while updating tuple (78048,17) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-27 12:15:23 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 2074375. Wait queue: 2074176.
Context: while updating tuple (78048,17) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-27 12:15:24 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 3 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 27 14 3 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-08-27 14:23:09 Database: rio Application: pgAdmin 4 - CONN:3598344 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-08-27 14:23:42 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-08-27 14:23:42 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 3 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 27 15 3 - ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 151 ));Date: 2026-08-27 15:05:15 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 151 ));Date: 2026-08-27 15:06:07 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,0,}', 151 ));Date: 2026-08-27 15:06:08 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 27 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-27 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-08-27 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 27 16 2 - ERROR: trailing junk after numeric literal at or near "5447CC49B7E3" at character 27
- ERROR: trailing junk after numeric literal at or near "5447CC49B7E3" at character 27
Statement: select * from rs_caixa_qr(5447CC49B7E3)
Date: 2026-08-27 16:57:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: select * from rs_caixa_qr(5447CC49B7E3)
Date: 2026-08-27 16:57:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 27 12 1 14 1 - ERROR: unterminated quoted string at or near "'select ''LENILDO''); " at character 53
- ERROR: unterminated quoted string at or near "'229730973744'');" at character 39
Statement: select rs_fast_excel('/var/www/html/temp/xx.xlsx', 'select ''LENILDO'');
Date: 2026-08-27 12:03:38 Database: rio Application: pgAdmin 4 - CONN:3598344 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229730973744'');
Date: 2026-08-27 14:37:42 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 2 ERROR: function rs_caixa_qr(...) does not exist
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 27 08 2 - ERROR: function rs_caixa_qr(numeric) does not exist at character 15
- ERROR: function rs_caixa_qr(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(11916485850068706917)Date: 2026-08-27 08:26:17 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: select * from rs_caixa_qr(11916485850068706917)Date: 2026-08-27 08:26:17 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 27 03 1 - LOG: database system was shut down at 2026-08-27 03:05:01 -03
Date: 2026-08-27 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 1 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 27 09 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":"485754437BF676B8","barra2":"2C94525942C8","barra3":"WIFITWPASCLARO_5942C8PPAFYH","lote":""}');Date: 2026-08-27 09:49:45 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log