pgBadger-
Global information
- Generated on Tue Jun 2 23:50:06 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 35,093 log entries in 5s
- Log start from 2026-06-02 00:02:01 to 2026-06-02 23:45:58
-
Overview
Global Stats
- 303 Number of unique normalized queries
- 5,613 Number of queries
- 6h13m43s Total query duration
- 2026-06-02 00:02:03 First query
- 2026-06-02 23:42:08 Last query
- 5 queries/s at 2026-06-02 10:40:06 Query peak
- 6h13m43s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6h13m43s Execute total duration
- 2,209 Number of events
- 16 Number of unique normalized events
- 1,766 Max number of times the same event was reported
- 0 Number of cancellation
- 482 Total number of automatic vacuums
- 1,045 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 209 Total number of sessions
- 6 sessions at 2026-06-02 06:35:01 Session peak
- 7d21h12m47s Total duration of sessions
- 54m19s Average duration of sessions
- 26 Average queries per session
- 1m47s Average queries duration per session
- 52m31s Average idle time per session
- 629 Total number of connections
- 6 connections/s at 2026-06-02 00:05:01 Connection peak
- 2 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-02 10:40:06 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-06-02 10:40:06 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-06-02 23:41:33 Date
Queries duration
Key values
- 6h13m43s 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) Jun 02 00 23 0ms 16s736ms 3s409ms 4s520ms 55s300ms 55s300ms 01 15 0ms 3s430ms 1s791ms 4s779ms 4s944ms 4s944ms 02 11 0ms 3s204ms 2s115ms 4s493ms 4s493ms 4s493ms 03 14 0ms 4s63ms 1s749ms 7s448ms 7s448ms 7s448ms 04 36 0ms 3s276ms 802ms 4s496ms 4s504ms 4s681ms 05 22 0ms 7m36s 27s745ms 2m3s 7m36s 7m36s 06 11 0ms 8s508ms 3s348ms 19s808ms 19s808ms 19s808ms 07 160 0ms 7m18s 9s775ms 39s925ms 3m45s 7m18s 08 482 150ms 5m37s 3s420ms 53s977ms 3m35s 5m50s 09 553 150ms 5m54s 3s276ms 40s980ms 3m38s 8m17s 10 504 150ms 6m33s 3s6ms 54s133ms 3m28s 6m38s 11 507 151ms 7m14s 3s735ms 1m9s 3m32s 7m26s 12 181 0ms 5m54s 8s261ms 33s137ms 3m41s 5m56s 13 355 0ms 5m34s 1s958ms 16s868ms 35s83ms 5m34s 14 659 150ms 6m46s 3s218ms 1m12s 4m2s 6m50s 15 813 150ms 5m49s 2s172ms 57s81ms 2m20s 9m26s 16 640 150ms 6m35s 2s651ms 38s979ms 3m44s 6m40s 17 258 0ms 6m59s 4s53ms 30s609ms 42s196ms 7m45s 18 14 0ms 5m15s 26s210ms 3s246ms 5m42s 5m42s 19 13 484ms 5m21s 28s618ms 3s229ms 5m49s 5m49s 20 72 0ms 6m45s 12s824ms 1m47s 6m45s 6m45s 21 25 0ms 5m28s 15s522ms 5s298ms 5m54s 5m54s 22 19 0ms 5m9s 19s542ms 5s632ms 5m38s 5m38s 23 226 0ms 1m54s 8s493ms 1m27s 1m34s 2m5s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 02 00 7 0 484ms 161ms 1s535ms 1s538ms 01 3 0 393ms 0ms 165ms 1s13ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 491ms 0ms 982ms 982ms 04 24 0 224ms 351ms 521ms 873ms 05 10 0 244ms 185ms 198ms 1s42ms 06 3 0 736ms 1s61ms 1s149ms 1s149ms 07 89 0 13s533ms 2s299ms 7s749ms 4m 08 352 0 3s452ms 5s749ms 18s946ms 3m38s 09 456 0 3s155ms 7s517ms 15s12ms 3m41s 10 404 0 2s871ms 7s683ms 16s436ms 3m43s 11 402 0 3s901ms 10s11ms 57s150ms 3m41s 12 118 0 9s856ms 3s343ms 12s202ms 4m42s 13 270 0 2s92ms 4s205ms 8s66ms 39s240ms 14 526 0 3s193ms 11s279ms 42s306ms 3m57s 15 683 0 2s70ms 11s722ms 24s694ms 3m55s 16 533 0 2s528ms 8s597ms 24s753ms 4m24s 17 206 0 3s918ms 7s248ms 10s110ms 3m3s 18 5 0 1m9s 0ms 1s828ms 5m42s 19 4 0 1m27s 0ms 1s471ms 5m49s 20 6 56 14s406ms 55s12ms 1m38s 6m45s 21 11 0 32s633ms 822ms 1s548ms 5m54s 22 4 0 1m24s 0ms 0ms 5m38s 23 6 220 8s493ms 1m11s 1m27s 2m5s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 02 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 Jun 02 00 0 1 1.00 0.00% 01 0 1 1.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 2 2.00 0.00% 05 0 1 1.00 0.00% 06 0 1 1.00 0.00% 07 0 4 4.00 0.00% 08 0 7 7.00 0.00% 09 0 9 9.00 0.00% 10 0 7 7.00 0.00% 11 0 7 7.00 0.00% 12 0 3 3.00 0.00% 13 0 8 8.00 0.00% 14 0 9 9.00 0.00% 15 0 10 10.00 0.00% 16 0 7 7.00 0.00% 17 0 2 2.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 2 2.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jun 02 00 27 0.01/s 01 19 0.01/s 02 17 0.00/s 03 21 0.01/s 04 17 0.00/s 05 24 0.01/s 06 23 0.01/s 07 26 0.01/s 08 35 0.01/s 09 37 0.01/s 10 32 0.01/s 11 33 0.01/s 12 24 0.01/s 13 34 0.01/s 14 36 0.01/s 15 41 0.01/s 16 33 0.01/s 17 27 0.01/s 18 22 0.01/s 19 24 0.01/s 20 25 0.01/s 21 26 0.01/s 22 22 0.01/s 23 4 0.00/s Day Hour Count Average Duration Average idle time Jun 02 00 1 10m 8m41s 01 7 1h1m17s 1h1m13s 02 5 1h36s 1h31s 03 6 25m44s 25m40s 04 5 1h1m12s 1h1m6s 05 3 1h1s 56m37s 06 5 1h37s 1h30s 07 7 1h52s 57m8s 08 11 48m16s 45m47s 09 15 57m20s 55m20s 10 16 57m17s 55m42s 11 12 57m31s 54m53s 12 15 56m17s 54m37s 13 5 52m15s 49m56s 14 16 57m29s 55m17s 15 17 50m42s 48m58s 16 19 53m27s 51m57s 17 13 58m54s 57m33s 18 8 1h36s 59m50s 19 3 43m20s 41m16s 20 6 41m47s 39m13s 21 4 47m30s 45m53s 22 5 1h36s 59m21s 23 5 43m1s 36m37s -
Connections
Established Connections
Key values
- 6 connections Connection Peak
- 2026-06-02 00:05:01 Date
Connections per database
Key values
- brasilia Main Database
- 629 connections Total
Connections per user
Key values
- intelifix Main User
- 629 connections Total
-
Sessions
Simultaneous sessions
Key values
- 6 sessions Session Peak
- 2026-06-02 06:35:01 Date
Histogram of session times
Key values
- 170 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 209 sessions Total
Sessions per user
Key values
- intelifix Main User
- 209 sessions Total
Sessions per host
Key values
- [local] Main Host
- 209 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 26,464 buffers Checkpoint Peak
- 2026-06-02 16:34:37 Date
- 270.069 seconds Highest write time
- 0.041 seconds Sync time
Checkpoints Wal files
Key values
- 13 files Wal files usage Peak
- 2026-06-02 11:09:35 Date
Checkpoints distance
Key values
- 420.19 Mo Distance Peak
- 2026-06-02 11:09:35 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jun 02 00 13,566 693.758s 0.021s 693.811s 01 3,453 345.961s 0.02s 346.014s 02 1,592 159.759s 0.013s 159.791s 03 1,629 163.36s 0.027s 163.419s 04 3,368 337.536s 0.02s 337.59s 05 8,309 797.024s 0.032s 797.087s 06 2,508 251.334s 0.001s 251.34s 07 40,497 2,375.893s 0.071s 2,376.043s 08 75,988 3,117.345s 0.185s 3,117.679s 09 86,250 3,214.323s 0.204s 3,214.701s 10 76,027 3,239.448s 0.209s 3,239.783s 11 77,989 3,190.36s 0.184s 3,190.698s 12 70,361 2,790.282s 0.112s 2,790.48s 13 26,654 2,331.07s 0.125s 2,331.304s 14 88,743 3,239.37s 0.223s 3,239.772s 15 69,696 3,188.162s 0.261s 3,188.579s 16 82,220 3,107.203s 0.22s 3,107.587s 17 32,055 2,192.623s 0.087s 2,192.8s 18 1,248 125.19s 0.008s 125.214s 19 28 2.829s 0.003s 2.836s 20 1,323 331.701s 0.006s 331.718s 21 2,424 242.944s 0.02s 243.004s 22 2,500 250.471s 0.017s 250.517s 23 2,234 349.714s 0.011s 349.742s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jun 02 00 0 0 5 521 0.003s 0.007s 01 0 0 1 502 0.003s 0.008s 02 0 0 1 337 0.003s 0.005s 03 0 0 0 400 0.003s 0.007s 04 0 0 1 600 0.003s 0.008s 05 0 0 4 758 0.011s 0.008s 06 0 0 1 7 0.001s 0.001s 07 0 0 24 2,111 0.008s 0.012s 08 0 0 44 5,054 0.004s 0.012s 09 0 0 45 6,187 0.012s 0.012s 10 0 0 35 5,798 0.007s 0.012s 11 0 0 44 5,576 0.003s 0.012s 12 0 0 40 2,651 0.006s 0.012s 13 0 0 12 3,884 0.003s 0.012s 14 0 0 51 5,003 0.004s 0.012s 15 0 0 34 5,566 0.003s 0.012s 16 0 0 48 5,385 0.004s 0.012s 17 0 0 26 2,847 0.005s 0.009s 18 0 0 0 104 0.002s 0.004s 19 0 0 0 9 0.002s 0.001s 20 0 0 1 62 0.002s 0.003s 21 0 0 1 403 0.003s 0.008s 22 0 0 1 455 0.004s 0.007s 23 0 0 0 35 0.003s 0.005s Day Hour Count Avg time (sec) Jun 02 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 Jun 02 00 12,244.86 kB 38,334.00 kB 01 1,737.38 kB 18,646.00 kB 02 1,608.80 kB 10,020.40 kB 03 1,104.88 kB 2,970.12 kB 04 2,111.62 kB 2,501.75 kB 05 7,563.00 kB 17,486.50 kB 06 7,862.00 kB 14,055.00 kB 07 32,739.25 kB 60,811.58 kB 08 60,577.08 kB 110,551.67 kB 09 61,486.25 kB 106,504.75 kB 10 48,339.58 kB 96,579.08 kB 11 59,980.75 kB 148,739.42 kB 12 54,398.92 kB 120,665.08 kB 13 16,222.17 kB 48,887.33 kB 14 70,250.25 kB 94,451.58 kB 15 45,472.08 kB 124,431.92 kB 16 65,834.17 kB 130,746.33 kB 17 46,910.22 kB 97,126.00 kB 18 1,055.75 kB 73,302.00 kB 19 182.00 kB 56,013.00 kB 20 6,443.67 kB 47,211.33 kB 21 1,362.62 kB 27,577.50 kB 22 1,904.86 kB 13,417.71 kB 23 1,556.25 kB 8,259.75 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 Jun 02 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
- 3.46 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-02 16:28:02 Date
- 0 sec Highest CPU-cost analyze
Table
Database rio - Date
Average Autovacuum Duration
Key values
- 3.46 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_06
Database rio - 2026-06-02 16:28:02 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (144) Main table analyzed (database rio)
- 1,045 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 144 rio.pg_catalog.pg_class 79 rio.pg_catalog.pg_type 63 rio.public.usuarios 52 rio.public.temp0000281513 46 rio.pg_catalog.pg_index 46 rio.pg_catalog.pg_depend 34 contagem.pg_catalog.pg_attribute 33 contagem.public.temp0000226326 32 rio.public.temp0000281453 32 rio.public.temp0000281469 30 rio.public.temp0000281543 29 rio.public.temp0000281459 25 rio.public.temp0000281461 24 contagem.public.usuarios 23 contagem.pg_catalog.pg_class 20 rio.public.temp0000281327 19 contagem.public.temp0000226296 19 rio.public.temp0000281463 16 contagem.pg_catalog.pg_type 16 rio.public.temp0000281533 15 rio.public.temp0000281549 13 rio.public.temp0000281479 12 rio.public.temp0000281483 12 rio.public.temp0000281523 11 rio.public.temp0000281515 11 rio.public.temp0000281471 11 contagem.public.temp0000226294 10 rio.public.temp0000281343 10 rio.public.temp0000281335 10 rio.public.temp0000281525 9 contagem.pg_catalog.pg_index 9 rio.public.temp0000281093 9 rio.public.temp0000281495 8 rio.auditor.auditor_2026_06 8 contagem.pg_catalog.pg_depend 7 contagem.pg_catalog.pg_shdepend 7 rio.public.temp0000281555 7 contagem.auditor.auditor_2026_06 6 rio.public.temp0000281413 6 rio.public.temp0000281509 6 rio.public.temp0000281567 5 rio.public.temp0000281539 5 rio.public.temp0000281467 4 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000281339 4 template1.pg_catalog.pg_shdepend 4 rio.public.temp0000281475 3 rio.public.temp0000281481 3 contagem.public.temp0000226322 3 postgres.pg_catalog.pg_shdepend 3 rio.public.temp0000281505 3 rio.public.temp0000281455 3 rio.public.temp0000281487 2 rio.public.temp0000281547 2 rio.public.temp0000281477 2 rio.public.temp0000281493 2 rio.public.temp0000281541 2 contagem.public.temp0000226320 2 rio.public.temp0000281537 1 rio.public.tmp_drill_0302 1 rio.public.temp0000281473 1 rio.public.temp0000281535 1 rio.public.temp0000281491 1 rio.public.temp0000281489 1 rio.public.temp0000281545 1 rio.public.temp0000281499 1 rio.public.temp0000281551 1 rio.public.temp0000281531 1 Total 1,045 Vacuums per table
Key values
- pg_catalog.pg_attribute (58) Main table vacuumed on database rio
- 482 vacuums Total
Index Buffer usage Skipped WAL usage Frozen Table Vacuums scans hits misses dirtied pins frozen records full page bytes pages tuples rio.pg_catalog.pg_attribute 58 52 0 0 0 0 0 29,748 6,646 10,155,224 473 11,407 rio.public.temp0000281513 47 0 0 0 0 0 0 41,596 219 2,488,294 0 0 rio.pg_catalog.pg_class 43 34 0 0 0 0 0 6,661 2,082 2,994,796 118 422 rio.pg_catalog.pg_type 34 29 0 0 0 0 0 2,781 782 992,820 102 328 rio.public.temp0000281469 30 0 0 0 0 0 0 18,142 142 1,092,467 0 0 rio.public.temp0000281543 29 0 0 0 0 0 0 30,959 107 1,843,483 0 0 contagem.public.usuarios 23 0 0 0 0 0 0 116 86 48,951 1 1 rio.pg_catalog.pg_index 20 19 0 0 0 0 0 1,267 312 274,657 58 98 rio.public.temp0000281327 19 0 0 0 0 0 0 1,193 104 86,304 0 0 rio.pg_catalog.pg_depend 14 14 0 0 0 0 0 4,285 1,490 2,131,087 71 692 rio.public.temp0000281483 12 0 0 0 0 0 0 13,904 45 827,377 0 0 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,457 2,272 3,731,066 26 685 rio.public.temp0000281523 11 0 0 0 0 0 0 1,204 59 80,981 0 0 rio.public.temp0000281335 10 0 0 0 0 0 0 1,246 51 82,207 0 0 rio.public.temp0000281093 9 0 0 0 0 0 0 788 53 54,695 0 0 rio.public.temp0000281525 9 0 0 0 0 0 0 7,739 32 461,768 0 0 rio.pg_catalog.pg_statistic 8 8 0 0 0 0 0 9,674 2,102 9,431,504 987 5,032 rio.public.temp0000281343 7 0 0 0 0 0 0 401 40 29,665 0 0 contagem.pg_catalog.pg_class 6 6 0 0 0 0 0 890 358 504,949 13 45 rio.pg_toast.pg_toast_2619 6 6 0 0 0 0 0 2,152 467 2,321,901 104 398 rio.public.temp0000281509 6 0 0 0 0 0 0 6,186 22 368,462 0 0 rio.auditor.auditor_2026_06 6 0 0 0 0 0 0 143,609 61,762 82,787,356 40,441 819,257 rio.public.temp0000281479 6 0 0 0 0 0 0 4,849 29 290,669 0 0 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 328 137 198,923 6 12 contagem.pg_catalog.pg_shdepend 4 4 0 0 0 0 0 814 271 416,131 43 76 rio.public.temp0000281505 3 0 0 0 0 0 0 1,554 10 93,365 0 0 rio.public.temp0000281339 3 0 0 0 0 0 0 186 17 13,268 0 0 contagem.auditor.auditor_2026_06 3 0 0 0 0 0 0 7,711 4,710 5,557,664 1,093 18,806 contagem.pg_catalog.pg_depend 3 3 0 0 0 0 0 808 309 606,342 7 48 contagem.pg_catalog.pg_statistic 3 3 0 0 0 0 0 3,381 1,273 3,844,194 1,084 7,461 rio.public.temp0000281481 3 0 0 0 0 0 0 3,174 14 189,389 0 0 rio.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 444 140 226,026 23 38 rio.public.usuarios 2 2 0 0 0 0 0 69 26 44,700 4 11 rio.public.temp0000281533 2 0 0 0 0 0 0 337 12 21,943 0 0 rio.public.logs 2 0 0 0 0 0 0 620 339 425,768 123 2,764 rio.public.temp0000281487 2 0 0 0 0 0 0 96 11 7,417 0 0 rio.public.temp0000281495 2 0 0 0 0 0 0 120 12 8,783 0 0 contagem.pg_catalog.pg_index 2 2 0 0 0 0 0 127 47 30,003 5 5 rio.public.temp0000281477 2 0 0 0 0 0 0 172 12 11,982 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 109 52 168,579 14 21 rio.public.temp0000281555 1 0 0 0 0 0 0 1,547 4 91,876 0 0 rio.public.temp0000281491 1 0 0 0 0 0 0 8 5 1,308 0 0 rio.public.temp0000281535 1 0 0 0 0 0 0 68 6 4,880 0 0 rio.public.temp0000281531 1 0 0 0 0 0 0 99 6 6,778 0 0 rio.public.temp0000281551 1 0 0 0 0 0 0 8 5 1,414 0 0 rio.public.caixa_itens_exclusao 1 0 0 0 0 0 0 37 19 61,490 9 984 rio.public.temp0000281541 1 0 0 0 0 0 0 99 6 6,778 0 0 rio.public.temp0000281489 1 0 0 0 0 0 0 8 5 1,308 0 0 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 274 129 380,605 41 2,044 rio.public.temp0000281545 1 0 0 0 0 0 0 99 6 6,779 0 0 rio.public.temp0000281539 1 0 0 0 0 0 0 99 6 6,778 0 0 rio.public.equipamentos_referencia 1 0 0 0 0 0 0 69 32 105,674 16 2,960 rio.public.temp0000281537 1 0 0 0 0 0 0 99 6 6,778 0 0 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 109 3 22,735 0 0 rio.public.temp0000281515 1 0 0 0 0 0 0 113 6 7,613 0 0 Total 482 201 0 0 0 0 0 358,633 86,898 135,657,954 44,862 873,595 Vacuum throughput per table
Key values
- auditor.auditor_2026_06 (18.1) Max CPU elapsed for vacuum on database rio
- unknown (0 ms) Max I/O read time for vacuum on database rio
- unknown (0 ms) Max I/O write time for vacuum on database rio
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.06 rio.public.temp0000281513 0 0 1.44 rio.pg_catalog.pg_class 0 0 0.84 rio.pg_catalog.pg_type 0 0 0.31 rio.public.temp0000281469 0 0 0.8 rio.public.temp0000281543 0 0 1.42 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_index 0 0 0.14 rio.public.temp0000281327 0 0 0.17 rio.pg_catalog.pg_depend 0 0 0.69 rio.public.temp0000281483 0 0 0.49 contagem.pg_catalog.pg_attribute 0 0 0.85 rio.public.temp0000281523 0 0 0.12 rio.public.temp0000281335 0 0 0.12 rio.public.temp0000281093 0 0 0.08 rio.public.temp0000281525 0 0 0.38 rio.pg_catalog.pg_statistic 0 0 1.02 rio.public.temp0000281343 0 0 0.06 contagem.pg_catalog.pg_class 0 0 0.22 rio.pg_toast.pg_toast_2619 0 0 0.25 rio.public.temp0000281509 0 0 0.26 rio.auditor.auditor_2026_06 0 0 18.1 rio.public.temp0000281479 0 0 0.17 contagem.pg_catalog.pg_type 0 0 0.05 contagem.pg_catalog.pg_shdepend 0 0 0.1 rio.public.temp0000281505 0 0 0.14 rio.public.temp0000281339 0 0 0.03 contagem.auditor.auditor_2026_06 0 0 1.24 contagem.pg_catalog.pg_depend 0 0 0.16 contagem.pg_catalog.pg_statistic 0 0 0.22 rio.public.temp0000281481 0 0 0.1 rio.pg_catalog.pg_shdepend 0 0 0.09 rio.public.usuarios 0 0 0 rio.public.temp0000281533 0 0 0.03 rio.public.logs 0 0 0.32 rio.public.temp0000281487 0 0 0.02 rio.public.temp0000281495 0 0 0.02 contagem.pg_catalog.pg_index 0 0 0.07 rio.public.temp0000281477 0 0 0.01 contagem.pg_toast.pg_toast_2619 0 0 0 rio.public.temp0000281555 0 0 0.04 rio.public.temp0000281491 0 0 0 rio.public.temp0000281535 0 0 0.01 rio.public.temp0000281531 0 0 0.01 rio.public.temp0000281551 0 0 0.01 rio.public.caixa_itens_exclusao 0 0 0.02 rio.public.temp0000281541 0 0 0.01 rio.public.temp0000281489 0 0 0 rio.public.nf_entrada_arquivo_erros 0 0 0.13 rio.public.temp0000281545 0 0 0.01 rio.public.temp0000281539 0 0 0 rio.public.equipamentos_referencia 0 0 0.01 rio.public.temp0000281537 0 0 0.01 rio.public.tmp_drill_0302 0 0 0 rio.public.temp0000281515 0 0 0.01 Total 0 0 33.86 Tuples removed per table
Key values
- pg_catalog.pg_attribute (235869) Main table with removed tuples on database rio
- 337431 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 58 52 235,869 1,455,608 71,801 430 35,313 contagem.pg_catalog.pg_attribute 11 11 31,145 266,531 64 0 5,793 rio.pg_catalog.pg_statistic 8 8 14,136 65,066 268 0 10,288 rio.pg_catalog.pg_type 34 29 10,220 82,854 5,200 38 2,442 rio.pg_catalog.pg_depend 14 14 7,557 274,556 4,839 26 2,474 rio.auditor.auditor_2026_06 6 0 6,858 9,524,628 0 0 460,705 rio.pg_catalog.pg_index 20 19 5,913 39,530 1,018 0 1,182 contagem.pg_catalog.pg_statistic 3 3 5,375 22,867 0 0 3,033 rio.pg_catalog.pg_class 43 34 4,657 169,780 17,805 131 5,149 contagem.pg_catalog.pg_shdepend 4 4 4,405 37,593 501 0 404 contagem.pg_catalog.pg_depend 3 3 3,040 56,976 0 0 519 rio.pg_catalog.pg_shdepend 2 2 2,609 18,703 163 0 202 contagem.public.usuarios 23 0 1,455 483 0 0 46 rio.pg_toast.pg_toast_2619 6 6 1,412 2,782 8 0 1,674 contagem.pg_catalog.pg_class 6 6 1,161 22,824 0 0 870 rio.public.nf_entrada_arquivo_erros 1 0 487 8,200,030 0 0 145,812 contagem.pg_catalog.pg_type 4 4 426 9,006 0 0 244 contagem.pg_catalog.pg_index 2 2 376 3,796 0 7 103 rio.public.usuarios 2 2 204 1,101 89 0 32 contagem.pg_toast.pg_toast_2619 1 1 94 111 0 0 49 rio.public.caixa_itens_exclusao 1 0 32 1,231,364 0 0 10,266 rio.public.temp0000281505 3 0 0 65,313 0 0 4,800 rio.public.temp0000281555 1 0 0 21,776 0 0 1,600 rio.public.temp0000281491 1 0 0 1,459 0 48 80 rio.public.temp0000281339 3 0 0 9,561 0 123 197 rio.public.temp0000281483 12 0 0 260,800 0 0 19,200 rio.public.temp0000281343 7 0 0 18,254 0 167 473 rio.public.temp0000281327 19 0 0 63,729 0 670 1,442 rio.public.temp0000281535 1 0 0 1,133 0 4 60 rio.public.temp0000281531 1 0 0 1,662 0 37 91 rio.public.temp0000281509 6 0 0 130,516 0 0 9,600 contagem.auditor.auditor_2026_06 3 0 0 614,334 0 0 27,868 rio.public.temp0000281551 1 0 0 6,944 0 35 157 rio.public.temp0000281533 2 0 0 14,164 0 63 321 rio.public.temp0000281093 9 0 0 36,444 0 199 825 rio.public.temp0000281541 1 0 0 1,662 0 37 91 rio.public.temp0000281489 1 0 0 1,459 0 48 80 rio.public.logs 2 0 0 31,581,991 0 0 1,261,877 rio.public.temp0000281335 10 0 0 70,205 0 182 1,610 rio.public.temp0000281545 1 0 0 1,662 0 37 91 rio.public.temp0000281469 30 0 0 368,030 0 677 26,715 rio.public.temp0000281523 11 0 0 67,653 0 314 1,542 rio.public.temp0000281539 1 0 0 1,662 0 37 91 rio.public.temp0000281543 29 0 0 631,234 0 0 46,400 rio.public.equipamentos_referencia 1 0 0 5,000,956 0 0 27,033 rio.public.temp0000281513 47 0 0 640,418 0 723 46,509 rio.public.temp0000281537 1 0 0 1,662 0 37 91 rio.public.temp0000281487 2 0 0 2,920 0 96 160 rio.public.temp0000281495 2 0 0 4,617 0 24 104 rio.public.tmp_drill_0302 1 1 0 1,701 0 0 45 rio.public.temp0000281515 1 0 0 4,642 0 23 105 rio.public.temp0000281525 9 0 0 195,732 0 0 14,400 rio.public.temp0000281481 3 0 0 44,913 0 50 3,278 rio.public.temp0000281477 2 0 0 2,858 0 100 156 rio.public.temp0000281479 6 0 0 70,578 0 96 5,088 Total 482 201 337,431 61,428,833 101,756 4,459 2,188,780 Pages removed per table
Key values
- public.temp0000281513 (723) Main table with removed pages on database rio
- 4459 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000281513 47 0 0 723 rio.public.temp0000281469 30 0 0 677 rio.public.temp0000281327 19 0 0 670 rio.pg_catalog.pg_attribute 58 52 235869 430 rio.public.temp0000281523 11 0 0 314 rio.public.temp0000281093 9 0 0 199 rio.public.temp0000281335 10 0 0 182 rio.public.temp0000281343 7 0 0 167 rio.pg_catalog.pg_class 43 34 4657 131 rio.public.temp0000281339 3 0 0 123 rio.public.temp0000281477 2 0 0 100 rio.public.temp0000281487 2 0 0 96 rio.public.temp0000281479 6 0 0 96 rio.public.temp0000281533 2 0 0 63 rio.public.temp0000281481 3 0 0 50 rio.public.temp0000281491 1 0 0 48 rio.public.temp0000281489 1 0 0 48 rio.pg_catalog.pg_type 34 29 10220 38 rio.public.temp0000281531 1 0 0 37 rio.public.temp0000281541 1 0 0 37 rio.public.temp0000281545 1 0 0 37 rio.public.temp0000281539 1 0 0 37 rio.public.temp0000281537 1 0 0 37 rio.public.temp0000281551 1 0 0 35 rio.pg_catalog.pg_depend 14 14 7557 26 rio.public.temp0000281495 2 0 0 24 rio.public.temp0000281515 1 0 0 23 contagem.pg_catalog.pg_index 2 2 376 7 rio.public.temp0000281535 1 0 0 4 rio.public.temp0000281505 3 0 0 0 contagem.pg_toast.pg_toast_2619 1 1 94 0 rio.public.temp0000281555 1 0 0 0 rio.pg_catalog.pg_shdepend 2 2 2609 0 contagem.pg_catalog.pg_class 6 6 1161 0 rio.public.temp0000281483 12 0 0 0 rio.pg_catalog.pg_index 20 19 5913 0 rio.pg_toast.pg_toast_2619 6 6 1412 0 rio.public.temp0000281509 6 0 0 0 contagem.pg_catalog.pg_type 4 4 426 0 contagem.auditor.auditor_2026_06 3 0 0 0 rio.public.caixa_itens_exclusao 1 0 32 0 rio.public.usuarios 2 2 204 0 rio.auditor.auditor_2026_06 6 0 6858 0 contagem.public.usuarios 23 0 1455 0 rio.public.nf_entrada_arquivo_erros 1 0 487 0 rio.public.logs 2 0 0 0 contagem.pg_catalog.pg_attribute 11 11 31145 0 contagem.pg_catalog.pg_depend 3 3 3040 0 rio.public.temp0000281543 29 0 0 0 rio.pg_catalog.pg_statistic 8 8 14136 0 rio.public.equipamentos_referencia 1 0 0 0 contagem.pg_catalog.pg_statistic 3 3 5375 0 rio.public.tmp_drill_0302 1 1 0 0 rio.public.temp0000281525 9 0 0 0 contagem.pg_catalog.pg_shdepend 4 4 4405 0 Total 482 201 337,431 4,459 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jun 02 00 1 1 01 0 1 02 0 0 03 0 0 04 0 3 05 4 0 06 0 0 07 20 32 08 54 131 09 63 133 10 45 109 11 39 111 12 47 46 13 33 63 14 41 113 15 42 123 16 55 116 17 36 61 18 0 0 19 0 0 20 0 0 21 2 2 22 0 0 23 0 0 - 3.46 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- ShareLock Main Lock Type
- 4 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query 1 1 13s835ms 13s835ms 13s835ms 13s835ms call rs_giga_triagem (?);-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 07:15:22 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 00:05:23 Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 20:05:10 Database: rio User: intelifix Remote: [local] Application: psql
2 1 12s368ms 12s368ms 12s368ms 12s368ms select * from rs_fast_excel (?, ?);-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025096, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 16:26:58 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025032, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 07:15:22 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025090, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 15:51:14 Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1 2s581ms 2s581ms 2s581ms 2s581ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39862, 417, 'ZTE3ANNR1Y27444,14CA56CF2DB3,14CA56CF2DB4,ZTEGD970E18F$ZTE3ANNQ4N06461,3CF9F0A9291C,3CF9F0A9291D,ZTEGD6411C38$ZTE3ANNR7B16390,3891484A6CCB,3891484A6CCC,ZTEGDB07D166$ZTE3ANNR8C09210,3891484F5EE3,3891484F5EE4,ZTEGDB08A46A$ZTE3ANNR4N05454,4896D955DAEC,4896D955DAED,ZTEGD97F3513$ZTE3ANNR1Y02237,14CA56CCDEE9,14CA56CCDEEA,ZTEGD9707F18$ZTE3ANNR6R55143,48D6823A912C,48D6823A912D,ZTEGDB02023A$ZTE3ANNRCP00019,6C11BA692B41,6C11BA692B42,ZTEGDC6F40A6$ZTE3ANNQ4N02626,3CF9F0A8CF3A,3CF9F0A8CF3B,ZTEGD6410D3D$ZTE3ANNR8C34719,38914851B4C1,38914851B4C2,ZTEGDB09080F$ZTE3ANNQ8F13526,689E29FD5FE1,689E29FD5FE2,ZTEGD7BA31A6$ZTE3ANNT2V11840,D831398CA458,D831398CA459,ZTEGDD3020BF$ZTE3ANNRC552235,6C11BA66F219,6C11BA66F21A,ZTEGDC6EE1CA$ZTE3ANNQ8125007,689E29BE28E5,689E29BE28E6,ZTEGD7B79C3F$ZTE3ANNRB747463,5872C992919B,5872C992919C,ZTEGDC61E43A$ZTE3ANNR5W76168,48D682357CFA,48D682357CFB,ZTEGDB012987$ZTE3ANNR7B32689,3891484BEACD,3891484BEACE,ZTEGDB081111$ZTE3ANNR9W44961,D89A0DAC79E9,D89A0DAC79EA,ZTEGDB16C14C$ZTE3ANNQ3607541,3CF9F0A5862C,3CF9F0A5862D,ZTEGD6408110$ZTE3ANNT3H64282,D831399CA634,D831399CA635,ZTEGDD32CBB9$ZTE3ANNT3F11556,D83139963AA0,D83139963AA1,ZTEGDD31B9CB$ZTE3ANNQ7108227,C4EBFF8A893A,C4EBFF8A893B,ZTEGD70A3CF5$ZTE3ANNT3F11502,D8313996395C,D8313996395D,ZTEGDD31B995$ZTE3ANNQ9345476,843C9936BF15,843C9936BF16,ZTEGD7BC6D9B$ZTE3ANNQ8111271,689E29BCE6F5,689E29BCE6F6,ZTEGD7B76697$ZTE3ANNQ4A03429,3CF9F0AA48A4,3CF9F0AA48A5,ZTEGD6414C24$ZTE3ANNR4N12844,4896D9568820,4896D9568821,ZTEGD97F51F1$ZTE3ANNT3H17673,D831399861CE,D831399861CF,ZTEGDD3215A8$ZTE3ANNQ4407976,3CF9F0AC19CE,3CF9F0AC19CF,ZTEGD64199AB$ZTE3ANNT3H17740,D83139986360,D83139986361,ZTEGDD3215EB$ZTE3ANNRC556456,6C11BA675507,6C11BA675508,ZTEGDC6EF247$ZTE3ANNR9329709,D89A0D851859,D89A0D85185A,ZTEGDB14E80C$ZTE3ANNR8C28098,389148511993,389148511994,ZTEGDB08EE32$ZTE3ANNR8C24166,38914850BD6B,38914850BD6C,ZTEGDB08DED6$ZTE3ANNT3H44810,D831399ADDD4,D831399ADDD5,ZTEGDD327FA9$ZTE3ANNR9W44658,D89A0DAC72CF,D89A0DAC72D0,ZTEGDB16C01D$ZTE3ANNRC575839,6C11BA691B51,6C11BA691B52,ZTEGDC6F3DFE$ZTE3ANNT3H17016,D83139985268,D83139985269,ZTEGDD321317$ZTE3ANNR9319663,D89A0D842CE5,D89A0D842CE6,ZTEGDB14C0CE$ZTE3ANNR3Y24990,4896D9520A6C,4896D9520A6D,ZTEGD97E9253', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 11:35:07 Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247905, 320, 'ZTE3ANNR9W23515,D89A0DAA8345,D89A0DAA8346,ZTEGDB166D86$ZTE3ANNRCB37330,D831392139EA,D831392139EB,ZTEGDD2A4767$ZTE3ANNRCP29846,6C11BA6BE653,6C11BA6BE654,ZTEGDC6FB529$ZTE3ANNQ5214935,3CF9F0A88920,3CF9F0A88921,ZTEGD641018E$ZTE3ANNQCA32918,14CA56D5485F,14CA56D54860,ZTEGD971E601$ZTE3ANNR9W37471,D89A0DABCA5D,D89A0DABCA5E,ZTEGDB16A40A$ZTE3ANNRAM56335,5872C98C6093,5872C98C6094,ZTEGDC60DC0E$ZTE3ANNRCP43134,6C11BA6D1DC3,6C11BA6D1DC4,ZTEGDC6FE911$ZTE3ANNRCB75661,D8313924BC4C,D8313924BC4D,ZTEGDD2ADD22$ZTE3ANNR1Y37934,14CA56D0238F,14CA56D02390,ZTEGD9710A89', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$','', 00);
Date: 2026-06-02 08:11:29 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39858, 407, '836051908001193,241730920202,241729919105,241645716274,241668281025,241676721523,241617428193,241704674565,241614453246,241732171929,241701730406,241594958807,241698709415,241713741219,241729506483,241728659194,241732088182,241659730819,241658526267,241706782526,241649677592,230048410314,241646262647,241712107175,241731227986,241727082532,241654642735,241695561521,241728734455,241695552025,241698725454,241729942138,241673350824,241727260709,241727037375,241708860305,241708933645,241654549011,241660140309,241695637689,241620729010,241656785974,241728691926,241673350420,241599254052,241676720311,241713365671,241676680206,241729907588,241680295070,230048410011', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 10:24:34 Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 1 1s1ms 1s1ms 1s1ms 1s1ms drop table if exists temp0000281513;-
DROP TABLE IF EXISTS temp0000281513;
Date: 2026-06-02 14:40:58 Database: rio User: intelifix Remote: [local] Application: [unknown]
-
DROP TABLE IF EXISTS temp0000281513;
Date: 2026-06-02 14:40:58 Database: rio User: intelifix Remote: [local] Application: [unknown]
Queries that waited the most
Rank Wait time Query 1 13s835ms CALL RS_GIGA_TRIAGEM ('REPROCESSAR');[ Date: 2026-06-02 07:15:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 12s368ms SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/Exclusão ATOP 1.xlsx'') ;', '/var/www/html/tmp/temp_83.xlsx');[ Date: 2026-06-02 15:54:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
3 2s581ms SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39860, 417, 'ZTEEH7VP6E02100,C0515CAFE49E$ZTEEH7VP6E02182,C0515CAFE5E6', '',0317,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$','', 00);[ Date: 2026-06-02 10:24:34 - Database: contagem - User: intelifix - Remote: [local] - Application: [unknown] ]
4 1s1ms DROP TABLE IF EXISTS temp0000281513;[ Date: 2026-06-02 14:40:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
-
Queries
Queries by type
Key values
- 4,124 Total read queries
- 1,195 Total write queries
Queries by database
Key values
- rio Main database
- 4,705 Requests
- 6h51s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,528 Requests
User Request type Count Duration etiquetas Total 2 357ms select 2 357ms intelifix Total 5,528 6h13m3s copy to 276 39m23s ddl 919 49m55s others 293 27m22s select 4,039 4h16m22s lenon Total 83 39s459ms select 83 39s459ms Duration by user
Key values
- 6h13m3s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 2 357ms select 2 357ms intelifix Total 5,528 6h13m3s copy to 276 39m23s ddl 919 49m55s others 293 27m22s select 4,039 4h16m22s lenon Total 83 39s459ms select 83 39s459ms Queries by host
Key values
- [local] Main host
- 5,613 Requests
- 6h13m43s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,855 Requests
- 3h14m25s ([unknown])
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-06-02 12:31:34 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 3,197 100-500ms duration
Slowest individual queries
Rank Duration Query 1 7m36s analyze verbose;[ Date: 2026-06-02 05:07:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 7m18s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 07:12:20 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 7m14s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 11:12:16 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 6m59s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 17:12:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 6m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 14:11:48 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 6m45s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 20:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 6m35s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 16:11:37 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 6m33s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 10:11:35 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 12:10:56 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 5m54s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 09:10:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
11 5m49s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 15:10:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 5m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 08:10:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 5m34s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 13:10:36 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 5m28s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 21:10:29 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
15 5m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 19:10:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m15s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 18:10:17 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m9s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-06-02 22:10:11 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 4m8s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025096, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-02 16:26:58 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
19 4m SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025032, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-02 07:15:22 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 3m52s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025090, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');[ Date: 2026-06-02 15:51:14 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h52m2s 248 154ms 4m8s 27s107ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 02 07 21 11m21s 32s436ms 08 10 11m 1m6s 09 14 13m4s 56s58ms 10 27 8m12s 18s250ms 11 25 13m36s 32s652ms 12 8 11m49s 1m28s 13 14 55s997ms 3s999ms 14 37 15m29s 25s110ms 15 28 11m19s 24s258ms 16 45 11m2s 14s726ms 17 19 4m10s 13s174ms [ User: intelifix - Total duration: 1h52m2s - Times executed: 248 ]
[ Application: [unknown] - Total duration: 1h52m2s - Times executed: 248 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025096, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 16:26:58 Duration: 4m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025032, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 07:15:22 Duration: 4m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025090, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 15:51:14 Duration: 3m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
2 1h39m3s 32 943ms 7m18s 3m5s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 02 07 2 7m20s 3m40s 08 2 5m38s 2m49s 09 2 5m57s 2m58s 10 2 6m43s 3m21s 11 2 7m24s 3m42s 12 2 5m56s 2m58s 13 2 5m36s 2m48s 14 2 6m48s 3m24s 15 2 5m50s 2m55s 16 2 6m36s 3m18s 17 2 7m1s 3m30s 18 2 5m16s 2m38s 19 2 5m21s 2m40s 20 2 6m47s 3m23s 21 2 5m29s 2m44s 22 2 5m11s 2m35s [ User: intelifix - Total duration: 1h39m3s - Times executed: 32 ]
[ Application: psql - Total duration: 1h39m3s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-02 07:12:20 Duration: 7m18s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-02 11:12:16 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-02 17:12:01 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: psql
3 15m19s 1,261 150ms 5s516ms 729ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 02 07 6 2s186ms 364ms 08 101 1m8s 676ms 09 171 2m16s 796ms 10 155 2m6s 815ms 11 126 1m50s 874ms 12 61 38s194ms 626ms 13 80 1m2s 781ms 14 159 1m54s 721ms 15 188 2m5s 669ms 16 169 1m42s 606ms 17 45 32s869ms 730ms [ User: intelifix - Total duration: 15m19s - Times executed: 1261 ]
[ Application: [unknown] - Total duration: 15m19s - Times executed: 1261 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39862, 417, 'ZTE3ANNR1Y27444,14CA56CF2DB3,14CA56CF2DB4,ZTEGD970E18F$ZTE3ANNQ4N06461,3CF9F0A9291C,3CF9F0A9291D,ZTEGD6411C38$ZTE3ANNR7B16390,3891484A6CCB,3891484A6CCC,ZTEGDB07D166$ZTE3ANNR8C09210,3891484F5EE3,3891484F5EE4,ZTEGDB08A46A$ZTE3ANNR4N05454,4896D955DAEC,4896D955DAED,ZTEGD97F3513$ZTE3ANNR1Y02237,14CA56CCDEE9,14CA56CCDEEA,ZTEGD9707F18$ZTE3ANNR6R55143,48D6823A912C,48D6823A912D,ZTEGDB02023A$ZTE3ANNRCP00019,6C11BA692B41,6C11BA692B42,ZTEGDC6F40A6$ZTE3ANNQ4N02626,3CF9F0A8CF3A,3CF9F0A8CF3B,ZTEGD6410D3D$ZTE3ANNR8C34719,38914851B4C1,38914851B4C2,ZTEGDB09080F$ZTE3ANNQ8F13526,689E29FD5FE1,689E29FD5FE2,ZTEGD7BA31A6$ZTE3ANNT2V11840,D831398CA458,D831398CA459,ZTEGDD3020BF$ZTE3ANNRC552235,6C11BA66F219,6C11BA66F21A,ZTEGDC6EE1CA$ZTE3ANNQ8125007,689E29BE28E5,689E29BE28E6,ZTEGD7B79C3F$ZTE3ANNRB747463,5872C992919B,5872C992919C,ZTEGDC61E43A$ZTE3ANNR5W76168,48D682357CFA,48D682357CFB,ZTEGDB012987$ZTE3ANNR7B32689,3891484BEACD,3891484BEACE,ZTEGDB081111$ZTE3ANNR9W44961,D89A0DAC79E9,D89A0DAC79EA,ZTEGDB16C14C$ZTE3ANNQ3607541,3CF9F0A5862C,3CF9F0A5862D,ZTEGD6408110$ZTE3ANNT3H64282,D831399CA634,D831399CA635,ZTEGDD32CBB9$ZTE3ANNT3F11556,D83139963AA0,D83139963AA1,ZTEGDD31B9CB$ZTE3ANNQ7108227,C4EBFF8A893A,C4EBFF8A893B,ZTEGD70A3CF5$ZTE3ANNT3F11502,D8313996395C,D8313996395D,ZTEGDD31B995$ZTE3ANNQ9345476,843C9936BF15,843C9936BF16,ZTEGD7BC6D9B$ZTE3ANNQ8111271,689E29BCE6F5,689E29BCE6F6,ZTEGD7B76697$ZTE3ANNQ4A03429,3CF9F0AA48A4,3CF9F0AA48A5,ZTEGD6414C24$ZTE3ANNR4N12844,4896D9568820,4896D9568821,ZTEGD97F51F1$ZTE3ANNT3H17673,D831399861CE,D831399861CF,ZTEGDD3215A8$ZTE3ANNQ4407976,3CF9F0AC19CE,3CF9F0AC19CF,ZTEGD64199AB$ZTE3ANNT3H17740,D83139986360,D83139986361,ZTEGDD3215EB$ZTE3ANNRC556456,6C11BA675507,6C11BA675508,ZTEGDC6EF247$ZTE3ANNR9329709,D89A0D851859,D89A0D85185A,ZTEGDB14E80C$ZTE3ANNR8C28098,389148511993,389148511994,ZTEGDB08EE32$ZTE3ANNR8C24166,38914850BD6B,38914850BD6C,ZTEGDB08DED6$ZTE3ANNT3H44810,D831399ADDD4,D831399ADDD5,ZTEGDD327FA9$ZTE3ANNR9W44658,D89A0DAC72CF,D89A0DAC72D0,ZTEGDB16C01D$ZTE3ANNRC575839,6C11BA691B51,6C11BA691B52,ZTEGDC6F3DFE$ZTE3ANNT3H17016,D83139985268,D83139985269,ZTEGDD321317$ZTE3ANNR9319663,D89A0D842CE5,D89A0D842CE6,ZTEGDB14C0CE$ZTE3ANNR3Y24990,4896D9520A6C,4896D9520A6D,ZTEGD97E9253', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 11:35:07 Duration: 5s516ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247905, 320, 'ZTE3ANNR9W23515,D89A0DAA8345,D89A0DAA8346,ZTEGDB166D86$ZTE3ANNRCB37330,D831392139EA,D831392139EB,ZTEGDD2A4767$ZTE3ANNRCP29846,6C11BA6BE653,6C11BA6BE654,ZTEGDC6FB529$ZTE3ANNQ5214935,3CF9F0A88920,3CF9F0A88921,ZTEGD641018E$ZTE3ANNQCA32918,14CA56D5485F,14CA56D54860,ZTEGD971E601$ZTE3ANNR9W37471,D89A0DABCA5D,D89A0DABCA5E,ZTEGDB16A40A$ZTE3ANNRAM56335,5872C98C6093,5872C98C6094,ZTEGDC60DC0E$ZTE3ANNRCP43134,6C11BA6D1DC3,6C11BA6D1DC4,ZTEGDC6FE911$ZTE3ANNRCB75661,D8313924BC4C,D8313924BC4D,ZTEGDD2ADD22$ZTE3ANNR1Y37934,14CA56D0238F,14CA56D02390,ZTEGD9710A89', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$','', 00);
Date: 2026-06-02 08:11:29 Duration: 4s795ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39858, 407, '836051908001193,241730920202,241729919105,241645716274,241668281025,241676721523,241617428193,241704674565,241614453246,241732171929,241701730406,241594958807,241698709415,241713741219,241729506483,241728659194,241732088182,241659730819,241658526267,241706782526,241649677592,230048410314,241646262647,241712107175,241731227986,241727082532,241654642735,241695561521,241728734455,241695552025,241698725454,241729942138,241673350824,241727260709,241727037375,241708860305,241708933645,241654549011,241660140309,241695637689,241620729010,241656785974,241728691926,241673350420,241599254052,241676720311,241713365671,241676680206,241729907588,241680295070,230048410011', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 10:24:34 Duration: 4s258ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 13m31s 81 8s233ms 12s578ms 10s21ms create table temp0000281513 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 02 10 13 2m8s 9s851ms 11 14 2m20s 10s71ms 12 13 2m 9s307ms 14 18 3m8s 10s465ms 15 17 2m50s 10s29ms 16 6 1m2s 10s462ms [ User: intelifix - Total duration: 13m31s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 13m31s - Times executed: 81 ]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:41:10 Duration: 12s578ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:20:54 Duration: 12s406ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 16:22:46 Duration: 12s20ms Database: rio User: intelifix Remote: [local] Application: [unknown]
5 9m40s 2 2m3s 7m36s 4m50s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 02 05 2 9m40s 4m50s [ User: intelifix - Total duration: 9m40s - Times executed: 2 ]
[ Application: psql - Total duration: 9m40s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-02 05:07:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-02 05:09:42 Duration: 2m3s Database: contagem User: intelifix Remote: [local] Application: psql
6 9m18s 32 437ms 44s681ms 17s467ms select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 02 07 2 45s506ms 22s753ms 08 2 31s476ms 15s738ms 09 2 31s858ms 15s929ms 10 2 41s207ms 20s603ms 11 2 45s361ms 22s680ms 12 2 29s721ms 14s860ms 13 2 29s224ms 14s612ms 14 2 34s903ms 17s451ms 15 2 45s643ms 22s821ms 16 2 36s215ms 18s107ms 17 2 36s856ms 18s428ms 18 2 27s553ms 13s776ms 19 2 28s829ms 14s414ms 20 2 40s27ms 20s13ms 21 2 27s233ms 13s616ms 22 2 27s327ms 13s663ms [ User: intelifix - Total duration: 9m18s - Times executed: 32 ]
[ Application: psql - Total duration: 9m18s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-02 15:11:35 Duration: 44s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-02 07:13:04 Duration: 44s193ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-02 11:13:00 Duration: 43s843ms Database: rio User: intelifix Remote: [local] Application: psql
7 7m57s 137 2s663ms 17s444ms 3s485ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 02 00 6 25s815ms 4s302ms 01 6 17s917ms 2s986ms 02 6 17s515ms 2s919ms 03 5 15s785ms 3s157ms 04 6 17s3ms 2s833ms 05 6 18s106ms 3s17ms 06 6 17s850ms 2s975ms 07 6 34s73ms 5s678ms 08 6 23s139ms 3s856ms 09 6 23s149ms 3s858ms 10 6 19s277ms 3s212ms 11 6 21s344ms 3s557ms 12 6 18s630ms 3s105ms 13 6 19s310ms 3s218ms 14 6 22s53ms 3s675ms 15 6 23s187ms 3s864ms 16 6 20s688ms 3s448ms 17 6 20s926ms 3s487ms 18 6 18s161ms 3s26ms 19 6 17s918ms 2s986ms 20 6 26s536ms 4s422ms 21 6 19s98ms 3s183ms 22 6 20s36ms 3s339ms [ User: intelifix - Total duration: 7m57s - Times executed: 137 ]
[ Application: psql - Total duration: 7m57s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 07:15:22 Duration: 17s444ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 00:05:23 Duration: 10s583ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 20:05:10 Duration: 8s776ms Database: rio User: intelifix Remote: [local] Application: psql
8 7m33s 1,016 150ms 2s649ms 446ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 02 07 1 2s649ms 2s649ms 08 128 1m7s 526ms 09 154 1m3s 415ms 10 102 43s559ms 427ms 11 139 1m1s 440ms 12 1 509ms 509ms 13 117 45s830ms 391ms 14 117 57s408ms 490ms 15 157 1m9s 445ms 16 98 40s636ms 414ms 17 2 854ms 427ms [ User: intelifix - Total duration: 7m33s - Times executed: 1016 ]
[ Application: [unknown] - Total duration: 7m33s - Times executed: 1016 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "247840", "modelo" : "464", "itens" : "241766279814,241762105568,241743618993,241747899008,241763676372,241759850220,241764787681,241764810109,241766989513,241744063841,241739966067,241739018791,863400600503908,241762243539,241759844663,241745294455,241763716073,241743641320,241687236566,241743841620,241745428990,241740044964,241747990914,241743640108,241760879601,241745411717,241741183448,241748115370,241763135657,241759845269,241760804667,241748007177,241761066667,241748041121,241687230001,241742735361,241748142343,241763698293,241762051321,241744096571,241768393859,241763674150,241763698091,241763699304,241763656673,241759795163,241747996267,241747993338,241748135978,241766995978,241687810821,241748012734,241748116986,241760783857,241740847578,241763676170,241739942227,241759771525,863400602209983,241748146181,241760223443,241764792329,241764789196,241764782530,241762845068,241744950101,241760065773,241763839496,241759812842,241763618588,241762119206,241767009919,241763136667,241763640309,241763684454,241687374964,241766841620,241748135372,241759798698,241763379800,241767040405,241747930123,241747942525,241744609001,241761383444,241761389101,241767394760,241777666873,241764811018,241742570722,241745290516,241747938406,241744682039,241759461921,241763772645,241747978689,241760204148,241761401426,241767714062,241764805057", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-02 07:58:52 Duration: 2s649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "247855", "modelo" : "464", "itens" : "241743947589,241743845660,241743847276,241763635863,241748117289,241762486065,241741255576,241739035460,241741220523,241743842832,241759805467,241759787687,241763843942,241767023355,241759784960,241739005053,241743689506,241740869398,241743987492,241741138796,241739700711,241688150809,241744617284,241762468083,241741248202,241759763342,241740567293,241743848589,241748149010,241744107077,241740076785,241760880208,241747930325,241740989411,241763825152,241763386871,241740076886,241743983957,241745410606,241762157593,241741249616,241741084650,241687385268,241763838486,241744560411,241744573846,241759772737,241743440010,241759877090,241766169297,241741210522,241738037697,241739983140,241762438888,241687992028,241763650512,241741155667,241768757081,241744741113,241742399515,241762766272,241764809198,241745396182,241768823452,241764905067,241742765566,241739994656,241760915362,241762098496,241748079104,241740916676,241762073141,241747056063,241742263946,241738956283,241744570311,241743529816,241759798901,241739015761,241687733439,241748001723,241766968703,241747999196,241747999499,241748071023,241739643859,241763635358,241743114242,241739117286,241740952337,241745513949,241762109609,241748145373,241759842946,241744677795,241762272128,241739999606,241762277380,241764376070,241742718389", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-02 08:02:07 Duration: 2s578ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "137", "itens" : "229703779495,229829835356,229830279293,229775001734,216926146568,229638671919,229880828403,229829288603,229729573540,216928203436,229715332633,229640688300,229694753857,229823586587,229834153758,229836029091", "usuario" : "405", "caixa" : "1219736", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-02 09:50:28 Duration: 2s158ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 6m15s 38 7s741ms 12s159ms 9s879ms create table temp0000281543 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 02 13 2 22s90ms 11s45ms 14 10 1m40s 10s41ms 15 3 27s996ms 9s332ms 16 12 2m2s 10s192ms 17 11 1m42s 9s329ms [ User: intelifix - Total duration: 6m15s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 6m15s - Times executed: 38 ]
-
CREATE TABLE temp0000281543 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 13:56:55 Duration: 12s159ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281543 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:26:31 Duration: 11s970ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281543 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 16:23:55 Duration: 11s662ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 5m58s 39 7s900ms 10s622ms 9s198ms create table temp0000281469 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 02 07 15 2m9s 8s620ms 08 16 2m35s 9s688ms 09 8 1m14s 9s303ms [ User: intelifix - Total duration: 5m58s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 5m58s - Times executed: 39 ]
-
CREATE TABLE temp0000281469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:04:44 Duration: 10s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:45:30 Duration: 10s477ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:20:59 Duration: 10s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 5m42s 101 172ms 10s953ms 3s394ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 02 00 6 15s443ms 2s573ms 01 6 7s768ms 1s294ms 02 5 5s756ms 1s151ms 03 6 7s511ms 1s251ms 04 6 6s504ms 1s84ms 05 4 9s174ms 2s293ms 07 5 26s879ms 5s375ms 08 6 33s430ms 5s571ms 09 6 29s554ms 4s925ms 10 6 28s296ms 4s716ms 11 6 35s604ms 5s934ms 12 6 29s752ms 4s958ms 13 4 5s932ms 1s483ms 14 6 33s661ms 5s610ms 15 6 29s966ms 4s994ms 16 6 21s513ms 3s585ms 21 5 6s377ms 1s275ms 22 6 9s678ms 1s613ms [ User: intelifix - Total duration: 5m42s - Times executed: 101 ]
[ Application: psql - Total duration: 5m42s - Times executed: 101 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 14:55:12 Duration: 10s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 00:05:12 Duration: 10s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 11:55:10 Duration: 8s286ms Database: rio User: intelifix Remote: [local] Application: psql
12 3m10s 45 808ms 13s324ms 4s233ms call rs_tcia_processa_lotes ();Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 02 08 3 16s248ms 5s416ms 09 3 20s857ms 6s952ms 10 3 19s936ms 6s645ms 11 3 21s81ms 7s27ms 12 3 11s733ms 3s911ms 13 3 15s32ms 5s10ms 14 3 20s419ms 6s806ms 15 3 25s410ms 8s470ms 16 3 14s646ms 4s882ms 17 3 8s835ms 2s945ms 18 3 3s3ms 1s1ms 19 3 3s294ms 1s98ms 20 3 3s314ms 1s104ms 21 3 3s603ms 1s201ms 22 3 3s108ms 1s36ms [ User: intelifix - Total duration: 3m10s - Times executed: 45 ]
[ Application: psql - Total duration: 3m10s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-02 15:40:15 Duration: 13s324ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-02 11:40:13 Duration: 12s217ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-02 08:20:13 Duration: 12s95ms Database: rio User: intelifix Remote: [local] Application: psql
13 3m8s 19 8s232ms 11s746ms 9s914ms create table temp0000281483 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 02 08 6 1m1s 10s270ms 09 8 1m15s 9s430ms 10 5 51s320ms 10s264ms [ User: intelifix - Total duration: 3m8s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 19 ]
-
CREATE TABLE temp0000281483 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 10:24:23 Duration: 11s746ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281483 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 09:01:49 Duration: 11s260ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281483 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:41:31 Duration: 11s209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m7s 73 229ms 40s364ms 2s571ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 02 07 6 2s698ms 449ms 08 8 5s710ms 713ms 09 8 20s879ms 2s609ms 10 7 9s814ms 1s402ms 11 7 42s874ms 6s124ms 12 7 13s248ms 1s892ms 13 1 643ms 643ms 14 11 51s781ms 4s707ms 15 7 3s391ms 484ms 16 6 16s509ms 2s751ms 17 5 20s195ms 4s39ms [ User: intelifix - Total duration: 3m7s - Times executed: 73 ]
[ Application: psql - Total duration: 3m7s - Times executed: 73 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 504); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025060);
Date: 2026-06-02 11:02:35 Duration: 40s364ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025080);
Date: 2026-06-02 14:32:46 Duration: 25s81ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025078);
Date: 2026-06-02 14:26:42 Duration: 22s374ms Database: rio User: intelifix Remote: [local] Application: psql
15 2m59s 2 1m29s 1m29s 1m29s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 02 20 1 1m29s 1m29s 23 1 1m29s 1m29s [ User: intelifix - Total duration: 2m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-02 23:39:33 Duration: 1m29s 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-06-02 20:08:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
16 2m26s 15 8s485ms 10s944ms 9s778ms create table temp0000281525 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 02 10 3 30s379ms 10s126ms 11 6 59s330ms 9s888ms 12 6 56s970ms 9s495ms [ User: intelifix - Total duration: 2m26s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m26s - Times executed: 15 ]
-
CREATE TABLE temp0000281525 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 10:54:36 Duration: 10s944ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281525 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 11:02:05 Duration: 10s666ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281525 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 11:02:19 Duration: 10s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m20s 33 3s76ms 6s57ms 4s252ms create table temp0000281513 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 02 09 5 17s200ms 3s440ms 10 4 17s67ms 4s266ms 12 12 45s823ms 3s818ms 14 2 9s783ms 4s891ms 15 7 36s611ms 5s230ms 16 3 13s855ms 4s618ms [ User: intelifix - Total duration: 2m20s - Times executed: 33 ]
[ Application: [unknown] - Total duration: 2m20s - Times executed: 33 ]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 15:18:37 Duration: 6s57ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 15:52:53 Duration: 5s747ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 15:18:15 Duration: 5s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 2m16s 2 22s210ms 1m54s 1m8s 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 #18
Day Hour Count Duration Avg duration Jun 02 23 2 2m16s 1m8s [ User: intelifix - Total duration: 2m16s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m16s - 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-06-02 23:14:47 Duration: 1m54s 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-06-02 23:41:06 Duration: 22s210ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
19 1m59s 2 53s893ms 1m5s 59s773ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 02 20 1 1m5s 1m5s 23 1 53s893ms 53s893ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-02 20:05:26 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-02 23:18:05 Duration: 53s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
20 1m54s 2 20s128ms 1m34s 57s479ms copy auditor.auditor_2026_03 (ti, table_name, action, field_name, pk_name, pk_value, user_id, user_name, date_time, old_value, new_value, stack) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 02 23 2 1m54s 57s479ms [ User: intelifix - Total duration: 1m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (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-06-02 23:11:38 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (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-06-02 23:40:23 Duration: 20s128ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,261 15m19s 150ms 5s516ms 729ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 02 07 6 2s186ms 364ms 08 101 1m8s 676ms 09 171 2m16s 796ms 10 155 2m6s 815ms 11 126 1m50s 874ms 12 61 38s194ms 626ms 13 80 1m2s 781ms 14 159 1m54s 721ms 15 188 2m5s 669ms 16 169 1m42s 606ms 17 45 32s869ms 730ms [ User: intelifix - Total duration: 15m19s - Times executed: 1261 ]
[ Application: [unknown] - Total duration: 15m19s - Times executed: 1261 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39862, 417, 'ZTE3ANNR1Y27444,14CA56CF2DB3,14CA56CF2DB4,ZTEGD970E18F$ZTE3ANNQ4N06461,3CF9F0A9291C,3CF9F0A9291D,ZTEGD6411C38$ZTE3ANNR7B16390,3891484A6CCB,3891484A6CCC,ZTEGDB07D166$ZTE3ANNR8C09210,3891484F5EE3,3891484F5EE4,ZTEGDB08A46A$ZTE3ANNR4N05454,4896D955DAEC,4896D955DAED,ZTEGD97F3513$ZTE3ANNR1Y02237,14CA56CCDEE9,14CA56CCDEEA,ZTEGD9707F18$ZTE3ANNR6R55143,48D6823A912C,48D6823A912D,ZTEGDB02023A$ZTE3ANNRCP00019,6C11BA692B41,6C11BA692B42,ZTEGDC6F40A6$ZTE3ANNQ4N02626,3CF9F0A8CF3A,3CF9F0A8CF3B,ZTEGD6410D3D$ZTE3ANNR8C34719,38914851B4C1,38914851B4C2,ZTEGDB09080F$ZTE3ANNQ8F13526,689E29FD5FE1,689E29FD5FE2,ZTEGD7BA31A6$ZTE3ANNT2V11840,D831398CA458,D831398CA459,ZTEGDD3020BF$ZTE3ANNRC552235,6C11BA66F219,6C11BA66F21A,ZTEGDC6EE1CA$ZTE3ANNQ8125007,689E29BE28E5,689E29BE28E6,ZTEGD7B79C3F$ZTE3ANNRB747463,5872C992919B,5872C992919C,ZTEGDC61E43A$ZTE3ANNR5W76168,48D682357CFA,48D682357CFB,ZTEGDB012987$ZTE3ANNR7B32689,3891484BEACD,3891484BEACE,ZTEGDB081111$ZTE3ANNR9W44961,D89A0DAC79E9,D89A0DAC79EA,ZTEGDB16C14C$ZTE3ANNQ3607541,3CF9F0A5862C,3CF9F0A5862D,ZTEGD6408110$ZTE3ANNT3H64282,D831399CA634,D831399CA635,ZTEGDD32CBB9$ZTE3ANNT3F11556,D83139963AA0,D83139963AA1,ZTEGDD31B9CB$ZTE3ANNQ7108227,C4EBFF8A893A,C4EBFF8A893B,ZTEGD70A3CF5$ZTE3ANNT3F11502,D8313996395C,D8313996395D,ZTEGDD31B995$ZTE3ANNQ9345476,843C9936BF15,843C9936BF16,ZTEGD7BC6D9B$ZTE3ANNQ8111271,689E29BCE6F5,689E29BCE6F6,ZTEGD7B76697$ZTE3ANNQ4A03429,3CF9F0AA48A4,3CF9F0AA48A5,ZTEGD6414C24$ZTE3ANNR4N12844,4896D9568820,4896D9568821,ZTEGD97F51F1$ZTE3ANNT3H17673,D831399861CE,D831399861CF,ZTEGDD3215A8$ZTE3ANNQ4407976,3CF9F0AC19CE,3CF9F0AC19CF,ZTEGD64199AB$ZTE3ANNT3H17740,D83139986360,D83139986361,ZTEGDD3215EB$ZTE3ANNRC556456,6C11BA675507,6C11BA675508,ZTEGDC6EF247$ZTE3ANNR9329709,D89A0D851859,D89A0D85185A,ZTEGDB14E80C$ZTE3ANNR8C28098,389148511993,389148511994,ZTEGDB08EE32$ZTE3ANNR8C24166,38914850BD6B,38914850BD6C,ZTEGDB08DED6$ZTE3ANNT3H44810,D831399ADDD4,D831399ADDD5,ZTEGDD327FA9$ZTE3ANNR9W44658,D89A0DAC72CF,D89A0DAC72D0,ZTEGDB16C01D$ZTE3ANNRC575839,6C11BA691B51,6C11BA691B52,ZTEGDC6F3DFE$ZTE3ANNT3H17016,D83139985268,D83139985269,ZTEGDD321317$ZTE3ANNR9319663,D89A0D842CE5,D89A0D842CE6,ZTEGDB14C0CE$ZTE3ANNR3Y24990,4896D9520A6C,4896D9520A6D,ZTEGD97E9253', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 11:35:07 Duration: 5s516ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247905, 320, 'ZTE3ANNR9W23515,D89A0DAA8345,D89A0DAA8346,ZTEGDB166D86$ZTE3ANNRCB37330,D831392139EA,D831392139EB,ZTEGDD2A4767$ZTE3ANNRCP29846,6C11BA6BE653,6C11BA6BE654,ZTEGDC6FB529$ZTE3ANNQ5214935,3CF9F0A88920,3CF9F0A88921,ZTEGD641018E$ZTE3ANNQCA32918,14CA56D5485F,14CA56D54860,ZTEGD971E601$ZTE3ANNR9W37471,D89A0DABCA5D,D89A0DABCA5E,ZTEGDB16A40A$ZTE3ANNRAM56335,5872C98C6093,5872C98C6094,ZTEGDC60DC0E$ZTE3ANNRCP43134,6C11BA6D1DC3,6C11BA6D1DC4,ZTEGDC6FE911$ZTE3ANNRCB75661,D8313924BC4C,D8313924BC4D,ZTEGDD2ADD22$ZTE3ANNR1Y37934,14CA56D0238F,14CA56D02390,ZTEGD9710A89', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$','', 00);
Date: 2026-06-02 08:11:29 Duration: 4s795ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39858, 407, '836051908001193,241730920202,241729919105,241645716274,241668281025,241676721523,241617428193,241704674565,241614453246,241732171929,241701730406,241594958807,241698709415,241713741219,241729506483,241728659194,241732088182,241659730819,241658526267,241706782526,241649677592,230048410314,241646262647,241712107175,241731227986,241727082532,241654642735,241695561521,241728734455,241695552025,241698725454,241729942138,241673350824,241727260709,241727037375,241708860305,241708933645,241654549011,241660140309,241695637689,241620729010,241656785974,241728691926,241673350420,241599254052,241676720311,241713365671,241676680206,241729907588,241680295070,230048410011', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 10:24:34 Duration: 4s258ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 1,016 7m33s 150ms 2s649ms 446ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 02 07 1 2s649ms 2s649ms 08 128 1m7s 526ms 09 154 1m3s 415ms 10 102 43s559ms 427ms 11 139 1m1s 440ms 12 1 509ms 509ms 13 117 45s830ms 391ms 14 117 57s408ms 490ms 15 157 1m9s 445ms 16 98 40s636ms 414ms 17 2 854ms 427ms [ User: intelifix - Total duration: 7m33s - Times executed: 1016 ]
[ Application: [unknown] - Total duration: 7m33s - Times executed: 1016 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "247840", "modelo" : "464", "itens" : "241766279814,241762105568,241743618993,241747899008,241763676372,241759850220,241764787681,241764810109,241766989513,241744063841,241739966067,241739018791,863400600503908,241762243539,241759844663,241745294455,241763716073,241743641320,241687236566,241743841620,241745428990,241740044964,241747990914,241743640108,241760879601,241745411717,241741183448,241748115370,241763135657,241759845269,241760804667,241748007177,241761066667,241748041121,241687230001,241742735361,241748142343,241763698293,241762051321,241744096571,241768393859,241763674150,241763698091,241763699304,241763656673,241759795163,241747996267,241747993338,241748135978,241766995978,241687810821,241748012734,241748116986,241760783857,241740847578,241763676170,241739942227,241759771525,863400602209983,241748146181,241760223443,241764792329,241764789196,241764782530,241762845068,241744950101,241760065773,241763839496,241759812842,241763618588,241762119206,241767009919,241763136667,241763640309,241763684454,241687374964,241766841620,241748135372,241759798698,241763379800,241767040405,241747930123,241747942525,241744609001,241761383444,241761389101,241767394760,241777666873,241764811018,241742570722,241745290516,241747938406,241744682039,241759461921,241763772645,241747978689,241760204148,241761401426,241767714062,241764805057", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-02 07:58:52 Duration: 2s649ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "247855", "modelo" : "464", "itens" : "241743947589,241743845660,241743847276,241763635863,241748117289,241762486065,241741255576,241739035460,241741220523,241743842832,241759805467,241759787687,241763843942,241767023355,241759784960,241739005053,241743689506,241740869398,241743987492,241741138796,241739700711,241688150809,241744617284,241762468083,241741248202,241759763342,241740567293,241743848589,241748149010,241744107077,241740076785,241760880208,241747930325,241740989411,241763825152,241763386871,241740076886,241743983957,241745410606,241762157593,241741249616,241741084650,241687385268,241763838486,241744560411,241744573846,241759772737,241743440010,241759877090,241766169297,241741210522,241738037697,241739983140,241762438888,241687992028,241763650512,241741155667,241768757081,241744741113,241742399515,241762766272,241764809198,241745396182,241768823452,241764905067,241742765566,241739994656,241760915362,241762098496,241748079104,241740916676,241762073141,241747056063,241742263946,241738956283,241744570311,241743529816,241759798901,241739015761,241687733439,241748001723,241766968703,241747999196,241747999499,241748071023,241739643859,241763635358,241743114242,241739117286,241740952337,241745513949,241762109609,241748145373,241759842946,241744677795,241762272128,241739999606,241762277380,241764376070,241742718389", "usuario" : "418", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-02 08:02:07 Duration: 2s578ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "104485", "modelo" : "137", "itens" : "229703779495,229829835356,229830279293,229775001734,216926146568,229638671919,229880828403,229829288603,229729573540,216928203436,229715332633,229640688300,229694753857,229823586587,229834153758,229836029091", "usuario" : "405", "caixa" : "1219736", "tecnico-cosmetico" : "0", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-06-02 09:50:28 Duration: 2s158ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 295 1m29s 150ms 1s378ms 304ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 02 08 15 8s393ms 559ms 14 58 15s518ms 267ms 15 126 43s649ms 346ms 16 29 6s528ms 225ms 17 67 15s818ms 236ms [ User: intelifix - Total duration: 1m29s - Times executed: 295 ]
[ Application: [unknown] - Total duration: 1m29s - Times executed: 295 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"36882","seriais":"226140727688","usuario":"416","observacao":""}');
Date: 2026-06-02 08:43:18 Duration: 1s378ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"36882","seriais":"225864778805","usuario":"416","observacao":""}');
Date: 2026-06-02 08:42:21 Duration: 1s116ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"36882","seriais":"226115197183","usuario":"416","observacao":""}');
Date: 2026-06-02 08:43:33 Duration: 930ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
4 248 1h52m2s 154ms 4m8s 27s107ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jun 02 07 21 11m21s 32s436ms 08 10 11m 1m6s 09 14 13m4s 56s58ms 10 27 8m12s 18s250ms 11 25 13m36s 32s652ms 12 8 11m49s 1m28s 13 14 55s997ms 3s999ms 14 37 15m29s 25s110ms 15 28 11m19s 24s258ms 16 45 11m2s 14s726ms 17 19 4m10s 13s174ms [ User: intelifix - Total duration: 1h52m2s - Times executed: 248 ]
[ Application: [unknown] - Total duration: 1h52m2s - Times executed: 248 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025096, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 16:26:58 Duration: 4m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025032, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 07:15:22 Duration: 4m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025090, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 15:51:14 Duration: 3m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 163 1m35s 157ms 4s560ms 584ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 02 07 21 10s247ms 487ms 08 3 919ms 306ms 09 2 1s518ms 759ms 10 13 7s582ms 583ms 11 16 6s338ms 396ms 13 18 5s540ms 307ms 14 29 20s775ms 716ms 15 14 15s278ms 1s91ms 16 30 16s825ms 560ms 17 17 10s283ms 604ms [ User: intelifix - Total duration: 1m35s - Times executed: 163 ]
[ Application: [unknown] - Total duration: 1m35s - Times executed: 163 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (039963) LIMIT 1;
Date: 2026-06-02 15:26:26 Duration: 4s560ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (039875) LIMIT 1;
Date: 2026-06-02 14:05:24 Duration: 3s871ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (039963) LIMIT 1;
Date: 2026-06-02 15:26:34 Duration: 3s544ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
6 162 29s200ms 150ms 404ms 180ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jun 02 01 1 165ms 165ms 08 1 150ms 150ms 10 2 465ms 232ms 11 1 159ms 159ms 12 2 386ms 193ms 13 2 335ms 167ms 14 22 4s122ms 187ms 15 39 6s899ms 176ms 16 72 12s916ms 179ms 17 20 3s598ms 179ms [ User: intelifix - Total duration: 29s200ms - Times executed: 162 ]
[ Application: [unknown] - Total duration: 29s200ms - Times executed: 162 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-06-02", "data-ate" : "2026-06-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-06-02 14:53:16 Duration: 404ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-06-02", "data-ate" : "2026-06-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-06-02 16:33:34 Duration: 343ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "312", "data-de" : "2026-06-02", "data-ate" : "2026-06-02", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 320 }');
Date: 2026-06-02 15:51:21 Duration: 335ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 144 26s608ms 150ms 336ms 184ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 02 00 2 318ms 159ms 04 20 3s664ms 183ms 05 8 1s406ms 175ms 07 9 1s706ms 189ms 08 13 2s374ms 182ms 09 15 2s927ms 195ms 10 15 2s699ms 179ms 11 14 2s647ms 189ms 12 8 1s420ms 177ms 14 17 3s226ms 189ms 15 19 3s442ms 181ms 16 4 774ms 193ms [ User: intelifix - Total duration: 26s608ms - Times executed: 144 ]
[ Application: [unknown] - Total duration: 26s608ms - Times executed: 144 ]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '229747917597,229806099213,229836720103,229750147691,216938224964,229689891531,229688379496,229785543245,229814273748,229808047382,229742641011,229669781016,229737717286,229782928690,229728563756,216944756566,229780801335,216937334866,229865655777,229738692747,229666797278', NULL, NULL, 0141, 00);
Date: 2026-06-02 09:45:30 Duration: 336ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241631730825,241614851927,241696882121,241707287479,241672826372,241610098904,241598642343,241674370003,241669416174,241622526278,241669680926,241649338692,241697523755,241677306888,241707297581,241698310409', NULL, NULL, 0320, 00);
Date: 2026-06-02 14:15:33 Duration: 265ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (409, 5, '113', 3, '241688955466,241601006366,241689427487,241688838181,230049292128,241703895869,241709689005,241661044246,241645512035,241682733243,241706743656,241669934362,241595788696,241658164964,241651175864,241651100123', NULL, NULL, 0320, 00);
Date: 2026-06-02 11:01:01 Duration: 264ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 137 7m57s 2s663ms 17s444ms 3s485ms call rs_giga_triagem (?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 02 00 6 25s815ms 4s302ms 01 6 17s917ms 2s986ms 02 6 17s515ms 2s919ms 03 5 15s785ms 3s157ms 04 6 17s3ms 2s833ms 05 6 18s106ms 3s17ms 06 6 17s850ms 2s975ms 07 6 34s73ms 5s678ms 08 6 23s139ms 3s856ms 09 6 23s149ms 3s858ms 10 6 19s277ms 3s212ms 11 6 21s344ms 3s557ms 12 6 18s630ms 3s105ms 13 6 19s310ms 3s218ms 14 6 22s53ms 3s675ms 15 6 23s187ms 3s864ms 16 6 20s688ms 3s448ms 17 6 20s926ms 3s487ms 18 6 18s161ms 3s26ms 19 6 17s918ms 2s986ms 20 6 26s536ms 4s422ms 21 6 19s98ms 3s183ms 22 6 20s36ms 3s339ms [ User: intelifix - Total duration: 7m57s - Times executed: 137 ]
[ Application: psql - Total duration: 7m57s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 07:15:22 Duration: 17s444ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 00:05:23 Duration: 10s583ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 20:05:10 Duration: 8s776ms Database: rio User: intelifix Remote: [local] Application: psql
9 101 5m42s 172ms 10s953ms 3s394ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 02 00 6 15s443ms 2s573ms 01 6 7s768ms 1s294ms 02 5 5s756ms 1s151ms 03 6 7s511ms 1s251ms 04 6 6s504ms 1s84ms 05 4 9s174ms 2s293ms 07 5 26s879ms 5s375ms 08 6 33s430ms 5s571ms 09 6 29s554ms 4s925ms 10 6 28s296ms 4s716ms 11 6 35s604ms 5s934ms 12 6 29s752ms 4s958ms 13 4 5s932ms 1s483ms 14 6 33s661ms 5s610ms 15 6 29s966ms 4s994ms 16 6 21s513ms 3s585ms 21 5 6s377ms 1s275ms 22 6 9s678ms 1s613ms [ User: intelifix - Total duration: 5m42s - Times executed: 101 ]
[ Application: psql - Total duration: 5m42s - Times executed: 101 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 14:55:12 Duration: 10s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 00:05:12 Duration: 10s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 11:55:10 Duration: 8s286ms Database: rio User: intelifix Remote: [local] Application: psql
10 81 13m31s 8s233ms 12s578ms 10s21ms create table temp0000281513 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 02 10 13 2m8s 9s851ms 11 14 2m20s 10s71ms 12 13 2m 9s307ms 14 18 3m8s 10s465ms 15 17 2m50s 10s29ms 16 6 1m2s 10s462ms [ User: intelifix - Total duration: 13m31s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 13m31s - Times executed: 81 ]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:41:10 Duration: 12s578ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:20:54 Duration: 12s406ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 16:22:46 Duration: 12s20ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 80 36s774ms 275ms 778ms 459ms 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 Jun 02 00 1 561ms 561ms 01 1 438ms 438ms 03 1 427ms 427ms 04 2 799ms 399ms 05 1 461ms 461ms 06 1 468ms 468ms 07 4 1s697ms 424ms 08 7 3s460ms 494ms 09 9 3s923ms 435ms 10 7 2s793ms 399ms 11 6 2s930ms 488ms 12 3 1s111ms 370ms 13 8 4s35ms 504ms 14 8 3s781ms 472ms 15 10 5s285ms 528ms 16 7 2s987ms 426ms 17 2 871ms 435ms 21 2 738ms 369ms [ User: lenon - Total duration: 36s774ms - Times executed: 80 ]
[ Application: [unknown] - Total duration: 36s774ms - Times executed: 80 ]
-
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-06-02 13:38:11 Duration: 778ms 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-06-02 11:27:11 Duration: 752ms 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-06-02 15:08:51 Duration: 718ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
12 75 42s272ms 349ms 851ms 563ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 02 00 1 777ms 777ms 01 1 575ms 575ms 04 2 920ms 460ms 05 1 581ms 581ms 07 4 2s37ms 509ms 08 6 3s717ms 619ms 09 9 4s783ms 531ms 10 7 3s488ms 498ms 11 6 3s462ms 577ms 12 3 1s367ms 455ms 13 7 4s324ms 617ms 14 8 4s589ms 573ms 15 10 6s232ms 623ms 16 7 3s874ms 553ms 17 2 1s55ms 527ms 21 1 485ms 485ms [ User: intelifix - Total duration: 42s272ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 42s272ms - Times executed: 75 ]
-
select * from rs_menu_grants (416, 81, 1);
Date: 2026-06-02 13:38:11 Duration: 851ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (503, 18, 1);
Date: 2026-06-02 08:05:07 Duration: 842ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (407, 18, 1);
Date: 2026-06-02 11:27:11 Duration: 827ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 73 3m7s 229ms 40s364ms 2s571ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 02 07 6 2s698ms 449ms 08 8 5s710ms 713ms 09 8 20s879ms 2s609ms 10 7 9s814ms 1s402ms 11 7 42s874ms 6s124ms 12 7 13s248ms 1s892ms 13 1 643ms 643ms 14 11 51s781ms 4s707ms 15 7 3s391ms 484ms 16 6 16s509ms 2s751ms 17 5 20s195ms 4s39ms [ User: intelifix - Total duration: 3m7s - Times executed: 73 ]
[ Application: psql - Total duration: 3m7s - Times executed: 73 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 504); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025060);
Date: 2026-06-02 11:02:35 Duration: 40s364ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025080);
Date: 2026-06-02 14:32:46 Duration: 25s81ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025078);
Date: 2026-06-02 14:26:42 Duration: 22s374ms Database: rio User: intelifix Remote: [local] Application: psql
14 70 25s213ms 270ms 534ms 360ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 02 07 3 952ms 317ms 08 4 1s371ms 342ms 09 7 2s684ms 383ms 10 7 2s412ms 344ms 11 8 2s710ms 338ms 12 5 1s646ms 329ms 13 2 734ms 367ms 14 7 2s805ms 400ms 15 8 2s733ms 341ms 16 11 4s333ms 393ms 17 8 2s829ms 353ms [ User: intelifix - Total duration: 25s213ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 25s213ms - Times executed: 70 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 029;
Date: 2026-06-02 16:11:58 Duration: 534ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-02 16:11:44 Duration: 528ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-06-02 15:53:57 Duration: 525ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 70 11s529ms 150ms 210ms 164ms select * from rs_modelos_lista (null, null) where mod_id = ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 02 08 9 1s497ms 166ms 09 3 493ms 164ms 10 6 1s3ms 167ms 11 7 1s161ms 165ms 12 1 160ms 160ms 13 1 168ms 168ms 14 14 2s302ms 164ms 15 24 3s916ms 163ms 16 4 666ms 166ms 17 1 158ms 158ms [ User: intelifix - Total duration: 11s529ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 11s529ms - Times executed: 70 ]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 0185;
Date: 2026-06-02 08:59:05 Duration: 210ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 046;
Date: 2026-06-02 14:09:07 Duration: 203ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_MODELOS_LISTA (NULL, NULL) WHERE MOD_ID = 039;
Date: 2026-06-02 11:47:54 Duration: 195ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 62 30s157ms 152ms 5s606ms 486ms create table temp0000281479 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 02 07 1 3s439ms 3s439ms 14 21 3s634ms 173ms 15 21 3s787ms 180ms 16 11 2s984ms 271ms 17 8 16s310ms 2s38ms [ User: intelifix - Total duration: 30s157ms - Times executed: 62 ]
[ Application: [unknown] - Total duration: 30s157ms - Times executed: 62 ]
-
CREATE TABLE temp0000281479 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 17:11:45 Duration: 5s606ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281479 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 17:20:18 Duration: 4s923ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281479 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 17:12:38 Duration: 4s447ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 57 14s599ms 154ms 538ms 256ms 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 Jun 02 08 3 1s141ms 380ms 09 9 2s921ms 324ms 10 6 1s532ms 255ms 11 12 3s120ms 260ms 13 5 1s12ms 202ms 14 5 1s172ms 234ms 15 11 2s404ms 218ms 16 4 801ms 200ms 17 2 491ms 245ms [ User: intelifix - Total duration: 14s599ms - Times executed: 57 ]
[ Application: [unknown] - Total duration: 14s599ms - Times executed: 57 ]
-
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 = 2471776 ORDER BY A.CAI_ORDEM;
Date: 2026-06-02 09:56:25 Duration: 538ms 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 = 2996050 ORDER BY A.CAI_ORDEM;
Date: 2026-06-02 08:55:29 Duration: 480ms 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 = 2995639 ORDER BY A.CAI_ORDEM;
Date: 2026-06-02 08:30:09 Duration: 472ms Database: rio User: intelifix Remote: [local] Application: [unknown]
18 55 17s352ms 150ms 4s4ms 315ms create table temp0000281499 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 02 08 6 5s496ms 916ms 09 6 1s874ms 312ms 10 12 3s704ms 308ms 12 2 325ms 162ms 13 6 988ms 164ms 14 10 1s915ms 191ms 15 13 3s47ms 234ms [ User: intelifix - Total duration: 17s352ms - Times executed: 55 ]
[ Application: [unknown] - Total duration: 17s352ms - Times executed: 55 ]
-
CREATE TABLE temp0000281499 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 08:27:54 Duration: 4s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281499 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"768", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 10:00:50 Duration: 431ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281499 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"768", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 10:19:36 Duration: 413ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 50 22s566ms 150ms 8s671ms 451ms create table temp0000281339 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 02 08 1 154ms 154ms 09 7 10s416ms 1s488ms 10 3 3s799ms 1s266ms 11 10 2s834ms 283ms 13 11 2s29ms 184ms 14 7 1s263ms 180ms 15 6 1s176ms 196ms 16 5 893ms 178ms [ User: intelifix - Total duration: 22s566ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 22s566ms - Times executed: 50 ]
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "104485", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-02 09:49:10 Duration: 8s671ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "242688", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-02 10:44:57 Duration: 3s346ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281339 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "108194", "oficina" : "6", "cliente" : "0", "nf" : "", "data-de" : "29-05-2026", "data-ate" : "01-07-2026", "grupo" : "0", "status" : "1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-06-02 11:37:10 Duration: 972ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 50 9s862ms 150ms 299ms 197ms select * from rs_lote_manutencao (?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 02 07 3 698ms 232ms 08 12 2s156ms 179ms 09 8 1s396ms 174ms 10 5 905ms 181ms 12 5 984ms 196ms 14 1 263ms 263ms 15 3 785ms 261ms 16 11 2s324ms 211ms 17 2 346ms 173ms [ User: intelifix - Total duration: 9s862ms - Times executed: 50 ]
[ Application: [unknown] - Total duration: 9s862ms - Times executed: 50 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"298", "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-06-02 15:52:47 Duration: 299ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"126", "usuario" :"320", "tipo" :"N", "itens" :"005", "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-06-02 07:29:27 Duration: 297ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO ('{ "id" :"0", "oficina" :"6", "cliente" :"5", "modelo" :"64", "usuario" :"320", "tipo" :"N", "itens" :"003", "nota-fiscal" :"1563", "arquivo" :"0", "conformidade" :"0", "status-acessorio":"0", "sem-serial" :"00", "status" :"0", "sem-nota" :"", "sucata" :"0", "novo" :"", "lote-stone" :"0", "preco" :"0"}');
Date: 2026-06-02 16:28:46 Duration: 286ms 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 2m3s 7m36s 4m50s 2 9m40s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 02 05 2 9m40s 4m50s [ User: intelifix - Total duration: 9m40s - Times executed: 2 ]
[ Application: psql - Total duration: 9m40s - Times executed: 2 ]
-
analyze verbose;
Date: 2026-06-02 05:07:38 Duration: 7m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-06-02 05:09:42 Duration: 2m3s Database: contagem User: intelifix Remote: [local] Application: psql
2 943ms 7m18s 3m5s 32 1h39m3s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 02 07 2 7m20s 3m40s 08 2 5m38s 2m49s 09 2 5m57s 2m58s 10 2 6m43s 3m21s 11 2 7m24s 3m42s 12 2 5m56s 2m58s 13 2 5m36s 2m48s 14 2 6m48s 3m24s 15 2 5m50s 2m55s 16 2 6m36s 3m18s 17 2 7m1s 3m30s 18 2 5m16s 2m38s 19 2 5m21s 2m40s 20 2 6m47s 3m23s 21 2 5m29s 2m44s 22 2 5m11s 2m35s [ User: intelifix - Total duration: 1h39m3s - Times executed: 32 ]
[ Application: psql - Total duration: 1h39m3s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-02 07:12:20 Duration: 7m18s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-02 11:12:16 Duration: 7m14s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-06-02 17:12:01 Duration: 6m59s Database: rio User: intelifix Remote: [local] Application: psql
3 1m29s 1m29s 1m29s 2 2m59s 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 Jun 02 20 1 1m29s 1m29s 23 1 1m29s 1m29s [ User: intelifix - Total duration: 2m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m59s - Times executed: 2 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-06-02 23:39:33 Duration: 1m29s 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-06-02 20:08:35 Duration: 1m29s Database: rio User: intelifix Remote: [local] Application: pg_dump
4 22s210ms 1m54s 1m8s 2 2m16s 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 Jun 02 23 2 2m16s 1m8s [ User: intelifix - Total duration: 2m16s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 2m16s - 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-06-02 23:14:47 Duration: 1m54s 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-06-02 23:41:06 Duration: 22s210ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
5 53s893ms 1m5s 59s773ms 2 1m59s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 02 20 1 1m5s 1m5s 23 1 53s893ms 53s893ms [ User: intelifix - Total duration: 1m59s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 2 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-02 20:05:26 Duration: 1m5s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-06-02 23:18:05 Duration: 53s893ms Database: rio User: intelifix Remote: [local] Application: pg_dump
6 20s128ms 1m34s 57s479ms 2 1m54s copy auditor.auditor_2026_03 (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 #6
Day Hour Count Duration Avg duration Jun 02 23 2 1m54s 57s479ms [ User: intelifix - Total duration: 1m54s - Times executed: 2 ]
[ Application: pg_dump - Total duration: 1m54s - Times executed: 2 ]
-
COPY auditor.auditor_2026_03 (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-06-02 23:11:38 Duration: 1m34s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY auditor.auditor_2026_03 (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-06-02 23:40:23 Duration: 20s128ms Database: contagem User: intelifix Remote: [local] Application: pg_dump
7 154ms 4m8s 27s107ms 248 1h52m2s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 02 07 21 11m21s 32s436ms 08 10 11m 1m6s 09 14 13m4s 56s58ms 10 27 8m12s 18s250ms 11 25 13m36s 32s652ms 12 8 11m49s 1m28s 13 14 55s997ms 3s999ms 14 37 15m29s 25s110ms 15 28 11m19s 24s258ms 16 45 11m2s 14s726ms 17 19 4m10s 13s174ms [ User: intelifix - Total duration: 1h52m2s - Times executed: 248 ]
[ Application: [unknown] - Total duration: 1h52m2s - Times executed: 248 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025096, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 16:26:58 Duration: 4m8s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025032, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 07:15:22 Duration: 4m Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 025090, 0320 )', '/var/www/html/tmp/nf_carga_lotes_0320.xlsx');
Date: 2026-06-02 15:51:14 Duration: 3m52s Database: rio User: intelifix Remote: [local] Application: [unknown]
8 437ms 44s681ms 17s467ms 32 9m18s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jun 02 07 2 45s506ms 22s753ms 08 2 31s476ms 15s738ms 09 2 31s858ms 15s929ms 10 2 41s207ms 20s603ms 11 2 45s361ms 22s680ms 12 2 29s721ms 14s860ms 13 2 29s224ms 14s612ms 14 2 34s903ms 17s451ms 15 2 45s643ms 22s821ms 16 2 36s215ms 18s107ms 17 2 36s856ms 18s428ms 18 2 27s553ms 13s776ms 19 2 28s829ms 14s414ms 20 2 40s27ms 20s13ms 21 2 27s233ms 13s616ms 22 2 27s327ms 13s663ms [ User: intelifix - Total duration: 9m18s - Times executed: 32 ]
[ Application: psql - Total duration: 9m18s - Times executed: 32 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-02 15:11:35 Duration: 44s681ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-02 07:13:04 Duration: 44s193ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-06-02 11:13:00 Duration: 43s843ms Database: rio User: intelifix Remote: [local] Application: psql
9 8s233ms 12s578ms 10s21ms 81 13m31s create table temp0000281513 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 02 10 13 2m8s 9s851ms 11 14 2m20s 10s71ms 12 13 2m 9s307ms 14 18 3m8s 10s465ms 15 17 2m50s 10s29ms 16 6 1m2s 10s462ms [ User: intelifix - Total duration: 13m31s - Times executed: 81 ]
[ Application: [unknown] - Total duration: 13m31s - Times executed: 81 ]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:41:10 Duration: 12s578ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:20:54 Duration: 12s406ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 16:22:46 Duration: 12s20ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 8s232ms 11s746ms 9s914ms 19 3m8s create table temp0000281483 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 02 08 6 1m1s 10s270ms 09 8 1m15s 9s430ms 10 5 51s320ms 10s264ms [ User: intelifix - Total duration: 3m8s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m8s - Times executed: 19 ]
-
CREATE TABLE temp0000281483 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 10:24:23 Duration: 11s746ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281483 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 09:01:49 Duration: 11s260ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281483 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:41:31 Duration: 11s209ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 7s741ms 12s159ms 9s879ms 38 6m15s create table temp0000281543 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 02 13 2 22s90ms 11s45ms 14 10 1m40s 10s41ms 15 3 27s996ms 9s332ms 16 12 2m2s 10s192ms 17 11 1m42s 9s329ms [ User: intelifix - Total duration: 6m15s - Times executed: 38 ]
[ Application: [unknown] - Total duration: 6m15s - Times executed: 38 ]
-
CREATE TABLE temp0000281543 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 13:56:55 Duration: 12s159ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281543 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 14:26:31 Duration: 11s970ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281543 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 16:23:55 Duration: 11s662ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 8s485ms 10s944ms 9s778ms 15 2m26s create table temp0000281525 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 02 10 3 30s379ms 10s126ms 11 6 59s330ms 9s888ms 12 6 56s970ms 9s495ms [ User: intelifix - Total duration: 2m26s - Times executed: 15 ]
[ Application: [unknown] - Total duration: 2m26s - Times executed: 15 ]
-
CREATE TABLE temp0000281525 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 10:54:36 Duration: 10s944ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281525 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 11:02:05 Duration: 10s666ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281525 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 11:02:19 Duration: 10s437ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 7s900ms 10s622ms 9s198ms 39 5m58s create table temp0000281469 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 02 07 15 2m9s 8s620ms 08 16 2m35s 9s688ms 09 8 1m14s 9s303ms [ User: intelifix - Total duration: 5m58s - Times executed: 39 ]
[ Application: [unknown] - Total duration: 5m58s - Times executed: 39 ]
-
CREATE TABLE temp0000281469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:04:44 Duration: 10s622ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:45:30 Duration: 10s477ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281469 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-06-02 08:20:59 Duration: 10s279ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3s76ms 6s57ms 4s252ms 33 2m20s create table temp0000281513 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 02 09 5 17s200ms 3s440ms 10 4 17s67ms 4s266ms 12 12 45s823ms 3s818ms 14 2 9s783ms 4s891ms 15 7 36s611ms 5s230ms 16 3 13s855ms 4s618ms [ User: intelifix - Total duration: 2m20s - Times executed: 33 ]
[ Application: [unknown] - Total duration: 2m20s - Times executed: 33 ]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 15:18:37 Duration: 6s57ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 15:52:53 Duration: 5s747ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000281513 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"28-05-2026", "ate" :"02-06-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-06-02 15:18:15 Duration: 5s720ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 808ms 13s324ms 4s233ms 45 3m10s call rs_tcia_processa_lotes ();Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 02 08 3 16s248ms 5s416ms 09 3 20s857ms 6s952ms 10 3 19s936ms 6s645ms 11 3 21s81ms 7s27ms 12 3 11s733ms 3s911ms 13 3 15s32ms 5s10ms 14 3 20s419ms 6s806ms 15 3 25s410ms 8s470ms 16 3 14s646ms 4s882ms 17 3 8s835ms 2s945ms 18 3 3s3ms 1s1ms 19 3 3s294ms 1s98ms 20 3 3s314ms 1s104ms 21 3 3s603ms 1s201ms 22 3 3s108ms 1s36ms [ User: intelifix - Total duration: 3m10s - Times executed: 45 ]
[ Application: psql - Total duration: 3m10s - Times executed: 45 ]
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-02 15:40:15 Duration: 13s324ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-02 11:40:13 Duration: 12s217ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_TCIA_PROCESSA_LOTES ();
Date: 2026-06-02 08:20:13 Duration: 12s95ms Database: rio User: intelifix Remote: [local] Application: psql
16 2s663ms 17s444ms 3s485ms 137 7m57s call rs_giga_triagem (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 02 00 6 25s815ms 4s302ms 01 6 17s917ms 2s986ms 02 6 17s515ms 2s919ms 03 5 15s785ms 3s157ms 04 6 17s3ms 2s833ms 05 6 18s106ms 3s17ms 06 6 17s850ms 2s975ms 07 6 34s73ms 5s678ms 08 6 23s139ms 3s856ms 09 6 23s149ms 3s858ms 10 6 19s277ms 3s212ms 11 6 21s344ms 3s557ms 12 6 18s630ms 3s105ms 13 6 19s310ms 3s218ms 14 6 22s53ms 3s675ms 15 6 23s187ms 3s864ms 16 6 20s688ms 3s448ms 17 6 20s926ms 3s487ms 18 6 18s161ms 3s26ms 19 6 17s918ms 2s986ms 20 6 26s536ms 4s422ms 21 6 19s98ms 3s183ms 22 6 20s36ms 3s339ms [ User: intelifix - Total duration: 7m57s - Times executed: 137 ]
[ Application: psql - Total duration: 7m57s - Times executed: 137 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 07:15:22 Duration: 17s444ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 00:05:23 Duration: 10s583ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-06-02 20:05:10 Duration: 8s776ms Database: rio User: intelifix Remote: [local] Application: psql
17 172ms 10s953ms 3s394ms 101 5m42s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 02 00 6 15s443ms 2s573ms 01 6 7s768ms 1s294ms 02 5 5s756ms 1s151ms 03 6 7s511ms 1s251ms 04 6 6s504ms 1s84ms 05 4 9s174ms 2s293ms 07 5 26s879ms 5s375ms 08 6 33s430ms 5s571ms 09 6 29s554ms 4s925ms 10 6 28s296ms 4s716ms 11 6 35s604ms 5s934ms 12 6 29s752ms 4s958ms 13 4 5s932ms 1s483ms 14 6 33s661ms 5s610ms 15 6 29s966ms 4s994ms 16 6 21s513ms 3s585ms 21 5 6s377ms 1s275ms 22 6 9s678ms 1s613ms [ User: intelifix - Total duration: 5m42s - Times executed: 101 ]
[ Application: psql - Total duration: 5m42s - Times executed: 101 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 14:55:12 Duration: 10s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 00:05:12 Duration: 10s953ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-06-02 11:55:10 Duration: 8s286ms Database: rio User: intelifix Remote: [local] Application: psql
18 229ms 40s364ms 2s571ms 73 3m7s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 02 07 6 2s698ms 449ms 08 8 5s710ms 713ms 09 8 20s879ms 2s609ms 10 7 9s814ms 1s402ms 11 7 42s874ms 6s124ms 12 7 13s248ms 1s892ms 13 1 643ms 643ms 14 11 51s781ms 4s707ms 15 7 3s391ms 484ms 16 6 16s509ms 2s751ms 17 5 20s195ms 4s39ms [ User: intelifix - Total duration: 3m7s - Times executed: 73 ]
[ Application: psql - Total duration: 3m7s - Times executed: 73 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 504); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025060);
Date: 2026-06-02 11:02:35 Duration: 40s364ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025080);
Date: 2026-06-02 14:32:46 Duration: 25s81ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 506); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (025078);
Date: 2026-06-02 14:26:42 Duration: 22s374ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 5s516ms 729ms 1,261 15m19s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 02 07 6 2s186ms 364ms 08 101 1m8s 676ms 09 171 2m16s 796ms 10 155 2m6s 815ms 11 126 1m50s 874ms 12 61 38s194ms 626ms 13 80 1m2s 781ms 14 159 1m54s 721ms 15 188 2m5s 669ms 16 169 1m42s 606ms 17 45 32s869ms 730ms [ User: intelifix - Total duration: 15m19s - Times executed: 1261 ]
[ Application: [unknown] - Total duration: 15m19s - Times executed: 1261 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39862, 417, 'ZTE3ANNR1Y27444,14CA56CF2DB3,14CA56CF2DB4,ZTEGD970E18F$ZTE3ANNQ4N06461,3CF9F0A9291C,3CF9F0A9291D,ZTEGD6411C38$ZTE3ANNR7B16390,3891484A6CCB,3891484A6CCC,ZTEGDB07D166$ZTE3ANNR8C09210,3891484F5EE3,3891484F5EE4,ZTEGDB08A46A$ZTE3ANNR4N05454,4896D955DAEC,4896D955DAED,ZTEGD97F3513$ZTE3ANNR1Y02237,14CA56CCDEE9,14CA56CCDEEA,ZTEGD9707F18$ZTE3ANNR6R55143,48D6823A912C,48D6823A912D,ZTEGDB02023A$ZTE3ANNRCP00019,6C11BA692B41,6C11BA692B42,ZTEGDC6F40A6$ZTE3ANNQ4N02626,3CF9F0A8CF3A,3CF9F0A8CF3B,ZTEGD6410D3D$ZTE3ANNR8C34719,38914851B4C1,38914851B4C2,ZTEGDB09080F$ZTE3ANNQ8F13526,689E29FD5FE1,689E29FD5FE2,ZTEGD7BA31A6$ZTE3ANNT2V11840,D831398CA458,D831398CA459,ZTEGDD3020BF$ZTE3ANNRC552235,6C11BA66F219,6C11BA66F21A,ZTEGDC6EE1CA$ZTE3ANNQ8125007,689E29BE28E5,689E29BE28E6,ZTEGD7B79C3F$ZTE3ANNRB747463,5872C992919B,5872C992919C,ZTEGDC61E43A$ZTE3ANNR5W76168,48D682357CFA,48D682357CFB,ZTEGDB012987$ZTE3ANNR7B32689,3891484BEACD,3891484BEACE,ZTEGDB081111$ZTE3ANNR9W44961,D89A0DAC79E9,D89A0DAC79EA,ZTEGDB16C14C$ZTE3ANNQ3607541,3CF9F0A5862C,3CF9F0A5862D,ZTEGD6408110$ZTE3ANNT3H64282,D831399CA634,D831399CA635,ZTEGDD32CBB9$ZTE3ANNT3F11556,D83139963AA0,D83139963AA1,ZTEGDD31B9CB$ZTE3ANNQ7108227,C4EBFF8A893A,C4EBFF8A893B,ZTEGD70A3CF5$ZTE3ANNT3F11502,D8313996395C,D8313996395D,ZTEGDD31B995$ZTE3ANNQ9345476,843C9936BF15,843C9936BF16,ZTEGD7BC6D9B$ZTE3ANNQ8111271,689E29BCE6F5,689E29BCE6F6,ZTEGD7B76697$ZTE3ANNQ4A03429,3CF9F0AA48A4,3CF9F0AA48A5,ZTEGD6414C24$ZTE3ANNR4N12844,4896D9568820,4896D9568821,ZTEGD97F51F1$ZTE3ANNT3H17673,D831399861CE,D831399861CF,ZTEGDD3215A8$ZTE3ANNQ4407976,3CF9F0AC19CE,3CF9F0AC19CF,ZTEGD64199AB$ZTE3ANNT3H17740,D83139986360,D83139986361,ZTEGDD3215EB$ZTE3ANNRC556456,6C11BA675507,6C11BA675508,ZTEGDC6EF247$ZTE3ANNR9329709,D89A0D851859,D89A0D85185A,ZTEGDB14E80C$ZTE3ANNR8C28098,389148511993,389148511994,ZTEGDB08EE32$ZTE3ANNR8C24166,38914850BD6B,38914850BD6C,ZTEGDB08DED6$ZTE3ANNT3H44810,D831399ADDD4,D831399ADDD5,ZTEGDD327FA9$ZTE3ANNR9W44658,D89A0DAC72CF,D89A0DAC72D0,ZTEGDB16C01D$ZTE3ANNRC575839,6C11BA691B51,6C11BA691B52,ZTEGDC6F3DFE$ZTE3ANNT3H17016,D83139985268,D83139985269,ZTEGDD321317$ZTE3ANNR9319663,D89A0D842CE5,D89A0D842CE6,ZTEGDB14C0CE$ZTE3ANNR3Y24990,4896D9520A6C,4896D9520A6D,ZTEGD97E9253', '',0323,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 11:35:07 Duration: 5s516ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (247905, 320, 'ZTE3ANNR9W23515,D89A0DAA8345,D89A0DAA8346,ZTEGDB166D86$ZTE3ANNRCB37330,D831392139EA,D831392139EB,ZTEGDD2A4767$ZTE3ANNRCP29846,6C11BA6BE653,6C11BA6BE654,ZTEGDC6FB529$ZTE3ANNQ5214935,3CF9F0A88920,3CF9F0A88921,ZTEGD641018E$ZTE3ANNQCA32918,14CA56D5485F,14CA56D54860,ZTEGD971E601$ZTE3ANNR9W37471,D89A0DABCA5D,D89A0DABCA5E,ZTEGDB16A40A$ZTE3ANNRAM56335,5872C98C6093,5872C98C6094,ZTEGDC60DC0E$ZTE3ANNRCP43134,6C11BA6D1DC3,6C11BA6D1DC4,ZTEGDC6FE911$ZTE3ANNRCB75661,D8313924BC4C,D8313924BC4D,ZTEGDD2ADD22$ZTE3ANNR1Y37934,14CA56D0238F,14CA56D02390,ZTEGD9710A89', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""}]','$$$$$$$$$','', 00);
Date: 2026-06-02 08:11:29 Duration: 4s795ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (39858, 407, '836051908001193,241730920202,241729919105,241645716274,241668281025,241676721523,241617428193,241704674565,241614453246,241732171929,241701730406,241594958807,241698709415,241713741219,241729506483,241728659194,241732088182,241659730819,241658526267,241706782526,241649677592,230048410314,241646262647,241712107175,241731227986,241727082532,241654642735,241695561521,241728734455,241695552025,241698725454,241729942138,241673350824,241727260709,241727037375,241708860305,241708933645,241654549011,241660140309,241695637689,241620729010,241656785974,241728691926,241673350420,241599254052,241676720311,241713365671,241676680206,241729907588,241680295070,230048410011', '',0321,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""},{"item":"40","qrcode":""},{"item":"41","qrcode":""},{"item":"42","qrcode":""},{"item":"43","qrcode":""},{"item":"44","qrcode":""},{"item":"45","qrcode":""},{"item":"46","qrcode":""},{"item":"47","qrcode":""},{"item":"48","qrcode":""},{"item":"49","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-06-02 10:24:34 Duration: 4s258ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 157ms 4s560ms 584ms 163 1m35s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 02 07 21 10s247ms 487ms 08 3 919ms 306ms 09 2 1s518ms 759ms 10 13 7s582ms 583ms 11 16 6s338ms 396ms 13 18 5s540ms 307ms 14 29 20s775ms 716ms 15 14 15s278ms 1s91ms 16 30 16s825ms 560ms 17 17 10s283ms 604ms [ User: intelifix - Total duration: 1m35s - Times executed: 163 ]
[ Application: [unknown] - Total duration: 1m35s - Times executed: 163 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (039963) LIMIT 1;
Date: 2026-06-02 15:26:26 Duration: 4s560ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (039875) LIMIT 1;
Date: 2026-06-02 14:05:24 Duration: 3s871ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (039963) LIMIT 1;
Date: 2026-06-02 15:26:34 Duration: 3s544ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jun 02 08 1 0ms 0ms 14 1 0ms 0ms 19 1 0ms 0ms [ User: intelifix - Total duration: 5m22s - Times executed: 3 ]
[ Application: psql - Total duration: 5m21s - Times executed: 1 ]
[ Application: [unknown] - Total duration: 1s123ms - Times executed: 2 ]
-
;
Date: Duration: 0ms Database: postgres User: rio Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 13,748 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 423 FATAL entries
- 1780 ERROR entries
- 0 WARNING entries
- 6 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,766 Max number of times the same event was reported
- 2,209 Total events found
Rank Times reported Error 1 1,766 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 02 07 48 08 191 09 321 10 273 11 246 12 74 13 92 14 171 15 182 16 144 17 24 - ERROR: prepared statement "_PLAN0000000029366790" does not exist
- ERROR: prepared statement "_PLAN0000000029DA2E90" does not exist
- ERROR: prepared statement "_PLAN000000003292F050" does not exist
Statement: DEALLOCATE "_PLAN0000000029366790"
Date: 2026-06-02 07:37:58 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000029DA2E90"
Date: 2026-06-02 07:42:38 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003292F050"
Date: 2026-06-02 07:43:20 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 411 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 02 00 19 01 14 02 14 03 13 04 14 05 19 06 16 07 18 08 19 09 20 10 19 11 19 12 19 13 19 14 19 15 20 16 19 17 19 18 19 19 16 20 17 21 20 22 19 23 1 - FATAL: database "brasilia" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "brasilia" does not exist
Date: 2026-06-02 00:02:03 Database: brasilia Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-02 00:02:03 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-06-02 00:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
3 7 FATAL: database "..." does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 02 18 1 19 3 20 3 - FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
- FATAL: database "brasilia" does not exist /usr/lib/python3.9/site-packages/urllib3/connectionpool.py:1018: InsecureRequestWarning: Unverified HTTPS request is being made to host 'homol.tcia.com.br'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings warnings.warn(
Date: 2026-06-02 18:35:32 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-02 19:15:20 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-06-02 19:35:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
4 5 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 02 08 3 10 2 - ERROR: column "d833b7a4438c" does not exist at character 27
- ERROR: column "d833b7a4438c" does not exist at character 27
- ERROR: column "d833b7a4438c" does not exist at character 27
Statement: SELECT * FROM RS_ETIQUETA(D833B7A4438C)
Date: 2026-06-02 08:04:37 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(D833B7A4438C)
Date: 2026-06-02 08:04:37 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(D833B7A4438C)
Date: 2026-06-02 08:04:37 Database: rio Application: [unknown] User: etiquetas Remote: [local]
5 4 LOG: process ... still waiting for ShareLock on transaction ... after ... ms
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 02 07 1 10 1 15 2 - LOG: process 3831974 still waiting for ShareLock on transaction 397738 after 1000.185 ms
- LOG: process 3981548 still waiting for ShareLock on transaction 413846 after 1000.226 ms
- LOG: process 72453 still waiting for ShareLock on transaction 439882 after 1000.149 ms
Detail: Process holding the lock: 3834590. Wait queue: 3831974.
Context: while updating tuple (68922,3) 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-06-02 07:15:09 Database: rio Application: psql User: intelifix Remote: [local]
Detail: Process holding the lock: 3985153. Wait queue: 3981548.
Context: while updating tuple (1,82) in relation "usuarios" SQL statement "UPDATE USUARIOS SET EQ_CODIGO = NULL, USU_CHECK_IN = NULL WHERE USU_ID = nUser" PL/pgSQL function rs_tecnico_check_out(integer) line 28 at SQL statement SQL statement "SELECT RS_TECNICO_CHECK_OUT( nTecnico )" PL/pgSQL function rs_baixa(integer,integer,integer,integer,character varying,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1129 at PERFORM PL/pgSQL function rs_fluxo_encerra(integer,integer,boolean) line 169 at assignment PL/pgSQL function rs_cria_fluxo_fechado(integer,character varying,integer,boolean) line 94 at assignment PL/pgSQL function rs_lote_manutencao_itens(integer,integer,character varying,character varying,integer,integer,character varying,character varying,character varying,integer) line 1095 at assignment
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(39860,417,'ZTEEH7VP6E02100,C0515CAFE49E$ZTEEH7VP6E02182,C0515CAFE5E6','',0317,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""}]','$','',00);Date: 2026-06-02 10:24:33 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Detail: Process holding the lock: 47362. Wait queue: 72453.
Context: while updating tuple (68861,168) in relation "nf_entrada_itens" SQL statement "UPDATE NF_ENTRADA_ITENS SET LI_ID = NULL WHERE LI_ID = ANY( aLIs )" PL/pgSQL function rs_exclui_seriais(character varying) line 59 at SQL statement PL/Python function "rs_fast_excel"
Statement: SELECT * FROM RS_FAST_EXCEL( 'SELECT * FROM rs_exclui_seriais(''/var/www/html/uploads/Exclusão ATOP 1.xlsx'') ;' , '/var/www/html/tmp/temp_83.xlsx' )Date: 2026-06-02 15:54:03 Database: rio Application: [unknown] User: intelifix Remote: [local]
6 3 ERROR: trailing junk after numeric literal at or near "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Jun 02 15 3 - ERROR: trailing junk after numeric literal at or near "828204P30000496" at character 27
- ERROR: trailing junk after numeric literal at or near "828204P30000496" at character 27
- ERROR: trailing junk after numeric literal at or near "828204P30000496" at character 27
Statement: SELECT * FROM RS_ETIQUETA(828204P30000496)
Date: 2026-06-02 15:18:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(828204P30000496)
Date: 2026-06-02 15:18:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: SELECT * FROM RS_ETIQUETA(828204P30000496)
Date: 2026-06-02 15:18:12 Database: rio Application: [unknown] User: etiquetas Remote: [local]
7 2 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Jun 02 03 2 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-06-02 03:05:01 Database: contagem Application: [unknown] User: intelifix Remote: [local]
Context: PL/pgSQL function rs_giga_processa_arquivos() line 60 at FOR over SELECT rows
Statement: CALL RS_GIGA_PROCESSA_ARQUIVOS()Date: 2026-06-02 03:05:02 Database: rio Application: psql User: intelifix Remote: [local]
8 2 ERROR: could not connect to server "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Jun 02 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-06-02 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-06-02 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 Jun 02 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-06-02 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-06-02 05:30:16 Database: contagem Application: psql User: intelifix Remote: [local]
10 1 LOG: process ... still waiting for AccessExclusiveLock on relation ... of database ... after ... ms
Times Reported Most Frequent Error / Event #10
Day Hour Count Jun 02 14 1 - LOG: process 4169983 still waiting for AccessExclusiveLock on relation 665487 of database 358220 after 1000.083 ms
Detail: Process holding the lock: 4190745. Wait queue: 4169983.
Statement: DROP TABLE IF EXISTS temp0000281513;Date: 2026-06-02 14:40:58 Database: rio Application: [unknown] User: intelifix Remote: [local]
11 1 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Jun 02 14 1 - ERROR: syntax error at or near ""},{"" at character 81
Statement: SELECT * FROM RS_LOTE_CONSISTE_SERIAL( '{"lote":"248014","seriais":[{"serial":"'"},{"serial":""}]}')
Date: 2026-06-02 14:01:26 Database: rio Application: [unknown] User: intelifix Remote: [local]
12 1 ERROR: canceling autovacuum task
Times Reported Most Frequent Error / Event #12
Day Hour Count Jun 02 14 1 - ERROR: canceling autovacuum task
Context: automatic vacuum of table "rio.public.temp0000281513"
Date: 2026-06-02 14:40:58
13 1 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #13
Day Hour Count Jun 02 03 1 - FATAL: the database system is shutting down
Date: 2026-06-02 03:05:02 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
14 1 FATAL: database "..." does not exist NOTICE: table "..." does not exist, skipping
Times Reported Most Frequent Error / Event #14
Day Hour Count Jun 02 15 1 - FATAL: database "brasilia" does not exist NOTICE: table "tmp_entrada" does not exist, skipping
Date: 2026-06-02 15:05:31 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
15 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #15
Day Hour Count Jun 02 03 1 - FATAL: canceling authentication due to timeout
Date: 2026-06-02 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
16 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #16
Day Hour Count Jun 02 03 1 - LOG: database system was shut down at 2026-06-02 03:05:02 -03
Date: 2026-06-02 03:05:03