pgBadger-
Global information
- Generated on Thu Jul 16 23:50:09 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 49,574 log entries in 7s
- Log start from 2026-07-16 00:00:15 to 2026-07-16 23:50:00
-
Overview
Global Stats
- 387 Number of unique normalized queries
- 7,535 Number of queries
- 8h38m5s Total query duration
- 2026-07-16 00:02:10 First query
- 2026-07-16 23:49:49 Last query
- 6 queries/s at 2026-07-16 16:54:18 Query peak
- 8h38m5s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h38m5s Execute total duration
- 4,416 Number of events
- 18 Number of unique normalized events
- 4,257 Max number of times the same event was reported
- 0 Number of cancellation
- 550 Total number of automatic vacuums
- 1,213 Total number of automatic analyzes
- 16 Number temporary file
- 235.59 MiB Max size of temporary file
- 126.98 MiB Average size of temporary file
- 393 Total number of sessions
- 9 sessions at 2026-07-16 07:35:35 Session peak
- 14d4h46m30s Total duration of sessions
- 52m1s Average duration of sessions
- 19 Average queries per session
- 1m19s Average queries duration per session
- 50m42s Average idle time per session
- 406 Total number of connections
- 7 connections/s at 2026-07-16 03:05:16 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-16 16:54:18 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-16 14:51:31 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-16 23:49:35 Date
Queries duration
Key values
- 8h38m5s 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 16 00 24 0ms 17s331ms 4s775ms 4s890ms 7s359ms 1m13s 01 28 0ms 4s290ms 1s316ms 4s876ms 5s802ms 6s593ms 02 18 0ms 4s626ms 1s958ms 4s664ms 5s753ms 7s146ms 03 21 0ms 10s393ms 2s183ms 5s181ms 6s879ms 11s924ms 04 20 0ms 4s530ms 1s804ms 4s608ms 6s257ms 7s781ms 05 43 0ms 7m36s 23s1ms 6s233ms 2m7s 7m38s 06 23 0ms 8s569ms 3s172ms 5s468ms 7s266ms 28s406ms 07 174 0ms 7m52s 9s909ms 58s928ms 4m25s 7m58s 08 632 0ms 7m16s 2s977ms 49s754ms 4m10s 7m55s 09 686 150ms 8m47s 3s715ms 58s143ms 5m16s 8m53s 10 820 150ms 9m35s 2s378ms 46s426ms 4m57s 9m44s 11 833 150ms 8m13s 3s236ms 1m49s 6m23s 8m59s 12 194 0ms 7m32s 9s137ms 26s92ms 5m3s 7m43s 13 447 0ms 6m16s 2s733ms 28s512ms 2m5s 7m 14 1,076 150ms 8m33s 2s183ms 55s339ms 1m57s 8m53s 15 822 150ms 8m47s 3s819ms 1m44s 6m7s 8m55s 16 708 150ms 8m42s 3s518ms 1m18s 4m18s 8m47s 17 413 0ms 8m49s 4s321ms 1m13s 1m53s 9m11s 18 23 0ms 6m18s 28s922ms 4s859ms 18s734ms 6m50s 19 21 0ms 5m49s 30s353ms 4s716ms 49s528ms 5m49s 20 109 0ms 6m26s 11s137ms 1m13s 1m22s 6m26s 21 32 0ms 5m48s 19s778ms 5s815ms 45s785ms 5m48s 22 26 0ms 5m55s 25s632ms 5s692ms 48s785ms 5m55s 23 342 0ms 1m48s 6s954ms 1m8s 1m26s 1m48s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 00 3 0 4s57ms 0ms 0ms 0ms 01 10 0 315ms 0ms 157ms 834ms 02 0 0 0ms 0ms 0ms 0ms 03 3 0 429ms 0ms 0ms 0ms 04 2 0 491ms 0ms 0ms 0ms 05 23 0 295ms 195ms 450ms 1s9ms 06 5 0 2s848ms 0ms 0ms 901ms 07 121 0 11s866ms 3s993ms 30s384ms 5m5s 08 464 0 3s33ms 11s114ms 26s389ms 5m1s 09 540 0 3s721ms 12s705ms 57s991ms 5m59s 10 624 0 2s702ms 11s243ms 32s809ms 5m45s 11 566 0 3s845ms 16s472ms 37s62ms 6m13s 12 125 0 11s403ms 4s206ms 14s91ms 5m3s 13 348 0 3s27ms 7s555ms 20s250ms 3m53s 14 885 0 1s891ms 19s623ms 35s714ms 4m52s 15 661 0 3s940ms 28s579ms 1m17s 6m17s 16 507 0 3s893ms 25s510ms 1m18s 6m4s 17 286 0 4s683ms 13s29ms 35s730ms 3m58s 18 9 0 1m10s 0ms 0ms 3m20s 19 6 0 1m40s 0ms 0ms 3m26s 20 8 84 12s708ms 19s633ms 1m4s 3m18s 21 14 0 42s530ms 0ms 859ms 3m18s 22 6 0 1m44s 0ms 0ms 3m43s 23 13 329 6s954ms 1m6s 1m8s 1m39s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 16 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 16 00 0 0 0.00 0.00% 01 0 2 2.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 7 7.00 0.00% 08 0 14 14.00 0.00% 09 0 12 12.00 0.00% 10 0 15 15.00 0.00% 11 0 15 15.00 0.00% 12 0 7 7.00 0.00% 13 0 14 14.00 0.00% 14 0 21 21.00 0.00% 15 0 16 16.00 0.00% 16 0 14 14.00 0.00% 17 0 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 3 3.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jul 16 00 17 0.00/s 01 12 0.00/s 02 9 0.00/s 03 20 0.01/s 04 10 0.00/s 05 8 0.00/s 06 15 0.00/s 07 18 0.01/s 08 24 0.01/s 09 31 0.01/s 10 20 0.01/s 11 21 0.01/s 12 15 0.00/s 13 21 0.01/s 14 27 0.01/s 15 26 0.01/s 16 26 0.01/s 17 18 0.01/s 18 11 0.00/s 19 11 0.00/s 20 14 0.00/s 21 11 0.00/s 22 10 0.00/s 23 11 0.00/s Day Hour Count Average Duration Average idle time Jul 16 00 6 1h 59m41s 01 16 1h53s 1h51s 02 12 1h30s 1h27s 03 19 19m4s 19m2s 04 10 1h2m42s 1h2m38s 05 10 1h36s 58m57s 06 8 56m53s 56m44s 07 14 58m 55m57s 08 21 52m33s 51m3s 09 27 47m42s 46m7s 10 23 54m43s 53m19s 11 21 50m52s 48m43s 12 20 55m9s 53m40s 13 15 55m58s 54m37s 14 25 48m45s 47m11s 15 27 46m44s 44m48s 16 25 50m50s 49m10s 17 23 54m38s 53m21s 18 17 57m26s 56m47s 19 10 58m 56m56s 20 13 47m20s 45m46s 21 10 55m13s 54m10s 22 10 1h53s 59m47s 23 11 47m15s 43m39s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-16 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 406 connections Total
Connections per user
Key values
- intelifix Main User
- 406 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-07-16 07:35:35 Date
Histogram of session times
Key values
- 310 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 393 sessions Total
Sessions per user
Key values
- intelifix Main User
- 393 sessions Total
Sessions per host
Key values
- [local] Main Host
- 393 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 393 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 18,204 buffers Checkpoint Peak
- 2026-07-16 00:10:38 Date
- 270.020 seconds Highest write time
- 0.142 seconds Sync time
Checkpoints Wal files
Key values
- 12 files Wal files usage Peak
- 2026-07-16 15:04:38 Date
Checkpoints distance
Key values
- 374.33 Mo Distance Peak
- 2026-07-16 15:04:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 16 00 19,720 422.025s 0.022s 422.098s 01 3,126 314.239s 0.04s 314.331s 02 1,677 168.583s 0.027s 168.645s 03 1,656 166.462s 0.05s 166.563s 04 2,441 245.208s 0.027s 245.288s 05 9,113 846.942s 0.089s 847.102s 06 7,334 521.052s 0.014s 521.097s 07 28,205 2,065.117s 0.226s 2,065.495s 08 59,597 3,039.35s 0.707s 3,040.293s 09 62,762 3,238.881s 0.705s 3,239.817s 10 73,106 3,238.446s 0.862s 3,239.604s 11 66,649 3,238.529s 0.826s 3,239.631s 12 35,801 2,273.364s 0.266s 2,273.765s 13 26,559 2,230.225s 0.471s 2,230.847s 14 84,417 3,238.588s 0.947s 3,239.851s 15 86,797 3,238.64s 0.737s 3,239.641s 16 67,239 3,238.546s 0.8s 3,239.628s 17 45,525 2,540.654s 0.44s 2,541.288s 18 3,636 364.142s 0.018s 364.195s 19 29 2.958s 0.004s 2.978s 20 750 247.643s 0.02s 247.69s 21 2,127 213.765s 0.063s 213.889s 22 1,444 145.167s 0.047s 145.257s 23 345 67.617s 0.015s 67.65s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 16 00 0 7 0 485 0.003s 0.005s 01 0 1 0 605 0.002s 0.008s 02 0 0 0 457 0.003s 0.006s 03 0 1 0 344 0.003s 0.006s 04 0 1 0 582 0.003s 0.007s 05 0 4 0 771 0.007s 0.009s 06 0 1 0 230 0.001s 0.004s 07 0 6 14 2,781 0.007s 0.012s 08 0 0 37 6,600 0.009s 0.012s 09 0 0 38 7,354 0.011s 0.012s 10 0 0 36 8,140 0.022s 0.012s 11 0 0 42 7,995 0.013s 0.012s 12 0 0 21 3,784 0.009s 0.012s 13 0 0 11 4,881 0.007s 0.012s 14 0 0 60 9,076 0.006s 0.012s 15 0 0 58 7,635 0.012s 0.012s 16 0 0 45 7,444 0.005s 0.012s 17 0 0 39 5,167 0.008s 0.012s 18 0 0 1 333 0.006s 0.005s 19 0 0 0 8 0.002s 0.002s 20 0 0 1 90 0.002s 0.003s 21 0 0 1 341 0.026s 0.007s 22 0 0 0 405 0.007s 0.007s 23 0 0 2 29 0.004s 0.003s Day Hour Count Avg time (sec) Jul 16 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 16 00 21,204.80 kB 81,163.40 kB 01 1,964.00 kB 42,608.88 kB 02 1,413.67 kB 20,935.67 kB 03 1,303.86 kB 4,123.00 kB 04 1,817.43 kB 2,669.43 kB 05 7,618.89 kB 17,157.78 kB 06 5,368.50 kB 12,230.00 kB 07 27,614.08 kB 60,958.25 kB 08 50,375.08 kB 108,776.33 kB 09 51,383.67 kB 92,797.75 kB 10 49,039.83 kB 118,894.17 kB 11 57,186.92 kB 92,542.75 kB 12 28,528.00 kB 72,780.25 kB 13 15,544.75 kB 39,494.25 kB 14 81,592.92 kB 112,073.25 kB 15 79,143.50 kB 149,798.75 kB 16 61,041.67 kB 119,459.92 kB 17 54,541.75 kB 128,986.83 kB 18 2,516.00 kB 67,770.40 kB 19 97.00 kB 46,638.50 kB 20 5,893.00 kB 37,354.67 kB 21 1,553.29 kB 23,018.57 kB 22 1,060.57 kB 11,704.29 kB 23 9,505.33 kB 18,035.33 kB -
Temporary Files
Size of temporary files
Key values
- 471.19 MiB Temp Files size Peak
- 2026-07-16 05:32:00 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-16 05:32:00 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 16 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.07 GiB 109.54 MiB 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 3 468.05 MiB 156.02 MiB 12 0 0 0 13 1 156.09 MiB 156.09 MiB 14 0 0 0 15 0 0 0 16 2 312.07 MiB 156.04 MiB 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 915.13 MiB 70.27 MiB 235.59 MiB 114.39 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-16 05:32:09 Duration: 1m28s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-16 05:32:00 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 6 936.21 MiB 156.01 MiB 156.09 MiB 156.03 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01559);
Date: 2026-07-16 13:26:19 Duration: 1m58s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01560);
Date: 2026-07-16 16:31:26 Duration: 1m49s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01558);
Date: 2026-07-16 11:39:24 Duration: 1m45s Database: contagem User: intelifix Remote: [local] Application: psql
3 2 180.30 MiB 90.15 MiB 90.15 MiB 90.15 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-16 05:30:41 Duration: 39s813ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-16 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 235.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 235.59 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:00 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 156.09 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01559);[ Date: 2026-07-16 13:25:58 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 156.05 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01561);[ Date: 2026-07-16 16:50:51 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 156.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01556);[ Date: 2026-07-16 11:18:37 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 156.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01560);[ Date: 2026-07-16 16:31:19 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01558);[ Date: 2026-07-16 11:39:19 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
8 156.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01557);[ Date: 2026-07-16 11:21:28 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
9 90.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-16 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 90.15 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-16 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 77.74 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 77.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 77.66 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 70.34 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 70.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 70.27 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-16 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 22.79 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-16 14:21:32 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 22.79 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database rio - 2026-07-16 14:21:32 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (135) Main table analyzed (database rio)
- 1,213 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 135 contagem.pg_catalog.pg_attribute 84 rio.pg_catalog.pg_class 72 contagem.pg_catalog.pg_class 71 rio.pg_catalog.pg_type 61 contagem.pg_catalog.pg_type 57 rio.public.temp0000285528 51 rio.public.usuarios 50 brasilia.pg_catalog.pg_attribute 45 rio.pg_catalog.pg_index 43 contagem.pg_catalog.pg_index 35 rio.pg_catalog.pg_depend 32 contagem.pg_catalog.pg_depend 27 rio.public.temp0000285576 26 rio.public.temp0000285020 24 rio.public.temp0000285516 21 rio.public.temp0000285540 21 brasilia.public.temp0000236290 20 rio.public.temp0000285584 19 brasilia.pg_catalog.pg_class 19 rio.public.temp0000285518 16 brasilia.pg_catalog.pg_type 16 contagem.public.usuarios 15 rio.public.temp0000285522 14 rio.public.temp0000285498 13 brasilia.pg_catalog.pg_index 11 rio.public.temp0000284984 10 rio.public.temp0000285632 10 rio.public.temp0000285404 9 brasilia.public.usuarios 9 rio.public.temp0000284750 9 brasilia.public.temp0000236264 9 brasilia.pg_catalog.pg_depend 8 brasilia.public.temp0000236292 7 rio.pg_catalog.pg_shdepend 7 contagem.public.temp0000226646 6 rio.public.temp0000285524 6 contagem.public.nf_entrada 6 rio.public.temp0000285608 6 rio.public.temp0000285552 6 rio.public.tmp_drill_0175 5 contagem.public.temp0000226648 5 rio.public.temp0000285530 4 rio.public.temp0000285510 4 contagem.pg_catalog.pg_shdepend 4 contagem.public.temp0000226650 4 postgres.pg_catalog.pg_shdepend 4 brasilia.pg_catalog.pg_shdepend 4 rio.public.temp0000285570 4 brasilia.public.temp0000236294 3 rio.public.temp0000285534 3 contagem.public.temp0000226652 3 contagem.public.parametros 3 rio.public.temp0000285536 3 contagem.public.temp0000226612 3 rio.public.temp0000285572 3 brasilia.public.temp0000236272 2 brasilia.public.nf_entrada 2 contagem.public.temp0000226610 2 template1.pg_catalog.pg_shdepend 2 rio.public.temp0000285586 2 brasilia.public.temp0000236282 2 brasilia.public.temp0000236274 2 rio.public.temp0000285526 2 contagem.public.temp0000226654 2 rio.public.temp0000285598 2 rio.public.temp0000284762 2 brasilia.public.temp0000236304 2 rio.public.temp0000285610 1 rio.public.temp0000285538 1 rio.public.temp0000285594 1 rio.public.temp0000285558 1 contagem.public.temp0000226644 1 rio.public.temp0000285550 1 rio.public.temp0000285554 1 brasilia.public.temp0000236248 1 brasilia.public.temp0000236314 1 rio.public.temp0000285618 1 rio.public.temp0000285574 1 contagem.public.temp0000226620 1 brasilia.public.temp0000236246 1 brasilia.public.temp0000236300 1 brasilia.public.temp0000236238 1 brasilia.public.temp0000236310 1 rio.public.temp0000285512 1 brasilia.public.temp0000236242 1 rio.public.temp0000285614 1 rio.public.temp0000285596 1 contagem.auditor.auditor_2026_07 1 brasilia.public.temp0000236240 1 rio.public.temp0000285600 1 rio.public.temp0000285542 1 Total 1,213 Vacuums per table
Key values
- pg_catalog.pg_attribute (55) Main table vacuumed on database rio
- 550 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 55 49 0 0 0 0 0 26,700 7,035 10,406,165 424 10,175 rio.public.temp0000285528 51 0 0 0 0 0 0 51,139 7,142 12,136,396 0 0 rio.pg_catalog.pg_class 38 32 0 0 0 0 0 6,493 1,998 3,004,121 104 428 contagem.pg_catalog.pg_attribute 32 32 0 0 0 0 0 18,877 4,152 8,023,757 30 814 rio.pg_catalog.pg_type 30 27 0 0 0 0 0 2,650 759 1,028,999 84 316 rio.public.temp0000285576 26 0 0 0 0 0 0 33,254 10,097 14,861,887 0 0 contagem.pg_catalog.pg_class 22 22 0 0 0 0 0 4,011 1,027 1,567,223 16 49 contagem.pg_catalog.pg_type 20 20 0 0 0 0 0 1,803 500 779,714 8 16 rio.pg_catalog.pg_index 16 16 0 0 0 0 0 926 294 281,685 54 139 contagem.public.usuarios 15 0 0 0 0 0 0 58 43 28,089 0 0 rio.pg_catalog.pg_depend 15 15 0 0 0 0 0 5,010 1,928 2,869,401 98 897 contagem.pg_catalog.pg_depend 13 13 0 0 0 0 0 3,649 1,037 2,158,041 13 78 rio.public.temp0000285498 12 0 0 0 0 0 0 14,910 3,062 4,716,204 0 0 contagem.pg_catalog.pg_index 12 12 0 0 0 0 0 660 209 223,959 11 12 brasilia.pg_catalog.pg_attribute 12 12 0 0 0 0 0 6,662 1,817 2,995,099 56 1,376 rio.public.temp0000285020 8 0 0 0 0 0 0 732 185 286,422 0 0 rio.public.temp0000285584 8 0 0 0 0 0 0 2,043 43 127,277 0 0 rio.public.temp0000284750 8 0 0 0 0 0 0 574 46 41,634 0 0 rio.public.temp0000285540 8 0 0 0 0 0 0 292 107 153,543 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 10,138 2,156 9,433,554 1,083 4,475 rio.public.temp0000285404 7 0 0 0 0 0 0 803 266 445,769 0 0 brasilia.pg_catalog.pg_type 7 7 0 0 0 0 0 555 176 257,315 9 45 brasilia.pg_catalog.pg_class 7 7 0 0 0 0 0 1,463 403 667,083 24 88 contagem.public.temp0000226646 6 0 0 0 0 0 0 436 34 31,269 0 0 rio.public.temp0000285552 6 0 0 0 0 0 0 5,049 22 301,379 0 0 rio.public.usuarios 6 3 0 0 0 0 0 84 32 57,237 2 4 rio.public.tmp_drill_0175 5 4 0 0 0 0 0 203 35 72,893 0 0 contagem.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 866 289 669,548 24 41 rio.public.temp0000285608 5 0 0 0 0 0 0 8,285 1,675 2,616,049 0 0 rio.public.temp0000284984 4 0 0 0 0 0 0 485 24 32,406 0 0 rio.public.temp0000285530 4 0 0 0 0 0 0 3,380 15 201,767 0 0 contagem.public.temp0000226650 4 0 0 0 0 0 0 226 22 16,973 0 0 brasilia.pg_catalog.pg_index 4 4 0 0 0 0 0 186 45 48,169 13 20 contagem.public.temp0000226648 4 0 0 0 0 0 0 226 22 16,973 0 0 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 2,109 477 2,406,314 146 446 contagem.public.temp0000226652 3 0 0 0 0 0 0 218 17 15,633 0 0 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,887 789 3,074,228 509 3,428 brasilia.pg_catalog.pg_depend 3 3 0 0 0 0 0 921 287 524,119 8 85 rio.public.temp0000285536 3 0 0 0 0 0 0 140 14 11,878 0 0 rio.public.temp0000285534 3 0 0 0 0 0 0 1,725 1,664 2,226,100 0 0 postgres.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 601 210 402,040 25 47 rio.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 498 156 356,727 14 21 contagem.public.temp0000226612 3 0 0 0 0 0 0 194 18 14,097 0 0 rio.public.temp0000285572 3 0 0 0 0 0 0 4,968 1,665 2,416,827 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 268 37 156,070 15 39 contagem.public.temp0000226654 2 0 0 0 0 0 0 113 11 8,488 0 0 contagem.public.nf_entrada 2 2 0 0 0 0 0 205 72 111,765 5 12 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 329 81 285,347 24 58 rio.public.temp0000285632 2 0 0 0 0 0 0 304 157 272,299 0 0 brasilia.public.temp0000236304 2 0 0 0 0 0 0 482 12 30,717 0 0 rio.public.temp0000285586 2 0 0 0 0 0 0 133 12 9,588 0 0 rio.public.temp0000284762 2 0 0 0 0 0 0 137 12 9,816 0 0 rio.public.temp0000285594 1 0 0 0 0 0 0 1,658 4 98,425 0 0 rio.public.temp0000285610 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.temp0000236282 1 0 0 0 0 0 0 241 6 15,359 0 0 rio.public.temp0000285554 1 0 0 0 0 0 0 67 4 4,556 0 0 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 33,577 19,911 26,128,913 6,776 145,479 rio.public.temp0000285550 1 0 0 0 0 0 0 73 6 5,196 0 0 rio.public.temp0000285596 1 0 0 0 0 0 0 79 6 5,562 0 0 contagem.public.lotes 1 1 0 0 0 0 0 1,227 911 2,543,725 44 1,364 rio.public.temp0000285614 1 0 0 0 0 0 0 80 6 5,620 0 0 contagem.auditor.auditor_2026_07 1 0 0 0 0 0 0 17,652 11,952 15,302,771 2,526 58,775 rio.public.temp0000285618 1 0 0 0 0 0 0 8 6 2,965 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 125,215 66,497 87,312,788 29,512 608,381 brasilia.public.temp0000236314 1 0 0 0 0 0 0 241 6 15,355 0 0 contagem.public.temp0000226620 1 0 0 0 0 0 0 45 6 3,485 0 0 rio.public.temp0000285542 1 0 0 0 0 0 0 4 3 774 0 0 brasilia.public.fluxos 1 1 0 0 0 0 0 10,026 7,932 32,589,500 327 15,366 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,508 7 178,976 0 0 rio.public.temp0000285598 1 0 0 0 0 0 0 1,658 4 98,425 0 0 rio.public.temp0000285570 1 0 0 0 0 0 0 94 6 6,457 0 0 rio.public.temp0000285600 1 0 0 0 0 0 0 117 6 7,836 0 0 Total 550 313 0 0 0 0 0 424,634 159,670 257,217,515 41,984 852,474 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (22.79) 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.58 rio.public.temp0000285528 0 0 1.82 rio.pg_catalog.pg_class 0 0 0.99 contagem.pg_catalog.pg_attribute 0 0 2.2 rio.pg_catalog.pg_type 0 0 0.38 rio.public.temp0000285576 0 0 1.59 contagem.pg_catalog.pg_class 0 0 0.57 contagem.pg_catalog.pg_type 0 0 0.27 rio.pg_catalog.pg_index 0 0 0.13 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_depend 0 0 1.07 contagem.pg_catalog.pg_depend 0 0 0.56 rio.public.temp0000285498 0 0 0.62 contagem.pg_catalog.pg_index 0 0 0.19 brasilia.pg_catalog.pg_attribute 0 0 1.05 rio.public.temp0000285020 0 0 0.13 rio.public.temp0000285584 0 0 0.18 rio.public.temp0000284750 0 0 0.13 rio.public.temp0000285540 0 0 0.18 rio.pg_catalog.pg_statistic 0 0 1.37 rio.public.temp0000285404 0 0 0.13 brasilia.pg_catalog.pg_type 0 0 0.18 brasilia.pg_catalog.pg_class 0 0 0.29 contagem.public.temp0000226646 0 0 0.09 rio.public.temp0000285552 0 0 0.28 rio.public.usuarios 0 0 0 rio.public.tmp_drill_0175 0 0 0.01 contagem.pg_catalog.pg_shdepend 0 0 0.18 rio.public.temp0000285608 0 0 0.3 rio.public.temp0000284984 0 0 0.08 rio.public.temp0000285530 0 0 0.15 contagem.public.temp0000226650 0 0 0.07 brasilia.pg_catalog.pg_index 0 0 0.03 contagem.public.temp0000226648 0 0 0.08 rio.pg_toast.pg_toast_2619 0 0 0.18 contagem.public.temp0000226652 0 0 0.05 brasilia.pg_catalog.pg_statistic 0 0 0.4 brasilia.pg_catalog.pg_depend 0 0 0.2 rio.public.temp0000285536 0 0 0.01 rio.public.temp0000285534 0 0 0.18 postgres.pg_catalog.pg_shdepend 0 0 0.12 rio.pg_catalog.pg_shdepend 0 0 0.08 contagem.public.temp0000226612 0 0 0.06 rio.public.temp0000285572 0 0 0.15 contagem.pg_toast.pg_toast_2619 0 0 0.03 contagem.public.temp0000226654 0 0 0.04 contagem.public.nf_entrada 0 0 0.05 brasilia.pg_toast.pg_toast_2619 0 0 0.03 rio.public.temp0000285632 0 0 0.04 brasilia.public.temp0000236304 0 0 0.05 rio.public.temp0000285586 0 0 0.03 rio.public.temp0000284762 0 0 0.02 rio.public.temp0000285594 0 0 0.05 rio.public.temp0000285610 0 0 0 brasilia.public.temp0000236282 0 0 0.02 rio.public.temp0000285554 0 0 0 brasilia.auditor.auditor_2026_07 0 0 6.69 rio.public.temp0000285550 0 0 0.01 rio.public.temp0000285596 0 0 0.02 contagem.public.lotes 0 0 0.38 rio.public.temp0000285614 0 0 0.02 contagem.auditor.auditor_2026_07 0 0 4.05 rio.public.temp0000285618 0 0 0.02 rio.auditor.auditor_2026_07 0 0 22.79 brasilia.public.temp0000236314 0 0 0.01 contagem.public.temp0000226620 0 0 0.01 rio.public.temp0000285542 0 0 0 brasilia.public.fluxos 0 0 3.82 contagem.pg_catalog.pg_statistic 0 0 0.05 rio.public.temp0000285598 0 0 0.05 rio.public.temp0000285570 0 0 0.01 rio.public.temp0000285600 0 0 0.01 Total 0 0 58.61 Tuples removed per table
Key values
- pg_catalog.pg_attribute (221239) Main table with removed tuples on database rio
- 517367 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 55 49 221,239 1,382,953 80,632 463 32,781 contagem.pg_catalog.pg_attribute 32 32 134,648 748,951 0 371 17,238 brasilia.pg_catalog.pg_attribute 12 12 52,273 272,921 64 172 6,823 rio.pg_catalog.pg_statistic 8 8 14,875 66,956 71 0 10,288 rio.pg_catalog.pg_depend 15 15 10,020 290,817 6,427 0 2,805 rio.pg_catalog.pg_type 30 27 8,892 72,178 3,786 21 2,152 contagem.pg_catalog.pg_depend 13 13 8,061 246,866 0 11 2,241 brasilia.pg_catalog.pg_statistic 3 3 6,387 23,850 0 0 3,216 rio.pg_catalog.pg_class 38 32 5,391 145,125 12,816 94 4,777 contagem.pg_catalog.pg_class 22 22 4,660 76,833 1 36 2,699 brasilia.pg_catalog.pg_depend 3 3 4,515 53,613 0 11 528 contagem.pg_catalog.pg_shdepend 5 5 4,479 67,966 11 0 575 rio.auditor.auditor_2026_07 1 0 4,452 11,669,417 0 0 533,134 contagem.pg_catalog.pg_statistic 1 1 4,329 7,274 0 0 1,011 rio.pg_catalog.pg_index 16 16 4,054 31,360 552 3 872 contagem.pg_catalog.pg_type 20 20 3,972 45,016 0 53 1,253 brasilia.pg_catalog.pg_class 7 7 3,523 26,833 0 15 985 brasilia.public.fluxos 1 1 3,492 1,168,837 0 0 14,242 contagem.pg_catalog.pg_index 12 12 3,037 22,776 0 20 637 rio.pg_catalog.pg_shdepend 3 3 2,871 40,841 0 0 345 postgres.pg_catalog.pg_shdepend 3 3 2,168 40,684 0 0 345 brasilia.pg_catalog.pg_type 7 7 1,768 15,475 0 11 426 brasilia.auditor.auditor_2026_07 1 0 1,463 2,854,233 0 0 126,590 rio.public.tmp_drill_0175 5 4 1,256 45,254 21,397 0 604 rio.pg_toast.pg_toast_2619 4 4 1,227 2,829 0 0 1,120 brasilia.pg_catalog.pg_index 4 4 1,207 7,514 0 0 212 contagem.public.nf_entrada 2 2 989 1,886 0 0 138 contagem.public.usuarios 15 0 887 345 0 0 30 contagem.public.lotes 1 1 676 42,387 0 0 674 brasilia.pg_toast.pg_toast_2619 2 2 197 243 0 3 139 rio.public.usuarios 6 3 193 4,033 979 0 96 contagem.pg_toast.pg_toast_2619 2 2 166 246 0 7 106 contagem.public.temp0000226652 3 0 0 3,818 0 93 291 rio.public.temp0000285594 1 0 0 23,333 0 0 1,664 rio.public.temp0000284984 4 0 0 20,283 0 187 453 rio.public.temp0000285020 8 0 0 28,414 0 228 668 rio.public.temp0000285610 1 0 0 1,082 0 0 64 brasilia.public.temp0000236282 1 0 0 3,108 0 23 233 contagem.public.temp0000226646 6 0 0 7,623 0 186 582 rio.public.temp0000285530 4 0 0 71,108 0 0 5,056 rio.public.temp0000285536 3 0 0 3,781 0 61 195 rio.public.temp0000285498 12 0 0 279,550 0 0 19,968 rio.public.temp0000285554 1 0 0 1,254 0 0 64 rio.public.temp0000285552 6 0 0 117,908 0 0 8,384 contagem.public.temp0000226654 2 0 0 2,548 0 62 194 rio.public.temp0000285550 1 0 0 1,309 0 63 65 rio.public.temp0000285596 1 0 0 1,403 0 57 71 rio.public.temp0000285614 1 0 0 1,448 0 56 72 rio.public.temp0000285584 8 0 0 37,149 0 344 2,216 contagem.public.temp0000226650 4 0 0 5,091 0 124 388 rio.public.temp0000285534 3 0 0 47,811 0 0 3,392 rio.public.temp0000284750 8 0 0 27,375 0 261 603 rio.public.temp0000285576 26 0 0 584,553 0 60 41,668 rio.public.temp0000285404 7 0 0 33,810 0 137 759 contagem.auditor.auditor_2026_07 1 0 0 1,795,876 0 0 75,794 rio.public.temp0000285618 1 0 0 1,496 0 54 74 rio.public.temp0000285608 5 0 0 116,576 0 0 8,320 contagem.public.temp0000226648 4 0 0 5,087 0 124 388 rio.public.temp0000285632 2 0 0 12,855 0 96 288 rio.public.temp0000285528 51 0 0 750,267 0 774 52,986 brasilia.public.temp0000236314 1 0 0 3,112 0 23 233 contagem.public.temp0000226612 3 0 0 3,338 0 87 169 rio.public.temp0000285540 8 0 0 56,607 0 274 3,694 rio.public.temp0000285572 3 0 0 69,914 0 0 4,992 contagem.public.temp0000226620 1 0 0 1,048 0 27 37 rio.public.temp0000285542 1 0 0 1,236 0 0 64 brasilia.public.temp0000236304 2 0 0 6,217 0 46 466 rio.public.temp0000285586 2 0 0 2,059 0 11 117 rio.public.temp0000285598 1 0 0 23,332 0 0 1,664 rio.public.temp0000284762 2 0 0 5,475 0 71 121 rio.public.temp0000285570 1 0 0 3,858 0 42 86 rio.public.temp0000285600 1 0 0 4,862 0 19 109 Total 550 313 517,367 23,643,486 126,736 4,881 1,005,734 Pages removed per table
Key values
- public.temp0000285528 (774) Main table with removed pages on database rio
- 4881 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000285528 51 0 0 774 rio.pg_catalog.pg_attribute 55 49 221239 463 contagem.pg_catalog.pg_attribute 32 32 134648 371 rio.public.temp0000285584 8 0 0 344 rio.public.temp0000285540 8 0 0 274 rio.public.temp0000284750 8 0 0 261 rio.public.temp0000285020 8 0 0 228 rio.public.temp0000284984 4 0 0 187 contagem.public.temp0000226646 6 0 0 186 brasilia.pg_catalog.pg_attribute 12 12 52273 172 rio.public.temp0000285404 7 0 0 137 contagem.public.temp0000226650 4 0 0 124 contagem.public.temp0000226648 4 0 0 124 rio.public.temp0000285632 2 0 0 96 rio.pg_catalog.pg_class 38 32 5391 94 contagem.public.temp0000226652 3 0 0 93 contagem.public.temp0000226612 3 0 0 87 rio.public.temp0000284762 2 0 0 71 rio.public.temp0000285550 1 0 0 63 contagem.public.temp0000226654 2 0 0 62 rio.public.temp0000285536 3 0 0 61 rio.public.temp0000285576 26 0 0 60 rio.public.temp0000285596 1 0 0 57 rio.public.temp0000285614 1 0 0 56 rio.public.temp0000285618 1 0 0 54 contagem.pg_catalog.pg_type 20 20 3972 53 brasilia.public.temp0000236304 2 0 0 46 rio.public.temp0000285570 1 0 0 42 contagem.pg_catalog.pg_class 22 22 4660 36 contagem.public.temp0000226620 1 0 0 27 brasilia.public.temp0000236282 1 0 0 23 brasilia.public.temp0000236314 1 0 0 23 rio.pg_catalog.pg_type 30 27 8892 21 contagem.pg_catalog.pg_index 12 12 3037 20 rio.public.temp0000285600 1 0 0 19 brasilia.pg_catalog.pg_class 7 7 3523 15 brasilia.pg_catalog.pg_depend 3 3 4515 11 brasilia.pg_catalog.pg_type 7 7 1768 11 contagem.pg_catalog.pg_depend 13 13 8061 11 rio.public.temp0000285586 2 0 0 11 contagem.pg_toast.pg_toast_2619 2 2 166 7 rio.pg_catalog.pg_index 16 16 4054 3 brasilia.pg_toast.pg_toast_2619 2 2 197 3 rio.public.temp0000285594 1 0 0 0 rio.public.temp0000285610 1 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6387 0 rio.public.temp0000285530 4 0 0 0 contagem.public.usuarios 15 0 887 0 rio.public.temp0000285498 12 0 0 0 rio.public.temp0000285554 1 0 0 0 rio.public.temp0000285552 6 0 0 0 rio.public.tmp_drill_0175 5 4 1256 0 brasilia.auditor.auditor_2026_07 1 0 1463 0 contagem.public.nf_entrada 2 2 989 0 rio.public.usuarios 6 3 193 0 contagem.public.lotes 1 1 676 0 rio.public.temp0000285534 3 0 0 0 brasilia.pg_catalog.pg_index 4 4 1207 0 contagem.pg_catalog.pg_shdepend 5 5 4479 0 postgres.pg_catalog.pg_shdepend 3 3 2168 0 contagem.auditor.auditor_2026_07 1 0 0 0 rio.public.temp0000285608 5 0 0 0 rio.auditor.auditor_2026_07 1 0 4452 0 rio.pg_catalog.pg_depend 15 15 10020 0 rio.pg_catalog.pg_shdepend 3 3 2871 0 rio.public.temp0000285572 3 0 0 0 rio.public.temp0000285542 1 0 0 0 brasilia.public.fluxos 1 1 3492 0 rio.pg_catalog.pg_statistic 8 8 14875 0 contagem.pg_catalog.pg_statistic 1 1 4329 0 rio.public.temp0000285598 1 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1227 0 Total 550 313 517,367 4,881 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 16 00 0 1 01 0 1 02 0 0 03 0 0 04 0 0 05 7 4 06 0 0 07 15 27 08 54 116 09 54 124 10 44 140 11 69 160 12 13 35 13 32 81 14 92 187 15 47 125 16 77 135 17 42 74 18 1 0 19 0 0 20 0 0 21 3 3 22 0 0 23 0 0 - 22.79 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 2 4m46s 1m53s 2m53s 2m23s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 12:18:04 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 09:47:07 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 20:05:13 Database: rio User: intelifix Remote: [local] Application: psql
2 2 2s 1s 1s 1s drop table if exists temp0000285576;-
DROP TABLE IF EXISTS temp0000285576;
Date: 2026-07-16 17:20:12 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285576;
Date: 2026-07-16 14:15:11 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285576;
Date: 2026-07-16 14:15:11 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000285540;-
DROP TABLE IF EXISTS temp0000285540;
Date: 2026-07-16 09:43:08 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285540;
Date: 2026-07-16 09:43:08 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 2m53s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-16 12:18:04 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m53s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-16 09:47:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s1ms DROP TABLE IF EXISTS temp0000285540;[ Date: 2026-07-16 09:43:08 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s DROP TABLE IF EXISTS temp0000285576;[ Date: 2026-07-16 17:20:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s DROP TABLE IF EXISTS temp0000285576;[ Date: 2026-07-16 14:15:11 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 5,229 Total read queries
- 1,812 Total write queries
Queries by database
Key values
- rio Main database
- 4,636 Requests
- 6h28m2s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 7,375 Requests
User Request type Count Duration etiquetas Total 40 7s648ms select 40 7s648ms intelifix Total 7,375 8h36m37s copy to 413 48m18s ddl 1,399 1h2s others 494 44m7s select 5,069 6h4m8s lenon Total 120 1m20s select 120 1m20s Duration by user
Key values
- 8h36m37s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 40 7s648ms select 40 7s648ms intelifix Total 7,375 8h36m37s copy to 413 48m18s ddl 1,399 1h2s others 494 44m7s select 5,069 6h4m8s lenon Total 120 1m20s select 120 1m20s Queries by host
Key values
- [local] Main host
- 7,534 Requests
- 8h38m3s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 6,386 Requests
- 4h22m26s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-16 20:10:57 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 4,238 100-500ms duration
Slowest individual queries
Rank Duration Query 1 9m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 10:14:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 17:13:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 15:13:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 09:13:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 16:13:44 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 14:13:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 11:13:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 7m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 07:12:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m36s analyze verbose;[ Date: 2026-07-16 05:07:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m32s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 12:12:33 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 08:12:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m26s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 20:11:27 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 18:11:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 13:11:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m8s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027152, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-16 15:03:12 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
16 6m5s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027133, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-16 11:30:53 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 5m59s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027161, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-16 15:37:54 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 5m57s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027163, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-16 15:47:40 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 22:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-16 19:10:51 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h7m31s 48 1s332ms 9m35s 2m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 07 3 8m27s 2m49s 08 3 7m39s 2m33s 09 3 9m21s 3m7s 10 3 10m11s 3m23s 11 3 8m36s 2m52s 12 3 7m55s 2m38s 13 3 6m35s 2m11s 14 3 9m2s 3m 15 3 9m24s 3m8s 16 3 9m9s 3m3s 17 3 9m15s 3m5s 18 3 6m38s 2m12s 19 3 6m8s 2m2s 20 3 6m46s 2m15s 21 3 6m5s 2m1s 22 3 6m13s 2m4s [ User: intelifix - Total duration: 2h7m31s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m31s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-16 10:14:36 Duration: 9m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-16 17:13:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-16 15:13:49 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
2 1h28m36s 394 150ms 6m8s 13s493ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 07 26 9m49s 22s678ms 08 40 6m44s 10s108ms 09 18 11m17s 37s626ms 10 24 5m54s 14s776ms 11 34 10m53s 19s227ms 12 9 9m54s 1m6s 13 27 56s171ms 2s80ms 14 43 2m41s 3s754ms 15 65 19m21s 17s875ms 16 55 8m14s 8s990ms 17 53 2m47s 3s166ms [ User: intelifix - Total duration: 1h28m36s - Times executed: 394 ]
[ Application: [unknown] - Total duration: 1h28m36s - Times executed: 394 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027152, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 15:03:12 Duration: 6m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027133, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 11:30:53 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027161, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 15:37:54 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h14m36s 48 230ms 4m40s 1m33s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 07 3 4m39s 1m33s 08 3 4m40s 1m33s 09 3 5m27s 1m49s 10 3 5m35s 1m51s 11 3 5m3s 1m41s 12 3 4m30s 1m30s 13 3 4m19s 1m26s 14 3 5m27s 1m49s 15 3 5m26s 1m48s 16 3 5m3s 1m41s 17 3 4m36s 1m32s 18 3 3m50s 1m16s 19 3 3m56s 1m18s 20 3 3m58s 1m19s 21 3 3m46s 1m15s 22 3 4m14s 1m24s [ User: intelifix - Total duration: 1h14m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h14m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-16 14:19:28 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-16 15:19:48 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-16 10:20:43 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
4 21m31s 1,659 150ms 4s630ms 778ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 07 16 7s567ms 472ms 08 161 2m8s 798ms 09 199 2m41s 810ms 10 248 2m54s 703ms 11 197 2m36s 794ms 12 50 39s103ms 782ms 13 91 1m2s 692ms 14 251 3m25s 819ms 15 201 2m19s 694ms 16 172 2m28s 864ms 17 73 1m7s 920ms [ User: intelifix - Total duration: 21m31s - Times executed: 1659 ]
[ Application: [unknown] - Total duration: 21m31s - Times executed: 1659 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (266991, 503, '929240109914,CC5830FF377F,A4224991B48F,2035431A4F26,2035435A35CE,2035435A379C,203543594B01,9C24722FCB2E,203543168671,203543572239,D8CF6165C2AB,9C24722FFE34,CC583000A19A,20354357211A,B0924A114D90,CC5830FED9B5,203543594E2D,9C247233716F,64FA2B6447CD,2035431D2EC0,203543136EAD,9C24723175EF,CC5830FF68E8,B01FF41ACB66,CC583000FD1F,CC583000FF4F,D8CF61663185,D8CF61659C16,441524E43129,CC5830FF2779,20354319A8B5,B01FF41CCBD2,20354316C826,B01FF41A761D,D8CF61659023,B01FF41CEEE0,B01FF41A766A,203543197C0E,DC92726F4432,2035431D2E50,2035431D2F99', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"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-16 11:41:18 Duration: 4s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265485, 452, '71802585850050501288,216833648810,216878275454,216832781520,216696207079,184270843144,216949064058,216908196567,216354890717,216838646783,216355218706,216838260001,216614115465,216819390101,216501116367,216561121416,216909561920,216501121217,216335391227,216834927688,216402997588H010948190,216630594043,216552560424,216818753439,216875770710,216395605565,216731471734,216834989614,216514307688,216514341430,216548341123,216550899812,216800493251,216353262533,216688768283,216351815051,216620078291,216732805466,216835511719,216355240426', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"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-16 10:46:58 Duration: 4s571ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (266991, 503, '929240498443,D8CF6166DC2C,2035431D242B,203543136D72,B01FF41AADE5,B01FF41AB483,2035431692F7,441524E6FF4A,203543549E32,B01FF41C9C92,20354313490D,20354319729F,A42249915ABC,D8CF61661960,2035431F4A45,9C24722FDFB0,2035431D3702,B01FF41A22C5,203543159289,CC5830FDE851,203543199591,B01FF41A330A,647B1EEE1661,20354316C849,203543152220,441524E6FBED,2035431D261C,20354358F388,B01FF41AC507,5447CCCB1E3C,B01FF41CE95A,CC583001C58D,2035431D175F,2035431C950D,20354319A822,B01FF41A7671,B01FF41ACF1E,2035431C9E4B,2035431C94DC,203543168C0C,2035431F5822', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"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-16 14:33:06 Duration: 4s525ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 17m2s 77 9s963ms 31s802ms 13s278ms create table temp0000285528 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 07 11 2m19s 12s673ms 08 15 3m4s 12s268ms 09 6 1m22s 13s831ms 10 6 1m16s 12s818ms 11 14 3m11s 13s680ms 12 2 22s293ms 11s146ms 14 5 1m17s 15s497ms 15 12 2m51s 14s331ms 16 6 1m15s 12s641ms [ User: intelifix - Total duration: 17m2s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 77 ]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 07:14:50 Duration: 31s802ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 11:24:05 Duration: 29s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 15:29:53 Duration: 22s248ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 16m59s 275 153ms 2m57s 3s708ms call rs_giga_triagem (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 00 12 33s795ms 2s816ms 01 12 25s78ms 2s89ms 02 12 27s774ms 2s314ms 03 12 34s955ms 2s912ms 04 12 25s398ms 2s116ms 05 12 27s612ms 2s301ms 06 12 30s368ms 2s530ms 07 12 28s864ms 2s405ms 08 12 31s400ms 2s616ms 09 12 2m26s 12s228ms 10 12 33s461ms 2s788ms 11 12 32s480ms 2s706ms 12 12 3m25s 17s91ms 13 12 31s379ms 2s614ms 14 12 33s749ms 2s812ms 15 12 41s21ms 3s418ms 16 12 39s270ms 3s272ms 17 12 34s333ms 2s861ms 18 11 28s896ms 2s626ms 19 12 28s794ms 2s399ms 20 12 41s147ms 3s428ms 21 12 29s307ms 2s442ms 22 12 28s797ms 2s399ms [ User: intelifix - Total duration: 16m59s - Times executed: 275 ]
[ Application: psql - Total duration: 16m59s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 12:18:04 Duration: 2m57s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 09:47:07 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 20:05:13 Duration: 11s607ms Database: rio User: intelifix Remote: [local] Application: psql
7 15m52s 96 1s685ms 35s711ms 9s918ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 07 2 11s225ms 5s612ms 09 7 1m15s 10s749ms 10 5 1m4s 12s898ms 11 6 1m28s 14s817ms 12 5 21s661ms 4s332ms 13 5 1m4s 12s873ms 14 12 1m25s 7s94ms 15 22 4m11s 11s452ms 16 13 2m40s 12s350ms 17 19 2m8s 6s768ms [ User: intelifix - Total duration: 15m52s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 15m52s - Times executed: 96 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 09:50:32 Duration: 35s711ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 13:21:00 Duration: 32s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 10:26:39 Duration: 30s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 13m43s 3 2m7s 7m36s 4m34s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 05 3 13m43s 4m34s [ User: intelifix - Total duration: 13m43s - Times executed: 3 ]
[ Application: psql - Total duration: 13m43s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-16 05:07:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-16 05:11:37 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-16 05:13:44 Duration: 2m7s Database: contagem User: intelifix Remote: [local] Application: psql
9 11m6s 10 1s503ms 1m58s 1m6s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 11 3 5m15s 1m45s 13 1 1m58s 1m58s 14 2 9s591ms 4s795ms 15 2 10s811ms 5s405ms 16 2 3m31s 1m45s [ User: intelifix - Total duration: 11m6s - Times executed: 10 ]
[ Application: psql - Total duration: 11m6s - Times executed: 10 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01559);
Date: 2026-07-16 13:26:19 Duration: 1m58s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01560);
Date: 2026-07-16 16:31:26 Duration: 1m49s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01558);
Date: 2026-07-16 11:39:24 Duration: 1m45s Database: contagem User: intelifix Remote: [local] Application: psql
10 8m26s 969 150ms 8s59ms 522ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 07 2 1s881ms 940ms 08 125 1m4s 513ms 09 119 1m1s 514ms 10 146 1m19s 546ms 11 119 1m5s 548ms 12 14 7s489ms 534ms 13 102 53s850ms 527ms 14 95 1m 639ms 15 144 1m6s 460ms 16 87 38s456ms 442ms 17 16 7s315ms 457ms [ User: intelifix - Total duration: 8m26s - Times executed: 969 ]
[ Application: [unknown] - Total duration: 8m26s - Times executed: 969 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "151", "itens" : "C85D387BAF47,C85D387DC490,C85D38015BCF,C85D3879E6F0,C85D387BCC12,C85D387556FA,C85D38E6B2EE,C85D38E6785C,C85D38FC31BE", "usuario" : "417", "caixa" : "2911990", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-16 11:54:20 Duration: 8s59ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "295", "itens" : "230027564160,230029988997,229977543846,230029886081,230051748911,229971312834,230044508495,230023212849,229967856873,230035555063,230052795163,229975158406,230044461320,230042009408,230052357488,230027523550,230050973246,229968211432,229962438702,229987170914,230052574861", "usuario" : "414", "caixa" : "2725816", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-16 10:17:28 Duration: 3s591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "266628", "modelo" : "464", "itens" : "241768891416,241764793844,241779325262,241745480411,241745649999,241772394350,241774192932,241778930421,241739090820,241761396980,241742687881,241743167580,241760168487,241761496788,241741061012,241742615675,241770204866,241738270628,241777656165,241747511922,241778907286,241774187678,241746139194,241746634249,241745651819,241760143132,241761480323,241761487090,241745552438,241761493051,241761484464,241742710511,241742606482,241779093646,241764785358,241742206263,241764836878,241763605153,241760014859,241747338290,241779142843,241760125779,241740698596,241764432036,241738280000,241777724051,241742655050,241762792235,241745977282,241764643145", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-16 08:30:16 Duration: 2s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8m2s 38 10s368ms 16s396ms 12s703ms create table temp0000285576 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 12 3 37s756ms 12s585ms 13 3 41s268ms 13s756ms 14 8 1m43s 12s902ms 16 5 1m7s 13s546ms 17 19 3m52s 12s250ms [ User: intelifix - Total duration: 8m2s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 8m2s - Times executed: 38 ]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 14:05:26 Duration: 16s396ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 17:02:10 Duration: 15s400ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 16:45:36 Duration: 15s230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 6m52s 159 195ms 12s87ms 2s596ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 16 00 5 18s718ms 3s743ms 01 6 8s633ms 1s438ms 02 6 7s471ms 1s245ms 03 5 9s311ms 1s862ms 04 6 9s703ms 1s617ms 05 3 3s327ms 1s109ms 06 3 4s346ms 1s448ms 07 10 25s662ms 2s566ms 08 12 35s548ms 2s962ms 09 12 39s182ms 3s265ms 10 12 38s404ms 3s200ms 11 12 40s283ms 3s356ms 12 11 36s108ms 3s282ms 13 8 11s54ms 1s381ms 14 12 35s63ms 2s921ms 15 12 44s813ms 3s734ms 16 10 27s987ms 2s798ms 17 5 4s682ms 936ms 20 1 195ms 195ms 21 3 5s347ms 1s782ms 22 5 6s982ms 1s396ms [ User: intelifix - Total duration: 6m52s - Times executed: 159 ]
[ Application: psql - Total duration: 6m52s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 00:05:13 Duration: 12s87ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 15:05:09 Duration: 8s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 12:35:09 Duration: 8s159ms Database: rio User: intelifix Remote: [local] Application: psql
13 4m3s 18 11s146ms 15s582ms 13s524ms create table temp0000285584 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 16 14 10 2m19s 13s937ms 15 8 1m44s 13s8ms [ User: intelifix - Total duration: 4m3s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 18 ]
-
CREATE TABLE temp0000285584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 15:06:19 Duration: 15s582ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 14:57:47 Duration: 15s80ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 14:58:10 Duration: 14s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m 14 10s805ms 16s180ms 12s873ms create table temp0000285498 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 16 08 8 1m36s 12s75ms 09 5 1m7s 13s487ms 10 1 16s180ms 16s180ms [ User: intelifix - Total duration: 3m - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m - Times executed: 14 ]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 10:00:32 Duration: 16s180ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 09:58:35 Duration: 15s10ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 09:58:08 Duration: 14s208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 2m57s 4 4s618ms 1m26s 44s467ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 16 20 2 1m26s 43s173ms 23 2 1m31s 45s760ms [ User: intelifix - Total duration: 2m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-16 23:37:37 Duration: 1m26s 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-16 20:08:41 Duration: 1m21s 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-16 23:47:40 Duration: 4s869ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
16 2m42s 37 765ms 14s488ms 4s400ms call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 16 08 2 13s619ms 6s809ms 09 3 15s991ms 5s330ms 10 3 30s566ms 10s188ms 11 2 10s444ms 5s222ms 12 3 13s893ms 4s631ms 13 3 10s77ms 3s359ms 14 3 24s152ms 8s50ms 15 2 13s751ms 6s875ms 16 2 13s418ms 6s709ms 17 3 5s493ms 1s831ms 18 1 1s314ms 1s314ms 19 3 3s57ms 1s19ms 20 3 3s150ms 1s50ms 21 3 2s829ms 943ms 22 1 1s73ms 1s73ms [ User: intelifix - Total duration: 2m42s - Times executed: 37 ]
[ Application: psql - Total duration: 2m42s - Times executed: 37 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-16 10:20:16 Duration: 14s488ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-16 14:20:10 Duration: 9s783ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-16 10:00:11 Duration: 9s769ms Database: rio User: intelifix Remote: [local] Application: psql
17 2m39s 70 182ms 1m 2s279ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 16 07 5 2s366ms 473ms 08 8 21s668ms 2s708ms 09 8 1m9s 8s690ms 10 2 1s55ms 527ms 11 5 2s204ms 440ms 12 2 1s331ms 665ms 13 1 1s338ms 1s338ms 14 14 36s705ms 2s621ms 15 8 3s522ms 440ms 16 5 7s662ms 1s532ms 17 12 12s161ms 1s13ms [ User: intelifix - Total duration: 2m39s - Times executed: 70 ]
[ Application: psql - Total duration: 2m39s - Times executed: 70 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027130);
Date: 2026-07-16 09:59:20 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027147);
Date: 2026-07-16 14:46:07 Duration: 21s250ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027117);
Date: 2026-07-16 08:15:00 Duration: 12s509ms Database: rio User: intelifix Remote: [local] Application: psql
18 2m24s 36 2s700ms 8s654ms 4s17ms create table temp0000285528 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 16 07 4 17s200ms 4s300ms 08 8 26s108ms 3s263ms 09 4 14s419ms 3s604ms 11 6 22s533ms 3s755ms 15 2 10s311ms 5s155ms 16 12 54s57ms 4s504ms [ User: intelifix - Total duration: 2m24s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 36 ]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 07:23:48 Duration: 8s654ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 16:24:23 Duration: 7s798ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 15:04:07 Duration: 6s145ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m22s 270 158ms 2s415ms 527ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 16 09 50 17s483ms 349ms 14 220 2m4s 567ms [ User: intelifix - Total duration: 2m22s - Times executed: 270 ]
[ Application: [unknown] - Total duration: 2m22s - Times executed: 270 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"128444","seriais":"241745702834,241814301931,241762342539,241775595964,241765608402,241778620312,241762328092,241775623240,241778108588,241745663941,241768041827,241765568195,241814373453,241778785153,241742109812,241775312929,241768004449,241814521223,241768024855,241762641536,241778717088,241744335057,241759007173,241747420926,241771263039,241765408809,241764427489,241814363755,241739621130,241771282233,241771010209,241744547883","usuario":"399","observacao":""}');
Date: 2026-07-16 14:20:34 Duration: 2s415ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"128444","seriais":"241734701424,241720463547,241737105676,241721782834,241787274141,241724489898,241753915779,241736991322,241757401114,241724777076,241787268911,241754270820,241720286380,241754121939,241736983543,241757338201,241782065664,241757334463,241725485159,241725812038,241722417373,241754135475,241720282441,241753750612,241722370322,241734679805,241791512535,241720419805,241704883553,241791627495,241748936067,241753921111,241705074155,241704885876,241782037176,241736983139,241724805867,241734711122,241720377073,241737116081","usuario":"399","observacao":""}');
Date: 2026-07-16 14:30:49 Duration: 2s372ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"128444","seriais":"241634867078,241707062026,241631431323,241691734761,230040110615,241604148604,241594185465,241706515878,241691530825,241618193858,241652332532,241657072647,241709376976,241691405559,241691429602,241631018498,241694122020,241691401923,241732534040,241609219918,241694497488,241709227792,241604809712,241658564150,241730748893,241714736074,241675357584,241672647185,241689280830,241638284550,241715534345,241706431527,241672002544,241694465566,241645837273","usuario":"399","observacao":""}');
Date: 2026-07-16 14:08:04 Duration: 2s126ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 2m13s 3 6s210ms 1m48s 44s655ms copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 16 23 3 2m13s 44s655ms [ User: intelifix - Total duration: 2m13s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-16 23:14:54 Duration: 1m48s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-16 23:48:46 Duration: 19s535ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-16 23:38:13 Duration: 6s210ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,659 21m31s 150ms 4s630ms 778ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 07 16 7s567ms 472ms 08 161 2m8s 798ms 09 199 2m41s 810ms 10 248 2m54s 703ms 11 197 2m36s 794ms 12 50 39s103ms 782ms 13 91 1m2s 692ms 14 251 3m25s 819ms 15 201 2m19s 694ms 16 172 2m28s 864ms 17 73 1m7s 920ms [ User: intelifix - Total duration: 21m31s - Times executed: 1659 ]
[ Application: [unknown] - Total duration: 21m31s - Times executed: 1659 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (266991, 503, '929240109914,CC5830FF377F,A4224991B48F,2035431A4F26,2035435A35CE,2035435A379C,203543594B01,9C24722FCB2E,203543168671,203543572239,D8CF6165C2AB,9C24722FFE34,CC583000A19A,20354357211A,B0924A114D90,CC5830FED9B5,203543594E2D,9C247233716F,64FA2B6447CD,2035431D2EC0,203543136EAD,9C24723175EF,CC5830FF68E8,B01FF41ACB66,CC583000FD1F,CC583000FF4F,D8CF61663185,D8CF61659C16,441524E43129,CC5830FF2779,20354319A8B5,B01FF41CCBD2,20354316C826,B01FF41A761D,D8CF61659023,B01FF41CEEE0,B01FF41A766A,203543197C0E,DC92726F4432,2035431D2E50,2035431D2F99', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"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-16 11:41:18 Duration: 4s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265485, 452, '71802585850050501288,216833648810,216878275454,216832781520,216696207079,184270843144,216949064058,216908196567,216354890717,216838646783,216355218706,216838260001,216614115465,216819390101,216501116367,216561121416,216909561920,216501121217,216335391227,216834927688,216402997588H010948190,216630594043,216552560424,216818753439,216875770710,216395605565,216731471734,216834989614,216514307688,216514341430,216548341123,216550899812,216800493251,216353262533,216688768283,216351815051,216620078291,216732805466,216835511719,216355240426', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"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-16 10:46:58 Duration: 4s571ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (266991, 503, '929240498443,D8CF6166DC2C,2035431D242B,203543136D72,B01FF41AADE5,B01FF41AB483,2035431692F7,441524E6FF4A,203543549E32,B01FF41C9C92,20354313490D,20354319729F,A42249915ABC,D8CF61661960,2035431F4A45,9C24722FDFB0,2035431D3702,B01FF41A22C5,203543159289,CC5830FDE851,203543199591,B01FF41A330A,647B1EEE1661,20354316C849,203543152220,441524E6FBED,2035431D261C,20354358F388,B01FF41AC507,5447CCCB1E3C,B01FF41CE95A,CC583001C58D,2035431D175F,2035431C950D,20354319A822,B01FF41A7671,B01FF41ACF1E,2035431C9E4B,2035431C94DC,203543168C0C,2035431F5822', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"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-16 14:33:06 Duration: 4s525ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 969 8m26s 150ms 8s59ms 522ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 07 2 1s881ms 940ms 08 125 1m4s 513ms 09 119 1m1s 514ms 10 146 1m19s 546ms 11 119 1m5s 548ms 12 14 7s489ms 534ms 13 102 53s850ms 527ms 14 95 1m 639ms 15 144 1m6s 460ms 16 87 38s456ms 442ms 17 16 7s315ms 457ms [ User: intelifix - Total duration: 8m26s - Times executed: 969 ]
[ Application: [unknown] - Total duration: 8m26s - Times executed: 969 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "243112", "modelo" : "151", "itens" : "C85D387BAF47,C85D387DC490,C85D38015BCF,C85D3879E6F0,C85D387BCC12,C85D387556FA,C85D38E6B2EE,C85D38E6785C,C85D38FC31BE", "usuario" : "417", "caixa" : "2911990", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-16 11:54:20 Duration: 8s59ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "227013", "modelo" : "295", "itens" : "230027564160,230029988997,229977543846,230029886081,230051748911,229971312834,230044508495,230023212849,229967856873,230035555063,230052795163,229975158406,230044461320,230042009408,230052357488,230027523550,230050973246,229968211432,229962438702,229987170914,230052574861", "usuario" : "414", "caixa" : "2725816", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-16 10:17:28 Duration: 3s591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "266628", "modelo" : "464", "itens" : "241768891416,241764793844,241779325262,241745480411,241745649999,241772394350,241774192932,241778930421,241739090820,241761396980,241742687881,241743167580,241760168487,241761496788,241741061012,241742615675,241770204866,241738270628,241777656165,241747511922,241778907286,241774187678,241746139194,241746634249,241745651819,241760143132,241761480323,241761487090,241745552438,241761493051,241761484464,241742710511,241742606482,241779093646,241764785358,241742206263,241764836878,241763605153,241760014859,241747338290,241779142843,241760125779,241740698596,241764432036,241738280000,241777724051,241742655050,241762792235,241745977282,241764643145", "usuario" : "414", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-16 08:30:16 Duration: 2s544ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 394 1h28m36s 150ms 6m8s 13s493ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 07 26 9m49s 22s678ms 08 40 6m44s 10s108ms 09 18 11m17s 37s626ms 10 24 5m54s 14s776ms 11 34 10m53s 19s227ms 12 9 9m54s 1m6s 13 27 56s171ms 2s80ms 14 43 2m41s 3s754ms 15 65 19m21s 17s875ms 16 55 8m14s 8s990ms 17 53 2m47s 3s166ms [ User: intelifix - Total duration: 1h28m36s - Times executed: 394 ]
[ Application: [unknown] - Total duration: 1h28m36s - Times executed: 394 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027152, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 15:03:12 Duration: 6m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027133, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 11:30:53 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027161, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 15:37:54 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 321 1m5s 151ms 405ms 205ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 07 12 2s507ms 208ms 08 22 4s693ms 213ms 09 42 9s24ms 214ms 10 47 9s142ms 194ms 11 55 11s590ms 210ms 13 28 5s410ms 193ms 14 65 12s468ms 191ms 15 28 5s834ms 208ms 16 19 4s315ms 227ms 17 3 937ms 312ms [ User: intelifix - Total duration: 1m5s - Times executed: 321 ]
[ Application: [unknown] - Total duration: 1m5s - Times executed: 321 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"156", "usuario" :"418", "tipo" :"N", "itens" :"003", "nota-fiscal" :"10758", "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-16 11:14:57 Duration: 405ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"302", "usuario" :"428", "tipo" :"N", "itens" :"01", "nota-fiscal" :"2022", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-16 09:10:16 Duration: 380ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"7", "cliente" :"11", "modelo" :"190", "usuario" :"397", "tipo" :"N", "itens" :"09", "nota-fiscal" :"14994", "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-16 14:58:04 Duration: 379ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
5 275 16m59s 153ms 2m57s 3s708ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 00 12 33s795ms 2s816ms 01 12 25s78ms 2s89ms 02 12 27s774ms 2s314ms 03 12 34s955ms 2s912ms 04 12 25s398ms 2s116ms 05 12 27s612ms 2s301ms 06 12 30s368ms 2s530ms 07 12 28s864ms 2s405ms 08 12 31s400ms 2s616ms 09 12 2m26s 12s228ms 10 12 33s461ms 2s788ms 11 12 32s480ms 2s706ms 12 12 3m25s 17s91ms 13 12 31s379ms 2s614ms 14 12 33s749ms 2s812ms 15 12 41s21ms 3s418ms 16 12 39s270ms 3s272ms 17 12 34s333ms 2s861ms 18 11 28s896ms 2s626ms 19 12 28s794ms 2s399ms 20 12 41s147ms 3s428ms 21 12 29s307ms 2s442ms 22 12 28s797ms 2s399ms [ User: intelifix - Total duration: 16m59s - Times executed: 275 ]
[ Application: psql - Total duration: 16m59s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 12:18:04 Duration: 2m57s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 09:47:07 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 20:05:13 Duration: 11s607ms Database: rio User: intelifix Remote: [local] Application: psql
6 270 2m22s 158ms 2s415ms 527ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 16 09 50 17s483ms 349ms 14 220 2m4s 567ms [ User: intelifix - Total duration: 2m22s - Times executed: 270 ]
[ Application: [unknown] - Total duration: 2m22s - Times executed: 270 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"128444","seriais":"241745702834,241814301931,241762342539,241775595964,241765608402,241778620312,241762328092,241775623240,241778108588,241745663941,241768041827,241765568195,241814373453,241778785153,241742109812,241775312929,241768004449,241814521223,241768024855,241762641536,241778717088,241744335057,241759007173,241747420926,241771263039,241765408809,241764427489,241814363755,241739621130,241771282233,241771010209,241744547883","usuario":"399","observacao":""}');
Date: 2026-07-16 14:20:34 Duration: 2s415ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"128444","seriais":"241734701424,241720463547,241737105676,241721782834,241787274141,241724489898,241753915779,241736991322,241757401114,241724777076,241787268911,241754270820,241720286380,241754121939,241736983543,241757338201,241782065664,241757334463,241725485159,241725812038,241722417373,241754135475,241720282441,241753750612,241722370322,241734679805,241791512535,241720419805,241704883553,241791627495,241748936067,241753921111,241705074155,241704885876,241782037176,241736983139,241724805867,241734711122,241720377073,241737116081","usuario":"399","observacao":""}');
Date: 2026-07-16 14:30:49 Duration: 2s372ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"128444","seriais":"241634867078,241707062026,241631431323,241691734761,230040110615,241604148604,241594185465,241706515878,241691530825,241618193858,241652332532,241657072647,241709376976,241691405559,241691429602,241631018498,241694122020,241691401923,241732534040,241609219918,241694497488,241709227792,241604809712,241658564150,241730748893,241714736074,241675357584,241672647185,241689280830,241638284550,241715534345,241706431527,241672002544,241694465566,241645837273","usuario":"399","observacao":""}');
Date: 2026-07-16 14:08:04 Duration: 2s126ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
7 159 6m52s 195ms 12s87ms 2s596ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 00 5 18s718ms 3s743ms 01 6 8s633ms 1s438ms 02 6 7s471ms 1s245ms 03 5 9s311ms 1s862ms 04 6 9s703ms 1s617ms 05 3 3s327ms 1s109ms 06 3 4s346ms 1s448ms 07 10 25s662ms 2s566ms 08 12 35s548ms 2s962ms 09 12 39s182ms 3s265ms 10 12 38s404ms 3s200ms 11 12 40s283ms 3s356ms 12 11 36s108ms 3s282ms 13 8 11s54ms 1s381ms 14 12 35s63ms 2s921ms 15 12 44s813ms 3s734ms 16 10 27s987ms 2s798ms 17 5 4s682ms 936ms 20 1 195ms 195ms 21 3 5s347ms 1s782ms 22 5 6s982ms 1s396ms [ User: intelifix - Total duration: 6m52s - Times executed: 159 ]
[ Application: psql - Total duration: 6m52s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 00:05:13 Duration: 12s87ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 15:05:09 Duration: 8s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 12:35:09 Duration: 8s159ms Database: rio User: intelifix Remote: [local] Application: psql
8 157 30s761ms 150ms 1s901ms 195ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 01 1 157ms 157ms 03 1 175ms 175ms 08 1 208ms 208ms 10 3 478ms 159ms 11 9 1s669ms 185ms 12 8 3s550ms 443ms 13 6 1s89ms 181ms 14 21 3s688ms 175ms 15 47 8s495ms 180ms 16 42 7s850ms 186ms 17 18 3s396ms 188ms [ User: intelifix - Total duration: 30s761ms - Times executed: 157 ]
[ Application: [unknown] - Total duration: 30s761ms - Times executed: 157 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "396", "data-de" : "2026-06-01", "data-ate" : "2026-07-16", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 450 }');
Date: 2026-07-16 12:22:08 Duration: 1s901ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "396", "data-de" : "2026-07-10", "data-ate" : "2026-07-16", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 450 }');
Date: 2026-07-16 12:21:48 Duration: 636ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-07-16", "data-ate" : "2026-07-16", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 404 }');
Date: 2026-07-16 16:39:31 Duration: 305ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 148 1m37s 152ms 9s597ms 658ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 07 19 9s943ms 523ms 08 17 9s857ms 579ms 09 2 607ms 303ms 10 12 6s817ms 568ms 11 10 3s667ms 366ms 13 18 9s349ms 519ms 14 10 26s598ms 2s659ms 15 22 12s182ms 553ms 16 16 5s96ms 318ms 17 22 13s357ms 607ms [ User: intelifix - Total duration: 1m37s - Times executed: 148 ]
[ Application: [unknown] - Total duration: 1m37s - Times executed: 148 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128444) LIMIT 1;
Date: 2026-07-16 14:47:53 Duration: 9s597ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128444) LIMIT 1;
Date: 2026-07-16 14:48:23 Duration: 6s777ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128444) LIMIT 1;
Date: 2026-07-16 14:48:07 Duration: 6s463ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
10 120 19s540ms 150ms 200ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 08 6 956ms 159ms 09 15 2s378ms 158ms 10 15 2s450ms 163ms 11 18 2s912ms 161ms 12 3 472ms 157ms 13 15 2s510ms 167ms 14 18 2s941ms 163ms 15 16 2s626ms 164ms 16 12 1s950ms 162ms 17 2 340ms 170ms [ User: intelifix - Total duration: 19s540ms - Times executed: 120 ]
[ Application: [unknown] - Total duration: 19s540ms - Times executed: 120 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-16 10:03:09 Duration: 200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0185;
Date: 2026-07-16 15:27:11 Duration: 198ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-16 13:54:31 Duration: 191ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 118 23s618ms 150ms 384ms 200ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 01 5 852ms 170ms 05 16 3s872ms 242ms 07 8 1s691ms 211ms 08 10 1s871ms 187ms 09 12 2s206ms 183ms 10 11 2s237ms 203ms 11 13 2s617ms 201ms 12 10 1s933ms 193ms 13 1 182ms 182ms 14 14 2s684ms 191ms 15 14 2s768ms 197ms 16 4 699ms 174ms [ User: intelifix - Total duration: 23s618ms - Times executed: 118 ]
[ Application: [unknown] - Total duration: 23s618ms - Times executed: 118 ]
-
SELECT * FROM RS_TRIAGEM (405, 5, '113', 3, '229808185757,229673100117,229741542329,229806710115,229734685868,229748051528,216944449814,229781567076,229670211215,229744713940,229674079920,229813798190,229687193961,229814780925', NULL, NULL, 0141, 00);
Date: 2026-07-16 11:11:23 Duration: 384ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241760776078,241743922537,241744557783,241740884047,241745305062,241738737800,241748103046,241743855560,241763846770,241743771232,241762058391,241762097587,241740909302,241759802841', NULL, NULL, 0464, 00);
Date: 2026-07-16 15:27:41 Duration: 343ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241770228000,241741171225,241740710619,241742771325,241777722132,241779156379,241770016991,241765317183,241770164963,241738042446', NULL, NULL, 0464, 00);
Date: 2026-07-16 05:05:39 Duration: 334ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 113 52s880ms 265ms 800ms 467ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 16 01 2 938ms 469ms 03 1 457ms 457ms 04 1 421ms 421ms 05 3 1s241ms 413ms 06 1 375ms 375ms 07 6 2s735ms 455ms 08 12 5s72ms 422ms 09 10 5s203ms 520ms 10 9 4s279ms 475ms 11 10 5s275ms 527ms 12 4 1s561ms 390ms 13 11 5s548ms 504ms 14 12 5s837ms 486ms 15 10 4s809ms 480ms 16 12 5s418ms 451ms 17 5 2s140ms 428ms 21 3 1s123ms 374ms 23 1 439ms 439ms [ User: lenon - Total duration: 52s880ms - Times executed: 113 ]
[ Application: [unknown] - Total duration: 52s880ms - Times executed: 113 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-16 14:00:22 Duration: 800ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-16 11:13:27 Duration: 792ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-16 15:27:39 Duration: 706ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
13 104 43s243ms 207ms 667ms 415ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 16 07 3 1s130ms 376ms 08 10 4s15ms 401ms 09 5 2s380ms 476ms 10 6 2s717ms 452ms 11 10 4s172ms 417ms 12 3 1s149ms 383ms 13 6 2s310ms 385ms 14 19 8s241ms 433ms 15 13 5s268ms 405ms 16 10 4s279ms 427ms 17 19 7s576ms 398ms [ User: intelifix - Total duration: 43s243ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 43s243ms - Times executed: 104 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-16 10:00:47 Duration: 667ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-16 09:56:18 Duration: 660ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-07-16 14:56:56 Duration: 632ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
14 102 59s713ms 299ms 937ms 585ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 16 01 2 1s205ms 602ms 03 1 656ms 656ms 04 1 561ms 561ms 05 3 1s504ms 501ms 07 4 2s345ms 586ms 08 10 5s333ms 533ms 09 10 6s269ms 626ms 10 9 5s174ms 574ms 11 10 6s370ms 637ms 12 3 1s495ms 498ms 13 11 6s783ms 616ms 14 11 6s438ms 585ms 15 10 6s118ms 611ms 16 12 6s765ms 563ms 17 4 2s222ms 555ms 21 1 466ms 466ms [ User: intelifix - Total duration: 59s713ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 59s713ms - Times executed: 102 ]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-07-16 11:13:27 Duration: 937ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (508, 18, 1);
Date: 2026-07-16 14:00:22 Duration: 915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 19, 1);
Date: 2026-07-16 15:27:39 Duration: 870ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 96 15m52s 1s685ms 35s711ms 9s918ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 16 07 2 11s225ms 5s612ms 09 7 1m15s 10s749ms 10 5 1m4s 12s898ms 11 6 1m28s 14s817ms 12 5 21s661ms 4s332ms 13 5 1m4s 12s873ms 14 12 1m25s 7s94ms 15 22 4m11s 11s452ms 16 13 2m40s 12s350ms 17 19 2m8s 6s768ms [ User: intelifix - Total duration: 15m52s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 15m52s - Times executed: 96 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 09:50:32 Duration: 35s711ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 13:21:00 Duration: 32s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 10:26:39 Duration: 30s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 79 20s207ms 152ms 1s144ms 255ms create table temp0000236290 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 16 13 7 2s330ms 332ms 14 15 3s560ms 237ms 15 14 3s443ms 245ms 16 10 3s17ms 301ms 17 33 7s855ms 238ms [ User: intelifix - Total duration: 20s207ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 20s207ms - Times executed: 79 ]
-
CREATE TABLE temp0000236290 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "11-07-2026", "data-ate" : "16-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-16 13:32:03 Duration: 1s144ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236290 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "16-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-16 16:34:33 Duration: 451ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236290 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "16-07-2026", "data-ate" : "16-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "N", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-16 16:44:29 Duration: 383ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
17 77 17m2s 9s963ms 31s802ms 13s278ms create table temp0000285528 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 16 07 11 2m19s 12s673ms 08 15 3m4s 12s268ms 09 6 1m22s 13s831ms 10 6 1m16s 12s818ms 11 14 3m11s 13s680ms 12 2 22s293ms 11s146ms 14 5 1m17s 15s497ms 15 12 2m51s 14s331ms 16 6 1m15s 12s641ms [ User: intelifix - Total duration: 17m2s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 77 ]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 07:14:50 Duration: 31s802ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 11:24:05 Duration: 29s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 15:29:53 Duration: 22s248ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 72 36s706ms 312ms 2s38ms 509ms create table temp0000226646 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 16 11 72 36s706ms 509ms [ User: intelifix - Total duration: 36s706ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 36s706ms - Times executed: 72 ]
-
CREATE TABLE temp0000226646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-16 11:15:18 Duration: 2s38ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-16 11:22:03 Duration: 896ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226646 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 02);
Date: 2026-07-16 11:21:29 Duration: 703ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 70 2m39s 182ms 1m 2s279ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 16 07 5 2s366ms 473ms 08 8 21s668ms 2s708ms 09 8 1m9s 8s690ms 10 2 1s55ms 527ms 11 5 2s204ms 440ms 12 2 1s331ms 665ms 13 1 1s338ms 1s338ms 14 14 36s705ms 2s621ms 15 8 3s522ms 440ms 16 5 7s662ms 1s532ms 17 12 12s161ms 1s13ms [ User: intelifix - Total duration: 2m39s - Times executed: 70 ]
[ Application: psql - Total duration: 2m39s - Times executed: 70 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027130);
Date: 2026-07-16 09:59:20 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027147);
Date: 2026-07-16 14:46:07 Duration: 21s250ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027117);
Date: 2026-07-16 08:15:00 Duration: 12s509ms Database: rio User: intelifix Remote: [local] Application: psql
20 67 18s339ms 156ms 3s672ms 273ms create table temp0000285552 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 16 08 3 4s35ms 1s345ms 09 9 1s875ms 208ms 10 10 2s147ms 214ms 11 6 1s258ms 209ms 12 6 1s358ms 226ms 13 2 536ms 268ms 14 14 3s617ms 258ms 15 9 1s904ms 211ms 16 8 1s606ms 200ms [ User: intelifix - Total duration: 18s339ms - Times executed: 67 ]
[ Application: [unknown] - Total duration: 18s339ms - Times executed: 67 ]
-
CREATE TABLE temp0000285552 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 08:22:13 Duration: 3s672ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285552 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"1551", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 11:26:08 Duration: 335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285552 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"1551", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 14:55:51 Duration: 329ms 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 2m7s 7m36s 4m34s 3 13m43s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 16 05 3 13m43s 4m34s [ User: intelifix - Total duration: 13m43s - Times executed: 3 ]
[ Application: psql - Total duration: 13m43s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-16 05:07:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-16 05:11:37 Duration: 3m59s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-16 05:13:44 Duration: 2m7s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s332ms 9m35s 2m39s 48 2h7m31s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 16 07 3 8m27s 2m49s 08 3 7m39s 2m33s 09 3 9m21s 3m7s 10 3 10m11s 3m23s 11 3 8m36s 2m52s 12 3 7m55s 2m38s 13 3 6m35s 2m11s 14 3 9m2s 3m 15 3 9m24s 3m8s 16 3 9m9s 3m3s 17 3 9m15s 3m5s 18 3 6m38s 2m12s 19 3 6m8s 2m2s 20 3 6m46s 2m15s 21 3 6m5s 2m1s 22 3 6m13s 2m4s [ User: intelifix - Total duration: 2h7m31s - Times executed: 48 ]
[ Application: psql - Total duration: 2h7m31s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-16 10:14:36 Duration: 9m35s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-16 17:13:50 Duration: 8m49s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-16 15:13:49 Duration: 8m47s Database: rio User: intelifix Remote: [local] Application: psql
3 230ms 4m40s 1m33s 48 1h14m36s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 16 07 3 4m39s 1m33s 08 3 4m40s 1m33s 09 3 5m27s 1m49s 10 3 5m35s 1m51s 11 3 5m3s 1m41s 12 3 4m30s 1m30s 13 3 4m19s 1m26s 14 3 5m27s 1m49s 15 3 5m26s 1m48s 16 3 5m3s 1m41s 17 3 4m36s 1m32s 18 3 3m50s 1m16s 19 3 3m56s 1m18s 20 3 3m58s 1m19s 21 3 3m46s 1m15s 22 3 4m14s 1m24s [ User: intelifix - Total duration: 1h14m36s - Times executed: 48 ]
[ Application: psql - Total duration: 1h14m36s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-16 14:19:28 Duration: 4m40s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-16 15:19:48 Duration: 4m37s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-16 10:20:43 Duration: 4m30s Database: brasilia User: intelifix Remote: [local] Application: psql
4 1s503ms 1m58s 1m6s 10 11m6s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 16 11 3 5m15s 1m45s 13 1 1m58s 1m58s 14 2 9s591ms 4s795ms 15 2 10s811ms 5s405ms 16 2 3m31s 1m45s [ User: intelifix - Total duration: 11m6s - Times executed: 10 ]
[ Application: psql - Total duration: 11m6s - Times executed: 10 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01559);
Date: 2026-07-16 13:26:19 Duration: 1m58s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01560);
Date: 2026-07-16 16:31:26 Duration: 1m49s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01558);
Date: 2026-07-16 11:39:24 Duration: 1m45s Database: contagem User: intelifix Remote: [local] Application: psql
5 6s210ms 1m48s 44s655ms 3 2m13s copy auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 16 23 3 2m13s 44s655ms [ User: intelifix - Total duration: 2m13s - Times executed: 3 ]
[ Application: pg_dump - Total duration: 2m13s - Times executed: 3 ]
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-16 23:14:54 Duration: 1m48s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-16 23:48:46 Duration: 19s535ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_06 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) TO stdout;
Date: 2026-07-16 23:38:13 Duration: 6s210ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 4s618ms 1m26s 44s467ms 4 2m57s 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 16 20 2 1m26s 43s173ms 23 2 1m31s 45s760ms [ User: intelifix - Total duration: 2m57s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m57s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-16 23:37:37 Duration: 1m26s 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-16 20:08:41 Duration: 1m21s 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-16 23:47:40 Duration: 4s869ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
7 11s146ms 15s582ms 13s524ms 18 4m3s create table temp0000285584 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 16 14 10 2m19s 13s937ms 15 8 1m44s 13s8ms [ User: intelifix - Total duration: 4m3s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 4m3s - Times executed: 18 ]
-
CREATE TABLE temp0000285584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 15:06:19 Duration: 15s582ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 14:57:47 Duration: 15s80ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285584 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 14:58:10 Duration: 14s858ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 150ms 6m8s 13s493ms 394 1h28m36s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 16 07 26 9m49s 22s678ms 08 40 6m44s 10s108ms 09 18 11m17s 37s626ms 10 24 5m54s 14s776ms 11 34 10m53s 19s227ms 12 9 9m54s 1m6s 13 27 56s171ms 2s80ms 14 43 2m41s 3s754ms 15 65 19m21s 17s875ms 16 55 8m14s 8s990ms 17 53 2m47s 3s166ms [ User: intelifix - Total duration: 1h28m36s - Times executed: 394 ]
[ Application: [unknown] - Total duration: 1h28m36s - Times executed: 394 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027152, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 15:03:12 Duration: 6m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027133, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 11:30:53 Duration: 6m5s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027161, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-16 15:37:54 Duration: 5m59s Database: rio User: intelifix Remote: [local] Application: [unknown]
9 9s963ms 31s802ms 13s278ms 77 17m2s create table temp0000285528 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 16 07 11 2m19s 12s673ms 08 15 3m4s 12s268ms 09 6 1m22s 13s831ms 10 6 1m16s 12s818ms 11 14 3m11s 13s680ms 12 2 22s293ms 11s146ms 14 5 1m17s 15s497ms 15 12 2m51s 14s331ms 16 6 1m15s 12s641ms [ User: intelifix - Total duration: 17m2s - Times executed: 77 ]
[ Application: [unknown] - Total duration: 17m2s - Times executed: 77 ]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 07:14:50 Duration: 31s802ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 11:24:05 Duration: 29s540ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 15:29:53 Duration: 22s248ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s805ms 16s180ms 12s873ms 14 3m create table temp0000285498 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 16 08 8 1m36s 12s75ms 09 5 1m7s 13s487ms 10 1 16s180ms 16s180ms [ User: intelifix - Total duration: 3m - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m - Times executed: 14 ]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 10:00:32 Duration: 16s180ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 09:58:35 Duration: 15s10ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 09:58:08 Duration: 14s208ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s368ms 16s396ms 12s703ms 38 8m2s create table temp0000285576 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 16 12 3 37s756ms 12s585ms 13 3 41s268ms 13s756ms 14 8 1m43s 12s902ms 16 5 1m7s 13s546ms 17 19 3m52s 12s250ms [ User: intelifix - Total duration: 8m2s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 8m2s - Times executed: 38 ]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 14:05:26 Duration: 16s396ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 17:02:10 Duration: 15s400ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285576 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-16 16:45:36 Duration: 15s230ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 1s685ms 35s711ms 9s918ms 96 15m52s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 16 07 2 11s225ms 5s612ms 09 7 1m15s 10s749ms 10 5 1m4s 12s898ms 11 6 1m28s 14s817ms 12 5 21s661ms 4s332ms 13 5 1m4s 12s873ms 14 12 1m25s 7s94ms 15 22 4m11s 11s452ms 16 13 2m40s 12s350ms 17 19 2m8s 6s768ms [ User: intelifix - Total duration: 15m52s - Times executed: 96 ]
[ Application: [unknown] - Total duration: 15m52s - Times executed: 96 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 09:50:32 Duration: 35s711ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 13:21:00 Duration: 32s668ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-16', 0175, '', '', 0, 6, '2026-07-01');
Date: 2026-07-16 10:26:39 Duration: 30s292ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 765ms 14s488ms 4s400ms 37 2m42s call rs_tcia_processa_lotes () / usr / lib / python3. ? / site - packages / urllib3 / connectionpool.py : ? : insecurerequestwarning: unverified https request is being made to host ?.adding certificate verification is strongly advised. see: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 16 08 2 13s619ms 6s809ms 09 3 15s991ms 5s330ms 10 3 30s566ms 10s188ms 11 2 10s444ms 5s222ms 12 3 13s893ms 4s631ms 13 3 10s77ms 3s359ms 14 3 24s152ms 8s50ms 15 2 13s751ms 6s875ms 16 2 13s418ms 6s709ms 17 3 5s493ms 1s831ms 18 1 1s314ms 1s314ms 19 3 3s57ms 1s19ms 20 3 3s150ms 1s50ms 21 3 2s829ms 943ms 22 1 1s73ms 1s73ms [ User: intelifix - Total duration: 2m42s - Times executed: 37 ]
[ Application: psql - Total duration: 2m42s - Times executed: 37 ]
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-16 10:20:16 Duration: 14s488ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-16 14:20:10 Duration: 9s783ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES () / usr / lib / python3.9 / site - packages / urllib3 / connectionpool.py :1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'.Adding certificate verification is strongly advised. See: https: // urllib3.readthedocs.io / en / latest / advanced - usage.html # ssl - warnings warnings.warn (;
Date: 2026-07-16 10:00:11 Duration: 9s769ms Database: rio User: intelifix Remote: [local] Application: psql
14 2s700ms 8s654ms 4s17ms 36 2m24s create table temp0000285528 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 16 07 4 17s200ms 4s300ms 08 8 26s108ms 3s263ms 09 4 14s419ms 3s604ms 11 6 22s533ms 3s755ms 15 2 10s311ms 5s155ms 16 12 54s57ms 4s504ms [ User: intelifix - Total duration: 2m24s - Times executed: 36 ]
[ Application: [unknown] - Total duration: 2m24s - Times executed: 36 ]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 07:23:48 Duration: 8s654ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 16:24:23 Duration: 7s798ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285528 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"11-07-2026", "ate" :"16-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-16 15:04:07 Duration: 6s145ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 153ms 2m57s 3s708ms 275 16m59s call rs_giga_triagem (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 16 00 12 33s795ms 2s816ms 01 12 25s78ms 2s89ms 02 12 27s774ms 2s314ms 03 12 34s955ms 2s912ms 04 12 25s398ms 2s116ms 05 12 27s612ms 2s301ms 06 12 30s368ms 2s530ms 07 12 28s864ms 2s405ms 08 12 31s400ms 2s616ms 09 12 2m26s 12s228ms 10 12 33s461ms 2s788ms 11 12 32s480ms 2s706ms 12 12 3m25s 17s91ms 13 12 31s379ms 2s614ms 14 12 33s749ms 2s812ms 15 12 41s21ms 3s418ms 16 12 39s270ms 3s272ms 17 12 34s333ms 2s861ms 18 11 28s896ms 2s626ms 19 12 28s794ms 2s399ms 20 12 41s147ms 3s428ms 21 12 29s307ms 2s442ms 22 12 28s797ms 2s399ms [ User: intelifix - Total duration: 16m59s - Times executed: 275 ]
[ Application: psql - Total duration: 16m59s - Times executed: 275 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 12:18:04 Duration: 2m57s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 09:47:07 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-16 20:05:13 Duration: 11s607ms Database: rio User: intelifix Remote: [local] Application: psql
16 195ms 12s87ms 2s596ms 159 6m52s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 16 00 5 18s718ms 3s743ms 01 6 8s633ms 1s438ms 02 6 7s471ms 1s245ms 03 5 9s311ms 1s862ms 04 6 9s703ms 1s617ms 05 3 3s327ms 1s109ms 06 3 4s346ms 1s448ms 07 10 25s662ms 2s566ms 08 12 35s548ms 2s962ms 09 12 39s182ms 3s265ms 10 12 38s404ms 3s200ms 11 12 40s283ms 3s356ms 12 11 36s108ms 3s282ms 13 8 11s54ms 1s381ms 14 12 35s63ms 2s921ms 15 12 44s813ms 3s734ms 16 10 27s987ms 2s798ms 17 5 4s682ms 936ms 20 1 195ms 195ms 21 3 5s347ms 1s782ms 22 5 6s982ms 1s396ms [ User: intelifix - Total duration: 6m52s - Times executed: 159 ]
[ Application: psql - Total duration: 6m52s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 00:05:13 Duration: 12s87ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 15:05:09 Duration: 8s190ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-16 12:35:09 Duration: 8s159ms Database: rio User: intelifix Remote: [local] Application: psql
17 182ms 1m 2s279ms 70 2m39s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 16 07 5 2s366ms 473ms 08 8 21s668ms 2s708ms 09 8 1m9s 8s690ms 10 2 1s55ms 527ms 11 5 2s204ms 440ms 12 2 1s331ms 665ms 13 1 1s338ms 1s338ms 14 14 36s705ms 2s621ms 15 8 3s522ms 440ms 16 5 7s662ms 1s532ms 17 12 12s161ms 1s13ms [ User: intelifix - Total duration: 2m39s - Times executed: 70 ]
[ Application: psql - Total duration: 2m39s - Times executed: 70 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027130);
Date: 2026-07-16 09:59:20 Duration: 1m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027147);
Date: 2026-07-16 14:46:07 Duration: 21s250ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027117);
Date: 2026-07-16 08:15:00 Duration: 12s509ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 4s630ms 778ms 1,659 21m31s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 16 07 16 7s567ms 472ms 08 161 2m8s 798ms 09 199 2m41s 810ms 10 248 2m54s 703ms 11 197 2m36s 794ms 12 50 39s103ms 782ms 13 91 1m2s 692ms 14 251 3m25s 819ms 15 201 2m19s 694ms 16 172 2m28s 864ms 17 73 1m7s 920ms [ User: intelifix - Total duration: 21m31s - Times executed: 1659 ]
[ Application: [unknown] - Total duration: 21m31s - Times executed: 1659 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (266991, 503, '929240109914,CC5830FF377F,A4224991B48F,2035431A4F26,2035435A35CE,2035435A379C,203543594B01,9C24722FCB2E,203543168671,203543572239,D8CF6165C2AB,9C24722FFE34,CC583000A19A,20354357211A,B0924A114D90,CC5830FED9B5,203543594E2D,9C247233716F,64FA2B6447CD,2035431D2EC0,203543136EAD,9C24723175EF,CC5830FF68E8,B01FF41ACB66,CC583000FD1F,CC583000FF4F,D8CF61663185,D8CF61659C16,441524E43129,CC5830FF2779,20354319A8B5,B01FF41CCBD2,20354316C826,B01FF41A761D,D8CF61659023,B01FF41CEEE0,B01FF41A766A,203543197C0E,DC92726F4432,2035431D2E50,2035431D2F99', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"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-16 11:41:18 Duration: 4s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (265485, 452, '71802585850050501288,216833648810,216878275454,216832781520,216696207079,184270843144,216949064058,216908196567,216354890717,216838646783,216355218706,216838260001,216614115465,216819390101,216501116367,216561121416,216909561920,216501121217,216335391227,216834927688,216402997588H010948190,216630594043,216552560424,216818753439,216875770710,216395605565,216731471734,216834989614,216514307688,216514341430,216548341123,216550899812,216800493251,216353262533,216688768283,216351815051,216620078291,216732805466,216835511719,216355240426', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"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-16 10:46:58 Duration: 4s571ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (266991, 503, '929240498443,D8CF6166DC2C,2035431D242B,203543136D72,B01FF41AADE5,B01FF41AB483,2035431692F7,441524E6FF4A,203543549E32,B01FF41C9C92,20354313490D,20354319729F,A42249915ABC,D8CF61661960,2035431F4A45,9C24722FDFB0,2035431D3702,B01FF41A22C5,203543159289,CC5830FDE851,203543199591,B01FF41A330A,647B1EEE1661,20354316C849,203543152220,441524E6FBED,2035431D261C,20354358F388,B01FF41AC507,5447CCCB1E3C,B01FF41CE95A,CC583001C58D,2035431D175F,2035431C950D,20354319A822,B01FF41A7671,B01FF41ACF1E,2035431C9E4B,2035431C94DC,203543168C0C,2035431F5822', '',0302,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"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-16 14:33:06 Duration: 4s525ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 152ms 9s597ms 658ms 148 1m37s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 16 07 19 9s943ms 523ms 08 17 9s857ms 579ms 09 2 607ms 303ms 10 12 6s817ms 568ms 11 10 3s667ms 366ms 13 18 9s349ms 519ms 14 10 26s598ms 2s659ms 15 22 12s182ms 553ms 16 16 5s96ms 318ms 17 22 13s357ms 607ms [ User: intelifix - Total duration: 1m37s - Times executed: 148 ]
[ Application: [unknown] - Total duration: 1m37s - Times executed: 148 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128444) LIMIT 1;
Date: 2026-07-16 14:47:53 Duration: 9s597ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128444) LIMIT 1;
Date: 2026-07-16 14:48:23 Duration: 6s777ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0128444) LIMIT 1;
Date: 2026-07-16 14:48:07 Duration: 6s463ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 299ms 937ms 585ms 102 59s713ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 16 01 2 1s205ms 602ms 03 1 656ms 656ms 04 1 561ms 561ms 05 3 1s504ms 501ms 07 4 2s345ms 586ms 08 10 5s333ms 533ms 09 10 6s269ms 626ms 10 9 5s174ms 574ms 11 10 6s370ms 637ms 12 3 1s495ms 498ms 13 11 6s783ms 616ms 14 11 6s438ms 585ms 15 10 6s118ms 611ms 16 12 6s765ms 563ms 17 4 2s222ms 555ms 21 1 466ms 466ms [ User: intelifix - Total duration: 59s713ms - Times executed: 102 ]
[ Application: [unknown] - Total duration: 59s713ms - Times executed: 102 ]
-
select * from rs_menu_grants (304, 18, 1);
Date: 2026-07-16 11:13:27 Duration: 937ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (508, 18, 1);
Date: 2026-07-16 14:00:22 Duration: 915ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (414, 19, 1);
Date: 2026-07-16 15:27:39 Duration: 870ms 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 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 16 13 1 0ms 0ms 18 1 0ms 0ms 22 1 0ms 0ms [ User: intelifix - Total duration: 1s156ms - Times executed: 3 ]
[ Application: psql - Total duration: 969ms - Times executed: 2 ]
[ Application: [unknown] - Total duration: 187ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 20,471 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
- 4384 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,257 Max number of times the same event was reported
- 4,416 Total events found
Rank Times reported Error 1 4,257 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 16 00 60 01 59 02 59 03 53 04 58 05 58 06 60 07 243 08 337 09 405 10 457 11 468 12 168 13 186 14 411 15 433 16 266 17 129 18 59 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN0000000029A7EF40" does not exist
- ERROR: prepared statement "_PLAN0000000029A82A90" does not exist
- ERROR: prepared statement "_PLAN0000000029A57730" does not exist
Statement: DEALLOCATE "_PLAN0000000029A7EF40"
Date: 2026-07-16 00:00:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A82A90"
Date: 2026-07-16 00:01:15 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A57730"
Date: 2026-07-16 00:02:16 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 16 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-16 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-16 00:35:01 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-16 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 16 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-16 08:00:06 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-16 08:20:10 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-16 08:40:09 Database: brasilia Application: psql User: intelifix Remote: [local]
4 11 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 16 09 1 10 8 15 2 - ERROR: trailing junk after numeric literal at or near "1FROM" at character 116
- ERROR: trailing junk after numeric literal at or near "83350052682545B" at character 27
- ERROR: trailing junk after numeric literal at or near "83350052682545B" at character 27
Statement: INSERT INTO TCIA_LOTE_FLUXOS SELECT 126479, FLU_ID FROM CAIXA_ITENS A WHERE CAI_ID= 3271135 AND NOT EXISTS( SELECT 1FROM TCIA_LOTE_FLUXOS C WHERE C.FLU_ID=A.FLU_ID)
Date: 2026-07-16 09:12:37 Database: rio Application: pgAdmin 4 - CONN:1718181 User: lenon Remote: 172.20.0.3
Statement: SELECT * FROM RS_ETIQUETA(83350052682545B)
Date: 2026-07-16 10:19:55 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(83350052682545B)
Date: 2026-07-16 10:19:55 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 9 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 16 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-16 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-16 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 16 00 1 06 2 09 3 19 1 20 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-16 00:02:14 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-16 06:02:15 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-16 06:17:55 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
7 8 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 16 09 1 13 2 15 5 - ERROR: syntax error at or near "WHERE" at character 93
- ERROR: syntax error at or near "6" at character 35
- ERROR: syntax error at or near "6" at character 35
Statement: INSERT INTO TCIA_LOTE_FLUXOS SELECT 126479, FLU_ID FROM CAIXA_ITENS A WHERE CAI_ID= 3271135 WHERE NOT EXISTS( SELECT 1FROM TCIA_LOTE_FLUXOS C WHERE C.FLU_ID=A.FLU_ID)
Date: 2026-07-16 09:12:24 Database: rio Application: pgAdmin 4 - CONN:1718181 User: lenon Remote: 172.20.0.3
Statement: SELECT RS_SERIAL_TEMPORARIO( ' 75'6\' ) OR RS_SERIAL_TEMPORARIO_VIVO( ' 75'6\' )
Date: 2026-07-16 13:36:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ' 75'6\' ) OR RS_SERIAL_TEMPORARIO_VIVO( ' 75'6\' )
Date: 2026-07-16 13:36:04 Database: rio Application: [unknown] User: intelifix Remote: [local]
8 6 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 16 09 3 12 3 - LOG: process 3910412 still waiting for ShareLock on transaction 2782239 after 1000.279 ms
- LOG: process 3910412 still waiting for ShareLock on transaction 2782239 after 5025.277 ms
- LOG: process 3910412 still waiting for ShareLock on transaction 2782239 after 22386.725 ms
Detail: Process holding the lock: 3923394. Wait queue: 3910412.
Context: while updating tuple (73786,18) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-16 09:45:13 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3923394. Wait queue: 3910412.
Context: while updating tuple (73786,18) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-16 09:45:17 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3923394. Wait queue: 3910412.
Context: while updating tuple (73786,18) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-16 09:45:34 Database: rio Application: psql User: intelifix Remote: [local]
9 4 ERROR: malformed array literal: "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 16 09 4 - ERROR: malformed array literal: "{0,}" at character 112
- ERROR: malformed array literal: "{0,0,}" at character 112
- ERROR: malformed array literal: "{0,0,0,}" at character 112
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,}', 141 ));Date: 2026-07-16 09:24:59 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,}', 141 ));Date: 2026-07-16 09:24:59 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Unexpected "}" character.
Statement: SELECT WF_ID,WF_NOME FROM WORK_FLOWS WHERE WF_ID IN (SELECT UNNEST(RS_DEFINE_WORKFLOW) FROM RS_DEFINE_WORKFLOW('{0,0,0,}', 141 ));Date: 2026-07-16 09:25:00 Database: contagem Application: [unknown] User: intelifix Remote: [local]
10 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 16 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-16 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-16 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-16 05:32:09 Database: contagem Application: psql User: intelifix Remote: [local]
11 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 16 09 1 14 1 17 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000285540"
Date: 2026-07-16 09:43:08
Context: automatic vacuum of table "rio.public.temp0000285576"
Date: 2026-07-16 14:15:11
Context: automatic vacuum of table "rio.public.temp0000285576"
Date: 2026-07-16 17:20:12
12 3 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 16 09 3 - ERROR: column "op3282211" does not exist at character 27
- ERROR: column "op3282211" does not exist at character 27
- ERROR: column "lot_id" does not exist at character 37
Statement: select * from rs_caixa_qr(op3282211 )
Date: 2026-07-16 09:09:35 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(op3282211 )
Date: 2026-07-16 09:09:36 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Hint: Perhaps you meant to reference the column "tcia_lote_fluxos.tl_id" or the column "tcia_lote_fluxos.flu_id".
Statement: select *From tcia_lote_fluxos where lot_id= 265684Date: 2026-07-16 09:10:37 Database: rio Application: pgAdmin 4 - CONN:1718181 User: lenon Remote: 172.20.0.3
13 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 16 09 1 14 1 17 1 - LOG: process 3952407 still waiting for AccessExclusiveLock on relation 2517109 of database 358220 after 1000.183 ms
- LOG: process 4175073 still waiting for AccessExclusiveLock on relation 2548162 of database 358220 after 1000.133 ms
- LOG: process 170003 still waiting for AccessExclusiveLock on relation 2581082 of database 358220 after 1000.207 ms
Detail: Process holding the lock: 3957355. Wait queue: 3952407.
Statement: DROP TABLE IF EXISTS temp0000285540;Date: 2026-07-16 09:43:08 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 4192964. Wait queue: 4175073.
Statement: DROP TABLE IF EXISTS temp0000285576;Date: 2026-07-16 14:15:11 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 192494. Wait queue: 170003.
Statement: DROP TABLE IF EXISTS temp0000285576;Date: 2026-07-16 17:20:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
14 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 16 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-16 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-16 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-16 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
15 2 ERROR: unterminated quoted identifier at or near ""..."
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 16 15 2 - ERROR: unterminated quoted identifier at or near ""}]}');" at character 98
- ERROR: unterminated quoted identifier at or near ""}]}')" at character 107
Statement: SELECT * FROM RS_CASA_MASCARAS('{"modelo":"155","seriais":[{"serial":"920381015915"},{"serial":"'"}]}');
Date: 2026-07-16 15:07:56 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"266987","seriais":[{"serial":"920381015915"},{"serial":"'"}]}')
Date: 2026-07-16 15:07:56 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 16 20 1 - FATAL: database "jaboatao" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-07-16 20:59:51 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
17 1 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 16 09 1 - ERROR: duplicate key value violates unique constraint "tcia_lote_fluxos_pkey"
Detail: Key (tl_id, flu_id)=(126479, 6028877) already exists.
Statement: INSERT INTO TCIA_LOTE_FLUXOS SELECT 126479, FLU_ID FROM CAIXA_ITENS WHERE CAI_ID= 3271135Date: 2026-07-16 09:11:57 Database: rio Application: pgAdmin 4 - CONN:1718181 User: lenon Remote: 172.20.0.3
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 16 03 1 - LOG: database system was shut down at 2026-07-16 03:05:01 -03
Date: 2026-07-16 03:05:02