pgBadger-
Global information
- Generated on Wed Jul 29 23:50:11 2026
- Log file: /usr/local/pgsql/data/log/serverlog-01.log, ..., /usr/local/pgsql/data/log/serverlog-31.log
- Parsed 41,327 log entries in 10s
- Log start from 2026-07-29 00:02:19 to 2026-07-29 23:49:54
-
Overview
Global Stats
- 359 Number of unique normalized queries
- 6,100 Number of queries
- 7h50m24s Total query duration
- 2026-07-29 00:02:19 First query
- 2026-07-29 23:45:01 Last query
- 5 queries/s at 2026-07-29 10:47:02 Query peak
- 7h50m24s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7h50m24s Execute total duration
- 3,921 Number of events
- 11 Number of unique normalized events
- 3,790 Max number of times the same event was reported
- 0 Number of cancellation
- 453 Total number of automatic vacuums
- 910 Total number of automatic analyzes
- 10 Number temporary file
- 237.47 MiB Max size of temporary file
- 110.41 MiB Average size of temporary file
- 363 Total number of sessions
- 9 sessions at 2026-07-29 01:05:01 Session peak
- 13d9h41m51s Total duration of sessions
- 53m10s Average duration of sessions
- 16 Average queries per session
- 1m17s Average queries duration per session
- 51m52s Average idle time per session
- 367 Total number of connections
- 4 connections/s at 2026-07-29 23:45:01 Connection peak
- 3 Total number of databases
SQL Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-29 10:47:02 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-07-29 10:47:02 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2026-07-29 23:43:52 Date
Queries duration
Key values
- 7h50m24s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 29 00 28 0ms 16s929ms 4s553ms 30s740ms 1m9s 1m9s 01 29 0ms 3s816ms 1s178ms 5s609ms 5s650ms 5s974ms 02 18 0ms 4s79ms 1s774ms 6s191ms 6s501ms 6s501ms 03 20 0ms 4s384ms 1s705ms 5s749ms 8s214ms 8s214ms 04 20 0ms 4s20ms 1s563ms 6s348ms 6s348ms 6s348ms 05 29 0ms 8m36s 36s626ms 2m33s 4m1s 8m36s 06 21 0ms 16s511ms 3s624ms 26s756ms 29s732ms 29s732ms 07 196 0ms 7m39s 7s527ms 41s254ms 4m2s 7m39s 08 631 150ms 6m50s 3s364ms 1m6s 4m59s 6m52s 09 719 150ms 8m37s 4s475ms 1m33s 5m54s 11m11s 10 613 150ms 8m8s 3s497ms 50s220ms 5m1s 8m12s 11 598 150ms 8m53s 3s582ms 1m1s 4m24s 9m6s 12 223 0ms 8m13s 6s973ms 54s945ms 4m3s 9m3s 13 337 0ms 6m4s 2s963ms 17s765ms 46s302ms 7m3s 14 707 150ms 8m40s 3s117ms 59s322ms 4m45s 8m45s 15 729 150ms 8m48s 3s780ms 1m48s 5m49s 9m20s 16 408 0ms 8m3s 3s381ms 38s97ms 47s769ms 9m33s 17 238 0ms 6m46s 4s348ms 24s170ms 1m14s 6m56s 18 23 0ms 5m52s 27s928ms 4s40ms 49s321ms 5m52s 19 21 0ms 5m40s 29s5ms 4s14ms 47s316ms 5m40s 20 105 0ms 6m21s 11s417ms 1m1s 1m55s 6m21s 21 29 0ms 5m55s 22s10ms 5s585ms 46s874ms 5m55s 22 27 0ms 5m57s 25s333ms 6s308ms 51s829ms 5m57s 23 331 0ms 1m26s 6s114ms 1m6s 1m7s 1m26s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 29 00 6 0 5s328ms 0ms 1s16ms 30s740ms 01 11 0 357ms 236ms 860ms 1s76ms 02 0 0 0ms 0ms 0ms 0ms 03 2 0 494ms 0ms 0ms 988ms 04 2 0 460ms 0ms 921ms 921ms 05 9 0 341ms 0ms 924ms 988ms 06 5 0 5s527ms 0ms 878ms 26s756ms 07 132 0 9s301ms 4s499ms 15s624ms 5m41s 08 465 0 3s667ms 12s933ms 41s813ms 5m16s 09 532 0 4s170ms 13s551ms 1m8s 8m46s 10 476 0 4s49ms 10s848ms 49s909ms 5m46s 11 441 0 4s133ms 16s693ms 56s166ms 5m25s 12 131 0 9s725ms 2s404ms 11s10ms 5m9s 13 252 0 3s537ms 5s557ms 14s485ms 3m58s 14 496 0 3s365ms 10s785ms 21s807ms 6m23s 15 539 0 4s445ms 17s49ms 1m10s 7m1s 16 286 0 4s151ms 8s152ms 26s594ms 4m18s 17 153 0 6s313ms 7s559ms 22s633ms 4m14s 18 8 0 1m16s 0ms 0ms 3m31s 19 6 0 1m36s 0ms 0ms 3m14s 20 8 82 12s935ms 3s901ms 1m1s 3m28s 21 10 0 1m 0ms 0ms 3m20s 22 6 0 1m47s 0ms 0ms 3m55s 23 8 323 6s114ms 1m3s 1m6s 1m26s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 29 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 29 00 0 1 1.00 0.00% 01 0 3 3.00 0.00% 02 0 0 0.00 0.00% 03 0 1 1.00 0.00% 04 0 1 1.00 0.00% 05 0 3 3.00 0.00% 06 0 1 1.00 0.00% 07 0 14 14.00 0.00% 08 0 12 12.00 0.00% 09 0 18 18.00 0.00% 10 0 14 14.00 0.00% 11 0 15 15.00 0.00% 12 0 11 11.00 0.00% 13 0 10 10.00 0.00% 14 0 14 14.00 0.00% 15 0 10 10.00 0.00% 16 0 9 9.00 0.00% 17 0 5 5.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 1 1.00 0.00% 22 0 0 0.00 0.00% 23 0 2 2.00 0.00% Day Hour Count Average / Second Jul 29 00 15 0.00/s 01 9 0.00/s 02 6 0.00/s 03 15 0.00/s 04 8 0.00/s 05 7 0.00/s 06 13 0.00/s 07 22 0.01/s 08 19 0.01/s 09 27 0.01/s 10 22 0.01/s 11 21 0.01/s 12 14 0.00/s 13 21 0.01/s 14 21 0.01/s 15 20 0.01/s 16 22 0.01/s 17 15 0.00/s 18 10 0.00/s 19 9 0.00/s 20 13 0.00/s 21 12 0.00/s 22 10 0.00/s 23 16 0.00/s Day Hour Count Average Duration Average idle time Jul 29 00 9 1h1m 1h46s 01 14 1h51s 1h49s 02 9 1h20s 1h17s 03 14 17m20s 17m18s 04 7 1h1m17s 1h1m12s 05 8 54m31s 52m18s 06 7 58m19s 58m8s 07 14 54m5s 52m20s 08 21 58m37s 56m56s 09 24 49m12s 46m58s 10 24 54m46s 53m17s 11 21 51m22s 49m40s 12 20 52m55s 51m37s 13 14 55m41s 54m29s 14 21 56m42s 54m57s 15 22 53m41s 51m36s 16 21 49m39s 48m33s 17 18 56m48s 55m50s 18 16 58m11s 57m31s 19 9 1h52s 59m44s 20 12 46m19s 44m39s 21 10 1h13s 59m9s 22 12 1h29s 59m32s 23 16 39m59s 37m53s -
Connections
Established Connections
Key values
- 4 connections Connection Peak
- 2026-07-29 23:45:01 Date
Connections per database
Key values
- rio Main Database
- 367 connections Total
Connections per user
Key values
- intelifix Main User
- 367 connections Total
-
Sessions
Simultaneous sessions
Key values
- 9 sessions Session Peak
- 2026-07-29 01:05:01 Date
Histogram of session times
Key values
- 294 3600000-28800000ms duration
Sessions per database
Key values
- rio Main Database
- 363 sessions Total
Sessions per user
Key values
- intelifix Main User
- 363 sessions Total
Sessions per host
Key values
- [local] Main Host
- 363 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 46,806 buffers Checkpoint Peak
- 2026-07-29 00:09:50 Date
- 270.049 seconds Highest write time
- 0.099 seconds Sync time
Checkpoints Wal files
Key values
- 15 files Wal files usage Peak
- 2026-07-29 09:19:38 Date
Checkpoints distance
Key values
- 482.12 Mo Distance Peak
- 2026-07-29 09:19:38 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 29 00 59,823 718.139s 0.037s 718.234s 01 2,623 263.606s 0.036s 263.697s 02 1,929 193.875s 0.024s 193.932s 03 2,593 260.324s 0.045s 260.43s 04 1,941 194.779s 0.021s 194.837s 05 9,596 934.742s 0.059s 934.846s 06 6,461 388.764s 0.017s 388.819s 07 24,383 2,075.24s 0.227s 2,075.602s 08 73,228 3,121.462s 0.656s 3,122.335s 09 89,525 3,238.625s 0.826s 3,239.742s 10 67,740 3,238.62s 0.755s 3,239.615s 11 75,626 3,238.713s 0.663s 3,239.605s 12 40,584 2,197.096s 0.304s 2,197.561s 13 24,841 2,224.734s 0.306s 2,225.158s 14 63,847 3,238.759s 0.759s 3,239.765s 15 83,896 3,238.89s 0.63s 3,239.728s 16 41,113 2,918.632s 0.357s 2,919.136s 17 20,775 1,924.972s 0.253s 1,925.346s 18 1,272 133.685s 0.015s 133.733s 19 23 2.329s 0.003s 2.338s 20 635 95.26s 0.039s 95.319s 21 2,425 244.124s 0.026s 244.232s 22 2,310 232.149s 0.052s 232.264s 23 521 54.516s 0.02s 54.572s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 29 00 0 0 10 610 0.002s 0.007s 01 0 0 1 594 0.003s 0.009s 02 0 0 0 472 0.003s 0.006s 03 0 0 1 562 0.003s 0.007s 04 0 0 1 468 0.002s 0.006s 05 0 0 4 605 0.008s 0.007s 06 0 0 1 81 0.006s 0.003s 07 0 0 16 3,145 0.006s 0.012s 08 0 0 47 5,874 0.009s 0.012s 09 0 0 83 7,664 0.023s 0.012s 10 0 0 32 7,085 0.009s 0.012s 11 0 0 38 7,110 0.006s 0.012s 12 0 0 29 4,015 0.003s 0.012s 13 0 0 8 4,505 0.003s 0.012s 14 0 0 40 7,296 0.008s 0.012s 15 0 0 44 7,058 0.012s 0.012s 16 0 0 21 5,358 0.009s 0.012s 17 0 0 9 3,754 0.014s 0.012s 18 0 0 0 88 0.003s 0.005s 19 0 0 0 3 0.002s 0.001s 20 0 0 1 88 0.010s 0.003s 21 0 0 0 382 0.003s 0.009s 22 0 0 1 440 0.024s 0.031s 23 0 0 0 89 0.006s 0.006s Day Hour Count Avg time (sec) Jul 29 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 29 00 22,011.00 kB 70,084.14 kB 01 1,517.00 kB 31,878.22 kB 02 1,718.67 kB 15,069.00 kB 03 1,737.12 kB 3,953.12 kB 04 1,717.83 kB 3,154.17 kB 05 9,679.71 kB 16,230.29 kB 06 5,016.00 kB 15,298.33 kB 07 22,027.25 kB 42,392.58 kB 08 63,887.83 kB 86,786.75 kB 09 113,994.92 kB 186,606.17 kB 10 43,190.50 kB 109,212.25 kB 11 52,010.42 kB 103,105.25 kB 12 39,578.75 kB 123,111.08 kB 13 11,681.75 kB 47,176.17 kB 14 54,480.92 kB 71,257.00 kB 15 60,229.75 kB 127,754.67 kB 16 27,611.50 kB 70,470.83 kB 17 12,018.75 kB 32,926.58 kB 18 789.00 kB 15,135.60 kB 19 176.00 kB 10,948.00 kB 20 4,672.67 kB 10,044.67 kB 21 1,397.29 kB 6,553.86 kB 22 1,541.88 kB 3,814.75 kB 23 277.40 kB 2,372.00 kB -
Temporary Files
Size of temporary files
Key values
- 474.94 MiB Temp Files size Peak
- 2026-07-29 05:32:01 Date
Number of temporary files
Key values
- 2 per second Temp Files Peak
- 2026-07-29 05:32:08 Date
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 29 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 10 1.08 GiB 110.41 MiB 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 Queries generating the most temporary files (N)
Rank Count Total size Min size Max size Avg size Query 1 8 922.54 MiB 70.83 MiB 237.47 MiB 115.32 MiB refresh materialized view concurrently rs_mv_codigos_barra;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-29 05:32:09 Duration: 1m27s Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-29 05:32:01 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
2 2 181.52 MiB 90.76 MiB 90.76 MiB 90.76 MiB refresh materialized view concurrently rs_mv_equipamentos;-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-29 05:30:41 Duration: 39s724ms Database: rio User: intelifix Remote: [local] Application: psql
-
REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-29 05:30:38 Duration: 0ms Database: rio User: intelifix Remote: [local] Application: psql
Queries generating the largest temporary files
Rank Size Query 1 237.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 237.47 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:01 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 90.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-29 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 90.76 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;[ Date: 2026-07-29 05:30:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 78.40 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 78.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 78.32 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 70.90 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:09 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 70.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:07 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 70.83 MiB REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;[ Date: 2026-07-29 05:32:08 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
-
Vacuums
Vacuums / Analyzes Distribution
Key values
- 10.63 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database brasilia - 2026-07-29 09:05:16 Date
- 0 sec Highest CPU-cost analyze
Table
Database brasilia - Date
Average Autovacuum Duration
Key values
- 10.63 sec Highest CPU-cost vacuum
Table auditor.auditor_2026_07
Database brasilia - 2026-07-29 09:05:16 Date
Analyzes per table
Key values
- pg_catalog.pg_attribute (100) Main table analyzed (database rio)
- 910 analyzes Total
Table Number of analyzes rio.pg_catalog.pg_attribute 100 brasilia.pg_catalog.pg_attribute 58 rio.pg_catalog.pg_class 54 rio.pg_catalog.pg_type 45 rio.public.usuarios 41 contagem.public.usuarios 36 rio.pg_catalog.pg_index 31 contagem.pg_catalog.pg_attribute 29 rio.public.temp0000286822 29 rio.public.temp0000286862 27 brasilia.pg_catalog.pg_class 26 brasilia.pg_catalog.pg_type 24 rio.public.temp0000286820 24 rio.pg_catalog.pg_depend 24 rio.public.temp0000286816 23 rio.public.temp0000286790 22 brasilia.pg_catalog.pg_index 16 contagem.public.temp0000226698 15 rio.public.temp0000286794 14 rio.public.temp0000286810 14 brasilia.pg_catalog.pg_depend 14 contagem.public.temp0000226706 13 contagem.pg_catalog.pg_class 12 brasilia.public.usuarios 11 contagem.pg_catalog.pg_type 10 brasilia.public.temp0000237106 10 rio.public.temp0000286876 9 rio.public.temp0000285404 9 rio.public.temp0000286684 9 rio.public.temp0000286800 9 rio.public.temp0000286682 9 rio.public.temp0000286784 8 rio.public.temp0000286572 8 rio.public.temp0000286788 7 rio.public.temp0000286830 7 rio.public.tmp_drill_0175 7 contagem.pg_catalog.pg_index 6 rio.public.temp0000286666 6 rio.public.temp0000286872 5 rio.public.temp0000286808 5 brasilia.public.nf_entrada 5 rio.public.temp0000286802 4 rio.public.temp0000286798 4 rio.public.temp0000286860 4 rio.pg_catalog.pg_shdepend 4 rio.public.temp0000286812 4 contagem.pg_catalog.pg_depend 4 brasilia.pg_catalog.pg_shdepend 3 template1.pg_catalog.pg_shdepend 3 rio.public.temp0000286890 2 rio.public.temp0000286824 2 rio.public.temp0000286792 2 rio.public.temp0000286850 2 rio.public.temp0000286902 2 rio.public.temp0000286518 2 contagem.pg_catalog.pg_shdepend 2 brasilia.public.temp0000237084 2 rio.public.temp0000286844 1 rio.public.temp0000286818 1 brasilia.public.temp0000237092 1 rio.public.temp0000286912 1 rio.public.temp0000286882 1 brasilia.public.temp0000237066 1 rio.public.temp0000286806 1 brasilia.public.temp0000237070 1 brasilia.public.temp0000237058 1 brasilia.public.temp0000237082 1 brasilia.public.temp0000237076 1 brasilia.public.temp0000237074 1 brasilia.public.temp0000237122 1 contagem.public.temp0000226718 1 rio.public.tmp_drill_0302 1 rio.public.temp0000286878 1 rio.public.temp0000286894 1 contagem.public.temp0000226716 1 brasilia.public.temp0000237062 1 rio.public.temp0000286898 1 contagem.public.nf_entrada 1 brasilia.public.temp0000237118 1 rio.public.temp0000286846 1 contagem.public.temp0000226682 1 brasilia.public.temp0000237064 1 brasilia.public.temp0000237060 1 rio.public.temp0000286910 1 brasilia.public.temp0000237108 1 rio.public.temp0000286786 1 brasilia.public.temp0000237112 1 brasilia.public.temp0000237128 1 rio.public.temp0000286866 1 rio.public.temp0000286858 1 Total 910 Vacuums per table
Key values
- pg_catalog.pg_attribute (45) Main table vacuumed on database rio
- 453 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 45 36 0 0 0 0 0 20,689 5,602 8,304,597 306 7,304 contagem.public.usuarios 36 0 0 0 0 0 0 164 119 68,219 2 11 rio.pg_catalog.pg_class 32 23 0 0 0 0 0 4,902 1,553 2,215,799 77 331 rio.public.temp0000286822 29 0 0 0 0 0 0 16,538 1,914 3,335,976 0 0 rio.pg_catalog.pg_type 29 21 0 0 0 0 0 2,102 637 794,609 66 230 rio.public.temp0000286790 22 0 0 0 0 0 0 7,700 268 769,135 0 0 brasilia.pg_catalog.pg_attribute 22 19 0 0 0 0 0 9,838 2,189 3,789,999 56 1,401 rio.public.temp0000286820 22 0 0 0 0 0 0 10,484 83 632,237 0 0 rio.pg_catalog.pg_index 17 13 0 0 0 0 0 663 207 201,936 32 85 brasilia.pg_catalog.pg_class 15 12 0 0 0 0 0 2,365 459 854,177 27 77 rio.public.tmp_drill_0175 12 7 0 0 0 0 0 5,916 108 1,078,264 2 78 contagem.pg_catalog.pg_attribute 11 11 0 0 0 0 0 6,451 1,721 3,126,185 26 596 brasilia.pg_catalog.pg_index 10 7 0 0 0 0 0 401 88 92,302 11 15 rio.public.temp0000286862 10 0 0 0 0 0 0 4,026 54 246,136 0 0 rio.pg_catalog.pg_depend 10 10 0 0 0 0 0 3,010 1,166 1,659,249 54 537 brasilia.pg_catalog.pg_type 10 10 0 0 0 0 0 957 211 327,078 22 101 rio.public.temp0000286816 9 0 0 0 0 0 0 261 42 22,143 0 0 rio.public.temp0000285404 9 0 0 0 0 0 0 864 51 58,898 0 0 rio.public.temp0000286876 8 0 0 0 0 0 0 3,762 38 227,940 0 0 rio.public.temp0000286684 7 0 0 0 0 0 0 547 40 38,750 0 0 rio.pg_catalog.pg_statistic 7 7 0 0 0 0 0 8,885 2,054 8,849,901 946 4,029 rio.public.temp0000286830 6 0 0 0 0 0 0 5,166 24 308,587 0 0 rio.public.temp0000286682 6 0 0 0 0 0 0 487 30 33,565 0 0 rio.public.temp0000286808 5 0 0 0 0 0 0 3,392 1,703 2,371,813 0 0 brasilia.pg_catalog.pg_depend 5 5 0 0 0 0 0 1,290 390 592,320 10 71 rio.public.temp0000286572 5 0 0 0 0 0 0 468 30 32,115 0 0 brasilia.pg_catalog.pg_shdepend 5 5 0 0 0 0 0 724 209 335,625 38 74 contagem.pg_catalog.pg_class 5 5 0 0 0 0 0 879 169 278,986 6 25 rio.public.usuarios 4 4 0 0 0 0 0 141 43 79,394 15 30 contagem.pg_catalog.pg_type 4 4 0 0 0 0 0 424 89 157,358 1 2 rio.pg_toast.pg_toast_2619 3 3 0 0 0 0 0 1,582 280 1,466,077 93 305 contagem.pg_catalog.pg_index 3 3 0 0 0 0 0 134 22 38,166 0 0 contagem.pg_catalog.pg_depend 2 2 0 0 0 0 0 624 97 254,755 4 18 contagem.pg_catalog.pg_shdepend 2 2 0 0 0 0 0 261 77 152,072 11 30 brasilia.public.temp0000237084 2 0 0 0 0 0 0 255 12 19,411 0 0 rio.public.temp0000286798 2 0 0 0 0 0 0 160 12 11,242 0 0 brasilia.pg_catalog.pg_statistic 2 2 0 0 0 0 0 3,315 391 1,584,838 282 2,203 brasilia.pg_toast.pg_toast_2619 2 2 0 0 0 0 0 296 54 233,012 18 43 contagem.pg_catalog.pg_statistic 2 2 0 0 0 0 0 2,923 1,211 3,831,843 1,082 7,420 rio.public.temp0000286910 1 0 0 0 0 0 0 97 6 6,659 0 0 rio.public.temp0000286866 1 0 0 0 0 0 0 92 6 6,352 0 0 rio.public.tmp_drill_0302 1 1 0 0 0 0 0 260 3 49,215 0 0 brasilia.public.nf_entrada_itens 1 1 0 0 0 0 0 10,483 8,348 33,051,973 22 1,413 brasilia.auditor.auditor_2026_07 1 0 0 0 0 0 0 37,873 31,847 41,662,928 3,190 87,663 brasilia.public.nf_entrada_modelos 1 1 0 0 0 0 0 574 268 1,013,297 56 2,955 rio.public.temp0000286860 1 0 0 0 0 0 0 92 6 6,352 0 0 rio.public.temp0000286872 1 0 0 0 0 0 0 92 6 6,352 0 0 contagem.public.temp0000226716 1 0 0 0 0 0 0 106 6 7,208 0 0 brasilia.public.temp0000237062 1 0 0 0 0 0 0 244 242 383,624 0 0 rio.public.temp0000286806 1 0 0 0 0 0 0 8 6 3,045 0 0 rio.public.temp0000286518 1 0 0 0 0 0 0 8 5 1,305 0 0 rio.public.temp0000286824 1 0 0 0 0 0 0 82 6 5,743 0 0 contagem.pg_toast.pg_toast_2619 1 1 0 0 0 0 0 137 59 179,633 20 41 rio.public.nf_entrada_arquivo_erros 1 0 0 0 0 0 0 1,936 1,531 4,204,730 176 8,362 brasilia.public.temp0000237070 1 0 0 0 0 0 0 245 244 384,688 0 0 Total 453 219 0 0 0 0 0 185,375 66,036 129,447,813 6,651 125,450 Vacuum throughput per table
Key values
- auditor.auditor_2026_07 (10.63) Max CPU elapsed for vacuum on database brasilia
- unknown (0 ms) Max I/O read time for vacuum on database brasilia
- unknown (0 ms) Max I/O write time for vacuum on database brasilia
I/O timing (ms) CPU (s) Table read write elapsed rio.pg_catalog.pg_attribute 0 0 3.09 contagem.public.usuarios 0 0 0 rio.pg_catalog.pg_class 0 0 1 rio.public.temp0000286822 0 0 0.9 rio.pg_catalog.pg_type 0 0 0.31 rio.public.temp0000286790 0 0 0.45 brasilia.pg_catalog.pg_attribute 0 0 1.42 rio.public.temp0000286820 0 0 0.98 rio.pg_catalog.pg_index 0 0 0.14 brasilia.pg_catalog.pg_class 0 0 0.34 rio.public.tmp_drill_0175 0 0 0.21 contagem.pg_catalog.pg_attribute 0 0 0.97 brasilia.pg_catalog.pg_index 0 0 0.07 rio.public.temp0000286862 0 0 0.23 rio.pg_catalog.pg_depend 0 0 0.64 brasilia.pg_catalog.pg_type 0 0 0.12 rio.public.temp0000286816 0 0 0.19 rio.public.temp0000285404 0 0 0.12 rio.public.temp0000286876 0 0 0.25 rio.public.temp0000286684 0 0 0.12 rio.pg_catalog.pg_statistic 0 0 1.27 rio.public.temp0000286830 0 0 0.27 rio.public.temp0000286682 0 0 0.08 rio.public.temp0000286808 0 0 0.24 brasilia.pg_catalog.pg_depend 0 0 0.27 rio.public.temp0000286572 0 0 0.08 brasilia.pg_catalog.pg_shdepend 0 0 0.13 contagem.pg_catalog.pg_class 0 0 0.36 rio.public.usuarios 0 0 0.01 contagem.pg_catalog.pg_type 0 0 0.15 rio.pg_toast.pg_toast_2619 0 0 0.2 contagem.pg_catalog.pg_index 0 0 0.18 contagem.pg_catalog.pg_depend 0 0 0.11 contagem.pg_catalog.pg_shdepend 0 0 0.05 brasilia.public.temp0000237084 0 0 0.03 rio.public.temp0000286798 0 0 0.03 brasilia.pg_catalog.pg_statistic 0 0 0.27 brasilia.pg_toast.pg_toast_2619 0 0 0.05 contagem.pg_catalog.pg_statistic 0 0 0.25 rio.public.temp0000286910 0 0 0.02 rio.public.temp0000286866 0 0 0.02 rio.public.tmp_drill_0302 0 0 0.01 brasilia.public.nf_entrada_itens 0 0 3.82 brasilia.auditor.auditor_2026_07 0 0 10.63 brasilia.public.nf_entrada_modelos 0 0 0.12 rio.public.temp0000286860 0 0 0.01 rio.public.temp0000286872 0 0 0.01 contagem.public.temp0000226716 0 0 0.01 brasilia.public.temp0000237062 0 0 0.02 rio.public.temp0000286806 0 0 0.01 rio.public.temp0000286518 0 0 0.02 rio.public.temp0000286824 0 0 0.02 contagem.pg_toast.pg_toast_2619 0 0 0.02 rio.public.nf_entrada_arquivo_erros 0 0 0.72 brasilia.public.temp0000237070 0 0 0.02 Total 0 0 31.06 Tuples removed per table
Key values
- pg_catalog.pg_attribute (151928) Main table with removed tuples on database rio
- 462829 tuples Total removed
Index Tuples Pages Table Vacuums scans removed remain not yet removable removed remain rio.pg_catalog.pg_attribute 45 36 151,928 1,142,539 108,681 371 27,716 brasilia.pg_catalog.pg_attribute 22 19 90,471 480,336 18,972 82 12,625 rio.public.tmp_drill_0175 12 7 88,811 100,455 4,951 0 2,398 contagem.pg_catalog.pg_attribute 11 11 44,640 264,197 0 21 6,599 rio.pg_catalog.pg_statistic 7 7 12,221 58,966 453 0 9,002 brasilia.auditor.auditor_2026_07 1 0 10,961 4,749,820 0 0 207,081 rio.pg_catalog.pg_depend 10 10 9,665 188,411 4,336 0 1,790 rio.pg_catalog.pg_type 29 21 7,269 74,757 8,806 16 2,123 contagem.pg_catalog.pg_statistic 2 2 5,481 14,961 0 0 2,022 brasilia.pg_catalog.pg_statistic 2 2 5,216 15,417 0 0 2,144 rio.pg_catalog.pg_class 32 23 4,541 129,699 23,490 59 4,286 brasilia.pg_catalog.pg_shdepend 5 5 4,359 68,404 526 0 595 brasilia.pg_catalog.pg_type 10 10 4,338 22,028 0 4 685 brasilia.pg_catalog.pg_class 15 12 3,786 55,594 3,315 4 1,957 rio.pg_catalog.pg_index 17 13 2,846 35,825 3,107 0 937 brasilia.pg_catalog.pg_depend 5 5 2,582 91,618 2,958 0 913 brasilia.pg_catalog.pg_index 10 7 2,403 20,424 1,705 8 545 contagem.public.usuarios 36 0 2,209 863 9 0 72 contagem.pg_catalog.pg_shdepend 2 2 2,197 27,145 12 0 238 contagem.pg_catalog.pg_type 4 4 2,038 9,002 0 0 293 brasilia.public.nf_entrada_modelos 1 1 1,114 83,654 0 0 827 rio.pg_toast.pg_toast_2619 3 3 1,095 1,751 0 0 867 contagem.pg_catalog.pg_index 3 3 913 5,692 0 9 147 contagem.pg_catalog.pg_class 5 5 582 17,734 0 2 671 rio.public.usuarios 4 4 331 2,247 211 0 72 contagem.pg_catalog.pg_depend 2 2 281 37,821 0 0 358 brasilia.pg_toast.pg_toast_2619 2 2 187 265 0 11 112 brasilia.public.nf_entrada_itens 1 1 177 1,662,665 0 0 17,384 contagem.pg_toast.pg_toast_2619 1 1 103 115 0 7 49 rio.public.nf_entrada_arquivo_erros 1 0 84 8,588,980 0 0 154,412 rio.public.temp0000286808 5 0 0 119,017 0 0 8,640 rio.public.temp0000286910 1 0 0 1,615 0 39 89 rio.public.temp0000286684 7 0 0 35,160 0 239 785 rio.public.temp0000286830 6 0 0 120,476 0 51 8,717 rio.public.temp0000286822 29 0 0 332,332 0 790 23,722 rio.public.temp0000286866 1 0 0 1,522 0 44 84 brasilia.public.temp0000237084 2 0 0 6,307 0 38 474 rio.public.temp0000286572 5 0 0 19,199 0 148 428 rio.public.tmp_drill_0302 1 1 0 4,272 0 0 112 rio.public.temp0000286798 2 0 0 2,490 0 112 144 rio.public.temp0000286682 6 0 0 28,393 0 68 636 rio.public.temp0000286790 22 0 0 141,040 0 416 9,440 rio.public.temp0000286860 1 0 0 1,522 0 44 84 rio.public.temp0000286862 10 0 0 74,476 0 222 4,258 rio.public.temp0000286872 1 0 0 1,522 0 44 84 contagem.public.temp0000226716 1 0 0 1,284 0 30 98 rio.public.temp0000286816 9 0 0 80,300 0 276 5,612 rio.public.temp0000285404 9 0 0 40,863 0 300 916 brasilia.public.temp0000237062 1 0 0 3,149 0 20 236 rio.public.temp0000286806 1 0 0 1,260 0 56 72 rio.public.temp0000286876 8 0 0 101,455 0 174 7,250 rio.public.temp0000286518 1 0 0 1,449 0 49 79 rio.public.temp0000286824 1 0 0 1,310 0 54 74 rio.public.temp0000286820 22 0 0 435,057 0 180 31,436 brasilia.public.temp0000237070 1 0 0 3,153 0 19 237 Total 453 219 462,829 19,510,008 181,532 4,007 562,627 Pages removed per table
Key values
- public.temp0000286822 (790) Main table with removed pages on database rio
- 4007 pages Total removed
Table Number of vacuums Index scans Tuples removed Pages removed rio.public.temp0000286822 29 0 0 790 rio.public.temp0000286790 22 0 0 416 rio.pg_catalog.pg_attribute 45 36 151928 371 rio.public.temp0000285404 9 0 0 300 rio.public.temp0000286816 9 0 0 276 rio.public.temp0000286684 7 0 0 239 rio.public.temp0000286862 10 0 0 222 rio.public.temp0000286820 22 0 0 180 rio.public.temp0000286876 8 0 0 174 rio.public.temp0000286572 5 0 0 148 rio.public.temp0000286798 2 0 0 112 brasilia.pg_catalog.pg_attribute 22 19 90471 82 rio.public.temp0000286682 6 0 0 68 rio.pg_catalog.pg_class 32 23 4541 59 rio.public.temp0000286806 1 0 0 56 rio.public.temp0000286824 1 0 0 54 rio.public.temp0000286830 6 0 0 51 rio.public.temp0000286518 1 0 0 49 rio.public.temp0000286866 1 0 0 44 rio.public.temp0000286860 1 0 0 44 rio.public.temp0000286872 1 0 0 44 rio.public.temp0000286910 1 0 0 39 brasilia.public.temp0000237084 2 0 0 38 contagem.public.temp0000226716 1 0 0 30 contagem.pg_catalog.pg_attribute 11 11 44640 21 brasilia.public.temp0000237062 1 0 0 20 brasilia.public.temp0000237070 1 0 0 19 rio.pg_catalog.pg_type 29 21 7269 16 brasilia.pg_toast.pg_toast_2619 2 2 187 11 contagem.pg_catalog.pg_index 3 3 913 9 brasilia.pg_catalog.pg_index 10 7 2403 8 contagem.pg_toast.pg_toast_2619 1 1 103 7 brasilia.pg_catalog.pg_class 15 12 3786 4 brasilia.pg_catalog.pg_type 10 10 4338 4 contagem.pg_catalog.pg_class 5 5 582 2 rio.public.usuarios 4 4 331 0 contagem.pg_catalog.pg_depend 2 2 281 0 rio.public.temp0000286808 5 0 0 0 contagem.pg_catalog.pg_shdepend 2 2 2197 0 brasilia.pg_catalog.pg_depend 5 5 2582 0 rio.pg_catalog.pg_index 17 13 2846 0 rio.pg_toast.pg_toast_2619 3 3 1095 0 rio.public.tmp_drill_0175 12 7 88811 0 rio.public.tmp_drill_0302 1 1 0 0 brasilia.public.nf_entrada_itens 1 1 177 0 brasilia.auditor.auditor_2026_07 1 0 10961 0 brasilia.public.nf_entrada_modelos 1 1 1114 0 rio.pg_catalog.pg_depend 10 10 9665 0 contagem.public.usuarios 36 0 2209 0 brasilia.pg_catalog.pg_statistic 2 2 5216 0 contagem.pg_catalog.pg_statistic 2 2 5481 0 contagem.pg_catalog.pg_type 4 4 2038 0 rio.pg_catalog.pg_statistic 7 7 12221 0 rio.public.nf_entrada_arquivo_erros 1 0 84 0 brasilia.pg_catalog.pg_shdepend 5 5 4359 0 Total 453 219 462,829 4,007 Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 29 00 0 0 01 0 0 02 0 0 03 0 3 04 0 0 05 7 6 06 0 0 07 19 25 08 65 133 09 95 150 10 29 88 11 47 97 12 34 59 13 15 40 14 43 109 15 61 98 16 24 62 17 10 36 18 0 0 19 0 0 20 0 0 21 4 4 22 0 0 23 0 0 - 10.63 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 3,984 Total read queries
- 1,620 Total write queries
Queries by database
Key values
- rio Main database
- 3,874 Requests
- 5h52m18s (rio)
- Main time consuming database
Queries by user
Key values
- intelifix Main user
- 5,948 Requests
User Request type Count Duration etiquetas Total 35 11s549ms select 35 11s549ms intelifix Total 5,948 7h48m23s copy to 405 42m4s ddl 1,215 49m6s others 495 38m8s select 3,832 5h39m4s lenon Total 117 1m49s select 117 1m49s Duration by user
Key values
- 7h48m23s (intelifix) Main time consuming user
User Request type Count Duration etiquetas Total 35 11s549ms select 35 11s549ms intelifix Total 5,948 7h48m23s copy to 405 42m4s ddl 1,215 49m6s others 495 38m8s select 3,832 5h39m4s lenon Total 117 1m49s select 117 1m49s Queries by host
Key values
- [local] Main host
- 6,100 Requests
- 7h50m24s ([local])
- Main time consuming host
Queries by application
Key values
- [unknown] Main application
- 4,984 Requests
- 4h7m15s (psql)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-07-29 08:00:30 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,963 100-500ms duration
Slowest individual queries
Rank Duration Query 1 8m53s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 11:13:55 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
2 8m48s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 15:13:50 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
3 8m40s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 14:13:41 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
4 8m37s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 09:13:39 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
5 8m36s analyze verbose;[ Date: 2026-07-29 05:08:38 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
6 8m13s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 12:13:14 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
7 8m8s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 10:13:10 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
8 8m3s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 16:13:05 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
9 7m39s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 07:12:40 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
10 6m56s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-28'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');[ Date: 2026-07-29 15:06:21 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
11 6m50s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 08:11:52 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
12 6m46s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 17:11:47 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
13 6m21s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 20:11:22 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
14 6m15s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027785, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-29 14:31:29 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
15 6m4s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 13:11:06 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
16 5m57s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 22:10:58 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
17 5m55s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 21:10:57 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
18 5m52s SELECT * FROM RS_SMART_FISCAL_ENTRADA ();[ Date: 2026-07-29 18:10:54 - Database: rio - User: intelifix - Remote: [local] - Application: psql ]
19 5m51s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027757, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-29 09:19:03 - Database: rio - User: intelifix - Remote: [local] - Application: [unknown] ]
20 5m41s SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027775, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');[ Date: 2026-07-29 10:33:30 - 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 2h4m19s 48 1s304ms 8m53s 2m35s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 29 07 3 8m17s 2m45s 08 3 7m15s 2m25s 09 3 9m18s 3m6s 10 3 8m47s 2m55s 11 3 9m32s 3m10s 12 3 8m49s 2m56s 13 3 6m25s 2m8s 14 3 9m15s 3m5s 15 3 9m19s 3m6s 16 3 8m41s 2m53s 17 3 7m9s 2m23s 18 3 6m11s 2m3s 19 3 5m58s 1m59s 20 3 6m41s 2m13s 21 3 6m14s 2m4s 22 3 6m20s 2m6s [ User: intelifix - Total duration: 2h4m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h4m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 11:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 15:13:50 Duration: 8m48s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 14:13:41 Duration: 8m40s Database: rio User: intelifix Remote: [local] Application: psql
2 1h21m41s 275 152ms 6m56s 17s824ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 29 07 7 5m13s 44s841ms 08 44 11m18s 15s416ms 09 42 13m32s 19s339ms 10 29 11m15s 23s293ms 11 24 8m12s 20s532ms 12 8 5m17s 39s709ms 13 13 18s592ms 1s430ms 14 45 7m2s 9s397ms 15 39 18m24s 28s320ms 16 19 41s387ms 2s178ms 17 5 23s917ms 4s783ms [ User: intelifix - Total duration: 1h21m41s - Times executed: 275 ]
[ Application: [unknown] - Total duration: 1h21m41s - Times executed: 275 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-28'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-29 15:06:21 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027785, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-29 14:31:29 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027757, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-29 09:19:03 Duration: 5m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
3 1h15m57s 48 192ms 4m34s 1m34s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 29 07 3 5m1s 1m40s 08 3 4m33s 1m31s 09 3 5m38s 1m52s 10 3 5m32s 1m50s 11 3 5m12s 1m44s 12 3 4m45s 1m35s 13 3 4m25s 1m28s 14 3 5m33s 1m51s 15 3 5m6s 1m42s 16 3 4m52s 1m37s 17 3 4m58s 1m39s 18 3 4m2s 1m20s 19 3 3m43s 1m14s 20 3 4m19s 1m26s 21 3 3m48s 1m16s 22 3 4m24s 1m28s [ User: intelifix - Total duration: 1h15m57s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m57s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-29 14:19:45 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-29 10:19:15 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-29 09:19:48 Duration: 4m31s Database: brasilia User: intelifix Remote: [local] Application: psql
4 23m4s 1,603 150ms 5s517ms 863ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 29 07 45 43s293ms 962ms 08 161 1m31s 567ms 09 189 2m26s 774ms 10 253 3m35s 852ms 11 210 3m27s 990ms 12 39 25s221ms 646ms 13 90 1m25s 950ms 14 197 3m17s 1s 15 266 3m44s 845ms 16 118 1m47s 913ms 17 35 39s587ms 1s131ms [ User: intelifix - Total duration: 23m4s - Times executed: 1603 ]
[ Application: [unknown] - Total duration: 23m4s - Times executed: 1603 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272224, 450, 'ZTE3ANNR3Y19950,4896D951944C,4896D951944D,ZTEGD97E7EA3$ZTE3ANNR3J04711,F4E84F86BCCA,F4E84F86BCCB,ZTEGD97B7431$ZTE3ANNRCP46717,6C11BA6D71BD,6C11BA6D71BE,ZTEGDC6FF710$ZTE3ANNR6R26142,48D68237E976,48D68237E977,ZTEGDB0190F1$ZTE3ANNR8C37452,38914851F4CF,38914851F4D0,ZTEGDB0912BC$ZTE3ANNRAD22221,D89A0DAFE331,D89A0DAFE332,ZTEGDB1752D8$ZTE3ANNQ6M06062,C4EBFF88EFE4,C4EBFF88EFE5,ZTEGD709F8BC$ZTE3ANNR3J04380,F4E84F86B508,F4E84F86B509,ZTEGD97B72E6$ZTE3ANNT2V11932,D831398CA680,D831398CA681,ZTEGDD30211B$ZTE3ANNQ3621312,3CF9F0A6C8EE,3CF9F0A6C8EF,ZTEGD640B6DB$ZTE3ANNR1Y13968,14CA56CDF1DB,14CA56CDF1DC,ZTEGD970ACEB$ZTE3ANNR3Y19752,4896D9518FA8,4896D9518FA9,ZTEGD97E7DDD$ZTE3ANNR3J04335,F4E84F86B3FA,F4E84F86B3FB,ZTEGD97B72B9$ZTE3ANNQ7507690,C4EBFF8BA778,C4EBFF8BA779,ZTEGD70A6CAA$ZTE3ANNQ4N00785,3CF9F0A8A414,3CF9F0A8A415,ZTEGD641060C$ZTE3ANNQ6M06076,C4EBFF88F038,C4EBFF88F039,ZTEGD709F8CA$ZTE3ANNRCP63949,6C11BA6F059D,6C11BA6F059E,ZTEGDC703A60$ZTE3ANNR5W51282,48D6823335B6,48D6823335B7,ZTEGDB00C851$ZTE3ANNRCP62001,6C11BA6ED7F5,6C11BA6ED7F6,ZTEGDC7032C4$ZTE3ANNR7B16918,3891484A792B,3891484A792C,ZTEGDB07D376$ZTE3ANNQ6M07903,C4EBFF891B0A,C4EBFF891B0B,ZTEGD709FFED$ZTE3ANNQ3612242,3CF9F0A5F45A,3CF9F0A5F45B,ZTEGD640936D$ZTE3ANNT3H83171,D831399E60EA,D831399E60EB,ZTEGDD331582$ZTE3ANNR2Q28985,F4E84F835B56,F4E84F835B57,ZTEGD97AE3F3$ZTE3ANNRAM59429,5872C98CA917,5872C98CA918,ZTEGDC60E824$ZTE3ANNRCP64065,6C11BA6F0855,6C11BA6F0856,ZTEGDC703AD4$ZTE3ANNQ4414781,3CF9F0ACB94C,3CF9F0ACB94D,ZTEGD641B440$ZTE3ANNQ4414771,3CF9F0ACB910,3CF9F0ACB911,ZTEGD641B436$ZTE3ANNQ7L04512,C4EBFF8DEE68,C4EBFF8DEE69,ZTEGD70ACDD2$ZTE3ANNT3H69051,D831399D15FA,D831399D15FB,ZTEGDD32DE5A$ZTE3ANNQ3R00781,3CF9F0A29214,3CF9F0A29215,ZTEGD640030C$ZTE3ANNQ7T02838,C4EBFF8F2DC4,C4EBFF8F2DC5,ZTEGD70B030C$ZTE3ANNQ8M18668,843C99207D73,843C99207D74,ZTEGD7BA9059$ZTE3ANNRAM35107,5872C98A6F0B,5872C98A6F0C,ZTEGDC608922$ZTE3ANNQ7507538,C4EBFF8BA3E8,C4EBFF8BA3E9,ZTEGD70A6C12$ZTE3ANNQ3R00816,3CF9F0A292E6,3CF9F0A292E7,ZTEGD640032F$ZTE3ANNR1Y42943,14CA56D098F5,14CA56D098F6,ZTEGD9711E1A$ZTE3ANNR5W68593,48D68234CB70,48D68234CB71,ZTEGDB010BF0$ZTE3ANNRCB72648,D831392475AE,D831392475AF,ZTEGDD2AD15D$ZTE3ANNR9F40709,D89A0DA69801,D89A0DA69802,ZTEGDB15C650', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 11:26:53 Duration: 5s517ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48437, 417, '835100915001254,241667960208,241708795371,241728742436,241731031425,241630183939,241664845167,241704047073,241676641818,241732153139,241604349914,241657188392,241717171318,241634989515,241668151719,241604356379,241708747386,241617356873,241713294553,241731033647,241635007294,241714073350,241659722333,241598878202,241706864554,241731001624,241676779205,241646271133,241593128303,241704327785,241676776881,241622485163,241708874346,241713312737,241668249405,241593408183,241678342231,241680375459,241649712546,241676779609,241708891217,241731036677,241731221926,241676790722,241628278602,241659726676,241731013847', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 16:43:57 Duration: 5s142ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48527, 417, 'ZTE3ANNQ7T03108,C4EBFF8F3418,C4EBFF8F3419,ZTEGD70B041A$ZTE3ANNR1Y33595,14CA56CFBDDD,14CA56CFBDDE,ZTEGD970F996$ZTE3ANNT2V11716,D831398CA170,D831398CA171,ZTEGDD302043$ZTE3ANNT2V85827,D83139936A6A,D83139936A6B,ZTEGDD3141C2$ZTE3ANNRCP61611,6C11BA6ECED1,6C11BA6ECED2,ZTEGDC70313E$ZTE3ANNR9W21005,D89A0DAA4871,D89A0DAA4872,ZTEGDB1663B8$ZTE3ANNR2Q32929,F4E84F83B7C6,F4E84F83B7C7,ZTEGD97AF35B$ZTE3ANNR2Q00737,F4E84F80C546,F4E84F80C547,ZTEGD97A759B$ZTE3ANNR8C09926,3891484F6FAB,3891484F6FAC,ZTEGDB08A736$ZTE3ANNRCB62896,D8313923911E,D8313923911F,ZTEGDD2AAB45$ZTE3ANNR7B15305,3891484A535D,3891484A535E,ZTEGDB07CD29$ZTE3ANNR3J45472,F4E84F8A7820,F4E84F8A7821,ZTEGD97C136A$ZTE3ANNR8C09961,3891484F707D,3891484F707E,ZTEGDB08A759$ZTE3ANNQ4N01186,3CF9F0A8AD7A,3CF9F0A8AD7B,ZTEGD641079D$ZTE3ANNQ4N04182,3CF9F0A8F3B2,3CF9F0A8F3B3,ZTEGD6411351$ZTE3ANNRCB74459,D8313924A020,D8313924A021,ZTEGDD2AD870$ZTE3ANNQ7501445,C4EBFF8B151A,C4EBFF8B151B,ZTEGD70A5445$ZTE3ANNR8C39074,389148521AD3,389148521AD4,ZTEGDB091912$ZTE3ANNT3H68495,D831399D08F2,D831399D08F3,ZTEGDD32DC2E$ZTE3ANNRCP03093,6C11BA69734D,6C11BA69734E,ZTEGDC6F4CA8$ZTE3ANNQ4414455,3CF9F0ACB1A8,3CF9F0ACB1A9,ZTEGD641B2FA$ZTE3ANNRCB26011,D831392030A0,D831392030A1,ZTEGDD2A1B30$ZTE3ANNR8C39012,38914852195F,389148521960,ZTEGDB0918D4$ZTE3ANNQCA02711,14CA56D28465,14CA56D28466,ZTEGD9717002$ZTE3ANNRC506238,6C11BA62BC0B,6C11BA62BC0C,ZTEGDC6E2E1D$ZTE3ANNRC507198,6C11BA62D28B,6C11BA62D28C,ZTEGDC6E31DD$ZTE3ANNR4N11685,4896D9566CF6,4896D9566CF7,ZTEGD97F4D6A$ZTE3ANNQ5N05450,3CF9F0AD4532,3CF9F0AD4533,ZTEGD641CB91$ZTE3ANNRCP02999,6C11BA697119,6C11BA69711A,ZTEGDC6F4C4A', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 10:47:52 Duration: 4s826ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
5 14m59s 3 2m21s 8m36s 4m59s analyze verbose;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 29 05 3 14m59s 4m59s [ User: intelifix - Total duration: 14m59s - Times executed: 3 ]
[ Application: psql - Total duration: 14m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-29 05:08:38 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-29 05:12:39 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-29 05:15:00 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql
6 12m2s 68 1s484ms 46s161ms 10s625ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 29 07 3 20s692ms 6s897ms 08 1 4s960ms 4s960ms 09 3 1m1s 20s418ms 10 5 1m28s 17s782ms 11 6 39s624ms 6s604ms 12 3 13s956ms 4s652ms 13 5 1m17s 15s568ms 14 5 32s323ms 6s464ms 15 8 1m31s 11s447ms 16 11 2m29s 13s582ms 17 18 2m21s 7s888ms [ User: intelifix - Total duration: 12m2s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 12m2s - Times executed: 68 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-29', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 09:04:50 Duration: 46s161ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-29', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 13:50:01 Duration: 41s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 10:32:13 Duration: 40s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10m 276 163ms 9s959ms 2s175ms call rs_giga_triagem (?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 29 00 12 28s753ms 2s396ms 01 12 22s869ms 1s905ms 02 12 22s879ms 1s906ms 03 12 22s723ms 1s893ms 04 12 22s778ms 1s898ms 05 12 21s556ms 1s796ms 06 12 21s889ms 1s824ms 07 12 25s460ms 2s121ms 08 12 24s454ms 2s37ms 09 12 32s778ms 2s731ms 10 12 31s283ms 2s606ms 11 12 25s902ms 2s158ms 12 12 27s425ms 2s285ms 13 12 25s290ms 2s107ms 14 12 30s852ms 2s571ms 15 12 32s42ms 2s670ms 16 12 30s544ms 2s545ms 17 12 25s272ms 2s106ms 18 12 24s26ms 2s2ms 19 12 23s672ms 1s972ms 20 12 30s101ms 2s508ms 21 12 24s540ms 2s45ms 22 12 23s288ms 1s940ms [ User: intelifix - Total duration: 10m - Times executed: 276 ]
[ Application: psql - Total duration: 10m - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 00:05:21 Duration: 9s959ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 09:15:12 Duration: 7s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 16:15:16 Duration: 7s434ms Database: rio User: intelifix Remote: [local] Application: psql
8 9m17s 45 10s102ms 15s464ms 12s389ms create table temp0000286822 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 29 09 30 6m13s 12s440ms 10 3 37s723ms 12s574ms 11 6 1m18s 13s146ms 12 6 1m7s 11s282ms [ User: intelifix - Total duration: 9m17s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 9m17s - Times executed: 45 ]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 11:50:50 Duration: 15s464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:51:09 Duration: 14s93ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 10:27:10 Duration: 14s46ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 7m24s 161 192ms 10s116ms 2s760ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 29 00 6 17s995ms 2s999ms 01 6 7s369ms 1s228ms 02 6 9s67ms 1s511ms 03 5 10s155ms 2s31ms 04 6 7s565ms 1s260ms 05 3 10s594ms 3s531ms 06 1 562ms 562ms 07 11 30s834ms 2s803ms 08 12 45s943ms 3s828ms 09 12 39s632ms 3s302ms 10 11 30s46ms 2s731ms 11 12 39s663ms 3s305ms 12 12 42s454ms 3s537ms 13 8 8s694ms 1s86ms 14 12 42s271ms 3s522ms 15 12 44s136ms 3s678ms 16 11 25s751ms 2s341ms 17 5 12s896ms 2s579ms 21 4 6s309ms 1s577ms 22 6 12s420ms 2s70ms [ User: intelifix - Total duration: 7m24s - Times executed: 161 ]
[ Application: psql - Total duration: 7m24s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 00:05:11 Duration: 10s116ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 14:35:09 Duration: 8s88ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 12:05:08 Duration: 7s786ms Database: rio User: intelifix Remote: [local] Application: psql
10 6m51s 787 150ms 1s905ms 522ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 29 07 3 2s477ms 825ms 08 97 1m4s 665ms 09 72 52s204ms 725ms 10 82 48s806ms 595ms 11 78 47s463ms 608ms 12 22 12s71ms 548ms 13 102 42s588ms 417ms 14 104 46s338ms 445ms 15 125 51s148ms 409ms 16 55 24s875ms 452ms 17 47 18s913ms 402ms [ User: intelifix - Total duration: 6m51s - Times executed: 787 ]
[ Application: [unknown] - Total duration: 6m51s - Times executed: 787 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272023", "modelo" : "141", "itens" : "229810489090,229690336175,229670115369,229726652739,229779212324,229866098199,229865417897,229737831417,229784010627,229836436483,229686284747,229685788201,229933324446,229672908100,229663613444,216937406264,229663335762,229661641333,229737961531,229781919614,229812772244,229879519801,229667073748,229865517379,229684447878,229752187890,229726949412,229884691833", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246639639601,246525417892,246514572536,226243972838,246587067388,246653435661,246648797475,246526873254,226237439393,246507996585,246517980815,246499264162,246599995474,246038548907,226200286475,246470632232,246183184055,246491234646,246569350621,246585410718,246628569698,246652547482,246498378283,246648306182,246512584362,246541044861,246539452439,226360378395,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-29 09:04:15 Duration: 1s905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272143", "modelo" : "297", "itens" : "645E1006B0BB,6413AB938085,74E9BF54370F,645E1042038C,C4FBAA0BC7CE,6413AB937D6D,645E109BD342,645E109BD9B7,645E10529372,E00CE524E125,645E1041FEFA,645E1052972C,C4FBAA0BC8E5,74E9BF54342D,645E1006ADEB,645E1042062F,6413AB642437,6413AB938595,645E107CC896,6413AB937E2A,645E1052919E,E00CE524E6AA,74E9BF543073,74E9BF543BBC,74E9BF543826,645E10529237,645E10420758,645E104200B3,645E10528D54,74E9BF543F1C,6413AB6417FB,645E1041FD65,C4FBAA0BC492,74E9BF544246,645E107CC72E,74E9BF543034,6413AB64192D,E00CE524E7B8,645E107CC254,C4FBAA0BC573,645E1042023F,645E104200C5,645E10528D93,645E104204AC,645E1042014C,645E107CC281,645E10420665,74E9BF542FB6,74E9BF5435C2,74E9BF54338B", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-29 09:22:17 Duration: 1s843ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272023", "modelo" : "141", "itens" : "229807116472,229836687394,216938708805,216940555270,229782206162,216936445576,229933319394,229660495878,229807766973,229739288797,229741558693,229783270319,229755250626,229727172341,229750239697,229779521625,216943991330,229755884256,229784980912,229884609905,229690927276,229663399405,229749104245,229663048810,229738905169,229685146162,229933597884,229933617987", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "226033844362,246639568405,246464220316,246474639615,246587981530,246477580419,246153940113,246444548282,246427712948,226375787183,246531213150,246587572444,246560591124,246507297392,246550813940,246558437377,246470237894,246560830418,246160908705,246087959105,246590151315,246559762446,246562702542,246487254561,246527439100,226025118202,226015782128,226205630522,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-29 08:56:26 Duration: 1s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 6m19s 28 9s618ms 34s812ms 13s563ms create table temp0000286820 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 29 09 3 34s160ms 11s386ms 10 1 25s159ms 25s159ms 11 5 1m27s 17s445ms 12 6 1m8s 11s357ms 15 10 2m8s 12s883ms 16 3 36s256ms 12s85ms [ User: intelifix - Total duration: 6m19s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 6m19s - Times executed: 28 ]
-
CREATE TABLE temp0000286820 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 11:21:17 Duration: 34s812ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286820 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 10:51:51 Duration: 25s159ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286820 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 11:26:40 Duration: 15s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 4m29s 59 179ms 1m11s 4s564ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 29 07 4 3s67ms 766ms 08 6 19s268ms 3s211ms 09 23 1m57s 5s105ms 10 1 367ms 367ms 11 4 44s545ms 11s136ms 12 4 1m4s 16s141ms 14 11 4s133ms 375ms 15 5 14s920ms 2s984ms 16 1 1s23ms 1s23ms [ User: intelifix - Total duration: 4m29s - Times executed: 59 ]
[ Application: psql - Total duration: 4m29s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027768);
Date: 2026-07-29 09:35:33 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027776);
Date: 2026-07-29 11:22:08 Duration: 38s959ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027766);
Date: 2026-07-29 09:26:09 Duration: 33s610ms Database: rio User: intelifix Remote: [local] Application: psql
13 3m35s 19 10s70ms 12s404ms 11s339ms create table temp0000286816 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 29 09 19 3m35s 11s339ms [ User: intelifix - Total duration: 3m35s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 19 ]
-
CREATE TABLE temp0000286816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:19:04 Duration: 12s404ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:17:32 Duration: 12s377ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:09:41 Duration: 11s981ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 3m23s 18 10s454ms 12s362ms 11s333ms create table temp0000286790 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 29 07 10 1m50s 11s27ms 08 8 1m33s 11s715ms [ User: intelifix - Total duration: 3m23s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m23s - Times executed: 18 ]
-
CREATE TABLE temp0000286790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 08:20:41 Duration: 12s362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 08:36:11 Duration: 12s350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 08:20:25 Duration: 12s147ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 3m5s 12 10s751ms 32s35ms 15s458ms create table temp0000286876 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 29 14 6 1m39s 16s653ms 15 6 1m25s 14s262ms [ User: intelifix - Total duration: 3m5s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 3m5s - Times executed: 12 ]
-
CREATE TABLE temp0000286876 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:23:11 Duration: 32s35ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286876 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 15:12:41 Duration: 26s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286876 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:23:36 Duration: 14s595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 3m1s 14 11s471ms 14s572ms 12s987ms create table temp0000286862 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 29 14 14 3m1s 12s987ms [ User: intelifix - Total duration: 3m1s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m1s - Times executed: 14 ]
-
CREATE TABLE temp0000286862 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:38:53 Duration: 14s572ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286862 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:44:30 Duration: 14s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286862 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:46:21 Duration: 14s228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
17 2m56s 4 4s422ms 1m26s 44s243ms copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 29 20 2 1m26s 43s85ms 23 2 1m30s 45s401ms [ User: intelifix - Total duration: 2m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-29 23:16:58 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-29 20:08:17 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-29 20:10:01 Duration: 4s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
18 2m14s 34 2s938ms 5s17ms 3s953ms create table temp0000286822 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 29 09 22 1m22s 3s756ms 10 6 27s63ms 4s510ms 12 6 24s698ms 4s116ms [ User: intelifix - Total duration: 2m14s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 34 ]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 10:22:52 Duration: 5s17ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 09:42:09 Duration: 4s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 12:04:30 Duration: 4s640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 2m2s 34 153ms 15s761ms 3s597ms select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 29 07 4 21s181ms 5s295ms 08 9 13s836ms 1s537ms 09 8 31s31ms 3s878ms 10 1 3s789ms 3s789ms 11 4 16s208ms 4s52ms 12 2 7s988ms 3s994ms 14 4 21s779ms 5s444ms 15 2 6s492ms 3s246ms [ User: intelifix - Total duration: 2m2s - Times executed: 34 ]
[ Application: psql - Total duration: 2m2s - Times executed: 34 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027741);
Date: 2026-07-29 07:08:41 Duration: 15s761ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027785);
Date: 2026-07-29 14:24:52 Duration: 12s33ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027779);
Date: 2026-07-29 11:51:46 Duration: 11s554ms Database: rio User: intelifix Remote: [local] Application: psql
20 1m59s 4 433ms 1m4s 29s987ms copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 29 20 2 55s453ms 27s726ms 23 2 1m4s 32s247ms [ User: intelifix - Total duration: 1m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-29 23:13:43 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-29 20:05:18 Duration: 55s15ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-29 20:09:29 Duration: 437ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,603 23m4s 150ms 5s517ms 863ms select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 29 07 45 43s293ms 962ms 08 161 1m31s 567ms 09 189 2m26s 774ms 10 253 3m35s 852ms 11 210 3m27s 990ms 12 39 25s221ms 646ms 13 90 1m25s 950ms 14 197 3m17s 1s 15 266 3m44s 845ms 16 118 1m47s 913ms 17 35 39s587ms 1s131ms [ User: intelifix - Total duration: 23m4s - Times executed: 1603 ]
[ Application: [unknown] - Total duration: 23m4s - Times executed: 1603 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272224, 450, 'ZTE3ANNR3Y19950,4896D951944C,4896D951944D,ZTEGD97E7EA3$ZTE3ANNR3J04711,F4E84F86BCCA,F4E84F86BCCB,ZTEGD97B7431$ZTE3ANNRCP46717,6C11BA6D71BD,6C11BA6D71BE,ZTEGDC6FF710$ZTE3ANNR6R26142,48D68237E976,48D68237E977,ZTEGDB0190F1$ZTE3ANNR8C37452,38914851F4CF,38914851F4D0,ZTEGDB0912BC$ZTE3ANNRAD22221,D89A0DAFE331,D89A0DAFE332,ZTEGDB1752D8$ZTE3ANNQ6M06062,C4EBFF88EFE4,C4EBFF88EFE5,ZTEGD709F8BC$ZTE3ANNR3J04380,F4E84F86B508,F4E84F86B509,ZTEGD97B72E6$ZTE3ANNT2V11932,D831398CA680,D831398CA681,ZTEGDD30211B$ZTE3ANNQ3621312,3CF9F0A6C8EE,3CF9F0A6C8EF,ZTEGD640B6DB$ZTE3ANNR1Y13968,14CA56CDF1DB,14CA56CDF1DC,ZTEGD970ACEB$ZTE3ANNR3Y19752,4896D9518FA8,4896D9518FA9,ZTEGD97E7DDD$ZTE3ANNR3J04335,F4E84F86B3FA,F4E84F86B3FB,ZTEGD97B72B9$ZTE3ANNQ7507690,C4EBFF8BA778,C4EBFF8BA779,ZTEGD70A6CAA$ZTE3ANNQ4N00785,3CF9F0A8A414,3CF9F0A8A415,ZTEGD641060C$ZTE3ANNQ6M06076,C4EBFF88F038,C4EBFF88F039,ZTEGD709F8CA$ZTE3ANNRCP63949,6C11BA6F059D,6C11BA6F059E,ZTEGDC703A60$ZTE3ANNR5W51282,48D6823335B6,48D6823335B7,ZTEGDB00C851$ZTE3ANNRCP62001,6C11BA6ED7F5,6C11BA6ED7F6,ZTEGDC7032C4$ZTE3ANNR7B16918,3891484A792B,3891484A792C,ZTEGDB07D376$ZTE3ANNQ6M07903,C4EBFF891B0A,C4EBFF891B0B,ZTEGD709FFED$ZTE3ANNQ3612242,3CF9F0A5F45A,3CF9F0A5F45B,ZTEGD640936D$ZTE3ANNT3H83171,D831399E60EA,D831399E60EB,ZTEGDD331582$ZTE3ANNR2Q28985,F4E84F835B56,F4E84F835B57,ZTEGD97AE3F3$ZTE3ANNRAM59429,5872C98CA917,5872C98CA918,ZTEGDC60E824$ZTE3ANNRCP64065,6C11BA6F0855,6C11BA6F0856,ZTEGDC703AD4$ZTE3ANNQ4414781,3CF9F0ACB94C,3CF9F0ACB94D,ZTEGD641B440$ZTE3ANNQ4414771,3CF9F0ACB910,3CF9F0ACB911,ZTEGD641B436$ZTE3ANNQ7L04512,C4EBFF8DEE68,C4EBFF8DEE69,ZTEGD70ACDD2$ZTE3ANNT3H69051,D831399D15FA,D831399D15FB,ZTEGDD32DE5A$ZTE3ANNQ3R00781,3CF9F0A29214,3CF9F0A29215,ZTEGD640030C$ZTE3ANNQ7T02838,C4EBFF8F2DC4,C4EBFF8F2DC5,ZTEGD70B030C$ZTE3ANNQ8M18668,843C99207D73,843C99207D74,ZTEGD7BA9059$ZTE3ANNRAM35107,5872C98A6F0B,5872C98A6F0C,ZTEGDC608922$ZTE3ANNQ7507538,C4EBFF8BA3E8,C4EBFF8BA3E9,ZTEGD70A6C12$ZTE3ANNQ3R00816,3CF9F0A292E6,3CF9F0A292E7,ZTEGD640032F$ZTE3ANNR1Y42943,14CA56D098F5,14CA56D098F6,ZTEGD9711E1A$ZTE3ANNR5W68593,48D68234CB70,48D68234CB71,ZTEGDB010BF0$ZTE3ANNRCB72648,D831392475AE,D831392475AF,ZTEGDD2AD15D$ZTE3ANNR9F40709,D89A0DA69801,D89A0DA69802,ZTEGDB15C650', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 11:26:53 Duration: 5s517ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48437, 417, '835100915001254,241667960208,241708795371,241728742436,241731031425,241630183939,241664845167,241704047073,241676641818,241732153139,241604349914,241657188392,241717171318,241634989515,241668151719,241604356379,241708747386,241617356873,241713294553,241731033647,241635007294,241714073350,241659722333,241598878202,241706864554,241731001624,241676779205,241646271133,241593128303,241704327785,241676776881,241622485163,241708874346,241713312737,241668249405,241593408183,241678342231,241680375459,241649712546,241676779609,241708891217,241731036677,241731221926,241676790722,241628278602,241659726676,241731013847', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 16:43:57 Duration: 5s142ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48527, 417, 'ZTE3ANNQ7T03108,C4EBFF8F3418,C4EBFF8F3419,ZTEGD70B041A$ZTE3ANNR1Y33595,14CA56CFBDDD,14CA56CFBDDE,ZTEGD970F996$ZTE3ANNT2V11716,D831398CA170,D831398CA171,ZTEGDD302043$ZTE3ANNT2V85827,D83139936A6A,D83139936A6B,ZTEGDD3141C2$ZTE3ANNRCP61611,6C11BA6ECED1,6C11BA6ECED2,ZTEGDC70313E$ZTE3ANNR9W21005,D89A0DAA4871,D89A0DAA4872,ZTEGDB1663B8$ZTE3ANNR2Q32929,F4E84F83B7C6,F4E84F83B7C7,ZTEGD97AF35B$ZTE3ANNR2Q00737,F4E84F80C546,F4E84F80C547,ZTEGD97A759B$ZTE3ANNR8C09926,3891484F6FAB,3891484F6FAC,ZTEGDB08A736$ZTE3ANNRCB62896,D8313923911E,D8313923911F,ZTEGDD2AAB45$ZTE3ANNR7B15305,3891484A535D,3891484A535E,ZTEGDB07CD29$ZTE3ANNR3J45472,F4E84F8A7820,F4E84F8A7821,ZTEGD97C136A$ZTE3ANNR8C09961,3891484F707D,3891484F707E,ZTEGDB08A759$ZTE3ANNQ4N01186,3CF9F0A8AD7A,3CF9F0A8AD7B,ZTEGD641079D$ZTE3ANNQ4N04182,3CF9F0A8F3B2,3CF9F0A8F3B3,ZTEGD6411351$ZTE3ANNRCB74459,D8313924A020,D8313924A021,ZTEGDD2AD870$ZTE3ANNQ7501445,C4EBFF8B151A,C4EBFF8B151B,ZTEGD70A5445$ZTE3ANNR8C39074,389148521AD3,389148521AD4,ZTEGDB091912$ZTE3ANNT3H68495,D831399D08F2,D831399D08F3,ZTEGDD32DC2E$ZTE3ANNRCP03093,6C11BA69734D,6C11BA69734E,ZTEGDC6F4CA8$ZTE3ANNQ4414455,3CF9F0ACB1A8,3CF9F0ACB1A9,ZTEGD641B2FA$ZTE3ANNRCB26011,D831392030A0,D831392030A1,ZTEGDD2A1B30$ZTE3ANNR8C39012,38914852195F,389148521960,ZTEGDB0918D4$ZTE3ANNQCA02711,14CA56D28465,14CA56D28466,ZTEGD9717002$ZTE3ANNRC506238,6C11BA62BC0B,6C11BA62BC0C,ZTEGDC6E2E1D$ZTE3ANNRC507198,6C11BA62D28B,6C11BA62D28C,ZTEGDC6E31DD$ZTE3ANNR4N11685,4896D9566CF6,4896D9566CF7,ZTEGD97F4D6A$ZTE3ANNQ5N05450,3CF9F0AD4532,3CF9F0AD4533,ZTEGD641CB91$ZTE3ANNRCP02999,6C11BA697119,6C11BA69711A,ZTEGDC6F4C4A', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 10:47:52 Duration: 4s826ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
2 787 6m51s 150ms 1s905ms 522ms select * from rs_lote_saida_manutencao_itens (?);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 29 07 3 2s477ms 825ms 08 97 1m4s 665ms 09 72 52s204ms 725ms 10 82 48s806ms 595ms 11 78 47s463ms 608ms 12 22 12s71ms 548ms 13 102 42s588ms 417ms 14 104 46s338ms 445ms 15 125 51s148ms 409ms 16 55 24s875ms 452ms 17 47 18s913ms 402ms [ User: intelifix - Total duration: 6m51s - Times executed: 787 ]
[ Application: [unknown] - Total duration: 6m51s - Times executed: 787 ]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272023", "modelo" : "141", "itens" : "229810489090,229690336175,229670115369,229726652739,229779212324,229866098199,229865417897,229737831417,229784010627,229836436483,229686284747,229685788201,229933324446,229672908100,229663613444,216937406264,229663335762,229661641333,229737961531,229781919614,229812772244,229879519801,229667073748,229865517379,229684447878,229752187890,229726949412,229884691833", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "246639639601,246525417892,246514572536,226243972838,246587067388,246653435661,246648797475,246526873254,226237439393,246507996585,246517980815,246499264162,246599995474,246038548907,226200286475,246470632232,246183184055,246491234646,246569350621,246585410718,246628569698,246652547482,246498378283,246648306182,246512584362,246541044861,246539452439,226360378395,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-29 09:04:15 Duration: 1s905ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272143", "modelo" : "297", "itens" : "645E1006B0BB,6413AB938085,74E9BF54370F,645E1042038C,C4FBAA0BC7CE,6413AB937D6D,645E109BD342,645E109BD9B7,645E10529372,E00CE524E125,645E1041FEFA,645E1052972C,C4FBAA0BC8E5,74E9BF54342D,645E1006ADEB,645E1042062F,6413AB642437,6413AB938595,645E107CC896,6413AB937E2A,645E1052919E,E00CE524E6AA,74E9BF543073,74E9BF543BBC,74E9BF543826,645E10529237,645E10420758,645E104200B3,645E10528D54,74E9BF543F1C,6413AB6417FB,645E1041FD65,C4FBAA0BC492,74E9BF544246,645E107CC72E,74E9BF543034,6413AB64192D,E00CE524E7B8,645E107CC254,C4FBAA0BC573,645E1042023F,645E104200C5,645E10528D93,645E104204AC,645E1042014C,645E107CC281,645E10420665,74E9BF542FB6,74E9BF5435C2,74E9BF54338B", "usuario" : "417", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-29 09:22:17 Duration: 1s843ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_SAIDA_MANUTENCAO_ITENS ('{ "lote" : "272023", "modelo" : "141", "itens" : "229807116472,229836687394,216938708805,216940555270,229782206162,216936445576,229933319394,229660495878,229807766973,229739288797,229741558693,229783270319,229755250626,229727172341,229750239697,229779521625,216943991330,229755884256,229784980912,229884609905,229690927276,229663399405,229749104245,229663048810,229738905169,229685146162,229933597884,229933617987", "usuario" : "415", "caixa" : "0", "tecnico-cosmetico" : "299", "acessorios" : "226033844362,246639568405,246464220316,246474639615,246587981530,246477580419,246153940113,246444548282,246427712948,226375787183,246531213150,246587572444,246560591124,246507297392,246550813940,246558437377,246470237894,246560830418,246160908705,246087959105,246590151315,246559762446,246562702542,246487254561,246527439100,226025118202,226015782128,226205630522,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,", "sem-nf-gvt" : "N", "observacoes" : "[[tela]]" }');
Date: 2026-07-29 08:56:26 Duration: 1s771ms Database: rio User: intelifix Remote: [local] Application: [unknown]
3 276 10m 163ms 9s959ms 2s175ms call rs_giga_triagem (?);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 29 00 12 28s753ms 2s396ms 01 12 22s869ms 1s905ms 02 12 22s879ms 1s906ms 03 12 22s723ms 1s893ms 04 12 22s778ms 1s898ms 05 12 21s556ms 1s796ms 06 12 21s889ms 1s824ms 07 12 25s460ms 2s121ms 08 12 24s454ms 2s37ms 09 12 32s778ms 2s731ms 10 12 31s283ms 2s606ms 11 12 25s902ms 2s158ms 12 12 27s425ms 2s285ms 13 12 25s290ms 2s107ms 14 12 30s852ms 2s571ms 15 12 32s42ms 2s670ms 16 12 30s544ms 2s545ms 17 12 25s272ms 2s106ms 18 12 24s26ms 2s2ms 19 12 23s672ms 1s972ms 20 12 30s101ms 2s508ms 21 12 24s540ms 2s45ms 22 12 23s288ms 1s940ms [ User: intelifix - Total duration: 10m - Times executed: 276 ]
[ Application: psql - Total duration: 10m - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 00:05:21 Duration: 9s959ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 09:15:12 Duration: 7s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 16:15:16 Duration: 7s434ms Database: rio User: intelifix Remote: [local] Application: psql
4 275 1h21m41s 152ms 6m56s 17s824ms select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 29 07 7 5m13s 44s841ms 08 44 11m18s 15s416ms 09 42 13m32s 19s339ms 10 29 11m15s 23s293ms 11 24 8m12s 20s532ms 12 8 5m17s 39s709ms 13 13 18s592ms 1s430ms 14 45 7m2s 9s397ms 15 39 18m24s 28s320ms 16 19 41s387ms 2s178ms 17 5 23s917ms 4s783ms [ User: intelifix - Total duration: 1h21m41s - Times executed: 275 ]
[ Application: [unknown] - Total duration: 1h21m41s - Times executed: 275 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-28'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-29 15:06:21 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027785, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-29 14:31:29 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027757, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-29 09:19:03 Duration: 5m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
5 161 7m24s 192ms 10s116ms 2s760ms call rs_giga_processa_arquivos ();Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 29 00 6 17s995ms 2s999ms 01 6 7s369ms 1s228ms 02 6 9s67ms 1s511ms 03 5 10s155ms 2s31ms 04 6 7s565ms 1s260ms 05 3 10s594ms 3s531ms 06 1 562ms 562ms 07 11 30s834ms 2s803ms 08 12 45s943ms 3s828ms 09 12 39s632ms 3s302ms 10 11 30s46ms 2s731ms 11 12 39s663ms 3s305ms 12 12 42s454ms 3s537ms 13 8 8s694ms 1s86ms 14 12 42s271ms 3s522ms 15 12 44s136ms 3s678ms 16 11 25s751ms 2s341ms 17 5 12s896ms 2s579ms 21 4 6s309ms 1s577ms 22 6 12s420ms 2s70ms [ User: intelifix - Total duration: 7m24s - Times executed: 161 ]
[ Application: psql - Total duration: 7m24s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 00:05:11 Duration: 10s116ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 14:35:09 Duration: 8s88ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 12:05:08 Duration: 7s786ms Database: rio User: intelifix Remote: [local] Application: psql
6 111 51s709ms 290ms 754ms 465ms select pro_id, pgp_sym_decrypt(nome, ?)::varchar, pgp_sym_decrypt(descricao, ?)::varchar, pgp_sym_decrypt(classe, ?)::varchar, pgp_sym_decrypt(php, ?)::varchar, pgp_sym_decrypt(extras, ?)::varchar from progs order by pro_id;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 29 00 1 398ms 398ms 01 3 1s302ms 434ms 03 1 416ms 416ms 04 1 391ms 391ms 05 3 1s129ms 376ms 06 1 378ms 378ms 07 12 5s690ms 474ms 08 8 3s51ms 381ms 09 12 6s220ms 518ms 10 11 5s52ms 459ms 11 10 5s296ms 529ms 12 6 3s117ms 519ms 13 9 3s905ms 433ms 14 10 4s817ms 481ms 15 8 3s371ms 421ms 16 9 4s452ms 494ms 17 5 2s319ms 463ms 21 1 398ms 398ms [ User: lenon - Total duration: 51s709ms - Times executed: 111 ]
[ Application: [unknown] - Total duration: 51s709ms - Times executed: 111 ]
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-29 07:45:03 Duration: 754ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-29 09:09:42 Duration: 753ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
-
SELECT pro_id, pgp_sym_decrypt(nome, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(descricao, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(classe, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(php, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar, pgp_sym_decrypt(extras, '4a79e307cf12b948a9095e16ae39c594d9dae1fce69604e956aeb77f2706e2a3')::varchar from progs ORDER BY PRO_ID;
Date: 2026-07-29 11:20:05 Duration: 749ms Database: rio User: lenon Remote: [local] Application: [unknown] Bind query: yes
7 101 43s694ms 227ms 1s138ms 432ms select * from rs_query_lista (?) where id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 29 07 5 1s896ms 379ms 08 13 5s353ms 411ms 09 20 9s229ms 461ms 10 5 2s239ms 447ms 11 9 3s574ms 397ms 12 6 2s136ms 356ms 13 2 1s633ms 816ms 14 13 6s188ms 476ms 15 10 4s134ms 413ms 16 14 5s718ms 408ms 17 4 1s590ms 397ms [ User: intelifix - Total duration: 43s694ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 43s694ms - Times executed: 101 ]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-07-29 13:59:41 Duration: 1s138ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 085;
Date: 2026-07-29 14:59:14 Duration: 675ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_QUERY_LISTA ('') WHERE ID = 083;
Date: 2026-07-29 10:46:56 Duration: 673ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 101 21s396ms 151ms 468ms 211ms select * from rs_triagem (?, ?, ?, ?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 29 00 1 215ms 215ms 01 5 988ms 197ms 07 17 3s810ms 224ms 08 17 3s982ms 234ms 09 19 3s588ms 188ms 10 12 2s221ms 185ms 11 12 2s626ms 218ms 12 6 1s410ms 235ms 14 5 1s30ms 206ms 15 5 1s162ms 232ms 16 2 359ms 179ms [ User: intelifix - Total duration: 21s396ms - Times executed: 101 ]
[ Application: [unknown] - Total duration: 21s396ms - Times executed: 101 ]
-
SELECT * FROM RS_TRIAGEM (430, 5, '138', 6, 'ACD75BB5A962,582FF7175DD2,D0CF0EFF2BAB,CC5830032673,5447CC49FECA,48295245E6CF,D833B7C97483,ACD75BB84B53,B0FC88EB7441,20B82BF98F8A,209A7DBB357D,B05B99FAECC7,64FD9663E7F1,20B82BF98596,20B82BF97FFB,64FD966C5CD4,841EA39714D9,186A81D6540F,D0CF0EFF2EC9,B0FC88EB4B0C,C03C0486B6D9,64FD9653C7CE,64FD966CFE2F,186A81D63982,5447CC787ABE,186A81D41B1E,B05B99FB98DA,CC5830E3F5EC,B0BBE54CDF82,5447CC49C09C,8CFDDE98892E,943C96AD7B5C,C4EB42EC3D0D,E8D2FFA53C20,ACD75BB7B995,3453D2A8B03D,20B82BF98B15,64FD9655ECFA', NULL, NULL, 0155, 00);
Date: 2026-07-29 08:23:08 Duration: 468ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '63', 2, '216941420518,229739356380,229665604244,229813674565,229813923860,229813550412,229739216063,229673733343,229671875462,229687499703,229733845674,216937982943', NULL, NULL, 0141, 00);
Date: 2026-07-29 07:00:37 Duration: 427ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_TRIAGEM (373, 5, '70', 2, '229689087478,216944379201,229734098606,229665315675,229734136869,229688177176,229688015668,229749128691,229786200818,229671973957', NULL, NULL, 0141, 00);
Date: 2026-07-29 08:07:54 Duration: 420ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 99 56s720ms 355ms 886ms 572ms select * from rs_menu_grants (?, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 29 00 1 618ms 618ms 01 3 1s637ms 545ms 03 1 572ms 572ms 04 1 530ms 530ms 05 3 1s404ms 468ms 06 1 500ms 500ms 07 10 5s925ms 592ms 08 7 3s333ms 476ms 09 10 5s986ms 598ms 10 9 5s108ms 567ms 11 9 5s607ms 623ms 12 5 3s142ms 628ms 13 8 4s447ms 555ms 14 10 6s8ms 600ms 15 8 4s132ms 516ms 16 8 4s898ms 612ms 17 5 2s868ms 573ms [ User: intelifix - Total duration: 56s720ms - Times executed: 99 ]
[ Application: [unknown] - Total duration: 56s720ms - Times executed: 99 ]
-
select * from rs_menu_grants (428, 21, 1);
Date: 2026-07-29 16:14:03 Duration: 886ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (417, 18, 1);
Date: 2026-07-29 11:26:21 Duration: 851ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
select * from rs_menu_grants (507, 18, 1);
Date: 2026-07-29 07:45:03 Duration: 835ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 89 29s39ms 150ms 3s4ms 326ms select * from rs_produtividade_horas_html (?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 29 07 2 481ms 240ms 08 9 13s770ms 1s530ms 09 2 371ms 185ms 10 4 812ms 203ms 11 4 779ms 194ms 12 2 471ms 235ms 13 2 448ms 224ms 14 15 2s831ms 188ms 15 20 3s728ms 186ms 16 18 3s402ms 189ms 17 11 1s941ms 176ms [ User: intelifix - Total duration: 29s39ms - Times executed: 89 ]
[ Application: [unknown] - Total duration: 29s39ms - Times executed: 89 ]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "307", "data-de" : "2026-07-01", "data-ate" : "2026-07-29", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 304 }');
Date: 2026-07-29 08:43:10 Duration: 3s4ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "432", "data-de" : "2026-07-01", "data-ate" : "2026-07-29", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 503 }');
Date: 2026-07-29 08:43:58 Duration: 2s6ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_PRODUTIVIDADE_HORAS_HTML ('{ "tecnico" : "431", "data-de" : "2026-07-01", "data-ate" : "2026-07-29", "passos" : "0" , "modelo" : "0" , "tipo" : 1, "departamento": "14", "usuario" : 504 }');
Date: 2026-07-29 08:44:54 Duration: 1s715ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 84 1m11s 158ms 10s732ms 854ms select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 29 08 19 10s175ms 535ms 09 13 5s995ms 461ms 10 15 7s229ms 481ms 11 3 23s569ms 7s856ms 14 19 16s751ms 881ms 15 8 3s325ms 415ms 16 7 4s739ms 677ms [ User: intelifix - Total duration: 1m11s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 1m11s - Times executed: 84 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048104) LIMIT 1;
Date: 2026-07-29 11:50:41 Duration: 10s732ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-07-29 11:54:11 Duration: 9s927ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0272023) LIMIT 1;
Date: 2026-07-29 14:34:07 Duration: 2s964ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 75 50s452ms 150ms 1s894ms 672ms select * from rs_nova_caixa_qr (?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 29 08 26 17s975ms 691ms 09 49 32s477ms 662ms [ User: intelifix - Total duration: 50s452ms - Times executed: 75 ]
[ Application: [unknown] - Total duration: 50s452ms - Times executed: 75 ]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"229687083748,229865611430,229784264949,229814584665,216938650214,229737712943,229816960408,229665191320,229685408589,229816672445,229812495471,229925617184,229743994566,229743068707,229924952743,229812158389,229781337884,229684446363,229749296991,229808986980,229741560917,229813497981,229736725865,229741461839,229669954040,229925620620,229806384650,229809768404,229782157897,229749612129,229753890426,216945282634,229925620317,229933814752,229925086874,229925591829,229669714769,229810967476,229750564253,229733852039,216941200216,229745161010,216941946988,229737843640,229805512029,229743962745,229726246178,229689132635,229745441722,229933952342","usuario":"416","observacao":""}');
Date: 2026-07-29 08:36:28 Duration: 1s894ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"54A65C89B4C6,14B7F8E14872,10C25A3C26B2,14B7F88D812F,A456CCE40927,383FB3A24671,D4B92F281F01,80D04A90D70F,54A65C0FD969,14B7F8DEC218,1062D0C80DDE,BC9B689A0635,54A65C0FD4AE,BC9B689B6A08,54A65C0FFBD6,1062D0125B19,A456CCE28502,B42A0E9C55DA,1062D09A6E88,54A65C0E9DA5,D4B92F2E44FE,80D04A8F7772,54A65C8C1E7F","usuario":"416","observacao":""}');
Date: 2026-07-29 08:35:42 Duration: 1s331ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_NOVA_CAIXA_QR ('{"lote":"48103","seriais":"F42D0645BE93,D8E8448D68EE,F42D0645C1F3,CC29BDEADCBD,6877DA58C497,6877DA59D313,802D1A207BB0,CC29BDEB8A8D,802D1A1EF0E0,6877DA5E95FF,D8E8448A07FA,D8E844AAE356,802D1A20A454,E84368539170,CC29BDED5729,6877DA60B6BB,802D1A013F54,6877DA5EF237,6877DA5BFB47,D8E8448BAC6A,C094AD99F8CB,D8E8448BAC8A,6877DA6095CF,D8E8448BAC56,D8E8448AB386,802D1A013F28,802D1A20BAA4,203AEBA72D7E,F42D064719C3,D8E8448C9142,6877DA59D31F,802D1A1EF0B4,6877DA62D287,6877DA5F7877,802D1A1EF83C,6877DA5D0677,CC29BDEDA895,E0B66809D874,F42D0645C2D3,F42D06477923,F42D06470AAF,CC29BDED5A05,203AEBA7229E,203AEBA74D06,203AEBA74C9E,6877DA5D9ED3,6877DA610BC3,304240931350,D8E8448A8B02,CC29BDEC425D","usuario":"416","observacao":""}');
Date: 2026-07-29 09:19:28 Duration: 1s242ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
13 70 18s56ms 152ms 3s395ms 257ms create table temp0000286824 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 29 08 1 3s395ms 3s395ms 09 4 1s398ms 349ms 10 11 1s968ms 178ms 11 19 4s14ms 211ms 12 1 170ms 170ms 13 4 670ms 167ms 14 16 3s249ms 203ms 15 11 2s562ms 232ms 16 3 626ms 208ms [ User: intelifix - Total duration: 18s56ms - Times executed: 70 ]
[ Application: [unknown] - Total duration: 18s56ms - Times executed: 70 ]
-
CREATE TABLE temp0000286824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 08:57:59 Duration: 3s395ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"441", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 09:30:01 Duration: 424ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286824 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"441", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 09:28:29 Duration: 369ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 68 12m2s 1s484ms 46s161ms 10s625ms select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 29 07 3 20s692ms 6s897ms 08 1 4s960ms 4s960ms 09 3 1m1s 20s418ms 10 5 1m28s 17s782ms 11 6 39s624ms 6s604ms 12 3 13s956ms 4s652ms 13 5 1m17s 15s568ms 14 5 32s323ms 6s464ms 15 8 1m31s 11s447ms 16 11 2m29s 13s582ms 17 18 2m21s 7s888ms [ User: intelifix - Total duration: 12m2s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 12m2s - Times executed: 68 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-29', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 09:04:50 Duration: 46s161ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-29', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 13:50:01 Duration: 41s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 10:32:13 Duration: 40s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
15 63 13s288ms 151ms 889ms 210ms create table temp0000237106 as select * from rs_lotes_saida_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 29 14 6 1s781ms 296ms 15 16 3s15ms 188ms 16 10 2s66ms 206ms 17 31 6s425ms 207ms [ User: intelifix - Total duration: 13s288ms - Times executed: 63 ]
[ Application: [unknown] - Total duration: 13s288ms - Times executed: 63 ]
-
CREATE TABLE temp0000237106 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "24-07-2026", "data-ate" : "29-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-29 14:16:04 Duration: 889ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237106 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "29-07-2026", "data-ate" : "29-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-29 16:12:33 Duration: 279ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237106 AS SELECT * FROM RS_LOTES_SAIDA_LISTA ('{ "id" : "", "oficina" : "7", "cliente" : "0", "nf" : "", "data-de" : "29-07-2026", "data-ate" : "29-07-2026", "grupo" : "0", "status" : "-1", "tipo" : "", "completo" : "", "status-vivo" : "0", "valorado" : "", "modelo" : "0", "lote-stone" : "", "motivo" : "0" }');
Date: 2026-07-29 16:48:16 Duration: 273ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
16 60 14s269ms 152ms 1s581ms 237ms create table temp0000237096 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 29 12 2 1s440ms 720ms 13 9 1s605ms 178ms 14 22 4s124ms 187ms 15 19 4s38ms 212ms 16 4 844ms 211ms 17 4 2s217ms 554ms [ User: intelifix - Total duration: 14s269ms - Times executed: 60 ]
[ Application: [unknown] - Total duration: 14s269ms - Times executed: 60 ]
-
CREATE TABLE temp0000237096 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 17:13:46 Duration: 1s581ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237096 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 12:45:44 Duration: 1s267ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000237096 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"7", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"15098", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 17:00:08 Duration: 250ms Database: brasilia User: intelifix Remote: [local] Application: [unknown]
17 59 4m29s 179ms 1m11s 4s564ms select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 29 07 4 3s67ms 766ms 08 6 19s268ms 3s211ms 09 23 1m57s 5s105ms 10 1 367ms 367ms 11 4 44s545ms 11s136ms 12 4 1m4s 16s141ms 14 11 4s133ms 375ms 15 5 14s920ms 2s984ms 16 1 1s23ms 1s23ms [ User: intelifix - Total duration: 4m29s - Times executed: 59 ]
[ Application: psql - Total duration: 4m29s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027768);
Date: 2026-07-29 09:35:33 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027776);
Date: 2026-07-29 11:22:08 Duration: 38s959ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027766);
Date: 2026-07-29 09:26:09 Duration: 33s610ms Database: rio User: intelifix Remote: [local] Application: psql
18 54 21s375ms 153ms 4s383ms 395ms create table temp0000286812 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 29 08 12 7s400ms 616ms 10 8 1s560ms 195ms 11 6 1s438ms 239ms 12 4 826ms 206ms 14 7 1s493ms 213ms 15 11 2s911ms 264ms 16 6 5s744ms 957ms [ User: intelifix - Total duration: 21s375ms - Times executed: 54 ]
[ Application: [unknown] - Total duration: 21s375ms - Times executed: 54 ]
-
CREATE TABLE temp0000286812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 16:46:27 Duration: 4s383ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 08:14:08 Duration: 4s69ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286812 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"1575", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 16:32:25 Duration: 423ms Database: rio User: intelifix Remote: [local] Application: [unknown]
19 52 18s80ms 163ms 3s171ms 347ms create table temp0000286810 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 29 08 22 9s587ms 435ms 09 12 4s776ms 398ms 10 9 1s755ms 195ms 11 9 1s960ms 217ms [ User: intelifix - Total duration: 18s80ms - Times executed: 52 ]
[ Application: [unknown] - Total duration: 18s80ms - Times executed: 52 ]
-
CREATE TABLE temp0000286810 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 08:08:42 Duration: 3s171ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286810 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"01-07-2026", "ate" :"29-07-2026", "nota-fiscal":"81039", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 09:42:33 Duration: 1s760ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286810 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"441", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 08:50:29 Duration: 396ms Database: rio User: intelifix Remote: [local] Application: [unknown]
20 48 2h4m19s 1s304ms 8m53s 2m35s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 29 07 3 8m17s 2m45s 08 3 7m15s 2m25s 09 3 9m18s 3m6s 10 3 8m47s 2m55s 11 3 9m32s 3m10s 12 3 8m49s 2m56s 13 3 6m25s 2m8s 14 3 9m15s 3m5s 15 3 9m19s 3m6s 16 3 8m41s 2m53s 17 3 7m9s 2m23s 18 3 6m11s 2m3s 19 3 5m58s 1m59s 20 3 6m41s 2m13s 21 3 6m14s 2m4s 22 3 6m20s 2m6s [ User: intelifix - Total duration: 2h4m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h4m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 11:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 15:13:50 Duration: 8m48s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 14:13:41 Duration: 8m40s Database: rio User: intelifix Remote: [local] Application: psql
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 2m21s 8m36s 4m59s 3 14m59s analyze verbose;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 29 05 3 14m59s 4m59s [ User: intelifix - Total duration: 14m59s - Times executed: 3 ]
[ Application: psql - Total duration: 14m59s - Times executed: 3 ]
-
analyze verbose;
Date: 2026-07-29 05:08:38 Duration: 8m36s Database: rio User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-29 05:12:39 Duration: 4m1s Database: brasilia User: intelifix Remote: [local] Application: psql
-
analyze verbose;
Date: 2026-07-29 05:15:00 Duration: 2m21s Database: contagem User: intelifix Remote: [local] Application: psql
2 1s304ms 8m53s 2m35s 48 2h4m19s select * from rs_smart_fiscal_entrada ();Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 29 07 3 8m17s 2m45s 08 3 7m15s 2m25s 09 3 9m18s 3m6s 10 3 8m47s 2m55s 11 3 9m32s 3m10s 12 3 8m49s 2m56s 13 3 6m25s 2m8s 14 3 9m15s 3m5s 15 3 9m19s 3m6s 16 3 8m41s 2m53s 17 3 7m9s 2m23s 18 3 6m11s 2m3s 19 3 5m58s 1m59s 20 3 6m41s 2m13s 21 3 6m14s 2m4s 22 3 6m20s 2m6s [ User: intelifix - Total duration: 2h4m19s - Times executed: 48 ]
[ Application: psql - Total duration: 2h4m19s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 11:13:55 Duration: 8m53s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 15:13:50 Duration: 8m48s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_ENTRADA ();
Date: 2026-07-29 14:13:41 Duration: 8m40s Database: rio User: intelifix Remote: [local] Application: psql
3 192ms 4m34s 1m34s 48 1h15m57s select * from rs_smart_fiscal_saida ();Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 29 07 3 5m1s 1m40s 08 3 4m33s 1m31s 09 3 5m38s 1m52s 10 3 5m32s 1m50s 11 3 5m12s 1m44s 12 3 4m45s 1m35s 13 3 4m25s 1m28s 14 3 5m33s 1m51s 15 3 5m6s 1m42s 16 3 4m52s 1m37s 17 3 4m58s 1m39s 18 3 4m2s 1m20s 19 3 3m43s 1m14s 20 3 4m19s 1m26s 21 3 3m48s 1m16s 22 3 4m24s 1m28s [ User: intelifix - Total duration: 1h15m57s - Times executed: 48 ]
[ Application: psql - Total duration: 1h15m57s - Times executed: 48 ]
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-29 14:19:45 Duration: 4m34s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-29 10:19:15 Duration: 4m32s Database: brasilia User: intelifix Remote: [local] Application: psql
-
SELECT * FROM RS_SMART_FISCAL_SAIDA ();
Date: 2026-07-29 09:19:48 Duration: 4m31s Database: brasilia User: intelifix Remote: [local] Application: psql
4 4s422ms 1m26s 44s243ms 4 2m56s copy public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 29 20 2 1m26s 43s85ms 23 2 1m30s 45s401ms [ User: intelifix - Total duration: 2m56s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 2m56s - Times executed: 4 ]
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-29 23:16:58 Duration: 1m26s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-29 20:08:17 Duration: 1m21s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.tcia_lotes (tl_id, lot_id, data_envio, status, mensagem, dados, resposta, criacao) TO stdout;
Date: 2026-07-29 20:10:01 Duration: 4s554ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
5 433ms 1m4s 29s987ms 4 1m59s copy public.logs (mensagem, quando) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 29 20 2 55s453ms 27s726ms 23 2 1m4s 32s247ms [ User: intelifix - Total duration: 1m59s - Times executed: 4 ]
[ Application: pg_dump - Total duration: 1m59s - Times executed: 4 ]
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-29 23:13:43 Duration: 1m4s Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-29 20:05:18 Duration: 55s15ms Database: rio User: intelifix Remote: [local] Application: pg_dump
-
COPY public.logs (mensagem, quando) TO stdout;
Date: 2026-07-29 20:09:29 Duration: 437ms Database: brasilia User: intelifix Remote: [local] Application: pg_dump
6 152ms 6m56s 17s824ms 275 1h21m41s select * from rs_fast_excel (?, ?);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 29 07 7 5m13s 44s841ms 08 44 11m18s 15s416ms 09 42 13m32s 19s339ms 10 29 11m15s 23s293ms 11 24 8m12s 20s532ms 12 8 5m17s 39s709ms 13 13 18s592ms 1s430ms 14 45 7m2s 9s397ms 15 39 18m24s 28s320ms 16 19 41s387ms 2s178ms 17 5 23s917ms 4s783ms [ User: intelifix - Total duration: 1h21m41s - Times executed: 275 ]
[ Application: [unknown] - Total duration: 1h21m41s - Times executed: 275 ]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM rs_triagens_lista(6,DATE(''2026-07-01''),DATE(''2026-07-28'')) ;', '/var/www/html/tmp/Relatorio BI Data.xlsx');
Date: 2026-07-29 15:06:21 Duration: 6m56s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027785, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-29 14:31:29 Duration: 6m15s Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_FAST_EXCEL ('SELECT * FROM RS_NF_CARGA_LOTES( 027757, 0507 )', '/var/www/html/tmp/nf_carga_lotes_0507.xlsx');
Date: 2026-07-29 09:19:03 Duration: 5m51s Database: rio User: intelifix Remote: [local] Application: [unknown]
7 10s751ms 32s35ms 15s458ms 12 3m5s create table temp0000286876 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 29 14 6 1m39s 16s653ms 15 6 1m25s 14s262ms [ User: intelifix - Total duration: 3m5s - Times executed: 12 ]
[ Application: [unknown] - Total duration: 3m5s - Times executed: 12 ]
-
CREATE TABLE temp0000286876 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:23:11 Duration: 32s35ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286876 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 15:12:41 Duration: 26s204ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286876 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:23:36 Duration: 14s595ms Database: rio User: intelifix Remote: [local] Application: [unknown]
8 9s618ms 34s812ms 13s563ms 28 6m19s create table temp0000286820 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 29 09 3 34s160ms 11s386ms 10 1 25s159ms 25s159ms 11 5 1m27s 17s445ms 12 6 1m8s 11s357ms 15 10 2m8s 12s883ms 16 3 36s256ms 12s85ms [ User: intelifix - Total duration: 6m19s - Times executed: 28 ]
[ Application: [unknown] - Total duration: 6m19s - Times executed: 28 ]
-
CREATE TABLE temp0000286820 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 11:21:17 Duration: 34s812ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286820 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 10:51:51 Duration: 25s159ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286820 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 11:26:40 Duration: 15s822ms Database: rio User: intelifix Remote: [local] Application: [unknown]
9 11s471ms 14s572ms 12s987ms 14 3m1s create table temp0000286862 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 29 14 14 3m1s 12s987ms [ User: intelifix - Total duration: 3m1s - Times executed: 14 ]
[ Application: [unknown] - Total duration: 3m1s - Times executed: 14 ]
-
CREATE TABLE temp0000286862 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:38:53 Duration: 14s572ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286862 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:44:30 Duration: 14s269ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286862 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 14:46:21 Duration: 14s228ms Database: rio User: intelifix Remote: [local] Application: [unknown]
10 10s102ms 15s464ms 12s389ms 45 9m17s create table temp0000286822 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 29 09 30 6m13s 12s440ms 10 3 37s723ms 12s574ms 11 6 1m18s 13s146ms 12 6 1m7s 11s282ms [ User: intelifix - Total duration: 9m17s - Times executed: 45 ]
[ Application: [unknown] - Total duration: 9m17s - Times executed: 45 ]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 11:50:50 Duration: 15s464ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:51:09 Duration: 14s93ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 10:27:10 Duration: 14s46ms Database: rio User: intelifix Remote: [local] Application: [unknown]
11 10s70ms 12s404ms 11s339ms 19 3m35s create table temp0000286816 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 29 09 19 3m35s 11s339ms [ User: intelifix - Total duration: 3m35s - Times executed: 19 ]
[ Application: [unknown] - Total duration: 3m35s - Times executed: 19 ]
-
CREATE TABLE temp0000286816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:19:04 Duration: 12s404ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:17:32 Duration: 12s377ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286816 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 09:09:41 Duration: 11s981ms Database: rio User: intelifix Remote: [local] Application: [unknown]
12 10s454ms 12s362ms 11s333ms 18 3m23s create table temp0000286790 as select * from rs_nf_entrada_arquivos_lista (?, ?, null, null, ?, ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 29 07 10 1m50s 11s27ms 08 8 1m33s 11s715ms [ User: intelifix - Total duration: 3m23s - Times executed: 18 ]
[ Application: [unknown] - Total duration: 3m23s - Times executed: 18 ]
-
CREATE TABLE temp0000286790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 08:20:41 Duration: 12s362ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 08:36:11 Duration: 12s350ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286790 AS SELECT * FROM RS_NF_ENTRADA_ARQUIVOS_LISTA (0, 00, NULL, NULL, 00, 06);
Date: 2026-07-29 08:20:25 Duration: 12s147ms Database: rio User: intelifix Remote: [local] Application: [unknown]
13 1s484ms 46s161ms 10s625ms 68 12m2s select * from rs_resumo_periodo_geral (?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 29 07 3 20s692ms 6s897ms 08 1 4s960ms 4s960ms 09 3 1m1s 20s418ms 10 5 1m28s 17s782ms 11 6 39s624ms 6s604ms 12 3 13s956ms 4s652ms 13 5 1m17s 15s568ms 14 5 32s323ms 6s464ms 15 8 1m31s 11s447ms 16 11 2m29s 13s582ms 17 18 2m21s 7s888ms [ User: intelifix - Total duration: 12m2s - Times executed: 68 ]
[ Application: [unknown] - Total duration: 12m2s - Times executed: 68 ]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-29', 0395, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 09:04:50 Duration: 46s161ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-29', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 13:50:01 Duration: 41s438ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_RESUMO_PERIODO_GERAL ('2026-07-28', 099, '', '', 0, 6, '2026-07-01');
Date: 2026-07-29 10:32:13 Duration: 40s393ms Database: rio User: intelifix Remote: [local] Application: [unknown]
14 179ms 1m11s 4s564ms 59 4m29s select rs_setglobal (?, ?); select * from rs_nf_entrada_carrega_daniel_rio (?);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 29 07 4 3s67ms 766ms 08 6 19s268ms 3s211ms 09 23 1m57s 5s105ms 10 1 367ms 367ms 11 4 44s545ms 11s136ms 12 4 1m4s 16s141ms 14 11 4s133ms 375ms 15 5 14s920ms 2s984ms 16 1 1s23ms 1s23ms [ User: intelifix - Total duration: 4m29s - Times executed: 59 ]
[ Application: psql - Total duration: 4m29s - Times executed: 59 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027768);
Date: 2026-07-29 09:35:33 Duration: 1m11s Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 437); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027776);
Date: 2026-07-29 11:22:08 Duration: 38s959ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 449); SELECT * FROM RS_NF_ENTRADA_CARREGA_DANIEL_RIO (027766);
Date: 2026-07-29 09:26:09 Duration: 33s610ms Database: rio User: intelifix Remote: [local] Application: psql
15 2s938ms 5s17ms 3s953ms 34 2m14s create table temp0000286822 as select * from rs_lotes_lista (?);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 29 09 22 1m22s 3s756ms 10 6 27s63ms 4s510ms 12 6 24s698ms 4s116ms [ User: intelifix - Total duration: 2m14s - Times executed: 34 ]
[ Application: [unknown] - Total duration: 2m14s - Times executed: 34 ]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 10:22:52 Duration: 5s17ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"5", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 09:42:09 Duration: 4s818ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
CREATE TABLE temp0000286822 AS SELECT * FROM RS_LOTES_LISTA ('{ "oficina" :"6", "cliente" :"0", "desde" :"24-07-2026", "ate" :"29-07-2026", "nota-fiscal":"", "modelo" :"0", "lotes" :"", "lote-stone" :"" }');
Date: 2026-07-29 12:04:30 Duration: 4s640ms Database: rio User: intelifix Remote: [local] Application: [unknown]
16 153ms 15s761ms 3s597ms 34 2m2s select rs_setglobal (?, ?); select * from rs_nf_entrada_atualiza (?);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 29 07 4 21s181ms 5s295ms 08 9 13s836ms 1s537ms 09 8 31s31ms 3s878ms 10 1 3s789ms 3s789ms 11 4 16s208ms 4s52ms 12 2 7s988ms 3s994ms 14 4 21s779ms 5s444ms 15 2 6s492ms 3s246ms [ User: intelifix - Total duration: 2m2s - Times executed: 34 ]
[ Application: psql - Total duration: 2m2s - Times executed: 34 ]
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027741);
Date: 2026-07-29 07:08:41 Duration: 15s761ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027785);
Date: 2026-07-29 14:24:52 Duration: 12s33ms Database: rio User: intelifix Remote: [local] Application: psql
-
SELECT RS_SETGLOBAL ('USUARIO', 507); SELECT * FROM RS_NF_ENTRADA_ATUALIZA (027779);
Date: 2026-07-29 11:51:46 Duration: 11s554ms Database: rio User: intelifix Remote: [local] Application: psql
17 192ms 10s116ms 2s760ms 161 7m24s call rs_giga_processa_arquivos ();Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 29 00 6 17s995ms 2s999ms 01 6 7s369ms 1s228ms 02 6 9s67ms 1s511ms 03 5 10s155ms 2s31ms 04 6 7s565ms 1s260ms 05 3 10s594ms 3s531ms 06 1 562ms 562ms 07 11 30s834ms 2s803ms 08 12 45s943ms 3s828ms 09 12 39s632ms 3s302ms 10 11 30s46ms 2s731ms 11 12 39s663ms 3s305ms 12 12 42s454ms 3s537ms 13 8 8s694ms 1s86ms 14 12 42s271ms 3s522ms 15 12 44s136ms 3s678ms 16 11 25s751ms 2s341ms 17 5 12s896ms 2s579ms 21 4 6s309ms 1s577ms 22 6 12s420ms 2s70ms [ User: intelifix - Total duration: 7m24s - Times executed: 161 ]
[ Application: psql - Total duration: 7m24s - Times executed: 161 ]
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 00:05:11 Duration: 10s116ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 14:35:09 Duration: 8s88ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_PROCESSA_ARQUIVOS ();
Date: 2026-07-29 12:05:08 Duration: 7s786ms Database: rio User: intelifix Remote: [local] Application: psql
18 163ms 9s959ms 2s175ms 276 10m call rs_giga_triagem (?);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 29 00 12 28s753ms 2s396ms 01 12 22s869ms 1s905ms 02 12 22s879ms 1s906ms 03 12 22s723ms 1s893ms 04 12 22s778ms 1s898ms 05 12 21s556ms 1s796ms 06 12 21s889ms 1s824ms 07 12 25s460ms 2s121ms 08 12 24s454ms 2s37ms 09 12 32s778ms 2s731ms 10 12 31s283ms 2s606ms 11 12 25s902ms 2s158ms 12 12 27s425ms 2s285ms 13 12 25s290ms 2s107ms 14 12 30s852ms 2s571ms 15 12 32s42ms 2s670ms 16 12 30s544ms 2s545ms 17 12 25s272ms 2s106ms 18 12 24s26ms 2s2ms 19 12 23s672ms 1s972ms 20 12 30s101ms 2s508ms 21 12 24s540ms 2s45ms 22 12 23s288ms 1s940ms [ User: intelifix - Total duration: 10m - Times executed: 276 ]
[ Application: psql - Total duration: 10m - Times executed: 276 ]
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 00:05:21 Duration: 9s959ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 09:15:12 Duration: 7s909ms Database: rio User: intelifix Remote: [local] Application: psql
-
CALL RS_GIGA_TRIAGEM ('REPROCESSAR');
Date: 2026-07-29 16:15:16 Duration: 7s434ms Database: rio User: intelifix Remote: [local] Application: psql
19 150ms 5s517ms 863ms 1,603 23m4s select * from rs_lote_manutencao_itens (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 29 07 45 43s293ms 962ms 08 161 1m31s 567ms 09 189 2m26s 774ms 10 253 3m35s 852ms 11 210 3m27s 990ms 12 39 25s221ms 646ms 13 90 1m25s 950ms 14 197 3m17s 1s 15 266 3m44s 845ms 16 118 1m47s 913ms 17 35 39s587ms 1s131ms [ User: intelifix - Total duration: 23m4s - Times executed: 1603 ]
[ Application: [unknown] - Total duration: 23m4s - Times executed: 1603 ]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (272224, 450, 'ZTE3ANNR3Y19950,4896D951944C,4896D951944D,ZTEGD97E7EA3$ZTE3ANNR3J04711,F4E84F86BCCA,F4E84F86BCCB,ZTEGD97B7431$ZTE3ANNRCP46717,6C11BA6D71BD,6C11BA6D71BE,ZTEGDC6FF710$ZTE3ANNR6R26142,48D68237E976,48D68237E977,ZTEGDB0190F1$ZTE3ANNR8C37452,38914851F4CF,38914851F4D0,ZTEGDB0912BC$ZTE3ANNRAD22221,D89A0DAFE331,D89A0DAFE332,ZTEGDB1752D8$ZTE3ANNQ6M06062,C4EBFF88EFE4,C4EBFF88EFE5,ZTEGD709F8BC$ZTE3ANNR3J04380,F4E84F86B508,F4E84F86B509,ZTEGD97B72E6$ZTE3ANNT2V11932,D831398CA680,D831398CA681,ZTEGDD30211B$ZTE3ANNQ3621312,3CF9F0A6C8EE,3CF9F0A6C8EF,ZTEGD640B6DB$ZTE3ANNR1Y13968,14CA56CDF1DB,14CA56CDF1DC,ZTEGD970ACEB$ZTE3ANNR3Y19752,4896D9518FA8,4896D9518FA9,ZTEGD97E7DDD$ZTE3ANNR3J04335,F4E84F86B3FA,F4E84F86B3FB,ZTEGD97B72B9$ZTE3ANNQ7507690,C4EBFF8BA778,C4EBFF8BA779,ZTEGD70A6CAA$ZTE3ANNQ4N00785,3CF9F0A8A414,3CF9F0A8A415,ZTEGD641060C$ZTE3ANNQ6M06076,C4EBFF88F038,C4EBFF88F039,ZTEGD709F8CA$ZTE3ANNRCP63949,6C11BA6F059D,6C11BA6F059E,ZTEGDC703A60$ZTE3ANNR5W51282,48D6823335B6,48D6823335B7,ZTEGDB00C851$ZTE3ANNRCP62001,6C11BA6ED7F5,6C11BA6ED7F6,ZTEGDC7032C4$ZTE3ANNR7B16918,3891484A792B,3891484A792C,ZTEGDB07D376$ZTE3ANNQ6M07903,C4EBFF891B0A,C4EBFF891B0B,ZTEGD709FFED$ZTE3ANNQ3612242,3CF9F0A5F45A,3CF9F0A5F45B,ZTEGD640936D$ZTE3ANNT3H83171,D831399E60EA,D831399E60EB,ZTEGDD331582$ZTE3ANNR2Q28985,F4E84F835B56,F4E84F835B57,ZTEGD97AE3F3$ZTE3ANNRAM59429,5872C98CA917,5872C98CA918,ZTEGDC60E824$ZTE3ANNRCP64065,6C11BA6F0855,6C11BA6F0856,ZTEGDC703AD4$ZTE3ANNQ4414781,3CF9F0ACB94C,3CF9F0ACB94D,ZTEGD641B440$ZTE3ANNQ4414771,3CF9F0ACB910,3CF9F0ACB911,ZTEGD641B436$ZTE3ANNQ7L04512,C4EBFF8DEE68,C4EBFF8DEE69,ZTEGD70ACDD2$ZTE3ANNT3H69051,D831399D15FA,D831399D15FB,ZTEGDD32DE5A$ZTE3ANNQ3R00781,3CF9F0A29214,3CF9F0A29215,ZTEGD640030C$ZTE3ANNQ7T02838,C4EBFF8F2DC4,C4EBFF8F2DC5,ZTEGD70B030C$ZTE3ANNQ8M18668,843C99207D73,843C99207D74,ZTEGD7BA9059$ZTE3ANNRAM35107,5872C98A6F0B,5872C98A6F0C,ZTEGDC608922$ZTE3ANNQ7507538,C4EBFF8BA3E8,C4EBFF8BA3E9,ZTEGD70A6C12$ZTE3ANNQ3R00816,3CF9F0A292E6,3CF9F0A292E7,ZTEGD640032F$ZTE3ANNR1Y42943,14CA56D098F5,14CA56D098F6,ZTEGD9711E1A$ZTE3ANNR5W68593,48D68234CB70,48D68234CB71,ZTEGDB010BF0$ZTE3ANNRCB72648,D831392475AE,D831392475AF,ZTEGDD2AD15D$ZTE3ANNR9F40709,D89A0DA69801,D89A0DA69802,ZTEGDB15C650', '',0318,00,'[{"item":"0","qrcode":""},{"item":"1","qrcode":""},{"item":"2","qrcode":""},{"item":"3","qrcode":""},{"item":"4","qrcode":""},{"item":"5","qrcode":""},{"item":"6","qrcode":""},{"item":"7","qrcode":""},{"item":"8","qrcode":""},{"item":"9","qrcode":""},{"item":"10","qrcode":""},{"item":"11","qrcode":""},{"item":"12","qrcode":""},{"item":"13","qrcode":""},{"item":"14","qrcode":""},{"item":"15","qrcode":""},{"item":"16","qrcode":""},{"item":"17","qrcode":""},{"item":"18","qrcode":""},{"item":"19","qrcode":""},{"item":"20","qrcode":""},{"item":"21","qrcode":""},{"item":"22","qrcode":""},{"item":"23","qrcode":""},{"item":"24","qrcode":""},{"item":"25","qrcode":""},{"item":"26","qrcode":""},{"item":"27","qrcode":""},{"item":"28","qrcode":""},{"item":"29","qrcode":""},{"item":"30","qrcode":""},{"item":"31","qrcode":""},{"item":"32","qrcode":""},{"item":"33","qrcode":""},{"item":"34","qrcode":""},{"item":"35","qrcode":""},{"item":"36","qrcode":""},{"item":"37","qrcode":""},{"item":"38","qrcode":""},{"item":"39","qrcode":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 11:26:53 Duration: 5s517ms Database: rio User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48437, 417, '835100915001254,241667960208,241708795371,241728742436,241731031425,241630183939,241664845167,241704047073,241676641818,241732153139,241604349914,241657188392,241717171318,241634989515,241668151719,241604356379,241708747386,241617356873,241713294553,241731033647,241635007294,241714073350,241659722333,241598878202,241706864554,241731001624,241676779205,241646271133,241593128303,241704327785,241676776881,241622485163,241708874346,241713312737,241668249405,241593408183,241678342231,241680375459,241649712546,241676779609,241708891217,241731036677,241731221926,241676790722,241628278602,241659726676,241731013847', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 16:43:57 Duration: 5s142ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT * FROM RS_LOTE_MANUTENCAO_ITENS (48527, 417, 'ZTE3ANNQ7T03108,C4EBFF8F3418,C4EBFF8F3419,ZTEGD70B041A$ZTE3ANNR1Y33595,14CA56CFBDDD,14CA56CFBDDE,ZTEGD970F996$ZTE3ANNT2V11716,D831398CA170,D831398CA171,ZTEGDD302043$ZTE3ANNT2V85827,D83139936A6A,D83139936A6B,ZTEGDD3141C2$ZTE3ANNRCP61611,6C11BA6ECED1,6C11BA6ECED2,ZTEGDC70313E$ZTE3ANNR9W21005,D89A0DAA4871,D89A0DAA4872,ZTEGDB1663B8$ZTE3ANNR2Q32929,F4E84F83B7C6,F4E84F83B7C7,ZTEGD97AF35B$ZTE3ANNR2Q00737,F4E84F80C546,F4E84F80C547,ZTEGD97A759B$ZTE3ANNR8C09926,3891484F6FAB,3891484F6FAC,ZTEGDB08A736$ZTE3ANNRCB62896,D8313923911E,D8313923911F,ZTEGDD2AAB45$ZTE3ANNR7B15305,3891484A535D,3891484A535E,ZTEGDB07CD29$ZTE3ANNR3J45472,F4E84F8A7820,F4E84F8A7821,ZTEGD97C136A$ZTE3ANNR8C09961,3891484F707D,3891484F707E,ZTEGDB08A759$ZTE3ANNQ4N01186,3CF9F0A8AD7A,3CF9F0A8AD7B,ZTEGD641079D$ZTE3ANNQ4N04182,3CF9F0A8F3B2,3CF9F0A8F3B3,ZTEGD6411351$ZTE3ANNRCB74459,D8313924A020,D8313924A021,ZTEGDD2AD870$ZTE3ANNQ7501445,C4EBFF8B151A,C4EBFF8B151B,ZTEGD70A5445$ZTE3ANNR8C39074,389148521AD3,389148521AD4,ZTEGDB091912$ZTE3ANNT3H68495,D831399D08F2,D831399D08F3,ZTEGDD32DC2E$ZTE3ANNRCP03093,6C11BA69734D,6C11BA69734E,ZTEGDC6F4CA8$ZTE3ANNQ4414455,3CF9F0ACB1A8,3CF9F0ACB1A9,ZTEGD641B2FA$ZTE3ANNRCB26011,D831392030A0,D831392030A1,ZTEGDD2A1B30$ZTE3ANNR8C39012,38914852195F,389148521960,ZTEGDB0918D4$ZTE3ANNQCA02711,14CA56D28465,14CA56D28466,ZTEGD9717002$ZTE3ANNRC506238,6C11BA62BC0B,6C11BA62BC0C,ZTEGDC6E2E1D$ZTE3ANNRC507198,6C11BA62D28B,6C11BA62D28C,ZTEGDC6E31DD$ZTE3ANNR4N11685,4896D9566CF6,4896D9566CF7,ZTEGD97F4D6A$ZTE3ANNQ5N05450,3CF9F0AD4532,3CF9F0AD4533,ZTEGD641CB91$ZTE3ANNRCP02999,6C11BA697119,6C11BA69711A,ZTEGDC6F4C4A', '',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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$','', 00);
Date: 2026-07-29 10:47:52 Duration: 4s826ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
20 158ms 10s732ms 854ms 84 1m11s select unaccent (cliente) as cliente from rs_lote_saida_lista (?) limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 29 08 19 10s175ms 535ms 09 13 5s995ms 461ms 10 15 7s229ms 481ms 11 3 23s569ms 7s856ms 14 19 16s751ms 881ms 15 8 3s325ms 415ms 16 7 4s739ms 677ms [ User: intelifix - Total duration: 1m11s - Times executed: 84 ]
[ Application: [unknown] - Total duration: 1m11s - Times executed: 84 ]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048104) LIMIT 1;
Date: 2026-07-29 11:50:41 Duration: 10s732ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (048103) LIMIT 1;
Date: 2026-07-29 11:54:11 Duration: 9s927ms Database: contagem User: intelifix Remote: [local] Application: [unknown]
-
SELECT UNACCENT (CLIENTE) AS CLIENTE FROM RS_LOTE_SAIDA_LISTA (0272023) LIMIT 1;
Date: 2026-07-29 14:34:07 Duration: 2s964ms Database: rio User: intelifix Remote: [local] Application: [unknown]
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 0ms 3 0ms 0ms 0ms ;Times Reported Time consuming bind #1
Day Hour Count Duration Avg duration Jul 29 19 2 0ms 0ms 20 1 0ms 0ms [ User: intelifix - Total duration: 4s600ms - Times executed: 3 ]
[ Application: psql - Total duration: 4s600ms - Times executed: 3 ]
-
;
Date: Duration: 0ms Database: postgres User: brasilia Remote: intelifix Application: [local] Queryid: psql
-
Events
Log levels
Key values
- 17,463 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 13 FATAL entries
- 3906 ERROR entries
- 0 WARNING entries
- 2 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 3,790 Max number of times the same event was reported
- 3,921 Total events found
Rank Times reported Error 1 3,790 ERROR: prepared statement "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 29 07 164 08 322 09 382 10 306 11 367 12 210 13 90 14 259 15 295 16 123 17 241 18 177 19 180 20 177 21 177 22 175 23 145 - ERROR: prepared statement "_PLAN0000000031437340" does not exist
- ERROR: prepared statement "_PLAN000000003139B690" does not exist
- ERROR: prepared statement "_PLAN0000000031C3E800" does not exist
Statement: DEALLOCATE "_PLAN0000000031437340"
Date: 2026-07-29 07:10:18 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN000000003139B690"
Date: 2026-07-29 07:10:23 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: DEALLOCATE "_PLAN0000000031C3E800"
Date: 2026-07-29 07:11:58 Database: rio Application: [unknown] User: etiquetas Remote: [local]
2 46 ERROR: PermissionError: ... Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 29 00 2 01 2 02 2 03 2 04 2 05 2 06 2 07 2 08 2 09 2 10 2 11 2 12 2 13 2 14 2 15 2 16 2 17 2 18 2 19 2 20 2 21 2 22 2 - ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
- ERROR: PermissionError: [Errno 1] Operation not permitted: '/prod/giga_upload/bsb/upload/tecnicos.csv'
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-29 00:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-29 00:35:01 Database: brasilia Application: psql User: intelifix Remote: [local]
Context: Traceback (most recent call last): PL/Python function "rs_write_file", line 21, in <module> os.chmod( cfile, 0o666 ) PL/Python function "rs_write_file" PL/pgSQL function rs_giga_tecnicos() line 41 at assignment
Statement: CALL RS_GIGA_TECNICOS()Date: 2026-07-29 01:05:01 Database: brasilia Application: psql User: intelifix Remote: [local]
3 45 ERROR: invalid input syntax for type json
Times Reported Most Frequent Error / Event #3
Day Hour Count Jul 29 08 3 09 3 10 3 11 3 12 3 13 3 14 3 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 3 - ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
- ERROR: invalid input syntax for type json
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-29 08:00:05 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES() NOTICE: table "tmp_entrada" does not exist, skippingDate: 2026-07-29 08:20:08 Database: brasilia Application: psql User: intelifix Remote: [local]
Detail: Expected "," or "}", but found "1936".
Context: JSON data, line 2487: "nrSerie":"92!2610"1936... PL/pgSQL function rs_resumo_tcia(integer) line 138 at assignment PL/pgSQL function rs_tcia_envia_lote(integer) line 33 at assignment PL/pgSQL function rs_tcia_processa_lotes(integer) line 48 at assignment
Statement: CALL RS_TCIA_PROCESSA_LOTES()Date: 2026-07-29 08:40:07 Database: brasilia Application: psql User: intelifix Remote: [local]
4 19 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Jul 29 09 5 12 2 13 1 14 1 15 10 - ERROR: syntax error at or near "230012307687" at character 41
- ERROR: syntax error at or near "DC5193DC3C65" at character 32
- ERROR: syntax error at or near "DC5193DC3C65A8TR6B01428" at character 592
Statement: SELECT * FROM RS_EQUIPAMENTO_CONSULTA(''230012307687');
Date: 2026-07-29 09:00:50 Database: rio Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT RS_SERIAL_TEMPORARIO( ''DC5193DC3C65' ) OR RS_SERIAL_TEMPORARIO_VIVO( ''DC5193DC3C65' )
Date: 2026-07-29 09:13:20 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Statement: SELECT * FROM RS_LOTE_MANUTENCAO_ITENS(130300,397,'3A8TR4H00990,DC5193DC303E,ZTE3A8TR4718926$3A8TR4700340,DC5193DB001A,ZTE3A8TR1M19861$3A8TR6B01507,E44E12937C6B,ZTE3A8TR6509197$3A8TR6B01431,E44E12938237,ZTE3A8TR6509568$3A8TR4G02570,DC5193DC2322,ZTE3A8TR4718087$3A8TR4R00485,38165A47DBE0,ZTE3A8TR4H11772$3A8TRCN01334,7C7D21ED615F,ZTE3A8TRCB13335$ZTE3A8TR1M19867,DC5193DB0032,ZTE3A8TR1M19862$3A8TRCJ01575,7C7D21ED17C7,ZTE3A8TRCB08625$3A8TR4R00488,38165A47DBCC,ZTE3A8TR4H11767$ZTE3A8TR4718010,DC5193DC21EE,ZTE3A8TR4718015$3A8TR4700337,DC5193DB0062,ZTE3A8TR1M19879$ZTE3A8TR4719704,DC5193DC3C66,'DC5193DC3C65$3A8TR6B01428,E44E129382CB,ZTE3A8TR6509605$3A8TT2D00846,7C7D21F0A5E3,ZTE3A8TRCS15872$3A8TR1701558,DC5193D8FE9A,ZTE3A8TQCH07397$3A8TR1701557,DC5193D8C56A,ZTE3A8TQCH03737$3A8TR6B01430,E44E1293827F,ZTE3A8TR6509586$3A8TT2D00839,7C7D21F0A5EF,ZTE3A8TRCS15875$ZTE3A8TR4H11628,38165A47D9A0,ZTE3A8TR4H11620','',0329,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":""}]','$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$','',00);
Date: 2026-07-29 09:13:20 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
5 6 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Jul 29 03 6 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-07-29 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
Date: 2026-07-29 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-29 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
6 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #6
Day Hour Count Jul 29 00 1 06 1 09 1 23 1 - FATAL: database "testes" does not exist
- FATAL: database "testes" does not exist
- FATAL: database "jaboatao" does not exist
Date: 2026-07-29 00:02:33 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-29 06:02:28 Database: testes Application: [unknown] User: lenon Remote: [local]
Date: 2026-07-29 09:15:37 Database: jaboatao Application: [unknown] User: intelifix Remote: [local]
7 4 ERROR: relation "..." does not exist
Times Reported Most Frequent Error / Event #7
Day Hour Count Jul 29 05 4 - ERROR: relation "rs_mv_equipamentos" does not exist
- ERROR: relation "rs_mv_codigos_barra" does not exist
- ERROR: relation "rs_mv_equipamentos" does not exist
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-29 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_CODIGOS_BARRA;
Date: 2026-07-29 05:32:09 Database: brasilia Application: psql User: intelifix Remote: [local]
Statement: REFRESH MATERIALIZED VIEW CONCURRENTLY RS_MV_EQUIPAMENTOS;
Date: 2026-07-29 05:32:09 Database: contagem Application: psql User: intelifix Remote: [local]
8 3 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Jul 29 03 3 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-07-29 03:05:01 Database: brasilia Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-29 03:05:01 Database: rio Application: [unknown] User: intelifix Remote: [local]
Date: 2026-07-29 03:05:01 Database: brasilia Application: [unknown] User: etiquetas Remote: [local]
9 2 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jul 29 09 2 - ERROR: column "v" does not exist at character 27
- ERROR: column "v" does not exist at character 27
Statement: select * from rs_caixa_qr(V)
Date: 2026-07-29 09:33:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
Statement: select * from rs_caixa_qr(V)
Date: 2026-07-29 09:33:56 Database: rio Application: [unknown] User: etiquetas Remote: [local]
10 1 LOG: skipping analyze of "..." --- lock not available
Times Reported Most Frequent Error / Event #10
Day Hour Count Jul 29 10 1 - LOG: skipping analyze of "temp0000286818" --- lock not available
Date: 2026-07-29 10:39:43
11 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #11
Day Hour Count Jul 29 03 1 - LOG: database system was shut down at 2026-07-29 03:05:01 -03
Date: 2026-07-29 03:05:02