pgBadger-
Global information
- Generated on Mon Jul 27 23:50:14 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 53,096 log entries in 13s
- Log start from 2026-07-27 00:00:32 to 2026-07-27 23:50:10
-
Overview
Global Stats
- 458 Number of unique normalized queries
- 6,843 Number of queries
- 17h59m40s Total query duration
- 2026-07-27 00:02:24 First query
- 2026-07-27 23:50:10 Last query
- 6 queries/s at 2026-07-27 10:05:20 Query peak
- 17h59m40s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 17h59m40s Execute total duration
- 5,706 Number of events
- 22 Number of unique normalized events
- 4,672 Max number of times the same event was reported
- 0 Number of cancellation
- 852 Total number of automatic vacuums
- 990 Total number of automatic analyzes
- 12 Number temporary file
- 237.16 MiB Max size of temporary file
- 109.24 MiB Average size of temporary file
- 417 Total number of sessions
- 8 sessions at 2026-07-27 21:05:23 Session peak
- 13d21h12m48s Total duration of sessions
- 47m56s Average duration of sessions
- 16 Average queries per session
- 2m35s Average queries duration per session
- 45m21s Average idle time per session
- 432 Total number of connections
- 8 connections/s at 2026-07-27 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-27 10:05:20 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-27 10:05:20 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-27 20:09:21 Date
Queries duration
Key values
- 17h59m40s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 27 00 23 0ms 22s428ms 5s411ms 3s216ms 3s386ms 1m14s 01 12 0ms 3s18ms 1s530ms 2s812ms 3s128ms 3s323ms 02 12 0ms 3s347ms 1s564ms 2s829ms 3s108ms 3s624ms 03 14 0ms 3s140ms 1s373ms 2s671ms 3s266ms 4s536ms 04 12 0ms 3s175ms 1s485ms 2s603ms 2s961ms 3s656ms 05 17 0ms 9m14s 1m3s 3s291ms 2m29s 9m14s 06 33 0ms 20s483ms 2s805ms 3s275ms 9s95ms 30s452ms 07 218 0ms 13m35s 15s87ms 1m48s 4m44s 16m41s 08 547 0ms 11m20s 4s604ms 1m5s 4m48s 11m39s 09 704 150ms 9m21s 5s298ms 4m22s 8m42s 9m26s 10 575 150ms 10m11s 4s367ms 56s785ms 5m8s 10m28s 11 763 150ms 30m39s 7s820ms 5m37s 8m40s 30m47s 12 194 0ms 43m21s 41s626ms 4m55s 17m14s 43m23s 13 407 0ms 7m25s 3s708ms 49s75ms 2m42s 7m27s 14 880 150ms 21m41s 5s347ms 1m55s 5m17s 21m54s 15 793 150ms 38m6s 23s87ms 6m54s 38m11s 1h45m12s 16 675 150ms 13m27s 4s571ms 1m3s 6m17s 13m30s 17 422 0ms 13m24s 5s809ms 1m9s 5m24s 13m26s 18 23 0ms 10m39s 45s858ms 4s322ms 2m4s 10m42s 19 21 0ms 6m16s 32s434ms 3s896ms 16s605ms 6m47s 20 143 0ms 11m23s 12s6ms 1m9s 2m27s 11m23s 21 34 0ms 7m28s 22s572ms 6s976ms 49s117ms 7m28s 22 32 0ms 5m37s 19s955ms 6s78ms 47s377ms 5m37s 23 289 0ms 1m36s 8s297ms 1m9s 1m10s 2m16s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 27 00 5 0 6s703ms 0ms 0ms 604ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 208ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 0 0 0ms 0ms 0ms 0ms 06 13 0 2s727ms 0ms 0ms 2s568ms 07 163 0 17s989ms 6s25ms 1m48s 13m39s 08 415 0 4s951ms 11s439ms 1m4s 5m52s 09 554 0 5s687ms 34s412ms 4m22s 8m34s 10 462 0 4s340ms 16s502ms 40s211ms 7m32s 11 609 0 8s792ms 31s675ms 4m58s 17m33s 12 133 0 59s167ms 7s955ms 4m55s 30m37s 13 327 0 3s666ms 10s396ms 37s354ms 4m9s 14 653 0 5s165ms 40s107ms 1m27s 10m32s 15 590 0 20s535ms 36s363ms 5m27s 38m11s 16 531 0 5s125ms 25s471ms 1m3s 7m49s 17 302 0 7s367ms 27s490ms 1m7s 5m13s 18 8 0 2m8s 0ms 0ms 3m57s 19 6 0 1m48s 0ms 0ms 3m49s 20 23 103 13s295ms 40s19ms 1m8s 4m6s 21 14 0 51s831ms 0ms 448ms 3m45s 22 10 0 1m 0ms 0ms 3m34s 23 11 278 8s297ms 1m4s 1m9s 2m16s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 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 1 0 0 1s440ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 27 00 0 1 1.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 3 3.00 0.00% 07 0 11 11.00 0.00% 08 0 19 19.00 0.00% 09 0 17 17.00 0.00% 10 0 23 23.00 0.00% 11 0 23 23.00 0.00% 12 0 9 9.00 0.00% 13 0 13 13.00 0.00% 14 0 32 32.00 0.00% 15 0 28 28.00 0.00% 16 0 19 19.00 0.00% 17 0 16 16.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 2 2.00 0.00% 21 0 1 1.00 0.00% 22 0 2 2.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jul 27 00 14 0.00/s 01 8 0.00/s 02 6 0.00/s 03 15 0.00/s 04 8 0.00/s 05 9 0.00/s 06 17 0.00/s 07 18 0.01/s 08 23 0.01/s 09 22 0.01/s 10 22 0.01/s 11 27 0.01/s 12 14 0.00/s 13 24 0.01/s 14 40 0.01/s 15 51 0.01/s 16 22 0.01/s 17 20 0.01/s 18 10 0.00/s 19 9 0.00/s 20 16 0.00/s 21 11 0.00/s 22 11 0.00/s 23 15 0.00/s Day Hour Count Average Duration Average idle time Jul 27 00 7 56m8s 55m51s 01 13 1h41s 1h40s 02 8 1h22s 1h20s 03 14 16m4s 16m2s 04 7 1h3m 1h2m57s 05 9 55m7s 53m7s 06 9 51m46s 51m35s 07 16 56m26s 53m1s 08 19 53m14s 51m1s 09 22 56m17s 53m28s 10 22 56m56s 55m2s 11 23 52m57s 48m38s 12 25 53m56s 48m33s 13 15 50m24s 48m43s 14 32 39m35s 37m8s 15 55 29m42s 24m9s 16 26 43m41s 41m43s 17 20 47m54s 45m52s 18 14 59m18s 58m3s 19 10 1h37s 59m29s 20 13 43m4s 40m52s 21 12 56m20s 55m16s 22 10 1h 58m56s 23 16 43m56s 41m26s -
Connections
Established Connections
Key values
- 8 connections Connection Peak
- 2026-07-27 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 432 connections Total
Connections per user
Key values
- intelifix Main User
- 432 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-27 21:05:23 Date
Histogram of session times
Key values
- 296 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 417 sessions Total
Sessions per user
Key values
- intelifix Main User
- 417 sessions Total
Sessions per host
Key values
- [local] Main Host
- 417 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 417 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 26,434 buffers Checkpoint Peak
- 2026-07-27 11:59:37 Date
- 270.036 seconds Highest write time
- 0.114 seconds Sync time
Checkpoints Wal files
Key values
- 17 files Wal files usage Peak
- 2026-07-27 14:39:37 Date
Checkpoints distance
Key values
- 544.81 Mo Distance Peak
- 2026-07-27 14:39:37 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 27 00 18,036 539.03s 0.009s 539.057s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0.059s 0.004s 0.075s 04 0 0s 0s 0s 05 6,166 616.869s 0.029s 616.937s 06 4,278 428.281s 0.017s 428.317s 07 47,167 2,464.668s 0.254s 2,465.034s 08 50,140 3,175.936s 0.554s 3,176.68s 09 82,303 3,238.698s 0.749s 3,239.71s 10 65,045 3,238.858s 0.603s 3,239.687s 11 142,500 3,238.553s 0.835s 3,239.658s 12 34,701 2,213.737s 0.198s 2,214.068s 13 28,663 2,219.792s 0.481s 2,220.431s 14 89,181 3,238.395s 0.927s 3,239.689s 15 97,232 3,238.435s 0.863s 3,239.621s 16 69,503 3,218.968s 0.62s 3,219.818s 17 51,853 2,384.272s 0.458s 2,384.92s 18 1,972 198.027s 0.023s 198.1s 19 28 2.877s 0.007s 2.903s 20 817 319.912s 0.042s 319.984s 21 3,095 312.778s 0.038s 312.893s 22 2,534 254.429s 0.059s 254.556s 23 562 56.484s 0.019s 56.533s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 27 00 0 0 6 62 0.002s 0.002s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 3 0.002s 0.001s 04 0 0 0 0 0s 0s 05 0 0 2 137 0.003s 0.006s 06 0 0 1 222 0.002s 0.003s 07 0 0 29 2,757 0.018s 0.011s 08 0 0 25 6,017 0.007s 0.012s 09 0 0 46 7,717 0.013s 0.012s 10 0 0 41 6,702 0.011s 0.012s 11 0 0 69 7,483 0.011s 0.012s 12 0 0 20 3,208 0.012s 0.012s 13 0 0 13 4,767 0.014s 0.012s 14 0 0 102 7,817 0.031s 0.012s 15 0 0 75 6,704 0.015s 0.012s 16 0 0 39 5,442 0.008s 0.012s 17 0 0 33 4,829 0.008s 0.012s 18 0 0 1 276 0.006s 0.006s 19 0 0 0 9 0.003s 0.004s 20 0 0 1 89 0.009s 0.004s 21 0 0 1 451 0.004s 0.009s 22 0 0 1 591 0.005s 0.009s 23 0 0 0 92 0.004s 0.006s Day Hour Count Avg time (sec) Jul 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 Jul 27 00 44,688.00 kB 44,688.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 24,456.00 kB 04 0.00 kB 0.00 kB 05 6,898.83 kB 10,366.00 kB 06 4,610.33 kB 10,743.33 kB 07 42,960.00 kB 66,803.36 kB 08 34,311.33 kB 81,304.08 kB 09 61,974.67 kB 101,163.92 kB 10 56,878.58 kB 85,548.42 kB 11 94,244.25 kB 155,997.75 kB 12 27,444.67 kB 138,000.50 kB 13 17,524.92 kB 49,534.33 kB 14 138,820.92 kB 182,170.67 kB 15 102,777.83 kB 205,445.75 kB 16 53,341.08 kB 108,448.17 kB 17 44,911.42 kB 93,260.17 kB 18 1,360.83 kB 45,058.33 kB 19 64.00 kB 27,847.67 kB 20 5,877.50 kB 21,204.25 kB 21 1,951.50 kB 12,283.75 kB 22 1,365.22 kB 6,010.00 kB 23 270.80 kB 3,264.40 kB -
Temporary Files
Size of temporary files
Key values
- 474.31 MiB Temp Files size Peak
- 2026-07-27 05:31:56 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-27 05:32:03 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 27 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.28 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 1 104.00 MiB 104.00 MiB 12 0 0 0 13 0 0 0 14 1 104.00 MiB 104.00 MiB 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 921.50 MiB 70.74 MiB 237.16 MiB 115.19 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-27 05:32:04 Duration: 1m22s 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-07-27 05:31:56 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 208.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 12:23:14 Duration: 43m21s 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( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 15:10:49 Duration: 38m6s 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( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');
Date: 2026-07-27 15:16:35 Duration: 33m Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 2 181.33 MiB 90.66 MiB 90.66 MiB 90.66 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-27 05:30:41 Duration: 39s703ms 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-07-27 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 237.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 237.16 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:31:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-27 11:19:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-27 14:20:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 90.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-27 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 90.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-27 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.35 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 78.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 78.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.81 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:32:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 70.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 70.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-27 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.77 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database contagem - 2026-07-27 10:58:03 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 7.77 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database contagem - 2026-07-27 10:58:03 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (126) Main table analyzed (database rio)
- 990 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 126 rio.pg_catalog.pg_class 63 rio.pg_catalog.pg_type 54 rio.public.temp0000286596 54 rio.public.temp0000286498 53 brasilia.pg_catalog.pg_attribute 52 rio.public.usuarios 47 rio.pg_catalog.pg_index 34 rio.public.temp0000286502 30 rio.pg_catalog.pg_depend 27 brasilia.pg_catalog.pg_class 24 rio.public.temp0000286606 22 contagem.pg_catalog.pg_attribute 22 brasilia.pg_catalog.pg_type 20 contagem.public.usuarios 19 rio.public.temp0000285404 17 rio.public.temp0000286576 16 rio.public.temp0000286492 15 rio.public.temp0000286632 14 brasilia.pg_catalog.pg_index 13 rio.public.temp0000286508 13 rio.public.temp0000286506 11 contagem.pg_catalog.pg_class 10 rio.public.temp0000286612 9 contagem.public.temp0000226696 9 brasilia.pg_catalog.pg_depend 9 rio.public.temp0000286572 9 contagem.pg_catalog.pg_type 8 rio.public.temp0000286642 8 rio.public.temp0000286564 7 brasilia.public.usuarios 7 rio.public.temp0000286494 7 rio.public.temp0000286566 6 rio.public.temp0000286562 6 brasilia.public.temp0000236950 6 rio.public.temp0000284750 6 contagem.pg_catalog.pg_index 5 rio.public.temp0000286112 5 rio.public.temp0000286608 5 rio.public.temp0000286400 5 brasilia.public.temp0000236914 5 contagem.pg_catalog.pg_shdepend 4 rio.public.temp0000286532 4 rio.public.tmp_drill_0175 4 contagem.pg_catalog.pg_depend 4 brasilia.public.temp0000236880 4 rio.public.temp0000286574 3 postgres.pg_catalog.pg_shdepend 3 brasilia.public.nf_entrada 3 rio.public.temp0000286618 3 rio.public.temp0000286614 3 rio.pg_catalog.pg_shdepend 3 rio.public.temp0000286568 3 brasilia.public.temp0000236916 3 brasilia.public.temp0000236942 2 brasilia.public.temp0000236888 2 template1.pg_catalog.pg_shdepend 2 brasilia.public.temp0000236908 2 rio.public.temp0000286604 2 contagem.public.temp0000226698 2 rio.public.temp0000286584 2 brasilia.public.temp0000236918 2 brasilia.pg_catalog.pg_shdepend 2 contagem.public.nf_entrada 2 rio.public.temp0000286546 2 rio.public.temp0000286626 2 contagem.public.temp0000226678 2 brasilia.public.temp0000236898 2 brasilia.public.temp0000236894 2 brasilia.public.temp0000236922 2 rio.public.temp0000286518 2 rio.public.temp0000286610 2 brasilia.public.temp0000236904 2 rio.public.temp0000286520 2 rio.public.temp0000285950 2 rio.public.temp0000286512 2 brasilia.public.temp0000236892 1 rio.public.temp0000286624 1 rio.public.temp0000286552 1 rio.public.temp0000286192 1 rio.public.temp0000286504 1 rio.public.temp0000286644 1 rio.public.temp0000286590 1 rio.public.temp0000286630 1 rio.public.temp0000286650 1 brasilia.public.temp0000236924 1 brasilia.public.temp0000236944 1 rio.public.temp0000286540 1 rio.public.temp0000286602 1 rio.public.tmp_drill_0302 1 rio.public.temp0000286636 1 rio.public.temp0000286628 1 rio.public.temp0000286598 1 rio.public.temp0000286622 1 brasilia.public.temp0000236902 1 rio.public.temp0000286522 1 rio.public.temp0000286528 1 rio.public.temp0000286530 1 rio.public.temp0000286600 1 rio.public.temp0000286580 1 Total 990 Vacuums per table
Key values
- pg_catalog.pg_attribute (152) Main table vacuumed on database rio
- 852 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 152 42 0 0 0 0 0 24,099 6,702 9,562,823 360 8,586 rio.public.usuarios 105 8 0 0 0 0 0 275 126 265,757 11 22 rio.pg_catalog.pg_class 93 30 0 0 0 0 0 6,095 1,863 2,571,188 93 515 rio.pg_catalog.pg_type 60 22 0 0 0 0 0 2,310 771 997,334 72 227 rio.public.temp0000286498 55 0 0 0 0 0 0 24,082 2,014 3,781,504 0 0 rio.pg_catalog.pg_index 44 16 0 0 0 0 0 1,053 306 287,025 61 127 rio.public.temp0000286596 44 0 0 0 0 0 0 2,756 295 339,230 0 0 rio.pg_catalog.pg_statistic 22 9 0 0 0 0 0 11,573 3,098 14,450,498 994 4,771 rio.public.temp0000286606 19 0 0 0 0 0 0 16,877 5,110 7,493,711 0 0 contagem.public.usuarios 19 0 0 0 0 0 0 90 68 35,597 0 0 brasilia.pg_catalog.pg_attribute 19 17 0 0 0 0 0 7,756 1,917 3,298,967 63 1,720 rio.public.temp0000285404 14 0 0 0 0 0 0 748 155 190,475 0 0 rio.public.temp0000286632 13 0 0 0 0 0 0 7,291 160 646,306 0 0 rio.pg_catalog.pg_depend 12 12 0 0 0 0 0 3,792 1,372 1,888,070 74 603 brasilia.pg_catalog.pg_type 11 9 0 0 0 0 0 833 217 303,521 20 58 brasilia.pg_catalog.pg_class 11 9 0 0 0 0 0 1,762 462 757,248 21 75 rio.public.temp0000286612 9 0 0 0 0 0 0 6,855 1,715 2,569,567 0 0 contagem.pg_catalog.pg_attribute 9 9 0 0 0 0 0 6,061 1,154 2,365,607 14 326 rio.public.temp0000286576 7 0 0 0 0 0 0 36 25 6,517 0 0 rio.public.temp0000286566 6 0 0 0 0 0 0 8,409 1,700 2,656,186 0 0 rio.public.temp0000284750 6 0 0 0 0 0 0 201 189 275,153 0 0 rio.public.temp0000286400 5 0 0 0 0 0 0 115 26 10,830 0 0 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 638 122 207,921 2 6 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,305 506 2,708,195 135 347 rio.public.temp0000286572 5 0 0 0 0 0 0 36 24 6,690 0 0 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 739 270 424,063 52 122 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 262 74 75,171 13 27 rio.public.temp0000286112 4 0 0 0 0 0 0 80 20 7,589 0 0 contagem.pg_catalog.pg_class 4 4 0 0 0 0 0 1,130 117 237,745 4 13 rio.public.temp0000286642 4 0 0 0 0 0 0 265 17 19,072 0 0 rio.public.tmp_drill_0175 4 3 0 0 0 0 0 231 11 51,617 0 0 brasilia.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,056 250 376,191 18 119 rio.public.temp0000286574 3 0 0 0 0 0 0 1,689 1,687 2,258,311 0 0 rio.public.temp0000286618 3 0 0 0 0 0 0 1,693 10 101,566 0 0 rio.public.temp0000286614 3 0 0 0 0 0 0 12 9 2,322 0 0 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,008 126 353,798 1 6 rio.public.temp0000286610 3 0 0 0 0 0 0 1,691 11 102,019 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 197 33 44,029 0 0 contagem.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 251 55 106,457 6 9 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,153 314 1,388,401 225 1,912 rio.public.temp0000286518 2 0 0 0 0 0 0 176 12 12,214 0 0 rio.public.temp0000286568 2 0 0 0 0 0 0 1,689 1,689 2,264,487 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 361 70 333,467 33 91 brasilia.public.temp0000236904 2 0 0 0 0 0 0 488 12 31,074 0 0 contagem.public.temp0000226696 2 0 0 0 0 0 0 114 11 8,549 0 0 rio.public.temp0000286604 2 0 0 0 0 0 0 3,364 1,687 2,360,068 0 0 rio.public.temp0000286584 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.public.temp0000286520 2 0 0 0 0 0 0 16 10 2,636 0 0 rio.public.temp0000285950 2 0 0 0 0 0 0 139 12 9,947 0 0 rio.public.temp0000286626 2 0 0 0 0 0 0 8 6 1,548 0 0 rio.public.temp0000286602 1 0 0 0 0 0 0 1,682 4 99,841 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 122 27 81,711 11 28 rio.public.temp0000286192 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286552 1 0 0 0 0 0 0 1,681 4 99,782 0 0 rio.public.temp0000286624 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000236898 1 0 0 0 0 0 0 244 6 15,537 0 0 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 41 3 8,587 0 0 rio.public.temp0000286608 1 0 0 0 0 0 0 101 6 6,901 0 0 rio.public.temp0000286636 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286644 1 0 0 0 0 0 0 8 6 2,714 0 0 rio.public.temp0000286590 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286628 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286598 1 0 0 0 0 0 0 83 6 5,782 0 0 rio.public.temp0000286564 1 0 0 0 0 0 0 54 6 4,026 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 26,844 20,630 26,094,788 2,968 73,320 rio.pg_catalog.pg_constraint 1 1 0 0 0 0 0 25 10 21,985 0 0 rio.public.temp0000286650 1 0 0 0 0 0 0 62 6 4,512 0 0 rio.public.temp0000286630 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000286622 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000236924 1 0 0 0 0 0 0 244 6 15,526 0 0 rio.public.temp0000286522 1 0 0 0 0 0 0 8 5 1,306 0 0 rio.public.temp0000286528 1 0 0 0 0 0 0 8 5 1,307 0 0 rio.public.temp0000286532 1 0 0 0 0 0 0 8 5 1,308 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,296 416 1,494,862 389 2,895 rio.public.temp0000286530 1 0 0 0 0 0 0 8 5 1,307 0 0 rio.public.temp0000286580 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.notas_fiscais 1 1 0 0 0 0 0 112 83 314,318 2 359 contagem.public.nf_entrada 1 1 0 0 0 0 0 119 46 69,493 0 0 rio.public.temp0000286540 1 0 0 0 0 0 0 89 6 6,169 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 89 40 126,209 4 6 rio.public.temp0000286546 1 0 0 0 0 0 0 35 35 51,480 0 0 Total 852 232 0 0 0 0 0 189,863 58,006 96,785,452 5,646 96,290 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (7.77) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 5.46999999999999 rio.public.usuarios 0 0 0.03 rio.pg_catalog.pg_class 0 0 1.3 rio.pg_catalog.pg_type 0 0 0.54 rio.public.temp0000286498 0 0 1.79 rio.pg_catalog.pg_index 0 0 0.46 rio.public.temp0000286596 0 0 1.03 rio.pg_catalog.pg_statistic 0 0 2.23 rio.public.temp0000286606 0 0 1.12 contagem.public.usuarios 0 0 0.01 brasilia.pg_catalog.pg_attribute 0 0 1.26 rio.public.temp0000285404 0 0 0.21 rio.public.temp0000286632 0 0 0.48 rio.pg_catalog.pg_depend 0 0 1.1 brasilia.pg_catalog.pg_type 0 0 0.43 brasilia.pg_catalog.pg_class 0 0 0.61 rio.public.temp0000286612 0 0 0.4 contagem.pg_catalog.pg_attribute 0 0 1.14 rio.public.temp0000286576 0 0 0.12 rio.public.temp0000286566 0 0 0.33 rio.public.temp0000284750 0 0 0.07 rio.public.temp0000286400 0 0 0.08 contagem.pg_catalog.pg_type 0 0 0.28 rio.pg_toast.pg_toast_2619 0 0 0.31 rio.public.temp0000286572 0 0 0.08 brasilia.pg_catalog.pg_shdepend 0 0 0.33 brasilia.pg_catalog.pg_index 0 0 5.09 rio.public.temp0000286112 0 0 0.03 contagem.pg_catalog.pg_class 0 0 0.31 rio.public.temp0000286642 0 0 0.08 rio.public.tmp_drill_0175 0 0 0.02 brasilia.pg_catalog.pg_depend 0 0 0.39 rio.public.temp0000286574 0 0 0.19 rio.public.temp0000286618 0 0 0.15 rio.public.temp0000286614 0 0 0.15 contagem.pg_catalog.pg_depend 0 0 0.24 rio.public.temp0000286610 0 0 0.17 contagem.pg_catalog.pg_index 0 0 0.17 contagem.pg_catalog.pg_shdepend 0 0 0.06 brasilia.pg_catalog.pg_statistic 0 0 0.28 rio.public.temp0000286518 0 0 0.02 rio.public.temp0000286568 0 0 0.13 brasilia.pg_toast.pg_toast_2619 0 0 0.06 brasilia.public.temp0000236904 0 0 0.04 contagem.public.temp0000226696 0 0 0.03 rio.public.temp0000286604 0 0 0.14 rio.public.temp0000286584 0 0 0.09 rio.public.temp0000286520 0 0 0.02 rio.public.temp0000285950 0 0 0.04 rio.public.temp0000286626 0 0 0.09 rio.public.temp0000286602 0 0 0.05 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000286192 0 0 0.05 rio.public.temp0000286552 0 0 0.05 rio.public.temp0000286624 0 0 0.05 brasilia.public.temp0000236898 0 0 0.02 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000286608 0 0 0.01 rio.public.temp0000286636 0 0 0.05 rio.public.temp0000286644 0 0 0.02 rio.public.temp0000286590 0 0 0.04 rio.public.temp0000286628 0 0 0.04 rio.public.temp0000286598 0 0 0.02 rio.public.temp0000286564 0 0 0.01 contagem.auditor.auditor_2026_07 0 0 7.77 rio.pg_catalog.pg_constraint 0 0 0.05 rio.public.temp0000286650 0 0 0.02 rio.public.temp0000286630 0 0 0.05 rio.public.temp0000286622 0 0 0.07 brasilia.public.temp0000236924 0 0 0.02 rio.public.temp0000286522 0 0 0.02 rio.public.temp0000286528 0 0 0.01 rio.public.temp0000286532 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.09 rio.public.temp0000286530 0 0 0.01 rio.public.temp0000286580 0 0 0.05 rio.public.notas_fiscais 0 0 0.23 contagem.public.nf_entrada 0 0 0.07 rio.public.temp0000286540 0 0 0.02 brasilia.public.nf_entrada 0 0 0.06 rio.public.temp0000286546 0 0 0 Total 0 0 38.16 Tuples removed per table
Key values
- pg_catalog.pg_attribute (201962) Main table with removed tuples on database rio
- 408663 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 152 42 201,962 4,690,035 1,348,365 441 111,619 brasilia.pg_catalog.pg_attribute 19 17 65,638 432,087 21,863 141 10,604 contagem.pg_catalog.pg_attribute 9 9 50,571 211,968 226 264 5,106 rio.pg_catalog.pg_statistic 22 9 14,963 227,803 29,263 0 28,292 rio.pg_catalog.pg_depend 12 12 14,281 224,538 7,212 0 2,248 rio.pg_catalog.pg_type 60 22 8,622 177,526 38,622 15 4,625 rio.pg_catalog.pg_class 93 30 6,872 450,446 112,044 81 12,793 brasilia.pg_catalog.pg_statistic 2 2 5,045 15,378 47 0 2,144 brasilia.pg_catalog.pg_shdepend 5 5 4,459 68,020 88 0 595 rio.pg_catalog.pg_index 44 16 4,381 101,919 16,383 0 2,596 contagem.pg_catalog.pg_statistic 1 1 4,237 7,274 0 0 1,011 brasilia.pg_catalog.pg_type 11 9 3,423 26,097 1,696 33 727 contagem.pg_catalog.pg_type 5 5 3,307 12,071 2 84 357 brasilia.pg_catalog.pg_class 11 9 3,261 39,528 4,189 0 1,511 contagem.pg_catalog.pg_depend 3 3 3,196 57,354 6 41 550 brasilia.pg_catalog.pg_depend 4 4 2,456 75,298 4,726 19 735 contagem.pg_catalog.pg_class 4 4 2,407 15,464 4 105 561 contagem.pg_catalog.pg_shdepend 2 2 1,568 27,634 473 0 238 contagem.pg_catalog.pg_index 2 2 1,543 3,791 1 13 122 rio.pg_toast.pg_toast_2619 5 5 1,291 3,244 3 0 1,280 contagem.public.usuarios 19 0 1,180 437 0 0 38 brasilia.pg_catalog.pg_index 5 5 1,078 9,650 287 0 291 rio.public.tmp_drill_0175 4 3 1,043 21,626 9,206 0 316 rio.public.usuarios 105 8 853 85,654 32,209 0 1,890 rio.public.tmp_drill_0302 1 1 392 392 0 0 11 contagem.public.nf_entrada 1 1 280 966 0 0 69 brasilia.pg_toast.pg_toast_2619 2 2 174 270 0 0 122 contagem.pg_toast.pg_toast_2619 1 1 94 113 0 0 51 brasilia.public.nf_entrada 1 1 63 6,036 952 0 152 rio.pg_catalog.pg_constraint 1 1 22 1,376 4 0 37 rio.public.notas_fiscais 1 1 1 178,558 0 0 968 rio.public.temp0000286602 1 0 0 23,680 0 0 1,728 rio.public.temp0000286112 4 0 0 5,058 0 16 112 rio.public.temp0000286192 1 0 0 23,706 0 0 1,728 rio.public.temp0000286552 1 0 0 23,660 0 0 1,728 rio.public.temp0000286624 1 0 0 23,724 0 0 1,728 rio.public.temp0000286612 9 0 0 169,282 0 69 12,283 rio.public.temp0000286574 3 0 0 71,007 0 0 5,184 rio.public.temp0000286618 3 0 0 71,180 0 0 5,184 brasilia.public.temp0000236898 1 0 0 3,142 0 20 236 rio.public.temp0000286608 1 0 0 1,671 0 35 93 rio.public.temp0000286566 6 0 0 141,988 0 0 10,368 rio.public.temp0000286636 1 0 0 23,734 0 0 1,728 rio.public.temp0000286644 1 0 0 5,273 0 9 119 rio.public.temp0000286614 3 0 0 71,127 0 0 5,184 rio.public.temp0000286576 7 0 0 58,905 0 78 3,826 rio.public.temp0000286642 4 0 0 39,841 0 9 2,103 rio.public.temp0000286590 1 0 0 23,678 0 0 1,728 rio.public.temp0000286628 1 0 0 23,725 0 0 1,728 rio.public.temp0000286400 5 0 0 14,713 0 120 328 rio.public.temp0000286598 1 0 0 3,361 0 53 75 rio.public.temp0000286564 1 0 0 2,086 0 18 46 contagem.auditor.auditor_2026_07 1 0 0 2,996,956 0 0 127,780 rio.public.temp0000285404 14 0 0 56,555 0 398 1,266 rio.public.temp0000284750 6 0 0 21,904 0 147 493 rio.public.temp0000286518 2 0 0 3,004 0 96 160 rio.public.temp0000286606 19 0 0 450,854 0 0 32,832 rio.public.temp0000286650 1 0 0 1,023 0 10 54 rio.public.temp0000286630 1 0 0 23,731 0 0 1,728 rio.public.temp0000286622 1 0 0 23,723 0 0 1,728 rio.public.temp0000286610 3 0 0 71,085 0 0 5,184 brasilia.public.temp0000236924 1 0 0 3,143 0 20 236 rio.public.temp0000286568 2 0 0 47,462 0 0 3,456 rio.public.temp0000286522 1 0 0 1,502 0 48 80 brasilia.public.temp0000236904 2 0 0 6,284 0 40 472 rio.public.temp0000286528 1 0 0 1,502 0 48 80 rio.public.temp0000286532 1 0 0 1,508 0 48 80 contagem.public.temp0000226696 2 0 0 2,564 0 60 196 rio.public.temp0000286604 2 0 0 47,362 0 0 3,456 rio.public.temp0000286572 5 0 0 15,321 0 40 344 rio.public.temp0000286584 2 0 0 47,356 0 0 3,456 rio.public.temp0000286530 1 0 0 1,502 0 48 80 rio.public.temp0000286520 2 0 0 3,153 0 84 172 rio.public.temp0000286580 1 0 0 23,670 0 0 1,728 rio.public.temp0000286596 44 0 0 333,413 0 1,406 20,226 rio.public.temp0000285950 2 0 0 2,324 0 69 123 rio.public.temp0000286540 1 0 0 1,511 0 47 81 rio.public.temp0000286498 55 0 0 703,616 0 1,244 50,596 rio.public.temp0000286632 13 0 0 176,482 0 179 12,685 rio.public.temp0000286546 1 0 0 1,395 0 0 32 rio.public.temp0000286626 2 0 0 47,453 0 0 3,456 Total 852 232 408,663 13,114,452 1,627,871 5,696 521,156 Pages removed per table
Key values
- public.temp0000286596 (1406) Main table with removed pages on database rio
- 5696 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000286596 44 0 0 1406 rio.public.temp0000286498 55 0 0 1244 rio.pg_catalog.pg_attribute 152 42 201962 441 rio.public.temp0000285404 14 0 0 398 contagem.pg_catalog.pg_attribute 9 9 50571 264 rio.public.temp0000286632 13 0 0 179 rio.public.temp0000284750 6 0 0 147 brasilia.pg_catalog.pg_attribute 19 17 65638 141 rio.public.temp0000286400 5 0 0 120 contagem.pg_catalog.pg_class 4 4 2407 105 rio.public.temp0000286518 2 0 0 96 contagem.pg_catalog.pg_type 5 5 3307 84 rio.public.temp0000286520 2 0 0 84 rio.pg_catalog.pg_class 93 30 6872 81 rio.public.temp0000286576 7 0 0 78 rio.public.temp0000286612 9 0 0 69 rio.public.temp0000285950 2 0 0 69 contagem.public.temp0000226696 2 0 0 60 rio.public.temp0000286598 1 0 0 53 rio.public.temp0000286522 1 0 0 48 rio.public.temp0000286528 1 0 0 48 rio.public.temp0000286532 1 0 0 48 rio.public.temp0000286530 1 0 0 48 rio.public.temp0000286540 1 0 0 47 contagem.pg_catalog.pg_depend 3 3 3196 41 brasilia.public.temp0000236904 2 0 0 40 rio.public.temp0000286572 5 0 0 40 rio.public.temp0000286608 1 0 0 35 brasilia.pg_catalog.pg_type 11 9 3423 33 brasilia.public.temp0000236898 1 0 0 20 brasilia.public.temp0000236924 1 0 0 20 brasilia.pg_catalog.pg_depend 4 4 2456 19 rio.public.temp0000286564 1 0 0 18 rio.public.temp0000286112 4 0 0 16 rio.pg_catalog.pg_type 60 22 8622 15 contagem.pg_catalog.pg_index 2 2 1543 13 rio.public.temp0000286650 1 0 0 10 rio.public.temp0000286644 1 0 0 9 rio.public.temp0000286642 4 0 0 9 rio.public.temp0000286602 1 0 0 0 contagem.pg_catalog.pg_shdepend 2 2 1568 0 contagem.pg_toast.pg_toast_2619 1 1 94 0 rio.public.temp0000286192 1 0 0 0 rio.public.temp0000286552 1 0 0 0 rio.public.temp0000286624 1 0 0 0 rio.public.usuarios 105 8 853 0 rio.pg_catalog.pg_statistic 22 9 14963 0 rio.public.temp0000286574 3 0 0 0 rio.public.temp0000286618 3 0 0 0 rio.public.tmp_drill_0302 1 1 392 0 rio.public.temp0000286566 6 0 0 0 rio.public.temp0000286636 1 0 0 0 rio.public.temp0000286614 3 0 0 0 brasilia.pg_catalog.pg_statistic 2 2 5045 0 rio.public.temp0000286590 1 0 0 0 rio.public.temp0000286628 1 0 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 rio.pg_catalog.pg_constraint 1 1 22 0 rio.public.temp0000286606 19 0 0 0 rio.public.temp0000286630 1 0 0 0 rio.public.temp0000286622 1 0 0 0 rio.public.temp0000286610 3 0 0 0 rio.public.temp0000286568 2 0 0 0 contagem.public.usuarios 19 0 1180 0 brasilia.pg_toast.pg_toast_2619 2 2 174 0 rio.pg_catalog.pg_index 44 16 4381 0 rio.pg_toast.pg_toast_2619 5 5 1291 0 rio.public.tmp_drill_0175 4 3 1043 0 contagem.pg_catalog.pg_statistic 1 1 4237 0 rio.public.temp0000286604 2 0 0 0 rio.public.temp0000286584 2 0 0 0 brasilia.pg_catalog.pg_class 11 9 3261 0 brasilia.pg_catalog.pg_shdepend 5 5 4459 0 rio.public.temp0000286580 1 0 0 0 rio.public.notas_fiscais 1 1 1 0 contagem.public.nf_entrada 1 1 280 0 brasilia.pg_catalog.pg_index 5 5 1078 0 brasilia.public.nf_entrada 1 1 63 0 rio.public.temp0000286546 1 0 0 0 rio.pg_catalog.pg_depend 12 12 14281 0 rio.public.temp0000286626 2 0 0 0 Total 852 232 408,663 5,696 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 27 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 6 0 06 0 1 07 11 19 08 42 90 09 56 114 10 52 97 11 91 119 12 82 31 13 26 56 14 139 168 15 187 136 16 72 92 17 84 61 18 0 0 19 0 0 20 0 0 21 2 3 22 1 2 23 1 1 - 7.77 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 27 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 15 2h26m 3s779ms 27m13s 9m44s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 12:23:14 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( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 15:10:49 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( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');
Date: 2026-07-27 15:16:35 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 5 1h3m9s 5s560ms 34m48s 12m37s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-27 15:11:42 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-07-27 15:11:44 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-07-27 09:37:29 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 2 23m6s 6m34s 16m31s 11m33s call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-27 15:11:44 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-07-27 15:11:55 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-07-27 09:05:22 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 2 1m4s 1s2ms 1m3s 32s228ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (271378, 507, '929240032276,5447CCCC5AF5,2035431B18EB', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$$$$$','', 00);
Date: 2026-07-27 15:23:09 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270205, 503, '518312082131,4C1265359621,BC644BD5A0E1,BC644BD06969,BC644BCC3EE3,5819F8446F04,BC644BCEF322,B0DAF94ACD47,F8F53255C8B8,A89FECBFC9CE,F8F53258CE9B,4C1265EAE53F,BC644BD5FC3F,5819F8444484,BC644BDB5AEF,B0935BECD2D3,B0935BEC8A8F,B0DAF9515D88,B0DAF94A5F74,BC644BC60D34,4C12653C5C8B,A89FECC2DA0B,BC644BDC38E3,A8F5DDED0E34,4C12653E003B,B0935BE96B52,BC644BC42C58,F8F53258CF7C,B0DAF9688BA9,4C1265EACCA3,BC644BE47170,4C1265E74FC9,B0935BEB6D5D,2C584F33D89B,A8F5DDE9652C,2C584F373275,BC644BD56A68,BC644BC89185,5819F8472F00,2C584F2F5488,BC644BE4B455', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-27 16:06:22 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48039, 418, '226122281018', '',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-07-27 15:40:04 Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 2 2s20ms 1s 1s19ms 1s10ms drop table if exists temp0000286498;-
DROP TABLE IF EXISTS temp0000286498;
Date: 2026-07-27 09:11:43 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
DROP TABLE IF EXISTS temp0000286498;
Date: 2026-07-27 10:51:45 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
DROP TABLE IF EXISTS temp0000286498;
Date: 2026-07-27 07:12:42 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 1 1s 1s 1s 1s drop table if exists temp0000286610;-
DROP TABLE IF EXISTS temp0000286610;
Date: 2026-07-27 14:31:11 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
DROP TABLE IF EXISTS temp0000286610;
Date: 2026-07-27 14:31:11 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Queries that waited the most
Rank Wait time Query 1 34m48s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-27 15:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 27m13s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');[ Date: 2026-07-27 15:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 25m56s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-27 15:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 24m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027631, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-27 15:11:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 19m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 15:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 16m31s CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-07-27 15:11:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 16m18s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 11:56:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 12m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027650, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-27 15:16:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 9m44s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 12:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 7m10s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0305 )', '/var/www/html/tmp/nf_carga_lotes_0305.xlsx');[ Date: 2026-07-27 12:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 6m34s CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-07-27 15:11:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m58s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0305 )', '/var/www/html/tmp/nf_carga_lotes_0305.xlsx');[ Date: 2026-07-27 12:23:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0175 )', '/var/www/html/tmp/nf_carga_lotes_0175.xlsx');[ Date: 2026-07-27 15:16:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 15:16:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 4m16s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 080 )', '/var/www/html/tmp/nf_carga_lotes_080.xlsx');[ Date: 2026-07-27 15:16:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 3m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0175 )', '/var/www/html/tmp/nf_carga_lotes_0175.xlsx');[ Date: 2026-07-27 15:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 3m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO ATOP.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-07-27 11:16:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 2m3s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-27 09:37:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 1m3s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (271378, 507, '929240032276,5447CCCC5AF5$929240600655,2035431B18EB', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$$$$$','', 00);[ Date: 2026-07-27 15:23:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 26s659ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');[ Date: 2026-07-27 15:11:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,830 Total read queries
- 1,551 Total write queries
Queries by database
Key values
- rio Main database
- 4,921 Requests
- 15h46m30s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,374 1h58m3s copy to 141 13m32s ddl 264 3m35s others 193 7m3s select 776 1h33m52s contagem Total 548 15m7s copy to 71 1m12s ddl 36 28s634ms others 9 2m53s select 432 10m32s rio Total 4,921 15h46m30s copy to 169 34m54s ddl 869 1h14m53s others 259 2h1m32s select 3,622 11h55m7s update 1 1s440ms Queries by user
Key values
- intelifix Main user
- 7,480 Requests
User Request type Count Duration etiquetas Total 120 29s445ms select 120 29s445ms intelifix Total 7,480 22h11m40s copy to 788 1h33m38s ddl 1,168 1h18m55s others 801 2h41m44s select 4,722 16h37m22s lenon Total 136 3m24s ddl 1 1s838ms select 134 3m21s update 1 1s440ms Duration by user
Key values
- 22h11m40s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 120 29s445ms select 120 29s445ms intelifix Total 7,480 22h11m40s copy to 788 1h33m38s ddl 1,168 1h18m55s others 801 2h41m44s select 4,722 16h37m22s lenon Total 136 3m24s ddl 1 1s838ms select 134 3m21s update 1 1s440ms Queries by host
Key values
- [local] Main host
- 7,728 Requests
- 22h15m3s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,698 Requests
- 10h17m25s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-27 11:59:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,059 100-500ms duration
Slowest individual queries
Rank Duration Query 1 43m21s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 12:23:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 38m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 15:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 36m32s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-27 15:11:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 33m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');[ Date: 2026-07-27 15:16:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 31m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027631, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-27 15:16:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 30m39s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 11:56:13 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 30m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0305 )', '/var/www/html/tmp/nf_carga_lotes_0305.xlsx');[ Date: 2026-07-27 12:29:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 26m32s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-27 15:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 25m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 15:16:39 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 21m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 14:21:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 19m37s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027650, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-27 15:23:09 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 17m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 12:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 16m42s CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-07-27 15:11:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 16m31s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-07-27 12:45:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 13m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-27 07:18:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 13m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-27 16:18:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 13m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-27 17:18:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 12m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-27 15:17:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 12m12s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027566, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-27 07:25:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 11m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-27 20:16:24 - 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 7h46m12s 348 150ms 43m21s 1m20s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 27 07 29 26m7s 54s48ms 08 22 12m12s 33s284ms 09 43 28m45s 40s133ms 10 20 6m38s 19s917ms 11 29 57m46s 1m59s 12 8 1h52m35s 14m4s 13 11 1m4s 5s899ms 14 59 25m54s 26s343ms 15 39 2h49m51s 4m21s 16 36 14m57s 24s924ms 17 51 9m54s 11s650ms 18 1 24s504ms 24s504ms [ User: intelifix - Total duration: 7h46m12s - Times executed: 348 ]
[ Application: [unknown] - Total duration: 7h46m12s - Times executed: 348 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 12:23:14 Duration: 43m21s 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( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 15:10:49 Duration: 38m6s 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( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');
Date: 2026-07-27 15:16:35 Duration: 33m Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 2h53m19s 48 1s607ms 13m35s 3m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 27 07 3 14m19s 4m46s 08 3 11m43s 3m54s 09 3 9m5s 3m1s 10 3 10m52s 3m37s 11 3 12m9s 4m3s 12 3 10m39s 3m33s 13 3 7m51s 2m37s 14 3 10m59s 3m39s 15 3 13m42s 4m34s 16 3 14m19s 4m46s 17 3 14m9s 4m43s 18 3 11m12s 3m44s 19 3 6m35s 2m11s 20 3 11m56s 3m58s 21 3 7m46s 2m35s 22 3 5m54s 1m58s [ User: intelifix - Total duration: 2h53m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h53m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-27 07:18:36 Duration: 13m35s 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-07-27 16:18:29 Duration: 13m27s 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-07-27 17:18:25 Duration: 13m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 1h31m53s 47 337ms 5m49s 1m57s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 27 07 3 5m54s 1m58s 08 3 4m34s 1m31s 09 2 5m46s 2m53s 10 3 6m29s 2m9s 11 3 6m28s 2m9s 12 3 5m52s 1m57s 13 3 4m55s 1m38s 14 3 6m11s 2m3s 15 3 7m21s 2m27s 16 3 7m35s 2m31s 17 3 6m25s 2m8s 18 3 5m28s 1m49s 19 3 4m18s 1m26s 20 3 6m7s 2m2s 21 3 4m16s 1m25s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h31m53s - Times executed: 47 ]
[ Application: psql - Total duration: 1h31m53s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-27 16:26:46 Duration: 5m49s 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-07-27 15:25:55 Duration: 5m25s 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-07-27 11:23:26 Duration: 4m54s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 1h15m15s 276 195ms 36m32s 16s361ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 27 00 12 38s176ms 3s181ms 01 12 18s362ms 1s530ms 02 12 18s776ms 1s564ms 03 12 18s457ms 1s538ms 04 12 17s828ms 1s485ms 05 12 17s872ms 1s489ms 06 12 18s268ms 1s522ms 07 12 18s59ms 1s504ms 08 12 22s212ms 1s851ms 09 12 2m37s 13s94ms 10 12 34s6ms 2s833ms 11 12 34s656ms 2s888ms 12 12 26s971ms 2s247ms 13 12 25s827ms 2s152ms 14 6 15s140ms 2s523ms 15 18 1h3m47s 3m32s 16 12 37s617ms 3s134ms 17 12 31s573ms 2s631ms 18 12 24s242ms 2s20ms 19 12 24s424ms 2s35ms 20 12 36s631ms 3s52ms 21 12 27s943ms 2s328ms 22 12 23s755ms 1s979ms [ User: intelifix - Total duration: 1h15m15s - Times executed: 276 ]
[ Application: psql - Total duration: 1h15m15s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-27 15:11:42 Duration: 36m32s 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-07-27 15:11:44 Duration: 26m32s 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-07-27 09:37:29 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 33m56s 122 163ms 16m42s 16s696ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 27 00 1 299ms 299ms 06 3 8s640ms 2s880ms 07 11 1m11s 6s476ms 08 12 1m10s 5s857ms 09 11 1m28s 8s71ms 10 12 1m5s 5s440ms 11 12 1m2s 5s166ms 12 8 55s806ms 6s975ms 13 6 17s222ms 2s870ms 14 8 38s339ms 4s792ms 15 13 24m48s 1m54s 16 9 44s867ms 4s985ms 17 5 4s745ms 949ms 21 5 11s121ms 2s224ms 22 6 9s349ms 1s558ms [ User: intelifix - Total duration: 33m56s - Times executed: 122 ]
[ Application: psql - Total duration: 33m56s - Times executed: 122 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-27 15:11:44 Duration: 16m42s 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-07-27 15:11:55 Duration: 6m54s 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-07-27 09:05:22 Duration: 20s839ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 28m27s 1,271 151ms 1m3s 1s343ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 27 07 1 221ms 221ms 08 141 2m12s 940ms 09 201 3m15s 972ms 10 129 3m8s 1s458ms 11 132 3m17s 1s494ms 12 45 1m8s 1s512ms 13 101 2m4s 1s235ms 14 148 3m12s 1s300ms 15 166 4m57s 1s793ms 16 140 3m32s 1s515ms 17 67 1m38s 1s470ms [ User: intelifix - Total duration: 28m27s - Times executed: 1271 ]
[ Application: [unknown] - Total duration: 28m27s - Times executed: 1271 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (271378, 507, '929240032276,5447CCCC5AF5,2035431B18EB', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$$$$$','', 00);
Date: 2026-07-27 15:23:09 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270205, 503, '518312082131,4C1265359621,BC644BD5A0E1,BC644BD06969,BC644BCC3EE3,5819F8446F04,BC644BCEF322,B0DAF94ACD47,F8F53255C8B8,A89FECBFC9CE,F8F53258CE9B,4C1265EAE53F,BC644BD5FC3F,5819F8444484,BC644BDB5AEF,B0935BECD2D3,B0935BEC8A8F,B0DAF9515D88,B0DAF94A5F74,BC644BC60D34,4C12653C5C8B,A89FECC2DA0B,BC644BDC38E3,A8F5DDED0E34,4C12653E003B,B0935BE96B52,BC644BC42C58,F8F53258CF7C,B0DAF9688BA9,4C1265EACCA3,BC644BE47170,4C1265E74FC9,B0935BEB6D5D,2C584F33D89B,A8F5DDE9652C,2C584F373275,BC644BD56A68,BC644BC89185,5819F8472F00,2C584F2F5488,BC644BE4B455', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-27 16:06:22 Duration: 8s468ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48039, 418, '226122281018', '',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-07-27 15:40:04 Duration: 8s41ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 16m15s 69 1s160ms 1m36s 14s132ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 27 07 5 28s12ms 5s602ms 08 2 56s629ms 28s314ms 09 5 1m29s 17s833ms 10 5 1m38s 19s637ms 11 2 1m45s 52s596ms 12 2 13s826ms 6s913ms 13 5 1m42s 20s551ms 14 8 2m8s 16s78ms 15 9 2m27s 16s378ms 16 5 1m14s 14s853ms 17 21 2m11s 6s241ms [ User: intelifix - Total duration: 16m15s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 16m15s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-27', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 11:31:44 Duration: 1m36s 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-07-27', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 14:53:01 Duration: 1m22s 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-07-27', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 15:50:32 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 15m38s 3 2m26s 9m14s 5m12s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 27 05 3 15m38s 5m12s [ User: intelifix - Total duration: 15m38s - Times executed: 3 ]
[ Application: psql - Total duration: 15m38s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-27 05:09:16 Duration: 9m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-07-27 05:13:14 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-07-27 05:15:40 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 15m24s 77 9s75ms 49s633ms 12s11ms create table temp0000286498 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 07 17 3m31s 12s420ms 08 14 2m36s 11s206ms 09 16 3m15s 12s231ms 10 12 2m23s 11s937ms 11 12 2m30s 12s559ms 12 6 1m7s 11s190ms [ User: intelifix - Total duration: 15m24s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 15m24s - Times executed: 77 ]
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 07:09:54 Duration: 49s633ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 11:09:50 Duration: 14s597ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 09:28:56 Duration: 14s578ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 13m23s 1,087 150ms 8s202ms 739ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 27 06 2 2s613ms 1s306ms 07 21 14s518ms 691ms 08 112 1m31s 817ms 09 144 1m48s 754ms 10 135 1m52s 833ms 11 159 1m57s 740ms 12 9 7s689ms 854ms 13 113 1m18s 698ms 14 107 1m6s 622ms 15 110 1m11s 650ms 16 146 1m50s 757ms 17 29 21s136ms 728ms [ User: intelifix - Total duration: 13m23s - Times executed: 1087 ]
[ Application: [unknown] - Total duration: 13m23s - Times executed: 1087 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249092", "modelo" : "295", "itens" : "229988630619,230035434748,230030555776,230014584756,229989038491,229965026384,229971517275,230029877292,229979446478,229982148492,229973174654,229990129697,230031554044,229987735166,229986395877,229982829906,229982601119,230035757686,230030556079,230027895662", "usuario" : "414", "caixa" : "3017498", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 10:58:01 Duration: 8s202ms 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" : "108194", "modelo" : "454", "itens" : "241627124157,241627176384,241613385072,241624612745,241625399903,241624969704,241625351919,241611010621,241625407176,241625461728,241625322747,241614413848,241614380512,241625442130,241612220324,241624607794,241612465072,241613385274,241626288283,241625057389,241613762842,241624869111,241613366888,241627177495,241627171637,241624700812,241613417072,241632888502,241632966668,241627235357,241627128602,241611552424,241634094848,241613362141,241613868485,241613834364,241613783854,241613744456,241612208504,241625360405,241614283151", "usuario" : "414", "caixa" : "1299019", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 08:21:15 Duration: 6s20ms 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" : "271359", "modelo" : "320", "itens" : "241649526668,241676645252,241629940628,241709379805,241680744766,241699055666,241656941321,241658300814,241650496673,241649572734,241717093151,241674121617,241631040926,241706533052,241619345777,241660338284,241667960107,241706952543,241709352126,241637303355,241660601521,241712616978,241604555871,241691367575,241652129605,241652114351,241715191327,241665268799,241727569605,241650480107,241691522945,241665014353,241709009915,241599466676,241728823959,241627989101,241616612020,241619330827,241691699101,241712678904,241660388188,241650415577,241648203341,241680686477,241602859296,241629941537,241603458098,241660338688", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 14:44:42 Duration: 2s969ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 13m20s 66 9s857ms 14s756ms 12s135ms create table temp0000286596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 27 13 4 49s255ms 12s313ms 14 50 10m3s 12s72ms 15 12 2m28s 12s338ms [ User: intelifix - Total duration: 13m20s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m20s - Times executed: 66 ]
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:00:20 Duration: 14s756ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:38:52 Duration: 14s245ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:22:46 Duration: 14s53ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 6m41s 54 276ms 44s635ms 7s427ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 27 07 3 56s525ms 18s841ms 08 3 12s661ms 4s220ms 09 4 38s398ms 9s599ms 10 6 52s371ms 8s728ms 11 7 1m12s 10s292ms 12 1 2s26ms 2s26ms 13 2 26s691ms 13s345ms 14 21 53s272ms 2s536ms 15 3 48s385ms 16s128ms 16 1 10s297ms 10s297ms 17 3 28s425ms 9s475ms [ User: intelifix - Total duration: 6m41s - Times executed: 54 ]
[ Application: psql - Total duration: 6m41s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027566);
Date: 2026-07-27 07:13:15 Duration: 44s635ms 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 (027631);
Date: 2026-07-27 14:44:28 Duration: 36s133ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027673);
Date: 2026-07-27 17:40:13 Duration: 27s483ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 5m50s 107 198ms 1m59s 3s277ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 27 07 6 4s245ms 707ms 08 5 3s524ms 704ms 09 6 4s422ms 737ms 10 7 51s458ms 7s351ms 11 11 2m3s 11s263ms 12 3 1s498ms 499ms 13 3 3s423ms 1s141ms 14 40 1m27s 2s184ms 15 17 8s698ms 511ms 16 5 24s593ms 4s918ms 17 4 37s517ms 9s379ms [ User: intelifix - Total duration: 5m50s - Times executed: 107 ]
[ Application: psql - Total duration: 5m50s - Times executed: 107 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027591);
Date: 2026-07-27 11:22:49 Duration: 1m59s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027624);
Date: 2026-07-27 14:31:51 Duration: 1m14s 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 (027584);
Date: 2026-07-27 10:18:18 Duration: 26s861ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 5m21s 25 10s827ms 14s728ms 12s871ms create table temp0000286606 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 27 13 4 52s841ms 13s210ms 15 3 40s838ms 13s612ms 16 9 1m59s 13s293ms 17 9 1m48s 12s53ms [ User: intelifix - Total duration: 5m21s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 25 ]
-
CREATE TABLE temp0000286606 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 13:46:49 Duration: 14s728ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286606 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:35:52 Duration: 14s415ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286606 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 13:57:25 Duration: 14s244ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 4m36s 21 10s321ms 15s364ms 13s152ms create table temp0000286632 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 27 15 18 3m59s 13s304ms 16 3 36s725ms 12s241ms [ User: intelifix - Total duration: 4m36s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m36s - Times executed: 21 ]
-
CREATE TABLE temp0000286632 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:55:54 Duration: 15s364ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286632 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:55:12 Duration: 15s310ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286632 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:55:36 Duration: 14s322ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 3m30s 44 3s634ms 6s275ms 4s795ms create table temp0000286596 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 27 13 3 13s214ms 4s404ms 14 35 2m47s 4s787ms 15 6 30s211ms 5s35ms [ User: intelifix - Total duration: 3m30s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 3m30s - Times executed: 44 ]
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 15:04:54 Duration: 6s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 15:15:06 Duration: 5s952ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 14:44:39 Duration: 5s626ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 3m25s 4 5s127ms 1m39s 51s467ms 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 Jul 27 20 2 1m44s 52s140ms 23 2 1m41s 50s795ms [ User: intelifix - Total duration: 3m25s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m25s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-27 20:09:16 Duration: 1m39s 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-07-27 23:17:09 Duration: 1m36s 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-07-27 23:38:37 Duration: 5s361ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 3m17s 46 3s289ms 14s807ms 4s301ms create table temp0000286498 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 27 08 18 1m7s 3s739ms 09 11 56s566ms 5s142ms 10 12 50s36ms 4s169ms 11 5 23s971ms 4s794ms [ User: intelifix - Total duration: 3m17s - Times executed: 46 ]
[ Application: [unknown] - Total duration: 3m17s - Times executed: 46 ]
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 09:39:37 Duration: 14s807ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 11:02:40 Duration: 6s165ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 10:44:36 Duration: 5s702ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 3m14s 149 184ms 5s922ms 1s305ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 27 07 23 24s15ms 1s44ms 08 6 6s129ms 1s21ms 09 18 8s225ms 456ms 10 6 6s16ms 1s2ms 11 11 38s858ms 3s532ms 12 1 2s765ms 2s765ms 14 39 58s232ms 1s493ms 15 10 15s742ms 1s574ms 16 7 8s540ms 1s220ms 17 28 26s65ms 930ms [ User: intelifix - Total duration: 3m14s - Times executed: 149 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 149 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0270648) LIMIT 1;
Date: 2026-07-27 11:44:39 Duration: 5s922ms Database: rio 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 (0271110) LIMIT 1;
Date: 2026-07-27 14:28:05 Duration: 5s593ms Database: rio 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 (0270648) LIMIT 1;
Date: 2026-07-27 14:47:47 Duration: 5s150ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 3m9s 15 11s204ms 13s949ms 12s643ms create table temp0000286612 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 27 14 15 3m9s 12s643ms [ User: intelifix - Total duration: 3m9s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m9s - Times executed: 15 ]
-
CREATE TABLE temp0000286612 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:43:03 Duration: 13s949ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286612 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:24:48 Duration: 13s827ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286612 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:25:22 Duration: 13s530ms Database: rio User: intelifix Remote: [local] Application: [unknown] 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,271 28m27s 151ms 1m3s 1s343ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 27 07 1 221ms 221ms 08 141 2m12s 940ms 09 201 3m15s 972ms 10 129 3m8s 1s458ms 11 132 3m17s 1s494ms 12 45 1m8s 1s512ms 13 101 2m4s 1s235ms 14 148 3m12s 1s300ms 15 166 4m57s 1s793ms 16 140 3m32s 1s515ms 17 67 1m38s 1s470ms [ User: intelifix - Total duration: 28m27s - Times executed: 1271 ]
[ Application: [unknown] - Total duration: 28m27s - Times executed: 1271 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (271378, 507, '929240032276,5447CCCC5AF5,2035431B18EB', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$$$$$','', 00);
Date: 2026-07-27 15:23:09 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270205, 503, '518312082131,4C1265359621,BC644BD5A0E1,BC644BD06969,BC644BCC3EE3,5819F8446F04,BC644BCEF322,B0DAF94ACD47,F8F53255C8B8,A89FECBFC9CE,F8F53258CE9B,4C1265EAE53F,BC644BD5FC3F,5819F8444484,BC644BDB5AEF,B0935BECD2D3,B0935BEC8A8F,B0DAF9515D88,B0DAF94A5F74,BC644BC60D34,4C12653C5C8B,A89FECC2DA0B,BC644BDC38E3,A8F5DDED0E34,4C12653E003B,B0935BE96B52,BC644BC42C58,F8F53258CF7C,B0DAF9688BA9,4C1265EACCA3,BC644BE47170,4C1265E74FC9,B0935BEB6D5D,2C584F33D89B,A8F5DDE9652C,2C584F373275,BC644BD56A68,BC644BC89185,5819F8472F00,2C584F2F5488,BC644BE4B455', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-27 16:06:22 Duration: 8s468ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48039, 418, '226122281018', '',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-07-27 15:40:04 Duration: 8s41ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 1,087 13m23s 150ms 8s202ms 739ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 27 06 2 2s613ms 1s306ms 07 21 14s518ms 691ms 08 112 1m31s 817ms 09 144 1m48s 754ms 10 135 1m52s 833ms 11 159 1m57s 740ms 12 9 7s689ms 854ms 13 113 1m18s 698ms 14 107 1m6s 622ms 15 110 1m11s 650ms 16 146 1m50s 757ms 17 29 21s136ms 728ms [ User: intelifix - Total duration: 13m23s - Times executed: 1087 ]
[ Application: [unknown] - Total duration: 13m23s - Times executed: 1087 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249092", "modelo" : "295", "itens" : "229988630619,230035434748,230030555776,230014584756,229989038491,229965026384,229971517275,230029877292,229979446478,229982148492,229973174654,229990129697,230031554044,229987735166,229986395877,229982829906,229982601119,230035757686,230030556079,230027895662", "usuario" : "414", "caixa" : "3017498", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 10:58:01 Duration: 8s202ms 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" : "108194", "modelo" : "454", "itens" : "241627124157,241627176384,241613385072,241624612745,241625399903,241624969704,241625351919,241611010621,241625407176,241625461728,241625322747,241614413848,241614380512,241625442130,241612220324,241624607794,241612465072,241613385274,241626288283,241625057389,241613762842,241624869111,241613366888,241627177495,241627171637,241624700812,241613417072,241632888502,241632966668,241627235357,241627128602,241611552424,241634094848,241613362141,241613868485,241613834364,241613783854,241613744456,241612208504,241625360405,241614283151", "usuario" : "414", "caixa" : "1299019", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 08:21:15 Duration: 6s20ms 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" : "271359", "modelo" : "320", "itens" : "241649526668,241676645252,241629940628,241709379805,241680744766,241699055666,241656941321,241658300814,241650496673,241649572734,241717093151,241674121617,241631040926,241706533052,241619345777,241660338284,241667960107,241706952543,241709352126,241637303355,241660601521,241712616978,241604555871,241691367575,241652129605,241652114351,241715191327,241665268799,241727569605,241650480107,241691522945,241665014353,241709009915,241599466676,241728823959,241627989101,241616612020,241619330827,241691699101,241712678904,241660388188,241650415577,241648203341,241680686477,241602859296,241629941537,241603458098,241660338688", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 14:44:42 Duration: 2s969ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 348 7h46m12s 150ms 43m21s 1m20s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 27 07 29 26m7s 54s48ms 08 22 12m12s 33s284ms 09 43 28m45s 40s133ms 10 20 6m38s 19s917ms 11 29 57m46s 1m59s 12 8 1h52m35s 14m4s 13 11 1m4s 5s899ms 14 59 25m54s 26s343ms 15 39 2h49m51s 4m21s 16 36 14m57s 24s924ms 17 51 9m54s 11s650ms 18 1 24s504ms 24s504ms [ User: intelifix - Total duration: 7h46m12s - Times executed: 348 ]
[ Application: [unknown] - Total duration: 7h46m12s - Times executed: 348 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 12:23:14 Duration: 43m21s 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( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 15:10:49 Duration: 38m6s 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( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');
Date: 2026-07-27 15:16:35 Duration: 33m Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 276 1h15m15s 195ms 36m32s 16s361ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 27 00 12 38s176ms 3s181ms 01 12 18s362ms 1s530ms 02 12 18s776ms 1s564ms 03 12 18s457ms 1s538ms 04 12 17s828ms 1s485ms 05 12 17s872ms 1s489ms 06 12 18s268ms 1s522ms 07 12 18s59ms 1s504ms 08 12 22s212ms 1s851ms 09 12 2m37s 13s94ms 10 12 34s6ms 2s833ms 11 12 34s656ms 2s888ms 12 12 26s971ms 2s247ms 13 12 25s827ms 2s152ms 14 6 15s140ms 2s523ms 15 18 1h3m47s 3m32s 16 12 37s617ms 3s134ms 17 12 31s573ms 2s631ms 18 12 24s242ms 2s20ms 19 12 24s424ms 2s35ms 20 12 36s631ms 3s52ms 21 12 27s943ms 2s328ms 22 12 23s755ms 1s979ms [ User: intelifix - Total duration: 1h15m15s - Times executed: 276 ]
[ Application: psql - Total duration: 1h15m15s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-27 15:11:42 Duration: 36m32s 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-07-27 15:11:44 Duration: 26m32s 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-07-27 09:37:29 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 199 1m3s 150ms 1s45ms 317ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 27 07 18 4s535ms 251ms 08 17 4s295ms 252ms 09 24 6s86ms 253ms 10 14 5s249ms 374ms 11 18 5s622ms 312ms 12 26 8s55ms 309ms 13 4 1s119ms 279ms 14 23 8s43ms 349ms 15 40 14s433ms 360ms 16 15 5s747ms 383ms [ User: intelifix - Total duration: 1m3s - Times executed: 199 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 199 ]
-
SELECT * FROM RS_TRIAGEM (310, 5, '95', 2, '3C82C0926D40,B85E71D0D770,00CB7AE2E340,3C82C0C9D028,E4BFFAF34ED4,B85E71D1FA9C,08A7C071EB74,B85E71D0BBA0,484BD4B12984,C4509CAF059C,08A7C07AE0C4,3C82C09214D0,B85E71D2E178,B85E71D244C0,B85E71D3BAF8,F8D2AC14F16C,F8D2AC155954,484BD4999884,C4509CAF188C,B85E71D33D30,CCF3C8485A44,3C82C0671D58,D4E2CB1E663C,00CB7ADF37CC,4075C39B6288,400FC1826D0C,484BD4A70A74,B85E71EE320C,484BD498E6C4,C4509CAEF264,4075C39A8188,3C82C069F2E4,B85E71C1186C,C4509CB02E54,B85E71D04AE4,B85E71EE09E4,4075C3B39254,08A7C074D7C4,400FC184BEDC,ECA81F1D95DC,80DAC2D05150,ECA81FF5A0FC,D4E2CB8FAFBC,B85E71D2CCD8,C4509CBE22DC,C4509CF47894,C4509CAC8294,D4E2CB931AB4,484BD4A3DDA4,4075C3B3DA84,B85E71D9C7F4,3C82C06A200C,4075C39AA5C8,1C9D7282EB1C,B85E71DA8ACC,B85E71D2C92C,ECA81F1E77FC,4075C39B8600,B85E71CC5A38,484BD4A4024C,08A7C07923D4', NULL, NULL, 0185, 00);
Date: 2026-07-27 16:02:45 Duration: 1s45ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_TRIAGEM (407, 5, '113', 3, '241626191732,241613574866,241632442645,241626774246,241624640930,241612175672,241612384357,241624746876,241625429097,241634097878,241627611938,241626667793,241641847288,241625358888,241612461133,241613594767,241627118601,241625113355,241625076482,241613627070', NULL, NULL, 0454, 00);
Date: 2026-07-27 14:25:14 Duration: 853ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_TRIAGEM (310, 5, '63', 2, 'B85E71BB4590,B85E71C6D608,ECA81F237B0C,CCF3C8478424,3C82C06B6944,B85E71CD4A60,484BD4A6514C,D4E2CB92000C,08A7C06A0F34,B85E71E6E2B8,484BD49BD4DC,E4BFFAF66A7C,B85E71CFCE84,C4509CF1B074,B85E71EE0570,08A7C07146A4,400FC17F6604,ECA81F23BF64,08A7C05151FC,4075C3C18968,3C82C0CFA890,C4509CE89184,400FC1827834,4075C3BC7CFC,E4BFFAF5E97C,08A7C04E8844,ECA81F197F0C,ECA81F6B9C9C,484BD4B109A4,CCF3C847318C,3C82C06998D0', NULL, NULL, 0185, 00);
Date: 2026-07-27 16:43:31 Duration: 788ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 149 3m14s 184ms 5s922ms 1s305ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 27 07 23 24s15ms 1s44ms 08 6 6s129ms 1s21ms 09 18 8s225ms 456ms 10 6 6s16ms 1s2ms 11 11 38s858ms 3s532ms 12 1 2s765ms 2s765ms 14 39 58s232ms 1s493ms 15 10 15s742ms 1s574ms 16 7 8s540ms 1s220ms 17 28 26s65ms 930ms [ User: intelifix - Total duration: 3m14s - Times executed: 149 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 149 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0270648) LIMIT 1;
Date: 2026-07-27 11:44:39 Duration: 5s922ms Database: rio 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 (0271110) LIMIT 1;
Date: 2026-07-27 14:28:05 Duration: 5s593ms Database: rio 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 (0270648) LIMIT 1;
Date: 2026-07-27 14:47:47 Duration: 5s150ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 139 26s616ms 150ms 590ms 191ms select * from rs_equipamento_consulta (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 27 06 1 499ms 499ms 07 12 2s231ms 185ms 08 17 2s997ms 176ms 09 11 2s88ms 189ms 10 7 1s309ms 187ms 11 10 1s797ms 179ms 13 6 1s171ms 195ms 14 7 1s240ms 177ms 15 53 10s69ms 189ms 16 2 321ms 160ms 17 8 1s529ms 191ms 20 1 590ms 590ms 21 4 769ms 192ms [ User: intelifix - Total duration: 26s616ms - Times executed: 139 ]
[ Application: [unknown] - Total duration: 26s616ms - Times executed: 139 ]
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('241757925160');
Date: 2026-07-27 20:56:16 Duration: 590ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('5CFA259C19C2');
Date: 2026-07-27 06:58:21 Duration: 499ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_EQUIPAMENTO_CONSULTA ('226324262739');
Date: 2026-07-27 15:40:56 Duration: 350ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 136 35s722ms 150ms 1s98ms 262ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 27 07 2 453ms 226ms 08 1 291ms 291ms 09 3 741ms 247ms 10 8 1s838ms 229ms 11 11 3s 272ms 12 5 1s816ms 363ms 13 7 2s175ms 310ms 14 14 5s96ms 364ms 15 18 6s610ms 367ms 16 50 10s175ms 203ms 17 17 3s522ms 207ms [ User: intelifix - Total duration: 35s722ms - Times executed: 136 ]
[ Application: [unknown] - Total duration: 35s722ms - Times executed: 136 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "434", "data-de" : "2026-07-27", "data-ate" : "2026-07-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-07-27 15:33:12 Duration: 1s98ms 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-07-27", "data-ate" : "2026-07-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 508 }');
Date: 2026-07-27 14:51:41 Duration: 1s56ms 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" : "396", "data-de" : "2026-07-27", "data-ate" : "2026-07-27", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 450 }');
Date: 2026-07-27 14:33:21 Duration: 1s43ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 122 33m56s 163ms 16m42s 16s696ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 00 1 299ms 299ms 06 3 8s640ms 2s880ms 07 11 1m11s 6s476ms 08 12 1m10s 5s857ms 09 11 1m28s 8s71ms 10 12 1m5s 5s440ms 11 12 1m2s 5s166ms 12 8 55s806ms 6s975ms 13 6 17s222ms 2s870ms 14 8 38s339ms 4s792ms 15 13 24m48s 1m54s 16 9 44s867ms 4s985ms 17 5 4s745ms 949ms 21 5 11s121ms 2s224ms 22 6 9s349ms 1s558ms [ User: intelifix - Total duration: 33m56s - Times executed: 122 ]
[ Application: psql - Total duration: 33m56s - Times executed: 122 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-27 15:11:44 Duration: 16m42s 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-07-27 15:11:55 Duration: 6m54s 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-07-27 09:05:22 Duration: 20s839ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 121 19s897ms 150ms 237ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 27 08 2 311ms 155ms 09 12 1s999ms 166ms 10 10 1s607ms 160ms 11 25 4s81ms 163ms 12 2 337ms 168ms 13 14 2s326ms 166ms 14 9 1s487ms 165ms 15 17 2s845ms 167ms 16 23 3s708ms 161ms 17 7 1s192ms 170ms [ User: intelifix - Total duration: 19s897ms - Times executed: 121 ]
[ Application: [unknown] - Total duration: 19s897ms - Times executed: 121 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-27 15:15:02 Duration: 237ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-07-27 13:47:19 Duration: 237ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0318;
Date: 2026-07-27 17:14:10 Duration: 201ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 113 51s693ms 268ms 789ms 457ms 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 #11
Day Hour Count Duration Avg duration Jul 27 06 2 792ms 396ms 07 7 2s660ms 380ms 08 13 5s755ms 442ms 09 7 3s305ms 472ms 10 10 5s284ms 528ms 11 13 5s802ms 446ms 12 4 1s458ms 364ms 13 10 4s551ms 455ms 14 17 7s962ms 468ms 15 11 5s173ms 470ms 16 6 2s846ms 474ms 17 9 4s221ms 469ms 20 1 547ms 547ms 21 1 357ms 357ms 22 2 972ms 486ms [ User: lenon - Total duration: 51s693ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 51s693ms - Times executed: 113 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-27 14:35:39 Duration: 789ms Database: contagem 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-07-27 10:17:29 Duration: 742ms 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-07-27 10:00:10 Duration: 737ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 107 5m50s 198ms 1m59s 3s277ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 27 07 6 4s245ms 707ms 08 5 3s524ms 704ms 09 6 4s422ms 737ms 10 7 51s458ms 7s351ms 11 11 2m3s 11s263ms 12 3 1s498ms 499ms 13 3 3s423ms 1s141ms 14 40 1m27s 2s184ms 15 17 8s698ms 511ms 16 5 24s593ms 4s918ms 17 4 37s517ms 9s379ms [ User: intelifix - Total duration: 5m50s - Times executed: 107 ]
[ Application: psql - Total duration: 5m50s - Times executed: 107 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027591);
Date: 2026-07-27 11:22:49 Duration: 1m59s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027624);
Date: 2026-07-27 14:31:51 Duration: 1m14s 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 (027584);
Date: 2026-07-27 10:18:18 Duration: 26s861ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 104 1m 331ms 1s2ms 584ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 27 07 7 3s509ms 501ms 08 11 6s130ms 557ms 09 7 4s219ms 602ms 10 10 6s403ms 640ms 11 13 7s285ms 560ms 12 4 2s35ms 508ms 13 10 5s908ms 590ms 14 15 8s700ms 580ms 15 10 6s114ms 611ms 16 5 2s952ms 590ms 17 9 5s320ms 591ms 20 1 1s2ms 1s2ms 22 2 1s210ms 605ms [ User: intelifix - Total duration: 1m - Times executed: 104 ]
[ Application: [unknown] - Total duration: 1m - Times executed: 104 ]
-
select * from rs_menu_grants (477, 81, 1);
Date: 2026-07-27 20:56:06 Duration: 1s2ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
select * from rs_menu_grants (417, 18, 1);
Date: 2026-07-27 17:04:24 Duration: 994ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-07-27 09:40:17 Duration: 892ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 95 53s358ms 150ms 1s609ms 561ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 27 11 72 31s8ms 430ms 14 23 22s349ms 971ms [ User: intelifix - Total duration: 53s358ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 53s358ms - Times executed: 95 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48104","seriais":"B0FC88EA1783,186A81D40481,44D45460142E,841EA38CA898,CC5830E32A28,186A81D50822,44D4546ACCF3,582FF70A8030,5CFA25173B66,64FD96555466,209A7DB38061,E8D2FF9709AB,D833B71F74E7,5CFA257FF05C,8CC5B4E32A64,186A81D3E674,C03C0480BE45","usuario":"416","observacao":""}');
Date: 2026-07-27 14:35:19 Duration: 1s609ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48104","seriais":"B4F2674E830A,6802B8F0091A,6802B8DB73B5,B4F2674E42EA,6802B8DFBC20,B4F2674D9880,6802B814C9A7,6802B8CB5C32,B4F2670C0AFB,6802B823B014,6802B8521D1A,B4F2674E6759,6802B8CF10CB,6802B8DB62FF,6802B8CB1984,B4F26758CA56","usuario":"416","observacao":""}');
Date: 2026-07-27 14:38:52 Duration: 1s550ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48104","seriais":"5C7D7D73ACD4,A0FF702DF454,5C7D7D629CD4,5C7D7D706BDC,A0FF7025FE04,A0FF70809CC4,F4C114768C5C,5C7D7D6BD004,A0FF7082293C,889E68DD288C,5C7D7D710F44,5C7D7D7099CC,484BD4A07D5C,A0FF70883EFC,5C7D7D6BDE5C,A0FF70829E0C,484BD483681C,F4C114735A64,F4C1147199E4","usuario":"416","observacao":""}');
Date: 2026-07-27 14:35:29 Duration: 1s404ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 95 39s226ms 217ms 681ms 412ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 27 07 4 1s653ms 413ms 08 8 3s470ms 433ms 09 9 3s434ms 381ms 10 9 3s972ms 441ms 11 11 4s597ms 417ms 12 3 917ms 305ms 13 5 2s148ms 429ms 14 14 5s446ms 389ms 15 7 2s880ms 411ms 16 15 6s439ms 429ms 17 10 4s265ms 426ms [ User: intelifix - Total duration: 39s226ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 39s226ms - Times executed: 95 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 054;
Date: 2026-07-27 17:09:20 Duration: 681ms 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-07-27 16:36:18 Duration: 675ms 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 = 029;
Date: 2026-07-27 10:33:56 Duration: 622ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 93 24s317ms 152ms 3s153ms 261ms create table temp0000286530 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 27 08 27 7s573ms 280ms 09 19 3s412ms 179ms 10 2 480ms 240ms 11 9 2s146ms 238ms 13 5 1s223ms 244ms 14 7 1s803ms 257ms 15 8 2s265ms 283ms 16 13 4s283ms 329ms 17 3 1s129ms 376ms [ User: intelifix - Total duration: 24s317ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 24s317ms - Times executed: 93 ]
-
CREATE TABLE temp0000286530 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 08:14:13 Duration: 3s153ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286530 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"69980", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 16:40:11 Duration: 511ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286530 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"69980", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 17:02:39 Duration: 426ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 92 19s779ms 150ms 700ms 214ms select * from rs_etiqueta (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 27 00 1 396ms 396ms 07 3 530ms 176ms 08 5 837ms 167ms 09 8 1s395ms 174ms 10 11 2s100ms 190ms 11 10 2s193ms 219ms 12 5 957ms 191ms 13 2 542ms 271ms 14 13 2s541ms 195ms 15 14 2s651ms 189ms 16 11 2s336ms 212ms 17 6 1s392ms 232ms 20 1 674ms 674ms 23 2 1s229ms 614ms [ User: etiquetas - Total duration: 19s779ms - Times executed: 92 ]
[ Application: [unknown] - Total duration: 19s779ms - Times executed: 92 ]
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-27 23:31:53 Duration: 700ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-27 20:45:15 Duration: 674ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_ETIQUETA ('');
Date: 2026-07-27 23:48:02 Duration: 529ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 77 15m24s 9s75ms 49s633ms 12s11ms create table temp0000286498 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 27 07 17 3m31s 12s420ms 08 14 2m36s 11s206ms 09 16 3m15s 12s231ms 10 12 2m23s 11s937ms 11 12 2m30s 12s559ms 12 6 1m7s 11s190ms [ User: intelifix - Total duration: 15m24s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 15m24s - Times executed: 77 ]
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 07:09:54 Duration: 49s633ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 11:09:50 Duration: 14s597ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 09:28:56 Duration: 14s578ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 69 16m15s 1s160ms 1m36s 14s132ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 27 07 5 28s12ms 5s602ms 08 2 56s629ms 28s314ms 09 5 1m29s 17s833ms 10 5 1m38s 19s637ms 11 2 1m45s 52s596ms 12 2 13s826ms 6s913ms 13 5 1m42s 20s551ms 14 8 2m8s 16s78ms 15 9 2m27s 16s378ms 16 5 1m14s 14s853ms 17 21 2m11s 6s241ms [ User: intelifix - Total duration: 16m15s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 16m15s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-27', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 11:31:44 Duration: 1m36s 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-07-27', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 14:53:01 Duration: 1m22s 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-07-27', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 15:50:32 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 66 13m20s 9s857ms 14s756ms 12s135ms create table temp0000286596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 27 13 4 49s255ms 12s313ms 14 50 10m3s 12s72ms 15 12 2m28s 12s338ms [ User: intelifix - Total duration: 13m20s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m20s - Times executed: 66 ]
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:00:20 Duration: 14s756ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:38:52 Duration: 14s245ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:22:46 Duration: 14s53ms Database: rio User: intelifix Remote: [local] Application: [unknown] 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 2m26s 9m14s 5m12s 3 15m38s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 27 05 3 15m38s 5m12s [ User: intelifix - Total duration: 15m38s - Times executed: 3 ]
[ Application: psql - Total duration: 15m38s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-27 05:09:16 Duration: 9m14s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-07-27 05:13:14 Duration: 3m57s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
analyze verbose;
Date: 2026-07-27 05:15:40 Duration: 2m26s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 1s607ms 13m35s 3m36s 48 2h53m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 27 07 3 14m19s 4m46s 08 3 11m43s 3m54s 09 3 9m5s 3m1s 10 3 10m52s 3m37s 11 3 12m9s 4m3s 12 3 10m39s 3m33s 13 3 7m51s 2m37s 14 3 10m59s 3m39s 15 3 13m42s 4m34s 16 3 14m19s 4m46s 17 3 14m9s 4m43s 18 3 11m12s 3m44s 19 3 6m35s 2m11s 20 3 11m56s 3m58s 21 3 7m46s 2m35s 22 3 5m54s 1m58s [ User: intelifix - Total duration: 2h53m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h53m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-27 07:18:36 Duration: 13m35s 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-07-27 16:18:29 Duration: 13m27s 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-07-27 17:18:25 Duration: 13m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 337ms 5m49s 1m57s 47 1h31m53s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 27 07 3 5m54s 1m58s 08 3 4m34s 1m31s 09 2 5m46s 2m53s 10 3 6m29s 2m9s 11 3 6m28s 2m9s 12 3 5m52s 1m57s 13 3 4m55s 1m38s 14 3 6m11s 2m3s 15 3 7m21s 2m27s 16 3 7m35s 2m31s 17 3 6m25s 2m8s 18 3 5m28s 1m49s 19 3 4m18s 1m26s 20 3 6m7s 2m2s 21 3 4m16s 1m25s 22 3 4m5s 1m21s [ User: intelifix - Total duration: 1h31m53s - Times executed: 47 ]
[ Application: psql - Total duration: 1h31m53s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-27 16:26:46 Duration: 5m49s 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-07-27 15:25:55 Duration: 5m25s 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-07-27 11:23:26 Duration: 4m54s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 150ms 43m21s 1m20s 348 7h46m12s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 27 07 29 26m7s 54s48ms 08 22 12m12s 33s284ms 09 43 28m45s 40s133ms 10 20 6m38s 19s917ms 11 29 57m46s 1m59s 12 8 1h52m35s 14m4s 13 11 1m4s 5s899ms 14 59 25m54s 26s343ms 15 39 2h49m51s 4m21s 16 36 14m57s 24s924ms 17 51 9m54s 11s650ms 18 1 24s504ms 24s504ms [ User: intelifix - Total duration: 7h46m12s - Times executed: 348 ]
[ Application: [unknown] - Total duration: 7h46m12s - Times executed: 348 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 12:23:14 Duration: 43m21s 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( 027624, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-07-27 15:10:49 Duration: 38m6s 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( 027624, 0302 )', '/var/www/html/tmp/nf_carga_lotes_0302.xlsx');
Date: 2026-07-27 15:16:35 Duration: 33m Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 5s127ms 1m39s 51s467ms 4 3m25s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 27 20 2 1m44s 52s140ms 23 2 1m41s 50s795ms [ User: intelifix - Total duration: 3m25s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m25s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-27 20:09:16 Duration: 1m39s 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-07-27 23:17:09 Duration: 1m36s 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-07-27 23:38:37 Duration: 5s361ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 163ms 16m42s 16s696ms 122 33m56s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 27 00 1 299ms 299ms 06 3 8s640ms 2s880ms 07 11 1m11s 6s476ms 08 12 1m10s 5s857ms 09 11 1m28s 8s71ms 10 12 1m5s 5s440ms 11 12 1m2s 5s166ms 12 8 55s806ms 6s975ms 13 6 17s222ms 2s870ms 14 8 38s339ms 4s792ms 15 13 24m48s 1m54s 16 9 44s867ms 4s985ms 17 5 4s745ms 949ms 21 5 11s121ms 2s224ms 22 6 9s349ms 1s558ms [ User: intelifix - Total duration: 33m56s - Times executed: 122 ]
[ Application: psql - Total duration: 33m56s - Times executed: 122 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-27 15:11:44 Duration: 16m42s 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-07-27 15:11:55 Duration: 6m54s 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-07-27 09:05:22 Duration: 20s839ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 195ms 36m32s 16s361ms 276 1h15m15s call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 27 00 12 38s176ms 3s181ms 01 12 18s362ms 1s530ms 02 12 18s776ms 1s564ms 03 12 18s457ms 1s538ms 04 12 17s828ms 1s485ms 05 12 17s872ms 1s489ms 06 12 18s268ms 1s522ms 07 12 18s59ms 1s504ms 08 12 22s212ms 1s851ms 09 12 2m37s 13s94ms 10 12 34s6ms 2s833ms 11 12 34s656ms 2s888ms 12 12 26s971ms 2s247ms 13 12 25s827ms 2s152ms 14 6 15s140ms 2s523ms 15 18 1h3m47s 3m32s 16 12 37s617ms 3s134ms 17 12 31s573ms 2s631ms 18 12 24s242ms 2s20ms 19 12 24s424ms 2s35ms 20 12 36s631ms 3s52ms 21 12 27s943ms 2s328ms 22 12 23s755ms 1s979ms [ User: intelifix - Total duration: 1h15m15s - Times executed: 276 ]
[ Application: psql - Total duration: 1h15m15s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-27 15:11:42 Duration: 36m32s 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-07-27 15:11:44 Duration: 26m32s 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-07-27 09:37:29 Duration: 2m8s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 1s160ms 1m36s 14s132ms 69 16m15s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 27 07 5 28s12ms 5s602ms 08 2 56s629ms 28s314ms 09 5 1m29s 17s833ms 10 5 1m38s 19s637ms 11 2 1m45s 52s596ms 12 2 13s826ms 6s913ms 13 5 1m42s 20s551ms 14 8 2m8s 16s78ms 15 9 2m27s 16s378ms 16 5 1m14s 14s853ms 17 21 2m11s 6s241ms [ User: intelifix - Total duration: 16m15s - Times executed: 69 ]
[ Application: [unknown] - Total duration: 16m15s - Times executed: 69 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-27', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 11:31:44 Duration: 1m36s 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-07-27', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 14:53:01 Duration: 1m22s 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-07-27', 0302, '', '', 0, 6, '2026-07-01');
Date: 2026-07-27 15:50:32 Duration: 1m19s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 10s321ms 15s364ms 13s152ms 21 4m36s create table temp0000286632 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 27 15 18 3m59s 13s304ms 16 3 36s725ms 12s241ms [ User: intelifix - Total duration: 4m36s - Times executed: 21 ]
[ Application: [unknown] - Total duration: 4m36s - Times executed: 21 ]
-
CREATE TABLE temp0000286632 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:55:54 Duration: 15s364ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286632 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:55:12 Duration: 15s310ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286632 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:55:36 Duration: 14s322ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 10s827ms 14s728ms 12s871ms 25 5m21s create table temp0000286606 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 27 13 4 52s841ms 13s210ms 15 3 40s838ms 13s612ms 16 9 1m59s 13s293ms 17 9 1m48s 12s53ms [ User: intelifix - Total duration: 5m21s - Times executed: 25 ]
[ Application: [unknown] - Total duration: 5m21s - Times executed: 25 ]
-
CREATE TABLE temp0000286606 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 13:46:49 Duration: 14s728ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286606 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:35:52 Duration: 14s415ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286606 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 13:57:25 Duration: 14s244ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 11s204ms 13s949ms 12s643ms 15 3m9s create table temp0000286612 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 27 14 15 3m9s 12s643ms [ User: intelifix - Total duration: 3m9s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m9s - Times executed: 15 ]
-
CREATE TABLE temp0000286612 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:43:03 Duration: 13s949ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286612 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:24:48 Duration: 13s827ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286612 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:25:22 Duration: 13s530ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 9s857ms 14s756ms 12s135ms 66 13m20s create table temp0000286596 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 27 13 4 49s255ms 12s313ms 14 50 10m3s 12s72ms 15 12 2m28s 12s338ms [ User: intelifix - Total duration: 13m20s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 13m20s - Times executed: 66 ]
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 15:00:20 Duration: 14s756ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:38:52 Duration: 14s245ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 14:22:46 Duration: 14s53ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 9s75ms 49s633ms 12s11ms 77 15m24s create table temp0000286498 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 27 07 17 3m31s 12s420ms 08 14 2m36s 11s206ms 09 16 3m15s 12s231ms 10 12 2m23s 11s937ms 11 12 2m30s 12s559ms 12 6 1m7s 11s190ms [ User: intelifix - Total duration: 15m24s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 15m24s - Times executed: 77 ]
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 07:09:54 Duration: 49s633ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 11:09:50 Duration: 14s597ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-27 09:28:56 Duration: 14s578ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 276ms 44s635ms 7s427ms 54 6m41s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 27 07 3 56s525ms 18s841ms 08 3 12s661ms 4s220ms 09 4 38s398ms 9s599ms 10 6 52s371ms 8s728ms 11 7 1m12s 10s292ms 12 1 2s26ms 2s26ms 13 2 26s691ms 13s345ms 14 21 53s272ms 2s536ms 15 3 48s385ms 16s128ms 16 1 10s297ms 10s297ms 17 3 28s425ms 9s475ms [ User: intelifix - Total duration: 6m41s - Times executed: 54 ]
[ Application: psql - Total duration: 6m41s - Times executed: 54 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027566);
Date: 2026-07-27 07:13:15 Duration: 44s635ms 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 (027631);
Date: 2026-07-27 14:44:28 Duration: 36s133ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 184); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027673);
Date: 2026-07-27 17:40:13 Duration: 27s483ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 3s634ms 6s275ms 4s795ms 44 3m30s create table temp0000286596 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 27 13 3 13s214ms 4s404ms 14 35 2m47s 4s787ms 15 6 30s211ms 5s35ms [ User: intelifix - Total duration: 3m30s - Times executed: 44 ]
[ Application: [unknown] - Total duration: 3m30s - Times executed: 44 ]
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 15:04:54 Duration: 6s275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 15:15:06 Duration: 5s952ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286596 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 14:44:39 Duration: 5s626ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 3s289ms 14s807ms 4s301ms 46 3m17s create table temp0000286498 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 27 08 18 1m7s 3s739ms 09 11 56s566ms 5s142ms 10 12 50s36ms 4s169ms 11 5 23s971ms 4s794ms [ User: intelifix - Total duration: 3m17s - Times executed: 46 ]
[ Application: [unknown] - Total duration: 3m17s - Times executed: 46 ]
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 09:39:37 Duration: 14s807ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 11:02:40 Duration: 6s165ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
CREATE TABLE temp0000286498 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"22-07-2026", "ate" :"27-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-27 10:44:36 Duration: 5s702ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 198ms 1m59s 3s277ms 107 5m50s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 27 07 6 4s245ms 707ms 08 5 3s524ms 704ms 09 6 4s422ms 737ms 10 7 51s458ms 7s351ms 11 11 2m3s 11s263ms 12 3 1s498ms 499ms 13 3 3s423ms 1s141ms 14 40 1m27s 2s184ms 15 17 8s698ms 511ms 16 5 24s593ms 4s918ms 17 4 37s517ms 9s379ms [ User: intelifix - Total duration: 5m50s - Times executed: 107 ]
[ Application: psql - Total duration: 5m50s - Times executed: 107 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027591);
Date: 2026-07-27 11:22:49 Duration: 1m59s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027624);
Date: 2026-07-27 14:31:51 Duration: 1m14s 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 (027584);
Date: 2026-07-27 10:18:18 Duration: 26s861ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 151ms 1m3s 1s343ms 1,271 28m27s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 27 07 1 221ms 221ms 08 141 2m12s 940ms 09 201 3m15s 972ms 10 129 3m8s 1s458ms 11 132 3m17s 1s494ms 12 45 1m8s 1s512ms 13 101 2m4s 1s235ms 14 148 3m12s 1s300ms 15 166 4m57s 1s793ms 16 140 3m32s 1s515ms 17 67 1m38s 1s470ms [ User: intelifix - Total duration: 28m27s - Times executed: 1271 ]
[ Application: [unknown] - Total duration: 28m27s - Times executed: 1271 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (271378, 507, '929240032276,5447CCCC5AF5,2035431B18EB', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$$$$$','', 00);
Date: 2026-07-27 15:23:09 Duration: 1m3s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (270205, 503, '518312082131,4C1265359621,BC644BD5A0E1,BC644BD06969,BC644BCC3EE3,5819F8446F04,BC644BCEF322,B0DAF94ACD47,F8F53255C8B8,A89FECBFC9CE,F8F53258CE9B,4C1265EAE53F,BC644BD5FC3F,5819F8444484,BC644BDB5AEF,B0935BECD2D3,B0935BEC8A8F,B0DAF9515D88,B0DAF94A5F74,BC644BC60D34,4C12653C5C8B,A89FECC2DA0B,BC644BDC38E3,A8F5DDED0E34,4C12653E003B,B0935BE96B52,BC644BC42C58,F8F53258CF7C,B0DAF9688BA9,4C1265EACCA3,BC644BE47170,4C1265E74FC9,B0935BEB6D5D,2C584F33D89B,A8F5DDE9652C,2C584F373275,BC644BD56A68,BC644BC89185,5819F8472F00,2C584F2F5488,BC644BE4B455', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-27 16:06:22 Duration: 8s468ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48039, 418, '226122281018', '',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-07-27 15:40:04 Duration: 8s41ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 184ms 5s922ms 1s305ms 149 3m14s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 27 07 23 24s15ms 1s44ms 08 6 6s129ms 1s21ms 09 18 8s225ms 456ms 10 6 6s16ms 1s2ms 11 11 38s858ms 3s532ms 12 1 2s765ms 2s765ms 14 39 58s232ms 1s493ms 15 10 15s742ms 1s574ms 16 7 8s540ms 1s220ms 17 28 26s65ms 930ms [ User: intelifix - Total duration: 3m14s - Times executed: 149 ]
[ Application: [unknown] - Total duration: 3m14s - Times executed: 149 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0270648) LIMIT 1;
Date: 2026-07-27 11:44:39 Duration: 5s922ms Database: rio 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 (0271110) LIMIT 1;
Date: 2026-07-27 14:28:05 Duration: 5s593ms Database: rio 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 (0270648) LIMIT 1;
Date: 2026-07-27 14:47:47 Duration: 5s150ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 150ms 8s202ms 739ms 1,087 13m23s select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 27 06 2 2s613ms 1s306ms 07 21 14s518ms 691ms 08 112 1m31s 817ms 09 144 1m48s 754ms 10 135 1m52s 833ms 11 159 1m57s 740ms 12 9 7s689ms 854ms 13 113 1m18s 698ms 14 107 1m6s 622ms 15 110 1m11s 650ms 16 146 1m50s 757ms 17 29 21s136ms 728ms [ User: intelifix - Total duration: 13m23s - Times executed: 1087 ]
[ Application: [unknown] - Total duration: 13m23s - Times executed: 1087 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "249092", "modelo" : "295", "itens" : "229988630619,230035434748,230030555776,230014584756,229989038491,229965026384,229971517275,230029877292,229979446478,229982148492,229973174654,229990129697,230031554044,229987735166,229986395877,229982829906,229982601119,230035757686,230030556079,230027895662", "usuario" : "414", "caixa" : "3017498", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 10:58:01 Duration: 8s202ms 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" : "108194", "modelo" : "454", "itens" : "241627124157,241627176384,241613385072,241624612745,241625399903,241624969704,241625351919,241611010621,241625407176,241625461728,241625322747,241614413848,241614380512,241625442130,241612220324,241624607794,241612465072,241613385274,241626288283,241625057389,241613762842,241624869111,241613366888,241627177495,241627171637,241624700812,241613417072,241632888502,241632966668,241627235357,241627128602,241611552424,241634094848,241613362141,241613868485,241613834364,241613783854,241613744456,241612208504,241625360405,241614283151", "usuario" : "414", "caixa" : "1299019", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 08:21:15 Duration: 6s20ms 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" : "271359", "modelo" : "320", "itens" : "241649526668,241676645252,241629940628,241709379805,241680744766,241699055666,241656941321,241658300814,241650496673,241649572734,241717093151,241674121617,241631040926,241706533052,241619345777,241660338284,241667960107,241706952543,241709352126,241637303355,241660601521,241712616978,241604555871,241691367575,241652129605,241652114351,241715191327,241665268799,241727569605,241650480107,241691522945,241665014353,241709009915,241599466676,241728823959,241627989101,241616612020,241619330827,241691699101,241712678904,241660388188,241650415577,241648203341,241680686477,241602859296,241629941537,241603458098,241660338688", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-27 14:44:42 Duration: 2s969ms 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 16 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 26 10 1 0ms 0ms 15 1 0ms 0ms 16 1 0ms 0ms 17 1 0ms 0ms 18 1 0ms 0ms 21 3 0ms 0ms 22 1 0ms 0ms Jul 27 10 1 0ms 0ms 13 1 0ms 0ms 16 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 20m48s - Times executed: 16 ]
[ Application: psql - Total duration: 20m48s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 601ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 24,297 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 21 FATAL entries
- 4799 ERROR entries
- 0 WARNING entries
- 886 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,672 Max number of times the same event was reported
- 5,706 Total events found
Rank Times reported Error 1 4,672 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 27 00 59 01 60 02 59 03 60 04 59 05 59 06 62 07 167 08 393 09 412 10 462 11 531 12 282 13 226 14 389 15 496 16 365 17 185 18 59 19 60 20 59 21 59 22 60 23 49 - ERROR: prepared statement "_PLAN000000002ED01BE0" does not exist
- ERROR: prepared statement "_PLAN000000002E94F830" does not exist
- ERROR: prepared statement "_PLAN000000002E94F830" does not exist
Statement: DEALLOCATE "_PLAN000000002ED01BE0"
Date: 2026-07-27 00:00:32 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: DEALLOCATE "_PLAN000000002E94F830"
Date: 2026-07-27 00:01:33 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: DEALLOCATE "_PLAN000000002E94F830"
Date: 2026-07-27 00:02:34 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
2 835 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 27 11 1 14 691 15 143 - ERROR: process 1865370 detected deadlock while waiting for ShareLock on transaction 3358225 after 1000.183 ms
- ERROR: process 1978383 detected deadlock while waiting for ShareLock on transaction 3372073 after 1000.102 ms
- ERROR: process 1978383 detected deadlock while waiting for ShareLock on transaction 3371644 after 1000.072 ms
Detail: Process holding the lock: 1854335. Wait queue: .
Context: while deleting tuple (69149,37) in relation "codigos_barra" SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,185,6,507,'832088913000379','','832088913000379','229921460517',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027590, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-07-27 11:14:28 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 2002454. Wait queue: .
Context: while updating tuple (74948,75) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-27 14:36:36 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 2002454. Wait queue: .
Context: while updating tuple (19410,67) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-27 14:36:38 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
3 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 27 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-27 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-27 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-27 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
4 44 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 27 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 2 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-27 08:00:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-27 08:20:06 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-27 08:40:11 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
5 37 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 27 09 4 11 5 12 4 14 11 15 13 - LOG: process 1748203 still waiting for ShareLock on transaction 3349413 after 1000.098 ms
- LOG: process 1748203 still waiting for ShareLock on transaction 3349413 after 6957.372 ms
- LOG: process 1748203 still waiting for ShareLock on transaction 3349413 after 78336.865 ms
Detail: Process holding the lock: 1717811. Wait queue: 1748203.
Context: while updating tuple (74805,3) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-27 09:35:24 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 1717811. Wait queue: 1748203.
Context: while updating tuple (74805,3) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-27 09:35:30 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 1717811. Wait queue: 1748203.
Context: while updating tuple (74805,3) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-27 09:36:42 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
6 18 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 27 09 8 12 4 14 2 16 4 - ERROR: syntax error at or near "D4925E19C82C" at character 46
- ERROR: syntax error at or near "D4925E19C82C" at character 32
- ERROR: syntax error at or near "D4925E19C82C" at character 46
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0298, ''D4925E19C82C' )
Date: 2026-07-27 09:48:25 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT RS_SERIAL_TEMPORARIO( ''D4925E19C82C' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''D4925E19C82C' )
Date: 2026-07-27 09:48:25 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0298, ''D4925E19C82C' )
Date: 2026-07-27 09:50:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
7 13 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 27 00 1 06 1 07 1 11 1 14 3 15 2 17 2 20 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-27 00:02:35 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-07-27 06:02:31 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-07-27 07:08:06 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
8 8 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 27 14 3 15 5 - LOG: process 2002435 still waiting for ExclusiveLock on tuple (74937,66) of relation 363850 of database 358220 after 1000.138 ms
- LOG: process 2002435 still waiting for ExclusiveLock on tuple (74937,66) of relation 363850 of database 358220 after 9137.174 ms
- LOG: process 2002435 still waiting for ExclusiveLock on tuple (74937,66) of relation 363850 of database 358220 after 69309.973 ms
Detail: Process holding the lock: 1961123. Wait queue: 2002435.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-27 14:51:13 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 1961123. Wait queue: 2002435.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-27 14:51:21 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 1961123. Wait queue: 2002435.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027624, 0434 )' , '/var/www/html/tmp/nf_carga_lotes_0434.xlsx' )Date: 2026-07-27 14:52:21 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
9 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 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-07-27 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-07-27 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Context: SQL statement "SELECT RS_CHMOD( cFile , '0o777' )" PL/pgSQL function rs_giga_tecnicos() line 42 at PERFORM
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-27 03:05:01 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
10 5 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 27 10 5 - ERROR: trailing junk after numeric literal at or near "20B82B2365F1" at character 27
- ERROR: trailing junk after numeric literal at or near "20B82B2365F1" at character 27
- ERROR: trailing junk after numeric literal at or near "82817792600L500" at character 27
Statement: select * from rs_caixa_qr(20B82B2365F1)
Date: 2026-07-27 10:32:47 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: select * from rs_caixa_qr(20B82B2365F1)
Date: 2026-07-27 10:32:47 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Statement: SELECT * FROM RS_ETIQUETA(82817792600L500)
Date: 2026-07-27 10:40:40 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
11 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 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-07-27 05:32:04 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-07-27 05:32:04 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-07-27 05:32:04 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
12 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 27 09 1 10 1 14 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000286498"
Date: 2026-07-27 09:11:43 Log file: /usr/local/pgsql/data/log/serverlog-27.log
Context: automatic vacuum of table "rio.public.temp0000286498"
Date: 2026-07-27 10:51:45 Log file: /usr/local/pgsql/data/log/serverlog-27.log
Context: automatic vacuum of table "rio.public.temp0000286610"
Date: 2026-07-27 14:31:11 Log file: /usr/local/pgsql/data/log/serverlog-27.log
13 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 27 09 1 10 1 14 1 - LOG: process 1734540 still waiting for AccessExclusiveLock on relation 2961911 of database 358220 after 1000.073 ms
- LOG: process 1807810 still waiting for AccessExclusiveLock on relation 2975534 of database 358220 after 1000.230 ms
- LOG: process 1949181 still waiting for AccessExclusiveLock on relation 2990781 of database 358220 after 1000.121 ms
Detail: Process holding the lock: 1755805. Wait queue: 1734540.
Statement: DROP TABLE IF EXISTS temp0000286498;Date: 2026-07-27 09:11:43 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 1846258. Wait queue: 1807810.
Statement: DROP TABLE IF EXISTS temp0000286498;Date: 2026-07-27 10:51:45 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 2002999. Wait queue: 1949181.
Statement: DROP TABLE IF EXISTS temp0000286610;Date: 2026-07-27 14:31:11 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
14 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 27 11 1 14 1 - ERROR: column a.flu_id does not exist at character 1127
- ERROR: column "controle" does not exist at character 36
Statement: SELECT A.LOT_ID,A.LOT_DATA_SAIDA,RS_NOME_USUARIO(A.USU_ID) AS USU_NOME,A.OFI_ID,RS_NOME_OFICINA(A.OFI_ID) AS OFI_NOME, A.CLI_ID,RS_NOME_CLIENTE(E.CLI_ID) AS CLI_NOME,C.CAI_ID,E.EQ_SERIE,E.EQ_MAC_ADDRESS,C.FLU_ID,E.EQ_ID, D.FLU_DATA,D.TEC_ID,E.MOD_ID,D.FLU_GARANTIA,A.LOT_FATURA,A.LOT_NOTAFISCAL,D.FLU_ORIGINAL,A.LOT_SUCATA, G.NFS_NUMERO,G.NFS_EMISSAO,A.LOT_COMPLETO,I.LOT_NOTAFISCAL AS NOTA_ENTRADA,J.USU_NOME AS USU_CAIXA, K.MOD_NOME,K.MOD_MNEMONICO,K.MOD_LEGADO, L.TCN_NOME,B.CAI_OBS, H.LI_ID, K.MOD_OBS FROM CAIXA_ITENS C INNER JOIN LOTE_CAIXAS B ON B.CAI_ID = C.CAI_ID INNER JOIN LOTES_SAIDAS A ON A.LOT_ID = B.LOT_ID INNER JOIN FLUXOS D ON D.FLU_ID = C.FLU_ID INNER JOIN EQUIPAMENTOS E ON E.EQ_ID = D.EQ_ID LEFT JOIN ARQUIVO_NFS F ON F.ANF_ID = C.ANF_ID LEFT JOIN NOTAS_SAIDA G ON G.NFS_ID = F.NFS_ID LEFT JOIN LOTE_ITENS H ON H.FLU_ID = C.FLU_ID LEFT JOIN LOTES I ON I.LOT_ID = H.LOT_ID LEFT JOIN USUARIOS J ON J.USU_ID = C.USU_ID INNER JOIN MODELOS K ON K.MOD_ID = E.MOD_ID LEFT JOIN TECNOLOGIAS L ON L.TCN_ID = K.TCN_ID where a.flu_id= 3085925
Date: 2026-07-27 11:51:57 Database: rio Application: pgAdmin 4 - CONN:6158286 User: lenon Remote: 172.20.0.3 Log file: /usr/local/pgsql/data/log/serverlog-27.log
Hint: Perhaps you meant to reference the column "temp0000236914.con_nome".
Statement: SELECT * FROM temp0000236914 WHERE CONTROLE='L'Date: 2026-07-27 14:43:57 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
15 2 LOG: process ... still waiting for AccessExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 27 12 2 - LOG: process 1859658 still waiting for AccessExclusiveLock on tuple (69180,67) of relation 362633 of database 358220 after 1000.133 ms
- LOG: process 1859658 still waiting for AccessExclusiveLock on tuple (69180,67) of relation 362633 of database 358220 after 199624.736 ms
Detail: Process holding the lock: 1854335. Wait queue: 1859658.
Context: SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,145,6,305,'829297943000077','','829297943000077','229725429094',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0305 )' , '/var/www/html/tmp/nf_carga_lotes_0305.xlsx' )Date: 2026-07-27 12:06:13 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Detail: Process holding the lock: 1854335. Wait queue: 1859658.
Context: SQL statement "DELETE FROM CODIGOS_BARRA WHERE EQ_ID = cRet.ID" PL/pgSQL function rs_equipamento_manutencao(integer,integer,integer,integer,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 655 at SQL statement SQL statement "SELECT * FROM RS_EQUIPAMENTO_MANUTENCAO( 0,5,145,6,305,'829297943000077','','829297943000077','229725429094',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 920 at EXECUTE PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 027591, 0305 )' , '/var/www/html/tmp/nf_carga_lotes_0305.xlsx' )Date: 2026-07-27 12:09:32 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
16 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 27 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-27 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
Date: 2026-07-27 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
17 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 27 03 1 - LOG: database system was shut down at 2026-07-27 03:05:01 -03
Date: 2026-07-27 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-27.log
18 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 27 22 1 - ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-27 22:40:03 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
19 1 ERROR: insert or update on table "..." violates foreign key constraint "..."
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 27 15 1 - ERROR: insert or update on table "lote_itens" violates foreign key constraint "lote_itens_flu_id_fkey"
Detail: Key (flu_id)=(1668618) is not present in table "fluxos".
Context: SQL statement "UPDATE LOTE_ITENS SET FLU_ID = nOriginal, LI_STATUS = 1 WHERE LI_ID = nLI" PL/pgSQL function rs_triagem_exclui(integer,integer) line 106 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 323 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-27 15:11:45 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
20 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #20
Day Hour Count Jul 27 09 1 - ERROR: unterminated quoted string at or near "''' )" at character 44
Statement: SELECT SAIDA FROM RS_SMARTCARD_TELA( 0298, ''' )
Date: 2026-07-27 09:48:20 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
21 1 ERROR: invalid input syntax for type date: ...
Times Reported Most Frequent Error / Event #21
Day Hour Count Jul 27 07 1 - ERROR: invalid input syntax for type date: "N-Na--N-Na" at character 40
Statement: SELECT * FROM RS_RESUMO_PERIODO_GERAL( 'N-Na--N-Na', 0404 ,'', '',0,7,'2026-07-01');
Date: 2026-07-27 07:16:34 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log
22 1 ERROR: spiexceptions.ForeignKeyViolation: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #22
Day Hour Count Jul 27 11 1 - ERROR: spiexceptions.ForeignKeyViolation: update or delete on table "equipamentos" violates foreign key constraint "ref_codigos_barra_to_equipamentos" on table "codigos_barra"
Detail: Key (eq_id)=(10652307) is still referenced from table "codigos_barra".
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/EXCLUSÃO ATOP.xlsx'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-07-27 11:16:38 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-27.log