pgBadger-
Global information
- Generated on Fri Sep 4 23:50:13 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 37,603 log entries in 11s
- Log start from 2026-09-04 00:00:18 to 2026-09-04 23:49:26
-
Overview
Global Stats
- 352 Number of unique normalized queries
- 4,905 Number of queries
- 7h28m24s Total query duration
- 2026-09-04 00:02:06 First query
- 2026-09-04 23:42:40 Last query
- 6 queries/s at 2026-09-04 23:42:17 Query peak
- 7h28m24s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h28m24s Execute total duration
- 3,481 Number of events
- 12 Number of unique normalized events
- 3,427 Max number of times the same event was reported
- 0 Number of cancellation
- 438 Total number of automatic vacuums
- 1,070 Total number of automatic analyzes
- 31 Number temporary file
- 244.45 MiB Max size of temporary file
- 77.63 MiB Average size of temporary file
- 370 Total number of sessions
- 9 sessions at 2026-09-04 01:05:03 Session peak
- 13d14h17m29s Total duration of sessions
- 52m54s Average duration of sessions
- 13 Average queries per session
- 1m12s Average queries duration per session
- 51m42s Average idle time per session
- 381 Total number of connections
- 4 connections/s at 2026-09-04 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-04 23:42:17 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-09-04 08:05:04 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 6 queries/s Query Peak
- 2026-09-04 23:42:17 Date
Queries duration
Key values
- 7h28m24s 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) Sep 04 00 31 0ms 22s846ms 3s341ms 4s301ms 6s333ms 1m9s 01 40 0ms 3s310ms 978ms 4s300ms 5s628ms 6s766ms 02 16 0ms 2s980ms 1s940ms 4s743ms 5s282ms 5s581ms 03 19 0ms 4s355ms 1s652ms 3s646ms 4s970ms 7s590ms 04 21 0ms 3s75ms 1s438ms 4s279ms 4s862ms 5s948ms 05 27 0ms 9m55s 48s109ms 10s321ms 2m47s 9m55s 06 36 0ms 1m36s 4s807ms 2s886ms 21s883ms 1m38s 07 310 0ms 6m41s 6s56ms 51s58ms 5m14s 6m45s 08 544 150ms 5m30s 3s91ms 43s564ms 3m44s 6m28s 09 584 150ms 6m7s 3s77ms 43s151ms 3m57s 6m58s 10 730 150ms 5m57s 3s562ms 1m22s 5m41s 6m2s 11 426 0ms 5m28s 4s670ms 59s993ms 5m29s 5m59s 12 126 0ms 17m56s 15s922ms 45s720ms 3m44s 17m56s 13 293 0ms 5m11s 4s155ms 22s309ms 3m41s 5m47s 14 530 150ms 5m6s 3s482ms 1m42s 3m47s 6m7s 15 381 0ms 18m24s 8s542ms 1m23s 4m7s 31m22s 16 113 0ms 5m10s 6s398ms 8s232ms 20s118ms 5m47s 17 98 0ms 5m13s 6s984ms 7s565ms 15s760ms 5m45s 18 49 0ms 5m5s 12s965ms 3s541ms 18s684ms 5m50s 19 20 0ms 5m 29s441ms 2s867ms 3s529ms 5m46s 20 111 0ms 5m15s 10s455ms 1m3s 1m18s 6m10s 21 27 0ms 4m58s 21s819ms 5s412ms 6s90ms 5m43s 22 36 0ms 4m52s 16s590ms 6s83ms 43s210ms 4m52s 23 337 0ms 1m1s 5s781ms 1m6s 1m11s 1m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 04 00 11 0 720ms 0ms 156ms 909ms 01 23 0 308ms 255ms 567ms 817ms 02 0 0 0ms 0ms 0ms 0ms 03 3 0 345ms 0ms 0ms 210ms 04 5 0 265ms 0ms 0ms 287ms 05 8 0 337ms 0ms 0ms 704ms 06 23 0 4s964ms 271ms 1s294ms 4s453ms 07 236 0 6s654ms 8s185ms 31s138ms 5m56s 08 442 0 2s843ms 7s943ms 21s722ms 5m35s 09 466 0 3s67ms 7s996ms 14s181ms 5m32s 10 545 0 3s406ms 13s568ms 1m 5m51s 11 303 0 5s190ms 7s183ms 58s968ms 5m29s 12 82 0 22s942ms 2s768ms 43s409ms 6m1s 13 210 0 4s985ms 6s760ms 11s533ms 5m15s 14 393 0 3s351ms 10s607ms 57s942ms 3m49s 15 269 0 11s9ms 15s518ms 1m 5m30s 16 78 0 8s561ms 2s479ms 4s5ms 3m48s 17 68 0 9s478ms 2s542ms 3s690ms 3m49s 18 29 0 20s419ms 305ms 2s375ms 3m47s 19 6 0 1m34s 0ms 0ms 3m39s 20 12 82 12s35ms 35s4ms 1m1s 3m34s 21 8 0 1m9s 0ms 0ms 3m30s 22 12 0 46s677ms 0ms 235ms 3m42s 23 15 320 5s813ms 1m4s 1m5s 1m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 04 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 Sep 04 00 0 2 2.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 3 3.00 0.00% 07 0 5 5.00 0.00% 08 0 13 13.00 0.00% 09 0 12 12.00 0.00% 10 0 13 13.00 0.00% 11 0 10 10.00 0.00% 12 0 5 5.00 0.00% 13 0 8 8.00 0.00% 14 0 12 12.00 0.00% 15 0 9 9.00 0.00% 16 0 5 5.00 0.00% 17 0 4 4.00 0.00% 18 0 1 1.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 0 0.00 0.00% 22 0 2 2.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Sep 04 00 17 0.00/s 01 10 0.00/s 02 10 0.00/s 03 18 0.01/s 04 10 0.00/s 05 11 0.00/s 06 17 0.00/s 07 16 0.00/s 08 24 0.01/s 09 24 0.01/s 10 21 0.01/s 11 23 0.01/s 12 13 0.00/s 13 20 0.01/s 14 23 0.01/s 15 25 0.01/s 16 18 0.01/s 17 15 0.00/s 18 11 0.00/s 19 9 0.00/s 20 13 0.00/s 21 9 0.00/s 22 12 0.00/s 23 12 0.00/s Day Hour Count Average Duration Average idle time Sep 04 00 8 58m3s 57m50s 01 15 1h46s 1h44s 02 11 1h33s 1h30s 03 18 24m40s 24m39s 04 9 1h2m40s 1h2m36s 05 8 1h 57m17s 06 11 58m38s 58m22s 07 14 56m56s 54m42s 08 19 51m13s 49m45s 09 23 52m49s 51m31s 10 24 51m50s 50m1s 11 21 50m11s 48m36s 12 19 53m11s 51m26s 13 12 1h1s 58m20s 14 23 55m12s 53m52s 15 26 47m56s 45m51s 16 18 59m2s 58m22s 17 17 57m11s 56m30s 18 16 51m45s 51m5s 19 9 1h33s 59m28s 20 12 46m12s 44m35s 21 10 1h19s 59m20s 22 9 1h20s 59m13s 23 18 42m18s 40m30s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-09-04 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 381 connections Total
Connections per user
Key values
- intelifix Main User
- 381 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-09-04 01:05:03 Date
Histogram of session times
Key values
- 297 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 370 sessions Total
Sessions per user
Key values
- intelifix Main User
- 370 sessions Total
Sessions per host
Key values
- [local] Main Host
- 370 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 31,949 buffers Checkpoint Peak
- 2026-09-04 14:34:36 Date
- 270.044 seconds Highest write time
- 0.084 seconds Sync time
Checkpoints Wal files
Key values
- 21 files Wal files usage Peak
- 2026-09-04 14:34:36 Date
Checkpoints distance
Key values
- 675.36 Mo Distance Peak
- 2026-09-04 14:34:36 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 04 00 23,685 683.464s 0.097s 683.665s 01 3,832 384.323s 0.196s 384.675s 02 2,006 201.058s 0.043s 201.13s 03 1,944 193.589s 0.065s 193.789s 04 2,842 284.684s 0.078s 284.807s 05 9,790 979.535s 0.15s 979.728s 06 4,954 406.056s 0.006s 406.073s 07 39,058 2,726.484s 0.244s 2,726.797s 08 51,112 3,201.185s 0.389s 3,201.758s 09 65,074 3,239.327s 0.257s 3,239.678s 10 53,011 3,239.317s 0.333s 3,239.767s 11 54,582 3,239.191s 0.37s 3,239.678s 12 36,831 2,636.726s 0.226s 2,637.009s 13 27,630 1,976.479s 0.173s 1,976.775s 14 88,663 3,239.137s 0.437s 3,239.737s 15 90,020 3,130.84s 0.278s 3,131.222s 16 14,495 1,401.11s 0.187s 1,401.415s 17 14,655 1,035.52s 0.298s 1,035.927s 18 4,036 404.992s 0.118s 405.248s 19 39 3.923s 0.007s 3.938s 20 753 308.192s 0.016s 308.217s 21 2,599 260.824s 0.104s 260.973s 22 1,870 187.287s 0.195s 187.51s 23 478 47.945s 0.085s 48.048s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 04 00 0 0 7 511 0.062s 0.011s 01 0 0 1 820 0.064s 0.029s 02 0 0 1 467 0.009s 0.006s 03 0 0 0 432 0.010s 0.011s 04 0 0 1 528 0.043s 0.011s 05 0 0 5 771 0.063s 0.012s 06 0 0 0 88 0.002s 0.003s 07 0 0 26 4,232 0.062s 0.012s 08 0 0 41 6,831 0.063s 0.012s 09 0 0 34 7,510 0.010s 0.012s 10 0 0 66 8,118 0.032s 0.012s 11 0 0 43 7,631 0.063s 0.012s 12 0 0 19 2,991 0.062s 0.012s 13 0 0 15 4,591 0.056s 0.012s 14 0 0 56 7,427 0.063s 0.012s 15 0 0 53 6,886 0.010s 0.012s 16 0 0 8 3,083 0.059s 0.012s 17 0 0 5 2,457 0.063s 0.013s 18 0 0 1 895 0.062s 0.008s 19 0 0 0 9 0.004s 0.002s 20 0 0 2 87 0.008s 0.003s 21 0 0 1 402 0.062s 0.006s 22 0 0 1 571 0.067s 0.009s 23 0 0 0 116 0.062s 0.012s Day Hour Count Avg time (sec) Sep 04 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 Sep 04 00 14,371.12 kB 52,358.00 kB 01 1,837.40 kB 23,886.50 kB 02 1,612.83 kB 11,040.00 kB 03 1,036.20 kB 2,528.80 kB 04 1,492.44 kB 2,100.33 kB 05 9,541.75 kB 16,303.12 kB 06 4,750.67 kB 14,037.67 kB 07 34,367.67 kB 57,223.17 kB 08 56,157.92 kB 96,997.92 kB 09 47,041.33 kB 90,478.75 kB 10 89,374.42 kB 129,468.33 kB 11 59,704.17 kB 99,265.33 kB 12 24,940.42 kB 70,694.92 kB 13 20,601.75 kB 44,490.33 kB 14 76,735.08 kB 188,008.67 kB 15 71,817.25 kB 156,658.67 kB 16 12,057.58 kB 66,479.25 kB 17 5,978.92 kB 23,979.58 kB 18 2,900.50 kB 10,320.00 kB 19 120.00 kB 6,505.00 kB 20 9,807.33 kB 23,860.00 kB 21 1,954.50 kB 15,694.67 kB 22 1,395.67 kB 8,031.22 kB 23 511.67 kB 4,255.33 kB -
Temporary Files
Size of temporary files
Key values
- 488.91 MiB Temp Files size Peak
- 2026-09-04 05:31:54 Date
Number of temporary files
Key values
- 4 per second Temp Files Peak
- 2026-09-04 05:32:02 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 04 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 20 1.30 GiB 66.52 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 2 140.00 MiB 70.00 MiB 10 1 104.00 MiB 104.00 MiB 11 2 208.00 MiB 104.00 MiB 12 2 208.00 MiB 104.00 MiB 13 0 0 0 14 2 208.00 MiB 104.00 MiB 15 2 208.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 16 1.00 GiB 36.45 MiB 244.45 MiB 64.14 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-04 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-04 05:31:54 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 11 1.05 GiB 36.00 MiB 104.00 MiB 97.82 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029354, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 15:30:18 Duration: 18m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029467, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 12:51:44 Duration: 17m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029443, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-04 10:14:24 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 4 304.28 MiB 56.57 MiB 93.09 MiB 76.07 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-04 05:30:40 Duration: 38s185ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-04 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 244.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-04 05:31:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 244.45 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-04 05:31:54 - 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-09-04 12:31:32 - 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-09-04 14:15:10 - 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-09-04 14:28:22 - 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-09-04 15:08:17 - 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-09-04 12:03:55 - 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-09-04 11:53:34 - 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-09-04 11:29:35 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-09-04 09:57:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 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-09-04 10:53:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 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-09-04 15:36:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 93.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-04 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 93.09 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-04 05:30:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 61.52 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-04 05:30:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 56.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-09-04 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 40.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-04 05:32:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 40.29 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-04 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 40.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-04 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 40.28 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-09-04 05:31:59 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 7.12 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-04 09:37:44 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 7.12 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_09
Database rio - 2026-09-04 09:37:44 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (121) Main table analyzed (database rio)
- 1,070 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 121 rio.pg_catalog.pg_class 58 rio.pg_catalog.pg_type 50 brasilia.pg_catalog.pg_attribute 50 brasilia.public.temp0000239592 46 rio.public.usuarios 44 rio.public.temp0000290657 38 rio.pg_catalog.pg_index 34 brasilia.public.temp0000239640 33 rio.public.temp0000290643 31 contagem.pg_catalog.pg_attribute 27 brasilia.pg_catalog.pg_class 25 rio.pg_catalog.pg_depend 23 brasilia.pg_catalog.pg_type 22 contagem.public.usuarios 20 contagem.public.temp0000227067 19 contagem.pg_catalog.pg_class 18 contagem.public.temp0000227061 17 rio.public.temp0000290226 16 rio.public.temp0000290627 15 rio.public.temp0000290689 15 rio.public.temp0000290641 15 rio.public.temp0000290651 14 brasilia.pg_catalog.pg_index 14 contagem.pg_catalog.pg_type 14 rio.public.temp0000290230 13 rio.public.temp0000290635 12 brasilia.pg_catalog.pg_depend 11 rio.public.temp0000290679 11 rio.public.temp0000290645 11 rio.public.temp0000290026 11 brasilia.public.temp0000239594 11 rio.public.temp0000290616 10 rio.public.temp0000290733 10 rio.public.temp0000290637 10 brasilia.public.usuarios 9 rio.public.temp0000290653 9 contagem.public.temp0000227037 9 contagem.pg_catalog.pg_index 8 rio.public.temp0000290709 8 rio.public.temp0000290721 8 brasilia.public.temp0000239658 7 rio.public.temp0000290711 7 rio.public.temp0000290412 7 rio.public.temp0000290232 7 contagem.pg_catalog.pg_depend 6 rio.public.temp0000290629 5 rio.public.temp0000290735 5 contagem.public.temp0000227071 5 rio.pg_catalog.pg_shdepend 4 brasilia.public.temp0000239680 4 rio.public.tmp_drill_0302 4 postgres.pg_catalog.pg_shdepend 4 brasilia.public.temp0000239586 4 rio.public.temp0000290655 3 brasilia.public.temp0000239632 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.tmp_drill_0320 3 brasilia.auditor.auditor_2026_09 3 rio.public.temp0000290673 3 rio.public.temp0000290737 2 rio.auditor.auditor_2026_09 2 rio.public.temp0000290725 2 contagem.pg_catalog.pg_shdepend 2 rio.public.temp0000290234 2 brasilia.public.temp0000239666 2 brasilia.public.nf_entrada 2 rio.public.temp0000290723 2 rio.public.temp0000290743 2 brasilia.public.temp0000239654 1 rio.public.temp0000290715 1 rio.public.temp0000290677 1 rio.public.temp0000290727 1 rio.public.temp0000290667 1 rio.public.temp0000290719 1 brasilia.public.temp0000239638 1 rio.public.temp0000290739 1 brasilia.public.temp0000239634 1 brasilia.public.temp0000239630 1 rio.public.temp0000290693 1 contagem.auditor.auditor_2026_09 1 brasilia.public.parametros 1 rio.public.temp0000290659 1 brasilia.public.temp0000239652 1 brasilia.public.temp0000239590 1 brasilia.public.tmp_drill_0173 1 brasilia.public.temp0000239648 1 contagem.public.temp0000227073 1 brasilia.public.temp0000239614 1 brasilia.public.temp0000239646 1 rio.public.temp0000290675 1 rio.public.temp0000290647 1 rio.public.temp0000290695 1 rio.public.temp0000290699 1 Total 1,070 Vacuums per table
Key values
- pg_catalog.pg_attribute (45) Main table vacuumed on database rio
- 438 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 45 40 0 0 0 0 0 22,884 5,704 8,395,072 371 9,329 rio.public.temp0000290643 31 0 0 0 0 0 0 19,488 401 1,666,200 0 0 rio.public.temp0000290657 31 0 0 0 0 0 0 8,601 2,094 3,157,904 0 0 rio.pg_catalog.pg_class 22 21 0 0 0 0 0 4,238 1,322 2,112,565 99 349 rio.pg_catalog.pg_type 20 19 0 0 0 0 0 1,813 493 703,928 67 212 contagem.public.usuarios 20 0 0 0 0 0 0 111 91 43,943 0 0 brasilia.pg_catalog.pg_attribute 16 16 0 0 0 0 0 8,312 1,799 3,210,264 56 1,299 rio.public.temp0000290689 15 0 0 0 0 0 0 16,382 149 1,151,538 0 0 rio.public.temp0000290641 13 0 0 0 0 0 0 753 263 384,937 0 0 rio.public.temp0000290230 13 0 0 0 0 0 0 739 207 280,760 0 0 rio.pg_catalog.pg_index 12 12 0 0 0 0 0 554 157 194,514 26 88 rio.public.temp0000290679 11 0 0 0 0 0 0 17,776 1,816 3,346,345 0 0 rio.public.temp0000290026 11 0 0 0 0 0 0 622 89 89,850 0 0 rio.public.tmp_drill_0302 11 4 0 0 0 0 0 115 50 63,127 2 88 brasilia.pg_catalog.pg_type 10 10 0 0 0 0 0 900 190 304,774 12 42 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 2,952 1,017 1,586,128 47 380 contagem.pg_catalog.pg_attribute 9 9 0 0 0 0 0 4,657 1,523 2,580,911 18 477 brasilia.pg_catalog.pg_class 9 9 0 0 0 0 0 1,668 366 676,171 25 87 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 10,283 3,341 13,409,403 1,895 9,139 rio.public.temp0000290721 8 0 0 0 0 0 0 12,451 1,805 3,031,177 0 0 contagem.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,158 396 616,141 61 120 rio.public.temp0000290733 6 0 0 0 0 0 0 252 32 20,186 0 0 rio.public.usuarios 6 4 0 0 0 0 0 128 42 85,232 5 6 brasilia.pg_catalog.pg_statistic 5 5 0 0 0 0 0 5,564 1,652 6,075,894 1,194 6,290 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 747 279 382,307 9 31 brasilia.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,317 447 697,120 19 180 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 221 50 52,646 7 23 rio.public.temp0000290735 5 0 0 0 0 0 0 7,116 19 422,794 0 0 rio.public.temp0000290412 4 0 0 0 0 0 0 151 21 11,930 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,753 519 2,370,727 161 453 brasilia.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 535 139 635,410 27 65 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 344 136 196,128 4 9 brasilia.public.tmp_drill_0173 3 1 0 0 0 0 0 353 3 62,906 0 0 rio.public.temp0000290709 3 0 0 0 0 0 0 113 16 9,325 0 0 rio.auditor.auditor_2026_09 3 0 0 0 0 0 0 132,746 53,289 74,954,149 39,385 839,283 rio.public.tmp_drill_0320 3 3 0 0 0 0 0 1,859 9 307,859 0 0 rio.public.temp0000290743 2 0 0 0 0 0 0 228 12 15,361 0 0 rio.public.temp0000290637 2 0 0 0 0 0 0 96 11 7,413 0 0 rio.public.temp0000290711 2 0 0 0 0 0 0 200 105 173,289 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 569 230 415,178 3 24 rio.public.temp0000290725 2 0 0 0 0 0 0 118 11 8,742 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 97 45 35,366 2 4 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,797 171 697,709 137 1,221 brasilia.public.temp0000239666 2 0 0 0 0 0 0 502 8 30,824 0 0 rio.public.temp0000290234 2 0 0 0 0 0 0 132 12 9,499 0 0 brasilia.auditor.auditor_2026_09 2 0 0 0 0 0 0 16,960 10,120 13,092,078 2,964 58,862 rio.public.temp0000290651 2 0 0 0 0 0 0 16 10 2,633 0 0 rio.public.temp0000290655 2 0 0 0 0 0 0 72 12 5,855 0 0 rio.public.temp0000290699 1 0 0 0 0 0 0 8 5 1,312 0 0 rio.public.temp0000290695 1 0 0 0 0 0 0 8 5 1,311 0 0 brasilia.public.temp0000239640 1 0 0 0 0 0 0 4 3 774 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 152 4 18,492 0 0 rio.public.temp0000290719 1 0 0 0 0 0 0 1,778 4 105,505 0 0 contagem.public.temp0000227073 1 0 0 0 0 0 0 114 6 7,695 0 0 rio.public.temp0000290739 1 0 0 0 0 0 0 106 6 7,208 0 0 rio.public.temp0000290659 1 0 0 0 0 0 0 86 85 167,323 0 0 rio.public.temp0000290677 1 0 0 0 0 0 0 64 6 4,625 0 0 rio.public.temp0000290667 1 0 0 0 0 0 0 1,776 4 105,387 0 0 rio.public.temp0000290727 1 0 0 0 0 0 0 65 6 4,695 0 0 brasilia.public.temp0000239652 1 0 0 0 0 0 0 251 4 15,412 0 0 brasilia.public.parametros 1 1 0 0 0 0 0 245 110 43,237 0 0 rio.public.temp0000290737 1 0 0 0 0 0 0 8 5 1,332 0 0 contagem.auditor.auditor_2026_09 1 0 0 0 0 0 0 6,725 4,915 6,260,188 862 14,625 brasilia.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 145 48 78,822 5 6 Total 438 215 0 0 0 0 0 322,978 95,889 154,607,530 47,463 942,692 Vacuum throughput per table
Key values
- auditor.auditor_2026_09 (17.34) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 2.92 rio.public.temp0000290643 0 0 0.48 rio.public.temp0000290657 0 0 0.4 rio.pg_catalog.pg_class 0 0 0.58 rio.pg_catalog.pg_type 0 0 0.21 contagem.public.usuarios 0 0 0.01 brasilia.pg_catalog.pg_attribute 0 0 1.03 rio.public.temp0000290689 0 0 0.47 rio.public.temp0000290641 0 0 0.02 rio.public.temp0000290230 0 0 0.02 rio.pg_catalog.pg_index 0 0 0.14 rio.public.temp0000290679 0 0 0.52 rio.public.temp0000290026 0 0 0.02 rio.public.tmp_drill_0302 0 0 0 brasilia.pg_catalog.pg_type 0 0 0.25 rio.pg_catalog.pg_depend 0 0 0.64 contagem.pg_catalog.pg_attribute 0 0 1.07 brasilia.pg_catalog.pg_class 0 0 0.55 rio.pg_catalog.pg_statistic 0 0 1.15 rio.public.temp0000290721 0 0 0.34 contagem.pg_catalog.pg_shdepend 0 0 0.63 rio.public.temp0000290733 0 0 0.02 rio.public.usuarios 0 0 0 brasilia.pg_catalog.pg_statistic 0 0 0.63 contagem.pg_catalog.pg_class 0 0 0.64 brasilia.pg_catalog.pg_depend 0 0 0.46 brasilia.pg_catalog.pg_index 0 0 0.1 rio.public.temp0000290735 0 0 0.2 rio.public.temp0000290412 0 0 0 rio.pg_toast.pg_toast_2619 0 0 0.24 brasilia.pg_toast.pg_toast_2619 0 0 0.06 contagem.pg_catalog.pg_type 0 0 0.34 brasilia.public.tmp_drill_0173 0 0 0.01 rio.public.temp0000290709 0 0 0.01 rio.auditor.auditor_2026_09 0 0 17.34 rio.public.tmp_drill_0320 0 0 0.05 rio.public.temp0000290743 0 0 0.02 rio.public.temp0000290637 0 0 0.01 rio.public.temp0000290711 0 0 0.01 contagem.pg_catalog.pg_depend 0 0 0.32 rio.public.temp0000290725 0 0 0 contagem.pg_catalog.pg_index 0 0 0.06 contagem.pg_catalog.pg_statistic 0 0 0.11 brasilia.public.temp0000239666 0 0 0 rio.public.temp0000290234 0 0 0 brasilia.auditor.auditor_2026_09 0 0 2.97 rio.public.temp0000290651 0 0 0 rio.public.temp0000290655 0 0 0 rio.public.temp0000290699 0 0 0 rio.public.temp0000290695 0 0 0 brasilia.public.temp0000239640 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000290719 0 0 0.04 contagem.public.temp0000227073 0 0 0 rio.public.temp0000290739 0 0 0 rio.public.temp0000290659 0 0 0.01 rio.public.temp0000290677 0 0 0 rio.public.temp0000290667 0 0 0.04 rio.public.temp0000290727 0 0 0 brasilia.public.temp0000239652 0 0 0 brasilia.public.parametros 0 0 0.07 rio.public.temp0000290737 0 0 0 contagem.auditor.auditor_2026_09 0 0 1.61 brasilia.pg_catalog.pg_shdepend 0 0 0.09 Total 0 0 36.91 Tuples removed per table
Key values
- pg_catalog.pg_attribute (177789) Main table with removed tuples on database rio
- 391555 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 45 40 177,789 1,124,544 49,407 334 26,743 brasilia.pg_catalog.pg_attribute 16 16 73,109 349,162 0 152 9,088 rio.public.tmp_drill_0320 3 3 28,035 28,382 0 0 714 contagem.pg_catalog.pg_attribute 9 9 25,837 213,370 0 0 4,729 rio.pg_catalog.pg_statistic 9 9 14,136 74,848 219 0 11,574 rio.auditor.auditor_2026_09 3 0 9,334 10,717,486 0 0 507,773 brasilia.pg_catalog.pg_statistic 5 5 8,603 40,092 0 0 5,360 contagem.pg_catalog.pg_shdepend 7 7 7,747 95,144 72 0 875 rio.pg_catalog.pg_type 20 19 7,375 47,320 1,722 11 1,408 rio.pg_catalog.pg_depend 10 10 7,116 194,431 2,784 0 1,813 contagem.pg_catalog.pg_statistic 2 2 5,331 14,813 0 0 2,022 brasilia.public.tmp_drill_0173 3 1 5,176 25,880 10,352 0 390 rio.pg_catalog.pg_class 22 21 3,290 102,124 4,500 102 3,662 brasilia.pg_catalog.pg_type 10 10 3,273 22,150 4 10 654 brasilia.pg_catalog.pg_depend 5 5 2,948 90,765 0 11 873 rio.pg_catalog.pg_index 12 12 2,254 23,480 443 13 606 brasilia.pg_catalog.pg_index 5 5 1,415 9,440 0 0 256 contagem.public.usuarios 20 0 1,290 480 0 0 40 contagem.pg_catalog.pg_depend 2 2 1,283 37,546 0 0 356 rio.pg_toast.pg_toast_2619 4 4 1,209 2,143 0 0 1,156 brasilia.pg_catalog.pg_class 9 9 954 34,567 0 28 1,263 contagem.pg_catalog.pg_class 5 5 848 17,434 0 0 640 rio.public.tmp_drill_0302 11 4 765 6,204 2,529 0 102 brasilia.pg_catalog.pg_shdepend 1 1 734 13,571 0 0 125 contagem.pg_catalog.pg_type 4 4 409 9,000 0 15 240 brasilia.auditor.auditor_2026_09 2 0 378 1,553,359 0 0 70,704 brasilia.pg_toast.pg_toast_2619 4 4 344 504 0 1 274 rio.public.usuarios 6 4 272 4,012 958 0 114 contagem.pg_toast.pg_toast_2619 1 1 132 115 0 0 61 contagem.pg_catalog.pg_index 2 2 122 3,796 0 7 92 brasilia.public.parametros 1 1 47 377 0 0 108 rio.public.temp0000290412 4 0 0 6,976 0 67 157 rio.public.temp0000290733 6 0 0 26,415 0 163 605 rio.public.temp0000290743 2 0 0 9,255 0 44 212 rio.public.temp0000290699 1 0 0 1,360 0 44 84 rio.public.temp0000290637 2 0 0 2,515 0 99 157 rio.public.temp0000290695 1 0 0 1,294 0 47 81 brasilia.public.temp0000239640 1 0 0 3,291 0 0 256 rio.public.temp0000290719 1 0 0 25,109 0 0 1,792 rio.public.temp0000290679 11 0 0 276,145 0 0 19,712 rio.public.temp0000290711 2 0 0 8,020 0 72 184 rio.public.temp0000290641 13 0 0 48,194 0 367 1,105 rio.public.temp0000290709 3 0 0 4,551 0 109 275 rio.public.temp0000290643 31 0 0 300,948 0 994 21,278 contagem.public.temp0000227073 1 0 0 1,361 0 22 106 rio.public.temp0000290739 1 0 0 1,611 0 30 98 rio.public.temp0000290026 11 0 0 31,520 0 209 719 rio.public.temp0000290659 1 0 0 1,245 0 50 78 rio.public.temp0000290725 2 0 0 8,431 0 63 193 rio.public.temp0000290677 1 0 0 2,467 0 8 56 rio.public.temp0000290689 15 0 0 281,712 0 167 20,057 rio.public.temp0000290721 8 0 0 200,895 0 0 14,336 rio.public.temp0000290667 1 0 0 25,075 0 0 1,792 rio.public.temp0000290727 1 0 0 1,080 0 7 57 brasilia.public.temp0000239652 1 0 0 3,290 0 0 256 rio.public.temp0000290230 13 0 0 36,581 0 260 828 rio.public.temp0000290737 1 0 0 1,566 0 35 93 contagem.auditor.auditor_2026_09 1 0 0 724,786 0 0 33,394 rio.public.temp0000290657 31 0 0 215,935 0 890 14,182 brasilia.public.temp0000239666 2 0 0 6,582 0 0 512 rio.public.temp0000290234 2 0 0 5,062 0 44 116 rio.public.temp0000290651 2 0 0 2,758 0 88 168 rio.public.temp0000290735 5 0 0 125,568 0 0 8,960 rio.public.temp0000290655 2 0 0 2,482 0 8 56 Total 438 215 391,555 17,250,619 72,990 4,571 795,770 Pages removed per table
Key values
- public.temp0000290643 (994) Main table with removed pages on database rio
- 4571 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000290643 31 0 0 994 rio.public.temp0000290657 31 0 0 890 rio.public.temp0000290641 13 0 0 367 rio.pg_catalog.pg_attribute 45 40 177789 334 rio.public.temp0000290230 13 0 0 260 rio.public.temp0000290026 11 0 0 209 rio.public.temp0000290689 15 0 0 167 rio.public.temp0000290733 6 0 0 163 brasilia.pg_catalog.pg_attribute 16 16 73109 152 rio.public.temp0000290709 3 0 0 109 rio.pg_catalog.pg_class 22 21 3290 102 rio.public.temp0000290637 2 0 0 99 rio.public.temp0000290651 2 0 0 88 rio.public.temp0000290711 2 0 0 72 rio.public.temp0000290412 4 0 0 67 rio.public.temp0000290725 2 0 0 63 rio.public.temp0000290659 1 0 0 50 rio.public.temp0000290695 1 0 0 47 rio.public.temp0000290743 2 0 0 44 rio.public.temp0000290699 1 0 0 44 rio.public.temp0000290234 2 0 0 44 rio.public.temp0000290737 1 0 0 35 rio.public.temp0000290739 1 0 0 30 brasilia.pg_catalog.pg_class 9 9 954 28 contagem.public.temp0000227073 1 0 0 22 contagem.pg_catalog.pg_type 4 4 409 15 rio.pg_catalog.pg_index 12 12 2254 13 rio.pg_catalog.pg_type 20 19 7375 11 brasilia.pg_catalog.pg_depend 5 5 2948 11 brasilia.pg_catalog.pg_type 10 10 3273 10 rio.public.temp0000290677 1 0 0 8 rio.public.temp0000290655 2 0 0 8 contagem.pg_catalog.pg_index 2 2 122 7 rio.public.temp0000290727 1 0 0 7 brasilia.pg_toast.pg_toast_2619 4 4 344 1 rio.pg_toast.pg_toast_2619 4 4 1209 0 brasilia.public.temp0000239640 1 0 0 0 brasilia.public.tmp_drill_0173 3 1 5176 0 contagem.pg_toast.pg_toast_2619 1 1 132 0 rio.public.temp0000290719 1 0 0 0 rio.public.temp0000290679 11 0 0 0 contagem.pg_catalog.pg_depend 2 2 1283 0 rio.auditor.auditor_2026_09 3 0 9334 0 contagem.public.usuarios 20 0 1290 0 rio.public.temp0000290721 8 0 0 0 rio.public.temp0000290667 1 0 0 0 brasilia.public.temp0000239652 1 0 0 0 contagem.pg_catalog.pg_attribute 9 9 25837 0 contagem.pg_catalog.pg_shdepend 7 7 7747 0 contagem.pg_catalog.pg_statistic 2 2 5331 0 brasilia.pg_catalog.pg_statistic 5 5 8603 0 brasilia.public.parametros 1 1 47 0 contagem.pg_catalog.pg_class 5 5 848 0 rio.public.usuarios 6 4 272 0 contagem.auditor.auditor_2026_09 1 0 0 0 brasilia.public.temp0000239666 2 0 0 0 brasilia.pg_catalog.pg_shdepend 1 1 734 0 brasilia.pg_catalog.pg_index 5 5 1415 0 rio.public.tmp_drill_0302 11 4 765 0 rio.pg_catalog.pg_depend 10 10 7116 0 brasilia.auditor.auditor_2026_09 2 0 378 0 rio.pg_catalog.pg_statistic 9 9 14136 0 rio.public.temp0000290735 5 0 0 0 rio.public.tmp_drill_0320 3 3 28035 0 Total 438 215 391,555 4,571 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Sep 04 00 1 1 01 0 7 02 0 0 03 0 0 04 0 1 05 6 3 06 0 1 07 40 79 08 44 115 09 41 117 10 51 159 11 45 152 12 16 25 13 19 67 14 71 145 15 81 133 16 11 30 17 5 22 18 3 7 19 0 0 20 0 0 21 2 4 22 1 1 23 1 1 - 7.12 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 4 13m46s 1s51ms 9m21s 3m26s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9,2C584F2F8F6B,4C126539E57D,4C12653D19FF,BC644BDC4112,5819F8490668,BC644BDEB78F,A89FECC52743,F8F532513195,5819F8491B76,BC644BCD054E,2C9569F4C441,A89FECC5650F,4C12653A3C12', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284794, 449, '71505585850012114605,216520404243,216409998585,216873513643,216874537895,216545014142,216398974345,216510642034,216397075776,216504994748,216832008403,216833403354,216869062749,216553736991,216348220313,216909123134,216410125972', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 14:26:56 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 1m51s 1m51s 1m51s 1m51s call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 14:27:02 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 00:05:24 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 15:05:11 Database: rio User: intelifix Remote: [local] Application: psql
Queries that waited the most
Rank Wait time Query 1 9m21s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4$518009117784,BC644BD251E8$519061058994,4C1265E8F2D9$518243485556,2C584F2F8F6B$519017721320,4C126539E57D$519058124344,4C12653D19FF$518012526169,BC644BDC4112$518165221729,5819F8490668$518040047783,BC644BDEB78F$518123254862,A89FECC52743$518184284660,F8F532513195$518166096074,5819F8491B76$517024161222,BC644BCD054E$518207093333,2C9569F4C441$518128062628,A89FECC5650F$519020077680,4C12653A3C12', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-09-04 15:30:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 3m33s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4$518009117784,BC644BD251E8$519061058994,4C1265E8F2D9', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-09-04 15:30:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 1m51s CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-09-04 14:26:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 49s925ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284794, 449, '71505585850012114605,216520404243$71501985850010800603,216409998585$71821185850056804764,216873513643$71821185850057105006,216874537895$71505685850012214368,216545014142$71432285850008714510,216398974345$71503785850011516983,216510642034$71431885850008302740,216397075776$71502885850011202238,216504994748$71800985850050006267,216832008403$71802385850049203333,216833403354$71819585850055907275,216869062749$71507585850012618772,216553736991$71427485850006023475,216348220313$71826885850059006225,216909123134$71501985850010801877,216410125972', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-09-04 14:26:55 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s51ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (56890, 413, '929240576120,203543187A0A$929240805625,8C9A8F5D74A7$929240587984,20354319BE72$929240769457,8C9A8F5997AF$929240681275,20354353F14D$929240416531,647B1EEDF575$929240727868,20354358EB54$929240718276,20354357E50C$929240279955,DC927270C9CA$929240111167,CC5830FF59C2$929240718531,20354357EC05$929240262652,B0924A126972$929240428049,D8CF615F5756$929240205223,9C247231BEFF$929240775991,8C9A8F5A4A59$929240078493,94988F2F1B64$929240818327,8C9A8F5ED00E', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-09-04 14:53:58 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 3,247 Total read queries
- 1,182 Total write queries
Queries by database
Key values
- rio Main database
- 3,051 Requests
- 5h40m27s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 4,782 Requests
User Request type Count Duration etiquetas Total 17 4s803ms select 17 4s803ms intelifix Total 4,782 7h27m37s copy to 402 41m22s ddl 780 45m11s others 476 41m42s select 3,124 5h19m20s lenon Total 106 42s880ms select 106 42s880ms Duration by user
Key values
- 7h27m37s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 17 4s803ms select 17 4s803ms intelifix Total 4,782 7h27m37s copy to 402 41m22s ddl 780 45m11s others 476 41m42s select 3,124 5h19m20s lenon Total 106 42s880ms select 106 42s880ms Queries by host
Key values
- [local] Main host
- 4,905 Requests
- 7h28m24s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 3,836 Requests
- 3h26m11s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-04 11:23:54 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,546 100-500ms duration
Slowest individual queries
Rank Duration Query 1 18m24s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029354, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-09-04 15:30:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
2 17m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029467, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');[ Date: 2026-09-04 12:51:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 9m55s analyze verbose;[ Date: 2026-09-04 05:09:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m22s SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9,2C584F2F8F6B,4C126539E57D,4C12653D19FF,BC644BDC4112,5819F8490668,BC644BDEB78F,A89FECC52743,F8F532513195,5819F8491B76,BC644BCD054E,2C9569F4C441,A89FECC5650F,4C12653A3C12', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-09-04 15:30:18 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 6m41s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 07:11:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m23s analyze verbose;[ Date: 2026-09-04 05:16:20 - Database: brasilia - User: intelifix - Remote: [local] - Application: psql ]
7 6m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 09:11:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 5m57s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029443, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-04 10:14:24 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 5m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029415, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-04 07:27:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
10 5m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 10:10:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m36s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029457, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-04 10:39:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
12 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029430, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-04 08:58:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
13 5m28s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029460, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-04 11:21:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 15:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m27s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029431, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-04 09:37:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 5m27s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 11:10:28 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m23s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029462, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-09-04 11:35:38 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 20:10:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 17:10:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-09-04 12:10:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h50m9s 197 152ms 18m24s 33s549ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 04 07 20 11m25s 34s282ms 08 27 6m53s 15s325ms 09 25 8m58s 21s534ms 10 29 14m33s 30s129ms 11 15 12m52s 51s485ms 12 7 20m33s 2m56s 13 18 5m57s 19s880ms 14 25 6m22s 15s298ms 15 21 22m12s 1m3s 16 5 13s679ms 2s735ms 17 4 3s922ms 980ms 18 1 1s125ms 1s125ms [ User: intelifix - Total duration: 1h50m9s - Times executed: 197 ]
[ Application: [unknown] - Total duration: 1h50m9s - Times executed: 197 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029354, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 15:30:18 Duration: 18m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029467, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 12:51:44 Duration: 17m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029443, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-04 10:14:24 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h30m49s 48 1s329ms 6m41s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 07 3 7m19s 2m26s 08 3 5m30s 1m50s 09 3 6m23s 2m7s 10 3 6m6s 2m2s 11 3 5m49s 1m56s 12 3 5m28s 1m49s 13 3 5m18s 1m46s 14 3 5m23s 1m47s 15 3 5m52s 1m57s 16 3 5m31s 1m50s 17 3 5m30s 1m50s 18 3 5m21s 1m47s 19 3 5m16s 1m45s 20 3 5m33s 1m51s 21 3 5m14s 1m44s 22 3 5m8s 1m42s [ User: intelifix - Total duration: 1h30m49s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m49s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 07:11:43 Duration: 6m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 09:11:09 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 10:10:49 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: psql
3 1h8m5s 47 256ms 4m4s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 04 07 3 4m52s 1m37s 08 2 3m35s 1m47s 09 3 4m13s 1m24s 10 3 4m44s 1m34s 11 3 4m16s 1m25s 12 3 4m13s 1m24s 13 3 4m8s 1m22s 14 3 4m11s 1m23s 15 3 4m25s 1m28s 16 3 4m19s 1m26s 17 3 4m19s 1m26s 18 3 4m10s 1m23s 19 3 4m9s 1m23s 20 3 4m16s 1m25s 21 3 3m59s 1m19s 22 3 4m10s 1m23s [ User: intelifix - Total duration: 1h8m5s - Times executed: 47 ]
[ Application: psql - Total duration: 1h8m5s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 10:15:49 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 07:17:02 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 17:14:48 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
4 25m26s 1,047 150ms 9m22s 1s458ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 04 06 2 1s745ms 872ms 07 85 49s414ms 581ms 08 174 1m40s 577ms 09 172 1m58s 688ms 10 181 1m58s 654ms 11 107 1m4s 602ms 12 24 16s100ms 670ms 13 52 35s309ms 679ms 14 133 2m25s 1s94ms 15 71 13m48s 11s667ms 16 29 30s889ms 1s65ms 17 17 17s516ms 1s30ms [ User: intelifix - Total duration: 25m26s - Times executed: 1047 ]
[ Application: [unknown] - Total duration: 25m26s - Times executed: 1047 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9,2C584F2F8F6B,4C126539E57D,4C12653D19FF,BC644BDC4112,5819F8490668,BC644BDEB78F,A89FECC52743,F8F532513195,5819F8491B76,BC644BCD054E,2C9569F4C441,A89FECC5650F,4C12653A3C12', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Duration: 9m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Duration: 3m33s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284794, 449, '71505585850012114605,216520404243,216409998585,216873513643,216874537895,216545014142,216398974345,216510642034,216397075776,216504994748,216832008403,216833403354,216869062749,216553736991,216348220313,216909123134,216410125972', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 14:26:56 Duration: 50s638ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 19m5s 3 2m47s 9m55s 6m21s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 05 3 19m5s 6m21s [ User: intelifix - Total duration: 19m5s - Times executed: 3 ]
[ Application: psql - Total duration: 19m5s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-04 05:09:56 Duration: 9m55s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-04 05:16:20 Duration: 6m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-04 05:19:07 Duration: 2m47s Database: contagem User: intelifix Remote: [local] Application: psql
6 9m11s 155 176ms 2m 3s559ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 00 6 35s732ms 5s955ms 01 6 14s316ms 2s386ms 02 6 13s35ms 2s172ms 03 5 11s529ms 2s305ms 04 6 11s931ms 1s988ms 05 4 13s323ms 3s330ms 07 11 27s507ms 2s500ms 08 12 36s417ms 3s34ms 09 12 33s386ms 2s782ms 10 12 42s432ms 3s536ms 11 12 48s575ms 4s47ms 12 7 8s801ms 1s257ms 13 8 16s503ms 2s62ms 14 12 2m42s 13s534ms 15 10 34s441ms 3s444ms 16 6 8s956ms 1s492ms 17 6 6s611ms 1s101ms 18 4 2s288ms 572ms 21 5 11s839ms 2s367ms 22 5 11s675ms 2s335ms [ User: intelifix - Total duration: 9m11s - Times executed: 155 ]
[ Application: psql - Total duration: 9m11s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 14:27:02 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 00:05:24 Duration: 22s846ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 15:05:11 Duration: 10s355ms Database: rio User: intelifix Remote: [local] Application: psql
7 8m31s 43 10s8ms 45s157ms 11s892ms create table temp0000290657 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 08 11 1m53s 10s300ms 09 7 1m53s 16s273ms 10 24 4m32s 11s372ms 11 1 11s226ms 11s226ms [ User: intelifix - Total duration: 8m31s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m31s - Times executed: 43 ]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 09:25:03 Duration: 45s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:15:30 Duration: 12s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:25:58 Duration: 11s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 8m15s 90 1s242ms 1m36s 5s504ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 06 1 1m36s 1m36s 07 7 21s50ms 3s7ms 08 5 33s709ms 6s741ms 09 2 13s912ms 6s956ms 10 14 1m8s 4s886ms 11 6 31s64ms 5s177ms 12 2 5s210ms 2s605ms 13 7 35s927ms 5s132ms 14 12 1m5s 5s475ms 15 11 1m8s 6s244ms 16 7 16s794ms 2s399ms 17 10 24s200ms 2s420ms 18 6 13s899ms 2s316ms [ User: intelifix - Total duration: 8m15s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 8m15s - Times executed: 90 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-04 06:59:12 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-04', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-04 08:50:51 Duration: 19s702ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-04', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-04 14:15:53 Duration: 11s833ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 8m7s 42 10s26ms 42s586ms 11s613ms create table temp0000290643 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 07 12 2m34s 12s907ms 08 9 1m36s 10s755ms 09 9 1m33s 10s418ms 10 12 2m22s 11s858ms [ User: intelifix - Total duration: 8m7s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8m7s - Times executed: 42 ]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 07:19:41 Duration: 42s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:08:08 Duration: 12s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:07:13 Duration: 12s256ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 7m10s 215 150ms 10s176ms 2s call rs_giga_triagem (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 00 9 26s537ms 2s948ms 01 11 17s730ms 1s611ms 02 10 18s17ms 1s801ms 03 11 18s822ms 1s711ms 04 10 16s949ms 1s694ms 05 10 16s418ms 1s641ms 06 7 15s814ms 2s259ms 07 10 22s867ms 2s286ms 08 7 17s203ms 2s457ms 09 9 16s797ms 1s866ms 10 11 16s546ms 1s504ms 11 10 18s140ms 1s814ms 12 8 16s354ms 2s44ms 13 9 15s976ms 1s775ms 14 10 18s250ms 1s825ms 15 11 20s433ms 1s857ms 16 10 21s524ms 2s152ms 17 10 20s25ms 2s2ms 18 9 18s629ms 2s69ms 19 8 18s112ms 2s264ms 20 10 23s829ms 2s382ms 21 8 17s391ms 2s173ms 22 7 17s628ms 2s518ms [ User: intelifix - Total duration: 7m10s - Times executed: 215 ]
[ Application: psql - Total duration: 7m10s - Times executed: 215 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 00:05:34 Duration: 10s176ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 07:25:13 Duration: 7s73ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 20:05:07 Duration: 6s345ms Database: rio User: intelifix Remote: [local] Application: psql
11 6m43s 928 150ms 7s847ms 434ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 06 1 1s448ms 1s448ms 07 80 38s600ms 482ms 08 141 55s601ms 394ms 09 143 1m14s 521ms 10 144 1m1s 429ms 11 99 45s432ms 458ms 12 13 5s954ms 458ms 13 41 17s747ms 432ms 14 120 50s675ms 422ms 15 105 37s18ms 352ms 16 13 5s459ms 419ms 17 19 5s615ms 295ms 18 9 3s49ms 338ms [ User: intelifix - Total duration: 6m43s - Times executed: 928 ]
[ Application: [unknown] - Total duration: 6m43s - Times executed: 928 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241594638191,241691845254,241716654062,241658206786,241670059604,241703495875,241715426074,241621985866,241617843038,241673210002,241699976979,241603128189,241706831622,241675687695,241699350623,241666368390,241716726773,241666116166,241689936280,241682591535,241634886777,241609023232,241679177575,241603290103,241615229113,241651683950,241618351528,241716738693,241617643344,241604211618,241649887489,241699986374,241709726382,241628863642,241682692532,241695141525,241635849307,241637862837,241675822434,241689969112,241712144351,241689990708,241628869298,230048387482,241658793039", "usuario" : "414", "caixa" : "2757498", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-04 09:03:03 Duration: 7s847ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284627", "modelo" : "463", "itens" : "241757681927,241790259618,241794195860,241737824747,241787364857,241704882947,241794333147,241750186481,241720822931,241736886384,241750245454,241758847887,241758945473,241755858190,241789437988,241758077879,241751139515,241735315860,241735019816,241781450319,241755878394,241721654864,241737152527,241735443853,241723835357,241750597890,241785792538,241719906062,241748439497,241754764661,241782316070,241735798589,241722362139,241757627173,241735783740,241721663249,241723269208,241748502434,241755054465,241748808401,241720365456,241749952744,241749928599,241758301718,241752407786,241754254858,241787536063,83350061340976A,241758195770,241748342441,241754605173,241755903650,241782116578,241736691416,241750062833,241755834047,241785784052,241723257792,241706256683,241721751417", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-04 11:13:24 Duration: 3s674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284497", "modelo" : "62", "itens" : "216513429511,216349656277,216619883952,216505405675,216633098686,216874376061,216355115564,216865016371,216755521926,216860243347,216753129919,216798642947,216413347689,216702036481", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-04 07:03:48 Duration: 2s293ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 5m7s 28 10s33ms 18s967ms 10s984ms create table temp0000290689 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 11 15 2m47s 11s193ms 13 3 31s196ms 10s398ms 14 10 1m48s 10s847ms [ User: intelifix - Total duration: 5m7s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 5m7s - Times executed: 28 ]
-
CREATE TABLE temp0000290689 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 11:14:38 Duration: 18s967ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290689 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 14:25:08 Duration: 12s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290689 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 11:48:12 Duration: 11s866ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 3m51s 17 10s369ms 47s362ms 13s644ms create table temp0000290679 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 10 5 1m32s 18s485ms 11 6 1m5s 10s931ms 12 6 1m13s 12s321ms [ User: intelifix - Total duration: 3m51s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m51s - Times executed: 17 ]
-
CREATE TABLE temp0000290679 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:52:23 Duration: 47s362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290679 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 12:24:32 Duration: 20s259ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290679 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:55:05 Duration: 11s557ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 2m44s 15 10s251ms 12s670ms 10s970ms create table temp0000290721 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 14 9 1m38s 10s893ms 15 6 1m6s 11s85ms [ User: intelifix - Total duration: 2m44s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 15 ]
-
CREATE TABLE temp0000290721 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 14:10:53 Duration: 12s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290721 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 15:08:35 Duration: 11s673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290721 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 15:11:07 Duration: 11s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m28s 29 218ms 25s115ms 5s121ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 07 2 27s746ms 13s873ms 08 5 40s282ms 8s56ms 09 3 10s515ms 3s505ms 10 6 22s173ms 3s695ms 11 4 20s404ms 5s101ms 12 2 13s560ms 6s780ms 13 1 4s670ms 4s670ms 14 5 8s955ms 1s791ms 15 1 218ms 218ms [ User: intelifix - Total duration: 2m28s - Times executed: 29 ]
[ Application: psql - Total duration: 2m28s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029415);
Date: 2026-09-04 07:21:25 Duration: 25s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029430);
Date: 2026-09-04 08:53:14 Duration: 23s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029467);
Date: 2026-09-04 12:32:56 Duration: 11s482ms Database: rio User: intelifix Remote: [local] Application: psql
16 2m12s 4 3s909ms 1m2s 33s59ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 20 2 1m6s 33s350ms 23 2 1m5s 32s767ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-04 20:08:36 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-04 23:16:31 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-04 20:10:32 Duration: 4s288ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
17 2m7s 37 152ms 28s490ms 3s448ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 07 3 1s190ms 396ms 08 5 7s767ms 1s553ms 09 4 1s87ms 271ms 10 6 2s159ms 359ms 11 7 14s165ms 2s23ms 12 2 17s3ms 8s501ms 13 2 967ms 483ms 14 6 41s793ms 6s965ms 15 2 41s465ms 20s732ms [ User: intelifix - Total duration: 2m7s - Times executed: 37 ]
[ Application: psql - Total duration: 2m7s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029470);
Date: 2026-09-04 14:16:22 Duration: 28s490ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029476);
Date: 2026-09-04 15:09:10 Duration: 25s415ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029477);
Date: 2026-09-04 15:39:10 Duration: 16s50ms Database: rio User: intelifix Remote: [local] Application: psql
18 1m58s 30 3s292ms 8s260ms 3s943ms create table temp0000290657 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 08 9 30s172ms 3s352ms 09 1 3s737ms 3s737ms 10 20 1m24s 4s219ms [ User: intelifix - Total duration: 1m58s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 1m58s - Times executed: 30 ]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 10:12:30 Duration: 8s260ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 10:29:33 Duration: 4s459ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 10:29:55 Duration: 4s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 1m53s 33 718ms 13s393ms 3s437ms 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 #19
Day Hour Count Duration Avg duration Sep 04 08 2 17s921ms 8s960ms 09 3 16s563ms 5s521ms 10 2 8s204ms 4s102ms 11 2 8s106ms 4s53ms 12 2 6s437ms 3s218ms 13 2 2s655ms 1s327ms 14 3 19s561ms 6s520ms 15 3 14s102ms 4s700ms 16 3 8s712ms 2s904ms 17 3 2s765ms 921ms 18 1 972ms 972ms 19 1 871ms 871ms 20 2 2s202ms 1s101ms 21 2 2s623ms 1s311ms 22 2 1s733ms 866ms [ User: intelifix - Total duration: 1m53s - Times executed: 33 ]
[ Application: psql - Total duration: 1m53s - 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-09-04 08:00:14 Duration: 13s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-09-04 09:20:12 Duration: 11s77ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-09-04 14:40:09 Duration: 7s528ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m45s 4 342ms 52s926ms 26s416ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 20 2 53s268ms 26s634ms 23 2 52s396ms 26s198ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-04 20:05:43 Duration: 52s926ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-04 23:13:40 Duration: 52s42ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-04 23:33:03 Duration: 354ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,047 25m26s 150ms 9m22s 1s458ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 04 06 2 1s745ms 872ms 07 85 49s414ms 581ms 08 174 1m40s 577ms 09 172 1m58s 688ms 10 181 1m58s 654ms 11 107 1m4s 602ms 12 24 16s100ms 670ms 13 52 35s309ms 679ms 14 133 2m25s 1s94ms 15 71 13m48s 11s667ms 16 29 30s889ms 1s65ms 17 17 17s516ms 1s30ms [ User: intelifix - Total duration: 25m26s - Times executed: 1047 ]
[ Application: [unknown] - Total duration: 25m26s - Times executed: 1047 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9,2C584F2F8F6B,4C126539E57D,4C12653D19FF,BC644BDC4112,5819F8490668,BC644BDEB78F,A89FECC52743,F8F532513195,5819F8491B76,BC644BCD054E,2C9569F4C441,A89FECC5650F,4C12653A3C12', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Duration: 9m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Duration: 3m33s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284794, 449, '71505585850012114605,216520404243,216409998585,216873513643,216874537895,216545014142,216398974345,216510642034,216397075776,216504994748,216832008403,216833403354,216869062749,216553736991,216348220313,216909123134,216410125972', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 14:26:56 Duration: 50s638ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 928 6m43s 150ms 7s847ms 434ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 06 1 1s448ms 1s448ms 07 80 38s600ms 482ms 08 141 55s601ms 394ms 09 143 1m14s 521ms 10 144 1m1s 429ms 11 99 45s432ms 458ms 12 13 5s954ms 458ms 13 41 17s747ms 432ms 14 120 50s675ms 422ms 15 105 37s18ms 352ms 16 13 5s459ms 419ms 17 19 5s615ms 295ms 18 9 3s49ms 338ms [ User: intelifix - Total duration: 6m43s - Times executed: 928 ]
[ Application: [unknown] - Total duration: 6m43s - Times executed: 928 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241594638191,241691845254,241716654062,241658206786,241670059604,241703495875,241715426074,241621985866,241617843038,241673210002,241699976979,241603128189,241706831622,241675687695,241699350623,241666368390,241716726773,241666116166,241689936280,241682591535,241634886777,241609023232,241679177575,241603290103,241615229113,241651683950,241618351528,241716738693,241617643344,241604211618,241649887489,241699986374,241709726382,241628863642,241682692532,241695141525,241635849307,241637862837,241675822434,241689969112,241712144351,241689990708,241628869298,230048387482,241658793039", "usuario" : "414", "caixa" : "2757498", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-04 09:03:03 Duration: 7s847ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284627", "modelo" : "463", "itens" : "241757681927,241790259618,241794195860,241737824747,241787364857,241704882947,241794333147,241750186481,241720822931,241736886384,241750245454,241758847887,241758945473,241755858190,241789437988,241758077879,241751139515,241735315860,241735019816,241781450319,241755878394,241721654864,241737152527,241735443853,241723835357,241750597890,241785792538,241719906062,241748439497,241754764661,241782316070,241735798589,241722362139,241757627173,241735783740,241721663249,241723269208,241748502434,241755054465,241748808401,241720365456,241749952744,241749928599,241758301718,241752407786,241754254858,241787536063,83350061340976A,241758195770,241748342441,241754605173,241755903650,241782116578,241736691416,241750062833,241755834047,241785784052,241723257792,241706256683,241721751417", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-04 11:13:24 Duration: 3s674ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "284497", "modelo" : "62", "itens" : "216513429511,216349656277,216619883952,216505405675,216633098686,216874376061,216355115564,216865016371,216755521926,216860243347,216753129919,216798642947,216413347689,216702036481", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-09-04 07:03:48 Duration: 2s293ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 215 7m10s 150ms 10s176ms 2s call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 04 00 9 26s537ms 2s948ms 01 11 17s730ms 1s611ms 02 10 18s17ms 1s801ms 03 11 18s822ms 1s711ms 04 10 16s949ms 1s694ms 05 10 16s418ms 1s641ms 06 7 15s814ms 2s259ms 07 10 22s867ms 2s286ms 08 7 17s203ms 2s457ms 09 9 16s797ms 1s866ms 10 11 16s546ms 1s504ms 11 10 18s140ms 1s814ms 12 8 16s354ms 2s44ms 13 9 15s976ms 1s775ms 14 10 18s250ms 1s825ms 15 11 20s433ms 1s857ms 16 10 21s524ms 2s152ms 17 10 20s25ms 2s2ms 18 9 18s629ms 2s69ms 19 8 18s112ms 2s264ms 20 10 23s829ms 2s382ms 21 8 17s391ms 2s173ms 22 7 17s628ms 2s518ms [ User: intelifix - Total duration: 7m10s - Times executed: 215 ]
[ Application: psql - Total duration: 7m10s - Times executed: 215 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 00:05:34 Duration: 10s176ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 07:25:13 Duration: 7s73ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 20:05:07 Duration: 6s345ms Database: rio User: intelifix Remote: [local] Application: psql
4 197 1h50m9s 152ms 18m24s 33s549ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 04 07 20 11m25s 34s282ms 08 27 6m53s 15s325ms 09 25 8m58s 21s534ms 10 29 14m33s 30s129ms 11 15 12m52s 51s485ms 12 7 20m33s 2m56s 13 18 5m57s 19s880ms 14 25 6m22s 15s298ms 15 21 22m12s 1m3s 16 5 13s679ms 2s735ms 17 4 3s922ms 980ms 18 1 1s125ms 1s125ms [ User: intelifix - Total duration: 1h50m9s - Times executed: 197 ]
[ Application: [unknown] - Total duration: 1h50m9s - Times executed: 197 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029354, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 15:30:18 Duration: 18m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029467, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 12:51:44 Duration: 17m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029443, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-04 10:14:24 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 155 9m11s 176ms 2m 3s559ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 00 6 35s732ms 5s955ms 01 6 14s316ms 2s386ms 02 6 13s35ms 2s172ms 03 5 11s529ms 2s305ms 04 6 11s931ms 1s988ms 05 4 13s323ms 3s330ms 07 11 27s507ms 2s500ms 08 12 36s417ms 3s34ms 09 12 33s386ms 2s782ms 10 12 42s432ms 3s536ms 11 12 48s575ms 4s47ms 12 7 8s801ms 1s257ms 13 8 16s503ms 2s62ms 14 12 2m42s 13s534ms 15 10 34s441ms 3s444ms 16 6 8s956ms 1s492ms 17 6 6s611ms 1s101ms 18 4 2s288ms 572ms 21 5 11s839ms 2s367ms 22 5 11s675ms 2s335ms [ User: intelifix - Total duration: 9m11s - Times executed: 155 ]
[ Application: psql - Total duration: 9m11s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 14:27:02 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 00:05:24 Duration: 22s846ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 15:05:11 Duration: 10s355ms Database: rio User: intelifix Remote: [local] Application: psql
6 144 41s180ms 150ms 723ms 285ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 09 25 8s457ms 338ms 10 71 20s396ms 287ms 13 42 11s16ms 262ms 14 6 1s310ms 218ms [ User: intelifix - Total duration: 41s180ms - Times executed: 144 ]
[ Application: [unknown] - Total duration: 41s180ms - Times executed: 144 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"56928","seriais":"D86C5A07C2F1,C85D38F7AAE3,D86C5A3AA490,C85D38858468,D86C5A44A888,C85D3878CB85,C85D38E4774A,D86C5A059686,C85D385A0F21,C85D381DD2A5,C85D389ABC2C,C85D38758B3B,C85D38A3897D,D86C5A48F2EE,C85D38D5E740,C85D38DE4C1B,C85D38F30BCD,C85D38A279F7,8C444FDD4AD2,C85D38D93E4B","usuario":"416","observacao":""}');
Date: 2026-09-04 10:15:59 Duration: 723ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"56927","seriais":"D89A0DAFDD2B,3CF9F0A47118,D89A0D851EFB,3CF9F0ACB66A,14CA56D40D95,D8313923965E,6C11BA675B97,389148509941,3CF9F0ACB5E0,D831399EAA40,6C11BA6F05A9,D89A0D8305A7,3891484A512F,6C11BA6903E1,3CF9F0A8BEE4,3CF9F0A8F4BA,C4EBFF8E3D64,D89A0DACC1AD,48D68235BE22,3CF9F0A5F31C,48D68235A118,3891484F72BD,F4E84F835EDA","usuario":"416","observacao":""}');
Date: 2026-09-04 13:48:54 Duration: 632ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"56928","seriais":"10A793423383,10A79340D46B,48BDCE6EB6BB,B85E71AF7A23,CCF3C881B4DB,CCF3C882D163,10A793408AD3,48BDCE6A1EEB,48BDCE6F8BEB,CCF3C8817B63,CCF3C88174A3,CCF3C856DDCB,F8D2ACF5B8AB","usuario":"416","observacao":""}');
Date: 2026-09-04 10:14:54 Duration: 598ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
7 102 30s775ms 246ms 1s467ms 301ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 06 3 1s983ms 661ms 07 3 815ms 271ms 08 13 4s323ms 332ms 09 11 2s972ms 270ms 10 15 4s615ms 307ms 11 9 2s787ms 309ms 12 6 1s649ms 274ms 13 7 1s890ms 270ms 14 15 4s13ms 267ms 15 10 2s836ms 283ms 16 5 1s516ms 303ms 17 4 1s108ms 277ms 18 1 261ms 261ms [ User: intelifix - Total duration: 30s775ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 30s775ms - Times executed: 102 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-04 06:54:29 Duration: 1s467ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-04 08:22:53 Duration: 1s131ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-09-04 11:52:31 Duration: 543ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
8 100 32s656ms 298ms 482ms 326ms 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 Sep 04 00 2 671ms 335ms 01 2 651ms 325ms 03 1 372ms 372ms 04 1 317ms 317ms 05 3 908ms 302ms 06 3 897ms 299ms 07 4 1s298ms 324ms 08 11 3s439ms 312ms 09 10 3s228ms 322ms 10 11 3s923ms 356ms 11 8 2s657ms 332ms 12 4 1s425ms 356ms 13 8 2s449ms 306ms 14 12 3s861ms 321ms 15 9 2s962ms 329ms 16 4 1s264ms 316ms 17 4 1s345ms 336ms 18 1 350ms 350ms 22 2 630ms 315ms [ User: lenon - Total duration: 32s656ms - Times executed: 100 ]
[ Application: [unknown] - Total duration: 32s656ms - Times executed: 100 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-09-04 12:06:02 Duration: 482ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
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-09-04 10:53:47 Duration: 422ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
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-09-04 14:20:52 Duration: 393ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 93 36s415ms 333ms 602ms 391ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 00 2 802ms 401ms 01 2 763ms 381ms 03 1 453ms 453ms 04 1 383ms 383ms 05 2 744ms 372ms 06 2 695ms 347ms 07 3 1s242ms 414ms 08 11 4s360ms 396ms 09 10 3s779ms 377ms 10 10 4s141ms 414ms 11 8 3s79ms 384ms 12 4 1s652ms 413ms 13 7 2s617ms 373ms 14 12 4s704ms 392ms 15 9 3s423ms 380ms 16 4 1s581ms 395ms 17 4 1s595ms 398ms 18 1 393ms 393ms [ User: intelifix - Total duration: 36s415ms - Times executed: 93 ]
[ Application: [unknown] - Total duration: 36s415ms - Times executed: 93 ]
-
select * from rs_menu_grants (406, 18, 1);
Date: 2026-09-04 08:15:15 Duration: 602ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (401, 5, 1);
Date: 2026-09-04 14:33:17 Duration: 565ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-09-04 12:06:02 Duration: 524ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 90 8m15s 1s242ms 1m36s 5s504ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 06 1 1m36s 1m36s 07 7 21s50ms 3s7ms 08 5 33s709ms 6s741ms 09 2 13s912ms 6s956ms 10 14 1m8s 4s886ms 11 6 31s64ms 5s177ms 12 2 5s210ms 2s605ms 13 7 35s927ms 5s132ms 14 12 1m5s 5s475ms 15 11 1m8s 6s244ms 16 7 16s794ms 2s399ms 17 10 24s200ms 2s420ms 18 6 13s899ms 2s316ms [ User: intelifix - Total duration: 8m15s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 8m15s - Times executed: 90 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-04 06:59:12 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-04', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-04 08:50:51 Duration: 19s702ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-04', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-04 14:15:53 Duration: 11s833ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 80 1m14s 654ms 3s67ms 935ms create table temp0000227067 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 08 1 3s67ms 3s67ms 09 12 9s55ms 754ms 10 23 17s912ms 778ms 11 24 25s331ms 1s55ms 13 20 19s483ms 974ms [ User: intelifix - Total duration: 1m14s - Times executed: 80 ]
[ Application: [unknown] - Total duration: 1m14s - Times executed: 80 ]
-
CREATE TABLE temp0000227067 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 08:27:11 Duration: 3s67ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227067 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 13:02:18 Duration: 1s538ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000227067 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 11:44:58 Duration: 1s503ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
12 54 1m16s 569ms 17s823ms 1s411ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 08 4 7s889ms 1s972ms 09 3 2s335ms 778ms 10 3 4s632ms 1s544ms 11 4 9s545ms 2s386ms 12 3 6s865ms 2s288ms 13 4 2s997ms 749ms 14 3 2s391ms 797ms 15 3 2s211ms 737ms 16 3 2s279ms 759ms 17 3 2s138ms 712ms 18 4 20s105ms 5s26ms 19 5 3s845ms 769ms 20 4 2s828ms 707ms 21 4 3s70ms 767ms 22 4 3s78ms 769ms [ User: intelifix - Total duration: 1m16s - Times executed: 54 ]
[ Application: psql - Total duration: 1m16s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-04 18:20:20 Duration: 17s823ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-04 11:40:08 Duration: 6s790ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-04 08:40:06 Duration: 5s543ms Database: rio User: intelifix Remote: [local] Application: psql
13 52 31s359ms 152ms 2s866ms 603ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 07 10 6s861ms 686ms 08 2 1s250ms 625ms 09 8 5s52ms 631ms 10 4 1s301ms 325ms 11 2 2s128ms 1s64ms 13 7 2s13ms 287ms 14 13 9s9ms 693ms 15 6 3s741ms 623ms [ User: intelifix - Total duration: 31s359ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 31s359ms - Times executed: 52 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0238726) LIMIT 1;
Date: 2026-09-04 14:53:06 Duration: 2s866ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0271822) LIMIT 1;
Date: 2026-09-04 15:10:16 Duration: 2s281ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0284502) LIMIT 1;
Date: 2026-09-04 14:55:41 Duration: 1s596ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 48 1h30m49s 1s329ms 6m41s 1m53s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 07 3 7m19s 2m26s 08 3 5m30s 1m50s 09 3 6m23s 2m7s 10 3 6m6s 2m2s 11 3 5m49s 1m56s 12 3 5m28s 1m49s 13 3 5m18s 1m46s 14 3 5m23s 1m47s 15 3 5m52s 1m57s 16 3 5m31s 1m50s 17 3 5m30s 1m50s 18 3 5m21s 1m47s 19 3 5m16s 1m45s 20 3 5m33s 1m51s 21 3 5m14s 1m44s 22 3 5m8s 1m42s [ User: intelifix - Total duration: 1h30m49s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m49s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 07:11:43 Duration: 6m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 09:11:09 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 10:10:49 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: psql
15 47 1h8m5s 256ms 4m4s 1m26s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 07 3 4m52s 1m37s 08 2 3m35s 1m47s 09 3 4m13s 1m24s 10 3 4m44s 1m34s 11 3 4m16s 1m25s 12 3 4m13s 1m24s 13 3 4m8s 1m22s 14 3 4m11s 1m23s 15 3 4m25s 1m28s 16 3 4m19s 1m26s 17 3 4m19s 1m26s 18 3 4m10s 1m23s 19 3 4m9s 1m23s 20 3 4m16s 1m25s 21 3 3m59s 1m19s 22 3 4m10s 1m23s [ User: intelifix - Total duration: 1h8m5s - Times executed: 47 ]
[ Application: psql - Total duration: 1h8m5s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 10:15:49 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 07:17:02 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 17:14:48 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
16 47 17s186ms 152ms 1s195ms 365ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 08 12 4s809ms 400ms 09 15 4s767ms 317ms 10 10 3s613ms 361ms 11 5 1s338ms 267ms 14 2 956ms 478ms 15 3 1s702ms 567ms [ User: intelifix - Total duration: 17s186ms - Times executed: 47 ]
[ Application: [unknown] - Total duration: 17s186ms - Times executed: 47 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '04E7959A4E5F,C40D96B19683,88892F895815,2868D21DF3B6,C40D96979764,1C3D2F492A63,FC73FBBDA275,C40D96B1910D,F09BB8C587E9,E8136E751E0D,00E406EF9F6D,D44649B4E53D', '76;1', 'DEFAULT', 09, 0189, '','', '', 00);
Date: 2026-09-04 15:08:06 Duration: 1s195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'ZTEGD3A868BA,ZTEGD3A7A29F,ZTEGD71E9093,ZTEGD3A7A1D5,ZTEGD3A82B0B,ZTEGD3A8BFBA,ZTEGD3A78916', '76;1', 'DEFAULT', 09, 0316, '','', '', 00);
Date: 2026-09-04 08:46:14 Duration: 975ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'ZTEGD3A88952,ZTEGD3A8965B,ZTEGD3A8A3CC,ZTEGD3A8846E,ZTEGD3A78FF2,ZTEGD3A76CC0,ZTEGD3A7DB9D', '76;1', 'DEFAULT', 09, 0316, '','', '', 00);
Date: 2026-09-04 08:49:06 Duration: 800ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 43 8m31s 10s8ms 45s157ms 11s892ms create table temp0000290657 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 08 11 1m53s 10s300ms 09 7 1m53s 16s273ms 10 24 4m32s 11s372ms 11 1 11s226ms 11s226ms [ User: intelifix - Total duration: 8m31s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m31s - Times executed: 43 ]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 09:25:03 Duration: 45s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:15:30 Duration: 12s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:25:58 Duration: 11s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 42 8m7s 10s26ms 42s586ms 11s613ms create table temp0000290643 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 07 12 2m34s 12s907ms 08 9 1m36s 10s755ms 09 9 1m33s 10s418ms 10 12 2m22s 11s858ms [ User: intelifix - Total duration: 8m7s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8m7s - Times executed: 42 ]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 07:19:41 Duration: 42s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:08:08 Duration: 12s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:07:13 Duration: 12s256ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 39 12s403ms 150ms 3s228ms 318ms create table temp0000290629 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 04 07 1 3s228ms 3s228ms 08 2 324ms 162ms 09 8 1s347ms 168ms 10 8 1s605ms 200ms 11 5 991ms 198ms 13 3 610ms 203ms 14 12 4s295ms 357ms [ User: intelifix - Total duration: 12s403ms - Times executed: 39 ]
[ Application: [unknown] - Total duration: 12s403ms - Times executed: 39 ]
-
CREATE TABLE temp0000290629 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 07:04:08 Duration: 3s228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290629 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"1117", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 14:18:17 Duration: 1s915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290629 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"1117", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 14:13:05 Duration: 255ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 37 2m7s 152ms 28s490ms 3s448ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 07 3 1s190ms 396ms 08 5 7s767ms 1s553ms 09 4 1s87ms 271ms 10 6 2s159ms 359ms 11 7 14s165ms 2s23ms 12 2 17s3ms 8s501ms 13 2 967ms 483ms 14 6 41s793ms 6s965ms 15 2 41s465ms 20s732ms [ User: intelifix - Total duration: 2m7s - Times executed: 37 ]
[ Application: psql - Total duration: 2m7s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029470);
Date: 2026-09-04 14:16:22 Duration: 28s490ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029476);
Date: 2026-09-04 15:09:10 Duration: 25s415ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029477);
Date: 2026-09-04 15:39:10 Duration: 16s50ms Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m47s 9m55s 6m21s 3 19m5s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 04 05 3 19m5s 6m21s [ User: intelifix - Total duration: 19m5s - Times executed: 3 ]
[ Application: psql - Total duration: 19m5s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-09-04 05:09:56 Duration: 9m55s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-04 05:16:20 Duration: 6m23s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-09-04 05:19:07 Duration: 2m47s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s329ms 6m41s 1m53s 48 1h30m49s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 07 3 7m19s 2m26s 08 3 5m30s 1m50s 09 3 6m23s 2m7s 10 3 6m6s 2m2s 11 3 5m49s 1m56s 12 3 5m28s 1m49s 13 3 5m18s 1m46s 14 3 5m23s 1m47s 15 3 5m52s 1m57s 16 3 5m31s 1m50s 17 3 5m30s 1m50s 18 3 5m21s 1m47s 19 3 5m16s 1m45s 20 3 5m33s 1m51s 21 3 5m14s 1m44s 22 3 5m8s 1m42s [ User: intelifix - Total duration: 1h30m49s - Times executed: 48 ]
[ Application: psql - Total duration: 1h30m49s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 07:11:43 Duration: 6m41s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 09:11:09 Duration: 6m7s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-09-04 10:10:49 Duration: 5m48s Database: rio User: intelifix Remote: [local] Application: psql
3 256ms 4m4s 1m26s 47 1h8m5s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 04 07 3 4m52s 1m37s 08 2 3m35s 1m47s 09 3 4m13s 1m24s 10 3 4m44s 1m34s 11 3 4m16s 1m25s 12 3 4m13s 1m24s 13 3 4m8s 1m22s 14 3 4m11s 1m23s 15 3 4m25s 1m28s 16 3 4m19s 1m26s 17 3 4m19s 1m26s 18 3 4m10s 1m23s 19 3 4m9s 1m23s 20 3 4m16s 1m25s 21 3 3m59s 1m19s 22 3 4m10s 1m23s [ User: intelifix - Total duration: 1h8m5s - Times executed: 47 ]
[ Application: psql - Total duration: 1h8m5s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 10:15:49 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 07:17:02 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-09-04 17:14:48 Duration: 3m47s Database: brasilia User: intelifix Remote: [local] Application: psql
4 152ms 18m24s 33s549ms 197 1h50m9s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 04 07 20 11m25s 34s282ms 08 27 6m53s 15s325ms 09 25 8m58s 21s534ms 10 29 14m33s 30s129ms 11 15 12m52s 51s485ms 12 7 20m33s 2m56s 13 18 5m57s 19s880ms 14 25 6m22s 15s298ms 15 21 22m12s 1m3s 16 5 13s679ms 2s735ms 17 4 3s922ms 980ms 18 1 1s125ms 1s125ms [ User: intelifix - Total duration: 1h50m9s - Times executed: 197 ]
[ Application: [unknown] - Total duration: 1h50m9s - Times executed: 197 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029354, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 15:30:18 Duration: 18m24s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029467, 0434 )', '/var/www/html/tmp/nf_carga_lotes_0434.xlsx');
Date: 2026-09-04 12:51:44 Duration: 17m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 029443, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-09-04 10:14:24 Duration: 5m57s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 3s909ms 1m2s 33s59ms 4 2m12s 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 Sep 04 20 2 1m6s 33s350ms 23 2 1m5s 32s767ms [ User: intelifix - Total duration: 2m12s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m12s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-04 20:08:36 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-04 23:16:31 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-09-04 20:10:32 Duration: 4s288ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 342ms 52s926ms 26s416ms 4 1m45s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 20 2 53s268ms 26s634ms 23 2 52s396ms 26s198ms [ User: intelifix - Total duration: 1m45s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m45s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-04 20:05:43 Duration: 52s926ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-04 23:13:40 Duration: 52s42ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-09-04 23:33:03 Duration: 354ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 10s369ms 47s362ms 13s644ms 17 3m51s create table temp0000290679 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 10 5 1m32s 18s485ms 11 6 1m5s 10s931ms 12 6 1m13s 12s321ms [ User: intelifix - Total duration: 3m51s - Times executed: 17 ]
[ Application: [unknown] - Total duration: 3m51s - Times executed: 17 ]
-
CREATE TABLE temp0000290679 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:52:23 Duration: 47s362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290679 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 12:24:32 Duration: 20s259ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290679 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:55:05 Duration: 11s557ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s8ms 45s157ms 11s892ms 43 8m31s create table temp0000290657 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 08 11 1m53s 10s300ms 09 7 1m53s 16s273ms 10 24 4m32s 11s372ms 11 1 11s226ms 11s226ms [ User: intelifix - Total duration: 8m31s - Times executed: 43 ]
[ Application: [unknown] - Total duration: 8m31s - Times executed: 43 ]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 09:25:03 Duration: 45s157ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:15:30 Duration: 12s13ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:25:58 Duration: 11s931ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s26ms 42s586ms 11s613ms 42 8m7s create table temp0000290643 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 07 12 2m34s 12s907ms 08 9 1m36s 10s755ms 09 9 1m33s 10s418ms 10 12 2m22s 11s858ms [ User: intelifix - Total duration: 8m7s - Times executed: 42 ]
[ Application: [unknown] - Total duration: 8m7s - Times executed: 42 ]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 07:19:41 Duration: 42s586ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:08:08 Duration: 12s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290643 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 10:07:13 Duration: 12s256ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s33ms 18s967ms 10s984ms 28 5m7s create table temp0000290689 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 11 15 2m47s 11s193ms 13 3 31s196ms 10s398ms 14 10 1m48s 10s847ms [ User: intelifix - Total duration: 5m7s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 5m7s - Times executed: 28 ]
-
CREATE TABLE temp0000290689 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 11:14:38 Duration: 18s967ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290689 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 14:25:08 Duration: 12s94ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290689 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 11:48:12 Duration: 11s866ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s251ms 12s670ms 10s970ms 15 2m44s create table temp0000290721 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 14 9 1m38s 10s893ms 15 6 1m6s 11s85ms [ User: intelifix - Total duration: 2m44s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m44s - Times executed: 15 ]
-
CREATE TABLE temp0000290721 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 14:10:53 Duration: 12s670ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290721 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 15:08:35 Duration: 11s673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290721 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-09-04 15:11:07 Duration: 11s531ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s242ms 1m36s 5s504ms 90 8m15s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 06 1 1m36s 1m36s 07 7 21s50ms 3s7ms 08 5 33s709ms 6s741ms 09 2 13s912ms 6s956ms 10 14 1m8s 4s886ms 11 6 31s64ms 5s177ms 12 2 5s210ms 2s605ms 13 7 35s927ms 5s132ms 14 12 1m5s 5s475ms 15 11 1m8s 6s244ms 16 7 16s794ms 2s399ms 17 10 24s200ms 2s420ms 18 6 13s899ms 2s316ms [ User: intelifix - Total duration: 8m15s - Times executed: 90 ]
[ Application: [unknown] - Total duration: 8m15s - Times executed: 90 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-03', 099, '', '', 0, 6, '2026-08-01');
Date: 2026-09-04 06:59:12 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-04', 099, '', '', 0, 6, '2026-09-01');
Date: 2026-09-04 08:50:51 Duration: 19s702ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-09-04', 0173, '', '', 0, 6, '2026-09-01');
Date: 2026-09-04 14:15:53 Duration: 11s833ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 218ms 25s115ms 5s121ms 29 2m28s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 07 2 27s746ms 13s873ms 08 5 40s282ms 8s56ms 09 3 10s515ms 3s505ms 10 6 22s173ms 3s695ms 11 4 20s404ms 5s101ms 12 2 13s560ms 6s780ms 13 1 4s670ms 4s670ms 14 5 8s955ms 1s791ms 15 1 218ms 218ms [ User: intelifix - Total duration: 2m28s - Times executed: 29 ]
[ Application: psql - Total duration: 2m28s - Times executed: 29 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029415);
Date: 2026-09-04 07:21:25 Duration: 25s115ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029430);
Date: 2026-09-04 08:53:14 Duration: 23s297ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (029467);
Date: 2026-09-04 12:32:56 Duration: 11s482ms Database: rio User: intelifix Remote: [local] Application: psql
14 3s292ms 8s260ms 3s943ms 30 1m58s create table temp0000290657 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 08 9 30s172ms 3s352ms 09 1 3s737ms 3s737ms 10 20 1m24s 4s219ms [ User: intelifix - Total duration: 1m58s - Times executed: 30 ]
[ Application: [unknown] - Total duration: 1m58s - Times executed: 30 ]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 10:12:30 Duration: 8s260ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 10:29:33 Duration: 4s459ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000290657 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"30-08-2026", "ate" :"04-09-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-09-04 10:29:55 Duration: 4s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 176ms 2m 3s559ms 155 9m11s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 00 6 35s732ms 5s955ms 01 6 14s316ms 2s386ms 02 6 13s35ms 2s172ms 03 5 11s529ms 2s305ms 04 6 11s931ms 1s988ms 05 4 13s323ms 3s330ms 07 11 27s507ms 2s500ms 08 12 36s417ms 3s34ms 09 12 33s386ms 2s782ms 10 12 42s432ms 3s536ms 11 12 48s575ms 4s47ms 12 7 8s801ms 1s257ms 13 8 16s503ms 2s62ms 14 12 2m42s 13s534ms 15 10 34s441ms 3s444ms 16 6 8s956ms 1s492ms 17 6 6s611ms 1s101ms 18 4 2s288ms 572ms 21 5 11s839ms 2s367ms 22 5 11s675ms 2s335ms [ User: intelifix - Total duration: 9m11s - Times executed: 155 ]
[ Application: psql - Total duration: 9m11s - Times executed: 155 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 14:27:02 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 00:05:24 Duration: 22s846ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-09-04 15:05:11 Duration: 10s355ms Database: rio User: intelifix Remote: [local] Application: psql
16 152ms 28s490ms 3s448ms 37 2m7s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 07 3 1s190ms 396ms 08 5 7s767ms 1s553ms 09 4 1s87ms 271ms 10 6 2s159ms 359ms 11 7 14s165ms 2s23ms 12 2 17s3ms 8s501ms 13 2 967ms 483ms 14 6 41s793ms 6s965ms 15 2 41s465ms 20s732ms [ User: intelifix - Total duration: 2m7s - Times executed: 37 ]
[ Application: psql - Total duration: 2m7s - Times executed: 37 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029470);
Date: 2026-09-04 14:16:22 Duration: 28s490ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029476);
Date: 2026-09-04 15:09:10 Duration: 25s415ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (029477);
Date: 2026-09-04 15:39:10 Duration: 16s50ms Database: rio User: intelifix Remote: [local] Application: psql
17 718ms 13s393ms 3s437ms 33 1m53s 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 #17
Day Hour Count Duration Avg duration Sep 04 08 2 17s921ms 8s960ms 09 3 16s563ms 5s521ms 10 2 8s204ms 4s102ms 11 2 8s106ms 4s53ms 12 2 6s437ms 3s218ms 13 2 2s655ms 1s327ms 14 3 19s561ms 6s520ms 15 3 14s102ms 4s700ms 16 3 8s712ms 2s904ms 17 3 2s765ms 921ms 18 1 972ms 972ms 19 1 871ms 871ms 20 2 2s202ms 1s101ms 21 2 2s623ms 1s311ms 22 2 1s733ms 866ms [ User: intelifix - Total duration: 1m53s - Times executed: 33 ]
[ Application: psql - Total duration: 1m53s - 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-09-04 08:00:14 Duration: 13s393ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-09-04 09:20:12 Duration: 11s77ms Database: rio User: intelifix Remote: [local] Application: psql
-
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-09-04 14:40:09 Duration: 7s528ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 10s176ms 2s 215 7m10s call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 00 9 26s537ms 2s948ms 01 11 17s730ms 1s611ms 02 10 18s17ms 1s801ms 03 11 18s822ms 1s711ms 04 10 16s949ms 1s694ms 05 10 16s418ms 1s641ms 06 7 15s814ms 2s259ms 07 10 22s867ms 2s286ms 08 7 17s203ms 2s457ms 09 9 16s797ms 1s866ms 10 11 16s546ms 1s504ms 11 10 18s140ms 1s814ms 12 8 16s354ms 2s44ms 13 9 15s976ms 1s775ms 14 10 18s250ms 1s825ms 15 11 20s433ms 1s857ms 16 10 21s524ms 2s152ms 17 10 20s25ms 2s2ms 18 9 18s629ms 2s69ms 19 8 18s112ms 2s264ms 20 10 23s829ms 2s382ms 21 8 17s391ms 2s173ms 22 7 17s628ms 2s518ms [ User: intelifix - Total duration: 7m10s - Times executed: 215 ]
[ Application: psql - Total duration: 7m10s - Times executed: 215 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 00:05:34 Duration: 10s176ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 07:25:13 Duration: 7s73ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-09-04 20:05:07 Duration: 6s345ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 9m22s 1s458ms 1,047 25m26s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 04 06 2 1s745ms 872ms 07 85 49s414ms 581ms 08 174 1m40s 577ms 09 172 1m58s 688ms 10 181 1m58s 654ms 11 107 1m4s 602ms 12 24 16s100ms 670ms 13 52 35s309ms 679ms 14 133 2m25s 1s94ms 15 71 13m48s 11s667ms 16 29 30s889ms 1s65ms 17 17 17s516ms 1s30ms [ User: intelifix - Total duration: 25m26s - Times executed: 1047 ]
[ Application: [unknown] - Total duration: 25m26s - Times executed: 1047 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9,2C584F2F8F6B,4C126539E57D,4C12653D19FF,BC644BDC4112,5819F8490668,BC644BDEB78F,A89FECC52743,F8F532513195,5819F8491B76,BC644BCD054E,2C9569F4C441,A89FECC5650F,4C12653A3C12', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Duration: 9m22s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284898, 449, '518099046471,A89FECC32CF4,BC644BD251E8,4C1265E8F2D9', '',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 15:30:18 Duration: 3m33s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (284794, 449, '71505585850012114605,216520404243,216409998585,216873513643,216874537895,216545014142,216398974345,216510642034,216397075776,216504994748,216832008403,216833403354,216869062749,216553736991,216348220313,216909123134,216410125972', '',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-09-04 14:26:56 Duration: 50s638ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 569ms 17s823ms 1s411ms 54 1m16s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 08 4 7s889ms 1s972ms 09 3 2s335ms 778ms 10 3 4s632ms 1s544ms 11 4 9s545ms 2s386ms 12 3 6s865ms 2s288ms 13 4 2s997ms 749ms 14 3 2s391ms 797ms 15 3 2s211ms 737ms 16 3 2s279ms 759ms 17 3 2s138ms 712ms 18 4 20s105ms 5s26ms 19 5 3s845ms 769ms 20 4 2s828ms 707ms 21 4 3s70ms 767ms 22 4 3s78ms 769ms [ User: intelifix - Total duration: 1m16s - Times executed: 54 ]
[ Application: psql - Total duration: 1m16s - Times executed: 54 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-04 18:20:20 Duration: 17s823ms Database: brasilia User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-04 11:40:08 Duration: 6s790ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-09-04 08:40:06 Duration: 5s543ms Database: rio User: intelifix Remote: [local] Application: psql
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 6 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Sep 04 17 1 0ms 0ms 19 2 0ms 0ms 20 1 0ms 0ms 21 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 5m14s - Times executed: 6 ]
[ Application: psql - Total duration: 5m14s - Times executed: 6 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 15,551 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 25 FATAL entries
- 3443 ERROR entries
- 0 WARNING entries
- 13 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,427 Max number of times the same event was reported
- 3,481 Total events found
Rank Times reported Error 1 3,427 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 04 00 60 01 59 02 60 03 55 04 59 05 60 06 60 07 202 08 302 09 388 10 375 11 266 12 98 13 169 14 361 15 238 16 122 17 131 18 74 19 60 20 59 21 60 22 60 23 49 - ERROR: prepared statement "_PLAN00000000297DB160" does not exist
- ERROR: prepared statement "_PLAN00000000297E0810" does not exist
- ERROR: prepared statement "_PLAN00000000297D9A90" does not exist
Statement: DEALLOCATE "_PLAN00000000297DB160"
Date: 2026-09-04 00:00:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000297E0810"
Date: 2026-09-04 00:01:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000297D9A90"
Date: 2026-09-04 00:02:19 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 13 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 04 00 1 02 1 04 2 06 4 10 1 11 1 15 1 16 2 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-09-04 00:02:08 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-09-04 02:25:03 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-04 04:18:58 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
3 9 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 04 14 6 15 3 - LOG: process 1732224 still waiting for ShareLock on transaction 5615201 after 1000.102 ms
- LOG: process 1732224 still waiting for ShareLock on transaction 5615201 after 25468.357 ms
- LOG: process 1747175 still waiting for ShareLock on transaction 5615201 after 1000.075 ms
Detail: Process holding the lock: 1749264. Wait queue: 1732224.
Context: while locking tuple (65043,12) in relation "equipamentos" SQL statement "SELECT 1 FROM ONLY "public"."equipamentos" x WHERE "eq_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x" SQL statement "INSERT INTO FLUXOS ( FLU_ID, WF_ID, TEC_ID, EQ_ID, FLU_GARANTIA, FLU_CAIXA, FLU_ORIGINAL, FLU_HOMOLOGADO ) VALUES ( nFlu, nWF, nTecnico , aIDs[ nInd ] , cGarantia, nCaixa , nOriginal, cHomologado )" PL/pgSQL function rs_triagem(integer,integer,character varying,integer,character varying,integer,integer,integer,integer) line 574 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 342 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-09-04 14:25:04 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1749264. Wait queue: 1732224.
Context: while locking tuple (65043,12) in relation "equipamentos" SQL statement "SELECT 1 FROM ONLY "public"."equipamentos" x WHERE "eq_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x" SQL statement "INSERT INTO FLUXOS ( FLU_ID, WF_ID, TEC_ID, EQ_ID, FLU_GARANTIA, FLU_CAIXA, FLU_ORIGINAL, FLU_HOMOLOGADO ) VALUES ( nFlu, nWF, nTecnico , aIDs[ nInd ] , cGarantia, nCaixa , nOriginal, cHomologado )" PL/pgSQL function rs_triagem(integer,integer,character varying,integer,character varying,integer,integer,integer,integer) line 574 at SQL statement PL/pgSQL function rs_processa_triagens_giga(integer) line 342 at assignment PL/pgSQL function rs_triagem_registra(character varying,integer,character varying,character varying,character varying,integer,character varying,character varying,character varying,character varying,character varying,character varying,character varying) line 75 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 192 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-09-04 14:25:29 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1749264. Wait queue: 1732224, 1747175.
Context: while locking tuple (13522,6) in relation "equipamentos" SQL statement "UPDATE EQUIPAMENTOS SET CLI_ID = nCliente, MOD_ID = nModelo , EQ_HOMOLOGADO = NULL -- trigger faz o resto! WHERE EQ_ID = nEQ" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 933 at SQL statement
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(284794,449,'71505585850012114605,216520404243$71501985850010800603,216409998585$71821185850056804764,216873513643$71821185850057105006,216874537895$71505685850012214368,216545014142$71432285850008714510,216398974345$71503785850011516983,216510642034$71431885850008302740,216397075776$71502885850011202238,216504994748$71800985850050006267,216832008403$71802385850049203333,216833403354$71819585850055907275,216869062749$71507585850012618772,216553736991$71427485850006023475,216348220313$71826885850059006225,216909123134$71501985850010801877,216410125972','',062,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-09-04 14:26:06 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 04 03 9 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-04 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-04 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-09-04 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
5 5 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 04 08 1 09 2 13 1 15 1 - ERROR: syntax error at or near "229926774862" at character 41
- ERROR: syntax error at or near "3600652" at character 29
- ERROR: syntax error at or near "3600652" at character 29
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''229926774862');
Date: 2026-09-04 08:04:58 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: select * from rs_caixa_qr(''3600652 )
Date: 2026-09-04 09:31:27 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(''3600652 )
Date: 2026-09-04 09:31:27 Database: rio Application: [unknown] User: etiquetas Remote: [local]
6 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 04 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-09-04 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-09-04 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-09-04 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
7 3 LOG: process ... still waiting for ExclusiveLock on tuple (...) of relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 04 15 3 - LOG: process 1821022 still waiting for ExclusiveLock on tuple (78715,98) of relation 363850 of database 358220 after 1000.121 ms
- LOG: process 1821022 still waiting for ExclusiveLock on tuple (78715,98) of relation 363850 of database 358220 after 9864.424 ms
- LOG: process 1821022 still waiting for ExclusiveLock on tuple (78715,98) of relation 363850 of database 358220 after 49609.904 ms
Detail: Process holding the lock: 1818411. Wait queue: 1821022.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(284898,449,'518099046471,A89FECC32CF4$518009117784,BC644BD251E8$519061058994,4C1265E8F2D9','',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-09-04 15:26:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1818411. Wait queue: 1821022.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(284898,449,'518099046471,A89FECC32CF4$518009117784,BC644BD251E8$519061058994,4C1265E8F2D9','',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-09-04 15:26:54 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1818411. Wait queue: 1821022.
Context: SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(284898,449,'518099046471,A89FECC32CF4$518009117784,BC644BD251E8$519061058994,4C1265E8F2D9','',042,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);Date: 2026-09-04 15:27:34 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 04 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-09-04 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-04 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-09-04 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 04 10 3 - ERROR: column "a456cce33410" does not exist at character 27
- ERROR: column "a456cce33410" does not exist at character 27
- ERROR: column "a456cce33410" does not exist at character 27
Statement: select * from rs_caixa_qr(A456CCE33410)
Date: 2026-09-04 10:23:00 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(A456CCE33410)
Date: 2026-09-04 10:23:00 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(A456CCE33410)
Date: 2026-09-04 10:23:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
10 2 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 04 08 1 14 1 - ERROR: trailing junk after numeric literal at or near "04885FF18C17" at character 41
- ERROR: trailing junk after numeric literal at or near "88892FFF2CC2" at character 41
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''04885FF18C17');
Date: 2026-09-04 08:08:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''88892FFF2CC2');
Date: 2026-09-04 14:30:57 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
11 2 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 04 11 1 14 1 - ERROR: unterminated quoted string at or near "'230022157077'');" at character 39
- ERROR: unterminated quoted string at or near "''');" at character 39
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA('230022157077'');
Date: 2026-09-04 11:11:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''');
Date: 2026-09-04 14:30:54 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 04 03 1 - LOG: database system was shut down at 2026-09-04 03:05:01 -03
Date: 2026-09-04 03:05:02