pgBadger-
Global information
- Generated on Fri Aug 14 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 61,938 log entries in 13s
- Log start from 2026-08-13 00:00:07 to 2026-08-13 23:59:53
-
Overview
Global Stats
- 429 Number of unique normalized queries
- 7,202 Number of queries
- 11h31m4s Total query duration
- 2026-08-13 00:02:13 First query
- 2026-08-13 23:52:30 Last query
- 7 queries/s at 2026-08-13 11:46:47 Query peak
- 11h31m4s Total query duration
- 160ms Prepare/parse total duration
- 0ms Bind total duration
- 11h31m4s Execute total duration
- 7,869 Number of events
- 18 Number of unique normalized events
- 7,733 Max number of times the same event was reported
- 0 Number of cancellation
- 594 Total number of automatic vacuums
- 1,087 Total number of automatic analyzes
- 11 Number temporary file
- 240.34 MiB Max size of temporary file
- 111.01 MiB Average size of temporary file
- 524 Total number of sessions
- 9 sessions at 2026-08-13 01:05:01 Session peak
- 15d3h24m42s Total duration of sessions
- 41m36s Average duration of sessions
- 13 Average queries per session
- 1m19s Average queries duration per session
- 40m17s Average idle time per session
- 538 Total number of connections
- 6 connections/s at 2026-08-13 03:05:16 Connection peak
- 4 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2026-08-13 11:46:47 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2026-08-13 11:46:47 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-13 23:52:23 Date
Queries duration
Key values
- 11h31m4s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 13 00 29 0ms 19s844ms 5s80ms 7s321ms 8s532ms 1m31s 01 35 0ms 4s407ms 1s346ms 5s905ms 7s53ms 9s100ms 02 18 0ms 5s49ms 2s267ms 5s624ms 6s696ms 8s338ms 03 20 0ms 5s971ms 2s217ms 5s546ms 7s863ms 9s232ms 04 18 0ms 4s741ms 2s291ms 5s182ms 6s911ms 9s190ms 05 50 0ms 10m 26s594ms 15s961ms 2m54s 10m1s 06 20 0ms 11s443ms 3s497ms 4s389ms 4s776ms 31s478ms 07 294 0ms 9m58s 9s911ms 1m8s 6m20s 9m58s 08 517 0ms 9m20s 4s400ms 40s59ms 5m40s 9m58s 09 526 150ms 9m38s 5s189ms 1m14s 5m55s 9m43s 10 579 150ms 9m22s 4s325ms 1m9s 6m18s 9m28s 11 663 150ms 8m44s 4s995ms 1m36s 7m1s 8m47s 12 242 0ms 8m20s 11s347ms 3m42s 5m34s 9m14s 13 388 150ms 6m48s 2s934ms 26s142ms 1m 6m52s 14 826 150ms 12m5s 6s218ms 6m39s 9m54s 12m14s 15 1,175 150ms 10m28s 4s123ms 5m53s 7m51s 11m46s 16 704 150ms 10m45s 4s509ms 1m31s 6m57s 10m59s 17 571 0ms 8m33s 3s363ms 1m15s 2m49s 8m59s 18 37 0ms 9m2s 24s747ms 6s666ms 1m39s 9m2s 19 24 0ms 6m11s 28s725ms 5s941ms 18s830ms 6m44s 20 124 0ms 8m47s 12s355ms 1m12s 1m45s 8m47s 21 40 0ms 7m20s 19s451ms 8s98ms 19s284ms 7m56s 22 30 0ms 6m11s 23s712ms 8s155ms 17s847ms 6m43s 23 272 0ms 1m39s 8s899ms 1m8s 1m12s 1m39s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 13 00 7 0 2s339ms 0ms 0ms 1s458ms 01 17 0 258ms 193ms 284ms 520ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 183ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 28 0 329ms 215ms 399ms 1s466ms 06 5 0 3s182ms 0ms 0ms 936ms 07 224 0 10s418ms 9s80ms 44s69ms 7m43s 08 381 0 5s183ms 11s509ms 29s411ms 7m11s 09 401 0 5s429ms 11s15ms 1m5s 6m34s 10 464 0 4s731ms 14s495ms 53s998ms 6m57s 11 499 0 5s133ms 26s712ms 1m35s 7m12s 12 150 0 15s320ms 6s118ms 3m19s 7m41s 13 300 0 3s115ms 5s467ms 13s701ms 4m1s 14 619 0 7s122ms 38s395ms 6m24s 10m41s 15 960 0 4s46ms 49s468ms 5m26s 10m37s 16 581 0 4s929ms 14s937ms 1m19s 10m1s 17 438 0 3s622ms 21s252ms 55s569ms 5m8s 18 16 0 54s96ms 0ms 2s377ms 3m35s 19 6 0 1m46s 0ms 0ms 3m34s 20 15 90 14s13ms 39s127ms 1m7s 4m3s 21 16 0 44s658ms 0ms 323ms 3m35s 22 6 0 1m47s 0ms 0ms 3m45s 23 16 256 8s899ms 1m2s 1m8s 1m15s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 13 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Aug 13 00 0 2 2.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 0 0.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 19 19.00 0.00% 08 0 18 18.00 0.00% 09 0 23 23.00 0.00% 10 0 20 20.00 0.00% 11 0 20 20.00 0.00% 12 0 15 15.00 0.00% 13 0 11 11.00 0.00% 14 0 23 23.00 0.00% 15 0 19 19.00 0.00% 16 0 12 12.00 0.00% 17 0 12 12.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 1 3 3.00 0.37% Day Hour Count Average / Second Aug 13 00 28 0.01/s 01 23 0.01/s 02 18 0.01/s 03 28 0.01/s 04 16 0.00/s 05 23 0.01/s 06 23 0.01/s 07 26 0.01/s 08 28 0.01/s 09 32 0.01/s 10 28 0.01/s 11 29 0.01/s 12 26 0.01/s 13 27 0.01/s 14 34 0.01/s 15 30 0.01/s 16 21 0.01/s 17 24 0.01/s 18 12 0.00/s 19 9 0.00/s 20 14 0.00/s 21 14 0.00/s 22 11 0.00/s 23 14 0.00/s Day Hour Count Average Duration Average idle time Aug 13 00 19 26m12s 26m5s 01 26 40m2s 40m 02 20 39m57s 39m55s 03 29 17m47s 17m46s 04 17 33m8s 33m5s 05 18 30m9s 28m55s 06 20 36m23s 36m19s 07 21 42m2s 39m43s 08 28 42m47s 41m26s 09 31 38m49s 37m21s 10 28 40m19s 38m49s 11 28 42m32s 40m34s 12 29 40m19s 38m44s 13 21 40m38s 39m44s 14 31 39m52s 37m7s 15 30 42m4s 39m23s 16 24 55m2s 52m49s 17 24 51m10s 49m50s 18 16 1h12s 59m15s 19 12 58m35s 57m37s 20 12 46m37s 44m29s 21 11 1h1m4s 59m54s 22 14 1h39s 59m48s 23 15 46m15s 43m33s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-08-13 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 538 connections Total
Connections per user
Key values
- etiquetas Main User
- 538 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-08-13 01:05:01 Date
Histogram of session times
Key values
- 304 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 524 sessions Total
Sessions per user
Key values
- etiquetas Main User
- 524 sessions Total
Sessions per host
Key values
- [local] Main Host
- 524 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 524 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 40,768 buffers Checkpoint Peak
- 2026-08-13 00:09:43 Date
- 270.027 seconds Highest write time
- 2.149 seconds Sync time
Checkpoints Wal files
Key values
- 44 files Wal files usage Peak
- 2026-08-13 14:19:40 Date
Checkpoints distance
Key values
- 1,411.39 Mo Distance Peak
- 2026-08-13 14:19:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 13 00 56,479 687.14s 0.083s 687.35s 01 3,719 373.312s 0.225s 373.683s 02 1,905 191.326s 0.13s 191.555s 03 1,929 192.841s 0.073s 192.967s 04 2,239 224.759s 0.116s 224.987s 05 10,966 1,094.219s 0.206s 1,094.522s 06 6,073 269.92s 0.064s 269.992s 07 51,160 2,805.888s 0.509s 2,806.583s 08 56,893 3,127.492s 0.896s 3,128.629s 09 84,662 3,238.562s 0.787s 3,239.594s 10 67,028 3,238.803s 0.746s 3,239.787s 11 71,184 3,148.448s 0.904s 3,149.636s 12 90,768 2,561.904s 0.508s 2,563.168s 13 21,890 2,138.679s 0.595s 2,139.412s 14 107,592 3,238.378s 2.971s 3,241.692s 15 123,268 3,238.035s 1.307s 3,239.717s 16 85,280 3,238.5s 0.856s 3,239.574s 17 62,755 2,900.514s 0.841s 2,901.563s 18 4,717 439.595s 0.209s 439.863s 19 38 3.869s 0.017s 3.907s 20 1,669 240.67s 0.088s 240.792s 21 2,648 265.804s 0.124s 266.003s 22 2,390 239.858s 0.068s 239.991s 23 566 57.105s 0.029s 57.209s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 13 00 0 0 9 532 0.008s 0.006s 01 0 0 2 767 0.064s 0.01s 02 0 0 0 407 0.064s 0.006s 03 0 0 1 405 0.007s 0.008s 04 0 0 1 439 0.064s 0.007s 05 0 0 5 822 0.024s 0.011s 06 0 0 0 10 0.061s 0.007s 07 0 0 33 4,291 0.026s 0.012s 08 0 0 32 5,465 0.065s 0.012s 09 0 0 43 6,584 0.011s 0.012s 10 0 0 33 7,045 0.011s 0.012s 11 0 0 67 6,435 0.063s 0.012s 12 0 0 89 3,468 0.026s 0.012s 13 0 0 7 4,680 0.060s 0.012s 14 0 0 109 7,419 2.089s 0.016s 15 0 0 90 8,525 0.062s 0.012s 16 0 0 43 6,827 0.063s 0.012s 17 0 0 46 5,655 0.062s 0.011s 18 0 0 1 634 0.063s 0.01s 19 0 0 0 15 0.011s 0.005s 20 0 0 1 91 0.061s 0.007s 21 0 0 1 502 0.063s 0.012s 22 0 0 1 458 0.006s 0.009s 23 0 0 0 30 0.007s 0.01s Day Hour Count Avg time (sec) Aug 13 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Aug 13 00 25,192.67 kB 63,448.00 kB 01 2,084.44 kB 31,730.56 kB 02 1,677.17 kB 15,149.17 kB 03 1,617.00 kB 3,610.71 kB 04 2,068.33 kB 2,755.00 kB 05 8,001.10 kB 15,827.10 kB 06 11,906.00 kB 12,982.00 kB 07 44,949.83 kB 67,485.25 kB 08 42,907.75 kB 83,506.75 kB 09 59,345.58 kB 106,615.33 kB 10 45,146.58 kB 93,461.75 kB 11 91,795.50 kB 163,610.33 kB 12 120,950.08 kB 360,825.33 kB 13 10,158.83 kB 131,621.92 kB 14 148,020.67 kB 410,252.58 kB 15 122,382.42 kB 261,110.00 kB 16 59,457.17 kB 138,769.00 kB 17 67,923.18 kB 110,200.91 kB 18 2,522.00 kB 67,006.38 kB 19 78.67 kB 36,784.33 kB 20 5,817.00 kB 27,444.75 kB 21 1,891.14 kB 16,251.29 kB 22 1,560.50 kB 8,394.62 kB 23 197.50 kB 4,383.67 kB -
Temporary Files
Size of temporary files
Key values
- 480.69 MiB Temp Files size Peak
- 2026-08-13 05:32:08 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-13 05:32:17 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 13 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.09 GiB 111.71 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 1 104.00 MiB 104.00 MiB 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 933.63 MiB 71.69 MiB 240.34 MiB 116.70 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-13 05:32:17 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-13 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 183.47 MiB 91.73 MiB 91.73 MiB 91.73 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-13 05:30:43 Duration: 41s801ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-13 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 1 104.00 MiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 14:39:46 Duration: 12m5s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028443, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 15:49:01 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-13 14:45:02 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Queries generating the largest temporary files
Rank Size Query 1 240.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 240.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-13 15:00:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 91.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-13 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 91.73 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-13 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 79.33 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 79.24 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 79.24 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 71.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 71.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 71.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-13 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 100.93 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-08-13 14:14:26 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 100.93 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-08-13 14:14:26 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (119) Main table analyzed (database rio)
- 1,087 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 119 rio.pg_catalog.pg_class 65 rio.pg_catalog.pg_type 54 rio.public.usuarios 49 contagem.pg_catalog.pg_attribute 38 rio.public.temp0000288341 37 rio.pg_catalog.pg_index 36 rio.pg_catalog.pg_depend 30 brasilia.pg_catalog.pg_attribute 29 rio.public.temp0000288258 28 contagem.public.temp0000226828 28 contagem.public.usuarios 26 rio.public.temp0000288304 25 rio.public.temp0000288254 25 rio.public.temp0000288264 24 rio.public.temp0000288361 23 rio.public.temp0000288262 23 contagem.pg_catalog.pg_class 21 rio.public.temp0000288130 20 rio.public.temp0000288302 18 contagem.pg_catalog.pg_type 18 rio.public.temp0000288268 17 rio.public.temp0000288128 17 rio.public.temp0000288322 17 rio.public.temp0000288373 14 brasilia.pg_catalog.pg_class 13 rio.public.temp0000288250 12 brasilia.public.temp0000238132 12 contagem.pg_catalog.pg_index 11 brasilia.pg_catalog.pg_type 11 rio.public.temp0000288162 9 contagem.public.temp0000226812 9 rio.public.temp0000288349 8 contagem.pg_catalog.pg_depend 8 brasilia.public.usuarios 8 rio.public.temp0000288286 8 brasilia.public.temp0000238138 7 rio.public.temp0000288246 7 rio.public.temp0000288363 7 brasilia.pg_catalog.pg_index 7 rio.public.temp0000288328 6 rio.public.temp0000288136 6 rio.public.temp0000288154 6 rio.public.temp0000288367 5 brasilia.pg_catalog.pg_depend 5 rio.public.temp0000288387 5 rio.public.temp0000288347 5 rio.public.temp0000288330 5 brasilia.public.temp0000238090 4 rio.public.temp0000288146 4 rio.public.temp0000288369 4 template1.pg_catalog.pg_shdepend 3 rio.public.temp0000288343 3 rio.public.temp0000288278 3 contagem.pg_catalog.pg_shdepend 3 rio.public.temp0000288280 3 rio.public.temp0000288252 3 rio.public.temp0000288290 3 rio.public.temp0000288298 3 rio.public.temp0000288355 3 brasilia.pg_catalog.pg_shdepend 3 brasilia.public.temp0000238110 3 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000288300 2 rio.public.temp0000288377 2 rio.public.tmp_drill_0173 2 brasilia.public.temp0000238104 2 rio.public.tmp_drill_0302 2 brasilia.public.temp0000238154 2 brasilia.public.nf_entrada 2 contagem.public.temp0000226764 2 brasilia.public.temp0000238100 2 rio.public.temp0000288314 2 rio.public.tmp_drill_0175 2 brasilia.public.temp0000238098 2 contagem.public.nf_entrada 2 rio.pg_catalog.pg_shdepend 2 brasilia.public.temp0000238134 2 brasilia.public.temp0000238108 2 brasilia.public.temp0000238156 2 rio.public.tmp_drill_0320 2 rio.public.temp0000288318 1 brasilia.public.temp0000238112 1 rio.public.temp0000288312 1 brasilia.public.temp0000238164 1 rio.public.temp0000288270 1 contagem.public.temp0000226826 1 rio.public.temp0000288357 1 brasilia.public.temp0000238130 1 brasilia.auditor.auditor_2026_08 1 brasilia.public.temp0000238084 1 brasilia.public.temp0000238078 1 brasilia.public.temp0000238094 1 contagem.auditor.auditor_2026_08 1 rio.public.temp0000288266 1 rio.public.temp0000288274 1 brasilia.public.temp0000238152 1 rio.public.temp0000288405 1 rio.public.passo_desvio 1 rio.public.temp0000288401 1 rio.public.temp0000288351 1 rio.public.temp0000288324 1 rio.auditor.auditor_2026_08 1 rio.public.temp0000288399 1 Total 1,087 Vacuums per table
Key values
- pg_catalog.pg_attribute (75) Main table vacuumed on database rio
- 594 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 75 43 0 0 0 0 0 25,507 6,226 9,486,324 370 8,913 rio.pg_catalog.pg_class 57 31 0 0 0 0 0 5,452 1,416 2,373,372 79 296 rio.pg_catalog.pg_type 52 28 0 0 0 0 0 2,297 546 801,023 64 232 rio.public.temp0000288258 29 0 0 0 0 0 0 26,426 199 1,716,058 0 0 contagem.public.usuarios 26 0 0 0 0 0 0 134 102 54,455 0 0 rio.public.temp0000288361 23 0 0 0 0 0 0 12,586 181 917,933 0 0 rio.public.usuarios 22 8 0 0 0 0 0 249 97 194,812 7 8 rio.pg_catalog.pg_index 18 18 0 0 0 0 0 1,004 298 332,876 60 133 rio.public.temp0000288341 16 0 0 0 0 0 0 6,285 81 384,221 0 0 rio.public.temp0000288130 16 0 0 0 0 0 0 914 318 452,090 0 0 rio.public.temp0000288373 14 0 0 0 0 0 0 19,007 1,776 3,352,386 0 0 rio.public.temp0000288128 14 0 0 0 0 0 0 1,012 174 227,038 0 0 rio.public.temp0000288268 14 0 0 0 0 0 0 12,099 49 721,828 0 0 rio.pg_catalog.pg_depend 14 14 0 0 0 0 0 4,188 1,475 2,162,688 102 792 contagem.pg_catalog.pg_attribute 13 13 0 0 0 0 0 6,996 1,989 3,482,512 22 508 rio.public.temp0000288304 11 0 0 0 0 0 0 415 56 33,741 0 0 rio.pg_catalog.pg_statistic 10 10 0 0 0 0 0 11,954 3,675 14,870,192 1,983 9,041 brasilia.pg_catalog.pg_attribute 8 8 0 0 0 0 0 3,682 1,209 1,819,326 70 1,664 contagem.public.temp0000226812 8 0 0 0 0 0 0 881 48 59,657 0 0 rio.public.temp0000288363 7 0 0 0 0 0 0 3,472 23 208,744 0 0 contagem.pg_catalog.pg_class 7 7 0 0 0 0 0 1,231 298 452,891 10 25 rio.public.temp0000288136 6 0 0 0 0 0 0 458 34 32,622 0 0 contagem.pg_catalog.pg_type 6 6 0 0 0 0 0 570 176 268,706 3 6 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 226 90 86,721 4 5 rio.public.temp0000288330 5 0 0 0 0 0 0 5,182 18 308,623 0 0 template1.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 710 230 353,380 75 182 rio.public.temp0000288387 5 0 0 0 0 0 0 1,743 16 105,592 0 0 rio.public.temp0000288367 4 0 0 0 0 0 0 16 12 3,096 0 0 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 885 310 454,859 14 72 rio.public.temp0000288146 4 0 0 0 0 0 0 256 22 18,848 0 0 brasilia.pg_catalog.pg_type 4 4 0 0 0 0 0 333 116 170,004 11 60 rio.public.temp0000288162 4 0 0 0 0 0 0 373 24 25,613 0 0 rio.public.tmp_drill_0175 4 2 0 0 0 0 0 16,411 6 2,623,005 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,217 649 3,307,256 188 579 contagem.pg_catalog.pg_depend 4 4 0 0 0 0 0 1,158 343 705,619 8 33 rio.public.temp0000288278 3 0 0 0 0 0 0 1,803 13 108,410 0 0 brasilia.pg_catalog.pg_index 3 3 0 0 0 0 0 157 60 39,887 3 9 rio.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 401 124 223,915 15 28 rio.public.temp0000288343 3 0 0 0 0 0 0 92 12 7,409 0 0 rio.public.temp0000288355 3 0 0 0 0 0 0 1,733 10 103,926 0 0 rio.public.temp0000288369 3 0 0 0 0 0 0 1,734 10 103,985 0 0 rio.public.temp0000288280 3 0 0 0 0 0 0 1,735 12 104,315 0 0 rio.public.temp0000288290 3 0 0 0 0 0 0 118 16 9,501 0 0 rio.public.temp0000288298 3 0 0 0 0 0 0 12 9 2,322 0 0 rio.public.tmp_drill_0173 2 2 0 0 0 0 0 1,144 6 206,246 0 0 rio.public.temp0000288286 2 0 0 0 0 0 0 89 9 6,681 0 0 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,856 199 853,478 162 1,417 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,548 1,042 3,837,502 867 5,705 brasilia.public.temp0000238100 2 0 0 0 0 0 0 249 8 16,252 0 0 rio.public.temp0000288349 2 0 0 0 0 0 0 153 11 10,951 0 0 rio.public.temp0000288377 2 0 0 0 0 0 0 184 12 12,706 0 0 rio.public.temp0000288300 2 0 0 0 0 0 0 150 12 10,632 0 0 rio.public.tmp_drill_0320 2 1 0 0 0 0 0 40 26 35,119 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 312 83 385,602 34 81 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 286 6 46,007 0 0 brasilia.public.temp0000238134 2 0 0 0 0 0 0 491 8 30,168 0 0 rio.auditor.auditor_2026_08 2 0 0 0 0 0 0 193,122 89,711 117,300,179 51,958 1,034,063 rio.public.codigos_barra 1 1 0 0 0 0 0 210,248 173,558 708,904,960 1,384 74,094 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 29,026 13,169 16,986,599 7,873 164,442 contagem.public.nf_entrada 1 1 0 0 0 0 0 160 78 129,358 6 13 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 461 157 169,905 2 42 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 158 7 19,302 0 0 brasilia.public.temp0000238164 1 0 0 0 0 0 0 245 4 15,058 0 0 rio.public.temp0000288347 1 0 0 0 0 0 0 8 5 1,414 0 0 rio.public.temp0000288274 1 0 0 0 0 0 0 8 5 1,280 0 0 brasilia.public.temp0000238152 1 0 0 0 0 0 0 245 4 15,058 0 0 rio.public.temp0000288270 1 0 0 0 0 0 0 8 5 1,280 0 0 rio.public.temp0000288328 1 0 0 0 0 0 0 78 6 5,495 0 0 contagem.public.lotes_saidas 1 1 0 0 0 0 0 43 12 26,846 1 50 brasilia.public.lotes_saidas 1 1 0 0 0 0 0 135 86 307,646 3 7 rio.public.temp0000288399 1 0 0 0 0 0 0 100 6 6,838 0 0 brasilia.public.temp0000238130 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 22,541 11,470 15,343,706 5,579 114,169 rio.public.temp0000288154 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.lote_itens 1 1 0 0 0 0 0 241,285 187,603 710,086,374 4,537 182,622 brasilia.public.temp0000238154 1 0 0 0 0 0 0 245 4 15,058 0 0 brasilia.public.temp0000238108 1 0 0 0 0 0 0 245 4 15,058 0 0 rio.public.temp0000288357 1 0 0 0 0 0 0 85 6 5,926 0 0 brasilia.public.nf_entrada 1 1 0 0 0 0 0 163 73 179,281 4 5 rio.public.temp0000288351 1 0 0 0 0 0 0 85 6 5,926 0 0 Total 594 239 0 0 0 0 0 892,318 499,955 1,628,267,220 75,498 1,599,296 Vacuum throughput per table
Key values
- public.codigos_barra (100.93) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.11 rio.pg_catalog.pg_class 0 0 1.11 rio.pg_catalog.pg_type 0 0 0.38 rio.public.temp0000288258 0 0 1.17 contagem.public.usuarios 0 0 0 rio.public.temp0000288361 0 0 0.85 rio.public.usuarios 0 0 0 rio.pg_catalog.pg_index 0 0 0.27 rio.public.temp0000288341 0 0 0.45 rio.public.temp0000288130 0 0 0.28 rio.public.temp0000288373 0 0 0.77 rio.public.temp0000288128 0 0 0.23 rio.public.temp0000288268 0 0 0.73 rio.pg_catalog.pg_depend 0 0 1.37 contagem.pg_catalog.pg_attribute 0 0 1.52 rio.public.temp0000288304 0 0 0.22 rio.pg_catalog.pg_statistic 0 0 1.67 brasilia.pg_catalog.pg_attribute 0 0 1.05 contagem.public.temp0000226812 0 0 0.12 rio.public.temp0000288363 0 0 0.36 contagem.pg_catalog.pg_class 0 0 0.48 rio.public.temp0000288136 0 0 0.12 contagem.pg_catalog.pg_type 0 0 0.25 contagem.pg_catalog.pg_index 0 0 0.31 rio.public.temp0000288330 0 0 0.25 template1.pg_catalog.pg_shdepend 0 0 0.75 rio.public.temp0000288387 0 0 0.26 rio.public.temp0000288367 0 0 0.18 brasilia.pg_catalog.pg_class 0 0 0.34 rio.public.temp0000288146 0 0 0.08 brasilia.pg_catalog.pg_type 0 0 0.17 rio.public.temp0000288162 0 0 0.07 rio.public.tmp_drill_0175 0 0 1.23 rio.pg_toast.pg_toast_2619 0 0 0.23 contagem.pg_catalog.pg_depend 0 0 0.29 rio.public.temp0000288278 0 0 0.12 brasilia.pg_catalog.pg_index 0 0 0.19 rio.pg_catalog.pg_shdepend 0 0 0.19 rio.public.temp0000288343 0 0 0.12 rio.public.temp0000288355 0 0 0.15 rio.public.temp0000288369 0 0 0.13 rio.public.temp0000288280 0 0 0.12 rio.public.temp0000288290 0 0 0.05 rio.public.temp0000288298 0 0 0.17 rio.public.tmp_drill_0173 0 0 0.05 rio.public.temp0000288286 0 0 0.02 contagem.pg_catalog.pg_statistic 0 0 0.13 brasilia.pg_catalog.pg_statistic 0 0 0.31 brasilia.public.temp0000238100 0 0 0.02 rio.public.temp0000288349 0 0 0.04 rio.public.temp0000288377 0 0 0.04 rio.public.temp0000288300 0 0 0.04 rio.public.tmp_drill_0320 0 0 0 brasilia.pg_toast.pg_toast_2619 0 0 0.03 rio.public.tmp_drill_0302 0 0 0.01 brasilia.public.temp0000238134 0 0 0.01 rio.auditor.auditor_2026_08 0 0 32.42 rio.public.codigos_barra 0 0 100.93 contagem.auditor.auditor_2026_08 0 0 4.8 contagem.public.nf_entrada 0 0 0.06 brasilia.pg_catalog.pg_depend 0 0 0.12 contagem.pg_toast.pg_toast_2619 0 0 0.02 brasilia.public.temp0000238164 0 0 0.01 rio.public.temp0000288347 0 0 0.02 rio.public.temp0000288274 0 0 0.02 brasilia.public.temp0000238152 0 0 0.01 rio.public.temp0000288270 0 0 0.01 rio.public.temp0000288328 0 0 0.02 contagem.public.lotes_saidas 0 0 0.04 brasilia.public.lotes_saidas 0 0 0.09 rio.public.temp0000288399 0 0 0.02 brasilia.public.temp0000238130 0 0 0 brasilia.auditor.auditor_2026_08 0 0 3.96 rio.public.temp0000288154 0 0 0.05 rio.public.lote_itens 0 0 85.35 brasilia.public.temp0000238154 0 0 0.01 brasilia.public.temp0000238108 0 0 0 rio.public.temp0000288357 0 0 0.01 brasilia.public.nf_entrada 0 0 0.09 rio.public.temp0000288351 0 0 0.01 Total 0 0 251.68 Tuples removed per table
Key values
- public.tmp_drill_0175 (252129) Main table with removed tuples on database rio
- 711312 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.public.tmp_drill_0175 4 2 252,129 1,241,385 494,628 0 18,766 rio.pg_catalog.pg_attribute 75 43 205,457 2,059,668 325,594 255 49,228 contagem.pg_catalog.pg_attribute 13 13 46,930 304,043 0 42 7,002 rio.public.lote_itens 1 1 39,859 6,225,462 0 0 90,569 brasilia.pg_catalog.pg_attribute 8 8 31,355 176,485 1,458 0 4,476 rio.public.codigos_barra 1 1 18,510 10,079,740 0 0 71,486 rio.public.tmp_drill_0173 2 2 16,982 17,084 0 0 429 rio.auditor.auditor_2026_08 2 0 16,441 15,643,088 0 0 746,279 rio.pg_catalog.pg_statistic 10 10 16,215 86,149 1,346 0 12,860 rio.pg_catalog.pg_depend 14 14 12,570 274,525 6,909 0 2,618 rio.pg_catalog.pg_type 52 28 9,452 140,822 20,198 8 3,801 contagem.pg_catalog.pg_statistic 2 2 5,303 14,857 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 4,965 15,403 0 0 2,144 rio.pg_catalog.pg_class 57 31 4,392 252,888 50,099 0 7,988 rio.pg_catalog.pg_index 18 18 4,327 36,232 1,304 0 995 contagem.pg_catalog.pg_depend 4 4 3,869 75,980 0 0 684 template1.pg_catalog.pg_shdepend 5 5 3,499 68,345 453 0 595 contagem.pg_catalog.pg_class 7 7 3,445 30,124 0 58 1,293 rio.pg_catalog.pg_shdepend 3 3 2,861 40,874 5 0 357 contagem.pg_catalog.pg_type 6 6 1,768 13,498 0 5 385 contagem.public.usuarios 26 0 1,625 624 0 0 52 brasilia.pg_catalog.pg_class 4 4 1,619 13,561 0 18 488 brasilia.auditor.auditor_2026_08 1 0 1,380 1,996,126 0 0 88,946 rio.pg_toast.pg_toast_2619 4 4 1,118 2,794 18 81 816 brasilia.pg_catalog.pg_type 4 4 923 8,888 0 16 242 contagem.pg_catalog.pg_index 5 5 914 9,485 0 0 253 brasilia.public.nf_entrada 1 1 886 4,775 0 0 152 brasilia.pg_catalog.pg_depend 1 1 872 17,941 0 0 178 rio.public.usuarios 22 8 637 14,451 3,253 0 352 brasilia.pg_catalog.pg_index 3 3 350 5,619 0 10 139 contagem.public.nf_entrada 1 1 324 1,003 0 0 79 brasilia.pg_toast.pg_toast_2619 2 2 179 285 1 26 96 contagem.pg_toast.pg_toast_2619 1 1 135 113 0 20 42 contagem.public.lotes_saidas 1 1 15 273 0 0 5 brasilia.public.lotes_saidas 1 1 6 4,610 0 0 62 rio.public.temp0000288367 4 0 0 97,356 0 0 6,912 contagem.auditor.auditor_2026_08 1 0 0 1,711,313 0 0 79,821 rio.public.temp0000288278 3 0 0 49,861 0 61 3,523 rio.public.temp0000288136 6 0 0 32,343 0 240 720 rio.public.temp0000288286 2 0 0 6,323 0 51 141 brasilia.public.temp0000238164 1 0 0 3,208 0 0 256 rio.public.temp0000288347 1 0 0 7,253 0 29 163 rio.public.temp0000288274 1 0 0 1,253 0 62 66 rio.public.temp0000288146 4 0 0 23,937 0 104 536 brasilia.public.temp0000238152 1 0 0 3,208 0 0 256 rio.public.temp0000288373 14 0 0 340,878 0 0 24,192 rio.public.temp0000288270 1 0 0 1,253 0 62 66 rio.public.temp0000288128 14 0 0 64,013 0 433 1,423 rio.public.temp0000288330 5 0 0 121,583 0 0 8,640 rio.public.temp0000288363 7 0 0 170,352 0 0 12,096 brasilia.public.temp0000238100 2 0 0 6,412 0 0 512 rio.public.temp0000288328 1 0 0 1,308 0 58 70 rio.public.temp0000288162 4 0 0 15,420 0 171 341 rio.public.temp0000288349 2 0 0 12,647 0 102 282 rio.public.temp0000288377 2 0 0 3,105 0 88 168 rio.public.temp0000288268 14 0 0 340,408 0 0 24,192 rio.public.temp0000288361 23 0 0 354,367 0 419 24,925 contagem.public.temp0000226812 8 0 0 10,604 0 208 816 rio.public.temp0000288304 11 0 0 60,928 0 296 2,712 rio.public.temp0000288343 3 0 0 50,089 0 52 3,532 rio.public.temp0000288341 16 0 0 175,367 0 474 10,022 rio.public.temp0000288300 2 0 0 2,509 0 122 134 rio.public.temp0000288399 1 0 0 1,731 0 36 92 brasilia.public.temp0000238130 1 0 0 3,207 0 0 256 rio.public.temp0000288130 16 0 0 72,213 0 575 1,601 rio.public.temp0000288355 3 0 0 72,969 0 0 5,184 rio.public.tmp_drill_0320 2 1 0 1,416 472 0 26 rio.public.temp0000288369 3 0 0 73,001 0 0 5,184 rio.public.temp0000288280 3 0 0 49,870 0 61 3,523 rio.public.temp0000288154 1 0 0 24,308 0 0 1,728 brasilia.public.temp0000238154 1 0 0 3,208 0 0 256 rio.public.temp0000288258 29 0 0 474,547 0 595 33,517 rio.public.tmp_drill_0302 2 2 0 4,946 0 0 124 brasilia.public.temp0000238108 1 0 0 3,206 0 0 256 brasilia.public.temp0000238134 2 0 0 6,415 0 0 512 rio.public.temp0000288387 5 0 0 121,740 0 0 8,640 rio.public.temp0000288357 1 0 0 1,427 0 51 77 rio.public.temp0000288290 3 0 0 11,998 0 119 265 rio.public.temp0000288298 3 0 0 72,912 0 0 5,184 rio.public.temp0000288351 1 0 0 1,427 0 51 77 Total 594 239 711,312 43,545,039 905,738 5,059 1,388,898 Pages removed per table
Key values
- public.temp0000288258 (595) Main table with removed pages on database rio
- 5059 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000288258 29 0 0 595 rio.public.temp0000288130 16 0 0 575 rio.public.temp0000288341 16 0 0 474 rio.public.temp0000288128 14 0 0 433 rio.public.temp0000288361 23 0 0 419 rio.public.temp0000288304 11 0 0 296 rio.pg_catalog.pg_attribute 75 43 205457 255 rio.public.temp0000288136 6 0 0 240 contagem.public.temp0000226812 8 0 0 208 rio.public.temp0000288162 4 0 0 171 rio.public.temp0000288300 2 0 0 122 rio.public.temp0000288290 3 0 0 119 rio.public.temp0000288146 4 0 0 104 rio.public.temp0000288349 2 0 0 102 rio.public.temp0000288377 2 0 0 88 rio.pg_toast.pg_toast_2619 4 4 1118 81 rio.public.temp0000288274 1 0 0 62 rio.public.temp0000288270 1 0 0 62 rio.public.temp0000288278 3 0 0 61 rio.public.temp0000288280 3 0 0 61 rio.public.temp0000288328 1 0 0 58 contagem.pg_catalog.pg_class 7 7 3445 58 rio.public.temp0000288343 3 0 0 52 rio.public.temp0000288286 2 0 0 51 rio.public.temp0000288357 1 0 0 51 rio.public.temp0000288351 1 0 0 51 contagem.pg_catalog.pg_attribute 13 13 46930 42 rio.public.temp0000288399 1 0 0 36 rio.public.temp0000288347 1 0 0 29 brasilia.pg_toast.pg_toast_2619 2 2 179 26 contagem.pg_toast.pg_toast_2619 1 1 135 20 brasilia.pg_catalog.pg_class 4 4 1619 18 brasilia.pg_catalog.pg_type 4 4 923 16 brasilia.pg_catalog.pg_index 3 3 350 10 rio.pg_catalog.pg_type 52 28 9452 8 contagem.pg_catalog.pg_type 6 6 1768 5 rio.public.tmp_drill_0173 2 2 16982 0 rio.public.temp0000288367 4 0 0 0 rio.public.codigos_barra 1 1 18510 0 contagem.auditor.auditor_2026_08 1 0 0 0 brasilia.pg_catalog.pg_attribute 8 8 31355 0 contagem.public.nf_entrada 1 1 324 0 brasilia.pg_catalog.pg_depend 1 1 872 0 contagem.pg_catalog.pg_index 5 5 914 0 rio.pg_catalog.pg_statistic 10 10 16215 0 brasilia.public.temp0000238164 1 0 0 0 contagem.pg_catalog.pg_statistic 2 2 5303 0 brasilia.pg_catalog.pg_statistic 2 2 4965 0 brasilia.public.temp0000238152 1 0 0 0 rio.public.temp0000288373 14 0 0 0 rio.pg_catalog.pg_shdepend 3 3 2861 0 rio.public.temp0000288330 5 0 0 0 rio.public.temp0000288363 7 0 0 0 brasilia.public.temp0000238100 2 0 0 0 contagem.public.lotes_saidas 1 1 15 0 brasilia.public.lotes_saidas 1 1 6 0 template1.pg_catalog.pg_shdepend 5 5 3499 0 rio.public.temp0000288268 14 0 0 0 rio.public.tmp_drill_0175 4 2 252129 0 rio.pg_catalog.pg_index 18 18 4327 0 contagem.pg_catalog.pg_depend 4 4 3869 0 brasilia.public.temp0000238130 1 0 0 0 rio.public.usuarios 22 8 637 0 brasilia.auditor.auditor_2026_08 1 0 1380 0 rio.public.temp0000288355 3 0 0 0 rio.public.tmp_drill_0320 2 1 0 0 rio.public.temp0000288369 3 0 0 0 rio.public.temp0000288154 1 0 0 0 rio.pg_catalog.pg_class 57 31 4392 0 rio.public.lote_itens 1 1 39859 0 brasilia.public.temp0000238154 1 0 0 0 rio.public.tmp_drill_0302 2 2 0 0 brasilia.public.temp0000238108 1 0 0 0 brasilia.public.temp0000238134 2 0 0 0 contagem.public.usuarios 26 0 1625 0 rio.public.temp0000288387 5 0 0 0 rio.auditor.auditor_2026_08 2 0 16441 0 rio.pg_catalog.pg_depend 14 14 12570 0 brasilia.public.nf_entrada 1 1 886 0 rio.public.temp0000288298 3 0 0 0 Total 594 239 711,312 5,059 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 13 00 0 0 01 0 5 02 0 0 03 0 0 04 0 0 05 6 3 06 0 0 07 24 48 08 30 69 09 53 107 10 47 111 11 55 129 12 28 50 13 18 57 14 94 147 15 98 167 16 87 98 17 51 90 18 1 3 19 0 0 20 0 0 21 2 3 22 0 0 23 0 0 - 100.93 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 10 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 7 24m36s 9s534ms 6m52s 3m30s select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 14:39:46 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028443, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 15:49:01 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-13 14:45:02 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 2 3m46s 1m27s 2m19s 1m53s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 09:37:34 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 07:16:41 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 00:05:34 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 1 1s8ms 1s8ms 1s8ms 1s8ms drop table if exists temp0000288268;-
DROP TABLE IF EXISTS temp0000288268;
Date: 2026-08-13 12:13:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
DROP TABLE IF EXISTS temp0000288268;
Date: 2026-08-13 11:52:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Queries that waited the most
Rank Wait time Query 1 6m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 14:34:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 4m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-13 14:39:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 4m22s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028443, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 15:43:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 3m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 14:45:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 3m7s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028448, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 16:00:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 2m19s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-13 09:37:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 2m6s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028406, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 11:59:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 1m27s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-13 07:16:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 9s534ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028435, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 15:12:43 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 1s8ms DROP TABLE IF EXISTS temp0000288268;[ Date: 2026-08-13 12:13:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,151 Total read queries
- 1,509 Total write queries
Queries by database
Key values
- rio Main database
- 4,473 Requests
- 9h14m25s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,600 1h59m58s copy to 134 13m12s ddl 223 2m12s others 249 11m40s select 994 1h32m53s contagem Total 1,127 16m40s copy to 58 49s616ms ddl 84 40s48ms others 5 3m22s select 980 11m47s postgres Total 2 325ms others 1 150ms select 1 175ms rio Total 4,473 9h14m25s copy to 154 36m19s ddl 856 1h7m others 287 39m4s select 3,176 6h52m Queries by user
Key values
- intelifix Main user
- 6,984 Requests
User Request type Count Duration etiquetas Total 87 19s169ms select 87 19s169ms intelifix Total 6,984 11h29m16s copy to 346 50m21s ddl 1,163 1h9m52s others 541 54m8s select 4,934 8h34m54s lenon Total 131 1m28s others 1 150ms select 130 1m28s Duration by user
Key values
- 11h29m16s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 87 19s169ms select 87 19s169ms intelifix Total 6,984 11h29m16s copy to 346 50m21s ddl 1,163 1h9m52s others 541 54m8s select 4,934 8h34m54s lenon Total 131 1m28s others 1 150ms select 130 1m28s Queries by host
Key values
- [local] Main host
- 7,198 Requests
- 11h31m3s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,051 Requests
- 5h45m36s ([unknown])
- Main time consuming application
Application Request type Count Duration [unknown] Total 6,051 5h45m36s ddl 1,163 1h9m52s select 4,888 4h35m43s pgAdmin 4 - CONN:8483557 Total 2 436ms select 2 436ms pgAdmin 4 - DB:postgres Total 2 325ms others 1 150ms select 1 175ms pg_dump Total 364 50m25s copy to 346 50m21s select 18 4s110ms psql Total 783 4h55m2s others 541 54m8s select 242 4h53s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-13 16:30:56 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,669 100-500ms duration
Slowest individual queries
Rank Duration Query 1 12m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 14:39:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 10m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 16:15:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 15:15:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m20s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028443, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 15:49:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 10m9s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-13 14:45:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 10m analyze verbose;[ Date: 2026-08-13 05:10:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 9m58s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 07:14:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 9m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028448, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 16:06:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 9m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 09:14:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 9m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 10:14:24 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 9m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 08:14:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 9m3s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 14:50:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 9m2s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 18:14:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 8m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 20:13:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 8m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 11:13:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 8m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 17:13:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 8m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 12:13:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 7m40s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028406, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-13 12:04:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 7m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-13 14:34:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 7m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-13 14:12:28 - 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 3h35m40s 291 150ms 12m5s 44s467ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 13 07 15 18m33s 1m14s 08 14 14m16s 1m1s 09 15 12m51s 51s451ms 10 12 14m4s 1m10s 11 33 17m38s 32s67ms 12 27 22m11s 49s316ms 13 21 12s522ms 596ms 14 45 51m10s 1m8s 15 53 35m34s 40s281ms 16 30 23m34s 47s155ms 17 24 5m26s 13s596ms 18 2 4s478ms 2s239ms [ User: intelifix - Total duration: 3h35m40s - Times executed: 291 ]
[ Application: [unknown] - Total duration: 3h35m40s - Times executed: 291 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 14:39:46 Duration: 12m5s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028443, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 15:49:01 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-13 14:45:02 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 2h25m59s 48 1s655ms 10m45s 3m2s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 13 07 3 10m48s 3m36s 08 3 9m42s 3m14s 09 3 10m24s 3m28s 10 3 10m1s 3m20s 11 3 9m21s 3m7s 12 3 9m 3m 13 3 7m7s 2m22s 14 3 7m56s 2m38s 15 3 11m18s 3m46s 16 3 11m31s 3m50s 17 3 9m9s 3m3s 18 3 9m37s 3m12s 19 3 6m32s 2m10s 20 3 9m15s 3m5s 21 3 7m39s 2m33s 22 3 6m30s 2m10s [ User: intelifix - Total duration: 2h25m59s - Times executed: 48 ]
[ Application: psql - Total duration: 2h25m59s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-13 16:15:47 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-13 15:15:30 Duration: 10m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-13 07:14:59 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 1h24m51s 48 238ms 5m21s 1m46s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 13 07 3 6m1s 2m 08 3 4m39s 1m33s 09 3 6m41s 2m13s 10 3 6m3s 2m1s 11 3 5m53s 1m57s 12 3 5m39s 1m53s 13 3 4m34s 1m31s 14 3 5m 1m40s 15 3 6m28s 2m9s 16 3 5m48s 1m56s 17 3 5m48s 1m56s 18 3 4m33s 1m31s 19 3 4m5s 1m21s 20 3 5m6s 1m42s 21 3 4m10s 1m23s 22 3 4m15s 1m25s [ User: intelifix - Total duration: 1h24m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h24m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-13 09:21:59 Duration: 5m21s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-13 15:22:36 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-13 10:20:59 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 21m30s 1,259 150ms 5s589ms 1s25ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 13 07 48 57s156ms 1s190ms 08 116 1m39s 861ms 09 134 2m18s 1s37ms 10 162 2m57s 1s92ms 11 127 2m8s 1s13ms 12 19 16s585ms 872ms 13 55 53s831ms 978ms 14 146 3m1s 1s241ms 15 185 3m10s 1s27ms 16 176 2m47s 952ms 17 91 1m19s 874ms [ User: intelifix - Total duration: 21m30s - Times executed: 1259 ]
[ Application: [unknown] - Total duration: 21m30s - Times executed: 1259 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277321, 450, '833312945004145,230034571421,230014118997,230052829207,230050666874,230029605369,230029603753,230027638386,230007623538,229975219500,229987853539,230052231214,229977403350,230019554949,230020749600,230039030622,230052807386,230044475967,229987829900,229987762846,229977048286,230013923143,230030005060,229979459409,229979127782,229991599707,230034580715,229977103444,230053258901,229965828998,229982465774,230052853856,230010931830,230051331721,230051328992,230022280828,229977001818,230050160406,230014124958,230051484362,230041914954', '',0295,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-08-13 14:20:30 Duration: 5s589ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277310, 450, '258165115088181,216882372948,216439853049,216840302546,216687310926,216831543251,216417077593,216901503434,216892453247,216539382740,216567323435,216915744162,216667697181,216795672242,216895618291,216885619617,216530093741,216847142641,216884203654,216913157893,216916499600,216704446065,216915102023,216529612527,216645551418,216646438383,216473514953,216849988686,216830541021,216852435267,216829269819,216884430624,216366461229,216321998695,216535864147,216705004257,216890163652,216884513740,216892312728,216731005773,216415937796', '',064,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-08-13 14:33:48 Duration: 5s524ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277310, 450, '258102115152932,216852175870,216602284142,216915416273,216916324858,216529670311,216603522838,216647749006,216666693234,216441738383,216415703756,216821813042,216890715961,216665957393,216880967894,216537432931,216621174852,216567012642,216933203756,216728444558,216880974966,216757575257,216684312440,216644894451,216443837982,216443909000,216771083153,216567835157,216795343343,216840247994,216643067179,216880575151,216605125867,216441857183,216805144243,216605067578,216768618691,216793548600,216366393545,216849210520,216855418498', '',064,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-08-13 11:25:35 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 18m57s 3 2m53s 10m 6m19s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 13 05 3 18m57s 6m19s [ User: intelifix - Total duration: 18m57s - Times executed: 3 ]
[ Application: psql - Total duration: 18m57s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-13 05:10:01 Duration: 10m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-08-13 05:16:04 Duration: 6m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-08-13 05:18:58 Duration: 2m53s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 16m33s 276 211ms 2m24s 3s597ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 13 00 12 43s395ms 3s616ms 01 12 27s804ms 2s317ms 02 12 30s501ms 2s541ms 03 12 31s733ms 2s644ms 04 12 28s209ms 2s350ms 05 12 33s261ms 2s771ms 06 12 28s414ms 2s367ms 07 12 2m 10s33ms 08 12 32s989ms 2s749ms 09 12 2m55s 14s593ms 10 12 36s94ms 3s7ms 11 12 41s784ms 3s482ms 12 12 33s680ms 2s806ms 13 12 31s14ms 2s584ms 14 12 30s898ms 2s574ms 15 12 40s234ms 3s352ms 16 12 35s250ms 2s937ms 17 12 31s663ms 2s638ms 18 12 29s880ms 2s490ms 19 12 30s907ms 2s575ms 20 12 38s837ms 3s236ms 21 12 30s353ms 2s529ms 22 12 30s579ms 2s548ms [ User: intelifix - Total duration: 16m33s - Times executed: 276 ]
[ Application: psql - Total duration: 16m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 09:37:34 Duration: 2m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 07:16:41 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 00:05:34 Duration: 13s439ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 14m 62 9s987ms 27s490ms 13s558ms create table temp0000288258 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 13 07 23 4m59s 13s7ms 08 6 1m25s 14s171ms 09 15 3m18s 13s230ms 10 9 2m3s 13s753ms 11 9 2m14s 14s906ms [ User: intelifix - Total duration: 14m - Times executed: 62 ]
[ Application: [unknown] - Total duration: 14m - Times executed: 62 ]
-
CREATE TABLE temp0000288258 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:24:55 Duration: 27s490ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288258 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 10:02:07 Duration: 16s552ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288258 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 10:02:54 Duration: 16s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 9m52s 1,100 150ms 4s861ms 538ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 13 07 63 35s972ms 570ms 08 99 1m13s 737ms 09 122 1m12s 592ms 10 143 1m14s 522ms 11 155 1m8s 441ms 12 9 5s851ms 650ms 13 106 1m2s 590ms 14 133 1m2s 468ms 15 102 55s1ms 539ms 16 105 49s940ms 475ms 17 62 31s693ms 511ms 18 1 1s65ms 1s65ms [ User: intelifix - Total duration: 9m52s - Times executed: 1100 ]
[ Application: [unknown] - Total duration: 9m52s - Times executed: 1100 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "277289", "modelo" : "318", "itens" : "843C9920802B,F4E84F8A76A6,14CA56D56D7F,3CF9F0AD1C58,3CF9F0A9DBD2,4896D94FF9D6,14CA56CF9563,48D6822E8676,14CA56CCE843,4896D953DAFA,,D682*119BC,3CF9F0AC72BA,3CF9F0AC704A,389148504DB7,3CF9F0AC1A64,689E29BE6B21,4896D957CEB4,14CA56D4B799,48D68235803C,4896D9560438", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-13 08:44:39 Duration: 4s861ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "159", "itens" : "229650254957,229650776882,229682339817,229650023442,229653406667,229652476060,229682416266,229762855172,229757560324,229681112537,229759375775,229651436879,229681116274,229654833945,229683142129,229682904855,229680228095,229680105760,229653375980,229762550620,229684088393,229760063048,229762565671,229654841017,229654390816,229682973347,229759274553,229679963547,229758793642,229680971132,229683994950", "usuario" : "414", "caixa" : "1297960", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-13 08:48:45 Duration: 3s494ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "277705", "modelo" : "141", "itens" : "229736148199,229727430324,229933165160,229726298204,229786013246,229755761719,229815665567,229690491825,229785012632,229744751520,229671331616,229739593452,229781961515,229687089203,229807757275,229691195058,229809552648,229739946168,229859394964,229924884352,229816101525,229750874463,229879615164,216941628595,229668566789,229745381941,229814884851,229865499600", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246526577085,246506832948,226273673851,246516841725,246602716379,246586337889,246136492136,246516227691,246586595266,246547295572,246489963546,246527426472,246585660922,246143513842,246595650202,246236451117,246627852222,226154896366,246235593244,246092730514,246636144445,246562820915,246652451638,246471194060,246515754761,246547395660,246631057697,246653639597,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-13 16:25:26 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 9m52s 62 1s378ms 36s929ms 9s558ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 13 07 3 48s623ms 16s207ms 08 2 24s544ms 12s272ms 09 2 29s933ms 14s966ms 10 6 1m9s 11s536ms 11 8 51s156ms 6s394ms 12 2 5s847ms 2s923ms 13 6 36s882ms 6s147ms 14 6 1m18s 13s162ms 15 9 1m30s 10s18ms 16 8 1m28s 11s113ms 17 8 1m1s 7s643ms 18 2 7s235ms 3s617ms [ User: intelifix - Total duration: 9m52s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 9m52s - Times executed: 62 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-13', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-13 07:54:08 Duration: 36s929ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-13', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-13 16:39:03 Duration: 34s427ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-13', 0395, '', '', 0, 6, '2026-08-01');
Date: 2026-08-13 15:23:23 Duration: 30s737ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 9m38s 161 183ms 19s730ms 3s590ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 13 00 6 31s831ms 5s305ms 01 6 14s921ms 2s486ms 02 6 10s309ms 1s718ms 03 5 11s846ms 2s369ms 04 6 13s36ms 2s172ms 05 4 13s431ms 3s357ms 07 11 48s343ms 4s394ms 08 12 1m1s 5s146ms 09 12 1m 5s70ms 10 12 49s805ms 4s150ms 11 11 50s740ms 4s612ms 12 12 46s984ms 3s915ms 13 8 9s732ms 1s216ms 14 12 49s219ms 4s101ms 15 12 46s651ms 3s887ms 16 10 22s571ms 2s257ms 17 5 8s456ms 1s691ms 21 5 12s8ms 2s401ms 22 6 15s587ms 2s597ms [ User: intelifix - Total duration: 9m38s - Times executed: 161 ]
[ Application: psql - Total duration: 9m38s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 00:05:20 Duration: 19s730ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 07:45:14 Duration: 12s482ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 08:15:12 Duration: 11s575ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 9m18s 42 11s757ms 15s143ms 13s305ms create table temp0000288361 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 13 14 10 2m10s 13s54ms 15 28 6m16s 13s445ms 16 4 51s792ms 12s948ms [ User: intelifix - Total duration: 9m18s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 9m18s - Times executed: 42 ]
-
CREATE TABLE temp0000288361 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:05:13 Duration: 15s143ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288361 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:45:53 Duration: 14s899ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288361 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:53:08 Duration: 14s868ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 7m45s 35 11s157ms 15s930ms 13s301ms create table temp0000288268 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 13 11 14 3m16s 14s29ms 12 19 4m4s 12s853ms 14 2 24s918ms 12s459ms [ User: intelifix - Total duration: 7m45s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m45s - Times executed: 35 ]
-
CREATE TABLE temp0000288268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:43:50 Duration: 15s930ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:46:32 Duration: 15s816ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:44:11 Duration: 15s681ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 5m28s 763 150ms 3s116ms 430ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 13 13 25 17s870ms 714ms 14 93 46s714ms 502ms 15 382 3m6s 487ms 16 129 41s42ms 318ms 17 134 36s800ms 274ms [ User: intelifix - Total duration: 5m28s - Times executed: 763 ]
[ Application: [unknown] - Total duration: 5m28s - Times executed: 763 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133035","seriais":"241765418608,241764147282,241776676889,241778564043,241767895370,241778571014,241747230627,241745447982,241765424646,241765525363,241765414769,241765413355,241776680830,241776669616,241738834554,241743243851,241743190816,241743365052,241747233657,241747380821,241765526878,241771011017,241743211929,241778568386,241764363847,241740546281,241777949000,241776518893,241777968597,241747251414,241738795358,241814179618,241740540928,241776651029,241765423434,241740747692","usuario":"399","observacao":""}');
Date: 2026-08-13 15:49:00 Duration: 3s116ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133035","seriais":"241775597479,241776815466,241813988790,241765621636,241814536577,241771256876,241767914867,241746643240,241742670608,241768007580,241767998185,241743293654,241771468692,241739548798,241778634353,241765533243,241742625979,241778468703,241771511526,241771444549,241743339315,241764422439,241778756486,241744537680,241743215666,241742848201,241739536777,241813277677,241738726283,241775545050,241771306275,241771210206,241738278810,241743340909,241738645770,241778779596,241775668800,241813975658,241775313737,241765415476","usuario":"399","observacao":""}');
Date: 2026-08-13 15:12:26 Duration: 3s11ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133035","seriais":"241758107882,241734660713,241722984051,241793278991,241734672532,241790834051,241758108488,241791621233,241787116875,241725801936,241757349212,241753913355,241752388188,241725820019,241782058491,241787245272,241753899616,241722372241,241794779610,241789644148,241791499098,241722912529,241750325260,241791335065,241720437281,241737118708,241791347086,241791342743,241789631319,241734690312,241789642128,241784636476,241791447780,241780568605,241787263961,241754230513,241791628304","usuario":"399","observacao":""}');
Date: 2026-08-13 15:15:16 Duration: 2s336ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 4m43s 83 211ms 1m 3s417ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 13 07 8 6s145ms 768ms 08 2 1s587ms 793ms 09 6 1m3s 10s621ms 10 4 7s284ms 1s821ms 11 12 32s668ms 2s722ms 12 6 13s90ms 2s181ms 13 2 485ms 242ms 14 15 30s717ms 2s47ms 15 19 34s869ms 1s835ms 16 4 7s324ms 1s831ms 17 5 1m25s 17s147ms [ User: intelifix - Total duration: 4m43s - Times executed: 83 ]
[ Application: psql - Total duration: 4m43s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028390);
Date: 2026-08-13 09:35:28 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028455);
Date: 2026-08-13 17:17:37 Duration: 44s232ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028454);
Date: 2026-08-13 17:14:47 Duration: 34s381ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 4m19s 20 10s211ms 15s7ms 12s957ms create table temp0000288373 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 13 15 7 1m34s 13s537ms 16 2 28s114ms 14s57ms 17 11 2m16s 12s389ms [ User: intelifix - Total duration: 4m19s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m19s - Times executed: 20 ]
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:25:08 Duration: 15s7ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 16:01:13 Duration: 14s940ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 17:29:09 Duration: 14s507ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 3m44s 46 284ms 20s616ms 4s872ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 13 07 4 32s981ms 8s245ms 08 1 9s890ms 9s890ms 09 5 20s356ms 4s71ms 10 3 16s31ms 5s343ms 11 8 39s940ms 4s992ms 12 2 9s320ms 4s660ms 14 8 43s16ms 5s377ms 15 10 36s102ms 3s610ms 16 2 7s951ms 3s975ms 17 3 8s558ms 2s852ms [ User: intelifix - Total duration: 3m44s - Times executed: 46 ]
[ Application: psql - Total duration: 3m44s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028377);
Date: 2026-08-13 07:10:07 Duration: 20s616ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028442);
Date: 2026-08-13 15:35:55 Duration: 17s403ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028395);
Date: 2026-08-13 10:46:16 Duration: 13s424ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 3m44s 15 11s716ms 42s473ms 14s934ms create table temp0000288341 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 13 13 4 1m18s 19s582ms 14 11 2m25s 13s243ms [ User: intelifix - Total duration: 3m44s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m44s - Times executed: 15 ]
-
CREATE TABLE temp0000288341 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 13:56:39 Duration: 42s473ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288341 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:56:45 Duration: 14s347ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288341 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:53:29 Duration: 14s343ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 3m33s 4 5s251ms 1m43s 53s345ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 13 20 2 1m48s 54s196ms 23 2 1m44s 52s494ms [ User: intelifix - Total duration: 3m33s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m33s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-13 20:09:36 Duration: 1m43s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-13 23:17:38 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-13 23:39:56 Duration: 5s500ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
19 3m21s 57 2s826ms 5s180ms 3s534ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 13 08 5 21s369ms 4s273ms 09 4 14s180ms 3s545ms 10 5 18s184ms 3s636ms 11 3 11s398ms 3s799ms 12 3 10s649ms 3s549ms 13 4 13s410ms 3s352ms 14 3 10s775ms 3s591ms 15 4 12s999ms 3s249ms 16 5 16s474ms 3s294ms 17 4 15s405ms 3s851ms 18 3 9s360ms 3s120ms 19 3 10s129ms 3s376ms 20 4 13s638ms 3s409ms 21 4 14s100ms 3s525ms 22 3 9s401ms 3s133ms [ User: intelifix - Total duration: 3m21s - Times executed: 57 ]
[ Application: psql - Total duration: 3m21s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-13 08:20:11 Duration: 5s180ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-13 17:20:10 Duration: 5s93ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-13 08:00:06 Duration: 4s657ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
20 2m54s 13 12s202ms 14s990ms 13s393ms create table temp0000288363 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 13 14 4 51s922ms 12s980ms 15 9 2m2s 13s577ms [ User: intelifix - Total duration: 2m54s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m54s - Times executed: 13 ]
-
CREATE TABLE temp0000288363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:33:19 Duration: 14s990ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:58:08 Duration: 14s587ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:12:07 Duration: 14s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,259 21m30s 150ms 5s589ms 1s25ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 13 07 48 57s156ms 1s190ms 08 116 1m39s 861ms 09 134 2m18s 1s37ms 10 162 2m57s 1s92ms 11 127 2m8s 1s13ms 12 19 16s585ms 872ms 13 55 53s831ms 978ms 14 146 3m1s 1s241ms 15 185 3m10s 1s27ms 16 176 2m47s 952ms 17 91 1m19s 874ms [ User: intelifix - Total duration: 21m30s - Times executed: 1259 ]
[ Application: [unknown] - Total duration: 21m30s - Times executed: 1259 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277321, 450, '833312945004145,230034571421,230014118997,230052829207,230050666874,230029605369,230029603753,230027638386,230007623538,229975219500,229987853539,230052231214,229977403350,230019554949,230020749600,230039030622,230052807386,230044475967,229987829900,229987762846,229977048286,230013923143,230030005060,229979459409,229979127782,229991599707,230034580715,229977103444,230053258901,229965828998,229982465774,230052853856,230010931830,230051331721,230051328992,230022280828,229977001818,230050160406,230014124958,230051484362,230041914954', '',0295,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-08-13 14:20:30 Duration: 5s589ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277310, 450, '258165115088181,216882372948,216439853049,216840302546,216687310926,216831543251,216417077593,216901503434,216892453247,216539382740,216567323435,216915744162,216667697181,216795672242,216895618291,216885619617,216530093741,216847142641,216884203654,216913157893,216916499600,216704446065,216915102023,216529612527,216645551418,216646438383,216473514953,216849988686,216830541021,216852435267,216829269819,216884430624,216366461229,216321998695,216535864147,216705004257,216890163652,216884513740,216892312728,216731005773,216415937796', '',064,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-08-13 14:33:48 Duration: 5s524ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277310, 450, '258102115152932,216852175870,216602284142,216915416273,216916324858,216529670311,216603522838,216647749006,216666693234,216441738383,216415703756,216821813042,216890715961,216665957393,216880967894,216537432931,216621174852,216567012642,216933203756,216728444558,216880974966,216757575257,216684312440,216644894451,216443837982,216443909000,216771083153,216567835157,216795343343,216840247994,216643067179,216880575151,216605125867,216441857183,216805144243,216605067578,216768618691,216793548600,216366393545,216849210520,216855418498', '',064,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-08-13 11:25:35 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1,100 9m52s 150ms 4s861ms 538ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 13 07 63 35s972ms 570ms 08 99 1m13s 737ms 09 122 1m12s 592ms 10 143 1m14s 522ms 11 155 1m8s 441ms 12 9 5s851ms 650ms 13 106 1m2s 590ms 14 133 1m2s 468ms 15 102 55s1ms 539ms 16 105 49s940ms 475ms 17 62 31s693ms 511ms 18 1 1s65ms 1s65ms [ User: intelifix - Total duration: 9m52s - Times executed: 1100 ]
[ Application: [unknown] - Total duration: 9m52s - Times executed: 1100 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "277289", "modelo" : "318", "itens" : "843C9920802B,F4E84F8A76A6,14CA56D56D7F,3CF9F0AD1C58,3CF9F0A9DBD2,4896D94FF9D6,14CA56CF9563,48D6822E8676,14CA56CCE843,4896D953DAFA,,D682*119BC,3CF9F0AC72BA,3CF9F0AC704A,389148504DB7,3CF9F0AC1A64,689E29BE6B21,4896D957CEB4,14CA56D4B799,48D68235803C,4896D9560438", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-13 08:44:39 Duration: 4s861ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "108194", "modelo" : "159", "itens" : "229650254957,229650776882,229682339817,229650023442,229653406667,229652476060,229682416266,229762855172,229757560324,229681112537,229759375775,229651436879,229681116274,229654833945,229683142129,229682904855,229680228095,229680105760,229653375980,229762550620,229684088393,229760063048,229762565671,229654841017,229654390816,229682973347,229759274553,229679963547,229758793642,229680971132,229683994950", "usuario" : "414", "caixa" : "1297960", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-13 08:48:45 Duration: 3s494ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "277705", "modelo" : "141", "itens" : "229736148199,229727430324,229933165160,229726298204,229786013246,229755761719,229815665567,229690491825,229785012632,229744751520,229671331616,229739593452,229781961515,229687089203,229807757275,229691195058,229809552648,229739946168,229859394964,229924884352,229816101525,229750874463,229879615164,216941628595,229668566789,229745381941,229814884851,229865499600", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246526577085,246506832948,226273673851,246516841725,246602716379,246586337889,246136492136,246516227691,246586595266,246547295572,246489963546,246527426472,246585660922,246143513842,246595650202,246236451117,246627852222,226154896366,246235593244,246092730514,246636144445,246562820915,246652451638,246471194060,246515754761,246547395660,246631057697,246653639597,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-13 16:25:26 Duration: 2s505ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 763 5m28s 150ms 3s116ms 430ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 13 13 25 17s870ms 714ms 14 93 46s714ms 502ms 15 382 3m6s 487ms 16 129 41s42ms 318ms 17 134 36s800ms 274ms [ User: intelifix - Total duration: 5m28s - Times executed: 763 ]
[ Application: [unknown] - Total duration: 5m28s - Times executed: 763 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133035","seriais":"241765418608,241764147282,241776676889,241778564043,241767895370,241778571014,241747230627,241745447982,241765424646,241765525363,241765414769,241765413355,241776680830,241776669616,241738834554,241743243851,241743190816,241743365052,241747233657,241747380821,241765526878,241771011017,241743211929,241778568386,241764363847,241740546281,241777949000,241776518893,241777968597,241747251414,241738795358,241814179618,241740540928,241776651029,241765423434,241740747692","usuario":"399","observacao":""}');
Date: 2026-08-13 15:49:00 Duration: 3s116ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133035","seriais":"241775597479,241776815466,241813988790,241765621636,241814536577,241771256876,241767914867,241746643240,241742670608,241768007580,241767998185,241743293654,241771468692,241739548798,241778634353,241765533243,241742625979,241778468703,241771511526,241771444549,241743339315,241764422439,241778756486,241744537680,241743215666,241742848201,241739536777,241813277677,241738726283,241775545050,241771306275,241771210206,241738278810,241743340909,241738645770,241778779596,241775668800,241813975658,241775313737,241765415476","usuario":"399","observacao":""}');
Date: 2026-08-13 15:12:26 Duration: 3s11ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133035","seriais":"241758107882,241734660713,241722984051,241793278991,241734672532,241790834051,241758108488,241791621233,241787116875,241725801936,241757349212,241753913355,241752388188,241725820019,241782058491,241787245272,241753899616,241722372241,241794779610,241789644148,241791499098,241722912529,241750325260,241791335065,241720437281,241737118708,241791347086,241791342743,241789631319,241734690312,241789642128,241784636476,241791447780,241780568605,241787263961,241754230513,241791628304","usuario":"399","observacao":""}');
Date: 2026-08-13 15:15:16 Duration: 2s336ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 291 3h35m40s 150ms 12m5s 44s467ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 13 07 15 18m33s 1m14s 08 14 14m16s 1m1s 09 15 12m51s 51s451ms 10 12 14m4s 1m10s 11 33 17m38s 32s67ms 12 27 22m11s 49s316ms 13 21 12s522ms 596ms 14 45 51m10s 1m8s 15 53 35m34s 40s281ms 16 30 23m34s 47s155ms 17 24 5m26s 13s596ms 18 2 4s478ms 2s239ms [ User: intelifix - Total duration: 3h35m40s - Times executed: 291 ]
[ Application: [unknown] - Total duration: 3h35m40s - Times executed: 291 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 14:39:46 Duration: 12m5s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028443, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 15:49:01 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-13 14:45:02 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 276 16m33s 211ms 2m24s 3s597ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 13 00 12 43s395ms 3s616ms 01 12 27s804ms 2s317ms 02 12 30s501ms 2s541ms 03 12 31s733ms 2s644ms 04 12 28s209ms 2s350ms 05 12 33s261ms 2s771ms 06 12 28s414ms 2s367ms 07 12 2m 10s33ms 08 12 32s989ms 2s749ms 09 12 2m55s 14s593ms 10 12 36s94ms 3s7ms 11 12 41s784ms 3s482ms 12 12 33s680ms 2s806ms 13 12 31s14ms 2s584ms 14 12 30s898ms 2s574ms 15 12 40s234ms 3s352ms 16 12 35s250ms 2s937ms 17 12 31s663ms 2s638ms 18 12 29s880ms 2s490ms 19 12 30s907ms 2s575ms 20 12 38s837ms 3s236ms 21 12 30s353ms 2s529ms 22 12 30s579ms 2s548ms [ User: intelifix - Total duration: 16m33s - Times executed: 276 ]
[ Application: psql - Total duration: 16m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 09:37:34 Duration: 2m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 07:16:41 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 00:05:34 Duration: 13s439ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 161 9m38s 183ms 19s730ms 3s590ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 13 00 6 31s831ms 5s305ms 01 6 14s921ms 2s486ms 02 6 10s309ms 1s718ms 03 5 11s846ms 2s369ms 04 6 13s36ms 2s172ms 05 4 13s431ms 3s357ms 07 11 48s343ms 4s394ms 08 12 1m1s 5s146ms 09 12 1m 5s70ms 10 12 49s805ms 4s150ms 11 11 50s740ms 4s612ms 12 12 46s984ms 3s915ms 13 8 9s732ms 1s216ms 14 12 49s219ms 4s101ms 15 12 46s651ms 3s887ms 16 10 22s571ms 2s257ms 17 5 8s456ms 1s691ms 21 5 12s8ms 2s401ms 22 6 15s587ms 2s597ms [ User: intelifix - Total duration: 9m38s - Times executed: 161 ]
[ Application: psql - Total duration: 9m38s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 00:05:20 Duration: 19s730ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 07:45:14 Duration: 12s482ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 08:15:12 Duration: 11s575ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 151 33s587ms 150ms 554ms 222ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 13 01 13 3s55ms 235ms 05 19 5s56ms 266ms 07 16 3s672ms 229ms 08 22 5s250ms 238ms 09 12 2s724ms 227ms 10 7 1s382ms 197ms 11 15 2s982ms 198ms 12 10 1s940ms 194ms 13 2 321ms 160ms 14 14 3s31ms 216ms 15 15 2s944ms 196ms 16 5 1s40ms 208ms 17 1 187ms 187ms [ User: intelifix - Total duration: 33s587ms - Times executed: 151 ]
[ Application: [unknown] - Total duration: 33s587ms - Times executed: 151 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241789222637,241794147191,241794312034,241790297174,241794171010,241750304854,241750346878,241725564965,241780518701,241750335665,241782031823,241757323553,241794320722,241758104549,241724799098,241753757783', NULL, NULL, 0463, 00);
Date: 2026-08-13 05:04:03 Duration: 554ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241794492130,241782515360,241751089409,241724053235,241757031123,241781450319,241735019816,241735315860,241722311326,241720344747,241749931025,241749943551,241722315063,241718985961,241705074155,241758116974', NULL, NULL, 0463, 00);
Date: 2026-08-13 05:05:02 Duration: 442ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_TRIAGEM (404, 5, '113', 3, '229723675063,216856374462,216855965454,216886981939,229659197075,216903904555,229658052026,216903217080,229659171215,229647937177,229721602235', NULL, NULL, 0131, 00);
Date: 2026-08-13 11:47:13 Duration: 440ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 127 57s152ms 154ms 832ms 450ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 13 07 5 1s864ms 372ms 08 11 4s860ms 441ms 09 8 3s824ms 478ms 10 6 2s850ms 475ms 11 11 5s541ms 503ms 12 11 4s757ms 432ms 13 2 684ms 342ms 14 24 10s665ms 444ms 15 22 10s514ms 477ms 16 11 4s888ms 444ms 17 14 5s998ms 428ms 18 2 702ms 351ms [ User: intelifix - Total duration: 57s152ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 57s152ms - Times executed: 127 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-13 15:07:04 Duration: 832ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-08-13 09:43:13 Duration: 782ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-13 11:29:11 Duration: 714ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 121 58s13ms 280ms 823ms 479ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 13 00 1 400ms 400ms 01 1 334ms 334ms 05 3 1s373ms 457ms 06 1 387ms 387ms 07 10 4s493ms 449ms 08 10 5s273ms 527ms 09 11 5s926ms 538ms 10 11 5s65ms 460ms 11 10 4s806ms 480ms 12 5 2s74ms 414ms 13 10 4s498ms 449ms 14 13 6s824ms 524ms 15 13 6s564ms 504ms 16 8 3s304ms 413ms 17 11 5s18ms 456ms 21 2 1s223ms 611ms 23 1 442ms 442ms [ User: lenon - Total duration: 58s13ms - Times executed: 121 ]
[ Application: [unknown] - Total duration: 58s13ms - Times executed: 121 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-13 08:38:51 Duration: 823ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-13 14:14:01 Duration: 797ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-08-13 15:26:14 Duration: 781ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 113 25s678ms 150ms 2s529ms 227ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 13 01 1 245ms 245ms 05 1 476ms 476ms 07 1 173ms 173ms 08 2 439ms 219ms 09 1 184ms 184ms 10 5 1s72ms 214ms 11 7 3s761ms 537ms 12 7 1s480ms 211ms 13 3 583ms 194ms 14 10 2s99ms 209ms 15 20 4s438ms 221ms 16 26 5s159ms 198ms 17 29 5s563ms 191ms [ User: intelifix - Total duration: 25s678ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 25s678ms - Times executed: 113 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-08-13", "data-ate" : "2026-08-13", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 417 }');
Date: 2026-08-13 11:35:20 Duration: 2s529ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-08-13", "data-ate" : "2026-08-13", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-08-13 17:14:48 Duration: 533ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "428", "data-de" : "2026-08-13", "data-ate" : "2026-08-13", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 499 }');
Date: 2026-08-13 05:06:18 Duration: 476ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 111 1m6s 375ms 1s65ms 602ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 13 00 1 862ms 862ms 01 1 462ms 462ms 05 3 1s938ms 646ms 07 6 3s442ms 573ms 08 10 6s467ms 646ms 09 11 7s176ms 652ms 10 11 6s384ms 580ms 11 10 6s186ms 618ms 12 5 2s557ms 511ms 13 9 5s22ms 558ms 14 12 7s473ms 622ms 15 12 7s534ms 627ms 16 8 4s217ms 527ms 17 11 6s80ms 552ms 23 1 1s41ms 1s41ms [ User: intelifix - Total duration: 1m6s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 111 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-13 15:26:14 Duration: 1s65ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-08-13 23:33:57 Duration: 1s41ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-13 14:14:01 Duration: 958ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 83 4m43s 211ms 1m 3s417ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 13 07 8 6s145ms 768ms 08 2 1s587ms 793ms 09 6 1m3s 10s621ms 10 4 7s284ms 1s821ms 11 12 32s668ms 2s722ms 12 6 13s90ms 2s181ms 13 2 485ms 242ms 14 15 30s717ms 2s47ms 15 19 34s869ms 1s835ms 16 4 7s324ms 1s831ms 17 5 1m25s 17s147ms [ User: intelifix - Total duration: 4m43s - Times executed: 83 ]
[ Application: psql - Total duration: 4m43s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028390);
Date: 2026-08-13 09:35:28 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028455);
Date: 2026-08-13 17:17:37 Duration: 44s232ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028454);
Date: 2026-08-13 17:14:47 Duration: 34s381ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 83 18s744ms 152ms 448ms 225ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 13 08 2 649ms 324ms 09 4 1s22ms 255ms 10 1 326ms 326ms 11 6 1s403ms 233ms 12 4 987ms 246ms 13 15 3s274ms 218ms 14 17 3s757ms 221ms 15 18 4s1ms 222ms 16 11 2s250ms 204ms 17 5 1s71ms 214ms [ User: intelifix - Total duration: 18s744ms - Times executed: 83 ]
[ Application: [unknown] - Total duration: 18s744ms - Times executed: 83 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"303", "usuario" :"428", "tipo" :"N", "itens" :"015", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-13 14:26:56 Duration: 448ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"189", "usuario" :"507", "tipo" :"N", "itens" :"001", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-13 08:05:52 Duration: 434ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"303", "usuario" :"428", "tipo" :"N", "itens" :"015", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-08-13 13:06:41 Duration: 418ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 80 1m4s 167ms 10s607ms 810ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 13 07 6 4s460ms 743ms 11 17 11s414ms 671ms 12 14 7s182ms 513ms 13 14 9s983ms 713ms 14 5 4s981ms 996ms 15 15 12s138ms 809ms 16 9 14s686ms 1s631ms [ User: intelifix - Total duration: 1m4s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 1m4s - Times executed: 80 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133035) LIMIT 1;
Date: 2026-08-13 16:38:32 Duration: 10s607ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0277289) LIMIT 1;
Date: 2026-08-13 14:12:26 Duration: 3s467ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0277363) LIMIT 1;
Date: 2026-08-13 15:59:00 Duration: 1s957ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 72 11s669ms 150ms 236ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 13 05 1 171ms 171ms 07 1 172ms 172ms 08 3 511ms 170ms 09 11 1s745ms 158ms 10 13 2s69ms 159ms 11 9 1s448ms 160ms 12 2 309ms 154ms 13 6 937ms 156ms 14 6 949ms 158ms 15 12 1s990ms 165ms 16 7 1s127ms 161ms 17 1 236ms 236ms [ User: intelifix - Total duration: 11s669ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 11s669ms - Times executed: 72 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0151;
Date: 2026-08-13 17:44:51 Duration: 236ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0295;
Date: 2026-08-13 15:14:16 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-08-13 15:55:01 Duration: 189ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 67 19s260ms 151ms 2s20ms 287ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 13 08 1 161ms 161ms 09 19 5s247ms 276ms 10 17 4s387ms 258ms 11 6 1s217ms 202ms 13 4 2s800ms 700ms 14 7 2s484ms 354ms 15 6 1s551ms 258ms 16 4 809ms 202ms 17 3 601ms 200ms [ User: intelifix - Total duration: 19s260ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 19s260ms - Times executed: 67 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'ZTEGD9710FB8,ZTEGD970E682,ZTEGD97B15AD,ZTEGD7BBB63C,ZTEGDB00C9DA,ZTEGD9710352,ZTEGD9716598,ZTEGD7BBE1F3,ZTEGD97B51C9,48D68232D2A4,843C9932DE8D,14CA56D54F8B,D89A0D84E39D,4896D956E754,4896D9501F68,4896D95427D4,48D682325486,4896D9506960,5872C9947087,D831399B01B0,F4E84F896C90,F4E84F8218A0,F4E84F8103CE,843C99363C17,5872C99465C5,D89A0DA38979,14CA56CCEB91,5872C9943D81,6C11BA65B4C1,14CA56D4EEB3,4896D958B224,D8313921AC50,6C11BA6BB905,F4E84F898508,4896D9540D28,843C992C73AD,3CF9F0AE656E,3CF9F06FDBA5,D89A0D84FFC3,4896D9571130,D89A0DACD437,48D68237F420,14CA56D2C0B9,6C11BA6891B7,14CA56D6C547,F4E84F834E30,14CA56D044A7,F4E84F897BDE,D89A0DA4C9A1,3CF9F0AB0268,3891484C0933,843C992E3A93,3891484C2E95,4896D95605CA,C4EBFF8A9EA6,3CF9F070C545,D831399B54C0,48D6823AA6A4,C4EBFF8D2A60,4896D95A3362,F4E84F83017A,F4E84F897EC0', '76;1', 'DEFAULT', 09, 0318, '','', '', 00);
Date: 2026-08-13 13:59:43 Duration: 2s20ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '9877E70C2A1E,743AEF95AE33,743AEFC59F2A,743AEFAC01A2,9877E7BBAF0F,84011205A811,743AEFDCB0DC,840112935D63,9877E77E1CB9,743AEFAF0BCF,9877E74EEA2F,1834AF28A1B6,743AEFABCF05,743AEF957912', '77;1', 'DEFAULT', 09, 0153, '','', '', 00);
Date: 2026-08-13 10:46:06 Duration: 756ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 7, '4896D9571130,D89A0DACD437,D89A0D84FFC3,3CF9F06FDBA5,3CF9F0AE656E,843C992C73AD,4896D9540D28,F4E84F898508,14CA56D54F8B,843C9932DE8D,48D68232D2A4,6C11BA6BB905,D8313921AC50,4896D958B224,4896D95A3362,C4EBFF8A9EA6,4896D95605CA,3891484C2E95,843C992E3A93,3891484C0933,3CF9F0AB0268,F4E84F87855E,3891484FA7C1,C4EBFF8D2A60,48D6823AA6A4,3CF9F070C545,D831399B01B0,5872C9947087,4896D9506960,48D682325486,4896D95427D4,4896D9501F68,4896D956E754,D89A0D84E39D,14CA56D4EEB3,6C11BA65B4C1,5872C9943D81,14CA56CCEB91,D89A0DA38979,5872C99465C5,843C99363C17,F4E84F8103CE,F4E84F8218A0,F4E84F896C90,F4E84F83017A,F4E84F897EC0', '113;1', 'DEFAULT', 00, 0318, '','', '', 00);
Date: 2026-08-13 14:11:00 Duration: 657ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 65 13s332ms 151ms 693ms 205ms select * from rs_etiqueta (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 13 07 7 1s438ms 205ms 08 6 1s197ms 199ms 09 12 2s391ms 199ms 10 9 1s744ms 193ms 11 7 1s367ms 195ms 12 9 1s718ms 190ms 14 8 1s731ms 216ms 15 2 334ms 167ms 16 4 1s205ms 301ms 17 1 202ms 202ms [ User: etiquetas - Total duration: 13s332ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 13s332ms - Times executed: 65 ]
-
SELECT * FROM RS_ETIQUETA ('582FF71740DD');
Date: 2026-08-13 16:32:43 Duration: 693ms Database: brasilia User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_ETIQUETA (829263938000067);
Date: 2026-08-13 07:01:16 Duration: 327ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_ETIQUETA ('929240917682');
Date: 2026-08-13 14:45:50 Duration: 292ms Database: rio User: etiquetas Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 65 13s254ms 152ms 290ms 203ms create table temp0000288154 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 13 08 16 3s510ms 219ms 09 16 3s435ms 214ms 10 1 152ms 152ms 11 1 154ms 154ms 12 2 323ms 161ms 13 1 207ms 207ms 14 14 2s685ms 191ms 15 12 2s421ms 201ms 17 2 363ms 181ms [ User: intelifix - Total duration: 13s254ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 13s254ms - Times executed: 65 ]
-
CREATE TABLE temp0000288154 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-08-2026", "ate" :"13-08-2026", "nota-fiscal":"2139", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-13 09:00:58 Duration: 290ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288154 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-08-2026", "ate" :"13-08-2026", "nota-fiscal":"394", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-13 15:29:16 Duration: 275ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288154 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"08-08-2026", "ate" :"13-08-2026", "nota-fiscal":"2139", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-13 08:39:05 Duration: 271ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
19 64 20s672ms 153ms 1s19ms 323ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 13 08 6 3s801ms 633ms 09 1 198ms 198ms 10 24 8s387ms 349ms 11 6 1s190ms 198ms 12 1 253ms 253ms 13 3 868ms 289ms 14 12 3s278ms 273ms 15 6 1s586ms 264ms 16 4 874ms 218ms 17 1 233ms 233ms [ User: intelifix - Total duration: 20s672ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 20s672ms - Times executed: 64 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2521431 ORDER BY A.CAI_ORDEM;
Date: 2026-08-13 08:52:50 Duration: 1s19ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2528287 ORDER BY A.CAI_ORDEM;
Date: 2026-08-13 08:38:33 Duration: 930ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3438561 ORDER BY A.CAI_ORDEM;
Date: 2026-08-13 10:35:00 Duration: 739ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
20 63 15s158ms 153ms 1s302ms 240ms create table temp0000238132 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 13 14 7 3s130ms 447ms 15 7 1s688ms 241ms 16 6 1s458ms 243ms 17 41 8s422ms 205ms 18 2 458ms 229ms [ User: intelifix - Total duration: 15s158ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 15s158ms - Times executed: 63 ]
-
CREATE TABLE temp0000238132 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "08-08-2026", "data-ate" : "13-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-13 14:20:20 Duration: 1s302ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000238132 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "08-08-2026", "data-ate" : "13-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-13 14:26:05 Duration: 590ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000238132 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "08-08-2026", "data-ate" : "13-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-13 14:30:50 Duration: 529ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m53s 10m 6m19s 3 18m57s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 13 05 3 18m57s 6m19s [ User: intelifix - Total duration: 18m57s - Times executed: 3 ]
[ Application: psql - Total duration: 18m57s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-13 05:10:01 Duration: 10m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-08-13 05:16:04 Duration: 6m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
analyze verbose;
Date: 2026-08-13 05:18:58 Duration: 2m53s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 1s655ms 10m45s 3m2s 48 2h25m59s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 13 07 3 10m48s 3m36s 08 3 9m42s 3m14s 09 3 10m24s 3m28s 10 3 10m1s 3m20s 11 3 9m21s 3m7s 12 3 9m 3m 13 3 7m7s 2m22s 14 3 7m56s 2m38s 15 3 11m18s 3m46s 16 3 11m31s 3m50s 17 3 9m9s 3m3s 18 3 9m37s 3m12s 19 3 6m32s 2m10s 20 3 9m15s 3m5s 21 3 7m39s 2m33s 22 3 6m30s 2m10s [ User: intelifix - Total duration: 2h25m59s - Times executed: 48 ]
[ Application: psql - Total duration: 2h25m59s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-13 16:15:47 Duration: 10m45s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-13 15:15:30 Duration: 10m28s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-13 07:14:59 Duration: 9m58s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 238ms 5m21s 1m46s 48 1h24m51s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 13 07 3 6m1s 2m 08 3 4m39s 1m33s 09 3 6m41s 2m13s 10 3 6m3s 2m1s 11 3 5m53s 1m57s 12 3 5m39s 1m53s 13 3 4m34s 1m31s 14 3 5m 1m40s 15 3 6m28s 2m9s 16 3 5m48s 1m56s 17 3 5m48s 1m56s 18 3 4m33s 1m31s 19 3 4m5s 1m21s 20 3 5m6s 1m42s 21 3 4m10s 1m23s 22 3 4m15s 1m25s [ User: intelifix - Total duration: 1h24m51s - Times executed: 48 ]
[ Application: psql - Total duration: 1h24m51s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-13 09:21:59 Duration: 5m21s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-13 15:22:36 Duration: 5m9s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-13 10:20:59 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 5s251ms 1m43s 53s345ms 4 3m33s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 13 20 2 1m48s 54s196ms 23 2 1m44s 52s494ms [ User: intelifix - Total duration: 3m33s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m33s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-13 20:09:36 Duration: 1m43s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-13 23:17:38 Duration: 1m39s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-13 23:39:56 Duration: 5s500ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 150ms 12m5s 44s467ms 291 3h35m40s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 13 07 15 18m33s 1m14s 08 14 14m16s 1m1s 09 15 12m51s 51s451ms 10 12 14m4s 1m10s 11 33 17m38s 32s67ms 12 27 22m11s 49s316ms 13 21 12s522ms 596ms 14 45 51m10s 1m8s 15 53 35m34s 40s281ms 16 30 23m34s 47s155ms 17 24 5m26s 13s596ms 18 2 4s478ms 2s239ms [ User: intelifix - Total duration: 3h35m40s - Times executed: 291 ]
[ Application: [unknown] - Total duration: 3h35m40s - Times executed: 291 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028421, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 14:39:46 Duration: 12m5s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028443, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-13 15:49:01 Duration: 10m20s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028420, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-13 14:45:02 Duration: 10m9s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 11s716ms 42s473ms 14s934ms 15 3m44s create table temp0000288341 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 13 13 4 1m18s 19s582ms 14 11 2m25s 13s243ms [ User: intelifix - Total duration: 3m44s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 3m44s - Times executed: 15 ]
-
CREATE TABLE temp0000288341 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 13:56:39 Duration: 42s473ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288341 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:56:45 Duration: 14s347ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288341 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:53:29 Duration: 14s343ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 9s987ms 27s490ms 13s558ms 62 14m create table temp0000288258 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 13 07 23 4m59s 13s7ms 08 6 1m25s 14s171ms 09 15 3m18s 13s230ms 10 9 2m3s 13s753ms 11 9 2m14s 14s906ms [ User: intelifix - Total duration: 14m - Times executed: 62 ]
[ Application: [unknown] - Total duration: 14m - Times executed: 62 ]
-
CREATE TABLE temp0000288258 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:24:55 Duration: 27s490ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288258 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 10:02:07 Duration: 16s552ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288258 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 10:02:54 Duration: 16s400ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 12s202ms 14s990ms 13s393ms 13 2m54s create table temp0000288363 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 13 14 4 51s922ms 12s980ms 15 9 2m2s 13s577ms [ User: intelifix - Total duration: 2m54s - Times executed: 13 ]
[ Application: [unknown] - Total duration: 2m54s - Times executed: 13 ]
-
CREATE TABLE temp0000288363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:33:19 Duration: 14s990ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:58:08 Duration: 14s587ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288363 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:12:07 Duration: 14s358ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 11s757ms 15s143ms 13s305ms 42 9m18s create table temp0000288361 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 13 14 10 2m10s 13s54ms 15 28 6m16s 13s445ms 16 4 51s792ms 12s948ms [ User: intelifix - Total duration: 9m18s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 9m18s - Times executed: 42 ]
-
CREATE TABLE temp0000288361 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:05:13 Duration: 15s143ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288361 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 14:45:53 Duration: 14s899ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288361 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:53:08 Duration: 14s868ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 11s157ms 15s930ms 13s301ms 35 7m45s create table temp0000288268 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 13 11 14 3m16s 14s29ms 12 19 4m4s 12s853ms 14 2 24s918ms 12s459ms [ User: intelifix - Total duration: 7m45s - Times executed: 35 ]
[ Application: [unknown] - Total duration: 7m45s - Times executed: 35 ]
-
CREATE TABLE temp0000288268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:43:50 Duration: 15s930ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:46:32 Duration: 15s816ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288268 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 11:44:11 Duration: 15s681ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 10s211ms 15s7ms 12s957ms 20 4m19s create table temp0000288373 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 13 15 7 1m34s 13s537ms 16 2 28s114ms 14s57ms 17 11 2m16s 12s389ms [ User: intelifix - Total duration: 4m19s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 4m19s - Times executed: 20 ]
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 15:25:08 Duration: 15s7ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 16:01:13 Duration: 14s940ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CREATE TABLE temp0000288373 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-13 17:29:09 Duration: 14s507ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 1s378ms 36s929ms 9s558ms 62 9m52s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 13 07 3 48s623ms 16s207ms 08 2 24s544ms 12s272ms 09 2 29s933ms 14s966ms 10 6 1m9s 11s536ms 11 8 51s156ms 6s394ms 12 2 5s847ms 2s923ms 13 6 36s882ms 6s147ms 14 6 1m18s 13s162ms 15 9 1m30s 10s18ms 16 8 1m28s 11s113ms 17 8 1m1s 7s643ms 18 2 7s235ms 3s617ms [ User: intelifix - Total duration: 9m52s - Times executed: 62 ]
[ Application: [unknown] - Total duration: 9m52s - Times executed: 62 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-13', 0366, '', '', 0, 6, '2026-08-01');
Date: 2026-08-13 07:54:08 Duration: 36s929ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-13', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-13 16:39:03 Duration: 34s427ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-13', 0395, '', '', 0, 6, '2026-08-01');
Date: 2026-08-13 15:23:23 Duration: 30s737ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 284ms 20s616ms 4s872ms 46 3m44s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 13 07 4 32s981ms 8s245ms 08 1 9s890ms 9s890ms 09 5 20s356ms 4s71ms 10 3 16s31ms 5s343ms 11 8 39s940ms 4s992ms 12 2 9s320ms 4s660ms 14 8 43s16ms 5s377ms 15 10 36s102ms 3s610ms 16 2 7s951ms 3s975ms 17 3 8s558ms 2s852ms [ User: intelifix - Total duration: 3m44s - Times executed: 46 ]
[ Application: psql - Total duration: 3m44s - Times executed: 46 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028377);
Date: 2026-08-13 07:10:07 Duration: 20s616ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028442);
Date: 2026-08-13 15:35:55 Duration: 17s403ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028395);
Date: 2026-08-13 10:46:16 Duration: 13s424ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 211ms 2m24s 3s597ms 276 16m33s call rs_giga_triagem (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 13 00 12 43s395ms 3s616ms 01 12 27s804ms 2s317ms 02 12 30s501ms 2s541ms 03 12 31s733ms 2s644ms 04 12 28s209ms 2s350ms 05 12 33s261ms 2s771ms 06 12 28s414ms 2s367ms 07 12 2m 10s33ms 08 12 32s989ms 2s749ms 09 12 2m55s 14s593ms 10 12 36s94ms 3s7ms 11 12 41s784ms 3s482ms 12 12 33s680ms 2s806ms 13 12 31s14ms 2s584ms 14 12 30s898ms 2s574ms 15 12 40s234ms 3s352ms 16 12 35s250ms 2s937ms 17 12 31s663ms 2s638ms 18 12 29s880ms 2s490ms 19 12 30s907ms 2s575ms 20 12 38s837ms 3s236ms 21 12 30s353ms 2s529ms 22 12 30s579ms 2s548ms [ User: intelifix - Total duration: 16m33s - Times executed: 276 ]
[ Application: psql - Total duration: 16m33s - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 09:37:34 Duration: 2m24s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 07:16:41 Duration: 1m33s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-13 00:05:34 Duration: 13s439ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 183ms 19s730ms 3s590ms 161 9m38s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 13 00 6 31s831ms 5s305ms 01 6 14s921ms 2s486ms 02 6 10s309ms 1s718ms 03 5 11s846ms 2s369ms 04 6 13s36ms 2s172ms 05 4 13s431ms 3s357ms 07 11 48s343ms 4s394ms 08 12 1m1s 5s146ms 09 12 1m 5s70ms 10 12 49s805ms 4s150ms 11 11 50s740ms 4s612ms 12 12 46s984ms 3s915ms 13 8 9s732ms 1s216ms 14 12 49s219ms 4s101ms 15 12 46s651ms 3s887ms 16 10 22s571ms 2s257ms 17 5 8s456ms 1s691ms 21 5 12s8ms 2s401ms 22 6 15s587ms 2s597ms [ User: intelifix - Total duration: 9m38s - Times executed: 161 ]
[ Application: psql - Total duration: 9m38s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 00:05:20 Duration: 19s730ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 07:45:14 Duration: 12s482ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-13 08:15:12 Duration: 11s575ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 2s826ms 5s180ms 3s534ms 57 3m21s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 13 08 5 21s369ms 4s273ms 09 4 14s180ms 3s545ms 10 5 18s184ms 3s636ms 11 3 11s398ms 3s799ms 12 3 10s649ms 3s549ms 13 4 13s410ms 3s352ms 14 3 10s775ms 3s591ms 15 4 12s999ms 3s249ms 16 5 16s474ms 3s294ms 17 4 15s405ms 3s851ms 18 3 9s360ms 3s120ms 19 3 10s129ms 3s376ms 20 4 13s638ms 3s409ms 21 4 14s100ms 3s525ms 22 3 9s401ms 3s133ms [ User: intelifix - Total duration: 3m21s - Times executed: 57 ]
[ Application: psql - Total duration: 3m21s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-13 08:20:11 Duration: 5s180ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-13 17:20:10 Duration: 5s93ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-13 08:00:06 Duration: 4s657ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 211ms 1m 3s417ms 83 4m43s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 13 07 8 6s145ms 768ms 08 2 1s587ms 793ms 09 6 1m3s 10s621ms 10 4 7s284ms 1s821ms 11 12 32s668ms 2s722ms 12 6 13s90ms 2s181ms 13 2 485ms 242ms 14 15 30s717ms 2s47ms 15 19 34s869ms 1s835ms 16 4 7s324ms 1s831ms 17 5 1m25s 17s147ms [ User: intelifix - Total duration: 4m43s - Times executed: 83 ]
[ Application: psql - Total duration: 4m43s - Times executed: 83 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028390);
Date: 2026-08-13 09:35:28 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028455);
Date: 2026-08-13 17:17:37 Duration: 44s232ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (028454);
Date: 2026-08-13 17:14:47 Duration: 34s381ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 150ms 5s589ms 1s25ms 1,259 21m30s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 13 07 48 57s156ms 1s190ms 08 116 1m39s 861ms 09 134 2m18s 1s37ms 10 162 2m57s 1s92ms 11 127 2m8s 1s13ms 12 19 16s585ms 872ms 13 55 53s831ms 978ms 14 146 3m1s 1s241ms 15 185 3m10s 1s27ms 16 176 2m47s 952ms 17 91 1m19s 874ms [ User: intelifix - Total duration: 21m30s - Times executed: 1259 ]
[ Application: [unknown] - Total duration: 21m30s - Times executed: 1259 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277321, 450, '833312945004145,230034571421,230014118997,230052829207,230050666874,230029605369,230029603753,230027638386,230007623538,229975219500,229987853539,230052231214,229977403350,230019554949,230020749600,230039030622,230052807386,230044475967,229987829900,229987762846,229977048286,230013923143,230030005060,229979459409,229979127782,229991599707,230034580715,229977103444,230053258901,229965828998,229982465774,230052853856,230010931830,230051331721,230051328992,230022280828,229977001818,230050160406,230014124958,230051484362,230041914954', '',0295,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-08-13 14:20:30 Duration: 5s589ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277310, 450, '258165115088181,216882372948,216439853049,216840302546,216687310926,216831543251,216417077593,216901503434,216892453247,216539382740,216567323435,216915744162,216667697181,216795672242,216895618291,216885619617,216530093741,216847142641,216884203654,216913157893,216916499600,216704446065,216915102023,216529612527,216645551418,216646438383,216473514953,216849988686,216830541021,216852435267,216829269819,216884430624,216366461229,216321998695,216535864147,216705004257,216890163652,216884513740,216892312728,216731005773,216415937796', '',064,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-08-13 14:33:48 Duration: 5s524ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (277310, 450, '258102115152932,216852175870,216602284142,216915416273,216916324858,216529670311,216603522838,216647749006,216666693234,216441738383,216415703756,216821813042,216890715961,216665957393,216880967894,216537432931,216621174852,216567012642,216933203756,216728444558,216880974966,216757575257,216684312440,216644894451,216443837982,216443909000,216771083153,216567835157,216795343343,216840247994,216643067179,216880575151,216605125867,216441857183,216805144243,216605067578,216768618691,216793548600,216366393545,216849210520,216855418498', '',064,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-08-13 11:25:35 Duration: 5s478ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
19 167ms 10s607ms 810ms 80 1m4s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 13 07 6 4s460ms 743ms 11 17 11s414ms 671ms 12 14 7s182ms 513ms 13 14 9s983ms 713ms 14 5 4s981ms 996ms 15 15 12s138ms 809ms 16 9 14s686ms 1s631ms [ User: intelifix - Total duration: 1m4s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 1m4s - Times executed: 80 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133035) LIMIT 1;
Date: 2026-08-13 16:38:32 Duration: 10s607ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0277289) LIMIT 1;
Date: 2026-08-13 14:12:26 Duration: 3s467ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0277363) LIMIT 1;
Date: 2026-08-13 15:59:00 Duration: 1s957ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
20 375ms 1s65ms 602ms 111 1m6s select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 13 00 1 862ms 862ms 01 1 462ms 462ms 05 3 1s938ms 646ms 07 6 3s442ms 573ms 08 10 6s467ms 646ms 09 11 7s176ms 652ms 10 11 6s384ms 580ms 11 10 6s186ms 618ms 12 5 2s557ms 511ms 13 9 5s22ms 558ms 14 12 7s473ms 622ms 15 12 7s534ms 627ms 16 8 4s217ms 527ms 17 11 6s80ms 552ms 23 1 1s41ms 1s41ms [ User: intelifix - Total duration: 1m6s - Times executed: 111 ]
[ Application: [unknown] - Total duration: 1m6s - Times executed: 111 ]
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-13 15:26:14 Duration: 1s65ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
select * from rs_menu_grants (499, 0, 1);
Date: 2026-08-13 23:33:57 Duration: 1s41ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
-
select * from rs_menu_grants (413, 18, 1);
Date: 2026-08-13 14:14:01 Duration: 958ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 160ms 1 160ms 160ms 160ms select * from rs_caixa_qr ();Times Reported Time consuming prepare #1
Day Hour Count Duration Avg duration Aug 13 23 1 160ms 160ms [ User: etiquetas - Total duration: 153ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 153ms - Times executed: 1 ]
-
select * from rs_caixa_qr ();
Date: 2026-08-13 23:36:41 Duration: 160ms Database: postgres User: contagem Remote: etiquetas Application: [local] Queryid: [unknown]
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 13 10 1 0ms 0ms 20 1 0ms 0ms 21 2 0ms 0ms [ User: intelifix - Total duration: 3s11ms - Times executed: 4 ]
[ Application: psql - Total duration: 2s339ms - Times executed: 3 ]
[ Application: [unknown] - Total duration: 672ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 27,431 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 28 FATAL entries
- 7818 ERROR entries
- 0 WARNING entries
- 23 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 7,733 Max number of times the same event was reported
- 7,869 Total events found
Rank Times reported Error 1 7,733 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 13 00 227 01 227 02 231 03 213 04 229 05 229 06 227 07 377 08 472 09 633 10 595 11 661 12 425 13 305 14 519 15 467 16 354 17 275 18 180 19 178 20 179 21 180 22 177 23 173 - ERROR: prepared statement "_PLAN000000002A5D49E0" does not exist
- ERROR: prepared statement "_PLAN0000000029B6C9C0" does not exist
- ERROR: prepared statement "_PLAN000000002A4CE1D0" does not exist
Statement: DEALLOCATE "_PLAN000000002A5D49E0"
Date: 2026-08-13 00:00:07 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: DEALLOCATE "_PLAN0000000029B6C9C0"
Date: 2026-08-13 00:00:19 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: DEALLOCATE "_PLAN000000002A4CE1D0"
Date: 2026-08-13 00:00:29 Database: contagem Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
2 45 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 13 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 1 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-08-13 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-13 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-13 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
3 20 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 13 07 2 09 3 11 2 14 6 15 7 - LOG: process 2480388 still waiting for ShareLock on transaction 4313716 after 1000.262 ms
- LOG: process 2480388 still waiting for ShareLock on transaction 4313716 after 5702.738 ms
- LOG: process 2553077 still waiting for ShareLock on transaction 4325889 after 1000.163 ms
Detail: Process holding the lock: 2480548. Wait queue: 2480388.
Context: while updating tuple (76540,6) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-13 07:15:12 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Detail: Process holding the lock: 2480548. Wait queue: 2480388.
Context: while updating tuple (76540,6) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-13 07:15:17 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Detail: Process holding the lock: 2560277. Wait queue: 2553077.
Context: while updating tuple (76549,4) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-08-13 09:35:15 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
4 15 ERROR: invalid byte sequence for encoding
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 13 11 9 13 3 16 3 - ERROR: invalid byte sequence for encoding "UTF8": 0x90
- ERROR: invalid byte sequence for encoding "UTF8": 0x90
- ERROR: invalid byte sequence for encoding "UTF8": 0x90
Date: 2026-08-13 11:12:06 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 11:12:08 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 11:12:08 Database: contagem Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
5 13 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 13 00 1 01 1 03 1 06 1 07 1 09 1 12 2 13 2 17 3 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-08-13 00:02:17 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 01:58:32 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 03:24:06 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
6 11 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 13 03 11 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-08-13 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
7 7 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 13 09 2 15 3 16 2 - ERROR: syntax error at or near "V" at character 35
- ERROR: syntax error at or near "V" at character 35
- ERROR: syntax error at or near "3450483" at character 35
Statement: select * from rs_caixa_qr(3443930 V)
Date: 2026-08-13 09:41:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: select * from rs_caixa_qr(3443930 V)
Date: 2026-08-13 09:41:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: select * from rs_caixa_qr(3450333 3450483 )
Date: 2026-08-13 15:09:47 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
8 6 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 13 08 2 09 3 10 1 - ERROR: column "f4e84f823316" does not exist at character 27
- ERROR: column "f4e84f823316" does not exist at character 27
- ERROR: column "dc" does not exist at character 27
Statement: select * from rs_caixa_qr(F4E84F823316)
Date: 2026-08-13 08:43:49 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: select * from rs_caixa_qr(F4E84F823316)
Date: 2026-08-13 08:43:49 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-82-D1-C9)
Date: 2026-08-13 09:28:34 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
9 4 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 13 10 4 - ERROR: trailing junk after numeric literal at or near "2C9452D77638" at character 27
- ERROR: trailing junk after numeric literal at or near "2C9452D77638" at character 27
- ERROR: trailing junk after numeric literal at or near "6802B8139BF7" at character 27
Statement: select * from rs_caixa_qr(2C9452D77638)
Date: 2026-08-13 10:22:56 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: select * from rs_caixa_qr(2C9452D77638)
Date: 2026-08-13 10:22:56 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: select * from rs_caixa_qr(6802B8139BF7)
Date: 2026-08-13 10:55:15 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
10 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 13 03 4 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-13 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Date: 2026-08-13 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
11 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 13 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-13 05:32:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-13 05:32:18 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-13 05:32:18 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
12 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 13 08 1 - ERROR: unterminated quoted string at or near "'229894457981'');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('229894457981'');
Date: 2026-08-13 08:50:21 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
13 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 13 03 1 - LOG: database system was shut down at 2026-08-13 03:05:01 -03
Date: 2026-08-13 03:05:02 Log file: /usr/local/pgsql/data/log/serverlog-13.log
14 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 13 07 1 - LOG: skipping analyze of "temp0000288258" --- lock not available
Date: 2026-08-13 07:54:42 Log file: /usr/local/pgsql/data/log/serverlog-13.log
15 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 13 12 1 - LOG: process 2730499 still waiting for AccessExclusiveLock on relation 3776021 of database 358220 after 1000.111 ms
Detail: Process holding the lock: 2751473. Wait queue: 2730499.
Statement: DROP TABLE IF EXISTS temp0000288268;Date: 2026-08-13 12:13:47 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
16 1 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "...", line 21, in <module> os.chmod(...) PL/Python function "..." PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 13 21 1 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv' PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Context: Traceback (most recent call last):
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-13 21:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log
17 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 13 12 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000288268"
Date: 2026-08-13 12:13:47 Log file: /usr/local/pgsql/data/log/serverlog-13.log
18 1 ERROR: function rs_fluxos_lista(...) does not exist
Times Reported Most Frequent Error / Event #18
Day Hour Count Aug 13 15 1 - ERROR: function rs_fluxos_lista(integer, integer, integer, unknown, unknown, integer, unknown, bigint) does not exist at character 46
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: CREATE TABLE temp0000288250 AS SELECT * FROM RS_FLUXOS_LISTA(06,00,0407,'13-08-2026','13-08-2026',0,'229972558398',0229972558398);Date: 2026-08-13 15:31:48 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-13.log