pgBadger-
Global information
- Generated on Wed Jul 15 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 58,007 log entries in 8s
- Log start from 2026-07-15 00:00:14 to 2026-07-15 23:49:10
-
Overview
Global Stats
- 441 Number of unique normalized queries
- 6,924 Number of queries
- 8h46m41s Total query duration
- 2026-07-15 00:02:11 First query
- 2026-07-15 23:48:49 Last query
- 6 queries/s at 2026-07-15 10:35:13 Query peak
- 8h46m41s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h46m41s Execute total duration
- 7,521 Number of events
- 37 Number of unique normalized events
- 4,621 Max number of times the same event was reported
- 0 Number of cancellation
- 482 Total number of automatic vacuums
- 1,018 Total number of automatic analyzes
- 20 Number temporary file
- 235.30 MiB Max size of temporary file
- 145.71 MiB Average size of temporary file
- 456 Total number of sessions
- 12 sessions at 2026-07-15 16:27:22 Session peak
- 15d21h21m5s Total duration of sessions
- 50m10s Average duration of sessions
- 15 Average queries per session
- 1m9s Average queries duration per session
- 49m1s Average idle time per session
- 463 Total number of connections
- 7 connections/s at 2026-07-15 03:05:16 Connection peak
- 5 Total number of databases
SQL Traffic
Key values
- 6 queries/s Query Peak
- 2026-07-15 10:35:13 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-15 10:35:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-15 23:48:36 Date
Queries duration
Key values
- 8h46m41s 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 15 00 27 0ms 17s242ms 4s192ms 5s211ms 6s266ms 1m11s 01 30 0ms 5s3ms 1s240ms 4s746ms 5s702ms 7s134ms 02 16 0ms 4s29ms 1s977ms 3s957ms 5s184ms 7s27ms 03 18 0ms 4s734ms 1s945ms 4s432ms 5s669ms 8s194ms 04 17 0ms 4s35ms 1s923ms 4s72ms 5s990ms 7s514ms 05 53 0ms 7m52s 19s558ms 7s913ms 2m23s 7m53s 06 20 0ms 8s586ms 3s130ms 3s781ms 4s291ms 30s545ms 07 165 0ms 8m32s 11s581ms 57s149ms 4m42s 8m40s 08 637 0ms 7m1s 3s542ms 1m17s 4m36s 7m56s 09 884 150ms 9m28s 2s757ms 1m 1m57s 9m59s 10 717 150ms 9m33s 2s603ms 47s21ms 1m25s 9m54s 11 696 150ms 9m11s 3s880ms 1m58s 4m3s 9m16s 12 295 0ms 8m49s 7s976ms 1m18s 6m8s 8m52s 13 509 0ms 9m1s 3s740ms 1m42s 1m54s 9m2s 14 698 150ms 7m23s 2s378ms 44s376ms 3m38s 7m28s 15 658 150ms 10m34s 4s86ms 1m12s 5m29s 11m3s 16 577 150ms 8m47s 2s744ms 36s65ms 1m53s 8m56s 17 252 0ms 8m11s 5s683ms 22s843ms 1m50s 8m49s 18 115 0ms 6m19s 14s645ms 1m12s 1m58s 6m49s 19 23 0ms 7m5s 33s872ms 4s691ms 28s705ms 7m58s 20 119 0ms 7m4s 11s28ms 1m7s 1m20s 7m51s 21 34 0ms 6m42s 21s43ms 6s133ms 53s834ms 6m42s 22 27 0ms 5m46s 24s65ms 5s623ms 45s606ms 5m46s 23 337 0ms 2m4s 6s877ms 1m21s 1m49s 2m28s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 00 5 0 2s687ms 0ms 0ms 285ms 01 13 0 330ms 0ms 179ms 1s149ms 02 0 0 0ms 0ms 0ms 0ms 03 0 0 0ms 0ms 0ms 0ms 04 0 0 0ms 0ms 0ms 0ms 05 31 0 271ms 360ms 597ms 960ms 06 5 0 2s434ms 0ms 0ms 809ms 07 108 0 15s432ms 4s398ms 26s632ms 7m19s 08 476 0 3s615ms 17s181ms 37s90ms 5m11s 09 658 0 2s499ms 18s293ms 39s224ms 4m52s 10 568 0 2s572ms 17s15ms 41s78ms 4m35s 11 476 0 4s478ms 19s248ms 1m53s 7m45s 12 193 0 10s14ms 5s929ms 1m3s 6m48s 13 382 0 3s954ms 11s792ms 1m41s 4m19s 14 529 0 2s740ms 12s843ms 32s315ms 4m44s 15 520 0 4s231ms 17s393ms 50s985ms 6m9s 16 437 0 3s55ms 11s547ms 23s495ms 4m28s 17 155 0 8s263ms 6s94ms 14s671ms 7m41s 18 13 85 16s729ms 55s376ms 1m12s 3m37s 19 7 0 1m44s 0ms 0ms 3m43s 20 14 85 12s690ms 19s634ms 1m3s 3m28s 21 11 0 1m1s 0ms 0ms 3m33s 22 6 0 1m41s 0ms 0ms 3m39s 23 9 328 6s877ms 1m7s 1m21s 2m28s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 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 14 8s456ms 0ms 0ms 2s583ms 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 2 1 0 0 1s131ms 0ms 0ms 608ms 21 1 3 0 0 2s166ms 0ms 0ms 510ms 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 15 00 0 1 1.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 4 4.00 0.00% 06 0 1 1.00 0.00% 07 0 11 11.00 0.00% 08 0 20 20.00 0.00% 09 0 20 20.00 0.00% 10 0 13 13.00 0.00% 11 0 13 13.00 0.00% 12 0 16 16.00 0.00% 13 0 12 12.00 0.00% 14 0 15 15.00 0.00% 15 0 12 12.00 0.00% 16 0 11 11.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 1 1.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jul 15 00 15 0.00/s 01 11 0.00/s 02 10 0.00/s 03 19 0.01/s 04 9 0.00/s 05 14 0.00/s 06 16 0.00/s 07 18 0.01/s 08 24 0.01/s 09 25 0.01/s 10 27 0.01/s 11 24 0.01/s 12 47 0.01/s 13 29 0.01/s 14 24 0.01/s 15 39 0.01/s 16 21 0.01/s 17 16 0.00/s 18 14 0.00/s 19 15 0.00/s 20 19 0.01/s 21 12 0.00/s 22 8 0.00/s 23 7 0.00/s Day Hour Count Average Duration Average idle time Jul 15 00 8 1h45s 1h31s 01 14 1h49s 1h46s 02 11 1h33s 1h30s 03 20 19m52s 19m50s 04 9 1h4m 1h3m56s 05 10 55m22s 53m39s 06 12 59m30s 59m25s 07 16 57m26s 55m27s 08 18 54m37s 52m32s 09 25 56m22s 54m44s 10 27 49m42s 48m33s 11 20 53m45s 51m30s 12 54 26m22s 25m38s 13 22 41m9s 39m43s 14 22 56m27s 55m11s 15 38 35m48s 34m38s 16 22 1h7m10s 1h5m58s 17 21 1h9m43s 1h8m35s 18 21 1h12m40s 1h11m20s 19 12 54m40s 53m35s 20 15 40m36s 39m9s 21 20 1h2m57s 1h2m21s 22 10 58m 56m55s 23 9 44m38s 40m21s -
Connections
Established Connections
Key values
- 7 connections Connection Peak
- 2026-07-15 03:05:16 Date
Connections per database
Key values
- rio Main Database
- 463 connections Total
Connections per user
Key values
- intelifix Main User
- 463 connections Total
-
Sessions
Simultaneous sessions
Key values
- 12 sessions Session Peak
- 2026-07-15 16:27:22 Date
Histogram of session times
Key values
- 318 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 456 sessions Total
Sessions per user
Key values
- intelifix Main User
- 456 sessions Total
Sessions per host
Key values
- [local] Main Host
- 456 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 456 sessions Total
Application Count Total Duration Average Duration [unknown] 369 13d14h11m43s 53m2s pgAdmin 4 - CONN:250295 3 19m2s 6m20s pgAdmin 4 - CONN:2701771 2 2m32s 1m16s pgAdmin 4 - CONN:3255731 4 7h47m46s 1h56m56s pgAdmin 4 - CONN:4208208 2 4s177ms 2s88ms pgAdmin 4 - CONN:4239752 2 5s394ms 2s697ms pgAdmin 4 - CONN:4732505 2 4s977ms 2s488ms pgAdmin 4 - CONN:6829152 2 6s948ms 3s474ms pgAdmin 4 - CONN:7085295 1 2h15m49s 2h15m49s pgAdmin 4 - CONN:8311409 5 5h18m42s 1h3m44s pgAdmin 4 - DB:brasilia 2 20s318ms 10s159ms pgAdmin 4 - DB:contagem 2 21s274ms 10s637ms pgAdmin 4 - DB:postgres 16 17h10m13s 1h4m23s pgAdmin 4 - DB:rio 10 6h48m54s 40m53s pgAdmin 4 - DB:testes 11 21m36s 1m57s pg_dump 9 2h2m43s 13m38s postgres_fdw 1 48m1s 48m1s psql 13 12h12m55s 56m22s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 30,248 buffers Checkpoint Peak
- 2026-07-15 12:16:47 Date
- 270.024 seconds Highest write time
- 1.396 seconds Sync time
Checkpoints Wal files
Key values
- 134 files Wal files usage Peak
- 2026-07-15 12:16:47 Date
Checkpoints distance
Key values
- 4,271.44 Mo Distance Peak
- 2026-07-15 12:16:47 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 15 00 18,757 649.294s 0.042s 649.394s 01 2,939 295.076s 0.054s 295.202s 02 1,340 134.564s 0.02s 134.615s 03 1,672 168.124s 0.026s 168.204s 04 2,193 220.237s 0.023s 220.295s 05 10,210 936.023s 0.061s 936.157s 06 6,774 372.912s 0.011s 372.945s 07 49,870 2,254.876s 0.271s 2,255.267s 08 62,953 3,138.92s 0.642s 3,139.814s 09 78,366 3,238.386s 0.859s 3,239.589s 10 62,960 3,238.697s 0.692s 3,239.657s 11 51,774 3,238.621s 0.89s 3,239.741s 12 84,790 2,347.139s 2.01s 2,350.182s 13 29,994 2,437.701s 0.389s 2,438.274s 14 49,680 3,238.551s 0.864s 3,239.679s 15 67,003 3,056.35s 0.885s 3,057.552s 16 47,397 3,110.786s 0.581s 3,111.628s 17 43,965 2,242.052s 0.369s 2,242.628s 18 2,331 491.027s 0.038s 491.125s 19 70 7.143s 0.016s 7.184s 20 2,635 269.891s 0.026s 269.958s 21 8,472 736.434s 0.057s 736.605s 22 2,231 224.335s 0.028s 224.408s 23 5,840 290.685s 0.033s 290.768s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 15 00 0 0 7 466 0.005s 0.008s 01 0 0 1 646 0.004s 0.013s 02 0 0 0 274 0.002s 0.006s 03 0 0 1 343 0.003s 0.006s 04 0 0 0 425 0.002s 0.006s 05 0 0 5 711 0.002s 0.009s 06 0 0 1 34 0.002s 0.003s 07 0 0 24 3,512 0.010s 0.012s 08 0 0 41 6,925 0.004s 0.012s 09 0 0 65 8,290 0.005s 0.012s 10 0 0 42 7,476 0.021s 0.012s 11 0 0 35 7,431 0.006s 0.012s 12 0 9 291 6,144 0.264s 0.015s 13 0 20 0 5,063 0.003s 0.011s 14 0 23 0 6,826 0.014s 0.012s 15 0 44 0 6,544 0.012s 0.012s 16 0 21 0 6,377 0.011s 0.012s 17 0 21 0 4,574 0.019s 0.013s 18 0 1 0 308 0.003s 0.008s 19 0 0 0 41 0.002s 0.006s 20 0 1 0 252 0.003s 0.007s 21 0 3 0 584 0.018s 0.026s 22 0 1 0 453 0.003s 0.007s 23 0 3 0 39 0.010s 0.007s Day Hour Count Avg time (sec) Jul 15 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 15 00 14,850.43 kB 50,333.14 kB 01 1,384.55 kB 23,349.73 kB 02 1,501.60 kB 10,565.40 kB 03 1,344.86 kB 2,822.71 kB 04 2,004.17 kB 3,162.50 kB 05 7,915.33 kB 18,342.56 kB 06 5,441.00 kB 14,186.00 kB 07 32,950.08 kB 62,504.17 kB 08 55,780.50 kB 94,776.25 kB 09 88,930.92 kB 164,906.58 kB 10 58,034.00 kB 103,546.50 kB 11 47,906.08 kB 83,982.00 kB 12 326,873.80 kB 673,526.00 kB 13 30,104.27 kB 33,483.91 kB 14 31,769.17 kB 79,414.58 kB 15 59,667.42 kB 95,949.17 kB 16 28,297.67 kB 102,298.58 kB 17 26,800.38 kB 74,620.31 kB 18 2,528.38 kB 34,593.00 kB 19 746.00 kB 18,721.50 kB 20 2,058.00 kB 11,719.33 kB 21 5,165.78 kB 14,019.89 kB 22 1,695.00 kB 7,259.57 kB 23 13,527.50 kB 23,077.25 kB -
Temporary Files
Size of temporary files
Key values
- 470.59 MiB Temp Files size Peak
- 2026-07-15 05:32:03 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-15 05:32:09 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 15 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.41 MiB 06 0 0 0 07 0 0 0 08 2 364.02 MiB 182.01 MiB 09 1 182.01 MiB 182.01 MiB 10 0 0 0 11 3 545.96 MiB 181.99 MiB 12 1 182.01 MiB 182.01 MiB 13 3 546.04 MiB 182.01 MiB 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 10 1.78 GiB 181.97 MiB 182.02 MiB 182.00 MiB select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01547);
Date: 2026-07-15 08:59:42 Duration: 2m9s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01552);
Date: 2026-07-15 12:01:34 Duration: 1m58s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01546);
Date: 2026-07-15 08:48:33 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql
2 8 913.99 MiB 70.18 MiB 235.30 MiB 114.25 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-15 05:32:11 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-15 05:32:03 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
3 2 180.09 MiB 90.05 MiB 90.05 MiB 90.05 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-15 05:30:43 Duration: 41s942ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-15 05:30:40 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 235.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 235.30 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:03 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01547);[ Date: 2026-07-15 08:59:37 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
4 182.02 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01553);[ Date: 2026-07-15 13:18:51 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
5 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01555);[ Date: 2026-07-15 13:29:47 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
6 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01548);[ Date: 2026-07-15 09:29:05 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
7 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01549);[ Date: 2026-07-15 11:13:54 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
8 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01554);[ Date: 2026-07-15 13:24:42 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
9 182.01 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01552);[ Date: 2026-07-15 12:01:32 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
10 182.00 MiB SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01546);[ Date: 2026-07-15 08:48:33 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
11 181.98 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01551);[ Date: 2026-07-15 11:36:51 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
12 181.97 MiB SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01550);[ Date: 2026-07-15 11:29:48 - Database: contagem - User: intelifix - Remote: [local] - Application: psql ]
13 90.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-15 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 90.05 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-15 05:30:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 77.64 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 77.57 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 77.56 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 70.26 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 70.19 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 70.18 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-15 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 53.29 sec Highest CPU-cost vacuum
Table public.giga_testes
Database testes - 2026-07-15 12:22:24 Date
- 0 sec Highest CPU-cost analyze
Table
Database testes - Date
Average Autovacuum Duration
Key values
- 53.29 sec Highest CPU-cost vacuum
Table public.giga_testes
Database testes - 2026-07-15 12:22:24 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (127) Main table analyzed (database rio)
- 1,018 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 127 rio.pg_catalog.pg_class 68 rio.pg_catalog.pg_type 59 rio.public.usuarios 49 brasilia.pg_catalog.pg_attribute 39 rio.pg_catalog.pg_index 37 contagem.pg_catalog.pg_attribute 36 rio.public.temp0000285372 35 rio.pg_catalog.pg_depend 30 contagem.public.usuarios 26 contagem.pg_catalog.pg_class 24 rio.public.temp0000285392 22 contagem.pg_catalog.pg_type 21 rio.public.temp0000285470 20 rio.public.temp0000285394 18 contagem.public.temp0000226610 18 rio.public.temp0000285446 18 brasilia.pg_catalog.pg_class 15 contagem.pg_catalog.pg_index 15 brasilia.public.temp0000236120 14 rio.public.temp0000285498 13 brasilia.pg_catalog.pg_type 13 brasilia.public.temp0000236174 12 contagem.pg_catalog.pg_depend 12 brasilia.public.temp0000236186 11 brasilia.public.usuarios 10 rio.public.temp0000285456 9 contagem.public.nf_entrada 8 rio.public.temp0000285396 8 rio.public.temp0000285366 8 rio.public.temp0000284750 8 rio.public.temp0000285386 7 brasilia.pg_catalog.pg_index 7 contagem.public.temp0000226640 7 contagem.public.temp0000226642 6 rio.public.x 6 brasilia.pg_catalog.pg_depend 6 rio.pg_catalog.pg_shdepend 5 rio.public.temp0000285494 5 rio.public.temp0000285502 5 rio.public.temp0000285402 5 rio.public.temp0000285426 4 rio.public.temp0000284984 4 brasilia.public.temp0000236166 4 template1.pg_catalog.pg_shdepend 4 contagem.pg_catalog.pg_shdepend 4 rio.public.temp0000285370 4 rio.public.temp0000285476 3 rio.public.temp0000285444 3 rio.public.tmp_drill_0175 3 brasilia.public.temp0000236178 3 rio.public.temp0000285496 3 testes.pg_catalog.pg_class 2 rio.public.tmp_drill_0302 2 postgres.pg_catalog.pg_shdepend 2 contagem.public.temp0000226612 2 rio.public.temp0000285388 2 rio.public.temp0000283926 2 rio.public.temp0000285420 2 rio.public.temp0000285020 2 brasilia.pg_catalog.pg_shdepend 2 rio.public.temp0000284664 2 brasilia.public.temp0000236126 2 rio.public.temp0000285368 2 brasilia.public.temp0000236196 2 rio.public.temp0000285404 2 testes.public.estoques 1 testes.public.defeito_materiais 1 testes.bk.tecnicos 1 testes.pg_catalog.pg_type 1 rio.public.temp0000285434 1 brasilia.public.temp0000236130 1 testes.ceps2009.cep_grandes_usuarios 1 rio.public.temp0000285460 1 testes.public.estoque_movto 1 testes.ceps2009.cep_bairros 1 testes.public.fornecedores 1 rio.public.temp0000285398 1 brasilia.public.temp0000236180 1 testes.public.lixo 1 rio.public.temp0000284762 1 testes.pg_catalog.pg_index 1 testes.pg_catalog.pg_attribute 1 brasilia.public.temp0000236142 1 testes.public.aa 1 testes.public.caixa_itens_exclusao 1 rio.public.temp0000285474 1 brasilia.public.temp0000236128 1 rio.public.temp0000285282 1 testes.lenon1.volta 1 rio.public.temp0000285452 1 testes.lenon1.mudancamodelo 1 testes.public.indices 1 testes.public.fluxos 1 testes.public.cli33 1 rio.public.temp0000285286 1 testes.public.def1 1 testes.public.equipamento_codigos 1 brasilia.public.temp0000236216 1 testes.public.giga_testes 1 brasilia.public.temp0000236228 1 testes.public.acessorios 1 testes.public.caixa_itens 1 rio.public.temp0000285430 1 rio.public.temp0000285466 1 brasilia.public.temp0000236146 1 rio.public.temp0000285376 1 brasilia.public.temp0000236138 1 rio.public.temp0000285472 1 testes.pg_catalog.pg_description 1 rio.public.temp0000285390 1 testes.public.codigos_barra 1 brasilia.public.temp0000236190 1 testes.ceps2009.cep_especiais 1 testes.pg_catalog.pg_attrdef 1 testes.bk.usuario_perfis 1 testes.public.enderecos 1 testes.ceps2009.cep_logradouros 1 testes.ceps2009.cep_coordenadas 1 testes.public.defeitos 1 rio.public.temp0000285408 1 testes.pg_catalog.pg_sequence 1 testes.public.equipamento_mudancas 1 testes.public.equipamentos 1 testes.public.acessos 1 testes.public.equip_defeitos 1 testes.pg_catalog.pg_proc 1 testes.bk.perfil_programas 1 testes.pg_catalog.pg_amproc 1 rio.public.temp0000285406 1 rio.public.temp0000285482 1 testes.public.adverbios 1 rio.public.temp0000285384 1 rio.public.temp0000285478 1 rio.public.temp0000285382 1 testes.bk.usuarios 1 testes.public.conserto_materiais 1 rio.public.temp0000285424 1 rio.public.temp0000285450 1 testes.pg_catalog.pg_depend 1 testes.public.fluxo_passos 1 testes.pg_catalog.pg_constraint 1 brasilia.public.temp0000236188 1 testes.public.caixa_itens_dup 1 testes.public.equipamentos_referencia 1 testes.ceps2009.cep_localidades 1 brasilia.public.temp0000236168 1 brasilia.public.temp0000236152 1 testes.public.language_data 1 testes.public.inventario_equipamentos 1 testes.public.defeito_posicoes 1 rio.public.temp0000285380 1 brasilia.public.temp0000236224 1 testes.pg_catalog.pg_amop 1 brasilia.public.temp0000236164 1 Total 1,018 Vacuums per table
Key values
- pg_catalog.pg_attribute (55) Main table vacuumed on database rio
- 482 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 47 0 0 0 0 0 27,586 7,152 10,625,293 392 9,671 rio.pg_catalog.pg_class 36 31 0 0 0 0 0 5,835 1,807 2,699,969 94 403 rio.public.temp0000285372 36 0 0 0 0 0 0 22,617 1,856 3,579,310 0 0 rio.pg_catalog.pg_type 26 25 0 0 0 0 0 2,728 775 1,161,974 64 212 contagem.public.usuarios 24 0 0 0 0 0 0 131 96 49,544 0 0 rio.public.temp0000285394 18 0 0 0 0 0 0 23,149 3,366 5,608,726 0 0 rio.pg_catalog.pg_index 17 17 0 0 0 0 0 1,067 299 271,144 60 124 contagem.pg_catalog.pg_attribute 16 16 0 0 0 0 0 9,327 2,363 4,465,391 39 843 contagem.public.temp0000226610 13 0 0 0 0 0 0 687 71 52,300 0 0 rio.pg_catalog.pg_depend 13 13 0 0 0 0 0 4,248 1,636 2,218,512 84 716 rio.public.temp0000285498 13 0 0 0 0 0 0 21,508 52 1,276,811 0 0 contagem.pg_catalog.pg_class 12 12 0 0 0 0 0 2,045 443 668,367 14 41 contagem.pg_catalog.pg_type 10 10 0 0 0 0 0 1,120 405 565,388 11 30 brasilia.pg_catalog.pg_attribute 10 10 0 0 0 0 0 4,787 1,614 2,506,498 63 1,615 rio.public.temp0000285396 9 0 0 0 0 0 0 11,568 1,681 2,801,126 0 0 rio.public.temp0000285446 8 0 0 0 0 0 0 5,326 108 451,958 0 0 rio.public.usuarios 8 7 0 0 0 0 0 201 76 134,885 18 55 contagem.public.temp0000226640 7 0 0 0 0 0 0 349 38 26,973 0 0 rio.pg_catalog.pg_statistic 6 6 0 0 0 0 0 8,672 1,727 8,368,108 772 4,186 rio.public.temp0000285470 6 0 0 0 0 0 0 3,749 148 426,672 0 0 rio.public.temp0000285494 6 0 0 0 0 0 0 6,624 1,673 2,512,671 0 0 contagem.pg_catalog.pg_index 6 6 0 0 0 0 0 329 115 90,622 5 7 rio.public.temp0000284750 6 0 0 0 0 0 0 269 122 134,497 0 0 rio.public.temp0000285392 6 0 0 0 0 0 0 412 91 151,867 0 0 contagem.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,498 485 920,252 23 582 contagem.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 661 232 501,882 26 181 rio.pg_toast.pg_toast_2619 4 4 0 0 0 0 0 1,828 374 2,022,396 134 402 brasilia.pg_catalog.pg_class 4 4 0 0 0 0 0 614 262 431,661 20 76 brasilia.pg_catalog.pg_type 3 3 0 0 0 0 0 198 91 136,916 6 22 rio.public.tmp_drill_0175 3 3 0 0 0 0 0 115 9 26,380 0 0 rio.pg_catalog.pg_shdepend 3 3 0 0 0 0 0 719 263 578,412 18 51 brasilia.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,888 600 2,436,883 402 2,725 rio.public.temp0000285502 3 0 0 0 0 0 0 315 18 21,390 0 0 rio.public.temp0000285476 3 0 0 0 0 0 0 3,384 14 201,751 0 0 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 371 86 356,860 32 82 template1.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 416 152 251,863 23 46 rio.public.temp0000285388 2 0 0 0 0 0 0 1,716 10 102,707 0 0 rio.public.temp0000283926 2 0 0 0 0 0 0 3,308 8 196,378 0 0 brasilia.pg_catalog.pg_index 2 2 0 0 0 0 0 128 45 36,111 13 19 rio.public.temp0000284984 2 0 0 0 0 0 0 226 12 15,199 0 0 rio.public.temp0000285020 2 0 0 0 0 0 0 219 12 14,769 0 0 testes.pg_catalog.pg_class 2 0 0 0 0 0 0 1 0 311 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 284 36 183,644 17 50 rio.public.tmp_drill_0302 2 2 0 0 0 0 0 715 33 169,545 0 0 contagem.public.temp0000226612 2 0 0 0 0 0 0 86 12 6,728 0 0 testes.pg_catalog.pg_depend 1 0 0 0 0 0 0 1 0 311 0 0 testes.public.posicao_oficina_01 1 0 0 0 0 0 0 4,806 1,604 2,972,609 0 0 testes.public.fluxo_passos 1 0 0 0 0 0 0 134,798 44,935 115,618,525 44,932 4,850,731 testes.ceps2009.cep_localidades 1 0 0 0 0 0 0 5 2 796 0 0 testes.public.equipamentos_referencia 1 0 0 0 0 0 0 84,020 28,008 87,011,733 28,006 5,181,079 testes.public.inventario_equipamentos 1 0 0 0 0 0 0 158 56 126,633 50 4,824 testes.public.posicao_oficina_02 1 0 0 0 0 0 0 102 36 51,887 0 0 rio.public.temp0000285404 1 0 0 0 0 0 0 126 6 8,401 0 0 rio.public.temp0000285408 1 0 0 0 0 0 0 62 6 4,520 0 0 testes.ceps2009.cep_logradouros 1 0 0 0 0 0 0 1 0 258 0 0 testes.ceps2009.cep_coordenadas 1 0 0 0 0 0 0 1 0 258 0 0 testes.public.equip_defeitos 1 0 0 0 0 0 0 40,713 40,712 119,634,662 0 0 testes.public.acessos 1 0 0 0 0 0 0 1 0 258 0 0 testes.public.equipamentos 1 0 0 0 0 0 0 179,063 59,690 207,473,487 59,687 4,903,477 testes.pg_catalog.pg_proc 1 1 0 0 0 0 0 140 0 10,230 0 0 rio.public.temp0000285478 1 0 0 0 0 0 0 1,654 4 98,189 0 0 rio.public.temp0000285482 1 0 0 0 0 0 0 75 6 5,317 0 0 rio.public.temp0000285406 1 0 0 0 0 0 0 75 6 5,316 0 0 testes.public.conserto_materiais 1 0 0 0 0 0 0 5 3 2,757 0 0 brasilia.pg_catalog.pg_depend 1 1 0 0 0 0 0 428 166 177,931 10 78 rio.public.temp0000285450 1 0 0 0 0 0 0 67 6 4,822 0 0 testes.public.fluxos 1 0 0 0 0 0 0 171,425 57,144 185,427,981 57,141 5,047,877 contagem.pg_catalog.pg_statistic 1 1 0 0 0 0 0 2,283 10 170,134 0 0 rio.public.temp0000285452 1 0 0 0 0 0 0 4 3 774 0 0 testes.lenon1.mudancamodelo 1 0 0 0 0 0 0 5 2 636 0 0 testes.lenon1.volta 1 0 0 0 0 0 0 1 0 258 0 0 rio.public.temp0000285286 1 0 0 0 0 0 0 1,655 4 98,248 0 0 testes.public.cli33 1 0 0 0 0 0 0 5 2 638 0 0 rio.public.temp0000285386 1 0 0 0 0 0 0 62 6 4,522 0 0 testes.public.logs 1 0 0 0 0 0 0 94,117 31,379 31,370,330 0 0 testes.public.equipamento_codigos 1 0 0 0 0 0 0 63,598 63,597 238,910,525 0 0 brasilia.public.giga_testes 1 1 0 0 0 0 0 4,353 3,575 12,326,632 35 422 rio.pg_toast.pg_toast_1255 1 1 0 0 0 0 0 356 116 721,778 25 56 testes.public.giga_testes 1 0 0 0 0 0 0 296,471 98,830 272,194,296 98,823 3,854,119 testes.public.caixa_itens 1 0 0 0 0 0 0 1 0 258 0 0 testes.public.acessorios 1 0 0 0 0 0 0 1 0 258 0 0 testes.public.codigos_barra 1 0 0 0 0 0 0 1 0 258 0 0 testes.pg_catalog.pg_description 1 0 0 0 0 0 0 2 0 397 0 0 rio.public.temp0000285390 1 0 0 0 0 0 0 8 5 1,251 0 0 rio.auditor.auditor_2026_07 1 0 0 0 0 0 0 67,473 49,548 67,961,714 8,903 178,506 testes.ceps2009.cep_especiais 1 0 0 0 0 0 0 5 2 699 0 0 rio.public.temp0000285444 1 0 0 0 0 0 0 77 6 5,438 0 0 rio.public.temp0000285434 1 0 0 0 0 0 0 8 5 1,278 0 0 testes.pg_catalog.pg_type 1 0 0 0 0 0 0 2 0 370 0 0 contagem.pg_toast.pg_toast_1255 1 1 0 0 0 0 0 394 112 703,270 19 40 testes.ceps2009.cep_bairros 1 0 0 0 0 0 0 1 0 258 0 0 contagem.public.nf_entrada 1 1 0 0 0 0 0 109 56 91,107 5 12 testes.public.estoque_movto 1 0 0 0 0 0 0 89 33 82,679 27 2,806 rio.public.temp0000285460 1 0 0 0 0 0 0 75 6 5,316 0 0 testes.ceps2009.cep_grandes_usuarios 1 0 0 0 0 0 0 1 0 258 0 0 rio.public.temp0000285398 1 0 0 0 0 0 0 73 6 5,174 0 0 testes.public.lixo 1 0 0 0 0 0 0 230 80 250,757 74 9,693 brasilia.public.temp0000236142 1 0 0 0 0 0 0 242 6 15,461 0 0 rio.public.temp0000284762 1 0 0 0 0 0 0 121 6 8,080 0 0 testes.pg_catalog.pg_attribute 1 0 0 0 0 0 0 3 0 429 0 0 rio.public.temp0000285474 1 0 0 0 0 0 0 75 6 5,316 0 0 testes.pg_catalog.pg_statistic 1 1 0 0 0 0 0 160 50 214,040 36 307 testes.public.caixa_itens_exclusao 1 0 0 0 0 0 0 1 0 258 0 0 Total 482 247 0 0 0 0 0 1,334,812 510,309 1,403,250,620 300,103 24,056,166 Vacuum throughput per table
Key values
- public.giga_testes (53.29) Max CPU elapsed for vacuum on database testes
- unknown (0 ms) Max I/O read time for vacuum on database testes
- unknown (0 ms) Max I/O write time for vacuum on database testes
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.01 rio.pg_catalog.pg_class 0 0 0.93 rio.public.temp0000285372 0 0 1.01 rio.pg_catalog.pg_type 0 0 0.36 contagem.public.usuarios 0 0 0 rio.public.temp0000285394 0 0 0.94 rio.pg_catalog.pg_index 0 0 0.3 contagem.pg_catalog.pg_attribute 0 0 1.34 contagem.public.temp0000226610 0 0 0.25 rio.pg_catalog.pg_depend 0 0 1 rio.public.temp0000285498 0 0 0.62 contagem.pg_catalog.pg_class 0 0 0.45 contagem.pg_catalog.pg_type 0 0 0.31 brasilia.pg_catalog.pg_attribute 0 0 0.96 rio.public.temp0000285396 0 0 0.49 rio.public.temp0000285446 0 0 0.25 rio.public.usuarios 0 0 0.02 contagem.public.temp0000226640 0 0 0.12 rio.pg_catalog.pg_statistic 0 0 1.16 rio.public.temp0000285470 0 0 0.16 rio.public.temp0000285494 0 0 0.28 contagem.pg_catalog.pg_index 0 0 0.15 rio.public.temp0000284750 0 0 0.1 rio.public.temp0000285392 0 0 0.03 contagem.pg_catalog.pg_depend 0 0 0.28 contagem.pg_catalog.pg_shdepend 0 0 0.15 rio.pg_toast.pg_toast_2619 0 0 0.21 brasilia.pg_catalog.pg_class 0 0 0.2 brasilia.pg_catalog.pg_type 0 0 0.05 rio.public.tmp_drill_0175 0 0 0 rio.pg_catalog.pg_shdepend 0 0 0.15 brasilia.pg_catalog.pg_statistic 0 0 0.44 rio.public.temp0000285502 0 0 0.06 rio.public.temp0000285476 0 0 0.12 brasilia.pg_toast.pg_toast_2619 0 0 0.03 template1.pg_catalog.pg_shdepend 0 0 0.08 rio.public.temp0000285388 0 0 0.05 rio.public.temp0000283926 0 0 0.12 brasilia.pg_catalog.pg_index 0 0 0.04 rio.public.temp0000284984 0 0 0.03 rio.public.temp0000285020 0 0 0.04 testes.pg_catalog.pg_class 0 0 0 contagem.pg_toast.pg_toast_2619 0 0 0.01 rio.public.tmp_drill_0302 0 0 0.04 contagem.public.temp0000226612 0 0 0.03 testes.pg_catalog.pg_depend 0 0 0 testes.public.posicao_oficina_01 0 0 0.82 testes.public.fluxo_passos 0 0 25.98 testes.ceps2009.cep_localidades 0 0 0.02 testes.public.equipamentos_referencia 0 0 10.37 testes.public.inventario_equipamentos 0 0 0.04 testes.public.posicao_oficina_02 0 0 0.03 rio.public.temp0000285404 0 0 0.01 rio.public.temp0000285408 0 0 0.02 testes.ceps2009.cep_logradouros 0 0 2.34 testes.ceps2009.cep_coordenadas 0 0 0.4 testes.public.equip_defeitos 0 0 23.9 testes.public.acessos 0 0 0.04 testes.public.equipamentos 0 0 22 testes.pg_catalog.pg_proc 0 0 0.01 rio.public.temp0000285478 0 0 0.05 rio.public.temp0000285482 0 0 0.01 rio.public.temp0000285406 0 0 0.01 testes.public.conserto_materiais 0 0 0.03 brasilia.pg_catalog.pg_depend 0 0 0.09 rio.public.temp0000285450 0 0 0.01 testes.public.fluxos 0 0 20.91 contagem.pg_catalog.pg_statistic 0 0 0.05 rio.public.temp0000285452 0 0 0.04 testes.lenon1.mudancamodelo 0 0 0.01 testes.lenon1.volta 0 0 0.01 rio.public.temp0000285286 0 0 0.06 testes.public.cli33 0 0 0.13 rio.public.temp0000285386 0 0 0.02 testes.public.logs 0 0 18.18 testes.public.equipamento_codigos 0 0 36.98 brasilia.public.giga_testes 0 0 2.34 rio.pg_toast.pg_toast_1255 0 0 0.04 testes.public.giga_testes 0 0 53.29 testes.public.caixa_itens 0 0 12.77 testes.public.acessorios 0 0 0.32 testes.public.codigos_barra 0 0 20.86 testes.pg_catalog.pg_description 0 0 0 rio.public.temp0000285390 0 0 0.01 rio.auditor.auditor_2026_07 0 0 16.63 testes.ceps2009.cep_especiais 0 0 0.02 rio.public.temp0000285444 0 0 0.02 rio.public.temp0000285434 0 0 0.01 testes.pg_catalog.pg_type 0 0 0 contagem.pg_toast.pg_toast_1255 0 0 0.04 testes.ceps2009.cep_bairros 0 0 0.01 contagem.public.nf_entrada 0 0 0.02 testes.public.estoque_movto 0 0 0.02 rio.public.temp0000285460 0 0 0.02 testes.ceps2009.cep_grandes_usuarios 0 0 0 rio.public.temp0000285398 0 0 0.02 testes.public.lixo 0 0 0.05 brasilia.public.temp0000236142 0 0 0.02 rio.public.temp0000284762 0 0 0.01 testes.pg_catalog.pg_attribute 0 0 0.01 rio.public.temp0000285474 0 0 0.02 testes.pg_catalog.pg_statistic 0 0 0.02 testes.public.caixa_itens_exclusao 0 0 2.83 Total 0 0 289.34 Tuples removed per table
Key values
- public.logs (808071) Main table with removed tuples on database testes
- 1222720 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain testes.public.logs 1 0 808,071 0 0 31,368 0 rio.pg_catalog.pg_attribute 55 47 208,591 1,391,980 79,870 397 34,104 contagem.pg_catalog.pg_attribute 16 16 51,482 376,773 98 200 8,539 brasilia.pg_catalog.pg_attribute 10 10 34,559 227,274 0 0 5,432 testes.public.posicao_oficina_01 1 0 27,967 0 0 1,600 0 rio.pg_catalog.pg_depend 13 13 13,484 251,957 4,596 0 2,431 rio.pg_catalog.pg_statistic 6 6 11,453 50,099 0 0 7,716 rio.public.tmp_drill_0302 2 2 9,722 10,589 0 0 267 rio.pg_catalog.pg_type 26 25 8,513 62,182 2,782 25 1,864 brasilia.pg_catalog.pg_statistic 3 3 6,482 23,686 0 0 3,216 rio.pg_catalog.pg_shdepend 3 3 5,582 40,928 196 19 345 rio.pg_catalog.pg_index 17 17 4,392 33,436 665 3 972 contagem.pg_catalog.pg_statistic 1 1 4,205 7,274 0 0 1,011 rio.pg_catalog.pg_class 36 31 3,839 137,984 11,463 69 4,274 contagem.pg_catalog.pg_type 10 10 3,493 22,502 4 15 680 rio.auditor.auditor_2026_07 1 0 3,359 10,387,956 0 0 470,433 contagem.pg_catalog.pg_shdepend 4 4 2,891 58,606 759 0 479 contagem.pg_catalog.pg_depend 5 5 1,995 91,706 12 13 870 brasilia.pg_catalog.pg_depend 1 1 1,611 16,354 0 0 187 contagem.public.usuarios 24 0 1,475 552 0 0 48 template1.pg_catalog.pg_shdepend 2 2 1,458 27,263 181 0 230 contagem.pg_catalog.pg_class 12 12 1,378 39,762 12 23 1,435 rio.pg_toast.pg_toast_2619 4 4 1,162 2,273 0 0 1,112 contagem.pg_catalog.pg_index 6 6 967 11,383 0 20 302 brasilia.pg_catalog.pg_class 4 4 891 17,937 0 5 580 testes.public.posicao_oficina_02 1 0 644 0 0 32 0 rio.public.usuarios 8 7 610 4,676 604 1 135 brasilia.pg_catalog.pg_index 2 2 531 3,756 7 0 106 brasilia.pg_catalog.pg_type 3 3 265 6,657 10 0 171 contagem.public.nf_entrada 1 1 262 938 0 0 69 brasilia.pg_toast.pg_toast_2619 2 2 238 280 0 0 142 brasilia.public.giga_testes 1 1 230 681,792 0 0 18,098 testes.pg_catalog.pg_statistic 1 1 223 655 0 0 54 contagem.pg_toast.pg_toast_1255 1 1 206 1,032 0 0 277 contagem.pg_toast.pg_toast_2619 2 2 184 231 0 0 120 rio.pg_toast.pg_toast_1255 1 1 174 1,021 39 0 268 testes.pg_catalog.pg_proc 1 1 123 5,890 1 0 411 testes.pg_catalog.pg_description 1 0 8 6,836 25 0 61 testes.pg_catalog.pg_depend 1 0 0 14,282 17 0 106 testes.public.fluxo_passos 1 0 0 4,850,731 0 0 44,944 testes.ceps2009.cep_localidades 1 0 0 10,283 0 37 123 testes.public.equipamentos_referencia 1 0 0 5,181,079 0 0 28,064 testes.public.inventario_equipamentos 1 0 0 4,824 0 30 50 rio.public.temp0000285404 1 0 0 5,275 0 10 118 contagem.public.temp0000226640 7 0 0 8,839 0 218 678 rio.public.temp0000285408 1 0 0 1,061 0 10 54 testes.ceps2009.cep_logradouros 1 0 0 775,617 0 0 9,056 testes.ceps2009.cep_coordenadas 1 0 0 353,995 0 0 3,152 contagem.public.temp0000226610 13 0 0 16,448 0 403 1,261 testes.public.equip_defeitos 1 0 0 5,249,712 0 0 42,760 rio.public.temp0000285446 8 0 0 76,446 0 315 5,317 testes.public.acessos 1 0 0 104,808 0 0 904 testes.public.equipamentos 1 0 0 4,903,477 0 0 59,720 rio.public.tmp_drill_0175 3 3 0 1,452 0 0 40 rio.public.temp0000285478 1 0 0 23,270 0 0 1,664 rio.public.temp0000285482 1 0 0 1,357 0 61 67 rio.public.temp0000285406 1 0 0 1,348 0 61 67 testes.public.conserto_materiais 1 0 0 56,512 0 49 471 rio.public.temp0000285450 1 0 0 1,020 0 5 59 testes.public.fluxos 1 0 0 5,047,877 0 0 57,200 rio.public.temp0000285388 2 0 0 24,309 0 11 1,717 rio.public.temp0000285470 6 0 0 63,227 0 103 3,737 rio.public.temp0000285452 1 0 0 23,268 0 0 1,664 testes.lenon1.mudancamodelo 1 0 0 4,473 0 23 25 testes.lenon1.volta 1 0 0 17,585 0 0 400 rio.public.temp0000285286 1 0 0 23,283 0 0 1,664 rio.public.temp0000285494 6 0 0 139,679 0 0 9,984 testes.public.cli33 1 0 0 13,428 0 23 73 rio.public.temp0000285396 9 0 0 209,116 0 0 14,976 rio.public.temp0000283926 2 0 0 46,553 0 0 3,328 rio.public.temp0000285386 1 0 0 1,022 0 10 54 rio.public.temp0000285394 18 0 0 418,418 0 0 29,952 testes.public.equipamento_codigos 1 0 0 9,590,541 0 0 63,600 testes.public.giga_testes 1 0 0 3,854,119 0 0 98,824 testes.public.caixa_itens 1 0 0 4,530,802 0 0 42,368 testes.public.acessorios 1 0 0 335,976 0 0 2,824 rio.public.temp0000284984 2 0 0 9,428 0 110 210 rio.public.temp0000285020 2 0 0 9,134 0 117 203 rio.public.temp0000284750 6 0 0 24,172 0 246 522 testes.public.codigos_barra 1 0 0 9,844,743 0 0 65,392 rio.public.temp0000285390 1 0 0 1,022 0 11 53 testes.ceps2009.cep_especiais 1 0 0 2,972 0 8 40 rio.public.temp0000285502 3 0 0 9,249 0 157 291 rio.public.temp0000285444 1 0 0 1,360 0 59 69 rio.public.temp0000285392 6 0 0 10,974 0 126 386 rio.public.temp0000285476 3 0 0 47,904 0 61 3,395 testes.pg_catalog.pg_class 2 0 0 5,018 1,154 0 116 rio.public.temp0000285434 1 0 0 1,330 0 63 65 testes.pg_catalog.pg_type 1 0 0 2,350 169 0 55 testes.ceps2009.cep_bairros 1 0 0 41,209 0 0 312 testes.public.estoque_movto 1 0 0 2,806 0 13 27 rio.public.temp0000285460 1 0 0 1,348 0 61 67 testes.ceps2009.cep_grandes_usuarios 1 0 0 11,018 0 0 160 rio.public.temp0000285398 1 0 0 2,917 0 63 65 rio.public.temp0000285498 13 0 0 302,674 0 0 21,632 testes.public.lixo 1 0 0 9,693 0 54 74 brasilia.public.temp0000236142 1 0 0 3,108 0 23 233 contagem.public.temp0000226612 2 0 0 2,022 0 58 70 rio.public.temp0000284762 1 0 0 5,064 0 15 113 testes.pg_catalog.pg_attribute 1 0 0 23,474 316 0 406 rio.public.temp0000285372 36 0 0 440,183 0 186 31,046 rio.public.temp0000285474 1 0 0 1,348 0 61 67 testes.public.caixa_itens_exclusao 1 0 0 1,296,379 0 0 10,824 Total 482 247 1,222,720 72,102,631 102,980 36,651 1,233,397 Pages removed per table
Key values
- public.logs (31368) Main table with removed pages on database testes
- 36651 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed testes.public.logs 1 0 808071 31368 testes.public.posicao_oficina_01 1 0 27967 1600 contagem.public.temp0000226610 13 0 0 403 rio.pg_catalog.pg_attribute 55 47 208591 397 rio.public.temp0000285446 8 0 0 315 rio.public.temp0000284750 6 0 0 246 contagem.public.temp0000226640 7 0 0 218 contagem.pg_catalog.pg_attribute 16 16 51482 200 rio.public.temp0000285372 36 0 0 186 rio.public.temp0000285502 3 0 0 157 rio.public.temp0000285392 6 0 0 126 rio.public.temp0000285020 2 0 0 117 rio.public.temp0000284984 2 0 0 110 rio.public.temp0000285470 6 0 0 103 rio.pg_catalog.pg_class 36 31 3839 69 rio.public.temp0000285434 1 0 0 63 rio.public.temp0000285398 1 0 0 63 rio.public.temp0000285482 1 0 0 61 rio.public.temp0000285406 1 0 0 61 rio.public.temp0000285476 3 0 0 61 rio.public.temp0000285460 1 0 0 61 rio.public.temp0000285474 1 0 0 61 rio.public.temp0000285444 1 0 0 59 contagem.public.temp0000226612 2 0 0 58 testes.public.lixo 1 0 0 54 testes.public.conserto_materiais 1 0 0 49 testes.ceps2009.cep_localidades 1 0 0 37 testes.public.posicao_oficina_02 1 0 644 32 testes.public.inventario_equipamentos 1 0 0 30 rio.pg_catalog.pg_type 26 25 8513 25 contagem.pg_catalog.pg_class 12 12 1378 23 testes.lenon1.mudancamodelo 1 0 0 23 testes.public.cli33 1 0 0 23 brasilia.public.temp0000236142 1 0 0 23 contagem.pg_catalog.pg_index 6 6 967 20 rio.pg_catalog.pg_shdepend 3 3 5582 19 contagem.pg_catalog.pg_type 10 10 3493 15 rio.public.temp0000284762 1 0 0 15 contagem.pg_catalog.pg_depend 5 5 1995 13 testes.public.estoque_movto 1 0 0 13 rio.public.temp0000285388 2 0 0 11 rio.public.temp0000285390 1 0 0 11 rio.public.temp0000285404 1 0 0 10 rio.public.temp0000285408 1 0 0 10 rio.public.temp0000285386 1 0 0 10 testes.ceps2009.cep_especiais 1 0 0 8 rio.public.temp0000285450 1 0 0 5 brasilia.pg_catalog.pg_class 4 4 891 5 rio.pg_catalog.pg_index 17 17 4392 3 rio.public.usuarios 8 7 610 1 testes.pg_catalog.pg_depend 1 0 0 0 testes.public.fluxo_passos 1 0 0 0 contagem.pg_catalog.pg_shdepend 4 4 2891 0 brasilia.pg_toast.pg_toast_2619 2 2 238 0 testes.public.equipamentos_referencia 1 0 0 0 testes.ceps2009.cep_logradouros 1 0 0 0 testes.ceps2009.cep_coordenadas 1 0 0 0 brasilia.pg_catalog.pg_type 3 3 265 0 rio.pg_catalog.pg_statistic 6 6 11453 0 testes.public.equip_defeitos 1 0 0 0 testes.public.acessos 1 0 0 0 testes.public.equipamentos 1 0 0 0 rio.public.tmp_drill_0175 3 3 0 0 testes.pg_catalog.pg_proc 1 1 123 0 template1.pg_catalog.pg_shdepend 2 2 1458 0 rio.public.temp0000285478 1 0 0 0 brasilia.pg_catalog.pg_depend 1 1 1611 0 testes.public.fluxos 1 0 0 0 contagem.pg_catalog.pg_statistic 1 1 4205 0 rio.public.temp0000285452 1 0 0 0 testes.lenon1.volta 1 0 0 0 rio.public.temp0000285286 1 0 0 0 rio.public.temp0000285494 6 0 0 0 rio.public.temp0000285396 9 0 0 0 rio.public.temp0000283926 2 0 0 0 rio.public.temp0000285394 18 0 0 0 testes.public.equipamento_codigos 1 0 0 0 brasilia.public.giga_testes 1 1 230 0 rio.pg_toast.pg_toast_1255 1 1 174 0 brasilia.pg_catalog.pg_index 2 2 531 0 testes.public.giga_testes 1 0 0 0 testes.public.caixa_itens 1 0 0 0 testes.public.acessorios 1 0 0 0 brasilia.pg_catalog.pg_statistic 3 3 6482 0 testes.public.codigos_barra 1 0 0 0 rio.pg_toast.pg_toast_2619 4 4 1162 0 testes.pg_catalog.pg_description 1 0 8 0 rio.auditor.auditor_2026_07 1 0 3359 0 testes.pg_catalog.pg_class 2 0 0 0 rio.pg_catalog.pg_depend 13 13 13484 0 testes.pg_catalog.pg_type 1 0 0 0 contagem.pg_toast.pg_toast_1255 1 1 206 0 testes.ceps2009.cep_bairros 1 0 0 0 contagem.public.nf_entrada 1 1 262 0 contagem.public.usuarios 24 0 1475 0 contagem.pg_toast.pg_toast_2619 2 2 184 0 testes.ceps2009.cep_grandes_usuarios 1 0 0 0 rio.public.temp0000285498 13 0 0 0 brasilia.pg_catalog.pg_attribute 10 10 34559 0 rio.public.tmp_drill_0302 2 2 9722 0 testes.pg_catalog.pg_attribute 1 0 0 0 testes.pg_catalog.pg_statistic 1 1 223 0 testes.public.caixa_itens_exclusao 1 0 0 0 Total 482 247 1,222,720 36,651 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 15 00 0 0 01 1 5 02 0 0 03 0 0 04 0 0 05 6 5 06 0 0 07 17 26 08 73 128 09 70 141 10 38 94 11 55 133 12 65 101 13 42 81 14 16 87 15 40 82 16 31 86 17 25 42 18 0 0 19 0 1 20 1 1 21 2 5 22 0 0 23 0 0 - 53.29 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 2m7s 47s528ms 1m19s 1m3s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:06:35 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 11:56:10 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:35:22 Database: rio User: intelifix Remote: [local] Application: psql
2 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000285494;-
DROP TABLE IF EXISTS temp0000285494;
Date: 2026-07-15 15:45:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285494;
Date: 2026-07-15 15:45:46 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000285396;-
DROP TABLE IF EXISTS temp0000285396;
Date: 2026-07-15 08:49:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285396;
Date: 2026-07-15 08:49:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
4 1 1s 1s 1s 1s drop table if exists temp0000285372;-
DROP TABLE IF EXISTS temp0000285372;
Date: 2026-07-15 10:13:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000285372;
Date: 2026-07-15 08:45:44 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 1m19s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-15 12:06:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 47s528ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-07-15 11:56:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 1s1ms DROP TABLE IF EXISTS temp0000285494;[ Date: 2026-07-15 15:45:46 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s1ms DROP TABLE IF EXISTS temp0000285396;[ Date: 2026-07-15 08:49:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s DROP TABLE IF EXISTS temp0000285372;[ Date: 2026-07-15 10:13:44 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,616 Total read queries
- 1,814 Total write queries
Queries by database
Key values
- rio Main database
- 4,742 Requests
- 6h27m12s (rio)
- Main time consuming database
Database Request type Count Duration brasilia Total 1,403 1h43m39s copy to 140 10m24s ddl 299 2m6s others 202 6m51s select 762 1h24m16s contagem Total 763 33m50s copy to 120 2m17s ddl 175 1m15s others 7 2m50s select 461 27m26s postgres Total 2 1s273ms ddl 2 1s273ms rio Total 4,742 6h27m12s copy to 238 51m20s ddl 819 52m33s insert 3 6s596ms others 285 32m11s select 3,393 4h10m55s update 4 5s463ms testes Total 14 1m58s copy from 14 1m58s Queries by user
Key values
- intelifix Main user
- 6,615 Requests
User Request type Count Duration etiquetas Total 53 13s103ms select 53 13s103ms intelifix Total 6,615 8h22m17s copy to 413 47m32s ddl 1,279 54m4s others 494 41m53s select 4,429 5h58m47s lenon Total 256 24m11s copy from 14 1m58s copy to 85 16m29s ddl 16 1m52s insert 3 6s596ms select 134 3m37s update 4 5s463ms Duration by user
Key values
- 8h22m17s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 53 13s103ms select 53 13s103ms intelifix Total 6,615 8h22m17s copy to 413 47m32s ddl 1,279 54m4s others 494 41m53s select 4,429 5h58m47s lenon Total 256 24m11s copy from 14 1m58s copy to 85 16m29s ddl 16 1m52s insert 3 6s596ms select 134 3m37s update 4 5s463ms Queries by host
Key values
- [local] Main host
- 6,885 Requests
- 8h42m14s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,645 Requests
- 4h41m1s (psql)
- Main time consuming application
Application Request type Count Duration [unknown] Total 5,645 2h55m10s ddl 1,279 54m4s select 4,366 2h1m5s pgAdmin 4 - CONN:250295 Total 13 49s660ms ddl 2 18s691ms insert 3 6s596ms select 4 18s909ms update 4 5s463ms pgAdmin 4 - CONN:3255731 Total 6 1m11s ddl 5 1m11s select 1 316ms pgAdmin 4 - CONN:4208208 Total 1 238ms ddl 1 238ms pgAdmin 4 - CONN:4239752 Total 1 334ms ddl 1 334ms pgAdmin 4 - CONN:4732505 Total 1 348ms ddl 1 348ms pgAdmin 4 - CONN:6829152 Total 1 279ms ddl 1 279ms pgAdmin 4 - CONN:7085295 Total 1 19s496ms ddl 1 19s496ms pgAdmin 4 - CONN:8311409 Total 13 2m3s ddl 2 609ms select 11 2m3s pgAdmin 4 - DB:postgres Total 2 1s273ms ddl 2 1s273ms pg_dump Total 510 1h4m4s copy to 498 1h4m1s select 12 2s417ms pg_restore Total 14 1m58s copy from 14 1m58s psql Total 716 4h41m1s others 494 41m53s select 222 3h59m7s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-15 12:24:20 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,617 100-500ms duration
Slowest individual queries
Rank Duration Query 1 10m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 15:15:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 9m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 10:14:34 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 9m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 09:14:30 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 9m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 11:14:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 9m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 13:14:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 12:13:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m47s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 16:13:49 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m32s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027040, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-15 07:29:45 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
9 8m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 17:13:13 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m52s analyze verbose;[ Date: 2026-07-15 05:07:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 14:12:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 07:12:19 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 7m5s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 19:12:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 7m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 20:12:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 7m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 08:12:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027083, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-15 11:56:02 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m42s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 21:11:43 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 6m35s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-15 12:06:34 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 6m19s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-15 18:11:21 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
20 6m4s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027098, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-15 15:07:16 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h17m16s 48 2s392ms 10m34s 2m51s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 07 3 7m51s 2m37s 08 3 7m33s 2m31s 09 3 10m7s 3m22s 10 3 10m22s 3m27s 11 3 9m53s 3m17s 12 3 9m30s 3m10s 13 3 9m39s 3m13s 14 3 7m56s 2m38s 15 3 11m18s 3m46s 16 3 9m27s 3m9s 17 3 8m41s 2m53s 18 3 6m39s 2m13s 19 3 7m40s 2m33s 20 3 7m27s 2m29s 21 3 7m1s 2m20s 22 3 6m4s 2m1s [ User: intelifix - Total duration: 2h17m16s - Times executed: 48 ]
[ Application: psql - Total duration: 2h17m16s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-15 15:15:35 Duration: 10m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-15 10:14:34 Duration: 9m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-15 09:14:30 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
2 1h18m45s 45 445ms 4m43s 1m45s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 07 3 4m34s 1m31s 08 3 5m17s 1m45s 09 3 5m51s 1m57s 10 3 5m28s 1m49s 11 2 5m5s 2m32s 12 3 5m36s 1m52s 13 2 5m19s 2m39s 14 3 5m15s 1m45s 15 3 5m16s 1m45s 16 2 5m20s 2m40s 17 3 4m38s 1m32s 18 3 4m5s 1m21s 19 3 4m30s 1m30s 20 3 4m11s 1m23s 21 3 4m8s 1m22s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h18m45s - Times executed: 45 ]
[ Application: psql - Total duration: 1h18m45s - Times executed: 45 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-15 09:20:55 Duration: 4m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-15 14:18:07 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-15 12:20:01 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
3 1h10m42s 308 152ms 8m32s 13s773ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 07 6 13m47s 2m17s 08 46 6m43s 8s775ms 09 37 1m29s 2s417ms 10 23 2m 5s250ms 11 28 8m11s 17s556ms 12 6 12m11s 2m1s 13 32 32s355ms 1s11ms 14 32 4m20s 8s133ms 15 40 13m9s 19s739ms 16 33 2m20s 4s258ms 17 24 5m52s 14s702ms 18 1 2s237ms 2s237ms [ User: intelifix - Total duration: 1h10m42s - Times executed: 308 ]
[ Application: [unknown] - Total duration: 1h10m42s - Times executed: 308 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027040, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 07:29:45 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027083, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 11:56:02 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 12:06:34 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 23m25s 1,715 150ms 6s505ms 819ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 07 51 46s986ms 921ms 08 144 2m12s 918ms 09 242 3m23s 840ms 10 253 3m14s 770ms 11 165 2m25s 882ms 12 77 48s118ms 624ms 13 130 1m53s 875ms 14 268 3m45s 842ms 15 189 2m28s 786ms 16 147 1m54s 779ms 17 49 31s268ms 638ms [ User: intelifix - Total duration: 23m25s - Times executed: 1715 ]
[ Application: [unknown] - Total duration: 23m25s - Times executed: 1715 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46717, 418, '834120918000230,241597682743,241636139616,241663099800,241667647090,241730931415,241689139502,241646287373,241603993437,241679925056,241676647070,241636021928,241704304854,241704320311,241617414758,241678343140,241663857079,241598817286,241617418596,241689391424,241647376279,241629363747,241615988288,241598144056,241659660913,241672177285,241713729500,241713734147,241654584547,241676715158,241679919196,241622633438,241646404759,241706846572,241660129498,241617327880,241676726068,241679924753,241708738496,241649692847,241614539214,241728693441,241616091734,241659881518,241614484663,241635302632,241728738394,241731257080,241646324347', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-15 13:53:47 Duration: 6s505ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46679, 418, '270911029413103298,229751118808,229783470215,229660495171,229750565667,229734547392,229661478487,216938552628,229783512239,229934048489,229750531725,229687534151,229934229595,229860199396,229755719616,229754840002,229879541824,229690604260,229689747576,216944727192,229750083645,229751824668,229661968288,229934056470,229879615164,229666249919,229667249904,229782157392,229690132239,229755031637,229751826385,229661621836,229726744061,229865821832,216940282135,229671724561,216944917895,229671331616,229814884851,229933043454,229786013246', '246566654667,246587104261,246544213139,246529751223,246546476266,246457169111,246477581631,246587946475,226382305272,246562956079,246519144957,246066948894,246651585761,246562267493,246559780102,246652956568,246516665467,246516206982,246456709414,246530629804,246563028285,246487201526,246236603556,246652451638,246495708393,246492102644,246587188690,246516218296,246563728892,246531790816,246485909110,246520175069,246653667075,246464154349,246488762329,246489125675,246489963546,246631057697,226073863049,246602716379', 0141, 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-15 09:59:22 Duration: 5s313ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46680, 418, '73908885850066800812,229703561720,229713363148,229676428588,229639235464,229716060314,229699305973,229711267084,229703560710,216921980607,229826440918,229710805165,229713412143,229709203853,229677743454,229714509814,229711048601,216923756178,229642446776,229712687088,229714177379,229641265965,229714616872,229832622733,229880853658,229710821430,229710049198,229701270206,229639192834,229677321213,229798834957,229638492429,229775515981,229826736075,229776112134,216921845464', '246503873355,246533792829,246459273940,246449170912,246550333557,246523272027,246542496888,,246439207189,246626738083,246535790320,246528603748,246540403654,246460173658,246533789797,246493230521,246480119611,246481641320,246533250521,246533950623,246476053232,246529192526,226026719009,226041546774,246544362424,246541783250,246533829701,246449518903,246460020815,246618186890,246449516074,246575287181,246624517889,,246442457697', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-15 11:15:18 Duration: 5s242ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 18m37s 10 1m40s 2m9s 1m51s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 08 2 4m4s 2m2s 09 1 1m51s 1m51s 11 3 5m23s 1m47s 12 1 1m58s 1m58s 13 3 5m19s 1m46s [ User: intelifix - Total duration: 18m37s - Times executed: 10 ]
[ Application: psql - Total duration: 18m37s - Times executed: 10 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01547);
Date: 2026-07-15 08:59:42 Duration: 2m9s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01552);
Date: 2026-07-15 12:01:34 Duration: 1m58s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01546);
Date: 2026-07-15 08:48:33 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql
6 14m26s 3 2m23s 7m52s 4m48s analyze verbose;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 15 05 3 14m26s 4m48s [ User: intelifix - Total duration: 14m26s - Times executed: 3 ]
[ Application: psql - Total duration: 14m26s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-15 05:07:54 Duration: 7m52s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-15 05:12:05 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-15 05:14:28 Duration: 2m23s Database: contagem User: intelifix Remote: [local] Application: psql
7 13m44s 274 159ms 1m29s 3s10ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 00 12 31s774ms 2s647ms 01 11 24s730ms 2s248ms 02 12 24s861ms 2s71ms 03 12 26s568ms 2s214ms 04 11 23s230ms 2s111ms 05 12 25s176ms 2s98ms 06 12 24s858ms 2s71ms 07 12 24s597ms 2s49ms 08 12 30s492ms 2s541ms 09 12 29s898ms 2s491ms 10 12 34s739ms 2s894ms 11 12 1m29s 7s495ms 12 12 2m1s 10s92ms 13 12 31s107ms 2s592ms 14 12 34s570ms 2s880ms 15 12 41s534ms 3s461ms 16 12 29s562ms 2s463ms 17 12 29s475ms 2s456ms 18 12 38s534ms 3s211ms 19 12 27s98ms 2s258ms 20 12 30s252ms 2s521ms 21 12 25s724ms 2s143ms 22 12 25s54ms 2s87ms [ User: intelifix - Total duration: 13m44s - Times executed: 274 ]
[ Application: psql - Total duration: 13m44s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:06:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 11:56:10 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:35:22 Duration: 11s183ms Database: rio User: intelifix Remote: [local] Application: psql
8 10m56s 50 9s689ms 37s183ms 13s131ms create table temp0000285372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 07 11 1m56s 10s547ms 08 6 1m10s 11s820ms 09 6 1m24s 14s40ms 10 9 2m1s 13s482ms 11 15 3m42s 14s839ms 12 3 41s438ms 13s812ms [ User: intelifix - Total duration: 10m56s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 10m56s - Times executed: 50 ]
-
CREATE TABLE temp0000285372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 11:57:48 Duration: 37s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 11:59:18 Duration: 19s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:31:38 Duration: 17s719ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 10m16s 73 1s518ms 40s533ms 8s446ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 07 4 16s894ms 4s223ms 08 2 17s128ms 8s564ms 09 5 1m14s 14s813ms 10 7 1m6s 9s486ms 11 8 1m 7s610ms 12 3 50s680ms 16s893ms 13 4 39s428ms 9s857ms 14 8 59s576ms 7s447ms 15 9 1m29s 9s966ms 16 13 1m21s 6s301ms 17 10 59s926ms 5s992ms [ User: intelifix - Total duration: 10m16s - Times executed: 73 ]
[ Application: [unknown] - Total duration: 10m16s - Times executed: 73 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 12:46:21 Duration: 40s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 15:29:45 Duration: 38s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 09:34:58 Duration: 26s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8m13s 906 151ms 3s204ms 545ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 15 08 127 1m1s 486ms 09 134 1m30s 671ms 10 121 59s794ms 494ms 11 110 56s645ms 514ms 12 14 9s935ms 709ms 13 93 53s834ms 578ms 14 111 57s428ms 517ms 15 108 59s554ms 551ms 16 71 36s214ms 510ms 17 17 8s706ms 512ms [ User: intelifix - Total duration: 8m13s - Times executed: 906 ]
[ Application: [unknown] - Total duration: 8m13s - Times executed: 906 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "266232", "modelo" : "320", "itens" : "241628289209,241657189099,241651201423,241666408495,241629291720,241699992032,241668071734,241658721719,241669997173,241669996163,241703405462,241630703238,241634905365,241715723859,241727917192,241593209904,241727911839,241675703354,241650510514,241675656076,241714743550,241663258806,241603182842,241629179307,241700694760,241674047995,241635336170,241731108402,241608791818,241675625669,241727937979,241730403350,241606045253,241708476574,241708299004,241709571822,241651257286,241731761328,241679159112,241727907393,241699883132,241714008090,241596595577,241599381012,241694696879,241603280203,241666401829,241630975868", "usuario" : "414", "caixa" : "3275668", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-15 09:10:52 Duration: 3s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "103107", "modelo" : "295", "itens" : "230035578499,230041138302,230050021425,229963156078,230051199811,230043135365,229990574545,230033400106,230034865063,230038117894,230011021334,230051939715,230043108796,230044075367,230052452526,230037967677,230053588911", "usuario" : "414", "caixa" : "1195751", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-15 09:40:53 Duration: 2s316ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "266490", "modelo" : "320", "itens" : "241634547395,241608655665,241608735976,241595498690,241712732243,241708630406,241652305660,241603121624,241699972232,230043559806,241711587293,241667086575,241674152529,241667626078,241698668299,241603921534,241614609602,241679131938,241727038688,241649466079,241711201016,241619588102,241646305355,241598592035,241614553031,241691200613,241691517590,241679110522,241673185577,241733078189,241651617781,241655489292,241655575261,241639347291,241728020615,241730330212,241716607087,241607102237,241635387892,241660376874,241599516176,241619333756,241716495056,241675515658,241691640813,241608860007,241700897989", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-15 09:25:41 Duration: 2s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7m21s 159 154ms 14s807ms 2s774ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 00 6 16s933ms 2s822ms 01 6 8s183ms 1s363ms 02 4 6s773ms 1s693ms 03 5 8s218ms 1s643ms 04 6 9s470ms 1s578ms 05 5 6s638ms 1s327ms 07 10 31s249ms 3s124ms 08 12 40s920ms 3s410ms 09 12 53s110ms 4s425ms 10 12 37s357ms 3s113ms 11 12 49s976ms 4s164ms 12 10 46s638ms 4s663ms 13 9 7s411ms 823ms 14 12 40s580ms 3s381ms 15 12 37s761ms 3s146ms 16 10 17s346ms 1s734ms 17 5 4s595ms 919ms 18 1 154ms 154ms 21 4 6s723ms 1s680ms 22 6 11s27ms 1s837ms [ User: intelifix - Total duration: 7m21s - Times executed: 159 ]
[ Application: psql - Total duration: 7m21s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 12:25:16 Duration: 14s807ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 09:35:11 Duration: 10s75ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 00:05:11 Duration: 9s516ms Database: rio User: intelifix Remote: [local] Application: psql
12 7m1s 33 10s377ms 14s630ms 12s766ms create table temp0000285394 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 08 11 2m16s 12s434ms 09 12 2m35s 12s988ms 10 10 2m8s 12s865ms [ User: intelifix - Total duration: 7m1s - Times executed: 33 ]
[ Application: [unknown] - Total duration: 7m1s - Times executed: 33 ]
-
CREATE TABLE temp0000285394 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 10:52:07 Duration: 14s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285394 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:15:17 Duration: 14s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285394 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:01:53 Duration: 14s285ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m14s 5 4s424ms 1m27s 50s829ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 18 1 1m27s 1m27s 20 2 1m23s 41s785ms 23 2 1m22s 41s304ms [ User: intelifix - Total duration: 2m46s - Times executed: 4 ]
[ User: lenon - Total duration: 1m27s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m14s - Times executed: 5 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-15 18:36:09 Duration: 1m27s Database: rio User: lenon 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-15 20:08:50 Duration: 1m19s 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-15 23:37:17 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
14 4m12s 19 10s891ms 33s807ms 13s268ms 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 15 15 9 2m10s 14s546ms 16 5 1m 12s172ms 17 5 1m 12s63ms [ User: intelifix - Total duration: 4m12s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m12s - Times executed: 19 ]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 15:34:05 Duration: 33s807ms 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-15 17:00:52 Duration: 14s119ms 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-15 15:35:33 Duration: 13s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 4m 18 10s581ms 16s623ms 13s345ms create table temp0000285396 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 15 08 12 2m30s 12s543ms 09 6 1m29s 14s950ms [ User: intelifix - Total duration: 4m - Times executed: 18 ]
[ Application: [unknown] - Total duration: 4m - Times executed: 18 ]
-
CREATE TABLE temp0000285396 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:00:49 Duration: 16s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285396 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:06:04 Duration: 16s101ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285396 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 08:55:11 Duration: 15s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m46s 6 277ms 1m1s 37s695ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 18 2 1m53s 56s919ms 20 2 1m2s 31s83ms 23 2 50s165ms 25s82ms [ User: lenon - Total duration: 1m53s - Times executed: 2 ]
[ User: intelifix - Total duration: 1m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m46s - Times executed: 6 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-15 20:05:46 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-15 18:32:59 Duration: 57s101ms Database: rio User: lenon Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-15 18:22:41 Duration: 56s737ms Database: rio User: lenon Remote: [local] Application: pg_dump
17 3m36s 16 11s443ms 14s726ms 13s514ms create table temp0000285392 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 09 16 3m36s 13s514ms [ User: intelifix - Total duration: 3m36s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m36s - Times executed: 16 ]
-
CREATE TABLE temp0000285392 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:51:24 Duration: 14s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285392 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:47:54 Duration: 14s555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285392 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:56:17 Duration: 14s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 3m13s 14 10s742ms 32s971ms 13s789ms create table temp0000285494 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 15 14 3 57s548ms 19s182ms 15 11 2m15s 12s318ms [ User: intelifix - Total duration: 3m13s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 14 ]
-
CREATE TABLE temp0000285494 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 14:59:15 Duration: 32s971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285494 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 15:46:00 Duration: 14s168ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285494 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 14:59:34 Duration: 13s372ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m33s 8 2s236ms 36s233ms 19s161ms copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 18 2 1m4s 32s237ms 20 3 47s880ms 15s960ms 23 3 40s935ms 13s645ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ User: lenon - Total duration: 1m4s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m33s - Times executed: 8 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-15 20:06:24 Duration: 36s233ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-15 18:33:34 Duration: 33s646ms Database: rio User: lenon Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-15 18:23:13 Duration: 30s827ms Database: rio User: lenon Remote: [local] Application: pg_dump
20 2m24s 2 20s106ms 2m4s 1m12s copy auditor.auditor_2026_05 (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 15 23 2 2m24s 1m12s [ User: intelifix - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m24s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (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-15 23:13:29 Duration: 2m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (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-15 23:47:29 Duration: 20s106ms Database: contagem 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,715 23m25s 150ms 6s505ms 819ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 07 51 46s986ms 921ms 08 144 2m12s 918ms 09 242 3m23s 840ms 10 253 3m14s 770ms 11 165 2m25s 882ms 12 77 48s118ms 624ms 13 130 1m53s 875ms 14 268 3m45s 842ms 15 189 2m28s 786ms 16 147 1m54s 779ms 17 49 31s268ms 638ms [ User: intelifix - Total duration: 23m25s - Times executed: 1715 ]
[ Application: [unknown] - Total duration: 23m25s - Times executed: 1715 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46717, 418, '834120918000230,241597682743,241636139616,241663099800,241667647090,241730931415,241689139502,241646287373,241603993437,241679925056,241676647070,241636021928,241704304854,241704320311,241617414758,241678343140,241663857079,241598817286,241617418596,241689391424,241647376279,241629363747,241615988288,241598144056,241659660913,241672177285,241713729500,241713734147,241654584547,241676715158,241679919196,241622633438,241646404759,241706846572,241660129498,241617327880,241676726068,241679924753,241708738496,241649692847,241614539214,241728693441,241616091734,241659881518,241614484663,241635302632,241728738394,241731257080,241646324347', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-15 13:53:47 Duration: 6s505ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46679, 418, '270911029413103298,229751118808,229783470215,229660495171,229750565667,229734547392,229661478487,216938552628,229783512239,229934048489,229750531725,229687534151,229934229595,229860199396,229755719616,229754840002,229879541824,229690604260,229689747576,216944727192,229750083645,229751824668,229661968288,229934056470,229879615164,229666249919,229667249904,229782157392,229690132239,229755031637,229751826385,229661621836,229726744061,229865821832,216940282135,229671724561,216944917895,229671331616,229814884851,229933043454,229786013246', '246566654667,246587104261,246544213139,246529751223,246546476266,246457169111,246477581631,246587946475,226382305272,246562956079,246519144957,246066948894,246651585761,246562267493,246559780102,246652956568,246516665467,246516206982,246456709414,246530629804,246563028285,246487201526,246236603556,246652451638,246495708393,246492102644,246587188690,246516218296,246563728892,246531790816,246485909110,246520175069,246653667075,246464154349,246488762329,246489125675,246489963546,246631057697,226073863049,246602716379', 0141, 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-15 09:59:22 Duration: 5s313ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46680, 418, '73908885850066800812,229703561720,229713363148,229676428588,229639235464,229716060314,229699305973,229711267084,229703560710,216921980607,229826440918,229710805165,229713412143,229709203853,229677743454,229714509814,229711048601,216923756178,229642446776,229712687088,229714177379,229641265965,229714616872,229832622733,229880853658,229710821430,229710049198,229701270206,229639192834,229677321213,229798834957,229638492429,229775515981,229826736075,229776112134,216921845464', '246503873355,246533792829,246459273940,246449170912,246550333557,246523272027,246542496888,,246439207189,246626738083,246535790320,246528603748,246540403654,246460173658,246533789797,246493230521,246480119611,246481641320,246533250521,246533950623,246476053232,246529192526,226026719009,226041546774,246544362424,246541783250,246533829701,246449518903,246460020815,246618186890,246449516074,246575287181,246624517889,,246442457697', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-15 11:15:18 Duration: 5s242ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 906 8m13s 151ms 3s204ms 545ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 08 127 1m1s 486ms 09 134 1m30s 671ms 10 121 59s794ms 494ms 11 110 56s645ms 514ms 12 14 9s935ms 709ms 13 93 53s834ms 578ms 14 111 57s428ms 517ms 15 108 59s554ms 551ms 16 71 36s214ms 510ms 17 17 8s706ms 512ms [ User: intelifix - Total duration: 8m13s - Times executed: 906 ]
[ Application: [unknown] - Total duration: 8m13s - Times executed: 906 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "266232", "modelo" : "320", "itens" : "241628289209,241657189099,241651201423,241666408495,241629291720,241699992032,241668071734,241658721719,241669997173,241669996163,241703405462,241630703238,241634905365,241715723859,241727917192,241593209904,241727911839,241675703354,241650510514,241675656076,241714743550,241663258806,241603182842,241629179307,241700694760,241674047995,241635336170,241731108402,241608791818,241675625669,241727937979,241730403350,241606045253,241708476574,241708299004,241709571822,241651257286,241731761328,241679159112,241727907393,241699883132,241714008090,241596595577,241599381012,241694696879,241603280203,241666401829,241630975868", "usuario" : "414", "caixa" : "3275668", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-15 09:10:52 Duration: 3s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "103107", "modelo" : "295", "itens" : "230035578499,230041138302,230050021425,229963156078,230051199811,230043135365,229990574545,230033400106,230034865063,230038117894,230011021334,230051939715,230043108796,230044075367,230052452526,230037967677,230053588911", "usuario" : "414", "caixa" : "1195751", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-15 09:40:53 Duration: 2s316ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "266490", "modelo" : "320", "itens" : "241634547395,241608655665,241608735976,241595498690,241712732243,241708630406,241652305660,241603121624,241699972232,230043559806,241711587293,241667086575,241674152529,241667626078,241698668299,241603921534,241614609602,241679131938,241727038688,241649466079,241711201016,241619588102,241646305355,241598592035,241614553031,241691200613,241691517590,241679110522,241673185577,241733078189,241651617781,241655489292,241655575261,241639347291,241728020615,241730330212,241716607087,241607102237,241635387892,241660376874,241599516176,241619333756,241716495056,241675515658,241691640813,241608860007,241700897989", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-15 09:25:41 Duration: 2s182ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 308 1h10m42s 152ms 8m32s 13s773ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 07 6 13m47s 2m17s 08 46 6m43s 8s775ms 09 37 1m29s 2s417ms 10 23 2m 5s250ms 11 28 8m11s 17s556ms 12 6 12m11s 2m1s 13 32 32s355ms 1s11ms 14 32 4m20s 8s133ms 15 40 13m9s 19s739ms 16 33 2m20s 4s258ms 17 24 5m52s 14s702ms 18 1 2s237ms 2s237ms [ User: intelifix - Total duration: 1h10m42s - Times executed: 308 ]
[ Application: [unknown] - Total duration: 1h10m42s - Times executed: 308 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027040, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 07:29:45 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027083, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 11:56:02 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 12:06:34 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 274 13m44s 159ms 1m29s 3s10ms call rs_giga_triagem (?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 00 12 31s774ms 2s647ms 01 11 24s730ms 2s248ms 02 12 24s861ms 2s71ms 03 12 26s568ms 2s214ms 04 11 23s230ms 2s111ms 05 12 25s176ms 2s98ms 06 12 24s858ms 2s71ms 07 12 24s597ms 2s49ms 08 12 30s492ms 2s541ms 09 12 29s898ms 2s491ms 10 12 34s739ms 2s894ms 11 12 1m29s 7s495ms 12 12 2m1s 10s92ms 13 12 31s107ms 2s592ms 14 12 34s570ms 2s880ms 15 12 41s534ms 3s461ms 16 12 29s562ms 2s463ms 17 12 29s475ms 2s456ms 18 12 38s534ms 3s211ms 19 12 27s98ms 2s258ms 20 12 30s252ms 2s521ms 21 12 25s724ms 2s143ms 22 12 25s54ms 2s87ms [ User: intelifix - Total duration: 13m44s - Times executed: 274 ]
[ Application: psql - Total duration: 13m44s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:06:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 11:56:10 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:35:22 Duration: 11s183ms Database: rio User: intelifix Remote: [local] Application: psql
5 188 31s515ms 150ms 264ms 167ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 01 1 179ms 179ms 05 4 655ms 163ms 07 1 152ms 152ms 08 21 3s590ms 170ms 09 32 5s333ms 166ms 10 24 3s932ms 163ms 11 31 5s317ms 171ms 12 8 1s328ms 166ms 13 17 2s784ms 163ms 14 21 3s549ms 169ms 15 18 3s15ms 167ms 16 10 1s675ms 167ms [ User: intelifix - Total duration: 31s515ms - Times executed: 188 ]
[ Application: [unknown] - Total duration: 31s515ms - Times executed: 188 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-15 11:56:43 Duration: 264ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-07-15 14:44:06 Duration: 239ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 00;
Date: 2026-07-15 08:46:06 Duration: 228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 159 7m21s 154ms 14s807ms 2s774ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 15 00 6 16s933ms 2s822ms 01 6 8s183ms 1s363ms 02 4 6s773ms 1s693ms 03 5 8s218ms 1s643ms 04 6 9s470ms 1s578ms 05 5 6s638ms 1s327ms 07 10 31s249ms 3s124ms 08 12 40s920ms 3s410ms 09 12 53s110ms 4s425ms 10 12 37s357ms 3s113ms 11 12 49s976ms 4s164ms 12 10 46s638ms 4s663ms 13 9 7s411ms 823ms 14 12 40s580ms 3s381ms 15 12 37s761ms 3s146ms 16 10 17s346ms 1s734ms 17 5 4s595ms 919ms 18 1 154ms 154ms 21 4 6s723ms 1s680ms 22 6 11s27ms 1s837ms [ User: intelifix - Total duration: 7m21s - Times executed: 159 ]
[ Application: psql - Total duration: 7m21s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 12:25:16 Duration: 14s807ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 09:35:11 Duration: 10s75ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 00:05:11 Duration: 9s516ms Database: rio User: intelifix Remote: [local] Application: psql
7 123 50s544ms 179ms 678ms 410ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 07 4 1s460ms 365ms 08 17 6s682ms 393ms 09 19 7s575ms 398ms 10 18 7s826ms 434ms 11 14 6s433ms 459ms 12 4 1s338ms 334ms 13 8 3s326ms 415ms 14 6 2s566ms 427ms 15 8 3s47ms 380ms 16 11 4s538ms 412ms 17 14 5s749ms 410ms [ User: intelifix - Total duration: 50s544ms - Times executed: 123 ]
[ Application: [unknown] - Total duration: 50s544ms - Times executed: 123 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-15 11:57:52 Duration: 678ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-15 09:00:08 Duration: 672ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-15 15:34:43 Duration: 613ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 108 50s272ms 282ms 710ms 465ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 01 3 1s258ms 419ms 05 4 1s436ms 359ms 06 1 332ms 332ms 07 8 3s280ms 410ms 08 12 5s755ms 479ms 09 11 5s603ms 509ms 10 9 4s265ms 473ms 11 9 4s163ms 462ms 12 10 4s894ms 489ms 13 10 4s598ms 459ms 14 9 4s227ms 469ms 15 7 3s718ms 531ms 16 9 4s349ms 483ms 17 4 1s627ms 406ms 20 1 391ms 391ms 21 1 367ms 367ms [ User: lenon - Total duration: 50s272ms - Times executed: 108 ]
[ Application: [unknown] - Total duration: 50s272ms - Times executed: 108 ]
-
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-15 09:41:56 Duration: 710ms Database: brasilia 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-15 10:35:13 Duration: 703ms Database: brasilia 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-15 15:32:16 Duration: 699ms Database: brasilia User: lenon Remote: [local] Application: [unknown] Bind query: yes
9 108 30s897ms 150ms 8s516ms 286ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 05 1 166ms 166ms 08 1 193ms 193ms 09 4 685ms 171ms 10 2 320ms 160ms 11 17 3s946ms 232ms 12 10 10s790ms 1s79ms 13 2 551ms 275ms 14 12 2s376ms 198ms 15 26 5s568ms 214ms 16 24 4s513ms 188ms 17 9 1s784ms 198ms [ User: intelifix - Total duration: 30s897ms - Times executed: 108 ]
[ Application: [unknown] - Total duration: 30s897ms - Times executed: 108 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-07-15", "data-ate" : "2026-07-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 507 }');
Date: 2026-07-15 12:06:59 Duration: 8s516ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "332", "data-de" : "2026-07-15", "data-ate" : "2026-07-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 401 }');
Date: 2026-07-15 12:13:59 Duration: 558ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "349", "data-de" : "2026-07-15", "data-ate" : "2026-07-15", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 404 }');
Date: 2026-07-15 12:22:43 Duration: 414ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 104 21s852ms 150ms 391ms 210ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 15 01 6 1s190ms 198ms 05 17 4s47ms 238ms 07 6 1s268ms 211ms 08 9 1s710ms 190ms 09 8 1s700ms 212ms 10 17 3s389ms 199ms 11 9 1s848ms 205ms 12 12 2s395ms 199ms 14 5 986ms 197ms 15 10 2s380ms 238ms 16 5 933ms 186ms [ User: intelifix - Total duration: 21s852ms - Times executed: 104 ]
[ Application: [unknown] - Total duration: 21s852ms - Times executed: 104 ]
-
SELECT * FROM RS_TRIAGEM (428, 5, '113', 3, '241738768284,241764869508,241764893955,241779163653,241765623858,241770025353,241767482547,241746029005,241767800715,241766433948,241770185268,241740581818,241763339516,241765421212,241742240106,241745810926', NULL, NULL, 0464, 00);
Date: 2026-07-15 05:09:23 Duration: 391ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241652107784,241635296267,241689777274,241645682231,241645866771,241628191018,241655676685,241691771533,241629494040,241667839814,241671936981,241614611320,241706590712,241732877182', NULL, NULL, 0320, 00);
Date: 2026-07-15 12:34:39 Duration: 380ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241655677796,241691204249,241608875159,241710891031,241652210119,241667764150,241635382337,241616276779', NULL, NULL, 0320, 00);
Date: 2026-07-15 15:09:37 Duration: 365ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 95 55s835ms 379ms 902ms 587ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 01 3 1s672ms 557ms 05 4 1s932ms 483ms 07 5 2s538ms 507ms 08 12 6s985ms 582ms 09 11 6s838ms 621ms 10 9 5s325ms 591ms 11 8 4s527ms 565ms 12 7 4s412ms 630ms 13 8 4s914ms 614ms 14 9 5s379ms 597ms 15 7 4s570ms 652ms 16 8 4s652ms 581ms 17 4 2s86ms 521ms [ User: intelifix - Total duration: 55s835ms - Times executed: 95 ]
[ Application: [unknown] - Total duration: 55s835ms - Times executed: 95 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-15 15:32:16 Duration: 902ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (401, 81, 1);
Date: 2026-07-15 09:41:56 Duration: 874ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (401, 53, 1);
Date: 2026-07-15 10:35:13 Duration: 795ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
12 84 48s300ms 153ms 1s946ms 575ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 08 16 7s358ms 459ms 10 3 2s171ms 723ms 11 3 1s673ms 557ms 13 20 14s104ms 705ms 14 8 5s333ms 666ms 15 17 9s322ms 548ms 16 14 6s252ms 446ms 17 3 2s84ms 694ms [ User: intelifix - Total duration: 48s300ms - Times executed: 84 ]
[ Application: [unknown] - Total duration: 48s300ms - Times executed: 84 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0266238) LIMIT 1;
Date: 2026-07-15 15:10:37 Duration: 1s946ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0266231) LIMIT 1;
Date: 2026-07-15 13:30:32 Duration: 1s785ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0266194) LIMIT 1;
Date: 2026-07-15 14:53:34 Duration: 1s554ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 78 18s193ms 151ms 2s639ms 233ms create table temp0000285388 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 08 3 2s967ms 989ms 09 17 3s12ms 177ms 10 24 4s350ms 181ms 11 6 1s263ms 210ms 12 2 568ms 284ms 13 1 182ms 182ms 14 7 1s571ms 224ms 15 1 217ms 217ms 16 17 4s59ms 238ms [ User: intelifix - Total duration: 18s193ms - Times executed: 78 ]
[ Application: [unknown] - Total duration: 18s193ms - Times executed: 78 ]
-
CREATE TABLE temp0000285388 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 08:22:33 Duration: 2s639ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285388 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"81664", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 11:54:58 Duration: 373ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285388 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"81664", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 12:05:00 Duration: 349ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 75 25s894ms 150ms 1s200ms 345ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 15 07 1 213ms 213ms 08 5 960ms 192ms 09 18 6s894ms 383ms 10 12 2s855ms 237ms 11 4 654ms 163ms 12 3 513ms 171ms 13 1 186ms 186ms 14 13 5s759ms 443ms 15 9 4s232ms 470ms 16 9 3s622ms 402ms [ User: intelifix - Total duration: 25s894ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 25s894ms - Times executed: 75 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '241660314545,241655150922,241604228689,241601486772,241667086373,241629770106,241675446785,241617468400,241622563858,241619411418,241608649200,241714776482,241607040312,241619731124,241703360408,241618424262,241604675961,241691521834,241689267999,241615115465,241593870609,241656992134,241655150518,241700184856,241658630925,241709688904,241621035560,241620962041,241699102843,241703425262,241631721834,241652237797,241708704655,241593083450,241689228703,241656993144,241679634545,241672469615,241709402939,241709421123,241651176773,241607312235,241658712627,241620816975,241726136872,241663272242,241682640406,241631838084,241726184857,241712276990,241618336677,241631903445,241691265366,241645935970,241667231315,241635787583,241728327389,241689859404,241691859598,241646232038,241635892746,241677382126,241669824755,241727909919,241647285260,241620730627,241638412139,230043856479,241727331928', '','DEFAULT',051,0320,'', '','', 00);
Date: 2026-07-15 16:13:39 Duration: 1s200ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229907472844,229953640818,229995807693,229957091828,229970767494,229991776065,229964233142,229957799607,229970224153,229940126883,229938486375,229991884157,230018208285,229962187891,230004559513,229959372331,230017986266,229957375974,230012534960,229960216868,230004559311,230003508085,229998035262,229957198505,229958655459,229935259506,229997178905,229935455664,229936454763,229927578284,229929361636,229994336068,230002786769,229996413342,229984915160,230012418103,229937573851,230012427878,229954718284,229991700526,229936400011,229926060113,229997417188,229998108502,229961682433,229921077897,229960447878,229953545353,230000788796,230003503136,229953058101,229995657375,229995227883,229991799198,229936335559,229931773644,229953690621,229948957475,229906295972', '','DEFAULT',051,0287,'', '','', 00);
Date: 2026-07-15 14:21:44 Duration: 1s44ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 1, 26, '229955989408,229992530719,229935199095,229953255370,229930952846,230004948596,230017165872,229955436570,229937963238,229996026278,230015369412,230018003844,229985400416,230002687388,229928044447,229960363954,229991961617,229998040516,230000836074,229995850527,229905912041,229938706778,229998134060,229956327779,229957291219,229921339214,229945972628,229993761131,229931250204,229937067280,229957351932,229956626675,229993273552,229936491737,229927981232,229994368495,229906324864,229993236780,229963925760,230004674350,229949057788,229936433852,229937554152,229986695053,230002721029,229936489615,229930958705,229958896975,229958387071,229984666370,229959712140,229954858298,230000504246,230008918502,229985686784,229931308491,229985117278,229954650322,229928612842,229953164250,229932127292,230002488301,229929907075,229944980422,229925806877,230018387900,230003830318,229957720812,229939621021,230000090211,229949864040,229952755063,229952449601,229937650930,230013860612,229969527182,229938735973,229969688690,229957366175,229934993341,229960442626,229997481516', '','DEFAULT',051,0287,'', '','', 00);
Date: 2026-07-15 14:39:27 Duration: 1s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 73 10m16s 1s518ms 40s533ms 8s446ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 15 07 4 16s894ms 4s223ms 08 2 17s128ms 8s564ms 09 5 1m14s 14s813ms 10 7 1m6s 9s486ms 11 8 1m 7s610ms 12 3 50s680ms 16s893ms 13 4 39s428ms 9s857ms 14 8 59s576ms 7s447ms 15 9 1m29s 9s966ms 16 13 1m21s 6s301ms 17 10 59s926ms 5s992ms [ User: intelifix - Total duration: 10m16s - Times executed: 73 ]
[ Application: [unknown] - Total duration: 10m16s - Times executed: 73 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 12:46:21 Duration: 40s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 15:29:45 Duration: 38s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 09:34:58 Duration: 26s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 68 1m52s 213ms 13s702ms 1s652ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 07 4 2s391ms 597ms 08 9 39s565ms 4s396ms 09 19 22s243ms 1s170ms 10 6 15s149ms 2s524ms 11 8 3s490ms 436ms 12 2 2s852ms 1s426ms 13 8 3s134ms 391ms 14 1 441ms 441ms 15 6 5s821ms 970ms 16 3 5s464ms 1s821ms 17 2 11s787ms 5s893ms [ User: intelifix - Total duration: 1m52s - Times executed: 68 ]
[ Application: psql - Total duration: 1m52s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027047);
Date: 2026-07-15 08:46:41 Duration: 13s702ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027054);
Date: 2026-07-15 09:03:24 Duration: 12s945ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027109);
Date: 2026-07-15 17:14:18 Duration: 10s555ms Database: rio User: intelifix Remote: [local] Application: psql
17 59 15s76ms 152ms 466ms 255ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 07 1 417ms 417ms 08 4 1s119ms 279ms 09 9 2s594ms 288ms 10 4 1s292ms 323ms 11 6 1s553ms 258ms 12 1 273ms 273ms 13 3 836ms 278ms 15 10 2s429ms 242ms 16 21 4s556ms 216ms [ User: intelifix - Total duration: 15s76ms - Times executed: 59 ]
[ Application: [unknown] - Total duration: 15s76ms - Times executed: 59 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"185", "usuario" :"417", "tipo" :"N", "itens" :"003", "nota-fiscal" :"137", "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-15 15:29:17 Duration: 466ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"189", "usuario" :"507", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-15 07:30:07 Duration: 417ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"147", "usuario" :"507", "tipo" :"N", "itens" :"009", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-07-15 10:39:09 Duration: 353ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 57 14s234ms 150ms 812ms 249ms create table temp0000226620 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 15 07 1 154ms 154ms 08 2 338ms 169ms 09 4 771ms 192ms 10 8 1s591ms 198ms 11 4 1s392ms 348ms 13 5 914ms 182ms 14 8 1s883ms 235ms 15 8 2s529ms 316ms 16 7 1s804ms 257ms 17 10 2s855ms 285ms [ User: intelifix - Total duration: 14s234ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 14s234ms - Times executed: 57 ]
-
CREATE TABLE temp0000226620 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"2816", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 11:56:00 Duration: 812ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226620 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"2816", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 15:09:51 Duration: 435ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000226620 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"2", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"2816", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 15:30:32 Duration: 392ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
19 57 14s4ms 151ms 2s64ms 245ms create table temp0000236120 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 07 7 3s726ms 532ms 08 13 3s157ms 242ms 09 13 2s583ms 198ms 10 6 1s34ms 172ms 11 11 2s171ms 197ms 12 7 1s330ms 190ms [ User: intelifix - Total duration: 14s4ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 14s4ms - Times executed: 57 ]
-
CREATE TABLE temp0000236120 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 07:34:51 Duration: 2s64ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236120 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 08:55:08 Duration: 834ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000236120 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-15 07:41:00 Duration: 783ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
20 55 9s12ms 150ms 215ms 163ms select * from rs_modelo_barra_smartcard (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 15 08 3 462ms 154ms 09 16 2s600ms 162ms 10 13 2s130ms 163ms 11 5 829ms 165ms 12 4 682ms 170ms 13 3 464ms 154ms 14 3 481ms 160ms 15 6 1s33ms 172ms 16 1 165ms 165ms 17 1 161ms 161ms [ User: intelifix - Total duration: 9s12ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 9s12ms - Times executed: 55 ]
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (0153);
Date: 2026-07-15 15:30:43 Duration: 215ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (0153);
Date: 2026-07-15 10:06:08 Duration: 197ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELO_BARRA_SMARTCARD (042);
Date: 2026-07-15 12:06:11 Duration: 190ms 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 2m23s 7m52s 4m48s 3 14m26s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 05 3 14m26s 4m48s [ User: intelifix - Total duration: 14m26s - Times executed: 3 ]
[ Application: psql - Total duration: 14m26s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-15 05:07:54 Duration: 7m52s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-15 05:12:05 Duration: 4m11s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-15 05:14:28 Duration: 2m23s Database: contagem User: intelifix Remote: [local] Application: psql
2 2s392ms 10m34s 2m51s 48 2h17m16s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 07 3 7m51s 2m37s 08 3 7m33s 2m31s 09 3 10m7s 3m22s 10 3 10m22s 3m27s 11 3 9m53s 3m17s 12 3 9m30s 3m10s 13 3 9m39s 3m13s 14 3 7m56s 2m38s 15 3 11m18s 3m46s 16 3 9m27s 3m9s 17 3 8m41s 2m53s 18 3 6m39s 2m13s 19 3 7m40s 2m33s 20 3 7m27s 2m29s 21 3 7m1s 2m20s 22 3 6m4s 2m1s [ User: intelifix - Total duration: 2h17m16s - Times executed: 48 ]
[ Application: psql - Total duration: 2h17m16s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-15 15:15:35 Duration: 10m34s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-15 10:14:34 Duration: 9m33s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-15 09:14:30 Duration: 9m28s Database: rio User: intelifix Remote: [local] Application: psql
3 1m40s 2m9s 1m51s 10 18m37s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 08 2 4m4s 2m2s 09 1 1m51s 1m51s 11 3 5m23s 1m47s 12 1 1m58s 1m58s 13 3 5m19s 1m46s [ User: intelifix - Total duration: 18m37s - Times executed: 10 ]
[ Application: psql - Total duration: 18m37s - Times executed: 10 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01547);
Date: 2026-07-15 08:59:42 Duration: 2m9s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 416); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01552);
Date: 2026-07-15 12:01:34 Duration: 1m58s Database: contagem User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 409); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL (01546);
Date: 2026-07-15 08:48:33 Duration: 1m55s Database: contagem User: intelifix Remote: [local] Application: psql
4 445ms 4m43s 1m45s 45 1h18m45s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 07 3 4m34s 1m31s 08 3 5m17s 1m45s 09 3 5m51s 1m57s 10 3 5m28s 1m49s 11 2 5m5s 2m32s 12 3 5m36s 1m52s 13 2 5m19s 2m39s 14 3 5m15s 1m45s 15 3 5m16s 1m45s 16 2 5m20s 2m40s 17 3 4m38s 1m32s 18 3 4m5s 1m21s 19 3 4m30s 1m30s 20 3 4m11s 1m23s 21 3 4m8s 1m22s 22 3 4m6s 1m22s [ User: intelifix - Total duration: 1h18m45s - Times executed: 45 ]
[ Application: psql - Total duration: 1h18m45s - Times executed: 45 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-15 09:20:55 Duration: 4m43s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-15 14:18:07 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-15 12:20:01 Duration: 4m33s Database: brasilia User: intelifix Remote: [local] Application: psql
5 20s106ms 2m4s 1m12s 2 2m24s copy auditor.auditor_2026_05 (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 15 23 2 2m24s 1m12s [ User: intelifix - Total duration: 2m24s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m24s - Times executed: 2 ]
-
COPY auditor.auditor_2026_05 (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-15 23:13:29 Duration: 2m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_05 (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-15 23:47:29 Duration: 20s106ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
6 4s424ms 1m27s 50s829ms 5 4m14s 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 15 18 1 1m27s 1m27s 20 2 1m23s 41s785ms 23 2 1m22s 41s304ms [ User: intelifix - Total duration: 2m46s - Times executed: 4 ]
[ User: lenon - Total duration: 1m27s - Times executed: 1 ]
[ Application: pg_dump - Total duration: 4m14s - Times executed: 5 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-15 18:36:09 Duration: 1m27s Database: rio User: lenon 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-15 20:08:50 Duration: 1m19s 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-15 23:37:17 Duration: 1m18s Database: rio User: intelifix Remote: [local] Application: pg_dump
7 277ms 1m1s 37s695ms 6 3m46s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 18 2 1m53s 56s919ms 20 2 1m2s 31s83ms 23 2 50s165ms 25s82ms [ User: lenon - Total duration: 1m53s - Times executed: 2 ]
[ User: intelifix - Total duration: 1m52s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 3m46s - Times executed: 6 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-15 20:05:46 Duration: 1m1s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-15 18:32:59 Duration: 57s101ms Database: rio User: lenon Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-15 18:22:41 Duration: 56s737ms Database: rio User: lenon Remote: [local] Application: pg_dump
8 2s236ms 36s233ms 19s161ms 8 2m33s copy public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 18 2 1m4s 32s237ms 20 3 47s880ms 15s960ms 23 3 40s935ms 13s645ms [ User: intelifix - Total duration: 1m28s - Times executed: 6 ]
[ User: lenon - Total duration: 1m4s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m33s - Times executed: 8 ]
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-15 20:06:24 Duration: 36s233ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-15 18:33:34 Duration: 33s646ms Database: rio User: lenon Remote: [local] Application: pg_dump
-
COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) TO stdout;
Date: 2026-07-15 18:23:13 Duration: 30s827ms Database: rio User: lenon Remote: [local] Application: pg_dump
9 10s742ms 32s971ms 13s789ms 14 3m13s create table temp0000285494 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 14 3 57s548ms 19s182ms 15 11 2m15s 12s318ms [ User: intelifix - Total duration: 3m13s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 14 ]
-
CREATE TABLE temp0000285494 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 14:59:15 Duration: 32s971ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285494 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 15:46:00 Duration: 14s168ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285494 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 14:59:34 Duration: 13s372ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 152ms 8m32s 13s773ms 308 1h10m42s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 15 07 6 13m47s 2m17s 08 46 6m43s 8s775ms 09 37 1m29s 2s417ms 10 23 2m 5s250ms 11 28 8m11s 17s556ms 12 6 12m11s 2m1s 13 32 32s355ms 1s11ms 14 32 4m20s 8s133ms 15 40 13m9s 19s739ms 16 33 2m20s 4s258ms 17 24 5m52s 14s702ms 18 1 2s237ms 2s237ms [ User: intelifix - Total duration: 1h10m42s - Times executed: 308 ]
[ Application: [unknown] - Total duration: 1h10m42s - Times executed: 308 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027040, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 07:29:45 Duration: 8m32s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027083, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 11:56:02 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027085, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-15 12:06:34 Duration: 6m35s Database: rio User: intelifix Remote: [local] Application: [unknown]
11 11s443ms 14s726ms 13s514ms 16 3m36s create table temp0000285392 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 09 16 3m36s 13s514ms [ User: intelifix - Total duration: 3m36s - Times executed: 16 ]
[ Application: [unknown] - Total duration: 3m36s - Times executed: 16 ]
-
CREATE TABLE temp0000285392 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:51:24 Duration: 14s726ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285392 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:47:54 Duration: 14s555ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285392 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:56:17 Duration: 14s489ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s581ms 16s623ms 13s345ms 18 4m create table temp0000285396 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 08 12 2m30s 12s543ms 09 6 1m29s 14s950ms [ User: intelifix - Total duration: 4m - Times executed: 18 ]
[ Application: [unknown] - Total duration: 4m - Times executed: 18 ]
-
CREATE TABLE temp0000285396 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:00:49 Duration: 16s623ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285396 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:06:04 Duration: 16s101ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285396 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 08:55:11 Duration: 15s581ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 10s891ms 33s807ms 13s268ms 19 4m12s create table temp0000285498 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 15 9 2m10s 14s546ms 16 5 1m 12s172ms 17 5 1m 12s63ms [ User: intelifix - Total duration: 4m12s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 4m12s - Times executed: 19 ]
-
CREATE TABLE temp0000285498 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 15:34:05 Duration: 33s807ms 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-15 17:00:52 Duration: 14s119ms 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-15 15:35:33 Duration: 13s250ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 9s689ms 37s183ms 13s131ms 50 10m56s create table temp0000285372 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 15 07 11 1m56s 10s547ms 08 6 1m10s 11s820ms 09 6 1m24s 14s40ms 10 9 2m1s 13s482ms 11 15 3m42s 14s839ms 12 3 41s438ms 13s812ms [ User: intelifix - Total duration: 10m56s - Times executed: 50 ]
[ Application: [unknown] - Total duration: 10m56s - Times executed: 50 ]
-
CREATE TABLE temp0000285372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 11:57:48 Duration: 37s183ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 11:59:18 Duration: 19s991ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285372 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:31:38 Duration: 17s719ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 10s377ms 14s630ms 12s766ms 33 7m1s create table temp0000285394 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 15 08 11 2m16s 12s434ms 09 12 2m35s 12s988ms 10 10 2m8s 12s865ms [ User: intelifix - Total duration: 7m1s - Times executed: 33 ]
[ Application: [unknown] - Total duration: 7m1s - Times executed: 33 ]
-
CREATE TABLE temp0000285394 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 10:52:07 Duration: 14s630ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285394 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:15:17 Duration: 14s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000285394 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-15 09:01:53 Duration: 14s285ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 1s518ms 40s533ms 8s446ms 73 10m16s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 07 4 16s894ms 4s223ms 08 2 17s128ms 8s564ms 09 5 1m14s 14s813ms 10 7 1m6s 9s486ms 11 8 1m 7s610ms 12 3 50s680ms 16s893ms 13 4 39s428ms 9s857ms 14 8 59s576ms 7s447ms 15 9 1m29s 9s966ms 16 13 1m21s 6s301ms 17 10 59s926ms 5s992ms [ User: intelifix - Total duration: 10m16s - Times executed: 73 ]
[ Application: [unknown] - Total duration: 10m16s - Times executed: 73 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 12:46:21 Duration: 40s533ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 15:29:45 Duration: 38s983ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-15', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-15 09:34:58 Duration: 26s287ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 159ms 1m29s 3s10ms 274 13m44s call rs_giga_triagem (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 00 12 31s774ms 2s647ms 01 11 24s730ms 2s248ms 02 12 24s861ms 2s71ms 03 12 26s568ms 2s214ms 04 11 23s230ms 2s111ms 05 12 25s176ms 2s98ms 06 12 24s858ms 2s71ms 07 12 24s597ms 2s49ms 08 12 30s492ms 2s541ms 09 12 29s898ms 2s491ms 10 12 34s739ms 2s894ms 11 12 1m29s 7s495ms 12 12 2m1s 10s92ms 13 12 31s107ms 2s592ms 14 12 34s570ms 2s880ms 15 12 41s534ms 3s461ms 16 12 29s562ms 2s463ms 17 12 29s475ms 2s456ms 18 12 38s534ms 3s211ms 19 12 27s98ms 2s258ms 20 12 30s252ms 2s521ms 21 12 25s724ms 2s143ms 22 12 25s54ms 2s87ms [ User: intelifix - Total duration: 13m44s - Times executed: 274 ]
[ Application: psql - Total duration: 13m44s - Times executed: 274 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:06:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 11:56:10 Duration: 1m2s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-15 12:35:22 Duration: 11s183ms Database: rio User: intelifix Remote: [local] Application: psql
18 154ms 14s807ms 2s774ms 159 7m21s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 15 00 6 16s933ms 2s822ms 01 6 8s183ms 1s363ms 02 4 6s773ms 1s693ms 03 5 8s218ms 1s643ms 04 6 9s470ms 1s578ms 05 5 6s638ms 1s327ms 07 10 31s249ms 3s124ms 08 12 40s920ms 3s410ms 09 12 53s110ms 4s425ms 10 12 37s357ms 3s113ms 11 12 49s976ms 4s164ms 12 10 46s638ms 4s663ms 13 9 7s411ms 823ms 14 12 40s580ms 3s381ms 15 12 37s761ms 3s146ms 16 10 17s346ms 1s734ms 17 5 4s595ms 919ms 18 1 154ms 154ms 21 4 6s723ms 1s680ms 22 6 11s27ms 1s837ms [ User: intelifix - Total duration: 7m21s - Times executed: 159 ]
[ Application: psql - Total duration: 7m21s - Times executed: 159 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 12:25:16 Duration: 14s807ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 09:35:11 Duration: 10s75ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-15 00:05:11 Duration: 9s516ms Database: rio User: intelifix Remote: [local] Application: psql
19 213ms 13s702ms 1s652ms 68 1m52s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 07 4 2s391ms 597ms 08 9 39s565ms 4s396ms 09 19 22s243ms 1s170ms 10 6 15s149ms 2s524ms 11 8 3s490ms 436ms 12 2 2s852ms 1s426ms 13 8 3s134ms 391ms 14 1 441ms 441ms 15 6 5s821ms 970ms 16 3 5s464ms 1s821ms 17 2 11s787ms 5s893ms [ User: intelifix - Total duration: 1m52s - Times executed: 68 ]
[ Application: psql - Total duration: 1m52s - Times executed: 68 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027047);
Date: 2026-07-15 08:46:41 Duration: 13s702ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027054);
Date: 2026-07-15 09:03:24 Duration: 12s945ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 433); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027109);
Date: 2026-07-15 17:14:18 Duration: 10s555ms Database: rio User: intelifix Remote: [local] Application: psql
20 150ms 6s505ms 819ms 1,715 23m25s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 15 07 51 46s986ms 921ms 08 144 2m12s 918ms 09 242 3m23s 840ms 10 253 3m14s 770ms 11 165 2m25s 882ms 12 77 48s118ms 624ms 13 130 1m53s 875ms 14 268 3m45s 842ms 15 189 2m28s 786ms 16 147 1m54s 779ms 17 49 31s268ms 638ms [ User: intelifix - Total duration: 23m25s - Times executed: 1715 ]
[ Application: [unknown] - Total duration: 23m25s - Times executed: 1715 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46717, 418, '834120918000230,241597682743,241636139616,241663099800,241667647090,241730931415,241689139502,241646287373,241603993437,241679925056,241676647070,241636021928,241704304854,241704320311,241617414758,241678343140,241663857079,241598817286,241617418596,241689391424,241647376279,241629363747,241615988288,241598144056,241659660913,241672177285,241713729500,241713734147,241654584547,241676715158,241679919196,241622633438,241646404759,241706846572,241660129498,241617327880,241676726068,241679924753,241708738496,241649692847,241614539214,241728693441,241616091734,241659881518,241614484663,241635302632,241728738394,241731257080,241646324347', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-15 13:53:47 Duration: 6s505ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46679, 418, '270911029413103298,229751118808,229783470215,229660495171,229750565667,229734547392,229661478487,216938552628,229783512239,229934048489,229750531725,229687534151,229934229595,229860199396,229755719616,229754840002,229879541824,229690604260,229689747576,216944727192,229750083645,229751824668,229661968288,229934056470,229879615164,229666249919,229667249904,229782157392,229690132239,229755031637,229751826385,229661621836,229726744061,229865821832,216940282135,229671724561,216944917895,229671331616,229814884851,229933043454,229786013246', '246566654667,246587104261,246544213139,246529751223,246546476266,246457169111,246477581631,246587946475,226382305272,246562956079,246519144957,246066948894,246651585761,246562267493,246559780102,246652956568,246516665467,246516206982,246456709414,246530629804,246563028285,246487201526,246236603556,246652451638,246495708393,246492102644,246587188690,246516218296,246563728892,246531790816,246485909110,246520175069,246653667075,246464154349,246488762329,246489125675,246489963546,246631057697,226073863049,246602716379', 0141, 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-15 09:59:22 Duration: 5s313ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (46680, 418, '73908885850066800812,229703561720,229713363148,229676428588,229639235464,229716060314,229699305973,229711267084,229703560710,216921980607,229826440918,229710805165,229713412143,229709203853,229677743454,229714509814,229711048601,216923756178,229642446776,229712687088,229714177379,229641265965,229714616872,229832622733,229880853658,229710821430,229710049198,229701270206,229639192834,229677321213,229798834957,229638492429,229775515981,229826736075,229776112134,216921845464', '246503873355,246533792829,246459273940,246449170912,246550333557,246523272027,246542496888,,246439207189,246626738083,246535790320,246528603748,246540403654,246460173658,246533789797,246493230521,246480119611,246481641320,246533250521,246533950623,246476053232,246529192526,226026719009,226041546774,246544362424,246541783250,246533829701,246449518903,246460020815,246618186890,246449516074,246575287181,246624517889,,246442457697', 0137, 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":""}]', '$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$', '', 00);
Date: 2026-07-15 11:15:18 Duration: 5s242ms Database: contagem 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 5 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 15 15 1 0ms 0ms 18 2 0ms 0ms 19 2 0ms 0ms [ User: intelifix - Total duration: 4s231ms - Times executed: 4 ]
[ User: lenon - Total duration: 699ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 2s936ms - Times executed: 2 ]
[ Application: psql - Total duration: 1s994ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 26,814 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 49 FATAL entries
- 7437 ERROR entries
- 14 WARNING entries
- 21 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,621 Max number of times the same event was reported
- 7,521 Total events found
Rank Times reported Error 1 4,621 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 15 00 114 01 114 02 115 03 101 04 112 05 118 06 116 07 277 08 386 09 458 10 438 11 402 12 201 13 206 14 369 15 393 16 233 17 122 18 59 19 59 20 60 21 59 22 60 23 49 - ERROR: prepared statement "_PLAN0000000029A82A90" does not exist
- ERROR: prepared statement "_PLAN000000003A6C3960" does not exist
- ERROR: prepared statement "_PLAN0000000029A55740" does not exist
Statement: DEALLOCATE "_PLAN0000000029A82A90"
Date: 2026-07-15 00:00:14 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003A6C3960"
Date: 2026-07-15 00:00:24 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029A55740"
Date: 2026-07-15 00:01:14 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 1,626 ERROR: could not create file "...": No space left on device
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 15 12 1,626 - ERROR: could not create file "pg_tblspc/16385/PG_18_202506291/358220/2479741": No space left on device
- ERROR: could not create file "pg_tblspc/16385/PG_18_202506291/358220/2479742": No space left on device
- ERROR: could not create file "pg_tblspc/16385/PG_18_202506291/358220/2479743": No space left on device
Statement: CREATE TABLE temp0000285386 AS SELECT * FROM RS_LOTES_LISTA('{ "oficina" :"6", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"1065341", "modelo" :"302", "lotes" :"", "lote-stone" :"" }')
Date: 2026-07-15 12:13:12 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: CREATE TABLE temp0000285386 AS SELECT * FROM RS_LOTES_LISTA('{ "oficina" :"6", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"1065341", "modelo" :"0", "lotes" :"", "lote-stone" :"" }')
Date: 2026-07-15 12:13:18 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: CREATE TABLE temp0000285386 AS SELECT * FROM RS_LOTES_LISTA('{ "oficina" :"6", "cliente" :"0", "desde" :"10-07-2026", "ate" :"15-07-2026", "nota-fiscal":"1065341", "modelo" :"0", "lotes" :"", "lote-stone" :"" }')
Date: 2026-07-15 12:13:22 Database: rio Application: [unknown] User: intelifix Remote: [local]
3 553 ERROR: could not extend file "...": No space left on device
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 15 12 553 - ERROR: could not extend file "pg_tblspc/16385/PG_18_202506291/2472802/2477999": No space left on device
- ERROR: could not extend file "pg_tblspc/16385/PG_18_202506291/2472802/2478095": No space left on device
- ERROR: could not extend file "pg_tblspc/16385/PG_18_202506291/2472802/2478112": No space left on device
Context: COPY lote_fechar, line 591
Hint: Check free disk space.
Statement: COPY public.lote_fechar (lot_id, lot_data, usu_id) FROM stdin;Date: 2026-07-15 12:13:19 Database: testes Application: pg_restore User: lenon Remote: [local]
Context: COPY lotes_saidas, line 504
Hint: Check free disk space.
Statement: COPY public.lotes_saidas (lot_id, lot_criacao, lot_data, lot_status, ofi_id, cli_id, usu_id, lot_notafiscal, lot_data_saida, lot_sucata, lot_garantia, lot_transferencias, lot_fatura, lot_datafatura, lot_rejei_data, lot_rejeitado, lot_entrada, lot_completo, lot_status_vivo, lot_valorado, is_id, mot_id, lot_numero, lot_obs, lot_def_extras, insp_inicio, insp_user, nf_vivo, lot_inspecao, lot_data_transf, lot_lpn, lot_npn, nf_imagens) FROM stdin;Date: 2026-07-15 12:13:23 Database: testes Application: pg_restore User: lenon Remote: [local]
Context: COPY lotes_saidas_old, line 2
Hint: Check free disk space.
Statement: COPY public.lotes_saidas_old (lot_id, lot_criacao, lot_data, lot_status, ofi_id, cli_id, usu_id, lot_notafiscal, lot_data_saida, lot_sucata, lot_garantia, lot_transferencias, lot_fatura, lot_datafatura, lot_rejei_data, lot_rejeitado, lot_entrada) FROM stdin;Date: 2026-07-15 12:13:23 Database: testes Application: pg_restore User: lenon Remote: [local]
4 406 ERROR: there is no unique constraint matching given keys for referenced table "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 15 12 406 - ERROR: there is no unique constraint matching given keys for referenced table "arquivo_nfs"
- ERROR: there is no unique constraint matching given keys for referenced table "lote_itens"
- ERROR: there is no unique constraint matching given keys for referenced table "grupos"
Statement: ALTER TABLE ONLY public.arquivo_detalhes ADD CONSTRAINT arquivo_detalhes_anf_id_fkey FOREIGN KEY (anf_id) REFERENCES public.arquivo_nfs(anf_id);
Date: 2026-07-15 12:18:59 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: ALTER TABLE ONLY public.arquivo_detalhes ADD CONSTRAINT arquivo_detalhes_li_id_fkey FOREIGN KEY (li_id) REFERENCES public.lote_itens(li_id);
Date: 2026-07-15 12:18:59 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: ALTER TABLE ONLY public.arquivos_clientes ADD CONSTRAINT arquivos_clientes_gru_id_fkey FOREIGN KEY (gru_id) REFERENCES public.grupos(gru_id);
Date: 2026-07-15 12:18:59 Database: testes Application: pg_restore User: lenon Remote: [local]
5 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 15 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-15 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-15 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-15 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
6 43 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 15 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 2 18 2 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-15 08:00:05 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-15 08:20: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-15 08:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
7 41 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 15 05 4 12 37 - 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-15 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-15 05:32:11 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-15 05:32:11 Database: contagem Application: psql User: intelifix Remote: [local]
8 36 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 15 03 10 12 25 18 1 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-15 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-15 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-15 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
9 24 ERROR: could not create file "...": No space left on device automatic vacuum of table "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 15 12 24 - ERROR: could not create file "pg_tblspc/16385/PG_18_202506291/2472802/2477430_vm": No space left on device automatic vacuum of table "testes.public.equipamentos"
- ERROR: could not create file "pg_tblspc/16385/PG_18_202506291/2472802/2477439_vm": No space left on device automatic vacuum of table "testes.public.equipamentos_referencia"
- ERROR: could not create file "pg_tblspc/16385/PG_18_202506291/2472802/2477466_vm": No space left on device automatic vacuum of table "testes.public.estoque_movto"
Context: while scanning block 0 of relation "public.equipamentos"
Date: 2026-07-15 12:13:10
Context: while scanning block 0 of relation "public.equipamentos_referencia"
Date: 2026-07-15 12:13:10
Context: while scanning block 0 of relation "public.estoque_movto"
Date: 2026-07-15 12:13:10
10 19 ERROR: could not extend file "..." with FileFallocate(): No space left on device
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 15 12 19 - ERROR: could not extend file "pg_tblspc/16385/PG_18_202506291/2472802/2477939" with FileFallocate(): No space left on device
- ERROR: could not extend file "pg_tblspc/16385/PG_18_202506291/2472802/2477958" with FileFallocate(): No space left on device
- ERROR: could not extend file "pg_tblspc/16385/PG_18_202506291/2472802/2478019" with FileFallocate(): No space left on device
Context: COPY logs, line 808199
Hint: Check free disk space.
Statement: COPY public.logs (mensagem, quando) FROM stdin;Date: 2026-07-15 12:12:55 Database: testes Application: pg_restore User: lenon Remote: [local]
Context: COPY lote_caixas, line 1000
Hint: Check free disk space.
Statement: COPY public.lote_caixas (cai_id, lot_id, cai_criacao, usu_id, mod_id, is_id, novo, qtd, cai_obs, cai_check, cai_check_data, cai_check_user, cai_check_mens) FROM stdin;Date: 2026-07-15 12:13:19 Database: testes Application: pg_restore User: lenon Remote: [local]
Context: COPY lote_itens, line 620
Hint: Check free disk space.
Statement: COPY public.lote_itens (li_id, li_serie, eq_id, lot_id, li_status, flu_id, li_exige_cq, li_random, li_com_nf, li_data, usu_id, ace_id, li_datahora, li_orig, cai_id, li_obs) FROM stdin;Date: 2026-07-15 12:13:19 Database: testes Application: pg_restore User: lenon Remote: [local]
11 14 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 15 09 1 10 3 11 8 14 1 15 1 - ERROR: syntax error at or near "241700921023" at character 41
- ERROR: syntax error at or near "," at character 27
- ERROR: syntax error at or near "," at character 27
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''241700921023');
Date: 2026-07-15 09:14:52 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(,,.3)
Date: 2026-07-15 10:26:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(,,.3)
Date: 2026-07-15 10:26:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
12 13 WARNING: could not create relation-cache initialization file "...": No space left on device
Times Reported Most Frequent Error / Event #12
Day Hour Count Jul 15 12 13 - WARNING: could not create relation-cache initialization file "pg_tblspc/16385/PG_18_202506291/358220/pg_internal.init.2416769": No space left on device
- WARNING: could not create relation-cache initialization file "pg_tblspc/16385/PG_18_202506291/2472802/pg_internal.init.2417123": No space left on device
- WARNING: could not create relation-cache initialization file "pg_tblspc/16385/PG_18_202506291/358220/pg_internal.init.2417391": No space left on device
Detail: Continuing anyway, but there's something wrong.
Date: 2026-07-15 12:14:00
Detail: Continuing anyway, but there's something wrong.
Date: 2026-07-15 12:14:30
Detail: Continuing anyway, but there's something wrong.
Date: 2026-07-15 12:15:00
13 12 ERROR: function "..." already exists with same argument types
Times Reported Most Frequent Error / Event #13
Day Hour Count Jul 15 12 12 - ERROR: function "rs_auditor" already exists with same argument types
- ERROR: function "rs_auditor_insert_trigger" already exists with same argument types
- ERROR: function "rs_auditor_novas_tabelas" already exists with same argument types
Statement: CREATE FUNCTION public.rs_auditor() RETURNS trigger LANGUAGE plpgsql AS $$ /* ==================================================================================================== ROTINA : RS_AUDITOR AUTOR : LENILDO BARBOZA DATA : 23/MAI/2013 OBJETIVO : GRAVA REGISTRO DE AUDITORIA EM ATUALIZAÇÕES DE TABELAS DO SISTEMA ==================================================================================================== DATA USUARIO ALTERAÇÃO ----------- --------------- ---------- 23/MAI/2013 LENILDO BARBOZA IMPLANTAÇÃO 19/MAI/2017 LENILDO BARBOZA ADIÇÃO DA VARIÁVEL AUDITOR PARA EVITAR A GRAVAÇÃO EM ROTINAS DE RESTAURAÇÃO DE DADOS (RS_GETGLOBAL('AUDITOR') ) 28/FEV/2020 LENILDO BARBOZA IDENTIFICADOR DE TRANSAÇÃO (TI) E DATE_TIME COM CLOCK_TIMESTAMP() ==================================================================================================== */ DECLARE cRoutine VARCHAR := 'RS_AUDITOR'; cVersion VARCHAR := 'V 1.0 (c) 23/MAI/2013'; REC RECORD; nUser INTEGER := RS_USER(); cUser VARCHAR := CURRENT_USER; cPChaves VARCHAR := RS_PKEY( CAST( TG_TABLE_NAME AS VARCHAR ) ); cPKey TEXT := ''; cPKValue VARCHAR := ''; aCampoNew VARCHAR[]; aCampoOld VARCHAR[]; aValorNew VARCHAR[]; aValorOld VARCHAR[]; nInd INTEGER; nMax INTEGER; cCampo VARCHAR; tAgora TIMESTAMP := CLOCK_TIMESTAMP(); nTI BIGINT := TXID_CURRENT(); cStack VARCHAR := RS_STACK(); BEGIN -- NÃO GRAVA DADOS DA TABELA "AUDITOR" IF TG_TABLE_NAME = 'auditor' OR COALESCE( RS_GETGLOBAL('AUDITOR') , 'S' ) = 'N' THEN IF TG_OP = 'DELETE' THEN RETURN NULL; END IF; RETURN NEW; END IF; -- LÊ TODOS OS CAMPOS DO REGISTRO IF TG_OP <> 'DELETE' THEN nInd := 0; FOR REC IN SELECT L."key", L."value" FROM EACH( HSTORE( NEW ) ) L LOOP nInd := nInd + 1; aCampoNew[ nInd ] := REC.KEY; aValorNew[ nInd ] := REC.VALUE; -- OBTEM VALOR DA CHAVE PRIMÁRIA IF TG_OP = 'INSERT' AND STRPOS( cPChaves , REC.KEY ) > 0 THEN IF cPKValue = '' THEN cPKValue := REC.VALUE; cPKey := REC.KEY; ELSE cPKValue := cPKValue || ', ' || REC.VALUE; cPKey := cPKey || ',' || REC.KEY; END IF; END IF; nMax := nInd; -- FICA COM O MAIOR ÍNDICE DA MATRIZ END LOOP; END IF; -- LÊ TODOS OS CAMPOS DO REGISTRO IF TG_OP <> 'INSERT' THEN nInd := 0; FOR REC IN SELECT L."key", L."value" FROM EACH( HSTORE( OLD ) ) L LOOP nInd := nInd + 1; aCampoOld[ nInd ] := REC.KEY; aValorOld[ nInd ] := REC.VALUE; -- OBTEM VALOR DA CHAVE PRIMÁRIA -- VALE PARA UPDATE E DELETE IF STRPOS( cPChaves , REC.KEY ) > 0 THEN IF cPKValue = '' THEN cPKValue := REC.VALUE; cPKey := REC.KEY; ELSE cPKValue := cPKValue || ', ' || REC.VALUE; cPKey := cPKey || ',' || REC.KEY; END IF; END IF; nMax := nInd; -- FICA COM O MAIOR ÍNDICE DA MATRIZ END LOOP; END IF; -- LOOP SOBRE OS CAMPOS PARA VERIFICAR ALTERAÇÕES FOR nInd IN 1..nMax LOOP IF aValorNew[ nInd ] IS NULL AND aValorOld[ nInd ] IS NULL THEN CONTINUE; END IF; IF TG_OP = 'INSERT' OR TG_OP = 'DELETE' OR ( TG_OP = 'UPDATE' AND COALESCE( aValorNew[ nInd ] , '' ) <> COALESCE( aValorOld[ nInd ] , '' ) ) THEN IF aCampoNew[ nInd ] IS NULL THEN cCampo := aCampoOld[ nInd ]; ELSE cCampo := aCampoNew[ nInd ]; END IF; INSERT INTO AUDITOR (TI,TABLE_NAME, ACTION, FIELD_NAME, PK_NAME, PK_VALUE, USER_ID, USER_NAME, DATE_TIME, OLD_VALUE, NEW_VALUE, STACK ) VALUES ( nTI, TG_TABLE_NAME, TG_OP , cCampo , cPKey, cPKValue , nUser, cUser , tAgora , aValorOld[ nInd ], aValorNew[ nInd ], cStack ); END IF; END LOOP; IF TG_OP = 'DELETE' THEN RETURN NULL; END IF; RETURN NEW; END; $$;
Date: 2026-07-15 12:10:45 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: CREATE FUNCTION public.rs_auditor_insert_trigger() RETURNS trigger LANGUAGE plpgsql AS $_$ /* ==================================================================================================== ROTINA : RS_AUDITOR_INSERT_TRIGGER AUTOR : LENILDO BARBOZA DATA : 27/MAR/2017 OBJETIVO : INSERE REGISTROS EM AUDITOR DE ACORDO DA A DATA ==================================================================================================== DATA USUARIO ALTERAÇÃO ----------- --------------- ---------- 27/MAR/2017 LENILDO BARBOZA IMPLANTAÇÃO ==================================================================================================== */ DECLARE cRoutine VARCHAR := 'RS_AUDITOR_INSERT_TRIGGER'; cVersion VARCHAR := 'V 1.0 (c) 27/MAR/2017'; dData DATE; cComm VARCHAR; cPeriodo VARCHAR; BEGIN -- DEFINE O PERÍODO (ANO/MES) DA INSERÇÃO PARA DEFINIR EM QUAL PARTIÇÃO ELA SERÁ FEITA dData := DATE( NEW.DATE_TIME ); cPeriodo := TO_CHAR( dData , 'YYYY_MM' ); -- FAZ O INSERT NA PARTIÇÃO DEVIDA - NÃO É À PROVA DE ERROS, A PARTIÇÃO PODE NÃO EXISTIR! -- PARA ISSO DEVE-SE EXECUTAR DIARIAMENTE A ROTINA RS_AUDITOR_NOVAS_TABELAS( CURRENT_DATE +1 ) cComm := ' INSERT INTO AUDITOR.AUDITOR_' || cPeriodo || ' SELECT $1.*'; EXECUTE cComm USING NEW; RETURN NULL; END; $_$;
Date: 2026-07-15 12:10:45 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: CREATE FUNCTION public.rs_auditor_novas_tabelas(ddata date DEFAULT CURRENT_DATE) RETURNS character varying LANGUAGE plpgsql AS $$ /* ==================================================================================================== ROTINA : RS_AUDITOR_NOVAS_TABELAS AUTOR : LENILDO BARBOZA DATA : 27/MAR/2017 OBJETIVO : CRIA NOVAS TABELAS HIERÁRQUICAS PARA A TABELA AUDITOR ==================================================================================================== DATA USUARIO ALTERAÇÃO ----------- --------------- ---------- 27/MAR/2017 LENILDO BARBOZA IMPLANTAÇÃO 02/JUN/2017 LENILDO BARBOZA EXCLUI DADOS COM MAIS DE 4 MESES 01/FEV/2025 LENILDO BARBOZA PASSA A GERAR PARA OS PRÓXIMOS 6 MESES! ==================================================================================================== */ DECLARE cRoutine VARCHAR := 'RS_AUDITOR_NOVAS_TABELAS'; cVersion VARCHAR := 'V 1.0 (c) 27/MAR/2017'; cPeriodo VARCHAR; cPeriodoNome VARCHAR; cTabela VARCHAR; cComm VARCHAR; nAux INTEGER; dInicio DATE; dFinal DATE; cSchema VARCHAR := 'auditor.'; cDeleta VARCHAR; -- TABELA COM MAIS DE 3 MESES A SER EXCLUÍDA bNaoExiste BOOLEAN := TRUE; dMax DATE; nInd INTEGER; BEGIN dMax := dData + INTERVAL '6 MONTHS'; WHILE dData <= dMax LOOP cPeriodo := TO_CHAR( dData , 'YYYY-MM' ); cPeriodoNome := REPLACE( cPeriodo , '-' , '_' ); -- DEFINE NOVA TABELA cTabela := 'AUDITOR_' || cPeriodoNome; cComm := 'SELECT 1 FROM ' || cSchema || cTabela; bNaoExiste := TRUE; BEGIN EXECUTE cComm INTO nAux; bNaoExiste := FALSE; EXCEPTION WHEN OTHERS THEN END; -- SE TABELA NÃO EXISTE IF bNaoExiste THEN -- DEFINE DATAS dInicio := DATE( cPeriodo || '-01' ); dFinal := RS_ULTIMO_DIA_MES( cPeriodo ); -- CRIA NOVA TABELA cComm := ' CREATE TABLE '|| cSchema || cTabela || ' ( CHECK ( DATE(DATE_TIME) BETWEEN DATE(''' || dInicio || ''') AND DATE(''' || dFinal || ''') ) ) INHERITS ( PUBLIC.AUDITOR ) ; CREATE INDEX '|| cTabela|| '0 ON ' || cSchema || cTabela || ' (DATE(DATE_TIME)) TABLESPACE INDEXES; CREATE INDEX '|| cTabela|| '1 ON ' || cSchema || cTabela || ' (TABLE_NAME,PK_VALUE) TABLESPACE INDEXES; CREATE INDEX '|| cTabela|| '2 ON ' || cSchema || cTabela || ' (TABLE_NAME,DATE(DATE_TIME)) TABLESPACE INDEXES; CREATE INDEX '|| cTabela|| '3 ON ' || cSchema || cTabela || ' (TI) TABLESPACE INDEXES; GRANT ALL ON TABLE '|| cSchema || cTabela || ' TO PUBLIC'; EXECUTE cComm; END IF; dData := dData + INTERVAL '1 MONTH'; END LOOP; -- EXCLUI TABELA COM MAIS DE QUATRO MESES dData := CURRENT_DATE - INTERVAL '4 MONTHS'; FOR nInd IN 1..30 LOOP cDeleta := cSchema || 'AUDITOR_' || TO_CHAR( dData , 'YYYY_MM' ); cComm := 'DROP TABLE IF EXISTS ' || cDeleta; EXECUTE cComm; dData := dData - INTERVAL '1 MONTHS'; END LOOP; RETURN 'OK'; END; $$;
Date: 2026-07-15 12:10:45 Database: testes Application: pg_restore User: lenon Remote: [local]
14 11 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #14
Day Hour Count Jul 15 15 1 16 3 17 3 21 4 - LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
- LOG: could not receive data from client: Connection timed out
Date: 2026-07-15 15:21:23 Database: rio Application: pgAdmin 4 - CONN:8311409 User: lenon Remote: 172.20.0.3
Date: 2026-07-15 16:13:49 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
Date: 2026-07-15 16:57:30 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
15 9 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count Jul 15 00 1 05 1 06 1 10 5 16 1 - FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
- FATAL: database "testes" does not exist
Date: 2026-07-15 00:02:14 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-15 05:25:09 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-15 06:02:13 Database: testes Application: [unknown] User: lenon Remote: [local]
16 5 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #16
Day Hour Count Jul 15 08 1 20 4 - ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint
- ERROR: null value in column "eq_id" of relation "lote_itens" violates not-null constraint
- ERROR: null value in column "eq_id" of relation "lote_itens" violates not-null constraint
Detail: Failing row contains (6458234, null, 1, null, A, 27052, 33, null, null, null).
Context: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statement
Statement: SELECT RS_SETGLOBAL('USUARIO',437);SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO( 027052 ); ERROR: null value in column "serie" of relation "nf_entrada_itens" violates not-null constraint DETAIL: Failing row contains (6458234, null, 1, null, A, 27052, 33, null, null, null). CONTEXT: SQL statement "INSERT INTO NF_ENTRADA_ITENS ( NEM_ID, SERIE, VALOR, NEA_ID, TIPO_LOCAL ) VALUES ( REC.NEM_ID, REC.SERIAL, REC.VALOR, nID, REC.TIPO_LOCAL )" PL/pgSQL function rs_nf_entrada_carrega_daniel_rio(integer) line 385 at SQL statementDate: 2026-07-15 08:55:58 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Failing row contains (6546164, null, null, null, 0, null, null, 356, N, 2026-07-15, 2, null, 2026-07-15 20:51:25.566043, null, null, null).
Statement: INSERT INTO LOTE_ITENS (LI_ID, LOT_ID, EQ_ID, USU_ID) SELECT NEXTVAL('gen_lote_item'),lot_id, eq_id, 2 from x0 where feito='N' and li_id is null;Date: 2026-07-15 20:51:25 Database: rio Application: pgAdmin 4 - CONN:250295 User: lenon Remote: 172.20.0.3
Detail: Failing row contains (6546165, null, null, null, 0, null, null, 808, N, 2026-07-15, 2, null, 2026-07-15 20:53:08.670631, null, null, null).
Statement: INSERT INTO LOTE_ITENS (LI_ID, LOT_ID, EQ_ID, USU_ID) SELECT NEXTVAL('gen_lote_item'),lot_id, eq_id, 2 from x0 where feito='N' and li_id is null;Date: 2026-07-15 20:53:08 Database: rio Application: pgAdmin 4 - CONN:250295 User: lenon Remote: 172.20.0.3
17 4 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #17
Day Hour Count Jul 15 03 3 12 1 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-15 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-15 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-15 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
18 4 ERROR: relation "..." already exists
Times Reported Most Frequent Error / Event #18
Day Hour Count Jul 15 12 4 - ERROR: relation "auditor" already exists
- ERROR: relation "auditor0" already exists
- ERROR: relation "auditor1" already exists
Statement: CREATE TABLE public.auditor ( ti bigint, table_name character varying, action character varying, field_name character varying, pk_name character varying, pk_value character varying, user_id integer, user_name character varying, date_time timestamp without time zone, old_value character varying, new_value character varying, stack character varying );
Date: 2026-07-15 12:10:48 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: CREATE INDEX auditor0 ON public.auditor USING btree (table_name, pk_value, action);
Date: 2026-07-15 12:18:58 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: CREATE INDEX auditor1 ON public.auditor USING btree (date(date_time), table_name);
Date: 2026-07-15 12:18:58 Database: testes Application: pg_restore User: lenon Remote: [local]
19 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #19
Day Hour Count Jul 15 11 2 12 2 - LOG: process 1906948 still waiting for ShareLock on transaction 2720525 after 1000.152 ms
- LOG: process 1906948 still waiting for ShareLock on transaction 2720525 after 2286.779 ms
- LOG: process 2308584 still waiting for ShareLock on transaction 2721818 after 1000.131 ms
Detail: Process holding the lock: 1949752. Wait queue: 1906948.
Context: while updating tuple (73722,4) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-15 11:55:16 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1949752. Wait queue: 1906948.
Context: while updating tuple (73722,4) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = nLI WHERE NEM_ID = nNEM AND SERIE = cSerial" PL/pgSQL function rs_nf_associa_equipamento(integer) line 132 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying) line 925 at assignment PL/pgSQL function rs_triagem_recepcao(character varying) line 58 at assignment PL/pgSQL function rs_giga_triagem(character varying) line 128 at assignment
Statement: CALL RS_GIGA_TRIAGEM('REPROCESSAR')Date: 2026-07-15 11:55:17 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 1913957. Wait queue: 2308584.
Context: while updating tuple (73723,26) 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-15 12:05:16 Database: rio Application: psql User: intelifix Remote: [local]
20 3 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #20
Day Hour Count Jul 15 03 1 12 2 - LOG: database system was shut down at 2026-07-15 03:05:01 -03
- LOG: database system was shut down at 2026-07-15 12:28:55 -03
- LOG: database system was shut down at 2026-07-15 12:30:41 -03
Date: 2026-07-15 03:05:02
Date: 2026-07-15 12:28:56
Date: 2026-07-15 12:30:41
21 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #21
Day Hour Count Jul 15 14 3 - ERROR: trailing junk after numeric literal at or near "4A" at character 42
- ERROR: trailing junk after numeric literal at or near "4A" at character 42
- ERROR: trailing junk after numeric literal at or near "4A" at character 42
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-92-D7-4A)
Date: 2026-07-15 14:30:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-92-D7-4A)
Date: 2026-07-15 14:30:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(DC-97-E6-92-D7-4A)
Date: 2026-07-15 14:30:40 Database: rio Application: [unknown] User: etiquetas Remote: [local]
22 3 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #22
Day Hour Count Jul 15 08 1 10 1 15 1 - ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
- ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000285396"
Date: 2026-07-15 08:49:44
Context: automatic vacuum of table "rio.public.temp0000285372"
Date: 2026-07-15 10:13:44
Context: automatic vacuum of table "rio.public.temp0000285494"
Date: 2026-07-15 15:45:46
23 3 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #23
Day Hour Count Jul 15 08 1 10 1 15 1 - LOG: process 1708581 still waiting for AccessExclusiveLock on relation 2446676 of database 358220 after 1000.122 ms
- LOG: process 1801227 still waiting for AccessExclusiveLock on relation 2460148 of database 358220 after 1000.164 ms
- LOG: process 3030843 still waiting for AccessExclusiveLock on relation 2493978 of database 358220 after 1000.118 ms
Detail: Process holding the lock: 1749795. Wait queue: 1708581.
Statement: DROP TABLE IF EXISTS temp0000285396;Date: 2026-07-15 08:49:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 1853579. Wait queue: 1801227.
Statement: DROP TABLE IF EXISTS temp0000285372;Date: 2026-07-15 10:13:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 3033440. Wait queue: 3030843.
Statement: DROP TABLE IF EXISTS temp0000285494;Date: 2026-07-15 15:45:46 Database: rio Application: [unknown] User: intelifix Remote: [local]
24 2 ERROR: event trigger "..." does not exist
Times Reported Most Frequent Error / Event #24
Day Hour Count Jul 15 12 2 - ERROR: event trigger "emaj_protection_trg" does not exist
- ERROR: event trigger "emaj_protection_trg" does not exist
Statement: ALTER EVENT TRIGGER emaj_protection_trg OWNER TO lenon;
Date: 2026-07-15 12:19:00 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: COMMENT ON EVENT TRIGGER emaj_protection_trg IS 'Blocks the removal of the emaj extension or schema.';
Date: 2026-07-15 12:19:00 Database: testes Application: pg_restore User: lenon Remote: [local]
25 2 ERROR: database "..." is being accessed by other users
Times Reported Most Frequent Error / Event #25
Day Hour Count Jul 15 12 2 - ERROR: database "testes" is being accessed by other users
- ERROR: database "testes" is being accessed by other users
Detail: There are 2 other sessions using the database.
Statement: DROP DATABASE IF EXISTS testes;Date: 2026-07-15 12:27:38 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
Detail: There is 1 other session using the database.
Statement: DROP DATABASE IF EXISTS testes;Date: 2026-07-15 12:29:51 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
26 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #26
Day Hour Count Jul 15 15 1 20 1 - ERROR: column "flu_atual" of relation "x0" does not exist at character 15
- ERROR: column a.mod_id does not exist at character 39
Statement: UPDATE X0 SET FLU_ATUAL = (SELECT B.FLU_ID FROM FLUXOS B WHERE B.EQ_ID = X0.EQ_ID ORDER BY B.FLU_ID DESC LIMIT 1);
Date: 2026-07-15 15:38:16 Database: rio Application: pgAdmin 4 - CONN:3255731 User: lenon Remote: 172.20.0.3
Hint: Perhaps you meant to reference the column "c.mod_id".
Statement: CREATE TEMP TABLE X0_LOTES AS SELECT A.MOD_ID,C.CLI_ID,0::INTEGER LOTE,COUNT(*) QTD FROM X0 A INNER JOIN LOTE_ITENS B ON B.FLU_ID= A.FLU_ID INNER JOIN LOTES C ON C.LOT_ID = B.LOT_ID WHERE FEITO='N' AND A.LI_ID IS NULL GROUP BY 1,2; UPDATE X0_LOTES A SET LOTE = ( SELECT B.LOT_ID FROM LOTES B WHERE B.CLI_ID=A.CLI_ID AND B.MOD_ID=A.MOD_ID ORDER BY B.LOT_ID DESC LIMIT 1); ALTER TABLE X0 ADD LOT_ID INTEGER; UPDATE X0 A SET LOT_ID = (SELECT B.LOTE FROM X0_LOTES B WHERE B.MOD_ID=A.MOD_ID);Date: 2026-07-15 20:45:15 Database: rio Application: pgAdmin 4 - CONN:250295 User: lenon Remote: 172.20.0.3
27 2 ERROR: type "..." already exists
Times Reported Most Frequent Error / Event #27
Day Hour Count Jul 15 12 2 - ERROR: type "rs_t_global" already exists
- ERROR: type "rs_t_stack" already exists
Statement: CREATE TYPE public.rs_t_global AS ( var_name character varying, var_value character varying );
Date: 2026-07-15 12:10:44 Database: testes Application: pg_restore User: lenon Remote: [local]
Statement: CREATE TYPE public.rs_t_stack AS ( rotina character varying, parametros character varying );
Date: 2026-07-15 12:10:45 Database: testes Application: pg_restore User: lenon Remote: [local]
28 1 ERROR: column "..." of relation "..." already exists
Times Reported Most Frequent Error / Event #28
Day Hour Count Jul 15 20 1 - ERROR: column "lot_id" of relation "x0" already exists
Statement: ALTER TABLE X0 ADD LOT_ID INTEGER; UPDATE X0 A SET LOT_ID = (SELECT B.LOTE FROM X0_LOTES B WHERE B.MOD_ID=A.MOD_ID);
Date: 2026-07-15 20:53:01 Database: rio Application: pgAdmin 4 - CONN:250295 User: lenon Remote: 172.20.0.3
29 1 ERROR: invalid input syntax for type json PL/pgSQL function rs_resumo_tcia(...) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(...) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(...) line 48 at assignment
Times Reported Most Frequent Error / Event #29
Day Hour Count Jul 15 18 1 - ERROR: invalid input syntax for type json 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
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936...
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-15 18:40:06 Database: brasilia Application: psql User: intelifix Remote: [local]
30 1 ERROR: table "..." does not exist
Times Reported Most Frequent Error / Event #30
Day Hour Count Jul 15 15 1 - ERROR: table "x" does not exist
Statement: drop table x;create table x as select * from auditor where table_name='caixa_itens' and action='UPDATE' AND FIELD_NAME='cai_id'
Date: 2026-07-15 15:09:15 Database: rio Application: pgAdmin 4 - CONN:7085295 User: lenon Remote: 172.20.0.3
31 1 ERROR: schema "..." already exists
Times Reported Most Frequent Error / Event #31
Day Hour Count Jul 15 12 1 - ERROR: schema "auditor" already exists
Statement: CREATE SCHEMA auditor;
Date: 2026-07-15 12:10:44 Database: testes Application: pg_restore User: lenon Remote: [local]
32 1 ERROR: column "..." must appear in the GROUP BY clause or be used in an aggregate function
Times Reported Most Frequent Error / Event #32
Day Hour Count Jul 15 12 1 - ERROR: column "e.tcn_nome" must appear in the GROUP BY clause or be used in an aggregate function at character 145
Statement: CREATE OR REPLACE VIEW public.faturamento AS SELECT to_char((a.cai_data)::timestamp with time zone, 'YYYY/MM'::text) AS mes, e.tcn_id, e.tcn_nome, to_char(count(*), '999G999G990'::text) AS qtd, ( CASE WHEN (e.tcn_id = ANY (ARRAY[3, 12])) THEN ((count(*))::numeric * 0.22) WHEN ((upper((e.tcn_nome)::text) ~~ '%ADSL%'::text) OR (upper((e.tcn_nome)::text) ~~ '%MODEM'::text)) THEN ((count(*))::numeric * 0.11) ELSE (0)::numeric END)::money AS valor, (sum(a.fd_valor))::money AS faturado FROM ((((public.caixa_itens a JOIN public.lote_caixas b ON ((b.cai_id = a.cai_id))) JOIN public.lotes_saidas c ON (((c.lot_id = b.lot_id) AND ((c.lot_sucata)::text = 'N'::text) AND (c.lot_id <> 28017)))) JOIN public.modelos d ON ((d.mod_id = b.mod_id))) JOIN public.tecnologias e ON ((e.tcn_id = d.tcn_id))) GROUP BY (to_char((a.cai_data)::timestamp with time zone, 'YYYY/MM'::text)), e.tcn_id;
Date: 2026-07-15 12:18:59 Database: testes Application: pg_restore User: lenon Remote: [local]
33 1 ERROR: spiexceptions.DiskFull: could not extend file "...": No space left on device
Times Reported Most Frequent Error / Event #33
Day Hour Count Jul 15 12 1 - ERROR: spiexceptions.DiskFull: could not extend file "pg_tblspc/16385/PG_18_202506291/358220/362323.3": No space left on device
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Hint: Check free disk space.
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(6,437,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-07-15 12:17:40 Database: rio Application: [unknown] User: intelifix Remote: [local]
34 1 ERROR: spiexceptions.DiskFull: could not create file "...": No space left on device
Times Reported Most Frequent Error / Event #34
Day Hour Count Jul 15 12 1 - ERROR: spiexceptions.DiskFull: could not create file "pg_tblspc/16385/PG_18_202506291/358220/t10_2479799": No space left on device
Context: Traceback (most recent call last): PL/Python function "rs_fast_excel", line 135, in <module> rows = dados.fetch(1000) PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_lotes_cria(6,437,''/var/www/html/uploads/CRIAÇÃO DE LOTES - PADRÃO.xlsx'') ;' , '/var/www/html/tmp/temp_29.xlsx' )Date: 2026-07-15 12:16:50 Database: rio Application: [unknown] User: intelifix Remote: [local]
35 1 ERROR: function rs_token(...) does not exist
Times Reported Most Frequent Error / Event #35
Day Hour Count Jul 15 15 1 - ERROR: function rs_token(character varying, integer, unknown) does not exist at character 8
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Statement: SELECT RS_TOKEN(PK_VALUE,2,',')::INTEGER FLU_ID,OLD_VALUE::INTEGER CAI_ID, NEW_VALUE::INTEGER CAI_NOVA FROM XDate: 2026-07-15 15:34:42 Database: rio Application: pgAdmin 4 - CONN:3255731 User: lenon Remote: 172.20.0.3
36 1 ERROR: trigger "..." for relation "..." already exists
Times Reported Most Frequent Error / Event #36
Day Hour Count Jul 15 12 1 - ERROR: trigger "auditor_insert" for relation "auditor" already exists
Statement: CREATE TRIGGER auditor_insert BEFORE INSERT ON public.auditor FOR EACH ROW EXECUTE FUNCTION public.rs_auditor_insert_trigger();
Date: 2026-07-15 12:18:59 Database: testes Application: pg_restore User: lenon Remote: [local]
37 1 WARNING: is not a PostgreSQL backend process
Times Reported Most Frequent Error / Event #37
Day Hour Count Jul 15 12 1 - WARNING: PID 1946491 is not a PostgreSQL backend process
Date: 2026-07-15 12:29:30 Database: rio Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3