pgBadger-
Global information
- Generated on Thu May 28 23:50:10 2026
- Log file: /usr/local/pgsql/data/log/serverlog-04.log, ..., /usr/local/pgsql/data/log/serverlog-28.log
- Parsed 45,679 log entries in 8s
- Log start from 2026-05-28 00:00:22 to 2026-05-28 23:49:49
-
Overview
Global Stats
- 363 Number of unique normalized queries
- 6,765 Number of queries
- 8h5m14s Total query duration
- 2026-05-28 00:02:10 First query
- 2026-05-28 23:45:01 Last query
- 4 queries/s at 2026-05-28 11:24:52 Query peak
- 8h5m14s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 8h5m14s Execute total duration
- 3,791 Number of events
- 18 Number of unique normalized events
- 3,326 Max number of times the same event was reported
- 0 Number of cancellation
- 671 Total number of automatic vacuums
- 1,187 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 273 Total number of sessions
- 6 sessions at 2026-05-28 17:06:56 Session peak
- 9d10h30m7s Total duration of sessions
- 49m46s Average duration of sessions
- 24 Average queries per session
- 1m46s Average queries duration per session
- 48m Average idle time per session
- 692 Total number of connections
- 5 connections/s at 2026-05-28 23:45:01 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-28 11:24:52 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-28 11:24:52 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-05-28 23:43:19 Date
Queries duration
Key values
- 8h5m14s 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) May 28 00 39 0ms 27s23ms 3s342ms 5s103ms 8s824ms 1m20s 01 12 0ms 4s778ms 3s194ms 4s442ms 6s460ms 7s791ms 02 12 0ms 5s776ms 2s938ms 3s631ms 6s974ms 8s585ms 03 13 0ms 4s509ms 2s797ms 4s276ms 6s471ms 7s396ms 04 42 0ms 9s639ms 1s333ms 4s827ms 8s239ms 13s120ms 05 29 0ms 9m14s 26s9ms 3s620ms 11s232ms 9m14s 06 14 0ms 24s170ms 5s584ms 3s340ms 9s343ms 27s651ms 07 230 0ms 12m 9s577ms 46s371ms 1m47s 20m26s 08 505 150ms 7m16s 2s968ms 37s162ms 53s192ms 7m58s 09 610 150ms 6m55s 3s402ms 1m2s 4m27s 7m1s 10 631 150ms 7m11s 2s947ms 44s998ms 4m42s 7m55s 11 629 150ms 10m1s 4s265ms 1m11s 4m21s 12m16s 12 301 0ms 8m16s 5s384ms 45s381ms 2m8s 9m3s 13 498 0ms 9m44s 2s311ms 18s97ms 46s724ms 10m 14 871 150ms 7m54s 3s215ms 1m58s 4m11s 8m4s 15 812 150ms 10m16s 3s986ms 1m11s 8m23s 10m54s 16 875 150ms 10m 3s371ms 2m14s 4m21s 10m29s 17 265 0ms 9m29s 5s129ms 32s465ms 2m52s 9m32s 18 16 0ms 5m12s 22s980ms 2s869ms 4s560ms 5m40s 19 17 0ms 5m21s 22s102ms 2s362ms 2s907ms 5m51s 20 80 0ms 7m23s 12s846ms 55s651ms 1m22s 7m23s 21 19 0ms 5m19s 19s574ms 2s881ms 4s296ms 5m46s 22 19 0ms 5m12s 19s393ms 3s554ms 4s627ms 5m40s 23 226 0ms 1m40s 8s999ms 1m13s 1m23s 2m23s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 28 00 24 0 749ms 184ms 334ms 1s901ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 1 0 920ms 0ms 0ms 0ms 04 30 0 295ms 214ms 505ms 1s326ms 05 15 0 362ms 175ms 282ms 741ms 06 4 0 2s730ms 0ms 0ms 1s578ms 07 127 0 12s473ms 2s360ms 14s11ms 4m6s 08 372 0 2s954ms 7s554ms 21s577ms 4m38s 09 460 0 3s516ms 9s926ms 17s515ms 4m37s 10 498 0 2s929ms 10s433ms 16s421ms 4m47s 11 518 0 3s956ms 15s367ms 54s333ms 6m58s 12 209 0 5s497ms 7s78ms 36s539ms 4m24s 13 380 0 2s683ms 9s435ms 14s316ms 1m21s 14 671 0 3s568ms 41s645ms 1m58s 6m28s 15 590 0 4s546ms 38s476ms 49s35ms 10m21s 16 676 0 3s576ms 31s258ms 2m14s 5m36s 17 208 0 5s595ms 6s177ms 30s732ms 3m14s 18 7 0 49s434ms 0ms 0ms 4s566ms 19 8 0 44s607ms 0ms 0ms 2s221ms 20 14 57 14s110ms 1s249ms 54s728ms 1m36s 21 5 0 1m9s 0ms 0ms 1s438ms 22 4 0 1m25s 0ms 0ms 0ms 23 7 219 8s999ms 1m8s 1m13s 2m23s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) May 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare May 28 00 0 2 2.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 3 3.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 7 7.00 0.00% 08 0 14 14.00 0.00% 09 0 11 11.00 0.00% 10 0 9 9.00 0.00% 11 0 9 9.00 0.00% 12 0 2 2.00 0.00% 13 0 10 10.00 0.00% 14 0 8 8.00 0.00% 15 0 11 11.00 0.00% 16 0 9 9.00 0.00% 17 0 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 1 1.00 0.00% 20 0 2 2.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 1 1.00 0.00% Day Hour Count Average / Second May 28 00 27 0.01/s 01 19 0.01/s 02 18 0.01/s 03 27 0.01/s 04 21 0.01/s 05 26 0.01/s 06 25 0.01/s 07 29 0.01/s 08 35 0.01/s 09 45 0.01/s 10 44 0.01/s 11 33 0.01/s 12 24 0.01/s 13 37 0.01/s 14 35 0.01/s 15 36 0.01/s 16 37 0.01/s 17 28 0.01/s 18 26 0.01/s 19 29 0.01/s 20 30 0.01/s 21 25 0.01/s 22 26 0.01/s 23 10 0.00/s Day Hour Count Average Duration Average idle time May 28 00 6 52m40s 52m18s 01 9 1h43s 1h38s 02 5 1h36s 1h29s 03 12 11m47s 11m44s 04 5 1h3m36s 1h3m25s 05 7 1h25s 58m38s 06 5 1h 59m44s 07 11 52m40s 49m20s 08 14 48m44s 46m57s 09 23 35m20s 33m49s 10 25 34m34s 33m19s 11 15 59m1s 56m2s 12 15 1h2m39s 1h51s 13 8 42m55s 40m31s 14 16 1h43s 57m48s 15 17 53m11s 50m1s 16 17 52m31s 49m37s 17 16 55m8s 53m43s 18 8 1h 59m14s 19 7 52m51s 51m58s 20 11 45m32s 43m59s 21 6 1h53s 59m51s 22 7 53m17s 52m24s 23 8 49m15s 45m1s -
Connections
Established Connections
Key values
- 5 connections Connection Peak
- 2026-05-28 23:45:01 Date
Connections per database
Key values
- brasilia Main Database
- 692 connections Total
Connections per user
Key values
- intelifix Main User
- 692 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-05-28 17:06:56 Date
Histogram of session times
Key values
- 205 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 273 sessions Total
Sessions per user
Key values
- intelifix Main User
- 273 sessions Total
Sessions per host
Key values
- [local] Main Host
- 273 sessions Total
Sessions per application
Key values
- [unknown] Main Application
- 273 sessions Total
Application Count Total Duration Average Duration [unknown] 239 8d21h55m21s 53m42s pgAdmin 4 - CONN:1223354 2 4s868ms 2s434ms pgAdmin 4 - CONN:3895900 2 4s373ms 2s186ms pgAdmin 4 - CONN:635022 2 4s917ms 2s458ms pgAdmin 4 - CONN:7527944 2 4s59ms 2s29ms pgAdmin 4 - CONN:9445764 1 4s908ms 4s908ms pgAdmin 4 - DB:contagem 2 18s987ms 9s493ms pgAdmin 4 - DB:postgres 3 2m 40s95ms pgAdmin 4 - DB:rio 5 2h14m59s 26m59s pg_dump 4 41m59s 10m29s psql 11 9h35m4s 52m16s -
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 21,898 buffers Checkpoint Peak
- 2026-05-28 11:54:38 Date
- 270.046 seconds Highest write time
- 0.061 seconds Sync time
Checkpoints Wal files
Key values
- 8 files Wal files usage Peak
- 2026-05-28 12:19:38 Date
Checkpoints distance
Key values
- 277.81 Mo Distance Peak
- 2026-05-28 16:44:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time May 28 00 15,769 466.799s 0.035s 466.882s 01 2,500 250.964s 0.021s 251.02s 02 1,836 184.386s 0.018s 184.429s 03 2,009 201.65s 0.021s 201.725s 04 3,681 369.32s 0.028s 369.387s 05 7,604 743.971s 0.035s 744.064s 06 2,466 246.785s 0.006s 246.799s 07 29,281 2,348.603s 0.111s 2,348.859s 08 57,472 2,865.971s 0.239s 2,866.468s 09 77,065 3,239.048s 0.277s 3,239.647s 10 87,910 3,239.252s 0.281s 3,239.826s 11 86,147 3,239.074s 0.271s 3,239.588s 12 53,291 2,707.387s 0.118s 2,707.619s 13 28,117 2,422.99s 0.128s 2,423.247s 14 72,227 3,171.313s 0.291s 3,171.787s 15 58,780 3,213.179s 0.31s 3,213.678s 16 79,606 3,237.058s 0.253s 3,237.485s 17 35,526 1,809.741s 0.086s 1,809.927s 18 1,010 101.41s 0.013s 101.449s 19 320 32.157s 0.005s 32.172s 20 1,320 138.749s 0.009s 138.772s 21 1,903 190.984s 0.019s 191.042s 22 2,427 243.602s 0.022s 243.654s 23 10,335 438.844s 0.007s 438.866s Day Hour Added Removed Recycled Synced files Longest sync Average sync May 28 00 0 6 0 452 0.003s 0.01s 01 0 1 0 475 0.003s 0.007s 02 0 0 0 331 0.002s 0.005s 03 0 1 0 408 0.003s 0.007s 04 0 1 0 635 0.004s 0.008s 05 0 3 0 659 0.003s 0.008s 06 0 0 0 35 0.003s 0.002s 07 0 19 0 2,151 0.004s 0.012s 08 0 31 0 4,454 0.006s 0.012s 09 0 44 0 6,388 0.004s 0.012s 10 0 45 0 6,282 0.005s 0.012s 11 0 27 11 5,627 0.004s 0.012s 12 0 0 41 2,878 0.011s 0.012s 13 0 0 12 4,540 0.003s 0.012s 14 0 0 38 6,531 0.005s 0.012s 15 0 0 36 6,183 0.010s 0.012s 16 0 0 56 6,160 0.005s 0.012s 17 0 0 26 3,448 0.003s 0.01s 18 0 0 0 163 0.003s 0.005s 19 0 0 0 55 0.002s 0.002s 20 0 0 1 71 0.002s 0.003s 21 0 0 0 392 0.002s 0.007s 22 0 0 1 414 0.003s 0.009s 23 0 0 1 63 0.002s 0.004s Day Hour Count Avg time (sec) May 28 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 May 28 00 11,297.38 kB 53,336.50 kB 01 1,929.14 kB 30,066.57 kB 02 1,542.80 kB 16,589.00 kB 03 1,401.12 kB 4,312.50 kB 04 2,189.88 kB 2,738.25 kB 05 5,924.62 kB 12,427.00 kB 06 5,264.00 kB 10,083.50 kB 07 26,022.42 kB 55,897.50 kB 08 41,172.67 kB 74,829.92 kB 09 60,903.75 kB 100,440.33 kB 10 61,788.17 kB 99,512.50 kB 11 50,752.25 kB 101,739.58 kB 12 56,419.83 kB 103,259.00 kB 13 16,980.67 kB 48,139.75 kB 14 51,109.25 kB 74,164.00 kB 15 49,727.08 kB 91,350.92 kB 16 75,865.92 kB 109,795.25 kB 17 42,191.20 kB 94,528.40 kB 18 863.40 kB 49,320.80 kB 19 647.00 kB 33,967.50 kB 20 3,832.00 kB 27,175.67 kB 21 1,148.14 kB 16,790.71 kB 22 1,590.50 kB 8,399.88 kB 23 3,335.00 kB 6,669.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size May 28 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 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 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 6.64 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-05-28 13:55:02 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 6.64 sec Highest CPU-cost vacuum
Table public.codigos_barra
Database rio - 2026-05-28 13:55:02 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (169) Main table analyzed (database rio)
- 1,187 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 169 rio.pg_catalog.pg_class 86 rio.public.temp0000281029 80 rio.pg_catalog.pg_type 72 contagem.pg_catalog.pg_attribute 58 rio.public.usuarios 49 rio.pg_catalog.pg_index 49 contagem.pg_catalog.pg_class 39 rio.pg_catalog.pg_depend 37 contagem.public.temp0000226294 32 rio.public.temp0000281051 31 contagem.pg_catalog.pg_type 31 contagem.public.usuarios 27 rio.public.temp0000281137 22 contagem.pg_catalog.pg_index 21 rio.public.temp0000281117 21 rio.public.temp0000281049 18 contagem.pg_catalog.pg_depend 17 rio.public.temp0000281127 16 rio.public.temp0000281045 15 rio.public.temp0000281023 15 contagem.public.temp0000226300 14 rio.public.temp0000281057 14 rio.public.temp0000281119 13 rio.public.temp0000281021 13 rio.public.temp0000281047 12 contagem.public.temp0000226296 12 contagem.public.nf_entrada 10 rio.public.temp0000281015 10 rio.public.temp0000281093 9 rio.public.temp0000281129 9 rio.public.temp0000281099 9 rio.public.temp0000281059 8 rio.public.temp0000281147 7 rio.public.temp0000281125 7 rio.public.temp0000281135 7 rio.public.temp0000281109 7 rio.public.temp0000281071 7 rio.pg_catalog.pg_shdepend 7 rio.public.temp0000281145 7 contagem.pg_catalog.pg_shdepend 7 template1.pg_catalog.pg_shdepend 6 rio.public.temp0000281111 6 rio.public.temp0000281077 6 rio.public.temp0000281043 6 rio.public.temp0000281031 4 rio.public.tmp_drill_0175 4 contagem.public.temp0000226298 4 rio.public.temp0000281113 4 rio.public.temp0000281169 4 rio.public.temp0000281027 4 contagem.public.temp0000226292 3 rio.public.temp0000281033 3 contagem.public.temp0000226306 3 rio.public.temp0000281079 3 rio.public.temp0000281019 3 postgres.pg_catalog.pg_shdepend 2 rio.public.temp0000281025 2 rio.public.temp0000281085 2 rio.public.temp0000281039 2 rio.public.temp0000281005 2 rio.public.temp0000281055 2 rio.public.temp0000281089 2 contagem.public.parametros 1 contagem.public.temp0000226302 1 rio.public.temp0000281097 1 rio.public.temp0000281013 1 rio.public.temp0000281065 1 rio.pg_catalog.pg_namespace 1 rio.public.temp0000281035 1 rio.public.temp0000281063 1 rio.public.temp0000281101 1 rio.public.temp0000281073 1 rio.public.temp0000281123 1 rio.public.temp0000281143 1 contagem.public.temp0000226304 1 rio.public.temp0000281041 1 rio.public.temp0000281061 1 rio.public.temp0000281053 1 Total 1,187 Vacuums per table
Key values
- pg_catalog.pg_attribute (94) Main table vacuumed on database rio
- 671 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 94 60 0 0 0 0 0 33,583 8,684 12,868,563 501 12,464 rio.public.temp0000281029 81 0 0 0 0 0 0 43,644 477 2,796,430 0 0 rio.pg_catalog.pg_class 72 39 0 0 0 0 0 6,639 1,895 2,827,217 118 898 rio.pg_catalog.pg_type 60 34 0 0 0 0 0 2,940 892 1,008,158 130 870 rio.auditor.auditor_2026_05 31 0 0 0 0 0 0 148,135 50,757 69,624,250 43,468 811,753 rio.pg_catalog.pg_index 27 23 0 0 0 0 0 1,141 327 296,673 56 166 contagem.pg_catalog.pg_attribute 23 23 0 0 0 0 0 14,909 3,478 6,534,565 141 6,350 rio.public.temp0000281137 22 0 0 0 0 0 0 19,999 79 1,192,622 0 0 rio.pg_catalog.pg_depend 16 16 0 0 0 0 0 4,500 1,616 2,309,643 110 4,081 rio.public.temp0000281045 15 0 0 0 0 0 0 1,318 209 319,517 0 0 contagem.public.usuarios 14 1 0 0 0 0 0 75 55 31,389 2 2 contagem.pg_catalog.pg_class 14 14 0 0 0 0 0 2,445 544 864,929 64 985 contagem.pg_catalog.pg_type 13 13 0 0 0 0 0 1,001 239 377,514 8 52 rio.public.temp0000281047 12 0 0 0 0 0 0 1,249 64 83,895 0 0 rio.public.temp0000281119 12 0 0 0 0 0 0 896 212 339,422 0 0 rio.public.tmp_drill_0175 10 4 0 0 0 0 0 1,386 31 263,675 1 25 contagem.public.temp0000226300 10 0 0 0 0 0 0 890 60 61,712 0 0 rio.public.temp0000281099 9 0 0 0 0 0 0 4,626 30 277,971 0 0 rio.pg_catalog.pg_statistic 9 9 0 0 0 0 0 10,016 2,460 10,082,336 1,023 6,267 rio.public.temp0000281093 9 0 0 0 0 0 0 879 51 60,537 0 0 contagem.pg_catalog.pg_depend 8 8 0 0 0 0 0 1,537 411 785,485 8 361 postgres.pg_catalog.pg_shdepend 7 7 0 0 0 0 0 1,276 437 684,639 63 222 rio.public.usuarios 7 3 0 0 0 0 0 89 28 46,514 2 61 contagem.pg_catalog.pg_index 7 7 0 0 0 0 0 304 91 98,210 9 54 rio.public.temp0000281077 6 0 0 0 0 0 0 6,140 22 365,748 0 0 rio.public.temp0000281043 5 0 0 0 0 0 0 71 24 7,636 0 0 rio.public.logs 5 0 0 0 0 0 0 765 272 354,035 201 4,636 rio.pg_toast.pg_toast_2619 5 5 0 0 0 0 0 1,660 383 2,258,480 107 488 rio.public.temp0000281027 4 0 0 0 0 0 0 4,607 1,546 2,216,480 0 0 rio.public.temp0000281109 4 0 0 0 0 0 0 184 21 14,705 0 0 rio.public.codigos_barra 4 0 0 0 0 0 0 18,803 18,143 68,372,232 49 4,707 rio.public.nf_entrada_arquivo_erros 4 0 0 0 0 0 0 369 140 391,961 73 3,472 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 4,560 678 2,851,565 423 3,559 rio.public.temp0000281057 3 0 0 0 0 0 0 198 17 14,379 0 0 contagem.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 176 46 169,228 6 23 rio.public.nf_entrada_itens 2 0 0 0 0 0 0 52 41 79,593 4 202 rio.public.temp0000281089 2 0 0 0 0 0 0 164 12 11,462 0 0 rio.public.temp0000281055 2 0 0 0 0 0 0 124 12 9,040 0 0 rio.public.temp0000281113 2 0 0 0 0 0 0 235 12 15,782 0 0 rio.public.temp0000281085 2 0 0 0 0 0 0 1,537 7 91,824 0 0 rio.public.temp0000281019 2 0 0 0 0 0 0 1,621 10 97,156 0 0 rio.public.giga_testes 2 0 0 0 0 0 0 495 181 478,735 164 359 template1.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 199 51 73,565 26 60 rio.public.equipamentos_referencia 2 0 0 0 0 0 0 49 18 39,855 9 1,526 rio.public.fluxos 2 0 0 0 0 0 0 691 363 1,071,071 68 2,634 contagem.public.nf_entrada 2 2 0 0 0 0 0 111 37 70,463 1 88 rio.public.temp0000281147 2 0 0 0 0 0 0 172 11 12,121 0 0 rio.public.temp0000281049 1 0 0 0 0 0 0 1,534 4 91,109 0 0 rio.public.temp0000281061 1 0 0 0 0 0 0 8 5 1,309 0 0 rio.public.caixa_itens 1 0 0 0 0 0 0 336 180 365,373 6 222 rio.public.temp0000281041 1 0 0 0 0 0 0 8 5 1,252 0 0 contagem.pg_catalog.pg_shdepend 1 1 0 0 0 0 0 196 48 76,389 4 6 rio.public.temp0000281169 1 0 0 0 0 0 0 115 6 7,757 0 0 rio.public.temp0000281059 1 0 0 0 0 0 0 8 5 1,309 0 0 rio.public.temp0000281123 1 0 0 0 0 0 0 68 6 4,884 0 0 rio.public.temp0000281073 1 0 0 0 0 0 0 89 6 6,171 0 0 rio.public.temp0000281079 1 0 0 0 0 0 0 91 6 6,294 0 0 rio.public.temp0000281111 1 0 0 0 0 0 0 4 3 774 0 0 rio.public.temp0000281063 1 0 0 0 0 0 0 89 6 6,171 0 0 rio.public.temp0000281065 1 0 0 0 0 0 0 89 6 6,167 0 0 rio.public.equipamento_codigos 1 0 0 0 0 0 0 428 32 153,192 27 2,356 rio.public.fluxo_passos 1 0 0 0 0 0 0 623 361 851,655 25 2,240 rio.public.temp0000281117 1 0 0 0 0 0 0 8 5 1,435 0 0 rio.public.lote_itens 1 0 0 0 0 0 0 1,150 418 1,414,253 335 2,362 rio.public.equip_defeitos 1 0 0 0 0 0 0 481 246 728,470 23 1,626 rio.public.temp0000281097 1 0 0 0 0 0 0 8 5 1,261 0 0 rio.public.temp0000281129 1 0 0 0 0 0 0 1,536 4 91,227 0 0 Total 671 276 0 0 0 0 0 353,329 96,531 196,719,434 47,255 875,177 Vacuum throughput per table
Key values
- public.codigos_barra (22.04) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 4.78 rio.public.temp0000281029 0 0 1.97 rio.pg_catalog.pg_class 0 0 1 rio.pg_catalog.pg_type 0 0 0.5 rio.auditor.auditor_2026_05 0 0 17.65 rio.pg_catalog.pg_index 0 0 0.22 contagem.pg_catalog.pg_attribute 0 0 1.9 rio.public.temp0000281137 0 0 0.96 rio.pg_catalog.pg_depend 0 0 1.01 rio.public.temp0000281045 0 0 0.11 contagem.public.usuarios 0 0 0 contagem.pg_catalog.pg_class 0 0 0.51 contagem.pg_catalog.pg_type 0 0 0.2 rio.public.temp0000281047 0 0 0.12 rio.public.temp0000281119 0 0 0.12 rio.public.tmp_drill_0175 0 0 0.05 contagem.public.temp0000226300 0 0 0.11 rio.public.temp0000281099 0 0 0.4 rio.pg_catalog.pg_statistic 0 0 1.36 rio.public.temp0000281093 0 0 0.11 contagem.pg_catalog.pg_depend 0 0 0.26 postgres.pg_catalog.pg_shdepend 0 0 0.5 rio.public.usuarios 0 0 19.9 contagem.pg_catalog.pg_index 0 0 0.07 rio.public.temp0000281077 0 0 0.25 rio.public.temp0000281043 0 0 0.04 rio.public.logs 0 0 0.51 rio.pg_toast.pg_toast_2619 0 0 0.3 rio.public.temp0000281027 0 0 0.17 rio.public.temp0000281109 0 0 0.05 rio.public.codigos_barra 0 0 22.04 rio.public.nf_entrada_arquivo_erros 0 0 0.26 contagem.pg_catalog.pg_statistic 0 0 0.45 rio.public.temp0000281057 0 0 0.07 contagem.pg_toast.pg_toast_2619 0 0 0.04 rio.public.nf_entrada_itens 0 0 0.11 rio.public.temp0000281089 0 0 0.02 rio.public.temp0000281055 0 0 0.01 rio.public.temp0000281113 0 0 0.02 rio.public.temp0000281085 0 0 0.08 rio.public.temp0000281019 0 0 0.06 rio.public.giga_testes 0 0 0.33 template1.pg_catalog.pg_shdepend 0 0 0.05 rio.public.equipamentos_referencia 0 0 0.01 rio.public.fluxos 0 0 0.47 contagem.public.nf_entrada 0 0 0.02 rio.public.temp0000281147 0 0 0.04 rio.public.temp0000281049 0 0 0.05 rio.public.temp0000281061 0 0 0.01 rio.public.caixa_itens 0 0 0.17 rio.public.temp0000281041 0 0 0.01 contagem.pg_catalog.pg_shdepend 0 0 0.02 rio.public.temp0000281169 0 0 0.01 rio.public.temp0000281059 0 0 0.01 rio.public.temp0000281123 0 0 0.01 rio.public.temp0000281073 0 0 0.01 rio.public.temp0000281079 0 0 0.01 rio.public.temp0000281111 0 0 0.04 rio.public.temp0000281063 0 0 0.01 rio.public.temp0000281065 0 0 0.01 rio.public.equipamento_codigos 0 0 0.64 rio.public.fluxo_passos 0 0 0.51 rio.public.temp0000281117 0 0 0.02 rio.public.lote_itens 0 0 0.8 rio.public.equip_defeitos 0 0 0.25 rio.public.temp0000281097 0 0 0.01 rio.public.temp0000281129 0 0 0.04 Total 0 0 81.8500000000001 Tuples removed per table
Key values
- pg_catalog.pg_attribute (274011) Main table with removed tuples on database rio
- 473446 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 94 60 274,011 2,541,231 404,761 502 60,950 contagem.pg_catalog.pg_attribute 23 23 88,884 541,193 98 101 12,457 rio.public.tmp_drill_0175 10 4 20,562 24,622 1,928 0 578 rio.pg_catalog.pg_statistic 9 9 14,514 88,259 878 8 11,582 rio.pg_catalog.pg_type 60 34 11,975 159,069 23,054 43 4,396 rio.pg_catalog.pg_depend 16 16 10,653 319,484 13,287 18 2,900 postgres.pg_catalog.pg_shdepend 7 7 6,597 65,782 844 0 707 contagem.pg_catalog.pg_statistic 3 3 6,272 26,684 0 0 2,985 rio.pg_catalog.pg_index 27 23 5,725 56,591 4,379 0 1,520 contagem.pg_catalog.pg_depend 8 8 5,285 149,054 6 0 1,362 rio.pg_catalog.pg_class 72 39 4,616 315,073 63,593 46 9,601 contagem.pg_catalog.pg_class 14 14 4,392 47,343 4 16 1,558 contagem.pg_catalog.pg_type 13 13 3,924 29,271 2 24 815 rio.auditor.auditor_2026_05 31 0 3,898 686,610,823 0 0 30,659,269 contagem.pg_catalog.pg_index 7 7 1,926 11,993 1 7 354 rio.public.codigos_barra 4 0 1,825 37,838,279 0 0 251,614 template1.pg_catalog.pg_shdepend 2 2 1,189 18,662 148 0 202 rio.pg_toast.pg_toast_2619 5 5 1,028 3,183 24 135 815 contagem.pg_catalog.pg_shdepend 1 1 1,022 9,293 0 0 101 rio.public.fluxos 2 0 863 9,740,430 0 0 110,360 contagem.public.usuarios 14 1 827 307 13 0 28 rio.public.nf_entrada_arquivo_erros 4 0 771 32,737,854 307 0 580,275 contagem.public.nf_entrada 2 2 639 1,652 0 4 44 rio.public.equipamento_codigos 1 0 587 9,217,397 0 0 61,196 rio.public.equip_defeitos 1 0 467 5,058,657 36 0 41,288 rio.public.caixa_itens 1 0 231 4,391,262 0 0 41,088 rio.public.fluxo_passos 1 0 223 4,677,923 0 0 43,356 rio.public.usuarios 7 3 163 4,586 1,044 0 118 rio.public.lote_itens 1 0 155 5,553,187 0 0 77,310 contagem.pg_toast.pg_toast_2619 2 2 119 230 0 29 61 rio.public.giga_testes 2 0 76 7,361,127 0 0 188,358 rio.public.nf_entrada_itens 2 0 27 12,099,798 86 0 136,994 rio.public.temp0000281049 1 0 0 21,606 0 0 1,536 rio.public.temp0000281043 5 0 0 11,010 0 123 229 rio.public.temp0000281061 1 0 0 1,417 0 47 81 rio.public.temp0000281041 1 0 0 1,006 0 11 53 rio.public.temp0000281089 2 0 0 5,142 0 44 148 rio.public.temp0000281027 4 0 0 66,187 0 48 4,688 rio.public.temp0000281055 2 0 0 2,042 0 20 108 rio.public.temp0000281113 2 0 0 9,710 0 37 219 rio.public.temp0000281057 3 0 0 4,521 0 129 255 rio.public.temp0000281169 1 0 0 1,943 0 21 107 rio.public.temp0000281099 9 0 0 194,411 0 0 13,824 rio.public.temp0000281029 81 0 0 851,062 0 1,678 59,314 rio.public.logs 5 0 0 78,773,446 0 0 3,147,239 rio.public.temp0000281085 2 0 0 43,190 0 0 3,072 rio.public.temp0000281059 1 0 0 1,417 0 47 81 rio.public.temp0000281077 6 0 0 129,541 0 0 9,216 rio.public.temp0000281123 1 0 0 1,132 0 4 60 rio.public.temp0000281019 2 0 0 22,994 0 48 1,616 rio.public.temp0000281073 1 0 0 1,417 0 47 81 rio.public.temp0000281079 1 0 0 1,484 0 45 83 contagem.public.temp0000226300 10 0 0 10,575 0 470 810 rio.public.temp0000281111 1 0 0 21,627 0 0 1,536 rio.public.temp0000281047 12 0 0 59,156 0 361 1,367 rio.public.temp0000281137 22 0 0 475,641 0 0 33,792 rio.public.temp0000281063 1 0 0 1,417 0 47 81 rio.public.temp0000281065 1 0 0 1,417 0 47 81 rio.public.temp0000281109 4 0 0 27,424 0 146 622 rio.public.temp0000281117 1 0 0 7,223 0 28 164 rio.public.equipamentos_referencia 2 0 0 9,961,884 0 0 53,861 rio.public.temp0000281097 1 0 0 1,081 0 7 57 rio.public.temp0000281045 15 0 0 51,269 0 283 1,381 rio.public.temp0000281129 1 0 0 21,624 0 0 1,536 rio.public.temp0000281147 2 0 0 13,997 0 67 317 rio.public.temp0000281119 12 0 0 70,672 0 352 1,632 rio.public.temp0000281093 9 0 0 53,662 0 321 1,215 Total 671 276 473,446 910,623,646 514,493 5,411 35,644,704 Pages removed per table
Key values
- public.temp0000281029 (1678) Main table with removed pages on database rio
- 5411 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000281029 81 0 0 1678 rio.pg_catalog.pg_attribute 94 60 274011 502 contagem.public.temp0000226300 10 0 0 470 rio.public.temp0000281047 12 0 0 361 rio.public.temp0000281119 12 0 0 352 rio.public.temp0000281093 9 0 0 321 rio.public.temp0000281045 15 0 0 283 rio.public.temp0000281109 4 0 0 146 rio.pg_toast.pg_toast_2619 5 5 1028 135 rio.public.temp0000281057 3 0 0 129 rio.public.temp0000281043 5 0 0 123 contagem.pg_catalog.pg_attribute 23 23 88884 101 rio.public.temp0000281147 2 0 0 67 rio.public.temp0000281027 4 0 0 48 rio.public.temp0000281019 2 0 0 48 rio.public.temp0000281061 1 0 0 47 rio.public.temp0000281059 1 0 0 47 rio.public.temp0000281073 1 0 0 47 rio.public.temp0000281063 1 0 0 47 rio.public.temp0000281065 1 0 0 47 rio.pg_catalog.pg_class 72 39 4616 46 rio.public.temp0000281079 1 0 0 45 rio.public.temp0000281089 2 0 0 44 rio.pg_catalog.pg_type 60 34 11975 43 rio.public.temp0000281113 2 0 0 37 contagem.pg_toast.pg_toast_2619 2 2 119 29 rio.public.temp0000281117 1 0 0 28 contagem.pg_catalog.pg_type 13 13 3924 24 rio.public.temp0000281169 1 0 0 21 rio.public.temp0000281055 2 0 0 20 rio.pg_catalog.pg_depend 16 16 10653 18 contagem.pg_catalog.pg_class 14 14 4392 16 rio.public.temp0000281041 1 0 0 11 rio.pg_catalog.pg_statistic 9 9 14514 8 rio.public.temp0000281097 1 0 0 7 contagem.pg_catalog.pg_index 7 7 1926 7 rio.public.temp0000281123 1 0 0 4 contagem.public.nf_entrada 2 2 639 4 rio.public.temp0000281049 1 0 0 0 rio.public.nf_entrada_itens 2 0 27 0 rio.public.caixa_itens 1 0 231 0 contagem.pg_catalog.pg_statistic 3 3 6272 0 rio.pg_catalog.pg_index 27 23 5725 0 contagem.pg_catalog.pg_depend 8 8 5285 0 contagem.pg_catalog.pg_shdepend 1 1 1022 0 rio.public.temp0000281099 9 0 0 0 rio.public.logs 5 0 0 0 rio.public.temp0000281085 2 0 0 0 contagem.public.usuarios 14 1 827 0 rio.auditor.auditor_2026_05 31 0 3898 0 rio.public.temp0000281077 6 0 0 0 rio.public.tmp_drill_0175 10 4 20562 0 rio.public.temp0000281111 1 0 0 0 rio.public.giga_testes 2 0 76 0 template1.pg_catalog.pg_shdepend 2 2 1189 0 postgres.pg_catalog.pg_shdepend 7 7 6597 0 rio.public.temp0000281137 22 0 0 0 rio.public.equipamento_codigos 1 0 587 0 rio.public.fluxo_passos 1 0 223 0 rio.public.usuarios 7 3 163 0 rio.public.lote_itens 1 0 155 0 rio.public.equipamentos_referencia 2 0 0 0 rio.public.equip_defeitos 1 0 467 0 rio.public.codigos_barra 4 0 1825 0 rio.public.temp0000281129 1 0 0 0 rio.public.nf_entrada_arquivo_erros 4 0 771 0 rio.public.fluxos 2 0 863 0 Total 671 276 473,446 5,411 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs May 28 00 2 0 01 0 0 02 1 0 03 0 0 04 2 1 05 5 2 06 1 1 07 32 44 08 54 105 09 72 150 10 61 129 11 62 104 12 34 60 13 37 91 14 62 144 15 116 148 16 93 154 17 34 52 18 1 0 19 0 0 20 0 0 21 1 2 22 1 0 23 0 0 - 6.64 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 5 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 3 7m48s 52s672ms 4m58s 2m36s call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 11:20:26 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 07:17:11 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 15:26:19 Database: rio User: intelifix Remote: [local] Application: psql
2 1 2s158ms 2s158ms 2s158ms 2s158ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246113, 504, '256297114030211,216721173254,216842851515,216535166671,216902434445,216855279797,216892378087,216603416890,216850237577,216902477580,216889556768,216364946164,216537362644,216793219802,216535916273,216828010920,216767121532,216770175050,216535897180,216848696776,216670196168,216673623035,216527106670,216664231726,216538319011,216449580003,216847280915,216361510914,216444597080,216534828300,216522940305,216566598202,184337382949,216821619712,216793362847,216673655159,216828836162,216851122345,216523982741', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 16:21:48 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246115, 504, '467075024951,216774830006,216715271219,216388405255,216468876363,216782562242,216774555051,216458662943,216462305464,216324182344,216651405064,216420419805,216379099106,216374614549,216578606769,216584282846,216322827676,216578639601,216760757374,216326821019,216374538706,216594470709,216651563340,216765201928,216598399497,216463235465,216715544859,216678612546,216426523353,216779653136,216782123052,216785973753,216494137392,216589639293,216419449800,216481966182,216432043151,216760875568,216589701119,216584033551', '',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 15:06:33 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246114, 504, '71420685850003120109,184271031928,216750671520,216550219409,216640019395,216546425559,216905959098,216336913743,216628646782,216355132031H011600722,216629516373,184270444564,216865909398,216910700000,216812902745,216607539717,216909813437,216907307580,216874170206,216790882425,216547105558,216348582020,216688693350,216347747280,216868790927,216543670409,216414108606,184327941635,216724480109,216557414163,184266502339,216879254349,216816024957,216752716062,216836661820,216356997386,216872143240,216867292430,216866960827,216739263549', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 14:21:15 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 1s4ms 1s4ms 1s4ms 1s4ms drop table if exists temp0000281029;-
DROP TABLE IF EXISTS temp0000281029;
Date: 2026-05-28 11:53:56 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000281029;
Date: 2026-05-28 11:53:56 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 4m58s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-05-28 11:20:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 1m57s CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-05-28 07:17:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 52s672ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-05-28 15:26:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 2s158ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (38785, 413, 'F200011337B71CB,840112934B1F$F200012189B35D1,1834AF24D7CD$F200013248B40CF,1834AF9BCD56$F200011057EAF97,9877E74E2525$F200012075B704F,840112DD8F49$F200011180B40F1,9877E7C07610', '',0153,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""}]','$$$$$$$$$$$$$$$$$','', 00);[ Date: 2026-05-28 13:54:53 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
5 1s4ms DROP TABLE IF EXISTS temp0000281029;[ Date: 2026-05-28 11:53:56 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,828 Total read queries
- 1,643 Total write queries
Queries by database
Key values
- rio Main database
- 5,893 Requests
- 7h43m49s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 6,650 Requests
User Request type Count Duration etiquetas Total 22 5s222ms select 22 5s222ms intelifix Total 6,650 8h4m6s copy to 276 41m41s ddl 1,363 55m49s others 292 44m15s select 4,717 5h42m20s lenon Total 93 1m2s ddl 4 1s30ms select 89 1m1s Duration by user
Key values
- 8h4m6s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 22 5s222ms select 22 5s222ms intelifix Total 6,650 8h4m6s copy to 276 41m41s ddl 1,363 55m49s others 292 44m15s select 4,717 5h42m20s lenon Total 93 1m2s ddl 4 1s30ms select 89 1m1s Queries by host
Key values
- [local] Main host
- 6,761 Requests
- 8h5m13s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 5,993 Requests
- 4h7m18s ([unknown])
- Main time consuming application
Application Request type Count Duration [unknown] Total 5,993 4h7m18s ddl 1,363 55m49s select 4,628 3h11m28s pgAdmin 4 - CONN:1223354 Total 1 324ms ddl 1 324ms pgAdmin 4 - CONN:3895900 Total 1 188ms ddl 1 188ms pgAdmin 4 - CONN:635022 Total 1 289ms ddl 1 289ms pgAdmin 4 - CONN:7527944 Total 1 228ms ddl 1 228ms pg_dump Total 286 41m43s copy to 276 41m41s select 10 2s136ms psql Total 482 3h16m11s others 292 44m15s select 190 2h31m56s Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-05-28 16:14:37 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,521 100-500ms duration
Slowest individual queries
Rank Duration Query 1 12m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 07:17:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 10m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 15:15:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 10m1s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 11:15:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 10m1s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-05-28 15:23:57 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
5 10m SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 16:15:02 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 9m44s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 13:14:46 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 9m29s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 17:14:31 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 9m14s analyze verbose;[ Date: 2026-05-28 05:09:15 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 8m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 12:13:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 7m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 14:12:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 7m23s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 20:12:25 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 7m16s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 08:12:18 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 7m14s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024878, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-28 15:26:15 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
14 7m11s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 10:12:12 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 6m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 09:11:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 6m54s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024860, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-28 11:20:25 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
17 6m26s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024837, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-28 07:17:10 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
18 6m19s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024872, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-28 14:32:37 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 5m30s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024885, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-05-28 16:28:52 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-05-28 19:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 2h8m39s 32 994ms 12m 4m1s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 28 07 2 12m5s 6m2s 08 2 7m18s 3m39s 09 2 6m56s 3m28s 10 2 7m12s 3m36s 11 2 10m9s 5m4s 12 2 8m17s 4m8s 13 2 9m47s 4m53s 14 2 8m1s 4m 15 2 10m24s 5m12s 16 2 10m10s 5m5s 17 2 9m37s 4m48s 18 2 5m14s 2m37s 19 2 5m22s 2m41s 20 2 7m26s 3m43s 21 2 5m20s 2m40s 22 2 5m13s 2m36s [ User: intelifix - Total duration: 2h8m39s - Times executed: 32 ]
[ Application: psql - Total duration: 2h8m39s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-28 07:17:01 Duration: 12m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-28 15:15:17 Duration: 10m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-28 11:15:02 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: psql
2 2h6m52s 282 152ms 10m1s 26s996ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 28 07 13 11m28s 52s936ms 08 35 5m46s 9s903ms 09 30 13m50s 27s686ms 10 14 9m21s 40s96ms 11 16 12m21s 46s323ms 12 13 5m9s 23s773ms 13 23 31s627ms 1s375ms 14 45 20m8s 26s862ms 15 30 22m1s 44s39ms 16 47 19m45s 25s228ms 17 12 6m21s 31s818ms 18 2 4s566ms 2s283ms 19 2 2s283ms 1s141ms [ User: intelifix - Total duration: 2h6m52s - Times executed: 282 ]
[ Application: [unknown] - Total duration: 2h6m52s - Times executed: 282 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-28 15:23:57 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024878, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-28 15:26:15 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024860, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-28 11:20:25 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 29m5s 1,567 150ms 6s853ms 1s113ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 28 07 14 8s345ms 596ms 08 80 1m34s 1s179ms 09 155 3m11s 1s233ms 10 160 3m31s 1s324ms 11 215 3m53s 1s86ms 12 97 1m36s 994ms 13 116 2m35s 1s344ms 14 297 4m52s 985ms 15 199 3m31s 1s61ms 16 173 3m11s 1s107ms 17 61 57s998ms 950ms [ User: intelifix - Total duration: 29m5s - Times executed: 1567 ]
[ Application: [unknown] - Total duration: 29m5s - Times executed: 1567 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246113, 504, '256297114030211,216721173254,216842851515,216535166671,216902434445,216855279797,216892378087,216603416890,216850237577,216902477580,216889556768,216364946164,216537362644,216793219802,216535916273,216828010920,216767121532,216770175050,216535897180,216848696776,216670196168,216673623035,216527106670,216664231726,216538319011,216449580003,216847280915,216361510914,216444597080,216534828300,216522940305,216566598202,184337382949,216821619712,216793362847,216673655159,216828836162,216851122345,216523982741', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 16:21:48 Duration: 6s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246115, 504, '467075024951,216774830006,216715271219,216388405255,216468876363,216782562242,216774555051,216458662943,216462305464,216324182344,216651405064,216420419805,216379099106,216374614549,216578606769,216584282846,216322827676,216578639601,216760757374,216326821019,216374538706,216594470709,216651563340,216765201928,216598399497,216463235465,216715544859,216678612546,216426523353,216779653136,216782123052,216785973753,216494137392,216589639293,216419449800,216481966182,216432043151,216760875568,216589701119,216584033551', '',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 15:06:33 Duration: 6s645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246114, 504, '71420685850003120109,184271031928,216750671520,216550219409,216640019395,216546425559,216905959098,216336913743,216628646782,216355132031H011600722,216629516373,184270444564,216865909398,216910700000,216812902745,216607539717,216909813437,216907307580,216874170206,216790882425,216547105558,216348582020,216688693350,216347747280,216868790927,216543670409,216414108606,184327941635,216724480109,216557414163,184266502339,216879254349,216816024957,216752716062,216836661820,216356997386,216872143240,216867292430,216866960827,216739263549', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 14:21:15 Duration: 6s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
4 19m28s 107 7s791ms 40s918ms 10s921ms create table temp0000281029 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 28 07 12 2m40s 13s343ms 08 6 1m5s 10s925ms 09 18 3m14s 10s820ms 10 9 1m49s 12s184ms 11 9 1m36s 10s753ms 12 18 3m1s 10s70ms 14 12 2m3s 10s295ms 15 15 2m39s 10s636ms 16 8 1m17s 9s661ms [ User: intelifix - Total duration: 19m28s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 19m28s - Times executed: 107 ]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 07:08:35 Duration: 40s918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:48:49 Duration: 13s908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:49:12 Duration: 13s839ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 15m40s 138 2s153ms 5m11s 6s816ms call rs_giga_triagem (?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 28 00 6 27s835ms 4s639ms 01 6 17s850ms 2s975ms 02 6 17s265ms 2s877ms 03 6 17s43ms 2s840ms 04 6 18s248ms 3s41ms 05 6 17s104ms 2s850ms 06 6 19s52ms 3s175ms 07 6 2m14s 22s420ms 08 6 17s978ms 2s996ms 09 6 21s143ms 3s523ms 10 6 20s378ms 3s396ms 11 6 5m29s 54s908ms 12 6 20s829ms 3s471ms 13 6 18s753ms 3s125ms 14 6 24s980ms 4s163ms 15 6 1m31s 15s176ms 16 6 27s129ms 4s521ms 17 6 15s984ms 2s664ms 18 6 15s515ms 2s585ms 19 6 15s944ms 2s657ms 20 6 22s584ms 3s764ms 21 6 15s474ms 2s579ms 22 6 14s503ms 2s417ms [ User: intelifix - Total duration: 15m40s - Times executed: 138 ]
[ Application: psql - Total duration: 15m40s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 11:20:26 Duration: 5m11s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 07:17:11 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 15:26:19 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
6 14m29s 32 437ms 1m30s 27s178ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 28 07 2 1m33s 46s619ms 08 2 37s472ms 18s736ms 09 2 36s28ms 18s14ms 10 2 38s1ms 19s 11 2 1m24s 42s339ms 12 2 34s62ms 17s31ms 13 2 1m16s 38s108ms 14 2 1m7s 33s666ms 15 2 1m21s 40s670ms 16 2 1m10s 35s189ms 17 2 55s583ms 27s791ms 18 2 26s393ms 13s196ms 19 2 31s31ms 15s515ms 20 2 1m23s 41s948ms 21 2 27s172ms 13s586ms 22 2 26s891ms 13s445ms [ User: intelifix - Total duration: 14m29s - Times executed: 32 ]
[ Application: psql - Total duration: 14m29s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-28 07:18:32 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-28 20:13:48 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-28 11:16:25 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
7 13m14s 19 30s351ms 1m48s 41s795ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 28 11 2 2m27s 1m13s 12 3 2m3s 41s231ms 13 1 41s611ms 41s611ms 14 2 1m21s 40s929ms 15 7 4m15s 36s428ms 16 3 1m46s 35s343ms 17 1 38s11ms 38s11ms [ User: intelifix - Total duration: 13m14s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 13m14s - Times executed: 19 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-28', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-28 11:08:22 Duration: 1m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-28', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-28 12:23:29 Duration: 51s175ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-28', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-28 14:34:11 Duration: 47s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 11m54s 2 2m40s 9m14s 5m57s analyze verbose;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 28 05 2 11m54s 5m57s [ User: intelifix - Total duration: 11m54s - Times executed: 2 ]
[ Application: psql - Total duration: 11m54s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-28 05:09:15 Duration: 9m14s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-28 05:11:55 Duration: 2m40s Database: contagem User: intelifix Remote: [local] Application: psql
9 11m33s 101 154ms 27s23ms 6s866ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 28 00 6 45s231ms 7s538ms 01 6 20s486ms 3s414ms 02 6 17s990ms 2s998ms 03 5 18s17ms 3s603ms 04 6 28s905ms 4s817ms 05 5 17s3ms 3s400ms 07 6 1m5s 10s959ms 08 6 1m12s 12s156ms 09 6 1m5s 10s891ms 10 6 49s869ms 8s311ms 11 6 59s113ms 9s852ms 12 6 56s837ms 9s472ms 13 3 5s832ms 1s944ms 14 6 50s710ms 8s451ms 15 6 1m11s 11s875ms 16 5 33s648ms 6s729ms 21 5 5s152ms 1s30ms 22 6 9s433ms 1s572ms [ User: intelifix - Total duration: 11m33s - Times executed: 101 ]
[ Application: psql - Total duration: 11m33s - Times executed: 101 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 00:05:29 Duration: 27s23ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 15:15:19 Duration: 18s388ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 07:25:17 Duration: 16s198ms Database: rio User: intelifix Remote: [local] Application: psql
10 11m12s 1,178 150ms 6s575ms 571ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 28 07 5 3s407ms 681ms 08 89 1m11s 806ms 09 114 56s686ms 497ms 10 178 1m22s 464ms 11 133 1m16s 574ms 13 140 1m24s 602ms 14 157 1m27s 555ms 15 106 1m8s 644ms 16 192 1m56s 605ms 17 64 25s808ms 403ms [ User: intelifix - Total duration: 11m12s - Times executed: 1178 ]
[ Application: [unknown] - Total duration: 11m12s - Times executed: 1178 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241667960208,241709744263,241704174662,241601509704,241709222439,241595261519,241599553756,241620905873,241706587377,241629456786,241708395152,241713983846,241679326782,241616745366,241618235556,241609249517,241671935466,241694012638,241651184148,241679167193,241635859813,241668185257,241635624459,241666434660,241653840828,241672652742,241693191133,241607814663,241657102122,241622810931,241701337078,241617565962,241698554753,241703553838,241708263748,241676761628,241617931128,241660360712,241630877070,241604382948,241672839404,241661186482,241617927086,241669618999,241672824756,241616171315,241622032942", "usuario" : "405", "caixa" : "2757970", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-28 16:41:34 Duration: 6s575ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "156", "itens" : "6802B8A1D77E,B4F267575653,6802B8F8F6E1,B4F26734107B,6802B8239C94,6802B823F0B5", "usuario" : "405", "caixa" : "2754764", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-28 15:17:11 Duration: 5s497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "46", "itens" : "14B7F88DBC0E,B42A0E9AD2DB,5C7695963BA2,1062D099514F,90585141B081,B42A0ED31AB4,B42A0ED409A9,087E648428A1,10C25A3CAFEF,54A65C8B1925,54A65C8A5238,B42A0E9C413C,54A65C0F0007,54A65C8B331F,087E6482B872", "usuario" : "405", "caixa" : "2901881", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-28 11:47:52 Duration: 5s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8m2s 47 8s92ms 42s195ms 10s264ms create table temp0000281137 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 28 14 3 1m1s 20s406ms 15 7 1m8s 9s726ms 16 26 4m11s 9s684ms 17 11 1m41s 9s210ms [ User: intelifix - Total duration: 8m2s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m2s - Times executed: 47 ]
-
CREATE TABLE temp0000281137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 14:08:29 Duration: 42s195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 16:57:08 Duration: 12s922ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 16:25:03 Duration: 11s424ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m48s 66 3s119ms 22s617ms 4s377ms create table temp0000281029 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 28 07 21 1m15s 3s603ms 09 8 32s665ms 4s83ms 11 5 41s447ms 8s289ms 12 8 33s365ms 4s170ms 14 6 26s572ms 4s428ms 15 10 44s269ms 4s426ms 16 8 34s903ms 4s362ms [ User: intelifix - Total duration: 4m48s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 4m48s - Times executed: 66 ]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 11:23:27 Duration: 22s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 12:17:21 Duration: 5s967ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 14:56:39 Duration: 5s892ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 4m39s 62 265ms 40s607ms 4s513ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 28 07 4 3s592ms 898ms 08 4 38s37ms 9s509ms 09 7 8s387ms 1s198ms 10 7 1m9s 9s889ms 11 4 39s393ms 9s848ms 12 9 46s795ms 5s199ms 14 5 7s291ms 1s458ms 15 7 17s905ms 2s557ms 16 11 41s439ms 3s767ms 17 4 7s789ms 1s947ms [ User: intelifix - Total duration: 4m39s - Times executed: 62 ]
[ Application: psql - Total duration: 4m39s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024853);
Date: 2026-05-28 10:21:16 Duration: 40s607ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024868);
Date: 2026-05-28 12:25:20 Duration: 40s389ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024858);
Date: 2026-05-28 11:10:05 Duration: 37s288ms Database: rio User: intelifix Remote: [local] Application: psql
14 4m6s 45 700ms 15s128ms 5s476ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 28 08 3 17s270ms 5s756ms 09 3 30s528ms 10s176ms 10 3 24s539ms 8s179ms 11 3 22s648ms 7s549ms 12 3 12s135ms 4s45ms 13 3 11s43ms 3s681ms 14 3 35s511ms 11s837ms 15 3 24s779ms 8s259ms 16 3 23s564ms 7s854ms 17 3 25s167ms 8s389ms 18 3 6s128ms 2s42ms 19 3 2s932ms 977ms 20 3 3s321ms 1s107ms 21 3 2s713ms 904ms 22 3 4s156ms 1s385ms [ User: intelifix - Total duration: 4m6s - Times executed: 45 ]
[ Application: psql - Total duration: 4m6s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-28 09:00:16 Duration: 15s128ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-28 14:00:16 Duration: 14s552ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-28 14:40:15 Duration: 14s117ms Database: rio User: intelifix Remote: [local] Application: psql
15 3m35s 20 9s509ms 14s496ms 10s798ms create table temp0000281099 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 28 10 5 55s880ms 11s176ms 11 3 34s444ms 11s481ms 12 12 2m5s 10s470ms [ User: intelifix - Total duration: 3m35s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 20 ]
-
CREATE TABLE temp0000281099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:54:39 Duration: 14s496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:53:11 Duration: 11s878ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 11:09:40 Duration: 11s730ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m16s 2 1m36s 1m40s 1m38s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 28 20 1 1m36s 1m36s 23 1 1m40s 1m40s [ User: intelifix - Total duration: 3m16s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m16s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-28 23:40:57 Duration: 1m40s 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-05-28 20:08:59 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
17 3m13s 192 150ms 23s729ms 1s5ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 28 07 13 7s986ms 614ms 08 29 12s918ms 445ms 09 22 6s850ms 311ms 10 9 3s850ms 427ms 11 5 3s718ms 743ms 13 22 12s199ms 554ms 14 34 1m53s 3s326ms 15 23 15s614ms 678ms 16 33 16s349ms 495ms 17 2 419ms 209ms [ User: intelifix - Total duration: 3m13s - Times executed: 192 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 192 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037595) LIMIT 1;
Date: 2026-05-28 14:16:03 Duration: 23s729ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037951) LIMIT 1;
Date: 2026-05-28 14:14:32 Duration: 15s202ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037949) LIMIT 1;
Date: 2026-05-28 14:15:03 Duration: 14s761ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
18 3m3s 44 192ms 27s350ms 4s171ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 28 07 2 29s252ms 14s626ms 08 3 11s678ms 3s892ms 09 8 7s423ms 927ms 10 5 17s133ms 3s426ms 11 3 32s53ms 10s684ms 12 5 18s485ms 3s697ms 14 3 19s10ms 6s336ms 15 4 23s801ms 5s950ms 16 9 23s30ms 2s558ms 17 2 1s689ms 844ms [ User: intelifix - Total duration: 3m3s - Times executed: 44 ]
[ Application: psql - Total duration: 3m3s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (024837);
Date: 2026-05-28 07:10:46 Duration: 27s350ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (024860);
Date: 2026-05-28 11:13:21 Duration: 18s769ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (024872);
Date: 2026-05-28 14:26:01 Duration: 12s435ms Database: rio User: intelifix Remote: [local] Application: psql
19 2m 2 25s127ms 1m35s 1m 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 #19
Day Hour Count Duration Avg duration May 28 23 2 2m 1m [ User: intelifix - Total duration: 2m - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m - 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-05-28 23:15:05 Duration: 1m35s 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-05-28 23:42:56 Duration: 25s127ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
20 1m56s 10 10s479ms 12s787ms 11s671ms create table temp0000281077 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 28 08 7 1m22s 11s781ms 09 3 34s249ms 11s416ms [ User: intelifix - Total duration: 1m56s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m56s - Times executed: 10 ]
-
CREATE TABLE temp0000281077 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 08:40:41 Duration: 12s787ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281077 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 08:45:59 Duration: 12s723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281077 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 09:40:07 Duration: 12s454ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,567 29m5s 150ms 6s853ms 1s113ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 28 07 14 8s345ms 596ms 08 80 1m34s 1s179ms 09 155 3m11s 1s233ms 10 160 3m31s 1s324ms 11 215 3m53s 1s86ms 12 97 1m36s 994ms 13 116 2m35s 1s344ms 14 297 4m52s 985ms 15 199 3m31s 1s61ms 16 173 3m11s 1s107ms 17 61 57s998ms 950ms [ User: intelifix - Total duration: 29m5s - Times executed: 1567 ]
[ Application: [unknown] - Total duration: 29m5s - Times executed: 1567 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246113, 504, '256297114030211,216721173254,216842851515,216535166671,216902434445,216855279797,216892378087,216603416890,216850237577,216902477580,216889556768,216364946164,216537362644,216793219802,216535916273,216828010920,216767121532,216770175050,216535897180,216848696776,216670196168,216673623035,216527106670,216664231726,216538319011,216449580003,216847280915,216361510914,216444597080,216534828300,216522940305,216566598202,184337382949,216821619712,216793362847,216673655159,216828836162,216851122345,216523982741', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 16:21:48 Duration: 6s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246115, 504, '467075024951,216774830006,216715271219,216388405255,216468876363,216782562242,216774555051,216458662943,216462305464,216324182344,216651405064,216420419805,216379099106,216374614549,216578606769,216584282846,216322827676,216578639601,216760757374,216326821019,216374538706,216594470709,216651563340,216765201928,216598399497,216463235465,216715544859,216678612546,216426523353,216779653136,216782123052,216785973753,216494137392,216589639293,216419449800,216481966182,216432043151,216760875568,216589701119,216584033551', '',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 15:06:33 Duration: 6s645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246114, 504, '71420685850003120109,184271031928,216750671520,216550219409,216640019395,216546425559,216905959098,216336913743,216628646782,216355132031H011600722,216629516373,184270444564,216865909398,216910700000,216812902745,216607539717,216909813437,216907307580,216874170206,216790882425,216547105558,216348582020,216688693350,216347747280,216868790927,216543670409,216414108606,184327941635,216724480109,216557414163,184266502339,216879254349,216816024957,216752716062,216836661820,216356997386,216872143240,216867292430,216866960827,216739263549', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 14:21:15 Duration: 6s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1,178 11m12s 150ms 6s575ms 571ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 28 07 5 3s407ms 681ms 08 89 1m11s 806ms 09 114 56s686ms 497ms 10 178 1m22s 464ms 11 133 1m16s 574ms 13 140 1m24s 602ms 14 157 1m27s 555ms 15 106 1m8s 644ms 16 192 1m56s 605ms 17 64 25s808ms 403ms [ User: intelifix - Total duration: 11m12s - Times executed: 1178 ]
[ Application: [unknown] - Total duration: 11m12s - Times executed: 1178 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "230007", "modelo" : "320", "itens" : "241667960208,241709744263,241704174662,241601509704,241709222439,241595261519,241599553756,241620905873,241706587377,241629456786,241708395152,241713983846,241679326782,241616745366,241618235556,241609249517,241671935466,241694012638,241651184148,241679167193,241635859813,241668185257,241635624459,241666434660,241653840828,241672652742,241693191133,241607814663,241657102122,241622810931,241701337078,241617565962,241698554753,241703553838,241708263748,241676761628,241617931128,241660360712,241630877070,241604382948,241672839404,241661186482,241617927086,241669618999,241672824756,241616171315,241622032942", "usuario" : "405", "caixa" : "2757970", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-28 16:41:34 Duration: 6s575ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "229989", "modelo" : "156", "itens" : "6802B8A1D77E,B4F267575653,6802B8F8F6E1,B4F26734107B,6802B8239C94,6802B823F0B5", "usuario" : "405", "caixa" : "2754764", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-28 15:17:11 Duration: 5s497ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "242688", "modelo" : "46", "itens" : "14B7F88DBC0E,B42A0E9AD2DB,5C7695963BA2,1062D099514F,90585141B081,B42A0ED31AB4,B42A0ED409A9,087E648428A1,10C25A3CAFEF,54A65C8B1925,54A65C8A5238,B42A0E9C413C,54A65C0F0007,54A65C8B331F,087E6482B872", "usuario" : "405", "caixa" : "2901881", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-05-28 11:47:52 Duration: 5s117ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 282 2h6m52s 152ms 10m1s 26s996ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 28 07 13 11m28s 52s936ms 08 35 5m46s 9s903ms 09 30 13m50s 27s686ms 10 14 9m21s 40s96ms 11 16 12m21s 46s323ms 12 13 5m9s 23s773ms 13 23 31s627ms 1s375ms 14 45 20m8s 26s862ms 15 30 22m1s 44s39ms 16 47 19m45s 25s228ms 17 12 6m21s 31s818ms 18 2 4s566ms 2s283ms 19 2 2s283ms 1s141ms [ User: intelifix - Total duration: 2h6m52s - Times executed: 282 ]
[ Application: [unknown] - Total duration: 2h6m52s - Times executed: 282 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-28 15:23:57 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024878, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-28 15:26:15 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024860, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-28 11:20:25 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
4 252 1m3s 150ms 612ms 250ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration May 28 00 15 4s180ms 278ms 04 18 4s674ms 259ms 05 12 4s30ms 335ms 07 26 6s295ms 242ms 08 26 6s199ms 238ms 09 28 7s22ms 250ms 10 25 6s542ms 261ms 11 20 4s691ms 234ms 12 20 5s165ms 258ms 14 20 4s731ms 236ms 15 24 5s431ms 226ms 16 17 3s822ms 224ms 17 1 233ms 233ms [ User: intelifix - Total duration: 1m3s - Times executed: 252 ]
[ Application: [unknown] - Total duration: 1m3s - Times executed: 252 ]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241646268405,241712533637,241656712028,241647305262,241602887885,241603558691,241631666070,241667811327,241638351527,241709476178,241649576168,241691641722,241698714062,241630179719,241678325259,241636026271,241654601721,241672357583,241726891728,241615179613', NULL, NULL, 0320, 00);
Date: 2026-05-28 04:59:35 Duration: 612ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241664770312,241632285356,241631518604,241729897385,241713354559,241654451426,241671521734,241666969920,241668176771,241618271621,241694859094,230047879295,241653912125,241655674261,241694897179,241649625365,241632280104,241711178689,241622469101,230043631531', NULL, NULL, 0320, 00);
Date: 2026-05-28 05:01:43 Duration: 606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (429, 5, '113', 3, '241663000420,241665295974,241664738186,241728555167,241632291822,241635700707,241658402137,241667894668,241599462030,241652089904,241629910827,241670337891,241679897477,241649660925,241673059403,241656740516,241620307778,241667126276,241670314455,230043682546', NULL, NULL, 0320, 00);
Date: 2026-05-28 05:00:39 Duration: 591ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 192 3m13s 150ms 23s729ms 1s5ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 28 07 13 7s986ms 614ms 08 29 12s918ms 445ms 09 22 6s850ms 311ms 10 9 3s850ms 427ms 11 5 3s718ms 743ms 13 22 12s199ms 554ms 14 34 1m53s 3s326ms 15 23 15s614ms 678ms 16 33 16s349ms 495ms 17 2 419ms 209ms [ User: intelifix - Total duration: 3m13s - Times executed: 192 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 192 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037595) LIMIT 1;
Date: 2026-05-28 14:16:03 Duration: 23s729ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037951) LIMIT 1;
Date: 2026-05-28 14:14:32 Duration: 15s202ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037949) LIMIT 1;
Date: 2026-05-28 14:15:03 Duration: 14s761ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 154 33s350ms 150ms 2s487ms 216ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 28 00 1 334ms 334ms 04 1 164ms 164ms 07 1 174ms 174ms 08 1 176ms 176ms 10 4 4s942ms 1s235ms 11 3 569ms 189ms 12 5 1s339ms 267ms 13 2 354ms 177ms 14 14 2s543ms 181ms 15 38 7s832ms 206ms 16 59 10s714ms 181ms 17 25 4s202ms 168ms [ User: intelifix - Total duration: 33s350ms - Times executed: 154 ]
[ Application: [unknown] - Total duration: 33s350ms - Times executed: 154 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-05-28", "data-ate" : "2026-05-28", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 506 }');
Date: 2026-05-28 10:34:20 Duration: 2s487ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "0", "data-de" : "2026-05-28", "data-ate" : "2026-05-28", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "0", "usuario" : 506 }');
Date: 2026-05-28 10:34:09 Duration: 2s133ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "362", "data-de" : "2026-05-28", "data-ate" : "2026-05-28", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 417 }');
Date: 2026-05-28 12:28:13 Duration: 557ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 138 15m40s 2s153ms 5m11s 6s816ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 28 00 6 27s835ms 4s639ms 01 6 17s850ms 2s975ms 02 6 17s265ms 2s877ms 03 6 17s43ms 2s840ms 04 6 18s248ms 3s41ms 05 6 17s104ms 2s850ms 06 6 19s52ms 3s175ms 07 6 2m14s 22s420ms 08 6 17s978ms 2s996ms 09 6 21s143ms 3s523ms 10 6 20s378ms 3s396ms 11 6 5m29s 54s908ms 12 6 20s829ms 3s471ms 13 6 18s753ms 3s125ms 14 6 24s980ms 4s163ms 15 6 1m31s 15s176ms 16 6 27s129ms 4s521ms 17 6 15s984ms 2s664ms 18 6 15s515ms 2s585ms 19 6 15s944ms 2s657ms 20 6 22s584ms 3s764ms 21 6 15s474ms 2s579ms 22 6 14s503ms 2s417ms [ User: intelifix - Total duration: 15m40s - Times executed: 138 ]
[ Application: psql - Total duration: 15m40s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 11:20:26 Duration: 5m11s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 07:17:11 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 15:26:19 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
8 108 17s498ms 150ms 221ms 162ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 28 00 2 316ms 158ms 04 5 783ms 156ms 05 1 166ms 166ms 07 2 352ms 176ms 08 11 1s794ms 163ms 09 6 1s93ms 182ms 10 7 1s143ms 163ms 11 13 2s107ms 162ms 12 7 1s105ms 157ms 13 12 1s908ms 159ms 14 13 2s58ms 158ms 15 18 2s905ms 161ms 16 10 1s602ms 160ms 17 1 159ms 159ms [ User: intelifix - Total duration: 17s498ms - Times executed: 108 ]
[ Application: [unknown] - Total duration: 17s498ms - Times executed: 108 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0155;
Date: 2026-05-28 09:45:14 Duration: 221ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-05-28 11:16:50 Duration: 211ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0156;
Date: 2026-05-28 13:27:29 Duration: 205ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 107 19m28s 7s791ms 40s918ms 10s921ms create table temp0000281029 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 28 07 12 2m40s 13s343ms 08 6 1m5s 10s925ms 09 18 3m14s 10s820ms 10 9 1m49s 12s184ms 11 9 1m36s 10s753ms 12 18 3m1s 10s70ms 14 12 2m3s 10s295ms 15 15 2m39s 10s636ms 16 8 1m17s 9s661ms [ User: intelifix - Total duration: 19m28s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 19m28s - Times executed: 107 ]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 07:08:35 Duration: 40s918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:48:49 Duration: 13s908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:49:12 Duration: 13s839ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 101 11m33s 154ms 27s23ms 6s866ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 28 00 6 45s231ms 7s538ms 01 6 20s486ms 3s414ms 02 6 17s990ms 2s998ms 03 5 18s17ms 3s603ms 04 6 28s905ms 4s817ms 05 5 17s3ms 3s400ms 07 6 1m5s 10s959ms 08 6 1m12s 12s156ms 09 6 1m5s 10s891ms 10 6 49s869ms 8s311ms 11 6 59s113ms 9s852ms 12 6 56s837ms 9s472ms 13 3 5s832ms 1s944ms 14 6 50s710ms 8s451ms 15 6 1m11s 11s875ms 16 5 33s648ms 6s729ms 21 5 5s152ms 1s30ms 22 6 9s433ms 1s572ms [ User: intelifix - Total duration: 11m33s - Times executed: 101 ]
[ Application: psql - Total duration: 11m33s - Times executed: 101 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 00:05:29 Duration: 27s23ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 15:15:19 Duration: 18s388ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 07:25:17 Duration: 16s198ms Database: rio User: intelifix Remote: [local] Application: psql
11 85 41s776ms 276ms 782ms 491ms 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 #11
Day Hour Count Duration Avg duration May 28 00 2 1s58ms 529ms 04 3 1s440ms 480ms 05 1 566ms 566ms 06 1 714ms 714ms 07 5 2s669ms 533ms 08 8 4s515ms 564ms 09 7 4s63ms 580ms 10 7 3s278ms 468ms 11 8 4s468ms 558ms 12 2 1s105ms 552ms 13 10 4s319ms 431ms 14 8 4s92ms 511ms 15 9 4s80ms 453ms 16 7 2s643ms 377ms 17 5 2s125ms 425ms 19 1 344ms 344ms 20 1 288ms 288ms [ User: lenon - Total duration: 41s776ms - Times executed: 85 ]
[ Application: [unknown] - Total duration: 41s776ms - Times executed: 85 ]
-
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-05-28 08:18:26 Duration: 782ms Database: contagem User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-28 14:10:15 Duration: 719ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-05-28 06:55:29 Duration: 714ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
12 79 32s937ms 180ms 8s96ms 416ms create table temp0000281127 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 28 13 6 14s840ms 2s473ms 14 32 7s554ms 236ms 15 20 5s261ms 263ms 16 18 4s539ms 252ms 17 3 741ms 247ms [ User: intelifix - Total duration: 32s937ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 32s937ms - Times executed: 79 ]
-
CREATE TABLE temp0000281127 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-05-2026", "ate" :"28-05-2026", "nota-fiscal":"78732", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 13:36:42 Duration: 8s96ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281127 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 13:36:16 Duration: 4s306ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281127 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-05-2026", "ate" :"28-05-2026", "nota-fiscal":"78732", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 13:37:09 Duration: 792ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 79 26s332ms 150ms 1s636ms 333ms select * from rs_baixa_executa (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 28 08 2 625ms 312ms 11 4 866ms 216ms 13 9 2s394ms 266ms 14 12 3s195ms 266ms 15 39 15s895ms 407ms 16 13 3s354ms 258ms [ User: intelifix - Total duration: 26s332ms - Times executed: 79 ]
[ Application: [unknown] - Total duration: 26s332ms - Times executed: 79 ]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '229936899610,229954811729,229993099113,229930280323,230003934345,230008776164,229946141231,230008410821,229930912640,229996594549,229938290218,229996625966,229929506172,229937432749,230000102939,229948910727,229936585056,229996281837,230009411738,229964184248,229930802831,229998117997', '70;1', 'DEFAULT', 09, 0287, '','', '', 00);
Date: 2026-05-28 15:56:39 Duration: 1s636ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, 'ECBEDDAC027A,F081752D3572,00CB515DCDB2,00CB51F69F57,F8084F49ECBC,F08175378840,34495B8F005D,981E191E529A,34495B96C95F,F081752C8990,D06EDE984DE3,8020DA4D1B6D,3093BCC5BBAD,D06EDE78B50B,A86ABBD1270D', '95;1', 'DEFAULT', 09, 0129, '','', '', 00);
Date: 2026-05-28 15:29:44 Duration: 1s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_BAIXA_EXECUTA (310, 5, 7, 6, '942CB34E2EBD,8C444F147AB6,942CB3AEA991,8C444FF024B2,E820E29035B7,942CB3C7D557,E820E28941CD,E820E24454A0,942CB34CE244,E820E2B68763,E820E2859B38,942CB3711F40,942CB3B168A8,8C444F10FE21,E820E285E97A', '95;1', 'DEFAULT', 09, 039, '','', '', 00);
Date: 2026-05-28 15:49:31 Duration: 1s232ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 76 16s157ms 150ms 488ms 212ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 28 07 10 2s168ms 216ms 08 2 496ms 248ms 09 4 806ms 201ms 10 3 466ms 155ms 11 6 1s448ms 241ms 12 4 772ms 193ms 13 6 1s384ms 230ms 14 15 2s952ms 196ms 15 18 3s616ms 200ms 16 7 1s785ms 255ms 17 1 259ms 259ms [ User: intelifix - Total duration: 16s157ms - Times executed: 76 ]
[ Application: [unknown] - Total duration: 16s157ms - Times executed: 76 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"305", "usuario" :"407", "tipo" :"N", "itens" :"001", "nota-fiscal" :"9941", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-05-28 13:10:31 Duration: 488ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"2", "cliente" :"1", "modelo" :"155", "usuario" :"417", "tipo" :"N", "itens" :"002", "nota-fiscal" :"9941", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-05-28 11:15:24 Duration: 423ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"464", "usuario" :"320", "tipo" :"N", "itens" :"002", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-05-28 07:18:54 Duration: 409ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 75 44s922ms 340ms 865ms 598ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 28 00 2 1s338ms 669ms 04 3 1s810ms 603ms 05 1 676ms 676ms 07 3 2s8ms 669ms 08 5 3s82ms 616ms 09 6 4s131ms 688ms 10 7 4s3ms 571ms 11 8 5s330ms 666ms 12 2 1s307ms 653ms 13 8 4s530ms 566ms 14 8 5s32ms 629ms 15 9 5s197ms 577ms 16 7 3s288ms 469ms 17 5 2s696ms 539ms 19 1 488ms 488ms [ User: intelifix - Total duration: 44s922ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 44s922ms - Times executed: 75 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-05-28 15:16:41 Duration: 865ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (415, 81, 1);
Date: 2026-05-28 11:56:19 Duration: 862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-05-28 14:10:15 Duration: 821ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 72 13s995ms 152ms 315ms 194ms create table temp0000281117 as select * from rs_baixas_lista (?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 28 13 17 3s383ms 199ms 14 30 5s513ms 183ms 15 12 2s553ms 212ms 16 9 1s806ms 200ms 17 4 738ms 184ms [ User: intelifix - Total duration: 13s995ms - Times executed: 72 ]
[ Application: [unknown] - Total duration: 13s995ms - Times executed: 72 ]
-
CREATE TABLE temp0000281117 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '6802B8A40740', '2026-05-26', '2026-05-28');
Date: 2026-05-28 16:18:43 Duration: 315ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281117 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '532090027984', '2026-05-26', '2026-05-28');
Date: 2026-05-28 13:23:30 Duration: 272ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281117 AS SELECT * FROM RS_BAIXAS_LISTA (06, 00, 00, 0173, 00, '1834AF9AA0C6', '2026-05-26', '2026-05-28');
Date: 2026-05-28 15:20:39 Duration: 267ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 70 20s769ms 162ms 1s912ms 296ms select (rs_fast_barras (b.eq_id)).* from caixa_itens a inner join fluxos b on b.flu_id = a.flu_id where a.cai_id = ? order by a.cai_ordem;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 28 07 1 227ms 227ms 08 6 2s174ms 362ms 09 10 2s447ms 244ms 10 14 3s743ms 267ms 11 10 2s680ms 268ms 13 5 1s218ms 243ms 14 5 1s283ms 256ms 15 3 604ms 201ms 16 12 5s423ms 451ms 17 4 964ms 241ms [ User: intelifix - Total duration: 20s769ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 20s769ms - Times executed: 70 ]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 2757970 ORDER BY A.CAI_ORDEM;
Date: 2026-05-28 16:41:12 Duration: 1s912ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 972524 ORDER BY A.CAI_ORDEM;
Date: 2026-05-28 08:03:50 Duration: 893ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT (RS_FAST_BARRAS (B.EQ_ID)).* FROM CAIXA_ITENS A INNER JOIN FLUXOS B ON B.FLU_ID = A.FLU_ID WHERE A.CAI_ID = 1227033 ORDER BY A.CAI_ORDEM;
Date: 2026-05-28 16:38:44 Duration: 767ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 66 4m48s 3s119ms 22s617ms 4s377ms create table temp0000281029 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 28 07 21 1m15s 3s603ms 09 8 32s665ms 4s83ms 11 5 41s447ms 8s289ms 12 8 33s365ms 4s170ms 14 6 26s572ms 4s428ms 15 10 44s269ms 4s426ms 16 8 34s903ms 4s362ms [ User: intelifix - Total duration: 4m48s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 4m48s - Times executed: 66 ]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 11:23:27 Duration: 22s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 12:17:21 Duration: 5s967ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 14:56:39 Duration: 5s892ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 65 21s775ms 155ms 3s849ms 335ms create table temp0000281059 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 28 08 6 5s44ms 840ms 09 1 319ms 319ms 10 13 3s526ms 271ms 11 2 547ms 273ms 12 5 1s424ms 284ms 13 5 1s673ms 334ms 14 9 3s68ms 340ms 15 8 3s521ms 440ms 16 15 2s490ms 166ms 17 1 157ms 157ms [ User: intelifix - Total duration: 21s775ms - Times executed: 65 ]
[ Application: [unknown] - Total duration: 21s775ms - Times executed: 65 ]
-
CREATE TABLE temp0000281059 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 08:07:11 Duration: 3s849ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281059 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"1081", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 15:53:19 Duration: 615ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281059 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"1081", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 15:37:00 Duration: 590ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 64 24s345ms 264ms 551ms 380ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 28 07 3 1s164ms 388ms 08 3 1s156ms 385ms 09 5 1s830ms 366ms 10 4 1s718ms 429ms 11 4 1s494ms 373ms 12 9 3s481ms 386ms 14 7 2s563ms 366ms 15 7 2s569ms 367ms 16 15 5s550ms 370ms 17 7 2s816ms 402ms [ User: intelifix - Total duration: 24s345ms - Times executed: 64 ]
[ Application: [unknown] - Total duration: 24s345ms - Times executed: 64 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-05-28 15:13:49 Duration: 551ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-05-28 16:21:25 Duration: 509ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-05-28 12:47:29 Duration: 491ms 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 2m40s 9m14s 5m57s 2 11m54s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration May 28 05 2 11m54s 5m57s [ User: intelifix - Total duration: 11m54s - Times executed: 2 ]
[ Application: psql - Total duration: 11m54s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-05-28 05:09:15 Duration: 9m14s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-05-28 05:11:55 Duration: 2m40s Database: contagem User: intelifix Remote: [local] Application: psql
2 994ms 12m 4m1s 32 2h8m39s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration May 28 07 2 12m5s 6m2s 08 2 7m18s 3m39s 09 2 6m56s 3m28s 10 2 7m12s 3m36s 11 2 10m9s 5m4s 12 2 8m17s 4m8s 13 2 9m47s 4m53s 14 2 8m1s 4m 15 2 10m24s 5m12s 16 2 10m10s 5m5s 17 2 9m37s 4m48s 18 2 5m14s 2m37s 19 2 5m22s 2m41s 20 2 7m26s 3m43s 21 2 5m20s 2m40s 22 2 5m13s 2m36s [ User: intelifix - Total duration: 2h8m39s - Times executed: 32 ]
[ Application: psql - Total duration: 2h8m39s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-28 07:17:01 Duration: 12m Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-28 15:15:17 Duration: 10m16s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-05-28 11:15:02 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: psql
3 1m36s 1m40s 1m38s 2 3m16s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration May 28 20 1 1m36s 1m36s 23 1 1m40s 1m40s [ User: intelifix - Total duration: 3m16s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 3m16s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-05-28 23:40:57 Duration: 1m40s 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-05-28 20:08:59 Duration: 1m36s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 25s127ms 1m35s 1m 2 2m 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 #4
Day Hour Count Duration Avg duration May 28 23 2 2m 1m [ User: intelifix - Total duration: 2m - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m - 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-05-28 23:15:05 Duration: 1m35s 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-05-28 23:42:56 Duration: 25s127ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 30s351ms 1m48s 41s795ms 19 13m14s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration May 28 11 2 2m27s 1m13s 12 3 2m3s 41s231ms 13 1 41s611ms 41s611ms 14 2 1m21s 40s929ms 15 7 4m15s 36s428ms 16 3 1m46s 35s343ms 17 1 38s11ms 38s11ms [ User: intelifix - Total duration: 13m14s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 13m14s - Times executed: 19 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-28', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-28 11:08:22 Duration: 1m48s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-28', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-28 12:23:29 Duration: 51s175ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-05-28', 0175, '', '', 0, 6, '2026-05-01');
Date: 2026-05-28 14:34:11 Duration: 47s443ms Database: rio User: intelifix Remote: [local] Application: [unknown]
6 437ms 1m30s 27s178ms 32 14m29s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration May 28 07 2 1m33s 46s619ms 08 2 37s472ms 18s736ms 09 2 36s28ms 18s14ms 10 2 38s1ms 19s 11 2 1m24s 42s339ms 12 2 34s62ms 17s31ms 13 2 1m16s 38s108ms 14 2 1m7s 33s666ms 15 2 1m21s 40s670ms 16 2 1m10s 35s189ms 17 2 55s583ms 27s791ms 18 2 26s393ms 13s196ms 19 2 31s31ms 15s515ms 20 2 1m23s 41s948ms 21 2 27s172ms 13s586ms 22 2 26s891ms 13s445ms [ User: intelifix - Total duration: 14m29s - Times executed: 32 ]
[ Application: psql - Total duration: 14m29s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-28 07:18:32 Duration: 1m30s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-28 20:13:48 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-05-28 11:16:25 Duration: 1m22s Database: rio User: intelifix Remote: [local] Application: psql
7 152ms 10m1s 26s996ms 282 2h6m52s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration May 28 07 13 11m28s 52s936ms 08 35 5m46s 9s903ms 09 30 13m50s 27s686ms 10 14 9m21s 40s96ms 11 16 12m21s 46s323ms 12 13 5m9s 23s773ms 13 23 31s627ms 1s375ms 14 45 20m8s 26s862ms 15 30 22m1s 44s39ms 16 47 19m45s 25s228ms 17 12 6m21s 31s818ms 18 2 4s566ms 2s283ms 19 2 2s283ms 1s141ms [ User: intelifix - Total duration: 2h6m52s - Times executed: 282 ]
[ Application: [unknown] - Total duration: 2h6m52s - Times executed: 282 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-05-01''),DATE(''2026-05-27'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-05-28 15:23:57 Duration: 10m1s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024878, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-28 15:26:15 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 024860, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-05-28 11:20:25 Duration: 6m54s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 10s479ms 12s787ms 11s671ms 10 1m56s create table temp0000281077 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration May 28 08 7 1m22s 11s781ms 09 3 34s249ms 11s416ms [ User: intelifix - Total duration: 1m56s - Times executed: 10 ]
[ Application: [unknown] - Total duration: 1m56s - Times executed: 10 ]
-
CREATE TABLE temp0000281077 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 08:40:41 Duration: 12s787ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281077 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 08:45:59 Duration: 12s723ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281077 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 09:40:07 Duration: 12s454ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 7s791ms 40s918ms 10s921ms 107 19m28s create table temp0000281029 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration May 28 07 12 2m40s 13s343ms 08 6 1m5s 10s925ms 09 18 3m14s 10s820ms 10 9 1m49s 12s184ms 11 9 1m36s 10s753ms 12 18 3m1s 10s70ms 14 12 2m3s 10s295ms 15 15 2m39s 10s636ms 16 8 1m17s 9s661ms [ User: intelifix - Total duration: 19m28s - Times executed: 107 ]
[ Application: [unknown] - Total duration: 19m28s - Times executed: 107 ]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 07:08:35 Duration: 40s918ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:48:49 Duration: 13s908ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:49:12 Duration: 13s839ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 9s509ms 14s496ms 10s798ms 20 3m35s create table temp0000281099 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration May 28 10 5 55s880ms 11s176ms 11 3 34s444ms 11s481ms 12 12 2m5s 10s470ms [ User: intelifix - Total duration: 3m35s - Times executed: 20 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 20 ]
-
CREATE TABLE temp0000281099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:54:39 Duration: 14s496ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 10:53:11 Duration: 11s878ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281099 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 11:09:40 Duration: 11s730ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 8s92ms 42s195ms 10s264ms 47 8m2s create table temp0000281137 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration May 28 14 3 1m1s 20s406ms 15 7 1m8s 9s726ms 16 26 4m11s 9s684ms 17 11 1m41s 9s210ms [ User: intelifix - Total duration: 8m2s - Times executed: 47 ]
[ Application: [unknown] - Total duration: 8m2s - Times executed: 47 ]
-
CREATE TABLE temp0000281137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 14:08:29 Duration: 42s195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 16:57:08 Duration: 12s922ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281137 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-05-28 16:25:03 Duration: 11s424ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 154ms 27s23ms 6s866ms 101 11m33s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration May 28 00 6 45s231ms 7s538ms 01 6 20s486ms 3s414ms 02 6 17s990ms 2s998ms 03 5 18s17ms 3s603ms 04 6 28s905ms 4s817ms 05 5 17s3ms 3s400ms 07 6 1m5s 10s959ms 08 6 1m12s 12s156ms 09 6 1m5s 10s891ms 10 6 49s869ms 8s311ms 11 6 59s113ms 9s852ms 12 6 56s837ms 9s472ms 13 3 5s832ms 1s944ms 14 6 50s710ms 8s451ms 15 6 1m11s 11s875ms 16 5 33s648ms 6s729ms 21 5 5s152ms 1s30ms 22 6 9s433ms 1s572ms [ User: intelifix - Total duration: 11m33s - Times executed: 101 ]
[ Application: psql - Total duration: 11m33s - Times executed: 101 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 00:05:29 Duration: 27s23ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 15:15:19 Duration: 18s388ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-05-28 07:25:17 Duration: 16s198ms Database: rio User: intelifix Remote: [local] Application: psql
13 2s153ms 5m11s 6s816ms 138 15m40s call rs_giga_triagem (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration May 28 00 6 27s835ms 4s639ms 01 6 17s850ms 2s975ms 02 6 17s265ms 2s877ms 03 6 17s43ms 2s840ms 04 6 18s248ms 3s41ms 05 6 17s104ms 2s850ms 06 6 19s52ms 3s175ms 07 6 2m14s 22s420ms 08 6 17s978ms 2s996ms 09 6 21s143ms 3s523ms 10 6 20s378ms 3s396ms 11 6 5m29s 54s908ms 12 6 20s829ms 3s471ms 13 6 18s753ms 3s125ms 14 6 24s980ms 4s163ms 15 6 1m31s 15s176ms 16 6 27s129ms 4s521ms 17 6 15s984ms 2s664ms 18 6 15s515ms 2s585ms 19 6 15s944ms 2s657ms 20 6 22s584ms 3s764ms 21 6 15s474ms 2s579ms 22 6 14s503ms 2s417ms [ User: intelifix - Total duration: 15m40s - Times executed: 138 ]
[ Application: psql - Total duration: 15m40s - Times executed: 138 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 11:20:26 Duration: 5m11s Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 07:17:11 Duration: 2m Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-05-28 15:26:19 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: psql
14 700ms 15s128ms 5s476ms 45 4m6s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration May 28 08 3 17s270ms 5s756ms 09 3 30s528ms 10s176ms 10 3 24s539ms 8s179ms 11 3 22s648ms 7s549ms 12 3 12s135ms 4s45ms 13 3 11s43ms 3s681ms 14 3 35s511ms 11s837ms 15 3 24s779ms 8s259ms 16 3 23s564ms 7s854ms 17 3 25s167ms 8s389ms 18 3 6s128ms 2s42ms 19 3 2s932ms 977ms 20 3 3s321ms 1s107ms 21 3 2s713ms 904ms 22 3 4s156ms 1s385ms [ User: intelifix - Total duration: 4m6s - Times executed: 45 ]
[ Application: psql - Total duration: 4m6s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-28 09:00:16 Duration: 15s128ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-28 14:00:16 Duration: 14s552ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-05-28 14:40:15 Duration: 14s117ms Database: rio User: intelifix Remote: [local] Application: psql
15 265ms 40s607ms 4s513ms 62 4m39s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration May 28 07 4 3s592ms 898ms 08 4 38s37ms 9s509ms 09 7 8s387ms 1s198ms 10 7 1m9s 9s889ms 11 4 39s393ms 9s848ms 12 9 46s795ms 5s199ms 14 5 7s291ms 1s458ms 15 7 17s905ms 2s557ms 16 11 41s439ms 3s767ms 17 4 7s789ms 1s947ms [ User: intelifix - Total duration: 4m39s - Times executed: 62 ]
[ Application: psql - Total duration: 4m39s - Times executed: 62 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 309); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024853);
Date: 2026-05-28 10:21:16 Duration: 40s607ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024868);
Date: 2026-05-28 12:25:20 Duration: 40s389ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (024858);
Date: 2026-05-28 11:10:05 Duration: 37s288ms Database: rio User: intelifix Remote: [local] Application: psql
16 3s119ms 22s617ms 4s377ms 66 4m48s create table temp0000281029 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration May 28 07 21 1m15s 3s603ms 09 8 32s665ms 4s83ms 11 5 41s447ms 8s289ms 12 8 33s365ms 4s170ms 14 6 26s572ms 4s428ms 15 10 44s269ms 4s426ms 16 8 34s903ms 4s362ms [ User: intelifix - Total duration: 4m48s - Times executed: 66 ]
[ Application: [unknown] - Total duration: 4m48s - Times executed: 66 ]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 11:23:27 Duration: 22s617ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 12:17:21 Duration: 5s967ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281029 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"23-05-2026", "ate" :"28-05-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-05-28 14:56:39 Duration: 5s892ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 192ms 27s350ms 4s171ms 44 3m3s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration May 28 07 2 29s252ms 14s626ms 08 3 11s678ms 3s892ms 09 8 7s423ms 927ms 10 5 17s133ms 3s426ms 11 3 32s53ms 10s684ms 12 5 18s485ms 3s697ms 14 3 19s10ms 6s336ms 15 4 23s801ms 5s950ms 16 9 23s30ms 2s558ms 17 2 1s689ms 844ms [ User: intelifix - Total duration: 3m3s - Times executed: 44 ]
[ Application: psql - Total duration: 3m3s - Times executed: 44 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (024837);
Date: 2026-05-28 07:10:46 Duration: 27s350ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (024860);
Date: 2026-05-28 11:13:21 Duration: 18s769ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 320); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (024872);
Date: 2026-05-28 14:26:01 Duration: 12s435ms Database: rio User: intelifix Remote: [local] Application: psql
18 150ms 6s853ms 1s113ms 1,567 29m5s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration May 28 07 14 8s345ms 596ms 08 80 1m34s 1s179ms 09 155 3m11s 1s233ms 10 160 3m31s 1s324ms 11 215 3m53s 1s86ms 12 97 1m36s 994ms 13 116 2m35s 1s344ms 14 297 4m52s 985ms 15 199 3m31s 1s61ms 16 173 3m11s 1s107ms 17 61 57s998ms 950ms [ User: intelifix - Total duration: 29m5s - Times executed: 1567 ]
[ Application: [unknown] - Total duration: 29m5s - Times executed: 1567 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246113, 504, '256297114030211,216721173254,216842851515,216535166671,216902434445,216855279797,216892378087,216603416890,216850237577,216902477580,216889556768,216364946164,216537362644,216793219802,216535916273,216828010920,216767121532,216770175050,216535897180,216848696776,216670196168,216673623035,216527106670,216664231726,216538319011,216449580003,216847280915,216361510914,216444597080,216534828300,216522940305,216566598202,184337382949,216821619712,216793362847,216673655159,216828836162,216851122345,216523982741', '',064,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 16:21:48 Duration: 6s853ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246115, 504, '467075024951,216774830006,216715271219,216388405255,216468876363,216782562242,216774555051,216458662943,216462305464,216324182344,216651405064,216420419805,216379099106,216374614549,216578606769,216584282846,216322827676,216578639601,216760757374,216326821019,216374538706,216594470709,216651563340,216765201928,216598399497,216463235465,216715544859,216678612546,216426523353,216779653136,216782123052,216785973753,216494137392,216589639293,216419449800,216481966182,216432043151,216760875568,216589701119,216584033551', '',034,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 15:06:33 Duration: 6s645ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (246114, 504, '71420685850003120109,184271031928,216750671520,216550219409,216640019395,216546425559,216905959098,216336913743,216628646782,216355132031H011600722,216629516373,184270444564,216865909398,216910700000,216812902745,216607539717,216909813437,216907307580,216874170206,216790882425,216547105558,216348582020,216688693350,216347747280,216868790927,216543670409,216414108606,184327941635,216724480109,216557414163,184266502339,216879254349,216816024957,216752716062,216836661820,216356997386,216872143240,216867292430,216866960827,216739263549', '',062,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-05-28 14:21:15 Duration: 6s568ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 150ms 23s729ms 1s5ms 192 3m13s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration May 28 07 13 7s986ms 614ms 08 29 12s918ms 445ms 09 22 6s850ms 311ms 10 9 3s850ms 427ms 11 5 3s718ms 743ms 13 22 12s199ms 554ms 14 34 1m53s 3s326ms 15 23 15s614ms 678ms 16 33 16s349ms 495ms 17 2 419ms 209ms [ User: intelifix - Total duration: 3m13s - Times executed: 192 ]
[ Application: [unknown] - Total duration: 3m13s - Times executed: 192 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037595) LIMIT 1;
Date: 2026-05-28 14:16:03 Duration: 23s729ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037951) LIMIT 1;
Date: 2026-05-28 14:14:32 Duration: 15s202ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (037949) LIMIT 1;
Date: 2026-05-28 14:15:03 Duration: 14s761ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 340ms 865ms 598ms 75 44s922ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration May 28 00 2 1s338ms 669ms 04 3 1s810ms 603ms 05 1 676ms 676ms 07 3 2s8ms 669ms 08 5 3s82ms 616ms 09 6 4s131ms 688ms 10 7 4s3ms 571ms 11 8 5s330ms 666ms 12 2 1s307ms 653ms 13 8 4s530ms 566ms 14 8 5s32ms 629ms 15 9 5s197ms 577ms 16 7 3s288ms 469ms 17 5 2s696ms 539ms 19 1 488ms 488ms [ User: intelifix - Total duration: 44s922ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 44s922ms - Times executed: 75 ]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-05-28 15:16:41 Duration: 865ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (415, 81, 1);
Date: 2026-05-28 11:56:19 Duration: 862ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (418, 81, 1);
Date: 2026-05-28 14:10:15 Duration: 821ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 2 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration May 28 13 1 0ms 0ms 15 1 0ms 0ms [ User: intelifix - Total duration: 4s290ms - Times executed: 1 ]
[ User: etiquetas - Total duration: 201ms - Times executed: 1 ]
[ Application: psql - Total duration: 4s290ms - Times executed: 1 ]
[ Application: [unknown] - Total duration: 201ms - Times executed: 1 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: etiquetas Application: [local] Queryid: [unknown]
-
Events
Log levels
Key values
- 18,684 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 426 FATAL entries
- 3345 ERROR entries
- 0 WARNING entries
- 20 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,326 Max number of times the same event was reported
- 3,791 Total events found
Rank Times reported Error 1 3,326 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count May 28 00 60 01 53 02 56 03 58 04 58 05 60 06 59 07 97 08 291 09 365 10 254 11 259 12 62 13 223 14 337 15 315 16 258 17 114 18 59 19 60 20 59 21 60 22 59 23 50 - ERROR: prepared statement "_PLAN00000000299A0CB0" does not exist
- ERROR: prepared statement "_PLAN00000000299A2CA0" does not exist
- ERROR: prepared statement "_PLAN0000000029C6C200" does not exist
Statement: DEALLOCATE "_PLAN00000000299A0CB0"
Date: 2026-05-28 00:00:22 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN00000000299A2CA0"
Date: 2026-05-28 00:01:22 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029C6C200"
Date: 2026-05-28 00:02:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 419 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count May 28 00 17 01 14 02 14 03 14 04 14 05 21 06 16 07 16 08 19 09 20 10 19 11 19 12 19 13 19 14 19 15 19 16 19 17 19 18 20 19 20 20 20 21 20 22 19 23 3 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-05-28 00:02:10 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-28 00:02:11 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-05-28 00:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 8 ERROR: process ... detected deadlock while waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #3
Day Hour Count May 28 11 8 - ERROR: process 4129400 detected deadlock while waiting for ShareLock on transaction 201559 after 1000.215 ms
- ERROR: process 4129400 detected deadlock while waiting for ShareLock on transaction 201559 after 1000.141 ms
- ERROR: process 4129400 detected deadlock while waiting for ShareLock on transaction 201559 after 1000.192 ms
Detail: Process holding the lock: 4145397. Wait queue: .
Context: while updating tuple (18714,12) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 024860, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-05-28 11:16:45 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 4145397. Wait queue: .
Context: while updating tuple (18714,12) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 024860, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-05-28 11:16:47 Database: rio Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 4145397. Wait queue: .
Context: while updating tuple (18714,12) in relation "nf_entrada_modelos" SQL statement "UPDATE NF_ENTRADA_MODELOS SET QTD_RECEBIDA = QTD_RECEBIDA + 1 WHERE NEM_ID = nNEM" PL/pgSQL function rs_nf_associa_equipamento(integer) line 135 at SQL statement PL/pgSQL assignment "cRetAux := RS_NF_ASSOCIA_EQUIPAMENTO( nLI )" PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1012 at assignment PL/pgSQL function rs_nf_carga_lotes(integer,integer) line 196 at assignment PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM RS_NF_CARGA_LOTES( 024860, 0320 )' , '/var/www/html/tmp/nf_carga_lotes_0320.xlsx' )Date: 2026-05-28 11:16:49 Database: rio Application: [unknown] User: intelifix Remote: [local]
4 7 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count May 28 10 2 14 2 16 3 - ERROR: trailing junk after numeric literal at or near "70037EA822B5" at character 27
- ERROR: trailing junk after numeric literal at or near "70037EA822B5" at character 27
- ERROR: trailing junk after numeric literal at or near "64FD966D08F5" at character 27
Statement: SELECT * FROM RS_ETIQUETA(70037EA822B5)
Date: 2026-05-28 10:52:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(70037EA822B5)
Date: 2026-05-28 10:52:25 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(64FD966D08F5)
Date: 2026-05-28 14:20:11 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 7 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count May 28 07 1 11 2 13 1 15 3 - LOG: process 4001934 still waiting for ShareLock on transaction 182683 after 1000.230 ms
- LOG: process 4145397 still waiting for ShareLock on transaction 201177 after 1000.113 ms
- LOG: process 4145397 still waiting for ShareLock on transaction 201177 after 47590.419 ms
Detail: Process holding the lock: 4001775. Wait queue: 4001934.
Context: while updating tuple (68438,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-05-28 07:15:14 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 4129400. Wait queue: 4145397.
Context: while updating tuple (68467,23) 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-05-28 11:15:28 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 4129400. Wait queue: 4145397.
Context: while updating tuple (68467,23) 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-05-28 11:16:15 Database: rio Application: psql User: intelifix Remote: [local]
6 5 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count May 28 03 5 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-05-28 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-05-28 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-28 03:05:01 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #7
Day Hour Count May 28 13 2 16 2 - ERROR: syntax error at or near "diagnostics" at character 42
- ERROR: syntax error at or near "diagnostics" at character 42
- ERROR: syntax error at or near "]" at character 33
Statement: select * from rs_caixa_qr(SeagullMessage diagnostics:)
Date: 2026-05-28 13:24:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(SeagullMessage diagnostics:)
Date: 2026-05-28 13:24:59 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(103377])
Date: 2026-05-28 16:38:59 Database: contagem Application: [unknown] User: etiquetas Remote: [local]
8 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count May 28 05 2 - ERROR: could not connect to server "Brasilia"
- ERROR: could not connect to server "Brasilia"
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;Date: 2026-05-28 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
Detail: connection to server at "localhost" (127.0.0.1), port 9276 failed: FATAL: database "brasilia" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;Date: 2026-05-28 05:30:01 Database: rio Application: psql User: intelifix Remote: [local]
9 2 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count May 28 05 2 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-05-28 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-05-28 05:30:17 Database: contagem Application: psql User: intelifix Remote: [local]
10 2 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #10
Day Hour Count May 28 10 2 - LOG: could not receive data from client: Connection reset by peer
- LOG: could not receive data from client: Connection reset by peer
Date: 2026-05-28 10:43:51 Database: postgres Application: pgAdmin 4 - DB:postgres User: lenon Remote: 172.20.0.3
Date: 2026-05-28 10:43:51 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3
11 2 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #11
Day Hour Count May 28 03 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-05-28 03:05:02 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-05-28 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
12 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #12
Day Hour Count May 28 11 1 - LOG: process 4183515 still waiting for AccessExclusiveLock on relation 491865 of database 358220 after 1001.028 ms
Detail: Process holding the lock: 39637. Wait queue: 4183515.
Statement: DROP TABLE IF EXISTS temp0000281029;Date: 2026-05-28 11:53:56 Database: rio Application: [unknown] User: intelifix Remote: [local]
13 1 LOG: could not receive data from client: Connection timed out
Times Reported Most Frequent Error / Event #13
Day Hour Count May 28 12 1 - LOG: could not receive data from client: Connection timed out
Date: 2026-05-28 12:08:42 Database: rio Application: pgAdmin 4 - DB:rio User: lenon Remote: 172.20.0.3
14 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #14
Day Hour Count May 28 11 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000281029"
Date: 2026-05-28 11:53:56
15 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #15
Day Hour Count May 28 11 1 - ERROR: column "cai_id" does not exist at character 39
Hint: Perhaps you meant to reference the column "temp0000226294.cli_id".
Statement: SELECT * FROM temp0000226294 ORDER BY CAI_ID DESCDate: 2026-05-28 11:20:50 Database: contagem Application: [unknown] User: intelifix Remote: [local]
16 1 ERROR: unterminated quoted string at or near "..."
Times Reported Most Frequent Error / Event #16
Day Hour Count May 28 09 1 - ERROR: unterminated quoted string at or near "''', 00, 06 );" at character 34
Statement: SELECT * FROM RS_BARRA_DETALHES( ''', 00, 06 );
Date: 2026-05-28 09:49:44 Database: rio Application: [unknown] User: intelifix Remote: [local]
17 1 ERROR: prepared statement "..." does not existNOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #17
Day Hour Count May 28 14 1 - ERROR: prepared statement "_PLAN0000000033403DD0" does not existNOTICE: table "tmp_entrada" does not exist, skipping
Statement: DEALLOCATE "_PLAN0000000033403DD0"
Date: 2026-05-28 14:43:28 Database: rio Application: [unknown] User: etiquetas Remote: [local]
18 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #18
Day Hour Count May 28 03 1 - LOG: database system was shut down at 2026-05-28 03:05:02 -03
Date: 2026-05-28 03:05:03