pgBadger-
Global information
- Generated on Thu Aug 20 23:50:16 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 49,195 log entries in 14s
- Log start from 2026-08-20 00:00:03 to 2026-08-20 23:49:52
-
Overview
Global Stats
- 407 Number of unique normalized queries
- 7,356 Number of queries
- 9h25m49s Total query duration
- 2026-08-20 00:02:15 First query
- 2026-08-20 23:46:32 Last query
- 10 queries/s at 2026-08-20 10:17:15 Query peak
- 9h25m49s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9h25m49s Execute total duration
- 4,664 Number of events
- 17 Number of unique normalized events
- 4,547 Max number of times the same event was reported
- 0 Number of cancellation
- 495 Total number of automatic vacuums
- 1,130 Total number of automatic analyzes
- 20 Number temporary file
- 241.76 MiB Max size of temporary file
- 103.62 MiB Average size of temporary file
- 391 Total number of sessions
- 8 sessions at 2026-08-20 08:05:11 Session peak
- 14d5h41m2s Total duration of sessions
- 52m25s Average duration of sessions
- 18 Average queries per session
- 1m26s Average queries duration per session
- 50m59s Average idle time per session
- 403 Total number of connections
- 5 connections/s at 2026-08-20 14:05:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 10 queries/s Query Peak
- 2026-08-20 10:17:15 Date
SELECT Traffic
Key values
- 10 queries/s Query Peak
- 2026-08-20 10:17:15 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-08-20 20:08:31 Date
Queries duration
Key values
- 9h25m49s 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 20 00 50 0ms 20s765ms 3s45ms 6s669ms 20s765ms 1m7s 01 21 0ms 4s564ms 1s728ms 4s656ms 5s951ms 7s203ms 02 18 0ms 5s328ms 2s71ms 4s467ms 6s989ms 7s972ms 03 24 0ms 6s48ms 1s649ms 4s558ms 5s916ms 8s227ms 04 26 0ms 4s887ms 1s343ms 4s174ms 6s77ms 6s610ms 05 23 0ms 9m40s 56s317ms 5s658ms 2m43s 9m40s 06 54 0ms 12s720ms 2s582ms 12s196ms 17s61ms 35s303ms 07 282 0ms 8m38s 7s886ms 1m24s 5m25s 8m43s 08 684 150ms 7m28s 4s474ms 1m31s 6m29s 7m30s 09 908 150ms 9m55s 3s905ms 2m2s 7m38s 11m31s 10 668 151ms 9m56s 5s259ms 4m38s 6m46s 10m13s 11 575 0ms 9m7s 3s867ms 1m34s 4m4s 9m44s 12 164 0ms 7m59s 5s508ms 8s214ms 29s988ms 8m55s 13 448 0ms 6m28s 3s742ms 42s245ms 3m25s 6m54s 14 1,020 150ms 8m31s 3s41ms 1m18s 6m36s 9m5s 15 878 150ms 9m 3s219ms 1m32s 4m58s 9m3s 16 714 150ms 7m54s 2s857ms 46s283ms 4m42s 8m7s 17 227 0ms 7m43s 4s588ms 21s340ms 1m8s 7m49s 18 27 0ms 6m18s 25s11ms 6s772ms 15s798ms 6m51s 19 24 0ms 5m52s 26s959ms 7s136ms 50s286ms 5m52s 20 119 0ms 6m16s 10s372ms 57s206ms 1m52s 6m16s 21 32 0ms 6m5s 20s766ms 7s317ms 8s20ms 6m54s 22 35 0ms 5m49s 18s689ms 7s219ms 49s537ms 5m49s 23 335 0ms 1m32s 6s506ms 1m7s 1m12s 1m32s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 20 00 28 0 1s252ms 219ms 325ms 1s750ms 01 3 0 386ms 0ms 0ms 160ms 02 0 0 0ms 0ms 0ms 0ms 03 6 0 508ms 0ms 0ms 1s 04 10 0 330ms 0ms 210ms 887ms 05 4 0 546ms 0ms 0ms 876ms 06 10 0 2s599ms 0ms 0ms 993ms 07 178 0 9s961ms 4s843ms 39s888ms 6m58s 08 499 0 4s731ms 13s987ms 1m19s 6m50s 09 739 0 3s934ms 13s314ms 1m57s 7m38s 10 489 0 6s132ms 20s478ms 4m33s 6m52s 11 402 0 4s54ms 9s951ms 1m15s 4m32s 12 99 0 8s424ms 2s176ms 3s178ms 3m40s 13 329 0 4s218ms 10s312ms 21s4ms 6m28s 14 781 0 3s186ms 29s245ms 43s137ms 7m17s 15 607 0 3s578ms 27s305ms 1m29s 6m44s 16 506 0 3s455ms 16s427ms 33s511ms 6m5s 17 176 0 5s362ms 6s394ms 14s870ms 4m2s 18 9 0 1m9s 0ms 0ms 3m19s 19 6 0 1m39s 0ms 0ms 3m14s 20 11 90 11s662ms 10s213ms 57s206ms 3m32s 21 9 0 1m7s 0ms 0ms 3m11s 22 11 0 54s143ms 0ms 185ms 3m15s 23 13 322 6s506ms 1m2s 1m7s 1m32s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Aug 20 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 20 00 0 3 3.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 3 3.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 3 3.00 0.00% 07 0 14 14.00 0.00% 08 0 14 14.00 0.00% 09 0 15 15.00 0.00% 10 0 15 15.00 0.00% 11 0 11 11.00 0.00% 12 0 5 5.00 0.00% 13 0 14 14.00 0.00% 14 0 14 14.00 0.00% 15 0 17 17.00 0.00% 16 0 12 12.00 0.00% 17 0 6 6.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 3 3.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Aug 20 00 16 0.00/s 01 11 0.00/s 02 9 0.00/s 03 23 0.01/s 04 10 0.00/s 05 11 0.00/s 06 15 0.00/s 07 21 0.01/s 08 27 0.01/s 09 25 0.01/s 10 23 0.01/s 11 19 0.01/s 12 15 0.00/s 13 19 0.01/s 14 24 0.01/s 15 23 0.01/s 16 22 0.01/s 17 17 0.00/s 18 9 0.00/s 19 10 0.00/s 20 13 0.00/s 21 14 0.00/s 22 12 0.00/s 23 15 0.00/s Day Hour Count Average Duration Average idle time Aug 20 00 9 55m6s 54m49s 01 14 1h51s 1h49s 02 11 1h33s 1h29s 03 23 15m9s 15m7s 04 9 1h2m39s 1h2m35s 05 10 1h14s 58m4s 06 10 57m48s 57m34s 07 18 50m27s 48m24s 08 20 52m2s 49m29s 09 25 55m43s 53m22s 10 24 53m54s 51m27s 11 26 52m21s 50m56s 12 16 53m3s 52m7s 13 14 53m4s 51m4s 14 21 56m5s 53m38s 15 25 52m12s 50m19s 16 21 58m16s 56m39s 17 20 58m27s 57m35s 18 16 1h11s 59m29s 19 10 55m6s 54m1s 20 12 46m20s 44m37s 21 10 1h51s 59m44s 22 10 55m 53m54s 23 17 41m9s 39m -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-08-20 14:05:01 Date
Connections per database
Key values
- rio Main Database
- 403 connections Total
Connections per user
Key values
- intelifix Main User
- 403 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-08-20 08:05:11 Date
Histogram of session times
Key values
- 311 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 391 sessions Total
Sessions per user
Key values
- intelifix Main User
- 391 sessions Total
Sessions per host
Key values
- [local] Main Host
- 391 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 35,621 buffers Checkpoint Peak
- 2026-08-20 00:09:44 Date
- 270.014 seconds Highest write time
- 0.130 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-08-20 15:24:39 Date
Checkpoints distance
Key values
- 484.06 Mo Distance Peak
- 2026-08-20 15:24:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Aug 20 00 50,673 767.309s 0.077s 767.457s 01 1,746 175.621s 0.027s 175.714s 02 1,907 191.633s 0.028s 191.703s 03 1,926 192.569s 0.043s 192.664s 04 2,317 233.344s 0.046s 233.452s 05 8,279 829.345s 0.1s 829.511s 06 6,579 385.328s 0.011s 385.357s 07 36,963 2,448.519s 0.336s 2,448.999s 08 75,493 3,238.411s 0.705s 3,239.336s 09 89,051 3,238.638s 0.779s 3,239.668s 10 82,578 3,219.542s 0.826s 3,220.609s 11 55,221 3,153.623s 0.675s 3,154.549s 12 12,328 1,150.387s 0.15s 1,150.623s 13 40,503 2,484.324s 0.45s 2,484.906s 14 88,551 3,238.68s 0.773s 3,239.692s 15 85,957 3,238.73s 0.745s 3,239.75s 16 63,408 3,238.677s 0.674s 3,239.569s 17 23,906 1,724.98s 0.238s 1,725.337s 18 1,038 104.281s 0.009s 104.319s 19 23 2.325s 0.003s 2.333s 20 698 131.467s 0.022s 131.509s 21 2,956 297.87s 0.025s 297.947s 22 2,101 211.213s 0.038s 211.333s 23 325 37.061s 0.014s 37.125s Day Hour Added Removed Recycled Synced files Longest sync Average sync Aug 20 00 0 0 10 641 0.020s 0.009s 01 0 0 0 457 0.002s 0.011s 02 0 0 1 499 0.003s 0.007s 03 0 0 0 529 0.003s 0.009s 04 0 0 1 585 0.007s 0.011s 05 0 0 4 561 0.014s 0.01s 06 0 0 1 60 0.002s 0.003s 07 0 0 27 4,729 0.009s 0.012s 08 0 0 54 6,594 0.017s 0.012s 09 0 0 47 7,873 0.013s 0.012s 10 0 0 45 7,759 0.010s 0.012s 11 0 0 52 7,363 0.029s 0.012s 12 0 0 4 2,567 0.008s 0.011s 13 0 0 20 5,239 0.012s 0.012s 14 0 0 61 7,958 0.037s 0.012s 15 0 0 64 7,885 0.006s 0.012s 16 0 0 34 7,088 0.006s 0.012s 17 0 0 10 3,593 0.003s 0.011s 18 0 0 1 95 0.002s 0.005s 19 0 0 0 3 0.002s 0.001s 20 0 0 0 78 0.002s 0.003s 21 0 0 1 416 0.003s 0.005s 22 0 0 1 447 0.003s 0.013s 23 0 0 0 35 0.002s 0.01s Day Hour Count Avg time (sec) Aug 20 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 20 00 16,637.11 kB 52,244.00 kB 01 819.82 kB 19,498.18 kB 02 1,357.29 kB 7,957.29 kB 03 1,101.00 kB 2,635.78 kB 04 1,199.00 kB 2,466.00 kB 05 7,074.56 kB 13,790.22 kB 06 5,567.67 kB 11,271.00 kB 07 37,296.50 kB 52,148.33 kB 08 73,317.00 kB 98,366.92 kB 09 64,785.17 kB 113,253.42 kB 10 60,941.58 kB 107,307.83 kB 11 70,603.83 kB 124,045.75 kB 12 5,882.36 kB 56,678.36 kB 13 27,989.83 kB 48,344.67 kB 14 82,805.00 kB 123,070.25 kB 15 87,276.00 kB 169,418.42 kB 16 46,729.75 kB 110,426.50 kB 17 15,499.55 kB 52,454.82 kB 18 757.00 kB 24,010.80 kB 19 186.00 kB 17,352.00 kB 20 3,405.33 kB 14,846.33 kB 21 2,658.80 kB 10,636.00 kB 22 862.08 kB 5,293.25 kB 23 104.22 kB 2,006.00 kB -
Temporary Files
Size of temporary files
Key values
- 483.52 MiB Temp Files size Peak
- 2026-08-20 05:32:08 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-08-20 05:32:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Aug 20 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 12 1.21 GiB 103.37 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 2 208.00 MiB 104.00 MiB 11 2 208.00 MiB 104.00 MiB 12 0 0 0 13 1 104.00 MiB 104.00 MiB 14 0 0 0 15 3 312.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 832.01 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( 028732, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-20 09:44:29 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028752, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 14:27:52 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028713, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 07:23:41 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 8 939.06 MiB 72.11 MiB 241.76 MiB 117.38 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-20 05:32:17 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-20 05:32:08 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 4 301.37 MiB 56.02 MiB 92.20 MiB 75.34 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-20 05:30:44 Duration: 42s604ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-20 05:30:41 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 241.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 241.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 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-20 11:10:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-08-20 15:16:36 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 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-20 15:35:19 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
6 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-20 15:46:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
7 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-20 13:57:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
8 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-20 11:25:49 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 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-20 10:55:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 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-20 10:48:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 92.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-20 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 92.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-20 05:30:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 79.77 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 79.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 05:32:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 79.69 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 05:32:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 72.19 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 05:32:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 72.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 05:32:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 72.11 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-08-20 05:32:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 60.96 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-20 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 56.02 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-08-20 05:30:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 10.07 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database contagem - 2026-08-20 14:42:07 Date
- 0 sec Highest CPU-cost analyze
Table
Database contagem - Date
Average Autovacuum Duration
Key values
- 10.07 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_08
Database contagem - 2026-08-20 14:42:07 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (134) Main table analyzed (database rio)
- 1,130 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 134 rio.pg_catalog.pg_class 69 rio.pg_catalog.pg_type 58 rio.public.usuarios 47 brasilia.pg_catalog.pg_attribute 43 contagem.pg_catalog.pg_attribute 38 rio.pg_catalog.pg_index 37 contagem.public.usuarios 33 rio.public.temp0000289084 31 rio.public.temp0000289130 28 rio.public.temp0000289048 28 rio.pg_catalog.pg_depend 27 brasilia.pg_catalog.pg_class 24 rio.public.temp0000289134 24 brasilia.public.temp0000238536 23 brasilia.pg_catalog.pg_type 21 rio.public.temp0000289050 20 rio.public.temp0000289070 19 contagem.pg_catalog.pg_class 18 rio.public.temp0000288964 17 contagem.pg_catalog.pg_type 15 rio.public.temp0000289056 15 brasilia.pg_catalog.pg_index 14 rio.public.temp0000289078 12 rio.public.temp0000289100 12 brasilia.public.temp0000238554 12 brasilia.pg_catalog.pg_depend 12 rio.public.temp0000289034 11 rio.public.temp0000289108 11 rio.public.temp0000289152 11 rio.public.temp0000289052 10 rio.public.temp0000289144 10 contagem.pg_catalog.pg_index 9 rio.public.temp0000289094 9 rio.public.temp0000289138 9 brasilia.public.usuarios 9 contagem.public.temp0000226885 8 rio.public.temp0000289098 8 rio.public.temp0000289068 8 rio.public.temp0000289146 8 rio.public.temp0000289154 7 contagem.pg_catalog.pg_depend 7 rio.public.temp0000289162 6 rio.public.temp0000289016 6 rio.public.temp0000289038 6 rio.public.temp0000289118 6 contagem.public.temp0000226856 6 rio.public.temp0000289168 6 rio.public.temp0000289128 5 brasilia.public.temp0000238606 5 rio.public.temp0000289120 5 rio.public.temp0000289040 5 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000289062 4 contagem.pg_catalog.pg_shdepend 4 rio.public.temp0000289172 4 rio.public.temp0000289030 4 rio.public.temp0000289136 4 brasilia.public.temp0000238592 4 brasilia.public.nf_entrada 4 rio.public.temp0000289170 4 rio.public.temp0000289082 3 rio.public.temp0000289044 3 contagem.public.temp0000226874 3 rio.public.tmp_drill_0302 3 rio.public.temp0000289042 3 template1.pg_catalog.pg_shdepend 3 rio.public.temp0000289046 3 rio.public.tmp_drill_0175 3 brasilia.public.temp0000238576 2 rio.public.tmp_drill_0320 2 rio.public.temp0000289126 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000289032 2 brasilia.public.temp0000238540 2 brasilia.public.temp0000238586 2 rio.public.temp0000289028 2 contagem.public.temp0000226850 2 brasilia.public.temp0000238602 2 contagem.public.temp0000226883 2 brasilia.public.temp0000238618 2 rio.public.temp0000289148 2 rio.public.temp0000289074 2 brasilia.public.temp0000238548 1 postgres.pg_catalog.pg_shdepend 1 brasilia.public.temp0000238628 1 brasilia.public.temp0000238630 1 contagem.public.nf_entrada 1 rio.public.temp0000289058 1 brasilia.public.temp0000238552 1 contagem.auditor.auditor_2026_08 1 brasilia.public.temp0000238562 1 brasilia.auditor.auditor_2026_08 1 rio.public.temp0000289096 1 rio.public.temp0000289064 1 rio.public.temp0000289114 1 rio.public.temp0000289066 1 brasilia.public.temp0000238610 1 brasilia.public.temp0000238572 1 brasilia.public.temp0000238564 1 rio.public.temp0000289124 1 rio.public.temp0000289076 1 rio.public.temp0000289104 1 Total 1,130 Vacuums per table
Key values
- pg_catalog.pg_attribute (48) Main table vacuumed on database rio
- 495 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 48 44 0 0 0 0 0 26,618 7,364 10,690,544 441 10,502 contagem.public.usuarios 32 0 0 0 0 0 0 151 113 63,232 0 0 rio.pg_catalog.pg_class 29 26 0 0 0 0 0 5,433 1,703 2,600,231 77 287 rio.pg_catalog.pg_type 25 22 0 0 0 0 0 2,112 604 877,352 74 231 rio.pg_catalog.pg_index 16 14 0 0 0 0 0 912 210 240,047 43 84 rio.public.temp0000289050 16 0 0 0 0 0 0 935 88 68,788 0 0 rio.public.temp0000289048 16 0 0 0 0 0 0 22,714 3,601 5,938,677 0 0 rio.public.temp0000289084 15 0 0 0 0 0 0 13,966 1,791 3,074,644 0 0 brasilia.pg_catalog.pg_attribute 14 14 0 0 0 0 0 7,576 1,796 2,969,189 75 1,911 contagem.pg_catalog.pg_attribute 14 14 0 0 0 0 0 7,077 2,077 3,633,003 22 638 rio.public.temp0000289056 13 0 0 0 0 0 0 17,433 1,788 3,280,434 0 0 rio.public.temp0000288964 12 0 0 0 0 0 0 719 184 241,131 0 0 rio.public.temp0000289100 12 0 0 0 0 0 0 325 60 28,479 0 0 rio.public.usuarios 12 9 0 0 0 0 0 239 81 167,756 13 15 brasilia.pg_catalog.pg_class 12 11 0 0 0 0 0 2,347 510 897,824 44 140 rio.pg_catalog.pg_depend 11 11 0 0 0 0 0 3,680 1,296 1,824,204 83 622 rio.public.temp0000289130 11 0 0 0 0 0 0 835 61 59,476 0 0 rio.pg_catalog.pg_statistic 11 11 0 0 0 0 0 11,672 3,672 14,628,840 2,082 9,533 brasilia.pg_catalog.pg_type 10 10 0 0 0 0 0 909 247 369,184 20 84 rio.public.temp0000289134 10 0 0 0 0 0 0 17,427 40 1,034,223 0 0 rio.public.temp0000289098 8 0 0 0 0 0 0 5,245 27 313,954 0 0 rio.public.tmp_drill_0175 8 3 0 0 0 0 0 561 81 168,978 1 28 rio.public.temp0000289052 8 0 0 0 0 0 0 650 40 47,106 0 0 rio.public.temp0000289118 7 0 0 0 0 0 0 6,980 25 415,846 0 0 rio.public.temp0000289154 7 0 0 0 0 0 0 10,463 27 621,461 0 0 rio.public.tmp_drill_0302 6 3 0 0 0 0 0 2,280 1,132 1,696,304 1 70 template1.pg_catalog.pg_shdepend 6 6 0 0 0 0 0 865 251 445,130 102 244 brasilia.pg_catalog.pg_index 6 6 0 0 0 0 0 319 88 77,747 11 31 rio.public.temp0000289168 5 0 0 0 0 0 0 379 28 26,953 0 0 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 2,083 601 3,122,950 175 398 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 879 210 326,830 3 10 contagem.pg_catalog.pg_type 5 5 0 0 0 0 0 418 117 185,846 1 2 rio.public.temp0000289170 4 0 0 0 0 0 0 6,972 16 413,760 0 0 rio.public.temp0000289120 4 0 0 0 0 0 0 413 159 264,628 0 0 rio.public.temp0000289172 4 0 0 0 0 0 0 5,235 15 311,212 0 0 rio.public.temp0000289078 4 0 0 0 0 0 0 90 21 8,552 0 0 rio.public.temp0000289136 4 0 0 0 0 0 0 219 119 179,851 0 0 contagem.pg_catalog.pg_index 4 4 0 0 0 0 0 192 55 59,015 2 2 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 891 331 622,379 5 30 rio.public.temp0000289016 3 0 0 0 0 0 0 213 16 14,913 0 0 rio.public.temp0000289146 3 0 0 0 0 0 0 132 16 10,432 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 996 249 416,314 13 96 brasilia.public.nf_entrada 3 3 0 0 0 0 0 534 203 413,813 15 17 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,480 1,276 4,998,131 949 6,210 rio.public.temp0000289044 3 0 0 0 0 0 0 122 92 133,312 0 0 rio.public.temp0000289082 3 0 0 0 0 0 0 1,877 12 112,552 0 0 rio.public.tmp_drill_0320 2 2 0 0 0 0 0 2,124 6 352,346 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 391 91 391,858 41 96 postgres.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 347 128 172,190 17 28 rio.public.temp0000289152 2 0 0 0 0 0 0 3,488 8 206,998 0 0 brasilia.public.temp0000238602 2 0 0 0 0 0 0 492 8 30,234 0 0 rio.public.temp0000289076 1 0 0 0 0 0 0 1,741 4 103,322 0 0 rio.public.temp0000289074 1 0 0 0 0 0 0 1,743 4 103,440 0 0 rio.public.temp0000289124 1 0 0 0 0 0 0 1,742 1,742 2,345,982 0 0 brasilia.public.giga_testes 1 1 0 0 0 0 0 6,128 4,832 14,586,553 58 771 brasilia.public.temp0000238564 1 0 0 0 0 0 0 247 4 15,189 0 0 brasilia.public.temp0000238552 1 0 0 0 0 0 0 246 4 15,117 0 0 contagem.auditor.auditor_2026_08 1 0 0 0 0 0 0 33,463 22,104 27,836,983 5,218 90,740 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 160 4 12,283 0 0 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,337 8 171,284 0 0 brasilia.auditor.auditor_2026_08 1 0 0 0 0 0 0 34,095 21,972 27,501,554 5,923 114,989 rio.public.temp0000289040 1 0 0 0 0 0 0 8 5 1,263 0 0 brasilia.public.temp0000238586 1 0 0 0 0 0 0 247 248 396,863 0 0 rio.public.temp0000289144 1 0 0 0 0 0 0 1,743 4 103,440 0 0 brasilia.public.lote_caixas 1 0 0 0 0 0 0 39 38 123,438 1 7 rio.public.temp0000289062 1 0 0 0 0 0 0 1,741 4 103,322 0 0 contagem.public.temp0000226885 1 0 0 0 0 0 0 111 6 7,513 0 0 brasilia.public.fluxos 1 1 0 0 0 0 0 15,042 10,987 40,271,110 697 28,155 contagem.public.nf_entrada 1 1 0 0 0 0 0 109 4 17,780 0 0 rio.public.temp0000289030 1 0 0 0 0 0 0 53 6 3,956 0 0 contagem.public.equipamentos 1 1 0 0 0 0 0 12,907 11,609 38,206,308 37 2,164 brasilia.public.temp0000238630 1 0 0 0 0 0 0 246 4 15,117 0 0 brasilia.public.temp0000238572 1 0 0 0 0 0 0 4 3 774 0 0 Total 495 247 0 0 0 0 0 317,562 106,330 221,191,444 16,244 268,135 Vacuum throughput per table
Key values
- auditor.auditor_2026_08 (10.07) Max CPU elapsed for vacuum on database contagem
- unknown (0 ms) Max I/O read time for vacuum on database contagem
- unknown (0 ms) Max I/O write time for vacuum on database contagem
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.04 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 1.05 rio.pg_catalog.pg_type 0 0 0.3 rio.pg_catalog.pg_index 0 0 0.24 rio.public.temp0000289050 0 0 0.24 rio.public.temp0000289048 0 0 0.85 rio.public.temp0000289084 0 0 0.82 brasilia.pg_catalog.pg_attribute 0 0 1.09 contagem.pg_catalog.pg_attribute 0 0 1.31 rio.public.temp0000289056 0 0 0.74 rio.public.temp0000288964 0 0 0.12 rio.public.temp0000289100 0 0 0.15 rio.public.usuarios 0 0 0.02 brasilia.pg_catalog.pg_class 0 0 0.3 rio.pg_catalog.pg_depend 0 0 0.74 rio.public.temp0000289130 0 0 0.19 rio.pg_catalog.pg_statistic 0 0 1.87 brasilia.pg_catalog.pg_type 0 0 0.18 rio.public.temp0000289134 0 0 0.51 rio.public.temp0000289098 0 0 0.4 rio.public.tmp_drill_0175 0 0 0.04 rio.public.temp0000289052 0 0 0.09 rio.public.temp0000289118 0 0 0.39 rio.public.temp0000289154 0 0 0.36 rio.public.tmp_drill_0302 0 0 0.19 template1.pg_catalog.pg_shdepend 0 0 0.27 brasilia.pg_catalog.pg_index 0 0 0.05 rio.public.temp0000289168 0 0 0.1 rio.pg_toast.pg_toast_2619 0 0 0.25 contagem.pg_catalog.pg_class 0 0 0.42 contagem.pg_catalog.pg_type 0 0 0.3 rio.public.temp0000289170 0 0 0.22 rio.public.temp0000289120 0 0 0.05 rio.public.temp0000289172 0 0 0.22 rio.public.temp0000289078 0 0 0.06 rio.public.temp0000289136 0 0 0.07 contagem.pg_catalog.pg_index 0 0 0.16 contagem.pg_catalog.pg_depend 0 0 0.33 rio.public.temp0000289016 0 0 0.02 rio.public.temp0000289146 0 0 0.04 brasilia.pg_catalog.pg_depend 0 0 0.35 brasilia.public.nf_entrada 0 0 0.12 brasilia.pg_catalog.pg_statistic 0 0 0.54 rio.public.temp0000289044 0 0 0.04 rio.public.temp0000289082 0 0 0.06 rio.public.tmp_drill_0320 0 0 0.07 brasilia.pg_toast.pg_toast_2619 0 0 0.03 postgres.pg_catalog.pg_shdepend 0 0 0.17 rio.public.temp0000289152 0 0 0.12 brasilia.public.temp0000238602 0 0 0 rio.public.temp0000289076 0 0 0.04 rio.public.temp0000289074 0 0 0.06 rio.public.temp0000289124 0 0 0.06 brasilia.public.giga_testes 0 0 3.76 brasilia.public.temp0000238564 0 0 0 brasilia.public.temp0000238552 0 0 0 contagem.auditor.auditor_2026_08 0 0 10.07 contagem.pg_toast.pg_toast_2619 0 0 0.01 contagem.pg_catalog.pg_statistic 0 0 0.04 brasilia.auditor.auditor_2026_08 0 0 7.87 rio.public.temp0000289040 0 0 0.02 brasilia.public.temp0000238586 0 0 0.01 rio.public.temp0000289144 0 0 0.04 brasilia.public.lote_caixas 0 0 0.01 rio.public.temp0000289062 0 0 0.05 contagem.public.temp0000226885 0 0 0.01 brasilia.public.fluxos 0 0 6.22 contagem.public.nf_entrada 0 0 0.03 rio.public.temp0000289030 0 0 0.02 contagem.public.equipamentos 0 0 5.9 brasilia.public.temp0000238630 0 0 0.01 brasilia.public.temp0000238572 0 0 0 Total 0 0 54.52 Tuples removed per table
Key values
- pg_catalog.pg_attribute (198657) Main table with removed tuples on database rio
- 487546 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 48 44 198,657 1,208,071 65,711 450 29,070 brasilia.pg_catalog.pg_attribute 14 14 66,936 306,130 430 73 8,149 contagem.pg_catalog.pg_attribute 14 14 44,551 343,694 9,064 261 7,637 rio.public.tmp_drill_0302 6 3 32,894 232,902 98,682 0 3,368 rio.public.tmp_drill_0320 2 2 32,386 32,781 0 0 823 rio.pg_catalog.pg_statistic 11 11 16,610 95,572 856 0 14,146 brasilia.public.fluxos 1 1 8,336 1,215,642 0 0 15,186 rio.pg_catalog.pg_depend 11 11 8,273 215,118 3,935 0 2,020 brasilia.pg_catalog.pg_depend 3 3 8,209 54,245 6 0 540 rio.pg_catalog.pg_type 25 22 7,476 61,495 3,980 13 1,779 brasilia.pg_catalog.pg_class 12 11 6,814 44,176 1,547 0 1,569 brasilia.pg_catalog.pg_statistic 3 3 6,415 24,153 0 0 3,216 contagem.auditor.auditor_2026_08 1 0 6,222 2,804,800 0 0 129,924 template1.pg_catalog.pg_shdepend 6 6 5,790 83,311 1,681 0 744 rio.pg_catalog.pg_class 29 26 5,541 113,805 11,095 69 3,780 contagem.pg_catalog.pg_statistic 1 1 4,270 7,274 0 0 1,011 brasilia.pg_catalog.pg_type 10 10 4,093 22,540 322 17 655 rio.pg_catalog.pg_index 16 14 4,008 32,729 1,797 0 928 contagem.pg_catalog.pg_class 5 5 2,990 20,679 2,288 0 770 rio.public.tmp_drill_0175 8 3 2,673 23,690 7,395 0 427 contagem.public.usuarios 32 0 2,003 768 0 0 64 brasilia.public.nf_entrada 3 3 1,867 13,868 842 0 456 brasilia.pg_catalog.pg_index 6 6 1,803 11,289 0 11 309 contagem.public.nf_entrada 1 1 1,530 1,550 0 0 79 rio.pg_toast.pg_toast_2619 5 5 1,267 2,949 8 0 1,355 contagem.pg_catalog.pg_type 5 5 1,185 12,159 916 24 330 contagem.pg_catalog.pg_depend 3 3 1,109 59,493 2,976 13 527 postgres.pg_catalog.pg_shdepend 2 2 966 27,385 287 0 248 contagem.pg_catalog.pg_index 4 4 772 8,048 458 10 208 rio.public.usuarios 12 9 718 7,229 1,121 0 252 brasilia.public.giga_testes 1 1 351 718,634 0 0 19,040 brasilia.auditor.auditor_2026_08 1 0 323 3,092,912 0 0 140,490 brasilia.pg_toast.pg_toast_2619 2 2 223 277 0 0 142 contagem.public.equipamentos 1 1 153 472,437 0 0 5,852 contagem.pg_toast.pg_toast_2619 1 1 131 113 0 15 51 brasilia.public.lote_caixas 1 0 1 133,670 0 0 1,038 rio.public.temp0000289076 1 0 0 24,550 0 0 1,792 rio.public.temp0000289074 1 0 0 24,580 0 0 1,792 rio.public.temp0000289124 1 0 0 24,569 0 0 1,792 rio.public.temp0000289016 3 0 0 8,596 0 63 193 rio.public.temp0000289170 4 0 0 98,333 0 0 7,168 rio.public.temp0000289120 4 0 0 20,796 0 167 473 rio.public.temp0000289168 5 0 0 24,986 0 72 568 rio.public.temp0000289050 16 0 0 57,972 0 416 1,312 brasilia.public.temp0000238564 1 0 0 3,224 0 0 256 brasilia.public.temp0000238552 1 0 0 3,223 0 0 256 rio.public.temp0000289098 8 0 0 196,462 0 0 14,336 rio.public.temp0000289146 3 0 0 13,751 0 72 312 rio.public.temp0000289040 1 0 0 2,914 0 63 65 brasilia.public.temp0000238586 1 0 0 3,227 0 0 256 rio.public.temp0000289144 1 0 0 24,574 0 0 1,792 rio.public.temp0000289172 4 0 0 98,340 0 0 7,168 rio.public.temp0000289130 11 0 0 58,704 0 395 1,333 rio.public.temp0000289056 13 0 0 319,335 0 0 23,296 rio.public.temp0000289052 8 0 0 41,385 0 199 953 rio.public.temp0000289078 4 0 0 11,688 0 186 262 rio.public.temp0000289062 1 0 0 24,548 0 0 1,792 rio.public.temp0000289084 15 0 0 368,505 0 0 26,880 rio.public.temp0000288964 12 0 0 38,601 0 255 865 rio.public.temp0000289152 2 0 0 49,174 0 0 3,584 rio.public.temp0000289100 12 0 0 35,575 0 418 798 contagem.public.temp0000226885 1 0 0 1,337 0 25 103 rio.public.temp0000289136 4 0 0 17,775 0 108 404 rio.public.temp0000289030 1 0 0 2,030 0 19 45 rio.public.temp0000289134 10 0 0 245,747 0 0 17,920 brasilia.public.temp0000238630 1 0 0 3,232 0 0 256 brasilia.public.temp0000238602 2 0 0 6,449 0 0 512 brasilia.public.temp0000238572 1 0 0 3,224 0 0 256 rio.public.temp0000289044 3 0 0 7,725 0 114 174 rio.public.temp0000289048 16 0 0 371,127 0 0 26,944 rio.public.temp0000289082 3 0 0 26,748 0 0 1,920 rio.public.temp0000289118 7 0 0 171,958 0 0 12,544 rio.public.temp0000289154 7 0 0 172,043 0 0 12,544 Total 495 247 487,546 14,112,595 215,397 3,528 569,099 Pages removed per table
Key values
- pg_catalog.pg_attribute (450) Main table with removed pages on database rio
- 3528 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.pg_catalog.pg_attribute 48 44 198657 450 rio.public.temp0000289100 12 0 0 418 rio.public.temp0000289050 16 0 0 416 rio.public.temp0000289130 11 0 0 395 contagem.pg_catalog.pg_attribute 14 14 44551 261 rio.public.temp0000288964 12 0 0 255 rio.public.temp0000289052 8 0 0 199 rio.public.temp0000289078 4 0 0 186 rio.public.temp0000289120 4 0 0 167 rio.public.temp0000289044 3 0 0 114 rio.public.temp0000289136 4 0 0 108 brasilia.pg_catalog.pg_attribute 14 14 66936 73 rio.public.temp0000289168 5 0 0 72 rio.public.temp0000289146 3 0 0 72 rio.pg_catalog.pg_class 29 26 5541 69 rio.public.temp0000289016 3 0 0 63 rio.public.temp0000289040 1 0 0 63 contagem.public.temp0000226885 1 0 0 25 contagem.pg_catalog.pg_type 5 5 1185 24 rio.public.temp0000289030 1 0 0 19 brasilia.pg_catalog.pg_type 10 10 4093 17 contagem.pg_toast.pg_toast_2619 1 1 131 15 contagem.pg_catalog.pg_depend 3 3 1109 13 rio.pg_catalog.pg_type 25 22 7476 13 brasilia.pg_catalog.pg_index 6 6 1803 11 contagem.pg_catalog.pg_index 4 4 772 10 rio.public.temp0000289076 1 0 0 0 rio.pg_catalog.pg_depend 11 11 8273 0 rio.public.temp0000289074 1 0 0 0 contagem.public.usuarios 32 0 2003 0 rio.public.temp0000289124 1 0 0 0 rio.public.temp0000289170 4 0 0 0 brasilia.public.giga_testes 1 1 351 0 rio.pg_catalog.pg_index 16 14 4008 0 rio.public.tmp_drill_0320 2 2 32386 0 brasilia.public.temp0000238564 1 0 0 0 brasilia.public.temp0000238552 1 0 0 0 contagem.auditor.auditor_2026_08 1 0 6222 0 rio.public.temp0000289098 8 0 0 0 brasilia.pg_toast.pg_toast_2619 2 2 223 0 rio.pg_toast.pg_toast_2619 5 5 1267 0 contagem.pg_catalog.pg_statistic 1 1 4270 0 brasilia.auditor.auditor_2026_08 1 0 323 0 brasilia.public.temp0000238586 1 0 0 0 rio.public.temp0000289144 1 0 0 0 rio.public.tmp_drill_0302 6 3 32894 0 rio.public.tmp_drill_0175 8 3 2673 0 brasilia.public.lote_caixas 1 0 1 0 rio.public.temp0000289172 4 0 0 0 rio.public.temp0000289056 13 0 0 0 template1.pg_catalog.pg_shdepend 6 6 5790 0 contagem.pg_catalog.pg_class 5 5 2990 0 rio.public.temp0000289062 1 0 0 0 rio.public.temp0000289084 15 0 0 0 postgres.pg_catalog.pg_shdepend 2 2 966 0 rio.public.temp0000289152 2 0 0 0 brasilia.pg_catalog.pg_depend 3 3 8209 0 brasilia.public.nf_entrada 3 3 1867 0 brasilia.public.fluxos 1 1 8336 0 contagem.public.nf_entrada 1 1 1530 0 brasilia.pg_catalog.pg_statistic 3 3 6415 0 rio.public.temp0000289134 10 0 0 0 rio.public.usuarios 12 9 718 0 contagem.public.equipamentos 1 1 153 0 brasilia.public.temp0000238630 1 0 0 0 brasilia.public.temp0000238602 2 0 0 0 rio.pg_catalog.pg_statistic 11 11 16610 0 brasilia.public.temp0000238572 1 0 0 0 rio.public.temp0000289048 16 0 0 0 rio.public.temp0000289082 3 0 0 0 rio.public.temp0000289118 7 0 0 0 brasilia.pg_catalog.pg_class 12 11 6814 0 rio.public.temp0000289154 7 0 0 0 Total 495 247 487,546 3,528 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Aug 20 00 0 3 01 0 2 02 0 0 03 0 2 04 0 12 05 7 1 06 1 4 07 18 54 08 59 120 09 45 116 10 59 120 11 62 108 12 5 15 13 26 75 14 58 160 15 88 183 16 49 123 17 17 29 18 0 0 19 0 0 20 0 0 21 1 3 22 0 0 23 0 0 - 10.07 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 3 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 4m11s 4m11s 4m11s 4m11s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 09:59:27 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 00:05:26 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 20:15:11 Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000289048;-
DROP TABLE IF EXISTS temp0000289048;
Date: 2026-08-20 08:09:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
DROP TABLE IF EXISTS temp0000289048;
Date: 2026-08-20 08:09:44 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 1 1s 1s 1s 1s drop table if exists temp0000289118;-
DROP TABLE IF EXISTS temp0000289118;
Date: 2026-08-20 11:11:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
DROP TABLE IF EXISTS temp0000289118;
Date: 2026-08-20 11:11:47 Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Queries that waited the most
Rank Wait time Query 1 4m11s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-08-20 09:59:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1s1ms DROP TABLE IF EXISTS temp0000289048;[ Date: 2026-08-20 08:09:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1s DROP TABLE IF EXISTS temp0000289118;[ Date: 2026-08-20 11:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,925 Total read queries
- 1,896 Total write queries
Queries by database
Key values
- rio Main database
- 4,859 Requests
- 7h16m35s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 13,451 Requests
User Request type Count Duration etiquetas Total 76 16s378ms select 76 16s378ms intelifix Total 13,451 18h2m44s copy to 767 1h34m19s ddl 2,715 1h44m23s others 1,044 1h42m7s select 8,925 13h1m54s lenon Total 250 3m17s select 250 3m17s Duration by user
Key values
- 18h2m44s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 76 16s378ms select 76 16s378ms intelifix Total 13,451 18h2m44s copy to 767 1h34m19s ddl 2,715 1h44m23s others 1,044 1h42m7s select 8,925 13h1m54s lenon Total 250 3m17s select 250 3m17s Queries by host
Key values
- [local] Main host
- 13,777 Requests
- 18h6m17s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,186 Requests
- 4h24m36s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-08-20 11:23:50 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,762 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m56s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 10:14:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 09:14:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m40s analyze verbose;[ Date: 2026-08-20 05:09:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 11:14:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 15:14:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m38s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 07:13:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m31s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 14:13:32 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 12:13:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 16:12:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m43s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 17:12:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028732, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');[ Date: 2026-08-20 09:44:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 7m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-08-20 08:12:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028752, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 14:27:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 6m57s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028713, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 07:23:41 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m43s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028760, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 15:25:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m34s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028735, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 09:59:26 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028723, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 08:44:06 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028747, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 13:50:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028754, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 14:46:23 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 6m25s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028737, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-08-20 10:22:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h13m 323 150ms 7m32s 24s707ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 20 07 10 12m33s 1m15s 08 49 20m24s 24s982ms 09 52 23m13s 26s792ms 10 22 26m11s 1m11s 11 17 6m27s 22s796ms 12 5 1s651ms 330ms 13 16 8m3s 30s235ms 14 71 14m59s 12s668ms 15 29 12m50s 26s565ms 16 32 7m28s 14s20ms 17 20 47s254ms 2s362ms [ User: intelifix - Total duration: 2h13m - Times executed: 323 ]
[ Application: [unknown] - Total duration: 2h13m - Times executed: 323 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028732, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-20 09:44:29 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028752, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 14:27:52 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028713, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 07:23:41 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 2h10m53s 48 1s367ms 9m56s 2m43s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 20 07 3 9m21s 3m7s 08 3 7m51s 2m37s 09 3 10m41s 3m33s 10 3 10m34s 3m31s 11 3 9m44s 3m14s 12 3 8m30s 2m50s 13 3 6m40s 2m13s 14 3 9m11s 3m3s 15 3 9m41s 3m13s 16 3 8m27s 2m49s 17 3 8m11s 2m43s 18 3 6m36s 2m12s 19 3 6m10s 2m3s 20 3 6m39s 2m13s 21 3 6m23s 2m7s 22 3 6m6s 2m2s [ User: intelifix - Total duration: 2h10m53s - Times executed: 48 ]
[ Application: psql - Total duration: 2h10m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-20 10:14:58 Duration: 9m56s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-20 09:14:56 Duration: 9m55s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-20 11:14:08 Duration: 9m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 1h7m33s 46 196ms 5m3s 1m28s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 20 07 3 5m32s 1m50s 08 3 4m49s 1m36s 09 3 6m15s 2m5s 10 3 5m56s 1m58s 11 2 59s825ms 29s912ms 12 3 4m27s 1m29s 13 3 3m45s 1m15s 14 3 5m27s 1m49s 15 2 58s809ms 29s404ms 16 3 5m17s 1m45s 17 3 4m35s 1m31s 18 3 3m50s 1m16s 19 3 3m47s 1m15s 20 3 4m17s 1m25s 21 3 3m42s 1m14s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h7m33s - Times executed: 46 ]
[ Application: psql - Total duration: 1h7m33s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-20 09:21:51 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-20 10:21:27 Duration: 4m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-20 16:18:39 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 25m25s 1,657 150ms 5s664ms 920ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 20 07 38 28s883ms 760ms 08 183 2m58s 973ms 09 311 4m17s 826ms 10 201 3m8s 936ms 11 184 2m47s 908ms 12 48 30s499ms 635ms 13 73 1m34s 1s299ms 14 205 3m42s 1s84ms 15 162 2m33s 945ms 16 191 2m37s 825ms 17 61 47s945ms 785ms [ User: intelifix - Total duration: 25m25s - Times executed: 1657 ]
[ Application: [unknown] - Total duration: 25m25s - Times executed: 1657 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54037, 413, '246203518990', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 10:21:44 Duration: 5s664ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54052, 413, '246160051416', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 11:39:09 Duration: 4s906ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278974, 452, '863400601904995,241759470104,241746775172$Z87325051035249,241740645561$Z87325051022832,241739403858$Z87325051023517,241739472327,241764764851,241764686987,241775358488,241763968601,241778885668,241742220508,241770593950,241770589101,241745820220,241778836168,241742303748,241745820523,241772336263,241762717479,241764635467,241772361115,241775587377,241745806278,241768882930,241769005568,241772674860,241745462934,241772698600,241745820624,241767646378,241745805975,241768929500,241742224447,241775592025,241777772541,241770579403,241769881827,241779197090,241769936175', '',0464,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 16:22:09 Duration: 4s699ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 18m49s 3 2m43s 9m40s 6m16s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 20 05 3 18m49s 6m16s [ User: intelifix - Total duration: 18m49s - Times executed: 3 ]
[ Application: psql - Total duration: 18m49s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-20 05:09:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-08-20 05:16:07 Duration: 6m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-08-20 05:18:51 Duration: 2m43s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 15m12s 273 153ms 4m18s 3s343ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 20 00 12 36s198ms 3s16ms 01 12 26s37ms 2s169ms 02 12 27s901ms 2s325ms 03 12 27s316ms 2s276ms 04 12 24s750ms 2s62ms 05 11 24s321ms 2s211ms 06 11 24s232ms 2s202ms 07 12 28s347ms 2s362ms 08 11 31s481ms 2s861ms 09 12 4m46s 23s842ms 10 12 35s241ms 2s936ms 11 12 31s298ms 2s608ms 12 12 25s520ms 2s126ms 13 12 26s77ms 2s173ms 14 12 33s192ms 2s766ms 15 12 32s227ms 2s685ms 16 12 28s850ms 2s404ms 17 12 28s606ms 2s383ms 18 12 24s862ms 2s71ms 19 12 25s334ms 2s111ms 20 12 33s656ms 2s804ms 21 12 25s290ms 2s107ms 22 12 25s884ms 2s157ms [ User: intelifix - Total duration: 15m12s - Times executed: 273 ]
[ Application: psql - Total duration: 15m12s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 09:59:27 Duration: 4m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 00:05:26 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 20:15:11 Duration: 9s526ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 13m6s 56 10s183ms 35s894ms 14s51ms create table temp0000289048 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 20 07 21 4m37s 13s203ms 08 20 4m40s 14s26ms 09 9 2m30s 16s772ms 10 6 1m18s 13s23ms [ User: intelifix - Total duration: 13m6s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 13m6s - Times executed: 56 ]
-
CREATE TABLE temp0000289048 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 07:14:16 Duration: 35s894ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289048 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 09:36:15 Duration: 34s760ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289048 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 09:52:05 Duration: 17s253ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 12m36s 75 1s286ms 34s492ms 10s91ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 20 07 5 19s464ms 3s892ms 08 5 50s461ms 10s92ms 09 6 55s54ms 9s175ms 10 8 1m23s 10s459ms 11 6 1m26s 14s360ms 12 3 7s68ms 2s356ms 13 7 57s796ms 8s256ms 14 9 2m1s 13s484ms 15 6 1m25s 14s257ms 16 17 2m34s 9s61ms 17 3 36s237ms 12s79ms [ User: intelifix - Total duration: 12m36s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 12m36s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 08:31:31 Duration: 34s492ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 16:37:07 Duration: 30s986ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 09:59:57 Duration: 26s636ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 9m22s 41 11s69ms 28s500ms 13s727ms create table temp0000289134 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 20 13 6 1m34s 15s759ms 14 23 5m12s 13s573ms 15 12 2m36s 13s7ms [ User: intelifix - Total duration: 9m22s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 9m22s - Times executed: 41 ]
-
CREATE TABLE temp0000289134 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 13:41:06 Duration: 28s500ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289134 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 14:20:28 Duration: 16s758ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289134 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 14:39:07 Duration: 15s550ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 9m15s 1,045 150ms 9s753ms 531ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 20 07 40 23s77ms 576ms 08 112 56s370ms 503ms 09 152 1m16s 503ms 10 117 59s108ms 505ms 11 94 43s561ms 463ms 12 18 9s522ms 529ms 13 47 24s999ms 531ms 14 108 1m2s 578ms 15 170 1m46s 626ms 16 146 1m13s 504ms 17 41 19s767ms 482ms [ User: intelifix - Total duration: 9m15s - Times executed: 1045 ]
[ Application: [unknown] - Total duration: 9m15s - Times executed: 1045 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "229996339293,229996348991,229996273250,229996273957,229996274664,229997355566,229998086378,229998104966,229998111836,229998219196,229998173435,229906095167,229906078397,229998152042,229998154264,229998195154,229998199093,229998199801,229998200913", "usuario" : "414", "caixa" : "2911897", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-20 15:35:43 Duration: 9s753ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279803", "modelo" : "263", "itens" : "229897764354,229901563737,229916599705,229892625962,229910718907,229916106166,229916191428,229920544355,229900533850,229912188185,229920513645,229918492741,229916446682,229901544061,229912066479,229902370921,229899777782,229895463748,229912072137,229910509515,229897881717,229912064560,229876945476,229899688605,229896492042,229896223149,229909846666,229895583737,229900948188", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-20 15:41:48 Duration: 1s794ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279451", "modelo" : "263", "itens" : "229897527181,229900708995,229902092330,229910482644,229908563242,229874076778,229901692942,229910737090,229899502627,229919234766,229898453041,229901951632,229900967180,229892430512,229908521723,229919111017,229899400014,229898314363,229897604058,229900049099,229899343745,229908042125,229908180725,229901945267,229892516883,229877083649,229914885778,229915730115,229876278384,229919260931,229897993647,229896141828,229911940710,229916494869,229899159507,229914621533,229897503846", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-20 08:11:48 Duration: 1s697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 8m47s 2 4m22s 4m24s 4m23s select * from rs_smart_fiscal_saida () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 20 11 1 4m22s 4m22s 15 1 4m24s 4m24s [ User: intelifix - Total duration: 8m47s - Times executed: 2 ]
[ Application: psql - Total duration: 8m47s - Times executed: 2 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 15:20:01 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 11:20:01 Duration: 4m22s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 7m13s 157 163ms 13s489ms 2s761ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 20 00 5 20s230ms 4s46ms 01 6 9s99ms 1s516ms 02 6 9s384ms 1s564ms 03 5 8s883ms 1s776ms 04 4 6s869ms 1s717ms 05 3 3s789ms 1s263ms 07 12 35s942ms 2s995ms 08 12 42s206ms 3s517ms 09 12 46s431ms 3s869ms 10 12 36s608ms 3s50ms 11 12 27s803ms 2s316ms 12 7 8s670ms 1s238ms 13 11 28s46ms 2s549ms 14 12 46s481ms 3s873ms 15 12 46s948ms 3s912ms 16 10 35s335ms 3s533ms 17 5 3s342ms 668ms 21 5 9s67ms 1s813ms 22 6 8s485ms 1s414ms [ User: intelifix - Total duration: 7m13s - Times executed: 157 ]
[ Application: psql - Total duration: 7m13s - Times executed: 157 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 00:05:14 Duration: 13s489ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 16:05:12 Duration: 11s551ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 07:35:09 Duration: 8s801ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 6m29s 29 11s381ms 16s922ms 13s445ms create table temp0000289084 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 20 10 4 54s279ms 13s569ms 11 24 5m21s 13s375ms 16 1 14s618ms 14s618ms [ User: intelifix - Total duration: 6m29s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 6m29s - Times executed: 29 ]
-
CREATE TABLE temp0000289084 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:23:51 Duration: 16s922ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289084 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:54:48 Duration: 16s218ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289084 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:24:08 Duration: 15s809ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 5m23s 22 11s696ms 36s968ms 14s684ms create table temp0000289056 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 20 08 6 1m23s 13s853ms 09 2 29s163ms 14s581ms 10 6 1m43s 17s286ms 13 1 14s116ms 14s116ms 15 7 1m32s 13s277ms [ User: intelifix - Total duration: 5m23s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 5m23s - Times executed: 22 ]
-
CREATE TABLE temp0000289056 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:38:03 Duration: 36s968ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289056 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 08:41:12 Duration: 15s708ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289056 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:45:17 Duration: 15s416ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 3m30s 57 3s106ms 4s459ms 3s688ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 20 08 3 12s463ms 4s154ms 09 5 17s592ms 3s518ms 10 5 17s534ms 3s506ms 11 4 13s175ms 3s293ms 12 3 11s120ms 3s706ms 13 4 13s725ms 3s431ms 14 5 18s419ms 3s683ms 15 3 11s298ms 3s766ms 16 4 14s440ms 3s610ms 17 3 10s802ms 3s600ms 18 4 14s542ms 3s635ms 19 4 16s34ms 4s8ms 20 4 14s964ms 3s741ms 21 3 12s211ms 4s70ms 22 3 11s942ms 3s980ms [ User: intelifix - Total duration: 3m30s - Times executed: 57 ]
[ Application: psql - Total duration: 3m30s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 19:40:10 Duration: 4s459ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 21:40:09 Duration: 4s417ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 21:00:08 Duration: 4s352ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 3m9s 339 154ms 3s82ms 559ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 20 09 57 23s488ms 412ms 13 115 52s220ms 454ms 14 167 1m53s 682ms [ User: intelifix - Total duration: 3m9s - Times executed: 339 ]
[ Application: [unknown] - Total duration: 3m9s - Times executed: 339 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133700","seriais":"241765427878,241777958899,241775837177,241813996872,241775840815,241772441628,241776515863,241812974966,241771055263,241740177580,241778069113,241778236682,241762476367,241778248299,241762589005,241762604764,241740261832,241759659415,241765560014,241764494264,241777970114,241777950516,241740754461,241777959102,241744511315,241776644563,241772560203,241814588300,241741969898,241812962137,241778707895,241814164768,241765564559,241747362031,241744305357,241740734358,241747445877,241762499703,241759635271,241764625365","usuario":"399","observacao":""}');
Date: 2026-08-20 14:20:58 Duration: 3s82ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133700","seriais":"241739632141,241764450321,241759644262,241778216579,241760839192,241759702326,241776812133,241739807488,241776808798,241739686971,241764445774,241814034553,241772772143,241772765879,241814030109,241814013036,241761342935,241738523839,241762586883,241747339402,241764450826,241813665471,241747444463,241772559797,241764443148,241814016369,241813648196,241759946973,241767919009,241814037785,241742793246,241775244359,241814728088,241778745576,241778725473,241775244056,241814581431,241743104668,241765595471,241778716987","usuario":"399","observacao":""}');
Date: 2026-08-20 14:21:06 Duration: 2s331ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133700","seriais":"241784730628,241786624347,241720666776,241794583149,241724942222,241754166768,241723083253,241734643438,241704959395,241724329300,241751225258,241758207286,241757292237,241734395153,241782012124,241750017373,241725572239,241734647478,241704970307,241734642731,241736946367,241750428806,241757267183,241754198791,241720297694,241787276363,241753857288,241725452126,241737018495,241749971938,241757315673,241754191923,241721805664,241749071738,241784641528,241750442848,241780481122,241724333038,241720444858,241784628293","usuario":"399","observacao":""}');
Date: 2026-08-20 14:05:09 Duration: 2s314ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 3m6s 4 4s631ms 1m32s 46s714ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 20 20 2 1m29s 44s885ms 23 2 1m37s 48s543ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-20 23:16:59 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-20 20:08:29 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-20 20:10:15 Duration: 5s227ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 2m54s 39 224ms 25s44ms 4s477ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 20 07 2 27s841ms 13s920ms 08 9 22s684ms 2s520ms 09 2 17s755ms 8s877ms 10 5 29s403ms 5s880ms 11 3 1s574ms 524ms 13 2 18s191ms 9s95ms 14 6 24s382ms 4s63ms 15 8 31s248ms 3s906ms 16 2 1s528ms 764ms [ User: intelifix - Total duration: 2m54s - Times executed: 39 ]
[ Application: psql - Total duration: 2m54s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028713);
Date: 2026-08-20 07:16:35 Duration: 25s44ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 502); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028739);
Date: 2026-08-20 10:45:20 Duration: 17s626ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028747);
Date: 2026-08-20 13:43:18 Duration: 16s884ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 2m40s 12 10s862ms 15s387ms 13s360ms create table temp0000289118 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 20 10 7 1m31s 13s64ms 11 5 1m8s 13s773ms [ User: intelifix - Total duration: 2m40s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m40s - Times executed: 12 ]
-
CREATE TABLE temp0000289118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:27:03 Duration: 15s387ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:56:22 Duration: 14s767ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:26:38 Duration: 14s268ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 2m2s 33 3s272ms 4s527ms 3s702ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 20 08 3 11s703ms 3s901ms 09 1 3s571ms 3s571ms 10 1 3s365ms 3s365ms 11 2 6s697ms 3s348ms 12 3 10s462ms 3s487ms 13 2 6s929ms 3s464ms 14 1 4s204ms 4s204ms 15 3 10s872ms 3s624ms 16 2 7s656ms 3s828ms 17 3 10s593ms 3s531ms 18 2 7s505ms 3s752ms 19 2 7s639ms 3s819ms 20 2 7s827ms 3s913ms 21 3 10s909ms 3s636ms 22 3 12s240ms 4s80ms [ User: intelifix - Total duration: 2m2s - Times executed: 33 ]
[ Application: psql - Total duration: 2m2s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 22:20:05 Duration: 4s527ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 20:40:05 Duration: 4s348ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 08:00:05 Duration: 4s237ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,657 25m25s 150ms 5s664ms 920ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 20 07 38 28s883ms 760ms 08 183 2m58s 973ms 09 311 4m17s 826ms 10 201 3m8s 936ms 11 184 2m47s 908ms 12 48 30s499ms 635ms 13 73 1m34s 1s299ms 14 205 3m42s 1s84ms 15 162 2m33s 945ms 16 191 2m37s 825ms 17 61 47s945ms 785ms [ User: intelifix - Total duration: 25m25s - Times executed: 1657 ]
[ Application: [unknown] - Total duration: 25m25s - Times executed: 1657 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54037, 413, '246203518990', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 10:21:44 Duration: 5s664ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54052, 413, '246160051416', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 11:39:09 Duration: 4s906ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278974, 452, '863400601904995,241759470104,241746775172$Z87325051035249,241740645561$Z87325051022832,241739403858$Z87325051023517,241739472327,241764764851,241764686987,241775358488,241763968601,241778885668,241742220508,241770593950,241770589101,241745820220,241778836168,241742303748,241745820523,241772336263,241762717479,241764635467,241772361115,241775587377,241745806278,241768882930,241769005568,241772674860,241745462934,241772698600,241745820624,241767646378,241745805975,241768929500,241742224447,241775592025,241777772541,241770579403,241769881827,241779197090,241769936175', '',0464,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 16:22:09 Duration: 4s699ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 1,045 9m15s 150ms 9s753ms 531ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 20 07 40 23s77ms 576ms 08 112 56s370ms 503ms 09 152 1m16s 503ms 10 117 59s108ms 505ms 11 94 43s561ms 463ms 12 18 9s522ms 529ms 13 47 24s999ms 531ms 14 108 1m2s 578ms 15 170 1m46s 626ms 16 146 1m13s 504ms 17 41 19s767ms 482ms [ User: intelifix - Total duration: 9m15s - Times executed: 1045 ]
[ Application: [unknown] - Total duration: 9m15s - Times executed: 1045 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "287", "itens" : "229996339293,229996348991,229996273250,229996273957,229996274664,229997355566,229998086378,229998104966,229998111836,229998219196,229998173435,229906095167,229906078397,229998152042,229998154264,229998195154,229998199093,229998199801,229998200913", "usuario" : "414", "caixa" : "2911897", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-20 15:35:43 Duration: 9s753ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279803", "modelo" : "263", "itens" : "229897764354,229901563737,229916599705,229892625962,229910718907,229916106166,229916191428,229920544355,229900533850,229912188185,229920513645,229918492741,229916446682,229901544061,229912066479,229902370921,229899777782,229895463748,229912072137,229910509515,229897881717,229912064560,229876945476,229899688605,229896492042,229896223149,229909846666,229895583737,229900948188", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-20 15:41:48 Duration: 1s794ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "279451", "modelo" : "263", "itens" : "229897527181,229900708995,229902092330,229910482644,229908563242,229874076778,229901692942,229910737090,229899502627,229919234766,229898453041,229901951632,229900967180,229892430512,229908521723,229919111017,229899400014,229898314363,229897604058,229900049099,229899343745,229908042125,229908180725,229901945267,229892516883,229877083649,229914885778,229915730115,229876278384,229919260931,229897993647,229896141828,229911940710,229916494869,229899159507,229914621533,229897503846", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-08-20 08:11:48 Duration: 1s697ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 339 3m9s 154ms 3s82ms 559ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 20 09 57 23s488ms 412ms 13 115 52s220ms 454ms 14 167 1m53s 682ms [ User: intelifix - Total duration: 3m9s - Times executed: 339 ]
[ Application: [unknown] - Total duration: 3m9s - Times executed: 339 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133700","seriais":"241765427878,241777958899,241775837177,241813996872,241775840815,241772441628,241776515863,241812974966,241771055263,241740177580,241778069113,241778236682,241762476367,241778248299,241762589005,241762604764,241740261832,241759659415,241765560014,241764494264,241777970114,241777950516,241740754461,241777959102,241744511315,241776644563,241772560203,241814588300,241741969898,241812962137,241778707895,241814164768,241765564559,241747362031,241744305357,241740734358,241747445877,241762499703,241759635271,241764625365","usuario":"399","observacao":""}');
Date: 2026-08-20 14:20:58 Duration: 3s82ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133700","seriais":"241739632141,241764450321,241759644262,241778216579,241760839192,241759702326,241776812133,241739807488,241776808798,241739686971,241764445774,241814034553,241772772143,241772765879,241814030109,241814013036,241761342935,241738523839,241762586883,241747339402,241764450826,241813665471,241747444463,241772559797,241764443148,241814016369,241813648196,241759946973,241767919009,241814037785,241742793246,241775244359,241814728088,241778745576,241778725473,241775244056,241814581431,241743104668,241765595471,241778716987","usuario":"399","observacao":""}');
Date: 2026-08-20 14:21:06 Duration: 2s331ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"133700","seriais":"241784730628,241786624347,241720666776,241794583149,241724942222,241754166768,241723083253,241734643438,241704959395,241724329300,241751225258,241758207286,241757292237,241734395153,241782012124,241750017373,241725572239,241734647478,241704970307,241734642731,241736946367,241750428806,241757267183,241754198791,241720297694,241787276363,241753857288,241725452126,241737018495,241749971938,241757315673,241754191923,241721805664,241749071738,241784641528,241750442848,241780481122,241724333038,241720444858,241784628293","usuario":"399","observacao":""}');
Date: 2026-08-20 14:05:09 Duration: 2s314ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 323 2h13m 150ms 7m32s 24s707ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 20 07 10 12m33s 1m15s 08 49 20m24s 24s982ms 09 52 23m13s 26s792ms 10 22 26m11s 1m11s 11 17 6m27s 22s796ms 12 5 1s651ms 330ms 13 16 8m3s 30s235ms 14 71 14m59s 12s668ms 15 29 12m50s 26s565ms 16 32 7m28s 14s20ms 17 20 47s254ms 2s362ms [ User: intelifix - Total duration: 2h13m - Times executed: 323 ]
[ Application: [unknown] - Total duration: 2h13m - Times executed: 323 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028732, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-20 09:44:29 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028752, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 14:27:52 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028713, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 07:23:41 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 273 15m12s 153ms 4m18s 3s343ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 20 00 12 36s198ms 3s16ms 01 12 26s37ms 2s169ms 02 12 27s901ms 2s325ms 03 12 27s316ms 2s276ms 04 12 24s750ms 2s62ms 05 11 24s321ms 2s211ms 06 11 24s232ms 2s202ms 07 12 28s347ms 2s362ms 08 11 31s481ms 2s861ms 09 12 4m46s 23s842ms 10 12 35s241ms 2s936ms 11 12 31s298ms 2s608ms 12 12 25s520ms 2s126ms 13 12 26s77ms 2s173ms 14 12 33s192ms 2s766ms 15 12 32s227ms 2s685ms 16 12 28s850ms 2s404ms 17 12 28s606ms 2s383ms 18 12 24s862ms 2s71ms 19 12 25s334ms 2s111ms 20 12 33s656ms 2s804ms 21 12 25s290ms 2s107ms 22 12 25s884ms 2s157ms [ User: intelifix - Total duration: 15m12s - Times executed: 273 ]
[ Application: psql - Total duration: 15m12s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 09:59:27 Duration: 4m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 00:05:26 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 20:15:11 Duration: 9s526ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 157 7m13s 163ms 13s489ms 2s761ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 20 00 5 20s230ms 4s46ms 01 6 9s99ms 1s516ms 02 6 9s384ms 1s564ms 03 5 8s883ms 1s776ms 04 4 6s869ms 1s717ms 05 3 3s789ms 1s263ms 07 12 35s942ms 2s995ms 08 12 42s206ms 3s517ms 09 12 46s431ms 3s869ms 10 12 36s608ms 3s50ms 11 12 27s803ms 2s316ms 12 7 8s670ms 1s238ms 13 11 28s46ms 2s549ms 14 12 46s481ms 3s873ms 15 12 46s948ms 3s912ms 16 10 35s335ms 3s533ms 17 5 3s342ms 668ms 21 5 9s67ms 1s813ms 22 6 8s485ms 1s414ms [ User: intelifix - Total duration: 7m13s - Times executed: 157 ]
[ Application: psql - Total duration: 7m13s - Times executed: 157 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 00:05:14 Duration: 13s489ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 16:05:12 Duration: 11s551ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 07:35:09 Duration: 8s801ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 141 42s913ms 151ms 2s569ms 304ms create table temp0000289070 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 20 08 24 10s646ms 443ms 09 18 4s233ms 235ms 10 20 5s63ms 253ms 11 20 6s33ms 301ms 12 4 1s73ms 268ms 13 4 964ms 241ms 14 20 6s84ms 304ms 15 26 7s932ms 305ms 16 3 474ms 158ms 17 2 405ms 202ms [ User: intelifix - Total duration: 42s913ms - Times executed: 141 ]
[ Application: [unknown] - Total duration: 42s913ms - Times executed: 141 ]
-
CREATE TABLE temp0000289070 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-08-2026", "ate" :"20-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-20 08:08:57 Duration: 2s569ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289070 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-08-2026", "ate" :"20-08-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-20 08:10:55 Duration: 2s104ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289070 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"15-08-2026", "ate" :"20-08-2026", "nota-fiscal":"1111", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-08-20 14:21:44 Duration: 712ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 119 55s615ms 266ms 933ms 467ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 20 00 2 887ms 443ms 01 1 427ms 427ms 03 3 1s312ms 437ms 04 2 801ms 400ms 05 2 986ms 493ms 06 3 1s110ms 370ms 07 10 4s341ms 434ms 08 12 5s180ms 431ms 09 13 7s709ms 593ms 10 10 5s637ms 563ms 11 9 4s458ms 495ms 12 5 1s959ms 391ms 13 10 4s156ms 415ms 14 11 5s200ms 472ms 15 9 3s632ms 403ms 16 9 4s232ms 470ms 17 6 2s686ms 447ms 22 1 462ms 462ms 23 1 430ms 430ms [ User: lenon - Total duration: 55s615ms - Times executed: 119 ]
[ Application: [unknown] - Total duration: 55s615ms - Times executed: 119 ]
-
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-20 09:55:04 Duration: 933ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-20.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-20 09:06:46 Duration: 806ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-20.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-20 14:40:15 Duration: 799ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 118 51s236ms 181ms 1s53ms 434ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 20 07 7 2s351ms 335ms 08 14 6s25ms 430ms 09 12 5s144ms 428ms 10 12 6s572ms 547ms 11 10 4s388ms 438ms 12 5 1s930ms 386ms 13 8 3s518ms 439ms 14 20 8s950ms 447ms 15 21 8s522ms 405ms 16 6 2s688ms 448ms 17 3 1s142ms 380ms [ User: intelifix - Total duration: 51s236ms - Times executed: 118 ]
[ Application: [unknown] - Total duration: 51s236ms - Times executed: 118 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-08-20 10:29:26 Duration: 1s53ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-20 11:36:45 Duration: 701ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-08-20 10:53:48 Duration: 683ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 107 1m34s 152ms 19s451ms 882ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 20 08 21 17s172ms 817ms 09 19 10s823ms 569ms 11 1 195ms 195ms 13 2 3s704ms 1s852ms 14 42 50s33ms 1s191ms 15 5 3s212ms 642ms 16 8 2s955ms 369ms 17 9 6s360ms 706ms [ User: intelifix - Total duration: 1m34s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 1m34s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-20 14:08:45 Duration: 19s451ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133700) LIMIT 1;
Date: 2026-08-20 14:26:52 Duration: 11s611ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133429) LIMIT 1;
Date: 2026-08-20 08:44:55 Duration: 3s310ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 107 1m3s 356ms 1s28ms 593ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 20 00 2 1s103ms 551ms 01 1 571ms 571ms 03 1 530ms 530ms 04 2 1s67ms 533ms 05 2 1s197ms 598ms 07 7 3s867ms 552ms 08 12 6s452ms 537ms 09 13 9s18ms 693ms 10 10 7s167ms 716ms 11 9 5s339ms 593ms 12 4 2s140ms 535ms 13 10 5s117ms 511ms 14 11 6s472ms 588ms 15 8 4s291ms 536ms 16 9 5s277ms 586ms 17 5 2s957ms 591ms 23 1 896ms 896ms [ User: intelifix - Total duration: 1m3s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 107 ]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-08-20 09:55:04 Duration: 1s28ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
select * from rs_menu_grants (419, 0, 1);
Date: 2026-08-20 23:45:07 Duration: 896ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
select * from rs_menu_grants (413, 5, 1);
Date: 2026-08-20 10:16:12 Duration: 880ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 106 23s80ms 151ms 613ms 217ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 20 00 17 3s752ms 220ms 01 1 160ms 160ms 04 6 1s433ms 238ms 07 21 4s612ms 219ms 08 8 1s723ms 215ms 09 4 764ms 191ms 10 9 1s707ms 189ms 11 2 372ms 186ms 13 4 1s304ms 326ms 14 14 2s978ms 212ms 15 14 3s19ms 215ms 16 4 850ms 212ms 17 2 400ms 200ms [ User: intelifix - Total duration: 23s80ms - Times executed: 106 ]
[ Application: [unknown] - Total duration: 23s80ms - Times executed: 106 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '63', 2, '229693723543,229678012021,229706690219', NULL, NULL, 0137, 00);
Date: 2026-08-20 13:59:09 Duration: 613ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '230052601430,229967922335,230019603439,229976115457,230022291637,229967393944,229986458587,230038001015,229991322127,230025952847,230027192732,229963489297,229989388099,230026116779,229991506667,230026333243,230050906067,230014862640,230050964558,230050994359', NULL, NULL, 0295, 00);
Date: 2026-08-20 07:07:40 Duration: 456ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229976641020,230032426183,229990581415,230014649712,229971724950,230033747591,229973626976,229971097279,230006080010', NULL, NULL, 0295, 00);
Date: 2026-08-20 00:37:06 Duration: 409ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 85 20s223ms 151ms 2s586ms 237ms create table temp0000238536 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 20 06 1 2s586ms 2s586ms 09 1 184ms 184ms 10 4 738ms 184ms 11 9 1s680ms 186ms 12 13 2s440ms 187ms 13 4 876ms 219ms 14 10 2s532ms 253ms 15 9 1s952ms 216ms 16 34 7s231ms 212ms [ User: intelifix - Total duration: 20s223ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 20s223ms - Times executed: 85 ]
-
CREATE TABLE temp0000238536 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "15-08-2026", "data-ate" : "20-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-20 06:59:33 Duration: 2s586ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000238536 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "20-08-2026", "data-ate" : "20-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-20 14:19:36 Duration: 536ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000238536 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "20-08-2026", "data-ate" : "20-08-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-08-20 15:17:15 Duration: 281ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 84 40s787ms 150ms 12s25ms 485ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 20 00 1 195ms 195ms 07 2 391ms 195ms 09 3 518ms 172ms 10 6 1s253ms 208ms 11 4 644ms 161ms 12 3 645ms 215ms 13 3 627ms 209ms 14 16 14s131ms 883ms 15 20 4s22ms 201ms 16 17 16s645ms 979ms 17 9 1s711ms 190ms [ User: intelifix - Total duration: 40s787ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 40s787ms - Times executed: 84 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-08-20", "data-ate" : "2026-08-20", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-08-20 16:52:50 Duration: 12s25ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-08-20", "data-ate" : "2026-08-20", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-08-20 14:59:06 Duration: 10s905ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-08-20", "data-ate" : "2026-08-20", "passos" : "-2" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 406 }');
Date: 2026-08-20 16:53:01 Duration: 1s510ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 77 25s714ms 152ms 787ms 333ms select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 20 10 1 303ms 303ms 14 9 1s713ms 190ms 15 67 23s698ms 353ms [ User: intelifix - Total duration: 25s714ms - Times executed: 77 ]
[ Application: [unknown] - Total duration: 25s714ms - Times executed: 77 ]
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-20 15:55:14 Duration: 787ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-20 15:55:57 Duration: 739ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTES_SAIDA_LISTA (103107);
Date: 2026-08-20 15:56:46 Duration: 687ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 75 12m36s 1s286ms 34s492ms 10s91ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 20 07 5 19s464ms 3s892ms 08 5 50s461ms 10s92ms 09 6 55s54ms 9s175ms 10 8 1m23s 10s459ms 11 6 1m26s 14s360ms 12 3 7s68ms 2s356ms 13 7 57s796ms 8s256ms 14 9 2m1s 13s484ms 15 6 1m25s 14s257ms 16 17 2m34s 9s61ms 17 3 36s237ms 12s79ms [ User: intelifix - Total duration: 12m36s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 12m36s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 08:31:31 Duration: 34s492ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 16:37:07 Duration: 30s986ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 09:59:57 Duration: 26s636ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 75 12s239ms 150ms 208ms 163ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 20 00 1 178ms 178ms 07 2 311ms 155ms 08 15 2s433ms 162ms 09 6 959ms 159ms 10 15 2s498ms 166ms 11 5 768ms 153ms 13 1 155ms 155ms 14 13 2s186ms 168ms 15 5 846ms 169ms 16 11 1s749ms 159ms 17 1 153ms 153ms [ User: intelifix - Total duration: 12s239ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 12s239ms - Times executed: 75 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0141;
Date: 2026-08-20 10:21:13 Duration: 208ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-08-20 14:05:01 Duration: 197ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-08-20 14:37:21 Duration: 193ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 73 17s549ms 155ms 351ms 240ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 20 07 5 1s298ms 259ms 08 7 1s709ms 244ms 09 19 5s105ms 268ms 10 14 3s4ms 214ms 11 13 2s521ms 193ms 13 2 473ms 236ms 14 9 2s356ms 261ms 15 4 1s78ms 269ms [ User: intelifix - Total duration: 17s549ms - Times executed: 73 ]
[ Application: [unknown] - Total duration: 17s549ms - Times executed: 73 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"002", "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-20 14:29:12 Duration: 351ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"003", "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-20 10:26:53 Duration: 345ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"003", "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-20 09:33:02 Duration: 337ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 63 16s994ms 154ms 599ms 269ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 20 08 1 184ms 184ms 09 8 2s794ms 349ms 10 16 4s41ms 252ms 11 9 2s807ms 311ms 12 1 168ms 168ms 13 4 1s664ms 416ms 14 17 3s785ms 222ms 15 6 1s374ms 229ms 16 1 173ms 173ms [ User: intelifix - Total duration: 16s994ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 16s994ms - Times executed: 63 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '44D454C430FB,D0CF0EFDE4BB,44D4549417E6,C4EB42A2C333,582FF70A74FA,C4EB42EB2DE9,6CFFCE694A27,D833B7CBDC9F,44D4546AAA1D,94988F316883,94988F95BE77,186A81D3FC54,E4C0E2908412', '77;1', 'DEFAULT', 09, 0155, '','', '', 00);
Date: 2026-08-20 09:34:03 Duration: 599ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, 'A456CCDFE889,A456CCE44E55,54A65C893974,BC9B6896A07C,54A65C8C1A5E,D4B92F26F5F1,905851A884C8,54A65C12B5AD,BC9B689B17DD,D4B92F2641B8,1062D010AFA9,1062D0277432,BC9B689AEED2,BC9B68967B45,10C25A16C20C,54A65C90D8AD,1062D0993510,54A65C0FE547,D4B92F2BB796,A456CCE718B7,54A65C901DD6,BC9B6897E936,B42A0E195E42,905851A7902A,54A65C90F9DF,80D04A917E21,54A65C11416B,80D04A98AFC2', '','DEFAULT',056,046,'', '','', 00);
Date: 2026-08-20 10:04:14 Duration: 587ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '942CB349784E,942CB388B858,8C444F574F77,8C444F3AEAD7,942CB345A5D6,E820E2792E91,8C444FF06F19,E820E28E97B4,E820E255D0E2,8C444F36B73F,942CB380645E,942CB3D0CB82,942CB3C7A488,E820E2520914,8C444F7287F0,8C444F7F818C,E820E200A657,8C444F7E8673,8C444FF672FD,8C444F1EEB74,8C444F3F12C9,E820E28DA451,8C444F1D5D31,E820E2AF28AB,8C444FA7E60E,E820E2C90577,8C444F654C4B,E820E25D54C3', '','DEFAULT',056,039,'', '','', 00);
Date: 2026-08-20 11:24:50 Duration: 586ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 57 3m30s 3s106ms 4s459ms 3s688ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 20 08 3 12s463ms 4s154ms 09 5 17s592ms 3s518ms 10 5 17s534ms 3s506ms 11 4 13s175ms 3s293ms 12 3 11s120ms 3s706ms 13 4 13s725ms 3s431ms 14 5 18s419ms 3s683ms 15 3 11s298ms 3s766ms 16 4 14s440ms 3s610ms 17 3 10s802ms 3s600ms 18 4 14s542ms 3s635ms 19 4 16s34ms 4s8ms 20 4 14s964ms 3s741ms 21 3 12s211ms 4s70ms 22 3 11s942ms 3s980ms [ User: intelifix - Total duration: 3m30s - Times executed: 57 ]
[ Application: psql - Total duration: 3m30s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 19:40:10 Duration: 4s459ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 21:40:09 Duration: 4s417ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 21:00:08 Duration: 4s352ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m43s 9m40s 6m16s 3 18m49s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Aug 20 05 3 18m49s 6m16s [ User: intelifix - Total duration: 18m49s - Times executed: 3 ]
[ Application: psql - Total duration: 18m49s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-08-20 05:09:42 Duration: 9m40s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-08-20 05:16:07 Duration: 6m25s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
analyze verbose;
Date: 2026-08-20 05:18:51 Duration: 2m43s Database: contagem User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 4m22s 4m24s 4m23s 2 8m47s select * from rs_smart_fiscal_saida () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Aug 20 11 1 4m22s 4m22s 15 1 4m24s 4m24s [ User: intelifix - Total duration: 8m47s - Times executed: 2 ]
[ Application: psql - Total duration: 8m47s - Times executed: 2 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 15:20:01 Duration: 4m24s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 11:20:01 Duration: 4m22s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 1s367ms 9m56s 2m43s 48 2h10m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Aug 20 07 3 9m21s 3m7s 08 3 7m51s 2m37s 09 3 10m41s 3m33s 10 3 10m34s 3m31s 11 3 9m44s 3m14s 12 3 8m30s 2m50s 13 3 6m40s 2m13s 14 3 9m11s 3m3s 15 3 9m41s 3m13s 16 3 8m27s 2m49s 17 3 8m11s 2m43s 18 3 6m36s 2m12s 19 3 6m10s 2m3s 20 3 6m39s 2m13s 21 3 6m23s 2m7s 22 3 6m6s 2m2s [ User: intelifix - Total duration: 2h10m53s - Times executed: 48 ]
[ Application: psql - Total duration: 2h10m53s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-20 10:14:58 Duration: 9m56s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-20 09:14:56 Duration: 9m55s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-08-20 11:14:08 Duration: 9m7s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 196ms 5m3s 1m28s 46 1h7m33s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Aug 20 07 3 5m32s 1m50s 08 3 4m49s 1m36s 09 3 6m15s 2m5s 10 3 5m56s 1m58s 11 2 59s825ms 29s912ms 12 3 4m27s 1m29s 13 3 3m45s 1m15s 14 3 5m27s 1m49s 15 2 58s809ms 29s404ms 16 3 5m17s 1m45s 17 3 4m35s 1m31s 18 3 3m50s 1m16s 19 3 3m47s 1m15s 20 3 4m17s 1m25s 21 3 3m42s 1m14s 22 3 3m47s 1m15s [ User: intelifix - Total duration: 1h7m33s - Times executed: 46 ]
[ Application: psql - Total duration: 1h7m33s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-20 09:21:51 Duration: 5m3s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-20 10:21:27 Duration: 4m48s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-08-20 16:18:39 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 4s631ms 1m32s 46s714ms 4 3m6s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Aug 20 20 2 1m29s 44s885ms 23 2 1m37s 48s543ms [ User: intelifix - Total duration: 3m6s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m6s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-20 23:16:59 Duration: 1m32s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-20 20:08:29 Duration: 1m24s Database: rio User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-08-20 20:10:15 Duration: 5s227ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 150ms 7m32s 24s707ms 323 2h13m select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Aug 20 07 10 12m33s 1m15s 08 49 20m24s 24s982ms 09 52 23m13s 26s792ms 10 22 26m11s 1m11s 11 17 6m27s 22s796ms 12 5 1s651ms 330ms 13 16 8m3s 30s235ms 14 71 14m59s 12s668ms 15 29 12m50s 26s565ms 16 32 7m28s 14s20ms 17 20 47s254ms 2s362ms [ User: intelifix - Total duration: 2h13m - Times executed: 323 ]
[ Application: [unknown] - Total duration: 2h13m - Times executed: 323 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028732, 0502 )', '/var/www/html/tmp/nf_carga_lotes_0502.xlsx');
Date: 2026-08-20 09:44:29 Duration: 7m32s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028752, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 14:27:52 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 028713, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-08-20 07:23:41 Duration: 6m57s Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 11s696ms 36s968ms 14s684ms 22 5m23s create table temp0000289056 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Aug 20 08 6 1m23s 13s853ms 09 2 29s163ms 14s581ms 10 6 1m43s 17s286ms 13 1 14s116ms 14s116ms 15 7 1m32s 13s277ms [ User: intelifix - Total duration: 5m23s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 5m23s - Times executed: 22 ]
-
CREATE TABLE temp0000289056 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:38:03 Duration: 36s968ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289056 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 08:41:12 Duration: 15s708ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289056 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:45:17 Duration: 15s416ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 10s183ms 35s894ms 14s51ms 56 13m6s create table temp0000289048 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Aug 20 07 21 4m37s 13s203ms 08 20 4m40s 14s26ms 09 9 2m30s 16s772ms 10 6 1m18s 13s23ms [ User: intelifix - Total duration: 13m6s - Times executed: 56 ]
[ Application: [unknown] - Total duration: 13m6s - Times executed: 56 ]
-
CREATE TABLE temp0000289048 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 07:14:16 Duration: 35s894ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289048 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 09:36:15 Duration: 34s760ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289048 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 09:52:05 Duration: 17s253ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 11s69ms 28s500ms 13s727ms 41 9m22s create table temp0000289134 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Aug 20 13 6 1m34s 15s759ms 14 23 5m12s 13s573ms 15 12 2m36s 13s7ms [ User: intelifix - Total duration: 9m22s - Times executed: 41 ]
[ Application: [unknown] - Total duration: 9m22s - Times executed: 41 ]
-
CREATE TABLE temp0000289134 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 13:41:06 Duration: 28s500ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289134 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 14:20:28 Duration: 16s758ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289134 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 14:39:07 Duration: 15s550ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 11s381ms 16s922ms 13s445ms 29 6m29s create table temp0000289084 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Aug 20 10 4 54s279ms 13s569ms 11 24 5m21s 13s375ms 16 1 14s618ms 14s618ms [ User: intelifix - Total duration: 6m29s - Times executed: 29 ]
[ Application: [unknown] - Total duration: 6m29s - Times executed: 29 ]
-
CREATE TABLE temp0000289084 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:23:51 Duration: 16s922ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289084 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:54:48 Duration: 16s218ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289084 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:24:08 Duration: 15s809ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 10s862ms 15s387ms 13s360ms 12 2m40s create table temp0000289118 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Aug 20 10 7 1m31s 13s64ms 11 5 1m8s 13s773ms [ User: intelifix - Total duration: 2m40s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 2m40s - Times executed: 12 ]
-
CREATE TABLE temp0000289118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:27:03 Duration: 15s387ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 10:56:22 Duration: 14s767ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CREATE TABLE temp0000289118 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-08-20 11:26:38 Duration: 14s268ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 1s286ms 34s492ms 10s91ms 75 12m36s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Aug 20 07 5 19s464ms 3s892ms 08 5 50s461ms 10s92ms 09 6 55s54ms 9s175ms 10 8 1m23s 10s459ms 11 6 1m26s 14s360ms 12 3 7s68ms 2s356ms 13 7 57s796ms 8s256ms 14 9 2m1s 13s484ms 15 6 1m25s 14s257ms 16 17 2m34s 9s61ms 17 3 36s237ms 12s79ms [ User: intelifix - Total duration: 12m36s - Times executed: 75 ]
[ Application: [unknown] - Total duration: 12m36s - Times executed: 75 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 08:31:31 Duration: 34s492ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 16:37:07 Duration: 30s986ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-08-20', 0175, '', '', 0, 6, '2026-08-01');
Date: 2026-08-20 09:59:57 Duration: 26s636ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 224ms 25s44ms 4s477ms 39 2m54s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Aug 20 07 2 27s841ms 13s920ms 08 9 22s684ms 2s520ms 09 2 17s755ms 8s877ms 10 5 29s403ms 5s880ms 11 3 1s574ms 524ms 13 2 18s191ms 9s95ms 14 6 24s382ms 4s63ms 15 8 31s248ms 3s906ms 16 2 1s528ms 764ms [ User: intelifix - Total duration: 2m54s - Times executed: 39 ]
[ Application: psql - Total duration: 2m54s - Times executed: 39 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028713);
Date: 2026-08-20 07:16:35 Duration: 25s44ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 502); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028739);
Date: 2026-08-20 10:45:20 Duration: 17s626ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (028747);
Date: 2026-08-20 13:43:18 Duration: 16s884ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 3s272ms 4s527ms 3s702ms 33 2m2s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Aug 20 08 3 11s703ms 3s901ms 09 1 3s571ms 3s571ms 10 1 3s365ms 3s365ms 11 2 6s697ms 3s348ms 12 3 10s462ms 3s487ms 13 2 6s929ms 3s464ms 14 1 4s204ms 4s204ms 15 3 10s872ms 3s624ms 16 2 7s656ms 3s828ms 17 3 10s593ms 3s531ms 18 2 7s505ms 3s752ms 19 2 7s639ms 3s819ms 20 2 7s827ms 3s913ms 21 3 10s909ms 3s636ms 22 3 12s240ms 4s80ms [ User: intelifix - Total duration: 2m2s - Times executed: 33 ]
[ Application: psql - Total duration: 2m2s - Times executed: 33 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 22:20:05 Duration: 4s527ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 20:40:05 Duration: 4s348ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-08-20 08:00:05 Duration: 4s237ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 3s106ms 4s459ms 3s688ms 57 3m30s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Aug 20 08 3 12s463ms 4s154ms 09 5 17s592ms 3s518ms 10 5 17s534ms 3s506ms 11 4 13s175ms 3s293ms 12 3 11s120ms 3s706ms 13 4 13s725ms 3s431ms 14 5 18s419ms 3s683ms 15 3 11s298ms 3s766ms 16 4 14s440ms 3s610ms 17 3 10s802ms 3s600ms 18 4 14s542ms 3s635ms 19 4 16s34ms 4s8ms 20 4 14s964ms 3s741ms 21 3 12s211ms 4s70ms 22 3 11s942ms 3s980ms [ User: intelifix - Total duration: 3m30s - Times executed: 57 ]
[ Application: psql - Total duration: 3m30s - Times executed: 57 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 19:40:10 Duration: 4s459ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 21:40:09 Duration: 4s417ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-08-20 21:00:08 Duration: 4s352ms Database: brasilia User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 153ms 4m18s 3s343ms 273 15m12s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Aug 20 00 12 36s198ms 3s16ms 01 12 26s37ms 2s169ms 02 12 27s901ms 2s325ms 03 12 27s316ms 2s276ms 04 12 24s750ms 2s62ms 05 11 24s321ms 2s211ms 06 11 24s232ms 2s202ms 07 12 28s347ms 2s362ms 08 11 31s481ms 2s861ms 09 12 4m46s 23s842ms 10 12 35s241ms 2s936ms 11 12 31s298ms 2s608ms 12 12 25s520ms 2s126ms 13 12 26s77ms 2s173ms 14 12 33s192ms 2s766ms 15 12 32s227ms 2s685ms 16 12 28s850ms 2s404ms 17 12 28s606ms 2s383ms 18 12 24s862ms 2s71ms 19 12 25s334ms 2s111ms 20 12 33s656ms 2s804ms 21 12 25s290ms 2s107ms 22 12 25s884ms 2s157ms [ User: intelifix - Total duration: 15m12s - Times executed: 273 ]
[ Application: psql - Total duration: 15m12s - Times executed: 273 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 09:59:27 Duration: 4m18s Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 00:05:26 Duration: 11s598ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-08-20 20:15:11 Duration: 9s526ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 163ms 13s489ms 2s761ms 157 7m13s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Aug 20 00 5 20s230ms 4s46ms 01 6 9s99ms 1s516ms 02 6 9s384ms 1s564ms 03 5 8s883ms 1s776ms 04 4 6s869ms 1s717ms 05 3 3s789ms 1s263ms 07 12 35s942ms 2s995ms 08 12 42s206ms 3s517ms 09 12 46s431ms 3s869ms 10 12 36s608ms 3s50ms 11 12 27s803ms 2s316ms 12 7 8s670ms 1s238ms 13 11 28s46ms 2s549ms 14 12 46s481ms 3s873ms 15 12 46s948ms 3s912ms 16 10 35s335ms 3s533ms 17 5 3s342ms 668ms 21 5 9s67ms 1s813ms 22 6 8s485ms 1s414ms [ User: intelifix - Total duration: 7m13s - Times executed: 157 ]
[ Application: psql - Total duration: 7m13s - Times executed: 157 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 00:05:14 Duration: 13s489ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 16:05:12 Duration: 11s551ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-08-20 07:35:09 Duration: 8s801ms Database: rio User: intelifix Remote: [local] Application: psql Log file: /usr/local/pgsql/data/log/serverlog-20.log
18 150ms 5s664ms 920ms 1,657 25m25s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Aug 20 07 38 28s883ms 760ms 08 183 2m58s 973ms 09 311 4m17s 826ms 10 201 3m8s 936ms 11 184 2m47s 908ms 12 48 30s499ms 635ms 13 73 1m34s 1s299ms 14 205 3m42s 1s84ms 15 162 2m33s 945ms 16 191 2m37s 825ms 17 61 47s945ms 785ms [ User: intelifix - Total duration: 25m25s - Times executed: 1657 ]
[ Application: [unknown] - Total duration: 25m25s - Times executed: 1657 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54037, 413, '246203518990', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 10:21:44 Duration: 5s664ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (54052, 413, '246160051416', '',0172,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 11:39:09 Duration: 4s906ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (278974, 452, '863400601904995,241759470104,241746775172$Z87325051035249,241740645561$Z87325051022832,241739403858$Z87325051023517,241739472327,241764764851,241764686987,241775358488,241763968601,241778885668,241742220508,241770593950,241770589101,241745820220,241778836168,241742303748,241745820523,241772336263,241762717479,241764635467,241772361115,241775587377,241745806278,241768882930,241769005568,241772674860,241745462934,241772698600,241745820624,241767646378,241745805975,241768929500,241742224447,241775592025,241777772541,241770579403,241769881827,241779197090,241769936175', '',0464,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-08-20 16:22:09 Duration: 4s699ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
19 152ms 19s451ms 882ms 107 1m34s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Aug 20 08 21 17s172ms 817ms 09 19 10s823ms 569ms 11 1 195ms 195ms 13 2 3s704ms 1s852ms 14 42 50s33ms 1s191ms 15 5 3s212ms 642ms 16 8 2s955ms 369ms 17 9 6s360ms 706ms [ User: intelifix - Total duration: 1m34s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 1m34s - Times executed: 107 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (052752) LIMIT 1;
Date: 2026-08-20 14:08:45 Duration: 19s451ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133700) LIMIT 1;
Date: 2026-08-20 14:26:52 Duration: 11s611ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0133429) LIMIT 1;
Date: 2026-08-20 08:44:55 Duration: 3s310ms Database: brasilia User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
20 356ms 1s28ms 593ms 107 1m3s select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Aug 20 00 2 1s103ms 551ms 01 1 571ms 571ms 03 1 530ms 530ms 04 2 1s67ms 533ms 05 2 1s197ms 598ms 07 7 3s867ms 552ms 08 12 6s452ms 537ms 09 13 9s18ms 693ms 10 10 7s167ms 716ms 11 9 5s339ms 593ms 12 4 2s140ms 535ms 13 10 5s117ms 511ms 14 11 6s472ms 588ms 15 8 4s291ms 536ms 16 9 5s277ms 586ms 17 5 2s957ms 591ms 23 1 896ms 896ms [ User: intelifix - Total duration: 1m3s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 107 ]
-
select * from rs_menu_grants (404, 18, 1);
Date: 2026-08-20 09:55:04 Duration: 1s28ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
select * from rs_menu_grants (419, 0, 1);
Date: 2026-08-20 23:45:07 Duration: 896ms Database: rio User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
-
select * from rs_menu_grants (413, 5, 1);
Date: 2026-08-20 10:16:12 Duration: 880ms Database: contagem User: intelifix Remote: [local] Application: [unknown] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 12 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Aug 19 09 1 0ms 0ms 10 1 0ms 0ms 13 1 0ms 0ms 19 1 0ms 0ms 20 2 0ms 0ms 21 1 0ms 0ms Aug 20 08 1 0ms 0ms 19 1 0ms 0ms 20 3 0ms 0ms [ User: intelifix - Total duration: 19s715ms - Times executed: 11 ]
[ User: etiquetas - Total duration: 171ms - Times executed: 1 ]
[ Application: psql - Total duration: 18s913ms - Times executed: 10 ]
[ Application: [unknown] - Total duration: 973ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,596 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 26 FATAL entries
- 4631 ERROR entries
- 0 WARNING entries
- 7 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,547 Max number of times the same event was reported
- 4,664 Total events found
Rank Times reported Error 1 4,547 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Aug 20 00 119 01 119 02 119 03 108 04 120 05 119 06 119 07 343 08 384 09 423 10 392 11 278 12 99 13 230 14 337 15 328 16 306 17 149 18 69 19 59 20 60 21 60 22 112 23 95 - ERROR: prepared statement "_PLAN00000000297DC220" does not exist
- ERROR: prepared statement "_PLAN00000000340F6760" does not exist
- ERROR: prepared statement "_PLAN00000000297DAFE0" does not exist
Statement: DEALLOCATE "_PLAN00000000297DC220"
Date: 2026-08-20 00:00:03 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: DEALLOCATE "_PLAN00000000340F6760"
Date: 2026-08-20 00:00:30 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: DEALLOCATE "_PLAN00000000297DAFE0"
Date: 2026-08-20 00:01:04 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Aug 20 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-08-20 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.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-20 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.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-20 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
3 12 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Aug 20 00 1 05 1 06 2 12 1 17 1 21 5 23 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-08-20 00:02:30 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-08-20 05:30:23 Database: jaboatao Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-08-20 06:02:24 Database: testes Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
4 11 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Aug 20 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-20 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-08-20 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-08-20 03:05:01 Database: rio Application: [unknown] User: lenon Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
5 11 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Aug 20 07 3 08 6 14 2 - ERROR: syntax error at or near "," at character 28
- ERROR: syntax error at or near "," at character 28
- ERROR: syntax error at or near "," at character 28
Statement: SELECT * FROM RS_ETIQUETA( ,5RT)
Date: 2026-08-20 07:52:53 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: SELECT * FROM RS_ETIQUETA( ,5RT)
Date: 2026-08-20 07:52:54 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: SELECT * FROM RS_ETIQUETA( ,5RT)
Date: 2026-08-20 07:52:54 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
6 8 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Aug 20 10 2 11 4 15 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73910285850067212571)Date: 2026-08-20 10:29:28 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73910285850067212571)Date: 2026-08-20 10:29:29 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73903785850065212649)Date: 2026-08-20 11:05:33 Database: rio Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
7 6 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Aug 20 08 4 13 2 - ERROR: trailing junk after numeric literal at or near "24E4CE57A7A9" at character 27
- ERROR: trailing junk after numeric literal at or near "24E4CE57A7A9" at character 27
- ERROR: trailing junk after numeric literal at or near "24E4CE57A7A9" at character 27
Statement: select * from rs_caixa_qr(24E4CE57A7A9)
Date: 2026-08-20 08:14:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: select * from rs_caixa_qr(24E4CE57A7A9)
Date: 2026-08-20 08:14:06 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: select * from rs_caixa_qr(24E4CE57A7A9)
Date: 2026-08-20 08:14:07 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Aug 20 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-20 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-08-20 05:32:17 Database: brasilia Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-08-20 05:32:17 Database: contagem Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
9 4 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Aug 20 07 1 08 2 09 1 - ERROR: column "controle" does not exist at character 36
- ERROR: column "zte3annr9w1555391620" does not exist at character 27
- ERROR: column "zte3annr9w1555391620" does not exist at character 27
Statement: SELECT * FROM temp0000238536 WHERE CONTROLE='L'
Date: 2026-08-20 07:12:57 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: select * from rs_caixa_qr(ZTE3ANNR9W1555391620)
Date: 2026-08-20 08:58:29 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: select * from rs_caixa_qr(ZTE3ANNR9W1555391620)
Date: 2026-08-20 08:58:29 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
10 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Aug 20 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-08-20 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-08-20 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Date: 2026-08-20 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
11 2 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #11
Day Hour Count Aug 20 09 2 - LOG: process 1568147 still waiting for ShareLock on transaction 4736962 after 1000.095 ms
- LOG: process 1568147 still waiting for ShareLock on transaction 4736962 after 42624.860 ms
Detail: Process holding the lock: 1499452. Wait queue: 1568147.
Context: while updating tuple (77181,70) 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-20 09:55:15 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Detail: Process holding the lock: 1499452. Wait queue: 1568147.
Context: while updating tuple (77181,70) 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-20 09:55:57 Database: rio Application: psql User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
12 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count Aug 20 08 1 11 1 - LOG: process 1430557 still waiting for AccessExclusiveLock on relation 4040540 of database 358220 after 1000.197 ms
- LOG: process 1631673 still waiting for AccessExclusiveLock on relation 4058902 of database 358220 after 1000.089 ms
Detail: Process holding the lock: 1432694. Wait queue: 1430557.
Statement: DROP TABLE IF EXISTS temp0000289048;Date: 2026-08-20 08:09:44 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Detail: Process holding the lock: 1657398. Wait queue: 1631673.
Statement: DROP TABLE IF EXISTS temp0000289118;Date: 2026-08-20 11:11:47 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
13 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Aug 20 14 2 - ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
- ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 );
Date: 2026-08-20 14:00:05 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 ); /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1030: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-08-20 14:00:05 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
14 2 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #14
Day Hour Count Aug 20 09 2 - ERROR: process 1499452 detected deadlock while waiting for ShareLock on transaction 4737422 after 1000.120 ms
- ERROR: process 1499452 detected deadlock while waiting for ShareLock on transaction 4737422 after 1000.130 ms
Detail: Process holding the lock: 1568147. Wait queue: .
Context: while updating tuple (18716,95) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028735, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-20 09:55:57 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
Detail: Process holding the lock: 1568147. Wait queue: .
Context: while updating tuple (77181,55) 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 assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 028735, 0507 )' , '/var/www/html/tmp/nf_carga_lotes_0507.xlsx' )Date: 2026-08-20 09:56:02 Database: rio Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log
15 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #15
Day Hour Count Aug 20 08 1 11 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000289048"
Date: 2026-08-20 08:09:44 Log file: /usr/local/pgsql/data/log/serverlog-20.log
Context: automatic vacuum of table "rio.public.temp0000289118"
Date: 2026-08-20 11:11:47 Log file: /usr/local/pgsql/data/log/serverlog-20.log
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Aug 20 03 1 - LOG: database system was shut down at 2026-08-20 03:05:01 -03
Date: 2026-08-20 03:05:03 Log file: /usr/local/pgsql/data/log/serverlog-20.log
17 1 ERROR: function rs_lote_manutencao_itens(...) does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Aug 20 12 1 - ERROR: function rs_lote_manutencao_itens(integer, integer, unknown, unknown, integer, integer, unknown, unknown, unknown, bigint) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(133523,401,'465072742929,216490472041$464191095569,184292748503$464309216273,216385385959$464351549708,216436212121$466210115461,216710348000$465072662736,216489972138$467157103854,216782472839','',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',0216651255779);Date: 2026-08-20 12:25:25 Database: brasilia Application: [unknown] User: intelifix Remote: [local] Log file: /usr/local/pgsql/data/log/serverlog-20.log