pgBadger-
Global information
- Generated on Sat Jul 4 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 49,965 log entries in 8s
- Log start from 2026-07-03 00:00:32 to 2026-07-03 23:59:57
-
Overview
Global Stats
- 455 Number of unique normalized queries
- 7,386 Number of queries
- 8h55m15s Total query duration
- 2026-07-03 00:02:04 First query
- 2026-07-03 23:54:57 Last query
- 5 queries/s at 2026-07-03 20:08:40 Query peak
- 8h55m15s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h55m15s Execute total duration
- 4,382 Number of events
- 17 Number of unique normalized events
- 4,207 Max number of times the same event was reported
- 0 Number of cancellation
- 611 Total number of automatic vacuums
- 1,313 Total number of automatic analyzes
- 32 Number temporary file
- 233.20 MiB Max size of temporary file
- 132.20 MiB Average size of temporary file
- 377 Total number of sessions
- 8 sessions at 2026-07-03 09:58:52 Session peak
- 13d15h4m59s Total duration of sessions
- 52m3s Average duration of sessions
- 19 Average queries per session
- 1m25s Average queries duration per session
- 50m38s Average idle time per session
- 389 Total number of connections
- 4 connections/s at 2026-07-03 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-03 20:08:40 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-03 10:23:42 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-03 20:08:40 Date
Queries duration
Key values
- 8h55m15s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 03 00 22 0ms 18s161ms 4s654ms 3s955ms 5s276ms 1m15s 01 26 0ms 4s137ms 1s264ms 3s557ms 4s801ms 7s535ms 02 13 0ms 2s784ms 1s852ms 3s449ms 4s8ms 4s956ms 03 20 0ms 4s11ms 1s419ms 3s490ms 4s274ms 6s890ms 04 27 0ms 3s5ms 1s144ms 3s892ms 4s646ms 5s77ms 05 31 0ms 8m18s 32s868ms 10s83ms 2m14s 8m19s 06 27 0ms 13s694ms 2s447ms 2s689ms 6s143ms 29s308ms 07 422 0ms 9m14s 4s860ms 45s568ms 4m55s 9m40s 08 928 150ms 7m44s 3s 1m13s 4m55s 7m49s 09 826 150ms 8m37s 3s478ms 1m28s 4m44s 8m42s 10 779 150ms 8m4s 3s7ms 1m24s 4m19s 8m19s 11 897 150ms 8m10s 3s373ms 1m54s 4m51s 9m13s 12 197 0ms 7m55s 7s121ms 36s738ms 4m9s 7m56s 13 366 0ms 6m24s 4s102ms 1m31s 1m43s 6m57s 14 817 150ms 7m37s 3s294ms 1m25s 4m48s 7m49s 15 882 150ms 8m22s 2s964ms 1m 5m2s 8m32s 16 446 150ms 8m7s 4s967ms 1m48s 3m47s 9m5s 17 181 0ms 7m1s 6s238ms 11s632ms 1m42s 8m4s 18 21 0ms 5m20s 29s128ms 3s522ms 15s924ms 5m55s 19 21 0ms 5m40s 29s38ms 3s407ms 46s907ms 5m40s 20 115 0ms 7m30s 11s218ms 1m10s 1m34s 7m30s 21 33 0ms 6m1s 19s160ms 5s90ms 7s337ms 6m45s 22 27 0ms 5m51s 23s324ms 5s296ms 43s5ms 5m51s 23 262 0ms 1m43s 9s177ms 1m13s 1m27s 1m55s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 03 00 4 0 863ms 0ms 0ms 176ms 01 13 0 255ms 0ms 164ms 825ms 02 0 0 0ms 0ms 0ms 0ms 03 6 0 343ms 0ms 0ms 859ms 04 14 0 283ms 0ms 204ms 1s19ms 05 14 0 256ms 0ms 207ms 1s104ms 06 10 0 474ms 0ms 0ms 1s49ms 07 326 0 5s345ms 6s124ms 12s417ms 5m50s 08 649 0 2s933ms 11s435ms 1m2s 5m36s 09 608 0 3s376ms 22s618ms 1m10s 4m57s 10 559 0 3s18ms 13s263ms 1m8s 5m7s 11 638 0 3s419ms 17s755ms 1m7s 5m 12 128 0 9s137ms 3s555ms 13s474ms 4m57s 13 268 0 5s175ms 16s72ms 1m30s 3m30s 14 643 0 3s234ms 22s956ms 1m10s 5m5s 15 679 0 2s930ms 16s753ms 36s759ms 5m20s 16 295 0 5s809ms 19s131ms 1m32s 4m6s 17 101 0 10s692ms 4s494ms 7s784ms 3m30s 18 8 0 1m13s 0ms 0ms 3m31s 19 6 0 1m37s 0ms 0ms 3m18s 20 11 90 12s495ms 10s320ms 1m10s 3m26s 21 14 0 42s717ms 0ms 925ms 3m8s 22 6 0 1m39s 0ms 0ms 3m21s 23 11 251 9s177ms 1m3s 1m12s 1m43s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 03 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 Jul 03 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 2 2.00 0.00% 04 0 2 2.00 0.00% 05 0 2 2.00 0.00% 06 0 3 3.00 0.00% 07 0 9 9.00 0.00% 08 0 15 15.00 0.00% 09 0 10 10.00 0.00% 10 0 13 13.00 0.00% 11 0 15 15.00 0.00% 12 0 7 7.00 0.00% 13 0 12 12.00 0.00% 14 0 13 13.00 0.00% 15 0 14 14.00 0.00% 16 0 12 12.00 0.00% 17 0 4 4.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 1 1.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 0 3 3.00 0.00% Day Hour Count Average / Second Jul 03 00 18 0.01/s 01 12 0.00/s 02 9 0.00/s 03 26 0.01/s 04 9 0.00/s 05 10 0.00/s 06 13 0.00/s 07 18 0.01/s 08 22 0.01/s 09 36 0.01/s 10 21 0.01/s 11 21 0.01/s 12 14 0.00/s 13 21 0.01/s 14 21 0.01/s 15 20 0.01/s 16 19 0.01/s 17 17 0.00/s 18 11 0.00/s 19 10 0.00/s 20 12 0.00/s 21 12 0.00/s 22 8 0.00/s 23 9 0.00/s Day Hour Count Average Duration Average idle time Jul 03 00 4 1h 59m34s 01 16 1h1m5s 1h1m3s 02 12 1h30s 1h28s 03 19 22m16s 22m15s 04 10 1h2m23s 1h2m20s 05 9 1h40s 58m47s 06 9 57m34s 57m26s 07 14 56m58s 54m31s 08 19 54m43s 52m16s 09 33 35m5s 33m38s 10 23 53m56s 52m14s 11 23 52m43s 50m32s 12 20 52m26s 51m16s 13 14 54m46s 52m59s 14 22 54m29s 52m26s 15 22 51m40s 49m41s 16 18 55m24s 53m21s 17 19 55m57s 54m58s 18 16 57m10s 56m32s 19 10 58m 56m59s 20 13 47m39s 46m 21 9 1h 58m50s 22 12 1h59s 1h6s 23 11 47m31s 43m52s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-07-03 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 389 connections Total
Connections per user
Key values
- intelifix Main User
- 389 connections Total
-
Sessions
Simultaneous sessions
Key values
- 8 sessions Session Peak
- 2026-07-03 09:58:52 Date
Histogram of session times
Key values
- 297 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 377 sessions Total
Sessions per user
Key values
- intelifix Main User
- 377 sessions Total
Sessions per host
Key values
- [local] Main Host
- 377 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 377 sessions Total
Application Count Total Duration Average Duration [unknown] 341 12d18h52m40s 53m59s pgAdmin 4 - CONN:1226542 1 33s924ms 33s924ms pgAdmin 4 - CONN:3221510 3 4s583ms 1s527ms pgAdmin 4 - CONN:6973557 3 6s683ms 2s227ms pgAdmin 4 - DB:brasilia 1 11s521ms 11s521ms pgAdmin 4 - DB:contagem 1 9s802ms 9s802ms pgAdmin 4 - DB:postgres 1 38s55ms 38s55ms pgAdmin 4 - DB:rio 1 8s273ms 8s273ms pg_dump 6 50m55s 8m29s postgres_fdw 1 35m2s 35m2s psql 18 18h44m29s 1h2m28s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 25,937 buffers Checkpoint Peak
- 2026-07-03 00:19:40 Date
- 270.006 seconds Highest write time
- 0.140 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-07-03 11:49:34 Date
Checkpoints distance
Key values
- 473.32 Mo Distance Peak
- 2026-07-03 11:49:34 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 03 00 30,918 681.905s 0.041s 682.018s 01 2,930 294.329s 0.041s 294.43s 02 1,954 196.235s 0.032s 196.316s 03 2,001 201.159s 0.048s 201.273s 04 3,493 351.026s 0.042s 351.168s 05 11,434 1,093.019s 0.121s 1,093.221s 06 4,679 468.746s 0.047s 468.837s 07 45,366 2,767.372s 0.433s 2,767.963s 08 66,963 3,238.541s 0.841s 3,239.697s 09 79,405 3,238.532s 0.794s 3,239.625s 10 83,743 3,238.502s 0.853s 3,239.648s 11 111,658 3,238.723s 0.694s 3,239.749s 12 34,233 1,949.155s 0.211s 1,949.498s 13 17,839 1,686.848s 0.321s 1,687.306s 14 79,948 3,226.333s 0.773s 3,227.371s 15 71,262 3,238.569s 0.738s 3,239.614s 16 52,084 3,202.808s 0.51s 3,203.575s 17 12,689 1,282.991s 0.154s 1,283.253s 18 688 69.17s 0.017s 69.212s 19 21 2.134s 0.005s 2.147s 20 531 356.701s 0.027s 356.748s 21 2,948 298.472s 0.076s 298.695s 22 1,959 196.935s 0.029s 197.013s 23 1,544 439.403s 0.024s 439.469s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 03 00 0 0 7 606 0.003s 0.009s 01 0 0 1 526 0.003s 0.007s 02 0 0 1 438 0.003s 0.008s 03 0 0 1 501 0.004s 0.01s 04 0 0 1 714 0.002s 0.011s 05 0 0 4 1,107 0.013s 0.009s 06 0 0 1 275 0.003s 0.005s 07 0 0 25 3,559 0.019s 0.012s 08 0 0 64 7,126 0.024s 0.012s 09 0 0 68 8,520 0.009s 0.012s 10 0 0 63 7,891 0.038s 0.012s 11 0 0 79 7,271 0.030s 0.012s 12 0 0 26 3,093 0.004s 0.01s 13 0 0 10 3,807 0.003s 0.012s 14 0 0 51 7,330 0.015s 0.012s 15 0 0 52 7,830 0.006s 0.012s 16 0 0 48 5,281 0.005s 0.012s 17 0 0 6 2,576 0.004s 0.012s 18 0 0 0 129 0.002s 0.004s 19 0 0 0 3 0.003s 0.002s 20 0 0 2 91 0.003s 0.003s 21 0 0 0 369 0.023s 0.014s 22 0 0 1 405 0.003s 0.007s 23 0 0 1 19 0.009s 0.011s Day Hour Count Avg time (sec) Jul 03 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 03 00 14,453.00 kB 61,702.62 kB 01 2,138.00 kB 33,448.86 kB 02 1,420.86 kB 16,820.00 kB 03 1,194.67 kB 2,897.44 kB 04 1,535.91 kB 2,785.18 kB 05 8,817.22 kB 17,636.11 kB 06 2,945.00 kB 12,360.60 kB 07 34,271.00 kB 64,669.75 kB 08 86,308.42 kB 121,181.50 kB 09 93,063.00 kB 138,009.42 kB 10 86,895.83 kB 152,748.42 kB 11 106,960.08 kB 155,958.50 kB 12 42,752.50 kB 148,418.40 kB 13 13,698.67 kB 59,408.50 kB 14 70,079.67 kB 86,492.33 kB 15 70,582.67 kB 128,355.17 kB 16 65,127.08 kB 117,035.50 kB 17 8,301.58 kB 76,028.08 kB 18 767.75 kB 33,540.50 kB 19 166.00 kB 25,627.00 kB 20 9,558.00 kB 23,262.33 kB 21 1,854.00 kB 14,745.43 kB 22 1,533.86 kB 7,855.57 kB 23 1,428.20 kB 4,756.20 kB -
Temporary Files
Size of temporary files
Key values
- 466.41 MiB Temp Files size Peak
- 2026-07-03 05:31:55 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-03 05:31:55 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 03 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.06 GiB 108.43 MiB 06 0 0 0 07 0 0 0 08 2 286.02 MiB 143.01 MiB 09 4 416.00 MiB 104.00 MiB 10 3 312.00 MiB 104.00 MiB 11 1 104.00 MiB 104.00 MiB 12 0 0 0 13 5 910.03 MiB 182.01 MiB 14 3 390.01 MiB 130.00 MiB 15 0 0 0 16 1 182.01 MiB 182.01 MiB 17 3 546.02 MiB 182.01 MiB 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 11 1.12 GiB 104.00 MiB 104.00 MiB 104.00 MiB select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 07:19:07 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026605, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:06:01 Duration: 5m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026611, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:24:58 Duration: 5m Database: rio User: intelifix Remote: [local] Application: [unknown]
2 11 1.96 GiB 182.00 MiB 182.02 MiB 182.01 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01486);
Date: 2026-07-03 14:06:34 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01480);
Date: 2026-07-03 08:56:12 Duration: 1m48s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01487);
Date: 2026-07-03 16:53:28 Duration: 1m47s Database: contagem User: intelifix Remote: [local] Application: psql
3 8 905.89 MiB 69.56 MiB 233.20 MiB 113.24 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-03 05:32:03 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-03 05:31:55 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
4 2 178.38 MiB 89.19 MiB 89.19 MiB 89.19 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-03 05:30:40 Duration: 38s526ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-03 05:30:37 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 233.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-03 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 233.20 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-03 05:31:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01480);[ Date: 2026-07-03 08:56:07 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01490);[ Date: 2026-07-03 17:42:27 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01489);[ Date: 2026-07-03 17:18:07 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01486);[ Date: 2026-07-03 14:06:32 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01481);[ Date: 2026-07-03 13:07:19 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
8 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01487);[ Date: 2026-07-03 16:53:27 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
9 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01482);[ Date: 2026-07-03 13:23:38 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
10 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01483);[ Date: 2026-07-03 13:36:21 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
11 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01484);[ Date: 2026-07-03 13:47:51 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
12 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01485);[ Date: 2026-07-03 13:47:59 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
13 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01488);[ Date: 2026-07-03 17:06:25 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
14 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,433,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-03 11:39:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-03 09:33:20 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-03 10:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,508,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-03 14:14:27 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-03 09:56:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-03 10:22:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 104.00 MiB SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_lotes_cria(6,434,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;', '/var/www/html/tmp/temp_29.xlsx');[ Date: 2026-07-03 08:55:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 5.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-03 09:57:38 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 5.47 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-03 09:57:38 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (141) Main table analyzed (database rio)
- 1,313 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 141 rio.pg_catalog.pg_class 78 rio.pg_catalog.pg_type 63 rio.public.usuarios 48 rio.pg_catalog.pg_index 45 brasilia.pg_catalog.pg_attribute 44 rio.public.temp0000284382 41 rio.pg_catalog.pg_depend 36 contagem.pg_catalog.pg_attribute 34 rio.public.temp0000284388 33 contagem.public.temp0000226545 33 rio.public.temp0000284410 32 brasilia.public.temp0000235312 27 rio.public.temp0000284222 26 contagem.public.temp0000226531 24 brasilia.public.temp0000235258 23 brasilia.pg_catalog.pg_class 22 rio.public.temp0000284378 22 rio.public.temp0000284394 21 contagem.pg_catalog.pg_class 20 brasilia.pg_catalog.pg_type 18 contagem.pg_catalog.pg_type 18 rio.public.temp0000284374 17 rio.public.temp0000283956 17 rio.public.temp0000284420 16 rio.public.temp0000284458 16 rio.public.temp0000284370 16 rio.public.temp0000284376 14 rio.public.temp0000284386 13 rio.public.temp0000284482 13 contagem.pg_catalog.pg_index 13 contagem.public.usuarios 13 rio.public.temp0000284372 12 brasilia.public.temp0000235290 12 rio.public.temp0000284244 12 brasilia.public.temp0000235298 12 rio.public.temp0000284466 12 contagem.pg_catalog.pg_depend 11 rio.public.temp0000284454 11 rio.public.temp0000284494 11 brasilia.pg_catalog.pg_index 11 rio.public.temp0000284444 10 rio.public.temp0000281789 10 brasilia.pg_catalog.pg_depend 10 rio.public.temp0000284486 8 rio.public.temp0000284398 8 brasilia.public.usuarios 8 rio.public.temp0000284442 7 contagem.public.nf_entrada 6 rio.public.temp0000284450 5 template1.pg_catalog.pg_shdepend 5 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000284464 5 rio.public.temp0000284476 4 brasilia.public.temp0000235250 4 rio.public.temp0000284496 4 rio.auditor.auditor_2026_07 4 brasilia.public.temp0000235232 4 rio.public.temp0000284042 4 rio.public.temp0000284256 4 rio.public.temp0000284404 4 rio.public.temp0000284356 4 rio.public.tmp_drill_0302 3 contagem.auditor.auditor_2026_07 3 rio.public.temp0000284452 3 brasilia.public.temp0000235266 3 rio.public.temp0000284380 3 rio.public.temp0000284428 3 brasilia.pg_catalog.pg_shdepend 3 rio.public.temp0000284438 3 brasilia.public.temp0000235322 3 rio.public.temp0000284448 3 brasilia.public.temp0000235292 2 rio.public.temp0000283932 2 brasilia.public.temp0000235302 2 contagem.pg_catalog.pg_shdepend 2 contagem.public.temp0000226547 2 rio.public.temp0000284408 2 postgres.pg_catalog.pg_shdepend 2 brasilia.public.temp0000235286 2 brasilia.public.temp0000235306 2 brasilia.public.temp0000235296 2 brasilia.public.temp0000235240 1 brasilia.public.temp0000235320 1 contagem.public.temp0000226543 1 brasilia.public.temp0000235282 1 brasilia.public.temp0000235310 1 brasilia.public.temp0000235278 1 brasilia.public.temp0000235288 1 brasilia.public.temp0000235270 1 brasilia.public.temp0000235274 1 brasilia.public.temp0000235230 1 contagem.public.temp0000226553 1 rio.public.temp0000284390 1 rio.public.temp0000284396 1 brasilia.public.temp0000235264 1 brasilia.public.temp0000235256 1 brasilia.public.temp0000235244 1 brasilia.public.temp0000235300 1 rio.public.temp0000284432 1 brasilia.auditor.auditor_2026_07 1 brasilia.public.temp0000235226 1 brasilia.public.temp0000235248 1 brasilia.public.temp0000235332 1 rio.public.temp0000284402 1 brasilia.public.temp0000235304 1 brasilia.public.temp0000235246 1 brasilia.public.temp0000235284 1 rio.public.temp0000284418 1 brasilia.public.temp0000235276 1 contagem.public.temp0000226520 1 rio.public.temp0000284436 1 contagem.public.temp0000226549 1 brasilia.public.temp0000235340 1 rio.public.temp0000284498 1 brasilia.public.temp0000235338 1 brasilia.public.temp0000235330 1 brasilia.public.nf_entrada 1 brasilia.public.temp0000235328 1 brasilia.public.temp0000235238 1 brasilia.public.temp0000235344 1 Total 1,313 Vacuums per table
Key values
- pg_catalog.pg_attribute (63) Main table vacuumed on database rio
- 611 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 63 52 0 0 0 0 0 31,341 6,689 10,543,449 393 9,749 rio.pg_catalog.pg_class 44 37 0 0 0 0 0 7,621 1,999 2,772,058 96 359 rio.public.temp0000284382 41 0 0 0 0 0 0 36,396 1,797 4,252,430 0 0 rio.pg_catalog.pg_type 32 29 0 0 0 0 0 2,853 757 1,089,415 68 212 rio.public.temp0000284410 32 0 0 0 0 0 0 33,038 3,532 6,440,968 0 0 contagem.public.temp0000226531 24 0 0 0 0 0 0 1,494 135 111,827 0 0 rio.pg_catalog.pg_index 20 20 0 0 0 0 0 1,353 321 285,105 52 111 rio.public.temp0000284388 19 0 0 0 0 0 0 8,978 98 544,228 0 0 rio.public.temp0000284420 16 0 0 0 0 0 0 19,524 3,304 5,312,945 0 0 rio.pg_catalog.pg_depend 15 15 0 0 0 0 0 5,631 1,769 2,582,301 95 699 rio.public.usuarios 15 5 0 0 0 0 0 137 53 123,930 4 11 contagem.pg_catalog.pg_attribute 15 15 0 0 0 0 0 8,631 1,974 3,662,691 30 759 brasilia.pg_catalog.pg_attribute 15 15 0 0 0 0 0 7,877 1,845 3,039,910 83 2,404 contagem.public.usuarios 14 0 0 0 0 0 0 69 52 29,147 0 0 rio.public.temp0000284482 12 0 0 0 0 0 0 13,356 1,678 2,875,060 0 0 rio.public.temp0000284244 11 0 0 0 0 0 0 596 59 44,613 0 0 rio.public.temp0000284444 10 0 0 0 0 0 0 13,022 39 776,621 0 0 rio.public.temp0000284494 10 0 0 0 0 0 0 9,786 1,660 2,660,700 0 0 contagem.pg_catalog.pg_shdepend 10 10 0 0 0 0 0 1,400 413 848,633 64 160 contagem.pg_catalog.pg_class 10 10 0 0 0 0 0 1,738 328 525,971 13 38 rio.public.temp0000284466 10 0 0 0 0 0 0 11,407 37 678,848 0 0 rio.public.tmp_drill_0302 9 3 0 0 0 0 0 72 26 37,189 1 57 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 12,869 2,810 13,783,466 999 4,961 rio.public.temp0000284486 8 0 0 0 0 0 0 13,024 32 773,240 0 0 rio.public.temp0000281789 8 0 0 0 0 0 0 345 98 91,534 0 0 contagem.pg_catalog.pg_type 8 8 0 0 0 0 0 800 191 313,844 6 11 rio.public.temp0000284374 7 0 0 0 0 0 0 4,898 24 292,943 0 0 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,688 426 676,787 25 103 contagem.pg_catalog.pg_depend 6 6 0 0 0 0 0 1,617 455 893,339 9 48 brasilia.pg_catalog.pg_type 6 6 0 0 0 0 0 591 144 184,484 25 84 rio.public.temp0000284476 5 0 0 0 0 0 0 6,518 19 387,505 0 0 rio.public.temp0000284450 5 0 0 0 0 0 0 3,352 1,643 2,277,881 0 0 brasilia.pg_catalog.pg_index 5 5 0 0 0 0 0 246 58 56,394 14 24 contagem.pg_catalog.pg_index 5 5 0 0 0 0 0 262 77 82,800 7 7 rio.public.temp0000284256 4 0 0 0 0 0 0 314 22 21,871 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,321 504 3,031,862 156 521 brasilia.pg_catalog.pg_statistic 4 4 0 0 0 0 0 5,052 939 4,011,555 535 3,720 rio.auditor.auditor_2026_07 4 0 0 0 0 0 0 134,333 58,585 79,423,473 37,049 790,033 rio.public.temp0000284356 4 0 0 0 0 0 0 118 21 10,228 0 0 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,645 1,452 4,650,481 1,139 7,508 rio.public.temp0000284438 3 0 0 0 0 0 0 4,878 1,634 2,365,258 0 0 rio.public.temp0000284442 3 0 0 0 0 0 0 1,735 15 104,746 0 0 rio.public.temp0000284452 3 0 0 0 0 0 0 320 18 21,695 0 0 contagem.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 355 117 463,154 24 59 contagem.public.temp0000226545 3 0 0 0 0 0 0 208 17 15,007 0 0 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 1,008 294 359,951 23 260 rio.public.temp0000284464 3 0 0 0 0 0 0 335 123 235,825 0 0 rio.public.temp0000284448 3 0 0 0 0 0 0 4,878 12 289,611 0 0 brasilia.public.temp0000235292 2 0 0 0 0 0 0 476 12 30,316 0 0 rio.public.temp0000283932 2 0 0 0 0 0 0 116 11 8,506 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 140 63 142,581 7 16 contagem.auditor.auditor_2026_07 2 0 0 0 0 0 0 9,501 6,669 8,990,615 1,292 26,326 brasilia.public.temp0000235266 2 0 0 0 0 0 0 476 12 30,330 0 0 rio.public.temp0000284380 2 0 0 0 0 0 0 1,707 10 102,214 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 368 83 339,323 30 78 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 5,926 4,385 5,640,717 725 12,409 rio.public.temp0000284042 1 0 0 0 0 0 0 146 145 253,166 0 0 brasilia.public.temp0000235320 1 0 0 0 0 0 0 238 6 15,157 0 0 rio.public.temp0000284398 1 0 0 0 0 0 0 80 78 153,527 0 0 rio.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 200 76 113,315 3 4 brasilia.public.temp0000235248 1 0 0 0 0 0 0 239 6 15,233 0 0 brasilia.public.temp0000235282 1 0 0 0 0 0 0 8 5 1,505 0 0 rio.public.temp0000284402 1 0 0 0 0 0 0 80 6 5,620 0 0 rio.public.temp0000284454 1 0 0 0 0 0 0 8 5 1,352 0 0 brasilia.public.temp0000235278 1 0 0 0 0 0 0 125 4 7,978 0 0 rio.public.temp0000284394 1 0 0 0 0 0 0 8 5 1,351 0 0 brasilia.public.temp0000235270 1 0 0 0 0 0 0 240 6 15,403 0 0 rio.public.temp0000284418 1 0 0 0 0 0 0 81 6 5,681 0 0 brasilia.public.temp0000235276 1 0 0 0 0 0 0 239 6 15,242 0 0 rio.public.nf_entrada_arquivos_notas 1 1 0 0 0 0 0 34 24 97,965 0 0 rio.public.temp0000284404 1 0 0 0 0 0 0 80 6 5,621 0 0 brasilia.public.temp0000235306 1 0 0 0 0 0 0 238 6 15,159 0 0 brasilia.public.temp0000235286 1 0 0 0 0 0 0 8 5 1,504 0 0 brasilia.public.temp0000235328 1 0 0 0 0 0 0 238 6 15,159 0 0 contagem.public.temp0000226547 1 0 0 0 0 0 0 100 6 6,840 0 0 brasilia.public.temp0000235330 1 0 0 0 0 0 0 238 6 15,159 0 0 rio.public.temp0000284390 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000235296 1 0 0 0 0 0 0 238 6 15,159 0 0 rio.public.temp0000284396 1 0 0 0 0 0 0 8 5 1,294 0 0 Total 611 280 0 0 0 0 0 443,618 109,967 180,120,739 42,967 860,731 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (18.89) 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 3.95 rio.pg_catalog.pg_class 0 0 1.11 rio.public.temp0000284382 0 0 1.59 rio.pg_catalog.pg_type 0 0 0.39 rio.public.temp0000284410 0 0 1.39 contagem.public.temp0000226531 0 0 0.46 rio.pg_catalog.pg_index 0 0 0.27 rio.public.temp0000284388 0 0 0.44 rio.public.temp0000284420 0 0 0.89 rio.pg_catalog.pg_depend 0 0 1.02 rio.public.usuarios 0 0 0 contagem.pg_catalog.pg_attribute 0 0 1.18 brasilia.pg_catalog.pg_attribute 0 0 1.1 contagem.public.usuarios 0 0 0 rio.public.temp0000284482 0 0 0.49 rio.public.temp0000284244 0 0 0.18 rio.public.temp0000284444 0 0 0.51 rio.public.temp0000284494 0 0 0.54 contagem.pg_catalog.pg_shdepend 0 0 0.31 contagem.pg_catalog.pg_class 0 0 0.3 rio.public.temp0000284466 0 0 0.5 rio.public.tmp_drill_0302 0 0 0 rio.pg_catalog.pg_statistic 0 0 1.72 rio.public.temp0000284486 0 0 0.4 rio.public.temp0000281789 0 0 0.1 contagem.pg_catalog.pg_type 0 0 0.14 rio.public.temp0000284374 0 0 0.34 brasilia.pg_catalog.pg_class 0 0 0.34 contagem.pg_catalog.pg_depend 0 0 0.24 brasilia.pg_catalog.pg_type 0 0 0.1 rio.public.temp0000284476 0 0 0.27 rio.public.temp0000284450 0 0 0.24 brasilia.pg_catalog.pg_index 0 0 0.07 contagem.pg_catalog.pg_index 0 0 0.19 rio.public.temp0000284256 0 0 0.06 rio.pg_toast.pg_toast_2619 0 0 0.2 brasilia.pg_catalog.pg_statistic 0 0 0.55 rio.auditor.auditor_2026_07 0 0 18.89 rio.public.temp0000284356 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.3 rio.public.temp0000284438 0 0 0.2 rio.public.temp0000284442 0 0 0.07 rio.public.temp0000284452 0 0 0.05 contagem.pg_toast.pg_toast_2619 0 0 0.04 contagem.public.temp0000226545 0 0 0.04 brasilia.pg_catalog.pg_depend 0 0 0.19 rio.public.temp0000284464 0 0 0.05 rio.public.temp0000284448 0 0 0.15 brasilia.public.temp0000235292 0 0 0.04 rio.public.temp0000283932 0 0 0.03 contagem.public.nf_entrada 0 0 0.03 contagem.auditor.auditor_2026_07 0 0 2.47 brasilia.public.temp0000235266 0 0 0.05 rio.public.temp0000284380 0 0 0.07 brasilia.pg_toast.pg_toast_2619 0 0 0.02 brasilia.auditor.auditor_2026_07 0 0 1.55 rio.public.temp0000284042 0 0 0.02 brasilia.public.temp0000235320 0 0 0.02 rio.public.temp0000284398 0 0 0.01 rio.pg_catalog.pg_shdepend 0 0 0.04 brasilia.public.temp0000235248 0 0 0.01 brasilia.public.temp0000235282 0 0 0.02 rio.public.temp0000284402 0 0 0.02 rio.public.temp0000284454 0 0 0.02 brasilia.public.temp0000235278 0 0 0 rio.public.temp0000284394 0 0 0.01 brasilia.public.temp0000235270 0 0 0.02 rio.public.temp0000284418 0 0 0.02 brasilia.public.temp0000235276 0 0 0.02 rio.public.nf_entrada_arquivos_notas 0 0 0.01 rio.public.temp0000284404 0 0 0.02 brasilia.public.temp0000235306 0 0 0.02 brasilia.public.temp0000235286 0 0 0.02 brasilia.public.temp0000235328 0 0 0.02 contagem.public.temp0000226547 0 0 0.01 brasilia.public.temp0000235330 0 0 0.02 rio.public.temp0000284390 0 0 0.05 brasilia.public.temp0000235296 0 0 0.02 rio.public.temp0000284396 0 0 0.01 Total 0 0 46.3 Tuples removed per table
Key values
- pg_catalog.pg_attribute (248478) Main table with removed tuples on database rio
- 467647 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 63 52 248,478 1,609,603 128,792 662 38,440 brasilia.pg_catalog.pg_attribute 15 15 59,847 343,849 892 125 9,387 contagem.pg_catalog.pg_attribute 15 15 59,188 355,688 290 86 8,157 rio.pg_catalog.pg_statistic 9 9 15,432 77,596 509 0 11,574 rio.pg_catalog.pg_depend 15 15 12,738 289,663 2,843 0 2,777 rio.pg_catalog.pg_type 32 29 11,975 77,452 4,016 25 2,333 contagem.pg_catalog.pg_shdepend 10 10 8,594 136,325 322 0 1,150 brasilia.pg_catalog.pg_statistic 4 4 7,708 34,749 0 0 4,288 contagem.pg_catalog.pg_statistic 3 3 6,558 22,734 17 0 3,033 rio.pg_catalog.pg_index 20 20 6,496 39,224 637 0 1,180 rio.pg_catalog.pg_class 44 37 5,144 173,390 15,562 183 5,595 brasilia.pg_catalog.pg_type 6 6 3,032 13,422 0 0 460 contagem.pg_catalog.pg_type 8 8 2,718 18,032 2 13 511 contagem.pg_catalog.pg_depend 6 6 2,648 113,072 6 11 1,038 contagem.auditor.auditor_2026_07 2 0 2,208 777,449 0 0 32,267 rio.auditor.auditor_2026_07 4 0 2,141 9,718,722 0 0 457,580 brasilia.pg_catalog.pg_class 7 7 2,081 23,764 16 105 778 brasilia.pg_catalog.pg_depend 3 3 1,903 52,856 0 0 552 contagem.pg_catalog.pg_index 5 5 1,251 9,496 2 5 263 contagem.pg_catalog.pg_class 10 10 1,242 34,141 8 36 1,196 rio.pg_toast.pg_toast_2619 4 4 1,224 3,332 1 0 1,080 brasilia.pg_catalog.pg_index 5 5 1,096 9,398 0 12 261 contagem.public.usuarios 14 0 830 322 0 0 28 brasilia.auditor.auditor_2026_07 1 0 816 574,916 0 0 25,117 rio.pg_catalog.pg_shdepend 1 1 764 13,550 24 0 115 rio.public.tmp_drill_0302 9 3 586 3,926 1,670 0 64 contagem.public.nf_entrada 2 2 294 2,962 0 0 138 brasilia.pg_toast.pg_toast_2619 2 2 234 274 0 0 140 contagem.pg_toast.pg_toast_2619 3 3 201 341 0 22 120 rio.public.usuarios 15 5 177 10,480 2,845 0 255 rio.public.nf_entrada_arquivos_notas 1 1 43 19,813 0 0 108 rio.public.temp0000284042 1 0 0 6,137 0 54 138 rio.public.temp0000284486 8 0 0 183,226 0 0 13,312 brasilia.public.temp0000235320 1 0 0 3,065 0 26 230 rio.public.temp0000284398 1 0 0 1,310 0 56 72 rio.public.temp0000284420 16 0 0 365,865 0 0 26,624 rio.public.temp0000284476 5 0 0 114,484 0 0 8,320 brasilia.public.temp0000235292 2 0 0 6,130 0 52 460 rio.public.temp0000283932 2 0 0 5,661 0 33 127 rio.public.temp0000284382 41 0 0 703,026 0 496 50,832 rio.public.temp0000284374 7 0 0 160,205 0 0 11,648 rio.public.temp0000284256 4 0 0 12,831 0 130 286 brasilia.public.temp0000235248 1 0 0 3,062 0 26 230 brasilia.public.temp0000235282 1 0 0 3,063 0 26 230 rio.public.temp0000284402 1 0 0 1,310 0 56 72 rio.public.temp0000284450 5 0 0 93,065 0 46 6,738 rio.public.temp0000284454 1 0 0 5,356 0 8 120 rio.public.temp0000281789 8 0 0 17,001 0 172 436 brasilia.public.temp0000235278 1 0 0 1,352 0 0 128 rio.public.temp0000284444 10 0 0 228,838 0 0 16,640 rio.public.temp0000284494 10 0 0 229,059 0 0 16,640 rio.public.temp0000284394 1 0 0 1,946 0 26 102 rio.public.temp0000284438 3 0 0 68,616 0 0 4,992 rio.public.temp0000284442 3 0 0 28,701 0 73 1,847 brasilia.public.temp0000235270 1 0 0 3,062 0 26 230 contagem.public.temp0000226531 24 0 0 29,100 0 844 2,228 rio.public.temp0000284418 1 0 0 1,316 0 55 73 rio.public.temp0000284388 19 0 0 141,055 0 475 9,189 rio.public.temp0000284410 32 0 0 602,667 0 305 43,727 rio.public.temp0000284452 3 0 0 11,763 0 89 295 brasilia.public.temp0000235276 1 0 0 3,063 0 26 230 brasilia.public.temp0000235266 2 0 0 6,125 0 52 460 rio.public.temp0000284380 2 0 0 24,201 0 56 1,736 rio.public.temp0000284404 1 0 0 1,311 0 56 72 contagem.public.temp0000226545 3 0 0 3,620 0 108 276 rio.public.temp0000284244 11 0 0 43,090 0 346 966 brasilia.public.temp0000235306 1 0 0 3,065 0 26 230 rio.public.temp0000284482 12 0 0 211,788 0 86 15,274 brasilia.public.temp0000235286 1 0 0 3,064 0 26 230 brasilia.public.temp0000235328 1 0 0 3,065 0 26 230 contagem.public.temp0000226547 1 0 0 1,207 0 36 92 brasilia.public.temp0000235330 1 0 0 3,065 0 26 230 rio.public.temp0000284390 1 0 0 22,839 0 0 1,664 rio.public.temp0000284464 3 0 0 5,973 0 73 311 rio.public.temp0000284356 4 0 0 10,244 0 59 261 brasilia.public.temp0000235296 1 0 0 3,065 0 26 230 rio.public.temp0000284466 10 0 0 228,954 0 0 16,640 rio.public.temp0000284396 1 0 0 1,311 0 55 73 rio.public.temp0000284448 3 0 0 68,627 0 0 4,992 Total 611 280 467,647 18,240,490 158,454 5,442 870,148 Pages removed per table
Key values
- public.temp0000226531 (844) Main table with removed pages on database contagem
- 5442 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed contagem.public.temp0000226531 24 0 0 844 rio.pg_catalog.pg_attribute 63 52 248478 662 rio.public.temp0000284382 41 0 0 496 rio.public.temp0000284388 19 0 0 475 rio.public.temp0000284244 11 0 0 346 rio.public.temp0000284410 32 0 0 305 rio.pg_catalog.pg_class 44 37 5144 183 rio.public.temp0000281789 8 0 0 172 rio.public.temp0000284256 4 0 0 130 brasilia.pg_catalog.pg_attribute 15 15 59847 125 contagem.public.temp0000226545 3 0 0 108 brasilia.pg_catalog.pg_class 7 7 2081 105 rio.public.temp0000284452 3 0 0 89 contagem.pg_catalog.pg_attribute 15 15 59188 86 rio.public.temp0000284482 12 0 0 86 rio.public.temp0000284442 3 0 0 73 rio.public.temp0000284464 3 0 0 73 rio.public.temp0000284356 4 0 0 59 rio.public.temp0000284398 1 0 0 56 rio.public.temp0000284402 1 0 0 56 rio.public.temp0000284380 2 0 0 56 rio.public.temp0000284404 1 0 0 56 rio.public.temp0000284418 1 0 0 55 rio.public.temp0000284396 1 0 0 55 rio.public.temp0000284042 1 0 0 54 brasilia.public.temp0000235292 2 0 0 52 brasilia.public.temp0000235266 2 0 0 52 rio.public.temp0000284450 5 0 0 46 contagem.public.temp0000226547 1 0 0 36 contagem.pg_catalog.pg_class 10 10 1242 36 rio.public.temp0000283932 2 0 0 33 brasilia.public.temp0000235320 1 0 0 26 brasilia.public.temp0000235248 1 0 0 26 brasilia.public.temp0000235282 1 0 0 26 rio.public.temp0000284394 1 0 0 26 brasilia.public.temp0000235270 1 0 0 26 brasilia.public.temp0000235276 1 0 0 26 brasilia.public.temp0000235306 1 0 0 26 brasilia.public.temp0000235286 1 0 0 26 brasilia.public.temp0000235328 1 0 0 26 brasilia.public.temp0000235330 1 0 0 26 brasilia.public.temp0000235296 1 0 0 26 rio.pg_catalog.pg_type 32 29 11975 25 contagem.pg_toast.pg_toast_2619 3 3 201 22 contagem.pg_catalog.pg_type 8 8 2718 13 brasilia.pg_catalog.pg_index 5 5 1096 12 contagem.pg_catalog.pg_depend 6 6 2648 11 rio.public.temp0000284454 1 0 0 8 contagem.pg_catalog.pg_index 5 5 1251 5 brasilia.auditor.auditor_2026_07 1 0 816 0 rio.public.temp0000284486 8 0 0 0 rio.public.temp0000284420 16 0 0 0 rio.public.temp0000284476 5 0 0 0 rio.pg_catalog.pg_depend 15 15 12738 0 rio.public.temp0000284374 7 0 0 0 rio.public.tmp_drill_0302 9 3 586 0 rio.pg_catalog.pg_shdepend 1 1 764 0 rio.pg_toast.pg_toast_2619 4 4 1224 0 rio.public.usuarios 15 5 177 0 contagem.public.nf_entrada 2 2 294 0 rio.pg_catalog.pg_index 20 20 6496 0 rio.pg_catalog.pg_statistic 9 9 15432 0 contagem.pg_catalog.pg_statistic 3 3 6558 0 brasilia.public.temp0000235278 1 0 0 0 rio.public.temp0000284444 10 0 0 0 rio.public.temp0000284494 10 0 0 0 brasilia.pg_catalog.pg_statistic 4 4 7708 0 rio.public.temp0000284438 3 0 0 0 contagem.auditor.auditor_2026_07 2 0 2208 0 rio.public.nf_entrada_arquivos_notas 1 1 43 0 rio.auditor.auditor_2026_07 4 0 2141 0 brasilia.pg_toast.pg_toast_2619 2 2 234 0 brasilia.pg_catalog.pg_type 6 6 3032 0 contagem.public.usuarios 14 0 830 0 brasilia.pg_catalog.pg_depend 3 3 1903 0 rio.public.temp0000284390 1 0 0 0 contagem.pg_catalog.pg_shdepend 10 10 8594 0 rio.public.temp0000284466 10 0 0 0 rio.public.temp0000284448 3 0 0 0 Total 611 280 467,647 5,442 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 03 00 1 1 01 0 0 02 0 0 03 0 1 04 0 13 05 6 16 06 2 6 07 24 57 08 70 137 09 93 158 10 69 137 11 81 177 12 21 45 13 32 75 14 78 164 15 54 182 16 48 96 17 28 43 18 0 1 19 0 0 20 0 0 21 4 4 22 0 0 23 0 0 - 5.47 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- AccessExclusiveLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 1m3s 1m3s 1m3s 1m3s select * from rs_nf_entrada_exclui (?);-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (026581);
Date: 2026-07-03 16:16:55 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (026603);
Date: 2026-07-03 14:52:07 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NF_ENTRADA_EXCLUI (026542);
Date: 2026-07-03 09:14:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1 57s219ms 57s219ms 57s219ms 57s219ms call rs_giga_processa_arquivos ();-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 15:06:05 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 00:05:14 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 09:05:11 Database: rio User: intelifix Remote: [local] Application: psql
3 1 5s768ms 5s768ms 5s768ms 5s768ms select * from rs_lote_manutencao (?);-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"0015", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-03 14:49:17 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"316", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-03 07:43:03 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"303", "usuario" :"507", "tipo" :"N", "itens" :"004", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-03 08:30:26 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000284410;-
DROP TABLE IF EXISTS temp0000284410;
Date: 2026-07-03 10:24:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000284410;
Date: 2026-07-03 10:24:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
5 1 1s 1s 1s 1s drop table if exists temp0000284476;-
DROP TABLE IF EXISTS temp0000284476;
Date: 2026-07-03 14:35:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000284476;
Date: 2026-07-03 14:35:47 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m3s SELECT * FROM RS_NF_ENTRADA_EXCLUI (01485);[ Date: 2026-07-03 13:48:00 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
2 57s219ms CALL RS_GIGA_PROCESSA_ARQUIVOS ();[ Date: 2026-07-03 15:06:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 5s768ms SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"0015", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');[ Date: 2026-07-03 14:49:17 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s1ms DROP TABLE IF EXISTS temp0000284410;[ Date: 2026-07-03 10:24:33 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s DROP TABLE IF EXISTS temp0000284476;[ Date: 2026-07-03 14:35:47 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,011 Total read queries
- 1,964 Total write queries
Queries by database
Key values
- rio Main database
- 5,311 Requests
- 6h44m40s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,238 Requests
User Request type Count Duration etiquetas Total 35 6s775ms select 35 6s775ms intelifix Total 7,238 8h54m16s copy to 341 48m56s ddl 1,623 1h21m54s others 409 35m58s select 4,863 6h7m27s lenon Total 113 52s229ms select 113 52s229ms Duration by user
Key values
- 8h54m16s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 35 6s775ms select 35 6s775ms intelifix Total 7,238 8h54m16s copy to 341 48m56s ddl 1,623 1h21m54s others 409 35m58s select 4,863 6h7m27s lenon Total 113 52s229ms select 113 52s229ms Queries by host
Key values
- [local] Main host
- 7,386 Requests
- 8h55m15s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,356 Requests
- 4h14m24s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-03 21:24:11 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,993 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 07:14:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 09:13:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m22s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 15:13:23 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m18s analyze verbose;[ Date: 2026-07-03 05:08:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m10s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 11:13:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m7s SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;[ Date: 2026-07-03 16:13:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 10:13:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 12:12:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 08:12:45 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 14:12:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m30s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 20:12:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 17:12:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m24s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 13:11:26 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 21:11:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m51s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 22:10:53 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m46s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-03 07:19:07 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 19:10:42 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m20s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-03 18:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m4s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026605, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-03 15:06:01 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026611, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-03 15:24:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h55m36s 47 1s301ms 9m14s 2m27s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 03 07 3 9m49s 3m16s 08 3 8m6s 2m42s 09 3 9m10s 3m3s 10 3 8m32s 2m50s 11 3 8m36s 2m52s 12 3 8m21s 2m47s 13 3 6m41s 2m13s 14 3 7m58s 2m39s 15 3 8m46s 2m55s 16 2 24s8ms 12s4ms 17 3 7m19s 2m26s 18 3 5m38s 1m52s 19 3 5m57s 1m59s 20 3 7m48s 2m36s 21 3 6m18s 2m6s 22 3 6m7s 2m2s [ User: intelifix - Total duration: 1h55m36s - Times executed: 47 ]
[ Application: psql - Total duration: 1h55m36s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-03 07:14:15 Duration: 9m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-03 09:13:39 Duration: 8m37s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-03 15:13:23 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
2 1h42m59s 432 150ms 5m46s 14s304ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 03 07 17 10m26s 36s880ms 08 58 11m34s 11s969ms 09 40 13m59s 20s977ms 10 44 8m55s 12s174ms 11 43 15m59s 22s324ms 12 16 5m7s 19s205ms 13 32 1m29s 2s794ms 14 63 14m14s 13s559ms 15 62 10m58s 10s616ms 16 45 9m57s 13s269ms 17 12 17s328ms 1s444ms [ User: intelifix - Total duration: 1h42m59s - Times executed: 432 ]
[ Application: [unknown] - Total duration: 1h42m59s - Times executed: 432 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 07:19:07 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026605, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:06:01 Duration: 5m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026611, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:24:58 Duration: 5m Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h10m10s 46 249ms 4m45s 1m31s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 03 07 3 5m52s 1m57s 08 3 4m42s 1m34s 09 3 5m5s 1m41s 10 3 4m53s 1m37s 11 2 4m5s 2m2s 12 2 4m39s 2m19s 13 3 3m59s 1m19s 14 3 4m29s 1m29s 15 3 4m31s 1m30s 16 3 4m13s 1m24s 17 3 4m1s 1m20s 18 3 4m4s 1m21s 19 3 3m48s 1m16s 20 3 4m18s 1m26s 21 3 3m35s 1m11s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h10m10s - Times executed: 46 ]
[ Application: psql - Total duration: 1h10m10s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-03 07:20:36 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-03 08:17:48 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-03 11:18:27 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
4 18m25s 15 1s694ms 1m52s 1m13s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 03 08 2 1m54s 57s303ms 10 1 2s638ms 2s638ms 11 2 5s743ms 2s871ms 13 5 7m54s 1m34s 14 1 1m52s 1m52s 16 1 1m47s 1m47s 17 3 4m48s 1m36s [ User: intelifix - Total duration: 18m25s - Times executed: 15 ]
[ Application: psql - Total duration: 18m25s - Times executed: 15 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01486);
Date: 2026-07-03 14:06:34 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01480);
Date: 2026-07-03 08:56:12 Duration: 1m48s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01487);
Date: 2026-07-03 16:53:28 Duration: 1m47s Database: contagem User: intelifix Remote: [local] Application: psql
5 15m41s 82 9s12ms 14s457ms 11s479ms create table temp0000284382 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 03 07 12 2m8s 10s671ms 08 10 1m51s 11s149ms 09 8 1m44s 13s120ms 10 10 1m50s 11s21ms 11 13 2m28s 11s389ms 12 6 1m3s 10s593ms 14 15 2m56s 11s791ms 15 8 1m38s 12s262ms [ User: intelifix - Total duration: 15m41s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 15m41s - Times executed: 82 ]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:01:21 Duration: 14s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:00:25 Duration: 14s331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 15:18:15 Duration: 14s115ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 14m23s 3 2m14s 8m18s 4m47s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 03 05 3 14m23s 4m47s [ User: intelifix - Total duration: 14m23s - Times executed: 3 ]
[ Application: psql - Total duration: 14m23s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-03 05:08:20 Duration: 8m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-03 05:12:10 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-03 05:14:24 Duration: 2m14s Database: contagem User: intelifix Remote: [local] Application: psql
7 14m9s 1,349 150ms 3s604ms 629ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 03 07 44 28s882ms 656ms 08 203 2m 595ms 09 193 1m55s 596ms 10 188 2m8s 681ms 11 179 1m25s 480ms 12 48 32s758ms 682ms 13 79 41s318ms 523ms 14 147 1m42s 699ms 15 185 2m16s 739ms 16 70 45s285ms 646ms 17 13 11s244ms 864ms [ User: intelifix - Total duration: 14m9s - Times executed: 1349 ]
[ Application: [unknown] - Total duration: 14m9s - Times executed: 1349 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (261777, 450, 'F200011103B20E9,9877E77B97AF$F200011167B41C0,9877E7BD6212$F200011300B25D9,8401127F7A5E$F200011081B0AAC,9877E74B1564$F200011235B45E2,84011229FD85$F200011074B7346,9877E749EC46$F200011011B020E,9877E707EA9A$F200011102B295D,9877E77B5F07$F200011151B5680,9877E7BC9D55$F200010258E0ADF,743AEF9A6A09$F200011131B70AE,9877E7B9C245$F200011053B8390,9877E74CC83D$F200011280B1D90,8401125F44BA$F20001016014463,743AEF5C4FB5$F200012075B9D38,840112DDA2F2$F200012004B6839,84011295D29F$F200011180B17F4,9877E7C06420$F200011301B4B07,8401127FD653$F200010295E25FC,743AEFAF9823$F200011251B6648,8401123776F3$F200010279B5BC3,743AEFABDD36$F200013237B388D,1834AF9ABFB3$F200012015B7204,8401129836C4$F200011350B8E94,8401129462D9AEF5C3973,743AEF5C3973$F200010279B34B3,743AEFABCC1F$F200011112B8ADB,9877E77E0910$F200010339B6493,9877E7015CD2$F200011323B41A6,8401128239C9$F200012031B0A08,840112BFC82A$F200010245B8AEF,743AEF956C00$F200010314B4544,743AEFC6D8E8$F200011063BB8DD,9877E747DB48$F200011217B4418,84011227F5E8$F200013195B048C,1834AF995C26$F200011323B5A02,840112824473$F200011082B42D1,9877E74B79E8$F200011293B08A5,840112607E5C$F200012060B4707,840112C255A7$F200011151B7BC2,9877E7BCADA1', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-03 14:13:18 Duration: 3s604ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260497, 503, 'ZTE3ANNR9300512,D89A0D826C0B,D89A0D826C0C,ZTEGDB1475FF$ZTE3ANNQ4A14986,3CF9F0AB5782,3CF9F0AB5783,ZTEGD6417949$ZTE3ANNRB728696,5872C990D9C1,5872C990D9C2,ZTEGDC619AEB$ZTE3ANNRCP67289,6C11BA6F53E5,6C11BA6F53E6,ZTEGDC70476C$ZTE3ANNT3H01929,D8313996F0CE,D8313996F0CF,ZTEGDD31D828$ZTE3ANNRC536165,6C11BA657975,6C11BA657976,ZTEGDC6EA304$ZTE3ANNR7B15452,3891484A56CF,3891484A56D0,ZTEGDB07CDBC$ZTE3ANNQ9337015,843C9935F8C7,843C9935F8C8,ZTEGD7BC4C8E$ZTE3ANNQ9334397,843C9935BB6B,843C9935BB6C,ZTEGD7BC4254$ZTE3ANNQ9334631,843C9935C0E7,843C9935C0E8,ZTEGD7BC433E$ZTE3ANNQ8M08329,843C991F8B21,843C991F8B22,ZTEGD7BA67F6$ZTE3ANNR1Y17968,14CA56CE4F9B,14CA56CE4F9C,ZTEGD970BC8B$ZTE3ANNRAM63391,5872C98D05F3,5872C98D05F4,ZTEGDC60F79E$ZTE3ANNRB747714,5872C992977D,5872C992977E,ZTEGDC61E535$ZTE3ANNR1Y17986,14CA56CE5007,14CA56CE5008,ZTEGD970BC9D$ZTE3ANNRAD24632,D89A0DB01BB3,D89A0DB01BB4,ZTEGDB175C43$ZTE3ANNR7B16531,3891484A7019,3891484A701A,ZTEGDB07D1F3$ZTE3ANNR9W18526,D89A0DAA0E57,D89A0DAA0E58,ZTEGDB165A09$ZTE3ANNRC553546,6C11BA6710D3,6C11BA6710D4,ZTEGDC6EE6E9$ZTE3ANNR5W68619,48D68234CC0C,48D68234CC0D,ZTEGDB010C0A$ZTE3ANNRC506673,6C11BA62C63D,6C11BA62C63E,ZTEGDC6E2FD0$ZTE3ANNQ9336958,843C9935F771,843C9935F772,ZTEGD7BC4C55$ZTE3ANNR8C28324,389148511EDF,389148511EE0,ZTEGDB08EF14$ZTE3ANNQ4A14740,3CF9F0AB51BE,3CF9F0AB51BF,ZTEGD6417853$ZTE3ANNR3J00285,F4E84F86550E,F4E84F86550F,ZTEGD97B62E7$ZTE3ANNQ4A14872,3CF9F0AB54D6,3CF9F0AB54D7,ZTEGD64178D7$ZTE3ANNR7B15440,3891484A5687,3891484A5688,ZTEGDB07CDB0$ZTE3ANNRAD24813,D89A0DB01FF1,D89A0DB01FF2,ZTEGDB175CF8$ZTE3ANNR8C34886,38914851B8AB,38914851B8AC,ZTEGDB0908B6$ZTE3ANNRB701239,5872C98E563B,5872C98E563C,ZTEGDC612FAA$ZTE3ANNQ9323436,843C9934BA85,843C9934BA86,ZTEGD7BC1783$ZTE3ANNQ8F08577,689E29FCEBE3,689E29FCEBE4,ZTEGD7BA1E51$ZTE3ANNR3J00548,F4E84F865B38,F4E84F865B39,ZTEGD97B63EE$ZTE3ANNQ9334659,843C9935C18F,843C9935C190,ZTEGD7BC435A$ZTE3ANNRAD24722,D89A0DB01DCF,D89A0DB01DD0,ZTEGDB175C9D$ZTE3ANNRAM35392,5872C98A75B9,5872C98A75BA,ZTEGDC608A3F$ZTE3ANNR3Y29470,4896D952736C,4896D952736D,ZTEGD97EA3D3$ZTE3ANNQ4A15245,3CF9F0AB5D94,3CF9F0AB5D95,ZTEGD6417A4C$ZTE3ANNR2Q01492,F4E84F80D6F8,F4E84F80D6F9,ZTEGD97A788E$ZTE3ANNQ8F02898,689E29FC66C9,689E29FC66CA,ZTEGD7BA0822', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-03 09:53:27 Duration: 3s602ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260497, 304, 'ZTE3ANNT2V13509,D831398CCB76,D831398CCB77,ZTEGDD302744$ZTE3ANNR8C35655,38914851CAB1,38914851CAB2,ZTEGDB090BB7$ZTE3ANNQ8F09917,689E29FD0B4B,689E29FD0B4C,ZTEGD7BA238D$ZTE3ANNRB747763,5872C99298A3,5872C99298A4,ZTEGDC61E566$ZTE3ANNR2Q02835,F4E84F80F672,F4E84F80F673,ZTEGD97A7DCD$ZTE3ANNRCP49595,6C11BA6DB531,6C11BA6DB532,ZTEGDC70024E$ZTE3ANNR3J00257,F4E84F865466,F4E84F865467,ZTEGD97B62CB$ZTE3ANNR1Y48893,14CA56D12469,14CA56D1246A,ZTEGD9713558$ZTE3ANNRCB21062,D831391FBCA2,D831391FBCA3,ZTEGDD2A07DB$ZTE3ANNRCB21183,D831391FBF78,D831391FBF79,ZTEGDD2A0854$ZTE3ANNR3Y51239,4896D95471A2,4896D95471A3,ZTEGD97EF8DC$ZTE3ANNQ7506346,C4EBFF8B87F8,C4EBFF8B87F9,ZTEGD70A676A$ZTE3ANNQ3R02022,3CF9F0A2AF2A,3CF9F0A2AF2B,ZTEGD64007E5$ZTE3ANNQ9341628,843C993664E5,843C993664E6,ZTEGD7BC5E93$ZTE3ANNR7B33378,3891484BFAF3,3891484BFAF4,ZTEGDB0813C2$ZTE3ANNT3H46203,D831399AFE7A,D831399AFE7B,219702062154$ZTE3ANNRCB66174,D8313923DDF2,D8313923DDF3,ZTEGDD2AB813$ZTE3ANNT3F11415,D83139963752,D83139963753,ZTEGDD31B93E$ZTE3ANNR3J02680,F4E84F868D30,F4E84F868D31,ZTEGD97B6C42$ZTE3ANNRC506380,6C11BA62BF5F,6C11BA62BF60,ZTEGDC6E2EAB$ZTE3ANNQ8126448,689E29BE4AAB,689E29BE4AAC,ZTEGD7B7A1E0$ZTE3ANNQ9344571,843C9936A9DF,843C9936A9E0,ZTEGD7BC6A12$ZTE3ANNR9W42679,D89A0DAC446D,D89A0DAC446E,ZTEGDB16B862$ZTE3ANNR9F40479,D89A0DA6929D,D89A0DA6929E,ZTEGDB15C56A$ZTE3ANNQ9341523,843C9936626F,843C99366270,ZTEGD7BC5E2A$ZTE3ANNQ8125633,689E29BE3791,689E29BE3792,ZTEGD7B79EB1$ZTE3ANNR5W03122,48D6822ECCF6,48D6822ECCF7,ZTEGDB000C31$ZTE3ANNR7B32641,3891484BE9AD,3891484BE9AE,ZTEGDB0810E1$ZTE3ANNR7B32398,3891484BE3FB,3891484BE3FC,ZTEGDB080FEE$ZTE3ANNR8C35481,38914851C69D,38914851C69E,ZTEGDB090B09$ZTE3ANNT2V36051,D831398EDBCA,D831398EDBCB,ZTEGDD307F52', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-03 09:14:39 Duration: 3s541ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 13m19s 196 1s451ms 18s619ms 4s78ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 03 07 4 32s690ms 8s172ms 08 5 44s215ms 8s843ms 09 7 31s679ms 4s525ms 10 13 1m2s 4s838ms 11 20 1m23s 4s156ms 12 4 19s918ms 4s979ms 13 13 41s640ms 3s203ms 14 26 1m18s 3s10ms 15 45 3m40s 4s897ms 16 30 1m58s 3s961ms 17 28 1m3s 2s269ms 18 1 2s130ms 2s130ms [ User: intelifix - Total duration: 13m19s - Times executed: 196 ]
[ Application: [unknown] - Total duration: 13m19s - Times executed: 196 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-03 07:14:19 Duration: 18s619ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-03 16:48:43 Duration: 15s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-03 10:40:30 Duration: 14s642ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11m38s 60 9s649ms 14s927ms 11s643ms create table temp0000284410 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 03 08 28 5m28s 11s725ms 09 15 2m54s 11s666ms 10 17 3m15s 11s489ms [ User: intelifix - Total duration: 11m38s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 11m38s - Times executed: 60 ]
-
CREATE TABLE temp0000284410 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:35:44 Duration: 14s927ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284410 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:40:27 Duration: 14s729ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284410 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:44:20 Duration: 14s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m38s 1,112 151ms 2s834ms 465ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 03 07 143 1m2s 438ms 08 145 1m15s 524ms 09 155 1m17s 498ms 10 131 1m 461ms 11 153 1m5s 429ms 12 2 1s706ms 853ms 13 56 23s821ms 425ms 14 176 1m11s 405ms 15 123 1m2s 511ms 16 18 9s248ms 513ms 17 10 7s37ms 703ms [ User: intelifix - Total duration: 8m38s - Times executed: 1112 ]
[ Application: [unknown] - Total duration: 8m38s - Times executed: 1112 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241493", "modelo" : "287", "itens" : "229992921217,229947739310,229961871621,229949878182,229921598385,230009055866,229961465262,229955031526,229985398192,230012702631,229954472021,229930697388,229936942544,229907056282,229952618507,230003644766,229993085778,229945525962,229906949807,230002807276,229992803147", "usuario" : "414", "caixa" : "2879594", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-03 15:39:35 Duration: 2s834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "261483", "modelo" : "141", "itens" : "229784366575,229752178495,229805722229,229879538994,229814875052,216932295676,229860323450,229728407982,229735240424,229734251831,229746752142,229747336575,229782250814,229781385364,229933367682,229809459911,229755243352,229754357193,229733736067,229687410526,229739636385,229785876666,229740883039,229740756988,229690393353,229815619198,229809549819,229781956284", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246584787996,246560996269,246596305675,246652158702,246642313757,246433442845,246652046973,246546318596,246545316164,246544646065,246558397575,246550822224,246592984453,246588022847,226207345559 ,246612503339,246585120005,246557666483,246547063148,246517051319,246527815859,246601184748,246549835573,246528232444,246516799801,246632425373,246611703553,246587010414,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-03 08:25:18 Duration: 1s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "261547", "modelo" : "141", "itens" : "229689956587,229739110824,216937081834,229742086276,229810590819,229689864053,229782056271,229779496571,216937835577,229671816668,216944472948,229752915975,229738691535,229741486868,229752911834,216932108283,229783999716,229687457981,229784182742,229811533144,229784989699,229809777394,229780523148,229665348709,229667799004,229671619803,229749053455,229667619211", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246524386972,246529662527,246498651824,246527860915,246642703952,246516312425,246588301718,246583686082,246441159399,246494748389,246461379296,246529446164,246558693340,246567705768,246531941717,246433036284,246547174146,246518094260,246586311524,246611737091,246585903347,246613017384,246583724245,246469749508,246498438794,246494205879,246563267074,246498481426,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-03 08:10:18 Duration: 1s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8m9s 203 151ms 10s174ms 2s412ms call rs_giga_triagem (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 03 00 8 25s74ms 3s134ms 01 7 20s120ms 2s874ms 02 7 15s707ms 2s243ms 03 7 17s198ms 2s456ms 04 7 16s682ms 2s383ms 05 7 19s502ms 2s786ms 06 8 17s640ms 2s205ms 07 7 18s89ms 2s584ms 08 7 20s257ms 2s893ms 09 6 20s688ms 3s448ms 10 7 21s510ms 3s72ms 11 9 24s215ms 2s690ms 12 8 19s831ms 2s478ms 13 8 21s310ms 2s663ms 14 8 22s934ms 2s866ms 15 12 31s447ms 2s620ms 16 12 28s953ms 2s412ms 17 11 21s569ms 1s960ms 18 10 22s194ms 2s219ms 19 12 20s55ms 1s671ms 20 11 23s577ms 2s143ms 21 12 19s949ms 1s662ms 22 12 21s177ms 1s764ms [ User: intelifix - Total duration: 8m9s - Times executed: 203 ]
[ Application: psql - Total duration: 8m9s - Times executed: 203 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 00:05:25 Duration: 10s174ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 16:15:11 Duration: 8s667ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 15:25:14 Duration: 8s260ms Database: rio User: intelifix Remote: [local] Application: psql
12 8m7s 1 8m7s 8m7s 8m7s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 03 16 1 8m7s 8m7s [ User: intelifix - Total duration: 8m7s - Times executed: 1 ]
[ Application: psql - Total duration: 8m7s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-03 16:13:09 Duration: 8m7s Database: rio User: intelifix Remote: [local] Application: psql
13 7m21s 147 160ms 1m4s 3s6ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 03 00 6 21s720ms 3s620ms 01 6 9s437ms 1s572ms 02 6 8s369ms 1s394ms 03 5 8s649ms 1s729ms 04 6 10s246ms 1s707ms 05 5 11s546ms 2s309ms 06 1 1s10ms 1s10ms 07 10 38s920ms 3s892ms 08 12 38s966ms 3s247ms 09 12 46s500ms 3s875ms 10 12 39s89ms 3s257ms 11 10 33s536ms 3s353ms 12 6 15s776ms 2s629ms 13 5 5s450ms 1s90ms 14 12 32s339ms 2s694ms 15 11 1m29s 8s94ms 16 10 12s430ms 1s243ms 17 2 1s856ms 928ms 21 4 7s599ms 1s899ms 22 6 9s475ms 1s579ms [ User: intelifix - Total duration: 7m21s - Times executed: 147 ]
[ Application: psql - Total duration: 7m21s - Times executed: 147 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 15:06:05 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 00:05:14 Duration: 12s971ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 09:05:11 Duration: 9s587ms Database: rio User: intelifix Remote: [local] Application: psql
14 5m56s 31 9s338ms 13s742ms 11s498ms create table temp0000284420 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 03 08 3 33s22ms 11s7ms 09 15 2m51s 11s433ms 10 9 1m46s 11s821ms 11 4 45s525ms 11s381ms [ User: intelifix - Total duration: 5m56s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m56s - Times executed: 31 ]
-
CREATE TABLE temp0000284420 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 10:31:43 Duration: 13s742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284420 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 10:32:08 Duration: 13s455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284420 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:34:42 Duration: 12s938ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 4m25s 24 8s614ms 13s359ms 11s71ms create table temp0000284482 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 03 14 2 21s147ms 10s573ms 15 5 58s337ms 11s667ms 16 17 3m6s 10s954ms [ User: intelifix - Total duration: 4m25s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 4m25s - Times executed: 24 ]
-
CREATE TABLE temp0000284482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 16:34:28 Duration: 13s359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 16:37:58 Duration: 12s947ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 15:41:19 Duration: 12s496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 4m22s 22 9s810ms 15s423ms 11s938ms create table temp0000284388 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 03 08 10 2m3s 12s337ms 09 12 2m19s 11s605ms [ User: intelifix - Total duration: 4m22s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m22s - Times executed: 22 ]
-
CREATE TABLE temp0000284388 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:30:24 Duration: 15s423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284388 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:24:13 Duration: 14s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284388 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:29:17 Duration: 13s820ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 3m54s 20 10s 15s469ms 11s711ms create table temp0000284444 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 03 11 12 2m20s 11s733ms 12 7 1m23s 11s887ms 13 1 10s225ms 10s225ms [ User: intelifix - Total duration: 3m54s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m54s - Times executed: 20 ]
-
CREATE TABLE temp0000284444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 12:18:23 Duration: 15s469ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 11:09:06 Duration: 13s140ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 11:25:30 Duration: 12s897ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 3m27s 94 158ms 24s420ms 2s203ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 03 07 4 2s224ms 556ms 08 18 7s519ms 417ms 09 17 53s492ms 3s146ms 10 9 19s651ms 2s183ms 11 14 1m2s 4s487ms 12 5 9s856ms 1s971ms 14 10 17s534ms 1s753ms 15 10 12s36ms 1s203ms 16 7 21s967ms 3s138ms [ User: intelifix - Total duration: 3m27s - Times executed: 94 ]
[ Application: psql - Total duration: 3m27s - Times executed: 94 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026581);
Date: 2026-07-03 11:41:57 Duration: 24s420ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026555);
Date: 2026-07-03 09:34:35 Duration: 21s338ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026561);
Date: 2026-07-03 09:57:29 Duration: 20s215ms Database: rio User: intelifix Remote: [local] Application: psql
19 3m8s 4 5s228ms 1m32s 47s25ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 03 20 2 1m37s 48s986ms 23 2 1m30s 45s64ms [ User: intelifix - Total duration: 3m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m8s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-03 20:08:38 Duration: 1m32s 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-07-03 23:38:41 Duration: 1m24s 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-07-03 20:10:30 Duration: 5s251ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
20 2m53s 165 152ms 8s873ms 1s53ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 03 07 11 7s968ms 724ms 08 35 17s687ms 505ms 09 13 14s759ms 1s135ms 10 13 12s678ms 975ms 11 4 7s239ms 1s809ms 13 23 57s512ms 2s500ms 14 17 24s484ms 1s440ms 15 28 15s111ms 539ms 16 17 13s25ms 766ms 17 4 3s283ms 820ms [ User: intelifix - Total duration: 2m53s - Times executed: 165 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 165 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044094) LIMIT 1;
Date: 2026-07-03 13:26:01 Duration: 8s873ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044100) LIMIT 1;
Date: 2026-07-03 13:04:41 Duration: 8s264ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044094) LIMIT 1;
Date: 2026-07-03 13:59:28 Duration: 7s330ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,349 14m9s 150ms 3s604ms 629ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 03 07 44 28s882ms 656ms 08 203 2m 595ms 09 193 1m55s 596ms 10 188 2m8s 681ms 11 179 1m25s 480ms 12 48 32s758ms 682ms 13 79 41s318ms 523ms 14 147 1m42s 699ms 15 185 2m16s 739ms 16 70 45s285ms 646ms 17 13 11s244ms 864ms [ User: intelifix - Total duration: 14m9s - Times executed: 1349 ]
[ Application: [unknown] - Total duration: 14m9s - Times executed: 1349 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (261777, 450, 'F200011103B20E9,9877E77B97AF$F200011167B41C0,9877E7BD6212$F200011300B25D9,8401127F7A5E$F200011081B0AAC,9877E74B1564$F200011235B45E2,84011229FD85$F200011074B7346,9877E749EC46$F200011011B020E,9877E707EA9A$F200011102B295D,9877E77B5F07$F200011151B5680,9877E7BC9D55$F200010258E0ADF,743AEF9A6A09$F200011131B70AE,9877E7B9C245$F200011053B8390,9877E74CC83D$F200011280B1D90,8401125F44BA$F20001016014463,743AEF5C4FB5$F200012075B9D38,840112DDA2F2$F200012004B6839,84011295D29F$F200011180B17F4,9877E7C06420$F200011301B4B07,8401127FD653$F200010295E25FC,743AEFAF9823$F200011251B6648,8401123776F3$F200010279B5BC3,743AEFABDD36$F200013237B388D,1834AF9ABFB3$F200012015B7204,8401129836C4$F200011350B8E94,8401129462D9AEF5C3973,743AEF5C3973$F200010279B34B3,743AEFABCC1F$F200011112B8ADB,9877E77E0910$F200010339B6493,9877E7015CD2$F200011323B41A6,8401128239C9$F200012031B0A08,840112BFC82A$F200010245B8AEF,743AEF956C00$F200010314B4544,743AEFC6D8E8$F200011063BB8DD,9877E747DB48$F200011217B4418,84011227F5E8$F200013195B048C,1834AF995C26$F200011323B5A02,840112824473$F200011082B42D1,9877E74B79E8$F200011293B08A5,840112607E5C$F200012060B4707,840112C255A7$F200011151B7BC2,9877E7BCADA1', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-03 14:13:18 Duration: 3s604ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260497, 503, 'ZTE3ANNR9300512,D89A0D826C0B,D89A0D826C0C,ZTEGDB1475FF$ZTE3ANNQ4A14986,3CF9F0AB5782,3CF9F0AB5783,ZTEGD6417949$ZTE3ANNRB728696,5872C990D9C1,5872C990D9C2,ZTEGDC619AEB$ZTE3ANNRCP67289,6C11BA6F53E5,6C11BA6F53E6,ZTEGDC70476C$ZTE3ANNT3H01929,D8313996F0CE,D8313996F0CF,ZTEGDD31D828$ZTE3ANNRC536165,6C11BA657975,6C11BA657976,ZTEGDC6EA304$ZTE3ANNR7B15452,3891484A56CF,3891484A56D0,ZTEGDB07CDBC$ZTE3ANNQ9337015,843C9935F8C7,843C9935F8C8,ZTEGD7BC4C8E$ZTE3ANNQ9334397,843C9935BB6B,843C9935BB6C,ZTEGD7BC4254$ZTE3ANNQ9334631,843C9935C0E7,843C9935C0E8,ZTEGD7BC433E$ZTE3ANNQ8M08329,843C991F8B21,843C991F8B22,ZTEGD7BA67F6$ZTE3ANNR1Y17968,14CA56CE4F9B,14CA56CE4F9C,ZTEGD970BC8B$ZTE3ANNRAM63391,5872C98D05F3,5872C98D05F4,ZTEGDC60F79E$ZTE3ANNRB747714,5872C992977D,5872C992977E,ZTEGDC61E535$ZTE3ANNR1Y17986,14CA56CE5007,14CA56CE5008,ZTEGD970BC9D$ZTE3ANNRAD24632,D89A0DB01BB3,D89A0DB01BB4,ZTEGDB175C43$ZTE3ANNR7B16531,3891484A7019,3891484A701A,ZTEGDB07D1F3$ZTE3ANNR9W18526,D89A0DAA0E57,D89A0DAA0E58,ZTEGDB165A09$ZTE3ANNRC553546,6C11BA6710D3,6C11BA6710D4,ZTEGDC6EE6E9$ZTE3ANNR5W68619,48D68234CC0C,48D68234CC0D,ZTEGDB010C0A$ZTE3ANNRC506673,6C11BA62C63D,6C11BA62C63E,ZTEGDC6E2FD0$ZTE3ANNQ9336958,843C9935F771,843C9935F772,ZTEGD7BC4C55$ZTE3ANNR8C28324,389148511EDF,389148511EE0,ZTEGDB08EF14$ZTE3ANNQ4A14740,3CF9F0AB51BE,3CF9F0AB51BF,ZTEGD6417853$ZTE3ANNR3J00285,F4E84F86550E,F4E84F86550F,ZTEGD97B62E7$ZTE3ANNQ4A14872,3CF9F0AB54D6,3CF9F0AB54D7,ZTEGD64178D7$ZTE3ANNR7B15440,3891484A5687,3891484A5688,ZTEGDB07CDB0$ZTE3ANNRAD24813,D89A0DB01FF1,D89A0DB01FF2,ZTEGDB175CF8$ZTE3ANNR8C34886,38914851B8AB,38914851B8AC,ZTEGDB0908B6$ZTE3ANNRB701239,5872C98E563B,5872C98E563C,ZTEGDC612FAA$ZTE3ANNQ9323436,843C9934BA85,843C9934BA86,ZTEGD7BC1783$ZTE3ANNQ8F08577,689E29FCEBE3,689E29FCEBE4,ZTEGD7BA1E51$ZTE3ANNR3J00548,F4E84F865B38,F4E84F865B39,ZTEGD97B63EE$ZTE3ANNQ9334659,843C9935C18F,843C9935C190,ZTEGD7BC435A$ZTE3ANNRAD24722,D89A0DB01DCF,D89A0DB01DD0,ZTEGDB175C9D$ZTE3ANNRAM35392,5872C98A75B9,5872C98A75BA,ZTEGDC608A3F$ZTE3ANNR3Y29470,4896D952736C,4896D952736D,ZTEGD97EA3D3$ZTE3ANNQ4A15245,3CF9F0AB5D94,3CF9F0AB5D95,ZTEGD6417A4C$ZTE3ANNR2Q01492,F4E84F80D6F8,F4E84F80D6F9,ZTEGD97A788E$ZTE3ANNQ8F02898,689E29FC66C9,689E29FC66CA,ZTEGD7BA0822', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-03 09:53:27 Duration: 3s602ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (260497, 304, 'ZTE3ANNT2V13509,D831398CCB76,D831398CCB77,ZTEGDD302744$ZTE3ANNR8C35655,38914851CAB1,38914851CAB2,ZTEGDB090BB7$ZTE3ANNQ8F09917,689E29FD0B4B,689E29FD0B4C,ZTEGD7BA238D$ZTE3ANNRB747763,5872C99298A3,5872C99298A4,ZTEGDC61E566$ZTE3ANNR2Q02835,F4E84F80F672,F4E84F80F673,ZTEGD97A7DCD$ZTE3ANNRCP49595,6C11BA6DB531,6C11BA6DB532,ZTEGDC70024E$ZTE3ANNR3J00257,F4E84F865466,F4E84F865467,ZTEGD97B62CB$ZTE3ANNR1Y48893,14CA56D12469,14CA56D1246A,ZTEGD9713558$ZTE3ANNRCB21062,D831391FBCA2,D831391FBCA3,ZTEGDD2A07DB$ZTE3ANNRCB21183,D831391FBF78,D831391FBF79,ZTEGDD2A0854$ZTE3ANNR3Y51239,4896D95471A2,4896D95471A3,ZTEGD97EF8DC$ZTE3ANNQ7506346,C4EBFF8B87F8,C4EBFF8B87F9,ZTEGD70A676A$ZTE3ANNQ3R02022,3CF9F0A2AF2A,3CF9F0A2AF2B,ZTEGD64007E5$ZTE3ANNQ9341628,843C993664E5,843C993664E6,ZTEGD7BC5E93$ZTE3ANNR7B33378,3891484BFAF3,3891484BFAF4,ZTEGDB0813C2$ZTE3ANNT3H46203,D831399AFE7A,D831399AFE7B,219702062154$ZTE3ANNRCB66174,D8313923DDF2,D8313923DDF3,ZTEGDD2AB813$ZTE3ANNT3F11415,D83139963752,D83139963753,ZTEGDD31B93E$ZTE3ANNR3J02680,F4E84F868D30,F4E84F868D31,ZTEGD97B6C42$ZTE3ANNRC506380,6C11BA62BF5F,6C11BA62BF60,ZTEGDC6E2EAB$ZTE3ANNQ8126448,689E29BE4AAB,689E29BE4AAC,ZTEGD7B7A1E0$ZTE3ANNQ9344571,843C9936A9DF,843C9936A9E0,ZTEGD7BC6A12$ZTE3ANNR9W42679,D89A0DAC446D,D89A0DAC446E,ZTEGDB16B862$ZTE3ANNR9F40479,D89A0DA6929D,D89A0DA6929E,ZTEGDB15C56A$ZTE3ANNQ9341523,843C9936626F,843C99366270,ZTEGD7BC5E2A$ZTE3ANNQ8125633,689E29BE3791,689E29BE3792,ZTEGD7B79EB1$ZTE3ANNR5W03122,48D6822ECCF6,48D6822ECCF7,ZTEGDB000C31$ZTE3ANNR7B32641,3891484BE9AD,3891484BE9AE,ZTEGDB0810E1$ZTE3ANNR7B32398,3891484BE3FB,3891484BE3FC,ZTEGDB080FEE$ZTE3ANNR8C35481,38914851C69D,38914851C69E,ZTEGDB090B09$ZTE3ANNT2V36051,D831398EDBCA,D831398EDBCB,ZTEGDD307F52', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-03 09:14:39 Duration: 3s541ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,112 8m38s 151ms 2s834ms 465ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 03 07 143 1m2s 438ms 08 145 1m15s 524ms 09 155 1m17s 498ms 10 131 1m 461ms 11 153 1m5s 429ms 12 2 1s706ms 853ms 13 56 23s821ms 425ms 14 176 1m11s 405ms 15 123 1m2s 511ms 16 18 9s248ms 513ms 17 10 7s37ms 703ms [ User: intelifix - Total duration: 8m38s - Times executed: 1112 ]
[ Application: [unknown] - Total duration: 8m38s - Times executed: 1112 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "241493", "modelo" : "287", "itens" : "229992921217,229947739310,229961871621,229949878182,229921598385,230009055866,229961465262,229955031526,229985398192,230012702631,229954472021,229930697388,229936942544,229907056282,229952618507,230003644766,229993085778,229945525962,229906949807,230002807276,229992803147", "usuario" : "414", "caixa" : "2879594", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-03 15:39:35 Duration: 2s834ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "261483", "modelo" : "141", "itens" : "229784366575,229752178495,229805722229,229879538994,229814875052,216932295676,229860323450,229728407982,229735240424,229734251831,229746752142,229747336575,229782250814,229781385364,229933367682,229809459911,229755243352,229754357193,229733736067,229687410526,229739636385,229785876666,229740883039,229740756988,229690393353,229815619198,229809549819,229781956284", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246584787996,246560996269,246596305675,246652158702,246642313757,246433442845,246652046973,246546318596,246545316164,246544646065,246558397575,246550822224,246592984453,246588022847,226207345559 ,246612503339,246585120005,246557666483,246547063148,246517051319,246527815859,246601184748,246549835573,246528232444,246516799801,246632425373,246611703553,246587010414,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-03 08:25:18 Duration: 1s764ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "261547", "modelo" : "141", "itens" : "229689956587,229739110824,216937081834,229742086276,229810590819,229689864053,229782056271,229779496571,216937835577,229671816668,216944472948,229752915975,229738691535,229741486868,229752911834,216932108283,229783999716,229687457981,229784182742,229811533144,229784989699,229809777394,229780523148,229665348709,229667799004,229671619803,229749053455,229667619211", "usuario" : "416", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246524386972,246529662527,246498651824,246527860915,246642703952,246516312425,246588301718,246583686082,246441159399,246494748389,246461379296,246529446164,246558693340,246567705768,246531941717,246433036284,246547174146,246518094260,246586311524,246611737091,246585903347,246613017384,246583724245,246469749508,246498438794,246494205879,246563267074,246498481426,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-03 08:10:18 Duration: 1s678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 432 1h42m59s 150ms 5m46s 14s304ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 03 07 17 10m26s 36s880ms 08 58 11m34s 11s969ms 09 40 13m59s 20s977ms 10 44 8m55s 12s174ms 11 43 15m59s 22s324ms 12 16 5m7s 19s205ms 13 32 1m29s 2s794ms 14 63 14m14s 13s559ms 15 62 10m58s 10s616ms 16 45 9m57s 13s269ms 17 12 17s328ms 1s444ms [ User: intelifix - Total duration: 1h42m59s - Times executed: 432 ]
[ Application: [unknown] - Total duration: 1h42m59s - Times executed: 432 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 07:19:07 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026605, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:06:01 Duration: 5m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026611, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:24:58 Duration: 5m Database: rio User: intelifix Remote: [local] Application: [unknown]
4 280 47s168ms 150ms 227ms 168ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 03 01 2 329ms 164ms 04 2 317ms 158ms 07 30 5s46ms 168ms 08 43 7s200ms 167ms 09 37 6s306ms 170ms 10 27 4s574ms 169ms 11 40 6s618ms 165ms 12 7 1s210ms 172ms 13 8 1s328ms 166ms 14 38 6s505ms 171ms 15 37 6s292ms 170ms 16 9 1s439ms 159ms [ User: intelifix - Total duration: 47s168ms - Times executed: 280 ]
[ Application: [unknown] - Total duration: 47s168ms - Times executed: 280 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0318;
Date: 2026-07-03 09:02:34 Duration: 227ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-03 08:07:08 Duration: 220ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-03 07:48:17 Duration: 220ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 203 8m9s 151ms 10s174ms 2s412ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 03 00 8 25s74ms 3s134ms 01 7 20s120ms 2s874ms 02 7 15s707ms 2s243ms 03 7 17s198ms 2s456ms 04 7 16s682ms 2s383ms 05 7 19s502ms 2s786ms 06 8 17s640ms 2s205ms 07 7 18s89ms 2s584ms 08 7 20s257ms 2s893ms 09 6 20s688ms 3s448ms 10 7 21s510ms 3s72ms 11 9 24s215ms 2s690ms 12 8 19s831ms 2s478ms 13 8 21s310ms 2s663ms 14 8 22s934ms 2s866ms 15 12 31s447ms 2s620ms 16 12 28s953ms 2s412ms 17 11 21s569ms 1s960ms 18 10 22s194ms 2s219ms 19 12 20s55ms 1s671ms 20 11 23s577ms 2s143ms 21 12 19s949ms 1s662ms 22 12 21s177ms 1s764ms [ User: intelifix - Total duration: 8m9s - Times executed: 203 ]
[ Application: psql - Total duration: 8m9s - Times executed: 203 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 00:05:25 Duration: 10s174ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 16:15:11 Duration: 8s667ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 15:25:14 Duration: 8s260ms Database: rio User: intelifix Remote: [local] Application: psql
6 196 13m19s 1s451ms 18s619ms 4s78ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 03 07 4 32s690ms 8s172ms 08 5 44s215ms 8s843ms 09 7 31s679ms 4s525ms 10 13 1m2s 4s838ms 11 20 1m23s 4s156ms 12 4 19s918ms 4s979ms 13 13 41s640ms 3s203ms 14 26 1m18s 3s10ms 15 45 3m40s 4s897ms 16 30 1m58s 3s961ms 17 28 1m3s 2s269ms 18 1 2s130ms 2s130ms [ User: intelifix - Total duration: 13m19s - Times executed: 196 ]
[ Application: [unknown] - Total duration: 13m19s - Times executed: 196 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-03 07:14:19 Duration: 18s619ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-03 16:48:43 Duration: 15s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-03 10:40:30 Duration: 14s642ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 165 2m53s 152ms 8s873ms 1s53ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 03 07 11 7s968ms 724ms 08 35 17s687ms 505ms 09 13 14s759ms 1s135ms 10 13 12s678ms 975ms 11 4 7s239ms 1s809ms 13 23 57s512ms 2s500ms 14 17 24s484ms 1s440ms 15 28 15s111ms 539ms 16 17 13s25ms 766ms 17 4 3s283ms 820ms [ User: intelifix - Total duration: 2m53s - Times executed: 165 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 165 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044094) LIMIT 1;
Date: 2026-07-03 13:26:01 Duration: 8s873ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044100) LIMIT 1;
Date: 2026-07-03 13:04:41 Duration: 8s264ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044094) LIMIT 1;
Date: 2026-07-03 13:59:28 Duration: 7s330ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
8 147 7m21s 160ms 1m4s 3s6ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 03 00 6 21s720ms 3s620ms 01 6 9s437ms 1s572ms 02 6 8s369ms 1s394ms 03 5 8s649ms 1s729ms 04 6 10s246ms 1s707ms 05 5 11s546ms 2s309ms 06 1 1s10ms 1s10ms 07 10 38s920ms 3s892ms 08 12 38s966ms 3s247ms 09 12 46s500ms 3s875ms 10 12 39s89ms 3s257ms 11 10 33s536ms 3s353ms 12 6 15s776ms 2s629ms 13 5 5s450ms 1s90ms 14 12 32s339ms 2s694ms 15 11 1m29s 8s94ms 16 10 12s430ms 1s243ms 17 2 1s856ms 928ms 21 4 7s599ms 1s899ms 22 6 9s475ms 1s579ms [ User: intelifix - Total duration: 7m21s - Times executed: 147 ]
[ Application: psql - Total duration: 7m21s - Times executed: 147 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 15:06:05 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 00:05:14 Duration: 12s971ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 09:05:11 Duration: 9s587ms Database: rio User: intelifix Remote: [local] Application: psql
9 140 26s491ms 150ms 412ms 189ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 03 01 6 1s22ms 170ms 04 5 1s273ms 254ms 05 7 1s212ms 173ms 07 20 3s882ms 194ms 08 13 2s399ms 184ms 09 17 3s401ms 200ms 10 14 2s745ms 196ms 11 16 3s247ms 202ms 12 10 1s682ms 168ms 14 16 2s883ms 180ms 15 12 2s63ms 171ms 16 4 677ms 169ms [ User: intelifix - Total duration: 26s491ms - Times executed: 140 ]
[ Application: [unknown] - Total duration: 26s491ms - Times executed: 140 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229854536779,229862169713,229839207292,229861853947,229852192937,229843311936,229851730614,229856668199,229842416786,229840519104,229840494152,229842846278,229853650622,229841664053,229852292139,229848006467,229837378809,229851718591,229843721830,229843589718,229851565872,229861022340,229843522843,229854648989,229842146479,229855571920', NULL, NULL, 0160, 00);
Date: 2026-07-03 04:50:44 Duration: 412ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '229682224048,229757490014,229762872323,229654381017,229681924546,229653663034,229653347391,229680942745,229650999104,216917164345,229652449515,229653766478,229652313845,229682211522,229682259506,229679729910,229757401015,229683944564,229682334059,229683410820,216917587394,229651470924,229654164856', NULL, NULL, 0159, 00);
Date: 2026-07-03 04:55:27 Duration: 345ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (410, 5, '113', 3, '229985296566,229928787886,229948306671,229930913347,229985764850,229937593954,230012939297,229921361315,229946837695,230012766879,229959522727,229959560610,230017925677', NULL, NULL, 0287, 00);
Date: 2026-07-03 11:08:52 Duration: 329ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 127 47s935ms 154ms 612ms 377ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 03 07 3 1s180ms 393ms 08 13 4s941ms 380ms 09 16 6s110ms 381ms 10 14 5s423ms 387ms 11 24 8s998ms 374ms 12 6 2s123ms 353ms 13 1 255ms 255ms 14 17 6s769ms 398ms 15 12 4s802ms 400ms 16 16 5s609ms 350ms 17 5 1s719ms 343ms [ User: intelifix - Total duration: 47s935ms - Times executed: 127 ]
[ Application: [unknown] - Total duration: 47s935ms - Times executed: 127 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-03 14:03:36 Duration: 612ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 073;
Date: 2026-07-03 09:58:05 Duration: 601ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-03 10:29:41 Duration: 591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 114 53s836ms 158ms 3s365ms 472ms create table temp0000284374 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 03 07 13 10s836ms 833ms 08 31 19s922ms 642ms 09 19 12s13ms 632ms 10 10 2s30ms 203ms 11 19 4s77ms 214ms 14 3 586ms 195ms 15 12 2s588ms 215ms 16 7 1s780ms 254ms [ User: intelifix - Total duration: 53s836ms - Times executed: 114 ]
[ Application: [unknown] - Total duration: 53s836ms - Times executed: 114 ]
-
CREATE TABLE temp0000284374 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 07:15:55 Duration: 3s365ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284374 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 09:40:33 Duration: 1s132ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284374 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 09:43:37 Duration: 959ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 114 48s806ms 150ms 7s496ms 428ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 03 01 1 162ms 162ms 05 1 227ms 227ms 07 2 341ms 170ms 08 1 2s37ms 2s37ms 09 4 678ms 169ms 10 12 9s846ms 820ms 11 19 14s65ms 740ms 12 5 918ms 183ms 13 3 540ms 180ms 14 27 5s4ms 185ms 15 29 12s758ms 439ms 16 10 2s225ms 222ms [ User: intelifix - Total duration: 48s806ms - Times executed: 114 ]
[ Application: [unknown] - Total duration: 48s806ms - Times executed: 114 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-03", "data-ate" : "2026-07-03", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-07-03 15:11:10 Duration: 7s496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-03", "data-ate" : "2026-07-03", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-07-03 11:35:09 Duration: 5s940ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-03", "data-ate" : "2026-07-03", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-07-03 11:33:38 Duration: 4s796ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 107 47s219ms 278ms 728ms 441ms 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 #13
Day Hour Count Duration Avg duration Jul 03 01 2 711ms 355ms 03 2 745ms 372ms 04 2 760ms 380ms 05 2 760ms 380ms 06 3 1s240ms 413ms 07 7 3s238ms 462ms 08 12 5s157ms 429ms 09 9 4s10ms 445ms 10 9 4s241ms 471ms 11 10 4s743ms 474ms 12 4 1s548ms 387ms 13 11 5s265ms 478ms 14 8 3s470ms 433ms 15 11 4s930ms 448ms 16 8 3s247ms 405ms 17 4 1s721ms 430ms 21 3 1s424ms 474ms [ User: lenon - Total duration: 47s219ms - Times executed: 107 ]
[ Application: [unknown] - Total duration: 47s219ms - Times executed: 107 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-03 08:35:25 Duration: 728ms Database: contagem 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-07-03 13:05:39 Duration: 728ms Database: contagem 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-07-03 07:06:19 Duration: 721ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
14 98 54s80ms 364ms 839ms 551ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 03 01 2 1s89ms 544ms 03 1 474ms 474ms 04 2 985ms 492ms 05 2 1s37ms 518ms 06 2 1s37ms 518ms 07 5 2s915ms 583ms 08 11 5s833ms 530ms 09 8 4s334ms 541ms 10 9 5s94ms 566ms 11 10 5s814ms 581ms 12 4 2s29ms 507ms 13 11 6s462ms 587ms 14 8 4s348ms 543ms 15 11 5s912ms 537ms 16 6 3s304ms 550ms 17 4 2s209ms 552ms 21 2 1s195ms 597ms [ User: intelifix - Total duration: 54s80ms - Times executed: 98 ]
[ Application: [unknown] - Total duration: 54s80ms - Times executed: 98 ]
-
select * from rs_menu_grants (397, 18, 1);
Date: 2026-07-03 08:50:05 Duration: 839ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-07-03 14:41:57 Duration: 816ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 18, 1);
Date: 2026-07-03 08:35:25 Duration: 808ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
15 94 3m27s 158ms 24s420ms 2s203ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 03 07 4 2s224ms 556ms 08 18 7s519ms 417ms 09 17 53s492ms 3s146ms 10 9 19s651ms 2s183ms 11 14 1m2s 4s487ms 12 5 9s856ms 1s971ms 14 10 17s534ms 1s753ms 15 10 12s36ms 1s203ms 16 7 21s967ms 3s138ms [ User: intelifix - Total duration: 3m27s - Times executed: 94 ]
[ Application: psql - Total duration: 3m27s - Times executed: 94 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026581);
Date: 2026-07-03 11:41:57 Duration: 24s420ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026555);
Date: 2026-07-03 09:34:35 Duration: 21s338ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026561);
Date: 2026-07-03 09:57:29 Duration: 20s215ms Database: rio User: intelifix Remote: [local] Application: psql
16 82 15m41s 9s12ms 14s457ms 11s479ms create table temp0000284382 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 03 07 12 2m8s 10s671ms 08 10 1m51s 11s149ms 09 8 1m44s 13s120ms 10 10 1m50s 11s21ms 11 13 2m28s 11s389ms 12 6 1m3s 10s593ms 14 15 2m56s 11s791ms 15 8 1m38s 12s262ms [ User: intelifix - Total duration: 15m41s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 15m41s - Times executed: 82 ]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:01:21 Duration: 14s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:00:25 Duration: 14s331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 15:18:15 Duration: 14s115ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 72 56s932ms 153ms 13s694ms 790ms create table temp0000284380 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 03 06 1 13s694ms 13s694ms 07 1 519ms 519ms 08 22 14s603ms 663ms 09 4 2s912ms 728ms 10 8 6s283ms 785ms 11 14 11s178ms 798ms 12 8 5s74ms 634ms 14 2 349ms 174ms 15 9 1s833ms 203ms 16 3 482ms 160ms [ User: intelifix - Total duration: 56s932ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 56s932ms - Times executed: 72 ]
-
CREATE TABLE temp0000284380 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 06:56:23 Duration: 13s694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284380 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:12:13 Duration: 1s165ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284380 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:37:50 Duration: 1s87ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 69 53s28ms 161ms 4s523ms 768ms create table temp0000284396 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 03 08 11 10s463ms 951ms 09 22 15s165ms 689ms 10 10 8s180ms 818ms 11 17 13s931ms 819ms 12 4 3s347ms 836ms 13 1 1s6ms 1s6ms 15 4 933ms 233ms [ User: intelifix - Total duration: 53s28ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 53s28ms - Times executed: 69 ]
-
CREATE TABLE temp0000284396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 08:08:08 Duration: 4s523ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:55:33 Duration: 1s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:25:42 Duration: 1s103ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 65 32s478ms 284ms 1s886ms 499ms create table temp0000226531 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 03 13 22 11s676ms 530ms 14 6 3s402ms 567ms 16 11 5s535ms 503ms 17 26 11s864ms 456ms [ User: intelifix - Total duration: 32s478ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 32s478ms - Times executed: 65 ]
-
CREATE TABLE temp0000226531 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-03 13:05:17 Duration: 1s886ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226531 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-03 14:02:14 Duration: 722ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226531 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-03 14:06:58 Duration: 720ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 64 17s603ms 153ms 599ms 275ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 03 07 5 1s449ms 289ms 08 3 1s107ms 369ms 09 6 1s972ms 328ms 10 3 638ms 212ms 11 2 685ms 342ms 14 15 4s256ms 283ms 15 22 5s866ms 266ms 16 8 1s627ms 203ms [ User: intelifix - Total duration: 17s603ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 17s603ms - Times executed: 64 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3210352 ORDER BY A.CAI_ORDEM;
Date: 2026-07-03 08:54:23 Duration: 599ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 3203759 ORDER BY A.CAI_ORDEM;
Date: 2026-07-03 09:12:47 Duration: 537ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2913224 ORDER BY A.CAI_ORDEM;
Date: 2026-07-03 14:56:03 Duration: 530ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 8m7s 8m7s 8m7s 1 8m7s select * from rs_smart_fiscal_entrada () notice: table "tmp_entrada" does not exist, skipping;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 03 16 1 8m7s 8m7s [ User: intelifix - Total duration: 8m7s - Times executed: 1 ]
[ Application: psql - Total duration: 8m7s - Times executed: 1 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA () NOTICE: table "tmp_entrada" does not exist, skipping;
Date: 2026-07-03 16:13:09 Duration: 8m7s Database: rio User: intelifix Remote: [local] Application: psql
2 2m14s 8m18s 4m47s 3 14m23s analyze verbose;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 03 05 3 14m23s 4m47s [ User: intelifix - Total duration: 14m23s - Times executed: 3 ]
[ Application: psql - Total duration: 14m23s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-03 05:08:20 Duration: 8m18s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-03 05:12:10 Duration: 3m50s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-03 05:14:24 Duration: 2m14s Database: contagem User: intelifix Remote: [local] Application: psql
3 1s301ms 9m14s 2m27s 47 1h55m36s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 03 07 3 9m49s 3m16s 08 3 8m6s 2m42s 09 3 9m10s 3m3s 10 3 8m32s 2m50s 11 3 8m36s 2m52s 12 3 8m21s 2m47s 13 3 6m41s 2m13s 14 3 7m58s 2m39s 15 3 8m46s 2m55s 16 2 24s8ms 12s4ms 17 3 7m19s 2m26s 18 3 5m38s 1m52s 19 3 5m57s 1m59s 20 3 7m48s 2m36s 21 3 6m18s 2m6s 22 3 6m7s 2m2s [ User: intelifix - Total duration: 1h55m36s - Times executed: 47 ]
[ Application: psql - Total duration: 1h55m36s - Times executed: 47 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-03 07:14:15 Duration: 9m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-03 09:13:39 Duration: 8m37s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-03 15:13:23 Duration: 8m22s Database: rio User: intelifix Remote: [local] Application: psql
4 249ms 4m45s 1m31s 46 1h10m10s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 03 07 3 5m52s 1m57s 08 3 4m42s 1m34s 09 3 5m5s 1m41s 10 3 4m53s 1m37s 11 2 4m5s 2m2s 12 2 4m39s 2m19s 13 3 3m59s 1m19s 14 3 4m29s 1m29s 15 3 4m31s 1m30s 16 3 4m13s 1m24s 17 3 4m1s 1m20s 18 3 4m4s 1m21s 19 3 3m48s 1m16s 20 3 4m18s 1m26s 21 3 3m35s 1m11s 22 3 3m48s 1m16s [ User: intelifix - Total duration: 1h10m10s - Times executed: 46 ]
[ Application: psql - Total duration: 1h10m10s - Times executed: 46 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-03 07:20:36 Duration: 4m45s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-03 08:17:48 Duration: 4m5s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-03 11:18:27 Duration: 4m4s Database: brasilia User: intelifix Remote: [local] Application: psql
5 1s694ms 1m52s 1m13s 15 18m25s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 03 08 2 1m54s 57s303ms 10 1 2s638ms 2s638ms 11 2 5s743ms 2s871ms 13 5 7m54s 1m34s 14 1 1m52s 1m52s 16 1 1m47s 1m47s 17 3 4m48s 1m36s [ User: intelifix - Total duration: 18m25s - Times executed: 15 ]
[ Application: psql - Total duration: 18m25s - Times executed: 15 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01486);
Date: 2026-07-03 14:06:34 Duration: 1m52s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01480);
Date: 2026-07-03 08:56:12 Duration: 1m48s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 406); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01487);
Date: 2026-07-03 16:53:28 Duration: 1m47s Database: contagem User: intelifix Remote: [local] Application: psql
6 5s228ms 1m32s 47s25ms 4 3m8s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 03 20 2 1m37s 48s986ms 23 2 1m30s 45s64ms [ User: intelifix - Total duration: 3m8s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m8s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-03 20:08:38 Duration: 1m32s 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-07-03 23:38:41 Duration: 1m24s 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-07-03 20:10:30 Duration: 5s251ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 150ms 5m46s 14s304ms 432 1h42m59s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 03 07 17 10m26s 36s880ms 08 58 11m34s 11s969ms 09 40 13m59s 20s977ms 10 44 8m55s 12s174ms 11 43 15m59s 22s324ms 12 16 5m7s 19s205ms 13 32 1m29s 2s794ms 14 63 14m14s 13s559ms 15 62 10m58s 10s616ms 16 45 9m57s 13s269ms 17 12 17s328ms 1s444ms [ User: intelifix - Total duration: 1h42m59s - Times executed: 432 ]
[ Application: [unknown] - Total duration: 1h42m59s - Times executed: 432 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026523, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 07:19:07 Duration: 5m46s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026605, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:06:01 Duration: 5m4s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 026611, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-03 15:24:58 Duration: 5m Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s810ms 15s423ms 11s938ms 22 4m22s create table temp0000284388 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 03 08 10 2m3s 12s337ms 09 12 2m19s 11s605ms [ User: intelifix - Total duration: 4m22s - Times executed: 22 ]
[ Application: [unknown] - Total duration: 4m22s - Times executed: 22 ]
-
CREATE TABLE temp0000284388 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:30:24 Duration: 15s423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284388 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:24:13 Duration: 14s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284388 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:29:17 Duration: 13s820ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10s 15s469ms 11s711ms 20 3m54s create table temp0000284444 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 03 11 12 2m20s 11s733ms 12 7 1m23s 11s887ms 13 1 10s225ms 10s225ms [ User: intelifix - Total duration: 3m54s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m54s - Times executed: 20 ]
-
CREATE TABLE temp0000284444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 12:18:23 Duration: 15s469ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 11:09:06 Duration: 13s140ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284444 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 11:25:30 Duration: 12s897ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s649ms 14s927ms 11s643ms 60 11m38s create table temp0000284410 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 03 08 28 5m28s 11s725ms 09 15 2m54s 11s666ms 10 17 3m15s 11s489ms [ User: intelifix - Total duration: 11m38s - Times executed: 60 ]
[ Application: [unknown] - Total duration: 11m38s - Times executed: 60 ]
-
CREATE TABLE temp0000284410 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:35:44 Duration: 14s927ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284410 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:40:27 Duration: 14s729ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284410 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 08:44:20 Duration: 14s620ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 9s338ms 13s742ms 11s498ms 31 5m56s create table temp0000284420 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 03 08 3 33s22ms 11s7ms 09 15 2m51s 11s433ms 10 9 1m46s 11s821ms 11 4 45s525ms 11s381ms [ User: intelifix - Total duration: 5m56s - Times executed: 31 ]
[ Application: [unknown] - Total duration: 5m56s - Times executed: 31 ]
-
CREATE TABLE temp0000284420 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 10:31:43 Duration: 13s742ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284420 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 10:32:08 Duration: 13s455ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284420 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:34:42 Duration: 12s938ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 9s12ms 14s457ms 11s479ms 82 15m41s create table temp0000284382 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 03 07 12 2m8s 10s671ms 08 10 1m51s 11s149ms 09 8 1m44s 13s120ms 10 10 1m50s 11s21ms 11 13 2m28s 11s389ms 12 6 1m3s 10s593ms 14 15 2m56s 11s791ms 15 8 1m38s 12s262ms [ User: intelifix - Total duration: 15m41s - Times executed: 82 ]
[ Application: [unknown] - Total duration: 15m41s - Times executed: 82 ]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:01:21 Duration: 14s457ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 09:00:25 Duration: 14s331ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284382 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 15:18:15 Duration: 14s115ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 8s614ms 13s359ms 11s71ms 24 4m25s create table temp0000284482 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 03 14 2 21s147ms 10s573ms 15 5 58s337ms 11s667ms 16 17 3m6s 10s954ms [ User: intelifix - Total duration: 4m25s - Times executed: 24 ]
[ Application: [unknown] - Total duration: 4m25s - Times executed: 24 ]
-
CREATE TABLE temp0000284482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 16:34:28 Duration: 13s359ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 16:37:58 Duration: 12s947ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284482 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-03 15:41:19 Duration: 12s496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 1s451ms 18s619ms 4s78ms 196 13m19s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 03 07 4 32s690ms 8s172ms 08 5 44s215ms 8s843ms 09 7 31s679ms 4s525ms 10 13 1m2s 4s838ms 11 20 1m23s 4s156ms 12 4 19s918ms 4s979ms 13 13 41s640ms 3s203ms 14 26 1m18s 3s10ms 15 45 3m40s 4s897ms 16 30 1m58s 3s961ms 17 28 1m3s 2s269ms 18 1 2s130ms 2s130ms [ User: intelifix - Total duration: 13m19s - Times executed: 196 ]
[ Application: [unknown] - Total duration: 13m19s - Times executed: 196 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-02', 0302, '', '', 0, 6, '2026-07-02');
Date: 2026-07-03 07:14:19 Duration: 18s619ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-03 16:48:43 Duration: 15s422ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-03', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-03 10:40:30 Duration: 14s642ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 160ms 1m4s 3s6ms 147 7m21s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 03 00 6 21s720ms 3s620ms 01 6 9s437ms 1s572ms 02 6 8s369ms 1s394ms 03 5 8s649ms 1s729ms 04 6 10s246ms 1s707ms 05 5 11s546ms 2s309ms 06 1 1s10ms 1s10ms 07 10 38s920ms 3s892ms 08 12 38s966ms 3s247ms 09 12 46s500ms 3s875ms 10 12 39s89ms 3s257ms 11 10 33s536ms 3s353ms 12 6 15s776ms 2s629ms 13 5 5s450ms 1s90ms 14 12 32s339ms 2s694ms 15 11 1m29s 8s94ms 16 10 12s430ms 1s243ms 17 2 1s856ms 928ms 21 4 7s599ms 1s899ms 22 6 9s475ms 1s579ms [ User: intelifix - Total duration: 7m21s - Times executed: 147 ]
[ Application: psql - Total duration: 7m21s - Times executed: 147 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 15:06:05 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 00:05:14 Duration: 12s971ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-03 09:05:11 Duration: 9s587ms Database: rio User: intelifix Remote: [local] Application: psql
16 151ms 10s174ms 2s412ms 203 8m9s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 03 00 8 25s74ms 3s134ms 01 7 20s120ms 2s874ms 02 7 15s707ms 2s243ms 03 7 17s198ms 2s456ms 04 7 16s682ms 2s383ms 05 7 19s502ms 2s786ms 06 8 17s640ms 2s205ms 07 7 18s89ms 2s584ms 08 7 20s257ms 2s893ms 09 6 20s688ms 3s448ms 10 7 21s510ms 3s72ms 11 9 24s215ms 2s690ms 12 8 19s831ms 2s478ms 13 8 21s310ms 2s663ms 14 8 22s934ms 2s866ms 15 12 31s447ms 2s620ms 16 12 28s953ms 2s412ms 17 11 21s569ms 1s960ms 18 10 22s194ms 2s219ms 19 12 20s55ms 1s671ms 20 11 23s577ms 2s143ms 21 12 19s949ms 1s662ms 22 12 21s177ms 1s764ms [ User: intelifix - Total duration: 8m9s - Times executed: 203 ]
[ Application: psql - Total duration: 8m9s - Times executed: 203 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 00:05:25 Duration: 10s174ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 16:15:11 Duration: 8s667ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-03 15:25:14 Duration: 8s260ms Database: rio User: intelifix Remote: [local] Application: psql
17 158ms 24s420ms 2s203ms 94 3m27s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 03 07 4 2s224ms 556ms 08 18 7s519ms 417ms 09 17 53s492ms 3s146ms 10 9 19s651ms 2s183ms 11 14 1m2s 4s487ms 12 5 9s856ms 1s971ms 14 10 17s534ms 1s753ms 15 10 12s36ms 1s203ms 16 7 21s967ms 3s138ms [ User: intelifix - Total duration: 3m27s - Times executed: 94 ]
[ Application: psql - Total duration: 3m27s - Times executed: 94 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026581);
Date: 2026-07-03 11:41:57 Duration: 24s420ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026555);
Date: 2026-07-03 09:34:35 Duration: 21s338ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 434); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (026561);
Date: 2026-07-03 09:57:29 Duration: 20s215ms Database: rio User: intelifix Remote: [local] Application: psql
18 152ms 8s873ms 1s53ms 165 2m53s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 03 07 11 7s968ms 724ms 08 35 17s687ms 505ms 09 13 14s759ms 1s135ms 10 13 12s678ms 975ms 11 4 7s239ms 1s809ms 13 23 57s512ms 2s500ms 14 17 24s484ms 1s440ms 15 28 15s111ms 539ms 16 17 13s25ms 766ms 17 4 3s283ms 820ms [ User: intelifix - Total duration: 2m53s - Times executed: 165 ]
[ Application: [unknown] - Total duration: 2m53s - Times executed: 165 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044094) LIMIT 1;
Date: 2026-07-03 13:26:01 Duration: 8s873ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044100) LIMIT 1;
Date: 2026-07-03 13:04:41 Duration: 8s264ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (044094) LIMIT 1;
Date: 2026-07-03 13:59:28 Duration: 7s330ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 153ms 13s694ms 790ms 72 56s932ms create table temp0000284380 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 03 06 1 13s694ms 13s694ms 07 1 519ms 519ms 08 22 14s603ms 663ms 09 4 2s912ms 728ms 10 8 6s283ms 785ms 11 14 11s178ms 798ms 12 8 5s74ms 634ms 14 2 349ms 174ms 15 9 1s833ms 203ms 16 3 482ms 160ms [ User: intelifix - Total duration: 56s932ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 56s932ms - Times executed: 72 ]
-
CREATE TABLE temp0000284380 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 06:56:23 Duration: 13s694ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284380 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:12:13 Duration: 1s165ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284380 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:37:50 Duration: 1s87ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 161ms 4s523ms 768ms 69 53s28ms create table temp0000284396 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 03 08 11 10s463ms 951ms 09 22 15s165ms 689ms 10 10 8s180ms 818ms 11 17 13s931ms 819ms 12 4 3s347ms 836ms 13 1 1s6ms 1s6ms 15 4 933ms 233ms [ User: intelifix - Total duration: 53s28ms - Times executed: 69 ]
[ Application: [unknown] - Total duration: 53s28ms - Times executed: 69 ]
-
CREATE TABLE temp0000284396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 08:08:08 Duration: 4s523ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:55:33 Duration: 1s233ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000284396 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-06-2026", "ate" :"03-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-03 11:25:42 Duration: 1s103ms Database: rio User: intelifix Remote: [local] Application: [unknown]
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 4 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 03 13 1 0ms 0ms 14 1 0ms 0ms 15 1 0ms 0ms 18 1 0ms 0ms [ User: intelifix - Total duration: 3s471ms - Times executed: 4 ]
[ Application: [unknown] - Total duration: 1s747ms - Times executed: 3 ]
[ Application: psql - Total duration: 1s723ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: contagem Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,420 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 22 FATAL entries
- 4351 ERROR entries
- 0 WARNING entries
- 9 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,207 Max number of times the same event was reported
- 4,382 Total events found
Rank Times reported Error 1 4,207 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 03 00 59 01 60 02 60 03 55 04 60 05 59 06 60 07 233 08 427 09 459 10 342 11 314 12 164 13 154 14 308 15 349 16 188 17 155 18 117 19 117 20 118 21 117 22 117 23 115 - ERROR: prepared statement "_PLAN0000000029D2D140" does not exist
- ERROR: prepared statement "_PLAN0000000029929AF0" does not exist
- ERROR: prepared statement "_PLAN0000000029F75A00" does not exist
Statement: DEALLOCATE "_PLAN0000000029D2D140"
Date: 2026-07-03 00:00:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029929AF0"
Date: 2026-07-03 00:01:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029F75A00"
Date: 2026-07-03 00:02:33 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 03 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-03 00:05:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-03 00:35:02 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-03 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 03 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-03 08:00:16 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-03 08:20:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-03 08:40:05 Database: brasilia Application: psql User: intelifix Remote: [local]
4 33 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 03 08 19 09 12 14 2 - ERROR: trailing junk after numeric literal at or near "983910713C80" at character 27
- ERROR: trailing junk after numeric literal at or near "983910713C80" at character 27
- ERROR: trailing junk after numeric literal at or near "983910713C80" at character 27
Statement: SELECT * FROM RS_ETIQUETA(983910713C80)
Date: 2026-07-03 08:13:38 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(983910713C80)
Date: 2026-07-03 08:13:38 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(983910713C80)
Date: 2026-07-03 08:13:38 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 10 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 03 00 2 03 6 05 1 06 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-03 00:02:05 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-03 00:09:30 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-03 03:02:31 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
6 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 03 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-07-03 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Context: PL/pgSQL assignment "cDirPara := cDirPara || cMes || '/'" PL/pgSQL function rs_giga_processa_arquivos() line 41 at assignment
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-03 03:05:01 Database: rio Application: psql User: intelifix Remote: [local]
Date: 2026-07-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
7 8 ERROR: function rs_etiqueta(...) does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 03 07 6 09 2 - ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
- ERROR: function rs_etiqueta(numeric) does not exist at character 15
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73107085850092102628)Date: 2026-07-03 07:29:43 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73107085850092102628)Date: 2026-07-03 07:29:44 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT * FROM RS_ETIQUETA(73027685850085203345)Date: 2026-07-03 07:44:04 Database: rio Application: [unknown] User: etiquetas Remote: [local]
8 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 03 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-03 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-03 05:32:03 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-03 05:32:03 Database: contagem Application: psql User: intelifix Remote: [local]
9 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 03 13 2 15 2 - LOG: process 3659181 still waiting for ShareLock on transaction 2092719 after 1000.063 ms
- LOG: process 3659181 still waiting for ShareLock on transaction 2092719 after 9990.662 ms
- LOG: process 3736425 still waiting for ShareLock on transaction 2099128 after 1000.148 ms
Detail: Process holding the lock: 3645871. Wait queue: 3659181.
Context: while deleting tuple (27,55) in relation "nf_entrada_arquivos" SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(01485)Date: 2026-07-03 13:46:57 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3645871. Wait queue: 3659181.
Context: while deleting tuple (27,55) in relation "nf_entrada_arquivos" SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(01485)Date: 2026-07-03 13:47:06 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3681391. Wait queue: 3736425.
Context: while updating tuple (72577,35) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying,integer) line 128 at assignment SQL statement "CALL RS_GIGA_TRIAGEM( cNome, nAux )" PL/pgSQL function rs_giga_processa_arquivos() line 63 at CALL
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-07-03 15:05:05 Database: rio Application: psql User: intelifix Remote: [local]
10 3 ERROR: update or delete on table "..." violates foreign key constraint "..." on table "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 03 13 1 16 2 - ERROR: update or delete on table "nf_entrada_arquivos" violates foreign key constraint "nf_entrada_arquivo_erros_nea_id_fkey" on table "nf_entrada_arquivo_erros"
- ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
- ERROR: update or delete on table "lote_itens" violates foreign key constraint "nf_entrada_itens_li_id_fkey" on table "nf_entrada_itens"
Detail: Key (nea_id)=(1485) is still referenced from table "nf_entrada_arquivo_erros".
Context: SQL statement "DELETE FROM NF_ENTRADA_ARQUIVOS WHERE NEA_ID = nNEA" PL/pgSQL function rs_nf_entrada_exclui(integer) line 57 at SQL statement
Statement: SELECT * FROM RS_NF_ENTRADA_EXCLUI(01485)Date: 2026-07-03 13:48:00 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Key (li_id)=(5793634) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0262294);Date: 2026-07-03 16:39:55 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Key (li_id)=(5793634) is still referenced from table "nf_entrada_itens".
Context: SQL statement "DELETE FROM LOTE_ITENS WHERE EQ_ID = REC.EQ_ID" PL/pgSQL function rs_lote_exclui(integer) line 82 at SQL statement
Statement: SELECT * FROM RS_LOTE_EXCLUI(0262294);Date: 2026-07-03 16:40:07 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 03 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-07-03 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-03 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-03 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
12 2 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 03 14 2 - ERROR: syntax error at or near "]" at character 35
- ERROR: syntax error at or near "]" at character 35
Statement: select * from rs_caixa_qr(3214273 ])
Date: 2026-07-03 14:24:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(3214273 ])
Date: 2026-07-03 14:24:32 Database: rio Application: [unknown] User: etiquetas Remote: [local]
13 2 LOG: process ... still waiting for ExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 03 14 2 - LOG: process 3681391 still waiting for ExclusiveLock on relation 364924 of database 358220 after 1000.139 ms
- LOG: process 3681391 still waiting for ExclusiveLock on relation 364924 of database 358220 after 3602.849 ms
Detail: Process holding the lock: 3711051. Wait queue: 3681391.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"0015", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-07-03 14:49:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3711051. Wait queue: 3681391.
Context: SQL statement "REFRESH MATERIALIZED VIEW CONCURRENTLY RS_V_LOTES_REDE" PL/pgSQL function rs_atualiza_views() line 17 at SQL statement SQL statement "CALL RS_ATUALIZA_VIEWS()" PL/pgSQL function rs_lote_manutencao(text) line 361 at CALL
Statement: SELECT * FROM RS_LOTE_MANUTENCAO('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"318", "usuario" :"507", "tipo" :"N", "itens" :"0015", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}')Date: 2026-07-03 14:49:15 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 2 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 03 10 1 14 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000284410"
Date: 2026-07-03 10:24:33
Context: automatic vacuum of table "rio.public.temp0000284476"
Date: 2026-07-03 14:35:47
15 2 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 03 10 1 14 1 - LOG: process 3482626 still waiting for AccessExclusiveLock on relation 1947619 of database 358220 after 1000.164 ms
- LOG: process 3673509 still waiting for AccessExclusiveLock on relation 1978349 of database 358220 after 1000.224 ms
Detail: Process holding the lock: 3524329. Wait queue: 3482626.
Statement: DROP TABLE IF EXISTS temp0000284410;Date: 2026-07-03 10:24:33 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3710782. Wait queue: 3673509.
Statement: DROP TABLE IF EXISTS temp0000284476;Date: 2026-07-03 14:35:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 03 03 1 - LOG: database system was shut down at 2026-07-03 03:05:01 -03
Date: 2026-07-03 03:05:03
17 1 ERROR: function rs_lote_modelos_selecao(...) does not exist
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 03 09 1 - ERROR: function rs_lote_modelos_selecao(integer, integer) does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT RS_LOTE_MODELOS_SELECAO( 126733, 0 )Date: 2026-07-03 09:58:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local]